Icon

20230215 Pikairos ChEMBL SQLite database Example of Quering Filtering and Joining before Reading Final Results

This workflow shows how to read data from the ChEMBL SQLite Database with quering, filtering and joining before reading the final Results.

Connect toSQLite ChEMBLDatabase:First download SQLite Databasefromhttps://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/latestCOMPOUNDPROPERTIESKeep rows withnum_ro5_violations = 0Recover Result fromQueriesKeep rows with"SINGLE PROTEIN"in Target_TypeACTIVITIESRecover Result fromQueriesKeep rows with" TYPE" equal to "IC50"AND"STANDARD_RELATION"equal to "="AND"STANDARD_UNIT"equal to "nM"Join Tablesusing KNIMEin MemoryJoin byMOLREGNORecover Result fromQueriesSQLite Connector DB Table Selector DB Row Filter DB Reader DB Row Filter DB Table Selector DB Reader DB Row Filter Joiner DB Joiner DB Reader Connect toSQLite ChEMBLDatabase:First download SQLite Databasefromhttps://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/latestCOMPOUNDPROPERTIESKeep rows withnum_ro5_violations = 0Recover Result fromQueriesKeep rows with"SINGLE PROTEIN"in Target_TypeACTIVITIESRecover Result fromQueriesKeep rows with" TYPE" equal to "IC50"AND"STANDARD_RELATION"equal to "="AND"STANDARD_UNIT"equal to "nM"Join Tablesusing KNIMEin MemoryJoin byMOLREGNORecover Result fromQueriesSQLite Connector DB Table Selector DB Row Filter DB Reader DB Row Filter DB Table Selector DB Reader DB Row Filter Joiner DB Joiner DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Molina
Created at: 2023-02-11
On NodePit since: 2023-02-15
Last update: 2026-01-10
Created with KNIME version: v4.5.2
Tags: SQLite ConnectorDB Table SelectorDB Row FilterDB JoinerDB ReaderChEMBL

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!