Example Queries

From Enigma-Dev
Jump to: navigation, search

Here are a few examples of the types of queries that are possible:

Which Cohort Projects have results available?

 
1000BRAINS proj ENIGMA3 Cortical GWAS
ABCD proj ENIGMA3 Cortical GWAS
ADNI1 proj ENIGMA3 Cortical GWAS
ADNI2GO proj ENIGMA3 Cortical GWAS
ALSPACa proj ENIGMA3 Cortical GWAS
AMC proj Cortical SCZ
AMC proj Subcortical SCZ
ASRB proj Cortical SCZ
ASRB proj ENIGMA3 Cortical GWAS
BETULA proj ENIGMA3 Cortical GWAS
BIG-Affy proj ENIGMA3 Cortical GWAS
BIG-PsychChip proj ENIGMA3 Cortical GWAS
BONN proj ENIGMA3 Cortical GWAS
Basel SCORE proj SubcorticalShape SCZ
BrainScale proj ENIGMA3 Cortical GWAS
... further results



Which Projects from ______ Working Group have already been published? ( Other statuses can be used, to generate different lists. )

 Project Status
BD Brain Aging
BD Cortical
BD Cortical;BD Subcortical
BD DTI Machine Learning
BD Hippocampal Subfields
BD Structural Machine Learning
BD Subcortical
BD Subcortical Shape
BD Subcortical Shape;BD Brain Aging;BD Cortical;BD Subcortical;BD Structural Machine Learning
DTI Machine Learning BD
... further results



Which Cohorts belong to both ____________ and ___________ Working groups?




Which Cohorts have (T1w, DTI, GWAS) data?

 Brain Scan Datatype
Wellcome proj SubcorticalShape SCZT1w
UiO2017 proj ENIGMA3 Cortical GWAST1w
UiO2016 proj ENIGMA3 Cortical GWAST1w
UPENN proj SubcorticalShape SCZT1w
UPENN proj Subcortical SCZT1w
UPENN proj PositiveSymptoms SCZT1w
UPENN proj NegativeSymptoms SCZT1w
UPENN proj Cortical SCZT1w
UNICAMP proj ENIGMA3 Cortical GWAST1w
... further results


How many participants (from various cohorts) are in [a specific project]?

 N
HMS proj Cortical SCZ
HMS proj Subcortical SCZ
BONN proj ENIGMA3 Cortical GWAS
PAFIP proj ENIGMA3 Cortical GWAS
GOBS proj ENIGMA3 Cortical GWAS
Galway proj Cortical SCZ
Meth-CT proj ENIGMA3 Cortical GWAS
Olin proj SubcorticalShape SCZ
IMAGEN proj ENIGMA3 Cortical GWAS
Galway proj SubcorticalShape SCZ
SNUH proj Cortical SCZ
CHARGE Replication Cohort proj ENIGMA3 Cortical GWAS
Huilong2 proj Cortical SCZ
UNICAMP proj ENIGMA3 Cortical GWAS
COBRE proj Cortical SCZ
... further results



Projects that have "Dublin" Cohort

has Dublin
Proj Cortical SCZ
Proj DTI IQ SCZ
Proj Negative Symptoms SCZ
Proj Subcortical SCZ
Proj Subcortical Shapes SCZ

Projects that have "CIAM" Cohort

has CIAM
Proj Cortical SCZ
Proj Positive Symptoms SCZ
Proj Subcortical Shapes SCZ