TxDb database for UCSC refGene table, so that you can run database queries like:
library(TxDb.Dmelanogaster.UCSC.dm6.refGene)
tx <- transcripts(TxDb.Dmelanogaster.UCSC.dm6.refGene,
columns = c("TXID", "TXNAME", "GENEID"))
install.packages("devtools")
host="https://github.uconn.edu/api/v3"
devtools::install_github("CoreLab/TxDb.Dmelanogaster.UCSC.dm6.refGene", host = host)