The External Tools Node lets you call executable files for other applications. It's especially useful for working with Shell scripts and Window’s executables so that you can integrate KNIME with your existing processes and applications.View on KNIME Hub
Previous Workflow Snippets
Always wanted to generate beautiful reports with the Business Intelligence and Reporting Tool (BIRT) and never dared to try? This workflow snippet gives you an excellent opportunity to learn how to transfer several different data elements to a BIRT report using KNIME Report Designer.
Connecting to a Database could fail for multiple reasons such as network related issues, too many connections to the server at a time, etc. It is desirable to automatically retry connecting to a database a couple of times to avoid a failure of workflow execution due to a temporary glitch. This workflow snippet shows one way of doing that.
Ever got impressed by the many different ways in which chemists can represent the same thing? In this workflow snippet we show how to use the open-source RDKit nodes to standardize molecular structures. In particular we have a look at the Remove Hs, Salt Stripper and Structure Normalizer nodes.
This workflow snippet demonstrates an example query to a GraphQL API. The Open Targets Platform provides a GraphQL API, which supports queries for a single target, disease/phenotype, drug, or target-disease association. Here, we are using Ensembl Gene IDs to query more information, e.g. description, genomic location, associated disease, ...
This workflow snippet demonstrates how to use an already trained model on new data to predict bioactivity. Simply load the trained model with the Model Reader node and provide this to the corresponding Predictor Node, in our case this is the Random Forest Predictor node.
Did you even wonder how you can train a bioactivity model using chemical structures? Take a look at this workflow snippet, to learn how to transform chemical structures into hashed bit-based fingerprints, which serve as an input for a Random Forest model to predict CDPK1 bioactivity. Evaluate the model performance using the ROC Curve and the confusion matrix.
This workflow snippet shows how a time-to-event analysis can be easily done using KNIME Analytics Platform. You simply upload a file containing the corresponding data from a clinical study, e.g. in .xpt format, and after a small column manipulation the event is ready to be analyzed in the Kaplan-Meier Plot.
This workflow snippet counts the number of atoms in a molecule for an element of choice. This is done by first getting the molecular formula and using regex to extract the number of atoms.
Sometimes special colors are needed to let your report shine! This workflow shows you how to customize colors in your chart using KNIME Analytics Platform.
This workflow shows you how to create a clickable hyperlink in the Table View. It takes PubMed IDs as input and manipulates them into a certain format. This makes your interactive views even more interactive and allows you to open other pages right away from the Table View.
This workflow snippet is meant as a sequel to the previous one, where we showed you how to align molecules. There are some cases where the alignment might not have worked for you right away, e.g. when your drawn structure contains aromaticity. Learn in this snippet how to sanitize SMARTS for any kind of queries (or well, to finally align your molecules).
Your molecules all contain the same substructure, but they are not aligned accordingly and deep down it’s driving you somehow nuts? Check out this workflow snippet that shows you how to align the orientation of molecules according to a drawn substructure. Using the SMARTS thereof we can then generate 2D coordinates for all the molecules. If you run into trouble with the SMARTS, check out the next workflow snippet where we will show you how to sanitize them.
The Table Manipulator node is rarely used, although it combines quite some functionalities. You can use it to rename columns, resort the column order, change the column types and select which columns to include or exclude from your table. Have a look at this workflow snippet to see the Table Manipulator node in action.
Would you like to color individual cells in your data table based on a certain value? This workflow snippet shows how to customize the individual cells in the table using the HTML color groups.
Do you want to use your favorite python library to create highly customized plots from the KNIME Analytics platform? This example workflow shows how to create a 2D kernel density estimate (KDE) plot using the seaborn (https://seaborn.pydata.org/) python data visualization library.
Learn how to apply a flow variable with multiple columns. Using the example of filtering multiple columns, we extract the column names of our data, create a collection column containing the desired column names, and then generate a variable that we use in the column filter node.
Discover in this workflow snippet how to do matched molecular pairs analysis in KNIME. Check the preprocessing of the molecules happening in the metanode, and find matches in your data set with the nodes from the Vernalis community extension.
This workflow snippet to format your Excel file might appear very complex in the beginning, but once you get the hang of it, you can easily automate your Excel formatting and reduce your manual work. More time to do fun stuff.
Did you know that the Excel Writer node does not only export strings and numerical values to your Excel file, but also images? This comes in handy when you want to export images of your molecules. Simply use the Renderer to Image node and export your PNGs to Excel.
Interested in finding hidden relationships in your data and demonstrating it to your colleagues in a clear and concise way? This workflow snippet shows how to visually explore a dataset with molecules and their properties.
Do you want to fetch data from a database without loading a complete database table? You are interested in just a couple of columns and some rows meeting a certain criteria? This workflow snippet shows how to get only the attributes & records you need as a KNIME table.
Do you want to combine the power of KNIME with your favourite R library? Learn in this easy workflow snippet how to import a R package and create a simple R plot.
Wondering what a whole row of 0s and 1s have to do with chemical structures? Want to investigate the similarity of molecules? Have a look at this workflow snippet demonstrating how to compute molecular fingerprints in KNIME and giving some background information.
Good things come to those who wait! Of course, with “good things” we mean finally being able to explore molecules in 3D with KNIME. Have a look at this workflow snippet demonstrating how to query the Protein Data Bank (PDB) and visualising the results in 3D using the 3D Molecule Viewer component. This was definitely worth the wait!
Don't have a ChemAxon license and miss the MarvinSketch node? Try this component to draw molecules, chemical structures and reactions. Depending on your choice, the output is available in two different chemical data formats. And as a cherry on top, you can even supply input SMILES by flow variable!
Have you ever heard of Streaming in KNIME? No, we did not integrate Netflix. Streaming in KNIME enables you to execute certain nodes in a section of your workflow concurrently, instead of node by node. This way, the results of one node are instantly provided as input to downstream nodes, which cuts down memory usage and speeds up your calculations.
Did you ever wonder how to retrieve data from a (public) web service like mygene.info or maybe ChEMBL? Just use the GET Request node of KNIME and enter the URL as demonstrated in this workflow snippet. The JSON Path node or XML Path node will help you to parse the retrieved data. And off you go with the latest data for your use case!
The Molecule Type Cast node can be sometimes overlooked, but it is important if you want to convert a string column into any molecule type, such as Mol2, PDB, SDF, CML, HELM, SLN, SMILES, SMARTS or RXN. This workflow snippet demonstrates the use of the Molecule Type Cast node to convert a string to the SMILES data format. In a second step, a RDKit node is used to canonicalize the SMILES.