Database Schema and Common SQL Queries

Image Files
Common SQL Queries (pdf): Size137.5 kB Last Modified2007-03-02 16:24:03

Common SQL queries for human 8.1, mouse 2.1, and rat 1.1 and all newer cisRED database versions for these species.
Database Schema for Human 8.1, Mouse 2.1, Rat 1.1, C.elegans 2 and all newer cisRED database versions for these species.: Size1 kB Last Modified2007-06-20 16:44:35

An entity relationship diagram of the cisRED relational database.
Database Tables and Fields for Human 9 (pdf): Size64.2 kB Last Modified2007-11-19 10:28:29

This database contains the additional table 'search_region_masks'.
Database Tables and Fields for Human 8.3 (pdf): Size67.3 kB Last Modified2007-06-14 13:18:46

This database contains two additional tables: pattern_go_terms and search_region_masks
Database Tables and Fields for Human Stat1 ChIP-seq peaks (pdf): Size64.0 kB Last Modified2007-06-14 13:31:02

This database contains two additional tables: region_transcript_associations and search_region_masks.
Database Tables and Fields for Mouse 3.1(pdf): Size66.4 kB Last Modified2007-06-14 13:24:44

This database contains two additional tables: custom_tf and search_region_masks
Database Tables and Fields for Rat 1.1(pdf): Size63.7 kB Last Modified2007-06-14 13:30:07

This database contains one additional table: search_region_masks
Database Tables and Fields for Human 8.1 and 8.2, Mouse 2.1 and 3.0, Rat 1.1, and C.elegans 2 (pdf): Size63.5 kB Last Modified2007-06-20 16:56:14