metadata: contig_metadata: 17 rows where bioproject = "PRJNA980585", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA980585", 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
6058152	6058152	PRJNA980585_P_NODE_38025_length_257_cov_1.673913_g37771_i0	PRJNA980585	38025	257	1.673913	4.30195641	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	350	7.400000000000001e-92	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g37771	i0	91.221	164.501945525292	262	15	100	7	1	257	2059636	2059378	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	42277	350	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
6373513	6373513	PRJNA980585_P_NODE_7225_length_484_cov_0.856448_g6971_i0	PRJNA980585	7225	484	0.856448	4.14520832	Candidatus Protochlamydia	282132	Bacteria	Bacteria	701	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g6971	i0	92.653	121.256198347107	490	30	100	5	1	484	1250742	1250253	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	58688	701	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
7332960	7332960	PRJNA980585_P_NODE_59306_length_242_cov_0.911243_g59052_i0	PRJNA980585	59306	242	0.911243	2.20520806	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	137	1.3699999999999998e-35	NR	MFA6915771.1	2052178	g59052	i0	88.8	5.9504132231405	80	9	99.2	0	2	241	161	240	MFA6915771.1 ATP-dependent chaperone ClpB [Parachlamydiales bacterium]	diamond	1440	137	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
12434230	12434230	PRJNA980585_P_NODE_48250_length_247_cov_1.551724_g47996_i0	PRJNA980585	48250	247	1.551724	3.83275828	Pseudomonadati	3379134	Bacteria	Bacteria	150	3.95e-40	NR	OGN52361.1	1797595	g47996	i0	86.6	8.96356275303644	82	11	99.6	0	1	246	557	638	OGN52361.1 MAG: DNA-directed RNA polymerase subunit beta [Chlamydiae bacterium GWA2_50_15]	diamond	2214	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium GWA2_50_15
16571847	16571847	PRJNA980585_P_NODE_28493_length_284_cov_1.094787_g28239_i0	PRJNA980585	28493	284	1.094787	3.10919508	Bacteria	2	Bacteria	Bacteria	82.4	3.34e-11	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g28239	i0	94.34	1.48239436619718	53	3	19	0	1	53	2364382	2364434	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	421	82.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23906964	23906964	PRJNA980585_P_NODE_14979_length_360_cov_1.341463_g14725_i0	PRJNA980585	14979	360	1.341463	4.8292668	Simkania sp.	34094	Bacteria	Bacteria	127	7.73e-34	NR	MCB1084310.1	34094	g14725	i0	80.3	0.633333333333333	76	15	63.3	0	131	358	1	76	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	228	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
26677702	26677702	PRJNA980585_P_NODE_61481_length_237_cov_2.792683_g61227_i0	PRJNA980585	61481	237	2.792683	6.61865871	Chlamydiota bacterium	2081524	Bacteria	Bacteria	65.9	2.21e-10	NR	MCX6989805.1	2081524	g61227	i0	68.9	1.08860759493671	45	14	57	0	236	102	185	229	MCX6989805.1 RsmB/NOP family class I SAM-dependent RNA methyltransferase [Chlamydiota bacterium]	diamond	258	65.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
26899695	26899695	PRJNA980585_P_NODE_37841_length_258_cov_1.302703_g37587_i0	PRJNA980585	37841	258	1.302703	3.36097374	Chlamydiota bacterium	2081524	Bacteria	Bacteria	134	3.2399999999999993e-34	NR	MES2122565.1	2081524	g37587	i0	77.6	0.988372093023256	85	19	98.8	0	2	256	24	108	MES2122565.1 hypothetical protein [Chlamydiota bacterium]	diamond	255	134	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27374183	27374183	PRJNA980585_P_NODE_48863_length_247_cov_0.885057_g48609_i0	PRJNA980585	48863	247	0.885057	2.18609079	Chlamydiota bacterium	2081524	Bacteria	Bacteria	117	2.06e-28	NR	NGX54014.1	2081524	g48609	i0	62.8	17.7692307692308	86	27	98.4	1	245	3	455	540	NGX54014.1 Xylulose-5-phosphate phosphoketolase [Chlamydiota bacterium]	diamond	4389	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27405633	27405633	PRJNA980585_P_NODE_52983_length_245_cov_0.895349_g52729_i0	PRJNA980585	52983	245	0.895349	2.19360505	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	94.4	2.19e-20	NR	HEX4839716.1	2047756	g52729	i0	63.6	1.88571428571429	77	27	93.1	1	243	16	69	145	HEX4839716.1 FAD-dependent monooxygenase [Rhabdochlamydiaceae bacterium]	diamond	462	94.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27437247	27437247	PRJNA980585_P_NODE_10383_length_416_cov_7.294461_g10129_i0	PRJNA980585	10383	416	7.294461	30.34495776	Chlamydiales bacterium	2047757	Bacteria	Bacteria	161	8.839999999999998e-48	NR	MCP5470420.1	2047757	g10129	i0	62.7	0.966346153846154	134	50	96.6	0	414	13	2	135	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	402	161	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28542312	28542312	PRJNA980585_P_NODE_28347_length_284_cov_1.459716_g28093_i0	PRJNA980585	28347	284	1.459716	4.14559344	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	51.2	3.83e-5	NR	HEY5259118.1	2047756	g28093	i0	36.6	0.75	71	45	75	0	214	2	6	76	HEY5259118.1 CT253 family lipoprotein [Rhabdochlamydiaceae bacterium]	diamond	213	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29394677	29394677	PRJNA980585_P_NODE_52609_length_245_cov_0.895349_g52355_i0	PRJNA980585	52609	245	0.895349	2.19360505	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	106	9.75e-27	NR	MBX9923211.1	2047756	g52355	i0	67.1	2.9265306122449	79	26	96.7	0	8	244	117	195	MBX9923211.1 adenine phosphoribosyltransferase [Rhabdochlamydiaceae bacterium]	diamond	717	106	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31385103	31385103	PRJNA980585_P_NODE_18056_length_336_cov_1.171103_g17802_i0	PRJNA980585	18056	336	1.171103	3.93490608	Simkania sp.	34094	Bacteria	Bacteria	75.9	6.16e-14	NR	MCB1084310.1	34094	g17802	i0	58.6	0.517857142857143	58	24	51.8	0	334	161	113	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	174	75.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31701247	31701247	PRJNA980585_P_NODE_11057_length_405_cov_3.539157_g10803_i0	PRJNA980585	11057	405	3.539157	14.33358585	Chlamydiales bacterium	2047757	Bacteria	Bacteria	204	1.02e-64	NR	MCP5470420.1	2047757	g10803	i0	80.7	1	135	24	100	1	1	405	3	135	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	405	204	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32334300	32334300	PRJNA980585_P_NODE_17299_length_341_cov_1.384328_g17045_i0	PRJNA980585	17299	341	1.384328	4.72055848	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	55.8	2.86e-6	NR	MCK4934013.1	2698248	g17045	i0	30.6	6.26392961876833	121	68	96.8	4	12	341	189	304	MCK4934013.1 protein kinase [Simkaniaceae bacterium]	diamond	2136	55.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
32555853	32555853	PRJNA980585_P_NODE_58659_length_242_cov_0.911243_g58405_i0	PRJNA980585	58659	242	0.911243	2.20520806	Chlamydiota bacterium	2081524	Bacteria	Bacteria	71.2	1.12e-12	NR	MDP3981347.1	2081524	g58405	i0	55.4	0.694214876033058	56	25	69.4	0	1	168	131	186	MDP3981347.1 VIT1/CCC1 transporter family protein [Chlamydiota bacterium]	diamond	168	71.2	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);;