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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_sequence_key int4 10
seq_allele_assoc
seq_coord_cache
seq_genemodel
seq_genetrap
seq_marker_cache
seq_probe_cache
seq_sequence_assoc
seq_sequence_assoc
seq_sequence_raw
seq_source_assoc
primary key
_sequencetype_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 21 (Sequence Type)
_sequencequality_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 19 (Sequence Quality)
_sequencestatus_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 20 (Sequence Status)
_sequenceprovider_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 25 (Sequence Provider)
_organism_key int4 10
mgi_organism
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 who created the record
_modifiedby_key int4 10 1001
mgi_user
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
_sequence_key Primary key, Used to cluster data Asc
_sequencetype_key + _sequenceprovider_key + length Performance Asc/Asc/Asc
_createdby_key Performance Asc
length Performance Asc
_modifiedby_key Performance Asc
seqrecord_date Performance Asc
_sequenceprovider_key Performance Asc
_sequencequality_key Performance Asc
_sequencestatus_key Performance Asc
_sequencetype_key Performance Asc

Close relationships  within of separation: