MCL Data Template List
Template Description
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.
    PrefixColumn TypeDescription
    *requiredThe star symbol indicates a required column. All the values in this column must be provided
    #descriptorA 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
    $markerA column name followed by a dollar symbol indicates that the column holds marker name.
    %stockA column name followed by a percent symbol indicates that the column holds stock name.
    ~sequenceA column name followed by a tilde symbol indicates that the column holds sequnce information.
    (sp)(sp)propertyA 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"
Template NameDetailsDownload
dbviewdownload
cvviewdownload
propertyviewdownload
cvtermviewdownload
traitviewdownload
method_classviewdownload
methodviewdownload
descriptorviewdownload
pubviewdownload
contactviewdownload
datasetviewdownload
organismviewdownload
libraryviewdownload
site_cottonviewdownload
stockcollectionviewdownload
stock_cottonviewdownload
stockcollection_stock_cottonviewdownload
crossviewdownload
progenyviewdownload
markerviewdownload
mtl_cottonviewdownload
qtl_cottonviewdownload
haplotype_blockviewdownload
haplotypeviewdownload
haplotype_snpviewdownload
gene_annotationviewdownload
mapviewdownload
map_positionviewdownload
genome_positionviewdownload
gwas_groupviewdownload
gwasviewdownload
gwas_trait_dataviewdownload
fb_field_databaseviewdownload
fb_field_tableviewdownload
phenotypeviewdownload
phenotype_cottonviewdownload
qtl_trait_data_cottonviewdownload
genotypeviewdownload
genotype_bviewdownload
genotype_cviewdownload
genotype_snp_long_formviewdownload
genotype_snp_wide_formviewdownload
imageviewdownload
Returns to MCL home