This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to join and match two database lists, blastdb and list

Hello, how is it going?

I was wondering if you can help me with the following. I ran a blast of my own sequences against a custom database, and I would like to match the two lists according to the access code to be able to display the results in the first column of List1 in the blast result (list 2).

List 1: separated by tabulation

GH5_42  Bacteria    Aquimarina sp. TRL1 QKX03962.1
GH5 Viruses Aquipluma nitroreducens MeG22   BBE16908.1
GH5_13  Euka    Aquipluma neros Miu BBE17787.1
GH5_1   Bacteria    Aquimarina sp. BL5  AXT53262.1
GH5_1   Bacteria    Aquimarina sp. BL5  AXT51693.1
GH5_2   Bacteria    Aquimarina sp. BL5  AXT51262.1
GH5_2   Bacteria    Aquimarina sp. BL5  AXT50092.1
GH5_2   Bacteria    Aquimarina sp. BL5  AXT51607.1
GH5_7   Bacteria    Aquimarina sp. BL5  AXT53265.1
GH5_42  Bacteria    Aquimarina sp. BL5  AXT52587.1

List 2: separated by space

QKX03962.1 Endoglucanase A precursor [Aquimarina sp. TRL1]       261     4e-81
BBE16908.1 Endoglucanase 5 precursor [Aquipluma nitroreducens MeG22]       260     1e-80
BBE17787.1 glycoside hydrolase family 5 [Aquipluma neros Miu]  256     1e-80

I hope to have this output:

GH5_42  Bacteria    QKX03962.1 Endoglucanase A precursor [Aquimarina sp. TRL1]       261     4e-81
GH5 Viruses BBE16908.1 Endoglucanase 5 precursor [Aquipluma nitroreducens MeG22]       260     1e-80
GH5_13  Euka    BBE17787.1 glycoside hydrolase family 5 [Aquipluma neros Miu]  256     1e-80
linux join

0 answers

No answers yet.

Log in to answer this question.