Database Methods

MDX Query Language

Sample Queries

 Database Description > Sample Queries > List all proline residues in all proteins in the database and show their Phi Psi values

Sample MDX Query

< Previous QueryNext Query >

List all proline residues in all proteins in the database and show their Phi Psi values

WITH

SET STR AS
       [ID].[structure]

SET pro as filter(descendants([ID].[hierarchy], 2), [ID].[hierarchy].currentmember.properties( "Residue" )="PRO")

SELECT
       non empty STR *pro on 1,
       [run].[1]* {[phi],[psi]} on 0

FROM [dynameomics]

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