The results of experiments and instrument runs can be uploaded and associated with samples that are registered in the system.
This topic covers how to create a "template" describing each different type of experiment data you will upload. LabKey Sample Manager calls these data descriptions
Assay Designs. All assay data will be associated with a sample, so a mapping to the correct Sample Type is required.
Create Assay Design
From the main menu, select
Assays and then select
Create > Assay Design.
(Before any assays have been created, you will see a direct link to "Create an assay design" on the menu.)
- Give the assay design a Name (Required). The name must be unique and cannot be changed after the design is created.
- Enter a Description to give more information (Optional).
- Choose Editing Settings using the checkboxes. Either runs, results, or both can be editable.
- Add the necessary fields and sample mapping described below before clicking Finish Creating Assay Design.
Add Run Fields
Run fields represent information that will be set once per
run of data, such as a spreadsheet of individual result rows uploaded together. All rows will have the same value for any run fields you define.
- Click the Run Fields section to open it.
- If you have a specially prepared JSON file of field definitions, you can drop it into the Import fields from file panel.
- Otherwise, click Manually Define Fields.
- Use Add Field to add each run field you need (one is created for you).
- Enter a Name (without spaces)
- Select the Data Type.
- To set more properties of the field, click the expansion icon.
If you add any extraneous fields, delete them by clicking the
.
Add Results Fields
Results Fields represent the data information in the spreadsheet. You can define results fields in several ways:
- Upload a sample spreadsheet to infer all the necessary fields. Either drag and drop a file into the upload area, or click within the same area to select a file directly.
- Import a specially designed JSON file containing field definitions by dropping or selecting it in the same panel.
- Click Manually Define Fields below the panel to define fields in the editor.
In the Sample Manager tutorial, you can try this procedure with our sample data in the step:
Tutorial: Define Assays.
Results fields will be inferred from your upload (see image below). Note that the data itself will
not be imported at this time. Once fields have been inferred, you can make changes if needed. For instance, if your results spreadsheet also includes columns for the run fields you defined (Date and Instrument, as above), you may need to delete the duplicate fields. Click the
to delete a field.
There must be a field mapping assay data to the sample it represents. If your fields include one named "SampleID", it will be automatically mapped. Otherwise, you will see a blue notice and need to follow the steps in the
next section before clicking
Finish Creating Assay Design for your assay design.
Map to Samples
In order to associate all assay data with the sample it represents, every assay design must included a field which maps to samples in the system. The data type
Sample is used to represent that mapping as a lookup into the Sample Type containing the samples.
After you infer fields, if one of them is named "SampleID" (such as when you use a naming pattern), it will be mapped automatically. If not, you will see a blue message section asking you to map one of the fields to be the Sample Lookup. The pulldown menu will be populated with the results fields that were inferred. If you need to add a new field to provide the sample linkage, use
Add new field. In this example, the SampleID field will be our lookup.
As soon as you select it from the dropdown, the chosen field changes to be of type
Sample and opens the properties panel. Select the desired Sample Type from the dropdown.
Click
Finish Creating Assay Design in the lower right when finished.
The assay design describing the
structure of assay data has now been created. Note that the actual data contained in the spreadsheet you used to infer fields was
not imported.
Now you can add experiment data that matches this structure and map it to samples and other associated data.
Related Topics
