Question: Change Tracking Id to Gene name
0
gravatar for VY
4 months ago by
VY120
United States
VY120 wrote:

Hello,

I'm not sure if this is something that can be done in galaxy, but if anyone knows how to do it in R that would help aswell.

I've run cuffdiff on my samples and I've selected the output count file function.

When I look at my cuffdiff gene count tracking file, all the rows are under the tracking id (XLOC_00001 etc). Looking at my gene differential expression file though, I can see both the tracking id and the gene name (BRCA1 etc) as I had used a reflat gtf.

I'd like to use the normalised counts file for some other stuff but having the tracking id displayed is not helpful, and changing it manually into the gene names would be too time consuming and daunting. Does anyone know how I can match the tracking id in the one file to the gene name in the other? Either or galaxy or in R?

Any suggestions would be really helpful.

Thanks V

rna-seq rnaseq cuffdiff • 158 views
ADD COMMENTlink modified 4 months ago by Jennifer Hillman Jackson22k • written 4 months ago by VY120
0
gravatar for Jennifer Hillman Jackson
4 months ago by
United States
Jennifer Hillman Jackson22k wrote:

Hello,

Datasets can be joined on a common identifier and the merged dataset columns cut (reduced/reordered) to produce the desired final result dataset.

  • To join any two datasets based on common tracking ids, use the tool Join, Subtract and Group > Join two Datasets side by side on a specified field
  • To cut out columns from a dataset and output in any order, use the tool Text Manipulation > Cut columns from a table
  • After using the tool Cut, click on the pencil icon to reset the datatype (first, and save) and column assignments (second, and save), if the cut action produces something other than a generalized tabular file and you want something more specific. Example: Cut was used to produce bed, interval, etc. that meets one of those datatype's specifications, and that datatype format is required by downstream tools.

The Galaxy 101 goes through a simple walk-through of data manipulation tools that are similar and might be useful to learn more about how to use text manipulation and related tools. If a tool you want to use is not in the tutorial, usage can be found on the tool form (many are similar to line-command utilities - there is no need to do this manually or by hand): http://usegalaxy.org/galaxy101

Hopefully this helps! Jen, Galaxy team

ADD COMMENTlink written 4 months ago by Jennifer Hillman Jackson22k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 72 users visited in the last hour