Question: Column Join Feature
1
gravatar for Justin Clarke
4.7 years ago by
Justin Clarke20 wrote:
Hi, I am analysing some RNA-seq data and have two different datasets, total RNA plus enzyme and total RNA minus enzyme. I used to type in "column join" in the "Tools" menu on the Galaxy homepage after uploaded the files in Text delimited format. Column join allowed me to join two datasets by a hinge column, in this case I would choose column 1 which would be the chromosome position. I would also be allowed to fill empty columns with a value of 1. The output would give me 3 columns, chromosome number (which both datasets shared), reads for minus enzyme, and reads for plus enzyme. The function would never reject any chromosome position with reads in one dataset and not the other. However, I cannot seem to be able to find this function anymore, and the new function "Join two datasets" seems to only give me back rows where both plus and minus datasets have reads. Does anyone else have this problem or know how I could get around it? Regards, Justin Justin Clarke McDowall Laboratory Garstang 8.52/8.51 Faculty of biological sciences University of Leeds Leeds LS2 9JT
galaxy • 935 views
ADD COMMENTlink modified 4.7 years ago by Jennifer Hillman Jackson25k • written 4.7 years ago by Justin Clarke20
0
gravatar for Jennifer Hillman Jackson
4.7 years ago by
United States
Jennifer Hillman Jackson25k wrote:
Hello Justin, Unfortunately, this tool is no longer supported. As an alternative, you can create a workflow to obtain the same results. It will include a few different tools, but the intermediate datasets can be hidden and just the results shown. The tools in the group "Join, Subtract and Group" that remain have options to output non-matching rows, fill in empty fields, etc. The general idea is to run two queries - one that captures all the data from the first file (matching and non-matching) and then the data from the second file (non-matching, by switching the file order in the tool), and in the end put the results together. The tool "Text Manipulation -> Concatenate datasets" can merge files and "Filter and Sort -> Sort" can reorganize the rows. Once you work out the steps, use the history menu option "Extract Workflow" to create the workflow from that start. Edit as needed, then save and use. Hopefully this will work out for you, Jen Galaxy team -- Jennifer Hillman-Jackson http://galaxyproject.org
ADD COMMENTlink written 4.7 years ago by Jennifer Hillman Jackson25k
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: 169 users visited in the last hour