metadata: contig_metadata: 26 rows where bioproject = "PRJNA515078" and tax

26 rows where bioproject = "PRJNA515078" and tax_superkingdom = "Viruses"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4939249	4939249	PRJNA515078_P_NODE_4724_length_440_cov_1.451613_g4491_i0	PRJNA515078	4724	440	1.451613	6.3870972	root	1	Root_unresolved	Root_unresolved	811	0	NTclustered	gi\|1803061242\|dbj\|LC375022.1\|	12211	g4491	i0	100	99.7681818181818	439	0	99	0	1	439	7917	8355	Plum pox virus PPV-D Kg5 genomic RNA, complete genome	blastn	43898	811	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
10039483	10039483	PRJNA515078_P_NODE_21008_length_189_cov_1.565789_g20775_i0	PRJNA515078	21008	189	1.565789	2.95934121	Moumouvirus	3080801	Viruses	Viruses	78.7	2.68e-10	NTclustered	gi\|371944806\|gb\|JN885998.1\|	1128131	g20775	i0	90	1.37566137566138	60	6	32	0	4	63	146231	146172	Moumouvirus Monve isolate Mv13-mv, partial genome	blastn	260	78.7	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Moumouvirus	Moumouvirus sp. 'Monve'
10039528	10039528	PRJNA515078_P_NODE_608_length_1207_cov_5.194872_g521_i0	PRJNA515078	608	1207	5.194872	62.70210504	root	1	Root_unresolved	Root_unresolved	2230	0	NTclustered	gi\|333301\|gb\|M21847.1\|PPVCPOL	12211	g521	i0	100	99.1267605633803	1207	0	100	0	1	1207	2852	1646	Plum pox potyvirus (PPV) capsid protein and RNA polymerase genes, complete cds	blastn	119646	2230	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
12589879	12589879	PRJNA515078_P_NODE_18030_length_205_cov_1.392857_g17797_i0	PRJNA515078	18030	205	1.392857	2.85535685	root	1	Root_unresolved	Root_unresolved	379	7.229999999999999e-101	NTclustered	gi\|1803061108\|dbj\|LC374955.1\|	12211	g17797	i0	100	100	205	0	100	0	1	205	5851	6055	Plum pox virus PPV-D Ad2 genomic RNA, complete genome	blastn	20500	379	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
13864713	13864713	PRJNA515078_P_NODE_18611_length_201_cov_1.621951_g18378_i0	PRJNA515078	18611	201	1.621951	3.26012151	root	1	Root_unresolved	Root_unresolved	372	1.18e-98	NTclustered	gi\|333303\|gb\|M26965.1\|PPVNIAPRO	12211	g18378	i0	100	100	201	0	100	0	1	201	855	1055	Plum pox potyvirus ORF containing NI-a-like protein mRNA, partial cds	blastn	20100	372	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
13864741	13864741	PRJNA515078_P_NODE_25871_length_171_cov_1.164179_g25638_i0	PRJNA515078	25871	171	1.164179	1.99074609	root	1	Root_unresolved	Root_unresolved	316	4.6e-82	NTclustered	gi\|1803061751\|dbj\|LC375125.1\|	12211	g25638	i0	100	100	171	0	100	0	1	171	6890	6720	Plum pox virus PPV-D Wa7 genomic RNA, complete genome	blastn	17100	316	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
15789501	15789501	PRJNA515078_P_NODE_16593_length_214_cov_1.502825_g16360_i0	PRJNA515078	16593	214	1.502825	3.2160455	Potyvirus euphorbiae	3240527	Viruses	Viruses	381	2.1199999999999995e-101	NTclustered	gi\|1079485077\|ref\|NC_031339.1\|	291286	g16360	i0	98.598	3	214	3	100	0	1	214	8747	8534	Euphorbia ringspot virus isolate PV-0902, complete genome	blastn	642	381	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus euphorbiae
18338479	18338479	PRJNA515078_P_NODE_18835_length_200_cov_1.429448_g18602_i0	PRJNA515078	18835	200	1.429448	2.858896	Potyvirus euphorbiae	3240527	Viruses	Viruses	364	1.96e-96	NTclustered	gi\|1079485077\|ref\|NC_031339.1\|	291286	g18602	i0	99.5	3	200	1	100	0	1	200	8990	9189	Euphorbia ringspot virus isolate PV-0902, complete genome	blastn	600	364	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus euphorbiae
19612956	19612956	PRJNA515078_P_NODE_31936_length_155_cov_1.644068_g31703_i0	PRJNA515078	31936	155	1.644068	2.5483054	Potyvirus euphorbiae	3240527	Viruses	Viruses	287	3.21e-73	NTclustered	gi\|1079485077\|ref\|NC_031339.1\|	291286	g31703	i0	100	5	155	0	100	0	1	155	9529	9683	Euphorbia ringspot virus isolate PV-0902, complete genome	blastn	775	287	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus euphorbiae
20237412	20237412	PRJNA515078_P_NODE_30176_length_159_cov_1.278689_g29943_i0	PRJNA515078	30176	159	1.278689	2.03311551	root	1	Root_unresolved	Root_unresolved	294	1.98e-75	NTclustered	gi\|1803061108\|dbj\|LC374955.1\|	12211	g29943	i0	100	100	159	0	100	0	1	159	7577	7419	Plum pox virus PPV-D Ad2 genomic RNA, complete genome	blastn	15900	294	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus plumpoxi
24712852	24712852	PRJNA515078_P_NODE_15060_length_226_cov_1.407407_g14827_i0	PRJNA515078	15060	226	1.407407	3.18073982	Plotvirus plot	2170099	Viruses	Viruses	62.1	3.34e-5	NTclustered	gi\|1720702708\|gb\|MN119378.1\|	2596982	g14827	i0	91.489	0.805309734513274	47	1	19	2	155	198	45867	45913	Mycobacterium phage Penelope2018, complete genome	blastn	182	62.1	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes			Plotvirus	Plotvirus plot
24712950	24712950	PRJNA515078_P_NODE_28240_length_164_cov_1.228346_g28007_i0	PRJNA515078	28240	164	1.228346	2.01448744	Potyvirus euphorbiae	3240527	Viruses	Viruses	303	3.42e-78	NTclustered	gi\|1079485077\|ref\|NC_031339.1\|	291286	g28007	i0	100	2	164	0	100	0	1	164	368	205	Euphorbia ringspot virus isolate PV-0902, complete genome	blastn	328	303	1	Viruses		Orthornavirae	Pisuviricota	Stelpaviricetes	Patatavirales	Potyviridae	Potyvirus	Potyvirus euphorbiae
26728574	26728574	PRJNA515078_P_NODE_4481_length_454_cov_2.705036_g4249_i0	PRJNA515078	4481	454	2.705036	12.28086344	Tupanvirus deep ocean	2126984	Viruses	Viruses	77.8	9.45e-14	NR	YP_010780356.1	2126984	g4249	i0	29.1	0.977973568281938	148	105	97.8	0	2	445	148	295	YP_010780356.1 hypothetical protein QJ856_gp1009 [Tupanvirus deep ocean]	diamond	444	77.8	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus altamarinense
27772360	27772360	PRJNA515078_P_NODE_20264_length_193_cov_1.000000_g20031_i0	PRJNA515078	20264	193	1	1.93	Caudoviricetes sp.	2832643	Viruses	Viruses	44.3	0.00564	NR	DAR07133.1	2832643	g20031	i0	47.8	0.715025906735751	46	22	71.5	2	26	163	726	769	DAR07133.1 MAG TPA: minor tail protein, partial [Caudoviricetes sp.]	diamond	138	44.3	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28482186	28482186	PRJNA515078_P_NODE_10926_length_272_cov_1.034043_g10693_i0	PRJNA515078	10926	272	1.034043	2.81259696	root	1	Root_unresolved	Root_unresolved	42.4	0.0118	NR	NP_047769.1	10449	g10693	i0	45.5	1.73161764705882	33	18	36.4	0	110	12	1	33	NP_047769.1 LdOrf-132 [Lymantria dispar multiple nucleopolyhedrovirus]	diamond	471	42.7	0.992974238875878	Viruses				Naldaviricetes	Lefavirales	Baculoviridae	Alphabaculovirus	Alphabaculovirus lydisparis
29161627	29161627	PRJNA515078_P_NODE_15589_length_222_cov_0.951351_g15356_i0	PRJNA515078	15589	222	0.951351	2.11199922	Pithovirus LCPAC3	2506594	Viruses	Viruses	68.9	1.65e-11	NR	QBK92355.1	2506594	g15356	i0	63	1.66216216216216	54	20	73	0	163	2	1191	1244	QBK92355.1 MAG: DEAD-like helicase family protein [Pithovirus LCPAC304]	diamond	369	68.9	1	Viruses	Pithoviruses							Pithovirus LCPAC304
29413891	29413891	PRJNA515078_P_NODE_3029_length_559_cov_2.013410_g2805_i0	PRJNA515078	3029	559	2.01341	11.2549619	Emiliania huxleyi virus 2	181208	Viruses	Viruses	60.1	9.03e-7	NR	AEP15724.1	181214	g2805	i0	34.3	0.56350626118068	105	65	56.4	2	35	349	814	914	AEP15724.1 hypothetical protein EQVG_00314 [Emiliania huxleyi virus 207]	diamond	315	60.1	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 207
30267096	30267096	PRJNA515078_P_NODE_9972_length_287_cov_1.084000_g9739_i0	PRJNA515078	9972	287	1.084	3.11108	Klosneuvirus KNV1	1977640	Viruses	Viruses	155	4.0799999999999996e-43	NR	ARF12058.1	1977640	g9739	i0	70.5	4.96515679442509	95	28	99.3	0	286	2	248	342	ARF12058.1 aminotransferase class-III [Klosneuvirus KNV1]	diamond	1425	155	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Klosneuvirus	Klosneuvirus KNV1
30677354	30677354	PRJNA515078_P_NODE_6613_length_364_cov_1.920489_g6380_i0	PRJNA515078	6613	364	1.920489	6.99057996	Terrestrivirus sp.	2487775	Viruses	Viruses	119	1.61e-30	NR	AYV76623.1	2487775	g6380	i0	44.8	1.03021978021978	125	62	98.1	3	6	362	1	124	AYV76623.1 MAG: hypothetical protein Terrestrivirus10_7 [Terrestrivirus sp.]	diamond	375	119	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Terrestrivirus sp.
31056970	31056970	PRJNA515078_P_NODE_20875_length_190_cov_1.222222_g20642_i0	PRJNA515078	20875	190	1.222222	2.3222218	Xanthomonas phage XaC1	3073039	Viruses	Viruses	66.6	5.17e-11	NR	WNA15848.1	3073039	g20642	i0	46.8	0.978947368421053	62	33	97.9	0	190	5	25	86	WNA15848.1 hypothetical protein XaC1_205 [Xanthomonas phage XaC1]	diamond	186	66.6	1	Viruses		Heunggongvirae	Uroviricota	Caudoviricetes				Xanthomonas phage XaC1
31499415	31499415	PRJNA515078_P_NODE_10876_length_272_cov_2.651064_g10643_i0	PRJNA515078	10876	272	2.651064	7.21089408	Chlorovirus sp.	2809302	Viruses	Viruses	95.5	1.47e-20	NR	XOK35624.1	2809302	g10643	i0	50.6	1.875	81	40	89.3	0	265	23	111	191	XOK35624.1 Oxidoreductase [Chlorovirus sp.]	diamond	510	95.5	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Chlorovirus	Chlorovirus sp.
31499426	31499426	PRJNA515078_P_NODE_2056_length_679_cov_2.049844_g1861_i0	PRJNA515078	2056	679	2.0498440000000002	13.91844076	Megaviridae environmental sample	1737588	Viruses	Viruses	216	3.41e-61	NR	QFG74443.1	1737588	g1861	i0	57.6	0.729013254786451	165	69	72.5	1	678	187	763	927	QFG74443.1 MAG: GDP-mannose 4,6 dehydratase [Megaviridae environmental sample]	diamond	495	216	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae		Megaviridae environmental sample
32385118	32385118	PRJNA515078_P_NODE_16399_length_215_cov_2.275281_g16166_i0	PRJNA515078	16399	215	2.275281	4.89185415	Emiliania huxleyi virus 2	181208	Viruses	Viruses	52	1.45e-5	NR	AEP15724.1	181214	g16166	i0	46.3	3.76744186046512	54	26	75.3	1	183	22	814	864	AEP15724.1 hypothetical protein EQVG_00314 [Emiliania huxleyi virus 207]	diamond	810	52	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Algavirales	Phycodnaviridae	Coccolithovirus	Emiliania huxleyi virus 207
32448636	32448636	PRJNA515078_P_NODE_28979_length_162_cov_1.248000_g28746_i0	PRJNA515078	28979	162	1.248	2.02176	Cafeteria roenbergensis virus BV-PW1	693272	Viruses	Viruses	48.9	1.5e-5	NR	YP_003969654.1	693272	g28746	i0	69.7	0.611111111111111	33	10	61.1	0	150	52	2	34	YP_003969654.1 hypothetical protein crov022 [Cafeteria roenbergensis virus BV-PW1]	diamond	99	48.9	1	Viruses		Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Rheavirus	Rheavirus sinusmexicani
32512010	32512010	PRJNA515078_P_NODE_30059_length_159_cov_1.918033_g29826_i0	PRJNA515078	30059	159	1.918033	3.04967247	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	84	3.63e-17	NR	XCM67826.1	3003959	g29826	i0	76.9	2.90566037735849	52	12	98.1	0	1	156	1694	1745	XCM67826.1 MAG: nonstructural polyprotein [Picornavirales sp.]	diamond	462	84	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
32669280	32669280	PRJNA515078_P_NODE_25660_length_172_cov_0.851852_g25427_i0	PRJNA515078	25660	172	0.851852	1.46518544	Chuvivirus	2842604	Viruses	Viruses	51.2	1.46e-5	NR	WET19891.1	2842604	g25427	i0	52.4	1.53488372093023	42	20	73.3	0	162	37	456	497	WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1]	diamond	264	51.2	1	Viruses		Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus

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