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 QuickStart - Videos 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 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 Sharing ARCs via the DataHUB Work with your ARC Using ARCs with Galaxy Computational Workflows CWL Introduction CWL runner installation CWL Examples CWL Metadata 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 Troubleshooting Git Troubleshooting Contribute Swate Templates Knowledge Base Teaching Materials 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 Start Your ARC Series - Videos Events 2024 CEPLAS ARC Trainings – Spring 2024 MibiNet CEPLAS DataPLANT Tool-Workshops Frequently Asked Questions

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