| AnnotationDb-objects {AnnotationDbi} | R Documentation |
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, cols 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 and GODb.
cols 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 and cols and keytype
arguments.
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.
cols(x) keytypes(x) select(x, keys, cols, keytype, ...) saveDb(x, file) loadDb(file, dbType, dbPackage, ...)
x |
the |
keys |
the keys to select records for from the database. All possible
keys are returned by using the |
cols |
the cols or kinds of things that can be retrieved from the
database. As with |
keytype |
the keytype that matches the keys used. For the
|
file |
an |
dbType |
dbType - not required |
dbPackage |
dbPackage - not required |
... |
other arguments |
keys,cols and keytypes each return a character
vector or possible values. select returns a data.frame.
Marc Carlson
keys,
dbConnect,
dbListTables,
dbListFields,
dbGetQuery,
Bimap
require(hgu95av2.db)
## display the cols
cols(hgu95av2.db)
## get the 1st 6 possible keys
keys <- head( keys(hgu95av2.db) )
keys
## lookup gene symbol and unigene ID for the 1st 6 keys
select(hgu95av2.db, keys=keys, cols = c("SYMBOL","UNIGENE"))
## get keys based on unigene
keyunis <- head( keys(hgu95av2.db, keytype="UNIGENE") )
keyunis
## list supported key types
keytypes(hgu95av2.db)
## lookup gene symbol and unigene ID based on unigene IDs by setting
## the keytype to "UNIGENE" and passing in unigene keys:
select(hgu95av2.db, keys=keyunis, cols = c("SYMBOL","UNIGENE"),
keytype="UNIGENE")