metadata: contig_metadata: 27 rows where bioproject = "PRJNA1174207" and tax

27 rows where bioproject = "PRJNA1174207" 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_order	tax_family	tax_genus	tax_species
315771	315771	PRJNA1174207_P_NODE_32161_length_255_cov_3.472527_g31632_i0	PRJNA1174207	32161	255	3.472527	8.85494385	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	455	1.51e-123	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g31632	i0	98.824	218.450980392157	255	3	100	0	1	255	138767	139021	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	55705	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
3591189	3591189	PRJNA1174207_P_NODE_38343_length_245_cov_0.895349_g37814_i0	PRJNA1174207	38343	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	182	2.7e-41	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g37814	i0	85.965	4.92244897959184	171	23	70	1	1	171	125886	126055	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1206	183	0.994535519125683	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
4868650	4868650	PRJNA1174207_P_NODE_26244_length_280_cov_2.019324_g25715_i0	PRJNA1174207	26244	280	2.019324	5.6541072	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g25715	i0	98.929	108.967857142857	280	3	100	0	1	280	146809	146530	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	30511	501	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
5418901	5418901	PRJNA1174207_P_NODE_37765_length_246_cov_0.890173_g37236_i0	PRJNA1174207	37765	246	0.890173	2.18982558	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g37236	i0	100	1	246	0	100	0	1	246	66746	66501	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	246	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5418932	5418932	PRJNA1174207_P_NODE_39545_length_243_cov_1.670588_g39016_i0	PRJNA1174207	39545	243	1.670588	4.05952884	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	71.3	6.05e-8	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g39016	i0	82.558	1.90534979423868	86	10	35	5	158	241	628318	628400	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	463	71.3	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9243360	9243360	PRJNA1174207_P_NODE_19428_length_322_cov_1.116466_g18899_i0	PRJNA1174207	19428	322	1.116466	3.59502052	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	420	7.19e-113	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g18899	i0	90.373	137.965838509317	322	27	99	4	1	320	3738050	3737731	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	44425	420	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
11243908	11243908	PRJNA1174207_P_NODE_28549_length_270_cov_2.766497_g28020_i0	PRJNA1174207	28549	270	2.766497	7.4695419	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	451	2.09e-122	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g28020	i0	97.026	201.644444444444	269	6	99	2	1	268	146227	146494	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	54444	451	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
14344419	14344419	PRJNA1174207_P_NODE_17352_length_342_cov_3.055762_g16823_i0	PRJNA1174207	17352	342	3.055762	10.45070604	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	532	9.47e-147	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g16823	i0	94.737	66.6169590643275	342	18	100	0	1	342	111393	111734	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	22783	532	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
14344680	14344680	PRJNA1174207_P_NODE_31552_length_258_cov_1.664865_g31023_i0	PRJNA1174207	31552	258	1.664865	4.2953517	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g31023	i0	100	115.616279069767	258	0	100	0	1	258	138980	139237	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	29829	477	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14344963	14344963	PRJNA1174207_P_NODE_7412_length_593_cov_3.013462_g6891_i0	PRJNA1174207	7412	593	3.013462	17.86982966	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	1046	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g6891	i0	98.482	151.939291736931	593	9	100	0	1	593	138132	138724	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	90100	1046	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
15618151	15618151	PRJNA1174207_P_NODE_14173_length_386_cov_4.031949_g13644_i0	PRJNA1174207	14173	386	4.031949	15.56332314	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	462	1.44e-125	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g13644	i0	88.342	82.8031088082902	386	44	100	1	1	386	891915	892299	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	31962	462	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
15618562	15618562	PRJNA1174207_P_NODE_36693_length_247_cov_0.885057_g36164_i0	PRJNA1174207	36693	247	0.885057	2.18609079	Candidatus Nanosynbacter lyticus	2093824	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2516688763\|gb\|CP124549.1\|	2093824	g36164	i0	97.166	9.97165991902834	247	7	100	0	1	247	802199	802445	Candidatus Nanosynbacter lyticus strain ML1 chromosome, complete genome	blastn	2463	418	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
15618593	15618593	PRJNA1174207_P_NODE_38293_length_245_cov_0.895349_g37764_i0	PRJNA1174207	38293	245	0.895349	2.19360505	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g37764	i0	98.776	2	245	3	100	0	1	245	170638	170882	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	490	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
18167634	18167634	PRJNA1174207_P_NODE_9615_length_495_cov_2.661137_g9089_i0	PRJNA1174207	9615	495	2.661137	13.17262815	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	387	1.17e-102	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g9089	i0	81.151	106.993939393939	504	75	100	18	1	495	814917	814425	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	52962	387	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
20717287	20717287	PRJNA1174207_P_NODE_42957_length_229_cov_2.397436_g42428_i0	PRJNA1174207	42957	229	2.397436	5.49012844	Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9	1618663	Bacteria	Bacteria	307	3.95e-79	NTclustered	gi\|1118703468\|gb\|KX123381.1\|	1618663	g42428	i0	90.909	101.170305676856	231	18	100	2	1	229	2334	2105	Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9 16S ribosomal RNA gene, partial sequence	blastn	23168	307	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota					Candidatus Jorgensenbacteria bacterium GW2011_GWA2_45_9
24541976	24541976	PRJNA1174207_P_NODE_8080_length_558_cov_2.600000_g7556_i0	PRJNA1174207	8080	558	2.6	14.508	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	926	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g7556	i0	96.768	82.7544802867384	557	15	99	3	1	556	137407	137961	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	46177	926	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
27672546	27672546	PRJNA1174207_P_NODE_41724_length_241_cov_0.916667_g41195_i0	PRJNA1174207	41724	241	0.916667	2.20916747	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	149	3.4599999999999993e-40	NR	HSX83381.1	2890869	g41195	i0	88.8	1.99170124481328	80	9	99.6	0	2	241	86	165	HSX83381.1 iron ABC transporter permease [Candidatus Saccharimonadia bacterium]	diamond	480	149	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
27735846	27735846	PRJNA1174207_P_NODE_39484_length_243_cov_1.811765_g38955_i0	PRJNA1174207	39484	243	1.811765	4.40258895	Candidatus Wildermuthbacteria bacterium	2053642	Bacteria	Bacteria	121	2.3699999999999997e-30	NR	MBI2113267.1	2053642	g38955	i0	77.5	0.987654320987654	80	18	98.8	0	2	241	342	421	MBI2113267.1 MATE family efflux transporter [Candidatus Wildermuthbacteria bacterium]	diamond	240	121	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota					Candidatus Wildermuthbacteria bacterium
28335403	28335403	PRJNA1174207_P_NODE_35086_length_249_cov_0.875000_g34557_i0	PRJNA1174207	35086	249	0.875	2.17875	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	168	4.7e-51	NR	MBY0278448.1	2838779	g34557	i0	97.6	1	83	2	100	0	1	249	15	97	MBY0278448.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	249	168	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29156578	29156578	PRJNA1174207_P_NODE_25829_length_282_cov_1.473684_g25300_i0	PRJNA1174207	25829	282	1.473684	4.15578888	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	134	7.420000000000001e-36	NR	HEY2773004.1	2838779	g25300	i0	65.6	5.93617021276596	93	32	98.9	0	280	2	14	106	HEY2773004.1 lysophospholipid acyltransferase family protein [Candidatus Binatia bacterium]	diamond	1674	134	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29977311	29977311	PRJNA1174207_P_NODE_38311_length_245_cov_0.895349_g37782_i0	PRJNA1174207	38311	245	0.895349	2.19360505	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	139	3.04e-39	NR	MEO6027488.1	2838779	g37782	i0	75	0.979591836734694	80	19	96.7	1	245	9	145	224	MEO6027488.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Binatia bacterium]	diamond	240	139	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30028309	30028309	PRJNA1174207_P_NODE_40791_length_242_cov_0.911243_g40262_i0	PRJNA1174207	40791	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	58.5	1.37e-8	NR	RKW24594.1	2044595	g40262	i0	100	0.793388429752066	32	0	39.7	0	242	147	106	137	RKW24594.1 MAG: hypothetical protein D8B45_02005 [Candidatus Altimarinota bacterium]	diamond	192	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
30217644	30217644	PRJNA1174207_P_NODE_20772_length_310_cov_4.295359_g20243_i0	PRJNA1174207	20772	310	4.295359	13.3156129	Gallionella	96	Bacteria	Bacteria	102	7.989999999999999e-23	NR	KKQ99086.1	1618899	g20243	i0	98	5.76774193548387	50	1	48.4	0	310	161	267	316	KKQ99086.1 MAG: hypothetical protein UT25_C0005G0034, partial [Parcubacteria group bacterium GW2011_GWC1_39_12]	diamond	1788	102	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium GW2011_GWC1_39_12
30230080	30230080	PRJNA1174207_P_NODE_35312_length_249_cov_0.875000_g34783_i0	PRJNA1174207	35312	249	0.875	2.17875	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	162	2.48e-44	NR	MES2931127.1	2052139	g34783	i0	90.2	0.987951807228916	82	8	98.8	0	2	247	502	583	MES2931127.1 class I tRNA ligase family protein [Patescibacteria group bacterium]	diamond	246	162	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
31241051	31241051	PRJNA1174207_P_NODE_38815_length_244_cov_1.590643_g38286_i0	PRJNA1174207	38815	244	1.590643	3.88116892	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	167	2.95e-51	NR	MBY0273815.1	2838779	g38286	i0	100	0.995901639344262	81	0	99.6	0	2	244	74	154	MBY0273815.1 3D domain-containing protein [Candidatus Binatia bacterium]	diamond	243	167	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32727369	32727369	PRJNA1174207_P_NODE_33180_length_251_cov_1.730337_g32651_i0	PRJNA1174207	33180	251	1.730337	4.34314587	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	103	1.5899999999999999e-24	NR	MET1033121.1	2973664	g32651	i0	63.9	0.99203187250996006	83	30	99.2	0	1	249	150	232	MET1033121.1 glycosyltransferase family 2 protein [Candidatus Saccharimonadales bacterium]	diamond	249	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32840777	32840777	PRJNA1174207_P_NODE_34840_length_249_cov_1.392045_g34311_i0	PRJNA1174207	34840	249	1.392045	3.46619205	Bacteria	2	Bacteria	Bacteria	129	2.5899999999999993e-34	NR	MEK7157355.1	2052139	g34311	i0	79.7	9.66265060240964	79	16	95.2	0	248	12	34	112	MEK7157355.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Patescibacteria group bacterium]	diamond	2406	129	1	Bacteria	Bacteria candidate phyla						Patescibacteria group 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);;