metadata: contig_metadata: 14 rows where bioproject = "PRJNA556992" and tax

14 rows where bioproject = "PRJNA556992" and tax_phylum = "Cossaviricota"

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
4350022	4350022	PRJNA556992_P_NODE_1087004_length_216_cov_4.097902_g1084813_i0	PRJNA556992	1087004	216	4.097902	8.85146832	Gammapapillomavirus 8	1175850	Viruses	Viruses	372	1.29e-98	NTclustered	gi\|343411609\|gb\|HM999999.1\|	1070420	g1084813	i0	97.685	1	216	5	100	0	1	216	3666	3451	Human papillomavirus type 147 isolate GH659, complete genome	blastn	216	372	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Gammapapillomavirus	Gammapapillomavirus 8
4354503	4354503	PRJNA556992_P_NODE_329244_length_285_cov_1.132075_g327055_i0	PRJNA556992	329244	285	1.132075	3.22641375	Alphapapillomavirus 2	337039	Viruses	Viruses	510	3.61e-140	NTclustered	gi\|58430757\|dbj\|AB201226.1\|	260717	g327055	i0	98.947	12.4771929824561	285	3	100	0	1	285	2295	2011	Human papillomavirus type 94 DNA, nearly complete genome, Korean variant	blastn	3556	510	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Alphapapillomavirus	Alphapapillomavirus 2
10737229	10737229	PRJNA556992_P_NODE_788169_length_246_cov_4.208092_g785979_i0	PRJNA556992	788169	246	4.208092	10.35190632	Betapapillomavirus 2	333924	Viruses	Viruses	433	6.79e-117	NTclustered	gi\|1273499042\|gb\|MF588683.1\|	333924	g785979	i0	98.374	2	246	4	100	0	1	246	4744	4499	Betapapillomavirus 2 isolate Beta02_m292c88, complete genome	blastn	492	433	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 2
12006821	12006821	PRJNA556992_P_NODE_374410_length_279_cov_2.398058_g372221_i0	PRJNA556992	374410	279	2.398058	6.69058182	Betapapillomavirus 1	337051	Viruses	Viruses	503	5.9e-138	NTclustered	gi\|1273498994\|gb\|MF588677.1\|	337051	g372221	i0	99.281	2.89964157706093	278	2	99	0	1	278	5312	5589	Betapapillomavirus 1 isolate Beta01_HIVGc36, complete genome	blastn	809	503	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 1
13287639	13287639	PRJNA556992_P_NODE_829451_length_244_cov_2.883041_g827261_i0	PRJNA556992	829451	244	2.883041	7.03462004	Betapapillomavirus 1	337051	Viruses	Viruses	56.5	0.002	NTclustered	gi\|1200175664\|gb\|KY969593.1\|	31547	g827261	i0	100	0.245901639344262	30	0	12	0	23	52	5585	5556	Human papillomavirus 20 strain HPV-20/Lancaster/2015, complete genome	blastn	60	56.5	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Zurhausenvirales	Papillomaviridae	Betapapillomavirus	Betapapillomavirus 1
14557185	14557185	PRJNA556992_P_NODE_396712_length_277_cov_1.446078_g394523_i0	PRJNA556992	396712	277	1.446078	4.00563606	Blatella germanica densoviruses-like virus 1	2776787	Viruses	Viruses	490	4.56e-134	NTclustered	gi\|1917254128\|gb\|MN851295.1\|	2776787	g394523	i0	98.556	30.8736462093863	277	4	100	0	1	277	131	407	Blatella germanica densoviruses-like virus 1 isolate EuB-PV1 nonstructural protein genes, complete cds	blastn	8552	490	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Blatella germanica densoviruses-like virus 1
18385995	18385995	PRJNA556992_P_NODE_870755_length_242_cov_2.254438_g868565_i0	PRJNA556992	870755	242	2.254438	5.45573996	Epsilonpolyomavirus bovis	1891754	Viruses	Viruses	58.4	4.69e-4	NTclustered	gi\|954182136\|gb\|KU170643.1\|	1561702	g868565	i0	100	0.128099173553719	31	0	13	0	115	145	138	108	Bovine polyomavirus 1 isolate #7535, complete genome	blastn	31	58.4	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Epsilonpolyomavirus	Epsilonpolyomavirus bovis
19654700	19654700	PRJNA556992_P_NODE_40976_length_554_cov_2.871102_g38831_i0	PRJNA556992	40976	554	2.871102	15.90590508	Parvoviridae sp.	1940570	Viruses	Viruses	304	5.090000000000001e-100	NR	XNT21172.1	1940570	g38831	i0	76.6	3.985559566787	184	43	99.6	0	553	2	70	253	XNT21172.1 MAG: replication protein [Parvoviridae sp.]	diamond	2208	304	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
22204461	22204461	PRJNA556992_P_NODE_33478_length_601_cov_4.880682_g31362_i0	PRJNA556992	33478	601	4.880682	29.33289882	Psittaciform aveparvovirus	3042447	Viruses	Viruses	300	1.69e-98	NR	XNT21000.1	3042447	g31362	i0	70.5	1.99667221297837	200	57	99.8	1	2	601	52	249	XNT21000.1 MAG: replication protein [Parvoviridae sp.]	diamond	1200	300	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform aveparvovirus
27204628	27204628	PRJNA556992_P_NODE_277422_length_294_cov_1.393665_g275233_i0	PRJNA556992	277422	294	1.393665	4.0973751	parvo-like hybrid virus	3367306	Viruses	Viruses	108	3.18e-25	NR	XHS97069.1	3367306	g275233	i0	60.7	0.857142857142857	84	33	85.7	0	1	252	9	92	XHS97069.1 capsid protein [parvo-like hybrid virus]	diamond	252	108	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		parvo-like hybrid virus
27710922	27710922	PRJNA556992_P_NODE_72584_length_448_cov_4.661333_g70408_i0	PRJNA556992	72584	448	4.661333	20.88277184	Phoenicopteridae parvo-like hybrid virus	2794528	Viruses	Viruses	63.2	2.29e-8	NR	QTE03745.1	2794528	g70408	i0	32.9	0.9375	140	70	90.4	3	413	9	144	264	QTE03745.1 MAG: hypothetical protein [Phoenicopteridae parvo-like hybrid virus]	diamond	420	63.2	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Phoenicopteridae parvo-like hybrid virus
28878309	28878309	PRJNA556992_P_NODE_171788_length_343_cov_4.340741_g169600_i0	PRJNA556992	171788	343	4.340741	14.88874163	Parvoviridae sp.	1940570	Viruses	Viruses	107	9.499999999999999e-25	NR	QKE54869.1	1940570	g169600	i0	53.9	0.778425655976676	89	40	77	1	315	52	262	350	QKE54869.1 MAG: capsid protein [Parvoviridae sp.]	diamond	267	107	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
29162869	29162869	PRJNA556992_P_NODE_173069_length_343_cov_0.855556_g170881_i0	PRJNA556992	173069	343	0.855556	2.93455708	Parvoviridae sp.	1940570	Viruses	Viruses	190	9.13e-57	NR	QKE54887.1	1940570	g170881	i0	80.7	5.98250728862974	114	22	99.7	0	342	1	281	394	QKE54887.1 MAG: replication protein [Parvoviridae sp.]	diamond	2052	190	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvoviridae sp.
30805018	30805018	PRJNA556992_P_NODE_1062934_length_221_cov_7.635135_g1060744_i0	PRJNA556992	1062934	221	7.635135	16.87364835	Ambidensovirus sp.	2050976	Viruses	Viruses	55.5	8.99e-7	NR	AWV66974.1	2050976	g1060744	i0	58.7	1.289592760181	46	17	62.4	1	216	79	116	159	AWV66974.1 Structural ORF, partial [Ambidensovirus sp.]	diamond	285	55.5	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Protoambidensovirus	Protoambidensovirus incertum3

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