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