metadata: contig_metadata: 29 rows where bioproject = "PRJNA940501" and tax

29 rows where bioproject = "PRJNA940501" and tax_kingdom = "Bamfordvirae"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
920646	920646	PRJNA940501_S_NODE_335501_length_160_cov_1.606838_g334683_i0	PRJNA940501	335501	160	1.606838	2.5709408	Erythrocytic necrosis virus	1543320	Viruses	Viruses	182	1.62e-41	NTclustered	gi\|1624806707\|gb\|MK638720.1\|	1543320	g334683	i0	91.603	16.59375	131	11	82	0	1	131	235	105	Erythrocytic necrosis virus isolate SEQ_18 putative RNA-dependent DNA polymerase mRNA, partial cds	blastn	2655	182	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
2534240	2534240	PRJNA940501_S_NODE_80802_length_252_cov_1.679426_g79984_i0	PRJNA940501	80802	252	1.679426	4.23215352	Alphatectivirus	2169669	Viruses	Viruses	424	4.2e-114	NTclustered	gi\|2693686684\|gb\|PP412828.1\|	3127592	g79984	i0	100	54.8849206349206	229	0	91	0	1	229	1612	1840	Enterobacteria phage PRDcobalt, complete genome	blastn	13831	424	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Enterobacteria phage PRDcobalt
4747759	4747759	PRJNA940501_S_NODE_226004_length_185_cov_1.535211_g225186_i0	PRJNA940501	226004	185	1.535211	2.84014035	Parapoxvirus orf	3431389	Viruses	Viruses	52.8	0.016	NTclustered	gi\|325073632\|gb\|HM133903.1\|	10258	g225186	i0	100	0.151351351351351	28	0	15	0	2	29	133678	133705	Orf virus strain D1701, complete genome	blastn	28	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Parapoxvirus	Parapoxvirus orf
5085740	5085740	PRJNA940501_S_NODE_168504_length_204_cov_1.167702_g167686_i0	PRJNA940501	168504	204	1.167702	2.38211208	Deltaentomopoxvirus	2733302	Viruses	Viruses	52.8	0.018	NTclustered	gi\|9631294\|ref\|NC_001993.1\|	83191	g167686	i0	100	0.274509803921569	28	0	14	0	22	49	192478	192505	Melanoplus sanguinipes entomopoxvirus, complete genome	blastn	56	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Deltaentomopoxvirus	Deltaentomopoxvirus msanguinipes
6020686	6020686	PRJNA940501_S_NODE_103405_length_236_cov_0.984456_g102587_i0	PRJNA940501	103405	236	0.984456	2.32331616	Erythrocytic necrosis virus	1543320	Viruses	Viruses	361	3.1e-95	NTclustered	gi\|1624806635\|gb\|MK638688.1\|	1543320	g102587	i0	93.878	7.16101694915254	245	6	100	2	1	236	152	396	Erythrocytic necrosis virus isolate SEQ_16 hypothetical protein mRNA, partial cds	blastn	1690	361	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
7636028	7636028	PRJNA940501_S_NODE_274326_length_173_cov_1.084615_g273508_i0	PRJNA940501	274326	173	1.084615	1.87638395	Mimiviridae	549779	Viruses	Viruses	52.8	0.015	NTclustered	gi\|363539767\|ref\|NC_016072.1\|	1094892	g273508	i0	100	1.45664739884393	28	0	16	0	138	165	862557	862584	Megavirus chiliensis, complete genome	blastn	252	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus chilense
8571304	8571304	PRJNA940501_S_NODE_158407_length_208_cov_1.169697_g157589_i0	PRJNA940501	158407	208	1.169697	2.43296976	Erythrocytic necrosis virus	1543320	Viruses	Viruses	340	3.4699999999999996e-89	NTclustered	gi\|1624806662\|gb\|MK638698.1\|	1543320	g157589	i0	96.154	5.84615384615385	208	8	100	0	1	208	375	168	Erythrocytic necrosis virus isolate SEQ_13 putative RNA-dependent DNA polymerase mRNA, complete cds	blastn	1216	340	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
8575204	8575204	PRJNA940501_S_NODE_95487_length_241_cov_1.595960_g94669_i0	PRJNA940501	95487	241	1.59596	3.8462636	Edafosvirus sp.	2487765	Viruses	Viruses	111	1.02e-26	NR	AYV78014.1	2487765	g94669	i0	63.8	1.9792531120332	80	29	99.6	0	240	1	371	450	AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.]	diamond	477	111	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Edafosvirus sp.
9848113	9848113	PRJNA940501_S_NODE_275348_length_172_cov_15.372093_g274530_i0	PRJNA940501	275348	172	15.372093	26.43999996	Orthopoxvirus monkeypox	3431483	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2309594316\|gb\|OP536747.1\|	10244	g274530	i0	100	16.8604651162791	29	0	17	0	69	97	119302	119274	Monkeypox virus isolate 9000365, partial genome	blastn	2900	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Orthopoxvirus	Orthopoxvirus monkeypox
17498330	17498330	PRJNA940501_S_NODE_271914_length_173_cov_2.092308_g271096_i0	PRJNA940501	271914	173	2.092308	3.61969284	Megavirus baoshanense	3060196	Viruses	Viruses	54.7	0.004	NTclustered	gi\|2500365504\|ref\|NC_075367.1\|	2496520	g271096	i0	100	0.167630057803468	29	0	17	0	23	51	218853	218825	Megavirus baoshan strain SH, complete genome	blastn	29	54.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus baoshanense
17835477	17835477	PRJNA940501_S_NODE_314614_length_164_cov_1.752066_g313796_i0	PRJNA940501	314614	164	1.752066	2.87338824	Alphatectivirus	2169669	Viruses	Viruses	298	1.59e-76	NTclustered	gi\|2693687230\|gb\|PP412836.1\|	3127600	g313796	i0	99.39	65.0975609756098	164	1	100	0	1	164	1173	1336	Enterobacteria phage PRDhazel, complete genome	blastn	10676	298	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae		Enterobacteria phage PRDhazel
21321424	21321424	PRJNA940501_S_NODE_22197_length_352_cov_194.673139_g21379_i0	PRJNA940501	22197	352	194.673139	685.24944928	Betaentomopoxvirus amoorei	28321	Viruses	Viruses	52.8	0.033	NTclustered	gi\|9964314\|ref\|NC_002520.1\|	28321	g21379	i0	94.286	0.0994318181818182	35	1	10	1	211	244	153509	153475	Amsacta moorei entomopoxvirus 'L', complete genome	blastn	35	52.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Pokkesviricetes	Chitovirales	Poxviridae	Betaentomopoxvirus	Betaentomopoxvirus amoorei
24209076	24209076	PRJNA940501_S_NODE_178839_length_200_cov_1.496815_g178021_i0	PRJNA940501	178839	200	1.496815	2.99363	Alphatectivirus	2169669	Viruses	Viruses	370	4.22e-98	NTclustered	gi\|2127008276\|gb\|OK041468.1\|	2884452	g178021	i0	100	73	200	0	100	0	1	200	1468	1667	Burkholderia phage BCE1, complete genome	blastn	14600	370	1	Viruses	Bamfordvirae	Preplasmiviricota	Tectiliviricetes	Kalamavirales	Tectiviridae	Alphatectivirus	Alphatectivirus PRD1
26771976	26771976	PRJNA940501_S_NODE_107261_length_233_cov_1.968421_g106443_i0	PRJNA940501	107261	233	1.968421	4.58642093	Tupanvirus soda lake	2126985	Viruses	Viruses	88.2	2.91e-18	NR	YP_010782467.1	2126985	g106443	i0	65.7	0.862660944206009	67	22	86.3	1	216	16	422	487	YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake]	diamond	201	88.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
27689060	27689060	PRJNA940501_S_NODE_7024_length_557_cov_21.217899_g6313_i0	PRJNA940501	7024	557	21.217899	118.18369743	Tupanvirus soda lake	2126985	Viruses	Viruses	107	5.77e-25	NR	YP_010782214.1	2126985	g6313	i0	43.7	0.727109515260323	135	61	72.2	5	556	155	76	196	YP_010782214.1 exonuclease [Tupanvirus soda lake]	diamond	405	107	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
28004625	28004625	PRJNA940501_S_NODE_2745_length_1385_cov_8.323398_g2533_i0	PRJNA940501	2745	1385	8.323398	115.2790623	Bodo saltans virus	2024608	Viruses	Viruses	229	2.38e-69	NR	YP_010778932.1	2024608	g2533	i0	70.9	0.327075812274368	151	44	32.7	0	28	480	37	187	YP_010778932.1 N6-adenine methyltransferase [Bodo saltans virus]	diamond	453	229	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Theiavirus	Theiavirus salishense
28793545	28793545	PRJNA940501_S_NODE_185067_length_198_cov_1.212903_g184249_i0	PRJNA940501	185067	198	1.212903	2.40154794	Pimephales minnow adintovirus	2609864	Viruses	Viruses	68.6	1.37e-11	NR	DAC81401.1	2609864	g184249	i0	53.1	2.90909090909091	64	30	97	0	5	196	98	161	DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus]	diamond	576	68.6	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
29488175	29488175	PRJNA940501_S_NODE_77610_length_255_cov_1.108491_g76792_i0	PRJNA940501	77610	255	1.108491	2.82665205	Hyperionvirus sp.	2487770	Viruses	Viruses	63.2	2.86e-9	NR	AYV84279.1	2487770	g76792	i0	43.4	0.894117647058824	76	41	89.4	1	4	231	95	168	AYV84279.1 MAG: endonuclease/exonuclease/phosphatase family [Hyperionvirus sp.]	diamond	228	63.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
29677433	29677433	PRJNA940501_S_NODE_312890_length_164_cov_19.289256_g312072_i0	PRJNA940501	312890	164	19.289256	31.63437984	Pimephales minnow adintovirus	2609864	Viruses	Viruses	58.2	2.71e-8	NR	DAC81394.1	2609864	g312072	i0	69.4	0.658536585365854	36	11	65.9	0	108	1	7	42	DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus]	diamond	108	58.2	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Pimephales minnow adintovirus
29835610	29835610	PRJNA940501_S_NODE_291731_length_169_cov_1.277778_g290913_i0	PRJNA940501	291731	169	1.277778	2.15944482	Erythrocytic necrosis virus	1543320	Viruses	Viruses	76.3	6.55e-16	NR	QCF47477.1	1543320	g290913	i0	68	1.77514792899408	50	16	88.8	0	2	151	89	138	QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	300	76.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
30316947	30316947	PRJNA940501_S_NODE_17572_length_378_cov_3.865672_g16755_i0	PRJNA940501	17572	378	3.865672	14.61224016	Tupanvirus	2094720	Viruses	Viruses	121	1.83e-30	NR	YP_010781083.1	2126984	g16755	i0	55.9	1.63492063492063	102	44	81	1	362	57	223	323	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	618	122	0.991803278688525	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
30751979	30751979	PRJNA940501_S_NODE_213154_length_189_cov_1.287671_g212336_i0	PRJNA940501	213154	189	1.287671	2.43369819	Hyperionvirus sp.	2487770	Viruses	Viruses	72.4	5.81e-14	NR	AYV84438.1	2487770	g212336	i0	53.4	0.920634920634921	58	27	92.1	0	184	11	11	68	AYV84438.1 MAG: hypothetical protein Hyperionvirus25_24 [Hyperionvirus sp.]	diamond	174	72.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
31036592	31036592	PRJNA940501_S_NODE_7015_length_558_cov_4.219417_g6304_i0	PRJNA940501	7015	558	4.219417	23.54434686	Hyperionvirus sp.	2487770	Viruses	Viruses	91.7	1.01e-18	NR	AYV83005.1	2487770	g6304	i0	44.7	0.553763440860215	103	54	54.8	2	1	306	159	259	AYV83005.1 MAG: YchF/TatD family DNA exonuclease [Hyperionvirus sp.]	diamond	309	91.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
31384161	31384161	PRJNA940501_S_NODE_8736_length_498_cov_3.017582_g7958_i0	PRJNA940501	8736	498	3.017582	15.02755836	Terrestrivirus sp.	2487775	Viruses	Viruses	91.7	1.5e-18	NR	AYV75160.1	2487775	g7958	i0	38	0.728915662650602	121	64	72.3	2	494	135	229	339	AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.]	diamond	363	91.7	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31479087	31479087	PRJNA940501_S_NODE_25916_length_337_cov_5.982993_g25098_i0	PRJNA940501	25916	337	5.982993	20.16268641	Marseillevirus LCMAC1	2506602	Viruses	Viruses	47	0.00285	NR	QBK85868.1	2506602	g25098	i0	40	1.01483679525223	60	32	53.4	2	6	185	106	161	QBK85868.1 MAG: hypothetical protein LCMAC101_04630 [Marseillevirus LCMAC101]	diamond	342	47	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Marseilleviridae		Marseillevirus LCMAC101
31573942	31573942	PRJNA940501_S_NODE_185716_length_198_cov_0.909677_g184898_i0	PRJNA940501	185716	198	0.909677	1.80116046	Larimichthys croaker adintovirus	2609857	Viruses	Viruses	53.1	4.17e-6	NR	DBA47690.1	2609857	g184898	i0	59.5	2.5	37	12	51.5	1	107	6	276	312	DBA47690.1 MAG TPA_asm: Integrase [Adintovirus homo13306]	diamond	495	53.1	1	Viruses	Bamfordvirae	Preplasmiviricota	Polintoviricetes	Orthopolintovirales	Adintoviridae		Larimichthys croaker adintovirus
32466770	32466770	PRJNA940501_S_NODE_43779_length_294_cov_4.505976_g42961_i0	PRJNA940501	43779	294	4.505976	13.24756944	Tupanvirus	2094720	Viruses	Viruses	97.1	1.14e-21	NR	YP_010781083.1	2126984	g42961	i0	56.6	1.69387755102041	83	35	84.7	1	294	46	242	323	YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean]	diamond	498	97.1	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
32617591	32617591	PRJNA940501_S_NODE_399740_length_150_cov_1.056075_g398922_i0	PRJNA940501	399740	150	1.056075	1.5841125	Erythrocytic necrosis virus	1543320	Viruses	Viruses	95.9	4.83e-24	NR	QCF47486.1	1543320	g398922	i0	92	2	50	4	100	0	1	150	50	99	QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus]	diamond	300	95.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus
32711988	32711988	PRJNA940501_S_NODE_230700_length_184_cov_1.007092_g229882_i0	PRJNA940501	230700	184	1.007092	1.85304928	Erythrocytic necrosis virus	1543320	Viruses	Viruses	58.9	4.74e-9	NR	QCF47477.1	1543320	g229882	i0	74.3	1.14130434782609	35	9	57.1	0	159	55	89	123	QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus]	diamond	210	58.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Pimascovirales	Iridoviridae		Erythrocytic necrosis virus

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;