DECIPHER (version 1.12.0)

BrowseDB: View A Database Table In A Web Browser

Description

Opens an html file in a web browser to show the contents of a table in a database.

Usage

BrowseDB(dbFile, htmlFile = paste(tempdir(), "/db.html", sep = ""), tblName = "DNA", identifier = "", limit = -1, orderBy = "row_names", maxChars = 50, clause="")

Arguments

dbFile

A SQLite connection object or a character string specifying the path to the database file.

htmlFile

Character string giving the location where the html file should be written.

tblName

Character string specifying the table to view.

identifier

Optional character string used to narrow the search results to those matching a specific identifier. If "" then all identifiers are selected.

limit

Number of results to display. The default (-1) does not limit the number of results.

orderBy

Character string giving the column name for sorting the results. Defaults to the order of entries in the database. Optionally can be followed by " ASC" or " DESC" to specify ascending (the default) or descending order.

maxChars

Maximum number of characters to display in each column.

clause

An optional character string to append to the query as a clause.

Value

Creates an html table containing all the fields of the database table and opens it in the web browser for easy viewing.Returns htmlFile if the html file was written successfully.

See Also

BrowseSequences

Examples

db <- system.file("extdata", "Bacteria_175seqs.sqlite", package="DECIPHER")
BrowseDB(db)