- 论坛徽章:
- 0
|
- <p>[devopr@localhost temp]$ cat file1
- chr1.11188078.C.A MTOR SJALL013791 O4 0.043 29 67510 A
- chr1.115256528.T.G NRAS SJALL013791 D1 0.073 34 46390 G
- chr1.115256530.G.T NRAS SJALL013791 O4 0.062 44 70979 T
- chr1.115256530.G.T NRAS SJALL013791 R1 0.04 36 89427 T
- chr1.115258744.C.T NRAS SJALL013791 D1 1.005 585 58203 T
- chr1.115258744.C.T NRAS SJALL013791 O2 0.029 19 66608 T
- chr1.115258744.C.T NRAS SJALL013791 R1 20.799 22079 106155 T
- chr1.14107249.C.T PRDM2 SJALL013791 R1 0.092 9 9801 T
- chr1.149878236.C.T SV2A SJALL013791 D1 0.38 168 44198 T
- chr1.149878236.C.T SV2A SJALL013791 O2 0.079 34 43289 T
- chr1.149878236.C.T SV2A SJALL013791 O4 0.065 42 64411 T
- chr1.149878236.C.T SV2A SJALL013791 R1 5.104 3294 64532 T
- [devopr@localhost temp]$ awk '{a=$1FS$2FS$3;b=$4FS$5FS$6FS$7;out[a]=out[a]""FS""b;grp[a]=a}END{l=asort(grp);for(i=1;i<=l;i++)print grp[i],out[grp[i]]}' file1
- chr1.11188078.C.A MTOR SJALL013791 O4 0.043 29 67510
- chr1.115256528.T.G NRAS SJALL013791 D1 0.073 34 46390
- chr1.115256530.G.T NRAS SJALL013791 O4 0.062 44 70979 R1 0.04 36 89427
- chr1.115258744.C.T NRAS SJALL013791 D1 1.005 585 58203 O2 0.029 19 66608 R1 20.799 22079 106155
- chr1.14107249.C.T PRDM2 SJALL013791 R1 0.092 9 9801
- chr1.149878236.C.T SV2A SJALL013791 D1 0.38 168 44198 O2 0.079 34 43289 O4 0.065 42 64411 R1 5.104 3294 64532
- [devopr@localhost temp]$
- </p>
复制代码
|
|