summaryrefslogtreecommitdiff
path: root/issues
diff options
context:
space:
mode:
authorAlexander_Kabui2023-07-07 19:05:17 +0300
committerAlexander_Kabui2023-07-07 19:05:17 +0300
commit9a7fd35850661916792887f2bb15fec50de317a9 (patch)
treeb658737b8174ca991b6a941677ce29e2715964c7 /issues
parent303091f3f8d44bf0bc2820509d5bad933f02529f (diff)
downloadgn-gemtext-9a7fd35850661916792887f2bb15fec50de317a9.tar.gz
update issues/linking-genofiles-to-dataset
Diffstat (limited to 'issues')
-rw-r--r--issues/linking_genotype-files-to-datasets.gmi33
1 files changed, 32 insertions, 1 deletions
diff --git a/issues/linking_genotype-files-to-datasets.gmi b/issues/linking_genotype-files-to-datasets.gmi
index d6fdccb..03a302f 100644
--- a/issues/linking_genotype-files-to-datasets.gmi
+++ b/issues/linking_genotype-files-to-datasets.gmi
@@ -5,7 +5,7 @@
* assigned: alexm
* type: debug
* priority: high
-* status: in progrss
+* status: in progress
## Notes
@@ -14,4 +14,35 @@ A dataset can have multiple groups. In order to fetch all possible sample data f
As an example example the dataset HC_M2_0606_P is of type Probeset and linked groups for this dataset include (bxd,others) that would translate to these genofiles BXD.geno etc
+## Species relationship to groups/
+A dataset has got species for example (mouse,human)
+Similary a species can have multiple groups/families
+Example-> Species(mouse) ->Families(BXD family, B6D2RI, B6D2F2) -> Genofiles related to this (BXD.geno, B6D2RI.geno, B6D2F2.geno)
+
+* How to fetch Families given a species
+
+```sql
+SELECT InbredSet.Name, InbredSet.FullName
+FROM InbredSet, Species WHERE Species.Name = 'mouse'
+AND InbredSet.SpeciesId = Species.Id GROUP by
+InbredSet.Name ORDER BY IFNULL(InbredSet.FamilyOrder,
+InbredSet.FullName) ASC, IFNULL(InbredSet.Family,
+InbredSet.FullName) ASC, InbredSet.FullName ASC,
+InbredSet.MenuOrderId ASC
+
+```
+
+* Limit you fetch to specified type for Dataset
+Example of types Probeset,Publish
+
+
+```sql
+
+select InbredSet.Name, InbredSet.FullName from InbredSet,Species,
+ProbeFreeze where Species.Name = 'mouse'
+and InbredSet.SpeciesId = Species.Id and
+(ProbeFreeze.InbredSetId = InbredSet.Id)
+group by InbredSet.Name
+order by InbredSet.FullName
+```