Table cxgn.sgn.cos_markers

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
cos_marker_id serial 10  √  nextval('cos_markers_cos_marker_id_seq'::regclass)
marker_id int8 19 (0)::bigint
marker.marker_id marker_id_fk
est_read_id int8 19 (0)::bigint
cos_id varchar 10 ''::character varying
at_match varchar 25  √  null
bac_id int8 19  √  null
at_position numeric 11,7  √  null
best_gb_prot_hit varchar 25  √  null
at_evalue varchar 25  √  null
at_identities numeric 11,3  √  null
mips_cat varchar 11  √  null
description text 2147483647  √  null
comment text 2147483647  √  null
tomato_copy_number varchar 11  √  null
gbprot_evalue varchar 25  √  null
gbprot_identities numeric 11,3  √  null

Table contained 1,025 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
cos_marker_id Primary key Asc cos_markers_pkey
marker_id + cos_id Performance Asc/Asc marker_id_idx

Close relationships  within one two degrees of separation :