Using the Field Book App and BIMS in

Using the Field Book App and BIMS in GDR for Peach Breeding Ksenija Gasic, Trevor Rife, Jesse Poland, Sook Jung, Jim Mc. Ferson, Michael Coe, Kate Evans, Nnadozie Oraguzie, Lisa Wasko De. Vetter, Cameron Peace, Mercy Olmstead, Michael Kahn, Dorrie Main

Outline • Using the Field. Book App in peach breeding • Demo of GDR BIMS (Breeding Information Management System)

Collecting Field notes Get the App by searching for Field Book github. com/trife wheatgenetics. org/apps

Field. Book App

Field. Book App - traits Numeric Date Photo Categorical Percent Multicat Rust Rating Text Counter

Field. Book App – import file Field_ID NVB_1_1 -3_KV 970512 -501 NVB_1_7 -9_KV 930465 -301 NVB_1_10 -12_KV 980677 -801 NVB_1_13 -15_KV 980316 -701 NVB_1_16 -18_KV 930386 -401 NVB_1_19 -21_KV 980330 -601 NVB_1_22 -24_Sweet Dream NVB_1_25 -26_Galaxy NVB_1_27 -29_China Pearl NVB_1_36 -38_Intrepid NVB_1_39 -40_Carolina Gold NVB_1_42 -44_Summer Gold NVB_1_45 -47_Belle of Georgia NVB_1_49 -50_Flameprince NVB_2_25 -27_Late Large 23 NVB_2_22, 24_5 D Big NVB_2_19 -21_9 Ball Row Tree 11_3 17_9 110_12 113_15 116_18 119_21 122_24 125_26 127_29 136_38 139_40 142_44 145_47 149_50 225_27 222, 24 219_21 Name KV 970512 -501 KV 930465 -301 KV 980677 -801 KV 980316 -701 KV 930386 -401 KV 980330 -601 Sweet Dream Galaxy China Pearl Intrepid Carolina Gold Summer Gold Belle of Georgia Flameprince Late Large 23 5 D Big 9 Ball R_T R 1 T 1_3 R 1 T 7_9 R 1 T 10_12 R 1 T 13_15 R 1 T 16_18 R 1 T 19_21 R 1 T 22_24 R 1 T 25_26 R 1 T 27_29 R 1 T 36_38 R 1 T 39_40 R 1 T 42_44 R 1 T 45_47 R 1 T 49_50 R 2 T 25_27 R 2 T 22, 24 R 2 T 19_21

Field. Book App – exporting data • Export to CSV files • Two formats: database, table • Choose what gets exported • All field columns vs. Unique ID • All traits vs. Active traits • Overwrite previous export • Option to share to other services after export

Field. Book App – export formats Database Field_ID Row Tree NVB_1_25 -26_Galaxy 125_26 NVB_4_49 -50_BY 01 z 1957 t 449_50 NVB_4_43 -45_BY 00 m 2264 z 443_45 Name Galaxy BY 01 z 1957 t BY 00 m 2264 z R_T R 1 T 25_26 R 4 T 49_50 R 4 T 43_45 trait 50% Bloom 90% Bloom value 2015. 3. 10 2015. 3. 12 2015. 3. 11 2015. 3. 8 2015. 3. 10 person trey_ trey_ timestamp 2015. 03. 11 16: 00: 37 2015. 03. 11 16: 00: 45 2015. 03. 11 16: 02: 06 2015. 03. 11 16: 02: 15 2015. 03. 11 16: 02: 18 Table Field_ID NVB_1_1 -3_KV 970512 -501 NVB_1_7 -9_KV 930465 -301 NVB_1_10 -12_KV 980677 -801 NVB_1_13 -15_KV 980316 -701 NVB_1_16 -18_KV 930386 -401 Row Tree 11_3 17_9 110_12 113_15 116_18 Name KV 970512 -501 KV 930465 -301 KV 980677 -801 KV 980316 -701 KV 930386 -401 R_T R 1 T 1_3 R 1 T 7_9 R 1 T 10_12 R 1 T 13_15 R 1 T 16_18 50% Bloom 2015. 3. 10 2015. 3. 11 2015. 3. 8 2015. 3. 12 90% Bloom 2015. 3. 12 2015. 3. 13 2015. 3. 10 2015. 3. 15

Using the Field. Book App in peach breeding • Field. Book app downloaded on two tablets and one phone • All material relevant for the peach breeding program and planted at the research farm, prepared as “import files”, uploaded into the app • Traits prepared and uploaded to all devices • Collected data stays within the app • No syncing between devices available – will be part of BIMS • Weekly export of collected data and update of the import files with column “evaluated” (yes/no) allows the tracking of what has been evaluated

Using the Field. Book App in peach breeding • Data are connected with the Unique_ID not the import file name • Data can be changed in the app and lost if not downloaded frequently • Data stay in the app until the database has been reset • Reset removes the data from the app and disconnects the collected audio and photo data from unique_ID • Prior to resetting download the database • Field. Book is used for collection of data in field and in lab

Vision of BIMS To aid new cultivar development by providing individual breeders with a secure and comprehensive online breeding information management system which will allow them to: • Store, manage, archive and analyze their private breeding program data • Fully integrate their data with publicly available genomic, genetic and breeding data • Manage data from the Field Book App, an android app for efficient collection of phenotype data in the field and laboratory

Components of BIMS in GDR • Archive • Manage Breeding • Data Import, Edit and Download • Search and Compare • Field Book App Management • Data Analysis Tools • Breeding Decision Tools

BIMS Home Login from GDR home page accesses the breeders private BIMS

Archive complete breeding program data to PC and view history of archiving

Manage Breeding – Manage Program Add members and give them privileges to read or read/write

Manage Breeding – Manage Lists Create lists of germplasm and traits to make phenotypic data collection sheets, download phenotypic or genotypic data in ‘Download’ or any other future BIMS tools.

Manage Breeding – Manage Traits • View existing traits and trait details • Add/edit/delete traits in admin menu

Manage Breeding – Manage Trials View all trials. Clicking on a trial name, populates the trial description

Manage Breeding – Manage Trials Add new trials, edit or remove trials from the program.

Manage Breeding – Manage Trials View all trials. Right click and create new folders and move trials into the new folder.

Manage Breeding – Manage Trials Clicking on trial provides data selectable by trait, stats about the trait and access to view/ download all the data for the trial.

Manage Breeding – Manage Trials The phenotypic data can be sorted by column heading. We will add ability to select what data is displayed in the table

Manage Breeding – Manage Trials The Breeding Line Tree shows all the progeny and breeding lines that have been tested. Clicking on a breeding line shows all the trials where the breeding line was phenotyped, Clicking any trial name will access the same phenotype page with the statistical information and the entire phenotype data.

Data Import - Templates In data import, templates for each type of data are available for download in template list page. Data import for Field Book App output will be shortly available.

Data Import – Upload data from Templates In data upload, files can be uploaded. The status of the upload is shown. The history of files uploaded is being added with submission details.

Search – By Germplasm Name Search by name, search germplasm records by name or upload a file of germplasm to return summary details, then drill down to crosses, trials and phenotype data for that germplasm.

Download – By Trial Download all the phenotype data by trial. Download by list available later.

Field. Book App Management Upload trait evaluation data collected with the Field Book App to BIMS Download trait data collection files in Field Book Format

Timeline for Development • V 1. 0 by January 2017 • Load complete breeding program data and tested by breeder • Feedback from breeders on proposed BIMS • V 1. 0 by June 2017 • Excel template and Field. Book App data loading available • Search germplasm by name, parentage, trait, and genotype available • Archiving available • V 2. 0 by September 2017 • Compare by germplasm and dataset available