metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
1886380	1886380	PRJNA640143_S_NODE_5802_length_345_cov_1.938312_g5592_i0	PRJNA640143	5802	345	1.938312	6.6871764	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	610	4.29e-170	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g5592	i0	98.551	40.1217391304348	345	5	100	0	1	345	78072	78416	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	13842	610	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
3160562	3160562	PRJNA640143_S_NODE_10703_length_264_cov_2.074890_g10493_i0	PRJNA640143	10703	264	2.07489	5.4777096	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	459	1.22e-124	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g10493	i0	98.099	0.996212121212121	263	5	99	0	1	263	198312	198574	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	263	459	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
5713854	5713854	PRJNA640143_S_NODE_8165_length_297_cov_1.780769_g7955_i0	PRJNA640143	8165	297	1.780769	5.28888393	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g7955	i0	99.663	1	297	1	100	0	1	297	197881	198177	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	297	544	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
6988209	6988209	PRJNA640143_S_NODE_13826_length_234_cov_2.456853_g13616_i0	PRJNA640143	13826	234	2.456853	5.74903602	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	399	6.499999999999999e-107	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g13616	i0	97.436	1	234	6	100	0	1	234	197549	197782	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	234	399	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
9538199	9538199	PRJNA640143_S_NODE_12448_length_246_cov_1.875598_g12238_i0	PRJNA640143	12448	246	1.875598	4.61397108	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	224	4.45e-54	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g12238	i0	83.73	202.174796747967	252	26	99	11	1	245	1105276	1105519	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	49735	224	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
10814267	10814267	PRJNA640143_S_NODE_30309_length_157_cov_1.866667_g30099_i0	PRJNA640143	30309	157	1.866667	2.93066719	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	279	5.46e-71	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g30099	i0	98.726	1	157	2	100	0	1	157	198313	198157	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	157	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
12089706	12089706	PRJNA640143_S_NODE_9550_length_278_cov_1.618257_g9340_i0	PRJNA640143	9550	278	1.618257	4.49875446	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	496	9.84e-136	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g9340	i0	98.921	25.6187050359712	278	2	100	1	1	278	550200	550476	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	7122	496	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
14638502	14638502	PRJNA640143_S_NODE_10372_length_268_cov_2.272727_g10162_i0	PRJNA640143	10372	268	2.272727	6.09090836	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	462	9.57e-126	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g10162	i0	97.761	1	268	6	100	0	1	268	198820	198553	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	268	462	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
14638642	14638642	PRJNA640143_S_NODE_15692_length_220_cov_7.606557_g15482_i0	PRJNA640143	15692	220	7.606557	16.7344254	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	279	8.210000000000001e-71	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g15482	i0	89.593	114.372727272727	221	22	100	1	1	220	850066	849846	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	25162	279	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
15912907	15912907	PRJNA640143_S_NODE_28493_length_163_cov_2.166667_g28283_i0	PRJNA640143	28493	163	2.166667	3.53166721	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g28283	i0	98.16	1	163	3	100	0	1	163	198921	199083	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	163	285	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
16458282	16458282	PRJNA640143_S_NODE_9813_length_275_cov_1.558824_g9603_i0	PRJNA640143	9813	275	1.558824	4.286766	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g9603	i0	95.273	8	275	13	100	0	1	275	126494	126768	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2200	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
19736457	19736457	PRJNA640143_S_NODE_14896_length_226_cov_1.650794_g14686_i0	PRJNA640143	14896	226	1.650794	3.73079444	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	361	2.94e-95	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g14686	i0	95.575	8	226	9	100	1	1	226	78451	78675	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1808	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
21557407	21557407	PRJNA640143_S_NODE_8197_length_296_cov_6.772201_g7987_i0	PRJNA640143	8197	296	6.772201	20.04571496	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	416	8.459999999999998e-112	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g7987	i0	93.08	124.496621621622	289	12	97	5	1	286	142204	142487	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	36851	416	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
22287389	22287389	PRJNA640143_S_NODE_9838_length_274_cov_6.181435_g9628_i0	PRJNA640143	9838	274	6.181435	16.9371319	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	375	1.3099999999999998e-99	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g9628	i0	94.979	2.61678832116788	239	12	87	0	1	239	516162	515924	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	717	375	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23562906	23562906	PRJNA640143_S_NODE_9259_length_281_cov_2.922131_g9049_i0	PRJNA640143	9259	281	2.922131	8.21118811	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	128	4.18e-25	NTclustered	gi\|1958092354\|gb\|CP065002.1\|	2026804	g9049	i0	97.333	1.05338078291815	75	2	27	0	188	262	656226	656152	MAG: Candidatus Woesebacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.182_cln chromosome, complete genome	blastn	296	128	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria 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);;