metadata: contig_metadata: 26 rows where bioproject = "PRJNA737474", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

26 rows where bioproject = "PRJNA737474", tax_clade = "Cyanobacteriota/Melainabacteria group" 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_class	tax_order	tax_family	tax_genus	tax_species
25576973	25576973	PRJNA737474f_S_NODE_12897_length_561_cov_541.555328_g12237_i0	PRJNA737474	12897	561	541.555328	3038.12539008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	301	1.53e-100	NR	RTL37621.1	2052166	g12237	i0	98.7	1.64705882352941	154	2	82.4	0	561	100	38	191	RTL37621.1 MAG: hypothetical protein EKK48_23325 [Candidatus Melainabacteria bacterium]	diamond	924	301	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32937383	32937383	PRJNA737474g_S_NODE_169257_length_289_cov_0.962963_g167963_i0	PRJNA737474	169257	289	0.962963	2.78296307	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	146	5.1e-43	NR	MDP3507410.1	2052166	g167963	i0	88.4	0.892733564013841	86	10	89.3	0	31	288	1	86	MDP3507410.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	258	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32941959	32941959	PRJNA737474g_S_NODE_419233_length_242_cov_1.520710_g417939_i0	PRJNA737474	419233	242	1.52071	3.6801182	Bacillati	1783272	Bacteria	Bacteria	119	4.08e-29	NR	RTL43186.1	2052166	g417939	i0	73.3	1.84710743801653	75	20	93	0	242	18	438	512	RTL43186.1 MAG: amylo-alpha-1,6-glucosidase [Candidatus Melainabacteria bacterium]	diamond	447	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32954806	32954806	PRJNA737474g_S_NODE_215714_length_273_cov_1.050000_g214420_i0	PRJNA737474	215714	273	1.05	2.8665	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	115	1.2399999999999998e-31	NR	MBK7746241.1	2711154	g214420	i0	89.4	0.725274725274725	66	7	72.5	0	262	65	1	66	MBK7746241.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	198	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32976299	32976299	PRJNA737474g_S_NODE_85754_length_342_cov_1.494424_g84460_i0	PRJNA737474	85754	342	1.494424	5.11093008	Bacillati	1783272	Bacteria	Bacteria	162	1.36e-48	NR	MFN8552990.1	2364082	g84460	i0	90.2	1.6140350877193	92	9	80.7	0	65	340	1	92	MFN8552990.1 cytochrome b N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	552	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32988895	32988895	PRJNA737474g_S_NODE_220955_length_271_cov_2.181818_g219661_i0	PRJNA737474	220955	271	2.181818	5.91272678	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	165	9.39e-46	NR	MBN9393975.1	2052166	g219661	i0	100	0.996309963099631	90	0	99.6	0	270	1	10	99	MBN9393975.1 DUF4388 domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	270	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33006533	33006533	PRJNA737474g_S_NODE_90107_length_337_cov_1.609848_g88813_i0	PRJNA737474	90107	337	1.609848	5.42518776	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.8	2.46e-8	NR	MFN8555340.1	2364082	g88813	i0	88.6	0.605341246290801	35	4	31.2	0	33	137	184	218	MFN8555340.1 SbmA/BacA-like family transporter [Candidatus Obscuribacterales bacterium]	diamond	204	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33010267	33010267	PRJNA737474g_S_NODE_421763_length_242_cov_1.053254_g420469_i0	PRJNA737474	421763	242	1.053254	2.54887468	Bacillati	1783272	Bacteria	Bacteria	98.6	2.33e-24	NR	MDR3614483.1	2364082	g420469	i0	68.9	6.50826446280992	74	23	91.7	0	238	17	52	125	MDR3614483.1 response regulator [Candidatus Obscuribacterales bacterium]	diamond	1575	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33038340	33038340	PRJNA737474c_S_NODE_5868_length_444_cov_4.199461_g5038_i0	PRJNA737474	5868	444	4.199461	18.64560684	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	69.7	9.1e-11	NR	MBL8081486.1	2711154	g5038	i0	57.6	1.59459459459459	59	25	39.9	0	266	442	7	65	MBL8081486.1 AI-2E family transporter [Candidatus Obscuribacter sp.]	diamond	708	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
33039689	33039689	PRJNA737474g_S_NODE_117492_length_314_cov_1.705394_g116198_i0	PRJNA737474	117492	314	1.705394	5.35493716	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	103	1.02e-24	NR	MBX9667415.1	2364082	g116198	i0	50.5	0.945859872611465	99	49	94.6	0	311	15	76	174	MBX9667415.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	297	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33039716	33039716	PRJNA737474g_S_NODE_123732_length_310_cov_1.886076_g122438_i0	PRJNA737474	123732	310	1.886076	5.8468356	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	108	6.3499999999999995e-25	NR	MDJ0625991.1	2729995	g122438	i0	55.3	0.996774193548387	103	42	96.8	2	1	300	185	286	MDJ0625991.1 hypothetical protein [Candidatus Caenarcanales bacterium]	diamond	309	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
33044217	33044217	PRJNA737474g_S_NODE_125276_length_309_cov_2.262712_g123982_i0	PRJNA737474	125276	309	2.262712	6.99178008	Bacillati	1783272	Bacteria	Bacteria	110	1.37e-26	NR	MBY0547580.1	2364082	g123982	i0	53.6	1.85436893203884	97	43	92.2	1	15	299	150	246	MBY0547580.1 IS3 family transposase [Candidatus Obscuribacterales bacterium]	diamond	573	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33060997	33060997	PRJNA737474f_S_NODE_10573_length_624_cov_2.101633_g9936_i0	PRJNA737474	10573	624	2.101633	13.11418992	Candidatus Obscuribacter	1906156	Bacteria	Bacteria	281	9.649999999999999e-91	NR	MCC6977763.1	2052166	g9936	i0	61.5	15	208	79	100	1	1	624	113	319	MCC6977763.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Melainabacteria bacterium]	diamond	9360	282	0.99645390070922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33078168	33078168	PRJNA737474f_S_NODE_126733_length_277_cov_1.083333_g126055_i0	PRJNA737474	126733	277	1.083333	3.00083241	Bacillati	1783272	Bacteria	Bacteria	62	7.61e-9	NR	MBX9567767.1	2364082	g126055	i0	49.1	5.32851985559567	57	29	61.7	0	3	173	242	298	MBX9567767.1 universal stress protein [Candidatus Obscuribacterales bacterium]	diamond	1476	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33089883	33089883	PRJNA737474d_S_NODE_39846_length_244_cov_1.163743_g39252_i0	PRJNA737474	39846	244	1.163743	2.83953292	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	2.07e-29	NR	MDR3614111.1	2364082	g39252	i0	75.3	0.995901639344262	81	20	99.6	0	2	244	112	192	MDR3614111.1 TolC family protein [Candidatus Obscuribacterales bacterium]	diamond	243	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33107803	33107803	PRJNA737474f_S_NODE_85094_length_301_cov_2.399123_g84416_i0	PRJNA737474	85094	301	2.399123	7.22136023	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	72.8	1.87e-12	NR	RTL42403.1	2052166	g84416	i0	64.3	0.558139534883721	56	20	55.8	0	298	131	365	420	RTL42403.1 MAG: hypothetical protein EKK48_10435 [Candidatus Melainabacteria bacterium]	diamond	168	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33124223	33124223	PRJNA737474f_S_NODE_116143_length_282_cov_1.459330_g115465_i0	PRJNA737474	116143	282	1.45933	4.1153106	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	84.7	4.13e-17	NR	MBX9724431.1	2364082	g115465	i0	46.9	0.861702127659574	81	43	86.2	0	3	245	115	195	MBX9724431.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	243	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33129333	33129333	PRJNA737474d_S_NODE_38991_length_246_cov_1.485549_g38397_i0	PRJNA737474	38991	246	1.485549	3.65445054	Bacillati	1783272	Bacteria	Bacteria	120	4.92e-30	NR	MDX2086181.1	2052166	g38397	i0	82.6	3.36585365853659	69	12	84.1	0	38	244	384	452	MDX2086181.1 IMP dehydrogenase [Candidatus Melainabacteria bacterium]	diamond	828	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33129556	33129556	PRJNA737474f_S_NODE_8743_length_692_cov_14.833603_g8134_i0	PRJNA737474	8743	692	14.833603	102.64853276	Bacteria	2	Bacteria	Bacteria	159	7.74e-45	NR	HNB23518.1	2052166	g8134	i0	54.3	3	138	63	59.8	0	1	414	77	214	HNB23518.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Melainabacteria bacterium]	diamond	2076	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33140941	33140941	PRJNA737474d_S_NODE_35847_length_255_cov_1.263736_g35253_i0	PRJNA737474	35847	255	1.263736	3.2225268	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	137	2.04e-35	NR	MDR3614111.1	2364082	g35253	i0	78.6	0.988235294117647	84	18	98.8	0	3	254	159	242	MDR3614111.1 TolC family protein [Candidatus Obscuribacterales bacterium]	diamond	252	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33158670	33158670	PRJNA737474f_S_NODE_39224_length_364_cov_2.340206_g38546_i0	PRJNA737474	39224	364	2.340206	8.51834984	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	141	5.109999999999999e-38	NR	MDR3615288.1	2364082	g38546	i0	55.1	0.972527472527473	118	53	97.3	0	356	3	64	181	MDR3615288.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	354	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33158863	33158863	PRJNA737474f_S_NODE_77768_length_307_cov_1.461538_g77090_i0	PRJNA737474	77768	307	1.461538	4.48692166	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	51.6	5.55e-5	NR	MDZ4835331.1	2052166	g77090	i0	54.5	0.53745928338762206	55	20	53.7	1	179	15	1	50	MDZ4835331.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	165	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33163623	33163623	PRJNA737474g_S_NODE_25264_length_581_cov_1.850394_g24009_i0	PRJNA737474	25264	581	1.850394	10.75078914	Bacillati	1783272	Bacteria	Bacteria	47.8	6.56e-4	NR	MDX1918778.1	2729995	g24009	i0	48.6	1.2960413080895	37	19	19.1	0	581	471	12	48	MDX1918778.1 tetratricopeptide repeat protein [Candidatus Caenarcanales bacterium]	diamond	753	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
33176937	33176937	PRJNA737474g_S_NODE_393696_length_244_cov_1.660819_g392402_i0	PRJNA737474	393696	244	1.660819	4.05239836	Vampirovibrio sp.	2717857	Bacteria	Bacteria	105	3.5700000000000005e-27	NR	WP_373531235.1	2717857	g392402	i0	86.2	3.54098360655738	58	8	71.3	0	176	3	8	65	WP_373531235.1 hypothetical protein [Vampirovibrio sp.]	diamond	864	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrio	Vampirovibrio sp.
33177014	33177014	PRJNA737474g_S_NODE_439992_length_241_cov_0.886905_g438698_i0	PRJNA737474	439992	241	0.886905	2.13744105	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	147	3.88e-40	NR	MBN8659058.1	1906157	g438698	i0	92	0.933609958506224	75	6	93.4	0	17	241	1	75	MBN8659058.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Candidatus Obscuribacter phosphatis]	diamond	225	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
33180608	33180608	PRJNA737474f_S_NODE_141448_length_270_cov_1.441624_g140770_i0	PRJNA737474	141448	270	1.441624	3.8923848	Candidatus Obscuribacter	1906156	Bacteria	Bacteria	71.6	4.04e-13	NR	MBX9772038.1	2364082	g140770	i0	43.7	2.87777777777778	87	47	94.4	1	261	7	15	101	MBX9772038.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	777	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;