metadata: contig_metadata: 21 rows where bioproject = "PRJNA384462" and tax

21 rows where bioproject = "PRJNA384462" and tax_clade = "PVC group"

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
2956002	2956002	PRJNA384462_S_NODE_14603_length_163_cov_0.894737_g14487_i0	PRJNA384462	14603	163	0.894737	1.45842131	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	204	3.54e-48	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g14487	i0	92.857	180.822085889571	140	10	86	0	4	143	5936370	5936231	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	29474	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2956013	2956013	PRJNA384462_S_NODE_2483_length_330_cov_3.587189_g2367_i0	PRJNA384462	2483	330	3.587189	11.8377237	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	134	3.79e-36	NR	MEX2673135.1	2026777	g2367	i0	68.8	0.845454545454545	93	28	84.5	1	330	52	187	278	MEX2673135.1 aspartate-semialdehyde dehydrogenase [Phycisphaeraceae bacterium]	diamond	279	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
2956028	2956028	PRJNA384462_S_NODE_6163_length_220_cov_2.976608_g6047_i0	PRJNA384462	6163	220	2.976608	6.5485376	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	142	9.55e-38	NR	HEX5104735.1	2699754	g6047	i0	95.8	26.1954545454545	71	3	96.8	0	216	4	432	502	HEX5104735.1 dihydroxy-acid dehydratase [Pirellulaceae bacterium]	diamond	5763	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
5509004	5509004	PRJNA384462_S_NODE_13385_length_166_cov_0.871795_g13269_i0	PRJNA384462	13385	166	0.871795	1.4471797	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g13269	i0	96.988	1	166	5	100	0	1	166	227977	227812	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	166	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6178798	6178798	PRJNA384462_S_NODE_10505_length_180_cov_1.557252_g10389_i0	PRJNA384462	10505	180	1.557252	2.8030536	Planctomycetota bacterium	2026780	Bacteria	Bacteria	69.7	2.94e-12	NR	HEV8111908.1	2026780	g10389	i0	66	1.56666666666667	47	16	78.3	0	142	2	83	129	HEV8111908.1 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetota bacterium]	diamond	282	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6783020	6783020	PRJNA384462_S_NODE_2626_length_320_cov_4.771218_g2510_i0	PRJNA384462	2626	320	4.771218	15.2678976	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	106	3.59e-24	NR	HAI13640.1	2052180	g2510	i0	55.3	1.06875	114	42	99.4	4	319	2	4843	4955	HAI13640.1 hypothetical protein [Phycisphaerales bacterium]	diamond	342	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
8728511	8728511	PRJNA384462_S_NODE_15427_length_161_cov_0.910714_g15311_i0	PRJNA384462	15427	161	0.910714	1.46624954	Fontisphaera	3050007	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g15311	i0	95.031	121.633540372671	161	8	100	0	1	161	3832570	3832410	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	19583	255	0.996078431372549	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22081772	22081772	PRJNA384462_S_NODE_1818_length_386_cov_2.406528_g1702_i0	PRJNA384462	1818	386	2.406528	9.28919808	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	114	1.25e-26	NR	WP_213157304.1	2795736	g1702	i0	46.5	0.987046632124352	127	60	98.7	2	386	6	3163	3281	WP_213157304.1 hypothetical protein [Parachlamydia sp. AcF125]	diamond	381	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
23357373	23357373	PRJNA384462_S_NODE_16199_length_152_cov_3.893204_g16083_i0	PRJNA384462	16199	152	3.893204	5.91767008	Schlesneria sphaerica	3373610	Bacteria	Bacteria	182	1.52e-41	NTclustered	gi\|2844279856\|gb\|CP172346.1\|	3373610	g16083	i0	91.603	17.7039473684211	131	11	86	0	2	132	369172	369042	Schlesneria sp. T3-172 chromosome, complete genome	blastn	2691	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sphaerica
26885500	26885500	PRJNA384462_S_NODE_1861_length_381_cov_11.132530_g1745_i0	PRJNA384462	1861	381	11.13253	42.4149393	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	78.6	5.46e-14	NR	HAI13640.1	2052180	g1745	i0	51.9	0.606299212598425	77	36	59.8	1	380	153	4912	4988	HAI13640.1 hypothetical protein [Phycisphaerales bacterium]	diamond	231	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27359827	27359827	PRJNA384462_S_NODE_8723_length_193_cov_1.937500_g8607_i0	PRJNA384462	8723	193	1.9375	3.739375	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62.4	1.48e-10	NR	MDI9431618.1	2026780	g8607	i0	52.1	2.30051813471503	48	23	74.6	0	163	20	36	83	MDI9431618.1 CocE/NonD family hydrolase [Planctomycetota bacterium]	diamond	444	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27896320	27896320	PRJNA384462_S_NODE_2945_length_303_cov_1.330709_g2829_i0	PRJNA384462	2945	303	1.330709	4.03204827	Humisphaera sp.	2807514	Bacteria	Bacteria	47	0.00235	NR	MEA2735087.1	2807514	g2829	i0	32.2	1.16831683168317	118	59	97	5	303	10	123	239	MEA2735087.1 hypothetical protein [Humisphaera sp.]	diamond	354	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
27976418	27976418	PRJNA384462_S_NODE_7305_length_207_cov_0.968354_g7189_i0	PRJNA384462	7305	207	0.968354	2.00449278	Bacteria	2	Bacteria	Bacteria	42	0.046	NR	MBU4273540.1	2026780	g7189	i0	35.9	3.97101449275362	64	33	92.8	2	207	16	1183	1238	MBU4273540.1 hypothetical protein [Planctomycetota bacterium]	diamond	822	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29569771	29569771	PRJNA384462_S_NODE_10670_length_179_cov_1.569231_g10554_i0	PRJNA384462	10670	179	1.569231	2.80892349	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	51.2	1.62e-5	NR	MDB5389690.1	2026779	g10554	i0	48.3	0.972067039106145	58	28	97.2	2	3	176	171	226	MDB5389690.1 outer rane adhesin like protein [Planctomycetaceae bacterium]	diamond	174	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31086256	31086256	PRJNA384462_S_NODE_1955_length_372_cov_6.470588_g1839_i0	PRJNA384462	1955	372	6.470588	24.07058736	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	78.6	4.9e-14	NR	HAI13640.1	2052180	g1839	i0	53.2	0.620967741935484	77	35	61.3	1	371	144	4912	4988	HAI13640.1 hypothetical protein [Phycisphaerales bacterium]	diamond	231	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31876680	31876680	PRJNA384462_S_NODE_12077_length_171_cov_1.254098_g11961_i0	PRJNA384462	12077	171	1.254098	2.14450758	Candidatus Velamenicoccus archaeovorus	1930593	Bacteria	Bacteria	48.5	1.25e-4	NR	MFB3739493.1	1930593	g11961	i0	51	0.859649122807018	49	23	86	1	11	157	320	367	MFB3739493.1 sorbosone dehydrogenase family protein [Candidatus Velamenicoccus archaeovorus]	diamond	147	48.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Velamenicoccus	Candidatus Velamenicoccus archaeovorus
32431740	32431740	PRJNA384462_S_NODE_6399_length_217_cov_1.994048_g6283_i0	PRJNA384462	6399	217	1.994048	4.32708416	Pseudomonadati	3379134	Bacteria	Bacteria	100	1.63e-22	NR	GMV98705.1	2026778	g6283	i0	66.2	5.75115207373272	68	23	94	0	13	216	43	110	GMV98705.1 MAG: phosphoenolpyruvate carboxykinase [GTP] [Phycisphaerae bacterium]	diamond	1248	101	0.99009900990099	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32573165	32573165	PRJNA384462_S_NODE_819_length_567_cov_2.343629_g714_i0	PRJNA384462	819	567	2.343629	13.28837643	Planctomycetota bacterium	2026780	Bacteria	Bacteria	159	3.89e-41	NR	MBX3467716.1	2026780	g714	i0	46.6	1.84126984126984	174	83	91.5	4	553	35	1933	2097	MBX3467716.1 hypothetical protein [Planctomycetota bacterium]	diamond	1044	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32667255	32667255	PRJNA384462_S_NODE_13220_length_166_cov_1.188034_g13104_i0	PRJNA384462	13220	166	1.188034	1.97213644	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0254	NR	KAF0241093.1	2026780	g13104	i0	47.1	0.921686746987952	51	17	74.1	1	150	28	183	233	KAF0241093.1 MAG: hypothetical protein FD180_4631, partial [Planctomycetota bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32667258	32667258	PRJNA384462_S_NODE_4720_length_246_cov_2.071066_g4604_i0	PRJNA384462	4720	246	2.071066	5.09482236	Planctomycetota bacterium	2026780	Bacteria	Bacteria	76.6	8.82e-15	NR	MBA3699301.1	2026780	g4604	i0	66	0.646341463414634	53	18	64.6	0	245	87	177	229	MBA3699301.1 phosphoserine phosphatase SerB [Planctomycetota bacterium]	diamond	159	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32856191	32856191	PRJNA384462_S_NODE_14640_length_163_cov_0.885965_g14524_i0	PRJNA384462	14640	163	0.885965	1.44412295	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	50.4	2.37e-5	NR	RYD65414.1	2026800	g14524	i0	90.9	0.404907975460123	22	2	40.5	0	163	98	313	334	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	66	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium

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