about summary refs log tree commit diff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-05-29 14:27:59 +0300
committerBonfaceKilz2023-05-30 11:51:30 +0300
commit0546748145e0753057b0d3694d47fad1537e4375 (patch)
treec8e24f9ad56696450240582b706592cd3e739118
parent9df0828255632582f515d5d869a3a06f8eda735b (diff)
downloadgn-transform-databases-0546748145e0753057b0d3694d47fad1537e4375.tar.gz
Replace species with inbredSet metadata when dumping info-files
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xexamples/dump-dataset-metadata.scm8
1 files changed, 3 insertions, 5 deletions
diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm
index ebaea52..9d575df 100755
--- a/examples/dump-dataset-metadata.scm
+++ b/examples/dump-dataset-metadata.scm
@@ -84,9 +84,9 @@
            (left-join PublishFreeze "ON InfoFiles.InfoPageName = PublishFreeze.Name")
            (left-join GenoFreeze "ON InfoFiles.InfoPageName = GenoFreeze.Name")
            (left-join ProbeSetFreeze "ON InfoFiles.InfoPageName = ProbeSetFreeze.Name")
+           (left-join InbredSet "ON InfoFiles.InbredSetId = InbredSet.InbredSetId")
            (left-join Datasets "USING (DatasetId)")
            (left-join DatasetStatus "USING (DatasetStatusId)")
-           (left-join Species "USING (SpeciesId)")
            (left-join Tissue "USING (TissueId)")
            (left-join Investigators "USING (InvestigatorId)")
            (left-join AvgMethod "USING (AvgMethodId)")
@@ -95,8 +95,6 @@
   (schema-triples
    (gn:datasetOfInvestigator rdfs:domain gn:dataset)
    (gn:datasetOfInvestigator rdfs:range foaf:Person)
-   (gn:datasetOfSpecies rdfs:domain gn:dataset)
-   (gn:datasetOfSpecies rdfs:range gn:species)
    (gn:datasetOfInbredSet rdfs:domain gn:dataset)
    (gn:datasetOfInbredSet rdfs:range gn:inbredSet)
    (gn:datasetOfTissue rdfs:domain gn:dataset)
@@ -144,8 +142,8 @@
                                              (field InfoFiles GN_AccesionId))))
     (set gn:datasetStatusName (string-downcase
                                (field DatasetStatus DatasetStatusName)))
-    (set gn:datasetOfSpecies (string->identifier "species"
-                              (field Species FullName BinomialName)))
+    (set gn:datasetOfInbredSet
+         (string->identifier "inbredSet" (field InbredSet Name InbredSetName)))
     (set gn:datasetOfTissue (string->identifier "tissue"
                                                 (field Tissue Short_Name)))
     (set gn:normalization