I am currently trying to fill in annotations from a BLASTP of the same database into rows that are 0 in the BLASTX. The columns look like this:
BLASTX BLASTP annot1 annot1 annot 2 0 0 annot3
In this example I want "annot3" to be moved under the BLASTX column, so that the column contains origional BLASTX annotations and where empty gets filled by the BLASTP annotation like so:
BLASTX BLASTP annot1 annot1 annot 2 0 annot3 annot3
The ultimate reason for this is so that I can make a list of identifiers for downstream purposes.
I have been trying to do this manually LibreOffice, but with 160,000 sequences I realized the only practical way would be to use awk or python scripting.