Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.seq_genetrap
A row in this table represents additional information about Gene Trap sequences.

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_view._sequence_key Implied Constraint R
seq_allele_view._sequence_key Implied Constraint R
seq_marker_cache_view._sequence_key Implied Constraint R
seq_probe_cache_view._sequence_key Implied Constraint R
seq_sequence_view._sequence_key Implied Constraint R
seq_sequence._sequence_key seq_genetrap__sequence_key_fkey C
foreign key to SEQ_Sequence
_tagmethod_key int4 10
voc_term._term_key seq_genetrap__tagmethod_key_fkey R
foreign key to VOC_Term (_Vocab_key = 66) The name of the procedure used to produce a sequence tag from a gene trap insertion in a mutant cell line.
_vectorend_key int4 10
voc_term._term_key seq_genetrap__vectorend_key_fkey R
foreign key to VOC_Term (_Vocab_key = 67)
_reversecomp_key int4 10
voc_term._term_key seq_genetrap__reversecomp_key_fkey R
foreign key to VOC_Term (_Vocab_key = 68). Answers the question is this sequence reverse complemented?
goodhitcount int4 10  √  null Number of good blat hits
pointcoordinate numeric 131089  √  null The single coordinate picked to indicate where the insertion actually happened
_createdby_key int4 10 1001
mgi_user._user_key seq_genetrap__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key seq_genetrap__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 906,842 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_sequence_key Primary key, Used to cluster data Asc seq_genetrap_pkey
_reversecomp_key Performance Asc seq_genetrap_idx_reversecomp_key
_tagmethod_key Performance Asc seq_genetrap_idx_tagmethod_key
_vectorend_key Performance Asc seq_genetrap_idx_vectorend_key

Close relationships  within of separation: