My recent course on "Data Carpentry" in Cambridge did briefly cover the topic of integration of R with databases, for example SQL databases. The problem was that this was covered towards the end, very briefly, and I am none the wiser. I think the whole tutorial took 5 minutes.
My objective is to annotate a table of gene expression data "say for organism A" with information on orthologues from "organism B", as an additional column on a table. I watched tutorials online (YouTube) on how do do this using the BioMart GUI. Many clicks involved...
Is there a way to achieve the same think from R by pulling data from BioMart?
Thanks in advance for your help.