Hi,
We have a local installation of UCSC that was updated yesterday, and I
have problem querying the mysql DB and I would like to know if you can
help me.
I want use the mysql tables to retrieve informations starting from a
list of ensembl gene ID. To do this I use the tables: ensGene,
knownToEnsembl, kgXref with the following query:
>>select QUERY.name,QUERY.name2,QUERY.geneSymbol,QUERY.refseq from
(select X.*, G.* from ensGene as G, knownToEnsembl as KE, kgXref as
X where G.name=KE.value
and KE.name=X.kgID and G.name2='ensID') as QUERY;
For some of this ensemblId if I query the hg19 DB I don't get any
results, instead of if I query hg18 DB they can be found.
But when I search the same ensemblID through the web interface I see
that they are present in the ensembl gene track.
although in the visualization in hg19 the results are titled
EnsemblGene, in the hg18 EnsGene (I don't know if this may be relevant).
Is there anything missing in my query?
here are some of the ensemblID for which I see this problem:
ENSG00000026103
ENSG00000030110
ENSG00000104725
ENSG00000104774
Thanks in advances, best regard
Rossella
----------------------------------------------------------------------------
Rossella Rispoli,
Bioinformatics Core Group
Telethon Institute of Genetics and Medicine (TIGEM)
Via P. Castellino 111, 80131, Naples, Italy
Tel: +39 081 6132 498
Fax: +39 081 6132 351
Web: http://bioinformatics.tigem.it/
-----------------------------------------------------------------------------
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
