Question: Joining multiple datasets from same experiment.
gravatar for smn5360
3.6 years ago by
Brunei Darussalam
smn536010 wrote:

Want to join datasets from replicates


MYC    5.4

ERBB2    8.7

ERGF    1.1


A little challenge will be to combine all these files into a single table kinda looking like this:

    Sample1    Sample2    ...

MYC    5.4    7.9

ERBB2    8.7    8.1

ERGF    1.1    0.7


How do I arrange 70 sample data in the above manner using galaxy.


alignment • 917 views
ADD COMMENTlink modified 3.6 years ago by Martin Čech ♦♦ 4.9k • written 3.6 years ago by smn536010


ADD REPLYlink modified 3.6 years ago • written 3.6 years ago by Guy Reeves1.0k
gravatar for Guy Reeves
3.6 years ago by
Guy Reeves1.0k
Guy Reeves1.0k wrote:


Somebody might have a better way but you could use the 'Paste two files side by side' tool.  However,  this tool only works with 2 files (there may be versions of this tool that might work with more, which might be worth looking for on the toolshed). But you could set a workflow up with pastes file 1 and 2  to make 'file 1,2' .  Then paste file 3 to 'file 1,2'    and so on.... .  This will end up with lots of duplicate copies of MYC, ERBB2, ERGF columns,   which could  all then be cut in a single final  step using the Cut columns from a table.  Obviously setting up a work flow with 70 steps will be a pain and there might be a more elegant way to do this. 

Thanks Guy

ADD COMMENTlink written 3.6 years ago by Guy Reeves1.0k
Please log in to add an answer.


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