metadata: contig_metadata: 24 rows where bioproject = "PRJNA975724" and tax

24 rows where 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
2542439	2542439	PRJNA975724_S_NODE_18222_length_395_cov_2.062112_g18041_i0	PRJNA975724	18222	395	2.062112	8.1453424	Candidatus Protochlamydia	282132	Bacteria	Bacteria	604	2.309999999999999e-168	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g18041	i0	95.276	186.643037974684	381	18	96	0	15	395	1249125	1249505	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	73724	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
3497271	3497271	PRJNA975724_S_NODE_60783_length_277_cov_2.132353_g60602_i0	PRJNA975724	60783	277	2.132353	5.90661781	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	4.6499999999999983e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g60602	i0	95.341	155.447653429603	279	9	100	3	1	277	654468	654192	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43059	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
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
7323845	7323845	PRJNA975724_S_NODE_31806_length_342_cov_2.003717_g31625_i0	PRJNA975724	31806	342	2.003717	6.85271214	Estrella lausannensis	483423	Bacteria	Bacteria	302	2.91e-77	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g31625	i0	82.659	169.72514619883	346	54	100	6	1	342	1574	1231	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	58046	302	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
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.
12425695	12425695	PRJNA975724_S_NODE_55050_length_287_cov_42.383178_g54869_i0	PRJNA975724	55050	287	42.383178	121.63972086	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	351	2.34e-92	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g54869	i0	90.84	43.0174216027875	262	24	91	0	1	262	173622	173361	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	12346	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
14974537	14974537	PRJNA975724_S_NODE_6072_length_501_cov_1.619159_g5893_i0	PRJNA975724	6072	501	1.619159	8.11198659	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	604	2.9999999999999985e-168	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g5893	i0	89.979	270.916167664671	469	45	93	2	1	468	2363973	2364440	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	135729	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16569312	16569312	PRJNA975724_S_NODE_53573_length_290_cov_2.129032_g53392_i0	PRJNA975724	53573	290	2.129032	6.1741928	Parachlamydiales	1963360	Bacteria	Bacteria	331	3.0800000000000006e-86	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g53392	i0	87.543	108.931034482759	289	32	99	4	3	289	3414	3700	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	31590	333	0.993993993993994	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
17523797	17523797	PRJNA975724_S_NODE_27234_length_357_cov_2.982394_g27053_i0	PRJNA975724	27234	357	2.982394	10.64714658	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	499	1e-136	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g27053	i0	91.899	178.086834733894	358	27	100	2	1	357	2362895	2363251	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	63577	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17524284	17524284	PRJNA975724_S_NODE_46154_length_305_cov_2.280172_g45973_i0	PRJNA975724	46154	305	2.280172	6.9545246	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	322	1.96e-83	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g45973	i0	87.544	66.0360655737705	281	32	91	3	15	293	1250339	1250618	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20141	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18797768	18797768	PRJNA975724_S_NODE_33195_length_338_cov_1.520755_g33014_i0	PRJNA975724	33195	338	1.520755	5.1401519	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	135	3.0800000000000004e-27	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g33014	i0	76.744	2.45562130177515	301	35	86	24	26	315	112016	111740	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	830	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
20073121	20073121	PRJNA975724_S_NODE_53916_length_290_cov_1.018433_g53735_i0	PRJNA975724	53916	290	1.018433	2.9534557	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	329	1.1099999999999998e-85	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g53735	i0	87.119	113.451724137931	295	32	100	5	1	290	654929	655222	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32901	329	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21669159	21669159	PRJNA975724_S_NODE_67577_length_266_cov_1.860104_g67396_i0	PRJNA975724	67577	266	1.860104	4.94787664	Chlamydiia	204429	Bacteria	Bacteria	407	4.509999999999999e-109	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g67396	i0	94.361	114.53007518797	266	14	100	1	1	266	2363602	2363866	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	30465	407	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23898769	23898769	PRJNA975724_S_NODE_47159_length_303_cov_1.673913_g46978_i0	PRJNA975724	47159	303	1.673913	5.07195639	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	272	1.99e-68	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g46978	i0	84.397	663.425742574257	282	38	92	6	20	297	2364438	2364159	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	201018	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
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);;