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

27 rows where analysis = "blastn" and tax_phylum = "Candidatus Hydrogenedentota"

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_kingdom	tax_phylum	tax_species
527986	527986	PRJNA556992_P_NODE_382021_length_278_cov_3.326829_g379832_i0	PRJNA556992	382021	278	3.326829	9.24858462	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	351	2.25e-92	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g379832	i0	92.063	209.838129496403	252	16	90	4	1	250	2443980	2444229	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	58335	351	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
602194	602194	PRJNA630162_P_NODE_34721_length_304_cov_2.082353_g33198_i0	PRJNA630162	34721	304	2.082353	6.33035312	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	359	1.49e-94	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g33198	i0	88.079	64.2269736842105	302	36	99	0	3	304	2443085	2442784	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	19525	359	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
1681164	1681164	PRJNA385073_P_NODE_53362_length_244_cov_0.900585_g53200_i0	PRJNA385073	53362	244	0.900585	2.1974274	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	230	9.47e-56	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g53200	i0	85.268	67.7254098360656	224	31	91	1	23	244	1907535	1907758	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	16525	230	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
2831565	2831565	PRJNA1123686_S_NODE_1823_length_293_cov_20.568182_g1791_i0	PRJNA1123686	1823	293	20.568182	60.26477326	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2107987552\|gb\|CP070779.1\|	2030809	g1791	i0	100	0.0989761092150171	29	0	10	0	87	115	1128365	1128393	MAG: Candidatus Hydrogenedentota bacterium isolate bin18 chromosome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
3474953	3474953	PRJNA944406_P_NODE_11363_length_371_cov_1.550336_g10404_i0	PRJNA944406	11363	371	1.550336	5.75174656	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	558	1.7e-154	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g10404	i0	93.834	242.102425876011	373	19	99	3	1	370	2443051	2442680	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	89820	558	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
5232418	5232418	PRJEB64798_P_NODE_9665_length_641_cov_116.175676_g8192_i0	PRJEB64798	9665	641	116.175676	744.68608316	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	553	1.4299999999999995e-152	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g8192	i0	84.752	138.163806552262	564	73	87	10	3	560	2441893	2441337	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	88563	553	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
6513284	6513284	PRJEB73599_P_NODE_5826_length_257_cov_3.293860_g5539_i0	PRJEB73599	5826	257	3.29386	8.4652202	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	165	2.88e-36	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g5539	i0	83.799	497.070038910506	179	24	68	5	2	176	2442660	2442837	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	127747	165	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
8098880	8098880	PRJNA473799_P_NODE_43307_length_246_cov_2.225434_g43033_i0	PRJNA473799	43307	246	2.225434	5.47456764	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	267	7.289999999999999e-67	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g43033	i0	86.345	258.967479674797	249	29	100	5	1	246	2444289	2444043	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	63706	267	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
8841227	8841227	PRJNA704949_P_NODE_2086407_length_164_cov_1.695652_g2071068_i0	PRJNA704949	2086407	164	1.695652	2.78086928	FCB group	1783270	Bacteria	Bacteria	117	4.79e-22	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g2071068	i0	93.59	16.0670731707317	78	5	48	0	51	128	1648450	1648373	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	2635	117	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
9650544	9650544	PRJNA743294_P_NODE_39948_length_269_cov_1.474490_g39492_i0	PRJNA743294	39948	269	1.47449	3.9663781	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	398	2.7499999999999996e-106	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g39492	i0	93.309	680.494423791822	269	18	100	0	1	269	2442646	2442914	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	183053	398	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
10653719	10653719	PRJNA488043_S_NODE_849_length_204_cov_5.702857_g838_i0	PRJNA488043	849	204	5.702857	11.63382828	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	119	1.73e-22	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g838	i0	90.217	0.450980392156863	92	8	45	1	107	197	2441510	2441601	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	92	119	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
11158338	11158338	PRJNA980585_P_NODE_41409_length_251_cov_0.865169_g41155_i0	PRJNA980585	41409	251	0.865169	2.17157419	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	291	4.43e-74	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g41155	i0	87.698	1025.11553784861	252	27	100	4	1	251	2441359	2441607	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	257304	291	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
12092990	12092990	PRJNA641707_P_NODE_221570_length_193_cov_2.381944_g218907_i0	PRJNA641707	221570	193	2.381944	4.59715192	uncultured Hydrogenedentota bacterium	214883	Bacteria	Bacteria	283	5.42e-72	NTclustered	gi\|26000473\|gb\|AY150902.1\|	214883	g218907	i0	94.565	96.0880829015544	184	9	95	1	5	188	276	94	Uncultured candidate division NKB19 bacterium clone WYO5c 16S ribosomal RNA gene, partial sequence	blastn	18545	283	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	uncultured Hydrogenedentota bacterium
13127370	13127370	PRJNA293269_P_NODE_2131_length_548_cov_1.641283_g1888_i0	PRJNA293269	2131	548	1.641283	8.99423084	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	78.7	8.89e-10	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g1888	i0	88.06	2.80109489051095	67	6	12	2	123	188	3923508	3923443	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	1535	78.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
14775963	14775963	PRJNA771359_S_NODE_4852_length_155_cov_1.652542_g4769_i0	PRJNA771359	4852	155	1.652542	2.5614401	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	106	9.64e-19	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g4769	i0	91.139	1.20645161290323	79	6	50	1	78	155	2441510	2441588	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	187	106	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
15592860	15592860	PRJNA1146029_P_NODE_10613_length_287_cov_0.822430_g10332_i0	PRJNA1146029	10613	287	0.82243	2.3603741	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	281	3.11e-71	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g10332	i0	87.55	44.4459930313589	249	24	86	6	36	283	2443163	2442921	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	12756	281	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
16910805	16910805	PRJNA1218818_P_NODE_17954_length_294_cov_1.914027_g17887_i0	PRJNA1218818	17954	294	1.914027	5.62723938	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	226	1.52e-54	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g17887	i0	80.612	26.4047619047619	294	56	100	1	1	294	2441891	2441599	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	7763	226	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
17180619	17180619	PRJNA630162_P_NODE_72854_length_210_cov_3.111801_g71331_i0	PRJNA630162	72854	210	3.111801	6.5347821	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	189	1.35e-43	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g71331	i0	83.495	397.490476190476	206	31	98	2	2	206	2444334	2444131	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	83473	189	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
19571132	19571132	PRJNA473799_P_NODE_13816_length_294_cov_1.212670_g13542_i0	PRJNA473799	13816	294	1.21267	3.5652498	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	414	3.02e-111	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g13542	i0	92.734	341.850340136054	289	18	98	2	8	294	2442912	2442625	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	100504	414	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
19571794	19571794	PRJNA473799_P_NODE_8316_length_372_cov_3.892977_g8042_i0	PRJNA473799	8316	372	3.892977	14.48187444	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	324	6.79e-84	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g8042	i0	82.656	113.180107526882	369	60	99	4	5	372	2441527	2441892	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	42103	324	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
20772436	20772436	PRJNA276667_S_NODE_5097_length_181_cov_3.486842_g4958_i0	PRJNA276667	5097	181	3.486842	6.31118402	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	102	1.51e-17	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g4958	i0	82.906	0.646408839779006	117	16	64	4	1	115	2442791	2442677	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	117	102	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
22028187	22028187	PRJNA1247234_P_NODE_22478_length_250_cov_0.881356_g22322_i0	PRJNA1247234	22478	250	0.881356	2.20339	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	244	3.48e-60	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g22322	i0	84.462	108.9	251	35	99	4	1	249	2996446	2996198	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	27225	244	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
23402322	23402322	PRJNA488043_S_NODE_1279_length_171_cov_4.457746_g1268_i0	PRJNA488043	1279	171	4.457746	7.62274566	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	233	4.77e-57	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g1268	i0	91.329	298.959064327485	173	12	100	2	1	171	2442938	2442767	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	51122	233	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
24827812	24827812	PRJNA630162_P_NODE_128320_length_170_cov_1.809917_g126797_i0	PRJNA630162	128320	170	1.809917	3.0768589	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	169	1.35e-37	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g126797	i0	85.03	497.8	167	23	97	2	5	169	2444166	2444332	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	84626	169	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
26058230	26058230	PRJEB20058_P_NODE_128877_length_348_cov_1.484321_g126058_i0	PRJEB20058	128877	348	1.484321	5.16543708	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	292	1.7799999999999998e-74	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g126058	i0	82.102	85.183908045977	352	54	100	7	1	348	2441782	2441436	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	29644	292	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
26267217	26267217	PRJNA737474g_S_NODE_341894_length_249_cov_0.863636_g340600_i0	PRJNA737474	341894	249	0.863636	2.15045364	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	80.5	1.03e-10	NTclustered	gi\|2166243706\|dbj\|LC663005.1\|	2030809	g340600	i0	94.34	179.208835341365	53	2	21	1	28	79	1	53	Candidatus Hydrogenedentes bacterium ARSSAG-00002382 DNA, putative prophage region, clone: 00002382_pp1	blastn	44623	80.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota bacterium
26470935	26470935	PRJEB20058_P_NODE_231416_length_230_cov_3.674556_g228591_i0	PRJEB20058	231416	230	3.674556	8.4514788	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	268	1.87e-67	NTclustered	gi\|2621786419\|emb\|OY782877.1\|	2030809	g228591	i0	88.636	457.252173913043	220	25	96	0	11	230	2441995	2442214	MAG: Candidatus Hydrogenedentes bacterium isolate 28e603e2-5466-4732-bb1a-a7370d5bccbd genome assembly, chromosome: 1	blastn	105168	268	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota	Candidatus Hydrogenedentota 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);;