SchemaSpy Analysis of scope Generated by
SchemaSpy
Generated by SchemaSpy on Wed Oct 09 10:41 PDT 2013
Database Type: MySQL - 5.1.63-0+squeeze1 SourceForge.net


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

Table Children Parents Columns Rows Comments
aerospaci 2 19 577,001 AEROSPACI all data
astral_chain 2 3 5 1,858,201 ASTRAL chain sequence
astral_chain_link_domain 2 2 333,892 Links between ASTRAL chains and domains
astral_chain_subset_id 2 3 381,564 PDB representative chains selected by %ID
astral_domain 3 4 7 3,133,209 ASTRAL domain sequence
astral_domain_subset_blast_e 3 4 1,326,969 SCOP representative domains selected by BLAST E-value
astral_domain_subset_id 3 4 2,013,865 SCOP representative domains selected by %ID
astral_seq 5 3 227,361 ASTRAL sequences
astral_seq_blast 1 6 13 138,062,136 ASTRAL BLAST results
astral_seq_blast_gap 1 4 1,153,132 Gaps from ASTRAL BLAST results
astral_seq_hmm_pfam 1 2 9 422,977 Pfam hits in ASTRAL sequences
astral_seq_hmm_pfam_gap 1 4 61,454 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 1,122,387 Link to parent PDB chain
link_pfam 1 2 6,637 Link to Pfam
link_species 2 2 154,344 Link to species data
link_uniprot 1 2 24,389 Link to Uniprot
pdb_author 3 66,682 PDB authors
pdb_chain 5 1 4 702,285 PDB chain
pdb_chain_compound 2 2 613,557 links between PDB compounds and chains
pdb_chain_gene 2 2 341,649 links between PDB sources (genes) and chains
pdb_chain_source 2 2 579,148 links between PDB sources (species) and chains
pdb_compound 1 2 43,831 PDB compounds
pdb_entry 4 1 8 93,251 PDB entries and literature references
pdb_gene 1 2 24,481 PDB sources (genes)
pdb_headers 1 5 214,733 PDB headers
pdb_heterogen 1 2 14,522 PDB heterogens
pdb_local 1 5 258,943 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 223,245 PDB entry releases
pdb_release_author 3 1,128,248 links between PDB authors and their released entries
pdb_release_heterogen 2 2 535,401 links between PDB heterogens and releases
pdb_source 2 6 17,365 PDB sources (species)
pdb_source_species 2 2 5,149 PDB sources mapped to SCOP species
pfam 4 2 8 125,948 Pfam
pfam_equiv 2 2 8,425 Map between old and new Pfam families
pfam_local 1 2 14 Local copies of Pfam hmm files
pfam_release 2 1 4 56 Pfam releases
pfam_type 1 2 4 Pfam family types
raf 1 4 6 1,016,810 RAF maps
raf_version 1 3 2 RAF version
scop_comment 1 4 899,595 SCOP comments
scop_curation_type 1 2 5 SCOP curation types
scop_history 4 6 30,159 SCOP history
scop_history_type 1 3 13 Types of SCOP history changes
scop_index 3 1,462,064 SCOP index
scop_level 1 7 8 SCOP level
scop_node 13 4 9 1,456,784 SCOP node
scop_node_pdbstyle 2 3 1,115,828 Links to ASTRAL PDB-style files
scop_node_thumbnail 9 9 1,360,041 Links to thumbnail images
scop_release 10 6 14 SCOP versions
scop_subset_level 2 2 338,841 SCOP representative domains from each level
species 2 5 4,234 SCOP species
thumbnail 8 4 1,196,942 Thumbnail images
uniprot 2 6 22,513,169 Uniprot
uniprot_accession 1 2 23,478,377 Uniprot Accession
uniprot_pfam 2 2 22,220,181 Uniprot to Pfam links given by Pfam
           
60 Tables     265 232,950,136  
0 Views     0