ABGSA

Metadata database

 +-----------------------+
 | Tables_in_ABGSAschema |
 +-----------------------+
 | ABGSAschema_main      |
 | filesize              |
 | fqfile_attributes     |
 | gc_cont               |
 +-----------------------+

CREATE TABLE `ABGSAschema_main` (
  `archive_name` varchar(9) DEFAULT NULL,
  `lane_names_orig` varchar(120) NOT NULL DEFAULT '',
  `readno` varchar(6) DEFAULT NULL,
  `ABG_individual_id` varchar(40) DEFAULT NULL,
  `PORHAPNUMBER` varchar(40) DEFAULT NULL,
  `HapMap60Kcheck` varchar(45) DEFAULT NULL,
  `perc_ident` float DEFAULT NULL,
  `indiv_pop_generic_name` varchar(60) DEFAULT NULL,
  `library_type` varchar(40) DEFAULT NULL,
  `md5sum_gzip` varchar(35) DEFAULT NULL,
  `md5sum_txt` varchar(35) DEFAULT NULL,
  `seq_format` varchar(8) DEFAULT NULL,
  `qscore_format` varchar(16) DEFAULT NULL,
  `generated_by` varchar(30) DEFAULT NULL,
  `Machine_type` varchar(30) DEFAULT NULL,
  `date_generated` varchar(12) DEFAULT NULL,
  `Lane_in_run` varchar(4) DEFAULT NULL,
  `lib_previously_known_as` varchar(30) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`lane_names_orig`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |