Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  • Prep_type_id from sample_prep (ID for the following prep types: ApeKI, PstI, EcoT22I, PstI/EcoT22I)
  • Grouping_id from sample_prep sorted Ascending (library prep barcode)
  • Project.name from SampleInfo (Project, I don't don’t use)
  • Plate_label from SampleInfo (DNA plate name)
  • Plate_label from grouping (Library plate name)
  • Grouping_id from SampleInfo (DNA plate barcode)
  • Bc_grouping_id from LibraryPlatesWithBarcodeInfo (Adapter plate barcode)
  • Destroy_date from grouping is Null

...

  • Approval_Status from submission (shows if I've I’ve approved it from the website)
  • Grouping_id from sample_dna (DNA barcode)
  • Plate_label from grouping (DNA plate name)
  • tag from grouping (not used right now, but can add tags to plates, for a while we had plate name here)
  • submission_date from submission
  • submission_id from submission (shows on website)
  • Destroy_date from grouping (if filled in then ignore entry)

...

  • Grouping_id from sample_prep (Library barcode)
  • Name from flowcell (Flowcell name)
  • Lane_name from lane
  • Lane_id from lane
  • Plate_label from grouping (Library name)
  • Destroy_date from grouping (checks to make sure I don't don’t have destroyed plates assigned to flowcell lanes)

...

I also have the following which I've I’ve used, but I don't don’t know how much I need them.

...

KeyFileName- returned a spreadsheet similar to the "key file" “key file” they generate