metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
924830	924830	PRJNA944406_P_NODE_68541_length_250_cov_0.870056_g67582_i0	PRJNA944406	68541	250	0.870056	2.17514	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	231	2.7099999999999996e-56	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g67582	i0	83.465	28.552	254	36	100	3	1	250	653698	653949	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	7138	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
4752594	4752594	PRJNA944406_P_NODE_12004_length_363_cov_1.327586_g11045_i0	PRJNA944406	12004	363	1.327586	4.81913718	Estrella lausannensis	483423	Bacteria	Bacteria	412	1.3699999999999998e-110	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g11045	i0	87.293	97.0633608815427	362	45	99	1	1	362	1301	941	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	35234	412	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
6027413	6027413	PRJNA944406_P_NODE_16365_length_319_cov_1.869919_g15406_i0	PRJNA944406	16365	319	1.869919	5.96504161	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	436	7.069999999999999e-118	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g15406	i0	91.536	148.711598746082	319	23	99	4	3	319	652881	653197	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	47439	436	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
6028054	6028054	PRJNA944406_P_NODE_7145_length_472_cov_1.852130_g6189_i0	PRJNA944406	7145	472	1.85213	8.7420536	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	582	1.3199999999999999e-161	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g6189	i0	89.099	106.491525423729	477	41	99	10	1	471	1249088	1249559	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	50264	582	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
8577277	8577277	PRJNA944406_P_NODE_26547_length_285_cov_1.452830_g25588_i0	PRJNA944406	26547	285	1.45283	4.1405655	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	370	6.4e-98	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g25588	i0	90.141	55.2350877192982	284	28	99	0	2	285	653811	654094	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	15742	370	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9852508	9852508	PRJNA944406_P_NODE_36728_length_275_cov_2.975248_g35769_i0	PRJNA944406	36728	275	2.975248	8.181932	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	398	2.8199999999999996e-106	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g35769	i0	92.727	175.672727272727	275	20	100	0	1	275	653288	653014	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48310	398	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11463240	11463240	PRJNA944406_P_NODE_34569_length_278_cov_0.868293_g33610_i0	PRJNA944406	34569	278	0.868293	2.41385454	Neochlamydia	112987	Bacteria	Bacteria	278	3.88e-70	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g33610	i0	84.783	42.6079136690648	276	42	99	0	1	276	653981	653706	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	11845	278	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
12403414	12403414	PRJNA944406_P_NODE_17930_length_309_cov_2.114407_g16971_i0	PRJNA944406	17930	309	2.114407	6.53351763	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	276	1.57e-69	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g16971	i0	83.498	134.42071197411	303	43	97	6	1	301	654954	655251	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	41536	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
12738673	12738673	PRJNA944406_P_NODE_105070_length_242_cov_0.911243_g104111_i0	PRJNA944406	105070	242	0.911243	2.20520806	Candidatus Protochlamydia	282132	Bacteria	Bacteria	257	4.3e-64	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g104111	i0	86.192	71.7190082644628	239	32	99	1	4	242	1251382	1251145	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	17356	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
13678032	13678032	PRJNA944406_P_NODE_2491_length_878_cov_1.388820_g1733_i0	PRJNA944406	2491	878	1.38882	12.1938396	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1170	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1733	i0	90.785	166.748291571754	879	76	99	5	2	878	654457	653582	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	146405	1170	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
13678282	13678282	PRJNA944406_P_NODE_47331_length_266_cov_1.046632_g46372_i0	PRJNA944406	47331	266	1.046632	2.78404112	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	198	2.95e-46	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g46372	i0	80.586	30.2781954887218	273	40	100	13	1	266	653963	653697	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	8054	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14953004	14953004	PRJNA944406_P_NODE_90532_length_245_cov_0.895349_g89573_i0	PRJNA944406	90532	245	0.895349	2.19360505	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	309	1.19e-79	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g89573	i0	89.388	11.1224489795918	245	26	100	0	1	245	2060199	2059955	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	2725	309	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15287410	15287410	PRJNA944406_P_NODE_54892_length_258_cov_2.686486_g53933_i0	PRJNA944406	54892	258	2.686486	6.93113388	Candidatus Protochlamydia	282132	Bacteria	Bacteria	387	5.67e-103	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g53933	i0	93.774	534.62015503876	257	16	99	0	1	257	2154205	2153949	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	137932	388	0.997422680412371	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
16227904	16227904	PRJNA944406_P_NODE_84073_length_246_cov_3.462428_g83114_i0	PRJNA944406	84073	246	3.462428	8.51757288	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	337	5.479999999999998e-88	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g83114	i0	93.074	112.540650406504	231	14	94	2	10	240	415202	414974	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	27685	337	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17502709	17502709	PRJNA944406_P_NODE_3754_length_690_cov_6.032415_g2869_i0	PRJNA944406	3754	690	6.032415	41.6236635	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1007	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2869	i0	93.064	139.560869565217	692	42	99	6	1	689	1250322	1249634	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	96297	1007	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
18776784	18776784	PRJNA944406_P_NODE_84315_length_246_cov_1.780347_g83356_i0	PRJNA944406	84315	246	1.780347	4.37965362	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	150	7.659999999999999e-32	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g83356	i0	81.383	2.05284552845528	188	32	76	3	59	244	1756153	1756339	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	505	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19110699	19110699	PRJNA944406_P_NODE_110135_length_241_cov_0.916667_g109176_i0	PRJNA944406	110135	241	0.916667	2.20916747	Parachlamydia	83551	Bacteria	Bacteria	243	1.2e-59	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g109176	i0	85.062	36.50622406639	241	32	99	2	3	241	1430	1668	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	8798	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
19110898	19110898	PRJNA944406_P_NODE_65555_length_251_cov_0.865169_g64596_i0	PRJNA944406	65555	251	0.865169	2.17157419	Waddlia	71666	Bacteria	Bacteria	180	1e-40	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g64596	i0	80.159	192.577689243028	252	40	99	10	1	250	1432	1675	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	48337	180	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
21326790	21326790	PRJNA944406_P_NODE_51537_length_262_cov_1.222222_g50578_i0	PRJNA944406	51537	262	1.222222	3.20222164	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	261	3.65e-65	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g50578	i0	84.758	190.988549618321	269	31	100	9	1	262	655242	654977	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	50039	261	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21661765	21661765	PRJNA944406_P_NODE_58517_length_255_cov_1.692308_g57558_i0	PRJNA944406	58517	255	1.692308	4.3153854	Candidatus Protochlamydia	282132	Bacteria	Bacteria	305	1.61e-78	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g57558	i0	88.281	21.2156862745098	256	29	100	1	1	255	1249862	1250117	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	5410	305	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
23877695	23877695	PRJNA944406_P_NODE_9159_length_411_cov_1.952663_g8200_i0	PRJNA944406	9159	411	1.952663	8.02544493	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	503	9.069999999999998e-138	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g8200	i0	88.702	413.936739659367	416	41	100	6	1	411	655328	654914	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	170128	503	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
23877727	23877727	PRJNA944406_P_NODE_95219_length_244_cov_0.900585_g94260_i0	PRJNA944406	95219	244	0.900585	2.1974274	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g94260	i0	94.583	141.377049180328	240	13	98	0	3	242	652467	652706	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	34496	372	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
25150779	25150779	PRJNA944406_P_NODE_45200_length_267_cov_3.881443_g44241_i0	PRJNA944406	45200	267	3.881443	10.36345281	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	472	1.5799999999999998e-128	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g44241	i0	98.502	141.123595505618	267	4	100	0	1	267	1250263	1249997	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	37680	472	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25150931	25150931	PRJNA944406_P_NODE_58360_length_255_cov_1.692308_g57401_i0	PRJNA944406	58360	255	1.692308	4.3153854	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	285	2.1e-72	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g57401	i0	89.565	72.5607843137255	230	16	89	6	30	255	1249221	1249446	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	18503	285	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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