Hi Davide,
The tool "Text Manipulation -> Add column to an existing dataset" could
be used to add in the column. This would add in the data to the end of
the existing file. To rearrange, use the "Cut columns from a table" tool.
You could also create a single column file, with the repeated file name
in each row, with the same number of rows as each of the 23 files and
upload that. Then join this file with the 23 chrom files with "Paste two
files side by side".
There are probably other ways, but I think this
This would all be manual. The re-run button (blue arrow) could be used
to set up the tool form for each run, which would cut down a bit on the
tediousness of running this on 23 files.
If a better way comes up, we'll send an update,
Thanks!
Jen
Galaxy team
On 3/7/12 7:15 AM, Cittaro Davide wrote:
Hi all,
I have a question about a weird usage of galaxy: suppose I have 23 files, each
for a chromosome, suppose the dataset name (in history) contains the chromosome
name but the dataset content don't (i.e. I only have chrom position and 2
associated values), is there a way to add a column so that the content of the
column contains the dataset name? In a automatic way, I mean...
i.e.
data-chr1
1000000 3.1 23
1000100 1.2 23
[…]
data-chr2
1234411 33.1 24
4225211 12.0 44
[…]
I would like them to be
data-chr1 1000000 3.1 23
data-chr1 1000100 1.2 23
[…]
data-chr2 1234411 33.1 24
data-chr2 4225211 12.0 44
[…]
So that I can merge them and strip 'data-'...
Oh, I know I can do it outside galaxy and upload the final file, but I would
like to know if (and how) this is possible,
d
/*
Davide Cittaro, PhD
Head of Bioinformatics Core
Center for Translational Genomics and Bioinformatics
San Raffaele Scientific Institute
Via Olgettina 58
20132 Milano
Italy
Office: +39 02 26439140
Mail: cittaro.dav...@hsr.it
Skype: daweonline
*/
___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org. Please keep all replies on the list by
using "reply all" in your mail client. For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:
http://lists.bx.psu.edu/listinfo/galaxy-dev
To manage your subscriptions to this and other Galaxy lists,
please use the interface at:
http://lists.bx.psu.edu/
___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org. Please keep all replies on the list by
using "reply all" in your mail client. For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:
http://lists.bx.psu.edu/listinfo/galaxy-dev
To manage your subscriptions to this and other Galaxy lists,
please use the interface at:
http://lists.bx.psu.edu/