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

57 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
274977	274977	PRJNA1120203_P_NODE_48501_length_324_cov_3.454183_g47485_i0	PRJNA1120203	48501	324	3.454183	11.19155292	uncultured cyanobacterium	1211	Bacteria	Bacteria	276	1.6599999999999999e-69	NTclustered	gi\|810785927\|gb\|KP238376.1\|	1211	g47485	i0	100	153.444444444444	149	0	85	0	174	322	149	1	Uncultured cyanobacterium isolate DGGE gel band IgD-a 23S ribosomal RNA gene, partial sequence	blastn	49716	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2303248	2303248	PRJNA1120203_P_NODE_57062_length_298_cov_2.373333_g56046_i0	PRJNA1120203	57062	298	2.373333	7.07253234	Nostocales	1161	Bacteria	Bacteria	134	9.61e-27	NTclustered	gi\|413968727\|gb\|CP003284.1\|	46234	g56046	i0	84.286	106.781879194631	140	18	57	4	149	286	953286	953149	Anabaena sp. 90 chromosome chANA01, complete sequence	blastn	31821	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. 90
2303511	2303511	PRJNA1120203_P_NODE_88782_length_247_cov_0.885057_g87766_i0	PRJNA1120203	88782	247	0.885057	2.18609079	Synechococcus	1129	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1895761424\|gb\|CP047938.1\|	1050646	g87766	i0	99.595	3	247	1	100	0	1	247	1504772	1504526	Synechococcus sp. A15-44 chromosome, complete genome	blastn	741	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-44
2825272	2825272	PRJNA1120203_P_NODE_105683_length_241_cov_0.916667_g104667_i0	PRJNA1120203	105683	241	0.916667	2.20916747	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	390	4.05e-104	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g104667	i0	95.851	1.90871369294606	241	10	100	0	1	241	239813	240053	Synechococcus sp. LTW-R chromosome, complete genome	blastn	460	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
2825648	2825648	PRJNA1120203_P_NODE_48203_length_325_cov_10.321429_g47187_i0	PRJNA1120203	48203	325	10.321429	33.54464425	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	255	2.17e-63	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g47187	i0	99.291	98.4738461538462	141	1	43	0	14	154	389	249	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	32004	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
3578235	3578235	PRJNA1120203_P_NODE_27783_length_454_cov_83.677165_g26768_i0	PRJNA1120203	27783	454	83.677165	379.8943291	Synechococcus	1129	Bacteria	Bacteria	706	0	NTclustered	gi\|685837124\|dbj\|LC002637.1\|	1211	g26768	i0	94.831	97.9691629955947	445	15	96	1	3	439	161	605	Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: LM5	blastn	44478	713	0.990182328190743	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3578291	3578291	PRJNA1120203_P_NODE_34903_length_392_cov_0.855799_g33888_i0	PRJNA1120203	34903	392	0.855799	3.35473208	Synechococcus	1129	Bacteria	Bacteria	719	0	NTclustered	gi\|393395684\|gb\|JQ837751.1\|	154535	g33888	i0	99.745	109.183673469388	392	1	100	0	1	392	479	88	Uncultured Synechococcus sp. clone S1-C-13 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	42800	719	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	uncultured Synechococcus sp.
3578431	3578431	PRJNA1120203_P_NODE_47343_length_328_cov_4.411765_g46327_i0	PRJNA1120203	47343	328	4.411765	14.4705892	Cyanobacterium	102234	Bacteria	Bacteria	272	2.1799999999999993e-68	NTclustered	gi\|428686127\|gb\|CP003940.1\|	292563	g46327	i0	98.693	121.134146341463	153	2	92	0	14	166	1172017	1171865	Cyanobacterium stanieri PCC 7202, complete genome	blastn	39732	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium stanieri
4101579	4101579	PRJNA1120203_P_NODE_104144_length_241_cov_0.916667_g103128_i0	PRJNA1120203	104144	241	0.916667	2.20916747	Synechococcus sp. RS9902	221345	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1895794691\|gb\|CP047949.1\|	221345	g103128	i0	97.095	10.9751037344398	241	7	100	0	1	241	2182404	2182644	Synechococcus sp. RS9902 chromosome, complete genome	blastn	2645	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9902
4855553	4855553	PRJNA1120203_P_NODE_19284_length_597_cov_24.742366_g18280_i0	PRJNA1120203	19284	597	24.742366	147.71192502	Leptolyngbya	47251	Bacteria	Bacteria	326	3.1499999999999997e-84	NTclustered	gi\|745734159\|gb\|KM458323.1\|	332963	g18280	i0	96.907	95.5879396984925	194	6	66	0	12	205	389	196	Uncultured Leptolyngbya sp. isolate OTU 00040 23S ribosomal RNA gene, partial sequence	blastn	57066	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	uncultured Leptolyngbya sp.
4855815	4855815	PRJNA1120203_P_NODE_48184_length_325_cov_26.222222_g47168_i0	PRJNA1120203	48184	325	26.222222	85.2222215	root	1	Root_unresolved	Root_unresolved	296	1.28e-75	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g47168	i0	100	85.8123076923077	160	0	92	0	165	324	344	185	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	27889	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5378143	5378143	PRJNA1120203_P_NODE_55265_length_303_cov_15.956522_g54249_i0	PRJNA1120203	55265	303	15.956522	48.34826166	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	278	4.28e-70	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g54249	i0	99.346	118.217821782178	153	1	95	0	149	301	3803	3651	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	35820	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6130554	6130554	PRJNA1120203_P_NODE_31025_length_422_cov_165.017192_g30010_i0	PRJNA1120203	31025	422	165.017192	696.37255024	Nostocales	1161	Bacteria	Bacteria	616	1.15e-171	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g30010	i0	93.902	182.199052132701	410	22	97	3	3	410	121298	121706	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	76888	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
6130713	6130713	PRJNA1120203_P_NODE_48185_length_325_cov_24.150794_g47169_i0	PRJNA1120203	48185	325	24.150794	78.4900805	root	1	Root_unresolved	Root_unresolved	296	1.28e-75	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g47169	i0	100	85.8769230769231	160	0	92	0	165	324	344	185	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	27910	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6130714	6130714	PRJNA1120203_P_NODE_48205_length_325_cov_7.468254_g47189_i0	PRJNA1120203	48205	325	7.468254	24.2718255	Cyanophyceae	3028117	Bacteria	Bacteria	246	1.31e-60	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g47189	i0	95.455	134.083076923077	154	7	90	0	172	325	3803494	3803341	Oscillatoria acuminata PCC 6304, complete genome	blastn	43577	248	0.991935483870968	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
6652816	6652816	PRJNA1120203_P_NODE_48486_length_324_cov_7.629482_g47470_i0	PRJNA1120203	48486	324	7.629482	24.71952168	Oscillatoria acuminata	118323	Bacteria	Bacteria	278	4.61e-70	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g47470	i0	100	142.070987654321	150	0	89	0	3	152	2200441	2200590	Oscillatoria acuminata PCC 6304, complete genome	blastn	46031	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
6653350	6653350	PRJNA1120203_P_NODE_86706_length_248_cov_0.880000_g85690_i0	PRJNA1120203	86706	248	0.88	2.1824	Synechococcus sp. M16.1	1442553	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1895808941\|gb\|CP047954.1\|	1442553	g85690	i0	98.79	8	248	3	100	0	1	248	1473882	1473635	Synechococcus sp. M16.1 chromosome, complete genome	blastn	1984	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. M16.1
7927502	7927502	PRJNA1120203_P_NODE_105687_length_241_cov_0.916667_g104671_i0	PRJNA1120203	105687	241	0.916667	2.20916747	Synechococcus sp. M16.1	1442553	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1895808941\|gb\|CP047954.1\|	1442553	g104671	i0	99.585	10.3485477178423	241	1	100	0	1	241	1115136	1114896	Synechococcus sp. M16.1 chromosome, complete genome	blastn	2494	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. M16.1
7927682	7927682	PRJNA1120203_P_NODE_31587_length_417_cov_7.270349_g30572_i0	PRJNA1120203	31587	417	7.270349	30.31735533	uncultured Synechococcus sp.	154535	Bacteria	Bacteria	721	0	NTclustered	gi\|2059417378\|gb\|MZ466354.1\|	154535	g30572	i0	99.495	102.525179856115	396	2	95	0	14	409	400	5	Uncultured Synechococcus sp. clone DAD-ALGPRO-17 23S ribosomal RNA gene, partial sequence	blastn	42753	721	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	uncultured Synechococcus sp.
8681065	8681065	PRJNA1120203_P_NODE_48187_length_325_cov_23.011905_g47171_i0	PRJNA1120203	48187	325	23.011905	74.78869125	root	1	Root_unresolved	Root_unresolved	296	1.28e-75	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g47171	i0	100	88.4646153846154	160	0	93	0	165	324	344	185	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	28751	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8681328	8681328	PRJNA1120203_P_NODE_80887_length_250_cov_0.870056_g79871_i0	PRJNA1120203	80887	250	0.870056	2.17514	Prochlorococcus	1218	Bacteria	Bacteria	139	1.6899999999999999e-28	NTclustered	gi\|2895594810\|gb\|CP138949.1\|	1499502	g79871	i0	82.609	10.132	161	24	64	4	7	165	1867330	1867172	Prochlorococcus sp. MIT 0701 chromosome, complete genome	blastn	2533	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 0701
8681451	8681451	PRJNA1120203_P_NODE_95507_length_245_cov_0.895349_g94491_i0	PRJNA1120203	95507	245	0.895349	2.19360505	Synechococcus	1129	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1895779638\|gb\|CP047944.1\|	221350	g94491	i0	98.776	12.9877551020408	245	3	100	0	1	245	266091	265847	Synechococcus sp. RS9907 chromosome, complete genome	blastn	3182	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9907
9203335	9203335	PRJNA1120203_P_NODE_81508_length_250_cov_0.870056_g80492_i0	PRJNA1120203	81508	250	0.870056	2.17514	Synechococcus sp. M16.1	1442553	Bacteria	Bacteria	429	8.949999999999998e-116	NTclustered	gi\|1895808941\|gb\|CP047954.1\|	1442553	g80492	i0	97.6	24.656	250	6	100	0	1	250	654256	654007	Synechococcus sp. M16.1 chromosome, complete genome	blastn	6164	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. M16.1
9955898	9955898	PRJNA1120203_P_NODE_47888_length_326_cov_8.865613_g46872_i0	PRJNA1120203	47888	326	8.865613	28.90189838	Cyanophyceae	3028117	Bacteria	Bacteria	278	4.64e-70	NTclustered	gi\|662702554\|gb\|CP007542.1\|	1147	g46872	i0	100	100.138036809816	150	0	89	0	175	324	1159370	1159221	Synechocystis sp. PCC 6714, complete genome	blastn	32645	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6714
10478405	10478405	PRJNA1120203_P_NODE_31369_length_419_cov_14.595376_g30354_i0	PRJNA1120203	31369	419	14.595376	61.15462544	cyanobacterium ARS04158_00005	1564713	Bacteria	Bacteria	603	8.879999999999997e-168	NTclustered	gi\|704000437\|gb\|KM676599.1\|	1564713	g30354	i0	93.233	144.997613365155	399	24	95	1	22	417	400	2	Cyanobacterium ARS04158_00005 23S ribosomal RNA gene, partial sequence	blastn	60754	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium ARS04158_00005
10478608	10478608	PRJNA1120203_P_NODE_48469_length_324_cov_62.529880_g47453_i0	PRJNA1120203	48469	324	62.52988	202.5968112	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	278	4.61e-70	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g47453	i0	99.346	249.243827160494	153	1	89	0	170	322	2875076	2874924	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	80755	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
11753436	11753436	PRJNA1120203_P_NODE_47910_length_326_cov_2.897233_g46894_i0	PRJNA1120203	47910	326	2.897233	9.44497958	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	250	1.01e-61	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g46894	i0	97.917	158.248466257669	144	3	90	0	11	154	2110178	2110321	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	51589	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
11753445	11753445	PRJNA1120203_P_NODE_48470_length_324_cov_62.354582_g47454_i0	PRJNA1120203	48470	324	62.354582	202.02884568	Cylindrospermum stagnale	142864	Bacteria	Bacteria	255	2.16e-63	NTclustered	gi\|485099135\|ref\|NR_102530.1\|	56107	g47454	i0	97.333	240.212962962963	150	4	88	0	173	322	2127	1978	Cylindrospermum stagnale PCC 7417 strain PCC 7417 23S ribosomal RNA, complete sequence	blastn	77829	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
13028523	13028523	PRJNA1120203_P_NODE_34911_length_391_cov_6.710692_g33896_i0	PRJNA1120203	34911	391	6.710692	26.23880572	Oscillatoria sp. CCAP 1459/26	272127	Bacteria	Bacteria	383	1.1699999999999998e-101	NTclustered	gi\|46409889\|gb\|AY584514.1\|	272127	g33896	i0	84.171	145.652173913043	398	39	97	12	13	391	1974	1582	Oscillatoria sp. CCAP 1459/26 23S ribosomal RNA gene, partial sequence	blastn	56950	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. CCAP 1459/26
13028703	13028703	PRJNA1120203_P_NODE_48471_length_324_cov_60.227092_g47455_i0	PRJNA1120203	48471	324	60.227092	195.13577808	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	279	1.28e-70	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g47455	i0	100	244.256172839506	151	0	89	0	173	323	2188	2038	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	79139	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
13781053	13781053	PRJNA1120203_P_NODE_43171_length_345_cov_20.702206_g42156_i0	PRJNA1120203	43171	345	20.702206	71.4226107	Leptolyngbya	47251	Bacteria	Bacteria	316	1.05e-81	NTclustered	gi\|745734159\|gb\|KM458323.1\|	332963	g42156	i0	96.825	122.428985507246	189	6	91	0	12	200	389	201	Uncultured Leptolyngbya sp. isolate OTU 00040 23S ribosomal RNA gene, partial sequence	blastn	42238	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	uncultured Leptolyngbya sp.
14304476	14304476	PRJNA1120203_P_NODE_94732_length_245_cov_0.895349_g93716_i0	PRJNA1120203	94732	245	0.895349	2.19360505	Synechococcus sp. M16.1	1442553	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1895808941\|gb\|CP047954.1\|	1442553	g93716	i0	99.592	10.1551020408163	245	1	100	0	1	245	984011	983767	Synechococcus sp. M16.1 chromosome, complete genome	blastn	2488	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. M16.1
15055513	15055513	PRJNA1120203_P_NODE_48472_length_324_cov_58.968127_g47456_i0	PRJNA1120203	48472	324	58.968127	191.05673148	Cyanophyceae	3028117	Bacteria	Bacteria	252	2.8e-62	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g47456	i0	100	240.561728395062	136	0	88	0	177	312	2135123	2134988	Nostoc sp. PCC 7524, complete genome	blastn	77942	254	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
15055605	15055605	PRJNA1120203_P_NODE_56672_length_299_cov_3.522124_g55656_i0	PRJNA1120203	56672	299	3.522124	10.53115076	root	1	Root_unresolved	Root_unresolved	263	1.18e-65	NTclustered	gi\|260069845\|gb\|GQ348575.1\|	1211	g55656	i0	98.013	91.4882943143813	151	3	96	0	149	299	435	285	Uncultured cyanobacterium clone SHAB462 16S ribosomal RNA gene, partial sequence	blastn	27355	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15578315	15578315	PRJNA1120203_P_NODE_86633_length_248_cov_0.880000_g85617_i0	PRJNA1120203	86633	248	0.88	2.1824	Synechococcus sp. RS9907	221350	Bacteria	Bacteria	451	1.89e-122	NTclustered	gi\|571048533\|gb\|KF528775.1\|	221350	g85617	i0	99.595	95.5403225806452	247	1	99	0	2	248	334	580	Synechococcus sp. RS9907 C-phycoerythrin class I subunit beta (cpeB) and C-phycoerythrin class I subunit alpha (cpeA) genes, complete cds	blastn	23694	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9907
15578470	15578470	PRJNA1120203_P_NODE_96553_length_244_cov_0.900585_g95537_i0	PRJNA1120203	96553	244	0.900585	2.1974274	Synechococcus sp. WH 8101	59932	Bacteria	Bacteria	143	1.27e-29	NTclustered	gi\|1896737323\|gb\|CP047932.1\|	59932	g95537	i0	77.966	5.7827868852459	236	46	95	6	1	233	340730	340498	Synechococcus sp. WH 8101 chromosome, complete genome	blastn	1411	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 8101
16852228	16852228	PRJNA1120203_P_NODE_45014_length_337_cov_12.541667_g43999_i0	PRJNA1120203	45014	337	12.541667	42.26541779	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	279	1.34e-70	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g43999	i0	98.125	136.925816023739	160	3	93	0	14	173	2443	2284	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	46144	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
17605284	17605284	PRJNA1120203_P_NODE_25814_length_478_cov_80.607407_g24800_i0	PRJNA1120203	25814	478	80.607407	385.30340546	Synechococcus	1129	Bacteria	Bacteria	710	0	NTclustered	gi\|685837123\|dbj\|LC002636.1\|	1211	g24800	i0	95.011	96.3933054393305	461	7	96	1	3	463	163	607	Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: LM4	blastn	46076	717	0.99023709902371	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17605884	17605884	PRJNA1120203_P_NODE_89774_length_247_cov_0.885057_g88758_i0	PRJNA1120203	89774	247	0.885057	2.18609079	Synechococcus	1129	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|1895794691\|gb\|CP047949.1\|	221345	g88758	i0	95.547	8.80566801619433	247	11	100	0	1	247	1329707	1329461	Synechococcus sp. RS9902 chromosome, complete genome	blastn	2175	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9902
18126660	18126660	PRJNA1120203_P_NODE_48195_length_325_cov_13.277778_g47179_i0	PRJNA1120203	48195	325	13.277778	43.1527785	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	255	2.17e-63	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g47179	i0	99.291	97.5815384615385	141	1	43	0	172	312	249	389	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	31714	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
18879459	18879459	PRJNA1120203_P_NODE_48475_length_324_cov_28.637450_g47459_i0	PRJNA1120203	48475	324	28.63745	92.785338	root	1	Root_unresolved	Root_unresolved	296	1.27e-75	NTclustered	gi\|148723931\|gb\|EF520516.1\|	1211	g47459	i0	100	87.3086419753086	160	0	91	0	2	161	185	344	Uncultured cyanobacterium clone ADK-MOe02-64 16S ribosomal RNA gene, partial sequence	blastn	28288	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19400641	19400641	PRJNA1120203_P_NODE_33836_length_399_cov_15.616564_g32821_i0	PRJNA1120203	33836	399	15.616564	62.31009036	cyanobacterium ARS04158_00005	1564713	Bacteria	Bacteria	409	1.97e-109	NTclustered	gi\|704000437\|gb\|KM676599.1\|	1564713	g32821	i0	95.669	115.761904761905	254	11	91	0	3	256	2	255	Cyanobacterium ARS04158_00005 23S ribosomal RNA gene, partial sequence	blastn	46189	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium ARS04158_00005
19400977	19400977	PRJNA1120203_P_NODE_59236_length_292_cov_1.552511_g58220_i0	PRJNA1120203	59236	292	1.552511	4.53333212	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	243	1.5e-59	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g58220	i0	81.818	51.6643835616438	297	47	100	6	1	292	3681222	3680928	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15086	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20153920	20153920	PRJNA1120203_P_NODE_100256_length_243_cov_0.905882_g99240_i0	PRJNA1120203	100256	243	0.905882	2.20129326	Synechococcus	1129	Bacteria	Bacteria	339	1.4999999999999997e-88	NTclustered	gi\|1895806267\|gb\|CP047953.1\|	221341	g99240	i0	91.77	11.9876543209877	243	20	100	0	1	243	33645	33887	Synechococcus sp. Minos11 chromosome, complete genome	blastn	2913	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. Minos11
20154079	20154079	PRJNA1120203_P_NODE_30916_length_423_cov_2689.411429_g29901_i0	PRJNA1120203	30916	423	2689.411429	11376.21034467	Synechococcales	1890424	Bacteria	Bacteria	749	0	NTclustered	gi\|146740642\|emb\|AM709629.1\|	169675	g29901	i0	99.755	169.382978723404	408	1	96	0	3	410	4386	4793	Synechococcus rubescens SAG 3.81 partial ribosomal RNA operon, strain SAG 3.81	blastn	71649	749	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus rubescens
20154458	20154458	PRJNA1120203_P_NODE_73016_length_261_cov_21.611702_g72000_i0	PRJNA1120203	73016	261	21.611702	56.40654222	root	1	Root_unresolved	Root_unresolved	279	1e-70	NTclustered	gi\|326205684\|gb\|HQ827304.1\|	1211	g72000	i0	100	102.413793103448	151	0	99	0	109	259	425	275	Uncultured cyanobacterium clone ciam15_P1R2C06 16S ribosomal RNA gene, partial sequence	blastn	26730	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20675956	20675956	PRJNA1120203_P_NODE_105517_length_241_cov_0.916667_g104501_i0	PRJNA1120203	105517	241	0.916667	2.20916747	Synechococcus sp. RS9909	221352	Bacteria	Bacteria	78.7	3.58e-10	NTclustered	gi\|1895776483\|gb\|CP047943.1\|	221352	g104501	i0	95.833	0.199170124481328	48	2	20	0	102	149	1874174	1874221	Synechococcus sp. RS9909 chromosome, complete genome	blastn	48	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9909
21951547	21951547	PRJNA1120203_P_NODE_37358_length_375_cov_227.350993_g36343_i0	PRJNA1120203	37358	375	227.350993	852.56622375	cyanobacterium ARS04158_00005	1564713	Bacteria	Bacteria	457	6.47e-124	NTclustered	gi\|704000437\|gb\|KM676599.1\|	1564713	g36343	i0	98.828	124.026666666667	256	3	91	0	23	278	400	145	Cyanobacterium ARS04158_00005 23S ribosomal RNA gene, partial sequence	blastn	46510	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium ARS04158_00005
21951707	21951707	PRJNA1120203_P_NODE_48478_length_324_cov_13.553785_g47462_i0	PRJNA1120203	48478	324	13.553785	43.9142634	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	254	7.77e-63	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g47462	i0	96.711	122.697530864198	152	5	90	0	173	324	1777375	1777526	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	39754	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
21952051	21952051	PRJNA1120203_P_NODE_71198_length_265_cov_2.218750_g70182_i0	PRJNA1120203	71198	265	2.21875	5.8796875	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	257	4.78e-64	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g70182	i0	84.351	2.99245283018868	262	41	99	0	1	262	1350677	1350416	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	793	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
22704759	22704759	PRJNA1120203_P_NODE_48178_length_325_cov_79.198413_g47162_i0	PRJNA1120203	48178	325	79.198413	257.39484225	root	1	Root_unresolved	Root_unresolved	287	7.69e-73	NTclustered	gi\|157063922\|gb\|EF630233.1\|	1211	g47162	i0	99.367	89.4523076923077	158	1	49	0	3	160	296	453	Uncultured cyanobacterium clone W04MLD7R 16S ribosomal RNA gene, partial sequence	blastn	29072	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22704760	22704760	PRJNA1120203_P_NODE_48218_length_325_cov_3.630952_g47202_i0	PRJNA1120203	48218	325	3.630952	11.800594	root	1	Root_unresolved	Root_unresolved	274	5.989999999999998e-69	NTclustered	gi\|195360595\|gb\|EU882171.1\|	1211	g47202	i0	99.338	77.8369230769231	151	1	46	0	174	324	239	89	Uncultured cyanobacterium isolate DGGE gel band MB-05-CYA-B2-8 16S ribosomal RNA gene, partial sequence	blastn	25297	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23227221	23227221	PRJNA1120203_P_NODE_48199_length_325_cov_10.960317_g47183_i0	PRJNA1120203	48199	325	10.960317	35.62103025	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	276	1.6599999999999999e-69	NTclustered	gi\|453199516\|gb\|JQ997496.1\|	259957	g47183	i0	99.342	100.243076923077	152	1	47	0	174	325	368	217	Uncultured Chroococcidiopsis sp. clone GKJWQY101ANW47 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32579	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23227835	23227835	PRJNA1120203_P_NODE_89819_length_247_cov_0.885057_g88803_i0	PRJNA1120203	89819	247	0.885057	2.18609079	Synechococcus sp. RS9907	221350	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|1895779638\|gb\|CP047944.1\|	221350	g88803	i0	78.543	20.3279352226721	247	45	98	7	5	247	2564795	2564553	Synechococcus sp. RS9907 chromosome, complete genome	blastn	5021	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9907
23227924	23227924	PRJNA1120203_P_NODE_95419_length_245_cov_0.895349_g94403_i0	PRJNA1120203	95419	245	0.895349	2.19360505	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	377	3.21e-100	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g94403	i0	98.148	6.8734693877551	216	4	100	0	30	245	1781739	1781954	Synechococcus sp. LTW-R chromosome, complete genome	blastn	1684	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R
24500876	24500876	PRJNA1120203_P_NODE_48200_length_325_cov_10.936508_g47184_i0	PRJNA1120203	48200	325	10.936508	35.543651	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	255	2.17e-63	NTclustered	gi\|745734118\|gb\|KM458372.1\|	183215	g47184	i0	99.291	92.4	141	1	43	0	14	154	389	249	Uncultured Pleurocapsales cyanobacterium isolate OTU 00115 23S ribosomal RNA gene, partial sequence	blastn	30030	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
24501521	24501521	PRJNA1120203_P_NODE_94080_length_245_cov_0.895349_g93064_i0	PRJNA1120203	94080	245	0.895349	2.19360505	Synechococcus sp. LTW-R	2751170	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|1891299085\|gb\|CP059060.1\|	2751170	g93064	i0	97.959	3.97959183673469	245	5	100	0	1	245	1862902	1862658	Synechococcus sp. LTW-R chromosome, complete genome	blastn	975	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LTW-R

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