metadata: contig_metadata: 13 rows where bioproject = "PRJNA904835" and tax

13 rows where bioproject = "PRJNA904835" 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
7260882	7260882	PRJNA904835_P_NODE_25546_length_393_cov_1.753125_g25290_i0	PRJNA904835	25546	393	1.753125	6.88978125	Stieleria magnilauensis	2527963	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g25290	i0	100	0.0737913486005089	29	0	7	0	103	131	3127751	3127779	Planctomycetes bacterium TBK1r chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
26802630	26802630	PRJNA904835_P_NODE_49621_length_255_cov_0.829670_g49365_i0	PRJNA904835	49621	255	0.82967	2.1156585	Neochlamydia sp. TUME1	1478174	Bacteria	Bacteria	40.4	0.0455	NR	WP_080502455.1	1478174	g49365	i0	46.2	0.458823529411765	39	21	45.9	0	164	48	5	43	WP_080502455.1 DUF4116 domain-containing protein [Neochlamydia sp. TUME1]	diamond	117	40.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. TUME1
26992411	26992411	PRJNA904835_P_NODE_59602_length_202_cov_3.162791_g59346_i0	PRJNA904835	59602	202	3.162791	6.38883782	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	59.7	4.75e-10	NR	HVU62796.1	2052180	g59346	i0	46.6	2.73267326732673	58	31	86.1	0	10	183	1	58	HVU62796.1 YqaE/Pmp3 family membrane protein [Phycisphaerales bacterium]	diamond	552	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27940397	27940397	PRJNA904835_P_NODE_20085_length_451_cov_2.055556_g19830_i0	PRJNA904835	20085	451	2.055556	9.27055756	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	111	2.22e-27	NR	WP_213106507.1	362787	g19830	i0	48.8	2.5410199556541	123	59	81.2	3	366	1	7	126	WP_213106507.1 histidine phosphatase family protein [Candidatus Protochlamydia amoebophila]	diamond	1146	111	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
28445627	28445627	PRJNA904835_P_NODE_39806_length_300_cov_2.625551_g39550_i0	PRJNA904835	39806	300	2.625551	7.876653	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00367	NR	MES2792001.1	2026780	g39550	i0	51.3	0.39	39	19	39	0	295	179	178	216	MES2792001.1 hypothetical protein [Planctomycetota bacterium]	diamond	117	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28674103	28674103	PRJNA904835_P_NODE_15647_length_523_cov_1.026667_g15394_i0	PRJNA904835	15647	523	1.026667	5.36946841	Pseudomonadati	3379134	Bacteria	Bacteria	131	1.11e-33	NR	MCH8824964.1	2026780	g15394	i0	49.7	5.20841300191205	147	68	80.9	4	424	2	48	194	MCH8824964.1 hypothetical protein [Planctomycetota bacterium]	diamond	2724	132	0.992424242424242	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29613363	29613363	PRJNA904835_P_NODE_2830_length_1265_cov_3.296980_g2704_i0	PRJNA904835	2830	1265	3.29698	41.706797	Gimesia chilikensis	2605989	Bacteria	Bacteria	89.7	1.63e-15	NR	WP_145039199.1	2605989	g2704	i0	26	0.685375494071146	289	173	63.3	8	4	804	125	394	WP_145039199.1 hypothetical protein [Gimesia chilikensis]	diamond	867	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
30245659	30245659	PRJNA904835_P_NODE_25492_length_394_cov_1.177570_g25236_i0	PRJNA904835	25492	394	1.17757	4.6396258	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	44.7	0.0383	NR	MBI9016996.1	2026778	g25236	i0	43.9	0.312182741116751	41	23	31.2	0	234	356	81	121	MBI9016996.1 c-type cytochrome [Phycisphaerae bacterium]	diamond	123	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
30687665	30687665	PRJNA904835_P_NODE_28333_length_371_cov_1.013423_g28077_i0	PRJNA904835	28333	371	1.013423	3.75979933	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	52.8	4.86e-5	NR	MCF7851681.1	2698248	g28077	i0	33.3	1.78706199460916	120	73	97	3	362	3	111	223	MCF7851681.1 DUF4116 domain-containing protein [Simkaniaceae bacterium]	diamond	663	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
31288102	31288102	PRJNA904835_P_NODE_54695_length_246_cov_0.890173_g54439_i0	PRJNA904835	54695	246	0.890173	2.18982558	Pedosphaera sp.	2024890	Bacteria	Bacteria	67.8	2.35e-12	NR	MCH2593153.1	2024890	g54439	i0	46.9	1.78048780487805	64	31	78	2	1	192	43	103	MCH2593153.1 hypothetical protein [Pedosphaera sp.]	diamond	438	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
31509775	31509775	PRJNA904835_P_NODE_40116_length_299_cov_1.349558_g39860_i0	PRJNA904835	40116	299	1.349558	4.03517842	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	45.4	0.0081	NR	MCA9110856.1	2026779	g39860	i0	27	0.74247491638796	74	52	72.2	1	237	22	602	675	MCA9110856.1 cbb3-type cytochrome c oxidase subunit I [Planctomycetaceae bacterium]	diamond	222	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31541358	31541358	PRJNA904835_P_NODE_58816_length_241_cov_0.916667_g58560_i0	PRJNA904835	58816	241	0.916667	2.20916747	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	67	9.87e-11	NR	MCG3180921.1	2026778	g58560	i0	43.4	7.89211618257261	76	42	94.6	1	2	229	204	278	MCG3180921.1 hypothetical protein [Phycisphaerae bacterium]	diamond	1902	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32110723	32110723	PRJNA904835_P_NODE_58798_length_241_cov_0.916667_g58542_i0	PRJNA904835	58798	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	51.2	3.69e-5	NR	MDP6357820.1	2026780	g58542	i0	36.4	4.26970954356846	77	49	95.9	0	9	239	177	253	MDP6357820.1 protein kinase [Planctomycetota bacterium]	diamond	1029	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;