metadata: contig_metadata: 5 rows where bioproject = "PRJNA577226", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA577226", 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
3112485	3112485	PRJNA577226_S_NODE_29963_length_228_cov_2.083770_g29024_i0	PRJNA577226	29963	228	2.08377	4.7509956	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	363	8.269999999999999e-96	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g29024	i0	95.575	131.907894736842	226	10	99	0	3	228	654409	654184	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	30075	363	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13891650	13891650	PRJNA577226_S_NODE_59191_length_163_cov_1.531746_g58252_i0	PRJNA577226	59191	163	1.531746	2.49674598	Neochlamydia	112987	Bacteria	Bacteria	228	2.0999999999999998e-55	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g58252	i0	92.025	172.042944785276	163	11	100	1	1	163	654703	654543	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	28043	228	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27300948	27300948	PRJNA577226_S_NODE_23463_length_260_cov_1.573991_g22524_i0	PRJNA577226	23463	260	1.573991	4.0923766	Chlamydia trachomatis	813	Bacteria	Bacteria	166	1.26e-50	NR	WP_194941313.1	813	g22524	i0	100	0.923076923076923	80	0	92.3	0	1	240	75	154	WP_194941313.1 hypothetical protein [Chlamydia trachomatis]	diamond	240	166	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27395890	27395890	PRJNA577226_S_NODE_48943_length_178_cov_1.957447_g48004_i0	PRJNA577226	48943	178	1.957447	3.48425566	Chlamydia trachomatis	813	Bacteria	Bacteria	114	1.1000000000000002e-28	NR	CPR46792.1	813	g48004	i0	100	0.97752808988764	58	0	97.8	0	176	3	281	338	CPR46792.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	174	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31533584	31533584	PRJNA577226_S_NODE_41296_length_193_cov_2.500000_g40357_i0	PRJNA577226	41296	193	2.5	4.825	Chlamydia trachomatis	813	Bacteria	Bacteria	108	2.25e-26	NR	CPR46792.1	813	g40357	i0	100	0.994818652849741	64	0	99.5	0	193	2	76	139	CPR46792.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	192	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis

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