Next: Expression data in relational tables
Up: Guide to the EpoDB
Previous: Protein data in table
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| regulatory_regions | table_id set | no | pointer(s) to row(s) in regulatory regions table | none |
| region_alignments | record set | yes | comments re. alignment with homologous regions | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| trrd_id | string | no | TRRD entry id | none |
| gene_accession | int | gene accession number in TRRD | none | |
| transfac_gene_accession | string | no | accession number common to TRRD and Transfac | none |
| trrd_annotated_by | string | no | TRRD annotator | none |
| trrd_last_modified | string | TRRD's last date of editing | none | |
| organism | string | organism field in TRRD | none | |
| gene_name | string | gene name field in TRRD | none | |
| gen_comments | record set | comments re. gene | none | |
| database_gene_source | string set | database and accession of entry containing region | none | |
| epd_gene_class | string | gene class according to EPD classification scheme | none | |
| key_words | string set | keywords in TRRD | none | |
| chromosomal_loc | record | chromosomal localization | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| comments_about | record set | comments re. specificity of gene regulation | none | |
| dev_stage | record set | stages of regulation of expression | none | |
| repression_by | record set | factors repressing expression | none | |
| tissue_where__not_expressed | record set | tissues where gene is not expressed | none | |
| tissue_where_expressed | record set | tissues where gene is expressed | none | |
| induction_by | record set | factors inducing expression | none | |
| cell_cycle | record set | stages of cell cycle stages at which expression is regulated | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| region_name | string | name of regulatory region | none | |
| composite_elements | table_id set | pointers to composite elements in region | none | |
| regulatory_units | table_id set | pointers to regulatory units in region | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| unit_name | string | name of regulatory unit | none | |
| point_name | string | name of position in the sequence relative to which other positions are enumerated | none | |
| start | int | start of unit | none | |
| end | int | end of unit | none | |
| epo_sites | table_id set | pointers to binding sites in unit | none | |
| trrd_sites | int set | TRRD ids for binding sites in unit | none | |
| reference | string | reference used to extract data | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| name | string | name of composite element | none | |
| compel_acc | string | accession number in COMPEL database | none | |
| start | int | start of composite element | none | |
| end | int | end of composite element | none | |
| epo_sites | table_id set | pointers to binding sites in element | none | |
| trrd_sites | int set | TRRD ids for binding sites in element | none | |
| reference | string | reference used to extract data | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| trrd_accession | int | TRRD accession number for site | none | |
| transfac_acc | string set | Transfac accession number for site | none | |
| name | record | name of binding site | none | |
| core_seq | record | binding site core sequence and reference | none | |
| core_sec_location | record | start, end and reference for core sequence | none | |
| footprint_seq | record | binding site sequence determined by footprint experiment | none | |
| footprint_location | record | start, end and reference for footprint sequence | none | |
| footprint_expts | record set | cell type, experiment names and references for footprint experiments | none | |
| ref_to_GenBank | record | pointer to GenBank entry and start of site | none | |
| homology_to_other | record set | homologous sites and references | none | |
| el_comments | record set | comments and references re. binding sites | none | |
| binding_factor | table_id set | pointers to factors which bind this site | none |
| id | identity | no | EpoDB Id | none |
| created_by | string | no | annotator initials | none |
| created_datime | datetime | no | time of parsing | none |
| last_modified_by | string | no | annotator initials | none |
| last_modified_datime | datetime | no | time of update | none |
| transcriptional_regulation | table_id | no | pointer to row in table transcriptional_regulation | none |
| transfac_id | string | Transfac id for factor | none | |
| name | record | short and long names for factor plus reference | none | |
| class | string | factor class | none | |
| comparative_affinity | record set | comparative affinity of factors to binding sites | none | |
| transcription_effect | record | effect on transcription and reference | none | |
| binding_site | table_id set | pointers to binding sites to which factor binds | none |
Fidel Salas