fixed labels and add project dialog
[sgn.git] / docs / managing-phenotypic-data.html
blob90a2ba8c16482b305908645f86d4557fa7d794f6
1 <!DOCTYPE html>
2 <html lang="" xml:lang="">
3 <head>
5 <meta charset="utf-8" />
6 <meta http-equiv="X-UA-Compatible" content="IE=edge" />
7 <title>Chapter 13 Managing Phenotypic Data | User Manual of Breedbase</title>
8 <meta name="description" content="A manual for all things Breedbase. How to create an account, search the database, manage different data types, and analyze data." />
9 <meta name="generator" content="bookdown 0.36 and GitBook 2.6.7" />
11 <meta property="og:title" content="Chapter 13 Managing Phenotypic Data | User Manual of Breedbase" />
12 <meta property="og:type" content="book" />
13 <meta property="og:image" content="https://solgenomics.github.io/assets/images/Breedbase_HighRes.png" />
14 <meta property="og:description" content="A manual for all things Breedbase. How to create an account, search the database, manage different data types, and analyze data." />
15 <meta name="github-repo" content="solgenomics/sgn" />
17 <meta name="twitter:card" content="summary" />
18 <meta name="twitter:title" content="Chapter 13 Managing Phenotypic Data | User Manual of Breedbase" />
20 <meta name="twitter:description" content="A manual for all things Breedbase. How to create an account, search the database, manage different data types, and analyze data." />
21 <meta name="twitter:image" content="https://solgenomics.github.io/assets/images/Breedbase_HighRes.png" />
23 <meta name="author" content="Breedbase team" />
26 <meta name="date" content="2024-01-30" />
28 <meta name="viewport" content="width=device-width, initial-scale=1" />
29 <meta name="apple-mobile-web-app-capable" content="yes" />
30 <meta name="apple-mobile-web-app-status-bar-style" content="black" />
33 <link rel="prev" href="using-fieldbook-app.html"/>
34 <link rel="next" href="managing-barcodes.html"/>
35 <script src="libs/jquery-3.6.0/jquery-3.6.0.min.js"></script>
36 <script src="https://cdn.jsdelivr.net/npm/fuse.js@6.4.6/dist/fuse.min.js"></script>
37 <link href="libs/gitbook-2.6.7/css/style.css" rel="stylesheet" />
38 <link href="libs/gitbook-2.6.7/css/plugin-table.css" rel="stylesheet" />
39 <link href="libs/gitbook-2.6.7/css/plugin-bookdown.css" rel="stylesheet" />
40 <link href="libs/gitbook-2.6.7/css/plugin-highlight.css" rel="stylesheet" />
41 <link href="libs/gitbook-2.6.7/css/plugin-search.css" rel="stylesheet" />
42 <link href="libs/gitbook-2.6.7/css/plugin-fontsettings.css" rel="stylesheet" />
43 <link href="libs/gitbook-2.6.7/css/plugin-clipboard.css" rel="stylesheet" />
52 <link href="libs/anchor-sections-1.1.0/anchor-sections.css" rel="stylesheet" />
53 <link href="libs/anchor-sections-1.1.0/anchor-sections-hash.css" rel="stylesheet" />
54 <script src="libs/anchor-sections-1.1.0/anchor-sections.js"></script>
55 <script async defer src="https://hypothes.is/embed.js"></script>
59 <style type="text/css">
61 div.hanging-indent{margin-left: 1.5em; text-indent: -1.5em;}
62 </style>
64 <link rel="stylesheet" href="assets/style.css" type="text/css" />
65 </head>
67 <body>
71 <div class="book without-animation with-summary font-size-2 font-family-1" data-basepath=".">
73 <div class="book-summary">
74 <nav role="navigation">
76 <ul class="summary">
77 <li class="toc-logo"><a href="./"><img src="assets/images/Breedbase_HighRes.png"></a></li>
78 <li class="divider"></li>
79 <li class="chapter" data-level="" data-path="index.html"><a href="index.html"><i class="fa fa-check"></i>Introduction</a></li>
80 <li class="chapter" data-level="1" data-path="basic-website-usage.html"><a href="basic-website-usage.html"><i class="fa fa-check"></i><b>1</b> Basic Website Usage</a>
81 <ul>
82 <li class="chapter" data-level="1.1" data-path="basic-website-usage.html"><a href="basic-website-usage.html#creating-a-user-account"><i class="fa fa-check"></i><b>1.1</b> Creating a User Account</a>
83 <ul>
84 <li class="chapter" data-level="1.1.1" data-path="basic-website-usage.html"><a href="basic-website-usage.html#verifying-first-that-you-do-not-already-have-an-account"><i class="fa fa-check"></i><b>1.1.1</b> Verifying first that you do not already have an account</a></li>
85 <li class="chapter" data-level="1.1.2" data-path="basic-website-usage.html"><a href="basic-website-usage.html#creating-a-user-account-1"><i class="fa fa-check"></i><b>1.1.2</b> Creating a user account</a></li>
86 </ul></li>
87 <li class="chapter" data-level="1.2" data-path="basic-website-usage.html"><a href="basic-website-usage.html#managing-your-account"><i class="fa fa-check"></i><b>1.2</b> Managing your Account</a>
88 <ul>
89 <li class="chapter" data-level="1.2.1" data-path="basic-website-usage.html"><a href="basic-website-usage.html#login"><i class="fa fa-check"></i><b>1.2.1</b> Login</a></li>
90 <li class="chapter" data-level="1.2.2" data-path="basic-website-usage.html"><a href="basic-website-usage.html#editing-account-settings"><i class="fa fa-check"></i><b>1.2.2</b> Editing Account Settings</a></li>
91 <li class="chapter" data-level="1.2.3" data-path="basic-website-usage.html"><a href="basic-website-usage.html#changing-your-account-status-from-user-to-submitter"><i class="fa fa-check"></i><b>1.2.3</b> Changing Your Account Status: From “User” to “Submitter”</a></li>
92 <li class="chapter" data-level="1.2.4" data-path="basic-website-usage.html"><a href="basic-website-usage.html#submitting-feedback-on-an-sgn-database"><i class="fa fa-check"></i><b>1.2.4</b> Submitting Feedback on an SGN Database</a></li>
93 </ul></li>
94 <li class="chapter" data-level="1.3" data-path="basic-website-usage.html"><a href="basic-website-usage.html#menu-layout"><i class="fa fa-check"></i><b>1.3</b> Menu Layout</a>
95 <ul>
96 <li class="chapter" data-level="1.3.1" data-path="basic-website-usage.html"><a href="basic-website-usage.html#menu-options"><i class="fa fa-check"></i><b>1.3.1</b> Menu Options</a></li>
97 </ul></li>
98 <li class="chapter" data-level="1.4" data-path="basic-website-usage.html"><a href="basic-website-usage.html#working-with-lists"><i class="fa fa-check"></i><b>1.4</b> Working with Lists</a>
99 <ul>
100 <li class="chapter" data-level="1.4.1" data-path="basic-website-usage.html"><a href="basic-website-usage.html#creating-lists"><i class="fa fa-check"></i><b>1.4.1</b> Creating lists</a></li>
101 <li class="chapter" data-level="1.4.2" data-path="basic-website-usage.html"><a href="basic-website-usage.html#viewing-and-editing-lists"><i class="fa fa-check"></i><b>1.4.2</b> Viewing and editing lists</a></li>
102 </ul></li>
103 <li class="chapter" data-level="1.5" data-path="basic-website-usage.html"><a href="basic-website-usage.html#user-permissions"><i class="fa fa-check"></i><b>1.5</b> User Permissions</a></li>
104 </ul></li>
105 <li class="chapter" data-level="2" data-path="searching-the-database.html"><a href="searching-the-database.html"><i class="fa fa-check"></i><b>2</b> Searching the Database</a>
106 <ul>
107 <li class="chapter" data-level="2.1" data-path="searching-the-database.html"><a href="searching-the-database.html#search-wizard"><i class="fa fa-check"></i><b>2.1</b> The Search Wizard</a>
108 <ul>
109 <li class="chapter" data-level="2.1.1" data-path="searching-the-database.html"><a href="searching-the-database.html#how-the-search-wizard-works"><i class="fa fa-check"></i><b>2.1.1</b> How the Search Wizard Works</a></li>
110 <li class="chapter" data-level="2.1.2" data-path="searching-the-database.html"><a href="searching-the-database.html#how-to-use-retrieved-data"><i class="fa fa-check"></i><b>2.1.2</b> How to use retrieved data</a></li>
111 <li class="chapter" data-level="2.1.3" data-path="searching-the-database.html"><a href="searching-the-database.html#updating-the-wizard"><i class="fa fa-check"></i><b>2.1.3</b> Updating the Wizard</a></li>
112 </ul></li>
113 <li class="chapter" data-level="2.2" data-path="searching-the-database.html"><a href="searching-the-database.html#accessions-and-plot-search"><i class="fa fa-check"></i><b>2.2</b> Accessions and Plot Search</a></li>
114 <li class="chapter" data-level="2.3" data-path="searching-the-database.html"><a href="searching-the-database.html#trials-search"><i class="fa fa-check"></i><b>2.3</b> Trials Search</a></li>
115 <li class="chapter" data-level="2.4" data-path="searching-the-database.html"><a href="searching-the-database.html#trait-search"><i class="fa fa-check"></i><b>2.4</b> Trait Search</a></li>
116 <li class="chapter" data-level="2.5" data-path="searching-the-database.html"><a href="searching-the-database.html#ontology-browser"><i class="fa fa-check"></i><b>2.5</b> Ontology Browser</a></li>
117 <li class="chapter" data-level="2.6" data-path="searching-the-database.html"><a href="searching-the-database.html#search-seedlots"><i class="fa fa-check"></i><b>2.6</b> Search Seedlots</a></li>
118 </ul></li>
119 <li class="chapter" data-level="3" data-path="managing-user-roles.html"><a href="managing-user-roles.html"><i class="fa fa-check"></i><b>3</b> Managing User Roles</a>
120 <ul>
121 <li class="chapter" data-level="3.1" data-path="managing-user-roles.html"><a href="managing-user-roles.html#what-are-user-roles"><i class="fa fa-check"></i><b>3.1</b> What are User Roles?</a></li>
122 <li class="chapter" data-level="3.2" data-path="managing-user-roles.html"><a href="managing-user-roles.html#the-manage-user-roles-page"><i class="fa fa-check"></i><b>3.2</b> The Manage User Roles page</a></li>
123 </ul></li>
124 <li class="chapter" data-level="4" data-path="managing-breeding-programs.html"><a href="managing-breeding-programs.html"><i class="fa fa-check"></i><b>4</b> Managing Breeding Programs</a></li>
125 <li class="chapter" data-level="5" data-path="managing-locations.html"><a href="managing-locations.html"><i class="fa fa-check"></i><b>5</b> Managing Locations</a></li>
126 <li class="chapter" data-level="6" data-path="managing-accessions.html"><a href="managing-accessions.html"><i class="fa fa-check"></i><b>6</b> Managing Accessions</a>
127 <ul>
128 <li class="chapter" data-level="6.1" data-path="managing-accessions.html"><a href="managing-accessions.html#add-accessions-using-a-list"><i class="fa fa-check"></i><b>6.1</b> Add Accessions Using A List</a></li>
129 <li class="chapter" data-level="6.2" data-path="managing-accessions.html"><a href="managing-accessions.html#uploading-accessions-and-accessions-info-from-a-file"><i class="fa fa-check"></i><b>6.2</b> Uploading Accessions and Accession’s Info From A File</a></li>
130 <li class="chapter" data-level="6.3" data-path="managing-accessions.html"><a href="managing-accessions.html#add-parentage-pedigree-information-to-accessions"><i class="fa fa-check"></i><b>6.3</b> Add Parentage (Pedigree) Information to Accessions</a></li>
131 <li class="chapter" data-level="6.4" data-path="managing-accessions.html"><a href="managing-accessions.html#working-with-grafts"><i class="fa fa-check"></i><b>6.4</b> Working with grafts</a></li>
132 <li class="chapter" data-level="6.5" data-path="managing-accessions.html"><a href="managing-accessions.html#bulk-renaming-of-accessions"><i class="fa fa-check"></i><b>6.5</b> Bulk renaming of accessions</a></li>
133 </ul></li>
134 <li class="chapter" data-level="7" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html"><i class="fa fa-check"></i><b>7</b> Managing Seed Lots</a>
135 <ul>
136 <li class="chapter" data-level="7.1" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#add-new-seedlots"><i class="fa fa-check"></i><b>7.1</b> Add New Seedlot(s)</a></li>
137 <li class="chapter" data-level="7.2" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#seedlot-transactions"><i class="fa fa-check"></i><b>7.2</b> Seedlot Transactions</a></li>
138 <li class="chapter" data-level="7.3" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#seed-inventory"><i class="fa fa-check"></i><b>7.3</b> Seed Inventory</a></li>
139 <li class="chapter" data-level="7.4" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#find-seedlots-for-a-list-of-accessions"><i class="fa fa-check"></i><b>7.4</b> Find Seedlots For a List of Accessions</a></li>
140 <li class="chapter" data-level="7.5" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#create-a-seedlot-for-an-accession-or-cross"><i class="fa fa-check"></i><b>7.5</b> Create a seedlot for an Accession or Cross</a></li>
141 <li class="chapter" data-level="7.6" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#add-quality-data-to-a-seedlot"><i class="fa fa-check"></i><b>7.6</b> Add quality data to a seedlot</a></li>
142 <li class="chapter" data-level="7.7" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#seedlot-maintenance-events"><i class="fa fa-check"></i><b>7.7</b> Seedlot Maintenance Events</a>
143 <ul>
144 <li class="chapter" data-level="7.7.1" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#setup"><i class="fa fa-check"></i><b>7.7.1</b> Setup</a></li>
145 <li class="chapter" data-level="7.7.2" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#adding-events"><i class="fa fa-check"></i><b>7.7.2</b> Adding Events</a></li>
146 <li class="chapter" data-level="7.7.3" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#displaying-events"><i class="fa fa-check"></i><b>7.7.3</b> Displaying Events</a></li>
147 <li class="chapter" data-level="7.7.4" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#downloading-events"><i class="fa fa-check"></i><b>7.7.4</b> Downloading Events</a></li>
148 </ul></li>
149 <li class="chapter" data-level="7.8" data-path="managing-seed-lots.html"><a href="managing-seed-lots.html#deleting-seedlots"><i class="fa fa-check"></i><b>7.8</b> Deleting Seedlots</a></li>
150 </ul></li>
151 <li class="chapter" data-level="8" data-path="managing-populations.html"><a href="managing-populations.html"><i class="fa fa-check"></i><b>8</b> Managing Populations</a></li>
152 <li class="chapter" data-level="9" data-path="managing-crosses.html"><a href="managing-crosses.html"><i class="fa fa-check"></i><b>9</b> Managing Crosses</a>
153 <ul>
154 <li class="chapter" data-level="9.1" data-path="managing-crosses.html"><a href="managing-crosses.html#crossing-experiment"><i class="fa fa-check"></i><b>9.1</b> Crossing Experiment</a>
155 <ul>
156 <li class="chapter" data-level="9.1.1" data-path="managing-crosses.html"><a href="managing-crosses.html#add-new-crossing-experiment"><i class="fa fa-check"></i><b>9.1.1</b> Add New Crossing Experiment</a></li>
157 </ul></li>
158 <li class="chapter" data-level="9.2" data-path="managing-crosses.html"><a href="managing-crosses.html#cross"><i class="fa fa-check"></i><b>9.2</b> Cross</a>
159 <ul>
160 <li class="chapter" data-level="9.2.1" data-path="managing-crosses.html"><a href="managing-crosses.html#add-new-crosses"><i class="fa fa-check"></i><b>9.2.1</b> Add New Crosses</a></li>
161 <li class="chapter" data-level="9.2.2" data-path="managing-crosses.html"><a href="managing-crosses.html#update-crosses-by-uploading"><i class="fa fa-check"></i><b>9.2.2</b> Update Crosses by Uploading</a></li>
162 </ul></li>
163 <li class="chapter" data-level="9.3" data-path="managing-crosses.html"><a href="managing-crosses.html#cross-wishlist"><i class="fa fa-check"></i><b>9.3</b> Cross Wishlist</a>
164 <ul>
165 <li class="chapter" data-level="9.3.1" data-path="managing-crosses.html"><a href="managing-crosses.html#create-a-cross-wishlist"><i class="fa fa-check"></i><b>9.3.1</b> Create a Cross Wishlist</a></li>
166 </ul></li>
167 <li class="chapter" data-level="9.4" data-path="managing-crosses.html"><a href="managing-crosses.html#crossing-experiment-detail-page"><i class="fa fa-check"></i><b>9.4</b> Crossing Experiment Detail Page</a></li>
168 <li class="chapter" data-level="9.5" data-path="managing-crosses.html"><a href="managing-crosses.html#cross-detail-page"><i class="fa fa-check"></i><b>9.5</b> Cross Detail Page</a></li>
169 </ul></li>
170 <li class="chapter" data-level="10" data-path="managing-field-trials.html"><a href="managing-field-trials.html"><i class="fa fa-check"></i><b>10</b> Managing Field Trials</a>
171 <ul>
172 <li class="chapter" data-level="10.1" data-path="managing-field-trials.html"><a href="managing-field-trials.html#trial-detail-page"><i class="fa fa-check"></i><b>10.1</b> Trial Detail Page</a></li>
173 <li class="chapter" data-level="10.2" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-trials"><i class="fa fa-check"></i><b>10.2</b> Adding Trials</a>
174 <ul>
175 <li class="chapter" data-level="10.2.1" data-path="managing-field-trials.html"><a href="managing-field-trials.html#prerequisites"><i class="fa fa-check"></i><b>10.2.1</b> Prerequisites</a></li>
176 <li class="chapter" data-level="10.2.2" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-a-trial-by-using-add-trial-form"><i class="fa fa-check"></i><b>10.2.2</b> Adding a trial by using “Add Trial” form</a></li>
177 <li class="chapter" data-level="10.2.3" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-a-trial-from-an-uploaded-file"><i class="fa fa-check"></i><b>10.2.3</b> Adding a trial from an uploaded file</a></li>
178 <li class="chapter" data-level="10.2.4" data-path="managing-field-trials.html"><a href="managing-field-trials.html#multi-location-trials"><i class="fa fa-check"></i><b>10.2.4</b> Multi-location trials</a></li>
179 <li class="chapter" data-level="10.2.5" data-path="managing-field-trials.html"><a href="managing-field-trials.html#viewing-plot-layout-and-trait-heatmap"><i class="fa fa-check"></i><b>10.2.5</b> Viewing Plot Layout and Trait HeatMap</a></li>
180 <li class="chapter" data-level="10.2.6" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-additional-information-in-the-trial-detail-page"><i class="fa fa-check"></i><b>10.2.6</b> Adding additional information in the “Trial Detail” page</a></li>
181 <li class="chapter" data-level="10.2.7" data-path="managing-field-trials.html"><a href="managing-field-trials.html#downloading-the-trial-layout-from-the-trial-detail-page"><i class="fa fa-check"></i><b>10.2.7</b> Downloading the Trial Layout from the “Trial Detail” page</a></li>
182 <li class="chapter" data-level="10.2.8" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-plant-entries-to-your-trial"><i class="fa fa-check"></i><b>10.2.8</b> Adding Plant Entries To Your Trial</a></li>
183 <li class="chapter" data-level="10.2.9" data-path="managing-field-trials.html"><a href="managing-field-trials.html#adding-tissue-sample-entries-to-your-trial"><i class="fa fa-check"></i><b>10.2.9</b> Adding Tissue Sample Entries To Your Trial</a></li>
184 <li class="chapter" data-level="10.2.10" data-path="managing-field-trials.html"><a href="managing-field-trials.html#uploading-gps-coordinates-for-plots"><i class="fa fa-check"></i><b>10.2.10</b> Uploading GPS Coordinates For Plots</a></li>
185 <li class="chapter" data-level="10.2.11" data-path="managing-field-trials.html"><a href="managing-field-trials.html#uploading-additional-files-to-trial"><i class="fa fa-check"></i><b>10.2.11</b> Uploading Additional Files To Trial</a></li>
186 <li class="chapter" data-level="10.2.12" data-path="managing-field-trials.html"><a href="managing-field-trials.html#deleting-trial-data"><i class="fa fa-check"></i><b>10.2.12</b> Deleting Trial Data</a></li>
187 </ul></li>
188 </ul></li>
189 <li class="chapter" data-level="11" data-path="managing-genotyping-plates.html"><a href="managing-genotyping-plates.html"><i class="fa fa-check"></i><b>11</b> Managing Genotyping Plates</a>
190 <ul>
191 <li class="chapter" data-level="11.1" data-path="managing-genotyping-plates.html"><a href="managing-genotyping-plates.html#adding-a-new-genotyping-plate"><i class="fa fa-check"></i><b>11.1</b> Adding a New Genotyping Plate</a></li>
192 <li class="chapter" data-level="11.2" data-path="managing-genotyping-plates.html"><a href="managing-genotyping-plates.html#genotyping-plate-detail-page"><i class="fa fa-check"></i><b>11.2</b> Genotyping Plate Detail Page</a></li>
193 </ul></li>
194 <li class="chapter" data-level="12" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html"><i class="fa fa-check"></i><b>12</b> Using Field Book App</a>
195 <ul>
196 <li class="chapter" data-level="12.1" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#a-typical-workflow"><i class="fa fa-check"></i><b>12.1</b> A typical workflow</a></li>
197 <li class="chapter" data-level="12.2" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-layout-files"><i class="fa fa-check"></i><b>12.2</b> Creating Field Layout Files for the Field Book App</a>
198 <ul>
199 <li class="chapter" data-level="12.2.1" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-field-layout-files-by-using-field-book-tools-page."><i class="fa fa-check"></i><b>12.2.1</b> Creating “Field Layout Files” by using “Field Book Tools” page.</a></li>
200 <li class="chapter" data-level="12.2.2" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-field-layout-files-by-using-trial-detail-page."><i class="fa fa-check"></i><b>12.2.2</b> Creating “Field Layout Files” by using “Trial Detail” page.</a></li>
201 </ul></li>
202 <li class="chapter" data-level="12.3" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-trait-files"><i class="fa fa-check"></i><b>12.3</b> Creating Trait Files for the Field Book App</a>
203 <ul>
204 <li class="chapter" data-level="12.3.1" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-a-trait-list"><i class="fa fa-check"></i><b>12.3.1</b> Creating a Trait List</a></li>
205 <li class="chapter" data-level="12.3.2" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#creating-a-trait-file"><i class="fa fa-check"></i><b>12.3.2</b> Creating a Trait File</a></li>
206 </ul></li>
207 <li class="chapter" data-level="12.4" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#transferring-files-from-your-computer-to-android-tablet"><i class="fa fa-check"></i><b>12.4</b> Transferring Files from Your Computer to Android Tablet</a>
208 <ul>
209 <li class="chapter" data-level="12.4.1" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#files-on-your-computer"><i class="fa fa-check"></i><b>12.4.1</b> Files on your computer</a></li>
210 <li class="chapter" data-level="12.4.2" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#files-on-your-android-tablet"><i class="fa fa-check"></i><b>12.4.2</b> Files on your Android tablet</a></li>
211 </ul></li>
212 <li class="chapter" data-level="12.5" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#setting-up-field-book-app-for-data-collection"><i class="fa fa-check"></i><b>12.5</b> Setting up “Field Book App” for data collection</a></li>
213 <li class="chapter" data-level="12.6" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#exporting-files-from-field-book-app"><i class="fa fa-check"></i><b>12.6</b> Exporting Files from Field Book App</a></li>
214 <li class="chapter" data-level="12.7" data-path="using-fieldbook-app.html"><a href="using-fieldbook-app.html#uploading-pheno-files"><i class="fa fa-check"></i><b>12.7</b> Uploading Phenotype Files to an SGN database</a></li>
215 </ul></li>
216 <li class="chapter" data-level="13" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html"><i class="fa fa-check"></i><b>13</b> Managing Phenotypic Data</a>
217 <ul>
218 <li class="chapter" data-level="13.1" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#uploading-fieldbook-phenotypes"><i class="fa fa-check"></i><b>13.1</b> Uploading Fieldbook Phenotypes</a>
219 <ul>
220 <li class="chapter" data-level="13.1.1" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#export-field-book-database-file"><i class="fa fa-check"></i><b>13.1.1</b> Export Field Book Database File</a></li>
221 <li class="chapter" data-level="13.1.2" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#upload-field-book-database-file"><i class="fa fa-check"></i><b>13.1.2</b> Upload Field Book Database File</a></li>
222 </ul></li>
223 <li class="chapter" data-level="13.2" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#uploading-spreadsheet-phenotypes"><i class="fa fa-check"></i><b>13.2</b> Uploading Spreadsheet Phenotypes</a>
224 <ul>
225 <li class="chapter" data-level="13.2.1" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#generating-spreadsheet-file"><i class="fa fa-check"></i><b>13.2.1</b> Generating Spreadsheet File</a></li>
226 <li class="chapter" data-level="13.2.2" data-path="managing-phenotypic-data.html"><a href="managing-phenotypic-data.html#uploading-spreadsheet-file"><i class="fa fa-check"></i><b>13.2.2</b> Uploading Spreadsheet File</a></li>
227 </ul></li>
228 </ul></li>
229 <li class="chapter" data-level="14" data-path="managing-barcodes.html"><a href="managing-barcodes.html"><i class="fa fa-check"></i><b>14</b> Managing Barcodes</a></li>
230 <li class="chapter" data-level="15" data-path="using-the-label-designer.html"><a href="using-the-label-designer.html"><i class="fa fa-check"></i><b>15</b> Using the Label Designer</a>
231 <ul>
232 <li class="chapter" data-level="15.0.1" data-path="using-the-label-designer.html"><a href="using-the-label-designer.html#first-select-a-datasource"><i class="fa fa-check"></i><b>15.0.1</b> First Select a Datasource</a></li>
233 <li class="chapter" data-level="15.0.2" data-path="using-the-label-designer.html"><a href="using-the-label-designer.html#set-page-and-label-size"><i class="fa fa-check"></i><b>15.0.2</b> Set Page and Label Size</a></li>
234 <li class="chapter" data-level="15.0.3" data-path="using-the-label-designer.html"><a href="using-the-label-designer.html#design-your-label"><i class="fa fa-check"></i><b>15.0.3</b> Design Your Label</a></li>
235 <li class="chapter" data-level="15.0.4" data-path="using-the-label-designer.html"><a href="using-the-label-designer.html#adjust-formatting-save-and-download"><i class="fa fa-check"></i><b>15.0.4</b> Adjust Formatting, Save, and Download</a></li>
236 </ul></li>
237 <li class="chapter" data-level="16" data-path="managing-downloads.html"><a href="managing-downloads.html"><i class="fa fa-check"></i><b>16</b> Managing Downloads</a></li>
238 <li class="chapter" data-level="17" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html"><i class="fa fa-check"></i><b>17</b> Managing ODK Data Collection</a>
239 <ul>
240 <li class="chapter" data-level="17.1" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html#ona-crossing-information"><i class="fa fa-check"></i><b>17.1</b> ONA Crossing Information</a>
241 <ul>
242 <li class="chapter" data-level="17.1.1" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html#managing-ona-crossing-information"><i class="fa fa-check"></i><b>17.1.1</b> Managing ONA Crossing Information</a></li>
243 <li class="chapter" data-level="17.1.2" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html#reviewing-plant-status"><i class="fa fa-check"></i><b>17.1.2</b> Reviewing Plant Status</a></li>
244 <li class="chapter" data-level="17.1.3" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html#graphical-summary-for-performed-crosses"><i class="fa fa-check"></i><b>17.1.3</b> Graphical Summary For Performed Crosses</a></li>
245 <li class="chapter" data-level="17.1.4" data-path="managing-odk-data-collection.html"><a href="managing-odk-data-collection.html#summary-information-for-performed-crosses"><i class="fa fa-check"></i><b>17.1.4</b> Summary Information For Performed Crosses</a></li>
246 </ul></li>
247 </ul></li>
248 <li class="chapter" data-level="18" data-path="managing-tissue-samples.html"><a href="managing-tissue-samples.html"><i class="fa fa-check"></i><b>18</b> Managing Tissue Samples</a>
249 <ul>
250 <li class="chapter" data-level="18.1" data-path="managing-tissue-samples.html"><a href="managing-tissue-samples.html#tissue-samples-from-field-trials"><i class="fa fa-check"></i><b>18.1</b> Tissue samples from field trials</a></li>
251 <li class="chapter" data-level="18.2" data-path="managing-tissue-samples.html"><a href="managing-tissue-samples.html#genotyping-plate-tissue-samples-96-or-384-well-plates"><i class="fa fa-check"></i><b>18.2</b> Genotyping Plate Tissue Samples (96 or 384 well plates)</a></li>
252 </ul></li>
253 <li class="chapter" data-level="19" data-path="managing-observation-variables.html"><a href="managing-observation-variables.html"><i class="fa fa-check"></i><b>19</b> Managing Observation Variables</a>
254 <ul>
255 <li class="chapter" data-level="19.1" data-path="managing-observation-variables.html"><a href="managing-observation-variables.html#managing-observation-variables-with-traits-methods-and-scales"><i class="fa fa-check"></i><b>19.1</b> Managing Observation Variables with Traits, Methods, and Scales</a></li>
256 </ul></li>
257 <li class="chapter" data-level="20" data-path="managing-image-data.html"><a href="managing-image-data.html"><i class="fa fa-check"></i><b>20</b> Managing Image Data</a>
258 <ul>
259 <li class="chapter" data-level="20.1" data-path="managing-image-data.html"><a href="managing-image-data.html#image-phenotyping-dashboard"><i class="fa fa-check"></i><b>20.1</b> Image-Phenotyping Dashboard</a></li>
260 <li class="chapter" data-level="20.2" data-path="managing-image-data.html"><a href="managing-image-data.html#image-input"><i class="fa fa-check"></i><b>20.2</b> Image Input</a></li>
261 <li class="chapter" data-level="20.3" data-path="managing-image-data.html"><a href="managing-image-data.html#standard-process"><i class="fa fa-check"></i><b>20.3</b> Standard Process</a></li>
262 <li class="chapter" data-level="20.4" data-path="managing-image-data.html"><a href="managing-image-data.html#ground-control-points"><i class="fa fa-check"></i><b>20.4</b> Ground Control Points</a></li>
263 </ul></li>
264 <li class="chapter" data-level="21" data-path="managing-vcf-data.html"><a href="managing-vcf-data.html"><i class="fa fa-check"></i><b>21</b> Managing VCF Data</a>
265 <ul>
266 <li class="chapter" data-level="21.1" data-path="managing-vcf-data.html"><a href="managing-vcf-data.html#uploading-vcf-data"><i class="fa fa-check"></i><b>21.1</b> Uploading VCF Data</a></li>
267 <li class="chapter" data-level="21.2" data-path="managing-vcf-data.html"><a href="managing-vcf-data.html#searching-and-downloading-vcf-data"><i class="fa fa-check"></i><b>21.2</b> Searching and Downloading VCF Data</a></li>
268 <li class="chapter" data-level="21.3" data-path="managing-vcf-data.html"><a href="managing-vcf-data.html#searching-protocols"><i class="fa fa-check"></i><b>21.3</b> Searching Protocols</a></li>
269 <li class="chapter" data-level="21.4" data-path="managing-vcf-data.html"><a href="managing-vcf-data.html#detail-pages-and-deletion"><i class="fa fa-check"></i><b>21.4</b> Detail Pages and Deletion</a></li>
270 </ul></li>
271 <li class="chapter" data-level="22" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html"><i class="fa fa-check"></i><b>22</b> Managing Spectral Data</a>
272 <ul>
273 <li class="chapter" data-level="22.1" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html#upload-spectral-data"><i class="fa fa-check"></i><b>22.1</b> Upload Spectral Data</a></li>
274 <li class="chapter" data-level="22.2" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html#evaluate-and-remove-outliers"><i class="fa fa-check"></i><b>22.2</b> Evaluate and Remove Outliers</a></li>
275 <li class="chapter" data-level="22.3" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html#plot-spectra"><i class="fa fa-check"></i><b>22.3</b> Plot Spectra</a></li>
276 <li class="chapter" data-level="22.4" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html#aggregate-spectra"><i class="fa fa-check"></i><b>22.4</b> Aggregate Spectra</a></li>
277 <li class="chapter" data-level="22.5" data-path="managing-spectral-data.html"><a href="managing-spectral-data.html#references"><i class="fa fa-check"></i><b>22.5</b> References</a></li>
278 </ul></li>
279 <li class="chapter" data-level="23" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html"><i class="fa fa-check"></i><b>23</b> Managing Sequence Metadata</a>
280 <ul>
281 <li class="chapter" data-level="23.1" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#what-is-sequence-metadata"><i class="fa fa-check"></i><b>23.1</b> What is Sequence Metadata?</a></li>
282 <li class="chapter" data-level="23.2" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#loading-sequence-metadata"><i class="fa fa-check"></i><b>23.2</b> Loading Sequence Metadata</a></li>
283 <li class="chapter" data-level="23.3" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#searching-sequence-metadata"><i class="fa fa-check"></i><b>23.3</b> Searching Sequence Metadata</a>
284 <ul>
285 <li class="chapter" data-level="23.3.1" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#basic-search"><i class="fa fa-check"></i><b>23.3.1</b> Basic Search</a></li>
286 <li class="chapter" data-level="23.3.2" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#advanced-search"><i class="fa fa-check"></i><b>23.3.2</b> Advanced Search</a></li>
287 </ul></li>
288 <li class="chapter" data-level="23.4" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#marker-integration"><i class="fa fa-check"></i><b>23.4</b> Marker Integration</a></li>
289 <li class="chapter" data-level="23.5" data-path="managing-sequence-metadata.html"><a href="managing-sequence-metadata.html#sequence-metadata-api"><i class="fa fa-check"></i><b>23.5</b> Sequence Metadata API</a></li>
290 </ul></li>
291 <li class="chapter" data-level="24" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html"><i class="fa fa-check"></i><b>24</b> Managing Outliers in Dataset</a>
292 <ul>
293 <li class="chapter" data-level="24.1" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#what-is-outliers-functionality-in-dataset"><i class="fa fa-check"></i><b>24.1</b> What is Outliers Functionality in Dataset ?</a></li>
294 <li class="chapter" data-level="24.2" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#accessing-trait-visualization"><i class="fa fa-check"></i><b>24.2</b> Accessing Trait Visualization</a></li>
295 <li class="chapter" data-level="24.3" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#interpreting-visual-elements"><i class="fa fa-check"></i><b>24.3</b> Interpreting Visual Elements</a></li>
296 <li class="chapter" data-level="24.4" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#choosing-cut-off-values"><i class="fa fa-check"></i><b>24.4</b> Choosing Cut-Off Values</a></li>
297 <li class="chapter" data-level="24.5" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#setting-deviation-multiplier"><i class="fa fa-check"></i><b>24.5</b> Setting Deviation Multiplier</a></li>
298 <li class="chapter" data-level="24.6" data-path="managing-outliers-in-dataset.html"><a href="managing-outliers-in-dataset.html#utilizing-graph-controls"><i class="fa fa-check"></i><b>24.6</b> Utilizing Graph Controls</a></li>
299 </ul></li>
300 <li class="chapter" data-level="25" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html"><i class="fa fa-check"></i><b>25</b> Data Analysis Tools</a>
301 <ul>
302 <li class="chapter" data-level="25.1" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#selection-index"><i class="fa fa-check"></i><b>25.1</b> Selection Index</a></li>
303 <li class="chapter" data-level="25.2" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#genomic-selection"><i class="fa fa-check"></i><b>25.2</b> Genomic Selection</a>
304 <ul>
305 <li class="chapter" data-level="25.2.1" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#method-1"><i class="fa fa-check"></i><b>25.2.1</b> Building a Model - Method 1:</a></li>
306 <li class="chapter" data-level="25.2.2" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#method-2"><i class="fa fa-check"></i><b>25.2.2</b> Building a Model - Method 2</a></li>
307 <li class="chapter" data-level="25.2.3" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#building-a-model---method-3"><i class="fa fa-check"></i><b>25.2.3</b> Building a Model - Method 3</a></li>
308 </ul></li>
309 <li class="chapter" data-level="25.3" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#genome-browsing"><i class="fa fa-check"></i><b>25.3</b> Genome Browsing</a>
310 <ul>
311 <li class="chapter" data-level="25.3.1" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#browsing-genotype-data-by-accession"><i class="fa fa-check"></i><b>25.3.1</b> Browsing Genotype data by Accession</a></li>
312 <li class="chapter" data-level="25.3.2" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#browsing-genotype-data-by-trial"><i class="fa fa-check"></i><b>25.3.2</b> Browsing Genotype data by Trial</a></li>
313 </ul></li>
314 <li class="chapter" data-level="25.4" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#principal-component-analysis-pca"><i class="fa fa-check"></i><b>25.4</b> Principal Component Analysis (PCA)</a></li>
315 <li class="chapter" data-level="25.5" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#anova"><i class="fa fa-check"></i><b>25.5</b> ANOVA</a></li>
316 <li class="chapter" data-level="25.6" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#clustering-k-means-hierarchical"><i class="fa fa-check"></i><b>25.6</b> Clustering (K-Means, Hierarchical)</a></li>
317 <li class="chapter" data-level="25.7" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#genetic-gain"><i class="fa fa-check"></i><b>25.7</b> Genetic Gain</a></li>
318 <li class="chapter" data-level="25.8" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#kinship-and-inbreeding-coefficients"><i class="fa fa-check"></i><b>25.8</b> Kinship and Inbreeding Coefficients</a></li>
319 <li class="chapter" data-level="25.9" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#creating-crossing-groups"><i class="fa fa-check"></i><b>25.9</b> Creating Crossing Groups</a></li>
320 <li class="chapter" data-level="25.10" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#search-wizard-genomic-relationship-matrix-grm-download"><i class="fa fa-check"></i><b>25.10</b> Search Wizard Genomic Relationship Matrix (GRM) Download</a></li>
321 <li class="chapter" data-level="25.11" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#search-wizard-genome-wide-association-study-gwas"><i class="fa fa-check"></i><b>25.11</b> Search Wizard Genome Wide Association Study (GWAS)</a></li>
322 <li class="chapter" data-level="25.12" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#spectral-analysis"><i class="fa fa-check"></i><b>25.12</b> Spectral Analysis</a>
323 <ul>
324 <li class="chapter" data-level="25.12.1" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#dataset-selection"><i class="fa fa-check"></i><b>25.12.1</b> Dataset selection</a></li>
325 <li class="chapter" data-level="25.12.2" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#cross-validation"><i class="fa fa-check"></i><b>25.12.2</b> Cross-validation</a></li>
326 <li class="chapter" data-level="25.12.3" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#preprocessing"><i class="fa fa-check"></i><b>25.12.3</b> Preprocessing</a></li>
327 <li class="chapter" data-level="25.12.4" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#algorithms"><i class="fa fa-check"></i><b>25.12.4</b> Algorithms</a></li>
328 <li class="chapter" data-level="25.12.5" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#output-common-model-summary-statistics"><i class="fa fa-check"></i><b>25.12.5</b> Output: common model summary statistics</a></li>
329 <li class="chapter" data-level="25.12.6" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#export-model-for-later-use"><i class="fa fa-check"></i><b>25.12.6</b> Export model for later use</a></li>
330 <li class="chapter" data-level="25.12.7" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#predict-phenotypes-from-an-exported-model-routine-use"><i class="fa fa-check"></i><b>25.12.7</b> Predict phenotypes from an exported model (routine use)</a></li>
331 <li class="chapter" data-level="25.12.8" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#faq"><i class="fa fa-check"></i><b>25.12.8</b> FAQ</a></li>
332 </ul></li>
333 <li class="chapter" data-level="25.13" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#general-mixed-model-tool"><i class="fa fa-check"></i><b>25.13</b> General Mixed Model Tool</a></li>
334 <li class="chapter" data-level="25.14" data-path="data-analysis-tools.html"><a href="data-analysis-tools.html#genomic-prediction-of-cross-performance-gcpc"><i class="fa fa-check"></i><b>25.14</b> Genomic Prediction of Cross Performance (GCPC)</a></li>
335 </ul></li>
336 <li class="divider"></li>
337 <li><a href="https://bookdown.org/" target="blank">Published with bookdown</a></li>
338 </ul>
340 </nav>
341 </div>
343 <div class="book-body">
344 <div class="body-inner">
345 <div class="book-header" role="navigation">
346 <h1>
347 <i class="fa fa-circle-o-notch fa-spin"></i><a href="./">User Manual of Breedbase</a>
348 </h1>
349 </div>
351 <div class="page-wrapper" tabindex="-1" role="main">
352 <div class="page-inner">
354 <section class="normal" id="section-">
355 <div id="managing-phenotypic-data" class="section level1 hasAnchor" number="13">
356 <h1><span class="header-section-number">Chapter 13</span> Managing Phenotypic Data<a href="managing-phenotypic-data.html#managing-phenotypic-data" class="anchor-section" aria-label="Anchor link to header"></a></h1>
357 <p>To facilitate uploading process for phenotypic data, “Manage Phenotypic Data” page provides two options for uploading: Field Book Phenotype file in database format and phenotype file in Excel (.xls or .xlsx) file format. To access “Manage Phenotypic Data” page, clicking on “Phenotyping” in the “Manage” menu.</p>
358 <p><img src="assets/images/image178.png" width="95%" style="display: block; margin: auto;" /></p>
359 <div id="uploading-fieldbook-phenotypes" class="section level2 hasAnchor" number="13.1">
360 <h2><span class="header-section-number">13.1</span> Uploading Fieldbook Phenotypes<a href="managing-phenotypic-data.html#uploading-fieldbook-phenotypes" class="anchor-section" aria-label="Anchor link to header"></a></h2>
361 <div id="export-field-book-database-file" class="section level3 hasAnchor" number="13.1.1">
362 <h3><span class="header-section-number">13.1.1</span> Export Field Book Database File<a href="managing-phenotypic-data.html#export-field-book-database-file" class="anchor-section" aria-label="Anchor link to header"></a></h3>
363 <p>The database upload of Field Book phenotype data relies on the “Database” format from the Field Book. Please make sure to export the “Database” format from the Field Book if you intend to upload the data using the Field Book Upload we describe below. If you prefer to use the “Table” format that the Field Book exports, you can modify this format to work with the Speadsheet Upload we describe below.</p>
364 </div>
365 <div id="upload-field-book-database-file" class="section level3 hasAnchor" number="13.1.2">
366 <h3><span class="header-section-number">13.1.2</span> Upload Field Book Database File<a href="managing-phenotypic-data.html#upload-field-book-database-file" class="anchor-section" aria-label="Anchor link to header"></a></h3>
367 <p>To upload a Field Book Phenotype file in a database format, click the “Upload Fieldbook” link</p>
368 <p><img src="assets/images/image185.png" width="95%" style="display: block; margin: auto;" /></p>
369 <p>The “Upload Fieldbook” link on this page and “Upload” link on the “Field Book Tools” page open the same dialogue. Please follow instructions for uploading phenotypic files on the <a href="using-fieldbook-app.html#using-fieldbook-app">12</a> page.</p>
370 <p><img src="assets/images/image112.png" width="95%" style="display: block; margin: auto;" /></p>
371 </div>
372 </div>
373 <div id="uploading-spreadsheet-phenotypes" class="section level2 hasAnchor" number="13.2">
374 <h2><span class="header-section-number">13.2</span> Uploading Spreadsheet Phenotypes<a href="managing-phenotypic-data.html#uploading-spreadsheet-phenotypes" class="anchor-section" aria-label="Anchor link to header"></a></h2>
375 <p>To upload a phenotype file in an Excel (.xls or .xlsx) file format, click the “Upload Spreadsheet” link.</p>
376 <p><img src="assets/images/image288.png" width="95%" style="display: block; margin: auto;" /></p>
377 <p>Please specify “Data Level” (Plots or Plants) and select the Excel file that you want to upload.</p>
378 <p><img src="assets/images/image68.png" width="95%" style="display: block; margin: auto;" /></p>
379 <div id="generating-spreadsheet-file" class="section level3 hasAnchor" number="13.2.1">
380 <h3><span class="header-section-number">13.2.1</span> Generating Spreadsheet File<a href="managing-phenotypic-data.html#generating-spreadsheet-file" class="anchor-section" aria-label="Anchor link to header"></a></h3>
381 <p>You can find more file format information by clicking on “Spreadsheet Format” link. Clicking on “Spreadsheet Format” will open the following dialog.</p>
382 <p><img src="assets/images/phenotype_spreadsheet_upload_help_dialog.png" width="75%" style="display: block; margin: auto;" /></p>
383 <p>Clicking on “Create Phenotyping Spreadsheet” will bring up a dialog where you can indicate the trial(s) you are interested in and the trait list you are interested in. Clicking “Submit” will download the xlsx file onto your computer, where you can then fill in the phenotypes.</p>
384 <p><img src="assets/images/create_phenotype_spreadsheet_dialog.png" width="95%" style="display: block; margin: auto;" /></p>
385 </div>
386 <div id="uploading-spreadsheet-file" class="section level3 hasAnchor" number="13.2.2">
387 <h3><span class="header-section-number">13.2.2</span> Uploading Spreadsheet File<a href="managing-phenotypic-data.html#uploading-spreadsheet-file" class="anchor-section" aria-label="Anchor link to header"></a></h3>
388 <p>To ensure that the file has a correct format for uploading, click on the “Verify” button. This will check the contents of the file and also perform quality checks on the values in the file. These checks include checking the trait definition for categorical values, minimum and maximum values, and data type checking. It will also check if there are already values uploaded for the given observation units and traits. If there are, there is an option to overwrite the existing values with the new values in your file. If the file is valid, only then can you click “Store” to store the information in the database.</p>
389 <p><img src="assets/images/phenotype_spreadsheet_upload_dialog.png" width="75%" style="display: block; margin: auto;" /></p>
391 </div>
392 </div>
393 </div>
394 </section>
396 </div>
397 </div>
398 </div>
399 <a href="using-fieldbook-app.html" class="navigation navigation-prev " aria-label="Previous page"><i class="fa fa-angle-left"></i></a>
400 <a href="managing-barcodes.html" class="navigation navigation-next " aria-label="Next page"><i class="fa fa-angle-right"></i></a>
401 </div>
402 </div>
403 <script src="libs/gitbook-2.6.7/js/app.min.js"></script>
404 <script src="libs/gitbook-2.6.7/js/clipboard.min.js"></script>
405 <script src="libs/gitbook-2.6.7/js/plugin-search.js"></script>
406 <script src="libs/gitbook-2.6.7/js/plugin-sharing.js"></script>
407 <script src="libs/gitbook-2.6.7/js/plugin-fontsettings.js"></script>
408 <script src="libs/gitbook-2.6.7/js/plugin-bookdown.js"></script>
409 <script src="libs/gitbook-2.6.7/js/jquery.highlight.js"></script>
410 <script src="libs/gitbook-2.6.7/js/plugin-clipboard.js"></script>
411 <script>
412 gitbook.require(["gitbook"], function(gitbook) {
413 gitbook.start({
414 "sharing": false,
415 "fontsettings": {
416 "theme": "white",
417 "family": "sans",
418 "size": 2
420 "edit": {
421 "link": null,
422 "text": null
424 "history": {
425 "link": null,
426 "text": null
428 "view": {
429 "link": null,
430 "text": null
432 "download": ["BreedbaseManual.pdf"],
433 "search": {
434 "engine": "fuse",
435 "options": null
437 "toc": {
438 "collapse": "section"
440 "info": false
443 </script>
445 <!-- dynamically load mathjax for compatibility with self-contained -->
446 <script>
447 (function () {
448 var script = document.createElement("script");
449 script.type = "text/javascript";
450 var src = "true";
451 if (src === "" || src === "true") src = "https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.9/latest.js?config=TeX-MML-AM_CHTML";
452 if (location.protocol !== "file:")
453 if (/^https?:/.test(src))
454 src = src.replace(/^https?:/, '');
455 script.src = src;
456 document.getElementsByTagName("head")[0].appendChild(script);
457 })();
458 </script>
459 </body>
461 </html>