How do you add gene annotations from a Diamond Blastx tsv file to a csv file with RNAseq differential expression data?
I have a Diamond BLASTx tsv file that has the Gene_Descriptions:
I have a csv file of the RNAseq expression data:
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!!
• 83 views