metadata: viruses_fish_associated_curated: 13 rows where bioproject = "PRJNA630162"

13 rows where bioproject = "PRJNA630162"

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_NTclustered	taxname_lca_NR	target_NTclustered	taxoncategory_NTclustered	taxoncategory_NR	taxoncategorysimple_NTclustered	taxoncategorysimple_NR	bits_NTclustered	bits_NR	evalue_NTclustered	evalue_NR
4956	4956	PRJNA630162_CONTIG_66518\|Carp_edema_virus\|CLUSTER1_Carp_edema_virus\|632\|87	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_66518\|Carp_edema_virus	PRJNA630162_CONTIG_66518	Carp edema virus	4680	143	36	CLUSTER1_Carp_edema_virus\|632\|87	PRJNA1075480_S_NODE_3_length_24555_cov_43.250551_g1_i0\|Carp_edema_virus\|NR\|0\|NA	629	87	PRJNA630162	66518	217	1.297619	2.81583323	Carp edema virus	1653087	Viruses	Viruses	87.4	4.95e-18	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_66518_length_217_cov_1.297619_g64995_i0	BCT22635.1 NTPase [Carp edema virus]	BCT22635.1	1653087	g64995	i0	57.1	0.967741935	70	30	96.8	0	1	210	311	380	210	87.4	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		87.4		4.95e-18
6212	6212	PRJNA630162_CONTIG_135069\|Carp_edema_virus\|CLUSTER4_Carp_edema_virus\|348\|78	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_135069\|Carp_edema_virus	PRJNA630162_CONTIG_135069	Carp edema virus	4680	143	36	CLUSTER4_Carp_edema_virus\|348\|78	PRJNA1075480_S_NODE_1_length_24682_cov_102.472876_g0_i0\|Carp_edema_virus\|NR\|2.31e-98\|NA	331	77	PRJNA630162	135069	168	1.310924	2.20235232	Carp edema virus	1653087	Viruses	Viruses	49.3	6.72e-05	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_135069_length_168_cov_1.310924_g133546_i0	BCT22587.1 hypothetical protein [Carp edema virus]	BCT22587.1	1653087	g133546	i0	41.1	1.0	56	32	98.2	1	4	168	336	391	168	49.3	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		49.3		6.72e-05
6687	6687	PRJNA630162_CONTIG_21714\|Carp_edema_virus\|CLUSTER6_Carp_edema_virus\|274\|111	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_21714\|Carp_edema_virus	PRJNA630162_CONTIG_21714	Carp edema virus	4680	143	36	CLUSTER6_Carp_edema_virus\|274\|111	PRJNA1075480_S_NODE_10_length_11763_cov_107.476048_g4_i0\|Carp_edema_virus\|NR\|0\|NA	264	107	PRJNA630162	21714	395	2.436416	9.6238432	Carp edema virus	1653087	Viruses	Viruses	65.9	1.28e-09	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_21714_length_395_cov_2.436416_g20196_i0	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	BCT22626.1	1653087	g20196	i0	37.2	0.653164557	86	51	63.0	2	122	370	67	152	258	65.9	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		65.9		1.28e-09
8761	8761	PRJNA630162_CONTIG_82749\|Carp_edema_virus\|CLUSTER17_Carp_edema_virus\|89\|39	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_82749\|Carp_edema_virus	PRJNA630162_CONTIG_82749	Carp edema virus	4680	143	36	CLUSTER17_Carp_edema_virus\|89\|39	PRJNA854078_P_NODE_51_length_3466_cov_13.696729_g37_i0\|Carp_edema_virus\|NR\|4.02e-76\|NA	89	39	PRJNA630162	82749	198	3.067114	6.07288572	Carp edema virus	1653087	Viruses	Viruses	78.6	4.75e-15	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_82749_length_198_cov_3.067114_g81226_i0	BCT22764.1 kelch-like protein [Carp edema virus]	BCT22764.1	1653087	g81226	i0	57.8	0.96969697	64	27	97.0	0	6	197	65	128	192	78.6	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		78.6		4.75e-15
9308	9308	PRJNA630162_CONTIG_73090\|Carp_edema_virus\|CLUSTER23_Carp_edema_virus\|62\|54	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_73090\|Carp_edema_virus	PRJNA630162_CONTIG_73090	Carp edema virus	4680	143	36	CLUSTER23_Carp_edema_virus\|62\|54	PRJNA318414_P_NODE_26_length_7203_cov_323.641065_g21_i0\|Carp_edema_virus\|NR\|1.66e-43\|NA	57	54	PRJNA630162	73090	210	2.31677	4.865217	Carp edema virus	1653087	Viruses	Viruses	43.5	0.0128	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_73090_length_210_cov_2.316770_g71567_i0	BCT22575.1 thymidine kinase [Carp edema virus]	BCT22575.1	1653087	g71567	i0	31.8	0.942857143	66	43	94.3	1	204	7	223	286	198	43.5	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		43.5		0.0128
9311	9311	PRJNA630162_CONTIG_139847\|Carp_edema_virus\|CLUSTER23_Carp_edema_virus\|62\|54	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_139847\|Carp_edema_virus	PRJNA630162_CONTIG_139847	Carp edema virus	4680	143	36	CLUSTER23_Carp_edema_virus\|62\|54	PRJNA318414_P_NODE_26_length_7203_cov_323.641065_g21_i0\|Carp_edema_virus\|NR\|1.66e-43\|NA	57	54	PRJNA630162	139847	167	0.881356	1.47186452	Carp edema virus	1653087	Viruses	Viruses	54.7	7.37e-07	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_139847_length_167_cov_0.881356_g138324_i0	BCT22575.1 thymidine kinase [Carp edema virus]	BCT22575.1	1653087	g138324	i0	53.1	0.880239521	49	23	88.0	0	153	7	114	162	147	54.7	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		54.7		7.37e-07
9652	9652	PRJNA630162_CONTIG_83848\|Carp_edema_virus\|CLUSTER28_Carp_edema_virus\|40\|36	Zebrafish jaw poxvirus	Novel	PRJNA630162_CONTIG_83848\|Carp_edema_virus	PRJNA630162_CONTIG_83848	Carp edema virus	4680	143	36	CLUSTER28_Carp_edema_virus\|40\|36	PRJNA318414_P_NODE_14_length_10700_cov_125.867398_g11_i0\|Carp_edema_virus\|NR\|1.58e-60\|NA	39	35	PRJNA630162	83848	197	2.608108	5.13797276	Carp edema virus	1653087	Viruses	Viruses	47.0	0.00065	Carp edema virus	Non-phage	NR	PRJNA630162_P_NODE_83848_length_197_cov_2.608108_g82325_i0	BCT22826.1 hypothetical protein [Carp edema virus]	BCT22826.1	1653087	g82325	i0	40.0	0.913705584	60	32	89.8	2	178	2	80	136	180	47.0	1.0	Viruses	Varidnaviria	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae		Carp edema virus	Viruses;Varidnaviria;Bamfordvirae;Nucleocytoviricota;Pokkesviricetes;Chitovirales;Poxviridae;Zebrafish jaw poxvirus		Carp edema virus			Viruses		Viruses		47.0		0.00065
9795	9795	PRJNA630162_CONTIG_172398\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER1_Fish-associated_parvo-like_hybrid_virus\|21\|14	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA630162_CONTIG_172398\|Fish-associated_parvo-like_hybrid_virus	PRJNA630162_CONTIG_172398	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER1_Fish-associated_parvo-like_hybrid_virus\|21\|14	MT138265_1_MAG_Nicoomyvirus_lizumae_isolate_par077par1_genomic_sequence	21	14	PRJNA630162	172398	152	2.446602	3.71883504	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	156.0	9.21e-34	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA630162_P_NODE_172398_length_152_cov_2.446602_g170875_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g170875	i0	100.0	0.980263158	84	0	97.0	0	6	89	666	583	149	156.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus		gi\|2413975758\|gb\|OP933682.1\|	Viruses		Viruses		156.0		9.21e-34
10057	10057	PRJNA630162_CONTIG_117271\|Psittaciform_aveparvovirus\|CLUSTER1_Psittaciform_aveparvovirus\|12\|7	Psittaciform aveparvovirus	Endogenous or not fish-associated	PRJNA630162_CONTIG_117271\|Psittaciform_aveparvovirus	PRJNA630162_CONTIG_117271	Psittaciform aveparvovirus	19	12	2	CLUSTER1_Psittaciform_aveparvovirus\|12\|7	OP577480_1_Psittaciform_aveparvovirus_strain_OBP1_FE1_49_2021_partial_genome	12	7	PRJNA630162	117271	176	1.291339	2.27275664	Psittaciform aveparvovirus	3042447	Viruses	Viruses	315.0	1.7199999999999998e-81	Psittaciform aveparvovirus	Non-phage	NTclustered	PRJNA630162_P_NODE_117271_length_176_cov_1.291339_g115748_i0	Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome	gi\|2496529060\|gb\|OP577480.1\|	3042447	g115748	i0	99.422	0.982954545	173	1	98.0	0	4	176	2044	1872	173	315.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittaciform aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Psittaciform aveparvovirus	Psittaciform aveparvovirus	Psittaciform aveparvovirus	gi\|2496529060\|gb\|OP577480.1\|	Viruses	Viruses	Viruses	Viruses	315.0	122.0	1.7199999999999998e-81	1.1100000000000001e-31
10206	10206	PRJNA630162_CONTIG_80112\|Fish-associated_parvo-like_hybrid_virus\|CLUSTER3_Fish-associated_parvo-like_hybrid_virus\|4\|4	Fish-associated parvo-like hybrid virus	Endogenous or not fish-associated	PRJNA630162_CONTIG_80112\|Fish-associated_parvo-like_hybrid_virus	PRJNA630162_CONTIG_80112	Fish-associated parvo-like hybrid virus	35	19	4	CLUSTER3_Fish-associated_parvo-like_hybrid_virus\|4\|4	PRJNA784979_S_NODE_744_length_713_cov_4.688253_g709_i0\|Fish-associated_parvo-like_hybrid_virus\|NTclustered\|0\|NA	4	4	PRJNA630162	80112	201	1.809211	3.63651411	Fish-associated parvo-like hybrid virus	3003968	Viruses	Viruses	363.0	7.11e-96	Fish-associated parvo-like hybrid virus	Non-phage	NTclustered	PRJNA630162_P_NODE_80112_length_201_cov_1.809211_g78589_i0	MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds	gi\|2413975758\|gb\|OP933682.1\|	3003968	g78589	i0	100.0	0.975124378	196	0	98.0	0	6	201	319	124	196	363.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Fish-associated parvo-like hybrid virus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Fish-associated parvo-like hybrid virus	Fish-associated parvo-like hybrid virus		gi\|2413975758\|gb\|OP933682.1\|	Viruses		Viruses		363.0		7.11e-96
10217	10217	PRJNA630162_CONTIG_16732\|Psittacidae_aveparvovirus\|CLUSTER2_Psittacidae_aveparvovirus\|3\|3	Psittacidae aveparvovirus	Endogenous or not fish-associated	PRJNA630162_CONTIG_16732\|Psittacidae_aveparvovirus	PRJNA630162_CONTIG_16732	Psittacidae aveparvovirus	18	10	4	CLUSTER2_Psittacidae_aveparvovirus\|3\|3	PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0\|Psittacidae_aveparvovirus\|NR\|1.21e-18\|NA	3	3	PRJNA630162	16732	457	2.938725	13.42997325	Psittacidae aveparvovirus	2794556	Viruses	Viruses	92.0	1.21e-18	Psittacidae aveparvovirus	Non-phage	NR	PRJNA630162_P_NODE_16732_length_457_cov_2.938725_g15229_i0	QTE03751.1 MAG: replication protein [Psittacidae aveparvovirus]	QTE03751.1	2794556	g15229	i0	39.3	0.800875274	122	58	78.1	3	97	453	16	124	366	92.0	1.0	Viruses	Monodnaviria	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Aveparvovirus	Psittacidae aveparvovirus	Viruses;Monodnaviria;Shotokuvirae;Cossaviricota;Quintoviricetes;Piccovirales;Parvoviridae;Aveparvovirus;Psittacidae aveparvovirus		Psittacidae aveparvovirus			Viruses		Viruses		92.0		1.21e-18
10421	10421	PRJNA630162_CONTIG_20357\|Flumine_Astrovirus_3\|CLUSTER3_Flumine_Astrovirus_3\|1\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJNA630162_CONTIG_20357\|Flumine_Astrovirus_3	PRJNA630162_CONTIG_20357	Flumine Astrovirus 3	6	2	5	CLUSTER3_Flumine_Astrovirus_3\|1\|1	PRJNA630162_P_NODE_20357_length_410_cov_2.520776_g18842_i0\|Flumine_Astrovirus_3\|NR\|3.47e-09\|NA	1	1	PRJNA630162	20357	410	2.520776	10.3351816	Flumine Astrovirus 3	2940955	Viruses	Viruses	65.1	3.47e-09	Flumine Astrovirus 3	Non-phage	NR	PRJNA630162_P_NODE_20357_length_410_cov_2.520776_g18842_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g18842	i0	34.1	1.324390244	91	60	66.6	0	278	6	60	150	543	65.1	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		65.1		3.47e-09
10460	10460	PRJNA630162_CONTIG_44607\|Flumine_Astrovirus_3\|CLUSTER4_Flumine_Astrovirus_3\|1\|1	Flumine Astrovirus 3	Endogenous or not fish-associated	PRJNA630162_CONTIG_44607\|Flumine_Astrovirus_3	PRJNA630162_CONTIG_44607	Flumine Astrovirus 3	6	2	5	CLUSTER4_Flumine_Astrovirus_3\|1\|1	PRJNA630162_P_NODE_44607_length_265_cov_2.009259_g43084_i0\|Flumine_Astrovirus_3\|NR\|1.85e-15\|NA	1	1	PRJNA630162	44607	265	2.009259	5.32453635	Flumine Astrovirus 3	2940955	Viruses	Viruses	80.9	1.85e-15	Flumine Astrovirus 3	Non-phage	NR	PRJNA630162_P_NODE_44607_length_265_cov_2.009259_g43084_i0	UQB76172.1 RNA-dependent RNA polymerase, partial [Flumine Astrovirus 3]	UQB76172.1	2940955	g43084	i0	44.2	1.743396226	77	43	87.2	0	252	22	231	307	462	80.9	1.0	Viruses	Riboviria	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae		Flumine Astrovirus 3	Viruses;Riboviria;Orthornavirae;Pisuviricota;Stelpaviricetes;Stellavirales;Astroviridae;Flumine Astrovirus 3		Flumine Astrovirus 3			Viruses		Viruses		80.9		1.85e-15

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