This R package contains utilities for connecting to and fetching data from the Erlich Lab database.
To connect you need to have a file in your home directory called .dbconf with the following format
[client]
user = yourusername
passwd = yourpassword
host = thedatabase.nyu.edu
Of course, the contents should be changed to reflect the actual credentials and domain name of the database.
Once your .dbconf is setup, you should be able to do
library(devtools)
install_git("https://github.com/erlichlab/el.db.git")
library(el.db)
con = elConnect()
out = dbGetQuery(con, 'select * from met.animals limit 20')
head(out)