From 6a193980dd83c235962a9a2adc127daa001036e3 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Tue, 2 May 2023 20:32:23 +0300 Subject: Dump molecular traits, also referred to as Probesets Signed-off-by: Munyoki Kilyungi --- dump.scm | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'dump.scm') diff --git a/dump.scm b/dump.scm index b95856e..eca54cd 100755 --- a/dump.scm +++ b/dump.scm @@ -455,6 +455,18 @@ must be remedied." (set gn:phenotype (field ("IF ((SELECT GenoFreeze.Name FROM GenoFreeze WHERE GenoFreeze.InbredSetId = InbredSet.Id LIMIT 1) IS NOT NULL, 'DNA Markers and SNPs', '')" phenotypeP))))) +(define-dump dump-molecular-traits + (tables (ProbeFreeze + (left-join ProbeSetFreeze "USING (ProbeFreezeId)") + (left-join InbredSet "USING (InbredSetId)") + (left-join Tissue "USING (TissueId)") + (left-join Species "USING (SpeciesId)")) + "GROUP BY InbredSet.Name") + (schema-triples + (gn:molecularTrait rdfs:range rdfs:Literal)) + (triples (inbred-set-name->id (field InbredSet Name)) + (set gn:molecularTrait (field Tissue TissueName)))) + ;; Metadata for published datasets (define-dump dump-publishfreeze (tables (PublishFreeze -- cgit v1.2.3