A table listing each analysis that has been performed to generate genetic hybrid scores for individual baboons, with basic information about each analysis.
Each analysis combines statistical techniques with the genetic data available at the time to estimate what proportion of each individual's genome came from ancestry of a specified other species[169]. These estimates are the so-called “hybrid scores”. After several years have elapsed, more individuals are available for scoring, which prompts a new analysis. For many reasons, each analysis may yield somewhat different scores for the same individual. A more-recent analysis does not necessarily negate or supersede an older one, so all analyses are stored here.
The HYBRIDGENE_ANALYSES.Date must be after the BIOGRAPH.Entrydate of all individuals scored in that analysis in HYBRIDGENE_SCORES.
A unique integer that identifies the analysis.
This column is automatically maintained by the
database, cannot be changed, and must not be
NULL
.
The OBSERVERS.Initials of the person who performed the analysis.
It's technically possible to have more than one person involved with an analysis, but even in such cases there will certainly be a lead whose initials should fill this column.
This column may not be NULL
.
The HYBRIDGENE_SOFTWARE.Software used to perform the analysis.
This column may not be NULL
.
A table listing all the hybrid scores determined by genetic hybridity analyses. Hybridity analyses use statistical tools that also determine upper and lower confidence limits. This table also stores those values.
The combination of Sname and HGAId must be unique.
An individual's Score must be greater than its Lower_Conf (inclusive), and less than its Upper_Conf (inclusive).
A unique integer that identifies the row.
This column is automatically maintained by the
database, cannot be changed, and must not be
NULL
.
The HYBRIDGENE_ANALYSES.HGAId of the analysis in which this score was determined.
This column may not be NULL
.
The individual's hybrid score for this
analysis. This value must be between 0
and 1
(inclusive).
This column may not be NULL
.
The lower confidence limit for the hybrid
score. This value must be between 0
and
1
(inclusive).
This column may not be NULL
.