Dynameomics - MDX Queries

The SQL Query Language
The MDX Query Language
Sample Queries
- MDX Queries
- SQL Queries
Database Access link

Previous Query Next Query

Report back a pseudo pdb file for a given time frame

WITH MEMBER [Measures].[atm_type] as '[id].[atom name].membervalue' MEMBER [Measures].[res_type] as '[id].residue.membervalue' MEMBER [Measures].[res_num] as '[id].[residue number].membervalue' MEMBER [Measures].[atm_num] as '[id].[Hierarchy].membervalue' MEMBER [Measures].[atom] as ("ATOM") SELECT {Measures. [atom], [atm_num], [atm_type], [res_type], [res_num], [x Coord], [y Coord], [z Coord]} on 0, Descendants([ID].[Hierarchy].[structure].[1a2p-1], 2) on 1 FROM [dynameomics] WHERE ([Time].[3], [Temp].[498], [Conditions].[cs=.4,nbcycl=3,cor=8]);