metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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
2850105	2850105	PRJNA1148190_P_NODE_70703_length_662_cov_1.811545_g59618_i0	PRJNA1148190	70703	662	1.811545	11.9924279	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	183	2.24e-41	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g59618	i0	78.853	0.421450151057402	279	53	42	6	165	440	1298758	1299033	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	279	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
5395036	5395036	PRJNA1148190_P_NODE_183905_length_390_cov_2.028391_g172736_i0	PRJNA1148190	183905	390	2.028391	7.9107249	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	289	2.61e-73	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g172736	i0	81.044	0.933333333333333	364	67	93	2	1	363	3380247	3380609	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	364	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
5397904	5397904	PRJNA1148190_P_NODE_372545_length_292_cov_2.000000_g361372_i0	PRJNA1148190	372545	292	2	5.84	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	300	8.75e-77	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g361372	i0	85.324	88.9212328767123	293	40	100	2	1	292	3681149	3681439	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25965	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
6678463	6678463	PRJNA1148190_P_NODE_86826_length_581_cov_2.059055_g75693_i0	PRJNA1148190	86826	581	2.059055	11.96310955	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	73.1	4.4e-8	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g75693	i0	100	0.261617900172117	39	0	25	0	506	544	1887772	1887810	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
7950638	7950638	PRJNA1148190_P_NODE_57887_length_761_cov_1.556686_g46929_i0	PRJNA1148190	57887	761	1.556686	11.84638046	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	320	1.8999999999999998e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g46929	i0	83.003	13.634691195795	353	60	46	0	1	353	3595019	3594667	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	10376	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
7952328	7952328	PRJNA1148190_P_NODE_709267_length_245_cov_0.895349_g698094_i0	PRJNA1148190	709267	245	0.895349	2.19360505	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	254	5.65e-63	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g698094	i0	85.892	45.8367346938776	241	30	98	4	1	239	579813	580051	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	11230	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
7953586	7953586	PRJNA1148190_P_NODE_81807_length_603_cov_1.728302_g70682_i0	PRJNA1148190	81807	603	1.728302	10.42166106	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	141	1.2399999999999999e-28	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g70682	i0	92.157	1.89054726368159	102	4	17	3	266	366	2111070	2110972	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	1140	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10497896	10497896	PRJNA1148190_P_NODE_336449_length_305_cov_2.068966_g325276_i0	PRJNA1148190	336449	305	2.068966	6.3103463	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	106	2.15e-18	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g325276	i0	93.151	48.1049180327869	73	4	24	1	1	73	1495080	1495151	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14672	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10500182	10500182	PRJNA1148190_P_NODE_493509_length_268_cov_1.215385_g482336_i0	PRJNA1148190	493509	268	1.215385	3.2572318	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	263	1.04e-65	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g482336	i0	84.387	2.07462686567164	269	40	100	2	1	268	1853239	1853506	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	556	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
11775296	11775296	PRJNA1148190_P_NODE_502590_length_266_cov_1.419689_g491417_i0	PRJNA1148190	502590	266	1.419689	3.77637274	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	324	4.67e-84	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g491417	i0	88.973	0.988721804511278	263	28	99	1	1	263	280640	280901	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	263	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
13053070	13053070	PRJNA1148190_P_NODE_726531_length_244_cov_0.900585_g715358_i0	PRJNA1148190	726531	244	0.900585	2.1974274	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g715358	i0	100	1	244	0	100	0	1	244	390872	391115	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	244	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
14320022	14320022	PRJNA1148190_P_NODE_143892_length_438_cov_1.972603_g132727_i0	PRJNA1148190	143892	438	1.972603	8.64000114	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	276	2.31e-69	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g132727	i0	88.839	1.02054794520548	224	25	51	0	1	224	3715777	3716000	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	447	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
15602001	15602001	PRJNA1148190_P_NODE_706553_length_245_cov_0.895349_g695380_i0	PRJNA1148190	706553	245	0.895349	2.19360505	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g695380	i0	100	1	245	0	100	0	1	245	3063063	3063307	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	245	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
19416685	19416685	PRJNA1148190_P_NODE_115216_length_493_cov_1.471429_g104054_i0	PRJNA1148190	115216	493	1.471429	7.25414497	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	455	3.14e-123	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g104054	i0	83.711	49.5354969574037	485	75	98	4	3	485	4230345	4230827	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	24421	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
19422823	19422823	PRJNA1148190_P_NODE_50936_length_836_cov_2.684142_g40132_i0	PRJNA1148190	50936	836	2.684142	22.43942712	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	333	2.68e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g40132	i0	85.185	0.755980861244019	324	48	39	0	431	754	3715692	3716015	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	632	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
19426885	19426885	PRJNA1148190_P_NODE_95576_length_549_cov_0.934874_g84427_i0	PRJNA1148190	95576	549	0.934874	5.13245826	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	320	1.34e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g84427	i0	84.735	1.74499089253188	321	48	58	1	230	549	4229186	4229506	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	958	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
21971720	21971720	PRJNA1148190_P_NODE_384518_length_289_cov_1.652778_g373345_i0	PRJNA1148190	384518	289	1.652778	4.77652842	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	145	4.29e-30	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g373345	i0	95.652	0.820069204152249	92	1	32	3	178	269	3855721	3855809	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	237	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24517057	24517057	PRJNA1148190_P_NODE_144120_length_438_cov_1.400000_g132955_i0	PRJNA1148190	144120	438	1.4	6.132	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	132	5.29e-26	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g132955	i0	96.296	16.6872146118721	81	2	18	1	221	301	1725592	1725671	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	7309	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24517720	24517720	PRJNA1148190_P_NODE_181540_length_393_cov_0.893750_g170371_i0	PRJNA1148190	181540	393	0.89375	3.5124375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	278	5.6999999999999996e-70	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g170371	i0	79.948	62.3918575063613	384	71	97	5	11	391	3981886	3981506	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	24520	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24524195	24524195	PRJNA1148190_P_NODE_63120_length_715_cov_2.655763_g40132_i1	PRJNA1148190	63120	715	2.655763	18.98870545	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	333	2.28e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g40132	i1	85.185	0.883916083916084	324	48	46	0	310	633	3715692	3716015	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	632	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24524828	24524828	PRJNA1148190_P_NODE_682620_length_246_cov_0.890173_g671447_i0	PRJNA1148190	682620	246	0.890173	2.18982558	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	195	3.49e-45	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g671447	i0	81.048	1.00813008130081	248	43	100	4	1	246	647351	647596	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	248	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24526477	24526477	PRJNA1148190_P_NODE_84180_length_592_cov_2.042389_g73048_i0	PRJNA1148190	84180	592	2.042389	12.09094288	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	414	6.48e-111	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g73048	i0	79.895	0.966216216216216	572	109	96	6	9	577	3244024	3244592	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	572	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
25262753	25262753	PRJNA1148190_P_NODE_87920_length_577_cov_1.418651_g76786_i0	PRJNA1148190	87920	577	1.418651	8.18561627	Bacillati	1783272	Bacteria	Bacteria	147	2.54e-30	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g76786	i0	100	13.6915077989601	79	0	14	0	184	262	3269303	3269381	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	7900	147	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);;