metadata: contig_metadata: 12 rows where bioproject = "PRJNA876641" and tax

12 rows where bioproject = "PRJNA876641" 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
12332244	12332244	PRJNA876641_P_NODE_17130_length_249_cov_1.312500_g17056_i0	PRJNA876641	17130	249	1.3125	3.268125	Simkania sp.	34094	Bacteria	Bacteria	146	9.969999999999999e-43	NR	MCB1084350.1	34094	g17056	i0	75.9	3.95180722891566	83	20	100	0	1	249	8	90	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	984	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27939774	27939774	PRJNA876641_P_NODE_13305_length_263_cov_2.089474_g13231_i0	PRJNA876641	13305	263	2.089474	5.49531662	Chlamydiales bacterium	2047757	Bacteria	Bacteria	61.2	3.78e-9	NR	MDP1609002.1	2047757	g13231	i0	43.5	0.787072243346008	69	39	78.7	0	57	263	6	74	MDP1609002.1 hypothetical protein [Chlamydiales bacterium]	diamond	207	61.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27939778	27939778	PRJNA876641_P_NODE_16645_length_250_cov_0.870056_g16571_i0	PRJNA876641	16645	250	0.870056	2.17514	Candidatus Rhabdochlamydia sp. T3358	2099795	Bacteria	Bacteria	49.7	1.39e-4	NR	WP_138106665.1	2099795	g16571	i0	41.7	1.008	84	42	96	4	245	6	77	157	WP_138106665.1 flavin monoamine oxidase family protein [Candidatus Rhabdochlamydia sp. T3358]	diamond	252	49.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp. T3358
28508062	28508062	PRJNA876641_P_NODE_9087_length_287_cov_1.439252_g9013_i0	PRJNA876641	9087	287	1.439252	4.13065324	Candidatus Neptunochlamydia vexilliferae	1651774	Bacteria	Bacteria	134	4.42e-36	NR	WP_320412044.1	1651774	g9013	i0	68.5	2.58188153310105	92	25	96.2	1	287	12	179	266	WP_320412044.1 transaldolase [Candidatus Neptunochlamydia vexilliferae]	diamond	741	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia vexilliferae
29139727	29139727	PRJNA876641_P_NODE_20869_length_244_cov_0.900585_g20795_i0	PRJNA876641	20869	244	0.900585	2.1974274	Chlamydiota bacterium	2081524	Bacteria	Bacteria	43.5	0.0208	NR	MBI1870221.1	2081524	g20795	i0	45.7	0.430327868852459	35	18	41.8	1	231	130	728	762	MBI1870221.1 fibronectin type III domain-containing protein [Chlamydiota bacterium]	diamond	105	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31097750	31097750	PRJNA876641_P_NODE_13375_length_263_cov_1.463158_g13301_i0	PRJNA876641	13375	263	1.463158	3.84810554	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	51.6	3.57e-5	NR	MCK4934525.1	2698248	g13301	i0	41.5	0.741444866920152	65	38	74.1	0	38	232	377	441	MCK4934525.1 sel1 repeat family protein [Simkaniaceae bacterium]	diamond	195	51.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
31160724	31160724	PRJNA876641_P_NODE_16675_length_250_cov_0.870056_g16601_i0	PRJNA876641	16675	250	0.870056	2.17514	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	53.5	6.65e-6	NR	MBA3238848.1	2052176	g16601	i0	33.8	0.96	80	50	96	1	2	241	27	103	MBA3238848.1 DUF4116 domain-containing protein [Parachlamydiaceae bacterium]	diamond	240	53.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31445720	31445720	PRJNA876641_P_NODE_7616_length_304_cov_1.329004_g7542_i0	PRJNA876641	7616	304	1.329004	4.04017216	Chlamydiales bacterium	2047757	Bacteria	Bacteria	101	6.81e-25	NR	MCP5470420.1	2047757	g7542	i0	67.9	0.828947368421053	84	27	82.9	0	304	53	64	147	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	252	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31920195	31920195	PRJNA876641_P_NODE_18277_length_248_cov_0.880000_g18203_i0	PRJNA876641	18277	248	0.88	2.1824	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	55.8	7.9e-7	NR	MBA3815591.1	2052176	g18203	i0	38.3	0.979838709677419	81	45	95.6	3	238	2	3	80	MBA3815591.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	243	55.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32678756	32678756	PRJNA876641_P_NODE_5300_length_344_cov_2.136531_g5226_i0	PRJNA876641	5300	344	2.136531	7.34966664	Chlamydiota bacterium	2081524	Bacteria	Bacteria	117	4.62e-29	NR	MCX6987222.1	2081524	g5226	i0	66	1.83139534883721	97	30	84.6	1	53	343	2	95	MCX6987222.1 transaldolase [Chlamydiota bacterium]	diamond	630	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32812899	32812899	PRJNA876641_P_NODE_7840_length_301_cov_0.745614_g7766_i0	PRJNA876641	7840	301	0.745614	2.24429814	Bacteria	2	Bacteria	Bacteria	61.6	1.48e-8	NR	WP_013181660.1	71667	g7766	i0	32	3.62790697674419	100	68	99.7	0	2	301	197	296	WP_013181660.1 zinc-binding dehydrogenase [Waddlia chondrophila]	diamond	1092	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
32836339	32836339	PRJNA876641_P_NODE_21900_length_243_cov_0.905882_g21826_i0	PRJNA876641	21900	243	0.905882	2.20129326	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.0037	NR	NGX57875.1	2081524	g21826	i0	46.2	1.06172839506173	39	21	48.1	0	113	229	33	71	NGX57875.1 hypothetical protein [Chlamydiota bacterium]	diamond	258	45.4	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);;