aboutsummaryrefslogtreecommitdiff
path: root/examples/dump-dataset-metadata.scm
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-06-06 14:45:45 +0300
committerBonfaceKilz2023-06-12 19:06:36 +0300
commit08df35602e16556991403d256dc156d0def8d5a5 (patch)
treea02a05708a580352177334f4166ce8671835864e /examples/dump-dataset-metadata.scm
parent0f9e3501be54e951c9101d448e8003ad693f6834 (diff)
downloadgn-transform-databases-08df35602e16556991403d256dc156d0def8d5a5.tar.gz
Add geoPlatfrom to dataset dump
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples/dump-dataset-metadata.scm')
-rwxr-xr-xexamples/dump-dataset-metadata.scm1
1 files changed, 1 insertions, 0 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