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

26 rows where analysis = "blastn", bioproject = "PRJNA900999" 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
878080	878080	PRJNA900999_S_NODE_1421_length_304_cov_17.796364_g1365_i0	PRJNA900999	1421	304	17.796364	54.10094656	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	411	4.059999999999999e-110	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g1365	i0	91.118	115.128289473684	304	26	100	1	1	304	2128	1826	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	34999	411	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1246000	1246000	PRJNA900999_S_NODE_381_length_475_cov_22.150224_g329_i0	PRJNA900999	381	475	22.150224	105.213564	Chroococcaceae	1890464	Bacteria	Bacteria	680	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g329	i0	92.781	199.604210526316	471	33	99	1	5	475	2466	1997	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	94812	680	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
1246011	1246011	PRJNA900999_S_NODE_681_length_386_cov_6.994398_g626_i0	PRJNA900999	681	386	6.994398	26.99837628	Oscillatoriales	1150	Bacteria	Bacteria	560	4.949999999999999e-155	NTclustered	gi\|55741013\|gb\|AY672718.1\|	54297	g626	i0	94.505	96.1865284974093	364	19	94	1	24	386	588	225	Arthrospira fusiformis strain AICB 664 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37128	562	0.99644128113879	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira fusiformis
2153408	2153408	PRJNA900999_S_NODE_4202_length_209_cov_10.188889_g4146_i0	PRJNA900999	4202	209	10.188889	21.29477801	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	294	2.76e-75	NTclustered	gi\|225696228\|gb\|FJ805895.1\|	259957	g4146	i0	94.301	122.913875598086	193	10	92	1	18	209	1679	1871	Uncultured Chroococcidiopsis sp. clone NA2_9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	25689	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3428823	3428823	PRJNA900999_S_NODE_1443_length_303_cov_38.989051_g1387_i0	PRJNA900999	1443	303	38.989051	118.13682453	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	483	8.45e-132	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g1387	i0	95.395	150.805280528053	304	12	100	2	1	303	521	219	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	45694	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
3797974	3797974	PRJNA900999_S_NODE_6363_length_178_cov_9.919463_g6307_i0	PRJNA900999	6363	178	9.919463	17.65664414	root	1	Root_unresolved	Root_unresolved	60.2	9e-5	NTclustered	gi\|341958203\|gb\|JN006617.1\|	1211	g6307	i0	97.222	23.1011235955056	36	0	20	1	1	36	1011	977	Uncultured cyanobacterium clone StB_12m_c71 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	4112	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5981339	5981339	PRJNA900999_S_NODE_1045_length_337_cov_32.957792_g989_i0	PRJNA900999	1045	337	32.957792	111.06775904	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	555	1.9899999999999994e-153	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g989	i0	96.697	247.175074183976	333	11	99	0	1	333	166	498	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	83298	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
7256181	7256181	PRJNA900999_S_NODE_246_length_542_cov_21.148148_g205_i0	PRJNA900999	246	542	21.148148	114.62296216	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	555	3.33e-153	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g205	i0	87.129	203.317343173432	505	46	93	10	36	538	11	498	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	110198	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
8898925	8898925	PRJNA900999_S_NODE_3747_length_219_cov_3.494737_g3691_i0	PRJNA900999	3747	219	3.494737	7.65347403	root	1	Root_unresolved	Root_unresolved	276	1.06e-69	NTclustered	gi\|972297463\|gb\|KT271139.1\|	1211	g3691	i0	97.516	74.8949771689498	161	4	74	0	59	219	183	23	Uncultured cyanobacterium isolate 1207VA10 clone 80 16S ribosomal RNA gene, partial sequence	blastn	16402	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9805994	9805994	PRJNA900999_S_NODE_268_length_526_cov_25.279678_g224_i0	PRJNA900999	268	526	25.279678	132.97110628	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	662	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g224	i0	90.619	197.61216730038	501	44	95	3	5	503	2466	1967	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	103944	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
12357011	12357011	PRJNA900999_S_NODE_1830_length_282_cov_22.822134_g1774_i0	PRJNA900999	1830	282	22.822134	64.35841788	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	398	2.9e-106	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g1774	i0	92.5	212.900709219858	280	17	99	4	1	278	1686	1963	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	60038	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12357038	12357038	PRJNA900999_S_NODE_3510_length_224_cov_19.974359_g3454_i0	PRJNA900999	3510	224	19.974359	44.74256416	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	274	3.9e-69	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3454	i0	89.72	30.90625	214	22	96	0	11	224	2150425	2150638	Leptolyngbya sp. 7M chromosome	blastn	6923	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
12357058	12357058	PRJNA900999_S_NODE_5510_length_188_cov_527.603774_g5454_i0	PRJNA900999	5510	188	527.603774	991.89509512	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	165	1.98e-36	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5454	i0	85.897	205.18085106383	156	20	82	1	1	154	3682416	3682571	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	38574	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12357085	12357085	PRJNA900999_S_NODE_830_length_362_cov_19.120120_g774_i0	PRJNA900999	830	362	19.12012	69.2148344	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	375	1.79e-99	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g774	i0	100	145.707182320442	203	0	100	0	1	203	1874240	1874038	Calothrix sp. PCC 6303, complete genome	blastn	52746	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
12357094	12357094	PRJNA900999_S_NODE_9870_length_150_cov_3.107438_g9814_i0	PRJNA900999	9870	150	3.107438	4.661157	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	134	4.2400000000000006e-27	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g9814	i0	83.66	114.733333333333	153	14	98	9	4	150	1245939	1245792	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	17210	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
12725547	12725547	PRJNA900999_S_NODE_1230_length_319_cov_5.831034_g1174_i0	PRJNA900999	1230	319	5.831034	18.60099846	Limnospira	2596745	Bacteria	Bacteria	396	1.1999999999999997e-105	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g1174	i0	91.186	158.134796238245	295	21	92	5	1	292	813347	813055	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	50445	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
15273960	15273960	PRJNA900999_S_NODE_1832_length_282_cov_22.430830_g1776_i0	PRJNA900999	1832	282	22.43083	63.2549406	Cyanophyceae	3028117	Bacteria	Bacteria	398	2.9e-106	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g1776	i0	92.446	130.921985815603	278	21	99	0	1	278	2603	2880	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	36920	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
18729478	18729478	PRJNA900999_S_NODE_2135_length_268_cov_25.552301_g2079_i0	PRJNA900999	2135	268	25.552301	68.48016668	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	364	2.769999999999999e-96	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g2079	i0	92.857	151.962686567164	252	16	94	2	3	253	1706	1456	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	40726	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19097501	19097501	PRJNA900999_S_NODE_495_length_431_cov_6.039801_g442_i0	PRJNA900999	495	431	6.039801	26.03154231	Oscillatoriales	1150	Bacteria	Bacteria	573	7.179999999999999e-159	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g442	i0	92.519	140.296983758701	401	29	94	1	7	406	813086	812686	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	60468	573	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
20372331	20372331	PRJNA900999_S_NODE_1216_length_321_cov_6.626712_g1160_i0	PRJNA900999	1216	321	6.626712	21.27174552	Limnospira	2596745	Bacteria	Bacteria	586	6.679999999999997e-163	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g1160	i0	99.688	169.1246105919	320	1	99	0	2	321	813680	813361	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	54289	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
21648164	21648164	PRJNA900999_S_NODE_517_length_424_cov_5.202532_g463_i0	PRJNA900999	517	424	5.202532	22.05873568	Oscillatoriales	1150	Bacteria	Bacteria	534	3.329999999999999e-147	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g463	i0	90.097	149.945754716981	414	38	98	3	7	418	812674	813086	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	63577	536	0.996268656716418	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
22554905	22554905	PRJNA900999_S_NODE_1778_length_285_cov_22.285156_g1722_i0	PRJNA900999	1778	285	22.285156	63.5126946	Kovacikia minuta	2931930	Bacteria	Bacteria	403	6.31e-108	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g1722	i0	92.281	140.778947368421	285	20	99	2	2	285	4176264	4176547	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	40122	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
22554918	22554918	PRJNA900999_S_NODE_258_length_535_cov_21.175889_g216_i0	PRJNA900999	258	535	21.175889	113.29100615	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	545	1.98e-150	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g216	i0	86.759	243.633644859813	506	48	94	11	5	508	498	10	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	130344	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
22923675	22923675	PRJNA900999_S_NODE_2638_length_249_cov_7.040909_g2582_i0	PRJNA900999	2638	249	7.040909	17.53186341	Oscillatoriales	1150	Bacteria	Bacteria	418	1.9299999999999995e-112	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g2582	i0	100	149.506024096386	226	0	91	0	4	229	811655	811430	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	37227	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
24197502	24197502	PRJNA900999_S_NODE_1459_length_302_cov_24.391941_g1403_i0	PRJNA900999	1459	302	24.391941	73.66366182	Oscillatoriales	1150	Bacteria	Bacteria	407	5.21e-109	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g1403	i0	91.304	146.831125827815	299	24	99	2	1	298	811632	811929	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	44343	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
25472674	25472674	PRJNA900999_S_NODE_260_length_533_cov_6.744048_g217_i0	PRJNA900999	260	533	6.744048	35.94577584	Oscillatoriales	1150	Bacteria	Bacteria	904	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g217	i0	99.008	162.866791744841	504	5	95	0	24	527	812583	813086	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	86808	904	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica

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