create table gene55 (
`gene_id` int(20) not null,
`start` int(8) not null,
`end` int(8) not null,
`biotype` varchar(40) null,
primary key (`gene_id`)
);
create table transcript55 (
`transcript_id` int(20) not null,
`gene_id` int(20) null,
`start` int(8) not null,
`end` int(8) not null,
`biotype` varchar(40) null,
primary key (`transcript_id`)
);
create table exon55 (
`exon_id` int(20) not null,
`start` int(8) not null,
`end` int(8) not null,
primary key (`exon_id`)
);
create table exon_transcript55 (
`exon_id` int(20) not null,
`transcript_id` int(20) not null,
`rank` int(8) not null,
primary key (`exon_id`, `transcript_id`)
);