diff options
| author | Munyoki Kilyungi | 2023-04-03 12:15:43 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-04-03 12:16:45 +0300 |
| commit | 3eb874d67209ee2ab1b1f84774e5ae45747a224b (patch) | |
| tree | 041e17c2583fe8d890b2babfaf958d5b243f0926 | |
| parent | ed011383b14ac5340653cb7cbca569ba237e8d6c (diff) | |
| download | gn-gemtext-3eb874d67209ee2ab1b1f84774e5ae45747a224b.tar.gz | |
Update formatting of SQL queries
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rw-r--r-- | issues/dump-genewiki-metadata.gmi | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/issues/dump-genewiki-metadata.gmi b/issues/dump-genewiki-metadata.gmi index b727e26..3aa5410 100644 --- a/issues/dump-genewiki-metadata.gmi +++ b/issues/dump-genewiki-metadata.gmi @@ -16,19 +16,22 @@ Dump the tables: => https://www.w3.org/TR/rdf-schema/ RDF Schema 1.1 => https://www.clearbyte.org/?p=5895&lang=en RDF/S quick walk through => https://www.dublincore.org/specifications/dublin-core/dcmi-terms/# DCMI Metadata Terms -=> https://sparql.uniprot.org/.well-known/sparql-examples/ => UNIPROT sparql examples +=> https://sparql.uniprot.org/.well-known/sparql-examples/ UNIPROT sparql examples ## Issues * Some entries in the GeneRIF table don't have any entries in the GeneRIF_BASIC table: ``` -SELECT * FROM GeneRIF LEFT JOIN GeneRIF_BASIC USING (symbol) LEFT JOIN GeneRIFXRef ON GeneRIFXRef.GeneRIFId = GeneRIF.Id LEFT JOIN GeneCategory ON GeneRIFXRef.GeneCategoryId = GeneCategory.Id WHERE GeneRIF.display > 0 AND GeneRIF.VersionId = 0 AND GeneRIF_BASIC.GeneId IS NULL\G +SELECT * FROM GeneRIF LEFT JOIN GeneRIF_BASIC USING (symbol) +LEFT JOIN GeneRIFXRef ON GeneRIFXRef.GeneRIFId = GeneRIF.Id +LEFT JOIN GeneCategory ON GeneRIFXRef.GeneCategoryId = GeneCategory.Id +WHERE GeneRIF.display > 0 AND GeneRIF.VersionId = 0 +AND GeneRIF_BASIC.GeneId IS NULL\G ``` * Missing data: some GeneIds stored in GN are not in GeneInfo. These can be conceptualised as anonymous genewiki entries. One example is the symbol "Mul1" with the GeneId 68350. This example exists in GN with different GeneId's. Example query: -=> ``` SELECT * FROM GeneInfo WHERE GeneId = 68350\G @@ -68,3 +71,7 @@ SELECT * FROM GeneRIF_BASIC WHERE symbol = 'NEWENTRY'\G ``` SELECT COUNT(*) FROM GeneRIF_BASIC WHERE symbol = ''; ``` + +* The are comments with the same values but different GeneIds. Example: + +=> https://gn1.genenetwork.org/webqtl/main.py?FormID=geneWiki&symbol=A2m |