About This Document »

Package name annotation
Built with Bioconductor (R) 3.6 (3.4.2)
Last Built Mon, 30 Oct 2017 12:47:04 -0700
Last Modified Mon, 30 Oct 2017 12:20:57 -0700 (r132185)
Source Package ../annotation_1.0.4.tar.gz
Windows Binary ../annotation_1.0.4.zip
R Script Annotation_Resources.R

To install this workflow under Bioconductor 3.6, start R and enter:

source("http://bioconductor.org/workflows.R")
workflowInstall("annotation")

Genomic Annotation Resources

Marc RJ Carlson, Herve Pages, Sonali Arora, Valerie Obenchain, and Martin Morgan

Contents

Introduction

Annotation resources make up a significant proportion of the Bioconductor project[1]. And there are also a diverse set of online resources available which are accessed using specific packages. This walkthrough will describe the most popular of these resources and give some high level examples on how to use them.

Bioconductor annotation resources have traditionally been used near the end of an analysis. After the bulk of the data analysis, annotations would be used interpretatively to learn about the most significant results. But increasingly, they are also used as a starting point or even as an intermediate step to help guide a study that is still in progress. In addition to this, what it means for something to be an annotation is also becoming less clear than it once was. It used to be clear that annotations were only those things that had been established after multiple different studies had been performed (such as the primary role of a gene product). But today many large data sets are treated by communities in much the same way that classic annotations once were: as a reference for additional comparisons.

Another change that is underway with annotations in Bioconductor is in the way that they are obtained. In the past annotations existed almost exclusively as separate annotation packages[2,3,4]. Today packages are still an enormous source of annotations. The current release repository contains over eight hundred annotation packages. This table summarizes some of the more important classes of annotation objects that are often accessed using packages:

Object Type Example Package Name Contents
TxDb
TxDb.Hsapiens.UCSC.hg19.knownGene
Transcriptome ranges for the known gene track of Homo sapiens, e.g., introns, exons, UTR regions.
OrgDb
org.Hs.eg.db
Gene-based information for Homo sapiens; useful for mapping between gene IDs, Names, Symbols, GO and KEGG identifiers, etc.
BSgenome
BSgenome.Hsapiens.UCSC.hg19
Full genome sequence for Homo sapiens.
Organism.dplyr
src_organism
Collection of multiple annotations for a common organism and genome build.
AnnotationHub
AnnotationHub
Provides a convenient interface to annotations from many different sources; objects are returned as fully parsed Bioconductor data objects or as the name of a file on disk.

But in spite of the popularity of annotation packages, annotations are increasingly also being pulled down from web services like biomaRt[5,6,7] or from the AnnotationHub[8]. And both of these represent enormous resources for annotation data.

In part because of the rapidly evolving landscape, it is currently impossible in a single document to cover every possible annotation or even every kind of annotation present in Bioconductor. So here we will instead go over the most popular annotation resources and describe them in a way intended to expose common patterns used for accessing them. The hope is that a user with this information will be able to make educated guesses about how to find and use additional resources that will inevitably be added later. Topics that will be covered will include the following:

Set Up

In this chapter we make use of several Bioconductor packages. You can install them with biocLite():

## try http:// if https:// URLs are not supported
source("https://bioconductor.org/biocLite.R")
biocLite(c("AnnotationHub", "Homo.sapiens",
           "Organism.dplyr",
           "TxDb.Hsapiens.UCSC.hg19.knownGene",
           "TxDb.Hsapiens.UCSC.hg38.knownGene",
           "BSgenome.Hsapiens.UCSC.hg19", "biomaRt",
           "TxDb.Athaliana.BioMart.plantsmart22"))

The usage of the installed packages will be described in detail within the Usage section.

Using AnnotationHub

The top of the list for learning about annotation resources is the relatively new AnnotationHub package[8]. The AnnotationHub was created to provide a convenient access point for end users to find a large range of different annotation objects for use with Bioconductor. Resources found in the AnnotationHub are easy to discover and are presented to the user as familiar Bioconductor data objects. Because it is a recent addition, the AnnotationHub allows access to a broad range of annotation like objects, some of which may not have been considered annotations even a few years ago. To get started with the AnnotationHub users only need to load the package and then create a local AnnotationHub object like this:

## Loading required package: VariantAnnotation

## Loading required package: BiocGenerics

## Loading required package: parallel

## 
## Attaching package: 'BiocGenerics'

## The following objects are masked from 'package:parallel':
## 
##     clusterApply, clusterApplyLB, clusterCall, clusterEvalQ,
##     clusterExport, clusterMap, parApply, parCapply, parLapply,
##     parLapplyLB, parRapply, parSapply, parSapplyLB

## The following objects are masked from 'package:stats':
## 
##     IQR, mad, sd, var, xtabs

## The following objects are masked from 'package:base':
## 
##     anyDuplicated, append, as.data.frame, cbind, colMeans, colnames,
##     colSums, do.call, duplicated, eval, evalq, Filter, Find, get, grep,
##     grepl, intersect, is.unsorted, lapply, lengths, Map, mapply, match,
##     mget, order, paste, pmax, pmax.int, pmin, pmin.int, Position, rank,
##     rbind, Reduce, rowMeans, rownames, rowSums, sapply, setdiff, sort,
##     table, tapply, union, unique, unsplit, which, which.max, which.min

## Loading required package: GenomeInfoDb

## Loading required package: S4Vectors

## Loading required package: stats4

## 
## Attaching package: 'S4Vectors'

## The following object is masked from 'package:base':
## 
##     expand.grid

## Loading required package: IRanges

## Loading required package: GenomicRanges

## Loading required package: SummarizedExperiment

## Loading required package: Biobase

## Welcome to Bioconductor
## 
##     Vignettes contain introductory material; view with
##     'browseVignettes()'. To cite Bioconductor, see
##     'citation("Biobase")', and for packages 'citation("pkgname")'.

## Loading required package: DelayedArray

## Loading required package: matrixStats

## 
## Attaching package: 'matrixStats'

## The following objects are masked from 'package:Biobase':
## 
##     anyMissing, rowMedians

## 
## Attaching package: 'DelayedArray'

## The following objects are masked from 'package:matrixStats':
## 
##     colMaxs, colMins, colRanges, rowMaxs, rowMins, rowRanges

## The following object is masked from 'package:base':
## 
##     apply

## Loading required package: Rsamtools

## Loading required package: Biostrings

## Loading required package: XVector

## 
## Attaching package: 'Biostrings'

## The following object is masked from 'package:DelayedArray':
## 
##     type

## The following object is masked from 'package:base':
## 
##     strsplit

## 
## Attaching package: 'VariantAnnotation'

## The following object is masked from 'package:base':
## 
##     tabulate

## Loading required package: AnnotationHub

## 
## Attaching package: 'AnnotationHub'

## The following object is masked from 'package:Biobase':
## 
##     cache

## Loading required package: Organism.dplyr

## Loading required package: dplyr

## 
## Attaching package: 'dplyr'

## The following object is masked from 'package:VariantAnnotation':
## 
##     select

## The following objects are masked from 'package:Biostrings':
## 
##     collapse, intersect, setdiff, setequal, union

## The following object is masked from 'package:XVector':
## 
##     slice

## The following object is masked from 'package:matrixStats':
## 
##     count

## The following object is masked from 'package:Biobase':
## 
##     combine

## The following objects are masked from 'package:GenomicRanges':
## 
##     intersect, setdiff, union

## The following object is masked from 'package:GenomeInfoDb':
## 
##     intersect

## The following objects are masked from 'package:IRanges':
## 
##     collapse, desc, intersect, setdiff, slice, union

## The following objects are masked from 'package:S4Vectors':
## 
##     first, intersect, rename, setdiff, setequal, union

## The following objects are masked from 'package:BiocGenerics':
## 
##     combine, intersect, setdiff, union

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

## Loading required package: AnnotationFilter

## Loading required package: TxDb.Hsapiens.UCSC.hg19.knownGene

## Loading required package: GenomicFeatures

## Loading required package: AnnotationDbi

## 
## Attaching package: 'AnnotationDbi'

## The following object is masked from 'package:dplyr':
## 
##     select

## Loading required package: TxDb.Hsapiens.UCSC.hg38.knownGene

## Loading required package: TxDb.Mmusculus.UCSC.mm10.ensGene

## Loading required package: org.Hs.eg.db

## 

## Loading required package: org.Mm.eg.db

## 

## Loading required package: Homo.sapiens

## Loading required package: OrganismDbi

## Loading required package: GO.db

## 

## Loading required package: BSgenome.Hsapiens.UCSC.hg19

## Loading required package: BSgenome

## Loading required package: rtracklayer

## Loading required package: biomaRt

## Loading required package: TxDb.Athaliana.BioMart.plantsmart22

## snapshotDate(): 2017-10-27

ah <- AnnotationHub()

The very 1st time that you call the AnnotationHub, it will create a cache directory on your system and download the latest metadata for the hubs current contents. From that time forward, whenever you download one of the hubs data objects, it will also cache those files in the local directory so that if you request the information again, you will be able to access it quickly.

The show method of an AnnotationHub object will tell you how many resources are currently accessible using that object as well as give a high level overview of the most common kinds of data present.

ah

## AnnotationHub with 42203 records
## # snapshotDate(): 2017-10-27 
## # $dataprovider: BroadInstitute, Ensembl, UCSC, Haemcode, ftp://ftp.ncbi.nlm...
## # $species: Homo sapiens, Mus musculus, Drosophila melanogaster, Bos taurus,...
## # $rdataclass: GRanges, BigWigFile, FaFile, TwoBitFile, Rle, ChainFile, OrgD...
## # additional mcols(): taxonomyid, genome, description,
## #   coordinate_1_based, maintainer, rdatadateadded, preparerclass, tags,
## #   rdatapath, sourceurl, sourcetype 
## # retrieve records with, e.g., 'object[["AH2"]]' 
## 
##             title                                               
##   AH2     | Ailuropoda_melanoleuca.ailMel1.69.dna.toplevel.fa   
##   AH3     | Ailuropoda_melanoleuca.ailMel1.69.dna_rm.toplevel.fa
##   AH4     | Ailuropoda_melanoleuca.ailMel1.69.dna_sm.toplevel.fa
##   AH5     | Ailuropoda_melanoleuca.ailMel1.69.ncrna.fa          
##   AH6     | Ailuropoda_melanoleuca.ailMel1.69.pep.all.fa        
##   ...       ...                                                 
##   AH57988 | TxDb.Ggallus.UCSC.galGal5.refGene.sqlite            
##   AH57989 | TxDb.Mmulatta.UCSC.rheMac3.refGene.sqlite           
##   AH57990 | TxDb.Mmulatta.UCSC.rheMac8.refGene.sqlite           
##   AH57991 | TxDb.Ptroglodytes.UCSC.panTro4.refGene.sqlite       
##   AH57992 | TxDb.Rnorvegicus.UCSC.rn5.refGene.sqlite

As you can see from the object above, there are a LOT of different resources available. So normally when you get an AnnotationHub object the 1st thing you want to do is to filter it to remove unwanted resources.

Fortunately, the AnnotationHub has several different kinds of metadata that you can use for searching and subsetting. To see the different categories all you need to do is to type the name of your AnnotationHub object and then tab complete from the ‘$’ operator. And to see all possible contents of one of these categories you can pass that value in to unique like this:

unique(ah$dataprovider)

##  [1] "Ensembl"                              
##  [2] "UCSC"                                 
##  [3] "RefNet"                               
##  [4] "Inparanoid8"                          
##  [5] "NHLBI"                                
##  [6] "ChEA"                                 
##  [7] "Pazar"                                
##  [8] "NIH Pathway Interaction Database"     
##  [9] "Haemcode"                             
## [10] "BroadInstitute"                       
## [11] "PRIDE"                                
## [12] "Gencode"                              
## [13] "CRIBI"                                
## [14] "Genoscope"                            
## [15] "MISO, VAST-TOOLS, UCSC"               
## [16] "ftp://ftp.ncbi.nlm.nih.gov/gene/DATA/"
## [17] "UWashington"                          
## [18] "Stanford"                             
## [19] "dbSNP"

One of the most valuable ways in which the data is labeled is according to the kind of R object that will be returned to you.

unique(ah$rdataclass)

##  [1] "FaFile"           "GRanges"          "data.frame"       "Inparanoid8Db"   
##  [5] "TwoBitFile"       "ChainFile"        "SQLiteConnection" "biopax"          
##  [9] "BigWigFile"       "AAStringSet"      "MSnSet"           "mzRpwiz"         
## [13] "mzRident"         "list"             "TxDb"             "Rle"             
## [17] "EnsDb"            "OrgDb"            "VcfFile"

Once you have identified which sorts of metadata you would like to use to find your data of interest, you can then use the subset or query methods to reduce the size of the hub object to something more manageable. For example you could select only those records where the string ‘GRanges’ was in the metadata. As you can see GRanges are one of the more popular formats for data that comes from the AnnotationHub.

grs <- query(ah, "GRanges")
grs

## AnnotationHub with 18988 records
## # snapshotDate(): 2017-10-27 
## # $dataprovider: BroadInstitute, UCSC, Ensembl, Haemcode, Pazar, Gencode, Ge...
## # $species: Homo sapiens, Mus musculus, Bos taurus, Pan troglodytes, Canis f...
## # $rdataclass: GRanges
## # additional mcols(): taxonomyid, genome, description,
## #   coordinate_1_based, maintainer, rdatadateadded, preparerclass, tags,
## #   rdatapath, sourceurl, sourcetype 
## # retrieve records with, e.g., 'object[["AH5012"]]' 
## 
##             title                                            
##   AH5012  | Chromosome Band                                  
##   AH5013  | STS Markers                                      
##   AH5014  | FISH Clones                                      
##   AH5015  | Recomb Rate                                      
##   AH5016  | ENCODE Pilot                                     
##   ...       ...                                              
##   AH57309 | Vicugna_pacos.vicPac1.90.gtf                     
##   AH57310 | Xenopus_tropicalis.JGI_4.2.90.abinitio.gtf       
##   AH57311 | Xenopus_tropicalis.JGI_4.2.90.gtf                
##   AH57312 | Xiphophorus_maculatus.Xipmac4.4.2.90.abinitio.gtf
##   AH57313 | Xiphophorus_maculatus.Xipmac4.4.2.90.gtf

Or you can use subsetting to only select for matches on a specific field

grs <- ah[ah$rdataclass == "GRanges",]

The subset function is also provided.

orgs <- subset(ah, ah$rdataclass == "OrgDb")
orgs

## AnnotationHub with 940 records
## # snapshotDate(): 2017-10-27 
## # $dataprovider: ftp://ftp.ncbi.nlm.nih.gov/gene/DATA/
## # $species: Escherichia coli, Acanthamoeba castellanii_str._Neff, Acanthisit...
## # $rdataclass: OrgDb
## # additional mcols(): taxonomyid, genome, description,
## #   coordinate_1_based, maintainer, rdatadateadded, preparerclass, tags,
## #   rdatapath, sourceurl, sourcetype 
## # retrieve records with, e.g., 'object[["AH53757"]]' 
## 
##             title                                               
##   AH53757 | org.Ag.eg.db.sqlite                                 
##   AH53758 | org.At.tair.db.sqlite                               
##   AH53759 | org.Bt.eg.db.sqlite                                 
##   AH53760 | org.Cf.eg.db.sqlite                                 
##   AH53761 | org.Gg.eg.db.sqlite                                 
##   ...       ...                                                 
##   AH56649 | org.Thermoplasmatales_archaeon_BRNA1.eg.sqlite      
##   AH56650 | org.Ignicoccus_hospitalis_KIN4|I.eg.sqlite          
##   AH56651 | org.Desulfurococcus_amylolyticus_DSM_16532.eg.sqlite
##   AH56652 | org.Pandoravirus_dulcis.eg.sqlite                   
##   AH56653 | org.Methanocaldococcus_infernus_ME.eg.sqlite

And if you really need access to all the metadata you can extract it as a DataFrame using mcols() like so:

meta <- mcols(ah)

Also if you are a fan of GUI’s you can use the display method to look at your data in a browser and return selected rows back as a smaller AnnotationHub object like this:

sah <- display(ah)

Calling this method will produce a web based interface like the one pictured here:

Once you have the AnnotationHub object pared down to a reasonable size, and are sure about which records you want to retrieve, then you only need to use the ‘[[’ operator to extract them. Using the ‘[[’ operator, you can extract by numeric index (1,2,3) or by AnnotationHub ID. If you choose to use the former, you simply extract the element that you are interested in. So for our chain example, you might just want to 1st one like this:

res <- grs[[1]]

## loading from cache '/var/lib/jenkins//.AnnotationHub/5012'

head(res, n=3)

## UCSC track 'cytoBand'
## UCSCData object with 3 ranges and 1 metadata column:
##       seqnames             ranges strand |        name
##          <Rle>          <IRanges>  <Rle> | <character>
##   [1]     chr1 [      1, 2300000]      * |      p36.33
##   [2]     chr1 [2300001, 5400000]      * |      p36.32
##   [3]     chr1 [5400001, 7200000]      * |      p36.31
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

AnnotationHub exercises

Exercise 1: Use the AnnotationHub to extract UCSC data that is from Homo sapiens and also specifically from the hg19 genome. What happens to the hub object as you filter data at each step?

Exercise 2 Now that you have basically narrowed things down to the hg19 annotations from UCSC genome browser, lets get one of these annotations. Find the oreganno track and save it into a local variable.

[ Back to top ]

OrgDb objects

At this point you might be wondering: What is this OrgDb object about? OrgDb objects are one member of a family of annotation objects that all represent hidden data through a shared set of methods. So if you look closely at the dog object created below you can see it contains data for Canis familiaris (taxonomy ID = 9615). You can learn a little more about it by learning about the columns method.

dog <- query(orgs, "Canis familiaris")[[1]]

## loading from cache '/var/lib/jenkins//.AnnotationHub/60498'

dog

## OrgDb object:
## | DBSCHEMAVERSION: 2.1
## | Db type: OrgDb
## | Supporting package: AnnotationDbi
## | DBSCHEMA: CANINE_DB
## | ORGANISM: Canis familiaris
## | SPECIES: Canine
## | EGSOURCEDATE: 2017-Mar29
## | EGSOURCENAME: Entrez Gene
## | EGSOURCEURL: ftp://ftp.ncbi.nlm.nih.gov/gene/DATA
## | CENTRALID: EG
## | TAXID: 9615
## | GOSOURCENAME: Gene Ontology
## | GOSOURCEURL: ftp://ftp.geneontology.org/pub/go/godatabase/archive/latest-lite/
## | GOSOURCEDATE: 2017-Mar29
## | GOEGSOURCEDATE: 2017-Mar29
## | GOEGSOURCENAME: Entrez Gene
## | GOEGSOURCEURL: ftp://ftp.ncbi.nlm.nih.gov/gene/DATA
## | KEGGSOURCENAME: KEGG GENOME
## | KEGGSOURCEURL: ftp://ftp.genome.jp/pub/kegg/genomes
## | KEGGSOURCEDATE: 2011-Mar15
## | GPSOURCENAME: UCSC Genome Bioinformatics (Canis familiaris)
## | GPSOURCEURL: 
## | GPSOURCEDATE: 2017-Mar17
## | UNIPROTGOSOURCENAME: UNIPROTGO
## | UNIPROTGOSOURCEDATE: Tue Apr  4 21:12:06 2017
## | UNIPROTGOSOURCEURL: ftp://ftp.uniprot.org/pub/databases/uniprot/current_release/knowledgebase/idmapping/idmapping_selected.tab.gz
## | ENSOURCEDATE: 2017-Mar29
## | ENSOURCENAME: Ensembl
## | ENSOURCEURL: ftp://ftp.ensembl.org/pub/current_fasta

## 
## Please see: help('select') for usage information

columns(dog)

##  [1] "ACCNUM"       "ALIAS"        "ENSEMBL"      "ENSEMBLPROT"  "ENSEMBLTRANS"
##  [6] "ENTREZID"     "ENZYME"       "EVIDENCE"     "EVIDENCEALL"  "GENENAME"    
## [11] "GO"           "GOALL"        "ONTOLOGY"     "ONTOLOGYALL"  "PATH"        
## [16] "PMID"         "REFSEQ"       "SYMBOL"       "UNIGENE"      "UNIPROT"

The columns method gives you a vector of data types that can be retrieved from the object that you call it on. So the above call indicates that there are several different data types that can be retrieved from the tetra object.

A very similar method is the keytypes method, which will list all the data types that can also be used as keys.

keytypes(dog)

##  [1] "ACCNUM"       "ALIAS"        "ENSEMBL"      "ENSEMBLPROT"  "ENSEMBLTRANS"
##  [6] "ENTREZID"     "ENZYME"       "EVIDENCE"     "EVIDENCEALL"  "GENENAME"    
## [11] "GO"           "GOALL"        "ONTOLOGY"     "ONTOLOGYALL"  "PATH"        
## [16] "PMID"         "REFSEQ"       "SYMBOL"       "UNIGENE"      "UNIPROT"

In many cases most of the things that are listed as columns will also come back from a keytypes call, but since these two things are not guaranteed to be identical, we maintain two separate methods.

Now that you can see what kinds of things can be used as keys, you can call the keys method to extract out all the keys of a given key type.

head(keys(dog, keytype="ENTREZID"))

## [1] "399518" "399530" "399544" "399545" "399653" "403152"

This is useful if you need to get all the IDs of a particular kind but the keys method has a few extra arguments that can make it even more flexible. For example, using the keys method you could also extract the gene SYMBOLS that contain “COX” like this:

keys(dog, keytype="SYMBOL", pattern="COX")

##  [1] "COX5B"   "COX7A2L" "COX8A"   "COX5A"   "COX4I1"  "COX6A2"  "COX20"  
##  [8] "COX18"   "ACOX1"   "COX4I2"  "ACOX3"   "COX17"   "COX11"   "ACOXL"  
## [15] "COX7A1"  "COX1"    "COX2"    "COX3"    "COX19"   "COX7B2"  "COX14"  
## [22] "COX16"   "ACOX2"

Or if you really needed an other keytype, you can use the column argument to extract the ENTREZ GENE IDs for those gene SYMBOLS that contain the string “COX”:

keys(dog, keytype="ENTREZID", pattern="COX", column="SYMBOL")

## 'select()' returned 1:1 mapping between keys and columns

##  [1] "474567"    "475739"    "476040"    "478370"    "479623"    "479780"   
##  [7] "480099"    "482193"    "483322"    "485825"    "488790"    "503668"   
## [13] "609555"    "611729"    "612614"    "804478"    "804479"    "804480"   
## [19] "100685945" "100687434" "100688544" "100846976" "100855488"

But often, you will really want to extract other data that matches a particular key or set of keys. For that there are two methods which you can use. The more powerful of these is probably select. Here is how you would look up the gene SYMBOL, and REFSEQ id for specific entrez gene ID.

select(dog, keys="804478", columns=c("SYMBOL","REFSEQ"), keytype="ENTREZID")

## 'select()' returned 1:1 mapping between keys and columns

##   ENTREZID SYMBOL    REFSEQ
## 1   804478   COX1 NP_008473

When you call it, select will return a data.frame that attempts to fill in matching values for all the columns you requested. However, if you ask select for things that have a many to one relationship to your keys it can result in an expansion of the data object that is returned. For example, watch what happens when we ask for the GO terms for the same entrez gene ID:

select(dog, keys="804478", columns="GO", keytype="ENTREZID")

## 'select()' returned 1:many mapping between keys and columns

##    ENTREZID         GO EVIDENCE ONTOLOGY
## 1    804478 GO:0004129      IEA       MF
## 2    804478 GO:0005506      IEA       MF
## 3    804478 GO:0005751      IEA       CC
## 4    804478 GO:0006119      IEA       BP
## 5    804478 GO:0006123      IEA       BP
## 6    804478 GO:0009060      IEA       BP
## 7    804478 GO:0015990      IEA       BP
## 8    804478 GO:0016021      IEA       CC
## 9    804478 GO:0020037      IEA       MF
## 10   804478 GO:0045277      IEA       CC

Because there are several GO terms associated with the gene “804478”, you end up with many rows in the data.frame. This can become problematic if you then ask for several columns that have a many to one relationship to the original key. If you were to do that, not only would the result multiply in size, it would also become really hard to use. A better strategy is to be selective when using select.

Sometimes you might want to look up matching results in a way that is simpler than the data.frame object that select returns. This is especially true when you only want to look up one kind of value per key. For these cases, we recommend that you look at the mapIds method. Lets look at what happens if request the same basic information as in our recent select call, but instead using the mapIds method:

mapIds(dog, keys="804478", column="GO", keytype="ENTREZID")

## 'select()' returned 1:many mapping between keys and columns

##       804478 
## "GO:0004129"

As you can see, the mapIds method allows you to simplify the result that is returned. And by default, mapIds only returns the 1st matching element for each key. But what if you really need all those GO terms returned when you call mapIds? Well then you can make use of the mapIds multiVals argument. There are several options for this argument, we have already seen how by default you can return only the ‘first’ element. But you can also return a ‘list’ or ‘CharacterList’ object, or you can ‘filter’ out or return ‘asNA’ any keys that have multiple matches. You can even define your own rule (as a function) and pass that in as an argument to multiVals. Lets look at what happens when you return a list:

mapIds(dog, keys="804478", column="GO", keytype="ENTREZID", multiVals="list")

## 'select()' returned 1:many mapping between keys and columns

## $`804478`
##  [1] "GO:0004129" "GO:0005506" "GO:0005751" "GO:0006119" "GO:0006123"
##  [6] "GO:0009060" "GO:0015990" "GO:0016021" "GO:0020037" "GO:0045277"

Now you know how to extract information from an OrgDb object, you might find it helpful to know that there is a whole family of other AnnotationDb derived objects that you can also use with these same five methods (keytypes(), columns(), keys(), select(), and mapIds()). For example there are ChipDb objects, InparanoidDb objects and TxDb objects which contain data about microarray probes, inparanoid homology partners or transcript range information respectively. And there are also more specialized objects like GODb or ReactomeDb objects which offer access to data from GO and reactome. In the next section, we will be looking at one of the more popular classes of these objects: the TxDb object.

OrgDb exercises

Exercise 3: Look at the help page for the different columns and keytypes values with: help(“SYMBOL”). Now use this information and what we just described to look up the entrez gene and chromosome for the gene symbol “MSX2”.

Exercise 4: In the previous exercise we had to use gene symbols as keys. But in the past this kind of behavior has sometimes been inadvisable because some gene symbols are used as the official symbol for more than one gene. To learn if this is still happening take advantage of the fact that entrez gene ids are uniquely assigned, and extract all of the gene symbols and their associated entrez gene ids from the org.Hs.eg.db package. Then check the symbols for redundancy.

[ Back to top ]

TxDb Objects

As mentioned before, TxDb objects can be accessed using the standard set of methods: keytypes(), columns(), keys(), select(), and mapIds(). But because these objects contain information about a transcriptome, they are often used to compare range based information to these important features of the genome[3,4]. As a result they also have specialized accessors for extracting out ranges that correspond to important transcriptome characteristics.

Lets start by loading a TxDb object from an annotation package based on the UCSC ensembl genes track for Drosophila. A common practice when loading these is to shorten the long name to ‘txdb’ (just as a convenience).

txdb <- TxDb.Hsapiens.UCSC.hg19.knownGene
txdb

## TxDb object:
## # Db type: TxDb
## # Supporting package: GenomicFeatures
## # Data source: UCSC
## # Genome: hg19
## # Organism: Homo sapiens
## # Taxonomy ID: 9606
## # UCSC Table: knownGene
## # Resource URL: http://genome.ucsc.edu/
## # Type of Gene ID: Entrez Gene ID
## # Full dataset: yes
## # miRBase build ID: GRCh37
## # transcript_nrow: 82960
## # exon_nrow: 289969
## # cds_nrow: 237533
## # Db created by: GenomicFeatures package from Bioconductor
## # Creation time: 2015-10-07 18:11:28 +0000 (Wed, 07 Oct 2015)
## # GenomicFeatures version at creation time: 1.21.30
## # RSQLite version at creation time: 1.0.0
## # DBSCHEMAVERSION: 1.1

Just by looking at the TxDb object, we can learn a lot about what data it contains including where the data came from, which build of the UCSC genome it was based on and the last time that the object was updated. One of the most common uses for a TxDb object is to extract various kinds of transcript data out of it. So for example you can extract all the transcripts out of the TxDb as a GRanges object like this:

txs <- transcripts(txdb)
txs

## GRanges object with 82960 ranges and 2 metadata columns:
##                 seqnames           ranges strand |     tx_id     tx_name
##                    <Rle>        <IRanges>  <Rle> | <integer> <character>
##       [1]           chr1 [ 11874,  14409]      + |         1  uc001aaa.3
##       [2]           chr1 [ 11874,  14409]      + |         2  uc010nxq.1
##       [3]           chr1 [ 11874,  14409]      + |         3  uc010nxr.1
##       [4]           chr1 [ 69091,  70008]      + |         4  uc001aal.1
##       [5]           chr1 [321084, 321115]      + |         5  uc001aaq.2
##       ...            ...              ...    ... .       ...         ...
##   [82956] chrUn_gl000237   [    1,  2686]      - |     82956  uc011mgu.1
##   [82957] chrUn_gl000241   [20433, 36875]      - |     82957  uc011mgv.2
##   [82958] chrUn_gl000243   [11501, 11530]      + |     82958  uc011mgw.1
##   [82959] chrUn_gl000243   [13608, 13637]      + |     82959  uc022brq.1
##   [82960] chrUn_gl000247   [ 5787,  5816]      - |     82960  uc022brr.1
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

Similarly, there are also extractors for exons(), cds(), genes() and promoters(). Which kind of feature you choose to extract just depends on what information you are after. These basic extractors are fine if you only want a flat representation of these data, but many of these features are inherently nested. So instead of extracting a flat GRanges object, you might choose instead to extract a GRangesList object that groups the transcripts by the genes that they are associated with like this:

txby <- transcriptsBy(txdb, by="gene")
txby

## GRangesList object of length 23459:
## $1 
## GRanges object with 2 ranges and 2 metadata columns:
##       seqnames               ranges strand |     tx_id     tx_name
##          <Rle>            <IRanges>  <Rle> | <integer> <character>
##   [1]    chr19 [58858172, 58864865]      - |     70455  uc002qsd.4
##   [2]    chr19 [58859832, 58874214]      - |     70456  uc002qsf.2
## 
## $10 
## GRanges object with 1 range and 2 metadata columns:
##       seqnames               ranges strand | tx_id    tx_name
##   [1]     chr8 [18248755, 18258723]      + | 31944 uc003wyw.1
## 
## $100 
## GRanges object with 1 range and 2 metadata columns:
##       seqnames               ranges strand | tx_id    tx_name
##   [1]    chr20 [43248163, 43280376]      - | 72132 uc002xmj.3
## 
## ...
## <23456 more elements>
## -------
## seqinfo: 93 sequences (1 circular) from hg19 genome

Just as with the flat extractors, there is a whole family of extractors available depending on what you want to extract and how you want it grouped. They include transcriptsBy(), exonsBy(), cdsBy(), intronsByTranscript(), fiveUTRsByTranscript() and threeUTRsByTranscript().

When dealing with genomic data it is almost inevitable that you will run into problems with the way that different groups have adopted alternate ways of naming chromosomes. This is because almost every major repository has cooked up their own slightly different way of labeling these important features.

To cope with this, the Seqinfo object was invented and is attached to TxDb objects as well as the GenomicRanges extracted from these objects. You can extract it using the seqinfo() method like this:

si <- seqinfo(txdb)
si

## Seqinfo object with 93 sequences (1 circular) from hg19 genome:
##   seqnames       seqlengths isCircular genome
##   chr1            249250621       <NA>   hg19
##   chr2            243199373       <NA>   hg19
##   chr3            198022430       <NA>   hg19
##   chr4            191154276       <NA>   hg19
##   chr5            180915260       <NA>   hg19
##   ...                   ...        ...    ...
##   chrUn_gl000245      36651       <NA>   hg19
##   chrUn_gl000246      38154       <NA>   hg19
##   chrUn_gl000247      36422       <NA>   hg19
##   chrUn_gl000248      39786       <NA>   hg19
##   chrUn_gl000249      38502       <NA>   hg19

And since the seqinfo information is also attached to the GRanges objects produced by the TxDb extractors, you can also call seqinfo on the results of those methods like this:

txby <- transcriptsBy(txdb, by="gene")
si <- seqinfo(txby)

The Seqinfo object contains a lot of valuable data about which chromosome features are present, whether they are circular or linear, and how long each one is. It is also something that will be checked against if you try to do an operation like ‘findOverlaps’ to compute overlapping ranges etc. So it’s a valuable way to make sure that the chromosomes and genome are the same for your annotations as the range that you are comparing them to. But sometimes you may have a situation where your annotation object contains data that is comparable to your data object, but where it is simply named with a different naming style. For those cases, there are helpers that you can use to discover what the current name style is for an object. And there is also a setter method to allow you to change the value to something more appropriate. So in the following example, we are going to change the seqlevelStyle from ‘UCSC’ to ‘ensembl’ based naming convention (and then back again).

head(seqlevels(txdb))

## [1] "chr1" "chr2" "chr3" "chr4" "chr5" "chr6"

seqlevelsStyle(txdb)

## [1] "UCSC"

seqlevelsStyle(txdb) <- "NCBI"
head(seqlevels(txdb))

## [1] "1" "2" "3" "4" "5" "6"

## then change it back
seqlevelsStyle(txdb) <- "UCSC"
head(seqlevels(txdb))

## [1] "chr1" "chr2" "chr3" "chr4" "chr5" "chr6"

In addition to being able to change the naming style used for an object with seqinfo data, you can also toggle which of the chromosomes are ‘active’ so that the software will ignore certain chromosomes. By default, all of the chromosomes are set to be ‘active’.

head(isActiveSeq(txdb), n=30)

##                 chr1                 chr2                 chr3 
##                 TRUE                 TRUE                 TRUE 
##                 chr4                 chr5                 chr6 
##                 TRUE                 TRUE                 TRUE 
##                 chr7                 chr8                 chr9 
##                 TRUE                 TRUE                 TRUE 
##                chr10                chr11                chr12 
##                 TRUE                 TRUE                 TRUE 
##                chr13                chr14                chr15 
##                 TRUE                 TRUE                 TRUE 
##                chr16                chr17                chr18 
##                 TRUE                 TRUE                 TRUE 
##                chr19                chr20                chr21 
##                 TRUE                 TRUE                 TRUE 
##                chr22                 chrX                 chrY 
##                 TRUE                 TRUE                 TRUE 
##                 chrM chr1_gl000191_random chr1_gl000192_random 
##                 TRUE                 TRUE                 TRUE 
##       chr4_ctg9_hap1 chr4_gl000193_random chr4_gl000194_random 
##                 TRUE                 TRUE                 TRUE

But sometimes you might wish to ignore some of them. For example, lets suppose that you wanted to ignore the Y chromosome from our txdb. You could do that like so:

isActiveSeq(txdb)["chrY"] <- FALSE
head(isActiveSeq(txdb), n=26)

TxDb exercises

Exercise 5: Use the accessors for the TxDb.Hsapiens.UCSC.hg19.knownGene package to retrieve the gene id, transcript name and transcript chromosome for all the transcripts. Do this using both the select() method and also using the transcripts() method. What is the difference in the output?

Exercise 6: Load the TxDb.Athaliana.BioMart.plantsmart22 package. This package is not from UCSC and it is based on plantsmart. Now use select or one of the range based accessors to look at the gene ids from this TxDb object. How do they compare to what you saw in the TxDb.Hsapiens.UCSC.hg19.knownGene package?

[ Back to top ]

Organism.dplyr src_organism Objects

So what happens if you have data from multiple different Annotation objects. For example, what if you had gene SYMBOLS (found in an OrgDb object) and you wanted to easily match those up with known gene transcript names from a UCSC based TxDb object? There is an ideal tool that can help with this kind of problem and it’s called an src_organism object from the Organism.dplyr package. src_organism objects and their related methods are able to query each of OrgDb and TxDb resources for you and then merge the results back together in way that lets you pretend that you only have one source for all your annotations.

library(Organism.dplyr)

src_organism objects can be created for organisms that have both an OrgDb and a TxDb. To see organisms that can have src_organism objects made, use the function supportOrganisms():

supported <- supportedOrganisms()
print(supported, n=Inf)

## # A tibble: 21 x 3
##                   organism         OrgDb                                   TxDb
##                      <chr>         <chr>                                  <chr>
##  1              Bos taurus  org.Bt.eg.db      TxDb.Btaurus.UCSC.bosTau8.refGene
##  2  Caenorhabditis elegans  org.Ce.eg.db        TxDb.Celegans.UCSC.ce11.refGene
##  3  Caenorhabditis elegans  org.Ce.eg.db         TxDb.Celegans.UCSC.ce6.ensGene
##  4        Canis familiaris  org.Cf.eg.db  TxDb.Cfamiliaris.UCSC.canFam3.refGene
##  5 Drosophila melanogaster  org.Dm.eg.db    TxDb.Dmelanogaster.UCSC.dm3.ensGene
##  6 Drosophila melanogaster  org.Dm.eg.db    TxDb.Dmelanogaster.UCSC.dm6.ensGene
##  7             Danio rerio  org.Dr.eg.db      TxDb.Drerio.UCSC.danRer10.refGene
##  8           Gallus gallus  org.Gg.eg.db      TxDb.Ggallus.UCSC.galGal4.refGene
##  9            Homo sapiens  org.Hs.eg.db      TxDb.Hsapiens.UCSC.hg18.knownGene
## 10            Homo sapiens  org.Hs.eg.db      TxDb.Hsapiens.UCSC.hg19.knownGene
## 11            Homo sapiens  org.Hs.eg.db      TxDb.Hsapiens.UCSC.hg38.knownGene
## 12            Mus musculus  org.Mm.eg.db       TxDb.Mmusculus.UCSC.mm10.ensGene
## 13            Mus musculus  org.Mm.eg.db     TxDb.Mmusculus.UCSC.mm10.knownGene
## 14            Mus musculus  org.Mm.eg.db      TxDb.Mmusculus.UCSC.mm9.knownGene
## 15          Macaca mulatta org.Mmu.eg.db     TxDb.Mmulatta.UCSC.rheMac3.refGene
## 16          Macaca mulatta org.Mmu.eg.db     TxDb.Mmulatta.UCSC.rheMac8.refGene
## 17         Pan troglodytes  org.Pt.eg.db TxDb.Ptroglodytes.UCSC.panTro4.refGene
## 18       Rattus norvegicus  org.Rn.eg.db      TxDb.Rnorvegicus.UCSC.rn4.ensGene
## 19       Rattus norvegicus  org.Rn.eg.db      TxDb.Rnorvegicus.UCSC.rn5.refGene
## 20       Rattus norvegicus  org.Rn.eg.db      TxDb.Rnorvegicus.UCSC.rn6.refGene
## 21              Sus scrofa  org.Ss.eg.db      TxDb.Sscrofa.UCSC.susScr3.refGene

Notice how there are multiple entries for a single organism (e.g. three for Homo sapiens). There is only one OrgDb per organism, but different TxDbs can be used. To specify a certain version of a TxDb to use, we can use the src_organism() function to create an src_organism object.

library(org.Hs.eg.db)
library(TxDb.Hsapiens.UCSC.hg38.knownGene)
src <- src_organism("TxDb.Hsapiens.UCSC.hg38.knownGene")
src

## src:  sqlite 3.19.3 [/var/lib/jenkins/.cache/BiocFileCache/382c598330c6_382c598330c6]
## tbls: id, id_accession, id_go, id_go_all, id_omim_pm, id_protein,
##   id_transcript, ranges_cds, ranges_exon, ranges_gene, ranges_tx

We can also create one using the src_ucsc() function. This will create an src_organism object using the most recent TxDb version available:

src <- src_ucsc("Homo sapiens")

## using org.Hs.eg.db, TxDb.Hsapiens.UCSC.hg38.knownGene

src

## src:  sqlite 3.19.3 [/var/lib/jenkins/.cache/BiocFileCache/382c598330c6_382c598330c6]
## tbls: id, id_accession, id_go, id_go_all, id_omim_pm, id_protein,
##   id_transcript, ranges_cds, ranges_exon, ranges_gene, ranges_tx

The five methods that worked for all of the other Db objects that we have discussed (keytypes(), columns(), keys(), select(), and mapIds()) all work for src_organism objects. Here, we use keytypes() to show which keytypes can be passed to the keytype argument of select().

keytypes(src)

##  [1] "accnum"       "alias"        "cds_chrom"    "cds_end"      "cds_id"      
##  [6] "cds_name"     "cds_start"    "cds_strand"   "ensembl"      "ensemblprot" 
## [11] "ensembltrans" "entrez"       "enzyme"       "evidence"     "evidenceall" 
## [16] "exon_chrom"   "exon_end"     "exon_id"      "exon_name"    "exon_rank"   
## [21] "exon_start"   "exon_strand"  "gene_chrom"   "gene_end"     "gene_start"  
## [26] "gene_strand"  "genename"     "go"           "goall"        "ipi"         
## [31] "map"          "omim"         "ontology"     "ontologyall"  "pfam"        
## [36] "pmid"         "prosite"      "refseq"       "symbol"       "tx_chrom"    
## [41] "tx_end"       "tx_id"        "tx_name"      "tx_start"     "tx_strand"   
## [46] "tx_type"      "unigene"      "uniprot"

Use columns() to show which keytypes can be passed to the keytype argument of select().

columns(src)

##  [1] "accnum"       "alias"        "cds_chrom"    "cds_end"      "cds_id"      
##  [6] "cds_name"     "cds_start"    "cds_strand"   "ensembl"      "ensemblprot" 
## [11] "ensembltrans" "entrez"       "enzyme"       "evidence"     "evidenceall" 
## [16] "exon_chrom"   "exon_end"     "exon_id"      "exon_name"    "exon_rank"   
## [21] "exon_start"   "exon_strand"  "gene_chrom"   "gene_end"     "gene_start"  
## [26] "gene_strand"  "genename"     "go"           "goall"        "ipi"         
## [31] "map"          "omim"         "ontology"     "ontologyall"  "pfam"        
## [36] "pmid"         "prosite"      "refseq"       "symbol"       "tx_chrom"    
## [41] "tx_end"       "tx_id"        "tx_name"      "tx_start"     "tx_strand"   
## [46] "tx_type"      "unigene"      "uniprot"

And that’s it. You can now use these objects in the same way that you use OrgDb or TxDb objects. It works the same as the base objects that it contains:

select(src, keys="4488", columns=c("symbol", "tx_name"), keytype="entrez")

## Joining, by = "entrez"

##   entrez symbol    tx_name
## 1   4488   MSX2 uc003mcy.4
## 2   4488   MSX2 uc063juz.1

Organism.dplyr also supports numerous Genomic Extractor functions allowing users to filter based on information contained in the OrgDb and TxDb objects. To see the filters supported by a src_organism() object, use supportedFIlters():

head(supportedFilters(src))

##            filter     field
## 1    AccnumFilter    accnum
## 2     AliasFilter     alias
## 3  CdsChromFilter cds_chrom
## 45   CdsEndFilter   cds_end
## 43    CdsIdFilter    cds_id
## 4   CdsNameFilter  cds_name

The ranged based accessors such as those in GenomicFeatures will also work. There are also “_tbl” functions (e.g. transcripts_tbl()) that return tbl objects instead of GRanges objects. Complex filter statements can be given as input. Here we declare a GRangesFilter and use two different type-returning accessors to query transcripts that either start with “SNORD” and are within our given GRangesFilter, or have symbol with symbol “ADA”:

gr <- GRangesFilter(GenomicRanges::GRanges("chr1:44000000-55000000"))
transcripts(src, filter=~(symbol %startsWith% "SNORD" & gr) | symbol == "ADA")

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')

## Warning in as.data.frame(mcols(x), ...): Arguments in '...' ignored

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN `ranges_tx` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT *
## FROM `id`
## WHERE (`symbol` = 'ADA')

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN `ranges_tx` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )) AS `TBL_LEFT`
##   INNER JOIN `table1_374` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)

## <SQL>
## SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`, `tx_type` AS `tx_type`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM (SELECT *
## FROM `ranges_tx`)) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM (SELECT *
## FROM `ranges_tx`)) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM (SELECT *
## FROM `id`)
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN (SELECT *
## FROM `ranges_tx`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )) AS `TBL_LEFT`
##   INNER JOIN (SELECT *
## FROM `table1_374`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )
## UNION
## SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`, `tx_type` AS `tx_type`
## FROM (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM (SELECT *
## FROM `id`)
## WHERE (`symbol` = 'ADA')) AS `TBL_LEFT`
##   LEFT JOIN (SELECT *
## FROM `ranges_tx`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## )

## GRanges object with 8 ranges and 3 metadata columns:
##       seqnames               ranges strand |     tx_id     tx_name      symbol
##          <Rle>            <IRanges>  <Rle> | <integer> <character> <character>
##   [1]     chr1 [44775864, 44775943]      + |      2560  uc057fwc.1     SNORD55
##   [2]     chr1 [44776490, 44776593]      + |      2561  uc001cmk.2     SNORD46
##   [3]     chr1 [44777843, 44777912]      + |      2564  uc009vxi.4    SNORD38A
##   [4]     chr1 [44778390, 44778456]      + |      2566  uc057fwg.1    SNORD38B
##   [5]     chr1 [44778390, 44778458]      + |      2567  uc001cml.3    SNORD38B
##   [6]    chr20 [44619522, 44626491]      - |    169786  uc061xfj.1         ADA
##   [7]    chr20 [44619522, 44651742]      - |    169787  uc002xmj.4         ADA
##   [8]    chr20 [44619810, 44651691]      - |    169789  uc061xfl.1         ADA
##   -------
##   seqinfo: 455 sequences (1 circular) from hg38 genome

transcripts_tbl(src, filter=~(symbol %startsWith% "SNORD" & gr) | symbol == "ADA")

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')

## Warning in as.data.frame(mcols(x), ...): Arguments in '...' ignored

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN `ranges_tx` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT *
## FROM `id`
## WHERE (`symbol` = 'ADA')

## <SQL>
## SELECT *
## FROM `ranges_tx`

## <SQL>
## SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM `ranges_tx`) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM `id`
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN `ranges_tx` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )) AS `TBL_LEFT`
##   INNER JOIN `table2_374` AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)

## <SQL>
## SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`, `tx_type` AS `tx_type`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM (SELECT *
## FROM `ranges_tx`)) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`
## FROM (SELECT `TBL_LEFT`.`tx_chrom` AS `tx_chrom`, `TBL_LEFT`.`tx_strand` AS `tx_strand`, `TBL_LEFT`.`tx_start` AS `tx_start`, `TBL_LEFT`.`tx_end` AS `tx_end`, `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`tx_id` AS `tx_id`, `TBL_LEFT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`map` AS `map`, `TBL_RIGHT`.`ensembl` AS `ensembl`, `TBL_RIGHT`.`symbol` AS `symbol`, `TBL_RIGHT`.`genename` AS `genename`, `TBL_RIGHT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`
## FROM (SELECT *
## FROM `ranges_tx`)) AS `TBL_LEFT`
##   INNER JOIN (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM (SELECT *
## FROM `id`)
## WHERE (`symbol` LIKE 'SNORD%')) AS `TBL_LEFT`
##   LEFT JOIN (SELECT *
## FROM `ranges_tx`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )) AS `TBL_LEFT`
##   INNER JOIN (SELECT *
## FROM `table2_374`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## ) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`tx_chrom` = `TBL_RIGHT`.`tx_chrom` AND `TBL_LEFT`.`tx_strand` = `TBL_RIGHT`.`tx_strand` AND `TBL_LEFT`.`tx_start` = `TBL_RIGHT`.`tx_start` AND `TBL_LEFT`.`tx_end` = `TBL_RIGHT`.`tx_end` AND `TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez` AND `TBL_LEFT`.`tx_id` = `TBL_RIGHT`.`tx_id` AND `TBL_LEFT`.`tx_name` = `TBL_RIGHT`.`tx_name`)
## )
## UNION
## SELECT `tx_chrom` AS `tx_chrom`, `tx_strand` AS `tx_strand`, `tx_start` AS `tx_start`, `tx_end` AS `tx_end`, `entrez` AS `entrez`, `tx_id` AS `tx_id`, `tx_name` AS `tx_name`, `map` AS `map`, `ensembl` AS `ensembl`, `symbol` AS `symbol`, `genename` AS `genename`, `alias` AS `alias`, `tx_type` AS `tx_type`
## FROM (SELECT `TBL_LEFT`.`entrez` AS `entrez`, `TBL_LEFT`.`map` AS `map`, `TBL_LEFT`.`ensembl` AS `ensembl`, `TBL_LEFT`.`symbol` AS `symbol`, `TBL_LEFT`.`genename` AS `genename`, `TBL_LEFT`.`alias` AS `alias`, `TBL_RIGHT`.`tx_chrom` AS `tx_chrom`, `TBL_RIGHT`.`tx_strand` AS `tx_strand`, `TBL_RIGHT`.`tx_start` AS `tx_start`, `TBL_RIGHT`.`tx_end` AS `tx_end`, `TBL_RIGHT`.`tx_id` AS `tx_id`, `TBL_RIGHT`.`tx_name` AS `tx_name`, `TBL_RIGHT`.`tx_type` AS `tx_type`
##   FROM (SELECT *
## FROM (SELECT *
## FROM `id`)
## WHERE (`symbol` = 'ADA')) AS `TBL_LEFT`
##   LEFT JOIN (SELECT *
## FROM `ranges_tx`) AS `TBL_RIGHT`
##   ON (`TBL_LEFT`.`entrez` = `TBL_RIGHT`.`entrez`)
## )

## # Source:     lazy query [?? x 7]
## # Database:   sqlite 3.19.3 []
## # Ordered by: tx_id
##   tx_chrom tx_start   tx_end tx_strand  tx_id    tx_name   symbol
##      <chr>    <int>    <int>     <chr>  <int>      <chr>    <chr>
## 1     chr1 44775864 44775943         +   2560 uc057fwc.1  SNORD55
## 2     chr1 44776490 44776593         +   2561 uc001cmk.2  SNORD46
## 3     chr1 44777843 44777912         +   2564 uc009vxi.4 SNORD38A
## 4     chr1 44778390 44778456         +   2566 uc057fwg.1 SNORD38B
## 5     chr1 44778390 44778458         +   2567 uc001cml.3 SNORD38B
## 6    chr20 44619522 44626491         - 169786 uc061xfj.1      ADA
## 7    chr20 44619522 44651742         - 169787 uc002xmj.4      ADA
## 8    chr20 44619810 44651691         - 169789 uc061xfl.1      ADA

Organism.dplyr exercises

Exercise 7: Use the src_organism object to look up the gene symbol, transcript start and chromosome using select(). Then do the same thing using transcripts. You might expect that this call to transcripts will look the same as it did for the TxDb object, but (temporarily) it will not.

Exercise 8: Look at the results from call the columns method on the src_organism object and compare that to what happens when you call columns on the org.Hs.eg.db object and then look at a call to columns on the TxDb.Hsapiens.UCSC.hg19.knownGene object.

Exercise 9: Use the src_organism object with the transcripts method to look up the entrez gene IDs for all gene symbols that contain the letter ‘X’.

[ Back to top ]

BSgenome Objects

Another important annotation resource type is a BSgenome package[10]. There are many BSgenome packages in the repository for you to choose from. And you can learn which organisms are already supported by using the available.genomes() function.

head(available.genomes())

## [1] "BSgenome.Alyrata.JGI.v1"                
## [2] "BSgenome.Amellifera.BeeBase.assembly4"  
## [3] "BSgenome.Amellifera.UCSC.apiMel2"       
## [4] "BSgenome.Amellifera.UCSC.apiMel2.masked"
## [5] "BSgenome.Athaliana.TAIR.04232008"       
## [6] "BSgenome.Athaliana.TAIR.TAIR9"

Unlike the other resources that we have discussed here, these packages are meant to contain sequence data for a specific genome build of an organism. You can load one of these packages in the usual way. And each of them normally has an alias for the primary object that is shorter than the full package name (as a convenience):

ls(2)

## [1] "create_env"   "populate_env"

Hsapiens

## Human genome:
## # organism: Homo sapiens (Human)
## # provider: UCSC
## # provider version: hg19
## # release date: Feb. 2009
## # release name: Genome Reference Consortium GRCh37
## # 93 sequences:
## #   chr1                  chr2                  chr3                 
## #   chr4                  chr5                  chr6                 
## #   chr7                  chr8                  chr9                 
## #   chr10                 chr11                 chr12                
## #   chr13                 chr14                 chr15                
## #   ...                   ...                   ...                  
## #   chrUn_gl000235        chrUn_gl000236        chrUn_gl000237       
## #   chrUn_gl000238        chrUn_gl000239        chrUn_gl000240       
## #   chrUn_gl000241        chrUn_gl000242        chrUn_gl000243       
## #   chrUn_gl000244        chrUn_gl000245        chrUn_gl000246       
## #   chrUn_gl000247        chrUn_gl000248        chrUn_gl000249       
## # (use 'seqnames()' to see all the sequence names, use the '$' or '[[' operator
## # to access a given sequence)

The getSeq method is a useful way of extracting data from these packages. This method takes several arguments but the important ones are the 1st two. The 1st argument specifies the BSgenome object to use and the second argument (names) specifies what data you want back out. So for example, if you call it and give a character vector that names the seqnames for the object then you will get the sequences from those chromosomes as a DNAStringSet object.

seqNms <- seqnames(Hsapiens)
head(seqNms)

## [1] "chr1" "chr2" "chr3" "chr4" "chr5" "chr6"

getSeq(Hsapiens, seqNms[1:2])

##   A DNAStringSet instance of length 2
##         width seq                                           names               
## [1] 249250621 NNNNNNNNNNNNNNNNNNNNN...NNNNNNNNNNNNNNNNNNNNN chr1
## [2] 243199373 NNNNNNNNNNNNNNNNNNNNN...NNNNNNNNNNNNNNNNNNNNN chr2

Whereas if you give the a GRanges object for the 2nd argument, you can instead get a DNAStringSet that corresponds to those ranges. This can be a powerful way to learn what sequence was present from a particular range. For example, here we can extract the range of a specific gene of interest like this.

txby <- transcriptsBy(txdb, by="gene")
geneOfInterest <- txby[["4488"]]
res <- getSeq(Hsapiens, geneOfInterest)
res

Additionally, the Biostrings[11] package has many useful functions for finding a pattern in a string set etc. You may not have noticed when it happened, but the Biostrings package was loaded when you loaded the BSgenome object, so these functions will already be available for you to explore.

BSgenome exercises

Exercise 10: Use what you have just learned to extract the sequence for the PTEN gene.

[ Back to top ]

biomaRt

Another great annotation resource is the biomaRt package[5,6,7]. The biomaRt package exposes a huge family of different online annotation resources called marts. Each mart is another of a set of online web resources that are following a convention that allows them to work with this package. So the first step in using biomaRt is always to load the package and then decide which “mart” you want to use. Once you have made your decision, you will then use the useMart() method to create a mart object in your R session. Here we are looking at the marts available and then choosing to use one of the most popular marts: the “ensembl”” mart.

head(listMarts())

##                biomart               version
## 1 ENSEMBL_MART_ENSEMBL      Ensembl Genes 90
## 2   ENSEMBL_MART_MOUSE      Mouse strains 90
## 3     ENSEMBL_MART_SNP  Ensembl Variation 90
## 4 ENSEMBL_MART_FUNCGEN Ensembl Regulation 90

ensembl <- useMart("ensembl")
ensembl

## Object of class 'Mart':
##   Using the ENSEMBL_MART_ENSEMBL BioMart database
##   No dataset selected.

Each ‘mart’ can contain datasets for multiple different things. So the next step is that you need to decide on a dataset. Once you have chosen one, you will need to specify that dataset using the dataset argument when you call the useMart() constructor method. Here we will point to the dataset for humans.

head(listDatasets(ensembl))

##                    dataset                               description
## 1     sscrofa_gene_ensembl                   Pig genes (Sscrofa11.1)
## 2   sharrisii_gene_ensembl    Tasmanian devil genes (Devil_ref v7.0)
## 3   mspreteij_gene_ensembl       Algerian mouse genes (SPRET_EiJ_v1)
## 4 cfamiliaris_gene_ensembl                     Dog genes (CanFam3.1)
## 5     ccrigri_gene_ensembl Chinese hamster CriGri genes (CriGri_1.0)
## 6  eeuropaeus_gene_ensembl                  Hedgehog genes (eriEur1)
##          version
## 1    Sscrofa11.1
## 2 Devil_ref v7.0
## 3   SPRET_EiJ_v1
## 4      CanFam3.1
## 5     CriGri_1.0
## 6        eriEur1

ensembl <- useMart("ensembl",dataset="hsapiens_gene_ensembl")
ensembl

## Object of class 'Mart':
##   Using the ENSEMBL_MART_ENSEMBL BioMart database
##   Using the hsapiens_gene_ensembl dataset

Next we need to think about attributes, values and filters. Lets start with attributes. You can get a listing of the different kinds of attributes from biomaRt buy using the listAttributes method:

head(listAttributes(ensembl))

##                            name                  description         page
## 1               ensembl_gene_id               Gene stable ID feature_page
## 2       ensembl_gene_id_version       Gene stable ID version feature_page
## 3         ensembl_transcript_id         Transcript stable ID feature_page
## 4 ensembl_transcript_id_version Transcript stable ID version feature_page
## 5            ensembl_peptide_id            Protein stable ID feature_page
## 6    ensembl_peptide_id_version    Protein stable ID version feature_page

And you can see what the values for a particular attribute are by using the getBM method:

head(getBM(attributes="chromosome_name", mart=ensembl))

##   chromosome_name
## 1               1
## 2              10
## 3              11
## 4              12
## 5              13
## 6              14

Attributes are the things that you can have returned from biomaRt. They are analogous to what you get when you use the columns method with other objects.

In the biomaRt package, filters are things that can be used with values to restrict or choose what comes back. The ‘values’ here are treated as keys that you are passing in and which you would like to know more information about. In contrast, the filter represents the kind of key that you are searching for. So for example, you might choose a filter name of “chromosome_name” to go with specific value of “1”. Together these two argument values would request whatever attributes matched things on the 1st chromosome. And just as there here is an accessor for attributes, there is also an accessor for filters:

head(listFilters(ensembl))

##              name              description
## 1 chromosome_name Chromosome/scaffold name
## 2           start                    Start
## 3             end                      End
## 4      band_start               Band Start
## 5        band_end                 Band End
## 6    marker_start             Marker Start

So now you know about attributes, values and filters, you can call the getBM method to put it all together and request specific data from the mart. So for example, the following requests gene symbols and entrez gene IDs that are found on chromosome 1 of flies:

res <- getBM(attributes=c("hgnc_symbol", "entrezgene"),
                    filters = "chromosome_name",
                    values = "1", mart = ensembl)
head(res)

##   hgnc_symbol entrezgene
## 1     DDX11L1      84771
## 2     DDX11L1     727856
## 3     DDX11L1  100287102
## 4     DDX11L1  100287596
## 5      WASH7P     653635
## 6   MIR6859-1  102466751

Of course you may have noticed that a lot of the arguments for getBM are very similar to what you do when you call shsapienselect. So if it’s your preference you can now also use the standard select methods with mart objects.

head(columns(ensembl))

## [1] "3_utr_end"   "3_utr_end"   "3_utr_start" "3_utr_start" "3utr"       
## [6] "5_utr_end"

biomaRt exercises

Exercise 11: Pull down GO terms for entrez gene id “1” from human by using the ensembl “hsapiens_gene_ensembl” dataset.

Exercise 12: Now compare the GO terms you just pulled down to the same GO terms from the org.Hs.eg.db package (which you can now retrieve using select()). What differences do you notice? Why do you suspect that is?

[ Back to top ]

Creating annotation objects

By now you are aware that Bioconductor has a lot of annotation resources. But it is still completely impossible to have every annotation resource pre-packaged for every conceivable use. Because of this, almost all annotation objects have special functions that can be called to create those objects (or the packages that load them) from generalized data resources or specific file types. Below is a table with a few of the more popular options.

If you want this And you have this Then you could call this to help
TxDb tracks from UCSC GenomicFeatures::makeTxDbPackageFromUCSC
TxDb data from biomaRt GenomicFeatures::makeTxDbPackageFromBiomaRt
TxDb gff or gtf file GenomicFeatures::makeTxDbFromGFF
OrgDb custom data.frames AnnotationForge::makeOrgPackage
OrgDb valid Taxonomy ID AnnotationForge::makeOrgPackageFromNCBI
ChipDb org package & data.frame AnnotationForge::makeChipPackage
BSgenome fasta or twobit sequence files BSgenome::forgeBSgenomeDataPkg

In most cases the output for resource creation functions will be an annotation package that you can install.

And there is unfortunately not enough space to demonstrate how to call each of these functions here. But to do so is actually pretty straightforward and most such functions will be well documented with their associated manual pages and vignettes[3,4,10,12]. As usual, you can see the help page for any function right inside of R.

help("makeTxDbPackageFromUCSC")

If you plan to make use of these kinds of functions then you should expect to consult the associated documentation first. These kinds of functions tend to have a lot of arguments and most of them also require that their input data meet some fairly specific criteria. Finally, you should know that even after you have succeeded at creating an annotation package, you will also have to make use of the install.packages() function (with the repos argument=NULL) to install whatever package source directory has just been created.

Important considerations

The bioconductor project represents a very large and active codebase from an active and engaged community. Because of this, you should expect that the software described in this walkthrough will change over time and often in dramatic ways. As an example, the getSeq function that is described in this chapter is expected to a big overhaul in the coming months. When this happens the older function will be deprecated for a full release cycle (6 months) and then labeled as defunct for another release cycle before it is removed. This cycle is in place so that active users can be warned about what is happening and where they should look for the appropriate replacement functionality. But obviously, this system cannot warn end users if they have not been vigilant about updating their software to the latest version. So please take the time to always update your software to the latest version.

To stay abreast of new developments users are encouraged to explore the bioconductor website which contains many current walkthroughs and vignettes. Also visit the support site where you can ask questions and engage in discussions.

sessionInfo()

Package versions used in this tutorial:

sessionInfo()

## R version 3.4.2 (2017-09-28)
## Platform: x86_64-pc-linux-gnu (64-bit)
## Running under: Ubuntu 16.04.3 LTS
## 
## Matrix products: default
## BLAS: /usr/local/lib/R/lib/libRblas.so
## LAPACK: /usr/local/lib/R/lib/libRlapack.so
## 
## locale:
##  [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
##  [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
##  [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
##  [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
##  [9] LC_ADDRESS=C               LC_TELEPHONE=C            
## [11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       
## 
## attached base packages:
## [1] stats4    parallel  stats     graphics  grDevices utils     datasets 
## [8] methods   base     
## 
## other attached packages:
##  [1] bindrcpp_0.2                             
##  [2] annotation_1.0.4                         
##  [3] TxDb.Athaliana.BioMart.plantsmart22_3.0.1
##  [4] biomaRt_2.33.4                           
##  [5] BSgenome.Hsapiens.UCSC.hg19_1.4.0        
##  [6] BSgenome_1.45.3                          
##  [7] rtracklayer_1.37.6                       
##  [8] Homo.sapiens_1.3.1                       
##  [9] GO.db_3.4.2                              
## [10] OrganismDbi_1.19.1                       
## [11] org.Mm.eg.db_3.4.2                       
## [12] org.Hs.eg.db_3.4.2                       
## [13] TxDb.Mmusculus.UCSC.mm10.ensGene_3.4.0   
## [14] TxDb.Hsapiens.UCSC.hg38.knownGene_3.4.0  
## [15] TxDb.Hsapiens.UCSC.hg19.knownGene_3.2.2  
## [16] GenomicFeatures_1.29.15                  
## [17] AnnotationDbi_1.39.4                     
## [18] Organism.dplyr_1.5.8                     
## [19] AnnotationFilter_1.1.9                   
## [20] dplyr_0.7.4                              
## [21] AnnotationHub_2.9.22                     
## [22] VariantAnnotation_1.23.9                 
## [23] Rsamtools_1.29.1                         
## [24] Biostrings_2.45.4                        
## [25] XVector_0.17.2                           
## [26] SummarizedExperiment_1.7.10              
## [27] DelayedArray_0.3.21                      
## [28] matrixStats_0.52.2                       
## [29] Biobase_2.37.2                           
## [30] GenomicRanges_1.29.15                    
## [31] GenomeInfoDb_1.13.6                      
## [32] IRanges_2.11.19                          
## [33] S4Vectors_0.15.14                        
## [34] BiocGenerics_0.23.4                      
## [35] BiocStyle_2.5.43                         
## [36] rmarkdown_1.6                            
## [37] knitr_1.17                               
## 
## loaded via a namespace (and not attached):
##  [1] httr_1.3.1                    bit64_0.9-7                  
##  [3] shiny_1.0.5                   assertthat_0.2.0             
##  [5] interactiveDisplayBase_1.15.0 BiocFileCache_1.1.17         
##  [7] RBGL_1.53.0                   blob_1.1.0                   
##  [9] GenomeInfoDbData_0.99.1       yaml_2.1.14                  
## [11] progress_1.1.2                RSQLite_2.0                  
## [13] backports_1.1.1               lattice_0.20-35              
## [15] glue_1.2.0                    digest_0.6.12                
## [17] htmltools_0.3.6               httpuv_1.3.5                 
## [19] Matrix_1.2-11                 XML_3.98-1.9                 
## [21] pkgconfig_2.0.1               zlibbioc_1.23.0              
## [23] xtable_1.8-2                  BiocParallel_1.11.13         
## [25] tibble_1.3.4                  lazyeval_0.2.1               
## [27] magrittr_1.5                  mime_0.5                     
## [29] memoise_1.1.0                 evaluate_0.10.1              
## [31] graph_1.55.0                  BiocInstaller_1.27.8         
## [33] tools_3.4.2                   prettyunits_1.0.2            
## [35] stringr_1.2.0                 compiler_3.4.2               
## [37] rlang_0.1.2                   grid_3.4.2                   
## [39] RCurl_1.95-4.8                rappdirs_0.3.1               
## [41] bitops_1.0-6                  curl_3.0                     
## [43] DBI_0.7                       R6_2.2.2                     
## [45] GenomicAlignments_1.13.6      bit_1.1-12                   
## [47] bindr_0.1                     rprojroot_1.2                
## [49] stringi_1.1.5                 Rcpp_0.12.13                 
## [51] dbplyr_1.1.0

Acknowledgments

Research reported in this chapter was supported by the National Human Genome Research Institute of the National Institutes of Health under Award Number U41HG004059 and by the National Cancer Institute of the National Institutes of Health under Award Number U24CA180996. We also want to thank the numerous institutions who produced and maintained the data that is used for generating and updating the annotation resources described here.

References

  1. Wolfgang Huber, Vincent J Carey, Robert Gentleman, Simon Anders, Marc Carlson, Benilton S Carvalho, Hector Corrada Bravo, Sean Davis, Laurent Gatto, Thomas Girke, Raphael Gottardo, Florian Hahne, Kasper D Hansen, Rafael A Irizarry, Michael Lawrence, Michael I Love, James MacDonald, Valerie Obenchain, Andrzej K Oleś, Hervé Pagès, Alejandro Reyes, Paul Shannon, Gordon K Smyth, Dan Tenenbaum, Levi Waldron & Martin Morgan (2015) Orchestrating high-throughput genomic analysis with Bioconductor Nature Methods 12:115-121

  2. Pages H, Carlson M, Falcon S and Li N. AnnotationDbi: Annotation Database Interface. R package version 1.30.0.

  3. M. Carlson, H. Pages, P. Aboyoun, S. Falcon, M. Morgan, D. Sarkar, M. Lawrence GenomicFeatures: Tools for making and manipulating transcript centric annotations version 1.19.38.

  4. Lawrence M, Huber W, Pagès H, Aboyoun P, Carlson M, Gentleman R, Morgan M and Carey V (2013). Software for Computing and Annotating Genomic Ranges. PLoS Computational Biology, 9. http://dx.doi.org/10.1371/journal.pcbi.1003118, http://www.ploscompbiol.org/article/info%3Adoi%2F10.1371%2Fjournal.pcbi.1003118

  5. Steffen Durinck, Wolfgang Huber biomaRt: Interface to BioMart databases (e.g. Ensembl, COSMIC ,Wormbase and Gramene) version 2.23.5.

  6. Durinck S, Spellman P, Birney E and Huber W (2009). Mapping identifiers for the integration of genomic datasets with the R/Bioconductor package biomaRt. Nature Protocols, 4, pp. 1184-1191.

  7. Durinck S, Moreau Y, Kasprzyk A, Davis S, De Moor B, Brazma A and Huber W (2005). BioMart and Bioconductor: a powerful link between biological databases and microarray data analysis. Bioinformatics, 21, pp. 3439-3440.

  8. Morgan M, Carlson M, Tenenbaum D and Arora S. AnnotationHub: Client to access AnnotationHub resources. R package version 2.0.1.

  9. Carlson M, Pages H, Morgan M and Obenchain V. OrganismDbi: Software to enable the smooth interfacing of different database packages. R package version 1.10.0.

  10. Pages H. BSgenome: Infrastructure for Biostrings-based genome data packages. R package version 1.36.0.

  11. Pages H, Aboyoun P, Gentleman R and DebRoy S. Biostrings: String objects representing biological sequences, and matching algorithms. R package version 2.36.0.

  12. Carlson M, and Pages H. AnnotationForge: Code for Building Annotation Database Packages. R package version 1.10.0.

Answers for exercises

Exercise 1:

The 1st thing you need to do is look for thing from UCSC

ahs <- query(ah, "UCSC")

Then you can look for Genome values that match ‘hg19’ and a species that matches ‘Homo sapiens’.

ahs <- subset(ahs, ahs$genome=='hg19')
length(ahs)

## [1] 5693

ahs <- subset(ahs, ahs$species=='Homo sapiens')
length(ahs)

## [1] 5693

You might notice that the last two filtering steps are redundant (IOW doing the 1st of them is the same as doing both of them.) If this were not the case, we might suspect that there was a problem with the metadata.

Exercise 2:

This pulls down the oreganno annotations. Which are described on the UCSC site thusly: “This track displays literature-curated regulatory regions, transcription factor binding sites, and regulatory polymorphisms from ORegAnno (Open Regulatory Annotation). For more detailed information on a particular regulatory element, follow the link to ORegAnno from the details page.”

ahs <- query(ah, 'oreganno')
ahs

## AnnotationHub with 9 records
## # snapshotDate(): 2017-10-27 
## # $dataprovider: Pazar, UCSC
## # $species: Homo sapiens, Saccharomyces cerevisiae, NA
## # $rdataclass: GRanges
## # additional mcols(): taxonomyid, genome, description,
## #   coordinate_1_based, maintainer, rdatadateadded, preparerclass, tags,
## #   rdatapath, sourceurl, sourcetype 
## # retrieve records with, e.g., 'object[["AH5087"]]' 
## 
##             title                                 
##   AH5087  | ORegAnno                              
##   AH5213  | ORegAnno                              
##   AH7053  | ORegAnno                              
##   AH7061  | ORegAnno                              
##   AH22286 | pazar_ORegAnno_20120522.csv           
##   AH22287 | pazar_ORegAnno_ENCODEprom_20120522.csv
##   AH22288 | pazar_ORegAnno_Erythroid_20120522.csv 
##   AH22289 | pazar_ORegAnno_STAT1_ChIP_20120522.csv
##   AH22290 | pazar_ORegAnno_STAT1_lit_20120522.csv

ahs[1]

## AnnotationHub with 1 record
## # snapshotDate(): 2017-10-27 
## # names(): AH5087
## # $dataprovider: UCSC
## # $species: Homo sapiens
## # $rdataclass: GRanges
## # $rdatadateadded: 2013-03-26
## # $title: ORegAnno
## # $description: GRanges object from UCSC track 'ORegAnno'
## # $taxonomyid: 9606
## # $genome: hg19
## # $sourcetype: UCSC track
## # $sourceurl: rtracklayer://hgdownload.cse.ucsc.edu/goldenpath/hg19/database...
## # $sourcesize: NA
## # $tags: c("oreganno", "UCSC", "track", "Gene", "Transcript",
## #   "Annotation") 
## # retrieve record with 'object[["AH5087"]]'

oreg <- ahs[['AH5087']]

## loading from cache '/var/lib/jenkins//.AnnotationHub/5087'

oreg

## GRanges object with 23118 ranges and 2 metadata columns:
##                        seqnames           ranges strand |        name     score
##                           <Rle>        <IRanges>  <Rle> | <character> <numeric>
##       [1]                  chr1 [873499, 873849]      + | OREG0012989         0
##       [2]                  chr1 [886764, 887214]      + | OREG0012990         0
##       [3]                  chr1 [886938, 886958]      + | OREG0007909         0
##       [4]                  chr1 [919400, 919950]      + | OREG0012991         0
##       [5]                  chr1 [919695, 919715]      + | OREG0007910         0
##       ...                   ...              ...    ... .         ...       ...
##   [23114]  chr7_gl000195_random [     1,    851]      + | OREG0026736         0
##   [23115]  chr7_gl000195_random [103427, 103447]      + | OREG0012963         0
##   [23116]  chr7_gl000195_random [121139, 121159]      + | OREG0012964         0
##   [23117] chr17_gl000204_random [ 58370,  58955]      + | OREG0026769         0
##   [23118] chr17_gl000205_random [117492, 118442]      + | OREG0026772         0
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

Exercise 3:

keys <- "MSX2"
columns <- c("ENTREZID", "CHR")
select(org.Hs.eg.db, keys, columns, keytype="SYMBOL")

## Warning in .deprecatedColsMessage(): Accessing gene location information via 'CHR','CHRLOC','CHRLOCEND' is
##   deprecated. Please use a range based accessor like genes(), or select()
##   with columns values like TXCHROM and TXSTART on a TxDb or OrganismDb
##   object instead.

## 'select()' returned 1:1 mapping between keys and columns

##   SYMBOL ENTREZID CHR
## 1   MSX2     4488   5

Exercise 4:

## 1st get all the gene symbols
orgSymbols <- keys(org.Hs.eg.db, keytype="SYMBOL")
## and then use that to get all gene symbols matched to all entrez gene IDs
egr <- select(org.Hs.eg.db, keys=orgSymbols, "ENTREZID", "SYMBOL")

## 'select()' returned 1:many mapping between keys and columns

length(egr$ENTREZID)

## [1] 59737

length(unique(egr$ENTREZID))

## [1] 59737

## VS:
length(egr$SYMBOL)

## [1] 59737

length(unique(egr$SYMBOL))

## [1] 59682

## So lets trap these symbols that are redundant and look more closely...
redund <- egr$SYMBOL
badSymbols <- redund[duplicated(redund)]
select(org.Hs.eg.db, badSymbols, "ENTREZID", "SYMBOL")

## 'select()' returned many:many mapping between keys and columns

##        SYMBOL  ENTREZID
## 1         HBD      3045
## 2         HBD 100187828
## 3        RNR1      4549
## 4        RNR1      6052
## 5        RNR2      4550
## 6        RNR2      6053
## 7         TEC      7006
## 8         TEC 100124696
## 9       MEMO1      7795
## 10      MEMO1     51072
## 11      RPP14     11102
## 12      RPP14 109703458
## 13      RFLNA    144347
## 14      RFLNA 100533183
## 15       MMD2    221938
## 16       MMD2 100505381
## 17   DEL11P13 100528024
## 18   DEL11P13 107648861
## 19  TRNAK-CUU 107984908
## 20  TRNAK-CUU 107985605
## 21  TRNAK-CUU 107985760
## 22  TRNAK-CUU 107984908
## 23  TRNAK-CUU 107985605
## 24  TRNAK-CUU 107985760
## 25  TRNAG-CCC 107985600
## 26  TRNAG-CCC 107985603
## 27  TRNAG-CCC 107985604
## 28  TRNAG-CCC 107985607
## 29  TRNAG-CCC 107985748
## 30  TRNAG-CCC 107985759
## 31  TRNAG-CCC 107985600
## 32  TRNAG-CCC 107985603
## 33  TRNAG-CCC 107985604
## 34  TRNAG-CCC 107985607
## 35  TRNAG-CCC 107985748
## 36  TRNAG-CCC 107985759
## 37  TRNAG-CCC 107985600
## 38  TRNAG-CCC 107985603
## 39  TRNAG-CCC 107985604
## 40  TRNAG-CCC 107985607
## 41  TRNAG-CCC 107985748
## 42  TRNAG-CCC 107985759
## 43  TRNAG-CCC 107985600
## 44  TRNAG-CCC 107985603
## 45  TRNAG-CCC 107985604
## 46  TRNAG-CCC 107985607
## 47  TRNAG-CCC 107985748
## 48  TRNAG-CCC 107985759
## 49  TRNAG-CCC 107985600
## 50  TRNAG-CCC 107985603
## 51  TRNAG-CCC 107985604
## 52  TRNAG-CCC 107985607
## 53  TRNAG-CCC 107985748
## 54  TRNAG-CCC 107985759
## 55  TRNAN-GUU 107985601
## 56  TRNAN-GUU 107985609
## 57  TRNAN-GUU 107985610
## 58  TRNAN-GUU 107985611
## 59  TRNAN-GUU 107985613
## 60  TRNAN-GUU 107985617
## 61  TRNAN-GUU 107985621
## 62  TRNAN-GUU 107985622
## 63  TRNAN-GUU 107985624
## 64  TRNAN-GUU 107985625
## 65  TRNAN-GUU 107985750
## 66  TRNAN-GUU 107985751
## 67  TRNAN-GUU 107985752
## 68  TRNAN-GUU 107985754
## 69  TRNAN-GUU 107985756
## 70  TRNAN-GUU 107985757
## 71  TRNAN-GUU 107985762
## 72  TRNAN-GUU 107985763
## 73  TRNAN-GUU 107987367
## 74  TRNAN-GUU 107985601
## 75  TRNAN-GUU 107985609
## 76  TRNAN-GUU 107985610
## 77  TRNAN-GUU 107985611
## 78  TRNAN-GUU 107985613
## 79  TRNAN-GUU 107985617
## 80  TRNAN-GUU 107985621
## 81  TRNAN-GUU 107985622
## 82  TRNAN-GUU 107985624
## 83  TRNAN-GUU 107985625
## 84  TRNAN-GUU 107985750
## 85  TRNAN-GUU 107985751
## 86  TRNAN-GUU 107985752
## 87  TRNAN-GUU 107985754
## 88  TRNAN-GUU 107985756
## 89  TRNAN-GUU 107985757
## 90  TRNAN-GUU 107985762
## 91  TRNAN-GUU 107985763
## 92  TRNAN-GUU 107987367
## 93  TRNAN-GUU 107985601
## 94  TRNAN-GUU 107985609
## 95  TRNAN-GUU 107985610
## 96  TRNAN-GUU 107985611
## 97  TRNAN-GUU 107985613
## 98  TRNAN-GUU 107985617
## 99  TRNAN-GUU 107985621
## 100 TRNAN-GUU 107985622
## 101 TRNAN-GUU 107985624
## 102 TRNAN-GUU 107985625
## 103 TRNAN-GUU 107985750
## 104 TRNAN-GUU 107985751
## 105 TRNAN-GUU 107985752
## 106 TRNAN-GUU 107985754
## 107 TRNAN-GUU 107985756
## 108 TRNAN-GUU 107985757
## 109 TRNAN-GUU 107985762
## 110 TRNAN-GUU 107985763
## 111 TRNAN-GUU 107987367
## 112 TRNAN-GUU 107985601
## 113 TRNAN-GUU 107985609
## 114 TRNAN-GUU 107985610
## 115 TRNAN-GUU 107985611
## 116 TRNAN-GUU 107985613
## 117 TRNAN-GUU 107985617
## 118 TRNAN-GUU 107985621
## 119 TRNAN-GUU 107985622
## 120 TRNAN-GUU 107985624
## 121 TRNAN-GUU 107985625
## 122 TRNAN-GUU 107985750
## 123 TRNAN-GUU 107985751
## 124 TRNAN-GUU 107985752
## 125 TRNAN-GUU 107985754
## 126 TRNAN-GUU 107985756
## 127 TRNAN-GUU 107985757
## 128 TRNAN-GUU 107985762
## 129 TRNAN-GUU 107985763
## 130 TRNAN-GUU 107987367
## 131 TRNAN-GUU 107985601
## 132 TRNAN-GUU 107985609
## 133 TRNAN-GUU 107985610
## 134 TRNAN-GUU 107985611
## 135 TRNAN-GUU 107985613
## 136 TRNAN-GUU 107985617
## 137 TRNAN-GUU 107985621
## 138 TRNAN-GUU 107985622
## 139 TRNAN-GUU 107985624
## 140 TRNAN-GUU 107985625
## 141 TRNAN-GUU 107985750
## 142 TRNAN-GUU 107985751
## 143 TRNAN-GUU 107985752
## 144 TRNAN-GUU 107985754
## 145 TRNAN-GUU 107985756
## 146 TRNAN-GUU 107985757
## 147 TRNAN-GUU 107985762
## 148 TRNAN-GUU 107985763
## 149 TRNAN-GUU 107987367
## 150 TRNAN-GUU 107985601
## 151 TRNAN-GUU 107985609
## 152 TRNAN-GUU 107985610
## 153 TRNAN-GUU 107985611
## 154 TRNAN-GUU 107985613
## 155 TRNAN-GUU 107985617
## 156 TRNAN-GUU 107985621
## 157 TRNAN-GUU 107985622
## 158 TRNAN-GUU 107985624
## 159 TRNAN-GUU 107985625
## 160 TRNAN-GUU 107985750
## 161 TRNAN-GUU 107985751
## 162 TRNAN-GUU 107985752
## 163 TRNAN-GUU 107985754
## 164 TRNAN-GUU 107985756
## 165 TRNAN-GUU 107985757
## 166 TRNAN-GUU 107985762
## 167 TRNAN-GUU 107985763
## 168 TRNAN-GUU 107987367
## 169 TRNAN-GUU 107985601
## 170 TRNAN-GUU 107985609
## 171 TRNAN-GUU 107985610
## 172 TRNAN-GUU 107985611
## 173 TRNAN-GUU 107985613
## 174 TRNAN-GUU 107985617
## 175 TRNAN-GUU 107985621
## 176 TRNAN-GUU 107985622
## 177 TRNAN-GUU 107985624
## 178 TRNAN-GUU 107985625
## 179 TRNAN-GUU 107985750
## 180 TRNAN-GUU 107985751
## 181 TRNAN-GUU 107985752
## 182 TRNAN-GUU 107985754
## 183 TRNAN-GUU 107985756
## 184 TRNAN-GUU 107985757
## 185 TRNAN-GUU 107985762
## 186 TRNAN-GUU 107985763
## 187 TRNAN-GUU 107987367
## 188 TRNAN-GUU 107985601
## 189 TRNAN-GUU 107985609
## 190 TRNAN-GUU 107985610
## 191 TRNAN-GUU 107985611
## 192 TRNAN-GUU 107985613
## 193 TRNAN-GUU 107985617
## 194 TRNAN-GUU 107985621
## 195 TRNAN-GUU 107985622
## 196 TRNAN-GUU 107985624
## 197 TRNAN-GUU 107985625
## 198 TRNAN-GUU 107985750
## 199 TRNAN-GUU 107985751
## 200 TRNAN-GUU 107985752
## 201 TRNAN-GUU 107985754
## 202 TRNAN-GUU 107985756
## 203 TRNAN-GUU 107985757
## 204 TRNAN-GUU 107985762
## 205 TRNAN-GUU 107985763
## 206 TRNAN-GUU 107987367
## 207 TRNAN-GUU 107985601
## 208 TRNAN-GUU 107985609
## 209 TRNAN-GUU 107985610
## 210 TRNAN-GUU 107985611
## 211 TRNAN-GUU 107985613
## 212 TRNAN-GUU 107985617
## 213 TRNAN-GUU 107985621
## 214 TRNAN-GUU 107985622
## 215 TRNAN-GUU 107985624
## 216 TRNAN-GUU 107985625
## 217 TRNAN-GUU 107985750
## 218 TRNAN-GUU 107985751
## 219 TRNAN-GUU 107985752
## 220 TRNAN-GUU 107985754
## 221 TRNAN-GUU 107985756
## 222 TRNAN-GUU 107985757
## 223 TRNAN-GUU 107985762
## 224 TRNAN-GUU 107985763
## 225 TRNAN-GUU 107987367
## 226 TRNAN-GUU 107985601
## 227 TRNAN-GUU 107985609
## 228 TRNAN-GUU 107985610
## 229 TRNAN-GUU 107985611
## 230 TRNAN-GUU 107985613
## 231 TRNAN-GUU 107985617
## 232 TRNAN-GUU 107985621
## 233 TRNAN-GUU 107985622
## 234 TRNAN-GUU 107985624
## 235 TRNAN-GUU 107985625
## 236 TRNAN-GUU 107985750
## 237 TRNAN-GUU 107985751
## 238 TRNAN-GUU 107985752
## 239 TRNAN-GUU 107985754
## 240 TRNAN-GUU 107985756
## 241 TRNAN-GUU 107985757
## 242 TRNAN-GUU 107985762
## 243 TRNAN-GUU 107985763
## 244 TRNAN-GUU 107987367
## 245 TRNAN-GUU 107985601
## 246 TRNAN-GUU 107985609
## 247 TRNAN-GUU 107985610
## 248 TRNAN-GUU 107985611
## 249 TRNAN-GUU 107985613
## 250 TRNAN-GUU 107985617
## 251 TRNAN-GUU 107985621
## 252 TRNAN-GUU 107985622
## 253 TRNAN-GUU 107985624
## 254 TRNAN-GUU 107985625
## 255 TRNAN-GUU 107985750
## 256 TRNAN-GUU 107985751
## 257 TRNAN-GUU 107985752
## 258 TRNAN-GUU 107985754
## 259 TRNAN-GUU 107985756
## 260 TRNAN-GUU 107985757
## 261 TRNAN-GUU 107985762
## 262 TRNAN-GUU 107985763
## 263 TRNAN-GUU 107987367
## 264 TRNAN-GUU 107985601
## 265 TRNAN-GUU 107985609
## 266 TRNAN-GUU 107985610
## 267 TRNAN-GUU 107985611
## 268 TRNAN-GUU 107985613
## 269 TRNAN-GUU 107985617
## 270 TRNAN-GUU 107985621
## 271 TRNAN-GUU 107985622
## 272 TRNAN-GUU 107985624
## 273 TRNAN-GUU 107985625
## 274 TRNAN-GUU 107985750
## 275 TRNAN-GUU 107985751
## 276 TRNAN-GUU 107985752
## 277 TRNAN-GUU 107985754
## 278 TRNAN-GUU 107985756
## 279 TRNAN-GUU 107985757
## 280 TRNAN-GUU 107985762
## 281 TRNAN-GUU 107985763
## 282 TRNAN-GUU 107987367
## 283 TRNAN-GUU 107985601
## 284 TRNAN-GUU 107985609
## 285 TRNAN-GUU 107985610
## 286 TRNAN-GUU 107985611
## 287 TRNAN-GUU 107985613
## 288 TRNAN-GUU 107985617
## 289 TRNAN-GUU 107985621
## 290 TRNAN-GUU 107985622
## 291 TRNAN-GUU 107985624
## 292 TRNAN-GUU 107985625
## 293 TRNAN-GUU 107985750
## 294 TRNAN-GUU 107985751
## 295 TRNAN-GUU 107985752
## 296 TRNAN-GUU 107985754
## 297 TRNAN-GUU 107985756
## 298 TRNAN-GUU 107985757
## 299 TRNAN-GUU 107985762
## 300 TRNAN-GUU 107985763
## 301 TRNAN-GUU 107987367
## 302 TRNAN-GUU 107985601
## 303 TRNAN-GUU 107985609
## 304 TRNAN-GUU 107985610
## 305 TRNAN-GUU 107985611
## 306 TRNAN-GUU 107985613
## 307 TRNAN-GUU 107985617
## 308 TRNAN-GUU 107985621
## 309 TRNAN-GUU 107985622
## 310 TRNAN-GUU 107985624
## 311 TRNAN-GUU 107985625
## 312 TRNAN-GUU 107985750
## 313 TRNAN-GUU 107985751
## 314 TRNAN-GUU 107985752
## 315 TRNAN-GUU 107985754
## 316 TRNAN-GUU 107985756
## 317 TRNAN-GUU 107985757
## 318 TRNAN-GUU 107985762
## 319 TRNAN-GUU 107985763
## 320 TRNAN-GUU 107987367
## 321 TRNAN-GUU 107985601
## 322 TRNAN-GUU 107985609
## 323 TRNAN-GUU 107985610
## 324 TRNAN-GUU 107985611
## 325 TRNAN-GUU 107985613
## 326 TRNAN-GUU 107985617
## 327 TRNAN-GUU 107985621
## 328 TRNAN-GUU 107985622
## 329 TRNAN-GUU 107985624
## 330 TRNAN-GUU 107985625
## 331 TRNAN-GUU 107985750
## 332 TRNAN-GUU 107985751
## 333 TRNAN-GUU 107985752
## 334 TRNAN-GUU 107985754
## 335 TRNAN-GUU 107985756
## 336 TRNAN-GUU 107985757
## 337 TRNAN-GUU 107985762
## 338 TRNAN-GUU 107985763
## 339 TRNAN-GUU 107987367
## 340 TRNAN-GUU 107985601
## 341 TRNAN-GUU 107985609
## 342 TRNAN-GUU 107985610
## 343 TRNAN-GUU 107985611
## 344 TRNAN-GUU 107985613
## 345 TRNAN-GUU 107985617
## 346 TRNAN-GUU 107985621
## 347 TRNAN-GUU 107985622
## 348 TRNAN-GUU 107985624
## 349 TRNAN-GUU 107985625
## 350 TRNAN-GUU 107985750
## 351 TRNAN-GUU 107985751
## 352 TRNAN-GUU 107985752
## 353 TRNAN-GUU 107985754
## 354 TRNAN-GUU 107985756
## 355 TRNAN-GUU 107985757
## 356 TRNAN-GUU 107985762
## 357 TRNAN-GUU 107985763
## 358 TRNAN-GUU 107987367
## 359 TRNAN-GUU 107985601
## 360 TRNAN-GUU 107985609
## 361 TRNAN-GUU 107985610
## 362 TRNAN-GUU 107985611
## 363 TRNAN-GUU 107985613
## 364 TRNAN-GUU 107985617
## 365 TRNAN-GUU 107985621
## 366 TRNAN-GUU 107985622
## 367 TRNAN-GUU 107985624
## 368 TRNAN-GUU 107985625
## 369 TRNAN-GUU 107985750
## 370 TRNAN-GUU 107985751
## 371 TRNAN-GUU 107985752
## 372 TRNAN-GUU 107985754
## 373 TRNAN-GUU 107985756
## 374 TRNAN-GUU 107985757
## 375 TRNAN-GUU 107985762
## 376 TRNAN-GUU 107985763
## 377 TRNAN-GUU 107987367
## 378 TRNAN-GUU 107985601
## 379 TRNAN-GUU 107985609
## 380 TRNAN-GUU 107985610
## 381 TRNAN-GUU 107985611
## 382 TRNAN-GUU 107985613
## 383 TRNAN-GUU 107985617
## 384 TRNAN-GUU 107985621
## 385 TRNAN-GUU 107985622
## 386 TRNAN-GUU 107985624
## 387 TRNAN-GUU 107985625
## 388 TRNAN-GUU 107985750
## 389 TRNAN-GUU 107985751
## 390 TRNAN-GUU 107985752
## 391 TRNAN-GUU 107985754
## 392 TRNAN-GUU 107985756
## 393 TRNAN-GUU 107985757
## 394 TRNAN-GUU 107985762
## 395 TRNAN-GUU 107985763
## 396 TRNAN-GUU 107987367
## 397 TRNAE-UUC 107985602
## 398 TRNAE-UUC 107985623
## 399 TRNAE-UUC 107985626
## 400 TRNAE-UUC 107985758
## 401 TRNAE-UUC 107987368
## 402 TRNAE-UUC 107985602
## 403 TRNAE-UUC 107985623
## 404 TRNAE-UUC 107985626
## 405 TRNAE-UUC 107985758
## 406 TRNAE-UUC 107987368
## 407 TRNAE-UUC 107985602
## 408 TRNAE-UUC 107985623
## 409 TRNAE-UUC 107985626
## 410 TRNAE-UUC 107985758
## 411 TRNAE-UUC 107987368
## 412 TRNAE-UUC 107985602
## 413 TRNAE-UUC 107985623
## 414 TRNAE-UUC 107985626
## 415 TRNAE-UUC 107985758
## 416 TRNAE-UUC 107987368
## 417 TRNAC-GCA 107985606
## 418 TRNAC-GCA 107985761
## 419 TRNAV-CAC 107985608
## 420 TRNAV-CAC 107985612
## 421 TRNAV-CAC 107985614
## 422 TRNAV-CAC 107985615
## 423 TRNAV-CAC 107985749
## 424 TRNAV-CAC 107985753
## 425 TRNAV-CAC 107985608
## 426 TRNAV-CAC 107985612
## 427 TRNAV-CAC 107985614
## 428 TRNAV-CAC 107985615
## 429 TRNAV-CAC 107985749
## 430 TRNAV-CAC 107985753
## 431 TRNAV-CAC 107985608
## 432 TRNAV-CAC 107985612
## 433 TRNAV-CAC 107985614
## 434 TRNAV-CAC 107985615
## 435 TRNAV-CAC 107985749
## 436 TRNAV-CAC 107985753
## 437 TRNAV-CAC 107985608
## 438 TRNAV-CAC 107985612
## 439 TRNAV-CAC 107985614
## 440 TRNAV-CAC 107985615
## 441 TRNAV-CAC 107985749
## 442 TRNAV-CAC 107985753
## 443 TRNAV-CAC 107985608
## 444 TRNAV-CAC 107985612
## 445 TRNAV-CAC 107985614
## 446 TRNAV-CAC 107985615
## 447 TRNAV-CAC 107985749
## 448 TRNAV-CAC 107985753
## 449 TRNAQ-CUG 107985616
## 450 TRNAQ-CUG 107985755
## 451 TRNAG-GCC 107985618
## 452 TRNAG-GCC 107985619
## 453 TRNAG-GCC 107985620
## 454 TRNAG-GCC 107985618
## 455 TRNAG-GCC 107985619
## 456 TRNAG-GCC 107985620
## 457 TRNAI-AAU 107986679
## 458 TRNAI-AAU 107986683
## 459 TRNAM-CAU 107986680
## 460 TRNAM-CAU 107986682
## 461 TRNAL-CAA 107986681
## 462 TRNAL-CAA 107987402
## 463 TRNAL-CAA 107987430
## 464 TRNAL-CAA 107987450
## 465 TRNAL-CAA 107987455
## 466 TRNAL-CAA 107987460
## 467 TRNAL-CAA 107987523
## 468 TRNAL-CAA 107986681
## 469 TRNAL-CAA 107987402
## 470 TRNAL-CAA 107987430
## 471 TRNAL-CAA 107987450
## 472 TRNAL-CAA 107987455
## 473 TRNAL-CAA 107987460
## 474 TRNAL-CAA 107987523
## 475 TRNAL-CAA 107986681
## 476 TRNAL-CAA 107987402
## 477 TRNAL-CAA 107987430
## 478 TRNAL-CAA 107987450
## 479 TRNAL-CAA 107987455
## 480 TRNAL-CAA 107987460
## 481 TRNAL-CAA 107987523
## 482 TRNAL-CAA 107986681
## 483 TRNAL-CAA 107987402
## 484 TRNAL-CAA 107987430
## 485 TRNAL-CAA 107987450
## 486 TRNAL-CAA 107987455
## 487 TRNAL-CAA 107987460
## 488 TRNAL-CAA 107987523
## 489 TRNAL-CAA 107986681
## 490 TRNAL-CAA 107987402
## 491 TRNAL-CAA 107987430
## 492 TRNAL-CAA 107987450
## 493 TRNAL-CAA 107987455
## 494 TRNAL-CAA 107987460
## 495 TRNAL-CAA 107987523
## 496 TRNAL-CAA 107986681
## 497 TRNAL-CAA 107987402
## 498 TRNAL-CAA 107987430
## 499 TRNAL-CAA 107987450
## 500 TRNAL-CAA 107987455
## 501 TRNAL-CAA 107987460
## 502 TRNAL-CAA 107987523

Exercise 5:

So to retrieve this information using select you need to do it like this:

res1 <- select(TxDb.Hsapiens.UCSC.hg19.knownGene,
               keys(TxDb.Hsapiens.UCSC.hg19.knownGene, keytype="TXID"),
               columns=c("GENEID","TXNAME","TXCHROM"), keytype="TXID")

## 'select()' returned 1:1 mapping between keys and columns

head(res1)

##   TXID    GENEID     TXNAME TXCHROM
## 1    1 100287102 uc001aaa.3    chr1
## 2    2 100287102 uc010nxq.1    chr1
## 3    3 100287102 uc010nxr.1    chr1
## 4    4     79501 uc001aal.1    chr1
## 5    5      <NA> uc001aaq.2    chr1
## 6    6      <NA> uc001aar.2    chr1

And to do it using transcripts you do it like this:

res2 <- transcripts(TxDb.Hsapiens.UCSC.hg19.knownGene,
                    columns = c("gene_id","tx_name"))
head(res2)

## GRanges object with 6 ranges and 2 metadata columns:
##       seqnames           ranges strand |         gene_id     tx_name
##          <Rle>        <IRanges>  <Rle> | <CharacterList> <character>
##   [1]     chr1 [ 11874,  14409]      + |       100287102  uc001aaa.3
##   [2]     chr1 [ 11874,  14409]      + |       100287102  uc010nxq.1
##   [3]     chr1 [ 11874,  14409]      + |       100287102  uc010nxr.1
##   [4]     chr1 [ 69091,  70008]      + |           79501  uc001aal.1
##   [5]     chr1 [321084, 321115]      + |                  uc001aaq.2
##   [6]     chr1 [321146, 321207]      + |                  uc001aar.2
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

Notice that in the 2nd case we don’t have to ask for the chromosome, as transcripts() returns a GRanges object, so the chromosome will automatically be returned as part of the object.

Exercise 6:

res <- transcripts(TxDb.Athaliana.BioMart.plantsmart22, columns = c("gene_id"))

You will notice that the gene ids for this package are TAIR locus IDs and are NOT entrez gene IDs like what you saw in the TxDb.Hsapiens.UCSC.hg19.knownGene package. It’s important to always pay attention to the kind of gene id is being used by the TxDb you are looking at.

Exercise 7:

keys <- keys(Homo.sapiens, keytype="TXID")
res1 <- select(Homo.sapiens,
               keys= keys,
               columns=c("SYMBOL","TXSTART","TXCHROM"), keytype="TXID")

head(res1)

And to do it using transcripts you do it like this:

res2 <- transcripts(Homo.sapiens, columns="SYMBOL")

## 'select()' returned 1:1 mapping between keys and columns

head(res2)

## GRanges object with 6 ranges and 1 metadata column:
##       seqnames           ranges strand |          SYMBOL
##          <Rle>        <IRanges>  <Rle> | <CharacterList>
##   [1]     chr1 [ 11874,  14409]      + |         DDX11L1
##   [2]     chr1 [ 11874,  14409]      + |         DDX11L1
##   [3]     chr1 [ 11874,  14409]      + |         DDX11L1
##   [4]     chr1 [ 69091,  70008]      + |           OR4F5
##   [5]     chr1 [321084, 321115]      + |              NA
##   [6]     chr1 [321146, 321207]      + |              NA
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

Exercise 8:

columns(Homo.sapiens)

##  [1] "ACCNUM"       "ALIAS"        "CDSCHROM"     "CDSEND"       "CDSID"       
##  [6] "CDSNAME"      "CDSSTART"     "CDSSTRAND"    "DEFINITION"   "ENSEMBL"     
## [11] "ENSEMBLPROT"  "ENSEMBLTRANS" "ENTREZID"     "ENZYME"       "EVIDENCE"    
## [16] "EVIDENCEALL"  "EXONCHROM"    "EXONEND"      "EXONID"       "EXONNAME"    
## [21] "EXONRANK"     "EXONSTART"    "EXONSTRAND"   "GENEID"       "GENENAME"    
## [26] "GO"           "GOALL"        "GOID"         "IPI"          "MAP"         
## [31] "OMIM"         "ONTOLOGY"     "ONTOLOGYALL"  "PATH"         "PFAM"        
## [36] "PMID"         "PROSITE"      "REFSEQ"       "SYMBOL"       "TERM"        
## [41] "TXCHROM"      "TXEND"        "TXID"         "TXNAME"       "TXSTART"     
## [46] "TXSTRAND"     "TXTYPE"       "UCSCKG"       "UNIGENE"      "UNIPROT"

columns(org.Hs.eg.db)

##  [1] "ACCNUM"       "ALIAS"        "ENSEMBL"      "ENSEMBLPROT"  "ENSEMBLTRANS"
##  [6] "ENTREZID"     "ENZYME"       "EVIDENCE"     "EVIDENCEALL"  "GENENAME"    
## [11] "GO"           "GOALL"        "IPI"          "MAP"          "OMIM"        
## [16] "ONTOLOGY"     "ONTOLOGYALL"  "PATH"         "PFAM"         "PMID"        
## [21] "PROSITE"      "REFSEQ"       "SYMBOL"       "UCSCKG"       "UNIGENE"     
## [26] "UNIPROT"

columns(TxDb.Hsapiens.UCSC.hg19.knownGene)

##  [1] "CDSCHROM"   "CDSEND"     "CDSID"      "CDSNAME"    "CDSSTART"  
##  [6] "CDSSTRAND"  "EXONCHROM"  "EXONEND"    "EXONID"     "EXONNAME"  
## [11] "EXONRANK"   "EXONSTART"  "EXONSTRAND" "GENEID"     "TXCHROM"   
## [16] "TXEND"      "TXID"       "TXNAME"     "TXSTART"    "TXSTRAND"  
## [21] "TXTYPE"

## You might also want to look at this:
transcripts(Homo.sapiens, columns=c("SYMBOL","CHRLOC"))

## 'select()' returned 1:1 mapping between keys and columns

## GRanges object with 82960 ranges and 1 metadata column:
##                 seqnames           ranges strand |          SYMBOL
##                    <Rle>        <IRanges>  <Rle> | <CharacterList>
##       [1]           chr1 [ 11874,  14409]      + |         DDX11L1
##       [2]           chr1 [ 11874,  14409]      + |         DDX11L1
##       [3]           chr1 [ 11874,  14409]      + |         DDX11L1
##       [4]           chr1 [ 69091,  70008]      + |           OR4F5
##       [5]           chr1 [321084, 321115]      + |              NA
##       ...            ...              ...    ... .             ...
##   [82956] chrUn_gl000237   [    1,  2686]      - |              NA
##   [82957] chrUn_gl000241   [20433, 36875]      - |              NA
##   [82958] chrUn_gl000243   [11501, 11530]      + |              NA
##   [82959] chrUn_gl000243   [13608, 13637]      + |              NA
##   [82960] chrUn_gl000247   [ 5787,  5816]      - |              NA
##   -------
##   seqinfo: 93 sequences (1 circular) from hg19 genome

The key difference is that the TXSTART refers to the start of a transcript and originates in the TxDb object from the TxDb.Hsapiens.UCSC.hg19.knownGene package, while the CHRLOC refers to the same thing but originates in the OrgDb object from the org.Hs.eg.db package. The point of origin is significant because the TxDb object represents a transcriptome from UCSC and the OrgDb is primarily gene centric data that originates at NCBI. The upshot is that CHRLOC will not have as many regions represented as TXSTART, since there has to be an official gene for there to even be a record. The CHRLOC data is also locked in for org.Hs.eg.db as data for hg19, whereas you can swap in a different TxDb object to match the genome you are using to make it hg18 etc. For these reasons, we strongly recommend using TXSTART instead of CHRLOC. Howeverm CHRLOC still remains in the org packages for historical reasons.

Exercise 9:

To find the keys that match, make use of the pattern and column arguments.

xk = head(keys(Homo.sapiens, keytype="ENTREZID", pattern="X", column="SYMBOL"))

## 'select()' returned 1:1 mapping between keys and columns

xk

## [1] "51"  "179" "189" "239" "240" "241"

select verifies the results

select(Homo.sapiens, xk, "SYMBOL", "ENTREZID")

## 'select()' returned 1:1 mapping between keys and columns

##   ENTREZID  SYMBOL
## 1       51   ACOX1
## 2      179   AGMX2
## 3      189    AGXT
## 4      239  ALOX12
## 5      240   ALOX5
## 6      241 ALOX5AP

Exercise 10:

## Get the transcript ranges grouped by gene
txby <- transcriptsBy(Homo.sapiens, by="gene")
## look up the entrez ID for the gene symbol 'PTEN'
select(Homo.sapiens, keys='PTEN', columns='ENTREZID', keytype='SYMBOL')
## subset that genes transcripts
geneOfInterest <- txby[["5728"]]
## extract the sequence
res <- getSeq(Hsapiens, geneOfInterest)
res

Exercise 11:

ensembl <- useMart("ensembl",dataset="hsapiens_gene_ensembl")
ids=c("1")
getBM(attributes=c('go_id', 'entrezgene'),
            filters = 'entrezgene',
                    values = ids, mart = ensembl)

##         go_id entrezgene
## 1                      1
## 2  GO:0005576          1
## 3  GO:0005615          1
## 4  GO:0003674          1
## 5  GO:0008150          1
## 6  GO:0070062          1
## 7  GO:0072562          1
## 8  GO:0043312          1
## 9  GO:0002576          1
## 10 GO:0034774          1
## 11 GO:1904813          1
## 12 GO:0031093          1

Exercise 12:

ids=c("1")
select(org.Hs.eg.db, keys=ids, columns="GO", keytype="ENTREZID")

## 'select()' returned 1:many mapping between keys and columns

##    ENTREZID         GO EVIDENCE ONTOLOGY
## 1         1 GO:0002576      TAS       BP
## 2         1 GO:0003674       ND       MF
## 3         1 GO:0005576      IDA       CC
## 4         1 GO:0005576      TAS       CC
## 5         1 GO:0005615      IDA       CC
## 6         1 GO:0008150       ND       BP
## 7         1 GO:0031093      TAS       CC
## 8         1 GO:0034774      TAS       CC
## 9         1 GO:0043312      TAS       BP
## 10        1 GO:0070062      IDA       CC
## 11        1 GO:0072562      IDA       CC
## 12        1 GO:1904813      TAS       CC

When this exercise was written, there was a different number of GO terms returned from biomaRt than from org.Hs.eg.db. This may not always be true in the future though as both of these resources are updated. It is expected however that this web service, (which is updated continuously) will fall in and out of sync with the org.Hs.eg.db package (which is updated twice a year). This is an important difference as each approach has different advantages and disadvantages. The advantage to updating continuously is that you always have the very latest annotations which are frequently different for something like GO terms. The advantage to using a package is that the results are frozen to a release of Bioconductor. And this can help you to get the same answers that you get today (reproducibility), a few years from now.

[ Back to top ]