Find content
Male
Thanks,
Using Galaxy (https://main.g2.bx.psu.edu/) tools I can convert the columns of interest using Convert delimiters to TAB, to remove white spaces and then using Join, Subtract, Group -Compare two Datasets tool to find common or distinct rows to display only non-matching alignments. Which is an okay method.
The method I went with is excel LOOKUP formula
For example
Copying the query id column from blastx with %identity>85 into the blastn results column AA, you can create a new column , B and use =lookup(A2,$AA$1:$AA$50,000). Then copy the formula into all B rows adjacent to an A row , until the last A row. Hope that made sense. Once the formula finishes you copy A and B and paste as values into AB to enable further data sorting.
This formula yielded better results than the galaxy compare tool because it is still in excel, no need to use .txt delimited.
