delivery – plant science pbmass (pedigree based marker assisted selection system) david rodgers
TRANSCRIPT
![Page 1: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/1.jpg)
Delivery – Plant Science
PBMASS(Pedigree Based Marker Assisted Selection System)
David Rodgers
![Page 2: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/2.jpg)
Delivery – Plant Science
Change databaseOr File->Open New blank database
Or File->New
Create a new blank database called PBMASSDemo.mdb
![Page 3: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/3.jpg)
Delivery – Plant Science
Change Background image:Tools->Options->Theme->Select Background Image
![Page 4: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/4.jpg)
Delivery – Plant Science
Tools->Options->Prompt Update Existing GermplasmTools->Options->Prompt Update Preferred Name
![Page 5: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/5.jpg)
Delivery – Plant Science
Import->Pedigrees->From File
Female Parent, Male Parent Format(Me, My Mum, My Dad)
Column headings: Genotype, Aliases, Female Parent, Male Parent, Selection History, Comment
![Page 6: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/6.jpg)
Delivery – Plant Science
Import->Pedigrees->From File
Purdy FormatColumn Headings:
Genotype, Aliases, Parentage, Selection History, Comment
![Page 7: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/7.jpg)
Delivery – Plant Science
![Page 8: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/8.jpg)
Delivery – Plant Science
Tools->List Manager->Import
![Page 9: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/9.jpg)
Delivery – Plant Science
List Manager->Import
• Select WorkshopDemo\Lists\ParentalLines.xls
• Select Save
• Import WorkshopDemo\Lists\SwornXSoberPopulationList.xls
• Save
• Close and reopen List Manager
• To combine two lists:– Select “Source List” : “SwornxSober Parental Lines”– Select >> button to add to destination list– Select “Source List” : “SwornxSober Population”– Select >> button to add to destination list– Enter a name and comment for the destination list– Save– Close “List Manager”
![Page 10: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/10.jpg)
Delivery – Plant Science
Display PedigreeResults->Descentogram
• Select List: “SwornXSober Population”• Select Genotype: “SwornXSober-10”• Set Generations to 6 click Genotype text box + Enter• Right-click Confraadential• “Copy Genotype”• Right-click Genotype text box and paste• Enter to display pedigree of Confraadential• Check “Exclude Backcrosses”• Click in Genotype text box + Enter• Click D to show descendents• Increase Generations to 2• Click Genotype text box + Enter
![Page 11: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/11.jpg)
Delivery – Plant Science
Display PedigreeResults->Descentogram
• Click F to display Family• Click Aphrodisiac*3/Classifieds to expand• Click again to contract• Click P to return to Ancestor mode• Display pedigree of SwornXSober-10• Mouse over SwornXSober-10 to display pedigree in task bar• Increase “Purdy Levels” to 2 to expand male parent• Increase “Purdy Levels” to 3 to expand both sides• Right-click Sober and select Aliases• Right-click “Court Courting (NZ)” and select Comment• Right-click “Court Courting (NZ)” and select Descendents• Save the resulting file
![Page 12: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/12.jpg)
Delivery – Plant Science
Display PedigreeResults->Descentogram
![Page 13: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/13.jpg)
Delivery – Plant Science
Display PedigreeResults->Descentogram
• Open a new Word document• Right-click SwornXSober-10 select “Copy Pedigree String”• Paste in the Word document• Right-click SwornXSober-10 select “Copy Pedigree Tree”• Paste in the Word document
![Page 14: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/14.jpg)
Delivery – Plant Science
Export PedigreesExport->Pedigree List
• Export ancestors to 4 generations in founder order
![Page 15: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/15.jpg)
Delivery – Plant Science
![Page 16: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/16.jpg)
Delivery – Plant Science
Add Pedigrees to FieldbookTools->Add Pedigrees To Fieldbook
• “Select Files to add pedigrees to”• Select WorshopDemo\Pedigree\AddPedigrees.xls
![Page 17: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/17.jpg)
Delivery – Plant Science
Add Pedigrees to FieldbookTools->Add Pedigrees To Fieldbook
• Click “Update”
![Page 18: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/18.jpg)
Delivery – Plant Science
Update Genotype NamesTools->Update Genotype Names
• “Select Files to update preferred names in”• Select WorshopDemo\Pedigree\UpdateGenoNames.xls
![Page 19: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/19.jpg)
Delivery – Plant Science
Update Genotype NamesTools->Update Genotype Names
![Page 20: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/20.jpg)
Delivery – Plant Science
Finding GenotypesWildcard searches
• Results->Descentogram• Type corridor[*] in the genotype text box• Enter• The drop down list box will be populated with
all genotypes starting with corridor including as an alias
• Repeat with Sworn[*]
![Page 21: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/21.jpg)
Delivery – Plant Science
Checking Marker Names
• Create a new blank database called PBMASSMarkers.mdb– File->New
• Import WorkshopDemo\Marker\MarkerNamesImport.xls– Import->Pedigrees->”From File”
• We can now use “Update Genotype Names” to check marker names– Tools->”Update Genotype Names”
– Open WorkshopDemo\Marker\UpdateMarkerNames.xls
– TX 3612 is not found
– Results->Descentogram
– Type [*]3612 in the Genotype text box and press Enter
• Change database back to WorkshopDemo\PBMASSDemoDB.mdb
![Page 22: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/22.jpg)
Delivery – Plant Science
Marker Data
• Importing marker data– State matrix– State sequential– Dart– Maps
• Graphical Genotypes
![Page 23: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/23.jpg)
Delivery – Plant Science
Import State (matrix format)Import->Marker->State (matrix)
•Open Data File•Select WorkshopDemo\Marker\SwornXSoberStateMatrix.xls•426 markers x 160 genotypes -> 68,000 data points
![Page 24: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/24.jpg)
Delivery – Plant Science
Import State (matrix format)Import->Marker->State (matrix)
• Click “Import Data”
![Page 25: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/25.jpg)
Delivery – Plant Science
Import State (sequential format)Import->Marker->State (Sequential)
•Open Data File•Select WorkshopDemo\Marker\SwornXSoberParentalLinesStateSequential.xls
![Page 26: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/26.jpg)
Delivery – Plant Science
Import State (sequential format)Import->Marker->State (sequential)
• Click “Import Data”
![Page 27: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/27.jpg)
Delivery – Plant Science
Import Dart dataImport->Marker->Dart
•Open Data File•Select WorkshopDemo\Marker\DART\SWORNXSOBERParentalLinesDartMatrix.xls•Repeat for WorkshopDemo\Marker\DART\SWORNXSOBERDartMatrix.xls
![Page 28: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/28.jpg)
Delivery – Plant Science
Import MapsImport->Marker->Distance Data
• Population map– “Open Data File” : WorkshopDemo\Marker\SWORNXSOBER-map_columns.xls
– Import Data
![Page 29: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/29.jpg)
Delivery – Plant Science
Import MapsImport->Marker->Distance Data
• Concensus map– Open data file: WorkshopDemo\Marker\SWORNXSOBER-Consensus-map.xls
– Import Data
![Page 30: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/30.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Tools->Options->IBD
![Page 31: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/31.jpg)
Delivery – Plant Science
Graphical Genotypes
• Set Genotype Colours
![Page 32: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/32.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Select Population and Map
![Page 33: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/33.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Select Genotype: SWORNXSOBER-10• Select Linkage Group: G
![Page 34: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/34.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Select Region
![Page 35: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/35.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Set options – IBS, no inference
![Page 36: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/36.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Set options – IBS + Pedigree inference
![Page 37: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/37.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Set options – IBD, no inference
![Page 38: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/38.jpg)
Delivery – Plant Science
Graphical GenotypesResults->Genotype->Graphical Genotype
• Set options – IBD + Pedigree inference + Flanking Marker inference
![Page 39: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/39.jpg)
Delivery – Plant Science
IBS, no inference IBS, Pedigree Inference IBD, no inference IBD + Pedigree and Flanking Marker inference
![Page 40: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/40.jpg)
Delivery – Plant Science
Export Dart Data
• Import List: WorkshopDemo\Lists\ExportDartList.xls
![Page 41: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/41.jpg)
Delivery – Plant Science
Export Dart Data
• Right-click• De-Select All• Select some rows• Right-click• Select Selected Rows
![Page 42: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/42.jpg)
Delivery – Plant Science
![Page 43: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/43.jpg)
Delivery – Plant Science
Phenotypic Data
• Import->Phenotype->Phenotypic Data• Open Spreadsheet: WorkshopDemo\Phenotype\PhenotypicData.xls• Import Data
![Page 44: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/44.jpg)
Delivery – Plant Science
Phenotypic Data
• Results->Phenotype
![Page 45: Delivery – Plant Science PBMASS (Pedigree Based Marker Assisted Selection System) David Rodgers](https://reader035.vdocuments.us/reader035/viewer/2022062511/551c57f1550346a5458b5083/html5/thumbnails/45.jpg)
Delivery – Plant Science
Phenotypic Data