metadata: contig_metadata: 11 rows where bioproject = "PRJNA812715", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA812715", 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
9742581	9742581	PRJNA812715_P_NODE_81488_length_282_cov_1.382775_g79688_i0	PRJNA812715	81488	282	1.382775	3.8994255	Chlamydiales bacterium	2047757	Bacteria	Bacteria	159	7e-43	NR	MCH9626528.1	2047757	g79688	i0	76.1	2.9468085106383	92	22	97.9	0	279	4	12	103	MCH9626528.1 1,4-alpha-glucan branching enzyme GlgB [Chlamydiales bacterium]	diamond	831	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
26769441	26769441	PRJNA812715_P_NODE_124341_length_226_cov_5.718954_g122540_i0	PRJNA812715	124341	226	5.718954	12.92483604	Chlamydia trachomatis	813	Bacteria	Bacteria	57.8	2.53e-8	NR	WP_323848342.1	813	g122540	i0	68.1	48.0398230088496	47	15	62.4	0	225	85	23	69	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	10857	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27411010	27411010	PRJNA812715_P_NODE_83643_length_278_cov_5.990244_g81843_i0	PRJNA812715	83643	278	5.990244	16.65287832	root	1	Root_unresolved	Root_unresolved	64.3	1.37e-10	NR	WP_323848342.1	813	g81843	i0	73.2	36	41	11	44.2	0	277	155	25	65	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	10008	64.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27433795	27433795	PRJNA812715_P_NODE_45503_length_407_cov_7.032934_g43707_i0	PRJNA812715	45503	407	7.032934	28.62404138	Chlamydia suis	83559	Bacteria	Bacteria	110	4.86e-28	NR	WP_323820768.1	83559	g43707	i0	68.4	41.4766584766585	79	25	58.2	0	406	170	60	138	WP_323820768.1 hypothetical protein [Chlamydia suis]	diamond	16881	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia suis
28444093	28444093	PRJNA812715_P_NODE_84466_length_277_cov_1.803922_g82666_i0	PRJNA812715	84466	277	1.803922	4.99686394	Chlamydiia bacterium	2052156	Bacteria	Bacteria	84.7	9.01e-17	NR	MCB1119603.1	2052156	g82666	i0	47.3	0.985559566787004	91	47	98.6	1	1	273	385	474	MCB1119603.1 6-phosphofructokinase [Chlamydiia bacterium]	diamond	273	84.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
28507121	28507121	PRJNA812715_P_NODE_111167_length_246_cov_0.988439_g109366_i0	PRJNA812715	111167	246	0.988439	2.43155994	Chlamydia trachomatis	813	Bacteria	Bacteria	63.9	1.29e-10	NR	WP_323848342.1	813	g109366	i0	67.4	43	43	14	52.4	0	113	241	16	58	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	10578	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31254976	31254976	PRJNA812715_P_NODE_79275_length_285_cov_2.641509_g77475_i0	PRJNA812715	79275	285	2.641509	7.52830065	Chlamydia trachomatis	813	Bacteria	Bacteria	58.2	3.69e-8	NR	WP_323848342.1	813	g77475	i0	62.3	42.9578947368421	53	20	55.8	0	1	159	32	84	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	12243	58.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31571456	31571456	PRJNA812715_P_NODE_104556_length_250_cov_0.870056_g102755_i0	PRJNA812715	104556	250	0.870056	2.17514	Candidatus Protochlamydia sp. R18	1353977	Bacteria	Bacteria	116	2.31e-28	NR	WP_042282224.1	1353977	g102755	i0	68.8	11.448	80	25	96	0	248	9	271	350	WP_042282224.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Candidatus Protochlamydia sp. R18]	diamond	2862	116	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. R18
31634441	31634441	PRJNA812715_P_NODE_119716_length_242_cov_0.911243_g117915_i0	PRJNA812715	119716	242	0.911243	2.20520806	Chlamydiia bacterium	2052156	Bacteria	Bacteria	50.1	8.12e-5	NR	MCB1108814.1	2052156	g117915	i0	30.7	0.929752066115702	75	52	93	0	5	229	138	212	MCB1108814.1 hypothetical protein [Chlamydiia bacterium]	diamond	225	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
31792470	31792470	PRJNA812715_P_NODE_121337_length_241_cov_0.916667_g119536_i0	PRJNA812715	121337	241	0.916667	2.20916747	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	84.7	6.01e-17	NR	MBA3816865.1	2052176	g119536	i0	61.2	0.83402489626556	67	26	83.4	0	22	222	288	354	MBA3816865.1 DUF3419 family protein [Parachlamydiaceae bacterium]	diamond	201	84.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32646237	32646237	PRJNA812715_P_NODE_72080_length_300_cov_7.400881_g70280_i0	PRJNA812715	72080	300	7.400881	22.202643	Chlamydia trachomatis	813	Bacteria	Bacteria	72	1.85e-13	NR	WP_323848342.1	813	g70280	i0	71.7	40.81	53	15	53	0	1	159	37	89	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	12243	72	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);;