In this step we import two different, but related, data tables to the Lab Workflow tutorial folder you just created:
  • Plasma sample inventory: a spreadsheet that describes different vials of plasma.
  • Assay result data: a spreadsheet that holds the experimental results of assaying the plasma.
These tables are connected by the fact that the assay data describes properties of the plasma in the vials. We will capture this relationship in the next step when we link these two tables together using a LabKey Server device called a lookup. In the current step, we will simply import these tables to the server.

Add Sample Type - Plasma

We will import information about the individual sample vials, such as the tissues stored and the barcode of each vial, like the table shown below.

Sample Type - Plasma

NameSample TypeFlagStatusLocationId
vl-100Plasma Receivedi-123456
vl-200PlasmaFlagged for reviewResults Invalidi-123457
vl-300Plasma Job Assignedi-123458
vl-400Plasma In Transiti-123459
vl-500Plasma Contaminatedi-123460
vl-600Plasma Preservedi-123461
vl-700Plasma Results Verifiedi-123462

  • Download the sample file Plasma.xlsx from this page.
  • Click the Vials tab.
  • On the Sample Types panel, click New Sample Type.
  • Provide the Name: "Plasma"
  • You do not need to provide a Naming Pattern since the data already contains a unique identifier in a "Name" column.
  • You don't need to add a description or parent column import alias.
  • Click the Fields panel to open it.
  • Click Manually Define Fields.
  • Click Add Field to add each of the following fields:
    • Status
    • LocationId
  • Click Save.
Now you will see Plasma included on the Sample Type web part.
  • Click Plasma to open it.
  • Click Import More Samples.
  • Click Upload file (.xslx, .xls, .csv, .txt) to open the file upload panel.
  • Leave the Import Options box for "update" unchecked.
  • Click Browse and select the Plasma.xlsx file you just downloaded.
  • Click Submit.

Import Assay Data - Immune Scores

Next, we import the data generated by assays performed on these plasma vials. The data includes:

  • Participant IDs - The subjects from which the samples were drawn.
  • Sample IDs - Note these values match the Name column in the Plasma table. This fact makes it possible to link these two tables (Assay and Sample Type) together.
  • Experimental measurements - Columns M1, M2, M3.

Follow the instructions below to import the assay data into the server.

  • Download the file immune-score.xlsx from this page. This is the data-bearing file. It holds the data results of your experiment, that is, the values measured by the instrument.
  • Click the Experiments tab.
  • Drag-and-drop this file into the Files panel.
  • In the Files panel select the file immune-score.xlsx and click Import Data.
  • In the Import Data pop-up dialog, select Create New Standard Assay Design and click Import.
  • On the Assay Import page:
    • In the Name field, enter "Immune Scores"
    • Set the Location to Current Folder (Lab Workflow).
    • Click Begin Import.
  • On the Data Import: Batch Properties page, do not change any values and click Next.
  • On the Data Import: Run Properties and Data File page, do not change any values and click Save and Finish.
  • Click the Assay Results tab.
  • You will now see the Immune Scores assay that you just defined.

In the next step we will connect this data.

Previous Step | Next Step (3 of 4)

Related Topics

Was this content helpful?

Log in or register an account to provide feedback

expand allcollapse all