extract the ids and key values

0

Entering edit mode

3.4 years ago

mathavanbioinfo ▴ 80

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 • 963 views

ADD COMMENT • link updated 3.4 years ago by Juke34 8.9k • written 3.4 years ago by mathavanbioinfo ▴ 80

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 3.4 years ago by Ram 44k

0

Entering edit mode

(or any other programming language)

ADD REPLY • link 3.4 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 3.4 years ago by mathavanbioinfo ▴ 80

0

Entering edit mode

What did you try with AWK? show us your command

ADD REPLY • link 3.4 years ago by Juke34 8.9k

Login before adding your answer.