aboutsummaryrefslogtreecommitdiff
path: root/examples
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-05-29 14:27:59 +0300
committerBonfaceKilz2023-05-30 11:51:30 +0300
commit0546748145e0753057b0d3694d47fad1537e4375 (patch)
treec8e24f9ad56696450240582b706592cd3e739118 /examples
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>
Diffstat (limited to 'examples')
-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