Two examples demonstrated with Knime

Knime is an open-source platform that can integrated with many third-party software, website and databases.

Posted by Quantao on December 22, 2020

KNIME is a very cool idea that it allows all people from different backgrounds to improve their work efficiency greatly.

Knime is free software, it can be integrated with many software, websites, and databases to help you work smarter. But if the third-party resources need a license, then you do need a license to let Knime run them in the background as well.

The first example we are going to talk about is EXCEL.

The good thing about Knime is all the calculation is happening behind the scene, you will not see anything happening but some “Traffic Lights” changing from yellow to green if everything is right, and a red one if there is an error, this helps you focus more on the problem itself.

Example 1

The next example is about making an image for sales statistical data.

The table below is what Knime needs to deal with, a staked are chart, and a pie chart need to be made.

This table is stored in the workspace of the Knime workspace you have defined when you launch Knime.

Now, if you just press “Shift+F7”, the Knime workflow will be executed. This is a really easy job for Knime, so the job will be done almost immediately. All the traffic lights turned green, indicating all job finished successfully.

After finish, you just need to right-click the last node to view the image like below.

Example 2.

(In case you decide to use this workflow in your research project, just remember to cite the paper about this workflow.)

Next, I will show you how to use Knime to explore Kinase information, The database called KLIFs is a database containing all the kinase and related ligand information. We split this example into two parts, part 1 is install the KLIFs node, part2 shows how to run the workflow to view the protein-ligand interaction, interaction fingerprint analysis of human MAPK-ligand complexes.

part1.

To enable Knime can interact with your software or database of interest, you need to install the software first on your computer, then in Knime, you need to install the corresponding “node” for that software. In our case, what I want Knime to do is to interact with a free database online, so I only need to install the “node” which is called “KLIFs-Knime-node” which is fine.

The node is fetched from So, you need to go to “Help” > “install new software > “add”, then paste "https://3d-e-chem.github.io/updates " to the Archive, click “OK” to search the Node, after some nodes are listed, select the “KLIFS KNIME nodes” and installed, then restart KNIME.

The workflow can be downloaded from the workflow link

part2.

What you need to is to select a kinase family of your interest, let’s say you are interested in the MAPK family, you just right-click the “Row Filter” node to configure the node, by selecting MAPK. If you just want to feel the fun of Knime, you could just leave it as its default, and press shift+f7 to execute all the workflow.

If you are interested in, e.g. the kinase group of CMGC, then, you need to modify the "Row Filter" to select as the next image

If you right-click the view button after finish there will be something like below, what you get is a group of similar kinases with their bound ligand structure and the pocket amino acid sequence, based on your screening conditions specified above

After all the job is done, if you click the “structures Retrievers” node, you will see a representative binding pattern for the ligand and the Hinge area of the kinase, based on your defined family.

The end

To be summarized, Knime is capable to interact with many software and databases. The above examples are kind of hard to understand for people who are not familiar with a certain research area. All I want to say is the community of Knime is huge and active, there are always new nodes and new workflow contributing to the KnimeHub. You can create your workflow and upload it to Knime Hub to be a contributor as well, especially in the area you are good at, Like the IT area or even language analysis!

Since knime works in a form of a workflow, which means once you need to update your first node, and you can just run the workflow to the final node, with one click. It is extremely convenient when calculations need to be validated.