chrom_info ( 
chrom	VARCHAR(25), 
start_pt INTEGER, 
stop_pt  INTEGER, 
species  VARCHAR(25)  
) 

repeat_family_info ( 
family  VARCHAR(50)  
)  

repeat_class_info ( 
class   VARCHAR(50) 
) 

genes ( 
id 		INTEGER, 
symbol  	VARCHAR(50), 
official	VARCHAR(1), 
description	VARCHAR(200), 
type_of_gene	VARCHAR(55), 
chrom		VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt		INTEGER, 
orientation 	CHAR(1), 
cds_start 	INTEGER, 
cds_stop 	INTEGER, 
function_summary VARCHAR(500), 
source		VARCHAR(10), 
num_of_exons	SMALLINT, 
evidence	VARCHAR(2) 
) 

gene_dbIDs ( 
id      INTEGER , 
db	VARCHAR(50) , 
dbID	VARCHAR(50)  
) 

exons ( 
name	VARCHAR(20), 
chrom	VARCHAR(10), 
start_pt INTEGER, 
stop_pt INTEGER, 
gene_id	INTEGER,
orientation CHAR(1) 
) 

conserved_regions ( 
local_id INTEGER, 
chrom    VARCHAR(10) , 
start_pt INTEGER , 
stop_pt  INTEGER ,
species  VARCHAR(50),
min_perc_id SMALLINT, 
ave_percent_identity DECIMAL(5,2), 
num_of_segs SMALLINT 
) 

seq_file ( 
ID		VARCHAR(9) , 
seq_file	VARCHAR(500), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
header		VARCHAR(500) 
) 

local_alignments ( 
chrom		VARCHAR(10), 
start_pt	INTEGER, 
stop_pt 	INTEGER, 
score 		INTEGER, 
ID		INTEGER, 
orientation 	VARCHAR(30), 
species 	VARCHAR(50), 
start2		INTEGER, 
stop2		INTEGER, 
other_seq   	VARCHAR(9) 
)  

gap_free_align ( 
local_id 	INTEGER, 
chrom  		VARCHAR(10), 
start_pt 	INTEGER, 
stop_pt 	INTEGER, 
percent_identity SMALLINT, 
orientation 	VARCHAR(30), 
species 	VARCHAR(50), 
chrom2          VARCHAR(25),
start2  	INTEGER, 
stop2   	INTEGER, 
len  		GENERATED ALWAYS AS (stop_pt - start_pt + 1), 
pct_bin 	GENERATED ALWAYS AS (INTEGER(percent_identity / 10)) 
)  

gene_alias ( 
gene_id INTEGER, 
name	VARCHAR(100), 
source  VARCHAR(50), 
) 

gene_cdd ( 
   gene_id	INTEGER, 
   name		VARCHAR(300), 
   domain_acc	VARCHAR(50), 
) 

gene_model_prots ( 
   gene_id      INTEGER, 
   protein	VARCHAR(50), 
   acc_no	VARCHAR(50) 
) 

gene_product ( 
   gene_id	INTEGER, 
   name		VARCHAR(200) 
) 

gene_ontology ( 
   gene_id	INTEGER, 
   category	VARCHAR(100), 
   term		VARCHAR(250), 
   evidence_code VARCHAR(20), 
   source	VARCHAR(50), 
   goID		VARCHAR(50) 
) 

go_defs_info ( 
term		VARCHAR(200), 
goID		VARCHAR(20), 
definition	VARCHAR(2000), 
comments	VARCHAR(1000) 
) 

evid_code_info ( 
   code		VARCHAR(10), 
   description	VARCHAR(200) 
) 

snps ( 
   snp_id	INTEGER , 
   dbsource	VARCHAR(10) , 
   chrom	VARCHAR(10), 
   start_pt	INTEGER, 
   stop_pt	INTEGER, 
) 

snp_allele ( 
   snp_id	INTEGER, 
   allele	VARCHAR(700), 
   freq		DECIMAL(20,19), 
   type_of	VARCHAR(50), 
) 

repeats ( 
  name		VARCHAR(50), 
  class		VARCHAR(50), 
  family	VARCHAR(50), 
  strand	CHAR(1), 
  chrom		VARCHAR(10) , 
  start_pt	INTEGER , 
  stop_pt	INTEGER , 
  milliDiv	SMALLINT, 
  lineage	VARCHAR(30), 
) 

gene_expr ( 
  gene_id	INTEGER , 
  tissue	VARCHAR(75), 
  dbsource	VARCHAR(50) 
) 

tfbinding_sites ( 
chrom           VARCHAR(10) , 
start_pt        INTEGER , 
stop_pt         INTEGER , 
strand          CHAR(1), 
score           DECIMAL(3,2), 
id              VARCHAR(20) 
)
  
recomb_rate ( 
chrom 	        VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
name		VARCHAR(20), 
recomb_rate	INTEGER, 
recomb_rateF	INTEGER, 
recomb_rateM	INTEGER, 
source		VARCHAR(20) 
) 

CpGislands (  
chrom		VARCHAR(10), 
start_pt	INTEGER, 
stop_pt		INTEGER, 
name		VARCHAR(50), 
) 

other_genes ( 
name		VARCHAR(255), 
chrom		VARCHAR(10), 
strand		CHAR(1), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
cds_start	INTEGER, 
cds_stop	INTEGER, 
exon_cnt	SMALLINT, 
id		INTEGER, 
track_name	VARCHAR(50) 
) 

other_exons ( 
name		SMALLINT, 
chrom           VARCHAR(10), 
strand		CHAR(1), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
gene_id		INTEGER 
) 

genename_search ( 
gene_id		INTEGER, 
names		VARCHAR(4000) 
) 

lscores ( 
chrom           VARCHAR(10) , 
start_pt        INTEGER , 
stop_pt         INTEGER , 
score           DECIMAL(4,3), 
dim_bins	GENERATED ALWAYS AS (INTEGER(score)) 
) 
  
regulatory_potential ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
score           DECIMAL(4,3), 
dim_bins        GENERATED ALWAYS AS (INTEGER(score)) 
)  
  
gc_percent ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
score           DECIMAL(4,1) 
) 

predicted_promoters ( 
chrom 		VARCHAR(10),  
start_pt        INTEGER, 
stop_pt         INTEGER, 
name		VARCHAR(15), 
score		SMALLINT, 
strand		CHAR(1) 
) 

expressionTissue_info ( 
TissueName    VARCHAR(25) 
) 

expressionData ( 
GENEID         INTEGER, 
AFFY           VARCHAR(35), 
digits         DECIMAL(10,1), 
gall_bladder     DECIMAL(10,1), 
testis         DECIMAL(10,1), 
thymus         DECIMAL(10,1), 
trachea        DECIMAL(10,1), 
hippocampus    DECIMAL(10,1), 
kidney         DECIMAL(10,1), 
large_intestine  DECIMAL(10,1), 
liver          DECIMAL(10,1), 
lung           DECIMAL(10,1), 
adipose_tissue   DECIMAL(10,1), 
lymph_node     DECIMAL(10,1), 
ovary          DECIMAL(10,1), 
prostate       DECIMAL(10,1), 
eye            DECIMAL(10,1), 
salivary_gland   DECIMAL(10,1), 
skeletal_muscle  DECIMAL(10,1), 
adrenal_gland  DECIMAL(10,1), 
snout_epidermis  DECIMAL(10,1), 
spleen         DECIMAL(10,1),
thyroid        DECIMAL(10,1), 
tongue         DECIMAL(10,1), 
trigeminal     DECIMAL(10,1), 
uterus         DECIMAL(10,1), 
bladder        DECIMAL(10,1), 
small_intestine  DECIMAL(10,1), 
stomach        DECIMAL(10,1), 
hypothalamus   DECIMAL(10,1), 
heart          DECIMAL(10,1), 
epidermis      DECIMAL(10,1), 
spinal_cord_lower  DECIMAL(10,1), 
spinal_cord_upper  DECIMAL(10,1), 
bone           DECIMAL(10,1), 
brown_fat      DECIMAL(10,1),
amygdala       DECIMAL(10,1), 
striatum       DECIMAL(10,1),
olfactory_bulb DECIMAL(10,1), 
DRG            DECIMAL(10,1), 
placenta       DECIMAL(10,1), 
mammary_gland  DECIMAL(10,1), 
umbilical_cord DECIMAL(10,1), 
bone_marrow    DECIMAL(10,1), 
cerebellum     DECIMAL(10,1), 
cortex         DECIMAL(10,1), 
frontal_cortex   DECIMAL(10,1) 
) 

gene_strain ( 
gene_id      INTEGER, 
strain      VARCHAR(150), 
SID    INTEGER, 
type   VARCHAR(30) 
) 

regulatory_regions ( 
chrom           VARCHAR(10), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
name            VARCHAR(25) 
)  

conserved_binding_sites ( 
chrom           VARCHAR(10) , 
start_pt        INTEGER , 
stop_pt         INTEGER , 
strand          VARCHAR(5), 
score           DECIMAL(3,2), 
id              VARCHAR(20) 
)
 
enzyme_info (
enzyme  VARCHAR(25),
pattern VARCHAR(25)
)

restriction_sites (
chrom           VARCHAR(10) ,
start_pt        INTEGER ,
stop_pt         INTEGER ,
enzyme          VARCHAR(25) 
)

multiple_aligns (
chrom           VARCHAR(25),
start_pt        INTEGER,
stop_pt         INTEGER,
strand          VARCHAR(1),
align_id        INTEGER,
local_id        INTEGER,
species_build   VARCHAR(10),
align_builds    VARCHAR(50),
score           DECIMAL(12,5),
score_bin       INTEGER,
)
 
mult_align_segments ( 
chrom           VARCHAR(25), 
start_pt        INTEGER, 
stop_pt         INTEGER, 
gap_size        SMALLINT, 
local_id        INTEGER  
) 
                                                                                
parallel_aligns (
chrom           VARCHAR(10),
start_pt        INTEGER,
stop_pt         INTEGER,
align           VARCHAR(20),
repeat          VARCHAR(20)
)

regulatory_potential_mult (
chrom           VARCHAR(10),
start_pt        INTEGER,
stop_pt         INTEGER,
score           DECIMAL(25, 24),
score_bin       INTEGER GENERATED ALWAYS AS (INTEGER(score * 1000))
)

snp_type_info ( 
type_of   VARCHAR(50) 
) 

tfbind_info ( 
factor   VARCHAR(25), 
id  VARCHAR(20) 
) 

REPEAT_LINEAGE_INFO ( 
LINEAGE   VARCHAR(30) 
)