The flagship compound↔target bioactivity bridge: measurements for a molecule (target deconvolution / selectivity), a target (lead finding), or both together (how potently one compound hits one target). Supply at least one of molecule_chembl_id (from chembl_search_molecules) or target_chembl_id (from chembl_search_targets) — supplying both narrows to that compound–target pair, supplying neither is an error. A drug's measurements are often split across its salts and other alternate forms, so molecule_chembl_id reads that one form unless include_alternate_forms widens it to the whole family under its parent (a salt's ID included), every view, page, and spill reading the same family. Filter by standard_type (IC50/Ki/EC50/…), minimum potency pchembl_value_min, assay_type, organism, and variant (wild type, or one recorded mutant such as "T315I"). Each row carries its activity_comment and data_validity_comment, its assay variant, its source document for citation, its family parent_molecule_chembl_id (merge a drug with its salts on it), ChEMBL's potential_duplicate flag for repeat citations, and its assay format (bao_label). Not every measurement has a derivable pchembl_value, so potency_view picks which side of that split you get: the default "potency_ranked" returns the measurements that have one, most potent first (ChEMBL sorts the rest first otherwise, which is why they are not merged), and "null_potency" returns exactly the measurements that have none. totalCount is the honest full match count across both views either way. Mixing measurement types (IC50 vs Ki) is a scientific error — set standard_type to compare like with like. A popular target carries tens of thousands of rows: results spill to a DataCanvas table (call chembl_dataframe_describe for its columns, then chembl_dataframe_query for honest aggregates across the staged set), while an inline preview answers the immediate question. Each view stages its own table (bioactivities / bioactivities_null_potency), so running both against one canvas_id lets a UNION ALL rebuild the full set. A canvas is minted only when a view spills; pass its canvas_id back and every later non-cursor call re-stages the table of its view with its own rows, even when they fit inline or none match, so a successful call never leaves rows from an earlier query in it, and a spill that fails or is cancelled leaves the earlier table in place. The spill is bounded by a row cap (CHEMBL_MAX_SPILL_ROWS) and a time budget (CHEMBL_SPILL_DEADLINE_MS); when either stops it short of the view, truncated is true, truncated_by names the bound, and the table is a bounded slice, not the complete view. The inline rows are always capped at limit, so compare that against totalCount before treating them as the whole answer. Spilling needs the canvas, which is on unless the server sets CANVAS_PROVIDER_TYPE=none. Whenever a call stages nothing and rows remain past this page — the canvas is off, or the view fit inline with no canvas_id — nextCursor continues the view: pass it back as cursor, with the same filters and potency_view, for the next page. A cursor page is always returned inline and never staged, canvas or not.
View input schema
{
"type": "object",
"properties": {
"molecule_chembl_id": {
"description": "ChEMBL molecule ID (from chembl_search_molecules), e.g. \"CHEMBL941\". Supply this, target_chembl_id, or both — both narrows to that compound–target pair.",
"type": "string"
},
"include_alternate_forms": {
"default": false,
"description": "Widen molecule_chembl_id to its whole family: the parent it belongs to and every salt and other alternate form ChEMBL files under it (a drug's measurements are often split across them). A salt's ID reaches its parent's family; each row keeps the molecule_chembl_id of the form it was measured on. Requires molecule_chembl_id; combines with target_chembl_id and every filter. Defaults to false: that one form's measurements only.",
"type": "boolean"
},
"target_chembl_id": {
"description": "ChEMBL target ID (from chembl_search_targets), e.g. \"CHEMBL203\". Supply this, molecule_chembl_id, or both — both narrows to that compound–target pair.",
"type": "string",
"pattern": "^\\s*(?:[Cc][Hh][Ee][Mm][Bb][Ll]\\d+\\s*)?$"
},
"standard_type": {
"description": "Restrict to one measurement type, e.g. \"IC50\", \"Ki\", \"EC50\". Matched exactly, case included — ChEMBL records distinct types that differ only by case, such as \"Kd\" and \"KD\". Set this to compare potencies validly.",
"type": "string"
},
"pchembl_value_min": {
"description": "Minimum pchembl_value (−log10 molar potency), e.g. 7 keeps sub-100 nM activities. Only valid on the potency_ranked view — the null_potency rows have no pchembl_value to compare against.",
"type": "number"
},
"potency_view": {
"description": "Which side of the pchembl_value presence split to retrieve. \"potency_ranked\" (default) returns the measurements that have a derivable pchembl_value, most potent first. \"null_potency\" returns exactly the measurements that have none — the rows the ranked view excludes, otherwise unreachable. The two partition the match set and stage to separate canvas tables.",
"default": "potency_ranked",
"type": "string",
"enum": [
"potency_ranked",
"null_potency",
""
]
},
"assay_type": {
"description": "Restrict to an assay type code: \"B\" (binding), \"F\" (functional), \"A\" (ADMET), \"T\" (toxicity), \"P\" (physicochemical), \"U\" (unassigned).",
"type": "string",
"pattern": "^\\s*(?:(?:[Bb]|[Bb][Ii][Nn][Dd][Ii][Nn][Gg]|[Ff]|[Ff][Uu][Nn][Cc][Tt][Ii][Oo][Nn][Aa][Ll]|[Aa]|[Aa][Dd][Mm][Ee]|[Aa][Dd][Mm][Ee][Tt]|[Tt]|[Tt][Oo][Xx][Ii][Cc][Ii][Tt][Yy]|[Pp]|[Pp][Hh][Yy][Ss][Ii][Cc][Oo][Cc][Hh][Ee][Mm][Ii][Cc][Aa][Ll]|[Uu]|[Uu][Nn][Aa][Ss][Ss][Ii][Gg][Nn][Ee][Dd]|[Uu][Nn][Cc][Ll][Aa][Ss][Ss][Ii][Ff][Ii][Ee][Dd])\\s*)?$"
},
"organism": {
"description": "Restrict to a target organism, e.g. \"Homo sapiens\" (case-insensitive exact match).",
"type": "string"
},
"variant": {
"description": "Restrict to one assay variant of the target. \"wild_type\" keeps the measurements that record no variant. Any other value keeps those whose recorded assay_variant_mutation equals it whole, case-insensitively, with spaces beside \",\" or \"/\" ignored: a substitution (\"T315I\"), a deletion (\"F508del\"), a multi-mutant in the order ChEMBL records it (\"L858R,T790M\"; \"T790M,L858R\" matches nothing, and \"L858R\" alone matches only the single mutant), or \"UNDEFINED MUTATION\" for an unspecified mutant. Read assay_variant_mutation on unfiltered rows for the recorded strings.",
"type": "string"
},
"limit": {
"description": "Maximum rows in the inline preview or cursor page, up to 1000 — a larger value is served at 1000, with a notice saying so. Defaults to the server default (25). With the canvas enabled, a view that spills still stages in full whatever the limit; when a call stages nothing, nextCursor reaches the rows past limit.",
"type": "integer",
"minimum": 1,
"maximum": 10000
},
"canvas_id": {
"description": "Optional canvas ID from a prior call to reuse the same canvas. With it, the call re-stages the selected potency_view's table with this call's rows whether they spill, fit inline, or are empty, so a second query of the SAME view REPLACES (overwrites) its prior rows once it succeeds — it does not append, and a spill that fails or is cancelled leaves them — while the other view's table is left intact, which is what lets both coexist on one canvas. Omit it and a fresh canvas is minted only if the view spills. Left untouched on a cursor page, which never stages.",
"type": "string",
"pattern": "^\\s*$|^[A-Za-z0-9_-]{10}$"
},
"cursor": {
"description": "Opaque continuation token from a previous call's nextCursor — resumes the view where that page ended. Omit for the first page. Re-send the same molecule_chembl_id/target_chembl_id, include_alternate_forms, filters, and potency_view that minted it (only limit may change; it sets this page's size); redeeming it against different filters walks a different result set. A cursor page is returned inline and never staged, even with the canvas enabled.",
"type": "string"
}
},
"$schema": "https://json-schema.org/draft/2020-12/schema",
"additionalProperties": false
}