I have a question regarding SNPs to genes mapping using BiomaRt.
I have successfully mapped my chr/start/end SNP positions to ENSIDs and gene symbols. I have done this several times but my question is; Can I keep my original SNP positions in the resulting file which has the chr-start-end gene positions and names? I struggle everytime I need to go back to the original SNP positions to link them to the genes I extracted from BiomaRt. As a picture is worth a 1000 words, please see below:
my file (examples of SNP positions):
chr start end 1 194972207 194972207 6 41187262 41187262 7 43120222 43120222 7 43120878 43120878
BiomaRt's gene results (examples of gene results):
chromosome_name start_position end_position ensembl_gene_id hgnc_symbol 1 119853316 119853748 ENSG00000227205 PFN1P9 1 119886304 119886927 ENSG00000226446 NOTCH2P1 1 119893533 119896515 ENSG00000134249 ADAM30
Therefore, I do have the gene list I requested based on my file's positions, but I do not have those positions in the resulting file. That would be really useful to have.
Any help would be greatly appreciated.
Thank you in advance