Hi list,
I am trying to use RMySQL to get genomic coordinates from a bunch of gene symbols and add 5kb to the TSS afterwards. I know I can do it using Tables from UCSC browser or BiomaRt but I would like to learn how to query using RMySQL or mysql,
I have followed this post but I cannot figure out how to do it with geneSymbols (HUGO names) because name in Knowngene table is different from kgXref table
Any help would it be appreciated
Thanks