Entity Assay Detail

DescriptionA qualitative or quantitative analysis of a substance/sample to determine the components. A substance/DNA to be so analyzed using an experimental technique. Genotyping assay techniques also differ substantially. They differ in their technical complexity and in the type of raw data generated. Assay techniques range from single PCR amplification assays to various high throughput approaches. The type of raw data generated also varies, for example, from Sanger sequencing technique which generates one chromatogram read per sample, to next generation sequencing methods which generate large numbers of short reads, provided as fluorescent image files.

Attributes
Assay NmAssay Nm
Assay Performed DtAssay Performed Dt
Assay SkAssay Sk
Assay Type Code SkAssay Type Code Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Load Info SkLoad Info Sk
Other Assay DescrOther Assay Descr
PCR Annealation TempPCR Annealation Temp
PCR Annealation Temp Code SkPCR Annealation Temp Code Sk
PCR Annealation TmPCR Annealation Tm
PCR Cycle CntPCR Cycle Cnt
PCR Denaturation TempPCR Denaturation Temp
PCR Denaturation Temp Code SkPCR Denaturation Temp Code Sk
PCR Denaturation TmPCR Denaturation Tm
PCR DescrPCR Descr
PCR Elongation TempPCR Elongation Temp
PCR Elongation Temp Code SkPCR Elongation Temp Code Sk
PCR Elongation TmPCR Elongation Tm
PCR Forward Primer TxtPCR Forward Primer Txt
PCR Forward Sequence TxtPCR Forward Sequence Txt
PCR Product Length QtyPCR Product Length Qty
PCR Product Length UOM Code SkPCR Product Length UOM Code Sk
PCR Reverse Primer TxtPCR Reverse Primer Txt
PCR Reverse Sequence TxtPCR Reverse Sequence Txt
PCR Technician TxtPCR Technician Txt
PCR Type Code SkPCR Type Code Sk
Source Code SkSource Code Sk
Tenant SkTenant Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Assay Detail_Assay_FKAssay Detail_Assay_FK

Primary Key
Assay Detail PKAssay Detail PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Assay Nm
DescriptionA word or a phrase used to identify the assay experiment.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Performed Dt
DescriptionThe date upon which the assay was performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Sk
DescriptionThe surrogate key for anchor Assay.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Assay Type Code Sk
DescriptionDefines the type of assay and general method of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Other Assay Descr
DescriptionA description of what was done as part of the assay.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Annealation Temp
DescriptionThe annealation temperature at which the primers (custom-made, short DNA strands, specifically designed to bond to sites at the beginning and end of the segment to be copied) bind to the DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Temperature [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Annealation Temp Code Sk
DescriptionPolymerase Chain Reaction (PCR) Annealation Temperature.
The temperature that is required to anneal or bind DNA strands.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Annealation Tm
DescriptionThe annealation time taken at which the primers (custom-made, short DNA strands, specifically designed to bond to sites at the beginning and end of the segment to be copied) bind to the DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Cycle Cnt
DescriptionNumber of PCR cycles needed to obtain desired strands of DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Denaturation Temp
DescriptionThe temperature at which the hydrogen bonds are broken in the double stranded DNA, creating single strands of DNA that are susceptible to copying.
Data TypeStandards - Data Domains.ddm/Data Domains/Temperature [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Denaturation Temp Code Sk
DescriptionPolymerase Chain Reaction (PCR) Denaturation Temperature.
The temperature that is required to break the double helix of DNA to single strands.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Denaturation Tm
DescriptionThe time taken for the hydrogen bonds to be broken in the double stranded DNA, creating single strands of DNA that are susceptible to copying.
Data TypeStandards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Descr
DescriptionThe description of the PCR experiment.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Long [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Elongation Temp
DescriptionThe Taq polymerase enzyme adds DNA nucleotides from 5'to 3', reading the template from 3' to 5' side, making two double stranded molecules from each one double stranded
DNA molecule that was denatured.
Data TypeStandards - Data Domains.ddm/Data Domains/Temperature [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Elongation Temp Code Sk
DescriptionPolymerase Chain Reaction (PCR) Elongation Temperature.
The units of the temperature required to elongate the DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Elongation Tm
DescriptionThe time taken for Taq polymerase enzyme to add DNA nucleotides from 5' to 3', reading the template from 3' to 5' side, making two double stranded molecules from each one double stranded DNA molecule that was denatured.
Data TypeStandards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Forward Primer Txt
DescriptionThe forward primer extends in PCR from the start codon towards the stop codon of template DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Forward Sequence Txt
DescriptionSequence of a strand in the 5-3 direction. For the forward strand, this means reading left-to-right.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Product Length Qty
DescriptionLength of the Amplified DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Product Length UOM Code Sk
DescriptionLength of the Amplified DNA.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Reverse Primer Txt
DescriptionThe reverse primer extends from the stop codon towards the start codon
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Reverse Sequence Txt
DescriptionSequence of a strand in the 5-3 direction. For the reverse strand it means right-to-left.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Technician Txt
DescriptionThe name of the technician who performed the DNA amplification.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PCR Type Code Sk
DescriptionPolymerase Chain Reaction Type.
1)  Assembly Polymerase Chain Reaction (PCR) or Polymerase Cycling Assembly (PCA): artificial synthesis of long DNA sequences by performing PCR on a pool of long oligonucleotides with short overlapping segments. The oligonucleotides alternate between sense and antisense directions, and the overlapping segments determine the order of the PCR fragments, thereby selectively producing the final long DNA product.
2) Helicase-dependent amplification: similar to traditional PCR, but uses a constant temperature rather than cycling through denaturation and annealing/extension cycles. DNA helicase, an enzyme that unwinds DNA, is used in place of thermal denaturation.
3) Hot start PCR: a technique that reduces non-specific amplification during the initial set up stages of the PCR. It may be performed manually by heating the reaction components to the denaturation temperature (for example, 95°C) before adding the polymerase. Specialized enzyme systems have been developed that inhibit the polymerase's activity at ambient temperature, either by the binding of an antibody or by the presence of covalently bound inhibitors that dissociate only after a high-temperature activation step. Hot-start/cold-finish PCR is achieved with new hybrid polymerases that are inactive at ambient temperature and are instantly activated at elongation temperature.
4) Inverse PCR: is commonly used to identify the flanking sequences around genomic inserts. It involves a series of DNA digestions and self ligation, resulting in known sequences at either end of the unknown sequence.
5) Methylation-specific PCR (MSP): developed by Stephen Baylin and Jim Herman at the Johns Hopkins School of Medicine, and is used to detect methylation of CpG islands in genomic DNA. DNA is first treated with sodium bisulfite, which converts unmethylated cytosine bases to uracil, which is recognized by PCR primers as thymine. Two PCRs are then carried out on the modified DNA, using primer sets identical except at any CpG islands within the primer sequences. At these points, one primer set recognizes DNA with cytosines to amplify methylated DNA, and one set recognizes DNA with uracil or thymine to amplify unmethylated DNA. MSP using qPCR can also be performed to obtain quantitative rather than qualitative information about methylation.
6) Multiplex Ligation-dependent Probe Amplification (MLPA): permits multiple targets to be amplified with only a single primer pair, thus avoiding the resolution limitations of multiplex PCR.
7) Multiplex-PCR: consists of multiple primer sets within a single PCR mixture to produce amplicons of varying sizes that are specific to different DNA sequences. By targeting multiple genes at once, additional information may be gained from a single test-run that otherwise would require several times the reagents and more time to perform. Annealing temperatures for each of the primer sets must be optimized to work correctly within a single reaction, and amplicon sizes. That is, their base pair length should be different enough to form distinct bands when visualized by gel electrophoresis.
8) Nested PCR: increases the specificity of DNA amplification, by reducing background due to non-specific amplification of DNA. Two sets of primers are used in two successive PCRs. In the first reaction, one pair of primers is used to generate DNA products, which besides the intended target, may still consist of non-specifically amplified DNA fragments. The product(s) are then used in a second PCR with a set of primers whose binding sites are completely or partially different from and located 3' of each of the primers used in the first reaction. Nested PCR is often more successful in specifically amplifying long DNA fragments than conventional PCR, but it requires more detailed knowledge of the target sequences.
9) Overlap-extension PCR or Splicing by overlap extension (SOE) : a genetic engineering technique that is used to splice together two or more DNA fragments that contain complementary sequences. It is used to join DNA pieces containing genes, regulatory sequences, or mutations; the technique enables creation of specific and long DNA constructs.
10) Quantitative PCR (Q-PCR): used to measure the quantity of a PCR product (commonly in real-time). It quantitatively measures starting amounts of DNA, cDNA, or RNA. Q-PCR is commonly used to determine whether a DNA sequence is present in a sample and the number of its copies in the sample. Quantitative real-time PCR has a very high degree of precision. QRT-PCR (or QF-PCR) methods use fluorescent dyes, such as Sybr Green, EvaGreen or fluorophore-containing DNA probes, such as TaqMan, to measure the amount of amplified product in real time. It is also sometimes abbreviated to RT-PCR (Real Time PCR) or RQ-PCR. QRT-PCR or RTQ-PCR are more appropriate contractions, since RT-PCR commonly refers to reverse transcription PCR (see below), often used in conjunction with Q-PCR.
11) Reverse Transcription PCR (RT-PCR): for amplifying DNA from RNA. Reverse transcriptase reverse transcribes RNA into cDNA, which is then amplified by PCR. RT-PCR is widely used in expression profiling, to determine the expression of a gene or to identify the sequence of an RNA transcript, including transcription start and termination sites. If the genomic DNA sequence of a gene is known, RT-PCR can be used to map the location of exons and introns in the gene. The 5' end of a gene (corresponding to the transcription start site) is typically identified by RACE-PCR (Rapid Amplification of cDNA Ends).
12) Thermal asymmetric interlaced PCR.
13) Touchdown PCR (Step-down PCR): a variant of PCR that aims to reduce nonspecific background by gradually lowering the annealing temperature as PCR cycling progresses. The annealing temperature at the initial cycles is usually a few degrees (3-5°C) above the Tm of the primers used, while at the later cycles, it is a few degrees (3-5°C) below the primer Tm. The higher temperatures give greater specificity for primer binding, and the lower temperatures permit more efficient amplification from the specific products formed during the initial cycles.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Assay Detail_Assay_FK
Is Identifying Relationshiptrue
Child TableAssay Detail
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAssay
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Assay Detail PK
Key AttributeAssay Sk
Key AttributeValid From Ts