Ensembl homo_sapiens_core_84_38: no more MIM_MORBID linked to genes?
0
0
Entering edit mode
8.6 years ago
rawi • 0

Hello @ALL BioStars! My first Question here...

I installed localy the (ensembl) human databases for me to learn and occasionally run scripts with SQL on them.

With the SQL:

SELECT gene.stable_id, gene.description, xref.*
FROM gene INNER JOIN object_xref ON gene.gene_id = object_xref.ensembl_id
    INNER JOIN xref ON xref.xref_id = object_xref.xref_id
WHERE 
    gene.stable_id = 'ENSG00000125730' AND
    object_xref.ensembl_object_type = 'Gene' AND
    xref.external_db_id = 1520

... i've got in homo_sapiens_core_81_38 still 3 MIM_MORBID records (1520 is the external_db_id for MIM_MORBID)

Now in homo_sapiens_core_84_38 I get nothing more.

xref has still over 8000 records for the external source MIM_MORBID, but none of them are liked in object_xref any more.

Looking at the WEB-Page of ENSG00000125730 I can see all possible phenotypes for this gene, not only MIM_MORBID, but also GOA (even with PMIDs) and Orphanet.

How I could link a gene again to this external resources (SQL)?

Orphanet isn't any more in the external_db table. PUBMED is there, but has no records in xref.

From where are those infos coming onto the Web page?

Thanks

ensembl database sql MIM_MORBID • 1.4k views
ADD COMMENT

Login before adding your answer.

Traffic: 2072 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6