cisRED > Home > Databases & Methods > Database Schema and Common SQL Queries

Database Schema and Common SQL Queries

Up one level

Database Schema and Common SQL Queries Image Files

Database Schema and Common SQL Queries 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 and Common SQL Queries 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 Schema and Common SQL Queries 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

Database Schema and Common SQL Queries 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 Schema and Common SQL Queries 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 Schema and Common SQL Queries 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 Schema and Common SQL Queries 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