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

13 rows where bioproject = "PRJNA1198392" and tax_phylum = "Candidatus Saccharimonadota"

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

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