metadata: contig_metadata: 52 rows where bioproject = "PRJNA1158727" and tax_clade = "Cyanobacteriota/Melainabacteria group"

52 rows where bioproject = "PRJNA1158727" 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
1037671	1037671	PRJNA1158727_P_NODE_51701_length_485_cov_2.444175_g44244_i0	PRJNA1158727	51701	485	2.444175	11.85424875	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	297	5.999999999999999e-101	NR	MBX9724270.1	2364082	g44244	i0	89.4	0.989690721649485	160	17	99	0	1	480	7	166	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	480	297	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
1578891	1578891	PRJNA1158727_P_NODE_156082_length_243_cov_1.735294_g148620_i0	PRJNA1158727	156082	243	1.735294	4.21676442	Prochlorococcus marinus	1219	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|95115443\|gb\|DQ473696.1\|	167555	g148620	i0	100	29.3497942386831	243	0	100	0	1	243	349	591	Prochlorococcus marinus str. NATL1A photosystem D2 protein (psbD) gene, partial cds	blastn	7132	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
1579012	1579012	PRJNA1158727_P_NODE_162662_length_241_cov_0.916667_g155200_i0	PRJNA1158727	162662	241	0.916667	2.20916747	Nostoc commune	1178	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g155200	i0	90	154.572614107884	240	22	99	2	1	239	1738015	1737777	Nostoc cf. commune SO-36 DNA, complete genome	blastn	37252	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
2312748	2312748	PRJNA1158727_P_NODE_125922_length_260_cov_3.251337_g118461_i0	PRJNA1158727	125922	260	3.251337	8.4534762	Macrochaete	1844958	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g118461	i0	99.231	99.6576923076923	260	2	100	0	1	260	555	814	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	25911	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2855033	2855033	PRJNA1158727_P_NODE_148223_length_246_cov_1.335260_g140761_i0	PRJNA1158727	148223	246	1.33526	3.2847396	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g140761	i0	98.374	157.256097560976	246	4	100	0	1	246	1244204	1243959	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	38685	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
3587949	3587949	PRJNA1158727_P_NODE_131923_length_254_cov_1.453039_g124462_i0	PRJNA1158727	131923	254	1.453039	3.69071906	Microcoleus	44471	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g124462	i0	100	190.476377952756	254	0	100	0	1	254	100959	100706	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	48381	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4130576	4130576	PRJNA1158727_P_NODE_126424_length_260_cov_1.486631_g118963_i0	PRJNA1158727	126424	260	1.486631	3.8652406	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	422	1.57e-113	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g118963	i0	97.189	151	249	7	96	0	1	249	2055878	2055630	Leptolyngbya sp. 7M chromosome	blastn	39260	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4130912	4130912	PRJNA1158727_P_NODE_143644_length_248_cov_0.880000_g136182_i0	PRJNA1158727	143644	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g136182	i0	90.323	166.907258064516	248	24	100	0	1	248	3680371	3680618	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	41393	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6681858	6681858	PRJNA1158727_P_NODE_141766_length_249_cov_0.875000_g134304_i0	PRJNA1158727	141766	249	0.875	2.17875	Pseudanabaena sp. ABRG5-3	685565	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1320987122\|dbj\|AP017561.1\|	685565	g134304	i0	94.595	0.602409638554217	37	1	15	1	134	170	189576	189611	Pseudanabaena sp. ABRG5-3 plasmid ABRG53a DNA, complete sequence	blastn	150	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. ABRG5-3
7415352	7415352	PRJNA1158727_P_NODE_131586_length_254_cov_1.701657_g124125_i0	PRJNA1158727	131586	254	1.701657	4.32220878	Oscillatoriales	1150	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g124125	i0	100	116.669291338583	254	0	100	0	1	254	2435	2182	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29634	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9231134	9231134	PRJNA1158727_P_NODE_103288_length_288_cov_1.251163_g95827_i0	PRJNA1158727	103288	288	1.251163	3.60334944	Microseira	1609595	Bacteria	Bacteria	191	6.089999999999998e-54	NR	WP_226592904.1	467598	g95827	i0	99	2	96	1	100	0	288	1	745	840	WP_226592904.1 peptidase domain-containing ABC transporter [Microseira wollei]	diamond	576	192	0.994791666666667	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
9232474	9232474	PRJNA1158727_P_NODE_167548_length_226_cov_2.013072_g160086_i0	PRJNA1158727	167548	226	2.013072	4.54954272	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	207	4.06e-49	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g160086	i0	83.186	4.90265486725664	226	38	100	0	1	226	5028571	5028346	Calothrix sp. PCC 6303, complete genome	blastn	1108	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
10510651	10510651	PRJNA1158727_P_NODE_97209_length_298_cov_1.711111_g89748_i0	PRJNA1158727	97209	298	1.711111	5.09911078	Stanieria cyanosphaera	102116	Bacteria	Bacteria	278	4.2e-70	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g89748	i0	84.138	21.1510067114094	290	43	96	2	12	298	584	295	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	6303	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
11241033	11241033	PRJNA1158727_P_NODE_79289_length_341_cov_4.197761_g71828_i0	PRJNA1158727	79289	341	4.197761	14.31436501	root	1	Root_unresolved	Root_unresolved	623	5.4499999999999985e-174	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g71828	i0	99.707	99.0821114369501	341	0	100	1	1	341	429	90	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	33787	623	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13057271	13057271	PRJNA1158727_P_NODE_124551_length_262_cov_1.608466_g117090_i0	PRJNA1158727	124551	262	1.608466	4.21418092	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	422	1.58e-113	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g117090	i0	95.802	113.24427480916	262	10	100	1	1	262	3350	3090	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29670	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
15606233	15606233	PRJNA1158727_P_NODE_116793_length_271_cov_1.474747_g109332_i0	PRJNA1158727	116793	271	1.474747	3.99656437	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	79	3.27e-16	NR	NJO63435.1	2720436	g109332	i0	51.1	0.996309963099631	90	38	99.6	3	271	2	14	97	NJO63435.1 NUDIX domain-containing protein [Richelia sp. RM2_1_2]	diamond	270	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
16882519	16882519	PRJNA1158727_P_NODE_44154_length_562_cov_2.533742_g36725_i0	PRJNA1158727	44154	562	2.533742	14.23963004	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	861	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g36725	i0	95.082	109.046263345196	549	24	98	3	15	562	2772	2226	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61284	861	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19429647	19429647	PRJNA1158727_P_NODE_123156_length_264_cov_1.089005_g115695_i0	PRJNA1158727	123156	264	1.089005	2.8749732	Egbenema sp. FJBBOT/2019	3398834	Bacteria	Bacteria	340	4.5999999999999996e-89	NTclustered	gi\|2917372002\|gb\|CP182236.1\|	3398834	g115695	i0	90.076	150.863636363636	262	26	99	0	3	264	261242	261503	Egbenema sp. FJBBOT/2019 chromosome, complete genome	blastn	39828	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Egbenema	Egbenema sp. FJBBOT/2019
19429805	19429805	PRJNA1158727_P_NODE_131056_length_255_cov_1.285714_g123595_i0	PRJNA1158727	131056	255	1.285714	3.2785707	Microcoleus vaginatus	119532	Bacteria	Bacteria	198	2.81e-46	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g123595	i0	82.883	48.6941176470588	222	36	99	2	1	220	1374470	1374691	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	12417	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
21981033	21981033	PRJNA1158727_P_NODE_153958_length_244_cov_0.900585_g146496_i0	PRJNA1158727	153958	244	0.900585	2.1974274	Bacillati	1783272	Bacteria	Bacteria	120	1.87e-32	NR	MBX2861300.1	2717857	g146496	i0	68.4	11.7540983606557	79	25	97.1	0	6	242	20	98	MBX2861300.1 nucleoside-diphosphate kinase [Vampirovibrio sp.]	diamond	2868	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrio	Vampirovibrio sp.
23255678	23255678	PRJNA1158727_P_NODE_116839_length_271_cov_1.393939_g109378_i0	PRJNA1158727	116839	271	1.393939	3.77757469	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	86.7	1.79e-17	NR	MDZ4837454.1	2052166	g109378	i0	69	0.929889298892989	84	20	87.5	3	237	1	1	83	MDZ4837454.1 S8/S53 family peptidase [Candidatus Melainabacteria bacterium]	diamond	252	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
23255979	23255979	PRJNA1158727_P_NODE_130759_length_255_cov_1.692308_g123298_i0	PRJNA1158727	130759	255	1.692308	4.3153854	Nostoc sphaeroides	446679	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g123298	i0	89.764	11.7294117647059	254	26	99	0	1	254	1101198	1101451	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	2991	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
24530016	24530016	PRJNA1158727_P_NODE_144320_length_248_cov_0.880000_g136858_i0	PRJNA1158727	144320	248	0.88	2.1824	Aliterella atlantica	1827278	Bacteria	Bacteria	145	2.71e-40	NR	WP_045053065.1	1827278	g136858	i0	87.8	0.991935483870968	82	10	99.2	0	1	246	79	160	WP_045053065.1 anthranilate phosphoribosyltransferase family protein [Aliterella atlantica]	diamond	246	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
24531656	24531656	PRJNA1158727_P_NODE_50480_length_496_cov_1.657210_g43025_i0	PRJNA1158727	50480	496	1.65721	8.2197616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	496	1.86e-135	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g43025	i0	85.507	80.5181451612903	483	61	96	9	19	496	3681097	3681575	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39937	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26806519	26806519	PRJNA1158727_P_NODE_135361_length_251_cov_0.865169_g127899_i0	PRJNA1158727	135361	251	0.865169	2.17157419	Bacillati	1783272	Bacteria	Bacteria	43.5	0.00985	NR	NDE38816.1	2461364	g127899	i0	54.8	1.55378486055777	42	19	50.2	0	127	2	18	59	NDE38816.1 hypothetical protein [Synechococcaceae bacterium WBA_2_066]	diamond	390	43.9	0.990888382687927	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae bacterium WBA_2_066
26850638	26850638	PRJNA1158727_P_NODE_115881_length_272_cov_1.547739_g108420_i0	PRJNA1158727	115881	272	1.547739	4.20985008	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	175	5.089999999999999e-52	NR	HEY9782601.1	3088178	g108420	i0	96.7	1.98529411764706	90	2	99.3	1	3	272	191	279	HEY9782601.1 PstS family phosphate ABC transporter substrate-binding protein [Leptolyngbyaceae cyanobacterium]	diamond	540	175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
27040373	27040373	PRJNA1158727_P_NODE_146202_length_247_cov_0.885057_g138740_i0	PRJNA1158727	146202	247	0.885057	2.18609079	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	147	1.02e-40	NR	MBX3152067.1	2364082	g138740	i0	97.6	0.995951417004049	82	2	99.6	0	2	247	99	180	MBX3152067.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	246	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27134754	27134754	PRJNA1158727_P_NODE_104722_length_286_cov_1.446009_g97261_i0	PRJNA1158727	104722	286	1.446009	4.13558574	Cyanobacteria bacterium PR.023	2067979	Bacteria	Bacteria	172	6.349999999999999e-52	NR	MBA4075678.1	2067979	g97261	i0	90.5	0.996503496503496	95	9	99.7	0	286	2	48	142	MBA4075678.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	285	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
27324854	27324854	PRJNA1158727_P_NODE_124703_length_262_cov_1.365079_g117242_i0	PRJNA1158727	124703	262	1.365079	3.57650698	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	176	2.34e-50	NR	MBX9672434.1	2364082	g117242	i0	100	0.99618320610687	87	0	99.6	0	261	1	467	553	MBX9672434.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	261	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27786441	27786441	PRJNA1158727_P_NODE_139264_length_250_cov_0.870056_g131802_i0	PRJNA1158727	139264	250	0.870056	2.17514	Coleofasciculaceae	1892251	Bacteria	Bacteria	50.4	6.55e-5	NR	WP_044210526.1	64178	g131802	i0	63.6	1.068	33	12	39.6	0	150	248	4	36	WP_044210526.1 ABC transporter permease [Coleofasciculus chthonoplastes]	diamond	267	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
27818017	27818017	PRJNA1158727_P_NODE_135844_length_251_cov_0.865169_g128382_i0	PRJNA1158727	135844	251	0.865169	2.17157419	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	63.2	2.66e-9	NR	WP_099700634.1	2049454	g128382	i0	60.4	3.1195219123506	53	21	63.3	0	3	161	70	122	WP_099700634.1 FG-GAP repeat protein [Gloeocapsopsis sp. IPPAS B-1203]	diamond	783	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis sp. IPPAS B-1203
28461747	28461747	PRJNA1158727_P_NODE_123386_length_263_cov_2.073684_g115925_i0	PRJNA1158727	123386	263	2.073684	5.45378892	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	96.7	4.3700000000000005e-21	NR	MBN8662705.1	1906157	g115925	i0	56	0.958174904942966	84	37	95.8	0	261	10	297	380	MBN8662705.1 tetratricopeptide repeat protein [Candidatus Obscuribacter phosphatis]	diamond	252	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
29554212	29554212	PRJNA1158727_P_NODE_160530_length_242_cov_0.911243_g153068_i0	PRJNA1158727	160530	242	0.911243	2.20520806	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	59.7	9.67e-10	NR	WP_054466059.1	132607	g153068	i0	50	3.24793388429752	60	29	74.4	1	236	57	7	65	WP_054466059.1 MULTISPECIES: hypothetical protein [Planktothricoides]	diamond	786	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides
29850899	29850899	PRJNA1158727_P_NODE_111391_length_278_cov_1.121951_g103930_i0	PRJNA1158727	111391	278	1.121951	3.11902378	Synechocystis sp. B12	2764086	Bacteria	Bacteria	42.7	0.0475	NR	WLT40268.1	2764086	g103930	i0	29.6	0.58273381294964	54	38	58.3	0	95	256	131	184	WLT40268.1 hypothetical protein NON20_23675 [Synechocystis sp. B12]	diamond	162	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. B12
29977105	29977105	PRJNA1158727_P_NODE_108571_length_281_cov_1.480769_g101110_i0	PRJNA1158727	108571	281	1.480769	4.16096089	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	154	5.42e-46	NR	HCF25636.1	2055787	g101110	i0	87.1	0.99288256227758	93	12	99.3	0	3	281	35	127	HCF25636.1 biopolymer transporter ExbD [Cyanobacteria bacterium UBA11049]	diamond	279	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
29996686	29996686	PRJNA1158727_P_NODE_165391_length_235_cov_2.697531_g157929_i0	PRJNA1158727	165391	235	2.697531	6.33919785	Bacteria	2	Bacteria	Bacteria	146	2.31e-41	NR	MDZ4838004.1	2052166	g157929	i0	90.9	1.96595744680851	77	7	98.3	0	235	5	27	103	MDZ4838004.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	462	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30356814	30356814	PRJNA1158727_P_NODE_134592_length_251_cov_1.595506_g127130_i0	PRJNA1158727	134592	251	1.595506	4.00472006	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	54.7	8.26e-7	NR	MBX9570187.1	2364082	g127130	i0	64.9	1.30278884462151	37	13	44.2	0	251	141	135	171	MBX9570187.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	327	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30388326	30388326	PRJNA1158727_P_NODE_164933_length_237_cov_2.817073_g157471_i0	PRJNA1158727	164933	237	2.817073	6.67646301	Pseudanabaena biceps	927669	Bacteria	Bacteria	46.2	0.00208	NR	NUN66916.1	927669	g157471	i0	48.8	0.518987341772152	41	21	51.9	0	237	115	92	132	NUN66916.1 relaxase/mobilization nuclease domain-containing protein [Pseudanabaena biceps]	diamond	123	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena biceps
30925248	30925248	PRJNA1158727_P_NODE_149934_length_246_cov_0.890173_g142472_i0	PRJNA1158727	149934	246	0.890173	2.18982558	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	145	4.66e-41	NR	MBN9393606.1	2052166	g142472	i0	92.6	0.98780487804878	81	6	98.8	0	3	245	38	118	MBN9393606.1 nickel pincer cofactor biosynthesis protein LarB [Candidatus Melainabacteria bacterium]	diamond	243	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31114372	31114372	PRJNA1158727_P_NODE_124515_length_262_cov_1.629630_g117054_i0	PRJNA1158727	124515	262	1.62963	4.2696306	Cyanobacteria bacterium PR.3.49	2067978	Bacteria	Bacteria	137	4.44e-40	NR	MBA3858196.1	2067978	g117054	i0	87.7	0.83587786259542	73	9	83.6	0	220	2	1	73	MBA3858196.1 hypothetical protein [Cyanobacteria bacterium PR.3.49]	diamond	219	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.3.49
31177497	31177497	PRJNA1158727_P_NODE_136075_length_251_cov_0.865169_g128613_i0	PRJNA1158727	136075	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	146	4.51e-39	NR	MBY0547976.1	2364082	g128613	i0	86.7	0.99203187250996006	83	11	99.2	0	251	3	10	92	MBY0547976.1 AMP-binding protein [Candidatus Obscuribacterales bacterium]	diamond	249	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31177515	31177515	PRJNA1158727_P_NODE_159155_length_242_cov_1.455621_g151693_i0	PRJNA1158727	159155	242	1.455621	3.52260282	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	112	1.02e-27	NR	MDP3508660.1	2052166	g151693	i0	61.3	1.98347107438017	80	31	99.2	0	3	242	254	333	MDP3508660.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	480	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31335778	31335778	PRJNA1158727_P_NODE_154056_length_244_cov_0.900585_g146594_i0	PRJNA1158727	154056	244	0.900585	2.1974274	Drouetiella sp.	3088174	Bacteria	Bacteria	118	1.11e-28	NR	HEY9730308.1	3088174	g146594	i0	74.1	0.995901639344262	81	21	99.6	0	244	2	138	218	HEY9730308.1 ATP-binding protein [Drouetiella sp.]	diamond	243	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
31450275	31450275	PRJNA1158727_P_NODE_164516_length_239_cov_3.126506_g157054_i0	PRJNA1158727	164516	239	3.126506	7.47234934	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	54.7	2.13e-6	NR	WP_193925692.1	945768	g157054	i0	70.6	2.86192468619247	34	10	42.7	0	133	234	5	38	WP_193925692.1 circadian clock protein KaiC [Plectonema radiosum]	diamond	684	55.1	0.992740471869329	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema radiosum
31620518	31620518	PRJNA1158727_P_NODE_119356_length_268_cov_1.482051_g111895_i0	PRJNA1158727	119356	268	1.482051	3.97189668	Cyanomargarita calcarea	1982362	Bacteria	Bacteria	42.4	0.0343	NR	MBW4670816.1	2839659	g111895	i0	34.4	0.682835820895522	61	38	68.3	1	209	27	17	75	MBW4670816.1 hypothetical protein [Cyanomargarita calcarea GSE-NOS-MK-12-04C]	diamond	183	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Cyanomargaritaceae	Cyanomargarita	Cyanomargarita calcarea
31841783	31841783	PRJNA1158727_P_NODE_139877_length_249_cov_1.545455_g132415_i0	PRJNA1158727	139877	249	1.545455	3.84818295	Sphaerospermopsis sp.	3100406	Bacteria	Bacteria	103	6.910000000000001e-27	NR	MEB3148512.1	3100406	g132415	i0	98	1.20481927710843	50	1	60.2	0	1	150	19	68	MEB3148512.1 hypothetical protein [Sphaerospermopsis sp.]	diamond	300	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis sp.
31873544	31873544	PRJNA1158727_P_NODE_106957_length_283_cov_1.466667_g99496_i0	PRJNA1158727	106957	283	1.466667	4.15066761	Leptolyngbya sp. FACHB-541	2692810	Bacteria	Bacteria	101	1.18e-22	NR	WP_190797464.1	2692810	g99496	i0	57.1	2.93639575971731	91	38	96.5	1	281	9	550	639	WP_190797464.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Leptolyngbya sp. FACHB-541]	diamond	831	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-541
31873561	31873561	PRJNA1158727_P_NODE_156817_length_243_cov_0.905882_g149355_i0	PRJNA1158727	156817	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	73.9	1.49e-14	NR	MBC8000228.1	2052166	g149355	i0	80.5	0.506172839506173	41	8	50.6	0	3	125	101	141	MBC8000228.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	123	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32367798	32367798	PRJNA1158727_P_NODE_154479_length_244_cov_0.900585_g147017_i0	PRJNA1158727	154479	244	0.900585	2.1974274	Crocosphaera	263510	Bacteria	Bacteria	44.3	0.00621	NR	WP_339390355.1	263511	g147017	i0	36.4	2.8155737704918	77	43	87.3	3	239	27	92	168	WP_339390355.1 hypothetical protein, partial [Crocosphaera watsonii]	diamond	687	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera watsonii
32683291	32683291	PRJNA1158727_P_NODE_146760_length_247_cov_0.885057_g139298_i0	PRJNA1158727	146760	247	0.885057	2.18609079	Cyanophyceae	3028117	Bacteria	Bacteria	157	1.81e-44	NR	WP_293229252.1	2798816	g139298	i0	95.1	2.98785425101215	82	4	99.6	0	247	2	8	89	WP_293229252.1 Fic family protein [Microcoleus sp. PH2017_05_CCC_O_A]	diamond	738	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PH2017_05_CCC_O_A
32695524	32695524	PRJNA1158727_P_NODE_157400_length_243_cov_0.905882_g149938_i0	PRJNA1158727	157400	243	0.905882	2.20129326	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	170	1.18e-49	NR	MBN9396708.1	2052166	g149938	i0	100	0.987654320987654	80	0	98.8	0	242	3	259	338	MBN9396708.1 beta-lactamase family protein [Candidatus Melainabacteria bacterium]	diamond	240	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32821548	32821548	PRJNA1158727_P_NODE_111780_length_277_cov_1.509804_g104319_i0	PRJNA1158727	111780	277	1.509804	4.18215708	Aliterella atlantica	1827278	Bacteria	Bacteria	92.8	1.3100000000000002e-21	NR	WP_045054872.1	1827278	g104319	i0	88.9	0.584837545126354	54	6	58.5	0	99	260	1	54	WP_045054872.1 salt stress protein, Slr1339 family [Aliterella atlantica]	diamond	162	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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);;