ChEMBL is a bioactivity database for drug-like compounds. The ACTIVITIES table stores the readout from bioassays that test compounds against a biological target. These are often numerical readouts such as Ki, IC50, Inhibition %, or Cmax but are occasionally non-numerical summary data, e.g., “Not Soluble”, “Not active”, or “Active”. Historically, the non-numerical data was captured as an ACTIVITY_COMMENT but since ChEMBL 24 this has been more accurately captured as TEXT_VALUE. Whilst the TEXT_VALUE field has been used more extensively in recent releases, legacy data covering experimental outcomes, observations, context such as threshold values, and other metadata is still largely hosted in the ACTIVITY_COMMENT field. Moving forward, only the TEXT_VALUE field will be used to report the primary outcome of an experiment where the output is not numerical, for example categorical data. This could be reporting an Activity (e.g., “Active”/ “ Not active”), Toxicity (e.g., “Toxic”/ “ ...
Blog of Chemical Biology Services at EMBL-EBI