readDfSQL: readDfSQL

In serratus-bio/tantalus: R Data Exploration for Serratus

readDfSQL

Description

Read SQL data into data frame

Usage

readDfSQL(
  dbs,
  table,
  columns = NULL,
  family = NULL,
  acc = NULL,
  sras = NULL,
  dataframe = F,
  score = NULL,
  pctid = NULL
)

Arguments

dbs	Database object (SQL)
table	Table in the database
columns	character vector of columns to return. NULL returns all [Default]
family	character, if specified return only matching "family_name"
acc	character, if specified return only matching virus accession "top_genbank_id"
sras	character, return only specified accessions
dataframe	boolean, if T, convert the output to dataframe
score	character, return only score greater than threshold
pctid	character, return only percent_identity greater than threshold

Value

data frame

serratus-bio/tantalus documentation built on March 29, 2023, 9:39 p.m.