metadata: viruses_fish_associated_curated: 25 rows where bioproject = "PRJNA611476" and clusterLCA

25 rows where bioproject = "PRJNA611476" and clusterLCA_curated = "Zebrafish jaw poxvirus"

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_species_NTorNR	classification	taxname_lca_NR	taxoncategory_NR	taxoncategorysimple_NR	bits_NR	evalue_NR
4875	4875	PRJNA611476_CONTIG_27365\|Carp_edema_virus\|CLUSTER1_Carp_edema_virus\|632\|87	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_27365\|Carp_edema_virus	PRJNA611476_CONTIG_27365	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	PRJNA611476	27365	390	1.116719	4.3552041	Carp edema virus	1653087	Viruses	Viruses	114.0	2.2500000000000002e-26	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_27365_length_390_cov_1.116719_g26574_i0	BCT22635.1 NTPase [Carp edema virus]	BCT22635.1	1653087	g26574	i0	42.6	0.992307692	129	71	99.2	1	389	3	103	228	387	114.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	114.0	2.2500000000000002e-26
4975	4975	PRJNA611476_CONTIG_118679\|Carp_edema_virus\|CLUSTER1_Carp_edema_virus\|632\|87	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_118679\|Carp_edema_virus	PRJNA611476_CONTIG_118679	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	PRJNA611476	118679	236	2.595092	6.12441712	Carp edema virus	1653087	Viruses	Viruses	53.5	5.11e-06	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_118679_length_236_cov_2.595092_g117888_i0	BCT22649.1 hypothetical protein [Carp edema virus]	BCT22649.1	1653087	g117888	i0	36.4	0.838983051	66	42	83.9	0	3	200	185	250	198	53.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	53.5	5.11e-06
5301	5301	PRJNA611476_CONTIG_6179\|Carp_edema_virus\|CLUSTER2_Carp_edema_virus\|553\|75	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_6179\|Carp_edema_virus	PRJNA611476_CONTIG_6179	Carp edema virus	4680	143	36	CLUSTER2_Carp_edema_virus\|553\|75	LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome	552	75	PRJNA611476	6179	777	2.205966	17.14035582	Carp edema virus	1653087	Viruses	Viruses	67.4	6.54e-09	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_6179_length_777_cov_2.205966_g5429_i0	BCT22728.1 DNA topoisomerase I [Carp edema virus]	BCT22728.1	1653087	g5429	i0	67.4	0.177606178	46	15	17.8	0	638	775	46	91	138	67.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	67.4	6.54e-09
5524	5524	PRJNA611476_CONTIG_96699\|Carp_edema_virus\|CLUSTER2_Carp_edema_virus\|553\|75	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_96699\|Carp_edema_virus	PRJNA611476_CONTIG_96699	Carp edema virus	4680	143	36	CLUSTER2_Carp_edema_virus\|553\|75	LC613089_1_Carp_edema_virus_FTI2020_DNA_complete_genome	552	75	PRJNA611476	96699	246	1.33526	3.2847396	Carp edema virus	1653087	Viruses	Viruses	125.0	1.92e-33	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_96699_length_246_cov_1.335260_g95908_i0	BCT22690.1 DNA-directed RNA polymerase, 18 kD subunit [Carp edema virus]	BCT22690.1	1653087	g95908	i0	66.7	0.951219512	78	26	95.1	0	11	244	137	214	234	125.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	125.0	1.92e-33
5818	5818	PRJNA611476_CONTIG_17330\|Carp_edema_virus\|CLUSTER3_Carp_edema_virus\|359\|69	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_17330\|Carp_edema_virus	PRJNA611476_CONTIG_17330	Carp edema virus	4680	143	36	CLUSTER3_Carp_edema_virus\|359\|69	PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0\|Carp_edema_virus\|NR\|0\|NA	358	69	PRJNA611476	17330	475	1.129353	5.36442675	Carp edema virus	1653087	Viruses	Viruses	137.0	5.809999999999999e-34	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_17330_length_475_cov_1.129353_g16540_i0	BCT22720.1 poxvirus B22R superfamily protein [Carp edema virus]	BCT22720.1	1653087	g16540	i0	44.0	0.947368421	150	81	93.5	2	447	4	679	827	450	137.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	137.0	5.809999999999999e-34
5861	5861	PRJNA611476_CONTIG_32541\|Carp_edema_virus\|CLUSTER3_Carp_edema_virus\|359\|69	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_32541\|Carp_edema_virus	PRJNA611476_CONTIG_32541	Carp edema virus	4680	143	36	CLUSTER3_Carp_edema_virus\|359\|69	PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0\|Carp_edema_virus\|NR\|0\|NA	358	69	PRJNA611476	32541	364	1.580756	5.75395184	Carp edema virus	1653087	Viruses	Viruses	71.6	1.17e-11	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_32541_length_364_cov_1.580756_g31750_i0	BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus]	BCT22715.1	1653087	g31750	i0	42.5	0.717032967	87	49	70.9	1	259	2	324	410	261	71.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	71.6	1.17e-11
5880	5880	PRJNA611476_CONTIG_64859\|Carp_edema_virus\|CLUSTER3_Carp_edema_virus\|359\|69	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_64859\|Carp_edema_virus	PRJNA611476_CONTIG_64859	Carp edema virus	4680	143	36	CLUSTER3_Carp_edema_virus\|359\|69	PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0\|Carp_edema_virus\|NR\|0\|NA	358	69	PRJNA611476	64859	276	1.492611	4.11960636	Carp edema virus	1653087	Viruses	Viruses	44.3	0.0161	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_64859_length_276_cov_1.492611_g64068_i0	BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus]	BCT22715.1	1653087	g64068	i0	32.5	0.836956522	77	51	83.7	1	233	3	810	885	231	44.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	44.3	0.0161
5884	5884	PRJNA611476_CONTIG_73969\|Carp_edema_virus\|CLUSTER3_Carp_edema_virus\|359\|69	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_73969\|Carp_edema_virus	PRJNA611476_CONTIG_73969	Carp edema virus	4680	143	36	CLUSTER3_Carp_edema_virus\|359\|69	PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0\|Carp_edema_virus\|NR\|0\|NA	358	69	PRJNA611476	73969	259	1.236559	3.20268781	Carp edema virus	1653087	Viruses	Viruses	55.1	2.05e-06	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_73969_length_259_cov_1.236559_g73178_i0	BCT22720.1 poxvirus B22R superfamily protein [Carp edema virus]	BCT22720.1	1653087	g73178	i0	36.9	0.972972973	84	48	95.0	4	254	9	1141	1221	252	55.1	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	55.1	2.05e-06
5889	5889	PRJNA611476_CONTIG_82479\|Carp_edema_virus\|CLUSTER3_Carp_edema_virus\|359\|69	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_82479\|Carp_edema_virus	PRJNA611476_CONTIG_82479	Carp edema virus	4680	143	36	CLUSTER3_Carp_edema_virus\|359\|69	PRJNA318414_P_NODE_2_length_28050_cov_65.213304_g1_i0\|Carp_edema_virus\|NR\|0\|NA	358	69	PRJNA611476	82479	250	0.870056	2.17514	Carp edema virus	1653087	Viruses	Viruses	63.5	1.96e-09	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_82479_length_250_cov_0.870056_g81688_i0	BCT22717.1 B22R family protein [Carp edema virus]	BCT22717.1	1653087	g81688	i0	40.0	0.78	65	39	78.0	0	13	207	1091	1155	195	63.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	63.5	1.96e-09
6149	6149	PRJNA611476_CONTIG_13365\|Carp_edema_virus\|CLUSTER4_Carp_edema_virus\|348\|78	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_13365\|Carp_edema_virus	PRJNA611476_CONTIG_13365	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	PRJNA611476	13365	537	1.258621	6.75879477	Carp edema virus	1653087	Viruses	Viruses	82.4	3.92e-16	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_13365_length_537_cov_1.258621_g12577_i0	BCT22576.1 deoxyuridine triphosphatase [Carp edema virus]	BCT22576.1	1653087	g12577	i0	39.2	0.798882682	143	81	78.8	3	424	2	26	164	429	82.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	82.4	3.92e-16
6205	6205	PRJNA611476_CONTIG_69097\|Carp_edema_virus\|CLUSTER4_Carp_edema_virus\|348\|78	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_69097\|Carp_edema_virus	PRJNA611476_CONTIG_69097	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	PRJNA611476	69097	268	1.497436	4.01312848	Carp edema virus	1653087	Viruses	Viruses	56.2	8.71e-07	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_69097_length_268_cov_1.497436_g68306_i0	BCT22585.1 hypothetical protein [Carp edema virus]	BCT22585.1	1653087	g68306	i0	34.8	1.029850746	92	57	99.6	1	268	2	165	256	276	56.2	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	56.2	8.71e-07
6375	6375	PRJNA611476_CONTIG_5459\|Carp_edema_virus\|CLUSTER5_Carp_edema_virus\|282\|82	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_5459\|Carp_edema_virus	PRJNA611476_CONTIG_5459	Carp edema virus	4680	143	36	CLUSTER5_Carp_edema_virus\|282\|82	PRJNA318414_P_NODE_10_length_15674_cov_109.855034_g8_i0\|Carp_edema_virus\|NR\|1.76e-230\|NA	266	81	PRJNA611476	5459	827	1.897878	15.69545106	Carp edema virus	1653087	Viruses	Viruses	59.3	8.18e-06	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_5459_length_827_cov_1.897878_g4725_i0	BCT22708.1 hypothetical protein [Carp edema virus]	BCT22708.1	1653087	g4725	i0	26.0	0.950423216	262	160	88.9	11	757	23	1098	1342	786	59.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	59.3	8.18e-06
6411	6411	PRJNA611476_CONTIG_10477\|Carp_edema_virus\|CLUSTER5_Carp_edema_virus\|282\|82	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_10477\|Carp_edema_virus	PRJNA611476_CONTIG_10477	Carp edema virus	4680	143	36	CLUSTER5_Carp_edema_virus\|282\|82	PRJNA318414_P_NODE_10_length_15674_cov_109.855034_g8_i0\|Carp_edema_virus\|NR\|1.76e-230\|NA	266	81	PRJNA611476	10477	602	2.319471	13.96321542	Carp edema virus	1653087	Viruses	Viruses	80.1	1.44e-14	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_10477_length_602_cov_2.319471_g9693_i0	BCT22707.1 hypothetical protein [Carp edema virus]	BCT22707.1	1653087	g9693	i0	34.9	0.857142857	172	95	82.7	7	56	553	18	178	516	80.1	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	80.1	1.44e-14
6596	6596	PRJNA611476_CONTIG_2527\|Carp_edema_virus\|CLUSTER6_Carp_edema_virus\|274\|111	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_2527\|Carp_edema_virus	PRJNA611476_CONTIG_2527	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	PRJNA611476	2527	1248	4.25617	53.1170016	Carp edema virus	1653087	Viruses	Viruses	181.0	1.86e-49	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_2527_length_1248_cov_4.256170_g1971_i0	BCT22626.1 putative DNA-binding virion core protein [Carp edema virus]	BCT22626.1	1653087	g1971	i0	36.4	0.752403846	313	182	71.9	6	1164	268	3	312	939	181.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	181.0	1.86e-49
6889	6889	PRJNA611476_CONTIG_24208\|Carp_edema_virus\|CLUSTER7_Carp_edema_virus\|191\|60	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_24208\|Carp_edema_virus	PRJNA611476_CONTIG_24208	Carp edema virus	4680	143	36	CLUSTER7_Carp_edema_virus\|191\|60	PRJNA318414_P_NODE_4_length_21553_cov_145.486805_g3_i0\|Carp_edema_virus\|NR\|0\|NA	184	57	PRJNA611476	24208	410	1.486647	6.0952527	Carp edema virus	1653087	Viruses	Viruses	47.4	0.00499	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_24208_length_410_cov_1.486647_g23417_i0	BCT22655.1 hypothetical protein [Carp edema virus]	BCT22655.1	1653087	g23417	i0	38.5	0.570731707	78	40	56.3	2	172	402	377	447	234	47.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	47.4	0.00499
6909	6909	PRJNA611476_CONTIG_66222\|Carp_edema_virus\|CLUSTER7_Carp_edema_virus\|191\|60	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_66222\|Carp_edema_virus	PRJNA611476_CONTIG_66222	Carp edema virus	4680	143	36	CLUSTER7_Carp_edema_virus\|191\|60	PRJNA318414_P_NODE_4_length_21553_cov_145.486805_g3_i0\|Carp_edema_virus\|NR\|0\|NA	184	57	PRJNA611476	66222	274	1.0	2.74	Carp edema virus	1653087	Viruses	Viruses	48.9	0.000365	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_66222_length_274_cov_1.000000_g65431_i0	BCT22653.1 4a protein [Carp edema virus]	BCT22653.1	1653087	g65431	i0	35.6	0.98540146	90	48	98.5	3	3	272	210	289	270	48.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	48.9	0.000365
7653	7653	PRJNA611476_CONTIG_106267\|Carp_edema_virus\|CLUSTER10_Carp_edema_virus\|185\|56	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_106267\|Carp_edema_virus	PRJNA611476_CONTIG_106267	Carp edema virus	4680	143	36	CLUSTER10_Carp_edema_virus\|185\|56	PRJNA318414_P_NODE_23_length_7708_cov_280.993359_g18_i0\|Carp_edema_virus\|NR\|5.21e-142\|NA	183	56	PRJNA611476	106267	244	0.900585	2.1974274	Carp edema virus	1653087	Viruses	Viruses	97.4	8.42e-22	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_106267_length_244_cov_0.900585_g105476_i0	BCT22662.1 soluble myristylprotein [Carp edema virus]	BCT22662.1	1653087	g105476	i0	59.7	0.946721311	77	31	94.7	0	3	233	34	110	231	97.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	97.4	8.42e-22
7812	7812	PRJNA611476_CONTIG_29219\|Carp_edema_virus\|CLUSTER12_Carp_edema_virus\|176\|54	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_29219\|Carp_edema_virus	PRJNA611476_CONTIG_29219	Carp edema virus	4680	143	36	CLUSTER12_Carp_edema_virus\|176\|54	PRJNA318414_P_NODE_15_length_10645_cov_116.245761_g12_i0\|Carp_edema_virus\|NR\|2.1e-150\|NA	175	54	PRJNA611476	29219	380	1.003257	3.8123766	Carp edema virus	1653087	Viruses	Viruses	100.0	7.45e-22	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_29219_length_380_cov_1.003257_g28428_i0	BCT22616.1 poly(A)-polymerase catalytic subunit PAPL [Carp edema virus]	BCT22616.1	1653087	g28428	i0	44.0	0.986842105	125	68	98.7	2	380	6	479	601	375	100.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	100.0	7.45e-22
7960	7960	PRJNA611476_CONTIG_13194\|Carp_edema_virus\|CLUSTER13_Carp_edema_virus\|165\|64	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_13194\|Carp_edema_virus	PRJNA611476_CONTIG_13194	Carp edema virus	4680	143	36	CLUSTER13_Carp_edema_virus\|165\|64	PRJNA1075480_S_NODE_19_length_10478_cov_35.577415_g8_i0\|Carp_edema_virus\|NR\|1.04e-246\|NA	165	64	PRJNA611476	13194	540	1.740899	9.4008546	Carp edema virus	1653087	Viruses	Viruses	49.3	0.00261	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_13194_length_540_cov_1.740899_g12406_i0	BCT22598.1 hypothetical protein [Carp edema virus]	BCT22598.1	1653087	g12406	i0	36.7	0.544444444	98	47	51.1	3	519	244	219	307	294	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	0.00261
7994	7994	PRJNA611476_CONTIG_62010\|Carp_edema_virus\|CLUSTER13_Carp_edema_virus\|165\|64	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_62010\|Carp_edema_virus	PRJNA611476_CONTIG_62010	Carp edema virus	4680	143	36	CLUSTER13_Carp_edema_virus\|165\|64	PRJNA1075480_S_NODE_19_length_10478_cov_35.577415_g8_i0\|Carp_edema_virus\|NR\|1.04e-246\|NA	165	64	PRJNA611476	62010	281	1.480769	4.16096089	Carp edema virus	1653087	Viruses	Viruses	56.6	7.26e-07	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_62010_length_281_cov_1.480769_g61219_i0	BCT22601.1 hypothetical protein [Carp edema virus]	BCT22601.1	1653087	g61219	i0	61.9	0.448398577	42	16	44.8	0	127	2	82	123	126	56.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	56.6	7.26e-07
8589	8589	PRJNA611476_CONTIG_19913\|Carp_edema_virus\|CLUSTER15_Carp_edema_virus\|92\|41	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_19913\|Carp_edema_virus	PRJNA611476_CONTIG_19913	Carp edema virus	4680	143	36	CLUSTER15_Carp_edema_virus\|92\|41	PRJNA318414_P_NODE_22_length_7797_cov_118.161689_g17_i0\|Carp_edema_virus\|NR\|1.23e-128\|NA	92	41	PRJNA611476	19913	446	1.873995	8.3580177	Carp edema virus	1653087	Viruses	Viruses	58.2	2.53e-07	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_19913_length_446_cov_1.873995_g19122_i0	BCT22687.1 hypothetical protein [Carp edema virus]	BCT22687.1	1653087	g19122	i0	29.2	0.760089686	113	74	74.0	3	441	112	49	158	339	58.2	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	58.2	2.53e-07
8609	8609	PRJNA611476_CONTIG_68052\|Carp_edema_virus\|CLUSTER15_Carp_edema_virus\|92\|41	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_68052\|Carp_edema_virus	PRJNA611476_CONTIG_68052	Carp edema virus	4680	143	36	CLUSTER15_Carp_edema_virus\|92\|41	PRJNA318414_P_NODE_22_length_7797_cov_118.161689_g17_i0\|Carp_edema_virus\|NR\|1.23e-128\|NA	92	41	PRJNA611476	68052	270	1.563452	4.2213204	Carp edema virus	1653087	Viruses	Viruses	67.4	3.92e-11	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_68052_length_270_cov_1.563452_g67261_i0	BCT22683.1 hypothetical protein [Carp edema virus]	BCT22683.1	1653087	g67261	i0	38.5	1.011111111	91	54	98.9	1	1	267	69	159	273	67.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	67.4	3.92e-11
8826	8826	PRJNA611476_CONTIG_9812\|Carp_edema_virus\|CLUSTER18_Carp_edema_virus\|87\|53	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_9812\|Carp_edema_virus	PRJNA611476_CONTIG_9812	Carp edema virus	4680	143	36	CLUSTER18_Carp_edema_virus\|87\|53	PRJNA854078_P_NODE_15_length_5165_cov_11.858209_g9_i0\|Carp_edema_virus\|NR\|2.41e-94\|NA	86	52	PRJNA611476	9812	622	1.112933	6.92244326	Carp edema virus	1653087	Viruses	Viruses	118.0	1.09e-28	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_9812_length_622_cov_1.112933_g9028_i0	BCT22606.1 hypothetical protein AL387_gp060 [Carp edema virus]	BCT22606.1	1653087	g9028	i0	34.6	0.766881029	159	94	75.2	3	100	567	112	263	477	118.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	118.0	1.09e-28
9237	9237	PRJNA611476_CONTIG_44225\|Carp_edema_virus\|CLUSTER22_Carp_edema_virus\|63\|35	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_44225\|Carp_edema_virus	PRJNA611476_CONTIG_44225	Carp edema virus	4680	143	36	CLUSTER22_Carp_edema_virus\|63\|35	PRJNA318414_P_NODE_148_length_2959_cov_89.363823_g94_i0\|Carp_edema_virus\|NR\|2.18e-108\|NA	63	35	PRJNA611476	44225	324	1.135458	3.67888392	Carp edema virus	1653087	Viruses	Viruses	93.2	1.9e-19	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_44225_length_324_cov_1.135458_g43434_i0	BCT22604.1 hypothetical protein AL387_gp058 [Carp edema virus]	BCT22604.1	1653087	g43434	i0	40.2	0.990740741	107	61	99.1	1	321	1	83	186	321	93.2	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	93.2	1.9e-19
9410	9410	PRJNA611476_CONTIG_76682\|Carp_edema_virus\|CLUSTER24_Carp_edema_virus\|59\|38	Zebrafish jaw poxvirus	Novel	PRJNA611476_CONTIG_76682\|Carp_edema_virus	PRJNA611476_CONTIG_76682	Carp edema virus	4680	143	36	CLUSTER24_Carp_edema_virus\|59\|38	PRJEB2894_P_NODE_2_length_9524_cov_24.108758_g1_i0\|Carp_edema_virus\|NR\|4.89e-65\|NA	59	38	PRJNA611476	76682	253	2.305556	5.83305668	Carp edema virus	1653087	Viruses	Viruses	62.8	3.8e-09	Carp edema virus	Non-phage	NR	PRJNA611476_P_NODE_76682_length_253_cov_2.305556_g75891_i0	BCT22715.1 putative membrane-associated glycoprotein [Carp edema virus]	BCT22715.1	1653087	g75891	i0	49.1	0.675889328	57	29	67.6	0	64	234	743	799	171	62.8	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	62.8	3.8e-09

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