metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
548284	548284	PRJNA564013_P_NODE_178641_length_326_cov_3.433962_g175791_i0	PRJNA564013	178641	326	3.433962	11.19471612	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	520	6.989999999999998e-143	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g175791	i0	100	1.7239263803681	281	0	86	0	23	303	138644	138924	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	562	520	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
552724	552724	PRJNA564013_P_NODE_72641_length_474_cov_8.985472_g69827_i0	PRJNA564013	72641	474	8.985472	42.59113728	Candidatus Nealsonbacteria bacterium DGGOD1a	3043262	Bacteria	Bacteria	67.6	1.65e-6	NTclustered	gi\|2205901313\|gb\|CP092821.1\|	3043262	g69827	i0	100	0.20253164556962	36	0	8	0	136	171	730153	730188	MAG: Candidatus Nealsonbacteria bacterium DGGOD1a chromosome, complete genome	blastn	96	67.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nealsoniibacteriota					Candidatus Nealsonbacteria bacterium DGGOD1a
1132107	1132107	PRJNA564013_P_NODE_22361_length_784_cov_73.301521_g20026_i0	PRJNA564013	22361	784	73.301521	574.68392464	Bacteria	2	Bacteria	Bacteria	617	6.179999999999998e-172	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g20026	i0	91.741	96.4132653061225	448	31	94	6	314	758	882938	883382	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	75588	617	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
1823118	1823118	PRJNA564013_P_NODE_149042_length_352_cov_9.711340_g146193_i0	PRJNA564013	149042	352	9.71134	34.1839168	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	588	2.05e-163	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g146193	i0	98.792	0.940340909090909	331	3	94	1	1	330	634581	634911	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	331	588	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
3098980	3098980	PRJNA564013_P_NODE_168843_length_335_cov_1.014599_g165993_i0	PRJNA564013	168843	335	1.014599	3.39890665	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	420	7.52e-113	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g165993	i0	90.184	0.973134328358209	326	27	96	5	13	335	326981	326658	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	326	420	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
3682934	3682934	PRJNA564013_P_NODE_142923_length_358_cov_5.471380_g140074_i0	PRJNA564013	142923	358	5.47138	19.5875404	Bacteria	2	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g140074	i0	100	0.23463687150838	28	0	8	0	22	49	667989	667962	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
4377345	4377345	PRJNA564013_P_NODE_259504_length_254_cov_1.347150_g256652_i0	PRJNA564013	259504	254	1.34715	3.421761	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	435	1.9600000000000003e-117	NTclustered	gi\|2877945256\|gb\|CP127222.1\|	2572087	g256652	i0	98.77	5.76377952755906	244	3	96	0	1	244	381664	381421	Candidatus Saccharibacteria bacterium oral taxon 955 strain 103.1.1 chromosome, complete genome	blastn	1464	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
4378452	4378452	PRJNA564013_P_NODE_319264_length_214_cov_1.660131_g316412_i0	PRJNA564013	319264	214	1.660131	3.55268034	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	387	4.55e-103	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g316412	i0	100	0.976635514018692	209	0	98	0	2	210	337155	337363	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	209	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
5651662	5651662	PRJNA564013_P_NODE_159785_length_343_cov_1.879433_g156935_i0	PRJNA564013	159785	343	1.879433	6.44645519	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	579	1.1999999999999996e-160	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g156935	i0	100	7.29446064139942	313	0	91	0	10	322	110360	110672	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	2502	579	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
5656832	5656832	PRJNA564013_P_NODE_89525_length_430_cov_4.604336_g86693_i0	PRJNA564013	89525	430	4.604336	19.7986448	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	348	4.720000000000001e-91	NTclustered	gi\|1842050796\|gb\|CP039997.1\|	713059	g86693	i0	82.426	2.81860465116279	404	66	93	5	24	424	803638	804039	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM010 chromosome, complete genome	blastn	1212	348	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
6235065	6235065	PRJNA564013_P_NODE_127705_length_374_cov_1.670927_g124858_i0	PRJNA564013	127705	374	1.670927	6.24926698	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	521	2.259999999999999e-143	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g124858	i0	94.152	7.31016042780749	342	20	91	0	18	359	785104	784763	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	2734	521	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
6924789	6924789	PRJNA564013_P_NODE_116586_length_386_cov_35.332308_g113742_i0	PRJNA564013	116586	386	35.332308	136.38270888	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	481	3.97e-131	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g113742	i0	93.009	1.70984455958549	329	23	85	0	36	364	10296	10624	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	660	481	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
6927804	6927804	PRJNA564013_P_NODE_250146_length_261_cov_3.580000_g247294_i0	PRJNA564013	250146	261	3.58	9.3438	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	239	1.7e-58	NTclustered	gi\|1805658607\|gb\|CP047918.1\|	2572087	g247294	i0	84.81	0.908045977011494	237	36	91	0	1	237	224445	224681	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome	blastn	237	239	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
10756855	10756855	PRJNA564013_P_NODE_57709_length_525_cov_21.939655_g54925_i0	PRJNA564013	57709	525	21.939655	115.18318875	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	180	2.26e-40	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g54925	i0	90.441	0.518095238095238	136	13	26	0	115	250	86832	86967	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	272	180	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13304938	13304938	PRJNA564013_P_NODE_310171_length_219_cov_2.677215_g307319_i0	PRJNA564013	310171	219	2.677215	5.86310085	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	329	7.99e-86	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g307319	i0	96.954	0.899543378995434	197	4	90	1	23	219	168014	167820	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	197	329	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
13306896	13306896	PRJNA564013_P_NODE_76591_length_462_cov_17.985037_g73770_i0	PRJNA564013	76591	462	17.985037	83.09087094	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	178	7.089999999999999e-40	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g73770	i0	83.938	1.85930735930736	193	24	41	6	56	246	820006	819819	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	859	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14579098	14579098	PRJNA564013_P_NODE_272092_length_244_cov_4.043716_g269240_i0	PRJNA564013	272092	244	4.043716	9.86666704	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g269240	i0	98.77	1	244	3	100	0	1	244	124299	124542	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	244	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
15853500	15853500	PRJNA564013_P_NODE_301573_length_224_cov_4.226994_g298721_i0	PRJNA564013	301573	224	4.226994	9.46846656	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	191	4.04e-44	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g298721	i0	85.405	0.825892857142857	185	26	82	1	20	203	339860	339676	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	185	191	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
15854809	15854809	PRJNA564013_P_NODE_38593_length_623_cov_5.202847_g35898_i0	PRJNA564013	38593	623	5.202847	32.41373681	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	893	0	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g35898	i0	92.628	3	624	40	99	4	3	623	250532	251152	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	1869	893	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
18398822	18398822	PRJNA564013_P_NODE_123415_length_378_cov_59.772871_g120569_i0	PRJNA564013	123415	378	59.772871	225.94145238	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	518	2.95e-142	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g120569	i0	94.627	1.17989417989418	335	17	88	1	24	357	631509	631175	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	446	518	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18400984	18400984	PRJNA564013_P_NODE_214115_length_293_cov_2.232759_g211264_i0	PRJNA564013	214115	293	2.232759	6.54198387	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	468	2.28e-127	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g211264	i0	97.445	0.935153583617747	274	7	94	0	10	283	66326	66053	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	274	468	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
20950350	20950350	PRJNA564013_P_NODE_176117_length_328_cov_6.363296_g173267_i0	PRJNA564013	176117	328	6.363296	20.87161088	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	333	9.84e-87	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g173267	i0	93.333	1.3719512195122	225	15	69	0	81	305	225695	225919	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	450	333	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
21534015	21534015	PRJNA564013_P_NODE_22117_length_788_cov_27.682256_g19789_i0	PRJNA564013	22117	788	27.682256	218.13617728	Candidatus Southlakia	3350975	Bacteria	Bacteria	1181	0	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g19789	i0	94.634	136.333756345178	764	38	97	3	1	762	511953	511191	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	107431	1186	0.995784148397976	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22227482	22227482	PRJNA564013_P_NODE_288198_length_233_cov_2.337209_g285346_i0	PRJNA564013	288198	233	2.337209	5.44569697	Candidatus Nanosynbacter lyticus	2093824	Bacteria	Bacteria	121	5.64e-23	NTclustered	gi\|2516688763\|gb\|CP124549.1\|	2093824	g285346	i0	87.619	7.48927038626609	105	11	45	2	108	211	273995	273892	Candidatus Nanosynbacter lyticus strain ML1 chromosome, complete genome	blastn	1745	121	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
24775250	24775250	PRJNA564013_P_NODE_21160_length_803_cov_10.474394_g18859_i0	PRJNA564013	21160	803	10.474394	84.10938382	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	992	0	NTclustered	gi\|2874254068\|emb\|OY970151.1\|	179883	g18859	i0	91.216	323.67496886675	740	50	97	13	51	780	658532	659266	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD00082.bin.2.65 genome assembly, chromosome: 1	blastn	259911	992	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria 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);;