metadata: contig_metadata: 22 rows where bioproject = "PRJNA1198392" and tax

22 rows where bioproject = "PRJNA1198392" 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
1043850	1043850	PRJNA1198392_P_NODE_9021_length_287_cov_1.252336_g8880_i0	PRJNA1198392	9021	287	1.252336	3.59420432	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	114	4.61e-27	NR	MDQ5932390.1	2052139	g8880	i0	93.3	0.627177700348432	60	4	62.7	0	2	181	515	574	MDQ5932390.1 beta-lactamase class [Patescibacteria group bacterium]	diamond	180	114	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
9971801	9971801	PRJNA1198392_P_NODE_11168_length_277_cov_1.083333_g11027_i0	PRJNA1198392	11168	277	1.083333	3.00083241	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g11027	i0	94.526	236.945848375451	274	15	99	0	1	274	598709	598436	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	65634	425	0.997647058823529	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
11247033	11247033	PRJNA1198392_P_NODE_13049_length_267_cov_1.587629_g12908_i0	PRJNA1198392	13049	267	1.587629	4.23896943	Bacteria	2	Bacteria	Bacteria	401	2.1099999999999995e-107	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g12908	i0	95.635	223.602996254682	252	8	94	3	4	253	850581	850831	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	59702	401	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11803043	11803043	PRJNA1198392_P_NODE_15090_length_255_cov_1.362637_g14949_i0	PRJNA1198392	15090	255	1.362637	3.47472435	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	449	7.03e-122	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g14949	i0	98.431	2	255	4	100	0	1	255	403595	403849	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	510	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
11803173	11803173	PRJNA1198392_P_NODE_20550_length_242_cov_1.408284_g20409_i0	PRJNA1198392	20550	242	1.408284	3.40804728	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	99	2.76e-16	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g20409	i0	77.665	0.814049586776859	197	21	74	14	18	195	738840	738648	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	197	99	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
15627483	15627483	PRJNA1198392_P_NODE_3973_length_386_cov_1.837061_g3832_i0	PRJNA1198392	3973	386	1.837061	7.09105546	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	630	3.7199999999999986e-176	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g3832	i0	96.124	249.924870466321	387	13	100	2	1	386	799131	798746	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	96471	630	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
16901732	16901732	PRJNA1198392_P_NODE_17754_length_248_cov_0.880000_g17613_i0	PRJNA1198392	17754	248	0.88	2.1824	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g17613	i0	95.928	4.46774193548387	221	9	89	0	28	248	189866	190086	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	1108	359	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
20170054	20170054	PRJNA1198392_P_NODE_6256_length_323_cov_3.568000_g6115_i0	PRJNA1198392	6256	323	3.568	11.52464	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	534	2.47e-147	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g6115	i0	96.594	68.2941176470588	323	10	100	1	1	323	696443	696122	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	22059	534	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
23276719	23276719	PRJNA1198392_P_NODE_15719_length_251_cov_0.865169_g15578_i0	PRJNA1198392	15719	251	0.865169	2.17157419	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	377	3.2999999999999995e-100	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g15578	i0	93.976	237.93625498008	249	15	99	0	1	249	1249522	1249274	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	59722	377	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
26597397	26597397	PRJNA1198392_P_NODE_16761_length_249_cov_1.738636_g16620_i0	PRJNA1198392	16761	249	1.738636	4.32920364	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	58.5	2.97e-8	NR	MFA5003891.1	2973664	g16620	i0	43.3	0.807228915662651	67	37	80.7	1	47	247	84	149	MFA5003891.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	201	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
26755814	26755814	PRJNA1198392_P_NODE_18661_length_246_cov_0.890173_g18520_i0	PRJNA1198392	18661	246	0.890173	2.18982558	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	110	1.18e-26	NR	HSX30426.1	2973664	g18520	i0	62.3	0.939024390243902	77	29	93.9	0	231	1	60	136	HSX30426.1 glycosyltransferase family 4 protein [Candidatus Saccharimonadales bacterium]	diamond	231	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27470792	27470792	PRJNA1198392_P_NODE_20763_length_242_cov_0.911243_g20622_i0	PRJNA1198392	20763	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	127	1.9399999999999993e-34	NR	MAU34099.1	2026720	g20622	i0	67.5	5.93801652892562	80	26	99.2	0	240	1	7	86	MAU34099.1 glutamine amidotransferase [Candidatus Saccharibacteria bacterium]	diamond	1437	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27862100	27862100	PRJNA1198392_P_NODE_21425_length_241_cov_0.916667_g21284_i0	PRJNA1198392	21425	241	0.916667	2.20916747	Candidatus Saccharibacteria bacterium 32-5	1970481	Bacteria	Bacteria	141	1.9999999999999997e-37	NR	OYX53895.1	1970481	g21284	i0	75.9	0.983402489626556	79	19	98.3	0	239	3	176	254	OYX53895.1 MAG: hypothetical protein B7Y92_01145 [Candidatus Saccharibacteria bacterium 32-50-13]	diamond	237	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-13
28683309	28683309	PRJNA1198392_P_NODE_16107_length_251_cov_0.865169_g15966_i0	PRJNA1198392	16107	251	0.865169	2.17157419	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	66.2	1.74e-10	NR	HXG26622.1	2838779	g15966	i0	48.2	0.99203187250996006	83	38	95.6	2	11	250	8	88	HXG26622.1 permease prefix domain 1-containing protein [Candidatus Binatia bacterium]	diamond	249	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29093760	29093760	PRJNA1198392_P_NODE_20708_length_242_cov_0.911243_g20567_i0	PRJNA1198392	20708	242	0.911243	2.20520806	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	63.9	7.89e-10	NR	RKW23767.1	2044595	g20567	i0	94.1	0.421487603305785	34	2	42.1	0	106	5	1	34	RKW23767.1 MAG: bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Candidatus Altimarinota bacterium]	diamond	102	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
29629995	29629995	PRJNA1198392_P_NODE_9110_length_286_cov_1.981221_g8969_i0	PRJNA1198392	9110	286	1.981221	5.66629206	Candidatus Microsaccharimonas sp.	3069365	Bacteria	Bacteria	66.2	2.63e-10	NR	HWT55651.1	3069365	g8969	i0	57.6	0.618881118881119	59	25	61.9	0	3	179	278	336	HWT55651.1 hypothetical protein [Candidatus Microsaccharimonas sp.]	diamond	177	66.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Microsaccharimonas	Candidatus Microsaccharimonas sp.
30514856	30514856	PRJNA1198392_P_NODE_20133_length_243_cov_0.905882_g19992_i0	PRJNA1198392	20133	243	0.905882	2.20129326	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	106	6.15e-25	NR	MBB1557816.1	2026720	g19992	i0	100	0.716049382716049	58	0	71.6	0	1	174	145	202	MBB1557816.1 CHAP domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	174	106	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30704385	30704385	PRJNA1198392_P_NODE_21894_length_226_cov_2.588235_g21753_i0	PRJNA1198392	21894	226	2.588235	5.8494111	Candidatus Mcinerneyibacteriales bacterium	2952940	Bacteria	Bacteria	48.5	7.68e-5	NR	HOO60205.1	2952940	g21753	i0	67.6	0.915929203539823	37	12	49.1	0	106	216	1	37	HOO60205.1 hypothetical protein [Candidatus Mcinerneyibacteriales bacterium]	diamond	207	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Macinerneyibacteriota	Candidatus Mcinerneyibacteria	Candidatus Mcinerneyibacteriales			Candidatus Mcinerneyibacteriales bacterium
30830777	30830777	PRJNA1198392_P_NODE_12974_length_267_cov_2.201031_g12833_i0	PRJNA1198392	12974	267	2.201031	5.87675277	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	68.2	5.7e-11	NR	HSE56758.1	2053589	g12833	i0	51.7	2.59550561797753	87	32	97.8	2	3	263	800	876	HSE56758.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	693	68.2	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31228697	31228697	PRJNA1198392_P_NODE_13595_length_264_cov_1.581152_g13454_i0	PRJNA1198392	13595	264	1.581152	4.17424128	Bacteria	2	Bacteria	Bacteria	85.9	3.21e-17	NR	RAL55812.1	1912928	g13454	i0	95.5	1	44	2	50	0	72	203	502	545	RAL55812.1 hypothetical protein BLD25_04045 [Candidatus Gracilibacteria bacterium GN02-872]	diamond	264	86.3	0.995365005793743	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium GN02-872
31304785	31304785	PRJNA1198392_P_NODE_8315_length_290_cov_1.331797_g8174_i0	PRJNA1198392	8315	290	1.331797	3.8622113	Candidatus Gracilibacteria bacterium GN	2044595	Bacteria	Bacteria	60.8	2.08e-8	NR	RAL57531.1	1912928	g8174	i0	100	0.3	29	0	30	0	125	211	156	184	RAL57531.1 hypothetical protein BLD25_02650 [Candidatus Gracilibacteria bacterium GN02-872]	diamond	87	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium GN02-872
31969029	31969029	PRJNA1198392_P_NODE_12998_length_267_cov_1.649485_g12857_i0	PRJNA1198392	12998	267	1.649485	4.40412495	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	46.6	5.68e-4	NR	MDC0292438.1	2838779	g12857	i0	32.5	0.898876404494382	80	33	67.4	2	218	39	2	80	MDC0292438.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	240	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;