This is a test version of Biostars. For the public version, visit https://www.biostars.org.
PubChem CID in ChEMBL

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

chembl pubchem

2 answers

Once again I've answered my own

Table: chembl25.compound_records

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

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...

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.

Log in to answer this question.