Merge pull request #2348 from solgenomics/topic/solgwas_speedup
[sgn.git] / system_cvterms.txt
blobcac74ecee059939b06713597c51563c269bf8d79
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 genotype_property       vcf_snp_genotyping      JSON string encoding all VCF info       6/20/2018       nm529   00098
23 geolocation_property    geolocation address                             00052
24 geolocation_property    geolocation year                                00052
25 geolocation_property    country_name    From BrAPI      03/27/2017      nm529   00076
26 geolocation_property    country_code    From BrAPI      03/27/2017      nm529   00076
27 geolocation_property    abbreviation    From BrAPI      03/27/2017      nm529   00076
28 geolocation_property    location_type   From BrAPI      03/27/2017      nm529   00076
29 geolocation_property    annual_total_precipitation      From BrAPI      03/27/2017      nm529   00076
30 geolocation_property    continent       From BrAPI      03/27/2017      nm529   00076
31 geolocation_property    annual_mean_temperature From BrAPI      03/27/2017      nm529   00076
32 geolocation_property    adm1    From BrAPI      03/27/2017      nm529   00076
33 geolocation_property    adm2    From BrAPI      03/27/2017      nm529   00076
34 geolocation_property    adm3    From BrAPI      03/27/2017      nm529   00076
35 geolocation_property    local_name      From BrAPI      03/27/2017      nm529   00076
36 geolocation_property    region  From BrAPI      03/27/2017      nm529   00076
37 geolocation_property    alternative_name        From BrAPI      03/27/2017      nm529   00076
38 list_types      identifier_generation           08/21/2018      nm529   00102
39 list_types      genotyping_trials               03/23/2018      nm529   00092
40 list_types      tissue_samples          02/15/2018      nm529   00091
41 list_types      seedlots                07/20/2017      nm529   00081
42 list_types      subplots                08/23/2017      nm529   00084
43 list_types      accessions
44 list_types      crosses                         00067
45 list_types      dataset                         00067
46 list_types      locations
47 list_types      locus_ids
48 list_types      numbers                         00067
49 list_types      plots
50 list_types      populations                             00067
51 list_types      traits
52 list_types      trials
53 list_types      unigene_ids
54 list_types      vector_constructs                               00049
55 list_types      years
56 local   date
57 local   months after planting
58 local   operator
59 local   organism_sequencing_metadata
60 local   sp_person_id                            00052
61 local   time
62 local   visible_to_role                         00052
63 nd_experiment_property  cross_name                              00052
64 nd_experiment_property  cross_type                              00052
65 nd_experiment_property  genotyping_project_name                         00052
66 nd_experiment_property  genotyping_user_id                              00052
67 nd_experiment_property  number_of_progeny                               00066
68 nd_experiment_property  number_of_seeds_distributed                             00082
69 organism_property       organism_synonym                                00052
70 organism_property       species authority       From BrAPI      03/27/2017      nm529   00076
71 organism_property       subtaxa From BrAPI      03/27/2017      nm529   00076
72 organism_property       subtaxa authority       From BrAPI      03/27/2017      nm529   00076
73 project_property        plot_width              04/05/2018      nm529   00093
74 project_property        plot_length             04/05/2018      nm529   00093
75 project_property        field_size              04/05/2018      nm529   00093
76 project_property        field_trial_is_planned_to_be_genotyped          04/05/2018      nm529   00093
77 project_property        field_trial_is_planned_to_cross         04/05/2018      nm529   00093
78 project_property        breeding_program                                00051
79 project_property        data_agreement
80 project_property        design
81 project_property        genomic selection
82 project_property        project_harvest_date                            00080
83 project_property        marker_count
84 project_property        project_planting_date                           00080
85 project_property        population type
86 project_property        project fertilizer date
87 project_property        project first harvest date                                      sgn database
88 project_property        project harvested plants
89 project_property        project last harvest date                                       sgn database
90 project_property        project location
91 project_property        project sowing date                                     sgn database
92 project_property        project sown plants
93 project_property        project transplanting date                                      sgn database
94 project_property        project year
95 project_property        project_has_plant_entries                               00054
96 project_property        project_has_subplot_entries                             00084
97 project_property        project_has_tissue_sample_entries                               00089
98 project_property        trial_folder
99 project_property        folder_for_trials       For determining if a folder appears on manage trials page       12/6/16 nm529   00071
100 project_property        folder_for_crosses      For determining if a folder appears on manage crosses page      12/6/16 nm529   00071
101 project_property        folder_for_genotyping_trials    For determining if a folder appears on manage genotyping plate page     6/20/18 nm529   00098
102 project_property        active  From BrAPI      03/27/2017      nm529   00076
103 project_property        breeding_program_abbreviation   From BrAPI      03/27/2017      nm529   00076
104 project_property        phenotypes_fully_uploaded       To determine when a trial has all phenotypes uploaded   06/09/2017      nm529   00078
105 project_property        trial_layout_json       A json string holding a trial's cached layout   10/12/2017      nm529   00087
106 project_property        genotyping_facility     For genotyping plate to indicate where the plate was submitted  2/16/2017       nm529   00091
107 project_property        genotyping_facility_submitted   For genotyping plate to indicate if the plate was submitted to geno facility    2/16/2017       nm529   00091
108 project_property        genotyping_facility_status      For genotyping plate to indicate the status of a plate submitted to geno facility       2/16/2017       nm529   00091
109 project_property        genotyping_plate_format For genotyping plate to indicate if 96 well or other    2/16/2017       nm529   00091
110 project_property        genotyping_plate_sample_type    For genotyping plate to indicate the type of sample in plate e.g. DNA   2/16/2017       nm529   00091
111 project_property        genotyping_facility_plate_id    To retrieve status info from genotyping facility this is the vendorPlateDbId    2/16/2017       nm529   00091
112 project_relationship    breeding_program_trial_relationship                             00051
113 project_relationship    trial_treatment_relationship                            00081
114 project_relationship    field_trial_from_field_trial    For linking field trials preceding other field trials   4/6/18  nm529   00093
115 project_relationship    genotyping_trial_from_field_trial       For linking genotyping plates to the source field trials        4/6/18  nm529   00093
116 project_relationship    crossing_trial_from_field_trial For linking crossing trials to the source field trials  4/6/18  nm529   00093
117 project_type    Advanced Yield Trial
118 project_type    Clonal Evaluation
119 project_type    Preliminary Yield Trial
120 project_type    Regional Trials
121 project_type    Seed Multiplication
122 project_type    Seedling Nursery
123 project_type    Uniform Yield Trial                             00052
124 project_type    Variety Release Trial
125 project_type    crossing_trial  00079
126 project_type    grafting_trial  00079
127 project_type    pollinating_trial       00079
128 project_type    Heterosis                               00082
129 project_type    Genetic Gain                            00082
130 project_type    Health Status                           00082
131 project_type    Storage                         00082
132 project_type    genotyping_trial                00087
133 project_type    phenotyping_trial       00087
134 project_type    crossing_block_trial    00098
135 stock_property  block                           00052
136 stock_property  col_number                              00052
137 stock_property  igd_synonym                             00052
138 stock_property  is a control                            00052
139 stock_property  location_code                           00052
140 stock_property  organization                            00052
141 stock_property  plant_index_number                              00054
142 stock_property  subplot_index_number                            00084
143 stock_property  tissue_sample_index_number                              00089
144 stock_property  plot number                             00052
145 stock_property  plot_geo_json   GeoJSON string for GPS coords polygon of plots. 12/03/2017      nm529   00088
146 stock_property  range                           00052
147 stock_property  replicate                               00052
148 stock_property  row_number                              00052
149 stock_property  stock_synonym                           00046
150 stock_property  T1                              00052
151 stock_property  T2                              00052
152 stock_property  transgenic                              00052
153 stock_property  variety Found in editable_stock_props
154 stock_property  notes   Found in editable_stock_props
155 stock_property  state   Found in editable_stock_props
156 stock_property  accession number        From BrAPI      03/27/2017      nm529   00076
157 stock_property  PUI     From BrAPI      03/27/2017      nm529   00076
158 stock_property  donor   From BrAPI      03/27/2017      nm529   00076
159 stock_property  donor institute From BrAPI      03/27/2017      nm529   00076
160 stock_property  donor PUI       From BrAPI      03/27/2017      nm529   00076
161 stock_property  seed source     From BrAPI      03/27/2017      nm529   00076
162 stock_property  institute code  From BrAPI      03/27/2017      nm529   00076
163 stock_property  institute name  From BrAPI      03/27/2017      nm529   00076
164 stock_property  biological status of accession code     From BrAPI      03/27/2017      nm529   00076
165 stock_property  country of origin       From BrAPI      03/27/2017      nm529   00076
166 stock_property  type of germplasm storage code  From BrAPI      03/27/2017      nm529   00076
167 stock_property  entry number    From BrAPI      03/27/2017      nm529   00076
168 stock_property  acquisition date        From BrAPI      03/27/2017      nm529   00076
169 stock_property  current_count   For keeping current count of seedlot    09/06/2017      nm529   00086
170 stock_property  current_weight_gram     For keeping current count of seedlot    09/06/2017      nm529   00092
171 stock_property  crossing_metadata_json    00086
172 stock_property  ploidy_level    For indicating ploidy level of accession        12/20/2017      nm529   00088
173 stock_property  genome_structure        For indicating genome structure of accession    12/20/2017      nm529   00088
174 stock_property  introgression_parent    For indicating introgression parent accession name      12/20/2017      nm529   00088
175 stock_property  introgression_backcross_parent  For indicating introgression backcross parent accession name    12/20/2017      nm529   00088
176 stock_property  introgression_map_version       For indicating map version of introgression bp position 12/20/2017      nm529   00088
177 stock_property  introgression_chromosome        For indicating chromosome number of introgression       12/20/2017      nm529   00088
178 stock_property  introgression_start_position_bp For indicating introgression start position in bp       12/20/2017      nm529   00088
179 stock_property  introgression_end_position_bp   For indicating introgression end position in bp 12/20/2017      nm529   00088
180 stock_property  is_blank        For indicating blank well in genotype plate     2/15/2018       nm529   00091
181 stock_property  concentration   For indicating concentration in genotype plate well     2/15/2018       nm529   00091
182 stock_property  volume  For indicating volume in genotype plate well    2/15/2018       nm529   00091
183 stock_property  dna_person      For indicating dna_person in genotype plate well        2/15/2018       nm529   00091
184 stock_property  extraction      For indicating extraction in genotype plate well        2/15/2018       nm529   00091
185 stock_property  tissue_type     For indicating tissue type in genotype plate well       2/15/2018       nm529   00091
186 stock_property  ncbi_taxonomy_id        For indicating ncbi taxonomy    2/15/2018       nm529   00091
187 stock_property  family_name    Some breeding programs use family name for progenies (in addition to cross name)    00101
188 stock_relationship      cross_relationship                              00052
189 stock_relationship      female_parent                           00052
190 stock_relationship      male_parent                             00052
191 stock_relationship      member_of                               00052
192 stock_relationship      offspring_of                            00052
193 stock_relationship      plant_of                                00052
194 stock_relationship      plot_of                         00052
195 stock_relationship      subplot_of                              00084
196 stock_relationship      plant_of_subplot                                00084
197 stock_relationship      tissue_sample_of                                00052
198 stock_relationship      collection_of                           00077
199 stock_relationship      seed transaction                                00077
200 stock_relationship      rootstock_of                                    00079
201 stock_relationship      scion_of                                        00079
202 stock_relationship  female_plot_of    00086
203 stock_relationship  male_plot_of    00086
204 stock_relationship  female_plant_of    00094
205 stock_relationship  male_plant_of    00094
206 stock_type      accession                               00052
207 stock_type      backcross population                            00052
208 stock_type      cross                           00052
209 stock_type      f2 population                           00052
210 stock_type      mutant population                               00052
211 stock_type      plant                           00052
212 stock_type      plot                            00052
213 stock_type      population                              00052
214 stock_type      tissue_sample                           00052
215 stock_type      training population                             00052
216 stock_type      vector_construct                                00052
217 stock_type      seedlot                         00077
218 stock_type      subplot                         00084
219 stock_type      grafted_accession               00079
220 trait_property  trait_categories
221 trait_property  trait_default_value
222 trait_property  trait_details
223 trait_property  trait_format
224 trait_property  trait_maximum
225 trait_property  trait_minimum
226 trial_type      genotyping_trial
227 trial_type      phenotyping_trial
228 cvterm_property uri     From BrAPI      03/27/2017      nm529   00076
229 cvterm_property datatype        From BrAPI      03/27/2017      nm529   00076
230 cvterm_property code    From BrAPI      03/27/2017      nm529   00076
231 cvterm_property formula
232 protocol_property       published date  From BrAPI      03/27/2017      nm529   00076
233 protocol_property       protocol type   From BrAPI      03/27/2017      nm529   00076
234 protocol_property       protocol unit   From BrAPI      03/27/2017      nm529   00076
235 protocol_property       protocol comment        From BrAPI      03/27/2017      nm529   00076
236 protocol_property       vcf_map_details Information about protocol, such as marker set  6/20/2018       nm529   00098
237 composable_cvs  trait_ontology          05/01/2017              00073
238 composable_cvs  composed_trait_ontology         05/01/2017              00073
239 composable_cvs  object_ontology         05/01/2017              00073
240 composable_cvs  attribute_ontology              05/01/2017              00073
241 composable_cvs  method_ontology         05/01/2017              00073
242 composable_cvs  unit_ontology           05/01/2017              00073
243 composable_cvs  time_ontology           05/01/2017              00073
244 project_design?                                                 suggested to move the trial design names from projectprop.value to projectprop.type_id
245 phenotype_property  phenotype_outlier   suppressed phenotype measurement    01/04/2018  aco46   00089