Specifically the issue is that the drug_indication table has the incorrect max_phase_for_ind.
For example,
The drug “AMLODIPINE” (molregno = 418414) shows 13 indications with Phase 4 in the UI
However, the drug_indication table in the database and accessible via web services has only one indication with Phase 4 (Cardiovascular disease, drug_ind_id = 52720).
One example of an indication that shows with phase 4 in the UI is Myocardial Infarction (drug_ind_id = 123210) but this shows with Phase 3 in web services and database.
Additional Information:
I have identified multiple other drugs with this same issue (e.g. LEVOTHYROXINE, LOSARTAN).
I'm not sure if this is related but in the AMLODIPINE and LOSARTAN examples it seems like if the source of the indication is ATC, then it’s phase is correct (such as the cardiovascular disease example above).
I recently discovered an issue where indication data shown in the UI does not align with the Chembl data downloadable at https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/latest/ or via web services.
Specifically the issue is that the
drug_indicationtable has the incorrectmax_phase_for_ind.For example,
drug_indicationtable in the database and accessible via web services has only one indication with Phase 4 (Cardiovascular disease, drug_ind_id = 52720).Additional Information:
I have identified multiple other drugs with this same issue (e.g. LEVOTHYROXINE, LOSARTAN).
I'm not sure if this is related but in the AMLODIPINE and LOSARTAN examples it seems like if the source of the indication is ATC, then it’s phase is correct (such as the cardiovascular disease example above).