colDescriptions: Get column descriptions of SRAmetadb.sqlite

Description Usage Arguments Value Author(s) Examples

Description

Get column descriptions of SRAmetadb.sqlite, including table, field, field data type, description and default values

Usage

1
colDescriptions( sra_con ) 

Arguments

sra_con

Connection of the SRAmetadb SQLite database

Value

A seven-column data.frame including table_name, field_name, type, description, value_list.

Author(s)

Jack Zhu<zhujack@mail.nih.gov> and Sean Davis <sdavis2@mail.nih.gov>

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
if(file.exists('SRAmetadb.sqlite')) {
  
  library(SRAdb)
  sra_dbname <- 'SRAmetadb.sqlite'	
  sra_con <- dbConnect(dbDriver("SQLite"), sra_dbname)
  
  ## Get column descriptions
  a <- colDescriptions(sra_con=sra_con)[1:5,]

} else {
  print("use getSRAdbFile() to get a copy of the SRAmetadb.sqlite file and then rerun the example")
}

seandavi/SRAdb documentation built on May 29, 2019, 4:33 p.m.