metadata: contig_metadata: 19 rows where bioproject = "PRJNA1022139", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA1022139", 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
3988128	3988128	PRJNA1022139_P_NODE_11924_length_389_cov_1.531646_g11819_i0	PRJNA1022139	11924	389	1.531646	5.95810294	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	1.11e-40	NR	MCH9608945.1	2047757	g11819	i0	59.7	0.994858611825193	129	49	99.5	1	388	2	38	163	MCH9608945.1 Transaldolase B [Chlamydiales bacterium]	diamond	387	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
16738596	16738596	PRJNA1022139_P_NODE_23274_length_291_cov_1.412844_g23169_i0	PRJNA1022139	23274	291	1.412844	4.11137604	root	1	Root_unresolved	Root_unresolved	123	3.0899999999999993e-31	NR	NBO24982.1	2081524	g23169	i0	56.3	2.94845360824742	96	41	97.9	1	6	290	264	359	NBO24982.1 type III PLP-dependent enzyme [Chlamydiota bacterium]	diamond	858	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
26717974	26717974	PRJNA1022139_P_NODE_2021_length_861_cov_1.475888_g1941_i0	PRJNA1022139	2021	861	1.475888	12.70739568	Chlamydiia bacterium	2052156	Bacteria	Bacteria	53.5	5.59e-4	NR	MCB1112575.1	2052156	g1941	i0	33.8	2.23344947735192	80	50	27.9	1	319	80	434	510	MCB1112575.1 hypothetical protein [Chlamydiia bacterium]	diamond	1923	53.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
26749632	26749632	PRJNA1022139_P_NODE_27541_length_276_cov_1.137931_g27436_i0	PRJNA1022139	27541	276	1.137931	3.14068956	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	113	2.6600000000000003e-27	NR	HEV8052334.1	2052176	g27436	i0	65.9	4.54347826086957	85	27	92.4	1	256	2	1	83	HEV8052334.1 L-serine ammonia-lyase [Parachlamydiaceae bacterium]	diamond	1254	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
26939848	26939848	PRJNA1022139_P_NODE_18742_length_321_cov_2.782258_g18637_i0	PRJNA1022139	18742	321	2.782258	8.93104818	Simkania sp.	34094	Bacteria	Bacteria	124	3.14e-31	NR	MCB1076117.1	34094	g18637	i0	61.2	1.92523364485981	103	40	96.3	0	309	1	204	306	MCB1076117.1 enoyl-CoA hydratase/isomerase family protein [Simkania sp.]	diamond	618	124	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
26971528	26971528	PRJNA1022139_P_NODE_21802_length_300_cov_1.792952_g21697_i0	PRJNA1022139	21802	300	1.792952	5.378856	Chlamydiales bacterium	2047757	Bacteria	Bacteria	70.9	9.37e-12	NR	MFI5343289.1	2047757	g21697	i0	38.3	2.82	94	52	89	2	2	268	478	570	MFI5343289.1 adenylate/guanylate cyclase domain-containing protein [Chlamydiales bacterium]	diamond	846	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27446056	27446056	PRJNA1022139_P_NODE_28603_length_272_cov_1.311558_g28498_i0	PRJNA1022139	28603	272	1.311558	3.56743776	Chlamydiota bacterium	2081524	Bacteria	Bacteria	92.8	1.47e-20	NR	MEM1283418.1	2081524	g28498	i0	49.4	0.981617647058823	89	42	97.1	2	266	3	73	159	MEM1283418.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Chlamydiota bacterium]	diamond	267	92.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27635368	27635368	PRJNA1022139_P_NODE_32424_length_257_cov_2.114130_g32319_i0	PRJNA1022139	32424	257	2.11413	5.4333141	Simkania sp.	34094	Bacteria	Bacteria	62.4	1.22e-10	NR	MCB1084365.1	34094	g32319	i0	46.7	0.875486381322957	75	39	87.5	1	243	19	2	75	MCB1084365.1 hypothetical protein [Simkania sp.]	diamond	225	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27793218	27793218	PRJNA1022139_P_NODE_33804_length_252_cov_1.720670_g33699_i0	PRJNA1022139	33804	252	1.72067	4.3360884	Chlamydia trachomatis	813	Bacteria	Bacteria	79.3	1.57e-16	NR	WP_052526587.1	813	g33699	i0	100	0.452380952380952	38	0	45.2	0	250	137	112	149	WP_052526587.1 conjugal transfer protein TraD [Chlamydia trachomatis]	diamond	114	79.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27982528	27982528	PRJNA1022139_P_NODE_18045_length_327_cov_1.212598_g17940_i0	PRJNA1022139	18045	327	1.212598	3.96519546	Chlamydiales bacterium	2047757	Bacteria	Bacteria	119	2.01e-31	NR	MCP5504210.1	2047757	g17940	i0	54.5	1.02752293577982	112	44	99.1	2	2	325	10	118	MCP5504210.1 GNAT family N-acetyltransferase [Chlamydiales bacterium]	diamond	336	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29024819	29024819	PRJNA1022139_P_NODE_14328_length_360_cov_2.616725_g14223_i0	PRJNA1022139	14328	360	2.616725	9.42021	Chlamydiales bacterium	2047757	Bacteria	Bacteria	186	5.58e-58	NR	MCP5470421.1	2047757	g14223	i0	79.6	1.8	108	22	90	0	359	36	14	121	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	648	186	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29774306	29774306	PRJNA1022139_P_NODE_23731_length_289_cov_1.629630_g23626_i0	PRJNA1022139	23731	289	1.62963	4.7096307	Pseudomonadati	3379134	Bacteria	Bacteria	159	1.7299999999999996e-43	NR	OJU82103.1	1895742	g23626	i0	71	8.66782006920415	93	27	96.5	0	287	9	387	479	OJU82103.1 MAG: phosphoenolpyruvate carboxykinase [Chlamydia sp. 32-24]	diamond	2505	160	0.99375	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24
30469724	30469724	PRJNA1022139_P_NODE_37733_length_247_cov_1.074713_g37628_i0	PRJNA1022139	37733	247	1.074713	2.65454111	root	1	Root_unresolved	Root_unresolved	57.4	2.23e-7	NR	HSX26201.1	2047757	g37628	i0	38	3.40080971659919	79	41	96	1	6	242	64	134	HSX26201.1 hypothetical protein [Chlamydiales bacterium]	diamond	840	57.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30761742	30761742	PRJNA1022139_P_NODE_3674_length_658_cov_2.813675_g3571_i0	PRJNA1022139	3674	658	2.813675	18.5139815	Chlamydiales bacterium	2047757	Bacteria	Bacteria	162	2.3499999999999996e-47	NR	MCP5510012.1	2047757	g3571	i0	57.9	0.638297872340426	140	57	63.8	2	527	108	3	140	MCP5510012.1 EVE domain-containing protein [Chlamydiales bacterium]	diamond	420	162	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31520399	31520399	PRJNA1022139_P_NODE_22936_length_293_cov_1.400000_g22831_i0	PRJNA1022139	22936	293	1.4	4.102	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	56.6	8.55e-7	NR	HEY2810417.1	2047756	g22831	i0	35.1	0.962457337883959	94	55	96.2	1	292	11	124	211	HEY2810417.1 class I SAM-dependent methyltransferase [Rhabdochlamydiaceae bacterium]	diamond	282	56.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31836366	31836366	PRJNA1022139_P_NODE_2217_length_825_cov_8.293883_g2133_i0	PRJNA1022139	2217	825	8.293883	68.42453475	Chlamydiia bacterium	2052156	Bacteria	Bacteria	68.2	1.21e-9	NR	MCB1136078.1	2052156	g2133	i0	49.2	0.44	65	33	23.6	0	507	701	131	195	MCB1136078.1 U-box domain-containing protein [Chlamydiia bacterium]	diamond	363	68.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32089693	32089693	PRJNA1022139_P_NODE_25698_length_282_cov_1.473684_g25593_i0	PRJNA1022139	25698	282	1.473684	4.15578888	Chlamydiota bacterium	2081524	Bacteria	Bacteria	54.3	3.74e-6	NR	MEM1283083.1	2081524	g25593	i0	30.2	0.670212765957447	63	44	67	0	35	223	173	235	MEM1283083.1 DUF4116 domain-containing protein [Chlamydiota bacterium]	diamond	189	54.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32121538	32121538	PRJNA1022139_P_NODE_34418_length_251_cov_0.865169_g34313_i0	PRJNA1022139	34418	251	0.865169	2.17157419	Chlamydiales bacterium	2047757	Bacteria	Bacteria	80.1	4.54e-16	NR	MBI5273578.1	2047757	g34313	i0	50	6.58565737051793	86	37	99.2	2	249	1	140	222	MBI5273578.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium]	diamond	1653	80.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32784652	32784652	PRJNA1022139_P_NODE_6700_length_506_cov_1.808314_g6595_i0	PRJNA1022139	6700	506	1.808314	9.15006884	Simkania sp.	34094	Bacteria	Bacteria	255	2.91e-83	NR	MCB1084310.1	34094	g6595	i0	76.2	0.99604743083004	168	40	99.6	0	3	506	16	183	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	504	255	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania 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);;