metadata: contig_metadata: 31 rows where bioproject = "PRJNA526367" and tax_clade = "Cyanobacteriota/Melainabacteria group"

31 rows where bioproject = "PRJNA526367" 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
1114006	1114006	PRJNA526367_P_NODE_66381_length_150_cov_4.772277_g66171_i0	PRJNA526367	66381	150	4.772277	7.1584155	Bacillati	1783272	Bacteria	Bacteria	79.3	1.28e-15	NR	MBW4593278.1	1049008	g66171	i0	72.3	1.86	47	13	94	0	9	149	1321	1367	MBW4593278.1 SDR family NAD(P)-dependent oxidoreductase [Brasilonema angustatum HA4187-MV1]	diamond	279	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema angustatum
1770920	1770920	PRJNA526367_P_NODE_17182_length_324_cov_2.683636_g16973_i0	PRJNA526367	17182	324	2.683636	8.69498064	Phormidium nigroviride	482564	Bacteria	Bacteria	141	6.31e-29	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g16973	i0	92.784	2.08641975308642	97	7	30	0	225	321	5667455	5667551	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	676	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
1771191	1771191	PRJNA526367_P_NODE_39722_length_183_cov_5.731343_g39512_i0	PRJNA526367	39722	183	5.731343	10.48835769	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	263	6.61e-66	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g39512	i0	94.253	126.098360655738	174	6	95	4	2	175	2151631	2151462	Leptolyngbya sp. 7M chromosome	blastn	23076	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
3046774	3046774	PRJNA526367_P_NODE_23483_length_324_cov_2.138182_g23274_i0	PRJNA526367	23483	324	2.138182	6.92770968	Candidatus Paraprochloron terpiosi	2892031	Bacteria	Bacteria	62.1	5.06e-5	NTclustered	gi\|2030184695\|gb\|CP073341.1\|	2829509	g23274	i0	94.872	5.47222222222222	39	2	12	0	237	275	956487	956525	MAG: Candidatus Paraprochloron terpiosi LD05 chromosome, complete genome	blastn	1773	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Candidatus Paraprochloron	Candidatus Paraprochloron terpiosi
3047000	3047000	PRJNA526367_P_NODE_39703_length_183_cov_5.985075_g39493_i0	PRJNA526367	39703	183	5.985075	10.95268725	Ancylothrix terrestris	2023235	Bacteria	Bacteria	206	1.13e-48	NTclustered	gi\|2257652262\|gb\|ON803474.1\|	2953716	g39493	i0	88.136	122.819672131148	177	16	95	4	10	183	2275	2449	Ancylothrix terrestris strain BEA0843B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22476	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix terrestris
3047345	3047345	PRJNA526367_P_NODE_62143_length_155_cov_5.745283_g61933_i0	PRJNA526367	62143	155	5.745283	8.90518865	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	110	7.46e-20	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g61933	i0	98.387	2.07741935483871	62	1	40	0	1	62	6598140	6598079	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	322	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
4323307	4323307	PRJNA526367_P_NODE_9624_length_324_cov_3.698182_g9415_i0	PRJNA526367	9624	324	3.698182	11.98210968	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	150	1.05e-31	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g9415	i0	95.699	0.561728395061728	93	4	56	0	8	100	5601566	5601658	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	182	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
6217336	6217336	PRJNA526367_P_NODE_44085_length_176_cov_3.181102_g43875_i0	PRJNA526367	44085	176	3.181102	5.59873952	Bacillati	1783272	Bacteria	Bacteria	161	2.3599999999999997e-35	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g43875	i0	84.337	288.943181818182	166	24	94	2	6	170	4828196	4828360	Leptolyngbya sp. 7M chromosome	blastn	50854	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
8148865	8148865	PRJNA526367_P_NODE_24127_length_324_cov_2.087273_g23918_i0	PRJNA526367	24127	324	2.087273	6.76276452	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	180	1.34e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g23918	i0	99	0.598765432098765	100	1	60	0	225	324	1368309	1368408	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	194	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11316609	11316609	PRJNA526367_P_NODE_18369_length_324_cov_2.574545_g18160_i0	PRJNA526367	18369	324	2.574545	8.3415258	Oscillatoriales	1150	Bacteria	Bacteria	158	6.27e-34	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g18160	i0	95.05	2.39506172839506	101	4	60	1	1	100	2895050	2894950	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	776	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
21515697	21515697	PRJNA526367_P_NODE_39277_length_184_cov_4.133333_g39067_i0	PRJNA526367	39277	184	4.133333	7.60533272	Leptolyngbya	47251	Bacteria	Bacteria	322	1.08e-83	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g39067	i0	99.435	145.625	177	1	96	0	8	184	247142	247318	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	26795	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
22172458	22172458	PRJNA526367_P_NODE_14298_length_324_cov_2.981818_g14089_i0	PRJNA526367	14298	324	2.981818	9.66109032	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	106	4.57e-24	NR	WP_106367426.1	2107693	g14089	i0	57.1	2.91666666666667	105	3	97.2	1	3	317	532	594	WP_106367426.1 transglycosylase domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	945	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
23448426	23448426	PRJNA526367_P_NODE_42799_length_178_cov_3.488372_g42589_i0	PRJNA526367	42799	178	3.488372	6.20930216	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	231	1.7999999999999997e-56	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g42589	i0	90.857	85.7584269662921	175	13	97	1	1	172	3670598	3670772	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	15265	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
24722410	24722410	PRJNA526367_P_NODE_61580_length_156_cov_4.186916_g61370_i0	PRJNA526367	61580	156	4.186916	6.53158896	Nostoc sphaeroides	446679	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1770420796\|gb\|CP045226.1\|	2653204	g61370	i0	83.607	0.391025641025641	61	8	38	2	84	143	4125154	4125213	Nostoc sphaeroides CCNUC1 chromosome Gxm1, complete sequence	blastn	61	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
26602330	26602330	PRJNA526367_P_NODE_51221_length_166_cov_4.059829_g51011_i0	PRJNA526367	51221	166	4.059829	6.73931614	Microcoleus sp.	44472	Bacteria	Bacteria	60.5	4e-9	NR	WP_371115402.1	44472	g51011	i0	96.4	0.506024096385542	28	1	50.6	0	159	76	209	236	WP_371115402.1 WbqC family protein [Microcoleus sp.]	diamond	84	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp.
26776303	26776303	PRJNA526367_P_NODE_48801_length_169_cov_1.700000_g48591_i0	PRJNA526367	48801	169	1.7	2.873	Chroococcidiopsis	54298	Bacteria	Bacteria	106	4.33e-25	NR	WP_250123882.1	155894	g48591	i0	94.5	6.85207100591716	55	3	97.6	0	169	5	494	548	WP_250123882.1 cyanophycin synthetase [Chroococcidiopsis sp. CCMEE 29]	diamond	1158	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
27614633	27614633	PRJNA526367_P_NODE_7944_length_324_cov_4.247273_g7735_i0	PRJNA526367	7944	324	4.247273	13.76116452	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	56.6	1.32e-6	NR	MEY3767674.1	2847862	g7735	i0	32.7	0.962962962962963	104	56	96.3	1	316	5	486	575	MEY3767674.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	312	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28214154	28214154	PRJNA526367_P_NODE_59906_length_158_cov_5.431193_g59696_i0	PRJNA526367	59906	158	5.431193	8.58128494	Cyanobacteria bacterium UBA12227	2055765	Bacteria	Bacteria	41.6	0.0278	NR	HAG80731.1	2055765	g59696	i0	39.5	0.816455696202532	43	26	81.6	0	144	16	10	52	HAG80731.1 hypothetical protein [Cyanobacteria bacterium UBA12227]	diamond	129	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA12227
28340658	28340658	PRJNA526367_P_NODE_12126_length_324_cov_3.258182_g11917_i0	PRJNA526367	12126	324	3.258182	10.55650968	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	52	5.39e-5	NR	WP_106367766.1	2107693	g11917	i0	85.7	0.518518518518518	28	4	25.9	0	18	101	709	736	WP_106367766.1 primosomal protein N' [Chlorogloea sp. CCALA 695]	diamond	168	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
28814003	28814003	PRJNA526367_P_NODE_37308_length_187_cov_8.862319_g37098_i0	PRJNA526367	37308	187	8.862319	16.57253653	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	100	7.91e-23	NR	MEY3768832.1	2847862	g37098	i0	80	0.962566844919786	60	12	96.3	0	7	186	134	193	MEY3768832.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	180	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29919557	29919557	PRJNA526367_P_NODE_46951_length_171_cov_6.385246_g46741_i0	PRJNA526367	46951	171	6.385246	10.91877066	Oscillatoriales cyanobacterium	1151	Bacteria	Bacteria	100	7.91e-24	NR	TAF51759.1	1151	g46741	i0	92.6	1.89473684210526	54	4	94.7	0	169	8	123	176	TAF51759.1 MAG: phosphoribulokinase [Oscillatoriales cyanobacterium]	diamond	324	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
29951038	29951038	PRJNA526367_P_NODE_51591_length_166_cov_0.871795_g51381_i0	PRJNA526367	51591	166	0.871795	1.4471797	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	88.6	1.66e-19	NR	MBX9673667.1	2364082	g51381	i0	100	0.740963855421687	41	0	74.1	0	164	42	240	280	MBX9673667.1 RDD family protein [Candidatus Obscuribacterales bacterium]	diamond	123	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30250853	30250853	PRJNA526367_P_NODE_24452_length_324_cov_2.065455_g24243_i0	PRJNA526367	24452	324	2.065455	6.6920742	Bacteria	2	Bacteria	Bacteria	70.9	5.33e-12	NR	WP_162398300.1	264686	g24243	i0	41.9	4.7962962962963	105	52	97.2	1	321	7	40	135	WP_162398300.1 cation diffusion facilitator family transporter [Nostoc edaphicum]	diamond	1554	71.6	0.990223463687151	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
30330654	30330654	PRJNA526367_P_NODE_54452_length_163_cov_8.903509_g54242_i0	PRJNA526367	54452	163	8.903509	14.51271967	Dulcicalothrix desertica	32056	Bacteria	Bacteria	94.7	1.7700000000000003e-21	NR	WP_127080777.1	32056	g54242	i0	94.1	1.87730061349693	51	3	93.9	0	9	161	151	201	WP_127080777.1 hypothetical protein [Dulcicalothrix desertica]	diamond	306	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
31373158	31373158	PRJNA526367_P_NODE_2916_length_384_cov_7.167164_g2719_i0	PRJNA526367	2916	384	7.167164	27.52190976	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	52.8	1.84e-5	NR	MEY3767059.1	2847862	g2719	i0	61	0.3203125	41	16	32	0	373	251	107	147	MEY3767059.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	123	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31546547	31546547	PRJNA526367_P_NODE_61536_length_156_cov_4.411215_g61326_i0	PRJNA526367	61536	156	4.411215	6.8814954	Cyanophyceae	3028117	Bacteria	Bacteria	45.1	0.00171	NR	WP_142602732.1	2480795	g61326	i0	48.9	2.78846153846154	47	23	90.4	1	142	2	31	76	WP_142602732.1 hypothetical protein [Pseudanabaena sp. UWO310]	diamond	435	45.4	0.993392070484582	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. UWO310
31657446	31657446	PRJNA526367_P_NODE_5137_length_329_cov_4.517857_g4928_i0	PRJNA526367	5137	329	4.517857	14.86374953	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.3	0.00322	NR	MEY3767675.1	2847862	g4928	i0	73.9	0.209726443768997	23	6	21	0	328	260	39	61	MEY3767675.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	69	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31973962	31973962	PRJNA526367_P_NODE_47558_length_170_cov_9.107438_g47348_i0	PRJNA526367	47558	170	9.107438	15.4826446	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	94.7	5.2599999999999997e-23	NR	MBW4638951.1	2839657	g47348	i0	78.8	0.917647058823529	52	11	91.8	0	167	12	37	88	MBW4638951.1 tryptophan-rich sensory protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	156	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32242674	32242674	PRJNA526367_P_NODE_9278_length_324_cov_3.778182_g9069_i0	PRJNA526367	9278	324	3.778182	12.24130968	Bacteria	2	Bacteria	Bacteria	102	3.0199999999999995e-23	NR	WP_086768748.1	1932667	g9069	i0	80.7	6.42592592592593	57	11	52.8	0	178	8	15	71	WP_086768748.1 aldo/keto reductase [Nostoc sp. 106C]	diamond	2082	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 106C
32779061	32779061	PRJNA526367_P_NODE_20660_length_324_cov_2.381818_g20451_i0	PRJNA526367	20660	324	2.381818	7.71709032	Bacteria	2	Bacteria	Bacteria	89	5.83e-18	NR	NJO76277.1	2720434	g20451	i0	43.8	2.92592592592593	105	33	97.2	1	321	7	332	410	NJO76277.1 diguanylate cyclase [Leptolyngbyaceae cyanobacterium RM1_406_9]	diamond	948	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium RM1_406_9
32827032	32827032	PRJNA526367_P_NODE_41500_length_180_cov_4.900763_g41290_i0	PRJNA526367	41500	180	4.900763	8.8213734	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	93.2	2.66e-20	NR	WP_250121267.1	155894	g41290	i0	77.2	2.85	57	13	95	0	179	9	77	133	WP_250121267.1 sigma 54-interacting transcriptional regulator [Chroococcidiopsis sp. CCMEE 29]	diamond	513	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29

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