Read a SQLite database into a list

This function will read a scrattch SQLite database into memory as a list.

db_to_list(
  db.file,
  get_tables = NULL,
  genes = NULL,
  group_by = NULL,
  groups = NULL
)

Arguments

db.file

- a character object specifying the location of the database

genes

- a character object with a list of genes to retrieve. NULL retrieves all genes. default = NULL

group_by

- a character object with the base of the annotation column to filter on if only specific groups should be selected. NULL retrieves all groups. default = NULL

groups

- a numeric object with the group indexes to be selected. NULL retrieves all groups. default = NULL

Value

A list object containing data.frames for each table in the database, filtered according to genes, group_by, and groups if provided.

Details

Each table (desc, anno, and data) will be a data frame within the list.