Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.seq_sequence
A record in this table represents a specific Sequence object.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_sequence_key int4 10
seq_allele_assoc._sequence_key seq_allele_assoc__sequence_key_fkey C
seq_coord_cache._sequence_key seq_coord_cache__sequence_key_fkey C
seq_genemodel._sequence_key seq_genemodel__sequence_key_fkey C
seq_genetrap._sequence_key seq_genetrap__sequence_key_fkey C
seq_marker_cache._sequence_key seq_marker_cache__sequence_key_fkey C
seq_probe_cache._sequence_key seq_probe_cache__sequence_key_fkey C
seq_sequence_assoc._sequence_key_1 seq_sequence_assoc__sequence_key_1_fkey C
seq_sequence_assoc._sequence_key_2 seq_sequence_assoc__sequence_key_2_fkey C
seq_sequence_raw._sequence_key seq_sequence_raw__sequence_key_fkey C
seq_source_assoc._sequence_key seq_source_assoc__sequence_key_fkey C
primary key
_sequencetype_key int4 10
voc_term._term_key seq_sequence__sequencetype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
_sequencequality_key int4 10
voc_term._term_key seq_sequence__sequencequality_key_fkey R
foreign key to VOC_Term where _Vocab_key = 19 (Sequence Quality)
_sequencestatus_key int4 10
voc_term._term_key seq_sequence__sequencestatus_key_fkey R
foreign key to VOC_Term where _Vocab_key = 20 (Sequence Status)
_sequenceprovider_key int4 10
voc_term._term_key seq_sequence__sequenceprovider_key_fkey R
foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
_organism_key int4 10
mgi_organism._organism_key seq_sequence__organism_key_fkey R
foreign key to MGI_Organism
length int4 10  √  null length of sequence
description text 2147483647  √  null description
version text 2147483647  √  null GenBank version
division bpchar 3  √  null GenBank division
virtual int2 5 is this sequence virtual (consensus)?
numberoforganisms int4 10  √  null for Swiss-Prot, number of non-mouse, non-human, non-rat organisms that are sources of this sequence
seqrecord_date timestamp 29,6 now() last modification date of the sequence record from the provider
sequence_date timestamp 29,6 now() last modification date of the sequence itself
_createdby_key int4 10 1001
mgi_user._user_key seq_sequence__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key seq_sequence__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 14,414,647 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_sequence_key Primary key, Used to cluster data Asc seq_sequence_pkey
_sequencetype_key + _sequenceprovider_key + length Performance Asc/Asc/Asc seq_sequence_idx_clustered
_createdby_key Performance Asc seq_sequence_idx_createdby_key
length Performance Asc seq_sequence_idx_length
_modifiedby_key Performance Asc seq_sequence_idx_modifiedby_key
seqrecord_date Performance Asc seq_sequence_idx_seqrecord_date
_sequenceprovider_key Performance Asc seq_sequence_idx_sequenceprovider_key
_sequencequality_key Performance Asc seq_sequence_idx_sequencequality_key
_sequencestatus_key Performance Asc seq_sequence_idx_sequencestatus_key
_sequencetype_key Performance Asc seq_sequence_idx_sequencetype_key

Close relationships  within of separation: