Guest User

Untitled

a guest
May 23rd, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. c.001A>C 11 p.His103 A
  2. c.000A>C 12 p.Thr102 E
  3. c.111A>C 12 p.Thr102 D
  4.  
  5. APC 5 112835056 ENST00000507379 13 c.001A>C p.Val599Phe
  6. APC 5 112819143 ENST00000257430 9 c.1111G p.G371X
  7. APC 5 1128395514 ENST00000257430 15 c.001A>C p.Glu1309AspfsT
  8. APC 5 112838773 ENST00000257430 15 c.000A>C p.Gln1062Ter
  9.  
  10. APC 5 112835056 ENST00000507379 13 c.001A>C p.Val59 c.001A>C 11 p.His103 A
  11. APC 5 1128395514 ENST00000257430 15 c.001A>C p.Glu1 c.001A>C 11 p.His103 A
  12. APC 5 112838773 ENST00000257430 15 c.000A>C p.Gln10 c.000A>C 12 p.Thr102 E
  13.  
  14.  
  15. awk -F't' -v OFS="t" 'FNR==NR{a[$1]=$1FS$2FS$3FS$4; next} {if ($6 in a) print $0, a[$1]}' file1 file2
  16.  
  17. $ join -1 1 -2 6 -o "2.1 2.2 2.3 2.4 2.5 2.6 2.7 1.3 1.4" <(sort file1) <(sed 's/ +/ /g' file2 | sort -k6) | column -t
  18. APC 5 112838773 ENST00000257430 15 c.000A>C p.Gln1062Ter p.Thr102 E
  19. APC 5 1128395514 ENST00000257430 15 c.001A>C p.Glu1309AspfsT p.His103 A
  20. APC 5 112835056 ENST00000507379 13 c.001A>C p.Val599Phe p.His103 A
Add Comment
Please, Sign In to add comment