PubChem CID in ChEMBL
2
0
Entering edit mode
5.0 years ago
jpsangio • 0

What table and variable in ChEMBL (version 24 or 25) may be used to search on PubChem CID?

ChEMBL PubChem • 3.2k views
ADD COMMENT
0
Entering edit mode
5.0 years ago
jpsangio • 0

Once again I've answered my own

Table: chembl25.compound_records

Variable: compound_key ('Pubchem CID [CID]')

ADD COMMENT
0
Entering edit mode

First, thanks for your self-answer. I just followed your answer, but there are few number of pubchem CID information (under 100 case) If you found some other method for mapping ChEMBL id to PubChem CID, please let me know...

ADD REPLY
0
Entering edit mode
2.8 years ago

You could use PubChem synonyms from https://ftp.ncbi.nlm.nih.gov/pubchem/Compound/Extras/CID-Synonym-filtered.gz. This file also contains Chembl IDs.

ADD COMMENT

Login before adding your answer.

Traffic: 2532 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