From f5eb10c5b598753cd2c40920e4344c7f29a2bb99 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Mon, 6 Mar 2023 14:05:48 +0300 Subject: 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 --- dump.scm | 8 ++++++-- 1 file 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))))) -- cgit 1.4.1