Entering edit mode
4.9 years ago
jpsangio
•
0
What table and variable in ChEMBL (version 24 or 25) may be used to search on PubChem CID?
What table and variable in ChEMBL (version 24 or 25) may be used to search on PubChem CID?
Once again I've answered my own
Table: chembl25.compound_records
Variable: compound_key ('Pubchem CID [CID]')
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.
Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
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...