metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Candidatus Melainabacteria"

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_order	tax_species
615948	615948	PRJNA641707_P_NODE_325581_length_156_cov_2.738318_g322918_i0	PRJNA641707	325581	156	2.738318	4.27177608	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g322918	i0	100	0.179487179487179	28	0	18	0	37	64	1558071	1558044	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
617629	617629	PRJNA641707_P_NODE_96201_length_246_cov_4.756345_g93538_i0	PRJNA641707	96201	246	4.756345	11.7006087	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	145	3.56e-30	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g93538	i0	97.619	0.703252032520325	84	2	36	0	5	88	3715808	3715891	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	173	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
1888928	1888928	PRJNA641707_P_NODE_185862_length_199_cov_7.986667_g183199_i0	PRJNA641707	185862	199	7.986667	15.89346733	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	178	2.7299999999999998e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g183199	i0	86.145	269.386934673367	166	22	83	1	6	170	3682165	3682000	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	53608	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
4439294	4439294	PRJNA641707_P_NODE_13684_length_585_cov_66.451493_g11426_i0	PRJNA641707	13684	585	66.451493	388.74123405	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	527	7.879999999999998e-145	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11426	i0	89.286	107.478632478632	420	45	72	0	1	420	3680278	3680697	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	62875	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
4443409	4443409	PRJNA641707_P_NODE_314024_length_160_cov_4.207207_g311361_i0	PRJNA641707	314024	160	4.207207	6.7315312	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	202	1.2499999999999998e-47	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g311361	i0	90.789	171.8375	152	13	94	1	10	160	598243	598092	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	27494	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
5716093	5716093	PRJNA641707_P_NODE_175605_length_200_cov_11.761589_g172942_i0	PRJNA641707	175605	200	11.761589	23.523178	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	174	3.55e-39	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g172942	i0	98	10.05	100	2	98	0	2	101	1222765	1222864	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	2010	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
5719851	5719851	PRJNA641707_P_NODE_3545_length_1067_cov_133.850688_g2527_i0	PRJNA641707	3545	1067	133.850688	1428.18684096	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1125	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2527	i0	85.968	165.900656044986	1069	131	99	19	5	1061	3681622	3682683	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	177016	1125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
5719870	5719870	PRJNA641707_P_NODE_36345_length_359_cov_14.787097_g33710_i0	PRJNA641707	36345	359	14.787097	53.08567823	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	241	6.76e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g33710	i0	86.977	71.4763231197772	215	27	60	1	126	339	3681191	3681405	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25660	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
5720443	5720443	PRJNA641707_P_NODE_61465_length_271_cov_4.504505_g58804_i0	PRJNA641707	61465	271	4.504505	12.20720855	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	171	6.58e-38	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g58804	i0	92.5	45.8376383763838	120	7	44	2	147	264	1478056	1477937	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	12422	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
6990593	6990593	PRJNA641707_P_NODE_159466_length_215_cov_26.246988_g156803_i0	PRJNA641707	159466	215	26.246988	56.4310242	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	180	8.33e-41	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g156803	i0	82.243	218.26976744186	214	33	98	4	1	211	3682169	3682380	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	46928	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
6994839	6994839	PRJNA641707_P_NODE_35546_length_363_cov_7.401274_g32914_i0	PRJNA641707	35546	363	7.401274	26.86662462	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	407	6.379999999999999e-109	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g32914	i0	94.677	140.961432506887	263	12	99	2	1	262	1478998	1479259	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	51169	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
10817815	10817815	PRJNA641707_P_NODE_22509_length_459_cov_8.819512_g19957_i0	PRJNA641707	22509	459	8.819512	40.48156008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	285	4.03e-72	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g19957	i0	83.601	30.2156862745098	311	44	67	6	152	459	3681144	3680838	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13869	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10821082	10821082	PRJNA641707_P_NODE_6189_length_853_cov_137.600746_g2527_i1	PRJNA641707	6189	853	137.600746	1173.73436338	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	966	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2527	i1	87.354	218.474794841735	854	95	99	13	5	849	3682471	3681622	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	186359	966	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
12091637	12091637	PRJNA641707_P_NODE_162170_length_209_cov_7.906250_g159507_i0	PRJNA641707	162170	209	7.90625	16.5240625	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	316	5.879999999999998e-82	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g159507	i0	94.634	155.004784688995	205	9	98	2	6	209	511945	511742	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	32396	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
13365647	13365647	PRJNA641707_P_NODE_130751_length_244_cov_4.528205_g128088_i0	PRJNA641707	130751	244	4.528205	11.0488202	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	172	1.62e-38	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g128088	i0	98.958	57.4754098360656	96	1	80	0	146	241	1477820	1477725	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	14024	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
13367503	13367503	PRJNA641707_P_NODE_21331_length_471_cov_35.834123_g11426_i1	PRJNA641707	21331	471	35.834123	168.77871933	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	438	3.009999999999999e-118	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11426	i1	88.611	178.203821656051	360	41	76	0	112	471	3680278	3680637	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	83934	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
15913802	15913802	PRJNA641707_P_NODE_103693_length_246_cov_3.736041_g101030_i0	PRJNA641707	103693	246	3.736041	9.19066086	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	187	5.839999999999998e-43	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g101030	i0	100	6.05691056910569	101	0	80	0	1	101	3681680	3681780	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	1490	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
17189926	17189926	PRJNA641707_P_NODE_153034_length_232_cov_4.551913_g150371_i0	PRJNA641707	153034	232	4.551913	10.56043816	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	139	1.55e-28	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g150371	i0	94.444	65.9612068965517	90	5	39	0	1	90	3680936	3681025	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15303	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
21016727	21016727	PRJNA641707_P_NODE_257477_length_179_cov_4.638462_g254814_i0	PRJNA641707	257477	179	4.638462	8.30284698	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	311	2.27e-80	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g254814	i0	98.851	8.27932960893855	174	2	97	0	6	179	1222624	1222451	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	1482	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
21017775	21017775	PRJNA641707_P_NODE_30057_length_395_cov_5.916185_g27447_i0	PRJNA641707	30057	395	5.916185	23.36893075	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	418	3.2399999999999993e-112	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g27447	i0	93.885	344.248101265823	278	16	70	1	118	395	1477441	1477717	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	135978	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
22291469	22291469	PRJNA641707_P_NODE_258518_length_178_cov_38.333333_g255855_i0	PRJNA641707	258518	178	38.333333	68.23333274	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	198	1.8299999999999998e-46	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g255855	i0	86.932	49.5393258426966	176	23	99	0	3	178	439889	439714	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	8818	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
23564713	23564713	PRJNA641707_P_NODE_158099_length_219_cov_5.417647_g155436_i0	PRJNA641707	158099	219	5.417647	11.86464693	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	244	2.98e-60	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g155436	i0	89	41.310502283105	200	19	91	3	21	219	511200	511003	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	9047	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
23565226	23565226	PRJNA641707_P_NODE_180639_length_200_cov_4.456954_g177976_i0	PRJNA641707	180639	200	4.456954	8.913908	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	135	1.68e-27	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g177976	i0	91.753	8.505	97	8	49	0	104	200	3682328	3682232	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	1701	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
23568872	23568872	PRJNA641707_P_NODE_337339_length_151_cov_9.029412_g334676_i0	PRJNA641707	337339	151	9.029412	13.63441212	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	200	4.16e-47	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g334676	i0	93.333	100.377483443709	135	9	89	0	4	138	3680221	3680355	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15157	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24843241	24843241	PRJNA641707_P_NODE_62360_length_268_cov_23.497717_g59699_i0	PRJNA641707	62360	268	23.497717	62.97388156	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	278	3.72e-70	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g59699	i0	88.511	227.39552238806	235	20	86	6	32	262	597324	597555	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	60942	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24843810	24843810	PRJNA641707_P_NODE_8900_length_715_cov_210.147147_g2527_i2	PRJNA641707	8900	715	210.147147	1502.55210105	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	889	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2527	i2	89.136	241.65034965035	718	72	99	6	3	715	3682248	3681532	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	172780	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;