SchemaSpy Analysis of scope Generated by
SchemaSpy
Generated by SchemaSpy on Mon Dec 03 17:18 PST 2012
Database Type: MySQL - 5.1.63-0+squeeze1-log SourceForge.net


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

Table Children Parents Columns Rows Comments
aerospaci 2 19 454,054 AEROSPACI all data
astral_chain 2 3 5 1,680,353 ASTRAL chain sequence
astral_chain_link_domain 2 2 397,444 Links between ASTRAL chains and domains
astral_chain_subset_id 2 3 243,119 PDB representative chains selected by %ID
astral_domain 3 4 7 2,415,677 ASTRAL domain sequence
astral_domain_subset_blast_e 3 4 676,143 SCOP representative domains selected by BLAST E-value
astral_domain_subset_id 3 4 1,319,393 SCOP representative domains selected by %ID
astral_seq 5 3 217,534 ASTRAL sequences
astral_seq_blast 1 6 13 38,283,998 ASTRAL BLAST results
astral_seq_blast_gap 1 4 621,886 Gaps from ASTRAL BLAST results
astral_seq_hmm_pfam 1 2 9 57,347 Pfam hits in ASTRAL sequences
astral_seq_hmm_pfam_gap 1 4 8,755 Gaps in Pfam hits in ASTRAL sequences
astral_seq_source 3 2 3 ASTRAL sequence source (i.e., atom or seqres)
astral_seq_style 5 2 4 ASTRAL sequence style (e.g., genetic domain)
hmmer_release 1 2 4 HMMER releases
link_pdb 2 2 959,107 Link to parent PDB chain
link_pfam 1 2 4,578 Link to Pfam
link_species 2 2 136,192 Link to species data
link_uniprot 1 2 18,405 Link to Uniprot
pdb_author 3 60,905 PDB authors
pdb_chain 5 1 4 637,785 PDB chain
pdb_chain_compound 2 2 548,505 links between PDB compounds and chains
pdb_chain_gene 2 2 166,145 links between PDB sources (genes) and chains
pdb_chain_source 2 2 355,221 links between PDB sources (species) and chains
pdb_compound 1 2 42,236 PDB compounds
pdb_entry 4 1 8 89,490 PDB entries and literature references
pdb_gene 1 2 20,980 PDB sources (genes)
pdb_headers 1 5 188,617 PDB headers
pdb_heterogen 1 2 12,976 PDB heterogens
pdb_local 1 5 242,223 Info about local copy of PDB
pdb_method 1 5 189 PDB experimental methods
pdb_model 1 1 414 PDB entries classifed by the PDB as models
pdb_release 5 3 18 255,435 PDB entry releases
pdb_release_author 3 1,037,929 links between PDB authors and their released entries
pdb_release_heterogen 2 2 488,133 links between PDB heterogens and releases
pdb_source 2 6 17,086 PDB sources (species)
pdb_source_species 2 2 4,737 PDB sources mapped to SCOP species
pfam 1 2 8 75,863 Pfam
pfam_local 1 2 13 Local copies of Pfam hmm files
pfam_release 2 1 4 55 Pfam releases
pfam_type 1 2 4 Pfam family types
raf 1 4 6 1,043,944 RAF maps
raf_version 1 3 2 RAF version
scop_comment 1 4 693,611 SCOP comments
scop_history 4 6 21,631 SCOP history
scop_history_type 1 3 12 Types of SCOP history changes
scop_index 2 37,333 SCOP index
scop_level 1 7 8 SCOP level
scop_node 13 3 8 1,202,519 SCOP node
scop_node_pdbstyle 2 3 804,297 Links to ASTRAL PDB-style files
scop_node_thumbnail 8 8 1,136,938 Links to thumbnail images
scop_release 10 6 13 SCOP versions
scop_subset_level 2 2 260,215 SCOP representative domains from each level
species 2 5 3,636 SCOP species
thumbnail 7 4 1,047,549 Thumbnail images
           
55 Tables     248 57,990,645  
0 Views     0