Database Description > Sample Queries > Find a sequence of amino acid residues from the entire database...

Sample MDX Query

Find a sequence of amino acid residues from the entire database and report back a the phi psi angles at a given time frame

WITH

Member [measures].[r1] as "GLN"
Member [measures].[r2] as "ALA"
Member [measures].[r3] as "LEU"
Member [measures].[r4] as "GLY"
Member [measures].[r5] as "TRP"
Member [measures].[r6] as "VAL"

SET STR AS
       [ID].[structure].[structure]

SET res1 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r1] and
[ID].[hierarchy].nextmember.properties( "Residue" )=[r2] and
[ID].[hierarchy].nextmember.nextmember.properties( "Residue" )=[r3] and
[ID].[hierarchy].nextmember.nextmember.nextmember.properties( "Residue" )=[r4] and
[ID].[hierarchy].nextmember.nextmember.nextmember.nextmember.properties( "Residue" )=[r5] and
[ID].[hierarchy].nextmember.nextmember.nextmember.nextmember.nextmember.properties( "Residue" )=[r6])

SET res2 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r2] and
[ID].[hierarchy].nextmember.properties( "Residue" )=[r3] and
[ID].[hierarchy].nextmember.nextmember.properties( "Residue" )=[r4] and
[ID].[hierarchy].nextmember.nextmember.nextmember.properties( "Residue" )=[r5] and
[ID].[hierarchy].nextmember.nextmember.nextmember.nextmember.properties( "Residue" )=[r6] and
[ID].[hierarchy].prevmember.properties( "Residue" )=[r1])

SET res3 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r3] and
[ID].[hierarchy].nextmember.properties( "Residue" )=[r4] and
[ID].[hierarchy].nextmember.nextmember.properties( "Residue" )=[r5] and
[ID].[hierarchy].nextmember.nextmember.nextmember.properties( "Residue" )=[r6] and
[ID].[hierarchy].prevmember.prevmember.properties( "Residue" )=[r1] and
[ID].[hierarchy].prevmember.properties( "Residue" )=[r2] )

SET res4 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r4] and
[ID].[hierarchy].nextmember.properties( "Residue" )=[r5] and
[ID].[hierarchy].nextmember.nextmember.properties( "Residue" )=[r6] and
[ID].[hierarchy].prevmember.prevmember.prevmember.properties( "Residue" )=[r1] and
[ID].[hierarchy].prevmember.prevmember.properties( "Residue" )=[r2] and
[ID].[hierarchy].prevmember.properties( "Residue" )=[r3])

SET res5 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r5] and
[ID].[hierarchy].nextmember.properties( "Residue" )=[r6] and
[ID].[hierarchy].prevmember.prevmember.prevmember.prevmember.properties( "Residue" )=[r1] and
[ID].[hierarchy].prevmember.prevmember.prevmember.properties( "Residue" )=[r2] and
[ID].[hierarchy].prevmember.prevmember.properties( "Residue" )=[r3] and
[ID].[hierarchy].prevmember.properties( "Residue" )=[r4])

SET res6 as filter(descendants([ID].[hierarchy], 2),
[ID].[hierarchy].currentmember.properties( "Residue" )=[r6] and
[ID].[hierarchy].prevmember.prevmember.prevmember.prevmember.prevmember.properties( "Residue" )=[r1] and
[ID].[hierarchy].prevmember.prevmember.prevmember.prevmember.properties( "Residue" )=[r2] and
[ID].[hierarchy].prevmember.prevmember.prevmember.properties( "Residue" )=[r3] and
[ID].[hierarchy].prevmember.prevmember.properties( "Residue" )=[r4] and
[ID].[hierarchy].prevmember.properties( "Residue" )=[r5])

SELECT
       non empty STR *{res1, res2, res3, res4, res5, res6} on 1,
       [run].[1]* {[phi],[psi]} on 0

FROM [dynameomics]

WHERE ( [Time].[0],
       [Temp].[498],
       [Conditions].[cs=.4,nbcycl=3,cor=8)