gravatar for star

2 hours ago by

Netherlands

I have a table like below that I would like to add another column in the data but based on the same regions in 3 first columns.

Input:

chr1    956563  956812    chr1    956563  956573
chr1    956563  956812    chr1    956573  956583
chr1    106563  106912    chr1    106583  106593
chr1    106563  106912    chr1    106653  106663
chr1    106563  106912    chr1    106663  106673
chr1    113563  113789    chr1    113763  113773
chr1    113563  113789    chr1    113573  113783
chr1    213563  213781    chr1    213663  213673

Output:

chr1    956563  956812    chr1    956563  956573     1
chr1    956563  956812    chr1    956573  956583     2
chr1    106563  106912    chr1    106583  106593     1
chr1    106563  106912    chr1    106653  106663     2
chr1    106563  106912    chr1    106663  106673     3
chr1    113563  113789    chr1    113763  113773     1
chr1    113563  113789    chr1    113573  113783     2
chr1    213563  213781    chr1    213663  213673     1

Thanks for any help in advance!

link

modified 1 hour ago

by

rpolicastro2.9k

written
2 hours ago
by

star270



Source link