ImportRefSeqtoKegg
Created: 2012-11-12 14:31:05
Last updated: 2013-01-08 09:25:20
This workflow extracts a column of RefSeq gene IDs from a CSV file and then converts them to Kegg gene identifiers
Preview
Run
Run this Workflow in the Taverna Workbench...
Workflow Components
Authors (1)
Titles (1)
Descriptions (1)
| This workflow extracts a column of RefSeq gene IDs from a CSV file and then converts them to Kegg gene identifiers |
Dependencies (0)
Inputs (1)
| Name |
Description |
| genes |
Accepts a CSV file with gene identifiers in one of the columns
|
Processors (9)
| Name |
Type |
Description |
| SpreadsheetImport |
spreadsheet |
|
| mmusculus_gene_ensembl |
biomart |
|
| Merge_gene_list |
localworker |
ScriptString seperatorString = "\n";
if (seperator != void) {
seperatorString = seperator;
}
StringBuffer sb = new StringBuffer();
for (Iterator i = stringlist.iterator(); i.hasNext();) {
String item = (String) i.next();
sb.append(item);
if (i.hasNext()) {
sb.append(seperatorString);
}
}
concatenated = sb.toString();
|
| add_unigene_to_string |
beanshell |
ScriptString[] split = input.split("\n");
Vector nonEmpty = new Vector();
for (int i = 0; i < split.length; i++)
{
String trimmed = split[i].trim();
nonEmpty.add(trimmed);
}
String output = "";
for (int i = 0; i < nonEmpty.size(); i++)
{
output = output + "unigene:" + (String) (nonEmpty.elementAt(i) + "\n");
} |
| bconv |
wsdl |
Wsdlhttp://soap.genome.jp/KEGG.wsdlWsdl Operationbconv |
| Split_gene_list |
localworker |
ScriptList split = new ArrayList();
if (!string.equals("")) {
String regexString = ",";
if (regex != void) {
regexString = regex;
}
String[] result = string.split(regexString);
for (int i = 0; i < result.length; i++) {
split.add(result[i]);
}
}
|
| regex_value |
stringconstant |
Value\n |
| extract_gene_ids |
beanshell |
ScriptString[] split = input.split("\n");
Vector nonEmpty = new Vector();
for (int i = 0; i < split.length; i++)
{
String trimmed = split[i].trim();
String[] trimmedSplit = trimmed.split("\t");
if (trimmedSplit.length > 2)
{
nonEmpty.add(trimmedSplit[1].trim());
}
}
String output = "";
for (int i = 0; i < nonEmpty.size(); i++)
{
output = output + (String) (nonEmpty.elementAt(i) + "\n");
} |
| split_by_regex |
localworker |
ScriptList split = new ArrayList();
if (!string.equals("")) {
String regexString = ",";
if (regex != void) {
regexString = regex;
}
String[] result = string.split(regexString);
for (int i = 0; i < result.length; i++) {
split.add(result[i]);
}
}
|
Beanshells (2)
| Name |
Description |
Inputs |
Outputs |
| add_unigene_to_string |
|
input
|
output
|
| extract_gene_ids |
|
input
|
output
|
Outputs (2)
| Name |
Description |
| Gene_List |
|
| KeggGeneIDs |
|
Datalinks (12)
| Source |
Sink |
| genes |
SpreadsheetImport:fileurl |
| SpreadsheetImport:D |
mmusculus_gene_ensembl:mmusculus_gene_ensembl.refseq_mrna_filter |
| mmusculus_gene_ensembl:mmusculus_gene_ensembl |
Merge_gene_list:stringlist |
| Merge_gene_list:concatenated |
add_unigene_to_string:input |
| Split_gene_list:split |
bconv:string |
| add_unigene_to_string:output |
Split_gene_list:string |
| regex_value:value |
Split_gene_list:regex |
| bconv:return |
extract_gene_ids:input |
| extract_gene_ids:output |
split_by_regex:string |
| regex_value:value |
split_by_regex:regex |
| Merge_gene_list:concatenated |
Gene_List |
| split_by_regex:split |
KeggGeneIDs |
Uploader
License
All versions of this Workflow are
licensed under:
Version 1 (earliest)
(of 3)
Credits (1)
(People/Groups)
Attributions (0)
(Workflows/Files)
None
Shared with Groups (0)
None
Featured In Packs (0)
None
Log in to add to one of your Packs
Attributed By (0)
(Workflows/Files)
None
Favourited By (0)
No one
Statistics
Other workflows that use similar services
(0)
There are no workflows in myExperiment that use similar services to this Workflow.
Download Workflow
]
Reviews
(0)
Log in to make a comment
Hi Katy, Can you add an example csv file pleae? I tried several inputs but all returned empty results for me. Thanks! -- Jun