metadata: contig_metadata: 16 rows where bioproject = "PRJNA1011844", tax_clade = "Bacteria candidate phyla" and tax

16 rows where bioproject = "PRJNA1011844", tax_clade = "Bacteria candidate phyla" 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
7379789	7379789	PRJNA1011844_P_NODE_46026_length_674_cov_3.564060_g37909_i0	PRJNA1011844	46026	674	3.56406	24.0217644	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	1212	0	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g37909	i0	99.698	319.476261127596	662	2	98	0	13	674	143168	143829	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	215327	1212	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9929921	9929921	PRJNA1011844_P_NODE_143468_length_253_cov_2.911111_g134890_i0	PRJNA1011844	143468	253	2.911111	7.36511083	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g134890	i0	100	246.399209486166	238	0	94	0	4	241	142473	142236	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	62339	440	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
18008072	18008072	PRJNA1011844_P_NODE_152175_length_247_cov_0.885057_g143596_i0	PRJNA1011844	152175	247	0.885057	2.18609079	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g143596	i0	94.421	1.85425101214575	233	11	94	2	9	240	382308	382077	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	458	357	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
19281562	19281562	PRJNA1011844_P_NODE_131116_length_268_cov_2.128205_g122538_i0	PRJNA1011844	131116	268	2.128205	5.7035894	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.6000000000000002e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g122538	i0	99.206	114.891791044776	252	2	94	0	5	256	137031	136780	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	30791	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
21404281	21404281	PRJNA1011844_P_NODE_54317_length_579_cov_3.081028_g45993_i0	PRJNA1011844	54317	579	3.081028	17.83915212	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	992	0	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g45993	i0	98.236	107.549222797927	567	10	98	0	13	579	151765	152331	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	62271	998	0.993987975951904	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
23108614	23108614	PRJNA1011844_P_NODE_153799_length_246_cov_0.890173_g145219_i0	PRJNA1011844	153799	246	0.890173	2.18982558	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g145219	i0	97.863	1.90243902439024	234	5	95	0	11	244	124664	124431	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	468	405	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
24382186	24382186	PRJNA1011844_P_NODE_137400_length_260_cov_3.016043_g128822_i0	PRJNA1011844	137400	260	3.016043	7.8417118	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	407	4.39e-109	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g128822	i0	96.356	89.3923076923077	247	9	95	0	14	260	800042	799796	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	23242	407	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26971298	26971298	PRJNA1011844_P_NODE_115922_length_290_cov_1.262673_g107346_i0	PRJNA1011844	115922	290	1.262673	3.6617517	Candidatus Saccharibacteria bacterium 32-5	1970480	Bacteria	Bacteria	156	3.07e-44	NR	OYX39241.1	1970480	g107346	i0	78.7	0.920689655172414	89	19	92.1	0	275	9	236	324	OYX39241.1 MAG: hypothetical protein B7Z00_00760 [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	267	156	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-10
27192623	27192623	PRJNA1011844_P_NODE_133482_length_265_cov_2.067708_g124904_i0	PRJNA1011844	133482	265	2.067708	5.4794262	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	6.65e-9	NR	HBO64468.1	2026720	g124904	i0	75.7	1.25660377358491	37	9	41.9	0	263	153	269	305	HBO64468.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	333	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28361129	28361129	PRJNA1011844_P_NODE_171086_length_227_cov_2.642857_g162505_i0	PRJNA1011844	171086	227	2.642857	5.99928539	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	42.4	0.0415	NR	HKR82482.1	2973664	g162505	i0	41.2	0.674008810572687	51	30	67.4	0	19	171	40	90	HKR82482.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	153	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28487663	28487663	PRJNA1011844_P_NODE_165707_length_235_cov_2.333333_g157126_i0	PRJNA1011844	165707	235	2.333333	5.48333255	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	42	0.0107	NR	MDO4774021.1	2026720	g157126	i0	36.5	0.663829787234043	52	33	66.4	0	45	200	11	62	MDO4774021.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	156	42	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29403156	29403156	PRJNA1011844_P_NODE_13569_length_1552_cov_8.720081_g9833_i0	PRJNA1011844	13569	1552	8.720081	135.33565712	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	53.5	0.00242	NR	HVF33711.1	2890869	g9833	i0	36.6	0.179768041237113	93	55	18	2	785	507	494	582	HVF33711.1 serine/threonine-protein kinase [Candidatus Saccharimonadia bacterium]	diamond	279	53.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
29497858	29497858	PRJNA1011844_P_NODE_139230_length_258_cov_2.410811_g130652_i0	PRJNA1011844	139230	258	2.410811	6.21989238	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.5	3.99e-4	NR	MCL2445014.1	2026720	g130652	i0	42	0.802325581395349	69	39	80.2	1	47	253	147	214	MCL2445014.1 IPT/TIG domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	207	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29718764	29718764	PRJNA1011844_P_NODE_94050_length_345_cov_3.422794_g85488_i0	PRJNA1011844	94050	345	3.422794	11.8086393	Candidatus Saccharibacteria bacterium 32-49-12	1970479	Bacteria	Bacteria	58.9	2.39e-7	NR	OYX40957.1	1970479	g85488	i0	37	0.869565217391304	100	62	87	1	341	42	378	476	OYX40957.1 MAG: hypothetical protein B7Y94_05830, partial [Candidatus Saccharibacteria bacterium 32-49-12]	diamond	300	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-49-12
30603419	30603419	PRJNA1011844_P_NODE_67113_length_472_cov_4.333333_g58675_i0	PRJNA1011844	67113	472	4.333333	20.45333176	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	58.5	1.28e-6	NR	HVP38111.1	2973664	g58675	i0	37.6	0.692796610169492	109	56	69.3	3	86	412	475	571	HVP38111.1 kelch repeat-containing protein [Candidatus Saccharimonadales bacterium]	diamond	327	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31615063	31615063	PRJNA1011844_P_NODE_936_length_4218_cov_13.434258_g568_i0	PRJNA1011844	936	4218	13.434258	566.65700244	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	54.3	0.00575	NR	HSX42623.1	2973664	g568	i0	24.8	0.214793741109531	302	173	19.4	11	1658	840	99	375	HSX42623.1 lectin-like protein [Candidatus Saccharimonadales bacterium]	diamond	906	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;