view_strain_collection_keys: View of strain collection keyfile

In EricEdwardBryant/rothfreezer: Freezer database for the Rothstein Lab

Description

This view adds strain names and gene IDs from the strains table to the strain collection key.

Usage

view_strain_collection_keys(src = src_rothfreezer())

Arguments

src	A connection to the rothfreezer database.

Value

Returns a tbl_sqlite query, which can be further manipulated with dplyr verbs such as filter, and mutate. To execute your query and return a dataframe, use collect. This view has the following fields:

strain_collection_id (chr)	ID of strain collection. See the strain_collection_info table for a description of the collection
strain_id (chr)	ID of strain. See the strains table for more information about the strain
strain_name (chr)	Strain name (not necessarily unique).
gene_id (chr)	Gene ID (may cantain multiple gene IDs separated by "|").
plate (int)	Plate number.
row (int)	Row numbr.
column (int)	Column number.
plate_control (lgl)	Is this strain a plate control in this collection?

Examples

## Not run: 

rad52 <- 
  view_strain_collection_keys() %>%
  filter(strain_name == 'rad52') %>%
  collect

## End(Not run)

EricEdwardBryant/rothfreezer documentation built on Nov. 27, 2020, 11:02 a.m.