metadata: contig_metadata: 53 rows where bioproject = "PRJNA270367" and tax_clade = "Cyanobacteriota/Melainabacteria group"

53 rows where bioproject = "PRJNA270367" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
370147	370147	PRJNA270367_P_NODE_40921_length_168_cov_0.873950_g40716_i0	PRJNA270367	40921	168	0.87395	1.468236	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	132	1.7600000000000002e-26	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g40716	i0	94.253	44.3928571428571	87	4	52	1	18	104	2001875	2001960	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	7458	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6160849	6160849	PRJNA270367_P_NODE_29665_length_205_cov_1.333333_g29460_i0	PRJNA270367	29665	205	1.333333	2.73333265	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	90.5	2.91e-19	NR	HEY9877209.1	3088178	g29460	i0	64.7	24.6439024390244	68	21	99.5	1	204	1	212	276	HEY9877209.1 ammonium transporter [Leptolyngbyaceae cyanobacterium]	diamond	5052	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
15085191	15085191	PRJNA270367_P_NODE_13792_length_349_cov_3.363333_g13587_i0	PRJNA270367	13792	349	3.363333	11.73803217	Cyanophyceae	3028117	Bacteria	Bacteria	156	1.8e-45	NR	WP_017304681.1	54311	g13587	i0	76.9	22.6848137535817	91	21	78.2	0	1	273	121	211	WP_017304681.1 peroxiredoxin [Spirulina subsalsa]	diamond	7917	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina subsalsa
16947588	16947588	PRJNA270367_P_NODE_5694_length_572_cov_3.502868_g5502_i0	PRJNA270367	5694	572	3.502868	20.03640496	Leptolyngbya sp. FACHB-261	2692806	Bacteria	Bacteria	225	2.01e-72	NR	WP_190801501.1	2692806	g5502	i0	67.8	1.57342657342657	149	48	78.1	0	28	474	1	149	WP_190801501.1 nucleoside-diphosphate kinase [Leptolyngbya sp. FACHB-261]	diamond	900	225	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-261
18221870	18221870	PRJNA270367_P_NODE_44715_length_164_cov_0.904348_g44510_i0	PRJNA270367	44715	164	0.904348	1.48313072	Dolichospermum sp. DL01	2717871	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2004368895\|gb\|CP050884.1\|	2717871	g44510	i0	100	0.170731707317073	28	0	17	0	77	104	641367	641394	MAG: Dolichospermum sp. DL01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. DL01
18909887	18909887	PRJNA270367_P_NODE_7495_length_493_cov_5.941441_g7297_i0	PRJNA270367	7495	493	5.941441	29.29130413	Cyanophyceae	3028117	Bacteria	Bacteria	224	1.4799999999999998e-72	NR	WP_166278818.1	207921	g7297	i0	71.6	14.421906693712	148	42	90.1	0	472	29	2	149	WP_166278818.1 nucleoside-diphosphate kinase [Lyngbya confervoides]	diamond	7110	226	0.991150442477876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya confervoides
22046578	22046578	PRJNA270367_P_NODE_30178_length_203_cov_1.012987_g29973_i0	PRJNA270367	30178	203	1.012987	2.05636361	Synechococcus sp. A15-28	1050638	Bacteria	Bacteria	60.2	1.06e-4	NTclustered	gi\|1895742380\|gb\|CP047931.1\|	1050638	g29973	i0	97.143	0.172413793103448	35	1	17	0	110	144	1646324	1646358	Synechococcus sp. A15-28 chromosome, complete genome	blastn	35	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-28
26757401	26757401	PRJNA270367_P_NODE_45381_length_163_cov_0.912281_g45176_i0	PRJNA270367	45381	163	0.912281	1.48701803	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	98.6	2.62e-22	NR	MBX9685218.1	2364082	g45176	i0	75.9	1.96932515337423	54	13	99.4	0	162	1	313	366	MBX9685218.1 M4 family metallopeptidase [Candidatus Obscuribacterales bacterium]	diamond	321	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27010644	27010644	PRJNA270367_P_NODE_382_length_2846_cov_26.101895_g293_i0	PRJNA270367	382	2846	26.101895	742.8599317	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	145	9.049999999999999e-35	NR	HEY9814218.1	2364082	g293	i0	34.3	0.31939564300773	303	141	31.3	10	1682	792	8	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	909	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27154561	27154561	PRJNA270367_P_NODE_16122_length_314_cov_1.569811_g15917_i0	PRJNA270367	16122	314	1.569811	4.92920654	Bacteria	2	Bacteria	Bacteria	48.1	0.00115	NR	BAU12161.1	1752064	g15917	i0	31.5	2.78025477707006	89	50	74.5	1	237	4	908	996	BAU12161.1 hypothetical protein LEP3755_26900 [Leptolyngbya sp. NIES-3755]	diamond	873	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
27295307	27295307	PRJNA270367_P_NODE_28283_length_212_cov_1.116564_g28078_i0	PRJNA270367	28283	212	1.116564	2.36711568	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	68.9	7.94e-13	NR	MFN4150795.1	2762020	g28078	i0	45.9	3.02830188679245	61	33	86.3	0	191	9	22	82	MFN4150795.1 S9 family peptidase [Candidatus Sericytochromatia bacterium]	diamond	642	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27484861	27484861	PRJNA270367_P_NODE_32783_length_192_cov_1.104895_g32578_i0	PRJNA270367	32783	192	1.104895	2.1213984	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	5.05e-30	NR	MBX9690498.1	2364082	g32578	i0	88.9	1.96875	63	7	98.4	0	190	2	54	116	MBX9690498.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	378	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27706236	27706236	PRJNA270367_P_NODE_14224_length_342_cov_0.887372_g14019_i0	PRJNA270367	14224	342	0.887372	3.03481224	Nostoc sp. 1	1052551	Bacteria	Bacteria	48.5	0.00102	NR	WP_086757060.1	1932667	g14019	i0	43.3	1.29824561403509	60	33	52.6	1	200	21	251	309	WP_086757060.1 tetratricopeptide repeat protein, partial [Nostoc sp. 106C]	diamond	444	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 106C
27737764	27737764	PRJNA270367_P_NODE_46664_length_162_cov_0.920354_g46459_i0	PRJNA270367	46664	162	0.920354	1.49097348	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	82.4	2.97e-17	NR	MBX9723908.1	2364082	g46459	i0	69.8	0.981481481481482	53	16	98.1	0	2	160	50	102	MBX9723908.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	159	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27912815	27912815	PRJNA270367_P_NODE_28825_length_209_cov_1.206250_g28620_i0	PRJNA270367	28825	209	1.20625	2.5210625	Bacteria	2	Bacteria	Bacteria	142	2.09e-37	NR	TRU80153.1	2486268	g28620	i0	98.6	2.97129186602871	69	1	99	0	2	208	494	562	TRU80153.1 MAG: TonB-dependent receptor [Microcystis viridis Mv_BB_P_19951000_S69D]	diamond	621	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
28039409	28039409	PRJNA270367_P_NODE_45465_length_163_cov_0.912281_g45260_i0	PRJNA270367	45465	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	80.9	3.54e-16	NR	MBU6451446.1	2800110	g45260	i0	66	1.93251533742331	53	18	97.5	0	3	161	105	157	MBU6451446.1 cytochrome-c peroxidase [Cyanobacteria bacterium REEB67]	diamond	315	81.6	0.991421568627451	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
28116215	28116215	PRJNA270367_P_NODE_33785_length_188_cov_1.489209_g33580_i0	PRJNA270367	33785	188	1.489209	2.79971292	Gloeobacterales cyanobacterium ES-bin-313	2812629	Bacteria	Bacteria	68.6	1.39e-11	NR	MBC7882842.1	2812629	g33580	i0	58.1	1.97872340425532	62	25	98.9	1	2	187	134	194	MBC7882842.1 ammonium transporter [Gloeobacterales cyanobacterium ES-bin-313]	diamond	372	68.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales			Gloeobacterales cyanobacterium ES-bin-313
28242443	28242443	PRJNA270367_P_NODE_34946_length_184_cov_1.155556_g34741_i0	PRJNA270367	34946	184	1.155556	2.12622304	Geitlerinema sp. PCC 9228	111611	Bacteria	Bacteria	41.6	0.0416	NR	WP_071518833.1	111611	g34741	i0	43.6	0.635869565217391	39	22	63.6	0	51	167	54	92	WP_071518833.1 gamma-carotene 1'-hydroxylase CruF [Geitlerinema sp. PCC 9228]	diamond	117	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 9228
28242456	28242456	PRJNA270367_P_NODE_42766_length_166_cov_0.888889_g42561_i0	PRJNA270367	42766	166	0.888889	1.47555574	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.1	0.00938	NR	HEY9793392.1	2364082	g42561	i0	33.3	0.921686746987952	51	34	92.2	0	3	155	208	258	HEY9793392.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	153	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28274070	28274070	PRJNA270367_P_NODE_37226_length_176_cov_1.188976_g37021_i0	PRJNA270367	37226	176	1.188976	2.09259776	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	50.1	1.77e-5	NR	MBA4078250.1	2067979	g37021	i0	90.9	0.375	22	2	37.5	0	176	111	148	169	MBA4078250.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	66	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
28400493	28400493	PRJNA270367_P_NODE_28566_length_210_cov_2.055901_g28361_i0	PRJNA270367	28566	210	2.055901	4.3173921	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	62	7.6e-10	NR	MBX9724270.1	2364082	g28361	i0	100	0.4	28	0	40	0	2	85	143	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	84	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28400505	28400505	PRJNA270367_P_NODE_386_length_2808_cov_7.908300_g297_i0	PRJNA270367	386	2808	7.9083	222.065064	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	130	7.66e-30	NR	HEY9814218.1	2364082	g297	i0	31.5	0.31517094017094	295	144	30.9	9	1634	768	16	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	885	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28495369	28495369	PRJNA270367_P_NODE_7967_length_477_cov_2.700935_g7769_i0	PRJNA270367	7967	477	2.700935	12.88345995	Oscillatoriales cyanobacterium RM2_1_1	2720435	Bacteria	Bacteria	48.9	0.00295	NR	NJO46494.1	2720435	g7769	i0	34.4	0.566037735849057	90	46	50.9	4	369	127	376	461	NJO46494.1 tandem-95 repeat protein [Oscillatoriales cyanobacterium RM2_1_1]	diamond	270	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium RM2_1_1
28702500	28702500	PRJNA270367_P_NODE_33147_length_191_cov_0.845070_g32942_i0	PRJNA270367	33147	191	0.84507	1.6140837	Bacillati	1783272	Bacteria	Bacteria	47.8	3.19e-4	NR	RTL37655.1	2052166	g32942	i0	81.5	1.30366492146597	27	5	42.4	0	188	108	159	185	RTL37655.1 MAG: hypothetical protein EKK48_23510 [Candidatus Melainabacteria bacterium]	diamond	249	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29032210	29032210	PRJNA270367_P_NODE_5968_length_558_cov_41.371316_g5775_i0	PRJNA270367	5968	558	41.371316	230.85194328	Nostoc sp. UIC 1	1180	Bacteria	Bacteria	97.4	5.85e-22	NR	WP_163931015.1	2100146	g5775	i0	32.3	1.72043010752688	158	104	84.4	2	541	71	5	160	WP_163931015.1 TerB family tellurite resistance protein [Nostoc sp. UIC 10630]	diamond	960	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UIC 10630
29189990	29189990	PRJNA270367_P_NODE_41989_length_167_cov_0.881356_g41784_i0	PRJNA270367	41989	167	0.881356	1.47186452	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	55.5	4.29e-7	NR	MBX9567892.1	2364082	g41784	i0	70.6	1.31137724550898	34	10	61.1	0	2	103	467	500	MBX9567892.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Candidatus Obscuribacterales bacterium]	diamond	219	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29221606	29221606	PRJNA270367_P_NODE_28629_length_210_cov_1.291925_g28424_i0	PRJNA270367	28629	210	1.291925	2.7130425	Tildeniella nuda	2303521	Bacteria	Bacteria	65.1	7.92e-11	NR	MBW4582717.1	2136405	g28424	i0	61.8	1.75714285714286	55	20	78.6	1	167	3	112	165	MBW4582717.1 glutathione S-transferase family protein [Tildeniella nuda ZEHNDER 1965/U140]	diamond	369	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Tildeniella	Tildeniella nuda
29252723	29252723	PRJNA270367_P_NODE_30629_length_201_cov_1.039474_g30424_i0	PRJNA270367	30629	201	1.039474	2.08934274	Phormidium willei BDU 13	399100	Bacteria	Bacteria	43.1	0.016	NR	OAB60180.1	399101	g30424	i0	40.3	1.80597014925373	62	35	89.6	2	193	14	3609	3670	OAB60180.1 hypothetical protein AY600_11355 [Phormidium willei BDU 130791]	diamond	363	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium willei
29379296	29379296	PRJNA270367_P_NODE_37269_length_176_cov_0.834646_g37064_i0	PRJNA270367	37269	176	0.834646	1.46897696	Cyanobacteria bacterium P01_H01_bin.58	3023321	Bacteria	Bacteria	70.5	2.49e-12	NR	MEM0979335.1	3023321	g37064	i0	54.5	5.60795454545455	55	25	93.8	0	12	176	250	304	MEM0979335.1 colicin uptake protein [Cyanobacteria bacterium P01_H01_bin.58]	diamond	987	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.58
30042424	30042424	PRJNA270367_P_NODE_43871_length_165_cov_0.896552_g43666_i0	PRJNA270367	43871	165	0.896552	1.4793108	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	55.5	3.51e-7	NR	MBX9720745.1	2364082	g43666	i0	60.5	1.36363636363636	38	15	69.1	0	160	47	239	276	MBX9720745.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	225	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30042425	30042425	PRJNA270367_P_NODE_44131_length_164_cov_1.373913_g43926_i0	PRJNA270367	44131	164	1.373913	2.25321732	Cyanobacterium stanieri PCC 72	102235	Bacteria	Bacteria	42	0.0241	NR	AFZ48470.1	292563	g43926	i0	42.1	0.695121951219512	38	22	69.5	0	12	125	252	289	AFZ48470.1 serine/threonine protein kinase [Cyanobacterium stanieri PCC 7202]	diamond	114	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium stanieri
30200216	30200216	PRJNA270367_P_NODE_39492_length_169_cov_0.866667_g39287_i0	PRJNA270367	39492	169	0.866667	1.46466723	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	49.3	6.69e-5	NR	HEY9759356.1	3088181	g39287	i0	56.8	1.45562130177515	44	19	78.1	0	168	37	55	98	HEY9759356.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	246	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30263938	30263938	PRJNA270367_P_NODE_44892_length_164_cov_0.895652_g44687_i0	PRJNA270367	44892	164	0.895652	1.46886928	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	70.9	1.53e-12	NR	MBX9688879.1	2364082	g44687	i0	64.8	0.98780487804878	54	19	98.8	0	162	1	1070	1123	MBX9688879.1 UvrD-helicase domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	162	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30358901	30358901	PRJNA270367_P_NODE_30392_length_202_cov_1.156863_g30187_i0	PRJNA270367	30392	202	1.156863	2.33686326	Nostoc sp. EkiNYC01	3075407	Bacteria	Bacteria	60.8	5.26e-9	NR	MFN6536685.1	3075407	g30187	i0	48.5	1.9009900990099	66	34	98	0	4	201	123	188	MFN6536685.1 hypothetical protein [Nostoc sp. EkiNYC01]	diamond	384	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. EkiNYC01
30674252	30674252	PRJNA270367_P_NODE_37833_length_174_cov_1.008000_g37628_i0	PRJNA270367	37833	174	1.008	1.75392	Limnospira platensis	118562	Bacteria	Bacteria	91.3	5.14e-22	NR	MDV7395947.1	3080829	g37628	i0	81.3	0.827586206896552	48	9	82.8	0	173	30	59	106	MDV7395947.1 citrate/2-methylcitrate synthase [Arthrospira platensis SPKY1]	diamond	144	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
30674254	30674254	PRJNA270367_P_NODE_39973_length_169_cov_0.866667_g39768_i0	PRJNA270367	39973	169	0.866667	1.46466723	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	88.2	2.9e-20	NR	MBX9687330.1	2364082	g39768	i0	80.9	0.834319526627219	47	9	83.4	0	141	1	4	50	MBX9687330.1 methyltransferase domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	141	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31053787	31053787	PRJNA270367_P_NODE_39635_length_169_cov_0.866667_g39430_i0	PRJNA270367	39635	169	0.866667	1.46466723	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	106	4.13e-25	NR	MBX9687846.1	2364082	g39430	i0	94.6	1.98816568047337	56	3	99.4	0	168	1	329	384	MBX9687846.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Candidatus Obscuribacterales bacterium]	diamond	336	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31085131	31085131	PRJNA270367_P_NODE_41855_length_167_cov_0.881356_g41650_i0	PRJNA270367	41855	167	0.881356	1.47186452	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	94.4	5.66e-21	NR	MBX9570569.1	2364082	g41650	i0	80	1.97604790419162	55	11	98.8	0	167	3	99	153	MBX9570569.1 imidazolonepropionase [Candidatus Obscuribacterales bacterium]	diamond	330	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31085136	31085136	PRJNA270367_P_NODE_46275_length_162_cov_0.920354_g46070_i0	PRJNA270367	46275	162	0.920354	1.49097348	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	66.2	5.84e-11	NR	HEY9868502.1	2364082	g46070	i0	67.3	0.907407407407407	49	16	90.7	0	3	149	297	345	HEY9868502.1 FAD-dependent oxidoreductase [Candidatus Obscuribacterales bacterium]	diamond	147	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31432849	31432849	PRJNA270367_P_NODE_936_length_1491_cov_8.146325_g297_i3	PRJNA270367	936	1491	8.146325	121.46170575	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	120	4.0700000000000005e-27	NR	HEY9814218.1	2364082	g297	i3	34.3	0.428571428571429	213	110	42.3	5	95	724	73	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	639	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31464747	31464747	PRJNA270367_P_NODE_39936_length_169_cov_0.866667_g39731_i0	PRJNA270367	39936	169	0.866667	1.46466723	Anthocerotibacter panamensis	2857077	Bacteria	Bacteria	47.4	3.28e-4	NR	WP_218080279.1	2857077	g39731	i0	51.1	0.798816568047337	45	22	79.9	0	136	2	413	457	WP_218080279.1 non-ribosomal peptide synthetase [Anthocerotibacter panamensis]	diamond	135	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Anthocerotibacteraceae	Anthocerotibacter	Anthocerotibacter panamensis
31527899	31527899	PRJNA270367_P_NODE_516_length_2136_cov_8.322952_g297_i1	PRJNA270367	516	2136	8.322952	177.77825472	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	130	4.8e-30	NR	HEY9814218.1	2364082	g297	i1	31.5	0.414325842696629	295	144	40.6	9	503	1369	16	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	885	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31654114	31654114	PRJNA270367_P_NODE_44817_length_164_cov_0.904348_g44612_i0	PRJNA270367	44817	164	0.904348	1.48313072	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	98.2	2.54e-22	NR	MBX9724197.1	2364082	g44612	i0	88.5	1.90243902439024	52	6	95.1	0	162	7	120	171	MBX9724197.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	312	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31735137	31735137	PRJNA270367_P_NODE_46297_length_162_cov_0.920354_g46092_i0	PRJNA270367	46297	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	63.9	2.77e-10	NR	MBU6455161.1	2800110	g46092	i0	87.5	2.35185185185185	32	4	59.3	0	67	162	1	32	MBU6455161.1 acetoacetate decarboxylase [Cyanobacteria bacterium REEB67]	diamond	381	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB67
31749045	31749045	PRJNA270367_P_NODE_10817_length_403_cov_1.531073_g10615_i0	PRJNA270367	10817	403	1.531073	6.17022419	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	179	6.96e-51	NR	MEZ0371079.1	2762020	g10615	i0	63.4	1.99503722084367	134	49	99.8	0	2	403	311	444	MEZ0371079.1 argininosuccinate lyase [Candidatus Sericytochromatia bacterium]	diamond	804	179	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31780660	31780660	PRJNA270367_P_NODE_20277_length_267_cov_1.000000_g20072_i0	PRJNA270367	20277	267	1	2.67	Nostoc sp.	1180	Bacteria	Bacteria	60.8	1.34e-8	NR	WP_335201451.1	1180	g20072	i0	66.7	0.471910112359551	42	14	47.2	0	6	131	1	42	WP_335201451.1 WD40 repeat domain-containing protein, partial [Nostoc sp.]	diamond	126	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31812443	31812443	PRJNA270367_P_NODE_33857_length_188_cov_1.122302_g33652_i0	PRJNA270367	33857	188	1.122302	2.10992776	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	57.8	4.82e-8	NR	MBX9686819.1	2364082	g33652	i0	44.3	0.973404255319149	61	34	97.3	0	187	5	81	141	MBX9686819.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	183	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32223842	32223842	PRJNA270367_P_NODE_24978_length_230_cov_1.364641_g24773_i0	PRJNA270367	24978	230	1.364641	3.1386743	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	67.4	2.99e-11	NR	HEY9814218.1	2364082	g24773	i0	43.7	0.926086956521739	71	39	92.6	1	15	227	74	143	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	213	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32350542	32350542	PRJNA270367_P_NODE_699_length_1793_cov_2.137041_g585_i0	PRJNA270367	699	1793	2.137041	38.31714513	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	132	5.26e-31	NR	HEY9814218.1	2364082	g585	i0	35.2	0.441717791411043	264	153	43	10	1552	782	6	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	792	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32477068	32477068	PRJNA270367_P_NODE_779_length_1670_cov_5.445404_g297_i2	PRJNA270367	779	1670	5.445404	90.9382468	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	129	6.49e-30	NR	HEY9814218.1	2364082	g297	i2	34.2	0.477844311377246	266	122	46.7	9	1601	822	40	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	798	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32540417	32540417	PRJNA270367_P_NODE_5119_length_604_cov_1.893694_g4928_i0	PRJNA270367	5119	604	1.893694	11.43791176	Calothrix sp. MO_167.B42	3036782	Bacteria	Bacteria	50.1	7.92e-4	NR	MDJ0677868.1	3036782	g4928	i0	28.3	0.526490066225166	106	61	49.2	3	602	306	7	104	MDJ0677868.1 glycosyltransferase [Calothrix sp. MO_167.B42]	diamond	318	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_167.B42
32666156	32666156	PRJNA270367_P_NODE_21000_length_260_cov_1.407583_g20795_i0	PRJNA270367	21000	260	1.407583	3.6597158	Microcystis sp. LE19-84.1B	3016438	Bacteria	Bacteria	65.1	4.87e-10	NR	WP_288141249.1	3016438	g20795	i0	44.6	3.45	74	41	85.4	0	6	227	247	320	WP_288141249.1 hypothetical protein [Microcystis sp. LE19-84.1B]	diamond	897	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. LE19-84.1B
32666166	32666166	PRJNA270367_P_NODE_30920_length_200_cov_0.927152_g30715_i0	PRJNA270367	30920	200	0.927152	1.854304	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	103	1.3600000000000002e-26	NR	MBX9722843.1	2364082	g30715	i0	72.3	0.975	65	18	97.5	0	200	6	35	99	MBX9722843.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	195	103	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);;