Feb 11, 2022

Public workspaceMultisite Gateway Calculations: Excel spreadsheet

  • 1University of Colorado School of Medicine, Anschutz Medical Campus
Icon indicating open access to content
QR code linking to this content
Document CitationChristian Mosimann 2022. Multisite Gateway Calculations: Excel spreadsheet. protocols.io https://dx.doi.org/10.17504/protocols.io.b4xdqxi6
License: This is an open access document distributed under the terms of the Creative Commons Attribution License,  which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited
Created: February 11, 2022
Last Modified: February 11, 2022
Document Integer ID: 58053
Keywords: Cloning, Multisite Gateway, Gateway, Entry Vectors, Transgenes, Vectors, Plasmids, Calculations, Excel Spreadsheet, low-tech
Disclaimer
DISCLAIMER – FOR INFORMATIONAL PURPOSES ONLY; USE AT YOUR OWN RISK

The protocol content here is for informational purposes only and does not constitute legal, medical, clinical, or safety advice, or otherwise; content added to protocols.io is not peer reviewed and may not have undergone a formal approval of any kind. Information presented in this protocol should not substitute for independent professional judgment, advice, diagnosis, or treatment. Any action you take or refrain from taking using or relying upon the information presented here is strictly at your own risk. You agree that neither the Company nor any of the authors, contributors, administrators, or anyone else associated with protocols.io, can be held responsible for your use of the information contained in or linked to this protocol or any of our Sites/Apps and Services.
Abstract
Multisite Gateway cloning provides a modular tool to assemble plasmid vectors suitable for numerous applications. The assembly of Multisite Gateway plasmids requires the correct ratios of three entry vectors and the destination backbone to favor correct recombination by Gateway LR Clonase II Plus. While simple, the calculation of recombination mixes is a reoccurring task when using Multisite Gateway that benefits from automation and proper documentation. This protocol provides a simple Excel-based spreadsheet to simplify the involved calculations based on providing individual vector lengths and working stock concentrations. Using this Multisite Gateway calculations spreadsheet supports correct reaction mix assembly, scaling of cloning reactions, cloning documentation, and troubleshooting.
Multisite Gateway calculations using a simple Excel spreadsheet

Christian Mosimann*
Department of Pediatrics, Section of Developmental Biology, University of Colorado School of Medicine, Anschutz Medical Campus, Aurora, CO, USA
* correspondence to: christian.mosimann@cuanschutz.edu


Multisite Gateway (1) is a widely used cloning method based on the widespread availability of individual component vectors through repositories such as AddGene (www.addgene.org) and a multitude of published plasmids from individual laboratories or organizations working on diverse models. For zebrafish, in particular the Tol2 Kit vectors for transgenesis have introduced a multitude of zebrafish labs to Gateway cloning, stimulating vector exchange and simple, modular assembly of new transgenesis tools (2).

Based on the recombination reaction catalyzed by Gateway LR Clonase II Plus, Multisite Gateway cloning incorporates Entry vectors with inserts flanked by dedicated repeats (commonly called Gateway repeats) into a final Destination vector. In their most-applied form, such multi-vector assemblies consist of 1) a 5' entry vector harboring a gene-regulatory element or promoter; 2) a middle entry vector harboring an ORF encoding a fluorescent protein or other factors of interest; 3) a 3' vector harboring a polyadenylation signal in a untranslated trailed sequence; and 4) a Destination backbone with suitable elements for transgenesis, bacterial selection, and more. A multitude of modular assemblies are possible beyond such basic expression constructs.

The successful assembly by recombination of all these four plasmids requires a well-balanced ratio of the individual parts in the reaction: standard reactions combine 10 femtomole (fmol) of each Entry vector with 20 fmol of the Destination backbone vector together with LR Clonase II Plus in a 10 microliter (μl) reaction volume. This reaction is incubated for 16+ hours at 25 degrees Celsius before short Proteinase K treatment and subsequent transformation into suitable competent bacteria for selection and propagation (as per manufacturer's protocol in Ref. 1). The original manufacturer's protocol describes 10 μl reactions, yet scaling down to 5 μl reactions has proven practical and economical (3,4).

While seemingly mundane, a common challenge in assembling Multisite Gateway reactions is the proper calculation of equal fmol amounts of each involved vector in the reaction tube. While the involved calculations are simple, having a means to rapidly calculate reaction mixes a) provides an additional safeguard against calculation errors; b) enables scaling up of reaction mix calculations to tackle several clonings at once; c) document the involved calculations for trouble-shooting, lab book documentation, and publications.

The final goal is to assemble a 5 μl reaction consisting of 4 μl total solution containing all four vectors in ddH2O plus 1 μ of LR Clonase II Plus.
Assuming the classic 660 g/mol for a DNA base pair, the calculations to achieve a final 10 fmol amount per vector in a 5 μl Multisite Gateway reaction is:

1. [total length of vector] bp x 10 fmol x (660/10^6) = [total vector amount] ng
2. ([total vector amount] ng / [concentration vector stock] ng/μl) / 2 (for 5 μl half-reactions) = μl for 10 fmol

To reach a total of 4 μl final vector solution, calculate:
3. 4 μl - ([volume 5' vector 1] + volume middle vector] + [volume 3' vector] + [volume backbone vector])
= μl ddH2O to reach 4 μl reaction mix before adding LR Clonase II Plus

These simple, yet repetitive calculations are combined here in an Excel-based spreadsheet that includes annotation fields to keep track of used vectors. The spreadsheet has pre-formatted calculation sections for two assemblies, and can easily be expanded by copy/paste to accommodate more. We have been using this spreadsheet since 2008 to reproducibly assemble Multisite Gateway vectors for zebrafish transgenesis (3,4). Rounding of the calculated numbers depends on individual Excel settings and, at the bench, should be assumed within practical reason for pipetting.

Saving a dedicated spreadsheet for each newly assembled vector or vector group is recommended as best practice, and to additionally document so in your personal lab book (hard copy or digital). In the lab, we commonly print the spreadsheet calculations for documentation purposes.

Figure 1: Multisite Gateway Cloning Spread Sheet to calculate cloning reactions involving all necessary vectors at correct concentrations, final water volume, and enzyme.

The Multisite Gateway Calculation sheet is used as follows in a cloning workflow:

  1. Fill in individual vector names in column B
  2. Fill in individual total vector size in base pairs in column C
  3. Fill in individual vector stock concentrations in column I
  4. Double-check pipetting volumes are practical (i.e. not below 0.2 μl; working stocks 20-60 ng/μl)
  5. Add 1 μl LR Clonase II Plus as last step (vortexed 2x for 2 sec), mix by flicking followed by quick spin
  6. Incubate reactions at 25 degrees Celsius for 16 h+


General Multisite Gateway tips:
  • Use clean minipreps, verified by 260/230 nm and 260/280 nm measurements; avoid kit elution buffers
  • Use ddH2O to make working stocks for gateway
  • Always use clean, fresh ddH2O or TE
  • Always vortex the Clonase 2x for 2 seconds to properly mix the stock (crucial)
  • Mix the reaction once assembled
  • Do not use too concentrated vector stock solution, working stocks in the range of 20-60 ng/μl work well


Download the spreadsheet here:
Download MultisiteGateway Calculations v1 Feb2022.xlsxMultisiteGateway Calculations v1 Feb2022.xlsx

Taken together, this simple spreadsheet facilitates the reproducible and documented assembly of Multisite Gateway reactions with three entry vectors and their targeted destination vector.



References:

2. Kwan KM, Fujimoto E, Grabher C, Mangum BD, Hardy ME, Campbell DS, Parant JM, Yost HJ, Kanki JP, Chien CB. The Tol2kit: a multisite gateway-based construction kit for Tol2 transposon transgenesis constructs. Dev Dyn. 2007 Nov;236(11):3088-99. doi: 10.1002/dvdy.21343. PMID: 17937395.

3. Mosimann C, Kaufman CK, Li P, Pugach EK, Tamplin OJ, Zon LI. Ubiquitous transgene expression and Cre-based recombination driven by the ubiquitin promoter in zebrafish. Development. 2011 Jan;138(1):169-77. doi: 10.1242/dev.059345. PMID: 21138979; PMCID: PMC2998170.

4. Felker A, Mosimann C. Contemporary zebrafish transgenesis with Tol2 and application for Cre/lox recombination experiments. Methods Cell Biol. 2016;135:219-44. doi: 10.1016/bs.mcb.2016.01.009. Epub 2016 Feb 26. PMID: 27443928.