ABGSA - Revision history

Hjmegens: /* Metadata database */

2013-11-30T10:31:47Z

Metadata database

← Older revision		Revision as of 12:31, 30 November 2013
Line 14:		Line 14:
	\| gc_cont \|		\| gc_cont \|
	+-----------------------+		+-----------------------+

			The most recent mysqldump file can be found at the root of the archive directory tree.

	=== TABLE: ABGSAschema_main ===		=== TABLE: ABGSAschema_main ===

Hjmegens at 09:49, 30 November 2013

2013-11-30T09:49:48Z

← Older revision		Revision as of 11:49, 30 November 2013
Line 137:		Line 137:
	) ENGINE=MyISAM DEFAULT CHARSET=latin1		) ENGINE=MyISAM DEFAULT CHARSET=latin1
	</source>		</source>

			== Creating the metadata and insert in database ==

			=== Main metadata ===
			https://github.com/hjmegens/NGStools/blob/master/various_scripts/ABGSAschema/get_test_attributes.py

			=== GC content ===
			https://github.com/hjmegens/NGStools/blob/master/various_scripts/ABGSAschema/get_gccont.py

	== Checking data integrity ==		== Checking data integrity ==

Hjmegens: /* Checking data integrity */

2013-11-30T09:45:21Z

Checking data integrity

← Older revision		Revision as of 11:45, 30 November 2013
Line 139:		Line 139:

	== Checking data integrity ==		== Checking data integrity ==

			https://github.com/hjmegens/NGStools/blob/master/various_scripts/ABGSAschema/ABGSA_integrity_extdrives.pl

	== Backing up ==		== Backing up ==

Hjmegens: /* Metadata database */

2013-11-30T09:44:29Z

Metadata database

← Older revision		Revision as of 11:44, 30 November 2013
Line 4:		Line 4:

	== Metadata database ==		== Metadata database ==
			Metadatabase name is ABGSAschema

	+-----------------------+		+-----------------------+

Hjmegens: /* Metadata database */

2013-11-30T09:43:55Z

Metadata database

← Older revision		Revision as of 11:43, 30 November 2013
Line 14:		Line 14:
	+-----------------------+		+-----------------------+

	=== TABLE: ABGSAschema_main ===		=== TABLE: ABGSAschema_main ===

	+-------------------------+--------------+------+-----+---------+-------+		+-------------------------+--------------+------+-----+---------+-------+
	\| Field \| Type \| Null \| Key \| Default \| Extra \|		\| Field \| Type \| Null \| Key \| Default \| Extra \|

Hjmegens: /* Metadata database */

2013-11-30T09:43:30Z

Metadata database

← Older revision		Revision as of 11:43, 30 November 2013
Line 14:		Line 14:
	+-----------------------+		+-----------------------+

			=== TABLE: ABGSAschema_main ===
	+-------------------------+--------------+------+-----+---------+-------+		+-------------------------+--------------+------+-----+---------+-------+
	\| Field \| Type \| Null \| Key \| Default \| Extra \|		\| Field \| Type \| Null \| Key \| Default \| Extra \|
Line 62:		Line 63:
	) ENGINE=InnoDB DEFAULT CHARSET=latin1 \|		) ENGINE=InnoDB DEFAULT CHARSET=latin1 \|
	</source>		</source>
			=== TABLE: fqfile_attributes ===
	+------------------+--------------+------+-----+-------------------+----------------+		+------------------+--------------+------+-----+-------------------+----------------+
	\| Field \| Type \| Null \| Key \| Default \| Extra \|		\| Field \| Type \| Null \| Key \| Default \| Extra \|
Line 98:		Line 99:
	</source>		</source>

			=== TABLE: gc_cont ===
	+-----------------+--------------+------+-----+-------------------+----------------+		+-----------------+--------------+------+-----+-------------------+----------------+
	\| Field \| Type \| Null \| Key \| Default \| Extra \|		\| Field \| Type \| Null \| Key \| Default \| Extra \|
Line 106:		Line 108:
	\| ts_create \| timestamp \| NO \| \| CURRENT_TIMESTAMP \| \|		\| ts_create \| timestamp \| NO \| \| CURRENT_TIMESTAMP \| \|
	+-----------------+--------------+------+-----+-------------------+----------------+		+-----------------+--------------+------+-----+-------------------+----------------+


	<source lang='mysql'>		<source lang='mysql'>
Line 117:		Line 118:
	) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1		) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1
	</source>		</source>
			=== TABLE: filesize ===
			This table is currently redundant with information in TABLE: fqfile_attributes. Slated to be removed from the database altogether to avoid confusion in future additions to the database. In addition, current table is not up to date for all entries.

	+-----------------+--------------+------+-----+---------+-------+		+-----------------+--------------+------+-----+---------+-------+

Hjmegens: /* Metadata database */

2013-11-30T09:20:35Z

Metadata database

@@ Line 13: / Line 13: @@
    | gc_cont               |
    +-----------------------+
 <source lang='mysql'>
@@ Line 38: / Line 62: @@
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
 </source>
 <source lang='mysql'>

Hjmegens: /* Metadata database */

2013-11-30T09:18:16Z

Metadata database

@@ Line 56: / Line 56: @@
 ) ENGINE=InnoDB AUTO_INCREMENT=1561 DEFAULT CHARSET=latin1
 </source>
 <source lang='mysql'>
@@ Line 67: / Line 77: @@
 </source>
 <source lang='mysql'>
 CREATE TABLE `filesize` (

Hjmegens: /* Metadata database */

2013-11-30T09:16:46Z

Metadata database

@@ Line 37: / Line 37: @@
    PRIMARY KEY (`lane_names_orig`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
 </source>

Hjmegens: /* Metadata database */

2013-11-30T09:13:07Z

Metadata database

← Older revision		Revision as of 11:13, 30 November 2013
Line 4:		Line 4:

	== Metadata database ==		== Metadata database ==

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

	<source lang='mysql'>		<source lang='mysql'>