I have a excel sheet and gff file and all I want to do is for each gene in the excel file match the same gene in gff file and any matches for each gene id in the first column and adding (Name=name) from the second column from excel file. I need a script to do it.
Excel sheet contains: two columns Gene ID and Name
scf0000 merged gene 218802 221564 . - . ID=gene id
The output that I want is:
scf0000 merged gene 218802 221564 . - . Name=gene_name; ID=gene id
Thanks in advance