metadata: contig_metadata: 28 rows where bioproject = "PRJNA1126198" and tax_clade = "Cyanobacteriota/Melainabacteria group"

28 rows where bioproject = "PRJNA1126198" 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
2305850	2305850	PRJNA1126198_P_NODE_48342_length_401_cov_1.353659_g47625_i0	PRJNA1126198	48342	401	1.353659	5.42817259	Oscillatoriales	1150	Bacteria	Bacteria	730	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g47625	i0	99.501	139.985037406484	401	2	100	0	1	401	1584	1184	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	56134	730	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3581058	3581058	PRJNA1126198_P_NODE_443043_length_244_cov_1.789474_g442322_i0	PRJNA1126198	443043	244	1.789474	4.36631656	root	1	Root_unresolved	Root_unresolved	363	8.949999999999999e-96	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g442322	i0	100	101.639344262295	196	0	99	0	1	196	295	490	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	24800	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7934646	7934646	PRJNA1126198_P_NODE_419767_length_247_cov_0.879310_g419046_i0	PRJNA1126198	419767	247	0.87931	2.1718957	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g419046	i0	97.788	1.29554655870445	226	5	91	0	22	247	5573667	5573892	Anabaena sp. YBS01 chromosome, complete genome	blastn	320	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
8683399	8683399	PRJNA1126198_P_NODE_202867_length_291_cov_5.756881_g202147_i0	PRJNA1126198	202867	291	5.756881	16.75252371	Oscillatoriales	1150	Bacteria	Bacteria	532	7.9e-147	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g202147	i0	99.656	144.676975945017	291	1	100	0	1	291	1237	947	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	42101	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
10485070	10485070	PRJNA1126198_P_NODE_381689_length_250_cov_1.847458_g380968_i0	PRJNA1126198	381689	250	1.847458	4.618645	Aliterella chasmolithica	2739056	Bacteria	Bacteria	411	3.239999999999999e-110	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g380968	i0	99.123	157.956	228	2	91	0	1	228	2273	2500	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39489	411	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
11233674	11233674	PRJNA1126198_P_NODE_259349_length_275_cov_3.153465_g258628_i0	PRJNA1126198	259349	275	3.153465	8.67202875	Oscillatoria	1158	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g258628	i0	100	100.003636363636	275	0	100	0	1	275	4	278	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	27501	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11233917	11233917	PRJNA1126198_P_NODE_5229_length_773_cov_3.360000_g4632_i0	PRJNA1126198	5229	773	3.36	25.9728	Chroococcidiopsis	54298	Bacteria	Bacteria	1190	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g4632	i0	94.459	104.941785252264	776	38	99	5	2	773	794243	795017	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	81120	1199	0.992493744787323	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
11759656	11759656	PRJNA1126198_P_NODE_13690_length_543_cov_5.353191_g13009_i0	PRJNA1126198	13690	543	5.353191	29.06782713	Cyanobium sp. ARS6	2024869	Bacteria	Bacteria	219	1.28e-69	NR	CAI8350359.1	2024869	g13009	i0	70.3	2.45303867403315	148	44	81.8	0	508	65	46	193	CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6]	diamond	1332	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ARS6
11759723	11759723	PRJNA1126198_P_NODE_173070_length_303_cov_1.265217_g172350_i0	PRJNA1126198	173070	303	1.265217	3.83360751	uncultured cyanobacterium	1211	Bacteria	Bacteria	484	2.3499999999999998e-132	NTclustered	gi\|389547676\|gb\|JQ402604.1\|	1211	g172350	i0	98.893	103.732673267327	271	3	89	0	33	303	1	271	Uncultured cyanobacterium clone CNY_03005 16S ribosomal RNA gene, partial sequence	blastn	31431	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11759762	11759762	PRJNA1126198_P_NODE_190770_length_296_cov_1.260090_g190050_i0	PRJNA1126198	190770	296	1.26009	3.7298664	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.0599999999999996e-114	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g190050	i0	93.08	114.547297297297	289	20	98	0	8	296	1921	1633	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33906	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13035126	13035126	PRJNA1126198_P_NODE_318851_length_261_cov_2.053191_g318130_i0	PRJNA1126198	318851	261	2.053191	5.35882851	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	124	6.879999999999999e-34	NR	WP_036481693.1	1541065	g318130	i0	64	18.6091954022989	86	31	98.9	0	260	3	17	102	WP_036481693.1 2-C-methyl-D-erythritol 2,4-cyclodiphosphate synthase [Myxosarcina sp. GI1]	diamond	4857	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. GI1
13783530	13783530	PRJNA1126198_P_NODE_185331_length_298_cov_1.368889_g184611_i0	PRJNA1126198	185331	298	1.368889	4.07928922	root	1	Root_unresolved	Root_unresolved	551	2.239999999999999e-152	NTclustered	gi\|151349732\|gb\|EF662441.1\|	1211	g184611	i0	100	109.986577181208	298	0	100	0	1	298	810	513	Uncultured cyanobacterium clone GASP-MA1S2_D03 16S ribosomal RNA gene, partial sequence	blastn	32776	551	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14310204	14310204	PRJNA1126198_P_NODE_268332_length_273_cov_1.740000_g267611_i0	PRJNA1126198	268332	273	1.74	4.7502	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	333	7.989999999999999e-87	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g267611	i0	89.259	135.322344322344	270	24	98	3	6	272	2200	2467	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36943	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
17608174	17608174	PRJNA1126198_P_NODE_464114_length_242_cov_1.822485_g463393_i0	PRJNA1126198	464114	242	1.822485	4.4104137	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g463393	i0	100	7.72727272727273	32	0	13	0	132	163	2768753	2768722	Cylindrospermum stagnale PCC 7417, complete genome	blastn	1870	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
20682704	20682704	PRJNA1126198_P_NODE_232417_length_283_cov_1.176190_g231696_i0	PRJNA1126198	232417	283	1.17619	3.3286177	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	366	8.21e-97	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g231696	i0	90.175	108.088339222615	285	23	99	5	2	283	3200	2918	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30589	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20682800	20682800	PRJNA1126198_P_NODE_281397_length_270_cov_1.563452_g280676_i0	PRJNA1126198	281397	270	1.563452	4.2213204	Cyanobium gracile	59930	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g280676	i0	100	0.103703703703704	28	0	10	0	232	259	3220364	3220391	Cyanobium gracile PCC 6307, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
21432188	21432188	PRJNA1126198_P_NODE_224997_length_285_cov_1.325472_g224276_i0	PRJNA1126198	224997	285	1.325472	3.7775952	Nostocaceae	1162	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g224276	i0	100	165.677192982456	285	0	100	0	1	285	3059667	3059951	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	47218	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
23233449	23233449	PRJNA1126198_P_NODE_162179_length_307_cov_2.260684_g161460_i0	PRJNA1126198	162179	307	2.260684	6.94029988	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	484	2.3799999999999994e-132	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g161460	i0	95.13	105.055374592834	308	14	100	1	1	307	2118	2425	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	32252	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
27533345	27533345	PRJNA1126198_P_NODE_428123_length_246_cov_0.895954_g427402_i0	PRJNA1126198	428123	246	0.895954	2.20404684	Nostocales	1161	Bacteria	Bacteria	111	3.8500000000000006e-27	NR	WP_096595365.1	1954171	g427402	i0	65.9	2	82	28	100	0	246	1	156	237	WP_096595365.1 hypothetical protein [Calothrix sp. NIES-2098]	diamond	492	112	0.991071428571429	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2098
28270212	28270212	PRJNA1126198_P_NODE_101446_length_341_cov_2.518657_g100727_i0	PRJNA1126198	101446	341	2.518657	8.58862037	Cyanobacteria bacterium SBC	2821503	Bacteria	Bacteria	139	6.829999999999999e-40	NR	MBP0003062.1	2821503	g100727	i0	61.2	13.108504398827	98	38	86.2	0	47	340	8	105	MBP0003062.1 phosphoribosyl-AMP cyclohydrolase [Cyanobacteria bacterium SBC]	diamond	4470	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SBC
28333553	28333553	PRJNA1126198_P_NODE_401406_length_248_cov_1.782857_g400685_i0	PRJNA1126198	401406	248	1.782857	4.42148536	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	81.6	4.21e-17	NR	MBL8086383.1	2711154	g400685	i0	73.6	0.641129032258065	53	14	64.1	0	236	78	92	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	159	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
30544260	30544260	PRJNA1126198_P_NODE_422793_length_246_cov_1.710983_g422072_i0	PRJNA1126198	422793	246	1.710983	4.20901818	Limnospira platensis	118562	Bacteria	Bacteria	62.8	4.79e-10	NR	MDV7395346.1	3080829	g422072	i0	88.2	0.414634146341463	34	4	41.5	0	192	91	1	34	MDV7395346.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	102	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
30733742	30733742	PRJNA1126198_P_NODE_387994_length_250_cov_0.875706_g387273_i0	PRJNA1126198	387994	250	0.875706	2.189265	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	120	8.39e-31	NR	MCA0314599.1	2052166	g387273	i0	95.2	0.744	62	3	74.4	0	65	250	1	62	MCA0314599.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium]	diamond	186	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30765390	30765390	PRJNA1126198_P_NODE_422074_length_246_cov_1.791908_g421353_i0	PRJNA1126198	422074	246	1.791908	4.40809368	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	158	1.58e-44	NR	MBN8658814.1	1906157	g421353	i0	97.5	0.975609756097561	80	2	97.6	0	242	3	1	80	MBN8658814.1 amidohydrolase family protein [Candidatus Obscuribacter phosphatis]	diamond	240	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
31671235	31671235	PRJNA1126198_P_NODE_412977_length_247_cov_1.522989_g412256_i0	PRJNA1126198	412977	247	1.522989	3.76178283	Microcystis	1125	Bacteria	Bacteria	55.5	1.33e-6	NR	WP_272081035.1	1126	g412256	i0	52.8	28.7246963562753	72	27	86.2	2	241	29	741	806	WP_272081035.1 beta strand repeat-containing protein [Microcystis aeruginosa]	diamond	7095	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31734336	31734336	PRJNA1126198_P_NODE_435997_length_245_cov_0.906977_g435276_i0	PRJNA1126198	435997	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	158	4.59e-45	NR	HAJ60538.1	2055766	g435276	i0	90.1	1.98367346938776	81	8	99.2	0	245	3	131	211	HAJ60538.1 glycosyl transferase, UDP-glucuronosyltransferase [Cyanobacteria bacterium UBA8543]	diamond	486	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA8543
32473308	32473308	PRJNA1126198_P_NODE_339339_length_257_cov_1.467391_g338618_i0	PRJNA1126198	339339	257	1.467391	3.77119487	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	175	4.87e-53	NR	MBX9672098.1	2364082	g338618	i0	98.8	0.992217898832685	85	1	99.2	0	256	2	129	213	MBX9672098.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	255	175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32725501	32725501	PRJNA1126198_P_NODE_358420_length_253_cov_1.588889_g357699_i0	PRJNA1126198	358420	253	1.588889	4.01988917	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	164	3.47e-46	NR	MCA0316296.1	2052166	g357699	i0	100	0.99604743083004	84	0	99.6	0	253	2	338	421	MCA0316296.1 GntR family transcriptional regulator [Candidatus Melainabacteria bacterium]	diamond	252	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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