How should I model CRISPR tracking in my LIMS system

[mathspete]

See below how we model CRIPSR production in iMITS

This data model allows you to track

1. Single and multiple CRISPR injections.
2. Single and multiple Oligo injections.
3. Injections using targeting Vector donors.
4. Injection that target multiple genes.
5. Production of multiple F1 colonies whilst also allowing their allele to be independently characterised. This allows a single micro-injection to produce multiple F1 colonies with different alleles as well as a single colony that has mutant alleles for multiple genes.

This copes this most situations I can think of, but would struggle with multiple mutations appearing in different exons on a single gene.

CRISPR database structure.pptx