aboutsummaryrefslogtreecommitdiff
path: root/examples
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-12-19 20:31:46 +0300
committerMunyoki Kilyungi2023-12-22 11:53:22 +0300
commit98b8397f788ac109a4c45bcfd5ecdef25dbd2b98 (patch)
tree314effdf45d02e22663394e6a1e0673b9a8afeac /examples
parentda5aa39b9791e697fd84cf2d4f8c881bac55d67a (diff)
downloadgn-transform-databases-98b8397f788ac109a4c45bcfd5ecdef25dbd2b98.tar.gz
Delete "GROUP BY" when transforming genelist/genelist_rn33 metadata.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'examples')
-rwxr-xr-xexamples/genelist.scm6
1 files changed, 2 insertions, 4 deletions
diff --git a/examples/genelist.scm b/examples/genelist.scm
index 2d94a3b..d6337bf 100755
--- a/examples/genelist.scm
+++ b/examples/genelist.scm
@@ -15,8 +15,7 @@
(define-transformer genelist
(tables (GeneList
- (left-join Species "USING (SpeciesId)"))
- "GROUP BY BINARY GeneSymbol, GeneId, chromosome, txStart, txEnd")
+ (left-join Species "USING (SpeciesId)")))
(schema-triples
(gnt:gene rdfs:domain gnc:GeneSymbol)
(gnt:belongsToSpecies rdfs:domain gnc:GeneSymbol)
@@ -303,8 +302,7 @@
#\,)))))
(define-transformer genelist-rn33
- (tables (GeneList_rn33)
- "GROUP BY BINARY GeneSymbol, chromosome, txStart, txEnd")
+ (tables (GeneList_rn33))
(triples
(string->identifier
"gene" (regexp-substitute/global #f "[^A-Za-z0-9:]"