SchemaSpy Analysis of cxgn.genomic |
Generated by SchemaSpy |
Generated by SchemaSpy on Wed May 20 01:31 EDT 2009 | |
Database Type: PostgreSQL - 8.1.11 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
18 Tables:
Total rows: 6,310,519
Table | Children | Parents | Rows | Comments |
---|---|---|---|---|
blast_db | 1 | 7 | ||
blast_defline | 73,443 | |||
blast_hit | 1 | 1,664,130 | ||
blast_query | 1 | 2 | 1,952,983 | |
chromat | 1 | 1 | 613,368 | |
clone | 1 | 2 | 473,472 | |
clone_type | 2 | 2 | ||
genbank_submission | 1 | 2 | ||
gss | 2 | 1 | 613,728 | |
gss_submitted_to_genbank | 2 | 305,545 | ||
library | 2 | 4 | 6 | |
library_annotation_db | 18 | |||
library_detail | 1 | 7 | ||
library_shortname_abbreviation | 1 | 28 | stores known abbreviations for the shortnames of genomic libraries | |
qc_report | 1 | 613,716 | ||
query_source_type | 1 | 1 | ||
read_class | 57 | |||
sequencing_primer | 2 | 6 |