drug_indication max_phase_for_ind is not aligned with max phase in UI

[kmarkey-mdsol]

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