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

29 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
451995	451995	PRJNA492280_P_NODE_1881_length_330_cov_3.907850_g1774_i0	PRJNA492280	1881	330	3.90785	12.895905	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	339	2.13e-88	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g1774	i0	92.149	97.8636363636364	242	15	73	3	4	243	2151635	2151874	Leptolyngbya sp. 7M chromosome	blastn	32295	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
1726874	1726874	PRJNA492280_P_NODE_602_length_555_cov_48.250965_g519_i0	PRJNA492280	602	555	48.250965	267.79285575	Drouetiella epilithica	3059494	Bacteria	Bacteria	819	0	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g519	i0	93.333	195.372972972973	555	36	100	1	1	555	2470	1917	Drouetiella epilithica ACKU670 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	108432	819	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica
1726888	1726888	PRJNA492280_P_NODE_6702_length_201_cov_3.701220_g6595_i0	PRJNA492280	6702	201	3.70122	7.4394522	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	124	3.6499999999999996e-24	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g6595	i0	84.211	10.044776119403	133	15	64	4	3	131	2152103	2151973	Leptolyngbya sp. 7M chromosome	blastn	2019	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
2374459	2374459	PRJNA492280_P_NODE_2702_length_287_cov_41.772000_g2595_i0	PRJNA492280	2702	287	41.772	119.88564	Cyanophyceae	3028117	Bacteria	Bacteria	385	2.2999999999999995e-102	NTclustered	gi\|1373417989\|gb\|KY511273.1\|	2136406	g2595	i0	91.228	154.08362369338	285	21	98	3	3	284	344	61	Trichotorquatus maritimus SMER-A clone 2 23S ribosomal RNA gene, partial sequence; 23S-5S intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	44222	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Trichotorquatus	Trichotorquatus maritimus
3002639	3002639	PRJNA492280_P_NODE_1883_length_330_cov_3.406143_g1776_i0	PRJNA492280	1883	330	3.406143	11.2402719	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	344	4.58e-90	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g1776	i0	92.562	81.6484848484849	242	14	73	3	4	243	2151635	2151874	Leptolyngbya sp. 7M chromosome	blastn	26944	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4279069	4279069	PRJNA492280_P_NODE_2784_length_285_cov_2.576613_g2677_i0	PRJNA492280	2784	285	2.576613	7.34334705	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	327	3.909999999999999e-85	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g2677	i0	96.482	131.277192982456	199	5	88	2	86	282	2341	2143	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	37414	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4279184	4279184	PRJNA492280_P_NODE_6124_length_208_cov_7.859649_g6017_i0	PRJNA492280	6124	208	7.859649	16.34806992	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	346	7.460000000000001e-91	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g6017	i0	97.525	111.466346153846	202	5	97	0	4	205	2003	2204	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	23185	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4927095	4927095	PRJNA492280_P_NODE_30304_length_151_cov_4.500000_g30197_i0	PRJNA492280	30304	151	4.5	6.795	Bacillati	1783272	Bacteria	Bacteria	137	3.31e-28	NTclustered	gi\|428692674\|gb\|CP003944.1\|	13035	g30197	i0	98.701	90.2582781456954	77	1	51	0	75	151	890275	890199	Dactylococcopsis salina PCC 8305, complete genome	blastn	13629	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Cymatolegaceae	Dactylococcopsis	Dactylococcopsis salina
6202322	6202322	PRJNA492280_P_NODE_9825_length_171_cov_4.567164_g9718_i0	PRJNA492280	9825	171	4.567164	7.80985044	Nodosilinea	1120752	Bacteria	Bacteria	178	2.26e-40	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g9718	i0	88.199	164.994152046784	161	4	94	1	4	164	3220	3365	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28214	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
6829556	6829556	PRJNA492280_P_NODE_25806_length_164_cov_2.354331_g25699_i0	PRJNA492280	25806	164	2.354331	3.86110284	Microcoleus vaginatus	119532	Bacteria	Bacteria	115	1.72e-21	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g25699	i0	94.595	0.451219512195122	74	4	45	0	90	163	4257144	4257071	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	74	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
6829591	6829591	PRJNA492280_P_NODE_28766_length_153_cov_14.887931_g28659_i0	PRJNA492280	28766	153	14.887931	22.77853443	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	237	3.22e-58	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g28659	i0	94.737	173.601307189542	152	8	99	0	2	153	2841	2690	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	26561	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
8105032	8105032	PRJNA492280_P_NODE_17747_length_164_cov_3.771654_g17640_i0	PRJNA492280	17747	164	3.771654	6.18551256	Oscillatoria acuminata	118323	Bacteria	Bacteria	134	4.75e-27	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g17640	i0	98.667	183.798780487805	75	1	90	0	90	164	3801630	3801704	Oscillatoria acuminata PCC 6304, complete genome	blastn	30143	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
8105309	8105309	PRJNA492280_P_NODE_9267_length_176_cov_3.100719_g9160_i0	PRJNA492280	9267	176	3.100719	5.45726544	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	150	5.12e-32	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g9160	i0	97.701	83.3465909090909	87	2	49	0	2	88	1561	1647	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	14669	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8751969	8751969	PRJNA492280_P_NODE_3407_length_263_cov_28.500000_g3300_i0	PRJNA492280	3407	263	28.5	74.955	root	1	Root_unresolved	Root_unresolved	460	3.37e-125	NTclustered	gi\|1026287172\|gb\|KU218946.1\|	1211	g3300	i0	98.837	100.688212927757	258	3	98	0	6	263	373	116	Uncultured cyanobacterium clone MnSV_DE08835H06 16S ribosomal RNA gene, partial sequence	blastn	26481	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9380019	9380019	PRJNA492280_P_NODE_7628_length_190_cov_4.941176_g7521_i0	PRJNA492280	7628	190	4.941176	9.3882344	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	8.83e-75	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g7521	i0	95.135	86.3368421052632	185	9	97	0	4	188	1793	1977	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	16404	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10655830	10655830	PRJNA492280_P_NODE_5149_length_224_cov_9.133690_g5042_i0	PRJNA492280	5149	224	9.13369	20.4594656	Trichocoleus desertorum	1481672	Bacteria	Bacteria	167	6.81e-37	NTclustered	gi\|2531337825\|gb\|CP116619.1\|	3023083	g5042	i0	80.444	15.75	225	39	99	5	1	221	1936016	1936239	Trichocoleus desertorum NBK24 chromosome	blastn	3528	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
11302315	11302315	PRJNA492280_P_NODE_8849_length_179_cov_4.852113_g8742_i0	PRJNA492280	8849	179	4.852113	8.68528227	Chroococcidiopsis	54298	Bacteria	Bacteria	122	1.1399999999999999e-23	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g8742	i0	80.745	64.6033519553073	161	28	89	3	4	163	2676	2834	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	11564	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13852552	13852552	PRJNA492280_P_NODE_271_length_765_cov_25.811813_g210_i0	PRJNA492280	271	765	25.811813	197.46036945	Stenomitos	1844270	Bacteria	Bacteria	1136	0	NTclustered	gi\|225696245\|gb\|FJ805912.1\|	1211	g210	i0	93.693	181.776470588235	761	44	99	4	4	762	2187	2945	Uncultured cyanobacterium clone AN2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	139059	1140	0.996491228070175	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14480646	14480646	PRJNA492280_P_NODE_29212_length_152_cov_3.200000_g29105_i0	PRJNA492280	29212	152	3.2	4.864	uncultured cyanobacterium	1211	Bacteria	Bacteria	200	4.1899999999999997e-47	NTclustered	gi\|146141747\|gb\|EF522251.1\|	1211	g29105	i0	91.667	89.9868421052632	144	12	95	0	9	152	551	694	Uncultured cyanobacterium clone FQSS031 16S ribosomal RNA gene, partial sequence	blastn	13678	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15126980	15126980	PRJNA492280_P_NODE_2892_length_280_cov_10.065844_g2785_i0	PRJNA492280	2892	280	10.065844	28.1843632	Oscillatoriales	1150	Bacteria	Bacteria	507	4.58e-139	NTclustered	gi\|428274174\|gb\|KC146552.1\|	1211	g2785	i0	99.639	154.335714285714	277	1	99	0	2	278	300	24	Uncultured cyanobacterium clone MID5_rep_c3135 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43214	512	0.990234375	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15754794	15754794	PRJNA492280_P_NODE_9453_length_174_cov_4.693431_g9346_i0	PRJNA492280	9453	174	4.693431	8.16656994	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	178	2.31e-40	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g9346	i0	85.799	2.9367816091954	169	22	97	2	1	168	452365	452198	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	511	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
17029244	17029244	PRJNA492280_P_NODE_21334_length_164_cov_3.094488_g21227_i0	PRJNA492280	21334	164	3.094488	5.07496032	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	252	1.26e-62	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g21227	i0	92.638	102.384146341463	163	10	99	1	1	163	1936257	1936097	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	16791	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
17676497	17676497	PRJNA492280_P_NODE_18254_length_164_cov_3.645669_g18147_i0	PRJNA492280	18254	164	3.645669	5.97889716	Nostoc	1177	Bacteria	Bacteria	202	1.28e-47	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g18147	i0	90.683	252.707317073171	161	2	98	1	2	162	1737937	1737790	Nostoc cf. commune SO-36 DNA, complete genome	blastn	41444	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
18950674	18950674	PRJNA492280_P_NODE_9215_length_176_cov_4.870504_g9108_i0	PRJNA492280	9215	176	4.870504	8.57208704	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g9108	i0	100	98.2613636363636	173	0	98	0	1	173	242	70	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	17294	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19577968	19577968	PRJNA492280_P_NODE_6916_length_198_cov_4.751553_g6809_i0	PRJNA492280	6916	198	4.751553	9.40807494	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	243	9.49e-60	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g6809	i0	90.625	106.808080808081	192	4	97	2	4	195	2898	2721	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21148	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20853799	20853799	PRJNA492280_P_NODE_7417_length_192_cov_7.638710_g7310_i0	PRJNA492280	7417	192	7.63871	14.6663232	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	331	1.9e-86	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g7310	i0	98.413	132.84375	189	2	98	1	2	189	3029	2841	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	25506	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22128454	22128454	PRJNA492280_P_NODE_31938_length_151_cov_2.412281_g31831_i0	PRJNA492280	31938	151	2.412281	3.64254431	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	137	3.31e-28	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g31831	i0	87.097	139.894039735099	124	12	81	4	3	124	1358	1479	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	21124	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
22775924	22775924	PRJNA492280_P_NODE_20758_length_164_cov_3.212598_g20651_i0	PRJNA492280	20758	164	3.212598	5.26866072	Cyanophyceae	3028117	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|298231375\|emb\|FN811246.1\|	1211	g20651	i0	100	85.1280487804878	76	0	91	0	1	76	1251	1176	Uncultured cyanobacterium partial 16S rRNA gene, clone UMAB-cl-62	blastn	13961	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23404254	23404254	PRJNA492280_P_NODE_23199_length_164_cov_2.834646_g23092_i0	PRJNA492280	23199	164	2.8346460000000002	4.64881944	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	69.4	1.36e-7	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g23092	i0	86.885	0.371951219512195	61	8	37	0	5	65	4663207	4663147	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	61	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870

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