Database Methods

MDX Query Language

Sample Queries

 Database Description > Sample Queries > List all phi psi angles for a protein at a given time frame

Sample SQL Query

< Previous QueryNext Query >

List all phi psi angles for a protein at a given time frame

SELECT Distinct i.residue_number, i.residue, c.phi, c.psi
FROM dbo.[PhiPsi_1A2P-1_1] AS c
JOIN dbo.ID AS i
        ON ( i.struct_id = c.struct_id
                and c.residue_number = i.residue_number)
WHERE c.[time]=1

ORDER BY i.residue_number