I have a table that has 5 columns and multiple rows
The last column has the sum of all values for each row
A B C D E gene1 1 3 5 9 gene2 0 0 4 4 gene3 1 0 1 2 gene4 5 5 0 10 gene5 2 0 0 2
What I would like to do is to extract gene2 and gene5 rows into a separate file and also to have another file that would contain the other genes (but without the extracted ones), gene1,gene3 and gene4
I am thinking of using the
awk command but I cannot understand how can I link rows and numbers?