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

7 rows where bioproject = "PRJNA564013", 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
10060341	10060341	PRJNA564013_P_NODE_193508_length_312_cov_5.306773_g190657_i0	PRJNA564013	193508	312	5.306773	16.55713176	Chlamydia	810	Bacteria	Bacteria	483	8.729999999999998e-132	NTclustered	gi\|2160499992\|gb\|CP042720.1\|	813	g190657	i0	99.251	85.5769230769231	267	2	86	0	23	289	662119	662385	Chlamydia trachomatis strain TC0080-IGR-TC0081::TncL2/tetR-1645 chromosome, complete genome	blastn	26700	483	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27173867	27173867	PRJNA564013_P_NODE_308742_length_220_cov_2.132075_g305890_i0	PRJNA564013	308742	220	2.132075	4.690565	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	76.3	1.25e-16	NR	MEI8125691.1	2052176	g305890	i0	90.7	1.22727272727273	43	4	58.6	0	130	2	1	43	MEI8125691.1 50S ribosomal protein L34 [Parachlamydiaceae bacterium]	diamond	270	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27995301	27995301	PRJNA564013_P_NODE_22805_length_778_cov_29.422594_g20453_i0	PRJNA564013	22805	778	29.422594	228.90778132	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	65.5	3.43e-8	NR	MBP9841150.1	2698248	g20453	i0	42.6	0.262210796915167	68	39	26.2	0	513	310	302	369	MBP9841150.1 hypothetical protein [Simkaniaceae bacterium]	diamond	204	65.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
28658428	28658428	PRJNA564013_P_NODE_242867_length_267_cov_5.116505_g240015_i0	PRJNA564013	242867	267	5.116505	13.66106835	Chlamydia psittaci 1	83554	Bacteria	Bacteria	63.5	2.81e-11	NR	EPP36750.1	1238236	g240015	i0	100	0.314606741573034	28	0	31.5	0	97	14	24	51	EPP36750.1 hypothetical protein CP10743SC13_2238, partial [Chlamydia psittaci 10_743_SC13]	diamond	84	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30503848	30503848	PRJNA564013_P_NODE_94853_length_419_cov_7.435754_g92020_i0	PRJNA564013	94853	419	7.435754	31.15580926	Chlamydiia	204429	Bacteria	Bacteria	143	9.84e-38	NR	WP_068466327.1	1414722	g92020	i0	56.1	8.26968973747017	132	51	90.2	3	25	402	7	137	WP_068466327.1 pyruvate dehydrogenase complex dihydrolipoamide acetyltransferase [Candidatus Protochlamydia phocaeensis]	diamond	3465	144	0.993055555555556	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
30788168	30788168	PRJNA564013_P_NODE_70994_length_479_cov_10.339713_g68182_i0	PRJNA564013	70994	479	10.339713	49.52722527	Estrella	483422	Bacteria	Bacteria	213	1.45e-60	NR	WP_098037575.1	483423	g68182	i0	73.3	4.57202505219207	146	39	91.4	0	18	455	545	690	WP_098037575.1 transcription-repair coupling factor [Estrella lausannensis]	diamond	2190	213	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
31578485	31578485	PRJNA564013_P_NODE_209896_length_297_cov_1.652542_g207045_i0	PRJNA564013	209896	297	1.652542	4.90804974	Bacteria	2	Bacteria	Bacteria	60.5	1.82e-8	NR	NGX45826.1	2081524	g207045	i0	63.9	1.57575757575758	36	13	36.4	0	190	297	6	41	NGX45826.1 hypothetical protein [Chlamydiota bacterium]	diamond	468	60.5	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);;