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 experiment_type seedlot_experiment                              00077
  17 genotype_property       igd number
  18 genotype_property       infinium array                                  sgn database
  19 genotype_property       snp genotyping
  20 geolocations_property   geolocation address                             00052
  21 geolocations_property   geolocation year                                00052
  22 geolocations_property   country_name    From BrAPI      03/27/2017      nm529   00076
  23 geolocations_property   country_code    From BrAPI      03/27/2017      nm529   00076
  24 geolocations_property   abbreviation    From BrAPI      03/27/2017      nm529   00076
  25 geolocations_property   location_type   From BrAPI      03/27/2017      nm529   00076
  26 geolocations_property   annual_total_precipitation      From BrAPI      03/27/2017      nm529   00076
  27 geolocations_property   continent       From BrAPI      03/27/2017      nm529   00076
  28 geolocations_property   annual_mean_temperature From BrAPI      03/27/2017      nm529   00076
  29 geolocations_property   adm1    From BrAPI      03/27/2017      nm529   00076
  30 geolocations_property   adm2    From BrAPI      03/27/2017      nm529   00076
  31 geolocations_property   adm3    From BrAPI      03/27/2017      nm529   00076
  32 geolocations_property   local_name      From BrAPI      03/27/2017      nm529   00076
  33 geolocations_property   region  From BrAPI      03/27/2017      nm529   00076
  34 geolocations_property   alternative_name        From BrAPI      03/27/2017      nm529   00076
  35 list_types      accessions
  36 list_types      crosses                         00067
  37 list_types      dataset                         00067
  38 list_types      locations
  39 list_types      locus_ids
  40 list_types      numbers                         00067
  41 list_types      plots
  42 list_types      populations                             00067
  43 list_types      traits
  44 list_types      trials
  45 list_types      unigene_ids
  46 list_types      vector_constructs                               00049
  47 list_types      years
  48 local   date
  49 local   months after planting
  50 local   operator
  51 local   organism_sequencing_metadata
  52 local   sp_person_id                            00052
  53 local   time
  54 local   visible_to_role                         00052
  55 nd_experiment_property  cross_name                              00052
  56 nd_experiment_property  cross_type                              00052
  57 nd_experiment_property  date_of_embryo_rescue                           00066
  58 nd_experiment_property  date_of_harvest                         00066
  59 nd_experiment_property  date_of_pollination                             00066
  60 nd_experiment_property  date_of_seed_extraction                         00066
  61 nd_experiment_property  days_from_extraction_to_embryo_rescue                           00066
  62 nd_experiment_property  days_from_harvest_to_extraction                         00066
  63 nd_experiment_property  days_to_maturity                                00066
  64 nd_experiment_property  genotyping_project_name                         00052
  65 nd_experiment_property  genotyping_user_id                              00052
  66 nd_experiment_property  number_of_embryos_contaminated
  67 nd_experiment_property  number_of_embryos_germinated                            00066
  68 nd_experiment_property  number_of_embryos_rescued                               00066
  69 nd_experiment_property  number_of_flowers                               00052
  70 nd_experiment_property  number_of_fruits
  71 nd_experiment_property  number_of_nonviable_seeds                               00066
  72 nd_experiment_property  number_of_progeny                               00066
  73 nd_experiment_property  number_of_seedlings_transplanted
  74 nd_experiment_property  number_of_seeds                         00052
  75 nd_experiment_property  number_of_seeds_extracted                               00066
  76 nd_experiment_property  number_of_seeds_germinated                              00066
  77 nd_experiment_property  number_of_seeds_planted                         00066
  78 nd_experiment_property  number_of_viable_seeds                          00066
  79 organism_property       organism_synonym                                00052
  80 organism_property       species authority       From BrAPI      03/27/2017      nm529   00076
  81 organism_property       subtaxa From BrAPI      03/27/2017      nm529   00076
  82 organism_property       subtaxa authority       From BrAPI      03/27/2017      nm529   00076
  83 project_property        breeding_program                                00051
  84 project_property        data_agreement
  85 project_property        design
  86 project_property        genomic selection
  87 project_property        harvest_date                            00051
  88 project_property        marker_count
  89 project_property        planting_date                           00051
  90 project_property        population type
  91 project_property        project fertilizer date
  92 project_property        project first harvest date                                      sgn database
  93 project_property        project harvest date
  94 project_property        project harvested plants
  95 project_property        project last harvest date                                       sgn database
  96 project_property        project location
  97 project_property        project planting date
  98 project_property        project sowing date                                     sgn database
  99 project_property        project sown plants
 100 project_property        project transplanting date                                      sgn database
 101 project_property        project year
 102 project_property        project_has_plant_entries                               00054
 103 project_property        trial_folder
 104 project_property        folder_for_trials       For determining if a folder appears on manage trials page       12/6/16 nm529   00071
 105 project_property        folder_for_crosses      For determining if a folder appears on manage crosses page      12/6/16 nm529   00071
 106 project_property        active  From BrAPI      03/27/2017      nm529   00076
 107 project_property        breeding_program_abbreviation   From BrAPI      03/27/2017      nm529   00076
 108 project_relationship    breeding_program_trial_relationship                             00051
 109 project_type    Advanced Yeld Trials                            00052
 110 project_type    Advanced Yield Trial
 111 project_type    Clonal Evaluation
 112 project_type    Preliminary Yield Trial
 113 project_type    Preliminary Yield Trials                                00052
 114 project_type    Regional Trials
 115 project_type    Seed Multiplication
 116 project_type    Seedling Nursery
 117 project_type    Uniform Yield Trial                             00052
 118 project_type    Variety Release Trial
 119 stock_property  block                           00052
 120 stock_property  col_number                              00052
 121 stock_property  igd_synonym                             00052
 122 stock_property  is a control                            00052
 123 stock_property  location_code                           00052
 124 stock_property  organization                            00052
 125 stock_property  plant_index_number                              00054
 126 stock_property  plot number                             00052
 127 stock_property  range                           00052
 128 stock_property  replicate                               00052
 129 stock_property  row_number                              00052
 130 stock_property  stock_synonym                           00046
 131 stock_property  T1                              00052
 132 stock_property  T2                              00052
 133 stock_property  transgenic                              00052
 134 stock_property  accession number        From BrAPI      03/27/2017      nm529   00076
 135 stock_property  PUI     From BrAPI      03/27/2017      nm529   00076
 136 stock_property  donor   From BrAPI      03/27/2017      nm529   00076
 137 stock_property  donor institute From BrAPI      03/27/2017      nm529   00076
 138 stock_property  donor PUI       From BrAPI      03/27/2017      nm529   00076
 139 stock_property  seed source     From BrAPI      03/27/2017      nm529   00076
 140 stock_property  institute code  From BrAPI      03/27/2017      nm529   00076
 141 stock_property  institute name  From BrAPI      03/27/2017      nm529   00076
 142 stock_property  biological status of accession code     From BrAPI      03/27/2017      nm529   00076
 143 stock_property  country of origin       From BrAPI      03/27/2017      nm529   00076
 144 stock_property  type of germplasm storage code  From BrAPI      03/27/2017      nm529   00076
 145 stock_property  entry number    From BrAPI      03/27/2017      nm529   00076
 146 stock_property  acquisition date        From BrAPI      03/27/2017      nm529   00076
 147 stock_relationship      cross_relationship                              00052
 148 stock_relationship      female_parent                           00052
 149 stock_relationship      male_parent                             00052
 150 stock_relationship      member_of                               00052
 151 stock_relationship      offspring_of                            00052
 152 stock_relationship      plant_of                                00052
 153 stock_relationship      plot_of                         00052
 154 stock_relationship      tissue_sample_of                                00052
 155 stock_relationship      collection_of                           00077
 156 stock_relationship      seed transaction                                00077
 157 stock_type      accession                               00052
 158 stock_type      backcross population                            00052
 159 stock_type      cross                           00052
 160 stock_type      f2 population                           00052
 161 stock_type      mutant population                               00052
 162 stock_type      plant                           00052
 163 stock_type      plot                            00052
 164 stock_type      population                              00052
 165 stock_type      tissue_sample                           00052
 166 stock_type      training population                             00052
 167 stock_type      vector_construct                                00052
 168 stock_type      seedlot                         00077
 169 trait_property  trait_categories
 170 trait_property  trait_default_value
 171 trait_property  trait_details
 172 trait_property  trait_format
 173 trait_property  trait_maximum
 174 trait_property  trait_minimum
 175 trial_type      crossing_trial
 176 trial_type      genotyping_trial
 177 trial_type      phenotyping_trial
 178 cvterm_property uri     From BrAPI      03/27/2017      nm529   00076
 179 cvterm_property datatype        From BrAPI      03/27/2017      nm529   00076
 180 cvterm_property code    From BrAPI      03/27/2017      nm529   00076
 181 protocol_property       published date  From BrAPI      03/27/2017      nm529   00076
 182 protocol_property       protocol type   From BrAPI      03/27/2017      nm529   00076
 183 protocol_property       protocol unit   From BrAPI      03/27/2017      nm529   00076
 184 protocol_property       protocol comment        From BrAPI      03/27/2017      nm529   00076
 185 composable_cvs  trait_ontology          05/01/2017              00073
 186 composable_cvs  composed_trait_ontology         05/01/2017              00073
 187 composable_cvs  object_ontology         05/01/2017              00073
 188 composable_cvs  attribute_ontology              05/01/2017              00073
 189 composable_cvs  method_ontology         05/01/2017              00073
 190 composable_cvs  unit_ontology           05/01/2017              00073
 191 composable_cvs  time_ontology           05/01/2017              00073
 192 project_design?                                                 suggested to move the trial design names from projectprop.value to projectprop.type_id