about summary refs log tree commit diff
path: root/examples/probesets-experiment-metadata.scm
diff options
context:
space:
mode:
authorMunyoki Kilyungi2026-02-18 11:03:48 +0300
committerMunyoki Kilyungi2026-02-18 11:03:48 +0300
commit2091c1c812912755d9cd67723f1ba45a6666de5d (patch)
tree0df37da679724fbffbcd82cceb7fe3337ce790d8 /examples/probesets-experiment-metadata.scm
parentf5e0df7a66f4dbecb27c8e4f41ac760746d6c9de (diff)
downloadgn-transform-databases-2091c1c812912755d9cd67723f1ba45a6666de5d.tar.gz
Only transform datasets with public > 0 and confidentiality < 1.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples/probesets-experiment-metadata.scm')
-rwxr-xr-xexamples/probesets-experiment-metadata.scm3
1 files changed, 2 insertions, 1 deletions
diff --git a/examples/probesets-experiment-metadata.scm b/examples/probesets-experiment-metadata.scm
index e019928..b15f7e9 100755
--- a/examples/probesets-experiment-metadata.scm
+++ b/examples/probesets-experiment-metadata.scm
@@ -16,7 +16,8 @@
 (define-transformer probesetxref->metadata
   (tables (ProbeSetXRef
            (inner-join ProbeSetFreeze "ON ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id")
-           (inner-join ProbeSet "ON ProbeSet.Id = ProbeSetXRef.ProbeSetId")))
+           (inner-join ProbeSet "ON ProbeSet.Id = ProbeSetXRef.ProbeSetId"))
+          "WHERE ProbeSetFreeze.public > 0 AND ProbeSetFreeze.confidentiality < 1")
   (triples (string->identifier
             "probeset_data"
             (uri-encode