metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_species
342697	342697	PRJNA1237347_P_NODE_416781_length_272_cov_5.693467_g410208_i0	PRJNA1237347	416781	272	5.693467	15.48623024	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g410208	i0	100	409.544117647059	272	0	100	0	1	272	849846	850117	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	111396	503	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
344832	344832	PRJNA1237347_P_NODE_534001_length_243_cov_1.811765_g527428_i0	PRJNA1237347	534001	243	1.811765	4.40258895	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	327	3.25e-85	NTclustered	gi\|2621785933\|emb\|OY782391.1\|	2044595	g527428	i0	90.947	89.6378600823045	243	22	100	0	1	243	138146	138388	MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1	blastn	21782	327	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
4170259	4170259	PRJNA1237347_P_NODE_435024_length_265_cov_1.604167_g428451_i0	PRJNA1237347	435024	265	1.604167	4.25104255	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	217	8.119999999999999e-52	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g428451	i0	82.022	10.0981132075472	267	36	100	9	1	265	444796	444540	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	2676	217	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
4172598	4172598	PRJNA1237347_P_NODE_561864_length_234_cov_2.757764_g555290_i0	PRJNA1237347	561864	234	2.757764	6.45316776	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	263	8.89e-66	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g555290	i0	86.92	94.9957264957265	237	27	100	4	1	234	4159186	4159421	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	22229	263	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota		Candidatus Eiseniibacteriota bacterium
6716260	6716260	PRJNA1237347_P_NODE_200326_length_433_cov_1.627778_g193754_i0	PRJNA1237347	200326	433	1.627778	7.04827874	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	322	2.89e-83	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g193754	i0	82.609	69.1270207852194	368	60	85	4	5	370	1295114	1295479	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	29932	322	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
6721088	6721088	PRJNA1237347_P_NODE_442846_length_262_cov_1.396825_g436273_i0	PRJNA1237347	442846	262	1.396825	3.6596815	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g436273	i0	100	0.217557251908397	29	0	11	0	205	233	672501	672473	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	57	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium
6724451	6724451	PRJNA1237347_P_NODE_99106_length_685_cov_3.651961_g92727_i0	PRJNA1237347	99106	685	3.651961	25.01593285	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	806	0	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g92727	i0	87.954	488.442335766423	689	75	100	7	1	685	383694	384378	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	334583	806	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
7991911	7991911	PRJNA1237347_P_NODE_200127_length_433_cov_2.263889_g193555_i0	PRJNA1237347	200127	433	2.263889	9.80263937	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	60.2	2.5e-4	NTclustered	gi\|2108210926\|gb\|CP070702.1\|	2212470	g193555	i0	97.143	0.173210161662818	35	1	8	0	391	425	1621140	1621106	MAG: Candidatus Eiseniibacteriota bacterium isolate bin56 chromosome	blastn	75	60.2	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota		Candidatus Eiseniibacteriota bacterium
9270747	9270747	PRJNA1237347_P_NODE_407368_length_276_cov_2.275862_g400795_i0	PRJNA1237347	407368	276	2.275862	6.28137912	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	285	2.3e-72	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g400795	i0	85.455	201.442028985507	275	39	99	1	2	276	383420	383693	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	55598	285	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
9271116	9271116	PRJNA1237347_P_NODE_426788_length_268_cov_2.830769_g420215_i0	PRJNA1237347	426788	268	2.830769	7.58646092	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	178	3.88e-40	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g420215	i0	78.889	1.00746268656716	270	51	99	5	2	268	626393	626659	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	270	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium TM7i
10548892	10548892	PRJNA1237347_P_NODE_528129_length_244_cov_0.900585_g521556_i0	PRJNA1237347	528129	244	0.900585	2.1974274	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g521556	i0	100	1	244	0	100	0	1	244	273942	274185	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	244	451	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11819898	11819898	PRJNA1237347_P_NODE_333590_length_312_cov_2.564854_g327017_i0	PRJNA1237347	333590	312	2.564854	8.00234448	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	246	1.25e-60	NTclustered	gi\|2621785933\|emb\|OY782391.1\|	2044595	g327017	i0	84.109	62.9294871794872	258	37	81	3	1	254	139629	139372	MAG: Candidatus Gracilibacteria bacterium isolate 3657eba1-8dd3-48ff-b7f3-7c2c16b724d5 genome assembly, chromosome: 1	blastn	19634	246	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
13090570	13090570	PRJNA1237347_P_NODE_129831_length_575_cov_2.231076_g123304_i0	PRJNA1237347	129831	575	2.231076	12.828687	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	464	6.15e-126	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g123304	i0	81.538	12.9026086956522	585	88	100	16	1	575	125571	126145	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	7419	464	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
14373658	14373658	PRJNA1237347_P_NODE_517732_length_245_cov_1.790698_g511159_i0	PRJNA1237347	517732	245	1.790698	4.3872101	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|1958035545\|gb\|CP064978.1\|	2030811	g511159	i0	80.269	8.50204081632653	223	34	90	8	1	221	440601	440815	MAG: Candidatus Peregrinibacteria bacterium isolate Fred_18-Q3-R57-64_BAT3C.1_cln chromosome, complete genome	blastn	2083	159	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
15642959	15642959	PRJNA1237347_P_NODE_273313_length_354_cov_1.608541_g266740_i0	PRJNA1237347	273313	354	1.608541	5.69423514	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	276	1.83e-69	NTclustered	gi\|1995742126\|gb\|CP070993.1\|	2030810	g266740	i0	81.18	6.81073446327684	356	55	99	10	1	350	403793	403444	MAG: Candidatus Kaiserbacteria bacterium isolate FR12parc1 chromosome, complete genome	blastn	2411	276	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium
15645488	15645488	PRJNA1237347_P_NODE_405433_length_277_cov_1.740196_g398860_i0	PRJNA1237347	405433	277	1.740196	4.82034292	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	189	1.86e-43	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g398860	i0	79.514	31.9314079422383	288	42	99	7	1	275	531594	531877	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	8845	189	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
16918650	16918650	PRJNA1237347_P_NODE_351574_length_302_cov_1.978166_g345001_i0	PRJNA1237347	351574	302	1.978166	5.97406132	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	503	6.459999999999998e-138	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g345001	i0	96.689	203.023178807947	302	10	100	0	1	302	4159089	4158788	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	61313	503	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota		Candidatus Eiseniibacteriota bacterium
16922508	16922508	PRJNA1237347_P_NODE_554234_length_241_cov_0.916667_g547661_i0	PRJNA1237347	554234	241	0.916667	2.20916747	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	239	1.55e-58	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g547661	i0	84.583	0.995850622406639	240	37	99	0	1	240	657322	657561	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	240	239	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium TM7i
18194702	18194702	PRJNA1237347_P_NODE_432855_length_266_cov_1.523316_g426282_i0	PRJNA1237347	432855	266	1.523316	4.05202056	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g426282	i0	99.248	1	266	2	100	0	1	266	103085	103350	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	266	481	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
19464342	19464342	PRJNA1237347_P_NODE_190996_length_447_cov_1.425134_g184424_i0	PRJNA1237347	190996	447	1.425134	6.37034898	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	407	8.019999999999999e-109	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g184424	i0	84.915	180.923937360179	411	53	91	7	4	411	443761	443357	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	80873	407	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
19469662	19469662	PRJNA1237347_P_NODE_458016_length_256_cov_1.426230_g451443_i0	PRJNA1237347	458016	256	1.42623	3.6511488	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	217	7.8e-52	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g451443	i0	86.139	1.56640625	202	27	79	1	20	221	1016334	1016134	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	401	217	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
19471397	19471397	PRJNA1237347_P_NODE_553936_length_241_cov_0.916667_g547363_i0	PRJNA1237347	553936	241	0.916667	2.20916747	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	106	1.64e-18	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g547363	i0	94.203	4.52282157676349	69	4	29	0	64	132	197492	197424	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	1090	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		uncultured Candidatus Saccharibacteria bacterium
20742833	20742833	PRJNA1237347_P_NODE_34177_length_1323_cov_6.246400_g30344_i0	PRJNA1237347	34177	1323	6.2464	82.639872	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	2442	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g30344	i0	100	241.784580498866	1322	0	99	0	2	1323	851682	850361	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	319881	2442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23294758	23294758	PRJNA1237347_P_NODE_394279_length_282_cov_1.425837_g387706_i0	PRJNA1237347	394279	282	1.425837	4.02086034	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	213	1.13e-50	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g387706	i0	81.159	52.8723404255319	276	42	96	9	10	281	886197	885928	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	14910	213	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium
24000254	24000254	PRJNA1237347_P_NODE_29359_length_1442_cov_9.877283_g25900_i0	PRJNA1237347	29359	1442	9.877283	142.43042086	Bacteria	2	Bacteria	Bacteria	2632	0	NTclustered	gi\|686400545\|dbj\|LC002961.1\|	171954	g25900	i0	99.86	97.4500693481276	1432	1	99	1	11	1441	2	1433	Uncultured candidate division TM6 bacterium gene for 16S ribosomal RNA, partial sequence, clone: 4X109	blastn	140523	2658	0.990218209179834	Bacteria	Bacteria candidate phyla			uncultured Candidatus Babelota 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);;