Description Usage Arguments Value Author(s) See Also Examples
AnnotationDb
is the virtual base class for all annotation
packages. It contain a database connection and is meant to be the
parent for a set of classes in the Bioconductor annotation
packages. These classes will provide a means of dispatch for a
widely available set of select
methods and thus allow the
easy extraction of data from the annotation packages.
select
, columns
and keys
are used together to
extract data from an AnnotationDb
object (or any object derived
from the parent class). Examples of classes derived from the
AnnotationDb
object include (but are not limited to):
ChipDb
, OrgDb
GODb
, OrthologyDb
and
ReactomeDb
.
columns
shows which kinds of data can be returned for the
AnnotationDb
object.
keytypes
allows the user to discover which keytypes can be
passed in to select
or keys
and the keytype
argument.
keys
returns keys for the database contained in the
AnnotationDb
object . This method is already documented in the
keys manual page but is mentioned again here because it's usage with
select
is so intimate. By default it will return the primary
keys for the database, but if used with the keytype
argument,
it will return the keys from that keytype.
select
will retrieve the data as a data.frame based on
parameters for selected keys
columns
and keytype
arguments. Users should be warned that if you call select
and request
columns that have multiple matches for your keys, select will return a
data.frame with one row for each possible match. This has the effect that if
you request multiple columns and some of them have a many to one relationship
to the keys, things will continue to multiply accordingly. So it's not a good
idea to request a large number of columns unless you know that what you are
asking for should have a one to one relationship with the initial set of keys.
In general, if you need to retrieve a column (like GO) that has a many to one
relationship to the original keys, it is most useful to extract that
separately.
mapIds
gets the mapped ids (column) for a set of keys that are of a
particular keytype. Usually returned as a named character vector.
saveDb
will take an AnnotationDb object and save the database
to the file specified by the path passed in to the file
argument.
loadDb
takes a .sqlite database file as an argument and uses
data in the metadata table of that file to return an AnnotationDb
style object of the appropriate type.
species
shows the genus and species label currently attached to
the AnnotationDb
objects database.
dbfile
gets the database file associated with an object.
dbconn
gets the datebase connection associated with an object.
taxonomyId
gets the taxonomy ID associated with an object (if available).
1 2 3 4 5 6 7 |
x |
the |
keys |
the keys to select records for from the database. All possible
keys are returned by using the |
columns |
the columns or kinds of things that can be retrieved
from the database. As with |
keytype |
the keytype that matches the keys used. For the
|
column |
the column to search on (for |
... |
other arguments. These include:
|
multiVals |
What should
|
file |
an |
packageName |
for internal use only |
keys
,columns
and keytypes
each return a character
vector or possible values. select
returns a data.frame.
Marc Carlson
keys
,
dbConnect
,
dbListTables
,
dbListFields
,
dbGetQuery
,
Bimap
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | require(hgu95av2.db)
## display the columns
columns(hgu95av2.db)
## get the 1st 6 possible keys
keys <- head( keys(hgu95av2.db) )
keys
## lookup gene symbol and gene type for the 1st 6 keys
select(hgu95av2.db, keys=keys, columns = c("SYMBOL","GENETYPE"))
## get keys based on RefSeq
keyref <- head( keys(hgu95av2.db, keytype="REFSEQ") )
keyref
## list supported key types
keytypes(hgu95av2.db)
## lookup gene symbol and refseq ID based on refseq IDs by setting
## the keytype to "REFSEQ" and passing in refseq keys:
select(hgu95av2.db, keys=keyref, columns = c("SYMBOL","REFSEQ"),
keytype="REFSEQ")
keys <- head(keys(hgu95av2.db, 'ENTREZID'))
## get a default result (captures only the 1st element)
mapIds(hgu95av2.db, keys=keys, column='ALIAS', keytype='ENTREZID')
## or use a different option
mapIds(hgu95av2.db, keys=keys, column='ALIAS', keytype='ENTREZID',
multiVals="CharacterList")
## Or define your own function
last <- function(x){x[[length(x)]]}
mapIds(hgu95av2.db, keys=keys, column='ALIAS', keytype='ENTREZID',
multiVals=last)
## For other ways to access the DB, you can use dbfile() or dbconn() to extract
dbconn(hgu95av2.db)
dbfile(hgu95av2.db)
## Try to retrieve an associated taxonomyId
taxonomyId(hgu95av2.db)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.