metadata: contig_metadata: 13 rows where bioproject = "PRJNA861969", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA861969", tax_clade = "PVC group" and tax_superkingdom = "Bacteria"

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
846434	846434	PRJNA861969_P_NODE_32841_length_249_cov_0.875000_g32610_i0	PRJNA861969	32841	249	0.875	2.17875	Prosthecobacter sp.	1965333	Bacteria	Bacteria	171	2.67e-47	NR	WP_395734942.1	1965333	g32610	i0	100	2.96385542168675	82	0	98.8	0	3	248	756	837	WP_395734942.1 efflux RND transporter permease subunit, partial [Prosthecobacter sp.]	diamond	738	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
846450	846450	PRJNA861969_P_NODE_33781_length_248_cov_0.880000_g33550_i0	PRJNA861969	33781	248	0.88	2.1824	Gemmata massiliana	1210884	Bacteria	Bacteria	265	2.6499999999999997e-66	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g33550	i0	85.944	1.00403225806452	249	33	100	2	1	248	4104838	4104591	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	249	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
8499078	8499078	PRJNA861969_P_NODE_16287_length_331_cov_0.895349_g16056_i0	PRJNA861969	16287	331	0.895349	2.96360519	Chthoniobacter flavus	191863	Bacteria	Bacteria	494	4.31e-135	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g16056	i0	93.656	256.253776435045	331	19	100	2	1	331	2227	1899	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	84820	494	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
13600151	13600151	PRJNA861969_P_NODE_33091_length_249_cov_0.875000_g32860_i0	PRJNA861969	33091	249	0.875	2.17875	Prosthecobacter sp.	1965333	Bacteria	Bacteria	159	2.66e-43	NR	WP_397385698.1	1965333	g32860	i0	98.8	3.95180722891566	82	1	98.8	0	2	247	345	426	WP_397385698.1 response regulator, partial [Prosthecobacter sp.]	diamond	984	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
23798674	23798674	PRJNA861969_P_NODE_33059_length_249_cov_0.875000_g32828_i0	PRJNA861969	33059	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g32828	i0	94.286	0.140562248995984	35	2	14	0	184	218	7103919	7103885	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26960021	26960021	PRJNA861969_P_NODE_33562_length_248_cov_1.760000_g33331_i0	PRJNA861969	33562	248	1.76	4.3648	Gemmataceae bacterium	2052164	Bacteria	Bacteria	151	1.69e-42	NR	MFO0852601.1	2052164	g33331	i0	81.7	0.991935483870968	82	15	99.2	0	2	247	259	340	MFO0852601.1 sialidase family protein [Gemmataceae bacterium]	diamond	246	151	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28160734	28160734	PRJNA861969_P_NODE_27525_length_264_cov_1.476440_g27294_i0	PRJNA861969	27525	264	1.47644	3.8978016	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.013	NR	MBM4009064.1	2026780	g27294	i0	38.6	1	44	24	46.6	1	249	127	135	178	MBM4009064.1 DMT family transporter [Planctomycetota bacterium]	diamond	264	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30908327	30908327	PRJNA861969_P_NODE_23114_length_284_cov_1.459716_g22883_i0	PRJNA861969	23114	284	1.459716	4.14559344	Candidatus Laterigemmans baculatus	2770505	Bacteria	Bacteria	180	1.77e-52	NR	WP_164101029.1	2770505	g22883	i0	96.8	1.98591549295775	94	3	99.3	0	284	3	214	307	WP_164101029.1 V-type ATP synthase subunit B [Candidatus Laterigemmans baculatus]	diamond	564	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Candidatus Laterigemmans	Candidatus Laterigemmans baculatus
30939945	30939945	PRJNA861969_P_NODE_37294_length_245_cov_0.895349_g37063_i0	PRJNA861969	37294	245	0.895349	2.19360505	Planctomycetota bacterium	2026780	Bacteria	Bacteria	70.1	6.57e-13	NR	MCI0332210.1	2026780	g37063	i0	47.8	0.820408163265306	67	35	82	0	1	201	84	150	MCI0332210.1 hypothetical protein [Planctomycetota bacterium]	diamond	201	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32458081	32458081	PRJNA861969_P_NODE_27319_length_265_cov_1.234375_g27088_i0	PRJNA861969	27319	265	1.234375	3.27109375	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	117	6.2899999999999995e-30	NR	WP_184211288.1	48465	g27088	i0	84.1	0.781132075471698	69	11	78.1	0	264	58	235	303	WP_184211288.1 DUF58 domain-containing protein [Prosthecobacter dejongeii]	diamond	207	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
32489742	32489742	PRJNA861969_P_NODE_37559_length_245_cov_0.895349_g37328_i0	PRJNA861969	37559	245	0.895349	2.19360505	Fimbriiglobus sp.	1914235	Bacteria	Bacteria	92	7.42e-20	NR	MCU0705219.1	1914235	g37328	i0	57.1	0.942857142857143	77	33	94.3	0	242	12	192	268	MCU0705219.1 ATP-grasp domain-containing protein [Fimbriiglobus sp.]	diamond	231	92	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Fimbriiglobus	Fimbriiglobus sp.
32584599	32584599	PRJNA861969_P_NODE_28119_length_261_cov_1.755319_g27888_i0	PRJNA861969	28119	261	1.755319	4.58138259	Prosthecobacter sp.	1965333	Bacteria	Bacteria	51.2	4.95e-5	NR	WP_294231802.1	1965333	g27888	i0	50	0.804597701149425	70	28	74.7	2	221	27	9083	9150	WP_294231802.1 autotransporter-associated beta strand repeat-containing protein [Prosthecobacter sp.]	diamond	210	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32710269	32710269	PRJNA861969_P_NODE_38880_length_243_cov_1.811765_g38649_i0	PRJNA861969	38880	243	1.811765	4.40258895	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	132	4e-36	NR	MBS0661148.1	2026799	g38649	i0	76.3	2.96296296296296	80	19	98.8	0	3	242	60	139	MBS0661148.1 glucose 1-dehydrogenase [Verrucomicrobiota bacterium]	diamond	720	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;