ABGSA: Difference between revisions

From HPCwiki
Jump to navigation Jump to search
Line 37: Line 37:
   PRIMARY KEY (`lane_names_orig`)
   PRIMARY KEY (`lane_names_orig`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
</source>
<source lang='mysql'>
CREATE TABLE `fqfile_attributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lane_names_orig` varchar(120) DEFAULT NULL,
  `md5check` varchar(120) DEFAULT NULL,
  `filesize` bigint(15) DEFAULT NULL,
  `numlines_in_gzip` bigint(15) DEFAULT NULL,
  `qval_offset` varchar(10) DEFAULT NULL,
  `maxlength_seq` int(6) DEFAULT NULL,
  `totnumbases` bigint(15) DEFAULT NULL,
  `totnumreads` int(12) DEFAULT NULL,
  `firstreadname` varchar(120) DEFAULT NULL,
  `lastreadname` varchar(120) DEFAULT NULL,
  `ts_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1
</source>
<source lang='mysql'>
CREATE TABLE `gc_cont` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lane_names_orig` varchar(120) DEFAULT NULL,
  `gc_cont` float DEFAULT NULL,
  `ts_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1
</source>
<source lang='mysql'>
CREATE TABLE `filesize` (
  `lane_names_orig` varchar(120) DEFAULT NULL,
  `filesize` bigint(15) DEFAULT NULL,
  `md5check` varchar(35) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
</source>
</source>



Revision as of 11:16, 30 November 2013

Rationale of the ABGSA

Description of the layout

Metadata database

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

<source lang='mysql'> 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 | </source>

<source lang='mysql'> CREATE TABLE `fqfile_attributes` (

 `id` int(11) NOT NULL AUTO_INCREMENT,
 `lane_names_orig` varchar(120) DEFAULT NULL,
 `md5check` varchar(120) DEFAULT NULL,
 `filesize` bigint(15) DEFAULT NULL,
 `numlines_in_gzip` bigint(15) DEFAULT NULL,
 `qval_offset` varchar(10) DEFAULT NULL,
 `maxlength_seq` int(6) DEFAULT NULL,
 `totnumbases` bigint(15) DEFAULT NULL,
 `totnumreads` int(12) DEFAULT NULL,
 `firstreadname` varchar(120) DEFAULT NULL,
 `lastreadname` varchar(120) DEFAULT NULL,
 `ts_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1 </source>

<source lang='mysql'>

CREATE TABLE `gc_cont` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `lane_names_orig` varchar(120) DEFAULT NULL,
 `gc_cont` float DEFAULT NULL,
 `ts_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1 </source>

<source lang='mysql'> CREATE TABLE `filesize` (

 `lane_names_orig` varchar(120) DEFAULT NULL,
 `filesize` bigint(15) DEFAULT NULL,
 `md5check` varchar(35) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 </source>

Checking data integrity

Backing up

See also

External links