Hub
Pricing About
ComponentComponent

ChEMBL Activity From Molecule Retrieval

gcincilla profile image
VersionV2.0.2 Created on  Jun 18, 2025 3:07 PM
Drag & drop
Like
Use or download
This component connects to an instance of the ChEMBL database and retrieves activities available based on small-molecule ChEMBL IDs.

The first output (outport_0) contains the aggregated activity values. Activity values that share the same small molecule, target, activity type, activity relation, and activity units are aggregated.
1. For "=", "~" or null activity relations, the aggregated value corresponds to the values mean. In these cases also the standard deviation is calculated, and a final aggregated and rounded activity string is also produced (e.g., "IC50 = 128 ± 6").
2. For "<", "<=" and "<<" activity relations, the aggregated value corresponds to the aggregated minimum value. Standard deviation is null in these cases.
3. For ">", ">=" and ">>" activity relations, the aggregated value corresponds to the aggregated maximum value. Standard deviation is null in these cases.

The second output (outport_1) includes all individual activities along with their corresponding activity source references.

For this component to function, the ChEMBL DB Connection variables must be defined at the workflow level. These variables can be established using the ChEMBL DB Connection component.

Component details

Input ports
  1. Type: Table
    Table with compound ChEMBL IDs.
    Table with compound ChEMBL IDs.
Output ports
  1. Type: Table
    Aggregated activity data
    Aggregated activity data
  2. Type: Table
    Activity data & data source
    Activity data & data source

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.6
  • Go to item
    KNIME Base Chemistry Types & NodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.6

    knime
  • Go to item
    KNIME DatabaseTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.6

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.6

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.6

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits