How do you add gene annotations from a Diamond Blastx tsv file to a csv file with RNAseq differential expression data?

3

I have a Diamond BLASTx tsv file that has the Gene_Descriptions:
Diamond BLASTx gene annotations

I have a csv file of the RNAseq expression data:
enter image description here

I want to match the gene names (column E) and descriptions from the tsv file using the corresponding IDs from column B in the tsv file to the IDs (column A) in the csv file and insert them into column H of the csv file so that I have everything in one file and I don't have to cross reference. Can anybody point me to some command line scripts that can do this? Thanks in advance!!


diamond


annotations


expression


BLASTx


rnaseq

• 83 views



Source link