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

26 rows where analysis = "diamond", bioproject = "PRJNA1118794" 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
4057936	4057936	PRJNA1118794_P_NODE_8164_length_492_cov_1.463007_g7421_i0	PRJNA1118794	8164	492	1.463007	7.19799444	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	184	3.529999999999999e-54	NR	MBX9694561.1	2847862	g7421	i0	59.5	1.98780487804878	163	63	98.8	2	3	488	53	213	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	978	184	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
7883976	7883976	PRJNA1118794_P_NODE_68067_length_243_cov_0.905882_g67317_i0	PRJNA1118794	68067	243	0.905882	2.20129326	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	73.9	3.9e-14	NR	MBL8086383.1	2711154	g67317	i0	78	0.506172839506173	41	9	50.6	0	243	121	104	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	123	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
11709532	11709532	PRJNA1118794_P_NODE_47070_length_254_cov_1.270718_g46320_i0	PRJNA1118794	47070	254	1.270718	3.22762372	Prochlorothrix sp.	54309	Bacteria	Bacteria	143	6.1e-40	NR	MEB3163896.1	54309	g46320	i0	72.6	4.96062992125984	84	23	99.2	0	254	3	220	303	MEB3163896.1 UDP-glucuronic acid decarboxylase family protein [Prochlorothrix sp.]	diamond	1260	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix sp.
14260149	14260149	PRJNA1118794_P_NODE_9192_length_465_cov_3.584184_g8444_i0	PRJNA1118794	9192	465	3.584184	16.6664556	Cyanophyceae	3028117	Bacteria	Bacteria	106	5.73e-26	NR	PSN10069.1	2107701	g8444	i0	69.4	5.54193548387097	72	22	46.5	0	464	249	78	149	PSN10069.1 nucleoside-diphosphate kinase [filamentous cyanobacterium CCP5]	diamond	2577	107	0.990654205607477	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP5
18082156	18082156	PRJNA1118794_P_NODE_24035_length_317_cov_1.692623_g23285_i0	PRJNA1118794	24035	317	1.692623	5.36561491	Cyanophyceae	3028117	Bacteria	Bacteria	102	4.52e-25	NR	WP_127085414.1	32056	g23285	i0	62.5	6.10410094637224	72	27	68.1	0	1	216	78	149	WP_127085414.1 nucleoside-diphosphate kinase [Dulcicalothrix desertica]	diamond	1935	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
21908055	21908055	PRJNA1118794_P_NODE_7518_length_512_cov_2.407745_g6776_i0	PRJNA1118794	7518	512	2.407745	12.3276544	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	164	2.9199999999999998e-46	NR	MBX9694561.1	2847862	g6776	i0	55.1	0.9140625	156	69	91.4	1	19	486	26	180	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	468	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26624859	26624859	PRJNA1118794_P_NODE_54241_length_249_cov_0.875000_g53491_i0	PRJNA1118794	54241	249	0.875	2.17875	Cyanobacteria bacterium 13_1_4	2847862	Bacteria	Bacteria	145	8.46e-41	NR	OLE69424.1	1805101	g53491	i0	75.6	2.96385542168675	82	20	98.8	0	247	2	50	131	OLE69424.1 MAG: hypothetical protein AUI36_04775 [Cyanobacteria bacterium 13_1_40CM_2_61_4]	diamond	738	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium 13_1_40CM_2_61_4
26783420	26783420	PRJNA1118794_P_NODE_66421_length_244_cov_0.900585_g65671_i0	PRJNA1118794	66421	244	0.900585	2.1974274	Pleurocapsales cyanobacterium LEGE 10410	1828828	Bacteria	Bacteria	42.4	0.0422	NR	MBE9043035.1	1828828	g65671	i0	51.4	0.430327868852459	35	17	43	0	106	2	10	44	MBE9043035.1 TetR/AcrR family transcriptional regulator [Pleurocapsales cyanobacterium LEGE 10410]	diamond	105	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			Pleurocapsales cyanobacterium LEGE 10410
26815026	26815026	PRJNA1118794_P_NODE_67821_length_243_cov_0.905882_g67071_i0	PRJNA1118794	67821	243	0.905882	2.20129326	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	110	4.08e-26	NR	MBS1953646.1	2807733	g67071	i0	64.2	2	81	29	100	0	243	1	710	790	MBS1953646.1 SulP family inorganic anion transporter [Cyanobacteria bacterium SZAS-4]	diamond	486	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
26869480	26869480	PRJNA1118794_P_NODE_52101_length_250_cov_0.870056_g51351_i0	PRJNA1118794	52101	250	0.870056	2.17514	Oxynema	1492710	Bacteria	Bacteria	86.7	1.38e-17	NR	WP_200665966.1	984206	g51351	i0	59.1	1.608	66	27	79.2	0	206	9	260	325	WP_200665966.1 RNB domain-containing ribonuclease [Oxynema sp. CENA135]	diamond	402	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oxynema	Oxynema sp. CENA135
27027395	27027395	PRJNA1118794_P_NODE_63282_length_245_cov_0.895349_g62532_i0	PRJNA1118794	63282	245	0.895349	2.19360505	Leptolyngbyaceae	1890438	Bacteria	Bacteria	138	3.9e-40	NR	WP_073070278.1	268141	g62532	i0	81.5	1.98367346938776	81	15	99.2	0	243	1	23	103	WP_073070278.1 endonuclease domain-containing protein [Phormidesmis priestleyi]	diamond	486	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis priestleyi
27510568	27510568	PRJNA1118794_P_NODE_65463_length_244_cov_0.900585_g64713_i0	PRJNA1118794	65463	244	0.900585	2.1974274	Microcoleus sp. HI-ES	2970922	Bacteria	Bacteria	42.4	0.0499	NR	MCZ0902702.1	2970922	g64713	i0	35.4	0.590163934426229	48	31	59	0	34	177	111	158	MCZ0902702.1 aldo/keto reductase [Microcoleus sp. HI-ES]	diamond	144	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. HI-ES
28078670	28078670	PRJNA1118794_P_NODE_36965_length_275_cov_1.524752_g36215_i0	PRJNA1118794	36965	275	1.524752	4.193068	Trichodesmium sp. MO_231.B1	3036787	Bacteria	Bacteria	132	2.37e-33	NR	MDJ0518620.1	3036787	g36215	i0	67.5	1.81090909090909	83	27	90.5	0	2	250	1763	1845	MDJ0518620.1 hypothetical protein [Trichodesmium sp. MO_231.B1]	diamond	498	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium sp. MO_231.B1
28552537	28552537	PRJNA1118794_P_NODE_47687_length_252_cov_2.430168_g46937_i0	PRJNA1118794	47687	252	2.430168	6.12402336	Oscillatoria sp. FACHB-14	1159	Bacteria	Bacteria	102	5.92e-23	NR	WP_190712339.1	2692846	g46937	i0	65.8	0.904761904761905	76	25	89.3	1	1	225	123	198	WP_190712339.1 colicin uptake protein [Oscillatoria sp. FACHB-1406]	diamond	228	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. FACHB-1406
29585000	29585000	PRJNA1118794_P_NODE_8310_length_488_cov_2.077108_g7567_i0	PRJNA1118794	8310	488	2.077108	10.13628704	Cyanophyceae	3028117	Bacteria	Bacteria	202	3.649999999999999e-57	NR	WP_228061793.1	767427	g7567	i0	62.3	12.9282786885246	162	60	99.6	1	3	488	206	366	WP_228061793.1 colicin uptake protein [[Phormidium] sp. LEGE 05292]	diamond	6309	204	0.990196078431373	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	[Phormidium] sp. LEGE 05292
30289603	30289603	PRJNA1118794_P_NODE_39932_length_269_cov_1.311224_g39182_i0	PRJNA1118794	39932	269	1.311224	3.52719256	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	55.5	1.78e-6	NR	MBX9876961.1	2364082	g39182	i0	50	0.981412639405205	88	38	98.1	2	268	5	1014	1095	MBX9876961.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	264	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30952936	30952936	PRJNA1118794_P_NODE_61874_length_246_cov_0.890173_g61124_i0	PRJNA1118794	61874	246	0.890173	2.18982558	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	50.8	5.53e-5	NR	MFN9621355.1	2847862	g61124	i0	42.1	1.85365853658537	76	39	87.8	3	233	18	1573	1647	MFN9621355.1 Calx-beta domain-containing protein [Cyanobacteriota bacterium]	diamond	456	50.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30975467	30975467	PRJNA1118794_P_NODE_71514_length_242_cov_0.911243_g70764_i0	PRJNA1118794	71514	242	0.911243	2.20520806	Allocoleopsis	2886347	Bacteria	Bacteria	110	2.85e-27	NR	HEY9634053.1	3081323	g70764	i0	75	2.97520661157025	80	20	99.2	0	3	242	171	250	HEY9634053.1 DUF3365 domain-containing protein [Coleofasciculaceae cyanobacterium]	diamond	720	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
31173583	31173583	PRJNA1118794_P_NODE_70795_length_242_cov_0.911243_g70045_i0	PRJNA1118794	70795	242	0.911243	2.20520806	Synechocystis sp. B12	2764086	Bacteria	Bacteria	42.4	0.0485	NR	WLT37854.1	2764086	g70045	i0	29.3	0.929752066115702	75	39	90.5	2	22	240	154	216	WLT37854.1 M48 family metalloprotease [Synechocystis sp. B12]	diamond	225	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. B12
31331965	31331965	PRJNA1118794_P_NODE_30856_length_290_cov_1.124424_g30106_i0	PRJNA1118794	30856	290	1.124424	3.2608296	Chroococcidiopsis sp. [FACHB-1243]	2692781	Bacteria	Bacteria	136	3.71e-35	NR	WP_192162675.1	2692781	g30106	i0	68.4	7.86206896551724	95	30	98.3	0	285	1	61	155	WP_192162675.1 group II intron reverse transcriptase/maturase [Chroococcidiopsis sp. [FACHB-1243]]	diamond	2280	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. [FACHB-1243]
31806467	31806467	PRJNA1118794_P_NODE_38457_length_272_cov_1.402010_g37707_i0	PRJNA1118794	38457	272	1.40201	3.8134672	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	130	2.91e-36	NR	MBL8086383.1	2711154	g37707	i0	73.9	0.970588235294118	88	22	97.1	1	1	264	58	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	264	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31837925	31837925	PRJNA1118794_P_NODE_48477_length_251_cov_1.438202_g47727_i0	PRJNA1118794	48477	251	1.438202	3.60988702	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	128	8.86e-33	NR	MEZ0371079.1	2762020	g47727	i0	75.9	1.9840637450199201	83	20	99.2	0	2	250	314	396	MEZ0371079.1 argininosuccinate lyase [Candidatus Sericytochromatia bacterium]	diamond	498	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
31996349	31996349	PRJNA1118794_P_NODE_55618_length_248_cov_0.880000_g54868_i0	PRJNA1118794	55618	248	0.88	2.1824	Brasilonema sp. UFV-L1	2234130	Bacteria	Bacteria	49.3	1.87e-4	NR	NMG11786.1	2234130	g54868	i0	37	0.979838709677419	81	42	98	2	246	4	2	73	NMG11786.1 hypothetical protein [Brasilonema sp. UFV-L1]	diamond	243	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sp. UFV-L1
32281294	32281294	PRJNA1118794_P_NODE_55779_length_248_cov_0.880000_g55029_i0	PRJNA1118794	55779	248	0.88	2.1824	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	119	1.07e-30	NR	MBP6350655.1	2711154	g55029	i0	77.1	3.01209677419355	83	14	99.2	2	1	246	173	251	MBP6350655.1 E3 binding domain-containing protein [Candidatus Obscuribacter sp.]	diamond	747	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32313013	32313013	PRJNA1118794_P_NODE_64099_length_245_cov_0.895349_g63349_i0	PRJNA1118794	64099	245	0.895349	2.19360505	Cyanobacteria bacterium SZAS LIN-3	2807732	Bacteria	Bacteria	44.7	0.00609	NR	MBS1994641.1	2807732	g63349	i0	35.7	1.31020408163265	56	36	68.6	0	78	245	19	74	MBS1994641.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-3]	diamond	321	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-3
32439542	32439542	PRJNA1118794_P_NODE_58799_length_247_cov_0.885057_g58049_i0	PRJNA1118794	58799	247	0.885057	2.18609079	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	75.1	1.5e-13	NR	MDX1986241.1	2711154	g58049	i0	60.9	0.777327935222672	64	25	77.7	0	194	3	4	67	MDX1986241.1 IS1380 family transposase [Candidatus Obscuribacter sp.]	diamond	192	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.

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