TATK E3: TIGR4 Testing Report - Revision history

Ajvree: /* Visual Inspection */

2013-11-21T18:54:15Z

‎Visual Inspection

2013-11-21T18:53:52Z

‎Visual Inspection: table analysis

2013-11-21T18:39:25Z

‎Visual Inspection

2013-11-21T18:35:48Z

‎Visual Inspection: systems table image

2013-11-21T18:29:00Z

‎OriginalRowCounts Comparison: note about ORC's

2013-11-21T18:26:40Z

‎OriginalRowCounts Comparison

2013-11-21T18:19:45Z

match, sql results

2013-11-21T18:15:45Z

‎TallyEngine: results for E3 count

2013-11-21T17:28:47Z

‎Export Information

2013-11-21T06:37:17Z

‎Export Information

@@ Line 84: / Line 84: @@
 '''RefSeq Table'''
 *all ID's in form NP_######
 [[User:Ajvree|Ajvree]] ([[User talk:Ajvree|talk]]) 10:39, 21 November 2013 (PST)

@@ Line 72: / Line 72: @@
 Perform visual inspection of individual tables to see if there are any problems.
 [[Image:20131121 E3Systemstable tATK TIGR4 AJV.PNG]]
 [[User:Ajvree|Ajvree]] ([[User talk:Ajvree|talk]]) 10:39, 21 November 2013 (PST)

← Older revision		Revision as of 18:39, 21 November 2013
Line 73:		Line 73:

	[[Image:20131121 E3Systemstable tATK TIGR4 AJV.PNG]]		[[Image:20131121 E3Systemstable tATK TIGR4 AJV.PNG]]
		+
		+	[[User:Ajvree\|Ajvree]] ([[User talk:Ajvree\|talk]]) 10:39, 21 November 2013 (PST)

	* Look at the Systems table. Is there a date in the Date field for all gene ID systems present in the database?		* Look at the Systems table. Is there a date in the Date field for all gene ID systems present in the database?

← Older revision		Revision as of 18:35, 21 November 2013
Line 71:		Line 71:

	Perform visual inspection of individual tables to see if there are any problems.		Perform visual inspection of individual tables to see if there are any problems.
		+
		+	[[Image:20131121 E3Systemstable tATK TIGR4 AJV.PNG]]

	* Look at the Systems table. Is there a date in the Date field for all gene ID systems present in the database?		* Look at the Systems table. Is there a date in the Date field for all gene ID systems present in the database?

@@ Line 54: / Line 54: @@
 E3 TIGR4: [[Image:20131121 E3rowcounts tATK TIGR4 AJV.PNG]]
 Benchmark:[[Image:20131121 benchmarkrowcounts tATK TIGR4 AJV.PNG]]
 [[User:Ajvree|Ajvree]] ([[User talk:Ajvree|talk]]) 10:26, 21 November 2013 (PST)

← Older revision		Revision as of 18:26, 21 November 2013
Line 52:		Line 52:

	==OriginalRowCounts Comparison==		==OriginalRowCounts Comparison==
		+	E3 TIGR4: [[Image:20131121 E3rowcounts tATK TIGR4 AJV.PNG]]
		+	Benchmark:[[Image:20131121 benchmarkrowcounts tATK TIGR4 AJV.PNG]]
		+
		+	[[User:Ajvree\|Ajvree]] ([[User talk:Ajvree\|talk]]) 10:26, 21 November 2013 (PST)
		+

	Within the .gdb file, look at the OriginalRowCounts table to see if the database has the expected tables with the expected number of records. Compare the tables and records with a benchmark .gdb file.		Within the .gdb file, look at the OriginalRowCounts table to see if the database has the expected tables with the expected number of records. Compare the tables and records with a benchmark .gdb file.

@@ Line 35: / Line 35: @@
 *screenshot: [[Image:20131121 TallyEngineE3 tATK TIGR4 AJV.PNG]]
+[[User:Ajvree|Ajvree]] ([[User talk:Ajvree|talk]]) 10:19, 21 November 2013 (PST)
 Run the TallyEngine in GenMAPP Builder and record the number of records for UniProt and GO in the XML data and in the PostgreSQL databases (or you can upload and link to a screenshot of the results).
 == Using XMLPipeDB match to Validate the XML Results from the TallyEngine==
 [[How_Do_I_Count_Thee%3F_Let_Me_Count_The_Ways#XMLPipeDB_Match | Follow the instructions found on this page to run XMLPipeDB match.]]
@@ Line 45: / Line 47: @@
 == Using SQL Queries to Validate the PostgreSQL Database Results from the TallyEngine==
 [[How_Do_I_Count_Thee%3F_Let_Me_Count_The_Ways#SQL | Follow the instructions on this page to query the PostgreSQL Database.]]

← Older revision		Revision as of 18:15, 21 November 2013
Line 30:		Line 30:
	==TallyEngine==		==TallyEngine==

		+	*Results for TallyEngine using new version gmbuilder72
		+	*Gene Id's now visible, total count 2105
		+	*Orderedlocusname count was consistent with previous count totals (2126)
		+	*screenshot: [[Image:20131121 TallyEngineE3 tATK TIGR4 AJV.PNG]]
		+
		+
	Run the TallyEngine in GenMAPP Builder and record the number of records for UniProt and GO in the XML data and in the PostgreSQL databases (or you can upload and link to a screenshot of the results).		Run the TallyEngine in GenMAPP Builder and record the number of records for UniProt and GO in the XML data and in the PostgreSQL databases (or you can upload and link to a screenshot of the results).

@@ Line 27: / Line 27: @@
 Note: There were no updates to XML or goa files since last IE cycle
 ==Template==
 {{Team ATK}}

← Older revision		Revision as of 06:37, 21 November 2013
Line 27:		Line 27:

	Note: There were no updates to XML or goa files since last IE cycle		Note: There were no updates to XML or goa files since last IE cycle
		+
		+	==Template==
		+	{{Team ATK}}