GEO Sample description

geosampledescirption.sql

CREATE TABLE gsm
( ID REAL,
	title TEXT,
	gsm TEXT,
	series_id TEXT,
	gpl TEXT,
	status TEXT,
	submission_date TEXT,
	last_update_date TEXT,
	type TEXT,
	source_name_ch1 TEXT,
	organism_ch1 TEXT,
	characteristics_ch1 TEXT,
	molecule_ch1 TEXT,
	label_ch1 TEXT,
	treatment_protocol_ch1 TEXT,
	extract_protocol_ch1 TEXT,
	label_protocol_ch1 TEXT,
	source_name_ch2 TEXT,
	organism_ch2 TEXT,
	characteristics_ch2 TEXT,
	molecule_ch2 TEXT,
	label_ch2 TEXT,
	treatment_protocol_ch2 TEXT,
	extract_protocol_ch2 TEXT,
	label_protocol_ch2 TEXT,
	hyb_protocol TEXT,
	description TEXT,
	data_processing TEXT,
	contact TEXT,
	supplementary_file TEXT,
	data_row_count REAL,
	channel_count REAL
);