metadata: contig_metadata: 22 rows where bioproject = "PRJNA577226" and tax_clade = "Cyanobacteriota/Melainabacteria group"

22 rows where bioproject = "PRJNA577226" 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
561585	561585	PRJNA577226_S_NODE_25281_length_249_cov_10.264151_g24342_i0	PRJNA577226	25281	249	10.264151	25.55773599	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g24342	i0	90.98	88.7469879518072	255	17	100	5	1	249	4983943	4983689	Leptolyngbya sp. 7M chromosome	blastn	22098	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
2413136	2413136	PRJNA577226_S_NODE_71282_length_150_cov_18.318584_g70343_i0	PRJNA577226	71282	150	18.318584	27.477876	root	1	Root_unresolved	Root_unresolved	278	1.85e-70	NTclustered	gi\|2676011752\|gb\|PP344484.1\|	1211	g70343	i0	100	99.8733333333333	150	0	100	0	1	150	162	13	Uncultured cyanobacterium clone OTU1273_spo1168 16S ribosomal RNA gene, partial sequence	blastn	14981	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2413177	2413177	PRJNA577226_S_NODE_9602_length_426_cov_19.462725_g8666_i0	PRJNA577226	9602	426	19.462725	82.9112085	Nostoc	1177	Bacteria	Bacteria	621	2.4999999999999994e-173	NTclustered	gi\|470483128\|ref\|NR_076575.1\|	63737	g8666	i0	93.023	282.870892018779	430	22	100	7	1	426	1128	703	Nostoc punctiforme PCC 73102 strain PCC 73102 23S ribosomal RNA gene, complete sequence	blastn	120503	625	0.9936	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
4965290	4965290	PRJNA577226_S_NODE_2224_length_1223_cov_25.064924_g1277_i1	PRJNA577226	2224	1223	25.064924	306.54402052	Gloeocapsopsis	693222	Bacteria	Bacteria	1742	0	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g1277	i1	92.484	122.640228945217	1224	82	100	9	1	1223	4122	2908	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	149989	1742	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
5665381	5665381	PRJNA577226_S_NODE_32085_length_220_cov_2.273224_g31146_i0	PRJNA577226	32085	220	2.273224	5.0010928	Halothece sp. PCC 7418	65093	Bacteria	Bacteria	106	1.47e-18	NTclustered	gi\|485099133\|ref\|NR_102528.1\|	65093	g31146	i0	86	6.4	100	12	45	2	48	147	260	163	Halothece sp. PCC 7418 strain PCC 7418 23S ribosomal RNA, complete sequence	blastn	1408	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Halothecacae	Halothece	Halothece sp. PCC 7418
10766864	10766864	PRJNA577226_S_NODE_65649_length_156_cov_1.277311_g64710_i0	PRJNA577226	65649	156	1.277311	1.99260516	Candidatus Atelocyanobacterium thalassae	713887	Bacteria	Bacteria	75	2.74e-9	NTclustered	gi\|284809060\|gb\|CP001842.1\|	1453429	g64710	i0	86.301	14.9102564102564	73	5	46	4	80	150	1759	1828	Candidatus Atelocyanobacterium thalassa isolate ALOHA, complete genome	blastn	2326	75	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
15165243	15165243	PRJNA577226_S_NODE_18732_length_294_cov_124.610895_g17793_i0	PRJNA577226	18732	294	124.610895	366.3560313	Bacteria	2	Bacteria	Bacteria	544	3.69e-150	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g17793	i0	100	99.9897959183673	294	0	100	0	1	294	320	27	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	29397	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15165406	15165406	PRJNA577226_S_NODE_3432_length_826_cov_17.097592_g2606_i0	PRJNA577226	3432	826	17.097592	141.22610992	Nostoc	1177	Bacteria	Bacteria	1201	0	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g2606	i0	93.012	291.001210653753	830	47	100	7	1	826	1738393	1737571	Nostoc cf. commune SO-36 DNA, complete genome	blastn	240367	1201	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
17715653	17715653	PRJNA577226_S_NODE_7654_length_487_cov_4.391111_g6723_i0	PRJNA577226	7654	487	4.391111	21.38471057	Trichocoleus	450526	Bacteria	Bacteria	189	3.4699999999999992e-43	NTclustered	gi\|2095813678\|gb\|OK161232.1\|	2876723	g6723	i0	90.845	83.9568788501027	142	12	29	1	1	141	2411	2270	Trichocoleus sp. 1.9A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40887	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. 1.9A
18414411	18414411	PRJNA577226_S_NODE_6175_length_553_cov_10.901163_g5253_i0	PRJNA577226	6175	553	10.901163	60.28343139	Moorena producens	1155739	Bacteria	Bacteria	455	3.5500000000000004e-123	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g5253	i0	81.964	319.30198915009	560	79	100	19	1	553	2427021	2426477	Moorena producens JHB chromosome, complete genome	blastn	176574	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
18988479	18988479	PRJNA577226_S_NODE_18855_length_293_cov_15.867188_g17916_i0	PRJNA577226	18855	293	15.867188	46.49086084	Nodularia	159191	Bacteria	Bacteria	484	2.2599999999999994e-132	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g17916	i0	96.587	285.58361774744	293	8	100	1	1	293	2506559	2506849	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	83676	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18988490	18988490	PRJNA577226_S_NODE_1995_length_1401_cov_18.242669_g1277_i0	PRJNA577226	1995	1401	18.242669	255.57979269	Gloeocapsopsis	693222	Bacteria	Bacteria	1766	0	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g1277	i0	89.582	125.396145610278	1411	120	100	21	1	1401	4122	2729	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	175680	1766	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
19688145	19688145	PRJNA577226_S_NODE_3256_length_859_cov_22.029197_g2445_i0	PRJNA577226	3256	859	22.029197	189.23080223	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1158	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g2445	i0	91.315	119.563445867288	852	69	99	5	3	851	2482	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	102705	1158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19688161	19688161	PRJNA577226_S_NODE_3316_length_847_cov_4.146914_g2286_i1	PRJNA577226	3316	847	4.146914	35.12436158	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	632	2.3899999999999996e-176	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g2286	i1	87.253	230.273907910272	557	67	65	3	3	556	4829105	4829660	Leptolyngbya sp. 7M chromosome	blastn	195042	632	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20963908	20963908	PRJNA577226_S_NODE_3357_length_840_cov_15.098381_g2536_i0	PRJNA577226	3357	840	15.098381	126.8264004	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	1131	0	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g2536	i0	90.995	163.163095238095	844	68	100	8	1	840	1171	2010	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	137057	1131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
24788398	24788398	PRJNA577226_S_NODE_5320_length_606_cov_19.564148_g4417_i0	PRJNA577226	5320	606	19.564148	118.55873688	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	675	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g4417	i0	92.165	102.161716171617	485	26	79	11	125	605	1995	2471	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	61910	675	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
28216379	28216379	PRJNA577226_S_NODE_59386_length_163_cov_1.238095_g58447_i0	PRJNA577226	59386	163	1.238095	2.01809485	unclassified Synechococcus	2626047	Bacteria	Bacteria	84.7	1.44e-17	NR	WP_259726860.1	2626047	g58447	i0	75.9	0.993865030674847	54	13	99.4	0	162	1	246	299	WP_259726860.1 MULTISPECIES: restriction endonuclease subunit S [unclassified Synechococcus]	diamond	162	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
28532539	28532539	PRJNA577226_S_NODE_5867_length_572_cov_2.310280_g4947_i0	PRJNA577226	5867	572	2.31028	13.2148016	Cyanobium sp.	2164130	Bacteria	Bacteria	51.6	4.68e-4	NR	MFM7266224.1	2164130	g4947	i0	42.2	1.27447552447552	64	35	33.6	1	332	523	230	291	MFM7266224.1 J domain-containing protein [Cyanobium sp.]	diamond	729	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp.
30079460	30079460	PRJNA577226_S_NODE_41152_length_194_cov_1.242038_g40213_i0	PRJNA577226	41152	194	1.242038	2.40955372	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	60.1	6.24e-9	NR	MBX9690932.1	2847862	g40213	i0	40	1.00515463917526	65	35	99	2	193	2	110	171	MBX9690932.1 replication initiation factor domain-containing protein [Cyanobacteriota bacterium]	diamond	195	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31438369	31438369	PRJNA577226_S_NODE_37916_length_202_cov_1.533333_g36977_i0	PRJNA577226	37916	202	1.533333	3.09733266	Leptolyngbya sp. SIOISBB	2607771	Bacteria	Bacteria	42.7	0.0215	NR	NEQ46644.1	2607771	g36977	i0	45.8	0.712871287128713	48	26	71.3	0	197	54	283	330	NEQ46644.1 TonB-dependent receptor [Leptolyngbya sp. SIOISBB]	diamond	144	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIOISBB
31817941	31817941	PRJNA577226_S_NODE_42497_length_191_cov_1.266234_g41558_i0	PRJNA577226	42497	191	1.266234	2.41850694	Leptolyngbyaceae cyanobacterium MO_188.B28	3036643	Bacteria	Bacteria	44.3	0.00151	NR	MDJ0702823.1	3036643	g41558	i0	50	0.816753926701571	52	19	77	3	160	14	4	51	MDJ0702823.1 hypothetical protein [Leptolyngbyaceae cyanobacterium MO_188.B28]	diamond	156	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium MO_188.B28
32590955	32590955	PRJNA577226_S_NODE_27719_length_238_cov_1.164179_g26780_i0	PRJNA577226	27719	238	1.164179	2.77074602	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	47.4	7.37e-4	NR	WP_373541143.1	2814140	g26780	i0	56.3	2.29411764705882	32	14	40.3	0	1	96	98	129	WP_373541143.1 DUF488 family protein [Chamaesiphon sp.]	diamond	546	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon sp.

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