I have a file that looks like:
chr1 1197592 . C A . . DP=67;ECNT=1;NLOD=8.12 GT:AD:AF:F1R2 0/1:37,2:0.063:13,0
chr1 1355707 . G T . . DP=69;ECNT=1;NLOD=4.51 GT:AD:AF:F1R2 0/1:50,3:0.059:20,3
chr1 1641723 . TC T . . DP=59;ECNT=1;NLOD=2.40 GT:AD:AF:F1R2 0/1:30,2:0.089:12,4
chr1 2550056 . TC CT . . DP=99;ECNT=1;NLOD=9.03 GT:AD:AF:F1R2 0/1:63,2:0.053:33,2
I would like to print the lines for which the 3rd value in the 10th column is greater than 0.06.
cat file.txt | cut -f 10 | cut -f 3 | awk -F':' '$3>0.06'
Will only give me:
0/1:37,2:0.063:13,0
0/1:30,2:0.089:12,4
And I would like the entire line. Can that be done with awk?