Icon

05. Database - solution

Database

Solution to "Database" exercise for basic Life Science User Training
- Writing data into a database
- Reading data from a database
- Filtering data in a database
- Joining data in a database
- Reading data in a database into a KNIME table







Activity: Databases- Drag & drop the malariahts_DB.sqlite file into your workspace- Connect malariahts_DB.sqlite to the two DB Table Selector nodes to read the "malariahts_experiment" and "malariahts_molecules_feature" table, respectively- Filter the Column called "Pf3D7_pEC50" in the "malariahts_experiment" table with the Database Column Filter node- Join the two tables together with the DB Joiner node using "Sample" column- Read the data into KNIME using the DB Reader node.- Write the data into a csv file read malariahts_experimentreadmalariahts_molecules_featureFilter Pf3D7_pEC50 Columnjoin two tableson sampleRead data intoKNIMEmalariahts_DB.sqlite DB Table Selector DB Table Selector DB Column Filter DB Joiner DB Reader SQLite Connector CSV Writer Activity: Databases- Drag & drop the malariahts_DB.sqlite file into your workspace- Connect malariahts_DB.sqlite to the two DB Table Selector nodes to read the "malariahts_experiment" and "malariahts_molecules_feature" table, respectively- Filter the Column called "Pf3D7_pEC50" in the "malariahts_experiment" table with the Database Column Filter node- Join the two tables together with the DB Joiner node using "Sample" column- Read the data into KNIME using the DB Reader node.- Write the data into a csv file read malariahts_experimentreadmalariahts_molecules_featureFilter Pf3D7_pEC50 Columnjoin two tableson sampleRead data intoKNIMEmalariahts_DB.sqliteDB Table Selector DB Table Selector DB Column Filter DB Joiner DB Reader SQLite Connector CSV Writer

Nodes

Extensions

Links