Lab Resources Bulk Load

Add TT References

This adds the TargetTrack reference to the ORF's Database References field.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Add TT References.
  3. Set the values in 'Add TT References' popup.
    • Labfund is a drop-down list of various sources of funding maintained by the lab master.
  4. Click OK.

Note

Load ORFs From CSV File

This adds ORFs to Sesame.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Load ORFs from CSV File.
  3. Set the values in 'Load ORF CSV File' popup.
    • File Name is the name of the ORF CSV file to be loaded. To set it, click on the field, then set the values in the 'Select File' popup.
      • In the Look in list, click the drive or folder that contains the file you want to load.
      • In the folder list, locate the folder that contains the file, and open it.
      • Click the file to load.
      • Click Select File.
    • Lab Visible Only is a checkbox that sets the uploaded ORFs as private, i.e. visible only to the members of the lab that uploaded them.
    • TT Target Rationale is the TargetTrack Target Rationale, that will be attached to all the ORFs in the file to be uploaded.
  4. Click Load.

Note

Bulk Update ORFs

This updates ORFs in Sesame, a field a time.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Load ORFs from CSV File.
  3. Set the values in 'Load ORF CSV File' popup.
    • File Name is the name of the ORF CSV file to be loaded. To set it, click on the field, then set the values in the 'Select File' popup.
      • In the Look in list, click the drive or folder that contains the file you want to load.
      • In the folder list, locate the folder that contains the file, and open it.
      • Click the file to load.
      • Click Select File.
    • Field Name is the list of the ORF fields that can be bulk updated.
  4. Click Load.

Note

CrystalFarm

This uploads descriptions of screens used in the CrystalFarm crystallization screening instrument or in electron microscopes (EMs).

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click CrystalFarm.
    • Database Host is ToDo
    • Database Port is ToDo
    • Database Name is ToDo
    • Database Username is a Username for accessing the instrument database.
    • Database Password is a password for accessing the instrument database.
    • Screen Type is a dropdown list of choices, currently 'Screen' (crystal) or 'EM Screen'.
    • Screen No List is ToDo
    • Base Path is ToDo
  3. Click Load.

Note

Load SDF Data

This... ToDo

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Load SDF Data.

Note

Verify ORFs From CSV File

This checks if the format of the file is correct for Bulk Load ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify Bulk Load ORFs.
  3. Set the values in 'Verify Bulk Load ORFs' popup.
    • File Name is the name of the CSV file to be verified for bulk upload. To set it, click on the field, then set the values in the 'Select File' popup.
      • In the Look in list, click the drive or folder that contains the file you want to load.
      • In the folder list, locate the folder that contains the file, and open it.
      • Click the file to verify.
      • Click Select File.
    • Lab Visible Only is irrelevant for the verification process.
    • TT Target Rationale is irrelevant for the verification process.
  4. Click Verify.

Note

Verify Bulk Update ORFs

This checks if the format of the file is correct for Bulk Update ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify Bulk Update ORFs.
  3. Set the values in 'Verify Bulk Update ORFs' popup.
    • File Name is the name of the CSV file to be verified for bulk update. To set it, click on the field, then set the values in the 'Select File' popup.
      • In the Look in list, click the drive or folder that contains the file you want to load.
      • In the folder list, locate the folder that contains the file, and open it.
      • Click the file to load.
      • Click Select File.
    • Field Name is the list of the ORF fields that can be bulk updated.
  4. Click Verify.

Note

AttachScores

This adds new scores (e.g., the Target Scores" that CESG uses to rank targets) to the ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Attach Scores.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Load Scores File.

Note

Verify DB References

This checks if the format of the file and the columns is correct.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify DB References.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Verify DB References File.

Note

Attach DB References

This adds DB references to ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Attach DB References.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Load DB References File.

Note

Verify ORF Modifications

This checks if the format of the file and the columns is correct, and checks if the ORF Modifications are from the ORF Modification Lab Resource.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify ORF Modifications.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Verify ORF Modifications File.

Note

Attach ORF Modifications

This adds ORF modification descriptions to ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Attach ORF Modifications.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Load ORF Modifications File.

Note

Verify Nof Transmembrane Segments

This checks if the format of the file and the columns is correct.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify Nof Transmembrane Segments.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Verify Nof Transmembrane Segments File.

Note

Attach Nof Transmembrane Segments

This adds the Number of Transmembrane Segments to the ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Attach Nof Transmembrane Segments.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Load Nof Transmembrane Segments File.

Note

Verify Signal Peptide Lengths

This checks if the format of the file and the columns is correct.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Verify Signal Peptide Lengths.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Verify Signal Peptide Lengths File.

Note

Attach Signal Peptide Lengths

This adds the Signal Peptide Lengths to the ORFs.

  1. Make the Lab Bulk Load window active in the Board.
  2. On the Bulk Load menu click Attach Signal Peptide Lengths.
  3. In the folder list, locate and open the folder that contains the file.
  4. Click the file, and then click Load Signal Peptide Lengths File.

Note

See also