18 files changed, 112222 insertions, 40 deletions
diff --git a/test/ParaView/proteins_by_year.sql b/test/ParaView/proteins_by_year.sql
new file mode 100644
index 0000000..d4d1499
--- a/dev/null
+++ b/test/ParaView/proteins_by_year.sql
@@ -0,0 +1,19 @@
+-- Extract the protein coordinates with the year of the strain as a
+-- feature for analysis in ParaView.
+EXPORT TO proteins_by_year.csv OF DEL
+SELECT C.x,
+       C.y,
+       0,
+       S.strain_year,
+       C.gi
+FROM influenza_meta M
+JOIN strains_parsed S
+ON   (S.GBSeq_accession_version = M.gbseq_accession_version)
+JOIN coordinates C
+ON   (C.gi = 'gi|' || M.gi)
+WHERE S.strain_year IS NOT NULL
+ORDER BY S.strain_year;
+-- Records with invalid years manually removed from the head and tail
+-- of the exported file.
+\ No newline at end of file

diff --git a/test/ParaView/proteins_by_year.sql b/test/ParaView/proteins_by_year.sql new file mode 100644 index 0000000..d4d1499 --- a/dev/null +++ b/test/ParaView/proteins_by_year.sql
@@ -0,0 +1,19 @@
	1	-- Extract the protein coordinates with the year of the strain as a
	2	-- feature for analysis in ParaView.
	3
	4	EXPORT TO proteins_by_year.csv OF DEL
	5	SELECT C.x,
	6	C.y,
	7	0,
	8	S.strain_year,
	9	C.gi
	10	FROM influenza_meta M
	11	JOIN strains_parsed S
	12	ON (S.GBSeq_accession_version = M.gbseq_accession_version)
	13	JOIN coordinates C
	14	ON (C.gi = 'gi\|' \|\| M.gi)
	15	WHERE S.strain_year IS NOT NULL
	16	ORDER BY S.strain_year;
	17
	18	-- Records with invalid years manually removed from the head and tail
	19	-- of the exported file. \ No newline at end of file