WashU Epigenome Browser » Browser Metadata

drop table if exists orfstruct;

create table orfstruct (

id int unsigned not null primary key,

chrom varchar(255) not null,

strand char(1) not null,

txStart int unsigned not null,

txEnd int unsigned not null,

cdsStart int unsigned not null,

cdsEnd int unsigned not null,

exonCount int unsigned not null,

exonStarts text not null,

exonEnds text not null,

name varchar(255) not null

);

load data local infile 'orf.struct' into table orfstruct;

drop table if exists orfsymbol;

create table orfsymbol (

name varchar(255) not null,

symbol varchar(255) null,

description text null,

id int unsigned not null primary key,

index(name)

);

drop table if exists Gleanstruct;

create table Gleanstruct (

id int unsigned not null primary key,

chrom varchar(255) not null,

strand char(1) not null,

txStart int unsigned not null,

txEnd int unsigned not null,

cdsStart int unsigned not null,

cdsEnd int unsigned not null,

exonCount int unsigned not null,

exonStarts text not null,

exonEnds text not null,

name varchar(255) not null

);

load data local infile 'Glean.struct' into table Gleanstruct;

drop table if exists Gleansymbol;

create table Gleansymbol (

name varchar(255) not null,

symbol varchar(255) null,

description text null,

id int unsigned not null primary key,

index(name)

);