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

26 rows where analysis = "blastn", bioproject = "PRJNA495391" 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
476210	476210	PRJNA495391_S_NODE_28341_length_227_cov_1.473958_g27289_i0	PRJNA495391	28341	227	1.473958	3.34588466	uncultured cyanobacterium	1211	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g27289	i0	100	0.251101321585903	29	0	13	0	104	132	1748239	1748211	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	57	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1107148	1107148	PRJNA495391_S_NODE_32041_length_214_cov_36.731844_g30989_i0	PRJNA495391	32041	214	36.731844	78.60614616	Nodularia	159191	Bacteria	Bacteria	363	7.669999999999997e-96	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g30989	i0	97.196	286.738317757009	214	6	100	0	1	214	2506848	2506635	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	61362	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1107525	1107525	PRJNA495391_S_NODE_63381_length_157_cov_12.204918_g62329_i0	PRJNA495391	63381	157	12.204918	19.16172126	Leptolyngbyaceae	1890438	Bacteria	Bacteria	261	1.98e-65	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g62329	i0	96.815	207.114649681529	157	3	99	2	2	157	19241	19396	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	32517	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
1750725	1750725	PRJNA495391_S_NODE_15542_length_304_cov_1.453532_g14490_i0	PRJNA495391	15542	304	1.453532	4.41873728	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	494	3.92e-135	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g14490	i0	96.346	156.434210526316	301	10	99	1	4	304	173814	174113	Nodosilinea sp. E11 chromosome	blastn	47556	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
2383302	2383302	PRJNA495391_S_NODE_7462_length_445_cov_26.409756_g6411_i0	PRJNA495391	7462	445	26.409756	117.5234142	Leptolyngbyaceae	1890438	Bacteria	Bacteria	684	0	NTclustered	gi\|225696245\|gb\|FJ805912.1\|	1211	g6411	i0	94.395	172.65393258427	446	24	100	1	1	445	2693	2248	Uncultured cyanobacterium clone AN2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	76831	689	0.992743105950653	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3028281	3028281	PRJNA495391_S_NODE_9503_length_391_cov_28.407303_g8451_i0	PRJNA495391	9503	391	28.407303	111.07255473	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	601	2.9599999999999992e-167	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g8451	i0	94.373	199.46547314578	391	22	100	0	1	391	1243069	1243459	Calothrix sp. NIES-4101 DNA, complete genome	blastn	77991	601	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
3658242	3658242	PRJNA495391_S_NODE_18643_length_277_cov_21.958678_g17591_i0	PRJNA495391	18643	277	21.958678	60.82553806	Cyanophyceae	3028117	Bacteria	Bacteria	429	1.0099999999999999e-115	NTclustered	gi\|146740638\|emb\|AM709625.1\|	317619	g17591	i0	94.909	210.685920577617	275	13	99	1	1	275	3067	2794	Prochlorothrix hollandica SAG 10.89 partial ribosomal RNA operon, strain SAG 10.89	blastn	58360	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix hollandica
3658915	3658915	PRJNA495391_S_NODE_8523_length_414_cov_26.852243_g7472_i0	PRJNA495391	8523	414	26.852243	111.16828602	Cyanophyceae	3028117	Bacteria	Bacteria	715	0	NTclustered	gi\|1345606782\|gb\|MG968516.1\|	2081952	g7472	i0	97.826	164.082125603865	414	9	100	0	1	414	107	520	Phormidium sp. UTEX B EE30 23S ribosomal RNA gene, partial sequence	blastn	67930	715	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. UTEX B EE30
4303113	4303113	PRJNA495391_S_NODE_31624_length_216_cov_1.602210_g30572_i0	PRJNA495391	31624	216	1.60221	3.4607736	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	172	1.4e-38	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g30572	i0	82.178	0.935185185185185	202	34	93	2	1	201	1710230	1710030	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	202	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
4303393	4303393	PRJNA495391_S_NODE_4204_length_617_cov_40.094502_g3197_i0	PRJNA495391	4204	617	40.094502	247.38307734	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	955	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3197	i0	94.652	175.102106969206	617	31	99	2	2	617	2056189	2055574	Leptolyngbya sp. 7M chromosome	blastn	108038	955	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6853478	6853478	PRJNA495391_S_NODE_16986_length_290_cov_49.172549_g15934_i0	PRJNA495391	16986	290	49.172549	142.6003921	Spirirestis rafaelensis	293980	Bacteria	Bacteria	483	8.039999999999998e-132	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g15934	i0	96.587	256.879310344828	293	7	100	2	1	290	496	204	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	74495	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
7485218	7485218	PRJNA495391_S_NODE_23806_length_246_cov_12.222749_g22754_i0	PRJNA495391	23806	246	12.222749	30.06796254	Cyanophyceae	3028117	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|1345606797\|gb\|MG968531.1\|	129975	g22754	i0	99.187	134.345528455285	246	2	100	0	1	246	472	717	Arthrospira platensis PCC 7345 23S ribosomal RNA gene, partial sequence	blastn	33049	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
9403698	9403698	PRJNA495391_S_NODE_13168_length_329_cov_47.391156_g12116_i0	PRJNA495391	13168	329	47.391156	155.91690324	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	564	3.2199999999999995e-156	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g12116	i0	97.568	121.41641337386	329	8	100	0	1	329	2496	2168	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39946	564	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10679325	10679325	PRJNA495391_S_NODE_11429_length_354_cov_8.175549_g10377_i0	PRJNA495391	11429	354	8.175549	28.94144346	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	577	4.469999999999999e-160	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g10377	i0	96.045	160.161016949153	354	14	100	0	1	354	1985	1632	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56697	577	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11955746	11955746	PRJNA495391_S_NODE_61270_length_160_cov_1.272000_g60218_i0	PRJNA495391	61270	160	1.272	2.0352	Nostoc flagelliforme	1306274	Bacteria	Bacteria	167	4.5399999999999995e-37	NTclustered	gi\|1297085807\|gb\|CP024793.1\|	2038116	g60218	i0	87.248	0.93125	149	16	92	2	14	160	505988	505841	Nostoc flagelliforme CCNUN1 plasmid pNFSY08, complete sequence	blastn	149	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
12586019	12586019	PRJNA495391_S_NODE_19510_length_271_cov_42.097458_g18458_i0	PRJNA495391	19510	271	42.097458	114.08411118	Cyanophyceae	3028117	Bacteria	Bacteria	462	9.69e-126	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g18458	i0	97.417	108.158671586716	271	7	100	0	1	271	2863	2593	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	29311	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14505519	14505519	PRJNA495391_S_NODE_52552_length_171_cov_1.529412_g51500_i0	PRJNA495391	52552	171	1.529412	2.61529452	Gloeothece verrucosa	2546359	Bacteria	Bacteria	279	6.03e-71	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g51500	i0	96.491	177.397660818713	171	3	100	1	1	171	1626630	1626463	Cyanothece sp. PCC 7822, complete genome	blastn	30335	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
15779456	15779456	PRJNA495391_S_NODE_5293_length_540_cov_8.073267_g4266_i0	PRJNA495391	5293	540	8.073267	43.5956418	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	780	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g4266	i0	93.384	105.361111111111	529	32	98	3	14	540	1614	2141	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	56895	780	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16409803	16409803	PRJNA495391_S_NODE_21373_length_259_cov_9.040179_g20321_i0	PRJNA495391	21373	259	9.040179	23.41406361	Chroococcidiopsis	54298	Bacteria	Bacteria	370	5.73e-98	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g20321	i0	93.6	143.660231660232	250	13	96	3	12	259	795432	795184	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	37208	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
19601775	19601775	PRJNA495391_S_NODE_17576_length_286_cov_1.669323_g16524_i0	PRJNA495391	17576	286	1.669323	4.77426378	Nostoc sp. PCC 7107	317936	Bacteria	Bacteria	196	1.15e-45	NTclustered	gi\|427357970\|gb\|CP003548.1\|	317936	g16524	i0	81.048	0.867132867132867	248	45	86	2	1	247	5229061	5229307	Nostoc sp. PCC 7107, complete genome	blastn	248	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
19602143	19602143	PRJNA495391_S_NODE_31396_length_216_cov_45.000000_g30344_i0	PRJNA495391	31396	216	45	97.2	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	363	7.749999999999998e-96	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g30344	i0	96.789	151.138888888889	218	5	100	1	1	216	2408	2191	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32646	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20877850	20877850	PRJNA495391_S_NODE_24657_length_242_cov_26.922705_g23605_i0	PRJNA495391	24657	242	26.922705	65.1529461	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	396	8.739999999999996e-106	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g23605	i0	96.296	285.00826446281	243	6	100	3	1	242	3354	3114	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	68972	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
20878190	20878190	PRJNA495391_S_NODE_36197_length_203_cov_1.523810_g35145_i0	PRJNA495391	36197	203	1.52381	3.0933343	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	159	1.01e-34	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g35145	i0	81.313	16.0147783251232	198	35	97	2	3	199	5416691	5416887	Nostoc sp. PCC 7524, complete genome	blastn	3251	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
20878650	20878650	PRJNA495391_S_NODE_5277_length_541_cov_10.907115_g4251_i0	PRJNA495391	5277	541	10.907115	59.00749215	Nostoc sp. C117	3349875	Bacteria	Bacteria	806	0	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g4251	i0	94.162	305.97966728281	531	27	98	4	13	541	147052	147580	Nostoc sp. C117 chromosome, complete genome	blastn	165535	806	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
23429200	23429200	PRJNA495391_S_NODE_51839_length_172_cov_1.547445_g50787_i0	PRJNA495391	51839	172	1.547445	2.6616054	Microcoleus vaginatus	119532	Bacteria	Bacteria	132	1.8e-26	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g50787	i0	81.287	32.1976744186046	171	25	98	7	5	172	102109	101943	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	5538	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
24701942	24701942	PRJNA495391_S_NODE_2140_length_950_cov_3.424044_g1284_i0	PRJNA495391	2140	950	3.424044	32.528418	Planktothricoides raciborskii	132608	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g1284	i0	100	0.0315789473684211	30	0	3	0	909	938	7128167	7128138	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii

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