metadata: contig_metadata: 28 rows where bioproject = "PRJNA1122875" and tax

28 rows where bioproject = "PRJNA1122875" 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
11755896	11755896	PRJNA1122875_P_NODE_10670_length_508_cov_1.949425_g10449_i0	PRJNA1122875	10670	508	1.949425	9.903079	Prasinovirus	181084	Viruses	Viruses	145	3.02e-38	NR	QIG59965.1	2704072	g10449	i0	48.3	2.46259842519685	149	74	86.8	3	508	68	252	399	QIG59965.1 ornithine decarboxylase [Dishui Lake phycodnavirus 4]	diamond	1251	145	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae		Dishui Lake phycodnavirus 4
26848803	26848803	PRJNA1122875_P_NODE_31901_length_289_cov_2.379630_g31677_i0	PRJNA1122875	31901	289	2.37963	6.8771307	Fadolivirus algeromassiliense	3060017	Viruses	Viruses	47.4	0.00129	NR	YP_010803114.1	3060017	g31677	i0	53.8	0.404844290657439	39	18	40.5	0	148	264	213	251	YP_010803114.1 ubiquitin protein [Fadolivirus algeromassiliense]	diamond	117	47.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Fadolivirus	Fadolivirus algeromassiliense
27291458	27291458	PRJNA1122875_P_NODE_31963_length_289_cov_1.833333_g31739_i0	PRJNA1122875	31963	289	1.833333	5.29833237	Klosneuvirus KNV1	1977640	Viruses	Viruses	144	5.71e-40	NR	ARF11950.1	1977640	g31739	i0	65.6	1.99307958477509	96	33	99.7	0	288	1	82	177	ARF11950.1 elongation factor Tu EF-Tu-like protein [Klosneuvirus KNV1]	diamond	576	144	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
27796858	27796858	PRJNA1122875_P_NODE_26304_length_322_cov_4.192771_g26080_i0	PRJNA1122875	26304	322	4.192771	13.50072262	Mimiviridae sp. ChoanoV1	2596887	Viruses	Viruses	99.8	2.4099999999999998e-24	NR	QDY52159.1	2596887	g26080	i0	42.1	1.88198757763975	107	62	99.7	0	322	2	9	115	QDY52159.1 hypothetical protein 4_39 [Mimiviridae sp. ChoanoV1]	diamond	606	99.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae		Mimiviridae sp. ChoanoV1
27859688	27859688	PRJNA1122875_P_NODE_3745_length_783_cov_1.707042_g3554_i0	PRJNA1122875	3745	783	1.707042	13.36613886	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	236	1.05e-73	NR	VBB18130.1	2420051	g3554	i0	49.4	0.915708812260536	239	109	87.4	3	3	686	36	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	717	236	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
27859708	27859708	PRJNA1122875_P_NODE_4925_length_704_cov_3.877971_g4718_i0	PRJNA1122875	4925	704	3.877971	27.30091584	Barrevirus sp.	2487763	Viruses	Viruses	49.3	0.00156	NR	AYV77266.1	2487763	g4718	i0	36.5	0.409090909090909	96	53	40.9	4	488	201	45	132	AYV77266.1 MAG: hypothetical protein Barrevirus25_9 [Barrevirus sp.]	diamond	288	49.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Barrevirus sp.
27986120	27986120	PRJNA1122875_P_NODE_33945_length_283_cov_1.690476_g33721_i0	PRJNA1122875	33945	283	1.690476	4.78404708	Megaviridae environmental sample	1737588	Viruses	Viruses	61.6	1.37e-8	NR	QFG74431.1	1737588	g33721	i0	64.1	0.413427561837456	39	14	41.3	0	152	268	514	552	QFG74431.1 MAG: asparagine synthase [Megaviridae environmental sample]	diamond	117	61.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
28080716	28080716	PRJNA1122875_P_NODE_12265_length_475_cov_2.542289_g12042_i0	PRJNA1122875	12265	475	2.542289	12.07587275	Mimiviridae sp. ChoanoV1	2596887	Viruses	Viruses	82	3.61e-16	NR	QDY52260.1	2596887	g12042	i0	38.4	0.707368421052632	112	64	68.2	2	1	324	21	131	QDY52260.1 hypothetical protein 5_57 [Mimiviridae sp. ChoanoV1]	diamond	336	82	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Schizomimiviridae		Mimiviridae sp. ChoanoV1
28112316	28112316	PRJNA1122875_P_NODE_3205_length_829_cov_1.808201_g1411_i1	PRJNA1122875	3205	829	1.808201	14.98998629	Megaviridae environmental sample	1737588	Viruses	Viruses	109	1.49e-24	NR	QFG74608.1	1737588	g1411	i1	30.7	0.788902291917973	218	133	73.1	5	678	73	11	226	QFG74608.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	654	109	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
28333416	28333416	PRJNA1122875_P_NODE_36566_length_274_cov_1.736318_g36342_i0	PRJNA1122875	36566	274	1.736318	4.75751132	Catovirus sp. 'naegleriensis'	3072188	Viruses	Viruses	44.3	0.00358	NR	CAK7597252.1	3072188	g36342	i0	46.5	0.470802919708029	43	23	47.1	0	145	273	6	48	CAK7597252.1 SET domain containing protein [Catovirus sp. 'naegleriensis']	diamond	129	44.3	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Catovirus	Catovirus sp. 'naegleriensis'
28933374	28933374	PRJNA1122875_P_NODE_1448_length_1074_cov_5.694306_g1306_i1	PRJNA1122875	1448	1074	5.694306	61.15684644	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	267	2.45e-84	NR	VBB18130.1	2420051	g1306	i1	50.2	0.723463687150838	259	117	69.3	3	131	874	16	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	777	267	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
28933415	28933415	PRJNA1122875_P_NODE_3828_length_778_cov_1.849645_g3636_i0	PRJNA1122875	3828	778	1.849645	14.3902381	Pyramimonas orientalis virus	455367	Viruses	Viruses	87.8	1.36e-16	NR	QOI90644.1	455367	g3636	i0	36.3	1.27249357326478	157	90	57.8	3	763	314	98	251	QOI90644.1 hypothetical protein HWQ62_00513 [Pyramimonas orientalis virus]	diamond	990	87.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Allomimiviridae	Heliosvirus	Heliosvirus raunefjordenense
29596105	29596105	PRJNA1122875_P_NODE_8690_length_557_cov_2.130165_g8471_i0	PRJNA1122875	8690	557	2.130165	11.86501905	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	127	2.58e-32	NR	VBB18130.1	2420051	g8471	i0	46.2	0.700179533213645	130	60	64.6	1	434	75	20	149	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	390	127	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
29690746	29690746	PRJNA1122875_P_NODE_1530_length_1054_cov_1.967380_g1411_i0	PRJNA1122875	1530	1054	1.96738	20.7361852	Megaviridae environmental sample	1737588	Viruses	Viruses	110	2.65e-24	NR	QFG74608.1	1737588	g1411	i0	29.8	0.620493358633776	218	135	57.5	5	152	757	11	226	QFG74608.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	654	110	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
29880775	29880775	PRJNA1122875_P_NODE_25751_length_326_cov_2.130435_g25527_i0	PRJNA1122875	25751	326	2.130435	6.9452181	Pyramimonas orientalis virus	455367	Viruses	Viruses	138	1.68e-39	NR	QOI90451.1	455367	g25527	i0	60.2	0.993865030674847	108	42	99.4	1	324	1	1	107	QOI90451.1 hypothetical protein HWQ62_00315 [Pyramimonas orientalis virus]	diamond	324	138	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Allomimiviridae	Heliosvirus	Heliosvirus raunefjordenense
29943943	29943943	PRJNA1122875_P_NODE_951_length_1227_cov_3.001733_g862_i0	PRJNA1122875	951	1227	3.001733	36.83126391	Indivirus ILV1	1977633	Viruses	Viruses	68.2	1.05e-9	NR	ARF09883.1	1977633	g862	i0	44.2	0.188264058679707	77	41	18.3	2	273	497	65	141	ARF09883.1 hypothetical protein Indivirus_5_6 [Indivirus ILV1]	diamond	231	68.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
30765264	30765264	PRJNA1122875_P_NODE_45654_length_249_cov_0.875000_g45430_i0	PRJNA1122875	45654	249	0.875	2.17875	Tupanvirus soda lake	2126985	Viruses	Viruses	43.9	0.0156	NR	YP_010781858.1	2126985	g45430	i0	31.8	0.795180722891566	66	44	79.5	1	234	37	287	351	YP_010781858.1 FAD-binding oxidoreductase [Tupanvirus soda lake]	diamond	198	43.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
30859992	30859992	PRJNA1122875_P_NODE_1414_length_1082_cov_2.012884_g1300_i0	PRJNA1122875	1414	1082	2.012884	21.77940488	Ostreococcus lucimarinus virus 7	1663209	Viruses	Viruses	72.4	3.53e-10	NR	YP_009173118.1	1663209	g1300	i0	25.8	1.52218114602588	178	94	49.1	3	547	1077	99	239	YP_009173118.1 hypothetical protein AP054_gp106 [Ostreococcus lucimarinus virus 7]	diamond	1647	72.4	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus lucimarinus virus 7
31112557	31112557	PRJNA1122875_P_NODE_18215_length_391_cov_1.305031_g17991_i0	PRJNA1122875	18215	391	1.305031	5.10267121	Hyperionvirus sp.	2487770	Viruses	Viruses	55.5	6.92e-6	NR	AYV82971.1	2487770	g17991	i0	34.9	0.636828644501279	83	51	61.4	1	4	243	207	289	AYV82971.1 MAG: hypothetical protein Hyperionvirus3_117 [Hyperionvirus sp.]	diamond	249	55.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Hyperionvirus sp.
31365941	31365941	PRJNA1122875_P_NODE_5396_length_677_cov_1.839404_g5185_i0	PRJNA1122875	5396	677	1.839404	12.45276508	Megaviridae environmental sample	1737588	Viruses	Viruses	103	4.4899999999999997e-23	NR	QFG74608.1	1737588	g5185	i0	31.4	0.846381093057607	191	113	77.5	4	656	132	38	226	QFG74608.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	573	103	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
31587286	31587286	PRJNA1122875_P_NODE_12276_length_475_cov_1.915423_g12053_i0	PRJNA1122875	12276	475	1.915423	9.09825925	Chlorovirus illinoense	3427929	Viruses	Viruses	155	6.249999999999999e-45	NR	3CA9_A	46019	g12053	i0	64.1	5.77263157894737	131	46	82.1	1	470	81	26	156	3CA9_A Chain A, Deoxyuridine triphosphatase [Paramecium bursaria Chlorella virus IL3A]	diamond	2742	155	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus illinoense
31840033	31840033	PRJNA1122875_P_NODE_53177_length_241_cov_1.720238_g52953_i0	PRJNA1122875	53177	241	1.720238	4.14577358	Gaeavirus sp.	2487767	Viruses	Viruses	66.2	1.42e-10	NR	AYV80060.1	2487767	g52953	i0	40.3	0.95850622406639	77	45	95.9	1	3	233	240	315	AYV80060.1 MAG: hypothetical protein Gaeavirus7_17 [Gaeavirus sp.]	diamond	231	66.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Gaeavirus sp.
31871728	31871728	PRJNA1122875_P_NODE_28077_length_310_cov_2.232068_g27853_i0	PRJNA1122875	28077	310	2.232068	6.9194108	Moumouvirus maliensis	2682469	Viruses	Viruses	62	1.33e-8	NR	QGR54390.1	2682469	g27853	i0	41.9	0.716129032258065	74	43	71.6	0	47	268	336	409	QGR54390.1 putative transposase [Moumouvirus maliensis]	diamond	222	62	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'maliensis'
32030106	32030106	PRJNA1122875_P_NODE_33478_length_285_cov_1.089623_g33254_i0	PRJNA1122875	33478	285	1.089623	3.10542555	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	101	8.66e-24	NR	VBB18130.1	2420051	g33254	i0	58.9	0.768421052631579	73	30	76.8	0	273	55	201	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	219	101	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32251770	32251770	PRJNA1122875_P_NODE_11078_length_499_cov_2.281690_g10857_i0	PRJNA1122875	11078	499	2.28169	11.3856331	Megaviridae environmental sample	1737588	Viruses	Viruses	73.9	1.86e-12	NR	QFG74608.1	1737588	g10857	i0	29.4	1.70140280561122	170	104	93.2	3	31	495	40	208	QFG74608.1 MAG: hypothetical protein [Megaviridae environmental sample]	diamond	849	73.9	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
32409750	32409750	PRJNA1122875_P_NODE_14679_length_435_cov_3.767956_g14455_i0	PRJNA1122875	14679	435	3.767956	16.3906086	Ostreococcus tauri virus 1	642926	Viruses	Viruses	135	1.5999999999999998e-36	NR	YP_003212949.1	642926	g14455	i0	50.7	3.9172413793103402	142	61	97.9	3	428	3	25	157	YP_003212949.1 exonuclease [Ostreococcus tauri virus 1]	diamond	1704	135	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Prasinovirus	Ostreococcus tauri virus 1
32819756	32819756	PRJNA1122875_P_NODE_1420_length_1080_cov_6.126117_g1306_i0	PRJNA1122875	1420	1080	6.126117	66.1620636	Yasminevirus sp. GU-2	3060817	Viruses	Viruses	266	5.25e-84	NR	VBB18130.1	2420051	g1306	i0	51	0.713888888888889	257	114	68.3	3	938	201	18	273	VBB18130.1 Piso0_000558 [Yasminevirus sp. GU-2018]	diamond	771	266	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Yasminevirus	Yasminevirus saudimassiliense
32882616	32882616	PRJNA1122875_P_NODE_29380_length_302_cov_1.834061_g29156_i0	PRJNA1122875	29380	302	1.834061	5.53886422	Pyramimonas orientalis virus	455367	Viruses	Viruses	60.8	1.44e-8	NR	QOI90527.1	455367	g29156	i0	34.7	1.94701986754967	95	50	94.4	3	286	2	70	152	QOI90527.1 hypothetical protein HWQ62_00392 [Pyramimonas orientalis virus]	diamond	588	60.8	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Allomimiviridae	Heliosvirus	Heliosvirus raunefjordenense

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