title: Select lines based on value in a column
body: <p>I have a tab delimited table for which I want to print all lines where column 'x' is greater than 'Y'. I have attempted using the code below but am new to using awk so am unsure how to use it based on columns.</p>
  
  <pre><code>awk '$X &gt;= Y {print} ' Table.txt | cat &gt; Wanted_lines 
  </code></pre>
  
  <p>Y are values from 1 to 100.</p>
  
  <p>If the input were like below with column X were the second column.</p>
  
  <pre><code>1    30
  2    50
  3    100
  4    100
  5    80
  6    79
  7    90
  </code></pre>
  
  <p>The wanted output would be:</p>
  
  <pre><code>3    100
  4    100
  5    80
  7    90
  </code></pre>
  
  <p>The first 2 lines of the file is:</p>
  
  <pre><code>1   OTU1    243622  208679  121420  265864  0   0   2   0   0   11  1   5   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   839604  OTU1    -   Archaea 100%    Euryarchaeota   100%    Methanobacteria 100%    Methanobacteriales  100%    Methanobacteriaceae 100%    Methanobrevibacter  100%
  2   OTU2    84366   120817  15834   74737   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   295755  OTU2    -   Archaea 100%    Euryarchaeota   100%    Methanobacteria 100%    Methanobacteriales  100%    Methanobacteriaceae 100%    Methanobrevibacter  100%
  </code></pre>