Icon

KNIME_​challenge12_​solution

KNIME_challenge12_solution
Loop through all response Separate route to handle xml response 1)+-------+-----------+------------+----------------------------------------------+--------+-------+| _id | _score | entrezgene | name | symbol | taxid |+-------+-----------+------------+----------------------------------------------+--------+-------+| 8660 | 6.0454245 | 8660 | insulin receptor substrate 2 | IRS2 | 9606 || 3643 | 5.7771645 | 3643 | insulin receptor | INSR | 9606 || 3630 | 5.7751064 | 3630 | insulin | INS | 9606 || 3667 | 5.7661147 | 3667 | insulin receptor substrate 1 | IRS1 | 9606 || 10580 | 5.6208963 | 10580 | sorbin and SH3 domain containing 1 | SORBS1 | 9606 || 6517 | 5.508826 | 6517 | solute carrier family 2 member 4 | SLC2A4 | 9606 || 2888 | 5.4575095 | 2888 | growth factor receptor bound protein 14 | GRB14 | 9606 || 3486 | 5.4575095 | 3486 | insulin like growth factor binding protein 3 | IGFBP3 | 9606 || 3651 | 5.4575095 | 3651 | pancreatic and duodenal homeobox 1 | PDX1 | 9606 || 60676 | 5.42569 | 60676 | pappalysin 2 | PAPPA2 | 9606 |... Challenge 12: Obtaining a List of Human Genes via RESTLevel: MediumDescription: You have been working for a Life Sciences company for a month as a a data wrangler. Several coworkers from theBiology department would like to obtain a list of human genes related to specific hormones, but they do not know how to useREST services, GET requests, etc. Your task is to use the REST service provided by MyGene.info to obtain a list of human genesrelated to a list of hormones provided to you by your coworkers. Next, you should parse the JSON response into a table that iseasy to read. list of hormonesNode 7Node 8Node 9Node 10REST baseurlNode 14Node 21decide routetop: jsonbottom: xmlNode 31Node 32Node 37Node 39Node 40Node 41Node 42Node 43 CSV Reader CredentialsConfiguration HTTP(S) Connector GET Request JSON to Table Variable Creator Column Expressions XML To JSON VariableExpressions CASE Switch Start CASE Switch End Table Rowto Variable Group Loop Start Loop End JSON Path Ungroup Column Filter Loop through all response Separate route to handle xml response 1)+-------+-----------+------------+----------------------------------------------+--------+-------+| _id | _score | entrezgene | name | symbol | taxid |+-------+-----------+------------+----------------------------------------------+--------+-------+| 8660 | 6.0454245 | 8660 | insulin receptor substrate 2 | IRS2 | 9606 || 3643 | 5.7771645 | 3643 | insulin receptor | INSR | 9606 || 3630 | 5.7751064 | 3630 | insulin | INS | 9606 || 3667 | 5.7661147 | 3667 | insulin receptor substrate 1 | IRS1 | 9606 || 10580 | 5.6208963 | 10580 | sorbin and SH3 domain containing 1 | SORBS1 | 9606 || 6517 | 5.508826 | 6517 | solute carrier family 2 member 4 | SLC2A4 | 9606 || 2888 | 5.4575095 | 2888 | growth factor receptor bound protein 14 | GRB14 | 9606 || 3486 | 5.4575095 | 3486 | insulin like growth factor binding protein 3 | IGFBP3 | 9606 || 3651 | 5.4575095 | 3651 | pancreatic and duodenal homeobox 1 | PDX1 | 9606 || 60676 | 5.42569 | 60676 | pappalysin 2 | PAPPA2 | 9606 |... Challenge 12: Obtaining a List of Human Genes via RESTLevel: MediumDescription: You have been working for a Life Sciences company for a month as a a data wrangler. Several coworkers from theBiology department would like to obtain a list of human genes related to specific hormones, but they do not know how to useREST services, GET requests, etc. Your task is to use the REST service provided by MyGene.info to obtain a list of human genesrelated to a list of hormones provided to you by your coworkers. Next, you should parse the JSON response into a table that iseasy to read. list of hormonesNode 7Node 8Node 9Node 10REST baseurlNode 14Node 21decide routetop: jsonbottom: xmlNode 31Node 32Node 37Node 39Node 40Node 41Node 42Node 43CSV Reader CredentialsConfiguration HTTP(S) Connector GET Request JSON to Table Variable Creator Column Expressions XML To JSON VariableExpressions CASE Switch Start CASE Switch End Table Rowto Variable Group Loop Start Loop End JSON Path Ungroup Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: MMU
Created at: 2022-04-03
On NodePit since: 2022-04-20
Last update: 2024-04-26
Created with KNIME version: v4.5.2
Tags: justknimeit-12justknimeitREST

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!