extract the ids and key values

0

Entering edit mode

2.8 years ago

mathavanbioinfo ▴ 90

Hi

I have a large file like this

File input

TRINITY_DN728479_c0_g1_i1   GO:0003674
TRINITY_DN728479_c0_g1_i1   GO:0003824
TRINITY_DN728479_c0_g1_i1   GO:0003887
TRINITY_DN728480_c0_g1_i1   GO:0003891
TRINITY_DN728480_c0_g1_i1   GO:0003892

I want the output

TRINITY_DN728479_c0_g1_i1        GO:0003674, GO:0003824, GO:0003887
TRINITY_DN728480_c0_g1_i1        GO:0003891,GO:0003892

please help how to change it

extract grep • 807 views

ADD COMMENT • link updated 2.8 years ago by Juke34 8.5k • written 2.8 years ago by mathavanbioinfo ▴ 90

0

Entering edit mode

What have you tried? This problem has been addressed on the forum before, and is straightforward to do using R or awk.

ADD REPLY • link 2.8 years ago by Ram 43k

0

Entering edit mode

(or any other programming language)

ADD REPLY • link 2.8 years ago by WouterDeCoster 47k

0

Entering edit mode

I have tried awk and csvtk but I am unable to get it

ADD REPLY • link 2.8 years ago by mathavanbioinfo ▴ 90

0

Entering edit mode

What did you try with AWK? show us your command

ADD REPLY • link 2.8 years ago by Juke34 8.5k

Login before adding your answer.