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

29 rows where analysis = "diamond", bioproject = "PRJNA393181" 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
6181290	6181290	PRJNA393181_S_NODE_1145_length_824_cov_2.664549_g1078_i0	PRJNA393181	1145	824	2.664549	21.95588376	Phormidium tenue	126344	Bacteria	Bacteria	297	2.65e-97	NR	MBD3885021.1	2692911	g1078	i0	60.7	9.16383495145631	252	94	91	3	73	822	19	267	MBD3885021.1 methyltransferase [Phormidium tenue FACHB-886]	diamond	7551	297	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
10614913	10614913	PRJNA393181_S_NODE_9069_length_399_cov_2.726519_g8963_i0	PRJNA393181	9069	399	2.726519	10.87881081	Dolichospermum sp. FACHB-1	2720786	Bacteria	Bacteria	82.4	2.91e-15	NR	WP_190391856.1	2692798	g8963	i0	72	5.61654135338346	107	29	79.7	1	3	320	968	1074	WP_190391856.1 Calx-beta domain-containing protein [Dolichospermum sp. FACHB-1091]	diamond	2241	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. FACHB-1091
15713306	15713306	PRJNA393181_S_NODE_3453_length_586_cov_3.315118_g3362_i0	PRJNA393181	3453	586	3.315118	19.42659148	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	266	1.15e-84	NR	PZV19133.1	1153	g3362	i0	68	2.95904436860068	194	62	99.3	0	584	3	3	196	PZV19133.1 MAG: class I SAM-dependent methyltransferase [Pseudanabaena sp.]	diamond	1734	266	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
19536397	19536397	PRJNA393181_S_NODE_32216_length_195_cov_2.860759_g32110_i0	PRJNA393181	32216	195	2.860759	5.57848005	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	81.3	1.14e-16	NR	MBW4472102.1	1382958	g32110	i0	69.6	2.70769230769231	56	15	83.1	1	5	166	151	206	MBW4472102.1 aminotransferase class I and II [Stenomitos rutilans HA7619-LM2]	diamond	528	82	0.991463414634146	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
20811635	20811635	PRJNA393181_S_NODE_10377_length_375_cov_2.357988_g10271_i0	PRJNA393181	10377	375	2.357988	8.842455	Myxosarcina	52605	Bacteria	Bacteria	139	4.88e-36	NR	WP_036483222.1	1541065	g10271	i0	51.2	2	125	59	99.2	2	2	373	259	382	WP_036483222.1 tetratricopeptide repeat protein [Myxosarcina sp. GI1]	diamond	750	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
27644212	27644212	PRJNA393181_S_NODE_37884_length_175_cov_2.731884_g37778_i0	PRJNA393181	37884	175	2.731884	4.780797	Rubidibacter lacunae	582514	Bacteria	Bacteria	96.3	1.65e-21	NR	WP_022604192.1	582514	g37778	i0	79.3	1.98857142857143	58	12	99.4	0	174	1	336	393	WP_022604192.1 AtzE family amidohydrolase [Rubidibacter lacunae]	diamond	348	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rubidibacter	Rubidibacter lacunae
27675795	27675795	PRJNA393181_S_NODE_24284_length_234_cov_2.279188_g24178_i0	PRJNA393181	24284	234	2.279188	5.33329992	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	110	1.3100000000000002e-27	NR	MEO8893792.1	3081323	g24178	i0	63.9	2.74358974358974	72	26	92.3	0	232	17	126	197	MEO8893792.1 DUF1698 domain-containing protein [Coleofasciculaceae cyanobacterium]	diamond	642	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
27976462	27976462	PRJNA393181_S_NODE_20345_length_261_cov_1.535714_g20239_i0	PRJNA393181	20345	261	1.535714	4.00821354	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	3.08e-25	NR	WP_332865236.1	1579216	g20239	i0	67.1	4.83908045977012	70	23	80.5	0	4	213	224	293	WP_332865236.1 phytanoyl-CoA dioxygenase family protein [Pannus brasiliensis]	diamond	1263	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Pannus	Pannus brasiliensis
28166027	28166027	PRJNA393181_S_NODE_32665_length_194_cov_1.407643_g32559_i0	PRJNA393181	32665	194	1.407643	2.73082742	Bacteria	2	Bacteria	Bacteria	95.5	5.08e-21	NR	WP_200326644.1	459663	g32559	i0	70.3	18.7886597938144	64	19	99	0	194	3	38	101	WP_200326644.1 hybrid sensor histidine kinase/response regulator [Sphaerospermopsis aphanizomenoides]	diamond	3645	95.9	0.995828988529718	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis aphanizomenoides
28243677	28243677	PRJNA393181_S_NODE_10726_length_368_cov_3.151057_g10620_i0	PRJNA393181	10726	368	3.151057	11.59588976	Xenococcaceae cyanobacterium MO_167.B52	3036637	Bacteria	Bacteria	59.7	2.47e-8	NR	MDJ0680803.1	3036637	g10620	i0	47.5	0.497282608695652	61	32	49.7	0	161	343	1	61	MDJ0680803.1 DUF1269 domain-containing protein [Xenococcaceae cyanobacterium MO_167.B52]	diamond	183	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_167.B52
28559735	28559735	PRJNA393181_S_NODE_16547_length_294_cov_2.354086_g16441_i0	PRJNA393181	16547	294	2.354086	6.92101284	unclassified Calothrix	2619626	Bacteria	Bacteria	54.3	6.06e-6	NR	WP_190628597.1	2619626	g16441	i0	61.5	0.816326530612245	39	15	39.8	0	124	8	675	713	WP_190628597.1 MULTISPECIES: RHS repeat-associated core domain-containing protein [unclassified Calothrix]	diamond	240	54.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix
28828863	28828863	PRJNA393181_S_NODE_33508_length_190_cov_2.627451_g33402_i0	PRJNA393181	33508	190	2.627451	4.9921569	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	61.2	2.89e-9	NR	WP_186548021.1	221341	g33402	i0	57.1	2.98421052631579	63	27	99.5	0	1	189	11	73	WP_186548021.1 SDR family oxidoreductase [Synechococcus sp. Minos11]	diamond	567	61.6	0.993506493506494	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. Minos11
28843597	28843597	PRJNA393181_S_NODE_11248_length_360_cov_1.891641_g11142_i0	PRJNA393181	11248	360	1.891641	6.8099076	Planktothrix mougeotii	54306	Bacteria	Bacteria	246	9.63e-78	NR	WP_407676174.1	54306	g11142	i0	100	1	120	0	100	0	1	360	320	439	WP_407676174.1 IS3 family transposase [Planktothrix mougeotii]	diamond	360	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
28938587	28938587	PRJNA393181_S_NODE_14068_length_321_cov_2.788732_g13962_i0	PRJNA393181	14068	321	2.788732	8.95182972	Pseudanabaena sp. UWO31	1153	Bacteria	Bacteria	57.8	4.56e-7	NR	WP_142599892.1	2480795	g13962	i0	60.4	1.05607476635514	53	20	48.6	1	164	319	13	65	WP_142599892.1 metallophosphoesterase family protein [Pseudanabaena sp. UWO310]	diamond	339	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. UWO310
28955559	28955559	PRJNA393181_S_NODE_9848_length_384_cov_3.391931_g9742_i0	PRJNA393181	9848	384	3.391931	13.02501504	Calothrix	1186	Bacteria	Bacteria	137	6.26e-36	NR	WP_096589198.1	1954171	g9742	i0	56.6	6.734375	122	51	95.3	1	7	372	198	317	WP_096589198.1 endo-1,4-beta-xylanase [Calothrix sp. NIES-2098]	diamond	2586	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2098
29128172	29128172	PRJNA393181_S_NODE_18609_length_275_cov_1.617647_g18503_i0	PRJNA393181	18609	275	1.617647	4.44852925	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	107	3.9799999999999998e-25	NR	MEY4354298.1	2847862	g18503	i0	66.2	3.85090909090909	71	24	77.5	0	62	274	2	72	MEY4354298.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	1059	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29854217	29854217	PRJNA393181_S_NODE_18571_length_275_cov_2.537815_g18465_i0	PRJNA393181	18571	275	2.537815	6.97899125	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.1	0.0388	NR	MFN8551875.1	2364082	g18465	i0	32.9	0.894545454545455	82	53	87.3	1	7	246	114	195	MFN8551875.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	246	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30155029	30155029	PRJNA393181_S_NODE_6032_length_476_cov_2.113895_g5926_i0	PRJNA393181	6032	476	2.113895	10.0621402	Bacillati	1783272	Bacteria	Bacteria	115	3.94e-27	NR	MBR8828978.1	1521640	g5926	i0	36.1	4.94747899159664	158	99	99.6	1	1	474	170	325	MBR8828978.1 serpin family protein [Gomphosphaeria aponina SAG 52.96 = DSM 107014]	diamond	2355	116	0.991379310344828	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Gomphosphaeriaceae	Gomphosphaeria	Gomphosphaeria aponina
30328601	30328601	PRJNA393181_S_NODE_18252_length_278_cov_2.207469_g18146_i0	PRJNA393181	18252	278	2.207469	6.13676382	Scytolyngbya sp. HA4215-MV1	1382716	Bacteria	Bacteria	62	9.4e-9	NR	MBW4521164.1	1382716	g18146	i0	51.7	1.29496402877698	60	28	63.7	1	277	101	543	602	MBW4521164.1 PQQ-dependent sugar dehydrogenase [Scytolyngbya sp. HA4215-MV1]	diamond	360	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Scytolyngbya	Scytolyngbya sp. HA4215-MV1
30660818	30660818	PRJNA393181_S_NODE_31333_length_199_cov_1.975309_g31227_i0	PRJNA393181	31333	199	1.975309	3.93086491	Bacteria	2	Bacteria	Bacteria	44.3	0.00598	NR	WP_075891405.1	454133	g31227	i0	45.7	10.070351758794	46	24	69.3	1	175	38	289	333	WP_075891405.1 Ig-like domain-containing protein [[Limnothrix rosea] IAM M-220]	diamond	2004	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Limnothrix rosea] IAM M-220
30928472	30928472	PRJNA393181_S_NODE_21114_length_255_cov_2.500000_g21008_i0	PRJNA393181	21114	255	2.5	6.375	Oculatella sp. FACHB-28	2692845	Bacteria	Bacteria	70.5	6.47e-12	NR	WP_190643169.1	2692845	g21008	i0	47.9	5.31764705882353	73	37	85.9	1	33	251	114	185	WP_190643169.1 2OG-Fe(II) oxygenase [Oculatella sp. FACHB-28]	diamond	1356	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella sp. FACHB-28
31149114	31149114	PRJNA393181_S_NODE_29155_length_209_cov_1.587209_g29049_i0	PRJNA393181	29155	209	1.587209	3.31726681	Floridanema evergladense	3396172	Bacteria	Bacteria	73.9	4.87e-15	NR	WP_413277025.1	3396172	g29049	i0	49.3	1.01913875598086	71	34	99	1	1	207	32	102	WP_413277025.1 DUF6968 family protein [Floridanema evergladense]	diamond	213	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Floridanema	Floridanema evergladense
31339169	31339169	PRJNA393181_S_NODE_19876_length_264_cov_2.629956_g19770_i0	PRJNA393181	19876	264	2.629956	6.94308384	cyanobacterium TDX16	1503470	Bacteria	Bacteria	80.5	1.06e-16	NR	OWY67765.1	1503470	g19770	i0	58.9	1.68181818181818	73	30	83	0	39	257	1	73	OWY67765.1 hypothetical protein B7486_29675 [cyanobacterium TDX16]	diamond	444	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
31434078	31434078	PRJNA393181_S_NODE_3476_length_585_cov_2.713504_g3385_i0	PRJNA393181	3476	585	2.713504	15.8739984	Pseudanabaena sp. UWO31	1153	Bacteria	Bacteria	175	2.2e-49	NR	WP_142599892.1	2480795	g3385	i0	42.4	1.97948717948718	191	110	97.9	0	1	573	216	406	WP_142599892.1 metallophosphoesterase family protein [Pseudanabaena sp. UWO310]	diamond	1158	175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. UWO310
31908627	31908627	PRJNA393181_S_NODE_5557_length_491_cov_3.911894_g5451_i0	PRJNA393181	5557	491	3.911894	19.20739954	Planktothrix pseudagardhii	132604	Bacteria	Bacteria	95.1	3.13e-19	NR	WP_302184699.1	132604	g5451	i0	48.9	0.824847250509165	135	40	82.5	2	488	84	1056	1161	WP_302184699.1 FG-GAP-like repeat-containing protein [Planktothrix pseudagardhii]	diamond	405	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix pseudagardhii
32478359	32478359	PRJNA393181_S_NODE_31039_length_200_cov_2.380368_g30933_i0	PRJNA393181	31039	200	2.380368	4.760736	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	55.1	7.01e-7	NR	WP_105219255.1	2859516	g30933	i0	87.1	1.38	31	4	46.5	0	107	199	2	32	WP_105219255.1 aspartate/glutamate racemase family protein [Gloeocapsopsis dulcis]	diamond	276	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
32510065	32510065	PRJNA393181_S_NODE_2459_length_653_cov_2.603896_g2378_i0	PRJNA393181	2459	653	2.603896	17.00344088	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	109	1.95e-26	NR	HVO22926.1	2053573	g2378	i0	65	0.725880551301684	80	28	36.8	0	408	647	60	139	HVO22926.1 integrase core domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	474	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
32667375	32667375	PRJNA393181_S_NODE_2480_length_651_cov_3.451140_g2399_i0	PRJNA393181	2480	651	3.45114	22.4669214	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	78.6	5.22e-13	NR	BAU10253.1	1752064	g2399	i0	33.8	1.15668202764977	151	75	58.1	3	379	2	9	159	BAU10253.1 endo-1,4-beta-xylanase [Leptolyngbya sp. NIES-3755]	diamond	753	78.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
32698860	32698860	PRJNA393181_S_NODE_18140_length_279_cov_2.252066_g18034_i0	PRJNA393181	18140	279	2.252066	6.28326414	Geitlerinema calcuttense	1471433	Bacteria	Bacteria	100	4.049999999999999e-23	NR	WP_285965063.1	1471433	g18034	i0	57.6	1.97849462365591	92	39	98.9	0	276	1	17	108	WP_285965063.1 carbohydrate ABC transporter permease [Geitlerinema calcuttense]	diamond	552	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema calcuttense

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