metadata: contig_metadata: 4 rows where bioproject = "PRJNA1164198", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA1164198", 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
7965191	7965191	PRJNA1164198_P_NODE_18627_length_287_cov_1.518692_g18358_i0	PRJNA1164198	18627	287	1.518692	4.35864604	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	420	6.31e-113	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g18358	i0	93.056	115.257839721254	288	18	100	2	1	287	1249726	1250012	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	33079	420	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
19437975	19437975	PRJNA1164198_P_NODE_30756_length_242_cov_0.923077_g30487_i0	PRJNA1164198	30756	242	0.923077	2.23384634	Chlamydia ibidis	1405396	Bacteria	Bacteria	69.3	9.3e-14	NR	EPP34946.1	1405396	g30487	i0	93.8	0.396694214876033	32	2	39.7	0	20	115	1	32	EPP34946.1 hypothetical protein CP10139811_1351, partial [Chlamydia ibidis]	diamond	96	69.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
28859669	28859669	PRJNA1164198_P_NODE_21648_length_267_cov_1.577320_g21379_i0	PRJNA1164198	21648	267	1.57732	4.2114444	Pseudomonadati	3379134	Bacteria	Bacteria	94.4	3e-20	NR	MDR3625161.1	2047757	g21379	i0	50	12.7078651685393	86	43	96.6	0	1	258	344	429	MDR3625161.1 leucyl aminopeptidase [Chlamydiales bacterium]	diamond	3393	94.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28872013	28872013	PRJNA1164198_P_NODE_23808_length_254_cov_1.624309_g23539_i0	PRJNA1164198	23808	254	1.624309	4.12574486	Chlamydia psittaci	83554	Bacteria	Bacteria	79	1.68e-17	NR	EPP28643.1	1112246	g23539	i0	87.8	0.484251968503937	41	5	48.4	0	4	126	6	46	EPP28643.1 hypothetical protein CP082626L3_1561, partial [Chlamydia psittaci 08-2626_L3]	diamond	123	79	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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);;