autogenerated name metadata table
[sgn.git] / docs / searching-the-database.html
bloba4ef68d3ee403852e22b9d08285e234c3f24e282
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 2 Searching the Database | 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 2 Searching the Database | 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 2 Searching the Database | 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-07-22" />
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="basic-website-usage.html"/>
34 <link rel="next" href="managing-user-roles.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#email-alert-for-accession-upload"><i class="fa fa-check"></i><b>6.3</b> Email alert for accession upload</a></li>
131 <li class="chapter" data-level="6.4" data-path="managing-accessions.html"><a href="managing-accessions.html#add-parentage-pedigree-information-to-accessions"><i class="fa fa-check"></i><b>6.4</b> Add Parentage (Pedigree) Information to Accessions</a></li>
132 <li class="chapter" data-level="6.5" data-path="managing-accessions.html"><a href="managing-accessions.html#working-with-grafts"><i class="fa fa-check"></i><b>6.5</b> Working with grafts</a></li>
133 <li class="chapter" data-level="6.6" data-path="managing-accessions.html"><a href="managing-accessions.html#bulk-renaming-of-accessions"><i class="fa fa-check"></i><b>6.6</b> Bulk renaming of accessions</a></li>
134 </ul></li>
135 <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>
136 <ul>
137 <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>
138 <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>
139 <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>
140 <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>
141 <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>
142 <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>
143 <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>
144 <ul>
145 <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>
146 <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>
147 <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>
148 <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>
149 </ul></li>
150 <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>
151 </ul></li>
152 <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>
153 <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>
154 <ul>
155 <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>
156 <ul>
157 <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>
158 </ul></li>
159 <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>
160 <ul>
161 <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>
162 <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>
163 </ul></li>
164 <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>
165 <ul>
166 <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>
167 </ul></li>
168 <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>
169 <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>
170 </ul></li>
171 <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>
172 <ul>
173 <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>
174 <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>
175 <ul>
176 <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>
177 <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>
178 <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>
179 <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>
180 <li class="chapter" data-level="10.2.5" data-path="managing-field-trials.html"><a href="managing-field-trials.html#email-alert-for-multiple-trial-design-upload"><i class="fa fa-check"></i><b>10.2.5</b> Email alert for multiple trial design upload</a></li>
181 <li class="chapter" data-level="10.2.6" 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.6</b> Viewing Plot Layout and Trait HeatMap</a></li>
182 <li class="chapter" data-level="10.2.7" 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.7</b> Adding additional information in the “Trial Detail” page</a></li>
183 <li class="chapter" data-level="10.2.8" 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.8</b> Downloading the Trial Layout from the “Trial Detail” page</a></li>
184 <li class="chapter" data-level="10.2.9" 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.9</b> Adding Plant Entries To Your Trial</a></li>
185 <li class="chapter" data-level="10.2.10" 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.10</b> Adding Tissue Sample Entries To Your Trial</a></li>
186 <li class="chapter" data-level="10.2.11" 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.11</b> Uploading GPS Coordinates For Plots</a></li>
187 <li class="chapter" data-level="10.2.12" 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.12</b> Uploading Additional Files To Trial</a></li>
188 <li class="chapter" data-level="10.2.13" data-path="managing-field-trials.html"><a href="managing-field-trials.html#deleting-trial-data"><i class="fa fa-check"></i><b>10.2.13</b> Deleting Trial Data</a></li>
189 </ul></li>
190 </ul></li>
191 <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>
192 <ul>
193 <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>
194 <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>
195 </ul></li>
196 <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>
197 <ul>
198 <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>
199 <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>
200 <ul>
201 <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>
202 <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>
203 </ul></li>
204 <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>
205 <ul>
206 <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>
207 <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>
208 </ul></li>
209 <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>
210 <ul>
211 <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>
212 <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>
213 </ul></li>
214 <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>
215 <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>
216 <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>
217 </ul></li>
218 <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>
219 <ul>
220 <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>
221 <ul>
222 <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>
223 <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>
224 </ul></li>
225 <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>
226 <ul>
227 <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>
228 <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>
229 </ul></li>
230 </ul></li>
231 <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>
232 <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>
233 <ul>
234 <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>
235 <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>
236 <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>
237 <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>
238 </ul></li>
239 <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>
240 <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>
241 <ul>
242 <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>
243 <ul>
244 <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>
245 <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>
246 <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>
247 <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>
248 </ul></li>
249 </ul></li>
250 <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>
251 <ul>
252 <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>
253 <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>
254 </ul></li>
255 <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>
256 <ul>
257 <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>
258 </ul></li>
259 <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>
260 <ul>
261 <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>
262 <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>
263 <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>
264 <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>
265 </ul></li>
266 <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>
267 <ul>
268 <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>
269 <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>
270 <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>
271 <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>
272 </ul></li>
273 <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>
274 <ul>
275 <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>
276 <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>
277 <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>
278 <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>
279 <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>
280 </ul></li>
281 <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>
282 <ul>
283 <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>
284 <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>
285 <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>
286 <ul>
287 <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>
288 <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>
289 </ul></li>
290 <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>
291 <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>
292 </ul></li>
293 <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>
294 <ul>
295 <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>
296 <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>
297 <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>
298 <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>
299 <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>
300 <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>
301 </ul></li>
302 <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>
303 <ul>
304 <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>
305 <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>
306 <ul>
307 <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>
308 <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>
309 <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>
310 </ul></li>
311 <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>
312 <ul>
313 <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>
314 <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>
315 </ul></li>
316 <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>
317 <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>
318 <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>
319 <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>
320 <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>
321 <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>
322 <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>
323 <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>
324 <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>
325 <ul>
326 <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>
327 <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>
328 <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>
329 <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>
330 <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>
331 <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>
332 <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>
333 <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>
334 </ul></li>
335 <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>
336 <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>
337 </ul></li>
338 <li class="divider"></li>
339 <li><a href="https://bookdown.org/" target="blank">Published with bookdown</a></li>
340 </ul>
342 </nav>
343 </div>
345 <div class="book-body">
346 <div class="body-inner">
347 <div class="book-header" role="navigation">
348 <h1>
349 <i class="fa fa-circle-o-notch fa-spin"></i><a href="./">User Manual of Breedbase</a>
350 </h1>
351 </div>
353 <div class="page-wrapper" tabindex="-1" role="main">
354 <div class="page-inner">
356 <section class="normal" id="section-">
357 <div id="searching-the-database" class="section level1 hasAnchor" number="2">
358 <h1><span class="header-section-number">Chapter 2</span> Searching the Database<a href="searching-the-database.html#searching-the-database" class="anchor-section" aria-label="Anchor link to header"></a></h1>
359 <p>You can search for information on the database by using the following search options: Wizard, which uses combined criteria specified by users; Accessions and Plots; Trials; Markers; Images; People; FAQ.</p>
360 <p><img src="assets/images/image267.png" width="95%" style="display: block; margin: auto;" /></p>
361 <div id="search-wizard" class="section level2 hasAnchor" number="2.1">
362 <h2><span class="header-section-number">2.1</span> The Search Wizard<a href="searching-the-database.html#search-wizard" class="anchor-section" aria-label="Anchor link to header"></a></h2>
363 <p><img src="assets/images/wizard_interface.png" width="95%" style="display: block; margin: auto;" /></p>
364 <div id="how-the-search-wizard-works" class="section level3 hasAnchor" number="2.1.1">
365 <h3><span class="header-section-number">2.1.1</span> How the Search Wizard Works<a href="searching-the-database.html#how-the-search-wizard-works" class="anchor-section" aria-label="Anchor link to header"></a></h3>
366 <p>The search wizard presents a number of select boxes, which are initially empty. You start searching by picking a category of data from the dropdown above the left-most select box.</p>
367 <p>Once a category has been picked, the database will retrieve all the options within this category and display them within the first select box. You then select one or more options from the first select box, which activates the second dropdown.</p>
368 <p>You can then select a category from the second dropdown, and repeat this same search process through all four dropdowns and select boxes.</p>
369 <p><img src="assets/images/wizard_interface_selections.png" width="95%" style="display: block; margin: auto;" /></p>
370 <ul>
371 <li><p>In the example above, the “locations” category was chosen in the first dropdown. The first select box then displayed all the possible locations in the database. The option Ibadan was selected.</p></li>
372 <li><p>This activated the second dropdown. The category “years” was chosen in the second dropdown. The second select box then displayed all the years that are linked in the database to the location Ibadan. From that list, the options 2011 and 2012 were selected.</p></li>
373 <li><p>This activated the third dropdown. A final category, “accessions”, was chosen in the third dropdown. The third select box was then populated with the 3847 accessions in the database that are linked with the location Ibadan in the years 2011 or 2012.</p></li>
374 </ul>
375 <p>In addition to the basic search operations demonstrated above, users can take advantage of two more features:</p>
376 <p><strong>Load Selection from List</strong></p>
377 <p><img src="assets/images/wizard_select_list.png" width="25%" style="display: block; margin: auto;" /></p>
378 <ul>
379 <li>Instead of picking a category in the first dropdown, users can instead populate the first selectbox from a list by scrolling down in the first dropdown to the “Load Selection from List” subheading and selecting a list. This is useful for starting queries with a list of plots, as this category is not among the options in the first dropdown.</li>
380 </ul>
381 <p><strong>ANY/MIN/ALL</strong> Toggle</p>
382 <p><img src="assets/images/wizard_any_min_all_toggle.jpg" width="25%" style="display: block; margin: auto;" /></p>
383 <ul>
384 <li><p>By default, the search wizard combines options within a category using an OR query. In the example above, in the third panel the wizard retrieved accessions associated with the location ‘Ibadan’ in <strong>ANY</strong> of the years “2011 <strong>OR</strong> 2012</p></li>
385 <li><p>If the user clicked the toggle below the second select box to change it to <strong>ALL</strong> before choosing accessions in the third dropdown, the wizard would instead retrieve accessions associated with the location ‘Ibadan’ in the years “2011 <strong>AND</strong> 2012”. This will be a smaller set of accessions, because any accessions used only in 2011, or only in 2012 will be excluded.</p></li>
386 <li><p>A more advanced search could use the <strong>MIN</strong> toggle option. This allows the user to make a query in between an ANY or ALL query, where a minimum number of matches from the selected column will be used as a filter for the next column. The minimum can be provided as either a percentage (%) or an actual count of items (#). In the example above, if the years 2011, 2012, and 2013 were selected in the second column, the user could enter ‘2’ in as the minimum and select ‘#’ as the minimum match type. This would select accessions in the third column that were used in 2 or more of the selected years.<br /></p></li>
387 </ul>
388 <p><img src="assets/images/wizard_any_min_all_toggle_min_details.jpg" width="25%" style="display: block; margin: auto;" /></p>
389 </div>
390 <div id="how-to-use-retrieved-data" class="section level3 hasAnchor" number="2.1.2">
391 <h3><span class="header-section-number">2.1.2</span> How to use retrieved data<a href="searching-the-database.html#how-to-use-retrieved-data" class="anchor-section" aria-label="Anchor link to header"></a></h3>
392 <div id="getting-more-info" class="section level4 unnumbered hasAnchor">
393 <h4>Getting more Info<a href="searching-the-database.html#getting-more-info" class="anchor-section" aria-label="Anchor link to header"></a></h4>
394 <p>Any option in the wizard select boxes (except for years) can be clicked to open a page with more details. The new page is opened in a new tab.</p>
395 </div>
396 <div id="saving-to-a-list" class="section level4 unnumbered hasAnchor">
397 <h4>Saving to a list<a href="searching-the-database.html#saving-to-a-list" class="anchor-section" aria-label="Anchor link to header"></a></h4>
398 <p>You can store the highlighted items in any selected box to lists. This is done using the inputs and buttons directly below the select box. <strong>Don’t forget, you must be logged in to work with lists!</strong></p>
399 <p><img src="assets/images/add_create_list.png" width="50%" style="display: block; margin: auto;" /></p>
400 <ul>
401 <li><p>To <strong>add items to an existing list</strong>, first pick an existing list using the “Add to List…” dropdown on the left. Then click the “Add” button. A popup window will confirm the action, and display the number of items added to your existing list.</p></li>
402 <li><p>To <strong>store items to a new list</strong>, first type a new list name in the “Create New List…” text input on the left. Then click on the “Create” button. A popup window will confirm the action, and display the number of items added to your new list.</p></li>
403 </ul>
404 </div>
405 <div id="downloading-data" class="section level4 unnumbered hasAnchor">
406 <h4>Downloading Data<a href="searching-the-database.html#downloading-data" class="anchor-section" aria-label="Anchor link to header"></a></h4>
407 <p>You can download trial metadata, phenotypes and genotypes associated with the highlighted items in the wizard select boxes. This is done using the buttons in the download section at the bottom of the page. <strong>Don’t forget, you must be logged in to download data!</strong></p>
408 <p><img src="assets/images/wizard_download_options.png" width="75%" style="display: block; margin: auto;" /></p>
409 <div id="metadata" class="section level5 unnumbered hasAnchor">
410 <h5>Metadata<a href="searching-the-database.html#metadata" class="anchor-section" aria-label="Anchor link to header"></a></h5>
411 <p>Trial metadata can be downloaded by selecting a subset of trials from the database or based on your search categories. To download, click on “Related Trial Metadata”, a dialog will appear. Select download format and click the “Metadata” button to complete your download.</p>
412 <p><img src="assets/images/wizard_related_metadata_download.png" width="75%" style="display: block; margin: auto;" /></p>
413 </div>
414 <div id="phenotypes" class="section level5 unnumbered hasAnchor">
415 <h5>Phenotypes<a href="searching-the-database.html#phenotypes" class="anchor-section" aria-label="Anchor link to header"></a></h5>
416 <p>The phenotypes download is quite flexible, and can download a subset of all the trial data in the database based on whichever categories and options you currently have selected. Simply click on the “Related Trial Phenotypes” link, review the options, changing or adding any additional parameters you like, then click ‘Download Phenotypes’.</p>
417 <p><img src="assets/images/wizard_related_phenotypes_download.png" width="75%" style="display: block; margin: auto;" /></p>
418 </div>
419 <div id="genotypes" class="section level5 unnumbered hasAnchor">
420 <h5>Genotypes<a href="searching-the-database.html#genotypes" class="anchor-section" aria-label="Anchor link to header"></a></h5>
421 <p>The genotype download is more stringent. It requires a minimum of one accession and one genotyping protocol to be selected in the wizard select boxes. The text box in the download section of the page will help track what has been selected. Once clicked, the “Download Genotypes” button will download a genotype file for the selected accessions.</p>
422 </div>
423 </div>
424 <div id="saving-the-wizard-selections" class="section level4 unnumbered hasAnchor">
425 <h4>Saving the wizard selections<a href="searching-the-database.html#saving-the-wizard-selections" class="anchor-section" aria-label="Anchor link to header"></a></h4>
426 <p>As discussed above, the selections of the individual select boxes in the wizard can be saved separately to a list. The lists can be used as inputs in other tools on the site. However, sometimes creating a selection is quite time consuming and restoring the selections from four different lists would be cumbersome too. Therefore, the selections can be saved together in a dataset, and named for later retrieval. This is done in the section “Load/Create Datasets” that is below the first two wizard select boxes. To select an existing dataset, one uses the “Load Dataset” dropdown. A particular dataset can be chosen, and the “Load” button can be clicked to retrieve and display the dataset in the wizard. To create a new dataset using items that are selected in the wizard, one can enter the name of the new dataset in the “Create New Dataset” text box. Once the dataset has been given a name, clicking the “Create” button will save the new dataset.</p>
427 <p><img src="assets/images/wizard_load_create_dataset.png" width="75%" style="display: block; margin: auto;" /></p>
428 </div>
429 </div>
430 <div id="updating-the-wizard" class="section level3 hasAnchor" number="2.1.3">
431 <h3><span class="header-section-number">2.1.3</span> Updating the Wizard<a href="searching-the-database.html#updating-the-wizard" class="anchor-section" aria-label="Anchor link to header"></a></h3>
432 <p>The search wizard uses a copy of the database, or a cache, to return results quickly. If data appears to be missing, it usually means that the cache needs to be updated. Users with submitter privileges or above can do this using the ‘Update Wizard’ button. One can also use the ‘Refresh Lists’ button to update the available lists.</p>
433 <p><img src="assets/images/wizard_update_list_refresh.png" width="75%" style="display: block; margin: auto;" /></p>
434 <p>This will take just a few seconds in small databases, but may take a few hours to complete in larger databases.</p>
435 </div>
436 </div>
437 <div id="accessions-and-plot-search" class="section level2 hasAnchor" number="2.2">
438 <h2><span class="header-section-number">2.2</span> Accessions and Plot Search<a href="searching-the-database.html#accessions-and-plot-search" class="anchor-section" aria-label="Anchor link to header"></a></h2>
439 <p>Accessions and their related materials (cross, plant, plot, population, tissue_sample, training population) can be searched by using “Search Accessions and Plots” page. On this page, “accession” is the default stock type; however, you can change stock type by selecting an option from the drop-down list.
440 From this page you can construct detailed queries for stock types. For example, by using the “Usage” section, the “Properties” section, and the “Phenotypes” section you could search for accessions which were diploids used in a specific year and location and were also phenotyped for height. You can also search for accessions based on genetic properties, such as the location of an introgression on a specific chromosome.</p>
441 <p><img src="assets/images/search_accessions.png" width="95%" style="display: block; margin: auto;" /></p>
442 <p>It is possible to query over any of the available properties, such as “ploidy_level”, “country of origin”, “introgression_chromosome”, etc.</p>
443 <p><img src="assets/images/search_accessions_properties_search.png" width="95%" style="display: block; margin: auto;" /></p>
444 <p>In the search result table it is possible to select any of the available properties to view.</p>
445 <p><img src="assets/images/search_accessions_properties_view.png" width="95%" style="display: block; margin: auto;" /></p>
446 <p>At the bottom of the accession search there is a phenotype graphical filtering tool. Here you can filter down accessions based on combinations of trait performance. The filtered down accessions are then able to be saved to a list.</p>
447 <p><img src="assets/images/search_accessions_graphical_filtering.png" width="95%" style="display: block; margin: auto;" /></p>
448 <p>For information on adding Accessions please see the Managing Accessions help.
449 For information on how field trial plots, plants, tissue samples, and subplots are added to the database, please see the Managing Field Trials help.</p>
450 </div>
451 <div id="trials-search" class="section level2 hasAnchor" number="2.3">
452 <h2><span class="header-section-number">2.3</span> Trials Search<a href="searching-the-database.html#trials-search" class="anchor-section" aria-label="Anchor link to header"></a></h2>
453 <p>Trials on the database can be searched based on trial name, description, breeding program, year, location, trial type, design, planting date, and harvest date.</p>
454 <p><img src="assets/images/trial_search.png" width="95%" style="display: block; margin: auto;" /></p>
455 </div>
456 <div id="trait-search" class="section level2 hasAnchor" number="2.4">
457 <h2><span class="header-section-number">2.4</span> Trait Search<a href="searching-the-database.html#trait-search" class="anchor-section" aria-label="Anchor link to header"></a></h2>
458 <p>On the Trait Search page (menu item <code>Search &gt; Traits</code>), traits in the database can be searched by ID, name, or descripiton. Optionally, a starting list of traits can be selected to filter down results.</p>
459 <p><img src="assets/images/trait-search-default.png" width="95%" style="display: block; margin: auto;" /></p>
460 <p>Selecting traits in the results of the search allows one to add the selected results to a trait list, or create a new trait list from the select results.</p>
461 <p><img src="assets/images/trait-search.png" width="95%" style="display: block; margin: auto;" /></p>
462 </div>
463 <div id="ontology-browser" class="section level2 hasAnchor" number="2.5">
464 <h2><span class="header-section-number">2.5</span> Ontology Browser<a href="searching-the-database.html#ontology-browser" class="anchor-section" aria-label="Anchor link to header"></a></h2>
465 <p>A more advanced tool for searching for Traits is the ontology browser, available by clicking on Analyze and Ontology Browser. From here you can search ontologies and see the various classifications of terms in a tree display.</p>
466 <p><img src="assets/images/ontology_browser.png" width="95%" style="display: block; margin: auto;" /></p>
467 <p>The terms which appear in the Trait Search in 2.4 are only variable terms. The ontology browser shows these variables as different from their grouping terms by indicating VARIABLE_OF like in the following screenshot.</p>
468 <p><img src="assets/images/ontology_browser_variable.png" width="95%" style="display: block; margin: auto;" /></p>
469 </div>
470 <div id="search-seedlots" class="section level2 hasAnchor" number="2.6">
471 <h2><span class="header-section-number">2.6</span> Search Seedlots<a href="searching-the-database.html#search-seedlots" class="anchor-section" aria-label="Anchor link to header"></a></h2>
472 <p>Seedlots are different from Accessions in that they represent the physical seed being evaluated in an experiment. Seedlots have things like physical storage locations and seed quantities, which accessions do not. To search for available seedlots you go to Manage and then click Seed Lots. By clicking Search Seedlots, you can specify query information. The results from your search will be in the table below the search form.</p>
473 <p><img src="assets/images/search_seedlots.png" width="95%" style="display: block; margin: auto;" /></p>
474 <p><img src="assets/images/manage_seedlots.png" width="95%" style="display: block; margin: auto;" /></p>
476 </div>
477 </div>
478 </section>
480 </div>
481 </div>
482 </div>
483 <a href="basic-website-usage.html" class="navigation navigation-prev " aria-label="Previous page"><i class="fa fa-angle-left"></i></a>
484 <a href="managing-user-roles.html" class="navigation navigation-next " aria-label="Next page"><i class="fa fa-angle-right"></i></a>
485 </div>
486 </div>
487 <script src="libs/gitbook-2.6.7/js/app.min.js"></script>
488 <script src="libs/gitbook-2.6.7/js/clipboard.min.js"></script>
489 <script src="libs/gitbook-2.6.7/js/plugin-search.js"></script>
490 <script src="libs/gitbook-2.6.7/js/plugin-sharing.js"></script>
491 <script src="libs/gitbook-2.6.7/js/plugin-fontsettings.js"></script>
492 <script src="libs/gitbook-2.6.7/js/plugin-bookdown.js"></script>
493 <script src="libs/gitbook-2.6.7/js/jquery.highlight.js"></script>
494 <script src="libs/gitbook-2.6.7/js/plugin-clipboard.js"></script>
495 <script>
496 gitbook.require(["gitbook"], function(gitbook) {
497 gitbook.start({
498 "sharing": false,
499 "fontsettings": {
500 "theme": "white",
501 "family": "sans",
502 "size": 2
504 "edit": {
505 "link": null,
506 "text": null
508 "history": {
509 "link": null,
510 "text": null
512 "view": {
513 "link": null,
514 "text": null
516 "download": ["BreedbaseManual.pdf"],
517 "search": {
518 "engine": "fuse",
519 "options": null
521 "toc": {
522 "collapse": "section"
524 "info": false
527 </script>
529 <!-- dynamically load mathjax for compatibility with self-contained -->
530 <script>
531 (function () {
532 var script = document.createElement("script");
533 script.type = "text/javascript";
534 var src = "true";
535 if (src === "" || src === "true") src = "https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.9/latest.js?config=TeX-MML-AM_CHTML";
536 if (location.protocol !== "file:")
537 if (/^https?:/.test(src))
538 src = src.replace(/^https?:/, '');
539 script.src = src;
540 document.getElementsByTagName("head")[0].appendChild(script);
541 })();
542 </script>
543 </body>
545 </html>