SchemaSpy - Table pub.mgd.seq

A row in this table represents additional information about Gene Trap sequences.

Generated by
SchemaSpy

Legend:

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

map_gm_coord_feature_view._sequence_key

Implied Constraint R

seq_sequence._sequence_key

seq_genetrap__sequence_key_fkey C

foreign key to SEQ_Sequence

_tagmethod_key

int4

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

voc_term._term_key

seq_genetrap__vectorend_key_fkey R

foreign key to VOC_Term (_Vocab_key = 67)

_reversecomp_key

int4

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

√

null

Number of good blat hits

pointcoordinate

numeric

131089

√

null

The single coordinate picked to indicate where the insertion actually happened

_createdby_key

int4

1001

mgi_user._user_key

seq_genetrap__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

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 Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_sequence_key	Primary key	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