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