TARO Database schema
TARO records about 100Mb of data per single query. Deployed TARO database size is 13 Gb. Database dump size 1.2 Gb. Table sizes are:
- 4.8Gb - pipe_display_main
- 4.3Gb - pipe_annotation
- 1.9Gb - pipe_sequence_homology
- 0.76Gb - pipe_sequence_statistics
- 0.59Gb - pipe_rps_blast_top_hit
- 0.34Gb - pipe_targetdb_status
- <0.6Gb - other tables
Suggested Improvements
Several foreing key constraints appears to be missing. The database consistency would have benefited if they are added. Unused tables may be safely dropped (pipe_astral_blast_top_hit)
