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

4 rows where bioproject = "PRJNA312107", 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
7441550	7441550	PRJNA312107_P_NODE_12126_length_209_cov_1.268750_g11960_i0	PRJNA312107	12126	209	1.26875	2.6516875	Candidatus Protochlamydia	282132	Bacteria	Bacteria	340	3.49e-89	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g11960	i0	96.172	133.368421052632	209	7	99	1	1	208	1250375	1250583	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	27874	340	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
24603713	24603713	PRJNA312107_P_NODE_5680_length_297_cov_1.346774_g5514_i0	PRJNA312107	5680	297	1.346774	3.99991878	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	316	8.86e-82	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5514	i0	86.288	152.59595959596	299	32	99	6	1	295	654916	654623	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	45321	316	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
26694323	26694323	PRJNA312107_P_NODE_22981_length_165_cov_0.896552_g22815_i0	PRJNA312107	22981	165	0.896552	1.4793108	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	52.8	2.5e-6	NR	MBX9923455.1	2047756	g22815	i0	64.1	0.709090909090909	39	14	70.9	0	119	3	134	172	MBX9923455.1 queuosine precursor transporter [Rhabdochlamydiaceae bacterium]	diamond	117	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31528097	31528097	PRJNA312107_P_NODE_24216_length_164_cov_0.904348_g24050_i0	PRJNA312107	24216	164	0.904348	1.48313072	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	54.3	1.06e-6	NR	MFA6501304.1	2052178	g24050	i0	47.2	0.969512195121951	53	27	95.1	1	162	7	853	905	MFA6501304.1 DEAD/DEAH box helicase [Parachlamydiales bacterium]	diamond	159	54.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales 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);;