metadata: contig_metadata: 24 rows where bioproject = "PRJNA946307" and tax

24 rows where bioproject = "PRJNA946307" 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
2202203	2202203	PRJNA946307_P_NODE_23742_length_263_cov_4.649533_g22868_i0	PRJNA946307	23742	263	4.649533	12.22827179	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	339	1.65e-88	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22868	i0	91.968	2.50190114068441	249	7	95	4	1	249	3682367	3682602	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	658	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
6029179	6029179	PRJNA946307_P_NODE_128165_length_171_cov_3.319672_g127291_i0	PRJNA946307	128165	171	3.319672	5.67663912	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	135	1.3800000000000002e-27	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g127291	i0	89.623	96.2397660818714	106	11	62	0	52	157	509914	510019	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	16457	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
7305200	7305200	PRJNA946307_P_NODE_3406_length_794_cov_11.401342_g2852_i0	PRJNA946307	3406	794	11.401342	90.52665548	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	889	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2852	i0	87.342	297.613350125945	790	83	98	16	14	794	3682595	3681814	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	236305	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8578415	8578415	PRJNA946307_P_NODE_10207_length_420_cov_128.854447_g9356_i0	PRJNA946307	10207	420	128.854447	541.1886774	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	532	1.1799999999999996e-146	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9356	i0	90.394	143.471428571429	406	37	96	2	15	419	3680698	3680294	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	60258	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
9854903	9854903	PRJNA946307_P_NODE_23508_length_265_cov_1.254630_g22634_i0	PRJNA946307	23508	265	1.25463	3.3247695	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	207	4.88e-49	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g22634	i0	82.258	946.052830188679	248	36	92	7	7	251	1477736	1477494	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	250704	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
9855677	9855677	PRJNA946307_P_NODE_66248_length_199_cov_5.433333_g65374_i0	PRJNA946307	66248	199	5.433333	10.81233267	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	158	3.56e-34	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g65374	i0	97.826	61.1105527638191	92	1	46	1	11	102	511466	511376	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	12161	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
13681267	13681267	PRJNA946307_P_NODE_60071_length_207_cov_1.797468_g59197_i0	PRJNA946307	60071	207	1.797468	3.72075876	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	348	2.06e-91	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g59197	i0	99.476	0.922705314009662	191	1	92	0	6	196	3681008	3681198	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	191	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
16230923	16230923	PRJNA946307_P_NODE_85653_length_190_cov_3.907801_g84779_i0	PRJNA946307	85653	190	3.907801	7.4248219	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	318	1.46e-82	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g84779	i0	99.429	138.763157894737	175	1	92	0	1	175	1477685	1477511	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	26365	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
17504732	17504732	PRJNA946307_P_NODE_156934_length_163_cov_1.666667_g156060_i0	PRJNA946307	156934	163	1.666667	2.7166672100000002	Bacillati	1783272	Bacteria	Bacteria	97.8	4.4e-22	NR	HIA54398.1	2052166	g156060	i0	93.9	6.33128834355828	49	3	90.2	0	17	163	344	392	HIA54398.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Melainabacteria bacterium]	diamond	1032	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
20054345	20054345	PRJNA946307_P_NODE_6636_length_551_cov_20.392430_g5857_i0	PRJNA946307	6636	551	20.39243	112.3622893	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	542	2.64e-149	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5857	i0	84.532	120.357531760436	556	77	100	6	1	551	3681049	3681600	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	66317	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
22604306	22604306	PRJNA946307_P_NODE_4018_length_729_cov_53.227941_g3396_i0	PRJNA946307	4018	729	53.227941	388.03168989	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	664	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3396	i0	84.046	292.912208504801	702	98	95	12	38	729	3680903	3681600	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	213533	664	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
22604695	22604695	PRJNA946307_P_NODE_63098_length_201_cov_6.414474_g62224_i0	PRJNA946307	63098	201	6.414474	12.89309274	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	335	1.5499999999999995e-87	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g62224	i0	98.93	119.388059701493	187	2	93	0	1	187	1479879	1479693	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	23997	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
23879954	23879954	PRJNA946307_P_NODE_4819_length_661_cov_25.433007_g4143_i0	PRJNA946307	4819	661	25.433007	168.11217627	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	604	4.0299999999999988e-168	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4143	i0	83.333	312.402420574887	672	94	100	14	1	661	3681600	3680936	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	206498	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26746835	26746835	PRJNA946307_P_NODE_67161_length_199_cov_4.333333_g66287_i0	PRJNA946307	67161	199	4.333333	8.62333267	Bacteria	2	Bacteria	Bacteria	67.4	4.21e-11	NR	MDX2086043.1	2052166	g66287	i0	96.9	0.964824120603015	32	1	48.2	0	5	100	243	274	MDX2086043.1 portal protein [Candidatus Melainabacteria bacterium]	diamond	192	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26867463	26867463	PRJNA946307_P_NODE_59701_length_207_cov_12.411392_g58827_i0	PRJNA946307	59701	207	12.411392	25.69158144	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	47	5.42e-5	NR	MBX9722867.1	2364082	g58827	i0	49	0.710144927536232	49	25	71	0	35	181	10	58	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	147	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
26898915	26898915	PRJNA946307_P_NODE_114741_length_177_cov_3.062500_g113867_i0	PRJNA946307	114741	177	3.0625	5.420625	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	55.5	6.25e-8	NR	PZM84364.1	2052166	g113867	i0	61.9	0.711864406779661	42	16	71.2	0	159	34	75	116	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	126	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27499454	27499454	PRJNA946307_P_NODE_101623_length_183_cov_2.820896_g100749_i0	PRJNA946307	101623	183	2.820896	5.16223968	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	56.2	2.96e-7	NR	MBX9937662.1	2364082	g100749	i0	54	0.819672131147541	50	22	82	1	34	183	123	171	MBX9937662.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	150	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
28358452	28358452	PRJNA946307_P_NODE_130926_length_170_cov_2.371901_g130052_i0	PRJNA946307	130926	170	2.371901	4.0322317	Bacteria	2	Bacteria	Bacteria	84.3	2.43e-17	NR	OGI04886.1	1801606	g130052	i0	76.9	7.34117647058823	52	12	91.8	0	2	157	135	186	OGI04886.1 MAG: adenosylhomocysteinase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	1248	84.7	0.995277449822904	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium GWF2_37_15
28636291	28636291	PRJNA946307_P_NODE_144627_length_166_cov_1.444444_g143753_i0	PRJNA946307	144627	166	1.444444	2.39777704	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	87.4	4.71e-19	NR	MDD3014313.1	2137880	g143753	i0	80.4	0.921686746987952	51	10	92.2	0	155	3	220	270	MDD3014313.1 flagellar basal body P-ring formation chaperone FlgA [Candidatus Gastranaerophilales bacterium]	diamond	153	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
29109844	29109844	PRJNA946307_P_NODE_62868_length_202_cov_1.947712_g61994_i0	PRJNA946307	62868	202	1.947712	3.93437824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	63.9	3.99e-11	NR	PZM84364.1	2052166	g61994	i0	58.5	0.787128712871287	53	22	78.7	0	200	42	63	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	159	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
30151596	30151596	PRJNA946307_P_NODE_66332_length_199_cov_5.260000_g65458_i0	PRJNA946307	66332	199	5.26	10.4674	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	74.7	2.31e-15	NR	PZM84364.1	2052166	g65458	i0	75	0.723618090452261	48	12	72.4	0	183	40	68	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	144	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
31517582	31517582	PRJNA946307_P_NODE_49156_length_210_cov_3.521739_g48282_i0	PRJNA946307	49156	210	3.521739	7.3956519	Bacillati	1783272	Bacteria	Bacteria	53.9	2.71e-6	NR	RTL36930.1	2052166	g48282	i0	93.1	0.828571428571429	29	2	41.4	0	12	98	1	29	RTL36930.1 MAG: VWA domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	174	54.3	0.992633517495396	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
31896957	31896957	PRJNA946307_P_NODE_127257_length_172_cov_1.577236_g126383_i0	PRJNA946307	127257	172	1.577236	2.71284592	Bacillati	1783272	Bacteria	Bacteria	80.5	2.64e-16	NR	RTL39761.1	2052166	g126383	i0	80.8	1.81395348837209	52	10	90.7	0	2	157	133	184	RTL39761.1 MAG: hypothetical protein EKK48_17975 [Candidatus Melainabacteria bacterium]	diamond	312	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32775110	32775110	PRJNA946307_P_NODE_118960_length_175_cov_4.158730_g118086_i0	PRJNA946307	118960	175	4.15873	7.2777775	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.5	3.03e-5	NR	PZM84364.1	2052166	g118086	i0	65.8	0.651428571428571	38	13	65.1	0	32	145	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	48.5	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);;