Within the Biologics application, you can import assay data from a file or by entering values directly into the grid. Both individual run and bulk insert options are available. You can also initiate assay data from a grid of samples, making it easy to enter data for those samples.
Import Assay Data
To import new assay data:
- From the main menu, under Assays, click the name of the assay design you wish to import into.
- Select Manage > Import Data.
- On the Data Import page fill out the form:
- Batch Details: (Optional) If the assay design includes batch fields, you will be prompted to enter values for them here.
- Run Details: (Optional) Run fields include the Assay Id (name for this run) and also capture the characteristics of this assay experiment defined as run fields in the assay design. These may include such the instrument settings, special circumstances, or which request this data fulfills.
- Assay Id: If no id is supplied, then the assay file name will be used. If no file name is used, then an id will be created from the assay design name plus a time stamp.
- Comments: Add text to record special circumstances connected to this assay run.
- Assay Request: Select the assay request, if any.
- Results - There are three tabs in this panel. To help your data conform to the assay design, click Template to download a template to use.
- Upload Files - On this tab (shown in the screencap above), you can either click to select your assay data file or you can drag and drop it directly onto the upload area.
- Copy-and-paste Data - On this tab, you can copy-and-paste your data into a text box. Include column headers in what you paste. The maximum number of rows permitted via this method is 1000.
- Enter Data Into Grid - On this tab, you have several options.
- You can manually enter data into a grid. Select the desired number of rows and click Add rows, then populate with data. For lookup fields like Sample ID, you can type ahead and choose the right option.
- You can click Bulk Insert to add a batch of assay rows that will share some set of properties.
- After entering properties that will be shared, click Add Rows to Grid; you will then be able to customize individual rows in the grid editing interface.
- After adding rows to the grid, either individually or via bulk insert, you can select one or more runs and choose Bulk Update.
- In the popup, you can click the Disabled slider to Enabled, then enter a value for any row that the selected rows should share. For example, to give all selected rows the same Day, you might use the following. No values will be changed for fields left Disabled. Scroll down and click Finish Editing Rows.
- After bulk editing rows, you will return to the grid view where you can make adjustments to individual rows if needed.
- Once your data has been uploaded or rows entered, click Save and Finish or Save and Import Another Run.
Import Assay Data Associated with a Sample
An alternative way to import assay data lets you directly associate assay data with some sample(s) in the registry.
From the Samples grid, select one or more samples, and then select Create > Assay Data > [Assay Design Name]
. The menu will expand to show the assay options from which to select. Scroll to select, or type into the filter box to narrow the list.
The assay import form will be pre-populated with the selected samples, as shown below.
Enter the necessary values and click Save and Finish
(or Save and Import Another Run
In cases where you need to revise assay data after uploading to the server, you can replace the data by "re-importing" a run.
To re-import a run of assay data:
- Go the details page for the target run. (For example, go to the runs table for an assay, and click one of the runs.)
- Click the (bars) menu and select Re-import Run.
Note that re-import of assay data is not supported for: file-based assay designs, ELISA, ELISpot, and FluoroSpot. If the reimport option is not available on the menu, the only way to reimport a run is to delete it and import it again from the original source file.
- For instrument-specific assay designs (such as NAb and Luminex), you will be directed to the specific assay’s import page in LabKey Server. Follow the procedure for re-import as dictated by the assay type: Reimport NAb Assay Run or Reimport Luminex Run.
- For general purpose assay designs, you will stay within the biologics application:
- Revise batch and run details as needed
- Enter new Results data. The first few lines of the existing results are shown in a preview. Choose Upload Files, Copy-and-Paste Data, or Enter Data Into Grid as when creating a new run.
- Click Re-Import.
- The data replacement event is recorded by the "Replaced By" field.
Delete Assay Runs
To delete one or more assay runs, you have several options:
- From the overview page for the assay, select the run(s) to delete using the checkboxes.
- Select Manage > Delete Selected Runs.
You can also delete a single run directly from the detail page for the run.
- Go to the runs table for an assay, and click the run to delete.
- Click the (bars) menu and select Delete Run.
For either option, you will be reminded that deletion of runs is permanent and cannot be undone. Confirm the action in the popup to actually delete the results.
Learn about editing and deleting individual results rows within a run in the topic Biologics: Work with Assay Data