system_cvterms.txt

   1 cv name cvterm name     definition      date    person  dbpatch #       comment
   2 calendar        Fertilizer Event                                00052
   3 calendar        Genotyping Event                                00052
   4 calendar        Harvest Event                           00052
   5 calendar        Meeting Event                           00052
   6 calendar        Phenotyping Event                               00052
   7 calendar        Planning Event                          00052
   8 calendar        Planting Event                          00052
   9 calendar        Presentation Event                              00052
  10 experiment_type  pedigree experiment
  11 experiment_type cross_experiment                                00052
  12 experiment_type field_layout                            00052
  13 experiment_type genotyping_experiment                           00052
  14 experiment_type genotyping_layout                               00052
  15 experiment_type phenotyping_experiment                          00052
  16 genotype_property       igd number
  17 genotype_property       infinium array                                  sgn database
  18 genotype_property       snp genotyping
  19 geolocations_property   geolocation address                             00052
  20 geolocations_property   geolocation year                                00052
  21 list_types      accessions
  22 list_types      crosses                         00067
  23 list_types      dataset                         00067
  24 list_types      locations
  25 list_types      locus_ids
  26 list_types      numbers                         00067
  27 list_types      plots
  28 list_types      populations                             00067
  29 list_types      traits
  30 list_types      trials
  31 list_types      unigene_ids
  32 list_types      vector_constructs                               00049
  33 list_types      years
  34 local   date
  35 local   months after planting
  36 local   operator
  37 local   organism_sequencing_metadata
  38 local   sp_person_id                            00052
  39 local   time
  40 local   visible_to_role                         00052
  41 nd_experiment_property  cross_name                              00052
  42 nd_experiment_property  cross_type                              00052
  43 nd_experiment_property  date_of_embryo_rescue                           00066
  44 nd_experiment_property  date_of_harvest                         00066
  45 nd_experiment_property  date_of_pollination                             00066
  46 nd_experiment_property  date_of_seed_extraction                         00066
  47 nd_experiment_property  days_from_extraction_to_embryo_rescue                           00066
  48 nd_experiment_property  days_from_harvest_to_extraction                         00066
  49 nd_experiment_property  days_to_maturity                                00066
  50 nd_experiment_property  genotyping_project_name                         00052
  51 nd_experiment_property  genotyping_user_id                              00052
  52 nd_experiment_property  number_of_embryos_contaminated
  53 nd_experiment_property  number_of_embryos_germinated                            00066
  54 nd_experiment_property  number_of_embryos_rescued                               00066
  55 nd_experiment_property  number_of_flowers                               00052
  56 nd_experiment_property  number_of_fruits
  57 nd_experiment_property  number_of_nonviable_seeds                               00066
  58 nd_experiment_property  number_of_progeny                               00066
  59 nd_experiment_property  number_of_seedlings_transplanted
  60 nd_experiment_property  number_of_seeds                         00052
  61 nd_experiment_property  number_of_seeds_extracted                               00066
  62 nd_experiment_property  number_of_seeds_germinated                              00066
  63 nd_experiment_property  number_of_seeds_planted                         00066
  64 nd_experiment_property  number_of_viable_seeds                          00066
  65 organism_property       organism_synonym                                00052
  66 project_property        breeding_program                                00051
  67 project_property        data_agreement
  68 project_property        design
  69 project_property        genomic selection
  70 project_property        harvest_date                            00051
  71 project_property        marker_count
  72 project_property        planting_date                           00051
  73 project_property        population type
  74 project_property        project fertilizer date
  75 project_property        project first harvest date                                      sgn database
  76 project_property        project harvest date
  77 project_property        project harvested plants
  78 project_property        project last harvest date                                       sgn database
  79 project_property        project location
  80 project_property        project planting date
  81 project_property        project sowing date                                     sgn database
  82 project_property        project sown plants
  83 project_property        project transplanting date                                      sgn database
  84 project_property        project year
  85 project_property        project_has_plant_entries                               00054
  86 project_property        trial_folder
  87 project_property    folder_for_trials   For determining if a folder appears on manage trials page   12/6/16 nm529   00071
  88 project_property    folder_for_crosses   For determining if a folder appears on manage crosses page   12/6/16 nm529   00071
  89 project_relationship    breeding_program_trial_relationship                             00051
  90 project_type    Advanced Yeld Trials                            00052
  91 project_type    Advanced Yield Trial
  92 project_type    Clonal Evaluation
  93 project_type    Preliminary Yield Trial
  94 project_type    Preliminary Yield Trials                                00052
  95 project_type    Regional Trials
  96 project_type    Seed Multiplication
  97 project_type    Seedling Nursery
  98 project_type    Uniform Yield Trial                             00052
  99 project_type    Variety Release Trial
 100 stock_property  block                           00052
 101 stock_property  col_number                              00052
 102 stock_property  igd_synonym                             00052
 103 stock_property  is a control                            00052
 104 stock_property  location_code                           00052
 105 stock_property  organization                            00052
 106 stock_property  plant_index_number                              00054
 107 stock_property  plot number                             00052
 108 stock_property  range                           00052
 109 stock_property  replicate                               00052
 110 stock_property  row_number                              00052
 111 stock_property  stock_synonym                           00046
 112 stock_property  T1                              00052
 113 stock_property  T2                              00052
 114 stock_property  transgenic                              00052
 115 stock_relationship      cross_relationship                              00052
 116 stock_relationship      female_parent                           00052
 117 stock_relationship      male_parent                             00052
 118 stock_relationship      member_of                               00052
 119 stock_relationship      offspring_of                            00052
 120 stock_relationship      plant_of                                00052
 121 stock_relationship      plot_of                         00052
 122 stock_relationship      tissue_sample_of                                00052
 123 stock_type      accession                               00052
 124 stock_type      backcross population                            00052
 125 stock_type      cross                           00052
 126 stock_type      f2 population                           00052
 127 stock_type      mutant population                               00052
 128 stock_type      plant                           00052
 129 stock_type      plot                            00052
 130 stock_type      population                              00052
 131 stock_type      tissue_sample                           00052
 132 stock_type      training population                             00052
 133 stock_type      vector_construct                                00052
 134 trait_property  trait_categories
 135 trait_property  trait_default_value
 136 trait_property  trait_details
 137 trait_property  trait_format
 138 trait_property  trait_maximum
 139 trait_property  trait_minimum
 140 trial_type      crossing_trial
 141 trial_type      genotyping_trial
 142 trial_type      phenotyping_trial
 143 project_design?                                                 suggested to move the trial design names from projectprop.value to projectprop.type_id