metadata: contig_metadata: 51 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax_clade = "Cyanobacteriota/Melainabacteria group"

51 rows where analysis = "diamond", bioproject = "PRJNA763243" 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
5847157	5847157	PRJNA763243_P_NODE_53545_length_249_cov_4.051136_g53199_i0	PRJNA763243	53545	249	4.051136	10.08732864	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	78.2	1.08e-14	NR	WP_250124232.1	155894	g53199	i0	90.2	2.01204819277108	41	4	49.4	0	125	247	1	41	WP_250124232.1 RNA-guided endonuclease InsQ/TnpB family protein [Chroococcidiopsis sp. CCMEE 29]	diamond	501	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
7122435	7122435	PRJNA763243_P_NODE_59526_length_244_cov_1.485380_g59180_i0	PRJNA763243	59526	244	1.48538	3.6243272	Cyanophyceae	3028117	Bacteria	Bacteria	167	7.79e-49	NR	WP_190766082.1	3028117	g59180	i0	97.5	0.983606557377049	80	2	98.4	0	4	243	85	164	WP_190766082.1 MULTISPECIES: type I glyceraldehyde-3-phosphate dehydrogenase [Cyanophyceae]	diamond	240	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
7583204	7583204	PRJNA763243_P_NODE_30126_length_309_cov_1.093220_g29780_i0	PRJNA763243	30126	309	1.09322	3.3780498	Cyanophyceae	3028117	Bacteria	Bacteria	172	5.78e-53	NR	WP_190767706.1	3028117	g29780	i0	85.1	2.03883495145631	101	15	98.1	0	305	3	6	106	WP_190767706.1 MULTISPECIES: photosystem II complex extrinsic protein PsbU [Cyanophyceae]	diamond	630	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
10947580	10947580	PRJNA763243_P_NODE_47549_length_259_cov_2.747312_g47203_i0	PRJNA763243	47549	259	2.747312	7.11553808	Cyanophyceae	3028117	Bacteria	Bacteria	140	3.86e-37	NR	WP_190766086.1	3028117	g47203	i0	84.5	1.94594594594595	84	13	97.3	0	255	4	276	359	WP_190766086.1 MULTISPECIES: UDP-N-acetylmuramate--L-alanine ligase [Cyanophyceae]	diamond	504	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
17322159	17322159	PRJNA763243_P_NODE_64274_length_240_cov_6.077844_g63928_i0	PRJNA763243	64274	240	6.077844	14.5868256	Calothrix sp. NIES-3974	2005462	Bacteria	Bacteria	135	3.95e-36	NR	WP_096626496.1	2005462	g63928	i0	92.5	10.8875	67	5	83.8	0	3	203	311	377	WP_096626496.1 cob(I)yrinic acid a,c-diamide adenosyltransferase [Calothrix sp. NIES-3974]	diamond	2613	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-3974
18594903	18594903	PRJNA763243_P_NODE_38955_length_279_cov_8.203883_g38609_i0	PRJNA763243	38955	279	8.203883	22.88883357	Chroococcidiopsidales cyanobacterium LEGE 13417	1828829	Bacteria	Bacteria	150	5.03e-44	NR	MBE9016107.1	1828829	g38609	i0	76.9	1.95698924731183	91	21	97.8	0	6	278	46	136	MBE9016107.1 Uma2 family endonuclease [Chroococcidiopsidales cyanobacterium LEGE 13417]	diamond	546	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales			Chroococcidiopsidales cyanobacterium LEGE 13417
18595272	18595272	PRJNA763243_P_NODE_5415_length_609_cov_4.289179_g5092_i0	PRJNA763243	5415	609	4.289179	26.12110011	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	317	5.47e-108	NR	MBX9724270.1	2364082	g5092	i0	91.1	0.827586206896552	168	15	82.8	0	22	525	3	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	504	317	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26704783	26704783	PRJNA763243_P_NODE_63781_length_241_cov_0.916667_g63435_i0	PRJNA763243	63781	241	0.916667	2.20916747	Cyanophyceae	3028117	Bacteria	Bacteria	85.5	1.4e-17	NR	WP_190769117.1	3028117	g63435	i0	83.3	0.672199170124481	54	8	67.2	1	80	241	1	53	WP_190769117.1 MULTISPECIES: WD40 repeat domain-containing protein [Cyanophyceae]	diamond	162	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
26895142	26895142	PRJNA763243_P_NODE_13181_length_420_cov_5.881844_g12836_i0	PRJNA763243	13181	420	5.881844	24.7037448	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	53.9	3.77e-6	NR	MEI3251335.1	3022870	g12836	i0	53.3	9.91428571428571	60	28	42.9	0	192	371	53	112	MEI3251335.1 30S ribosomal protein S13 [Candidatus Gastranaerophilaceae bacterium]	diamond	4164	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
26999374	26999374	PRJNA763243_P_NODE_71362_length_213_cov_74.964286_g71016_i0	PRJNA763243	71362	213	74.964286	159.67392918	root	1	Root_unresolved	Root_unresolved	46.2	0.00151	NR	WP_190550705.1	1186	g71016	i0	39	1.64788732394366	59	32	83.1	1	3	179	745	799	WP_190550705.1 MULTISPECIES: peptidoglycan DD-metalloendopeptidase family protein [Calothrix]	diamond	351	46.6	0.991416309012876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix
27084840	27084840	PRJNA763243_P_NODE_65282_length_237_cov_2.774390_g64936_i0	PRJNA763243	65282	237	2.77439	6.5753043	Cyanophyceae	3028117	Bacteria	Bacteria	144	8.21e-39	NR	WP_190768656.1	3028117	g64936	i0	87.2	0.987341772151899	78	10	98.7	0	234	1	357	434	WP_190768656.1 MULTISPECIES: hypothetical protein [Cyanophyceae]	diamond	234	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
27116146	27116146	PRJNA763243_P_NODE_12942_length_424_cov_1.344729_g12597_i0	PRJNA763243	12942	424	1.344729	5.70165096	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	101	2.68e-22	NR	MBX9692038.1	2847862	g12597	i0	50.5	0.77122641509434	109	49	73.6	2	424	113	93	201	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	327	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27274482	27274482	PRJNA763243_P_NODE_73383_length_204_cov_26.251908_g73037_i0	PRJNA763243	73383	204	26.251908	53.55389232	Cyanomargarita calcarea	1982362	Bacteria	Bacteria	89	5.44e-19	NR	MBW4669494.1	2839659	g73037	i0	62.9	0.911764705882353	62	23	91.2	0	3	188	87	148	MBW4669494.1 methyltransferase domain-containing protein [Cyanomargarita calcarea GSE-NOS-MK-12-04C]	diamond	186	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Cyanomargaritaceae	Cyanomargarita	Cyanomargarita calcarea
27505393	27505393	PRJNA763243_P_NODE_43803_length_267_cov_58.231959_g43457_i0	PRJNA763243	43803	267	58.231959	155.47933053	Cyanophyceae	3028117	Bacteria	Bacteria	109	1.17e-28	NR	WP_051482566.1	927677	g43457	i0	82.5	1.35955056179775	57	10	64	0	26	196	71	127	WP_051482566.1 hypothetical protein [Synechocystis sp. PCC 7509]	diamond	363	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
27558516	27558516	PRJNA763243_P_NODE_64764_length_238_cov_75.006061_g64418_i0	PRJNA763243	64764	238	75.006061	178.51442518	Aliterella atlantica	1827278	Bacteria	Bacteria	144	1.54e-42	NR	WP_045054946.1	1827278	g64418	i0	94.8	0.970588235294118	77	4	97.1	0	6	236	37	113	WP_045054946.1 ester cyclase [Aliterella atlantica]	diamond	231	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
27821119	27821119	PRJNA763243_P_NODE_37884_length_282_cov_2.875598_g37538_i0	PRJNA763243	37884	282	2.875598	8.10918636	Cyanophyceae	3028117	Bacteria	Bacteria	91.3	3.96e-19	NR	HIK18135.1	2747805	g37538	i0	92.2	1.08510638297872	51	4	54.3	0	129	281	307	357	HIK18135.1 IS66 family transposase [Leptolyngbyaceae cyanobacterium M33_DOE_097]	diamond	306	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M33_DOE_097
27842701	27842701	PRJNA763243_P_NODE_51504_length_251_cov_2.511236_g51158_i0	PRJNA763243	51504	251	2.511236	6.30320236	Cyanophyceae	3028117	Bacteria	Bacteria	95.1	3.8199999999999996e-23	NR	WP_190762547.1	3028117	g51158	i0	78.7	0.729083665338645	61	13	72.9	0	248	66	53	113	WP_190762547.1 MULTISPECIES: DUF4870 domain-containing protein [Cyanophyceae]	diamond	183	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
28095441	28095441	PRJNA763243_P_NODE_47025_length_260_cov_3.641711_g46679_i0	PRJNA763243	47025	260	3.641711	9.4684486	Cyanophyceae	3028117	Bacteria	Bacteria	159	9.58e-44	NR	WP_190767686.1	3028117	g46679	i0	93	0.992307692307692	86	6	99.2	0	260	3	69	154	WP_190767686.1 MULTISPECIES: AMP-dependent synthetase/ligase [Cyanophyceae]	diamond	258	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
28127139	28127139	PRJNA763243_P_NODE_43525_length_268_cov_3.138462_g43179_i0	PRJNA763243	43525	268	3.138462	8.41107816	Cyanobacteria bacterium UBA8553	2055771	Bacteria	Bacteria	170	8.799999999999999e-47	NR	HAA27056.1	2055771	g43179	i0	93.2	0.985074626865672	88	6	98.5	0	3	266	909	996	HAA27056.1 MFS transporter [Cyanobacteria bacterium UBA8553]	diamond	264	170	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA8553
28452588	28452588	PRJNA763243_P_NODE_41426_length_273_cov_2.485000_g41080_i0	PRJNA763243	41426	273	2.485	6.78405	Gloeocapsa	102231	Bacteria	Bacteria	103	1.35e-23	NR	NJR59569.1	2720403	g41080	i0	76.6	5.93406593406593	64	13	70.3	1	6	197	128	189	NJR59569.1 FAD-dependent oxidoreductase [Cyanobacteria bacterium CRU_2_1]	diamond	1620	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CRU_2_1
28505952	28505952	PRJNA763243_P_NODE_74647_length_199_cov_16.793651_g74301_i0	PRJNA763243	74647	199	16.793651	33.41936549	filamentous cyanobacterium CCP1	2107703	Bacteria	Bacteria	100	3.77e-24	NR	PSB55136.1	2107703	g74301	i0	79.7	0.889447236180904	59	12	88.9	0	182	6	50	108	PSB55136.1 hypothetical protein C7B61_21615, partial [filamentous cyanobacterium CCP1]	diamond	177	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP1
28884749	28884749	PRJNA763243_P_NODE_67188_length_231_cov_2.474684_g66842_i0	PRJNA763243	67188	231	2.474684	5.71652004	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	124	1.1699999999999999e-34	NR	MBX9722668.1	2364082	g66842	i0	78.9	0.987012987012987	76	16	98.7	0	228	1	28	103	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	228	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28894333	28894333	PRJNA763243_P_NODE_70488_length_218_cov_4.179310_g70142_i0	PRJNA763243	70488	218	4.17931	9.1108958	Cyanophyceae	3028117	Bacteria	Bacteria	100	1.26e-22	NR	NJK39933.1	2720468	g70142	i0	63.9	17.8348623853211	72	26	99.1	0	218	3	345	416	NJK39933.1 leucyl aminopeptidase [Oscillatoriales cyanobacterium SM2_3_0]	diamond	3888	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium SM2_3_0
29042825	29042825	PRJNA763243_P_NODE_17988_length_369_cov_3.976351_g17643_i0	PRJNA763243	17988	369	3.976351	14.67273519	Microcoleus sp. FACHB-1515	2692821	Bacteria	Bacteria	90.1	4.39e-20	NR	WP_313926973.1	2692821	g17643	i0	87	0.439024390243902	54	7	43.9	0	4	165	91	144	WP_313926973.1 flotillin domain-containing protein [Microcoleus sp. FACHB-1515]	diamond	162	90.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-1515
29042831	29042831	PRJNA763243_P_NODE_24788_length_324_cov_11.924303_g24442_i0	PRJNA763243	24788	324	11.924303	38.63474172	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	153	2.849999999999999e-43	NR	MBX9694561.1	2847862	g24442	i0	74.3	0.972222222222222	105	23	93.5	1	310	8	15	119	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	315	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29052466	29052466	PRJNA763243_P_NODE_36308_length_286_cov_56.018779_g35962_i0	PRJNA763243	36308	286	56.018779	160.21370794	Rivularia	373984	Bacteria	Bacteria	150	2.25e-40	NR	WP_038082044.1	1161	g35962	i0	73.4	3.94405594405594	94	25	98.6	0	285	4	26	119	WP_038082044.1 MULTISPECIES: hypothetical protein [Nostocales]	diamond	1128	151	0.993377483443709	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
29200717	29200717	PRJNA763243_P_NODE_31289_length_304_cov_1.844156_g30943_i0	PRJNA763243	31289	304	1.844156	5.60623424	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	77.8	4.68e-15	NR	MBX9690859.1	2847862	g30943	i0	43.9	1.05592105263158	107	50	98.7	3	300	1	86	189	MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium]	diamond	321	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29737075	29737075	PRJNA763243_P_NODE_75570_length_196_cov_4.398374_g75224_i0	PRJNA763243	75570	196	4.398374	8.62081304	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	129	1.65e-34	NR	WP_106370134.1	2107693	g75224	i0	96.9	0.979591836734694	64	2	98	0	4	195	151	214	WP_106370134.1 phosphatidate cytidylyltransferase [Chlorogloea sp. CCALA 695]	diamond	192	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
29895321	29895321	PRJNA763243_P_NODE_54651_length_248_cov_3.565714_g54305_i0	PRJNA763243	54651	248	3.565714	8.84297072	Cyanophyceae	3028117	Bacteria	Bacteria	112	1.15e-29	NR	WP_190765321.1	3028117	g54305	i0	96.4	0.665322580645161	55	2	66.5	0	165	1	1	55	WP_190765321.1 MULTISPECIES: photosystem I reaction center subunit IV [Cyanophyceae]	diamond	165	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
30274591	30274591	PRJNA763243_P_NODE_44332_length_266_cov_4.113990_g43986_i0	PRJNA763243	44332	266	4.11399	10.9432134	Aliterella atlantica	1827278	Bacteria	Bacteria	172	1.74e-49	NR	WP_045055340.1	1827278	g43986	i0	97.7	0.969924812030075	86	2	97	0	261	4	157	242	WP_045055340.1 hemolysin family protein [Aliterella atlantica]	diamond	258	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
30338004	30338004	PRJNA763243_P_NODE_67712_length_229_cov_4.333333_g67366_i0	PRJNA763243	67712	229	4.333333	9.92333257	Leptolyngbyaceae cyanobacterium SM1_3_5	2720458	Bacteria	Bacteria	113	3.18e-29	NR	NJL22645.1	2720458	g67366	i0	79.1	0.877729257641921	67	14	87.8	0	226	26	22	88	NJL22645.1 glutathione S-transferase family protein [Leptolyngbyaceae cyanobacterium SM1_3_5]	diamond	201	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium SM1_3_5
30558500	30558500	PRJNA763243_P_NODE_66033_length_234_cov_67.962733_g65687_i0	PRJNA763243	66033	234	67.962733	159.03279522	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	67	2.43e-11	NR	HEY9745580.1	3088181	g65687	i0	46.7	0.961538461538462	75	37	96.2	3	227	3	80	151	HEY9745580.1 type II secretion system protein [Oculatellaceae cyanobacterium]	diamond	225	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
30631377	30631377	PRJNA763243_P_NODE_67113_length_231_cov_3.253165_g66767_i0	PRJNA763243	67113	231	3.253165	7.51481115	Bacteria	2	Bacteria	Bacteria	93.2	9.7e-21	NR	NJL23364.1	2720458	g66767	i0	75.8	1.71428571428571	66	16	85.7	0	6	203	41	106	NJL23364.1 FAD-binding oxidoreductase [Leptolyngbyaceae cyanobacterium SM1_3_5]	diamond	396	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium SM1_3_5
30716572	30716572	PRJNA763243_P_NODE_48234_length_258_cov_1.437838_g47888_i0	PRJNA763243	48234	258	1.437838	3.70962204	Coleofasciculus sp. FACHB-SPT36	2692790	Bacteria	Bacteria	102	6.1e-23	NR	WP_242047587.1	2692790	g47888	i0	57.1	0.976744186046512	84	35	96.5	1	9	257	84	167	WP_242047587.1 GumC family protein, partial [Coleofasciculus sp. FACHB-SPT36]	diamond	252	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-SPT36
31073945	31073945	PRJNA763243_P_NODE_37875_length_282_cov_3.167464_g37529_i0	PRJNA763243	37875	282	3.167464	8.93224848	Bacteria	2	Bacteria	Bacteria	64.7	1.04e-9	NR	MBA4049988.1	2067976	g37529	i0	54.8	23.968085106383	62	26	63.8	1	3	182	5	66	MBA4049988.1 hypothetical protein [Cyanobacteria bacterium DS2.008]	diamond	6759	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.008
31253810	31253810	PRJNA763243_P_NODE_43975_length_267_cov_2.319588_g43629_i0	PRJNA763243	43975	267	2.319588	6.19329996	Cyanophyceae	3028117	Bacteria	Bacteria	160	4.799999999999999e-46	NR	WP_190767580.1	3028117	g43629	i0	89.7	0.97752808988764	87	9	97.8	0	261	1	178	264	WP_190767580.1 MULTISPECIES: hypothetical protein [Cyanophyceae]	diamond	261	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
31854757	31854757	PRJNA763243_P_NODE_66837_length_232_cov_2.792453_g66491_i0	PRJNA763243	66837	232	2.792453	6.47849096	Aliterella atlantica	1827278	Bacteria	Bacteria	75.9	6.92e-14	NR	WP_045054741.1	1827278	g66491	i0	95.3	0.556034482758621	43	2	55.6	0	103	231	1	43	WP_045054741.1 iron uptake porin [Aliterella atlantica]	diamond	129	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31918117	31918117	PRJNA763243_P_NODE_70437_length_218_cov_7.462069_g70091_i0	PRJNA763243	70437	218	7.462069	16.26731042	Microcoleus sp. FACHB-68	2692826	Bacteria	Bacteria	65.5	2.5e-10	NR	WP_190760241.1	2692826	g70091	i0	96.9	0.440366972477064	32	1	44	0	120	215	1	32	WP_190760241.1 acyltransferase family protein [Microcoleus sp. FACHB-68]	diamond	96	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-68
32107904	32107904	PRJNA763243_P_NODE_39898_length_277_cov_1.848039_g39552_i0	PRJNA763243	39898	277	1.848039	5.11906803	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	61.2	1.65e-8	NR	HCF29673.1	2055787	g39552	i0	84.6	0.422382671480144	39	6	42.2	0	160	276	1	39	HCF29673.1 hypothetical protein [Cyanobacteria bacterium UBA11049]	diamond	117	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
32266413	32266413	PRJNA763243_P_NODE_74218_length_201_cov_5.648438_g73872_i0	PRJNA763243	74218	201	5.648438	11.35336038	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	65.9	3.16e-11	NR	TAF52281.1	1151	g73872	i0	77.5	0.597014925373134	40	9	59.7	0	73	192	34	73	TAF52281.1 MAG: hypothetical protein EAZ61_08525 [Oscillatoriales cyanobacterium]	diamond	120	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
32392706	32392706	PRJNA763243_P_NODE_50159_length_254_cov_1.541436_g49813_i0	PRJNA763243	50159	254	1.541436	3.91524744	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	50.1	1.1e-4	NR	MBC7545036.1	2762020	g49813	i0	37	1.99606299212598	81	48	93.3	3	251	15	244	323	MBC7545036.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	507	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32424383	32424383	PRJNA763243_P_NODE_52799_length_250_cov_1.322034_g52453_i0	PRJNA763243	52799	250	1.322034	3.305085	Anabaenopsis circularis NIES-21	1085406	Bacteria	Bacteria	58.2	1.51e-7	NR	BAY16258.1	1085406	g52453	i0	64.1	0.468	39	14	46.8	0	32	148	275	313	BAY16258.1 hypothetical protein NIES21_20830 [Anabaenopsis circularis NIES-21]	diamond	117	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
32560816	32560816	PRJNA763243_P_NODE_67179_length_231_cov_2.525316_g66833_i0	PRJNA763243	67179	231	2.525316	5.83347996	Cyanophyceae	3028117	Bacteria	Bacteria	72.4	1.11e-12	NR	NJL20853.1	2720458	g66833	i0	57.1	2.8961038961039	56	24	72.7	0	226	59	292	347	NJL20853.1 PAS domain-containing protein [Leptolyngbyaceae cyanobacterium SM1_3_5]	diamond	669	72.8	0.994505494505495	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium SM1_3_5
32613949	32613949	PRJNA763243_P_NODE_22680_length_336_cov_4.152091_g22334_i0	PRJNA763243	22680	336	4.152091	13.95102576	Coleofasciculus sp. H7-2	3351545	Bacteria	Bacteria	50.8	1.6e-4	NR	WP_378174148.1	3351545	g22334	i0	27.4	1.00892857142857	113	70	90.2	2	33	335	462	574	WP_378174148.1 lipoxygenase family protein [Coleofasciculus sp. H7-2]	diamond	339	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. H7-2
32645131	32645131	PRJNA763243_P_NODE_43860_length_267_cov_9.226804_g43514_i0	PRJNA763243	43860	267	9.226804	24.63556668	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	82.8	9.96e-17	NR	MBW4638300.1	2839657	g43514	i0	88.6	0.49438202247191	44	5	49.4	0	60	191	235	278	MBW4638300.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	132	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32645138	32645138	PRJNA763243_P_NODE_47540_length_259_cov_3.053763_g47194_i0	PRJNA763243	47540	259	3.053763	7.90924617	Leptolyngbya sp. FACHB-1515	2933931	Bacteria	Bacteria	124	6.789999999999999e-31	NR	WP_190768086.1	2933931	g47194	i0	90.5	0.857142857142857	74	6	85.7	1	5	226	538	610	WP_190768086.1 PTS fructose-like transporter subunit IIB [Leptolyngbya sp. FACHB-1515]	diamond	222	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-1515
32708370	32708370	PRJNA763243_P_NODE_71020_length_215_cov_13.021127_g70674_i0	PRJNA763243	71020	215	13.021127	27.99542305	Cyanobacteria bacterium P01_H01_bin.21	3023318	Bacteria	Bacteria	59.7	2.93e-9	NR	MEM1254498.1	3023318	g70674	i0	44.3	3.26511627906977	61	34	85.1	0	28	210	3	63	MEM1254498.1 nuclear transport factor 2 family protein [Cyanobacteria bacterium P01_H01_bin.21]	diamond	702	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.21
32812422	32812422	PRJNA763243_P_NODE_44520_length_266_cov_1.554404_g44174_i0	PRJNA763243	44520	266	1.554404	4.13471464	Cyanophyceae	3028117	Bacteria	Bacteria	169	1.04e-51	NR	WP_396798158.1	2692821	g44174	i0	95.4	1.96240601503759	87	4	98.1	0	4	264	44	130	WP_396798158.1 DUF2267 domain-containing protein [Microcoleus sp. FACHB-1515]	diamond	522	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-1515
32834322	32834322	PRJNA763243_P_NODE_73820_length_202_cov_97.279070_g73474_i0	PRJNA763243	73820	202	97.27907	196.5037214	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	93.2	1.78e-22	NR	MBF2054278.1	2762020	g73474	i0	72.4	0.861386138613861	58	16	86.1	0	23	196	34	91	MBF2054278.1 VOC family protein [Candidatus Sericytochromatia bacterium]	diamond	174	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32865803	32865803	PRJNA763243_P_NODE_53740_length_249_cov_1.687500_g53394_i0	PRJNA763243	53740	249	1.6875	4.201875	Calothrix sp. HK-	1187	Bacteria	Bacteria	90.1	8.09e-19	NR	OKH45489.1	1137096	g53394	i0	43.7	1.51807228915663	126	23	94	2	236	3	352	477	OKH45489.1 hypothetical protein NIES2101_26520 [Calothrix sp. HK-06]	diamond	378	90.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. HK-06
32865816	32865816	PRJNA763243_P_NODE_69920_length_220_cov_65.986395_g69574_i0	PRJNA763243	69920	220	65.986395	145.170069	Chroococcidiopsis sp. CCALA	3088168	Bacteria	Bacteria	146	8.35e-43	NR	WP_199197366.1	869949	g69574	i0	94.4	0.981818181818182	72	4	98.2	0	2	217	39	110	WP_199197366.1 opioid growth factor receptor-related protein [Chroococcidiopsis sp. CCALA 051]	diamond	216	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCALA 051

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