metadata: viruses_fish_associated_curated: 37 rows where Category = "Novel" and clusterLCA

37 rows where Category = "Novel" and clusterLCA_curated = "Zebrafish rhabdo-like virus"

descending

Link	rowid ▼	contig_withLCA_withcluster	clusterLCA_curated	Category	contig_withLCA	shortcontigname	clusterLCA	clusterLCAcurated_contigcount	clusterLCAcurated_bioprojectcount	clusterLCAcurated_clustercount	shortclustername	cluster	clustersize	bioprojectsbycluster	bioproject	node	length	coverage	rel_abundance	taxname_lca_NTorNR	taxid_lca_NTorNR	taxoncategory_NTorNR	taxoncategorysimple_NTorNR	bits_NTorNR	evalue_NTorNR	viruscategory_NTorNR	viruscategorysimple_NTorNR	analysis_used	contig_name	target_title_NTorNR	target_NTorNR	taxid_NTorNR	gene_NTorNR	allele_NTorNR	pident_NTorNR	sumperc_cov_NTorNR	alnlen_NTorNR	mismatch_NTorNR	qcov_NTorNR	gapopen_NTorNR	qstart_NTorNR	qend_NTorNR	tstart_NTorNR	tend_NTorNR	sumalnlen_NTorNR	maxbits_NTorNR	bits_percmax_NTorNR	tax_superkingdom_NTorNR	tax_species_NTorNR	classification	taxname_lca_NR	taxoncategory_NR	taxoncategorysimple_NR	bits_NR	evalue_NR
9798	9798	PRJNA830699_CONTIG_25\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_25\|Salmovirus_WFRC1	PRJNA830699_CONTIG_25	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	25	1799	7.716949	138.8279125	Salmovirus WFRC1	1981916	Viruses	Viruses	478.0	6.62e-156	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_25_length_1799_cov_7.716949_g14_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i0	53.2	0.773763202	464	199	76.9	5	1384	2	96	544	1392	478.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	478.0	6.62e-156
9799	9799	PRJNA830699_CONTIG_27\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_27\|Salmovirus_WFRC1	PRJNA830699_CONTIG_27	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	27	1767	7.802647	137.8727725	Salmovirus WFRC1	1981916	Viruses	Viruses	513.0	1.05e-169	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_27_length_1767_cov_7.802647_g14_i1	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i1	49.8	0.950764007	560	233	89.8	8	180	1766	2	544	1680	513.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	513.0	1.05e-169
9800	9800	PRJNA906165_CONTIG_39\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA906165_CONTIG_39\|Salmovirus_WFRC1	PRJNA906165_CONTIG_39	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA906165	39	2481	3.908223	96.96301263	Salmovirus WFRC1	1981916	Viruses	Viruses	384.0	8.73e-117	Salmovirus WFRC1	Non-phage	NR	PRJNA906165_P_NODE_39_length_2481_cov_3.908223_g26_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g26	i0	54.6	0.418379686	346	152	41.5	2	1452	2480	2	345	1038	384.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	384.0	8.73e-117
9801	9801	PRJEB2368_CONTIG_55\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJEB2368_CONTIG_55\|Salmovirus_WFRC1	PRJEB2368_CONTIG_55	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJEB2368	55	2750	4.192407	115.2911925	Salmovirus WFRC1	1981916	Viruses	Viruses	360.0	7.9e-107	Salmovirus WFRC1	Non-phage	NR	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g36	i0	57.1	0.343636364	315	130	34.0	2	1063	128	103	415	945	360.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	360.0	7.9e-107
9802	9802	PRJNA830699_CONTIG_63\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_63\|Salmovirus_WFRC1	PRJNA830699_CONTIG_63	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	63	1444	8.031802	115.9792209	Salmovirus WFRC1	1981916	Viruses	Viruses	503.0	9.34e-168	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_63_length_1444_cov_8.031802_g14_i2	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i2	53.1	1.005540166	484	209	99.9	5	1	1443	76	544	1452	503.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	503.0	9.34e-168
9803	9803	PRJNA830699_CONTIG_69\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_69\|Salmovirus_WFRC1	PRJNA830699_CONTIG_69	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	69	1396	8.231895	114.9172542	Salmovirus WFRC1	1981916	Viruses	Viruses	491.0	3.35e-163	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_69_length_1396_cov_8.231895_g14_i3	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i3	53.4	1.005730659	468	200	99.9	5	1	1395	92	544	1404	491.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	491.0	3.35e-163
9804	9804	PRJNA830699_CONTIG_252\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_252\|Salmovirus_WFRC1	PRJNA830699_CONTIG_252	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	252	918	8.984252	82.47543336	Salmovirus WFRC1	1981916	Viruses	Viruses	246.0	1.31e-71	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_252_length_918_cov_8.984252_g14_i4	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i4	48.4	0.905228758	277	128	90.5	4	917	87	284	545	831	246.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	246.0	1.31e-71
9805	9805	PRJNA830699_CONTIG_268\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_268\|Salmovirus_WFRC1	PRJNA830699_CONTIG_268	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	268	890	8.824623	78.5391447	Salmovirus WFRC1	1981916	Viruses	Viruses	247.0	4.92e-72	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_268_length_890_cov_8.824623_g14_i5	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g14	i5	48.6	0.930337079	276	127	93.0	4	889	62	284	544	828	247.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	247.0	4.92e-72
9806	9806	PRJNA830699_CONTIG_307\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_307\|Salmovirus_WFRC1	PRJNA830699_CONTIG_307	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	307	844	7.766871	65.55239124	Salmovirus WFRC1	1981916	Viruses	Viruses	152.0	1.22e-38	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_307_length_844_cov_7.766871_g142_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g142	i0	42.5	0.753554502	212	109	73.9	5	626	3	224	426	636	152.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	152.0	1.22e-38
9807	9807	PRJNA830699_CONTIG_467\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_467\|Salmovirus_WFRC1	PRJNA830699_CONTIG_467	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA830699	467	706	10.509601	74.19778306	Salmovirus WFRC1	1981916	Viruses	Viruses	94.7	2.74e-18	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_467_length_706_cov_10.509601_g223_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g223	i0	42.2	0.492917847	116	67	49.3	0	507	160	13	128	348	94.7	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	94.7	2.74e-18
9808	9808	PRJNA851939_CONTIG_787\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA851939_CONTIG_787\|Salmovirus_WFRC1	PRJNA851939_CONTIG_787	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA851939	787	442	1.533875	6.7797275	Salmovirus WFRC1	1981916	Viruses	Viruses	193.0	2.67e-54	Salmovirus WFRC1	Non-phage	NR	PRJNA851939_P_NODE_787_length_442_cov_1.533875_g735_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g735	i0	60.0	0.984162896	145	58	98.4	0	441	7	88	232	435	193.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	193.0	2.67e-54
9809	9809	PRJNA851939_CONTIG_1253\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA851939_CONTIG_1253\|Salmovirus_WFRC1	PRJNA851939_CONTIG_1253	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA851939	1253	342	1.717472	5.87375424	Salmovirus WFRC1	1981916	Viruses	Viruses	104.0	1.73e-23	Salmovirus WFRC1	Non-phage	NR	PRJNA851939_P_NODE_1253_length_342_cov_1.717472_g1201_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g1201	i0	51.0	0.894736842	102	49	88.6	1	303	1	331	432	306	104.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	104.0	1.73e-23
9810	9810	PRJNA851939_CONTIG_1431\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA851939_CONTIG_1431\|Salmovirus_WFRC1	PRJNA851939_CONTIG_1431	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA851939	1431	322	1.012048	3.25879456	Salmovirus WFRC1	1981916	Viruses	Viruses	75.9	2.25e-13	Salmovirus WFRC1	Non-phage	NR	PRJNA851939_P_NODE_1431_length_322_cov_1.012048_g1379_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g1379	i0	43.6	0.875776398	94	51	87.6	1	40	321	2	93	282	75.9	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	75.9	2.25e-13
9811	9811	PRJNA450343_CONTIG_1661\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_1661\|Salmovirus_WFRC1	PRJNA450343_CONTIG_1661	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	1661	428	2.48285	10.626598	Salmovirus WFRC1	1981916	Viruses	Viruses	133.0	2.24e-33	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_1661_length_428_cov_2.482850_g1593_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g1593	i0	49.3	1.023364486	146	68	99.5	3	2	427	288	431	438	133.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	133.0	2.24e-33
9812	9812	PRJNA450343_CONTIG_2346\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_2346\|Salmovirus_WFRC1	PRJNA450343_CONTIG_2346	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	2346	355	2.660131	9.44346505	Salmovirus WFRC1	1981916	Viruses	Viruses	118.0	4.86e-28	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_2346_length_355_cov_2.660131_g2278_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g2278	i0	50.0	0.997183099	118	59	99.7	0	354	1	288	405	354	118.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	118.0	4.86e-28
9813	9813	PRJNA450343_CONTIG_3220\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_3220\|Salmovirus_WFRC1	PRJNA450343_CONTIG_3220	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	3220	298	3.421687	10.19662726	Salmovirus WFRC1	1981916	Viruses	Viruses	58.9	1.45e-07	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_3220_length_298_cov_3.421687_g3152_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g3152	i0	39.5	0.765100671	76	46	76.5	0	2	229	53	128	228	58.9	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	58.9	1.45e-07
9814	9814	PRJNA450343_CONTIG_6412\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_6412\|Salmovirus_WFRC1	PRJNA450343_CONTIG_6412	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	6412	211	1.432099	3.02172889	Salmovirus WFRC1	1981916	Viruses	Viruses	49.3	0.000122	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_6412_length_211_cov_1.432099_g6344_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g6344	i0	40.6	0.981042654	69	39	98.1	1	210	4	7	73	207	49.3	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	49.3	0.000122
9815	9815	PRJNA450343_CONTIG_9151\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_9151\|Salmovirus_WFRC1	PRJNA450343_CONTIG_9151	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	9151	180	1.938931	3.4900758	Salmovirus WFRC1	1981916	Viruses	Viruses	46.6	0.000688	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_9151_length_180_cov_1.938931_g9083_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g9083	i0	50.0	0.733333333	44	22	73.3	0	39	170	13	56	132	46.6	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	46.6	0.000688
9816	9816	PRJNA450343_CONTIG_9943\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_9943\|Salmovirus_WFRC1	PRJNA450343_CONTIG_9943	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA450343	9943	172	2.073171	3.56585412	Salmovirus WFRC1	1981916	Viruses	Viruses	79.7	1.33e-15	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_9943_length_172_cov_2.073171_g9875_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g9875	i0	57.9	0.994186047	57	24	99.4	0	172	2	144	200	171	79.7	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	79.7	1.33e-15
9817	9817	PRJNA929952_CONTIG_21708\|Salmovirus_WFRC1\|CLUSTER1_Salmovirus_WFRC1\|20\|6	Zebrafish rhabdo-like virus	Novel	PRJNA929952_CONTIG_21708\|Salmovirus_WFRC1	PRJNA929952_CONTIG_21708	Salmovirus WFRC1	37	9	6	CLUSTER1_Salmovirus_WFRC1\|20\|6	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0\|Salmovirus_WFRC1\|NR\|7.9e-107\|NA	20	6	PRJNA929952	21708	185	1.551282	2.8698717	Salmovirus WFRC1	1981916	Viruses	Viruses	84.3	3.67e-17	Salmovirus WFRC1	Non-phage	NR	PRJNA929952_P_NODE_21708_length_185_cov_1.551282_g20414_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g20414	i0	62.3	0.989189189	61	23	98.9	0	183	1	366	426	183	84.3	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	84.3	3.67e-17
10072	10072	PRJNA906165_CONTIG_155\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA906165_CONTIG_155\|Salmovirus_WFRC1	PRJNA906165_CONTIG_155	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA906165	155	1461	3.291066	48.08247426	Salmovirus WFRC1	1981916	Viruses	Viruses	286.0	7.69e-84	Salmovirus WFRC1	Non-phage	NR	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g112	i0	44.7	0.739219713	360	182	71.0	7	1447	410	432	788	1080	286.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	286.0	7.69e-84
10073	10073	PRJNA830699_CONTIG_161\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_161\|Salmovirus_WFRC1	PRJNA830699_CONTIG_161	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	161	1100	5.049486	55.544346	Salmovirus WFRC1	1981916	Viruses	Viruses	119.0	1.97e-25	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_161_length_1100_cov_5.049486_g78_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i0	36.2	0.542727273	199	115	51.8	6	2	571	593	788	597	119.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	119.0	1.97e-25
10074	10074	PRJNA830699_CONTIG_200\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_200\|Salmovirus_WFRC1	PRJNA830699_CONTIG_200	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	200	998	5.296182	52.85589636	Salmovirus WFRC1	1981916	Viruses	Viruses	119.0	9.490000000000001e-26	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_200_length_998_cov_5.296182_g78_i1	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i1	36.2	0.598196393	199	115	57.1	6	2	571	593	788	597	119.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	119.0	9.490000000000001e-26
10075	10075	PRJNA830699_CONTIG_222\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_222\|Salmovirus_WFRC1	PRJNA830699_CONTIG_222	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	222	977	5.489451	53.63193627	Salmovirus WFRC1	1981916	Viruses	Viruses	119.0	8.09e-26	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_222_length_977_cov_5.489451_g78_i2	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i2	36.2	0.611054248	199	115	58.3	6	2	571	593	788	597	119.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	119.0	8.09e-26
10076	10076	PRJNA830699_CONTIG_233\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_233\|Salmovirus_WFRC1	PRJNA830699_CONTIG_233	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	233	950	5.499457	52.2448415	Salmovirus WFRC1	1981916	Viruses	Viruses	125.0	6.900000000000001e-28	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_233_length_950_cov_5.499457_g78_i3	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i3	36.0	0.701052632	222	121	67.3	7	942	304	579	788	666	125.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	125.0	6.900000000000001e-28
10077	10077	PRJNA830699_CONTIG_254\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_254\|Salmovirus_WFRC1	PRJNA830699_CONTIG_254	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	254	915	5.756208	52.6693032	Salmovirus WFRC1	1981916	Viruses	Viruses	119.0	5.02e-26	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_254_length_915_cov_5.756208_g78_i4	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i4	35.5	0.66557377	203	119	63.6	6	31	612	589	788	609	119.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	119.0	5.02e-26
10078	10078	PRJNA830699_CONTIG_258\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA830699_CONTIG_258\|Salmovirus_WFRC1	PRJNA830699_CONTIG_258	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA830699	258	910	5.900114	53.6910374	Salmovirus WFRC1	1981916	Viruses	Viruses	119.0	4.78e-26	Salmovirus WFRC1	Non-phage	NR	PRJNA830699_P_NODE_258_length_910_cov_5.900114_g78_i5	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g78	i5	36.2	0.656043956	199	115	62.6	6	2	571	593	788	597	119.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	119.0	4.78e-26
10079	10079	PRJNA851939_CONTIG_374\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA851939_CONTIG_374\|Salmovirus_WFRC1	PRJNA851939_CONTIG_374	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA851939	374	663	1.344068	8.91117084	Salmovirus WFRC1	1981916	Viruses	Viruses	214.0	9.65e-61	Salmovirus WFRC1	Non-phage	NR	PRJNA851939_P_NODE_374_length_663_cov_1.344068_g322_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g322	i0	56.4	0.914027149	202	84	90.0	2	659	63	462	662	606	214.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	214.0	9.65e-61
10080	10080	PRJNA450343_CONTIG_529\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJNA450343_CONTIG_529\|Salmovirus_WFRC1	PRJNA450343_CONTIG_529	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJNA450343	529	787	1.876694	14.76958178	Salmovirus WFRC1	1981916	Viruses	Viruses	234.0	1.1199999999999999e-67	Salmovirus WFRC1	Non-phage	NR	PRJNA450343_P_NODE_529_length_787_cov_1.876694_g482_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g482	i0	50.6	0.972045743	255	117	94.2	3	15	755	432	685	765	234.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	234.0	1.1199999999999999e-67
10081	10081	PRJEB2368_CONTIG_4010\|Salmovirus_WFRC1\|CLUSTER2_Salmovirus_WFRC1\|10\|5	Zebrafish rhabdo-like virus	Novel	PRJEB2368_CONTIG_4010\|Salmovirus_WFRC1	PRJEB2368_CONTIG_4010	Salmovirus WFRC1	37	9	6	CLUSTER2_Salmovirus_WFRC1\|10\|5	PRJNA906165_P_NODE_155_length_1461_cov_3.291066_g112_i0\|Salmovirus_WFRC1\|NR\|7.69e-84\|NA	10	5	PRJEB2368	4010	396	2.011142	7.96412232	Salmovirus WFRC1	1981916	Viruses	Viruses	103.0	7.729999999999999e-23	Salmovirus WFRC1	Non-phage	NR	PRJEB2368_P_NODE_4010_length_396_cov_2.011142_g3698_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g3698	i0	58.8	0.734848485	97	40	73.5	0	3	293	502	598	291	103.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	103.0	7.729999999999999e-23
10216	10216	PRJNA293022_CONTIG_12374\|Salmovirus_WFRC1\|CLUSTER3_Salmovirus_WFRC1\|3\|3	Zebrafish rhabdo-like virus	Novel	PRJNA293022_CONTIG_12374\|Salmovirus_WFRC1	PRJNA293022_CONTIG_12374	Salmovirus WFRC1	37	9	6	CLUSTER3_Salmovirus_WFRC1\|3\|3	PRJNA293022_P_NODE_12374_length_406_cov_2.389356_g11637_i0\|Salmovirus_WFRC1\|NR\|2.65e-45\|NA	3	3	PRJNA293022	12374	406	2.389356	9.70078536	Salmovirus WFRC1	1981916	Viruses	Viruses	167.0	2.65e-45	Salmovirus WFRC1	Non-phage	NR	PRJNA293022_P_NODE_12374_length_406_cov_2.389356_g11637_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g11637	i0	54.9	0.982758621	133	59	98.3	1	4	402	146	277	399	167.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	167.0	2.65e-45
10225	10225	PRJEB27957_CONTIG_119162\|Salmovirus_WFRC1\|CLUSTER3_Salmovirus_WFRC1\|3\|3	Zebrafish rhabdo-like virus	Novel	PRJEB27957_CONTIG_119162\|Salmovirus_WFRC1	PRJEB27957_CONTIG_119162	Salmovirus WFRC1	37	9	6	CLUSTER3_Salmovirus_WFRC1\|3\|3	PRJNA293022_P_NODE_12374_length_406_cov_2.389356_g11637_i0\|Salmovirus_WFRC1\|NR\|2.65e-45\|NA	3	3	PRJEB27957	119162	164	0.904348	1.48313072	Salmovirus WFRC1	1981916	Viruses	Viruses	69.3	5.34e-12	Salmovirus WFRC1	Non-phage	NR	PRJEB27957_P_NODE_119162_length_164_cov_0.904348_g119052_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g119052	i0	51.9	0.951219512	52	25	95.1	0	1	156	250	301	156	69.3	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	69.3	5.34e-12
10229	10229	PRJNA643700_CONTIG_256698\|Salmovirus_WFRC1\|CLUSTER3_Salmovirus_WFRC1\|3\|3	Zebrafish rhabdo-like virus	Novel	PRJNA643700_CONTIG_256698\|Salmovirus_WFRC1	PRJNA643700_CONTIG_256698	Salmovirus WFRC1	37	9	6	CLUSTER3_Salmovirus_WFRC1\|3\|3	PRJNA293022_P_NODE_12374_length_406_cov_2.389356_g11637_i0\|Salmovirus_WFRC1\|NR\|2.65e-45\|NA	3	3	PRJNA643700	256698	235	1.430108	3.3607538	Salmovirus WFRC1	1981916	Viruses	Viruses	95.5	9.170000000000001e-21	Salmovirus WFRC1	Non-phage	NR	PRJNA643700_P_NODE_256698_length_235_cov_1.430108_g255142_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g255142	i0	51.3	0.995744681	78	37	99.6	1	1	234	151	227	234	95.5	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	95.5	9.170000000000001e-21
10244	10244	PRJNA293022_CONTIG_2483\|Salmovirus_WFRC1\|CLUSTER4_Salmovirus_WFRC1\|2\|2	Zebrafish rhabdo-like virus	Novel	PRJNA293022_CONTIG_2483\|Salmovirus_WFRC1	PRJNA293022_CONTIG_2483	Salmovirus WFRC1	37	9	6	CLUSTER4_Salmovirus_WFRC1\|2\|2	PRJNA293022_P_NODE_2483_length_847_cov_2.357143_g2015_i0\|Salmovirus_WFRC1\|NR\|4.69e-17\|NA	2	2	PRJNA293022	2483	847	2.357143	19.96500121	Salmovirus WFRC1	1981916	Viruses	Viruses	92.8	4.69e-17	Salmovirus WFRC1	Non-phage	NR	PRJNA293022_P_NODE_2483_length_847_cov_2.357143_g2015_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g2015	i0	45.6	0.40377804	114	58	40.4	1	847	506	318	427	342	92.8	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	92.8	4.69e-17
10275	10275	PRJNA643700_CONTIG_228661\|Salmovirus_WFRC1\|CLUSTER4_Salmovirus_WFRC1\|2\|2	Zebrafish rhabdo-like virus	Novel	PRJNA643700_CONTIG_228661\|Salmovirus_WFRC1	PRJNA643700_CONTIG_228661	Salmovirus WFRC1	37	9	6	CLUSTER4_Salmovirus_WFRC1\|2\|2	PRJNA293022_P_NODE_2483_length_847_cov_2.357143_g2015_i0\|Salmovirus_WFRC1\|NR\|4.69e-17\|NA	2	2	PRJNA643700	228661	255	0.873786	2.2281543	Salmovirus WFRC1	1981916	Viruses	Viruses	92.8	1.08e-19	Salmovirus WFRC1	Non-phage	NR	PRJNA643700_P_NODE_228661_length_255_cov_0.873786_g227105_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g227105	i0	51.8	1.0	85	40	100.0	1	255	1	250	333	255	92.8	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	92.8	1.08e-19
10437	10437	PRJNA643700_CONTIG_27336\|Salmovirus_WFRC1\|CLUSTER5_Salmovirus_WFRC1\|1\|1	Zebrafish rhabdo-like virus	Novel	PRJNA643700_CONTIG_27336\|Salmovirus_WFRC1	PRJNA643700_CONTIG_27336	Salmovirus WFRC1	37	9	6	CLUSTER5_Salmovirus_WFRC1\|1\|1	PRJNA643700_P_NODE_27336_length_757_cov_2.539548_g26155_i0\|Salmovirus_WFRC1\|NR\|2.09e-20\|NA	1	1	PRJNA643700	27336	757	2.539548	19.22437836	Salmovirus WFRC1	1981916	Viruses	Viruses	101.0	2.09e-20	Salmovirus WFRC1	Non-phage	NR	PRJNA643700_P_NODE_27336_length_757_cov_2.539548_g26155_i0	YP_009361866.1 polyprotein [Salmovirus WFRC1]	YP_009361866.1	1981916	g26155	i0	42.7	0.519154557	131	68	51.5	2	392	3	2	126	393	101.0	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	101.0	2.09e-20
10439	10439	PRJNA293022_CONTIG_30016\|Salmovirus_WFRC1\|CLUSTER6_Salmovirus_WFRC1\|1\|1	Zebrafish rhabdo-like virus	Novel	PRJNA293022_CONTIG_30016\|Salmovirus_WFRC1	PRJNA293022_CONTIG_30016	Salmovirus WFRC1	37	9	6	CLUSTER6_Salmovirus_WFRC1\|1\|1	PRJNA293022_P_NODE_30016_length_256_cov_2.381643_g29279_i0\|Salmovirus_WFRC1\|NR\|3.15e-05\|NA	1	1	PRJNA293022	30016	256	2.381643	6.09700608	Salmovirus WFRC1	1981916	Viruses	Viruses	51.6	3.15e-05	Salmovirus WFRC1	Non-phage	NR	PRJNA293022_P_NODE_30016_length_256_cov_2.381643_g29279_i0	YP_009361865.1 protease [Salmovirus WFRC1]	YP_009361865.1	1981916	g29279	i0	36.5	0.8671875	74	47	86.7	0	3	224	271	344	222	51.6	1.0	Viruses	Salmovirus WFRC1	Viruses;Zebrafish rhabdo-like virus	Salmovirus WFRC1	Viruses	Viruses	51.6	3.15e-05

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE viruses_fish_associated_curated(contig_withLCA_withcluster VARCHAR, clusterLCA_curated VARCHAR, Category VARCHAR, contig_withLCA VARCHAR, shortcontigname VARCHAR, clusterLCA VARCHAR, clusterLCAcurated_contigcount BIGINT, clusterLCAcurated_bioprojectcount BIGINT, clusterLCAcurated_clustercount BIGINT, shortclustername VARCHAR, "cluster" VARCHAR, clustersize BIGINT, bioprojectsbycluster BIGINT, bioproject VARCHAR, node BIGINT, length BIGINT, coverage DOUBLE, rel_abundance DOUBLE, taxname_lca_NTorNR VARCHAR, taxid_lca_NTorNR BIGINT, taxoncategory_NTorNR VARCHAR, taxoncategorysimple_NTorNR VARCHAR, bits_NTorNR DOUBLE, evalue_NTorNR DOUBLE, viruscategory_NTorNR VARCHAR, viruscategorysimple_NTorNR VARCHAR, analysis_used VARCHAR, contig_name VARCHAR, lowcoverage_flag DOUBLE, target_title_NTorNR VARCHAR, target_NTorNR VARCHAR, taxid_NTorNR BIGINT, gene_NTorNR VARCHAR, allele_NTorNR VARCHAR, pident_NTorNR DOUBLE, sumperc_cov_NTorNR DOUBLE, alnlen_NTorNR BIGINT, mismatch_NTorNR BIGINT, qcov_NTorNR DOUBLE, gapopen_NTorNR BIGINT, qstart_NTorNR BIGINT, qend_NTorNR BIGINT, tstart_NTorNR BIGINT, tend_NTorNR BIGINT, sumalnlen_NTorNR BIGINT, maxbits_NTorNR DOUBLE, bits_percmax_NTorNR DOUBLE, tax_superkingdom_NTorNR VARCHAR, tax_clade_NTorNR VARCHAR, tax_kingdom_NTorNR VARCHAR, tax_phylum_NTorNR VARCHAR, tax_class_NTorNR VARCHAR, tax_order_NTorNR VARCHAR, tax_family_NTorNR VARCHAR, tax_genus_NTorNR VARCHAR, tax_species_NTorNR VARCHAR, classification VARCHAR, taxname_lca_NTclustered VARCHAR, taxname_lca_NR VARCHAR, target_NTclustered VARCHAR, taxoncategory_NTclustered VARCHAR, taxoncategory_NR VARCHAR, taxoncategorysimple_NTclustered VARCHAR, taxoncategorysimple_NR VARCHAR, bits_NTclustered DOUBLE, bits_NR DOUBLE, evalue_NTclustered DOUBLE, evalue_NR DOUBLE);;
CREATE INDEX idx_vfac_bioproject ON viruses_fish_associated_curated(bioproject);;
CREATE INDEX idx_vfac_category ON viruses_fish_associated_curated(Category);;
CREATE INDEX idx_vfac_clusterLCA_curated ON viruses_fish_associated_curated(clusterLCA_curated);;
CREATE INDEX idx_vfac_tax_family ON viruses_fish_associated_curated(tax_family_NTorNR);;
CREATE INDEX idx_vfac_tax_genus ON viruses_fish_associated_curated(tax_genus_NTorNR);;
CREATE INDEX idx_vfac_tax_species ON viruses_fish_associated_curated(tax_species_NTorNR);;