about summary refs log tree commit diff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-11-22 18:29:50 +0300
committerMunyoki Kilyungi2023-11-22 18:29:50 +0300
commitcf54f81c7a90533ec0ed8d250a25ebc9fe183ba1 (patch)
treeea51296f7c8b3a2b26dccea79b464556e0857cdf
parentaac0772e2ee29009242f0b01fa56f01f510b1f45 (diff)
downloadgn-transform-databases-cf54f81c7a90533ec0ed8d250a25ebc9fe183ba1.tar.gz
Add extra joins for GeneList and GeneList_rn33.
These tables are referenced when constructing URIs for mouse and rat
data.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xexamples/probeset.scm2
1 files changed, 2 insertions, 0 deletions
diff --git a/examples/probeset.scm b/examples/probeset.scm
index e0a7685..78de14a 100755
--- a/examples/probeset.scm
+++ b/examples/probeset.scm
@@ -14,6 +14,8 @@
 (define-transformer probeset
   (tables (ProbeSet
            (left-join GeneChip "ON GeneChip.Id = ProbeSet.ChipId")
+           (left-join GeneList "ON GeneList.GeneID = ProbeSet.GeneId")
+           (left-join GeneList_rn33 "ON GeneList.geneSymbol = ProbeSet.Symbol")
            (left-join Species "ON GeneChip.SpeciesId = Species.Id")))
   (schema-triples
    (gnt:hasChip a owl:ObjectProperty)