Swate Walk-through

DataPLANT provides the Excel Add-In Swate to support you in data annotation. In this walk-through, we guide you on annotating your data using Swate with a show-case example.

🚀 Before we can start, please follow the installation instructions in the Swate Manual.

Swate uses an Excel table as main tool to annotate workflows. Each table represents one process from input to output.

For example:

• Plants → sampling → extract
• Measured data files → statistical analysis → result files

💡 The Excel table feature allows to group data that belongs together inside one sheet. This is not to be confused with a (work)sheet or workbook.

workbook (e.g. isa.assay.xlsx) └── worksheet (e.g. plant_growth) └── table (e.g. annotationTable)

This image displays major areas of the Swate user interface, which will be referenced below.

Create a Swate annotation table via the create annotation table in the yellow pop-up box OR click the Create Annotation Table quick access button.

💡 Each table is by default created with one input (Source Name) and one output (Sample Name) column
💡 Only one annotation table can be added per Excel sheet

1. Navigate to the Building Blocks tab via the navbar. Here you can add Building Blocks to the table.
2. Search for instrument model in the top panel of the Building Blocks tab. This search looks for suitable Terms in our Ontology database.
3. Select the Term with the id MS:1000031 and, instead of Parameter select Component from the drop-down menu.
4. Click Add building block.

💡 This adds three columns to your table, one visible and two hidden.

1. Navigate to the Terms tab in the Navbar
2. In the annotation table, select any number of cells below Component [instrument model]
3. Click into the search field in Swate.

💡 You should see instrument model showing in a field in front of the search field
💡 The search will now yield results related to instrument model

4. You can search or double click into the search field to show all related terms. Select any instrument model and click Fill selected cells with this term*

1. In the Building Blocks tab, re-select Parameter, search for sample volume and select the term with id MS:1000005.
2. Check the box for This Parameter has a unit and search for microliter in the adjacent search bar.
3. Select UO:0000101.
4. Click Add building block.

💡 This adds four columns to your table, one visible and three hidden.

In the annotation table, select any cell below Parameter [sample volume] and add any numbers as volume.

💡 You can see the numbers being complemented with the chosen unit, e.g. 10.00 microliter

Hold Ctrl and click the Autoformat Table quick access button to adjust column widths and un-hide all hidden columns.

💡 You can see that your instrument model of choice was added with id and source Ontology in the reference (hidden) columns.
⚠️ This feature is currently not supported on MacOS

Click the Update Ontology Terms quick access buttons.

💡 This updates all reference columns according to the main column. In this case the reference columns for Parameter [sample volume] are updated with the id and source ontology of the microliter unit.

At this point. Your table should look similar to this

Click the Autoformat Table quick access button without holding Ctrl to hide all reference columns.

1. Navigate to Templates in the Navbar and click Browse database in the first function block.

💡 Here you can find community created workflow annotation templates

2. Search for and select Proteomics MassSpec Assay (name may be issue to change in future updates, pls let us know if there are problems).
   • You will see a preview of all building blocks which are part of this template.
3. Click Add template to add all Building Blocks from the template to your table, which do not exist yet.

If there are any Building Blocks which do not fit your experiment you can use the Remove Building Block quick access button to remove it including all related (hidden) reference columns.

⚠️ Due to the hidden reference columns, we recommend not to delete table columns via the Excel menu.

Go ahead, adjust the Building Blocks you want to use to describe your experiment as you see fit. Insert values using Swate Term search and add input and output.

DataPLANT Support