aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-03-06 14:05:48 +0300
committerBonfaceKilz2023-03-06 22:30:50 +0300
commitf5eb10c5b598753cd2c40920e4344c7f29a2bb99 (patch)
tree8e7aae832c767e22c6cd8a1e269d57a9a4e9b068
parentc79ac02bb27ed3036ddb4928bf723a59852ee24d (diff)
downloadgn-transform-databases-f5eb10c5b598753cd2c40920e4344c7f29a2bb99.tar.gz
Add mapping method and species info to inbredsets.
* dump.scm (dump-inbred-set): Add mapping method and species as extra metadata for inbredsets. Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xdump.scm8
1 files changed, 6 insertions, 2 deletions
diff --git a/dump.scm b/dump.scm
index 43d6cda..7ab070f 100755
--- a/dump.scm
+++ b/dump.scm
@@ -367,17 +367,21 @@ must be remedied."
(define-dump dump-inbred-set
(tables (InbredSet
- (inner-join Species "USING (SpeciesId)")))
+ (left-join Species "ON InbredSet.SpeciesId=Species.Id")
+ (left-join MappingMethod
+ "ON InbredSet.MappingMethodId=MappingMethod.Id")))
(schema-triples
(gn:fullName rdfs:range rdfs:Literal)
(gn:geneticType rdfs:range rdfs:Literal)
(gn:family rdfs:range rdfs:Literal)
- (gn:inbredSetOfSpecies rdfs:range gn:species))
+ (gn:inbredSetOfSpecies rdfs:range gn:species)
+ (gn:inbredSetOfMappingMethod rdfs:range gn:mappingMethod))
(triples (inbred-set-name->id (field InbredSet Name))
(set rdf:type 'gn:inbredSet)
(set gn:fullName (field InbredSet FullName))
(set gn:geneticType (field InbredSet GeneticType))
(set gn:family (field InbredSet Family))
+ (set gn:inbredSetOfMappingMethod (field MappingMethod Name))
(set gn:inbredSetOfSpecies
(binomial-name->species-id (field Species FullName BinomialName)))))