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.
• 764 views
•
link
0 answers
No answers yet.
Log in to answer this question.
Hello bweil2!
Questions similar to yours can already be found at:
We have closed your question to allow us to keep similar content in the same thread.
If you disagree with this please tell us why in a reply below. We'll be happy to talk about it.
Cheers!