Home Fundamentals Research Data Management FAIR Data Principles Metadata Ontologies Data Sharing Data Publications Data Management Plan Version Control & Git Public Data Repositories Persistent Identifiers Electronic Lab Notebooks (ELN) DataPLANT Implementations Annotated Research Context User Journey ARC specification ARC Commander QuickStart QuickStart (Experts) Swate QuickStart Walk-through Best Practices For Data Annotation DataHUB DataPLAN Ontology Service Landscape ARC Commander Manual Setup Git Installation ARC Commander Installation Windows MacOS Linux ARC Commander DataHUB Access Before we start Central Functions Initialize Clone Connect Synchronize Configure Branch ISA Metadata Functions ISA Metadata Investigation Study Assay Update Export ARCitect Manual Installation - Windows Installation - macOS Installation - Linux QuickStart ARCmanager Manual What is the ARCmanager? How to use the ARCmanager Swate Manual Swate Installation Excel Browser Excel Desktop Windows – installer Windows – manually macOS – manually Organization-wide Core Features Annotation tables Building blocks Building Block Types Adding a Building Block Using Units with Building Blocks Filling cells with ontology terms Advanced Term Search Templates File Picker Expert Features Contribute Templates ISA-JSON Workflows Manual CWL Introduction CWL runner installation CWL Examples CWL Metadata DataHUB Manual Overview User Settings Generate a Personal Access Token (PAT) Projects Panel ARC Panel Forks Working with files ARC Settings ARC Wiki Groups Panel Create a new user group Data publications Passing Continuous Quality Control Submitting ARCs with ARChigator Track publication status Use your DOIs Guides ARC User Journey Create your ARC ARC Commander QuickStart ARC Commander QuickStart (Experts) ARCitect QuickStart Annotate Data in your ARC Annotation Principles ISA File Types Best Practices For Data Annotation Swate QuickStart Swate Walk-through Share your ARC Register at the DataHUB DataPLANT account Invite collaborators to your ARC Work with your ARC Using ARCs with Galaxy Recommended ARC practices Syncing recommendation Keep files from syncing to the DataHUB Working with large data files Adding external data to the ARC ARCs in Enabling Platforms Publication to ARC Contribute Swate Templates Knowledge Base Teaching Materials Slides DataPLANT Annotated Research Context Videos Start Your ARC Series Events 2023 Nov: CEPLAS PhD Module Oct: CSCS CEPLAS Start Your ARC Sept: MibiNet CEPLAS Start Your ARC July: RPTU Summer School on RDM July: Data Steward Circle May: CEPLAS Start Your ARC Series Frequently Asked Questions

Swate Walk-through

last updated at 2023-06-13 About this guide

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

UserNewbie ModeWalk-through

Before we can start
Starting Swate
  1. Open a fresh Excel workbook
  2. Load the Swate plug-in from Excel's "Data" tab Swate.Core Icon

💡 Depending on your Swate setup, the way to load Swate may differ.
💡 Alternatively you can open a isa.study.xlsx or isa.assay.xlsx file from your existing ARC to annotate your ARC's data.

Swate Overview
Major areas of the Swate user interface.
Create an annotation table

Create a Swate annotation table via the create annotation table button 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

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

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

Insert values to annotate your data
  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

  1. 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*
Add a building block with a unit
  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.

Insert unit-values to annotate your data

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

Showing ontology reference columns

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

Update ontology reference columns

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.

Your ISA table is growing

At this point. Your table should look similar to this

Source Name Parameter [instrument model] Term Source REF (MS:1000031) Term Accession Number (MS:1000031) Parameter [sample volume] Unit Term Source REF (MS:1000005) Term Accession Number (MS:1000005) Sample Name
SCIEX instrument model MS http://purl.obolibrary.org/obo/MS_1000121 10.00 microliter microliter UO http://purl.obolibrary.org/obo/UO_0000101
SCIEX instrument model MS http://purl.obolibrary.org/obo/MS_1000121 5.00 microliter microliter UO http://purl.obolibrary.org/obo/UO_0000101
SCIEX instrument model MS http://purl.obolibrary.org/obo/MS_1000121 5.00 microliter microliter UO http://purl.obolibrary.org/obo/UO_0000101
SCIEX instrument model MS http://purl.obolibrary.org/obo/MS_1000121 5.00 microliter microliter UO http://purl.obolibrary.org/obo/UO_0000101
Hiding ontology reference columns

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

Use a template
  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

  1. 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.
  2. Click Add template to add all Building Blocks from the template to your table, which do not exist yet.
Remove building blocks

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 usual Excel functions.

Your ISA table is ready 🎉

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

Besides these technical solutions, DataPLANT supports you with community-engaged data stewardship. For further assistance, feel free to reach out via our helpdesk or by contacting us directly .
Contribution Guide 📖
✏️ Edit this page