Embedded Files
The Database Routines section is to assist the user in keep their database in the state of their liking.
Note the warning, “These changes are permanent”, so backup before you do anything in case you change your mind.
Each of the DNA Segments or Relative Data actions may require a source and Profile to be selected as well as the appropriate attributes in the DNA Segment Minimums area. Think ahead of what you want accomplished.
Note: When deleting chromosome data for all sources and profiles, all triangulation data will be deleted as well.
Note: All Database routines need a double click to initiate them.
Assign DNA Segments to MRCA Triangulation/ICW groups
Assign DNA Segments to MRCA Triangulation/ICW groups
Takes the sides and group names that you have assigned to matches and applies them to unknown (?) DNA matches when triangulation and/or ICW is present.
Be warned: this is NOT recommended for Endogamy families, and the possibility for errors is present.
Backup First. Affects the entire database. No preview given.
Answer each pop up as desired. Be Patient.
A message is displayed showing how many triangulation and ICW groups were assigned.
Delete Chromosome Data by Source and Profile
Delete Chromosome Data by Source and Profile
Deletes the chromosome data for the Source and Profile you have set. A preview will be available so you can select entries to be excluded from the deletion.
Backup First. Can be Source &/or Profile specific, or affect the entire database. Preview given.
If data is found, the right hand side will populate with data that you can review and use the right click menu to adjust as needed. Click on Delete All to complete process.
Gives Option to defrag database at the end of the process - select Yes or No as desired.
Delete Chromosome data less than minimum cMs
Delete Chromosome data less than minimum cMs
Deletes the chromosome data for the Source, Profile, and Minimum cMs you have set at the top of the screen. A preview will be available, so you can select entries to be excluded from the deletion.
Backup First. Can be Source &/or Profile specific, or affect the entire database. Preview given.
If data is found, the right hand side will populate with data that you can review and use the right click menu to adjust as needed. Click on Delete All to complete process.
Gives Option to defrag database at the end of the process - answer Yes or No as desired.
Delete Chromosome data less than minimum SNPs
Delete Chromosome data less than minimum SNPs
Deletes the chromosome data for the Source, Profile, and Minimum SNPs you have set at the top of the screen. A preview will be available so you can select entries to be excluded from the deletion.
Backup First. Can be Source &/or Profile specific, or affect the entire database. Preview given.
If data is found, the right hand side will populate with data that you can review and use the right click menu to adjust as needed. Click on Delete All to complete process.
Gives Option to defrag database at the end of the process - answer Yes or No as desired.
Delete Chromosome Data less than minimum base pair length
Delete Chromosome Data less than minimum base pair length
Deletes the chromosome data for the Source, Profile, and Minimum Length you have set at the top of the screen. A preview will be available so you can select entries to be excluded from the deletion.
Backup First. Can be Source &/or Profile specific, or affect the entire database. Preview given.
If data is found, the right hand side will populate with data that you can review and use the right click menu to adjust as needed. Click on Delete All to complete process.
Gives Option to defrag database at the end of the process - select Yes or No as desired.
Delete or Hide Chromosome Data in False Positive Regions
Delete or Hide Chromosome Data in False Positive Regions
Deletes or hides the chromosome data for the Source and Profile you have set. False positives are shown as a yellow question make in the side column on the Chromosome page. A preview will be available, so you can select entries to be excluded from the deletion.
Note: Only works if the False Positive Regions have been set for a Profile in the Tables area - see section 6.3.1
Backup First. Can be Source &/or Profile specific, or affect the entire database. Preview given.
Select Yes or No as desired.
If no data is found, an appropriate message is displayed. If data is found, the right hand side will populate with data that you can review and use the right click menu to adjust as needed. Click on Delete All to complete process
Delete Triangulation data less than minimum cMs
Delete Triangulation data less than minimum cMs
Deletes triangulation data that is below the minimum value set at the top of the screen.
Backup First. Affects the entire database. No preview given.
If data is found, the number of triangulations removed will be displayed. If no data is found, a message will be displayed saying as such.
Remove all Triangulation and ICW data
Remove all Triangulation and ICW data
Removes all previously loaded Triangulation and ICW data from the entire database.
Backup First. Affects the entire database. No preview given.
Once the initial process is complete, gives option to Defrag the Database - answer Yes or No as desired.
Final message displayed
Remove all DNA Segment, Triangulation and ICW data
Remove all DNA Segment, Triangulation and ICW data
Removes ALL DNA segments, all Triangulation & all ICW data from the entire database, leaving you with just the relative records.
Backup First. Affects the entire database. No preview given.
This may be helpful if you feel your segment, triangulation, and ICW data has become corrupted but are confident in your relative lists.
Page updated
Google Sites
Report abuse