metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA846086" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA846086" 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
832922	832922	PRJNA846086_P_NODE_4621_length_245_cov_0.895349_g4555_i0	PRJNA846086	4621	245	0.895349	2.19360505	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	169	2.1e-37	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g4555	i0	88.971	0.555102040816327	136	15	56	0	110	245	458174	458039	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	136	169	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
832932	832932	PRJNA846086_P_NODE_5361_length_242_cov_0.911243_g5295_i0	PRJNA846086	5361	242	0.911243	2.20520806	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g5295	i0	97.934	1	242	5	100	0	1	242	427083	426842	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	242	420	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
3383657	3383657	PRJNA846086_P_NODE_3083_length_251_cov_0.865169_g3017_i0	PRJNA846086	3083	251	0.865169	2.17157419	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	111	3.7e-20	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g3017	i0	76.446	3.40637450199203	242	36	94	18	2	238	628543	628318	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	855	111	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
5936012	5936012	PRJNA846086_P_NODE_1325_length_326_cov_1.213439_g1259_i0	PRJNA846086	1325	326	1.213439	3.95581114	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	243	1.69e-59	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g1259	i0	80.363	196.027607361963	331	55	100	9	1	326	126326	126001	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	63905	243	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
9760880	9760880	PRJNA846086_P_NODE_1548_length_304_cov_3.679654_g1482_i0	PRJNA846086	1548	304	3.679654	11.18614816	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	475	1.4199999999999997e-129	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g1482	i0	95.066	133.171052631579	304	11	99	4	3	304	511669	511368	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	40484	475	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
9760908	9760908	PRJNA846086_P_NODE_3448_length_250_cov_0.870056_g3382_i0	PRJNA846086	3448	250	0.870056	2.17514	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	424	4.16e-114	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g3382	i0	97.2	2	250	7	100	0	1	250	727654	727903	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	500	424	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
11036528	11036528	PRJNA846086_P_NODE_1869_length_285_cov_3.122642_g1803_i0	PRJNA846086	1869	285	3.122642	8.8995297	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	320	6.54e-83	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g1803	i0	88.192	111.985964912281	271	29	94	3	1	269	125567	125298	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	31916	320	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
11036564	11036564	PRJNA846086_P_NODE_3829_length_248_cov_0.880000_g3763_i0	PRJNA846086	3829	248	0.88	2.1824	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g3763	i0	98.79	1	248	3	100	0	1	248	668027	667780	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	248	442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
12710816	12710816	PRJNA846086_P_NODE_2490_length_265_cov_3.385417_g2424_i0	PRJNA846086	2490	265	3.385417	8.97135505	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g2424	i0	99.245	76.2905660377358	265	2	100	0	1	265	143558	143822	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	20217	479	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
13586549	13586549	PRJNA846086_P_NODE_971_length_372_cov_1.030100_g905_i0	PRJNA846086	971	372	1.0301	3.831972	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	409	1.82e-109	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g905	i0	86.721	140.688172043011	369	47	99	2	1	367	127286	126918	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	52336	409	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
14860797	14860797	PRJNA846086_P_NODE_472_length_547_cov_1.350211_g406_i0	PRJNA846086	472	547	1.350211	7.38565417	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	953	0	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g406	i0	98.172	212.513711151737	547	8	99	2	2	547	150502	151047	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	116245	953	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
18684101	18684101	PRJNA846086_P_NODE_1975_length_282_cov_2.181818_g1909_i0	PRJNA846086	1975	282	2.181818	6.15272676	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	377	3.78e-100	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g1909	i0	91.135	1	282	20	99	3	2	282	539465	539188	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	282	377	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
19959290	19959290	PRJNA846086_P_NODE_3856_length_248_cov_0.880000_g3790_i0	PRJNA846086	3856	248	0.88	2.1824	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	370	5.45e-98	NTclustered	gi\|1805660319\|gb\|CP047920.1\|	713059	g3790	i0	93.548	13.4677419354839	248	16	100	0	1	248	197198	197445	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS07P chromosome, complete genome	blastn	3340	370	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
20357565	20357565	PRJNA846086_P_NODE_3296_length_250_cov_0.870056_g3230_i0	PRJNA846086	3296	250	0.870056	2.17514	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	313	9.41e-81	NTclustered	gi\|2869833183\|gb\|CP175706.1\|	2093824	g3230	i0	89.243	7.016	251	25	100	2	1	250	181985	181736	Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome	blastn	1754	313	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
21234964	21234964	PRJNA846086_P_NODE_4837_length_244_cov_0.900585_g4771_i0	PRJNA846086	4837	244	0.900585	2.1974274	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	241	4.38e-59	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g4771	i0	84.677	1.59836065573771	248	30	100	5	1	244	356516	356273	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	390	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
21633253	21633253	PRJNA846086_P_NODE_5037_length_243_cov_0.905882_g4971_i0	PRJNA846086	5037	243	0.905882	2.20129326	Candidatus Southlakia	3350975	Bacteria	Bacteria	206	1.59e-48	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4971	i0	99.13	1.37037037037037	115	0	47	1	1	114	488292	488178	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	333	206	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
22908749	22908749	PRJNA846086_P_NODE_4198_length_246_cov_1.543353_g4132_i0	PRJNA846086	4198	246	1.543353	3.79664838	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	313	9.23e-81	NTclustered	gi\|2869833183\|gb\|CP175706.1\|	2093824	g4132	i0	89.754	3.86991869918699	244	25	99	0	1	244	446425	446668	Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome	blastn	952	315	0.993650793650794	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
23785132	23785132	PRJNA846086_P_NODE_2999_length_251_cov_1.730337_g2933_i0	PRJNA846086	2999	251	1.730337	4.34314587	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	102	2.23e-17	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g2933	i0	95.312	26.0478087649402	64	3	25	0	188	251	469844	469781	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	6538	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
25059069	25059069	PRJNA846086_P_NODE_4740_length_244_cov_0.900585_g4674_i0	PRJNA846086	4740	244	0.900585	2.1974274	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g4674	i0	98.77	1	244	3	100	0	1	244	843975	843732	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	244	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
25059072	25059072	PRJNA846086_P_NODE_4800_length_244_cov_0.900585_g4734_i0	PRJNA846086	4800	244	0.900585	2.1974274	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g4734	i0	98.361	2	244	4	100	0	1	244	74533	74776	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	488	429	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002

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