# Create general scer_nlaiii_bsmfi_5 table
DROP TABLE IF EXISTS scer_nlaiii_bsmfi_5;
CREATE TABLE scer_nlaiii_bsmfi_5
(
	an_num		INT UNSIGNED NOT NULL,
	se_num		INT UNSIGNED NOT NULL,
	seqtag		VARCHAR(14) NOT NULL,
	oc_num		INT UNSIGNED NOT NULL,
	freq		INT UNSIGNED NOT NULL,
	class		VARCHAR(1) NOT NULL,
	tclass		VARCHAR(2) NOT NULL,
	sco_cl		FLOAT(4) NOT NULL,
	sco_co		FLOAT(4) NOT NULL,
	tconf		VARCHAR(2) NOT NULL,
	chr_t		INT UNSIGNED NOT NULL,
	ini_t		INT UNSIGNED NOT NULL,
	end_t		INT UNSIGNED NOT NULL,
	stra		ENUM('+','-') NOT NULL,
	chr_o		VARCHAR(10) NOT NULL,
	ini_o		INT UNSIGNED NOT NULL,
	end_o		INT UNSIGNED NOT NULL,
	len_o		INT UNSIGNED NOT NULL,
	i_corf		INT UNSIGNED NOT NULL,
	e_corf		INT UNSIGNED NOT NULL,
	len_co		INT UNSIGNED NOT NULL,
	conta		ENUM('Y','N') NOT NULL,
	intron		ENUM('Y','N') NOT NULL,
	gtype		INT UNSIGNED NOT NULL,
	tagpos		INT UNSIGNED NOT NULL,
	dist3u		INT UNSIGNED NOT NULL,
	polyA		ENUM('Y','N') NOT NULL,
	dispol		INT UNSIGNED NOT NULL,
	lenpol		INT UNSIGNED NOT NULL,
	stname		VARCHAR(10) NOT NULL,
	f_type		VARCHAR(10) NOT NULL,
	f_name		VARCHAR(20) NOT NULL,
	syname		VARCHAR(15) NOT NULL,
	tloc		VARCHAR(5) NOT NULL,
	pred		ENUM('P','N') NOT NULL,
	descr		LONGTEXT NOT NULL
);
LOAD DATA local infile "/disk2/www/sup-mat/HGA-yeast/1/full_table.txt" into table scer_nlaiii_bsmfi_5;