Have a query which I run to get UCSC2HGNC ID mappings
SELECT geneSymbol, hgncId, transcript, '-'
FROM knownCanonical,kgXref,proteome.hgncXref
WHERE kgXref.kgID=knownCanonical.transcript
AND kgXref.geneSymbol = proteome.hgncXref.symbol
I'm running it on
mysql -h genome-mysql.cse.ucsc.edu -u genome -A
USE hg19
and the query just hangs and sits there for hours
--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD Tel:44-1223 492626
Bioinformatician HUGO Gene Nomenclature Committee Email:
[email protected]
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
