Summarybed table: storage of queriable bed files. Back to top
SUMMARYBED TABLE |
||
Fields | Type | Null |
summarybed_id | int(11) | NO |
bedfile_id | int(11) | NO |
chrom | varchar(16) | NO |
chromstart | bigint(20) | NO |
chromend | bigint(20) | NO |
name | varchar(32) | YES |
score | int(11) | YES |
strand | enum('+','-') | YES |
thickstart | bigint(20) | YES |
thickend | bigint(20) | YES |
itemrgb | varchar(16) | YES |
blockcount | bigint(20) | YES |
blocksizes | varchar(32) | YES |
blockstarts | varchar(32) | YES |
Experiment table: Keeps track of individual experimental sessions. Back to top
EXPERIMENT TABLE |
||
Fields | Type | Null |
title | varchar(128) | NO |
researcher_id | int(11) | YES |
exp_date | datetime | NO |
create_date | datetime | NO |
keywords | text | YES |
description | text | YES |
bedcount | int(11) | YES |
Bedfiles tables: Record information about each bed file. Back to top
BEDFILES TABLE |
||
Fields | Type | Null |
bedfile_id | int(11) | NO |
experiment_id | int(11) | NO |
method_id | int(11) | YES |
genome_id | int(11) | YES |
filetype | varchar(32) | YES |
name | varchar(128) | NO |
upload_date | datetime | NO |
expiration | datetime | YES |
header | text | YES |
descr | text | YES |
token | varchar(32) | YES |
token_expires | datetime | YES |
overlap_counts_chart_url | text | YES |
overlaps_per_read_chart_url | text | YES |
is_reference | tinyint(4) | NO |
Genome table: Stores information on the genome builds. Back to top
GENOME TABLE |
||
Fields | Type | Null |
genome_id | int(11) | NO |
name | varchar(64) | NO |
researcher_id | int(11) | YES |
clade | varchar(50) | YES |
org | varchar(50) | YES |
db | varchar(50) | YES |
Method table: stores the different methods generated the bed files. Back to top
METHOD TABLE |
||
Fields | Type | Null |
method_id | int(11) | NO |
name | varchar(64) | NO |
Researcher table: list of individuals who have access to DASR. Back to top
RESEARCHER TABLE |
||
Fields | Type | Null |
researcher_id | int(11) | NO |
varchar(128) | YES | |
firstname | varchar(64) | YES |
lastname | varchar(64) | YES |
username | varchar(32) | NO |
approved | tinyint(4) | NO |
admin | tinyint(4) | NO |
pword_hash | char(64) | NO |