SchemaSpy Analysis of scop Generated by
SchemaSpy
Generated by SchemaSpy on Wed Feb 04 09:59 PST 2015
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 758,821 AEROSPACI all data
astral_chain 2 3 5 2,187,201 ASTRAL chain sequence
astral_chain_link_domain 2 2 117,789 Links between ASTRAL chains and domains
astral_chain_subset_id 2 3 556,704 PDB representative chains selected by %ID
astral_domain 3 4 7 3,454,566 ASTRAL domain sequence
astral_domain_subset_blast_e 3 4 1,739,079 SCOP representative domains selected by BLAST E-value
astral_domain_subset_id 3 4 2,484,617 SCOP representative domains selected by %ID
astral_seq 5 3 361,937 ASTRAL sequences
astral_seq_blast 1 6 13 397,919,583 ASTRAL BLAST results
astral_seq_blast_gap 1 4 4,548,108 Gaps from ASTRAL BLAST results
astral_seq_hmm_pfam 1 2 9 455,629 Pfam hits in ASTRAL sequences
astral_seq_hmm_pfam_gap 1 4 66,267 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,549,306 Link to parent PDB chain
link_pfam 1 2 11,597 Link to Pfam
link_pubmed 1 2 71 Link to PubMed
link_species 2 2 207,274 Link to species data
link_uniprot 1 2 36,382 Link to Uniprot
pdb_author 3 73,061 PDB authors
pdb_chain 7 1 4 760,671 PDB chain
pdb_chain_compound 2 2 740,542 links between PDB compounds and chains
pdb_chain_dbref 1 1 9 484,530 DB Cross-references from PDB metadata
pdb_chain_diff 3 7 458,488 Categories of SEQADV records
pdb_chain_diff_category 1 2 254 Categories of SEQADV records
pdb_chain_gene 2 2 389,853 links between PDB sources (genes) and chains
pdb_chain_source 2 2 700,569 links between PDB sources (species) and chains
pdb_compound 1 2 49,689 PDB compounds
pdb_entry 4 1 8 110,097 PDB entries and literature references
pdb_gene 1 2 27,143 PDB sources (genes)
pdb_headers 1 5 251,029 PDB headers
pdb_heterogen 1 2 17,069 PDB heterogens
pdb_local 1 5 311,044 Info about local copy of PDB
pdb_method 1 5 191 PDB experimental methods
pdb_model 1 1 414 PDB entries classifed by the PDB as models
pdb_release 5 3 18 304,491 PDB entry releases
pdb_release_author 3 1,268,966 links between PDB authors and their released entries
pdb_release_heterogen 2 2 614,961 links between PDB heterogens and releases
pdb_source 2 6 18,772 PDB sources (species)
pdb_source_species 2 2 4,416 PDB sources mapped to SCOP species
pfam 4 2 8 121,430 Pfam
pfam_equiv 2 2 7,813 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,297,612 RAF maps
raf_version 1 3 2 RAF version
scop_comment 1 4 1,556,223 SCOP comments
scop_curation_type 1 2 6 SCOP curation types
scop_history 4 6 44,482 SCOP history
scop_history_type 1 3 13 Types of SCOP history changes
scop_index 3 1,963,984 SCOP index
scop_level 1 7 8 SCOP level
scop_node 14 4 9 1,964,436 SCOP node
scop_node_pdbstyle 2 3 1,524,489 Links to ASTRAL PDB-style files
scop_node_thumbnail 9 9 2,062,110 Links to thumbnail images
scop_release 10 8 16 SCOP versions
scop_subset_level 2 2 429,518 SCOP representative domains from each level
species 2 5 5,128 SCOP species
thumbnail 8 4 1,618,503 Thumbnail images
uniprot 2 6 24,084,519 Uniprot
uniprot_accession 1 2 23,478,377 Uniprot Accession
uniprot_pfam 2 2 22,220,181 Uniprot to Pfam links given by Pfam
           
64 Tables     287 505,420,116  
0 Views     0