diff options
| author | Munyoki Kilyungi | 2023-06-06 14:45:45 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2023-06-12 19:06:36 +0300 |
| commit | 08df35602e16556991403d256dc156d0def8d5a5 (patch) | |
| tree | a02a05708a580352177334f4166ce8671835864e | |
| parent | 0f9e3501be54e951c9101d448e8003ad693f6834 (diff) | |
| download | gn-transform-databases-08df35602e16556991403d256dc156d0def8d5a5.tar.gz | |
Add geoPlatfrom to dataset dump
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/dump-dataset-metadata.scm | 1 | ||||
| -rwxr-xr-x | examples/dump-probesetfreeze.scm | 5 |
2 files changed, 5 insertions, 1 deletions
diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index 7519582..38f13bb 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -91,6 +91,7 @@ (left-join Tissue "USING (TissueId)") (left-join Investigators "USING (InvestigatorId)") (left-join AvgMethod "USING (AvgMethodId)") + (left-join Organizations "USING (OrganizationId)") (left-join GeneChip "USING (GeneChipId)")) "WHERE GN_AccesionId IS NOT NULL AND ((PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1) OR (GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1) OR (ProbeSetFreeze.public > 0 AND ProbeSetFreeze.confidentiality < 1))") (schema-triples diff --git a/examples/dump-probesetfreeze.scm b/examples/dump-probesetfreeze.scm index 3e0c930..0be81ac 100755 --- a/examples/dump-probesetfreeze.scm +++ b/examples/dump-probesetfreeze.scm @@ -26,7 +26,10 @@ (gn:name rdfs:range rdfs:Literal)) (triples (string->identifier "platform" (field GeneChip Name)) (set rdf:type 'gn:platform) - (set gn:name (field GeneChip GeneChipName)))) + (set gn:name (field GeneChip GeneChipName)) + (set gn:geoPlatform + (ontology 'geoSeries: + (string-trim-both (field GeneChip GeoPlatform)))))) ;; Molecular Traits are also referred to as ProbeSets (define-dump dump-probesetfreeze |