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

14 rows where bioproject = "PRJNA798511" 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
3340685	3340685	PRJNA798511_P_NODE_10923_length_1428_cov_9.009594_g8279_i0	PRJNA798511	10923	1428	9.009594	128.65700232	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	56.5	0.011	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g8279	i0	100	0.061624649859944	30	0	2	0	54	83	1852363	1852334	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	88	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
26927371	26927371	PRJNA798511_P_NODE_47302_length_371_cov_1.419463_g43036_i0	PRJNA798511	47302	371	1.419463	5.26620773	Opitutales bacterium	2026772	Bacteria	Bacteria	44.3	0.0403	NR	MEL0005672.1	2026772	g43036	i0	44.1	0.549865229110512	68	32	51.8	4	300	109	111	176	MEL0005672.1 substrate-binding domain-containing protein [Opitutales bacterium]	diamond	204	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27527847	27527847	PRJNA798511_P_NODE_35703_length_463_cov_1.753846_g31444_i0	PRJNA798511	35703	463	1.753846	8.12030698	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	68.9	3.35e-11	NR	HET6328477.1	2026779	g31444	i0	31.4	0.764578833693304	118	74	75.2	3	94	441	36	148	HET6328477.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	354	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28033221	28033221	PRJNA798511_P_NODE_37945_length_439_cov_1.754098_g33684_i0	PRJNA798511	37945	439	1.754098	7.70049022	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	9.36e-15	NR	HEY3226600.1	2026780	g33684	i0	45.1	6.10250569476082	102	46	68.3	3	432	133	165	258	HEY3226600.1 serine/threonine-protein kinase [Planctomycetota bacterium]	diamond	2679	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28033244	28033244	PRJNA798511_P_NODE_78865_length_269_cov_1.464286_g74599_i0	PRJNA798511	78865	269	1.464286	3.93892934	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	42.7	0.0457	NR	MBE6399572.1	1932692	g74599	i0	42.9	0.468401486988848	42	23	45.7	1	206	84	193	234	MBE6399572.1 FtsQ-type POTRA domain-containing protein [Lentisphaerota bacterium]	diamond	126	42.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28664612	28664612	PRJNA798511_P_NODE_35047_length_471_cov_1.092965_g30788_i0	PRJNA798511	35047	471	1.092965	5.14786515	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	145	4.359999999999999e-37	NR	MCP4255696.1	2268189	g30788	i0	44.9	1.72611464968153	158	81	96.8	1	1	456	627	784	MCP4255696.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	813	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
28980475	28980475	PRJNA798511_P_NODE_10888_length_1432_cov_35.709345_g8254_i0	PRJNA798511	10888	1432	35.709345	511.3578204	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.4	5.62e-20	NR	MFH0952965.1	2026799	g8254	i0	44.4	0.207402234636872	99	54	20.7	1	783	487	104	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	297	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29368294	29368294	PRJNA798511_P_NODE_10889_length_1432_cov_30.951435_g8254_i1	PRJNA798511	10889	1432	30.951435	443.2245492	Pseudomonadati	3379134	Bacteria	Bacteria	89.7	1.02e-16	NR	HLX63275.1	2026780	g8254	i1	46.2	1.37849162011173	93	49	19.5	1	650	928	99	190	HLX63275.1 ATP-dependent Clp protease proteolytic subunit [Planctomycetota bacterium]	diamond	1974	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30338759	30338759	PRJNA798511_P_NODE_82892_length_261_cov_0.819149_g78626_i0	PRJNA798511	82892	261	0.819149	2.13797889	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.9	4.24e-12	NR	MBT3191068.1	2026799	g78626	i0	38.4	8.45977011494253	86	52	98.9	1	259	2	101	185	MBT3191068.1 ATP-dependent Clp protease proteolytic subunit [Verrucomicrobiota bacterium]	diamond	2208	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30622513	30622513	PRJNA798511_P_NODE_73453_length_281_cov_1.120192_g69187_i0	PRJNA798511	73453	281	1.120192	3.14773952	Aquisphaera insulae	2712864	Bacteria	Bacteria	42	0.0443	NR	WP_165228110.1	2712864	g69187	i0	31.6	0.843416370106762	79	53	84.3	1	21	257	6	83	WP_165228110.1 hypothetical protein [Aquisphaera insulae]	diamond	237	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
30812150	30812150	PRJNA798511_P_NODE_14574_length_1103_cov_32.100971_g8254_i2	PRJNA798511	14574	1103	32.100971	354.07371013	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	81.3	6.59e-14	NR	MFH0952965.1	2026799	g8254	i2	42.4	0.677243880326383	85	48	23.1	1	741	487	118	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	747	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32045544	32045544	PRJNA798511_P_NODE_97198_length_245_cov_0.895349_g92932_i0	PRJNA798511	97198	245	0.895349	2.19360505	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	60.5	1.59e-8	NR	MBV8129076.1	2026779	g92932	i0	66.7	0.514285714285714	42	14	51.4	0	118	243	1	42	MBV8129076.1 ABC transporter permease [Planctomycetaceae bacterium]	diamond	126	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32740830	32740830	PRJNA798511_P_NODE_63060_length_308_cov_1.348936_g58794_i0	PRJNA798511	63060	308	1.348936	4.15472288	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	90.5	1.27e-18	NR	MCG8432081.1	2035772	g58794	i0	41	10.5194805194805	100	59	97.4	0	307	8	138	237	MCG8432081.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium]	diamond	3240	90.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32835075	32835075	PRJNA798511_P_NODE_49180_length_361_cov_1.829861_g44914_i0	PRJNA798511	49180	361	1.829861	6.60579821	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.5	0.00133	NR	HEU5068864.1	2499141	g44914	i0	37.7	0.506925207756233	61	29	44	3	229	71	517	576	HEU5068864.1 MFS transporter [Verrucomicrobiia bacterium]	diamond	183	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;