dnSNP data with gene name

Question

[chuanbao123]

Dear all,

I want to have five fields from dbsnp data:

chr  start  end  ref_allele  alt_allele  strand  gene_name

I know dbsnp.vcf file looks like this:

chrM    64      rs3883917       C       T       .       .       ASP;CAF=[0.9373,0.06268];COMMON=1;OTHERKG;R5;RS=3883917;RSPOS=64;SAO=0;SSR=0;VC=SNV;VP=0x050000020005000002000100;WGT=1;dbSNPBuildID=108

and I can get "chr","start","end","ref_allele","alt_allele" from the file. But where Can I have the strand and gene_name (like TP53, etc.) of all the SNP sites?

Thank you in advance!

Chuanbao