metadata: contig_metadata: 26 rows where bioproject = "PRJEB39269" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where bioproject = "PRJEB39269" 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
57104	57104	PRJEB39269_P_NODE_62061_length_175_cov_2.323529_g61656_i0	PRJEB39269	62061	175	2.323529	4.06617575	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	90.5	2.26e-19	NR	MBW4538427.1	1601998	g61656	i0	70.7	6.96	58	17	99.4	0	175	2	520	577	MBW4538427.1 amino acid adenylation domain-containing protein [Myxacorys chilensis ATA2-1-KO14]	diamond	1218	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys chilensis
989209	989209	PRJEB39269_P_NODE_33701_length_238_cov_1.497487_g33296_i0	PRJEB39269	33701	238	1.497487	3.56401906	Microcoleus	44471	Bacteria	Bacteria	429	8.45e-116	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g33296	i0	99.16	127.021008403361	238	2	100	0	1	238	3173	2936	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	30231	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
989262	989262	PRJEB39269_P_NODE_86621_length_153_cov_4.719298_g86216_i0	PRJEB39269	86621	153	4.719298	7.22052594	Nostoc	1177	Bacteria	Bacteria	143	7.23e-30	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g86216	i0	83.929	14.1437908496732	168	8	97	7	1	149	3206304	3206471	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	2164	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
1331402	1331402	PRJEB39269_P_NODE_91362_length_150_cov_1.477477_g90957_i0	PRJEB39269	91362	150	1.477477	2.2162155	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	261	1.86e-65	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g90957	i0	98	12.6266666666667	150	3	100	0	1	150	2150594	2150445	Leptolyngbya sp. 7M chromosome	blastn	1894	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
2606977	2606977	PRJEB39269_P_NODE_37163_length_226_cov_1.491979_g36758_i0	PRJEB39269	37163	226	1.491979	3.37187254	Phormidium nigroviride	482564	Bacteria	Bacteria	399	6.239999999999999e-107	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g36758	i0	98.667	137.938053097345	225	3	99	0	1	225	206	430	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	31174	399	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
2607005	2607005	PRJEB39269_P_NODE_73103_length_165_cov_0.976190_g72698_i0	PRJEB39269	73103	165	0.97619	1.6107135	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	98.6	3.5e-23	NR	WP_022603964.1	582514	g72698	i0	79.6	9.8	54	11	98.2	0	163	2	123	176	WP_022603964.1 polyphosphate kinase 2 family protein [Rubidibacter lacunae]	diamond	1617	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rubidibacter	Rubidibacter lacunae
3539750	3539750	PRJEB39269_P_NODE_13223_length_385_cov_11.164740_g12818_i0	PRJEB39269	13223	385	11.16474	42.984249	Nostoc	1177	Bacteria	Bacteria	501	3.039999999999999e-137	NTclustered	gi\|312985538\|gb\|HQ189049.1\|	1211	g12818	i0	90.206	78.9844155844156	388	32	100	6	1	385	499	883	Uncultured cyanobacterium clone B108210C 16S ribosomal RNA gene, partial sequence	blastn	30409	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6092362	6092362	PRJEB39269_P_NODE_6745_length_525_cov_3.878601_g6361_i0	PRJEB39269	6745	525	3.878601	20.36265525	Oscillatoriales	1150	Bacteria	Bacteria	856	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g6361	i0	96.381	155.11619047619	525	10	100	5	1	525	2241	2756	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	81436	861	0.994192799070848	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8984149	8984149	PRJEB39269_P_NODE_65488_length_171_cov_1.553030_g65083_i0	PRJEB39269	65488	171	1.55303	2.6556813	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	101	9.34e-24	NR	MEI6371988.1	3064516	g65083	i0	82.1	0.982456140350877	56	10	98.2	0	3	170	174	229	MEI6371988.1 NADH-quinone oxidoreductase subunit D [Nostocales cyanobacterium ELA608]	diamond	168	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
8984190	8984190	PRJEB39269_P_NODE_83128_length_156_cov_2.726496_g82723_i0	PRJEB39269	83128	156	2.726496	4.25333376	Nostoc sphaeroides	446679	Bacteria	Bacteria	132	1.6e-26	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g82723	i0	96.25	3.91666666666667	80	3	51	0	1	80	4737194	4737115	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	611	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
10259835	10259835	PRJEB39269_P_NODE_56929_length_182_cov_11.727273_g56524_i0	PRJEB39269	56929	182	11.727273	21.34363686	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g56524	i0	100	0.153846153846154	28	0	15	0	74	101	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
12810565	12810565	PRJEB39269_P_NODE_20831_length_307_cov_3.776119_g20426_i0	PRJEB39269	20831	307	3.776119	11.59268533	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	425	1.47e-114	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g20426	i0	91.64	212.436482084691	311	20	100	5	1	307	2054604	2054912	Leptolyngbya sp. 7M chromosome	blastn	65218	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
12810604	12810604	PRJEB39269_P_NODE_67211_length_170_cov_2.694656_g66806_i0	PRJEB39269	67211	170	2.694656	4.5809152	Spirulina sp.	1157	Bacteria	Bacteria	65.5	2.65e-11	NR	WP_323225406.1	3110248	g66806	i0	87.1	0.547058823529412	31	4	54.7	0	95	3	101	131	WP_323225406.1 DNA-primase RepB domain-containing protein, partial [Spirulina sp. 06S082]	diamond	93	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. 06S082
14085361	14085361	PRJEB39269_P_NODE_59832_length_178_cov_2.273381_g59427_i0	PRJEB39269	59832	178	2.273381	4.04661818	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	285	1.3599999999999998e-72	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g59427	i0	95.531	186.550561797753	179	7	100	1	1	178	2152357	2152179	Leptolyngbya sp. 7M chromosome	blastn	33206	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
16291914	16291914	PRJEB39269_P_NODE_37873_length_223_cov_9.630435_g37468_i0	PRJEB39269	37873	223	9.630435	21.47587005	Nostoc	1177	Bacteria	Bacteria	405	1.32e-108	NTclustered	gi\|470483128\|ref\|NR_076575.1\|	63737	g37468	i0	99.55	262.313901345291	222	1	99	0	1	222	324	545	Nostoc punctiforme PCC 73102 strain PCC 73102 23S ribosomal RNA gene, complete sequence	blastn	58496	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
18840936	18840936	PRJEB39269_P_NODE_52055_length_190_cov_2.516556_g51650_i0	PRJEB39269	52055	190	2.516556	4.7814564	Nostoc	1177	Bacteria	Bacteria	333	5.209999999999999e-87	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g51650	i0	98.413	177.568421052632	189	3	99	0	2	190	5293239	5293051	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	33738	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
23009111	23009111	PRJEB39269_P_NODE_57739_length_181_cov_2.288732_g57334_i0	PRJEB39269	57739	181	2.288732	4.14260492	Oscillatoria sp. 2.1A	2876722	Bacteria	Bacteria	318	1.37e-82	NTclustered	gi\|2095813707\|gb\|OK161270.1\|	2876722	g57334	i0	98.343	110.28729281768	181	3	100	0	1	181	3469	3649	Oscillatoria sp. 2.1A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19962	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. 2.1A
25215339	25215339	PRJEB39269_P_NODE_22200_length_297_cov_8.472868_g21795_i0	PRJEB39269	22200	297	8.472868	25.16441796	Nostoc	1177	Bacteria	Bacteria	521	1.7499999999999996e-143	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g21795	i0	98.316	300.545454545455	297	5	100	0	1	297	56571	56867	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	89262	521	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
27949406	27949406	PRJEB39269_P_NODE_77745_length_160_cov_1.669421_g77340_i0	PRJEB39269	77745	160	1.669421	2.6710736	Chlorogloeopsis sp. ULAP	28069	Bacteria	Bacteria	58.9	1.6e-8	NR	WP_341994077.1	3107926	g77340	i0	46.2	1.8	52	28	97.5	0	4	159	101	152	WP_341994077.1 TIGR04255 family protein [Chlorogloeopsis sp. ULAP02]	diamond	288	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis sp. ULAP02
28226680	28226680	PRJEB39269_P_NODE_62946_length_174_cov_1.822222_g62541_i0	PRJEB39269	62946	174	1.822222	3.17066628	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	95.1	5.15e-21	NR	HVO23940.1	2053573	g62541	i0	75.4	1.96551724137931	57	14	98.3	0	3	173	693	749	HVO23940.1 TonB-dependent receptor [Candidatus Margulisiibacteriota bacterium]	diamond	342	95.9	0.991657977059437	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28353219	28353219	PRJEB39269_P_NODE_67106_length_170_cov_2.763359_g66701_i0	PRJEB39269	67106	170	2.763359	4.6977103	Bacillati	1783272	Bacteria	Bacteria	53.1	2.3e-6	NR	MBI2810935.1	2052166	g66701	i0	96.2	1.83529411764706	26	1	45.9	0	168	91	65	90	MBI2810935.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	312	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28612467	28612467	PRJEB39269_P_NODE_84367_length_155_cov_2.525862_g83962_i0	PRJEB39269	84367	155	2.525862	3.9150861	Cylindrospermopsis raciborskii	77022	Bacteria	Bacteria	101	2.09e-26	NR	MBA4444480.1	2585138	g83962	i0	84.3	0.987096774193548	51	8	98.7	0	153	1	26	76	MBA4444480.1 hypothetical protein [Cylindrospermopsis raciborskii CS-506_C]	diamond	153	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
28801661	28801661	PRJEB39269_P_NODE_31368_length_247_cov_1.846154_g30963_i0	PRJEB39269	31368	247	1.846154	4.56000038	Alkalinema sp. FACHB-956	2692768	Bacteria	Bacteria	91.3	3.4e-19	NR	WP_190574486.1	2692768	g30963	i0	57.3	0.995951417004049	82	35	99.6	0	1	246	1191	1272	WP_190574486.1 SpvB/TcaC N-terminal domain-containing protein [Alkalinema sp. FACHB-956]	diamond	246	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. FACHB-956
30349850	30349850	PRJEB39269_P_NODE_43512_length_208_cov_1.455621_g43107_i0	PRJEB39269	43512	208	1.455621	3.02769168	Prochlorococcus	1218	Bacteria	Bacteria	53.1	5.03e-6	NR	WP_152557473.1	1218	g43107	i0	36.2	1.96153846153846	69	44	99.5	0	208	2	235	303	WP_152557473.1 MULTISPECIES: hypothetical protein [Prochlorococcus]	diamond	408	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus
30349856	30349856	PRJEB39269_P_NODE_81972_length_157_cov_2.059322_g81567_i0	PRJEB39269	81972	157	2.059322	3.23313554	Cyanobacteria bacterium J06649_5	3023235	Bacteria	Bacteria	79.3	1.27e-15	NR	MEO0708174.1	3023235	g81567	i0	70	0.955414012738854	50	15	95.5	0	152	3	113	162	MEO0708174.1 WD40 repeat domain-containing protein [Cyanobacteria bacterium J06649_5]	diamond	150	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06649_5
32024864	32024864	PRJEB39269_P_NODE_57918_length_181_cov_1.549296_g57513_i0	PRJEB39269	57918	181	1.549296	2.80422576	Cyanophyceae	3028117	Bacteria	Bacteria	75.9	3.31e-14	NR	WP_190454056.1	3028117	g57513	i0	62.7	0.977900552486188	59	22	97.8	0	3	179	1438	1496	WP_190454056.1 MULTISPECIES: PAS domain S-box protein [Cyanophyceae]	diamond	177	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae

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