view_strain_collection_keys: View of strain collection keyfile

Description Usage Arguments Value Examples

View source: R/views.R

Description

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

Usage

1

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

1
2
3
4
5
6
7
8
## Not run: 

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

## End(Not run)

EricEdwardBryant/rothfreezer documentation built on Nov. 7, 2018, 2:57 a.m.