metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA493632" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA493632" 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
468734	468734	PRJNA493632_P_NODE_718001_length_212_cov_6.172662_g714559_i0	PRJNA493632	718001	212	6.172662	13.08604344	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	237	4.79e-58	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g714559	i0	86.792	1	212	28	100	0	1	212	628563	628352	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	212	237	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
1103607	1103607	PRJNA493632_P_NODE_623381_length_243_cov_1.076471_g619940_i0	PRJNA493632	623381	243	1.076471	2.61582453	Candidatus Peribacter	1803399	Bacteria	Bacteria	211	3.41e-50	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g619940	i0	83.628	299.205761316872	226	35	93	2	1	225	1197282	1197058	MAG: Candidatus Peribacter riflensis, complete genome	blastn	72707	211	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacter	Candidatus Peribacter riflensis
1740030	1740030	PRJNA493632_P_NODE_504642_length_251_cov_1.719101_g501203_i0	PRJNA493632	504642	251	1.719101	4.31494351	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	180	1e-40	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g501203	i0	80.556	74.2868525896414	252	34	98	14	1	247	450951	450710	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	18646	180	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
3009529	3009529	PRJNA493632_P_NODE_145943_length_390_cov_3.842271_g142521_i0	PRJNA493632	145943	390	3.842271	14.9848569	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2314735967\|dbj\|AP024681.1\|	2762014	g142521	i0	96.875	0.0820512820512821	32	0	8	1	99	129	250604	250573	MAG: Candidatus Parcubacteria bacterium KatS3mg097 DNA, complete genome	blastn	32	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
3011583	3011583	PRJNA493632_P_NODE_268523_length_310_cov_1.177215_g265087_i0	PRJNA493632	268523	310	1.177215	3.6493665	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	195	4.5499999999999995e-45	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g265087	i0	82.379	1.76451612903226	227	36	73	4	1	225	137011	136787	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	547	195	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
5565325	5565325	PRJNA493632_P_NODE_325345_length_288_cov_2.116279_g321906_i0	PRJNA493632	325345	288	2.116279	6.09488352	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	294	4.01e-75	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g321906	i0	85.172	54.9236111111111	290	39	100	4	1	288	1079544	1079831	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	15818	294	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium
6846187	6846187	PRJNA493632_P_NODE_709606_length_220_cov_13.401361_g706164_i0	PRJNA493632	709606	220	13.401361	29.4829942	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	329	8.04e-86	NTclustered	gi\|1842053267\|gb\|CP039998.1\|	713059	g706164	i0	94.393	18.2727272727273	214	12	97	0	1	214	394135	393922	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM002 chromosome, complete genome	blastn	4020	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
8119739	8119739	PRJNA493632_P_NODE_596527_length_245_cov_0.895349_g593086_i0	PRJNA493632	596527	245	0.895349	2.19360505	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	220	5.73e-53	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g593086	i0	84.348	17.3102040816327	230	31	93	5	18	245	126026	125800	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	4241	220	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
9391625	9391625	PRJNA493632_P_NODE_424908_length_267_cov_1.443299_g421469_i0	PRJNA493632	424908	267	1.443299	3.85360833	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	455	1.5900000000000002e-123	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g421469	i0	97.378	1	267	7	100	0	1	267	51321	51055	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	267	455	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
9394911	9394911	PRJNA493632_P_NODE_610648_length_244_cov_0.900585_g607207_i0	PRJNA493632	610648	244	0.900585	2.1974274	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	235	2.0399999999999997e-57	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g607207	i0	85.909	123.151639344262	220	31	90	0	18	237	8914	8695	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	30049	235	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
9396220	9396220	PRJNA493632_P_NODE_685328_length_232_cov_8.503145_g681887_i0	PRJNA493632	685328	232	8.503145	19.7272964	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	351	1.8299999999999998e-92	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g681887	i0	95.111	14.5258620689655	225	8	96	2	2	223	275720	275944	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	3370	351	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
10671951	10671951	PRJNA493632_P_NODE_688189_length_231_cov_6.810127_g684748_i0	PRJNA493632	688189	231	6.810127	15.73139337	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	222	1.4899999999999999e-53	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g684748	i0	84.454	255.575757575758	238	23	100	12	1	231	161069	161299	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	59038	222	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
10672510	10672510	PRJNA493632_P_NODE_721989_length_208_cov_7.229630_g718547_i0	PRJNA493632	721989	208	7.22963	15.0376304	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	145	2.92e-30	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g718547	i0	86.364	3.80769230769231	132	18	63	0	38	169	1551	1682	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	792	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
11946303	11946303	PRJNA493632_P_NODE_65650_length_540_cov_3.721627_g62325_i0	PRJNA493632	65650	540	3.721627	20.0967858	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	99	6.72e-16	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g62325	i0	87.209	0.159259259259259	86	11	16	0	379	464	83712	83797	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	86	99	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium
13215370	13215370	PRJNA493632_P_NODE_319411_length_289_cov_5.250000_g315972_i0	PRJNA493632	319411	289	5.25	15.1725	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g315972	i0	100	1.99653979238754	289	0	100	0	1	289	603809	604097	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	577	534	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
15763318	15763318	PRJNA493632_P_NODE_265113_length_310_cov_2.827004_g261677_i0	PRJNA493632	265113	310	2.827004	8.7637124	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	65.8	3.72e-6	NTclustered	gi\|2518556404\|emb\|OX638375.1\|	2838779	g261677	i0	95.238	34.3096774193548	42	1	14	1	193	234	1341601	1341641	MAG: Candidatus Binatia bacterium isolate 97b5e0c7-6798-4f16-949c-9b63468df6e4 genome assembly, chromosome: 1	blastn	10636	65.8	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
15769186	15769186	PRJNA493632_P_NODE_590333_length_245_cov_2.500000_g586892_i0	PRJNA493632	590333	245	2.5	6.125	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g586892	i0	97.959	8.01632653061225	245	5	100	0	1	245	122872	123116	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1964	425	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
15769774	15769774	PRJNA493632_P_NODE_625833_length_243_cov_0.905882_g622392_i0	PRJNA493632	625833	243	0.905882	2.20129326	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g622392	i0	99.177	1	243	2	100	0	1	243	611621	611379	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	243	438	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
17037136	17037136	PRJNA493632_P_NODE_218834_length_332_cov_7.065637_g215399_i0	PRJNA493632	218834	332	7.065637	23.45791484	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	464	3.39e-126	NTclustered	gi\|2814788338\|emb\|OY761159.2\|	2838779	g215399	i0	92.121	98.0692771084337	330	25	99	1	4	332	3737639	3737310	MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1	blastn	32559	464	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
18310312	18310312	PRJNA493632_P_NODE_150055_length_386_cov_2.460064_g146632_i0	PRJNA493632	150055	386	2.460064	9.49584704	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	84.2	1.31e-11	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g146632	i0	86.25	0.207253886010363	80	8	20	3	308	386	366434	366511	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	80	84.2	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
19591892	19591892	PRJNA493632_P_NODE_555796_length_248_cov_0.880000_g552357_i0	PRJNA493632	555796	248	0.88	2.1824	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	165	2.76e-36	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g552357	i0	87.5	0.580645161290323	144	16	58	2	106	248	688929	688787	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	144	165	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
19593647	19593647	PRJNA493632_P_NODE_662256_length_241_cov_0.886905_g658815_i0	PRJNA493632	662256	241	0.886905	2.13744105	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	222	1.56e-53	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g658815	i0	89.655	110.398340248963	174	18	72	0	54	227	1105262	1105435	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	26606	222	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
19593695	19593695	PRJNA493632_P_NODE_665356_length_240_cov_2.095808_g661915_i0	PRJNA493632	665356	240	2.095808	5.0299392	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	411	3.089999999999999e-110	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g661915	i0	97.5	7.93333333333333	240	6	100	0	1	240	540494	540733	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1904	411	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
19594696	19594696	PRJNA493632_P_NODE_720696_length_209_cov_16.904412_g717254_i0	PRJNA493632	720696	209	16.904412	35.33022108	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	320	4.55e-83	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g717254	i0	94.258	8.00478468899522	209	12	100	0	1	209	271555	271763	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	1673	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
20869912	20869912	PRJNA493632_P_NODE_688157_length_231_cov_7.221519_g684716_i0	PRJNA493632	688157	231	7.221519	16.68170889	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	172	1.5199999999999996e-38	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g684716	i0	81.364	134.831168831169	220	33	94	8	9	225	765382	765168	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	31146	172	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota					Candidatus Uhrbacteria bacterium
23420136	23420136	PRJNA493632_P_NODE_662519_length_241_cov_0.857143_g659078_i0	PRJNA493632	662519	241	0.857143	2.06571463	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	292	1.17e-74	NTclustered	gi\|2874253993\|emb\|OY970318.1\|	179883	g659078	i0	88.843	564.410788381743	242	21	98	5	2	238	473360	473600	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04716.bin.c.3 genome assembly, chromosome: 1	blastn	136023	292	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
24687828	24687828	PRJNA493632_P_NODE_329720_length_287_cov_2.140187_g326281_i0	PRJNA493632	329720	287	2.140187	6.14233669	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	244	4.08e-60	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g326281	i0	83.643	213.142857142857	269	34	92	9	4	267	161058	161321	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	61172	244	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans

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