Hybrid Scores

HYBRIDGENE_ANALYSES

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.

Column Descriptions

HGAId (HybridGene_Analyses Identifier)

A unique integer that identifies the analysis.

This column is automatically maintained by the database, cannot be changed, and must not be NULL.

Date

The date the hybrid scores were generated by this analysis.

This column may not be NULL.

Analyzed_By

The OBSERVERS.Initials of the person who performed the analysis.

Tip

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.

Software

The HYBRIDGENE_SOFTWARE.Software used to perform the analysis.

This column may not be NULL.

Marker

The MARKERS.Marker type used in the analysis.

This column may not be NULL.

Comments

Notes or comments about the analysis.

This column may not be empty, it must contain characters, and it must contain at least one non-whitespace character.

This column may be NULL.

HYBRIDGENE_SCORES

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).

Column Descriptions

HGSId (HybridGene_Scores Identifier)

A unique integer that identifies the row.

This column is automatically maintained by the database, cannot be changed, and must not be NULL.

HGAId (HybridGene_Analyses Identifier)

The HYBRIDGENE_ANALYSES.HGAId of the analysis in which this score was determined.

This column may not be NULL.

Sname

The BIOGRAPH.Sname of the scored individual.

This column may not be NULL.

Score

The individual's hybrid score for this analysis. This value must be between 0 and 1 (inclusive).

This column may not be NULL.

Lower_Conf

The lower confidence limit for the hybrid score. This value must be between 0 and 1 (inclusive).

This column may not be NULL.

Upper_Conf

The upper confidence limit for the hybrid score. This value must be between 0 and 1 (inclusive).

This column may not be NULL.



[169] Usually the olive baboon, Papio anubis.


Page generated: 2016-07-22T23:08:17-04:00.