Difference between revisions of "GTRD"
Ivan Yevshin (Talk | contribs) |
Ivan Yevshin (Talk | contribs) |
||
| Line 52: | Line 52: | ||
==Database structure== | ==Database structure== | ||
| + | The metadata concerning GTRD is stored in MySQL tables. | ||
| + | |||
| + | Each ChIP-seq experiment has a row in 'chip_experiments' table, which assigns id and stores basic information about experiment. | ||
| + | 'chip_experiments' table structure: | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Column !! Description || Example value | ||
| + | |- | ||
| + | | id || Unique experiment identifier || EXP000489 | ||
| + | |- | ||
| + | | antibody || sc-345 | ||
| + | |- | ||
| + | | tfClassId || Id in TFClass[http://www.edgar-wingender.de/huTF_classification.html] database of target transcription factor, NULL for control experiments || 6.2.1.0.1 | ||
| + | |- | ||
| + | | cell_line || Studied cell line || HeLa S3 | ||
| + | |- | ||
| + | | specie || Specie latin name || Homo sapiens | ||
| + | |- | ||
| + | | treatment || Cell treatment or conditions || IFN gamma | ||
| + | |- | ||
| + | | control_id || Id of control experiment, NULL for control experiments or experiments without control || EXP000490 | ||
| + | |} | ||
==Web interface to database== | ==Web interface to database== | ||
Revision as of 18:40, 1 July 2013
GTRD (Gene Transcription Regulation Database) is a database of transcription factor binding sites identified from ChIP-seq experiments. GTRD analyze freely avalable ChIP-seq experiments from literature, GEO, SRA and ENCODE databases.
The web interface to GTRD is available at http://192.168.199.241/bioumlweb/#anonymous=true&perspective=GTRD.
Database statistics
GTRD uses 2417 ChIP-seq experiments for 470 distinct sequence specific transcription factors.
General statistics:
| Object type | Total count | Per ChIP-seq experiment |
|---|---|---|
| ChIP-seq reads | 80.808E9 | 34.937E6 |
| Read alignments | 58.848E9 | 25.675E6 |
| ChIP-seq peaks | 59.515E6 | 32899 |
In average each transcription factor is measured in 4.07 ChIP-seq experiments, but 284 (60%) transcription factors measured only in one experiment.
The ten most studied transcription factors listed bellow:
| Transcription Factor | Number of ChIP-seq experiments |
|---|---|
| CTCF | 195 |
| c-Myc | 45 |
| ERα | 44 |
| NRSF | 37 |
| C/EBPβ | 37 |
| GATA-1 | 33 |
| NF-κB p65 | 30 |
| Max | 30 |
| PU.1 | 29 |
| GR | 24 |
Database structure
The metadata concerning GTRD is stored in MySQL tables.
Each ChIP-seq experiment has a row in 'chip_experiments' table, which assigns id and stores basic information about experiment. 'chip_experiments' table structure:
| Column | Description | Example value |
|---|---|---|
| id | Unique experiment identifier | EXP000489 |
| antibody | sc-345 | |
| tfClassId | Id in TFClass[1] database of target transcription factor, NULL for control experiments | 6.2.1.0.1 |
| cell_line | Studied cell line | HeLa S3 |
| specie | Specie latin name | Homo sapiens |
| treatment | Cell treatment or conditions | IFN gamma |
| control_id | Id of control experiment, NULL for control experiments or experiments without control | EXP000490 |
