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

29 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
792887	792887	PRJNA799842_P_NODE_111841_length_277_cov_1.132353_g110268_i0	PRJNA799842	111841	277	1.132353	3.13661781	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	488	1.6399999999999999e-133	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g110268	i0	98.551	147.61371841155199	276	4	99	0	1	276	2909	3184	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40889	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
794380	794380	PRJNA799842_P_NODE_191161_length_233_cov_2.075000_g189588_i0	PRJNA799842	191161	233	2.075	4.83475	Calenema singularis	1983115	Bacteria	Bacteria	292	1.13e-74	NTclustered	gi\|940620467\|gb\|KR676347.1\|	945751	g189588	i0	89.27	158.025751072961	233	25	100	0	1	233	3691	3459	Calenema singularis LEGE 06188 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36820	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Calenema	Calenema singularis
2070961	2070961	PRJNA799842_P_NODE_55382_length_381_cov_27.639610_g53809_i0	PRJNA799842	55382	381	27.63961	105.3069141	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	359	1.91e-94	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g53809	i0	83.854	94.8897637795276	384	55	99	6	1	380	6832033	6831653	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	36153	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
2071141	2071141	PRJNA799842_P_NODE_63842_length_357_cov_0.781690_g62269_i0	PRJNA799842	63842	357	0.78169	2.7906333	Nostoc punctiforme	272131	Bacteria	Bacteria	217	1.13e-51	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g62269	i0	81.509	6.64985994397759	265	47	74	2	93	356	7711697	7711960	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	2374	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
2494166	2494166	PRJNA799842_P_NODE_126742_length_259_cov_4.123656_g125169_i0	PRJNA799842	126742	259	4.123656	10.68026904	Arthronema	241432	Bacteria	Bacteria	472	1.53e-128	NTclustered	gi\|664803861\|gb\|KM019974.1\|	241439	g125169	i0	99.612	99.2741312741313	258	1	99	0	2	259	699	442	Arthronema africanum SAG 12.89 16S ribosomal RNA gene, partial sequence	blastn	25712	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Arthronema	Arthronema africanum
2495210	2495210	PRJNA799842_P_NODE_7702_length_1124_cov_3.015224_g6743_i0	PRJNA799842	7702	1124	3.015224	33.89111776	Nostocales	1161	Bacteria	Bacteria	846	0	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g6743	i0	82.676	155.905693950178	964	158	85	9	165	1124	2561985	2562943	Nostoc sp. HK-01 DNA, complete genome	blastn	175238	852	0.992957746478873	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
4623844	4623844	PRJNA799842_P_NODE_66124_length_351_cov_1.061151_g64551_i0	PRJNA799842	66124	351	1.061151	3.72464001	Gloeotrichia echinulata	212360	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2707832175\|gb\|CP051187.1\|	2723856	g64551	i0	90.476	0.11965811965812	42	2	12	2	258	298	3148091	3148051	MAG: Gloeotrichia echinulata CP02 chromosome, complete genome	blastn	42	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
4623886	4623886	PRJNA799842_P_NODE_67804_length_347_cov_1.010949_g66231_i0	PRJNA799842	67804	347	1.010949	3.50799303	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	337	8.099999999999997e-88	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g66231	i0	85.196	29.0518731988473	331	46	95	2	1	328	2811881	2812211	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	10081	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5898145	5898145	PRJNA799842_P_NODE_27985_length_553_cov_1.120833_g26428_i0	PRJNA799842	27985	553	1.120833	6.19820649	Rivularia sp. PCC 7116	373994	Bacteria	Bacteria	254	1.39e-62	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g26428	i0	78.316	8.95117540687161	392	85	71	0	1	392	2994730	2995121	Rivularia sp. PCC 7116, complete genome	blastn	4950	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
6322472	6322472	PRJNA799842_P_NODE_10065_length_988_cov_7.226230_g1567_i1	PRJNA799842	10065	988	7.22623	71.3951524	Chroococcidiopsis	54298	Bacteria	Bacteria	1587	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g1567	i1	96.57	126.378542510121	962	26	97	5	29	988	630	1586	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	124862	1587	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
7172653	7172653	PRJNA799842_P_NODE_190966_length_236_cov_2.036810_g189393_i0	PRJNA799842	190966	236	2.03681	4.8068716	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	409	1.09e-109	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g189393	i0	97.881	181.792372881356	236	5	100	0	1	236	449801	450036	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	42903	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
7173907	7173907	PRJNA799842_P_NODE_76046_length_329_cov_2.742188_g74473_i0	PRJNA799842	76046	329	2.742188	9.02179852	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	420	7.37e-113	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g74473	i0	90.184	152.629179331307	326	26	98	6	1	321	3389	3065	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	50215	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7596978	7596978	PRJNA799842_P_NODE_154966_length_247_cov_1.321839_g153393_i0	PRJNA799842	154966	247	1.321839	3.26494233	Nostoc	1177	Bacteria	Bacteria	95.3	3.66e-15	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g153393	i0	77.966	2.76923076923077	177	22	65	7	87	247	1446406	1446581	Nostoc sp. NIES-3756 DNA, complete genome	blastn	684	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
8448202	8448202	PRJNA799842_P_NODE_52367_length_392_cov_5.075235_g50794_i0	PRJNA799842	52367	392	5.075235	19.8949212	Dolichospermum sp. UHCC 0315A	1914871	Bacteria	Bacteria	329	1.55e-85	NTclustered	gi\|1731522919\|gb\|CP043056.1\|	1914871	g50794	i0	84.866	82.3061224489796	337	39	84	8	62	392	1115019	1115349	Dolichospermum sp. UHCC 0315A chromosome, complete genome	blastn	32264	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. UHCC 0315A
9723127	9723127	PRJNA799842_P_NODE_47228_length_414_cov_0.900293_g45655_i0	PRJNA799842	47228	414	0.900293	3.72721302	Rivularia sp. PCC 7116	373994	Bacteria	Bacteria	370	9.67e-98	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g45655	i0	82.974	25.1787439613527	417	63	99	8	1	413	7311141	7311553	Rivularia sp. PCC 7116, complete genome	blastn	10424	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
10148328	10148328	PRJNA799842_P_NODE_9648_length_1009_cov_2.142094_g8559_i0	PRJNA799842	9648	1009	2.142094	21.61372846	Chroococcidiopsis	54298	Bacteria	Bacteria	1716	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g8559	i0	97.426	140.791873141724	1010	21	99	4	2	1009	1020	14	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	142059	1716	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
10999479	10999479	PRJNA799842_P_NODE_7429_length_1143_cov_13.732710_g6487_i0	PRJNA799842	7429	1143	13.73271	156.9648753	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	1182	0	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g6487	i0	85.74	313.798775153106	1122	157	98	3	14	1133	5496233	5497353	Calothrix sp. PCC 6303, complete genome	blastn	358672	1182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
12273345	12273345	PRJNA799842_P_NODE_168710_length_245_cov_0.895349_g167137_i0	PRJNA799842	168710	245	0.895349	2.19360505	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992	1206980	Bacteria	Bacteria	302	1.99e-77	NTclustered	gi\|394332606\|gb\|JX219483.1\|	1206980	g167137	i0	89.256	249.861224489796	242	25	99	1	2	243	5095	4855	Nostoc sp. 'Peltigera malacea DB3992 cyanobiont' 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile, tRNA-Ala, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	61216	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera malacea cyanobiont' DB3992
12274083	12274083	PRJNA799842_P_NODE_31290_length_518_cov_2.694382_g29726_i0	PRJNA799842	31290	518	2.694382	13.95689876	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	702	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g29726	i0	91.137	148.650579150579	519	44	100	2	1	518	2148	1631	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	77001	702	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16095759	16095759	PRJNA799842_P_NODE_128873_length_257_cov_1.440217_g127300_i0	PRJNA799842	128873	257	1.440217	3.70135769	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2004375065\|gb\|CP051188.1\|	2717882	g127300	i0	92.308	0.151750972762646	39	3	15	0	31	69	1674575	1674537	Aphanizomenon flos-aquae DEX188 chromosome, complete genome	blastn	39	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
16097273	16097273	PRJNA799842_P_NODE_36173_length_477_cov_2.061881_g34603_i0	PRJNA799842	36173	477	2.061881	9.83517237	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	636	1.01e-177	NTclustered	gi\|225696266\|gb\|FJ805933.1\|	259957	g34603	i0	90.814	169.962264150943	479	38	99	5	2	476	1524	2000	Uncultured Chroococcidiopsis sp. clone NA1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	81072	636	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16522305	16522305	PRJNA799842_P_NODE_57573_length_374_cov_7.242525_g56000_i0	PRJNA799842	57573	374	7.242525	27.0870435	Nostoc	1177	Bacteria	Bacteria	379	1.44e-100	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g56000	i0	86.441	82.5080213903743	354	38	93	8	26	371	6612042	6611691	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	30858	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
17371435	17371435	PRJNA799842_P_NODE_118014_length_270_cov_0.944162_g116441_i0	PRJNA799842	118014	270	0.944162	2.5492374	Nodularia harveyana	114805	Bacteria	Bacteria	477	3.4499999999999986e-130	NTclustered	gi\|1358126411\|gb\|KY963609.1\|	2093849	g116441	i0	98.519	266.640740740741	270	4	100	0	1	270	50	319	Nodularia harveyana UTEX B 2093 23S ribosomal RNA gene, partial sequence	blastn	71993	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia harveyana
17373052	17373052	PRJNA799842_P_NODE_31334_length_518_cov_1.467416_g29770_i0	PRJNA799842	31334	518	1.467416	7.60121488	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	885	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g29770	i0	97.49	309.166023166023	518	13	100	0	1	518	1858804	1859321	Calothrix sp. PCC 7716 DNA, complete genome	blastn	160148	885	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18644543	18644543	PRJNA799842_P_NODE_118635_length_269_cov_1.178571_g117062_i0	PRJNA799842	118635	269	1.178571	3.17035599	Moorena producens	1155739	Bacteria	Bacteria	95.3	4.04e-15	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g117062	i0	86.022	0.345724907063197	93	8	33	5	155	244	620864	620774	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	93	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
21198080	21198080	PRJNA799842_P_NODE_78917_length_324_cov_1.227092_g77344_i0	PRJNA799842	78917	324	1.227092	3.97577808	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	263	1.29e-65	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g77344	i0	81.481	4.41049382716049	324	56	99	4	1	322	2717175	2716854	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1429	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
22896419	22896419	PRJNA799842_P_NODE_159758_length_246_cov_1.745665_g158185_i0	PRJNA799842	159758	246	1.745665	4.2943359	Drouetiella	2303513	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|2312649307\|gb\|OP577847.1\|	2983374	g158185	i0	96.341	149.117886178862	246	9	100	0	1	246	1921	2166	Drouetiella lurida ACKU666 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36683	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella lurida
23745577	23745577	PRJNA799842_P_NODE_108379_length_281_cov_1.110577_g106806_i0	PRJNA799842	108379	281	1.110577	3.12072137	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	243	1.4300000000000001e-59	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g106806	i0	82.545	0.97864768683274	275	48	98	0	5	279	4253132	4252858	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	275	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
23748693	23748693	PRJNA799842_P_NODE_94119_length_299_cov_1.362832_g92546_i0	PRJNA799842	94119	299	1.362832	4.07486768	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g92546	i0	100	0.0936454849498328	28	0	9	0	40	67	1020018	1019991	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	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);;