In this step we import two different, but related, data tables:
  • Plasma sample inventory: an Excel spreadsheet that describes different vials of plasma specimens.
  • Assay result data: an Excel 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 Set - 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 Set - Plasma

NameSample SetFlagStatusLocationId
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 Sets panel, click (Create New Sample Set).
  • Provide the Name: "Plasma"
  • You do not need to provide a Name Expression since the data already contains a unique identifier in a "Name" column.
    • Note that the placeholder text shown in the box is not the default name expression, but an example of how one might look.
  • You don't need to add a description or parent column import alias.
  • Click Create.
  • On the next screen, click Add Field to add each of the following fields:
    • Status
    • LocationId
  • Click Save.
Now you will see Plasma included on the Sample Sets 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.
  • Specimen 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 Set) 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 General Assay Design and click Import.
  • On the General Assay Import page:
    • In the Name field, enter "Immune Scores"
    • Set the Location to Current Folder (ELN).
    • 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.

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 all collapse all