Data in Excel format
- Column names are case-insensitive.
- Data sheet name must match a template name.
- special column - special charcter at the begining of column name.
| Prefix | Column Type | Description |
|---|
| * | required | The star symbol indicates a required column. All the values in this column must be provided |
| # | descriptor | A column name followed by single pound sign must be a cvterm name. The cvterm is used as a descriptor of evaluation data in the column.
(e.g.) #brix #pH #fruit_weight |
| $ | marker | A column name followed by a dollar symbol indicates that the column holds marker name. |
| % | stock | A column name followed by a percent symbol indicates that the column holds stock name. |
| ~ | sequence | A column name followed by a tilde symbol indicates that the column holds sequnce information. |
| (sp)(sp) | property | A column name followed by double special characters must be a cvterm name. The cvterm is used as a type of a property table.
The following special characters can be used : #, @, % and $
(e.g.) ##cvterm_name @@cvterm_name %%cvterm_name and $$cvterm_name |
Data in CSV format
- The first line of CSV file must start with '#' followed by a template name.
- The second line of a CSV file must with '#' followed by headers.
- Data section starts from the third line. Each column should be double quoted and separated by commas.
(e.g.)
#contact
#"*name","first_name","last_name","alias","*type","lab","institution"
"N","F","L","", "person","Main Lab", "WSU"
