Get column descriptions for the GEOmetadb database

Description

Searching the GEOmetadb database requires a bit of knowledge about the structure of the database and column descriptions. This function returns those column descriptions for all columns in all tables in the database.

Usage

1
columnDescriptions(sqlite_db_name='GEOmetadb.sqlite')

Arguments

sqlite_db_name

The filename of the GEOmetadb sqlite database file

Value

A three-column data.frame including TableName, FieldName, and Description.

Author(s)

Sean Davis <sdavis2@mail.nih.gov>

References

http://meltzerlab.nci.nih.gov/apps/geo

Examples

1
2
3
4
5
6
if(file.exists('GEOmetadb.sqlite')) {
  columnDescriptions()[1:5,]
} else {
  print("You will need to usethe getSQLiteFile() function to get a copy
of the SQLite database file before this example will work")
}