Icon

RESOLUTE_​tool compounds_​publication

RESOLUTE_tool compounds

This workflow was created as part of the paper "Advancing drug discovery through assay development: a survey of tool compounds within the human solute carrier superfamily" by D. Digles, A. Ingles-Prieto et al. published in Frontiers in Pharmacology, 2024 (https://doi.org/10.3389/fphar.2024.1401599).
The workflow collects inhibitor information for solute carriers (SLCs) from different data sources, calculates selectivity values and adds flags that can be used as filters (e.g., to keep potential tool compounds only). For more details, please refer to the publication.
To run the workflow, the current ChEMBL sqlite file needs to be downloaded from https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/latest/, uncompressed and read with the SQLite Connector node. The original workflow was executed using ChEMBL Version 33, available here: https://doi.org/10.6019/CHEMBL.database.33. All other input data files are provided in the workflow data area. Result files will be written in the results folder in the workflow data area.

Download the latest sqlite file fromChEMBL, uncompress it and read itwith the SQLite Connector. Erlwood pareto ranking nolonger available for KNIME4.7, installed previousversion Result analysis, provides counts for the paper Exports full SLC inhibitor list Node 969extended SLC listRESOLUTE listremove whitespacesjoin to resolute manual listvia chembl parent idNode 1047if parent chembl molecule ID is missing, take pubchem ID insteadNode 1555purchase informationChEMBL33flag resoluteNode 1613adds PAINS flagTable from EUbOpenjoin to EUbOpen listNode 1621remove full data matrixNode 1624Node 1626Node 1629potential tool compounds that can be purchasedNode 1631SLCs in full listunique molecules(full list)unique molecules (potential tool compounds)downloaded data for Transporters from chemicalprobes.orgkeep SLCs onlyjoin to chemicalprobes.org dataflag chemicalprobespotential tool compoundnumber of potential tool compounds per SLCtested compounds onlytest resultskeep unique entrieskeep unique pairsNode 1662Node 1663databases onlyremove SLC from name for better readabilityfinal list with descriptorsused for Lipinski rule visualization in the manuscript supplementary table6tested compoundsSupplementary Figure 2public databases plus inhouse testingFigure4Achemical probes?suppl. table 2FLAG_potentialToolCompoundSLCs in potential tool compound listColumn explanationssuppl. table 2explanation sheetNode 1737Node 1738Node 1739 Get ChEMBLparent molecules Selectivity Entropy Target Matrix Primary &Off-Targets Pareto Ranking Structure-ActivityData Joiner Excel Reader Excel Reader String Manipulation(Multi Column) Joiner Column Rename Column Merger PAINS substructuresearch Table Reader SQLite Connector ConstantValue Column flags forselectivity Joiner Table Creator Joiner Column Rename Column Splitter Column Rename Column Resorter Sorter Joiner Excel Writer GroupBy GroupBy GroupBy File Reader Reference RowSplitter Joiner ConstantValue Column Row Filter Bar Chart Joiner Excel Reader GroupBy GroupBy merge structureand name columns Molecule Type Cast Heatmap String Replacer Excel Writer Excel Writer GroupBy Image Writer (Port) Heatmap Image Writer (Port) Row Filter Excel Writer Rule Engine GroupBy Table Creator Excel Writer data merging forSuppl. Table 6 preparation ofdata for heatmaps preparation of data forlipinski rule visualization Download the latest sqlite file fromChEMBL, uncompress it and read itwith the SQLite Connector. Erlwood pareto ranking nolonger available for KNIME4.7, installed previousversion Result analysis, provides counts for the paper Exports full SLC inhibitor list Node 969extended SLC listRESOLUTE listremove whitespacesjoin to resolute manual listvia chembl parent idNode 1047if parent chembl molecule ID is missing, take pubchem ID insteadNode 1555purchase informationChEMBL33flag resoluteNode 1613adds PAINS flagTable from EUbOpenjoin to EUbOpen listNode 1621remove full data matrixNode 1624Node 1626Node 1629potential tool compounds that can be purchasedNode 1631SLCs in full listunique molecules(full list)unique molecules (potential tool compounds)downloaded data for Transporters from chemicalprobes.orgkeep SLCs onlyjoin to chemicalprobes.org dataflag chemicalprobespotential tool compoundnumber of potential tool compounds per SLCtested compounds onlytest resultskeep unique entrieskeep unique pairsNode 1662Node 1663databases onlyremove SLC from name for better readabilityfinal list with descriptorsused for Lipinski rule visualization in the manuscript supplementary table6tested compoundsSupplementary Figure 2public databases plus inhouse testingFigure4Achemical probes?suppl. table 2FLAG_potentialToolCompoundSLCs in potential tool compound listColumn explanationssuppl. table 2explanation sheetNode 1737Node 1738Node 1739Get ChEMBLparent molecules Selectivity Entropy Target Matrix Primary &Off-Targets Pareto Ranking Structure-ActivityData Joiner Excel Reader Excel Reader String Manipulation(Multi Column) Joiner Column Rename Column Merger PAINS substructuresearch Table Reader SQLite Connector ConstantValue Column flags forselectivity Joiner Table Creator Joiner Column Rename Column Splitter Column Rename Column Resorter Sorter Joiner Excel Writer GroupBy GroupBy GroupBy File Reader Reference RowSplitter Joiner ConstantValue Column Row Filter Bar Chart Joiner Excel Reader GroupBy GroupBy merge structureand name columns Molecule Type Cast Heatmap String Replacer Excel Writer Excel Writer GroupBy Image Writer (Port) Heatmap Image Writer (Port) Row Filter Excel Writer Rule Engine GroupBy Table Creator Excel Writer data merging forSuppl. Table 6 preparation ofdata for heatmaps preparation of data forlipinski rule visualization

Nodes

Extensions

Links