metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA975724" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA975724" 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
4774271	4774271	PRJNA975724_S_NODE_33964_length_336_cov_1.171103_g33783_i0	PRJNA975724	33964	336	1.171103	3.93490608	Waddliaceae bacterium	2026802	Bacteria	Bacteria	75.5	2.39e-13	NR	HEY4831209.1	2026802	g33783	i0	50.7	0.651785714285714	73	36	65.2	0	334	116	276	348	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	219	75.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
12425419	12425419	PRJNA975724_S_NODE_44970_length_308_cov_1.310638_g44789_i0	PRJNA975724	44970	308	1.310638	4.03676504	Simkania sp.	34094	Bacteria	Bacteria	184	9.79e-57	NR	MBS3904017.1	34094	g44789	i0	88.2	2.98051948051948	102	12	99.4	0	307	2	75	176	MBS3904017.1 ATP-dependent Clp protease proteolytic subunit [Simkania sp.]	diamond	918	184	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
26899514	26899514	PRJNA975724_S_NODE_56481_length_285_cov_1.292453_g56300_i0	PRJNA975724	56481	285	1.292453	3.68349105	Waddliaceae bacterium	2026802	Bacteria	Bacteria	51.6	8.65e-6	NR	HEY4832334.1	2026802	g56300	i0	61.8	0.357894736842105	34	13	35.8	0	9	110	90	123	HEY4832334.1 uL14 family ribosomal protein [Waddliaceae bacterium]	diamond	102	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
28042991	28042991	PRJNA975724_S_NODE_86865_length_244_cov_1.801170_g86684_i0	PRJNA975724	86865	244	1.80117	4.3948548	Candidatus Protochlamydia	282132	Bacteria	Bacteria	98.6	1.16e-23	NR	WP_075883010.1	1785087	g86684	i0	94.1	3.13524590163934	51	3	62.7	0	91	243	131	181	WP_075883010.1 elongation factor P [Candidatus Protochlamydia sp. W-9]	diamond	765	98.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
28857559	28857559	PRJNA975724_S_NODE_53868_length_290_cov_1.064516_g53687_i0	PRJNA975724	53868	290	1.064516	3.0870964	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	82.8	3.79e-16	NR	HSX04566.1	2047756	g53687	i0	44.9	2.89655172413793	89	49	92.1	0	286	20	52	140	HSX04566.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	840	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29646610	29646610	PRJNA975724_S_NODE_71050_length_261_cov_1.398936_g70869_i0	PRJNA975724	71050	261	1.398936	3.65122296	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	97.8	1.8e-21	NR	MBA3721270.1	2052176	g70869	i0	96	1.14942528735632	50	2	57.5	0	152	3	1	50	MBA3721270.1 chaperonin GroEL [Parachlamydiaceae bacterium]	diamond	300	97.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29868096	29868096	PRJNA975724_S_NODE_27091_length_358_cov_1.270175_g26910_i0	PRJNA975724	27091	358	1.270175	4.5472265	Chlamydiota bacterium	2081524	Bacteria	Bacteria	48.9	8.81e-4	NR	MEC7840285.1	2081524	g26910	i0	30.7	0.737430167597765	88	60	72.9	1	357	97	336	423	MEC7840285.1 hypothetical protein [Chlamydiota bacterium]	diamond	264	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29868110	29868110	PRJNA975724_S_NODE_94311_length_218_cov_4.475862_g94130_i0	PRJNA975724	94311	218	4.475862	9.75737916	Chlamydiia bacterium	2052156	Bacteria	Bacteria	63.5	1.23e-9	NR	MCH9631148.1	2052156	g94130	i0	42.4	2.6697247706422	66	36	88.1	1	217	26	531	596	MCH9631148.1 Phosphoenolpyruvate carboxykinase [GTP] [Chlamydiia bacterium]	diamond	582	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
31517700	31517700	PRJNA975724_S_NODE_58576_length_281_cov_1.634615_g58395_i0	PRJNA975724	58576	281	1.634615	4.59326815	Candidatus Protochlamydia	282132	Bacteria	Bacteria	113	1.04e-26	NR	WP_059060001.1	389348	g58395	i0	56.3	3.02135231316726	96	39	99.3	1	280	2	760	855	WP_059060001.1 efflux RND transporter permease subunit [Candidatus Protochlamydia naegleriophila]	diamond	849	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
31764352	31764352	PRJNA975724_S_NODE_84737_length_246_cov_1.034682_g84556_i0	PRJNA975724	84737	246	1.034682	2.54531772	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	134	1.21e-34	NR	MBA3721406.1	2052176	g84556	i0	73.2	2	82	22	100	0	246	1	458	539	MBA3721406.1 DUF11 domain-containing protein [Parachlamydiaceae bacterium]	diamond	492	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32049075	32049075	PRJNA975724_S_NODE_84598_length_246_cov_1.329480_g84417_i0	PRJNA975724	84598	246	1.32948	3.2705208	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	74.7	7.77e-14	NR	MBA3815700.1	2052176	g84417	i0	49.2	0.768292682926829	63	32	76.8	0	193	5	20	82	MBA3815700.1 F0F1 ATP synthase subunit A [Parachlamydiaceae bacterium]	diamond	189	74.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32397289	32397289	PRJNA975724_S_NODE_56839_length_284_cov_1.824645_g56658_i0	PRJNA975724	56839	284	1.824645	5.1819918	Candidatus Protochlamydia sp.	2687294	Bacteria	Bacteria	52.8	2.24e-6	NR	MBA2369527.1	2687294	g56658	i0	40.9	0.697183098591549	66	35	69.7	1	56	253	1	62	MBA2369527.1 YtxH domain-containing protein [Candidatus Protochlamydia sp.]	diamond	198	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp.

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