Database Methods MDX Query Language Sample Queries
< Previous QueryNext 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)