Entity Genotype Experiment / Sequence Variation

DescriptionAn association between a sequence variation and a genotype experiment which can be used to identify the data recorded for a specific sequence variation in the context of a given genotype experiment.

Attributes
Alleles in Called Genotypes CntAlleles in Called Genotypes Cnt
Ancestral AlleleAncestral Allele
Depth NumDepth Num
FilterFilter
Mapping Quality NumMapping Quality Num
Quality Score NumQuality Score Num
Samples With Data CntSamples With Data Cnt
Zero MAPQ Reads CntZero MAPQ Reads Cnt

Relationship
Assay / Sequence Variation_Sequence Variation_FKAssay / Sequence Variation_Sequence Variation_FK
Genotype Experiment / Sequence Variation_Genotype Experiment_FKGenotype Experiment / Sequence Variation_Genotype Experiment_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Alleles in Called Genotypes Cnt
DescriptionTotal number of alleles in called genotypes.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Ancestral Allele
DescriptionSpecifies the ancestral allele.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Depth Num
DescriptionCombined depth across samples.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Filter
DescriptionThe filter value is PASS if this position has passed all filters (a call is made at this position). Otherwise, if the site has not passed all filters, a semicolon-separated list of codes for filters that fail is generated.

For example:
"q10;s50" can indicate that at this site the quality is below 10 and the number of samples with data is below 50% of the total number of samples. "0" is reserved and must not be used as a filter string. If filters have not been applied, this field must be set to the missing value.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Mapping Quality Num
DescriptionThe mapping quality (RMS - Root Mean Square) of the sequence variation within the given genotype experiment.

For example:
52
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Quality Score Num
DescriptionThe phred-scaled quality score for the assertion made in the Variation Sequence Txt attribute of the Sequence Variation entity, namely -10log_10 prob(call in "Variation Sequence Txt" attribute is incorrect). If "Variation Sequence Txt" is ”.” (no variant) then this is -10log_10 p(variant), and if "Variation Sequence Txt" is not ”.” this is -10log_10 p(no variant). High scores indicate high confidence calls. This attribute is permitted to be a floating point to enable higher resolution for low confidence calls if required. If unknown, the missing value must be specified.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Samples With Data Cnt
DescriptionNumber of samples with data.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Zero MAPQ Reads Cnt
DescriptionNumber of MAPQ reads equal to 0 covering this record.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Assay / Sequence Variation_Sequence Variation_FK
Is Identifying Relationshipfalse
Child TableGenotype Experiment / Sequence Variation
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSequence Variation
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Genotype Experiment / Sequence Variation_Genotype Experiment_FK
Is Identifying Relationshipfalse
Child TableGenotype Experiment / Sequence Variation
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGenotype Experiment
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE