1 2 3 4 5 6 7 8 9
| CREATE TABLE `test`.`fungi2_consensus` (
`id` smallint( 5 ) unsigned NOT NULL default '0',
`linking_consensus` enum( 'Aspergillus fumigatus', 'Alternaria alternata', 'Davidiella tassiana' ) default NULL ,
`organism` varchar( 60 ) NOT NULL default '',
`score` decimal( 5, 2 ) NOT NULL default '0.00',
`blast_length` smallint( 5 ) unsigned NOT NULL default '0',
`cover` decimal( 5, 2 ) NOT NULL default '0.00',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COMMENT = 'Les espèces les plus proches (BLAST) du consensus de A_alte' |
Partager