Column types

Deep Origin supports several types of basic and advanced columns.

Type	Description
ID	Unique auto-generated alphanumeric string for each row. IDs can be used to create references between rows. IDs are permanent. They cannot be changed.
Date	Captures dates, such as when each sample was collected.
Float	Captures decimal quantitative values, such as abundance measurements.
File	Captures raw files such as sequence reads, microscopy images, processed results, and reports such as PDFs. Learn more.
Formula	Enables users to create columns whose values are derived from the values of other columns using constants, operators, and functions. Learn more.
Integer	Captures integer quantitative values, such as numbers of raw sequence reads.
Reference	Captures relationships to rows of other databases or to other rows of the same database. Learn more.
Reference lookup	Retrieves data from a referenced database via the reference column. Allows users to display information from linked records without duplicating data. The looked-up value updates automatically when the source data changes. Learn more.
Select	Captures one or more options from a list of options. One use case is to categorize rows.
Text	Captures strings, such as names or descriptions.
URL	Captures hyperlinks. When clicked, links are opened in new tabs.
User	Captures users. One use case is to case the individual who signed off on an experiment.
Yes/No	Capture binary values, such as "true/false" and "yes/no".
Submission status	Choose between "Draft" and "Final". Useful to indicate finalized data for analysis
Creation context	Records the context where the database row is created
Date created	Captures the date when each row was created. This column is automatically created and its value it automatically set. Users cannot edit these columns.
Date updated	Captures the date when each row was last updated. This column is automatically created and its value is automatically updated. Users cannot edit these columns.
Created by	Capture the user who created each row.
Edited by	Capture the user who last updated each row.