Managing Sample Metadata
Each project in IRIDA may contain a collection of samples that corresponds to an isolate. Each sample can contain an indefinite number of metadata terms.
- Viewing and modifying metadata on a sample
- Bulk import of metadata for samples within a project
- Project Metadata Line List
- Project Sample Metadata
- Template Details Page
Viewing and modifying metadata on a sample
Metadata can be viewed and modified on the individual sample.
Bulk import of metadata for samples within a project
Administrators and project managers can directly upload Excel spreadsheets of metadata directly to a project. It is expected that one of the columns in the spreadsheet will map to the sample name within IRIDA, this can be selected at upload time.
Links to the upload page can be found:
Samplespage, under the
Sample Toolsdropdown menu:
Please note that this feature is still under development.
Any excel spreadsheet containing metadata for samples in a project can be uploaded through the IRIDA web interface. One of the column in the table must correspond to the sample name within the project. In this example spreadsheet, the
NLEP # column is the sample name.
THe first step is to select the Excel file containing the data. Either click on the square label
Click or drop Excel file containing metadata for samples in this project. or drag and drop the file from your file browser.
After uploading a spreadsheet, the column corresponding to the sample name must be selected. After selecting the column heading, press the
Preivew metadata to be uploaded button.
Before the metadata upload is completed, metadata that matches sample names and ones that don’t are presented.
Metadata that has a matching sample name are listed in the table
Rows matcthings samples with the number of matching samples. Clicking on the
Save valid metadata button will add the metadata to it’s sample and redirect to the linelist page.
Metadata that do not have matching sample names are listed in the table
Rows not matching samples with the number of non-matching samples. Currently nothing can be done about these. Try to check the sample names and re-importing the spreadsheet.
Project Metadata Line List
A Metadata Line List is a table that summarizes all metadata associated with samples in a project.
The initial sort is on the
Sample Name column in ascending order.
Columns can be sorted by clicking on the column headers and the sort direction is indicated by an arrow next to the label. Multiple columns can be sorted simultaneously by holding down the
Shift key while clicking on the column header.
Data within individual columns can be filtered. Hovering the cursor over the column header displays a menu icon that, when clicked, displays filtering options.
Filters can be set to be:
- Equals: the text entered must exactly match the value in the column
- Not equal: if the text entered matches the value in the column, the sample will be hidden
- Start with: column value must start with the value entered
- Ends with: column value must end with the value entered
- Contains: the text entered can be found anywhere in the value in the column
- Not contains: the text entered cannot ve found anywhere in the value in the column.
Up to 2 separate filters can be applied to a column at a time.
To make it easier to see related information, columns can be re-ordered by dragging the the column header to the required position.
Toggle Metadata Columns
Some columns might not have information that is useful in a particular analysis. Columns can be toggled on and off in the right hand side panel of the table. If the panel is closed, or needs to be opened, click the
Columns button on the right hand side of the table.
Columns can be toggled on and off by selecting the checkbox with the column name in it. If the checkbox is checked, the column will be visible.
Saving Column Order and Visible Metadata
Updating the column order and which metadata is visible can be saved as a Template so that the next time the line list is viewed the same settings can be applied quickly. Click the
Save Template button which will open a dialog window. Add a name for the template (this cannot match the name of another template within the project).
A template can up updated by selecting its name in the dropdown. The checkbox must be selected stating that the existing template will be overwritten.
After a template is created it can me modified or deleted under Project Settings > Sample Metadata Templates
Exporting Data from Metadata Table
Data can be exported as either Excel or CSV formats. Ony the fields currently in the table will be exported.
Hovering over the
Export button which will reveal a dropdown where you can select from either
Export as Excel or
Export as CSV, the download will begin automatically.
Values within the metadata table can be updated by double clicking on the cell you want to modify, enter the new value and press enter. The new value will be automatically saved. Once a cell has been edited, a notification will display with a “undo” button, that will revert the value back to the original.
Project Sample Metadata
Each sample can contain it’s own metadata. IRIDA uses the terms:
- Metadata Field as the label for a piece of metadata (e.g. Organism).
- Metadata Entry for the value associated with it (e.g. Salmonella enterica).
All metadata fields associated with samples in a project can be viewed on the metadata fields page. This is accessed by clicking on the ‘Sample Metadata’ tab.
Once on the Sample Metadata page, you will see a listing of all Metadata Field associated with samples in this project:
Metadata Fields have:
- Type: Indicates the type of data that the field can be. Usually this will be just “text”.
Metadata Templates provide a pre-defined collection and order of metadata fields used for displaying sample metadata on the line list page.
To create a new metadata template (project managers only) select the fields from the metadata fields table and click the “Create Template” button:
- Name: Must be unique within the project (required)
- Description: Any information that will help to understand why this template should be used.
- Fields: Fields can be dragged and dropped into any order.
A list of all metadata templates for the project can be viewed by selecting the “Metadata Templates” from the menu on the left hand side:
Each template listing contains:
- Template name; clicking this will redirect to the template details page.
- Template description, the number of fields in the template.
- Template actions, including (download Excel file of template fields, and remove template (managers only))
Set as Defaultbutton to set the template as the default for the project (displays if hovering on a template) or a
Defaulttag if template is already set as default for the project.
Template Details Page
Clicking on a template name will redirect you to the template details page.
Project manager can edit/update the template name, description and fields on this page. They can also set the template as the default for the project.