Fundamentals Research Data Management FAIR Data Principles Metadata Ontologies Data Sharing Data Publications Data Management Plan Version Control & Git Public Data Repositories Persistent Identifiers Implementation within DataPLANT Annotated Research Context User Journey ARC Commander QuickStart QuickStart (experts) Swate QuickStart Walk-through Best Practices For Data Annotation DataHUB DataPLAN ARC Commander Manual Setup Installing Dependencies Configure Git Installing the ARC Commander Windows MacOS Linux DataHUB Access Before we start Central Functions Initialize Clone Connect Synchronize Configure Branch ISA Metadata Functions ISA Metadata Investigation Study Assay Update Export Swate Manual Setup Installing Swate Browser Desktop, via installer (beta-stage) Desktop, manually (recommended) MacOS 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 Contribute Templates File Picker Expert Features ISA-JSON Frequently Asked Questions Teaching Materials DataPLANT Overview Big Picture ARC structure ARC Demo

Using Units with Building Blocks

last updated at 2023-02-15

  1. Choose the building block for which you want to change the unit.
  2. Select any number of rows of that building block's main column.
  3. Use the search field to search for the wanted unit and click on the unit in the dropdown to select it.
  4. Click Update unit for cells to update the unit only for the selected rows.
  5. Update your tables unit references by clicking the Update Ontology Terms quick access button.
Update Unit Example
  1. Start by creating a building block vegetative growth time (TO:0000369) with the unit hour (UO:0000032).
    • Expanded Table

      Parameter [vegetative growth time] Unit Term Source REF (TO:0000369) Term Accession Number (TO:0000369)

    • 👀 You can hold Ctrl and click the Autoformat Table quick access button to adjust column widths and unhide all hidden columns.

  2. Create more rows for the table and fill the main column (Parameter [vegetative growth time]) with some data.
    • Expanded Table

      Parameter [vegetative growth time] Unit Term Source REF (TO:0000369) Term Accession Number (TO:0000369)
      10,00 hour
      10,00 hour
      10,00 hour
      10,00 hour
      10,00 hour
      10,00 hour
      10,00 hour
      10,00 hour

    • When typing numbers into these cells, Excel will add the unit to the number values.

    • 👀 The unit information for the main column cells can be seen in Excel. Select main column cells → Home → Number → small expand symbol on the bottom right (image).

  3. Click the Update Ontology Terms quick access button, to update the reference columns.
  4. Select some or all rows of the main column Parameter [vegetative growth time] to mark them for the upcoming unit update. In this case i will select all but the first row.
  5. Search for a new unit, in this case day (UO:0000033), select it and click Update unit for cells.
  6. Click the Update Ontology Terms quick access button, to update the reference columns.
Add Unit Example

This workflow is especially important when working with templates, as these will often have columns which are intended to have a unit which is not set for you by the creators. For example a building block Characteristics [Plant age] without a unit. Let's assume you want to use such a template.

Characteristics [Plant age] Term Source REF (DPBO:0000033) Term Accession Number (DPBO:0000033)

  1. Select any number of rows of the Characteristics [Plant age] building block to mark it for the next steps.

  2. Search for the unit, which fits your experiment, in this case i will use: day (UO:0000033). Select the unit term and click Update unit for cells.

    • Expanded Table

      Characteristics [Plant age] Unit Term Source REF (DPBO:0000033) Term Accession Number (DPBO:0000033)

    • If you already had values in the main column they will be updated automatically.

      • Expanded Table | Before

        Characteristics [Plant age] Term Source REF (DPBO:0000033) Term Accession Number (DPBO:0000033)
        10
        10
        10
        10

      • Expanded Table | After

        Characteristics [Plant age] Unit Term Source REF (DPBO:0000033) Term Accession Number (DPBO:0000033)
        10,00 day
        10,00 day
        10,00 day
        10,00 day

    • ⚠️ Notize how this only changed the values in the main column and the number format.

  3. Click the Update Ontology Terms quick access button, to update the reference columns.


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 .
✏️ Edit this page