metadata: contig_metadata: 7 rows where bioproject = "PRJNA833575", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA833575", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
5927688	5927688	PRJNA833575_P_NODE_44045_length_229_cov_0.900000_g43908_i0	PRJNA833575	44045	229	0.9	2.061	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	263	8.67e-66	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g43908	i0	88	302.323144104803	225	23	97	4	1	222	2002112	2001889	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	69232	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
27875822	27875822	PRJNA833575_P_NODE_26225_length_291_cov_0.972973_g26088_i0	PRJNA833575	26225	291	0.972973	2.83135143	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.9	0.0235	NR	QYK46985.1	2026777	g26088	i0	32.1	1.71134020618557	81	46	83.5	2	45	287	135	206	QYK46985.1 MAG: isoprenylcysteine carboxylmethyltransferase family protein [Phycisphaeraceae bacterium]	diamond	498	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28484383	28484383	PRJNA833575_P_NODE_38086_length_235_cov_1.457831_g37949_i0	PRJNA833575	38086	235	1.457831	3.42590285	Bremerella	2714594	Bacteria	Bacteria	60.5	1.96e-8	NR	WP_345091782.1	1031537	g37949	i0	36.6	2.97446808510638	71	45	90.6	0	213	1	550	620	WP_345091782.1 beta strand repeat-containing protein [Bremerella cremea]	diamond	699	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella cremea
29179107	29179107	PRJNA833575_P_NODE_11809_length_421_cov_1.468750_g11672_i0	PRJNA833575	11809	421	1.46875	6.1834375	PVC group	1783257	Bacteria	Bacteria	62.4	1.25e-8	NR	HIA38721.1	2026780	g11672	i0	41	2.84323040380047	100	52	68.4	4	399	112	22	118	HIA38721.1 hypothetical protein [Planctomycetota bacterium]	diamond	1197	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29391565	29391565	PRJNA833575_P_NODE_45789_length_227_cov_0.911392_g45652_i0	PRJNA833575	45789	227	0.911392	2.06885984	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.4	9.88e-6	NR	HEY3324418.1	2026780	g45652	i0	45.3	0.845814977973568	64	31	84.6	1	227	36	184	243	HEY3324418.1 5'/3'-nucleotidase SurE [Planctomycetota bacterium]	diamond	192	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29652181	29652181	PRJNA833575_P_NODE_45850_length_227_cov_0.911392_g45713_i0	PRJNA833575	45850	227	0.911392	2.06885984	Botrimarina	2795782	Bacteria	Bacteria	85.5	2.47e-17	NR	MEN0111479.1	2026780	g45713	i0	61.8	4.91629955947137	76	19	91.2	2	221	15	5	77	MEN0111479.1 aldehyde dehydrogenase family protein [Planctomycetota bacterium]	diamond	1116	85.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32331243	32331243	PRJNA833575_P_NODE_33179_length_257_cov_1.526596_g33042_i0	PRJNA833575	33179	257	1.526596	3.92335172	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	64.7	6.51e-10	NR	MEP0848575.1	2026778	g33042	i0	41.9	1.00389105058366	86	45	95.7	2	5	250	195	279	MEP0848575.1 dienelactone hydrolase family protein [Phycisphaerae bacterium]	diamond	258	64.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae 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);;