metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_phylum = "Cyanobacteriota"

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
2340595	2340595	PRJNA315314_S_NODE_29702_length_155_cov_11.277778_g29381_i0	PRJNA315314	29702	155	11.277778	17.4805559	Synechococcus	1129	Bacteria	Bacteria	209	7.15e-50	NTclustered	gi\|2552542308\|gb\|CP130602.1\|	1140	g29381	i0	90.968	159.741935483871	155	14	100	0	1	155	573493	573339	Synechococcus elongatus PCC 7942 = FACHB-805 strain UTEX 2434 chromosome, complete genome	blastn	24760	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
2931302	2931302	PRJNA315314_S_NODE_12663_length_228_cov_65.185930_g12342_i0	PRJNA315314	12663	228	65.18593	148.6239204	Oscillatoria lutea	212356	Bacteria	Bacteria	394	2.93e-105	NTclustered	gi\|1345606792\|gb\|MG968526.1\|	2081949	g12342	i0	97.807	146.710526315789	228	5	100	0	1	228	701	474	Oscillatoria lutea UTEX B 1814 23S ribosomal RNA gene, partial sequence	blastn	33450	394	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria lutea
4208073	4208073	PRJNA315314_S_NODE_2584_length_493_cov_100.560345_g560_i6	PRJNA315314	2584	493	100.560345	495.76250085	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	577	6.419999999999998e-160	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g560	i6	92.982	135.148073022312	399	23	81	5	1	397	3681200	3680805	Leptolyngbya sp. 7M chromosome	blastn	66628	577	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4208293	4208293	PRJNA315314_S_NODE_7764_length_289_cov_51.950000_g7443_i0	PRJNA315314	7764	289	51.95	150.1355	Nodosilinea nodulosa	416001	Bacteria	Bacteria	466	8.06e-127	NTclustered	gi\|1358126428\|gb\|KY963626.1\|	416010	g7443	i0	96.14	144.076124567474	285	11	99	0	5	289	220	504	Nodosilinea nodulosa UTEX B 2910 23S ribosomal RNA gene, partial sequence	blastn	41638	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
6168051	6168051	PRJNA315314_S_NODE_12385_length_231_cov_2.559406_g12064_i0	PRJNA315314	12385	231	2.559406	5.91222786	Microcoleus	44471	Bacteria	Bacteria	339	1.41e-88	NTclustered	gi\|1519336827\|gb\|MK211228.1\|	2489143	g12064	i0	95.735	127.688311688312	211	7	91	2	1	210	2395	2186	Microcoleus vaginatus KZ-23-1 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	29496	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
6758757	6758757	PRJNA315314_S_NODE_8626_length_275_cov_12.443089_g8305_i0	PRJNA315314	8626	275	12.443089	34.21849475	Oscillatoria lutea	212356	Bacteria	Bacteria	470	5.89e-128	NTclustered	gi\|1345606792\|gb\|MG968526.1\|	2081949	g8305	i0	97.464	111.963636363636	276	6	100	1	1	275	214	489	Oscillatoria lutea UTEX B 1814 23S ribosomal RNA gene, partial sequence	blastn	30790	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria lutea
8033981	8033981	PRJNA315314_S_NODE_1567_length_617_cov_268.015306_g1313_i0	PRJNA315314	1567	617	268.015306	1653.65443802	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	889	0	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g1313	i0	92.707	243.042139384117	617	44	100	1	1	617	175598	176213	Nodosilinea sp. E11 chromosome	blastn	149957	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
8034065	8034065	PRJNA315314_S_NODE_20867_length_181_cov_4.414474_g20546_i0	PRJNA315314	20867	181	4.414474	7.99019794	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g20546	i0	100	0.160220994475138	29	0	16	0	48	76	6182750	6182778	Allocoleopsis franciscana PCC 7113, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
8034105	8034105	PRJNA315314_S_NODE_2327_length_516_cov_95.770021_g560_i3	PRJNA315314	2327	516	95.770021	494.17330836	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	612	1.85e-170	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g560	i3	88.499	155.281007751938	513	49	99	9	6	516	3680696	3681200	Leptolyngbya sp. 7M chromosome	blastn	80125	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
8717878	8717878	PRJNA315314_S_NODE_20067_length_184_cov_9.025806_g19746_i0	PRJNA315314	20067	184	9.025806	16.60748304	Nodosilinea	1120752	Bacteria	Bacteria	318	1.3999999999999995e-82	NTclustered	gi\|1435360276\|gb\|MH688851.1\|	2290992	g19746	i0	97.826	142.413043478261	184	4	100	0	1	184	2484	2301	Nodosilinea cf. epilithica Us-2-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26204	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea epilithica
9993455	9993455	PRJNA315314_S_NODE_25668_length_165_cov_7.529412_g25347_i0	PRJNA315314	25668	165	7.529412	12.4235298	Microcoleus	44471	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|225696244\|gb\|FJ805911.1\|	1211	g25347	i0	100	99.6181818181818	165	0	100	0	1	165	3916	3752	Uncultured cyanobacterium clone AN2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	16437	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10584627	10584627	PRJNA315314_S_NODE_18709_length_190_cov_815.658385_g18388_i0	PRJNA315314	18709	190	815.658385	1549.7509315	Nodosilinea nodulosa	416001	Bacteria	Bacteria	272	1.15e-68	NTclustered	gi\|46409896\|gb\|AY584521.1\|	118166	g18388	i0	92.632	187.584210526316	190	13	100	1	1	190	99	287	Leptolyngbya sp. PCC 7104 23S ribosomal RNA gene, partial sequence	blastn	35641	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
11859338	11859338	PRJNA315314_S_NODE_13170_length_224_cov_13.651282_g12849_i0	PRJNA315314	13170	224	13.651282	30.57887168	Leptodesmis sichuanensis	2906798	Bacteria	Bacteria	342	1.0499999999999999e-89	NTclustered	gi\|2173478203\|gb\|CP075171.1\|	2835870	g12849	i0	94.196	151.236607142857	224	13	100	0	1	224	2233719	2233496	Leptodesmis sichuanensis A121 chromosome, complete genome	blastn	33877	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptodesmis	Leptodesmis sichuanensis
14409525	14409525	PRJNA315314_S_NODE_11932_length_235_cov_5.558252_g11611_i0	PRJNA315314	11932	235	5.558252	13.0618922	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	182	2.57e-41	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g11611	i0	85.311	315.468085106383	177	24	75	2	1	177	3681592	3681766	Leptolyngbya sp. 7M chromosome	blastn	74135	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
14409606	14409606	PRJNA315314_S_NODE_1572_length_616_cov_327.962521_g1318_i0	PRJNA315314	1572	616	327.962521	2020.24912936	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	856	0	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g1318	i0	91.734	232.516233766234	617	49	100	2	1	616	175598	176213	Nodosilinea sp. E11 chromosome	blastn	143230	856	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
15683401	15683401	PRJNA315314_S_NODE_1773_length_583_cov_86.268953_g560_i2	PRJNA315314	1773	583	86.268953	502.94799599	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	625	2.7099999999999993e-174	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g560	i2	88.28	206.493996569468	529	53	90	9	58	583	3680678	3681200	Leptolyngbya sp. 7M chromosome	blastn	120386	625	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17642918	17642918	PRJNA315314_S_NODE_19574_length_186_cov_362.229299_g19253_i0	PRJNA315314	19574	186	362.229299	673.74649614	Bacteria	2	Bacteria	Bacteria	315	1.84e-81	NTclustered	gi\|344050612\|gb\|JN409018.1\|	1211	g19253	i0	97.312	97.5	186	4	99	1	1	185	475	290	Uncultured cyanobacterium clone HG-J0292 16S ribosomal RNA gene, partial sequence	blastn	18135	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17642924	17642924	PRJNA315314_S_NODE_20314_length_183_cov_9.740260_g19993_i0	PRJNA315314	20314	183	9.74026	17.8246758	Nodosilinea	1120752	Bacteria	Bacteria	333	4.97e-87	NTclustered	gi\|1435360276\|gb\|MH688851.1\|	2290992	g19993	i0	99.454	145.950819672131	183	1	100	0	1	183	2483	2301	Nodosilinea cf. epilithica Us-2-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26709	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea epilithica
18232436	18232436	PRJNA315314_S_NODE_18955_length_189_cov_9.693750_g18634_i0	PRJNA315314	18955	189	9.69375	18.3211875	Plectonema terebrans	272135	Bacteria	Bacteria	276	8.84e-70	NTclustered	gi\|46409900\|gb\|AY584525.1\|	272137	g18634	i0	93.085	136.396825396825	188	13	99	0	2	189	1144	957	Plectonema terebrans CCAP 1463/4 23S ribosomal RNA gene, partial sequence	blastn	25779	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema terebrans
18232502	18232502	PRJNA315314_S_NODE_2375_length_512_cov_97.664596_g560_i4	PRJNA315314	2375	512	97.664596	500.04273152	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	669	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g560	i4	90.551	145.9609375	508	44	99	4	6	512	3680696	3681200	Leptolyngbya sp. 7M chromosome	blastn	74732	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
18916730	18916730	PRJNA315314_S_NODE_19575_length_186_cov_257.031847_g19254_i0	PRJNA315314	19575	186	257.031847	478.07923542	Pleurocapsales	52604	Bacteria	Bacteria	327	2.36e-85	NTclustered	gi\|440337481\|gb\|KC110334.1\|	1211	g19254	i0	98.396	100.333333333333	187	2	100	1	1	186	231	45	Uncultured cyanobacterium clone CW1_P1_4E 16S ribosomal RNA gene, partial sequence	blastn	18662	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20191470	20191470	PRJNA315314_S_NODE_7596_length_292_cov_146.642586_g7275_i0	PRJNA315314	7596	292	146.642586	428.19635112	Cyanophyceae	3028117	Bacteria	Bacteria	508	1.34e-139	NTclustered	gi\|1345606797\|gb\|MG968531.1\|	129975	g7275	i0	98.276	131.304794520548	290	5	99	0	3	292	766	477	Arthrospira platensis PCC 7345 23S ribosomal RNA gene, partial sequence	blastn	38341	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
22742237	22742237	PRJNA315314_S_NODE_9978_length_256_cov_7.488987_g9657_i0	PRJNA315314	9978	256	7.488987	19.17180672	Cephalothrix	166041	Bacteria	Bacteria	436	5.5e-118	NTclustered	gi\|685430689\|gb\|KJ994516.1\|	1539061	g9657	i0	99.582	89.421875	239	1	93	0	18	256	239	1	Cephalothrix komarekiana CCIBt 3523 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22892	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Cephalothrix	Cephalothrix komarekiana
25291371	25291371	PRJNA315314_S_NODE_13840_length_219_cov_11.021053_g13519_i0	PRJNA315314	13840	219	11.021053	24.13610607	Lusitaniella	1983104	Bacteria	Bacteria	339	1.33e-88	NTclustered	gi\|940620469\|gb\|KR676349.1\|	945739	g13519	i0	94.521	142.045662100457	219	12	100	0	1	219	3816	3598	Lusitaniella coriacea LEGE 07167 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31108	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Lusitaniellaceae	Lusitaniella	Lusitaniella coriacea
25291475	25291475	PRJNA315314_S_NODE_30620_length_153_cov_1763.725806_g30299_i0	PRJNA315314	30620	153	1763.725806	2698.50048318	Cyanophyceae	3028117	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|485099134\|ref\|NR_102529.1\|	111780	g30299	i0	99.346	182.313725490196	153	1	100	0	1	153	1852	2004	Stanieria cyanosphaera PCC 7437 strain PCC 7437 23S ribosomal RNA, complete sequence	blastn	27894	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera

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