How to join and match two database lists, blastdb and list
0
0
Entering edit mode
9 months ago
BATMAN • 0

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 • 328 views
ADD COMMENT

Login before adding your answer.

Traffic: 2091 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6