ag "Observational study of gene-disease association" dump.ttl --pager='less -R' ag "gn:symbol" | sort | less ag "gn:anonSymbol" | sort | less
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 GeneInfo WHERE GeneId = 68350\G
To query these entries:
SELECT * FROM GeneRIF_BASIC WHERE symbol = 'NEWENTRY'\G
'(("\x28" . "") ("\x29" . "") ("\xa0" . " ") ("��\x81���" . "/") ("�����\x9d" . #\") ("��������" . #\') ("\x02" . "") ("\x01" . "") ("����" . "��") ("����-��\xad" . "��") ("��\xad" . "") ("����" . "��") ("��������" . "-"))
SELECT COUNT(*) FROM GeneRIF_BASIC WHERE symbol = '';