SchemaSpy - pub.mgd

Generated by
SchemaSpy

Generated by SchemaSpy on Mon Sep 11 06:12 EDT 2023
Database Type: PostgreSQL - 12.10
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Tables Views Comments

Table / View	Children	Parents	Columns	Rows	Comments
acc_accession	1	4	13	33,823,535	Master Accession table; stores all internal (MGI) and external accession numbers for any accessionable object. Each accession number has a prefix (non-numeric) part and a numeric part. Accession numbers are assigned to a specific object (_Object_key) within a specific data set (_MGIType_key), to a specific logical database (_LogicalDB_key). Accession numbers which are designated as private (1) are not dispalyed or searchable via the Web. Preferred accession numbers are the primary accession numbers for a given object. See ACC_AccessionMax, ACC_AccessionReference.
acc_accessionmax			4	2	Stores the current maximum numeric part for the "J:" and "MGI:" prefixes. Set maximum field to 0 when initializing a new record. When a new ACC_Accession record is added, maxNumericPart is incremented and ACC_Accession.numericPart is assigned that value. See ACC_Accession.
acc_accessionreference		4	6	9,073,422	Accession Reference table; A record in this table is the reference for a specific Accession number. See ACC_Accession.
acc_actualdb		3	11	82	Defines physical location, by URL, of an external data resource. Used to dynamically construct HTML links for the Web interface. Detail table of ACC_LogicalDB.
acc_logicaldb	3	3	8	167	Defines a logical entity to which to attach accession numbers. Examples include: Sequence DB, MGI, RIKEN, etc.. After a logical entity is defined, multiple URLs (actual database objects) may be attached to the logical object. Master table of ACC_ActualDB.
acc_mgitype	21	2	10	36	Controlled vocabulary table of all accessionable object types in the system. Accessionable objects will be assigned MGI accession numbers during inserts. See ACC_Accession.
acc_view			21	view
all_acc_view			14	view
all_allele	13	12	21	769,801	A record in this table represents one Allele. An Allele is any of the alternative forms of a gene occupying a given locus; any one of several mutational forms of a gene. In MGI, allelic variants are associated with phenotypes. See ALL_Marker_Assoc. A transgenic Allele will contain a Strain of Origin, and a new Strain can then be bred from this trangene. This new Strain will be associated with the transgenic allele (see PRB_Strain, PRB_Strain_Marker). For example, see TR11000/MMRRC/UC-Davis. For example: MGI:4847055/Tg(Foxi2-EGFP)HX217Gsat, strain of origin: FVB/NTac. New Strain: MGI:5003868/STOCK Tg(Foxi2-EGFP)HX217Gsat/Mmucd associated with MGI:5003868/Tg(Foxi2-EGFP)HX217Gsat via PRB_Strain/PRB_Strain_Marker.
all_allele_cellline		4	7	842,879	A record in this table represents the association between an Allele and a Cell Line. The type of Cell Line associated with the Allele depends on the Allele Type. See ALL_CellLine.
all_allele_cellline_view			23	view
all_allele_driver_view			6	view
all_allele_mutation		2	5	713,255	A record in this table represents the Molecular Mutation for a specific Allele. An Allele can have 0 or more Molecular Mutations.
all_allele_mutation_view			6	view
all_allele_subtype_view			9	view
all_allele_view			34	view
all_annot_view			4	view
all_cellline	4	5	10	957,910	A record in this table represents a parental or a mutant ES Cell Line.
all_cellline_acc_view			14	view
all_cellline_derivation	1	8	13	3,152	A record in this table represents the Derivation of a Cell Line. See ALL_CellLine.
all_cellline_derivation_view			27	view
all_cellline_view			26	view
all_cre_cache		8	24	62,804	A record in this table represents the cached values of a Cre Allele (that may/may not contain Assay information). See ALL_Allele, GXD_Assay, allcacheload/allelecrecache.csh.
all_genotype_view			2	view
all_knockout_cache		4	12	257	A record in this table represents a Deltagen or Lexicon knockout.
all_label		1	8	1,491,917	A record in this table represents an Allele Label (current symbol, current name, synonym). This table is a cache table of all "labels" for a given Allele...representing the different ways in which a user may search for a particular Allele. This table is loaded via the alllabelload product.
all_summary_view			17	view
all_summarybymarker_view			7	view
all_summarybyreference_view			9	view
all_variant	2	5	10	8,868	A record in this table represents a variant for an allele. An allele can have multiple variants. Each variant will eventually have two records in this table -- one for reported data and the other for curated data.
all_variant_sequence		4	12	11,082	A record in this table represents a sequence associated with a variant.n have multiple variants. Since each variant will have two records in ALL_Variant_Variant (one a source record, the other a curated record), there will be sequence records associated with both types of variant records.
bib_acc_view			14	view
bib_all_view			22	view
bib_associateddata_view			13	view
bib_books		1	8	319	A record in this table represents the Book attributes of a BIB_Refs record. This table is only populated if BIB_Refs.refType = BOOK.
bib_citation_cache		2	14	332,736	A record in this table represents a unique Reference. This table is a cache table of all References in MGI. This table is loaded via the mgicacheload product. See mgicacheload/bibcitation.csh.
bib_goxref_view			7	view
bib_notes		1	4	25,897	A record in this table represents a Reference note.
bib_refs	35	3	17	332,736	A record in this table represents a journal article, book or personal communication.
bib_status_view			7	view
bib_summary_view			30	view
bib_view			24	view
bib_workflow_data		5	11	0	A record in this table represents Reference information needed by the Triage Workflow process
bib_workflow_relevance		4	10	0	A record in this table represents the Relevance of a Reference by User over time
bib_workflow_status		5	9	0	A record in this table represents the Group/Status of a Reference by User over time
bib_workflow_tag		4	7	0	A record in this table represents a distinct Tag associated with a Reference
crs_cross	4	4	19	4,491	Controlled vocabulary table for all Mapping Cross descriptions. See MLD_Matrix, CRS_Matrix.
crs_matrix	2	2	8	28,009	Defines a row in a Matrix of a Mapping Panel Cross.
crs_progeny		1	7	3,610	Defines Progeny for Mapping Panel Cross. See CRS_Matrix, CRS_References, CRS_Typings.
crs_references		3	5	7,596	Defines References used in Mapping Panel Cross. See CRS_Matrix, CRS_Progeny, CRS_Typings.
crs_typings		2	6	63,596	Defines haplotype typings for Mapping Panel Cross. See CRS_Matrix, CRS_Progeny, CRS_References.
dag_closure		6	10	1,850,004	A record in this table represents an ancestor/descendent pair within a DAG. It caches data for performance reasons. Two common queries of a DAG are: 1. retrieve all the descendents of a node 2. retrieve all the ancestors of a node This table provides a mechanism for performing such queries within one SQL statement.
dag_dag	6	2	7	45	A record in this table represents a specific DAG.
dag_edge		4	8	219,186	A record in this table represents an edge of a DAG, the relationship between 2 nodes.
dag_label	4		4	24	A record in this table represents a "label" for a Node or an Edge. A "label" is an attribute of the Note or Edge which may be specific to a given DAG. A "label" is not necessarily something which is printed.
dag_node	4	2	6	140,300	A record in this table represents a specific Node within a DAG. The _Object_key/DAG_DAG._MGIType_key combination identifies the specific Node object. In the case of a GO DAG, this is a specific Vocabulary Term. The DAG_DAG._MGIType_key identifies the type of object (a Vocabulary Term) and the _Object_key identifies the object itself.
dag_node_view			9	view
go_tracking		4	8	109,235	A record in this table represents the GO Tracking history for a specific Gene (_Marker_key).
gxd_allelegenotype		5	8	160,123	A record in this table represents the association between an Allele, a Genotype and a Marker. This is a cache table which is derived from GXD_AllelePair.
gxd_allelepair		10	14	124,668	Defines Allele Pair for Genotype object. Each pair specifies two alleles, both of which must be associated with the same marker. Allele Pairs may be homozygous, heterzygous or hemizygous. For hemizygous Allele Pairs, Allele 2 is null. See GXD_Genotype.
gxd_allelepair_view			20	view
gxd_antibody	3	6	11	17,250	Defines an accessionable Antibody object. An antibody is a protein produced by cells of the immune system that binds to an antigen.
gxd_antibody_acc_view			15	view
gxd_antibody_view			22	view
gxd_antibodyalias		2	6	1,010	Antibody synonyms. See GXD_Antibody.
gxd_antibodyalias_view			7	view
gxd_antibodyaliasref_view			10	view
gxd_antibodyantigen_view			25	view
gxd_antibodymarker		2	5	17,769	Defines relationship between Antibodies and Markers. Antibodies can recognize the product of one or more markers. See GXD_Antibody.
gxd_antibodymarker_view			5	view
gxd_antibodyprep	1	3	6	30,227	Defines the Antibody preparation for an expression assay. The Antibody preparation specifies the antibody and detection system used. The detection is a combination of a Secondary Antibody and a labelling material. See GXD_Assay, GXD_Antibody, GXD_Secondary, GXD_Label.
gxd_antibodyprep_view			11	view
gxd_antigen	1	3	9	12,141	Defines an accessionable Antigen object. An antigen is a protein or fragment of a protein derived from a specific source.
gxd_antigen_acc_view			15	view
gxd_antigen_summary_view			17	view
gxd_antigen_view			23	view
gxd_assay	6	9	12	132,158	A record in this table represents the high level definition of a Gene Expression experiment; the type of Assay, the Reference, the Marker of interest, the Probe used to detect the Marker or Reporter Gene, the Antibody used to detect the Marker or Reporter Gene, the Reporter Gene, and the Image Pane. A Reporter Gene is a benign gene which is knocked-in to report the expression of the mouse gene. It is only applicable when Assay Type is "In situ reporter (knock in)", "In situ reporter (transgenic)" and "Recombinase reporter". These three assay types may use a nucleotide probe (has a Probe Prep), an antibody (has an Antibody Prep) or direct detection (has neither a Probe Prep nor an Antibody prep). Not all records in this table are in the GXD_Expression table. Assay Type "In situ reporter (transgenic)" assays are excluded because they do not examine the expression of endogenous genes. Assay Type "Recombinase reporter" assays are excluded because they do not examine gene expression. See GXD_Specimen, GXD_GelLane.
gxd_assay_acc_view			14	view
gxd_assay_allele_view			2	view
gxd_assay_dltemplate_view			9	view
gxd_assay_view			26	view
gxd_assaynote		1	5	47,241	Assay Notes. An Assay may have 0 more notes.
gxd_assaytype	2		7	10	Controlled vocabulary table for all Assay types. Includes Not Applicable (-2) and Not Specified (-1). See GXD_Assay.
gxd_expression		10	22	2,000,464	A cache table of redundant Assay results whose purpose is to make the most common kinds of queries more efficient. Primarily used by the Web interface. Loaded by a stored procedure which is executed from the GXD_Assay insert/update triggers. See GXD_Assay.
gxd_gelband		3	7	388,257	Defines a Gel Band for a given Gel Lane and Gel Row. A band is assigned a strength. See GXD_GelLane, GXD_GelRow.
gxd_gelband_view			11	view
gxd_gellane	3	4	16	352,140	Defines a Gel Lane. A Gel Assay is represented as a 2-D matrix with some number of columns (GXD_GelLane) and some number of rows (GXD_GelRow, GXD_GelBand). Lanes have sequence numbers for ordering and labels to describe lane content. The information associated with a Gel Lane corresponds to the way the gel was prepared in the lab. Source material is derived from one or more tissues in an animal. Tissues are described through reference to the anatomical dictionary. Animals are described via their genotype, age and sex. Minimal information is recorded for control lanes. See GXD_Assay, GXD_Genotype, GXD_GelLaneStructure, GXD_GelRNAType.
gxd_gellane_view			20	view
gxd_gellanestructure		3	6	317,514	Defines a relationship between a Gel Lane and an Anatomical Structure. A Gel Lane can correspond to one or more Anatomical Structures. See GXD_GelLane, VOC_Term_EMAPA.
gxd_gellanestructure_view			11	view
gxd_gelrow	1	2	8	55,572	Defines a Gel Row. A Gel Row corresponds to a particular size of band (GXD_GelBand) and includes attributes for size, units and optional notes. Band sizes are automatically sorted in decreasing order via the Editorial Interface. See GXD_GelLane, GXD_GelBand.
gxd_gelrow_view			10	view
gxd_genotype	9	4	9	96,729	Defines Genotype of animal used for Gel Lane or Specimen using Strain information. See GXD_GelLane, GXD_Specimen, GXD_AllelePair.
gxd_genotype_acc_view			15	view
gxd_genotype_dataset_view			3	view
gxd_genotype_summary_view			18	view
gxd_genotype_view			15	view
gxd_genotypeannotheader_view			7	view
gxd_htexperiment	4	10	21	52,673	A record in this table represents one high-througput expression experiment. There can be zero or more samples per experiment (GXD_HTSample) and zero or more experiment variables (GXD_ExperimentVariable). Many other experiment attributes are stored as properties (MGI_Property), as notes (MGI_Note), and as accession IDs (ACC_Accession).
gxd_htexperimentvariable		2	3	55,103	A record in this table represents one curator-identified experiment variable for an experiment. Each experiment (GXD_HTExperiment) can have zero or more expression variables associated with it.
gxd_htrawsample		3	7	1,829,483	A record in this table represents one high-througput expression raw sample. There can be zero or more raw samples per experiment (GXD_HTExperiment) Many other raw experiment attributes are stored as key:value pairs (MGI_KeyValue)
gxd_htsample	2	10	17	143,635	A record in this table represents one curated sample for a high-throughput expression experiment (GXD_HTExperiment). Each sample can have accession IDs (ACC_Accession), associated organisms (GXD_HTSampleOrganism), notes (MGI_Note), properties (MGI_Property), and a genotype (GXD_Genotype).
gxd_htsample_rnaseq		5	10	110,642,286	A record in this table represents an experiment/sample/gene combination
gxd_htsample_rnaseqcombined	2	4	9	36,724,708	A record in this table represents a gene/RNASeqSet combination
gxd_htsample_rnaseqset	2	8	13	706	A record in this table represents a distinct experiment/age/organism/sex/emapa/stage/genotype/note set/cluster as generated from GXD_HTSample via rnaseqload
gxd_htsample_rnaseqset_cache		4	7	36,724,708	A join table to provide easy access to RNASeqSet and RNASeqSet_Combined data
gxd_htsample_rnaseqsetmember		4	7	2,127	A record in this table represents a GXD_HTSample member of the GXD_HTSample_RNASeqSet
gxd_index	1	6	10	269,745	A record in this table represents a GXD "index" relationship between a Reference and a Marker. Precusor to fully coding a GXD paper. All records in the GXD Index may or may not be entered into the GXD Assay table. See GXD_Index_Stages.
gxd_index_stages		5	8	615,810	A record in this table represents the Assays and Stages present in a given Index (Reference/Marker pair). See GXD_Index.
gxd_index_summaryby_view			17	view
gxd_index_view			16	view
gxd_insituresult	3	3	8	1,565,117	Defines an In Situ Specimen Result. For each Specimen defined, one or more results can be recorded. Each result contains the anatomical structure(s), signal strength, pattern of expression within the structure(s) and optional notes. One or more Image Panes may also be associated with a result. See GXD_Specimen, GXD_InSituResultImage, GXD_ISResultStructure.
gxd_insituresult_view			10	view
gxd_insituresultimage		2	5	1,470,460	Defines relationship between an In Situ Result and an Image Pane. One In Situ Result can have one or more Image Panes associated with it. See GXD_InSituResult, GXD_ImagePane.
gxd_isresultcelltype		2	5	14,081	Defines relationship between an In Situ Result and a Cell Type. One In Situ Result can have one or more Cell Types associated with it. See GXD_InSituResult
gxd_isresultcelltype_view			10	view
gxd_isresultimage_view			19	view
gxd_isresultstructure		3	6	1,682,870	Defines relationship between an In Situ Result and an Anatomical Structure. One In Situ Result can have one or more Anatomical Structures associated with it. See GXD_InSituResult, VOC_Term_EMAPA.
gxd_isresultstructure_view			11	view
gxd_probeprep	1	4	8	95,542	Defines the Probe preparation for an expression assay. The Probe preparation specifies the probe used, final type (DNA, RNA) and the label used to visualize the probe. See GXD_Assay, PRB_Probe, GXD_ProbeSense, GXD_Label, GXD_LabelCoverage, GXD_Visualization.
gxd_probeprep_view			14	view
gxd_specimen	2	4	16	526,764	Defines an In Situ Assay Specimen. A Specimen is described in terms of its genotype, sex, age and the methods used to prepare the sample. If multiple animals within one reference have identical genotypes and preparation procedures, then they can be collectively represented by a single Specimen object. See GXD_Assay, GXD_EmbeddingMethod, GXD_FixationMethod, GXD_Genotype.
gxd_specimen_view			20	view
gxd_theilerstage	10		7	28	Defines the Theiler Stages, one for each developmental stage defined in the Theiler system. Each stage has a "stage" attribute, which is an integer from 1 to 28, an approximate mapping to DPC values, and a short description of the main anatomical developments for the stage. See VOC_Term_EMAPA.
img_image	2	6	12	342,097	A record in this table represents a full size or thumbnail Image. If the X dimension (width) and Y dimension (height) are non-null, then an Image file is associated with the Image (via the PIX accession ID).
img_image_acc_view			14	view
img_image_summary2_view			13	view
img_image_summarybyreference_view			19	view
img_image_view			22	view
img_imagepane	3	1	9	584,966	A record in this table represents an Image Pane. An Image hast at least one Image Pane.
img_imagepane_assoc		4	9	22,395	A record in this table represents an association between an Image Pane and an MGI Object (allele, genotype). At most one association for a given MGI object can be primary.
img_imagepane_assoc_view			15	view
img_imagepaneallele_view			6	view
img_imagepanegenotype_view			7	view
img_imagepanegxd_view			7	view
map_coord_collection	1	2	7	13	A record in this table represents one Coordinate Map Collection; an ordered set of Coordinate Maps. A Coordinate Map Colllection can contain Coordinate Maps of different Map Types.
map_coord_feature		4	11	2,240,086	A record in this table represents a feature on a coordinate map (MAP_Coordinate).
map_coordinate	2	6	15	259	A record in this table represents one Coordinate Map; a set of Coordinate Map Features of the specified Units for the specified Object. The Object can be an MGI object (Chromosome or Sequence), or a non-MGI object (in which case the _Object_key and _MGIType_key are null). A Coordinate Map can belong to at most one Collection.
map_gm_coord_feature_view			13	view
mgi_dbinfo			8	1	This table has one and only one record which contains information about the database such as the public version name, the product name, the last time the database was dumped.
mgi_keyvalue		3	10	28,913,433	A record in this table represents ordered key-value pairs (strings), associated with an object of a specific MGI Type.
mgi_note		4	9	3,005,544	A record in this table represents a Note of a specific type (_NoteType_key) for a specific object (_Object_key) of a specific object type (_Object_key) with a specific privacy setting.
mgi_note_allele_view			13	view
mgi_note_allelevariant_view			13	view
mgi_note_derivation_view			13	view
mgi_note_genotype_view			13	view
mgi_note_image_view			13	view
mgi_note_marker_view			13	view
mgi_note_probe_view			13	view
mgi_note_strain_view			13	view
mgi_note_vocevidence_view			13	view
mgi_notetype	1	3	8	45	A record in this table represents a Note Type.
mgi_notetype_strain_view			8	view
mgi_organism	15	2	7	110	A record in this table represents an Organism.
mgi_organism_allele_view			8	view
mgi_organism_antigen_view			7	view
mgi_organism_marker_view			8	view
mgi_organism_mgitype		4	8	238	A record in this table represents the relationship between an Organism and a MGI Type; what Organisms are valid for a given MGI Type. An Organism can be associated with one or more MGI Types. This enables us to generate a list of Organisms by MGI Type. Examples are Orthology, Molecular Segment , GXD Antigen, GXD Antibody, Sequence, Marker.
mgi_organism_mgitype_view			11	view
mgi_organism_probe_view			7	view
mgi_property		5	11	277,300	A record in this table represents ordered properties, or name-value pairs, of a specific Property Type, for any object defined in ACC_MGIType
mgi_propertytype	1	4	8	1	A record in this table represents a Property Type from a specific VOcabulary for a specific Object Type
mgi_refassoctype	1	3	8	25	A record in this table represents a Reference Association Type (e.g. General, Original).
mgi_reference_allele_view			19	view
mgi_reference_allelevariant_view			16	view
mgi_reference_antibody_view			16	view
mgi_reference_assoc		5	9	7,199,111	A record in this table repesents an association between a Reference of a specific type (_RefAssocType_key, e.g. Original) and a specific database object (_Object_key, e.g. Sequence A12345 ) of a specific object type (_MGIType_key, e.g., Sequence, Marker/Sequence Association).
mgi_reference_marker_view			20	view
mgi_reference_strain_view			19	view
mgi_relationship	1	7	12	4,798,810	A record in this table represents a relationship, of a particular category, between any two objects with an MGI Type. For example a relationship between two Markers or a relationship between an Allele and a Marker. See MGI_Relationship_Category
mgi_relationship_category	1	8	12	12	A record in this table defines a category (type) of relationship between two objects, allowing us to encapsulate data that is standard across all relationships of this type. See MGI_Relationship
mgi_relationship_fear_view			27	view
mgi_relationship_markerqtlcandidate_view			6	view
mgi_relationship_markerqtlinteraction_view			5	view
mgi_relationship_markertss_view			23	view
mgi_relationship_property		4	9	27,146,046	A record in this table represents ordered properties, or name-value pairs, for a relationship See MGI_Relationship
mgi_set	1	3	8	16	A record in this table represents a Set.
mgi_setmember	1	3	9	1,667	A record in this table represents the ordered member of a specific Set.
mgi_setmember_emapa		4	7	0	A record in this table represents the EMAPA info of a specific Set Member.
mgi_synonym		5	10	914,922	A record in this table repesents a Synonym of a specific type (_SynonymType_key, e.g. Exact) and a specific database object (_Object_key, e.g. Marker Kit ) of a specific object type (_MGIType_key, e.g., Marker). The Synonym may also have a Reference associated with it.
mgi_synonym_allele_view			17	view
mgi_synonym_musmarker_view			18	view
mgi_synonym_strain_view			17	view
mgi_synonymtype	1	4	10	27	A record in this table represents a Synonym Type (e.g. Exact) for a specific Object Type. The Object may be of a specific Organism (for example, Marker, Mouse).
mgi_synonymtype_strain_view			10	view
mgi_translation		3	9	4,486	A record in this table represents the Translation between a "bad name" and the corresponding MGI object (the "good name") of a specific Translation Type.
mgi_translationtype	1	4	10	18	A record in this table represents a Translation Type.
mgi_user	198	5	11	314	A record in this table represents a valid MGI user login.
mgi_user_active_view			14	view
mld_assay_types	1		4	79	Controlled vocabulary table for all Mapping Assays. Includes a blank (-1) Assay, which is used like a "Not Specified" vocabulary record. See MLD_Expt_Marker.
mld_concordance		2	10	11,827	Defines Concordance values for Hybrid Experiment. The Concordance table contains results for either Markers or Chromosomes. Concordance values are stored as integers which represent the number of Hybrid cells recording the presence/absence of a particular Marker/Chromosome in the Concordance table vs. the presence/absence of the Marker being tested for linkage: -/- (neither present), -/+ (linkage Marker present), +/- (Marker/Chromosome present), +/+ (both present). Detail of MLD_Hybrid.
mld_contig	1	1	8	2,054	Defines CONTIG Experiment for MIT Physical Mapping data. Each Contig has a name and an indication (minLink) of the minimum number of common hits required to assemble YACs into the Contig. For the MIT data, the value in this field is either 1 or 2. Each Contig is labelled with the minimum and maximum cM position of markers within the Contig. When printing the Contigs for a chromosome, the Contigs should be ordered by the mincm field. The Contig tables are loaded via a load script and there is no Editorial Interface for modifying this data. See MLD_ContigProbe, MLD_Hit, PRB_Probe.
mld_contigprobe		2	5	14,342	Defines the STS order within a Contig. A Contig can have one or more Probes/STS's associated with it. Detail of MLD_Contig, PRB_Probe.
mld_expt_marker		4	10	759,397	Defines relationship between an Experiment and a Marker reported for that Experiment. An Experiment may have one or more Markers associated with it. See MLD_Expts.
mld_expt_marker_view			22	view
mld_expt_notes		1	4	15,178	Mapping experiment notes.
mld_expt_view			16	view
mld_expts	18	1	7	24,051	Defines a Mapping Experiment for a specific Reference. A Reference may have one or more Experiments associated with it. Each Experiment within a specific Reference is assigned an Experiment Type and and Experiment Tag value (CROSS-1). The currently supported Experiment Types are: CONTIG, CROSS, FISH, HYBRID, IN SITU, MAP, RI, TEXT.
mld_fish		2	12	1,429	Defines FISH (Fluorescence In Situ Hybridization) Experiment. FISH Experiments use fluorescein tags to detect the hybridization of probes with metaphase chromosomes. This suggests the chromosome and band assignment of the marker to which the probe hybrdizes. Master of MLD_FISH_Region.
mld_fish_region		1	7	77	Defines number of single and double signal hits by chromosomal region for a specific FISH Experiment. Detail of MLD_FISH.
mld_hit		3	5	50,872	Defines hits between Probes and Targets for MIT Physical Mapping data. Each Probe and each Target is a Molecular Segment in PRB_Probe. Each hit is associated with an Experiment. In the case of MIT data, each _Probe_key points to an STS, and each _Target_key points to a YAC. Detail of MLD_Expts, PRB_Probe.
mld_hybrid		1	5	651	Defines HYBRID Experiment; stores the band assignment determined by the experiment. Master for MLD_Concordance.
mld_insitu		2	12	449	Defines IN SITU Experiment. In Situ Experiments use a DNA or RNA probe to detect the presence of the complementary DNA sequence in cloned bacterial or cultured eukaryotic cells. This suggests the chromosome and band assignment of the marker to which the probe hybridizes. Master of MLD_ISRegion.
mld_isregion		1	6	2,523	Defines number of grain counts by chromosomal region for a specific In Situ Experiment. Detail of MLD_InSitu.
mld_matrix		2	8	6,925	Defines CROSS Experiment. Cross Experiments may use a well-defined Cross or a one-time only mating of two strains. The Editorial Interface constructs the female and male genotypes based on the number of Markers used in the Experiment and the allele abbreviations designated for the Cross. See MLD_MC2point, MLC_MCDataList, CRS_Cross.
mld_mc2point		3	8	10,047	Defines 2 Point data for Cross Experiments. 2 Point data records typing of animals for specified pairs of Markers. Detail of MLD_Matrix.
mld_mcdatalist		1	6	30,247	Defines Haplotype data for Cross Experiments. Haplotype data records haplotypes and number of offspring for Experimental Markers designated as having Haplotype data (MLD_Expt_Marker.matrixData = 1). Detail of MLD_Matrix.
mld_notes		1	4	1,664	Mapping Notes for a specific Reference.
mld_ri		1	5	3,501	Defines RI (Recombinant Inbred and Recombinant Congenic) Experiment. RI Experiments use well-defined recombinant inbred and recombinant congenic strains to provide linkage mapping information. See MLD_RI2Point, MLD_RIData, RI_RISet.
mld_ri2point		3	9	524	Defines 2 Point data for RI Experiments. 2 Point data records typing of animals for specified pairs of Markers and specified RI Sets. Detail of MLD_RI.
mld_ridata		2	6	12,779	Defines Haplotype data for RI Experiments. Haplotype data records strain distribution pattern for Experimental Markers for each animal in the RI set. Detail of MLD_RI.
mld_statistics		3	10	27,147	Defines Statistics generated from Haplotype and 2 Point data. Generated automatically based on Experiment Type (CROSS or RI) and Cross Type (if Experiment is a CROSS). See MLD_Expts.
mrk_acc_view			15	view
mrk_accnoref_view			17	view
mrk_accref1_view			21	view
mrk_accref2_view			21	view
mrk_biotypemapping		7	11	191	Translations : raw biotype->feature type/MCV, raw biotype->marker type
mrk_chromosome		3	8	364	A record in this table represents an ordered Chromosome for the specified Organism (Species). See MRK_Marker.
mrk_cluster	1	4	10	62,796	A record in this table defines a relationship between a set of markers. This table was designed to represent Homology clusters to allow multiple markers per organism to be in a cluster and has been generalized by including a cluster type, a source and an accession ID See MRK_Marker
mrk_clustermember		2	4	185,964	A record in this table defines an ordered set of members of a marker cluster. See MRK_Cluster
mrk_current		2	4	747,982	Defines relationship between a Marker and its Current Symbol(s). A Marker may have one or more current symbols associated with it. Usually there is only one current symbol for a marker. But, if a marker is split, then each of the new symbols will be assigned as a current symbol of the split symbol. See MRK_Marker.
mrk_current_view			8	view
mrk_do_cache		5	16	12,521	A record in this table represents the cached value of a mouse genotype/DO annotation or a human marker/DO annotation. See mrkcacheload/mrkdo.csh.
mrk_history		7	13	817,702	A record in this table represents a nomenclature event in the life of a Marker. A nomenclature event is defined by the event itself (rename, merge, split, etc.), the reason for the event, date of the event, reference (J:).
mrk_history_view			24	view
mrk_label		3	11	3,881,155	A record in this table represents the cached value of a label (name, synonym, symbol) for a Marker. Examples: [priority = 1, label type = "MS", label name = "current symbol"], [priority = 2, label = "MN", label name = "current name"]. See mrkcacheload/mrklabel.csh for complete list.
mrk_location_cache		4	18	939,133	A record in this table represents the cached value of a Marker and its genetic and physical location. See mrkcacheload/mrklocation.csh.
mrk_marker	41	5	13	1,326,818	A record in this table represents a Marker (gene, dna segment, complex/cluster). Mouse Markers have MGI Accession IDs. Non-mouse Markers (human, rat, etc.) are also stored in this table.
mrk_marker_view			20	view
mrk_mcv_cache		3	9	2,639,910	A record in this table represents the cached value of a Marker and its Feature Types. See MRK_Marker. See mrkcacheload/mrkmcv.csh.
mrk_mcv_count_cache		2	6	65	A cache of the current number of markers annotated to a given Feature Type Vocab Term (formerly known as Marker Category Vocabulary)
mrk_mouse_view			22	view
mrk_notes		1	4	13,682	A record in this table represents a note for a Marker.
mrk_reference		2	8	2,317,020	A record in this table represents a unique association between a Marker and a Reference. This is a cache table that is rebuilt nightly by the mrkcacheload product. It represents a union of unique Marker/Reference associations from all data sets in MGI (Expression, Mapping, Alleles, GO Annotations, etc.).
mrk_status	1		4	3	Controlled vocabulary table for all Marker Statuses (approved, withdrawn). See MRK_Marker.
mrk_strainmarker		5	8	745,689	A record in this table represents a Strain/Marker relationship
mrk_summary_view			17	view
mrk_summarybyreference_view			9	view
mrk_types	4		4	9	Controlled vocabulary table for all Marker Types. See MRK_Marker.
prb_acc_view			15	view
prb_accref_view			16	view
prb_alias		3	7	99,922	Defines synonyms for Probe names referred to in a specific Reference. See PRB_Reference, PRB_Probe.
prb_allele	1	3	8	64,247	Defines relationship between an RFLV (marker/endonuclease pair), an allele "symbol", and a fragment size. See PRB_RFLV, PRB_Allele_Strain, PRB_Reference.
prb_allele_strain		4	7	138,903	Defines relationship between a defined RFLV Allele (PRB_Allele) and a Strain. An RFLV Allele may have one or more Strains associated with it. See PRB_Allele, PRB_RFLV, PRB_Strain.
prb_marker		5	9	1,117,827	Defines relationship between a Probe and a Marker. Relationship values: H = hybridizes to, E = encodes, A = amplifies, M = MIT Physical Mapping data, P = putative (ESTs). A Probe can have one or more Markers associated with it. See PRB_Probe, MRK_Marker.
prb_marker_view			12	view
prb_notes		1	5	76,339	A record in this table represents a note for a Molecular Segment.
prb_probe	10	7	17	2,207,657	Defines an accessionable Molecular Segment object. Master table for all Molecular Segments: Single-stranded DNA or RNA molecules of specific base sequence, labeled either radioactively or immunologically, that are used to detect the complementary base sequence by hybridization. Master for PRB_Marker, PRB_Reference.
prb_probe_view			25	view
prb_ref_notes		1	4	1,957	A record in this table represents a note for a Molecular Segment Reference.
prb_reference	3	4	9	2,911,099	Defines relationship between a Probe and a Reference. A Probe may have one or more References associated with it. Accession numbers can be associated with Probes using the Reference object in conjunction with the ACC_AccessionReference table. See PRB_Probe.
prb_rflv	1	4	8	22,683	Defines a relationship between a Marker and an Endonuclease for a specific Probe Reference. Variations exist between individuals in DNA fragment sizes cut by specific restriction enzymes; polymorphic sequences that result in RFLPs are used as markers on both physical maps and genetic linkage maps. RFLPs are usually caused by mutation at a cutting site. Detail of PRB_Reference.
prb_source	3	10	19	85,511	Defines the biological context from which a Probe is derived, e.g., species, strain, tissue, etc. Some sources are well-defined "libraries". Every Probe has one and only one Source. See PRB_Probe.
prb_source_acc_view			14	view
prb_source_view			30	view
prb_strain	17	4	11	89,555	A record in this table represents a unique strain or genetic background. Accession IDs for Strains (MGI, JRS, EMMA, MMRC, etc.) are stored in the ACC_Accession table.
prb_strain_acc_view			14	view
prb_strain_attribute_view			4	view
prb_strain_genotype		5	8	20,897	A record in this table represents a Strain/Genotype association. An association is qualified using the _Qualifier_key. A Strain can have 0 or more Genotypes associated with it.
prb_strain_genotype_view			13	view
prb_strain_marker		6	9	79,202	A record in this table represents a Strain/Marker/Allele association. An associations is qualified using the _Qualifier_key. A Strain can have 0 or more Marker/Allele pairs associated with it. A Strain may be created as the result of a mutation (transgenic allele), in which case the transgenic allele is associated with the newly bred Strain using this table. For example: MGI:4847055/Tg(Foxi2-EGFP)HX217Gsat, strain of origin: FVB/NTac. New Strain: MGI:5003868/STOCK Tg(Foxi2-EGFP)HX217Gsat/Mmucd associated with MGI:5003868/Tg(Foxi2-EGFP)HX217Gsat via PRB_Strain/PRB_Strain_Marker.
prb_strain_marker_view			14	view
prb_strain_needsreview_view			8	view
prb_strain_view			15	view
prb_tissue	1		5	590	Controlled vocabulary table for all Tissues. Includes Not Applicable (-2) and Not Specified (-1).
ri_riset	1	2	9	40	A record in this table represents the definition of a Recombinant Inbred Strain.
ri_summary		2	6	9,583	A record in this table represents the RI haplotypes for a given RI Set and a given Marker.
ri_summary_expt_ref		2	5	12,716	A record in this table defines the Experiment and Reference for an RI Summary record. There is one or more RI_Summary_Expt_Ref records per RI_Summary record.
seq_allele_assoc		6	9	745,030	A record in this table represents the association between an Allele and a Sequence.
seq_coord_cache		4	13	1,995,038	A record in this table represents the Sequence coordinate for an Assembly Sequence. See seqcacheload/seqcoord.csh.
seq_genemodel		4	9	1,219,596	A record in this table represents additional information about Gene Model Sequences.
seq_genetrap		6	10	906,842	A row in this table represents additional information about Gene Trap sequences.
seq_marker_cache		11	18	2,529,411	A record in this table represents the cached value of the annotation between a mouse Marker and a Sequence. See seqcacheload/seqmarker.csh.
seq_probe_cache		5	8	2,166,128	A record in this table represents the cached value of the annotation between a mouse Molecular Segment and a Sequence. See seqcacheload/seqprobe.csh.
seq_sequence	10	7	18	14,414,647	A record in this table represents a specific Sequence object.
seq_sequence_acc_view			14	view
seq_sequence_assoc		5	8	212,974	A record in this table represents the association between two Sequences objects. For example, a Gene Model Sequence can be associated with its protein or transcript sequence.
seq_sequence_raw		3	13	14,414,647	A record in this table represents the raw attributes of a Sequence.
seq_source_assoc		4	7	14,414,647	A record in this table represents the relationship between a Sequence and a Molecular Source (PRB_Source).
seq_summary_view			17	view
voc_allele_cache		2	4	440,559	A record in this table represents the cached value of the association between an Allele and an Annotation Type. The Annotation Types are VOC_AnnotType: 1002:Mammalian Phentype/Genotype, 1020:DO/Genotype. The cache is loaded from mgicacheload/vocallele.csh which calls stored procedures in pgmgddbschema/procedure (VOC_Allele_Cache, VOC_GO_Cache, VOC_Marker_Cache).
voc_annot	1	3	7	3,497,353	A record in this table represents the Annotation between a Vocabulary Term and an Object of type specified by the Annotation Type. There is one Annotation per Object/Term/Annotation Type/isNot. See VOC_AnnotType.
voc_annot_count_cache		1	6	85,056	A record in this table represents a cached value of the number of objects (of a given type) with annotations (of a given type) to a given vocabulary term.
voc_annot_view			16	view
voc_annotheader		5	12	217,832	A record in this table represents the unique use of a Header term for a specific annotated Object of a specific Annotation Type. A set of records grouped by Annot Type/Object represents the ordered list of Header terms for an annotated Object of a specific Annotation Type.
voc_annottype	2	4	8	21	A record in this table defines an Annotation Type. Each Annotation instance specifies its type (VOC_Annot). An Annotation Type specifies an Object type (_MGIType_key), the Vocabulary to which an Object of that type is being annotated (_Vocab_key), and the Evidence Vocabulary (_EvidenceVocab_key) used to annotate the Object of the specified type. An Object which is to be annotated (a Marker or a Genotype) is an accessionable object which requires an entry in ACC_MGIType.
voc_evidence	1	5	9	3,046,166	A record in this table represents one evidence statement which supports one Annotation. There can be one or more Evidence records per Annotation. Although the schema supports zero or more Evidence records per Annotation, editorially at least one Evidence record is required per Annotation.
voc_evidence_property		4	10	3,647,657	A record in this table represents the association between an Annotation Evidence record and a Property. This stores the contextual data of a particular Annotation row. Each stanza that occurs in a given Annotation experiment (row) is stored as separate contextual data within the Annotation experiment. Each individual stanza is treated as a distinct contextual set of data that is associated with the proper Annotation row.
voc_evidence_view			16	view
voc_go_cache		2	6	47,614	A record in this table represents the cached value of the GO Terms, the GO DAG and GO accession ids. See mgicacheload/vocgo.csh.
voc_marker_cache		2	4	4,061,465	A record in this table represents a cached value of the association between a Marker, a Term and an Annotation Type. The Annotation Types are VOC_AnnotType: 1000:GO/Marker, 1003:InterPro/Marker, 1002:Mammalian Phenotype/Genotype, 1020:DO/Genotype, 1022:DO/Human Marker, 1007:PIRSF/Marker. The cache is loaded from mgicacheload/vocmarker.csh which refers to stored procedues in mgddbschema/procedure (VOC_Cache_Markers, VOC_Cache_Anatomy_Markers, VOC_Cache_MP_Markers, VOC_Cache_DO_Markers, VOC_Cache_Other_Markers).
voc_term	122	3	11	258,245	A record in this table represents a Vocabulary Term for a specific Vocabulary. There is one big bucket of Terms for each Vocabulary. A Term can appear in 0 or more DAGS within the same Vocabulary. Remember that a Term is an accessionable object, so there is a corresponding entry for this table in ACC_MGIType.
voc_term_acc_view			14	view
voc_term_emapa		6	8	7,982	A record in this table represents additional information about EMAPA (abstract mouse) structured vocabulary terms. Each term has a starting and ending Theiler stage and a default parent (or null if root term). See VOC_Term._Vocab_key = 90
voc_term_emaps		6	8	35,964	A record in this table represents additional information about EMAPS (Theiler stage specific) structured vocabulary terms. Each term has a Theiler stage, an EMAPA term and a default parent (or null if root term). See VOC_Term._Vocab_key = 91
voc_term_repqualifier_view			12	view
voc_term_view			15	view
voc_termfamily_view			13	view
voc_termfamilyedges_view			5	view
voc_vocab	11	2	8	168	A record in this table represents a Vocabulary. Different versions of the same Vocabulary are represented by records with different names (as in GO 1.0, GO 2.0, etc).
voc_vocabdag		2	4	44	A record in this table represents an ownership relationship of a Vocabulary over a DAG. A Vocabulary can have many DAGS, but a DAG can belong to at most one Vocabulary.
wks_rosetta		1	6	64	A record in this table represents the relationship between a Marker in the WK Silvers book and a Marker in MGI.

176 Tables			1,588	412,468,659
126 Views			1,816