e0519e4a659be65e8f39fd4f52a542a8c6f1f415 fanhsu Thu Nov 17 07:47:58 2011 -0800 Added cosmic_mutation_id as an index key. diff --git src/hg/lib/cosmicRaw.sql src/hg/lib/cosmicRaw.sql new file mode 100644 index 0000000..e17d787 --- /dev/null +++ src/hg/lib/cosmicRaw.sql @@ -0,0 +1,20 @@ +CREATE TABLE cosmicRaw ( +source varchar(255), +cosmic_mutation_id varchar(255), +gene_name varchar(255), +accession_number varchar(255), +mut_description varchar(255), +mut_syntax_cds blob, +mut_syntax_aa varchar(255), +chromosome varchar(255), +grch37_start varchar(255), +grch37_stop varchar(255), +mut_nt blob, +mut_aa blob, +tumour_site varchar(255), +mutated_samples varchar(255), +examined_samples varchar(255), +mut_freq varchar(255), + +key cosmic_mutation_id (cosmic_mutation_id) +);