diff options
| author | Munyoki Kilyungi | 2023-09-11 14:00:00 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-09-11 14:00:29 +0300 |
| commit | b9252098ede330fb41b463530e93f182d4e929bf (patch) | |
| tree | 0725213b928e6ab36bb2c140e9fb7f7e5b97e2d6 | |
| parent | a002190cd1b9b3676e824837c7645169a1544e6f (diff) | |
| download | gn-transform-databases-b9252098ede330fb41b463530e93f182d4e929bf.tar.gz | |
Filter out empty symbols when dumping generif metadata.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/generif.scm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/examples/generif.scm b/examples/generif.scm index 89e7fce..83f8632 100755 --- a/examples/generif.scm +++ b/examples/generif.scm @@ -138,7 +138,7 @@ (define-transformer ncbi-genewiki-entries (tables (GeneRIF_BASIC (left-join Species "USING (SpeciesId)")) - "WHERE GeneRIF_BASIC.comment IS NOT NULL GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID") + "WHERE GeneRIF_BASIC.comment IS NOT NULL AND TRIM(GeneRIF_BASIC.comment) != '' AND TRIM(GeneRIF_BASIC.symbol) != '' GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID") (schema-triples (gnc:NCBIWikiEntry rdfs:subClassOf gnc:GeneWikiEntry) (gnc:NCBIWikiEntry rdfs:comment "Represents GeneRIF Entries obtained from NCBI") |