This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to match genes of one file to another but in multiple columns?

I want to see which genes in archloro.txt match both lines of ArabidopsisParalogue.txt. I tried grep -f but that would just find the genes in both files have in common and not 2 genes that are in the same line. Any ideas on how to do this?

head archloro.txt

AT1G01080|AT1G01080.  286   0.975  0.048  0.003  0.037   C    1
AT1G01080|AT1G01080.  293   0.975  0.048  0.003  0.037   C    1
AT1G01080|AT1G01080.  294   0.975  0.048  0.003  0.037   C    1
AT1G01090|AT1G01090.  428   0.962  0.121  0.003  0.038   C    1
AT1G01250|AT1G01250.  192   0.736  0.079  0.031  0.246   C    3
AT1G01520|AT1G01520.  258   0.559  0.128  0.222  0.120   C    4
AT1G01520|AT1G01520.  287   0.559  0.128  0.222  0.120   C    4
AT1G01550|AT1G01550.  349   0.805  0.215  0.015  0.092   C    3
AT1G01690|AT1G01690.  450   0.685  0.105  0.005  0.160   C    3
AT1G01690|AT1G01690.  450   0.766  0.100  0.004  0.136   C    2

I could not post ArabidopsisParalogue.txt due to formating but there are two columns of genes listed.

sequence genome

0 answers

No answers yet.

Log in to answer this question.