Skip to content
No description, website, or topics provided.
Python
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Google_sheet_to_benchling.py
LICENSE
MatreyekLab_Primer_Inventory.xlsx
Matreyeklab_primers_benchling.csv
README.md

README.md

Primer_Inventory_To_Benchling

Here's a Python script that converts the MatreyekLab primer google sheet into a csv file that is easily imported into benchling.

  1. Go to the lab primer inventory google sheet -> "https://docs.google.com/spreadsheets/d/15RD_WrP_xZXN34KhymHYkKeOglDYzfkhz5-x2PMkPo0/edit?usp=sharing"

  2. Go to file -> download -> Microsoft Excel (.xlsx)

  3. Then take above file (MatreyekLab_Primer_Inventory.xlsx) and put it in the same directory as the Google_sheet_to_benchling.py file.

  4. Open terminal, go to the right directory, and then enter:

Python3 Google_sheet_to_benchling.py

  1. It should make a new file called "Matreyeklab_primers_benchling.csv". The text in this file can be copy-pasted into benchling and imported into the "Primer" folder.

Uploading the list to Benchling

  1. Next, Log onto Benchling, go into the "MatreyekLab" project and into the "O_Primers" folder. Make a new folder named with the date (eg. "20200130" for January 30th, 2020). Once in the folder, select "Import Oligos", and copy-paste the contents of the csv file (Opened using a basic text editor like "TextEdit" or "Sublime Text 3".

  2. You'll have to scroll down all the way to the bottom, but then you can hit insert. Benchling is nice enough to get back to work as it uploads.

Using the new primer list

  1. Once it does finishes uploading, you can go to whatever plasmid map you want to annotate with our current primers. Go to the right-hand side, two icons down to "Primers". Hit attach existing, add the new folder as the new location, and hit "find binding sites". Select all of the primers (top check box), and then hit the "Attach Selected Primers" button in the top right.

  2. Now click on hte sequence map tab and Voila!, you can see the plasmid map now annotated. Find the primer you want (sequencing or otherwise) and go do some science.

You can’t perform that action at this time.