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

42 rows where analysis = "blastn", bioproject = "PRJNA879067" 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
2130427	2130427	PRJNA879067_P_NODE_43822_length_582_cov_2.184676_g40362_i0	PRJNA879067	43822	582	2.184676	12.71481432	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	734	0	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g40362	i0	91.176	133.092783505155	544	42	93	6	29	568	640	1181	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	77460	734	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
2131093	2131093	PRJNA879067_P_NODE_66722_length_406_cov_4.501502_g63237_i0	PRJNA879067	66722	406	4.501502	18.27609812	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	542	1.8999999999999994e-149	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g63237	i0	92.167	133.980295566502	383	30	94	0	24	406	2901	3283	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	54396	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2131286	2131286	PRJNA879067_P_NODE_74162_length_366_cov_2.563140_g70677_i0	PRJNA879067	74162	366	2.56314	9.3810924	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	532	1.02e-146	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g70677	i0	94.767	139.620218579235	344	14	93	3	25	366	2086	2427	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51101	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2514549	2514549	PRJNA879067_P_NODE_45002_length_570_cov_1.762575_g41539_i0	PRJNA879067	45002	570	1.762575	10.0466775	Trichotorquatus	2056240	Bacteria	Bacteria	747	0	NTclustered	gi\|2277954471\|gb\|OP058661.1\|	2967162	g41539	i0	93.939	161.266666666667	495	29	87	1	51	544	2186	1692	Trichotorquatus salinus FBCC-A1483 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	91922	747	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Trichotorquatus	Trichotorquatus salinus
2514925	2514925	PRJNA879067_P_NODE_97622_length_271_cov_1.434343_g94136_i0	PRJNA879067	97622	271	1.434343	3.88706953	Bacteria	2	Bacteria	Bacteria	97.1	1.13e-15	NTclustered	gi\|225696284\|gb\|FJ805951.1\|	259957	g94136	i0	100	64.3837638376384	52	0	19	0	31	82	1097	1148	Uncultured Chroococcidiopsis sp. clone AS5_9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17448	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3406683	3406683	PRJNA879067_P_NODE_69903_length_388_cov_7.015873_g66418_i0	PRJNA879067	69903	388	7.015873	27.22158724	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	556	6.44e-154	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g66418	i0	97.273	95.5927835051546	330	6	84	3	1	327	1893	1564	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37090	556	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4682230	4682230	PRJNA879067_P_NODE_108904_length_244_cov_0.812865_g105418_i0	PRJNA879067	108904	244	0.812865	1.9833906	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	263	9.34e-66	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g105418	i0	89.1	346.409836065574	211	23	86	0	7	217	570461	570671	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	84524	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
5956984	5956984	PRJNA879067_P_NODE_101685_length_256_cov_1.683060_g98199_i0	PRJNA879067	101685	256	1.68306	4.3086336	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	274	4.5599999999999997e-69	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g98199	i0	88.546	189.75390625	227	25	89	1	30	256	3562	3337	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	48577	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
5959052	5959052	PRJNA879067_P_NODE_67865_length_400_cov_1.685015_g64380_i0	PRJNA879067	67865	400	1.685015	6.74006	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	499	1.14e-136	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g64380	i0	91.081	154.1975	370	31	92	2	24	392	1605	1973	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	61679	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7231972	7231972	PRJNA879067_P_NODE_105146_length_248_cov_2.262857_g101660_i0	PRJNA879067	105146	248	2.262857	5.61188536	Macrochaete lichenoides	1844961	Bacteria	Bacteria	390	4.1799999999999996e-104	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g101660	i0	95.161	271.096774193548	248	11	100	1	1	248	1665	1911	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67232	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
7232468	7232468	PRJNA879067_P_NODE_19626_length_1022_cov_4.628030_g16723_i0	PRJNA879067	19626	1022	4.62803	47.2984666	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1447	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g16723	i0	92.822	141.533268101761	1003	65	98	5	1	999	2618	1619	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	144647	1447	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8506630	8506630	PRJNA879067_P_NODE_100487_length_260_cov_2.347594_g97001_i0	PRJNA879067	100487	260	2.347594	6.1037444	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	237	6.09e-58	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g97001	i0	91.329	1.91538461538462	173	15	67	0	62	234	4252885	4253057	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	498	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
9781605	9781605	PRJNA879067_P_NODE_101948_length_255_cov_1.659341_g98462_i0	PRJNA879067	101948	255	1.659341	4.23131955	Microcystis aeruginosa	1126	Bacteria	Bacteria	340	4.4199999999999996e-89	NTclustered	gi\|2673719\|emb\|AJ003181.1\|	324056	g98462	i0	93.478	0.901960784313726	230	13	90	2	27	255	79	307	Microcystis aeruginosa EAWAG175 partial pcB and pcA genes, strain EAWAG175	blastn	230	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11059546	11059546	PRJNA879067_P_NODE_71829_length_378_cov_2.872131_g68344_i0	PRJNA879067	71829	378	2.872131	10.85665518	Nostoc sp. CENA543	1869241	Bacteria	Bacteria	435	3.0600000000000003e-117	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g68344	i0	89.143	291.539682539683	350	36	92	2	1	349	3888389	3888041	Nostoc sp. CENA543 chromosome, complete genome	blastn	110202	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
11059931	11059931	PRJNA879067_P_NODE_86369_length_312_cov_2.895397_g82883_i0	PRJNA879067	86369	312	2.895397	9.03363864	Gloeothece verrucosa	2546359	Bacteria	Bacteria	333	9.3e-87	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g82883	i0	89.655	120.070512820513	261	27	84	0	25	285	1627500	1627760	Cyanothece sp. PCC 7822, complete genome	blastn	37462	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
11442955	11442955	PRJNA879067_P_NODE_71349_length_381_cov_1.704545_g67864_i0	PRJNA879067	71349	381	1.704545	6.49431645	Chroococcidiopsis	54298	Bacteria	Bacteria	182	4.439999999999999e-41	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g67864	i0	84.615	12.3779527559055	182	28	48	0	4	185	1873344	1873163	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	4716	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
12332934	12332934	PRJNA879067_P_NODE_108650_length_244_cov_0.900585_g105164_i0	PRJNA879067	108650	244	0.900585	2.1974274	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	375	1.15e-99	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g105164	i0	97.717	139.05737704918	219	4	90	1	26	244	1456	1239	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	33930	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
12335551	12335551	PRJNA879067_P_NODE_94390_length_282_cov_2.435407_g90904_i0	PRJNA879067	94390	282	2.435407	6.86784774	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	6.41e-88	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g90904	i0	90.31	97.0106382978723	258	23	91	2	5	261	3173	2917	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	27357	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13609499	13609499	PRJNA879067_P_NODE_70811_length_384_cov_1.340836_g67326_i0	PRJNA879067	70811	384	1.340836	5.14881024	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	407	6.789999999999999e-109	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g67326	i0	86.981	33.1119791666667	361	47	94	0	24	384	3018600	3018960	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	12715	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
13610130	13610130	PRJNA879067_P_NODE_94931_length_280_cov_2.657005_g91445_i0	PRJNA879067	94931	280	2.657005	7.439614	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	412	1.0299999999999997e-110	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g91445	i0	96.414	199.182142857143	251	8	90	1	1	251	3670642	3670891	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	55771	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
13993149	13993149	PRJNA879067_P_NODE_83891_length_323_cov_1.024000_g80405_i0	PRJNA879067	83891	323	1.024	3.30752	Nostoc	1177	Bacteria	Bacteria	257	5.99e-64	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g80405	i0	84	43.6501547987616	275	37	83	4	41	309	7552830	7552557	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	14099	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
14883019	14883019	PRJNA879067_P_NODE_41372_length_607_cov_6.316479_g37920_i0	PRJNA879067	41372	607	6.316479	38.34102753	Aliterella chasmolithica	2739056	Bacteria	Bacteria	604	3.6799999999999987e-168	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g37920	i0	87.805	84.2207578253707	533	44	87	14	78	607	1875	2389	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	51122	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14884015	14884015	PRJNA879067_P_NODE_75692_length_358_cov_6.214035_g72206_i0	PRJNA879067	75692	358	6.214035	22.246245299999998	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	553	7.619999999999998e-153	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g72206	i0	96.96	224.030726256983	329	10	94	0	1	329	1859008	1859336	Calothrix sp. PCC 7716 DNA, complete genome	blastn	80203	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
16158122	16158122	PRJNA879067_P_NODE_55153_length_484_cov_2.452555_g51668_i0	PRJNA879067	55153	484	2.452555	11.8703662	Aliterella chasmolithica	2739056	Bacteria	Bacteria	787	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g51668	i0	98.018	105.832644628099	454	8	94	1	32	484	2018	2471	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	51223	787	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
16158953	16158953	PRJNA879067_P_NODE_86173_length_313_cov_2.137500_g82687_i0	PRJNA879067	86173	313	2.1375	6.690375	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	357	5.54e-94	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g82687	i0	89.041	100.610223642173	292	27	93	5	24	313	2888	3176	Uncultured Chroococcidiopsis sp. clone A1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31491	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17433478	17433478	PRJNA879067_P_NODE_50394_length_521_cov_10.741071_g46912_i0	PRJNA879067	50394	521	10.741071	55.96097991	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	588	3.15e-163	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g46912	i0	88.548	184.389635316699	489	51	93	5	37	521	1588	2075	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	96067	588	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17433965	17433965	PRJNA879067_P_NODE_68194_length_398_cov_2.046154_g64709_i0	PRJNA879067	68194	398	2.046154	8.14369292	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	484	3.1699999999999994e-132	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g64709	i0	90.296	102.05527638191	371	35	93	1	1	370	3228	2858	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40618	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17434756	17434756	PRJNA879067_P_NODE_98334_length_268_cov_2.594872_g94848_i0	PRJNA879067	98334	268	2.594872	6.95425696	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	209	1.38e-49	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g94848	i0	87.363	6.69776119402985	182	23	68	0	83	264	163485	163304	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1795	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
17816428	17816428	PRJNA879067_P_NODE_32034_length_730_cov_5.095890_g28687_i0	PRJNA879067	32034	730	5.09589	37.199997	Chroococcidiopsis	54298	Bacteria	Bacteria	715	0	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g28687	i0	85.591	1.94109589041096	694	87	94	10	43	730	5097062	5097748	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1417	715	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18706796	18706796	PRJNA879067_P_NODE_52815_length_502_cov_2.118881_g49331_i0	PRJNA879067	52815	502	2.118881	10.63678262	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	667	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g49331	i0	92.017	160.386454183267	476	37	95	1	28	502	1619	2094	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	80514	667	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19980380	19980380	PRJNA879067_P_NODE_101876_length_255_cov_2.521978_g98390_i0	PRJNA879067	101876	255	2.521978	6.4310439	Phormidium sp. NIES-2121	2510782	Bacteria	Bacteria	407	4.29e-109	NTclustered	gi\|1566846234\|dbj\|LC455612.1\|	2510782	g98390	i0	97.095	141.03921568627501	241	7	95	0	1	241	276	36	Phormidium sp. NIES-2121 gene for 23S ribosomal RNA, partial sequence	blastn	35965	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2121
21256810	21256810	PRJNA879067_P_NODE_32617_length_721_cov_2.279321_g29258_i0	PRJNA879067	32617	721	2.279321	16.43390441	Ancylothrix terrestris	2023235	Bacteria	Bacteria	512	2.7499999999999997e-140	NTclustered	gi\|2257652262\|gb\|ON803474.1\|	2953716	g29258	i0	100	61.9889042995839	277	0	38	0	445	721	2070	2346	Ancylothrix terrestris strain BEA0843B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44694	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Ancylothrix	Ancylothrix terrestris
21257608	21257608	PRJNA879067_P_NODE_58717_length_458_cov_3.423377_g55232_i0	PRJNA879067	58717	458	3.423377	15.67906666	Macrochaete lichenoides	1844961	Bacteria	Bacteria	758	0	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g55232	i0	97.523	294.362445414847	444	10	97	1	15	458	1514	1956	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	134818	758	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
21257860	21257860	PRJNA879067_P_NODE_67717_length_401_cov_1.384146_g64232_i0	PRJNA879067	67717	401	1.384146	5.55042546	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	407	7.119999999999999e-109	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g64232	i0	88.596	228.640897755611	342	30	84	8	24	360	3682508	3682171	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	91685	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21258146	21258146	PRJNA879067_P_NODE_79437_length_341_cov_8.253731_g75951_i0	PRJNA879067	79437	341	8.253731	28.14522271	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	464	3.49e-126	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g75951	i0	91.202	79.4897360703812	341	30	100	0	1	341	2150847	2150507	Leptolyngbya sp. 7M chromosome	blastn	27106	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
21258333	21258333	PRJNA879067_P_NODE_86597_length_311_cov_3.386555_g83111_i0	PRJNA879067	86597	311	3.386555	10.53218605	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	422	1.92e-113	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g83111	i0	91.29	142.819935691318	310	26	99	1	2	311	2973	3281	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44417	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22533179	22533179	PRJNA879067_P_NODE_92938_length_287_cov_3.598131_g89452_i0	PRJNA879067	92938	287	3.598131	10.32663597	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	337	6.539999999999998e-88	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g89452	i0	87.847	273.738675958188	288	33	100	2	1	287	2005	1719	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	78563	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23807499	23807499	PRJNA879067_P_NODE_50499_length_520_cov_19.532438_g47017_i0	PRJNA879067	50499	520	19.532438	101.5686776	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	676	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g47017	i0	91.82	151.632692307692	489	34	93	6	1	484	2075	1588	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	78849	676	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23807565	23807565	PRJNA879067_P_NODE_53219_length_499_cov_1.835681_g49735_i0	PRJNA879067	53219	499	1.835681	9.16004819	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	630	4.9199999999999985e-176	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g49735	i0	90.909	172.635270541082	473	37	94	5	1	470	470	1	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	86145	630	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
23808176	23808176	PRJNA879067_P_NODE_7639_length_1811_cov_17.341197_g5834_i0	PRJNA879067	7639	1811	17.341197	314.04907767	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	1140	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g5834	i0	82.786	12.9110988404197	1278	218	71	2	42	1318	5648844	5647568	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	23382	1140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
23808248	23808248	PRJNA879067_P_NODE_79259_length_342_cov_2.721190_g75773_i0	PRJNA879067	79259	342	2.72119	9.3064698	Plectonema terebrans	272135	Bacteria	Bacteria	326	1.73e-84	NTclustered	gi\|46409900\|gb\|AY584525.1\|	272137	g75773	i0	87.719	121.359649122807	285	28	83	6	31	313	1144	865	Plectonema terebrans CCAP 1463/4 23S ribosomal RNA gene, partial sequence	blastn	41505	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Plectonema	Plectonema terebrans
24190879	24190879	PRJNA879067_P_NODE_91859_length_291_cov_2.688073_g88373_i0	PRJNA879067	91859	291	2.688073	7.82229243	Cyanophyceae	3028117	Bacteria	Bacteria	375	1.4099999999999998e-99	NTclustered	gi\|146740643\|emb\|AM709630.1\|	118168	g88373	i0	92.509	123.917525773196	267	13	90	6	1	262	2750	2486	Microcoleus chthonoplastes PCC 7420 partial ribosomal RNA operon, strain PCC 7420	blastn	36060	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes

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