ChEMBL Indication Processor

[cthoyt]

This SQL statement can be used with the chembl_downloader to get links between chemicals and their indications (either as mesh or EFO/HP) and their maximum clinical phase:

SELECT
    MOLECULE_DICTIONARY.chembl_id,
    MOLECULE_DICTIONARY.pref_name,
    DRUG_INDICATION.mesh_id,
    DRUG_INDICATION.mesh_heading,
    DRUG_INDICATION.efo_id,
    DRUG_INDICATION.efo_term,
    DRUG_INDICATION.max_phase_for_ind
FROM MOLECULE_DICTIONARY
JOIN DRUG_INDICATION ON MOLECULE_DICTIONARY.molregno == DRUG_INDICATION.molregno

There's another column in MOLECULE_DICTIONARY called chebi_par_id but a spot check of the first 10 rows showed this doesn't have good coverage