metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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
2874123	2874123	PRJNA1196438_P_NODE_60543_length_257_cov_2.543478_g60116_i0	PRJNA1196438	60543	257	2.543478	6.53673846	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	137	6.27e-28	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g60116	i0	77.729	0.891050583657588	229	47	88	4	5	231	491411	491637	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	229	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
4149804	4149804	PRJNA1196438_P_NODE_15124_length_312_cov_4.142259_g14698_i0	PRJNA1196438	15124	312	4.142259	12.92384808	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	268	2.66e-67	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g14698	i0	98.675	0.967948717948718	151	2	97	0	1	151	210244	210394	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	302	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
4149825	4149825	PRJNA1196438_P_NODE_19244_length_312_cov_3.138075_g18818_i0	PRJNA1196438	19244	312	3.138075	9.790794	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	451	2.46e-122	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g18818	i0	91.212	1.05769230769231	330	11	100	1	1	312	97586	97257	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	330	451	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5426090	5426090	PRJNA1196438_P_NODE_20125_length_312_cov_3.012552_g19699_i0	PRJNA1196438	20125	312	3.012552	9.39916224	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	132	3.64e-26	NTclustered	gi\|1805657665\|gb\|CP047917.1\|	713059	g19699	i0	88.785	3.58974358974359	107	12	34	0	1	107	862620	862726	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS15P chromosome, complete genome	blastn	1120	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
5426461	5426461	PRJNA1196438_P_NODE_55005_length_265_cov_4.192708_g54578_i0	PRJNA1196438	55005	265	4.192708	11.1106762	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	322	1.67e-83	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g54578	i0	88.636	8.84150943396226	264	30	99	0	2	265	463877	464140	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	2343	322	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
5426819	5426819	PRJNA1196438_P_NODE_78825_length_236_cov_3.466258_g78398_i0	PRJNA1196438	78825	236	3.466258	8.18036888	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	409	1.09e-109	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g78398	i0	97.881	3.88983050847458	236	5	100	0	1	236	693821	694056	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	918	409	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
6700919	6700919	PRJNA1196438_P_NODE_36446_length_294_cov_3.013575_g36020_i0	PRJNA1196438	36446	294	3.013575	8.8599105	Candidatus Nanosynbacter sp. TM7-074	3158573	Bacteria	Bacteria	132	3.41e-26	NTclustered	gi\|2781952016\|gb\|CP158487.1\|	3158573	g36020	i0	90.816	0.850340136054422	98	9	33	0	181	278	29024	29121	Candidatus Nanosynbacter sp. TM7-074 chromosome, complete genome	blastn	250	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. TM7-074
6701361	6701361	PRJNA1196438_P_NODE_68446_length_248_cov_10.857143_g68019_i0	PRJNA1196438	68446	248	10.857143	26.92571464	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g68019	i0	98.79	1	248	3	100	0	1	248	121958	121711	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
7421315	7421315	PRJNA1196438_P_NODE_65386_length_251_cov_3.483146_g64959_i0	PRJNA1196438	65386	251	3.483146	8.74269646	root	1	Root_unresolved	Root_unresolved	97.1	1.04e-15	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g64959	i0	95.082	22.593625498008	61	3	24	0	189	249	435993	435933	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	5671	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9251617	9251617	PRJNA1196438_P_NODE_85328_length_215_cov_4.302817_g84900_i0	PRJNA1196438	85328	215	4.302817	9.25105655	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	353	4.64e-93	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g84900	i0	96.279	1	215	8	100	0	1	215	684455	684669	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	215	353	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
11801454	11801454	PRJNA1196438_P_NODE_24370_length_311_cov_3.369748_g23944_i0	PRJNA1196438	24370	311	3.369748	10.47991628	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	272	2.0499999999999993e-68	NTclustered	gi\|1842052453\|gb\|CP040010.1\|	2572087	g23944	i0	99.333	6.29260450160772	150	1	97	0	1	150	789026	788877	Candidatus Saccharibacteria bacterium oral taxon 955 strain CM003 chromosome, complete genome	blastn	1957	272	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
14352349	14352349	PRJNA1196438_P_NODE_58212_length_261_cov_1.319149_g57785_i0	PRJNA1196438	58212	261	1.319149	3.44297889	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	472	1.54e-128	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g57785	i0	99.234	89.9272030651341	261	2	100	0	1	261	974743	974483	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	23471	472	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
15625890	15625890	PRJNA1196438_P_NODE_41453_length_286_cov_5.262911_g41026_i0	PRJNA1196438	41453	286	5.262911	15.05192546	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	435	2.25e-117	NTclustered	gi\|1842055115\|gb\|CP040000.1\|	713059	g41026	i0	94.077	9.02097902097902	287	15	100	2	1	286	64477	64762	Candidatus Saccharibacteria bacterium oral taxon 488 strain FS03P chromosome, complete genome	blastn	2580	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
16900379	16900379	PRJNA1196438_P_NODE_53334_length_268_cov_2.046154_g52907_i0	PRJNA1196438	53334	268	2.046154	5.48369272	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	161	3.909999999999999e-35	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g52907	i0	77.695	1.00373134328358	269	56	99	4	1	267	242535	242269	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	269	161	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17621276	17621276	PRJNA1196438_P_NODE_82234_length_229_cov_2.737179_g81807_i0	PRJNA1196438	82234	229	2.737179	6.26813991	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	363	8.309999999999999e-96	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g81807	i0	95.197	4.02620087336245	229	11	100	0	1	229	694549	694777	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	922	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
19449306	19449306	PRJNA1196438_P_NODE_54156_length_267_cov_1.597938_g53729_i0	PRJNA1196438	54156	267	1.597938	4.26649446	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	394	3.52e-105	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g53729	i0	93.561	27.6629213483146	264	17	99	0	2	265	285854	286117	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	7386	394	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
22000229	22000229	PRJNA1196438_P_NODE_68418_length_249_cov_0.886364_g67991_i0	PRJNA1196438	68418	249	0.886364	2.20704636	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	377	3.27e-100	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g67991	i0	93.976	1	249	15	100	0	1	249	803207	803455	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	249	377	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23995412	23995412	PRJNA1196438_P_NODE_39359_length_290_cov_1.433180_g38932_i0	PRJNA1196438	39359	290	1.43318	4.156222	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	464	2.9099999999999993e-126	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g38932	i0	95.517	7.95862068965517	290	13	100	0	1	290	568192	567903	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	2308	464	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;