SchemaSpy Analysis of scop Generated by
SchemaSpy
Generated by SchemaSpy on Sat Feb 27 10:37 PST 2016
Database Type: MySQL - 5.5.35-0+wheezy1 SourceForge.net


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

Table Children Parents Columns Rows Comments
aerospaci 2 19 874,729 AEROSPACI all data
astral_chain 2 3 5 2,498,112 ASTRAL chain sequence
astral_chain_link_domain 2 2 149,882 Links between ASTRAL chains and domains
astral_chain_subset_id 2 3 398,661 PDB representative chains selected by %ID
astral_domain 3 4 7 3,641,661 ASTRAL domain sequence
astral_domain_subset_blast_e 3 4 2,128,959 SCOP representative domains selected by BLAST E-value
astral_domain_subset_id 3 4 2,926,417 SCOP representative domains selected by %ID
astral_seq 6 3 431,874 ASTRAL sequences
astral_seq_blast 1 6 13 483,585,001 ASTRAL BLAST results
astral_seq_blast_gap 1 4 5,222,344 Gaps from ASTRAL BLAST results
astral_seq_coils 1 4 41,015 Coils hits in selected ASTRAL sequences
astral_seq_hmm_pfam 1 2 9 1,081,322 Pfam hits in ASTRAL sequences
astral_seq_hmm_pfam_gap 1 4 156,430 Gaps in Pfam hits in ASTRAL sequences
astral_seq_source 3 2 4 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 6 HMMER releases
link_pdb 2 2 1,811,637 Link to parent PDB chain
link_pfam 1 2 13,411 Link to Pfam
link_pubmed 1 2 133 Link to PubMed
link_species 2 2 227,944 Link to species data
link_uniprot 1 2 42,789 Link to Uniprot
pdb_author 3 78,030 PDB authors
pdb_chain 9 1 4 905,073 PDB chain
pdb_chain_compound 2 2 815,329 links between PDB compounds and chains
pdb_chain_dbref 1 1 9 776,319 DB Cross-references from PDB metadata
pdb_chain_diff 1 3 7 546,615 Categories of SEQADV records
pdb_chain_diff_category 1 2 260 Categories of SEQADV records
pdb_chain_gene 2 2 426,357 links between PDB sources (genes) and chains
pdb_chain_source 2 2 831,525 links between PDB sources (species) and chains
pdb_chain_tag 2 5 26,566 Tags inferred from SEQADV records
pdb_chain_uniprot 1 2 668,973 Links between PDB chains and Uniprot
pdb_compound 1 2 54,785 PDB compounds
pdb_entry 4 1 8 138,865 PDB entries and literature references
pdb_gene 1 2 29,023 PDB sources (genes)
pdb_headers 1 5 266,486 PDB headers
pdb_heterogen 1 2 18,073 PDB heterogens
pdb_local 1 5 329,591 Info about local copy of PDB
pdb_method 1 5 192 PDB experimental methods
pdb_model 1 1 414 PDB entries classifed by the PDB as models
pdb_release 5 3 18 348,987 PDB entry releases
pdb_release_author 3 1,373,756 links between PDB authors and their released entries
pdb_release_heterogen 2 2 676,737 links between PDB heterogens and releases
pdb_source 2 6 20,437 PDB sources (species)
pdb_source_species 2 2 5,149 PDB sources mapped to SCOP species
pfam 3 2 8 140,269 Pfam
pfam_equiv 2 2 8,425 Map between old and new Pfam families
pfam_local 1 2 15 Local copies of Pfam hmm files
pfam_release 2 1 4 57 Pfam releases
pfam_type 1 2 6 Pfam family types
raf 1 4 6 1,140,496 RAF maps
raf_version 1 3 2 RAF version
scop_comment 1 4 1,925,058 SCOP comments
scop_curation_type 1 2 7 SCOP curation types
scop_history 4 6 121,319 SCOP history
scop_history_type 1 3 13 Types of SCOP history changes
scop_index 3 2,267,734 SCOP index
scop_level 1 7 8 SCOP level
scop_node 14 4 9 2,238,775 SCOP node
scop_node_pdbstyle 2 3 1,781,397 Links to ASTRAL PDB-style files
scop_node_thumbnail 9 9 2,386,775 Links to thumbnail images
scop_release 10 8 17 SCOP versions
scop_subset_level 2 2 477,837 SCOP representative domains from each level
species 2 5 5,133 SCOP species
thumbnail 8 4 1,896,666 Thumbnail images
uniprot 7 80,283,765 Uniprot
           
65 Tables     295 608,243,651  
0 Views     0