metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
1505113	1505113	PRJNA1118794_P_NODE_1262_length_1301_cov_20.659609_g846_i0	PRJNA1118794	1262	1301	20.659609	268.78151309	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20	2056494	Bacteria	Bacteria	1690	0	NTclustered	gi\|1340357306\|gb\|CP025011.1\|	2056494	g846	i0	90.229	359.544196771714	1310	106	99	20	3	1301	1287359	1288657	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 chromosome, complete genome	blastn	467767	1690	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20
1505651	1505651	PRJNA1118794_P_NODE_54442_length_249_cov_0.875000_g53692_i0	PRJNA1118794	54442	249	0.875	2.17875	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	235	2.08e-57	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g53692	i0	84.298	250.819277108434	242	37	97	1	8	249	246903	247143	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	62454	235	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
4057760	4057760	PRJNA1118794_P_NODE_61204_length_246_cov_0.890173_g60454_i0	PRJNA1118794	61204	246	0.890173	2.18982558	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	291	4.33e-74	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g60454	i0	88.211	9.56910569105691	246	25	99	4	3	246	76314	76557	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	2354	291	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
9158131	9158131	PRJNA1118794_P_NODE_128_length_2995_cov_7.099589_g73_i0	PRJNA1118794	128	2995	7.099589	212.63269055	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	3035	0	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g73	i0	88.276	82.8307178631052	2576	249	98	45	52	2599	720674	718124	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	248078	3035	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
9158609	9158609	PRJNA1118794_P_NODE_50088_length_251_cov_0.865169_g49338_i0	PRJNA1118794	50088	251	0.865169	2.17157419	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g49338	i0	99.203	2	251	2	100	0	1	251	560804	560554	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	502	453	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
9158633	9158633	PRJNA1118794_P_NODE_51768_length_250_cov_0.870056_g51018_i0	PRJNA1118794	51768	250	0.870056	2.17514	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	122	1.7e-23	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g51018	i0	84.553	1.252	123	19	49	0	128	250	448587	448709	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	313	122	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
12984662	12984662	PRJNA1118794_P_NODE_50411_length_250_cov_2.146893_g49661_i0	PRJNA1118794	50411	250	2.146893	5.3672325	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20	2056494	Bacteria	Bacteria	267	7.43e-67	NTclustered	gi\|1340357306\|gb\|CP025011.1\|	2056494	g49661	i0	85.944	179.26	249	35	99	0	2	250	766171	765923	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 chromosome, complete genome	blastn	44815	267	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20
14259450	14259450	PRJNA1118794_P_NODE_20692_length_334_cov_34.425287_g19942_i0	PRJNA1118794	20692	334	34.425287	114.98045858	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	398	3.5099999999999994e-106	NTclustered	gi\|1958071672\|gb\|CP064992.1\|	2026720	g19942	i0	93.916	151.535928143713	263	16	79	0	72	334	636646	636384	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BATAC.98_uni chromosome, complete genome	blastn	50613	398	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14259861	14259861	PRJNA1118794_P_NODE_53552_length_249_cov_0.875000_g52802_i0	PRJNA1118794	53552	249	0.875	2.17875	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	399	6.989999999999999e-107	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g52802	i0	95.582	99.5903614457831	249	11	100	0	1	249	140959	140711	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	24798	399	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
18082421	18082421	PRJNA1118794_P_NODE_43835_length_260_cov_2.245989_g43085_i0	PRJNA1118794	43835	260	2.245989	5.8395714	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	263	1.01e-65	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g43085	i0	86.179	27.6846153846154	246	30	95	3	1	246	449114	448873	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	7198	263	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
18082519	18082519	PRJNA1118794_P_NODE_51955_length_250_cov_0.870056_g51205_i0	PRJNA1118794	51955	250	0.870056	2.17514	Candidatus Sonnebornia yantaiensis	1732522	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|451927926\|gb\|KC495060.1\|	1732522	g51205	i0	95.6	89.516	250	11	100	0	1	250	1131	1380	Candidatus Sonnebornia yantaiensis clone YTParaBac1 16S ribosomal RNA gene, partial sequence	blastn	22379	401	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria				Candidatus Sonnebornia	Candidatus Sonnebornia yantaiensis
21427000	21427000	PRJNA1118794_P_NODE_58077_length_247_cov_0.885057_g57327_i0	PRJNA1118794	58077	247	0.885057	2.18609079	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g57327	i0	97.177	67.9878542510122	248	6	100	1	1	247	694962	694715	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	16793	418	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
23183231	23183231	PRJNA1118794_P_NODE_65959_length_244_cov_0.900585_g65209_i0	PRJNA1118794	65959	244	0.900585	2.1974274	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	228	3.409999999999999e-55	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g65209	i0	86.538	204.364754098361	208	27	85	1	38	244	189767	189560	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	49865	228	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
24456902	24456902	PRJNA1118794_P_NODE_38980_length_271_cov_1.318182_g38230_i0	PRJNA1118794	38980	271	1.318182	3.57227322	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	126	1.44e-24	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g38230	i0	92.135	27.5129151291513	89	7	33	0	67	155	152073	152161	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	7456	126	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1

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