use TROMBONE;
CREATE TABLE bont_tent_mutagenesis(
	neurotoxin VARCHAR(10) NOT NULL,
	pdb VARCHAR(10) NOT NULL,
	wt VARCHAR(3) NOT NULL,
	pos INT NOT NULL,
	mt VARCHAR(3) NOT NULL,
	gbs_dist FLOAT NOT NULL,
	wt_sst VARCHAR(50) NOT NULL,
	mt_sst VARCHAR(50) NOT NULL,
	wt_psa FLOAT NOT NULL,
	mt_psa FLOAT NOT NULL,
	mcsm_pred FLOAT NOT NULL,
	avg_mcsm_pred FLOAT NOT NULL,
	sdm_pred FLOAT NOT NULL,
	avg_sdm_pred FLOAT NOT NULL,

	PRIMARY KEY ( neurotoxin, wt, pos, mt )
	);


load data local infile 'results_table.tsv' into table bont_tent_mutagenesis fields terminated by '\t';
