SchemaSpy Analysis of cxgn.sgn

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 20 01:50 EDT 2009
Database Type: PostgreSQL - 8.1.11 SourceForge.net

Please support this project

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

104 Tables and 1 View:

Table Children Parents Rows Comments
accession 5 2 66
accession_names 1 1 67
annotation_target_type 1
authors 0
blast_annotations 1 1 956,930
blast_db 1 1 55 This table holds metadata about the BLAST databases that we keep in stock.
blast_db_group 1 9
blast_defline 1,674,216
blast_hits 1 24,526,357
blast_targets 3
cds 1 1 725,273
clone 3 1 968,611
cloning_vector 9
common_name 2 17
cos_markers 1 1,025
cosii_ortholog 1 10,668
deprecated_linkage_groups 1 1 151
deprecated_map_cross 2 18
deprecated_mapdata 1 2 7,750
deprecated_maps 5 12
deprecated_marker_confidences 2 5
deprecated_marker_locations 3 7,724
deprecated_marker_types 1 16
deprecated_markers 3 1 7,516
derived_from_source 1 4
domain 1 1 24,823
domain_match 3 223,057
enzyme_restriction_sites 8,933
enzymes 1 130
est 3 1 1,197,154
est_dbxref 1 563,109
ests_mapped_by_clone 2 146
experiment_type 1 4
facility 1 28
family 2 1 128,925
family_build 1 6
family_member 1 607,067
family_tree 1 6,113
fish_chromatin_density_constants 2
fish_experimenter 1 1
fish_file 3,419
fish_image 216
fish_karyotype_constants 24
fish_karyotype_constants_old 12
fish_result 3 2,254
fish_result_composite 215
go 1 2,838
group_linkage 2,814,750
groups 1 34,827
id_linkage 907,042
il_info 163
interpro 1 13,261
interpro_go 2 17,839
library 1 1 203
linkage_group 1 3 407
loc_types 2
manual_annotations 6,833
manual_censor_reasons 1
map 2 3 19
map_version 3 2 32
marker 13 7,422
marker_alias 1 7,423
marker_collectible 2 3,968
marker_collection 1 3
marker_confidence 1 5
marker_derived_from 2 763
marker_experiment 4 27,361
marker_location 3 3 21,298
marker_to_map view
metadata 2 10
microarray 13,440
misc 0
organism 2 5 55
organismprop 1 141
p_markers 1 32
pcr_exp_accession 1 2 10,756
pcr_experiment 2 5 8,990
pcr_product 2 13,136
primer_unigene_match 2 1,895
qc_report 1 993,576
rflp_markers 1 3 665
rflp_sequences 3 1,277
rflp_unigene_associations 2 1,995
seqread 1 2 1,008,055
sequence 2 6,208
ssr 2 1 647
ssr_primer_unigene_matches 2 36
ssr_repeats 2 891
submit_user 10
taxonomy 4 29
temp_caps_correspondence 291
temp_map_correspondence 2 12
temp_marker_correspondence 1 607
tigrtc_index 1
tigrtc_membership 138,407
tigrtc_tracking 91,488
tm_markers 1 2 30
tm_markers_sequences 30
trim_feature 563,973
trim_feature_types 9
types 1 19
unigene 6 2 575,206
unigene_build 4 5 30
unigene_consensi 1 305,323
unigene_member 2 2,564,656

Total rows: 41,820,527