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

7 rows where bioproject = "PRJEB14803", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

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
8948550	8948550	PRJEB14803_P_NODE_4788_length_639_cov_1.948675_g4394_i0	PRJEB14803	4788	639	1.948675	12.45203325	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1031	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4394	i0	95.775	2.63067292644757	639	27	100	0	1	639	2275917	2276555	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	1681	1031	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
22973413	22973413	PRJEB14803_P_NODE_26359_length_215_cov_1.333333_g25893_i0	PRJEB14803	26359	215	1.333333	2.86666595	Waddliaceae bacterium	2026802	Bacteria	Bacteria	108	2.5e-26	NR	HEY4831209.1	2026802	g25893	i0	84.5	0.990697674418605	71	11	99.1	0	2	214	219	289	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	213	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
27033028	27033028	PRJEB14803_P_NODE_15302_length_309_cov_1.708029_g14836_i0	PRJEB14803	15302	309	1.708029	5.27780961	Neochlamydia sp. AcF95	2795734	Bacteria	Bacteria	47.8	0.00148	NR	WP_213152211.1	2795734	g14836	i0	48.9	0.436893203883495	45	23	43.7	0	309	175	588	632	WP_213152211.1 tetratricopeptide repeat protein [Neochlamydia sp. AcF95]	diamond	135	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. AcF95
27089995	27089995	PRJEB14803_P_NODE_15102_length_312_cov_1.281588_g14636_i0	PRJEB14803	15102	312	1.281588	3.99855456	Bacteria	2	Bacteria	Bacteria	51.6	6.63e-5	NR	MBA3238848.1	2052176	g14636	i0	34.2	2.45192307692308	79	50	76	2	12	248	22	98	MBA3238848.1 DUF4116 domain-containing protein [Parachlamydiaceae bacterium]	diamond	765	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28170116	28170116	PRJEB14803_P_NODE_11366_length_375_cov_2.044118_g10901_i0	PRJEB14803	11366	375	2.044118	7.6654425	Chlamydiales bacterium STE3	1910938	Bacteria	Bacteria	57	1.62e-6	NR	KAF3363195.1	1910938	g10901	i0	42.4	0.736	92	47	72	3	315	46	306	393	KAF3363195.1 Uncharacterized protein PHSC3_000209 [Chlamydiales bacterium STE3]	diamond	276	57	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium STE3
30728158	30728158	PRJEB14803_P_NODE_29634_length_199_cov_1.920732_g29168_i0	PRJEB14803	29634	199	1.920732	3.82225668	Chlamydiia bacterium	2052156	Bacteria	Bacteria	47.8	2.95e-4	NR	MCB1108812.1	2052156	g29168	i0	48.8	0.648241206030151	43	22	64.8	0	61	189	33	75	MCB1108812.1 2OG-Fe(II) oxygenase [Chlamydiia bacterium]	diamond	129	47.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
31360462	31360462	PRJEB14803_P_NODE_35296_length_179_cov_1.111111_g34830_i0	PRJEB14803	35296	179	1.111111	1.98888869	Chlamydiota bacterium	2081524	Bacteria	Bacteria	63.9	2.67e-10	NR	MBM3184206.1	2081524	g34830	i0	52.5	0.988826815642458	59	28	98.9	0	2	178	168	226	MBM3184206.1 SDR family oxidoreductase [Chlamydiota bacterium]	diamond	177	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;