metadata: viruses_fish_associated_curated: 27 rows where Category = "Endogenous or not fish-associated", clusterLCA_curated = "Salarius guttatus piscichuvirus" and tax_species_NTorNR = "Salarius guttatus piscichuvirus"

27 rows where Category = "Endogenous or not fish-associated", clusterLCA_curated = "Salarius guttatus piscichuvirus" and tax_species_NTorNR = "Salarius guttatus piscichuvirus"

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_clade_NTorNR	tax_kingdom_NTorNR	tax_phylum_NTorNR	tax_class_NTorNR	tax_order_NTorNR	tax_family_NTorNR	tax_genus_NTorNR	tax_species_NTorNR	classification	taxname_lca_NR	taxoncategory_NR	taxoncategorysimple_NR	bits_NR	evalue_NR
9114	9114	PRJNA1174776_CONTIG_1439\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA1174776_CONTIG_1439\|Salarius_guttatus_piscichuvirus	PRJNA1174776_CONTIG_1439	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA1174776	1439	454	4.603406	20.89946324	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	80.1	3.67e-14	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA1174776_S_NODE_1439_length_454_cov_4.603406_g1339_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g1339	i0	36.5	1.837004405	126	76	80.6	3	2	367	7	132	834	80.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	80.1	3.67e-14
9130	9130	PRJNA631796_CONTIG_2684\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA631796_CONTIG_2684\|Salarius_guttatus_piscichuvirus	PRJNA631796_CONTIG_2684	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA631796	2684	394	1.129129	4.44876826	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	77.0	2.21e-13	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA631796_S_NODE_2684_length_394_cov_1.129129_g2517_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g2517	i0	40.6	0.769035533	101	57	74.6	2	5	298	69	169	303	77.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	77.0	2.21e-13
9132	9132	PRJNA656271_CONTIG_2710\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA656271_CONTIG_2710\|Salarius_guttatus_piscichuvirus	PRJNA656271_CONTIG_2710	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA656271	2710	439	3.409836	14.96918004	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	96.7	5.12e-20	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA656271_S_NODE_2710_length_439_cov_3.409836_g2679_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g2679	i0	36.2	2.043280182	149	91	99.1	3	5	439	6	154	897	96.7	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	96.7	5.12e-20
9133	9133	PRJNA725224_CONTIG_2712\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA725224_CONTIG_2712\|Salarius_guttatus_piscichuvirus	PRJNA725224_CONTIG_2712	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA725224	2712	439	3.409836	14.96918004	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	96.7	5.12e-20	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA725224_S_NODE_2712_length_439_cov_3.409836_g2681_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g2681	i0	36.2	2.043280182	149	91	99.1	3	5	439	6	154	897	96.7	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	96.7	5.12e-20
9135	9135	PRJNA915203_CONTIG_3086\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA915203_CONTIG_3086\|Salarius_guttatus_piscichuvirus	PRJNA915203_CONTIG_3086	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA915203	3086	313	1.295833	4.05595729	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	68.2	1.06e-10	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA915203_P_NODE_3086_length_313_cov_1.295833_g3023_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g3023	i0	41.3	0.766773163	80	47	76.7	0	285	46	90	169	240	68.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	68.2	1.06e-10
9137	9137	PRJNA387951_CONTIG_3325\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA387951_CONTIG_3325\|Salarius_guttatus_piscichuvirus	PRJNA387951_CONTIG_3325	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA387951	3325	223	2.051724	4.57534452	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	50.4	5.48e-05	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA387951_P_NODE_3325_length_223_cov_2.051724_g3065_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g3065	i0	44.8	0.780269058	58	32	78.0	0	3	176	112	169	174	50.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	50.4	5.48e-05
9138	9138	PRJNA649806_CONTIG_3355\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA649806_CONTIG_3355\|Salarius_guttatus_piscichuvirus	PRJNA649806_CONTIG_3355	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA649806	3355	644	1.443082	9.29344808	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	122.0	7.17e-28	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g3086	i0	40.8	0.787267081	169	96	76.9	3	544	50	1	169	507	122.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	122.0	7.17e-28
9148	9148	PRJNA550048_CONTIG_4554\|Piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA550048_CONTIG_4554\|Piscichuvirus	PRJNA550048_CONTIG_4554	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA550048	4554	246	0.901734	2.21826564	Piscichuvirus	2842963	Viruses	Viruses	67.0	1.15e-10	Piscichuvirus	Non-phage	NR	PRJNA550048_P_NODE_4554_length_246_cov_0.901734_g4459_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g4459	i0	42.3	1.865853659	78	45	95.1	0	10	243	123	200	459	67.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Piscichuvirus	Viruses	Viruses	67.0	1.15e-10
9171	9171	PRJNA1240804_CONTIG_8939\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA1240804_CONTIG_8939\|Salarius_guttatus_piscichuvirus	PRJNA1240804_CONTIG_8939	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA1240804	8939	428	1.693931	7.25002468	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	92.8	9.85e-19	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA1240804_P_NODE_8939_length_428_cov_1.693931_g8577_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g8577	i0	38.5	1.654205607	117	72	82.0	0	425	75	90	206	708	92.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	92.8	9.85e-19
9174	9174	PRJNA293269_CONTIG_9506\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA293269_CONTIG_9506\|Salarius_guttatus_piscichuvirus	PRJNA293269_CONTIG_9506	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA293269	9506	237	1.925532	4.56351084	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	66.2	1.82e-10	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA293269_P_NODE_9506_length_237_cov_1.925532_g9257_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g9257	i0	44.2	1.962025316	77	42	96.2	1	230	3	1	77	465	66.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	66.2	1.82e-10
9181	9181	PRJNA438111_CONTIG_11356\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA438111_CONTIG_11356\|Salarius_guttatus_piscichuvirus	PRJNA438111_CONTIG_11356	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA438111	11356	305	3.608696	11.0065228	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	65.1	1.14e-09	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA438111_P_NODE_11356_length_305_cov_3.608696_g10731_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g10731	i0	43.6	2.31147541	78	43	75.7	1	231	1	1	78	705	65.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	65.1	1.14e-09
9183	9183	PRJNA551453_CONTIG_11934\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA551453_CONTIG_11934\|Salarius_guttatus_piscichuvirus	PRJNA551453_CONTIG_11934	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA551453	11934	178	1.824	3.24672	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	50.1	3.99e-05	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA551453_P_NODE_11934_length_178_cov_1.824000_g11852_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g11852	i0	43.9	0.960674157	57	32	96.1	0	6	176	109	165	171	50.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	50.1	3.99e-05
9193	9193	PRJNA1272846_CONTIG_13903\|Piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA1272846_CONTIG_13903\|Piscichuvirus	PRJNA1272846_CONTIG_13903	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA1272846	13903	266	1.528497	4.06580202	Piscichuvirus	2842963	Viruses	Viruses	47.8	0.000879	Piscichuvirus	Non-phage	NR	PRJNA1272846_S_NODE_13903_length_266_cov_1.528497_g13774_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g13774	i0	35.6	3.586466165	73	44	78.9	2	3	212	60	132	954	47.8	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Piscichuvirus	Viruses	Viruses	47.8	0.000879
9196	9196	PRJNA841653_CONTIG_16850\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA841653_CONTIG_16850\|Salarius_guttatus_piscichuvirus	PRJNA841653_CONTIG_16850	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA841653	16850	399	1.604294	6.40113306	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	69.7	8.56e-11	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA841653_P_NODE_16850_length_399_cov_1.604294_g16178_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g16178	i0	45.6	0.593984962	79	42	58.6	1	297	64	1	79	237	69.7	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	69.7	8.56e-11
9199	9199	PRJNA527366_CONTIG_17785\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA527366_CONTIG_17785\|Salarius_guttatus_piscichuvirus	PRJNA527366_CONTIG_17785	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA527366	17785	183	1.164179	2.13044757	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	50.1	4.54e-05	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA527366_P_NODE_17785_length_183_cov_1.164179_g17680_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g17680	i0	57.1	0.68852459	42	18	68.9	0	40	165	1	42	126	50.1	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	50.1	4.54e-05
9202	9202	PRJEB29441_CONTIG_18725\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJEB29441_CONTIG_18725\|Salarius_guttatus_piscichuvirus	PRJEB29441_CONTIG_18725	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJEB29441	18725	248	1.025126	2.54231248	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	64.3	1.02e-09	Salarius guttatus piscichuvirus	Non-phage	NR	PRJEB29441_P_NODE_18725_length_248_cov_1.025126_g18284_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g18284	i0	43.8	0.883064516	73	41	88.3	0	243	25	97	169	219	64.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	64.3	1.02e-09
9204	9204	PRJNA674002_CONTIG_19311\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA674002_CONTIG_19311\|Salarius_guttatus_piscichuvirus	PRJNA674002_CONTIG_19311	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA674002	19311	307	1.688889	5.18488923	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	54.3	7.02e-06	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA674002_P_NODE_19311_length_307_cov_1.688889_g18682_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g18682	i0	45.9	0.596091205	61	33	59.6	0	302	120	109	169	183	54.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	54.3	7.02e-06
9210	9210	PRJNA591127_CONTIG_21433\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA591127_CONTIG_21433\|Salarius_guttatus_piscichuvirus	PRJNA591127_CONTIG_21433	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA591127	21433	192	2.754839	5.28929088	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	49.3	9.26e-05	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA591127_P_NODE_21433_length_192_cov_2.754839_g21264_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g21264	i0	34.9	0.984375	63	41	98.4	0	3	191	90	152	189	49.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	49.3	9.26e-05
9216	9216	PRJNA704066_CONTIG_24827\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA704066_CONTIG_24827\|Salarius_guttatus_piscichuvirus	PRJNA704066_CONTIG_24827	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA704066	24827	268	1.435897	3.84820396	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	71.6	3.59e-12	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA704066_P_NODE_24827_length_268_cov_1.435897_g24700_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g24700	i0	43.5	0.951492537	85	48	95.1	0	1	255	102	186	255	71.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	71.6	3.59e-12
9217	9217	PRJNA606583_CONTIG_26571\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA606583_CONTIG_26571\|Salarius_guttatus_piscichuvirus	PRJNA606583_CONTIG_26571	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA606583	26571	213	1.772727	3.77590851	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	47.4	0.000595	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA606583_P_NODE_26571_length_213_cov_1.772727_g26142_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g26142	i0	36.1	0.85915493	61	39	85.9	0	30	212	90	150	183	47.4	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	47.4	0.000595
9220	9220	PRJNA753704_CONTIG_27505\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA753704_CONTIG_27505\|Salarius_guttatus_piscichuvirus	PRJNA753704_CONTIG_27505	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA753704	27505	244	0.912281	2.22596564	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	69.3	1.62e-11	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA753704_P_NODE_27505_length_244_cov_0.912281_g27144_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g27144	i0	45.6	0.971311475	79	42	95.9	1	236	3	1	79	237	69.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	69.3	1.62e-11
9224	9224	PRJNA670235_CONTIG_28611\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA670235_CONTIG_28611\|Salarius_guttatus_piscichuvirus	PRJNA670235_CONTIG_28611	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA670235	28611	362	3.290221	11.91060002	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	75.5	5.17e-13	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA670235_S_NODE_28611_length_362_cov_3.290221_g27840_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g27840	i0	37.0	0.986187845	119	71	95.3	3	351	7	6	124	357	75.5	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	75.5	5.17e-13
9243	9243	PRJNA700095_CONTIG_63546\|Salarius_guttatus_piscichuvirus\|CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA700095_CONTIG_63546\|Salarius_guttatus_piscichuvirus	PRJNA700095_CONTIG_63546	Salarius guttatus piscichuvirus	67	58	5	CLUSTER1_Salarius_guttatus_piscichuvirus\|63\|56	PRJNA649806_P_NODE_3355_length_644_cov_1.443082_g3086_i0\|Salarius_guttatus_piscichuvirus\|NR\|7.17e-28\|NA	63	56	PRJNA700095	63546	242	1.449704	3.50828368	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	69.3	1.62e-11	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA700095_P_NODE_63546_length_242_cov_1.449704_g62282_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g62282	i0	45.6	0.979338843	79	42	96.7	1	234	1	1	79	237	69.3	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	69.3	1.62e-11
10358	10358	PRJNA1022165_CONTIG_2678\|Salarius_guttatus_piscichuvirus\|CLUSTER2_Salarius_guttatus_piscichuvirus\|1\|1	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA1022165_CONTIG_2678\|Salarius_guttatus_piscichuvirus	PRJNA1022165_CONTIG_2678	Salarius guttatus piscichuvirus	67	58	5	CLUSTER2_Salarius_guttatus_piscichuvirus\|1\|1	PRJNA1022165_S_NODE_2678_length_165_cov_0.890625_g2456_i0\|Salarius_guttatus_piscichuvirus\|NR\|1.26e-13\|NA	1	1	PRJNA1022165	2678	165	0.890625	1.46953125	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	73.9	1.26e-13	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA1022165_S_NODE_2678_length_165_cov_0.890625_g2456_i0	UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus]	UVF58769.1	2951531	g2456	i0	72.2	3.890909091	54	15	98.2	0	163	2	307	360	642	74.3	0.99461642	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	73.9	1.26e-13
10433	10433	PRJNA293022_CONTIG_25640\|Salarius_guttatus_piscichuvirus\|CLUSTER3_Salarius_guttatus_piscichuvirus\|1\|1	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA293022_CONTIG_25640\|Salarius_guttatus_piscichuvirus	PRJNA293022_CONTIG_25640	Salarius guttatus piscichuvirus	67	58	5	CLUSTER3_Salarius_guttatus_piscichuvirus\|1\|1	PRJNA293022_P_NODE_25640_length_279_cov_1.347826_g24903_i0\|Salarius_guttatus_piscichuvirus\|NR\|8.22e-20\|NA	1	1	PRJNA293022	25640	279	1.347826	3.76043454	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	93.6	8.22e-20	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA293022_P_NODE_25640_length_279_cov_1.347826_g24903_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g24903	i0	50.5	0.978494624	91	42	94.6	2	270	7	1430	1520	273	93.6	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	93.6	8.22e-20
10436	10436	PRJNA293022_CONTIG_27190\|Salarius_guttatus_piscichuvirus\|CLUSTER4_Salarius_guttatus_piscichuvirus\|1\|1	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA293022_CONTIG_27190\|Salarius_guttatus_piscichuvirus	PRJNA293022_CONTIG_27190	Salarius guttatus piscichuvirus	67	58	5	CLUSTER4_Salarius_guttatus_piscichuvirus\|1\|1	PRJNA293022_P_NODE_27190_length_270_cov_1.574661_g26453_i0\|Salarius_guttatus_piscichuvirus\|NR\|1.63e-08\|NA	1	1	PRJNA293022	27190	270	1.574661	4.2515847	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	61.2	1.63e-08	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA293022_P_NODE_27190_length_270_cov_1.574661_g26453_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g26453	i0	47.9	0.533333333	48	25	53.3	0	148	5	1027	1074	144	61.2	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	61.2	1.63e-08
10450	10450	PRJNA293022_CONTIG_37175\|Salarius_guttatus_piscichuvirus\|CLUSTER5_Salarius_guttatus_piscichuvirus\|1\|1	Salarius guttatus piscichuvirus	Endogenous or not fish-associated	PRJNA293022_CONTIG_37175\|Salarius_guttatus_piscichuvirus	PRJNA293022_CONTIG_37175	Salarius guttatus piscichuvirus	67	58	5	CLUSTER5_Salarius_guttatus_piscichuvirus\|1\|1	PRJNA293022_P_NODE_37175_length_229_cov_1.716667_g36438_i0\|Salarius_guttatus_piscichuvirus\|NR\|6.27e-26\|NA	1	1	PRJNA293022	37175	229	1.716667	3.93116743	Salarius guttatus piscichuvirus	2951531	Viruses	Viruses	110.0	6.270000000000001e-26	Salarius guttatus piscichuvirus	Non-phage	NR	PRJNA293022_P_NODE_37175_length_229_cov_1.716667_g36438_i0	UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus]	UVF58767.1	2951531	g36438	i0	74.6	0.825327511	63	16	82.5	0	32	220	580	642	189	110.0	1.0	Viruses	Riboviria	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Piscichuvirus	Salarius guttatus piscichuvirus	Viruses;Riboviria;Orthornavirae;Negarnaviricota;Monjiviricetes;Jingchuvirales;Chuviridae;Piscichuvirus;Salarius guttatus piscichuvirus	Salarius guttatus piscichuvirus	Viruses	Viruses	110.0	6.270000000000001e-26

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);;