Icon

05_​ChEBI_​ontology_​explorer

Explore the ChEBI Ontology

In this example an ontology in OWL format was used.
After loading the OWL file using the Triple File Reader node, the triples will be stored in a SPARQL Endpoint that allows then to write SPARQL queries to get some usefule data.
When this first step is done, the workflow is containing furthr interaction points where a search query needs to be defined (to search for compounds with a certain substructure and role) and different views can be used to explore the content of ChEBI.

The example workflow can be explored within five steps:

Step 1. Read chebi.owl and insert triples into SPARQL Endpoint
Step 2.* Enter a molecule to search the ontology for chemical compounds containing a certain substructure
- enter a valid SMILES, e.g. N1C2=CC=CC=C2SC2=CC=CC=C12
- enter a role of your interest (e.g. dopaminergic antagonist)
Step 3.* The Tile View shows a list of compounds which match the search query from Step 2. Here only one compound should be selected to go to the next step.
Step 4.* The composite view shows more information about the selected compound. At this point two roles can be selected to go to the next step.
Step 5. Simple Tile View showing results from Step 4.
*User action is needed: Execute + Open Interactive View

Recommendation: increase the memory in your knime.ini as the workflow is loading the whole ontology file into the Memory Endpoint. This will improve the performance of the workflow!

References:
Hastings J, Owen G, Dekker A, Ennis M, Kale N, Muthukrishnan V, Turner S, Swainston N, Mendes P, Steinbeck C. (2016). ChEBI in 2016: Improved services and an expanding collection of metabolites. Nucleic Acids Res.

URL: ChEBI Ontology https://www.ebi.ac.uk/ols/ontologies/chebi
URL: Blog article: Exploring a Chemistry Ontology with KNIME https://www.knime.com/blog/exploring-a-chemistry-ontology-with-knime

Explore the ChEBI ontology
This workflow shows how to query ontologies in KNIME. Here we concentrate especially on chemistry related topics using the ChEBI (Chemical Entities of Biological Interest) ontology that is containing a classification for chemical compounds and their biological, chemical roles and applications.





Step 2*

Step 1

Step 3*

Step 4*

Step 5

Query mol entity classes with roles
SPARQL Query
Result View
String Manipulation
View Compounds Sharing Selected Roles
Memory Endpoint
Get compounds with selected "role"
Enter Search Options
Filter Triple File Store
SPARQL queries
Add triples into a SPARQL endpoint
SPARQL Insert
Query all children* of "molecular entity"
SPARQL Query
Molecule Substructure Filter
Network Visualization
Joining and Grouping
Read chebi.owl
Triple File Reader

Nodes

Extensions

Links