0 ×

Expand Well Position

DeprecatedHCS-Tools for KNIME version 4.0.0.v201906200802 by Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

This node takes a string column containing well positions (like B3 or C14) and appends two integer columns named 'plateRow' and 'plateColumn' containing two integer coordinates of the wells (link 2 and 3 or 3 and 14). It handles well positions up to 1536 plate format.

Additional splitting characters (comma, colons, semicolons, underscore) between the row letter and the column number will be ignored.

Options

Well Position: The column which contains well positions encoded as B3 oc C14
Convert Row Characters: If enabled, the row character (e.g. B or C) will be converted automatically into a row number (e.g. 2 or 3)
Delete Source Column: If enabled, the selected column will be removed.

Input Ports

: Input table with well column

Output Ports

: Input table with expanded well position.

Best Friends (Incoming)

Create Well Position (6 %)
Column Filter (6 %) Streamable
Joiner (6 %)
Rule Engine (6 %) Streamable
Expand Barcode (4 %)
File Reader (4 %) Streamable
Loop End (4 %)
~~String To Number~~ (4 %) StreamableDeprecated
Row Filter (4 %) Streamable
GroupBy (4 %)
Plate Heatmap Viewer (3 %)
CSV Reader (3 %)
Concatenate (3 %) Streamable
Column Rename (3 %) Streamable
String Manipulation (3 %) Streamable
~~XLS Reader~~ (3 %) Deprecated
~~Excel Reader (XLS)~~ (3 %) StreamableDeprecated
~~Expand Well Position~~ (1 %) Deprecated
Normalize Plates (POC) (1 %)
Normalize Plates (Z-Score) (1 %)
URL to File Path (1 %) Streamable
Table Creator (1 %)
Java Snippet (1 %) Streamable
Generic Loop Start (1 %)
Cell Replacer (1 %) Streamable
Column Combiner (1 %) Streamable
Constant Value Column (1 %) Streamable
Cross Joiner (1 %) Streamable
Missing Value Column Filter (1 %)
Nominal Value Row Filter (1 %) Streamable
Row Splitter (1 %) Streamable
Reference Row Filter (1 %)
Pivoting (1 %)
Missing Value (1 %)
Regex Split (1 %) Streamable
Sorter (1 %)
Column Splitter (1 %) Streamable
String Replacer (1 %) Streamable
Math Formula (1 %) Streamable
~~Excel Reader (XLS)~~ (1 %) StreamableDeprecated
Show all 40 recommendations

Best Friends (Outgoing)

Join Layout (14 %)
Plate Heatmap Viewer (13 %)
Joiner (9 %)
~~String To Number~~ (5 %) StreamableDeprecated
Column Rename (5 %) Streamable
Column Filter (4 %) Streamable
GroupBy (4 %)
Create Well Position (3 %)
String Manipulation (3 %) Streamable
Constant Value Column (2 %) Streamable
Row Splitter (2 %) Streamable
Row Filter (2 %) Streamable
Sorter (2 %)
Math Formula (2 %) Streamable
~~Expand Well Position~~ (1 %) Deprecated
Number Formatter (1 %)
Normalize Plates (B-Score) (1 %)
Normalize Plates (Z-Score) (1 %)
CV (1 %) Deprecated
CSV Writer (1 %) Streamable
Table Writer (1 %)
Group Loop Start (1 %)
Concatenate (1 %) Streamable
Auto-Binner (1 %)
Cell Replacer (1 %) Streamable
~~Number To String~~ (1 %) Deprecated
Column Resorter (1 %) Streamable
Reference Row Filter (1 %)
Pivoting (1 %)
Rule Engine (1 %) Streamable
Rule-based Row Splitter (1 %) Streamable
Statistics (1 %)
Interactive Table (local) (1 %)
WrappedNode Output (1 %)
~~Excel Writer (XLS)~~ (1 %) Deprecated
Java Snippet (simple) (1 %)
Line Plot (1 %)
Image Features (1 %)
R Snippet (1 %)
RDKit Molecule Substructure Filter (1 %)
Show all 40 recommendations

Workflows

02_Metadata_utilities_for_screening_data (KNIME Hub)
HTS_workflow (KNIME Hub)

Installation

To use this node in KNIME, install KNIME HCS Tools from the following update site:

KNIME 4.1

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.