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

20 rows where analysis = "blastn", bioproject = "PRJNA1036688" 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
169661	169661	PRJNA1036688_P_NODE_661_length_888_cov_38.274971_g466_i0	PRJNA1036688	661	888	38.274971	339.88174248	Nostoc commune	1178	Bacteria	Bacteria	1282	0	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g466	i0	92.721	286.418918918919	893	57	100	7	1	888	1737545	1738434	Nostoc cf. commune SO-36 DNA, complete genome	blastn	254340	1282	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
1008103	1008103	PRJNA1036688_P_NODE_721_length_851_cov_38.979115_g518_i0	PRJNA1036688	721	851	38.979115	331.71226865	Oscillatoriales	1150	Bacteria	Bacteria	1507	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g518	i0	98.593	129.207990599295	853	10	100	2	1	851	1728	2580	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	109956	1517	0.99340804218853	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1444346	1444346	PRJNA1036688_P_NODE_722_length_851_cov_37.912776_g519_i0	PRJNA1036688	722	851	37.912776	322.63772376	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1247	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g519	i0	93.116	183.012925969448	857	50	100	9	1	851	2369	1516	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	155744	1247	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3558750	3558750	PRJNA1036688_P_NODE_643_length_901_cov_33.047454_g453_i0	PRJNA1036688	643	901	33.047454	297.75756054	Oscillatoriales	1150	Bacteria	Bacteria	1583	0	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g453	i0	98.443	146.5371809101	899	14	99	0	1	899	1867	969	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	132030	1594	0.993099121706399	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3996177	3996177	PRJNA1036688_P_NODE_724_length_850_cov_38.353014_g521_i0	PRJNA1036688	724	850	38.353014	326.000619	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1242	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g521	i0	92.982	106.778823529412	855	55	100	4	1	850	2525	1671	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	90762	1242	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4836130	4836130	PRJNA1036688_P_NODE_2604_length_421_cov_19.252604_g2314_i0	PRJNA1036688	2604	421	19.252604	81.05346284	Nostoc	1177	Bacteria	Bacteria	549	1.1799999999999999e-151	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g2314	i0	90.33	168.261282660333	424	34	100	7	1	421	3060196	3059777	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	70838	551	0.996370235934664	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
4836131	4836131	PRJNA1036688_P_NODE_2624_length_419_cov_39.049738_g2334_i0	PRJNA1036688	2624	419	39.049738	163.61840222	Nostocaceae	1162	Bacteria	Bacteria	702	0	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g2334	i0	96.912	282.90692124105	421	9	100	4	1	419	730	312	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	118538	702	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
5272475	5272475	PRJNA1036688_P_NODE_11205_length_158_cov_2.702479_g10913_i0	PRJNA1036688	11205	158	2.702479	4.26991682	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	270	3.3099999999999996e-68	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g10913	i0	97.468	116.626582278481	158	4	100	0	1	158	2653	2810	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18427	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9097276	9097276	PRJNA1036688_P_NODE_7228_length_209_cov_2.529070_g6936_i0	PRJNA1036688	7228	209	2.52907	5.2857563	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	206	1.3299999999999998e-48	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g6936	i0	88.757	19.0765550239234	169	18	81	1	38	206	2831865	2832032	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	3987	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
9936204	9936204	PRJNA1036688_P_NODE_8288_length_191_cov_1.779221_g7996_i0	PRJNA1036688	8288	191	1.779221	3.39831211	Drouetiella	2303513	Bacteria	Bacteria	228	2.539999999999999e-55	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g7996	i0	97.727	88.0418848167539	132	3	69	0	60	191	2172	2041	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	16816	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica
10372896	10372896	PRJNA1036688_P_NODE_449_length_1082_cov_39.881340_g287_i0	PRJNA1036688	449	1082	39.88134	431.5160988	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1557	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g287	i0	92.784	131.630314232902	1081	71	99	6	1	1080	2168	3242	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	142424	1557	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11211406	11211406	PRJNA1036688_P_NODE_3829_length_326_cov_46.948097_g3538_i0	PRJNA1036688	3829	326	46.948097	153.05079622	Cyanophyceae	3028117	Bacteria	Bacteria	547	3.209999999999999e-151	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g3538	i0	96.933	140.193251533742	326	10	100	0	1	326	704	1029	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	45703	547	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
12923393	12923393	PRJNA1036688_P_NODE_7411_length_205_cov_3.142857_g7119_i0	PRJNA1036688	7411	205	3.142857	6.44285685	uncultured cyanobacterium	1211	Bacteria	Bacteria	252	1.64e-62	NTclustered	gi\|312985591\|gb\|HQ189102.1\|	1211	g7119	i0	88.78	89.1951219512195	205	23	100	0	1	205	208	4	Uncultured cyanobacterium clone B90201C 16S ribosomal RNA gene, partial sequence	blastn	18285	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13761474	13761474	PRJNA1036688_P_NODE_2191_length_468_cov_56.132251_g1902_i0	PRJNA1036688	2191	468	56.132251	262.69893468	Nodularia	159191	Bacteria	Bacteria	769	0	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g1902	i0	96.375	293.337606837607	469	13	100	3	1	468	2506518	2506983	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	137282	769	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14198277	14198277	PRJNA1036688_P_NODE_772_length_815_cov_29.421594_g562_i0	PRJNA1036688	772	815	29.421594	239.7859911	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1070	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g562	i0	90.541	132.546012269939	814	70	99	6	3	815	3242	2435	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	108025	1070	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19295489	19295489	PRJNA1036688_P_NODE_516_length_1013_cov_35.340164_g340_i0	PRJNA1036688	516	1013	35.340164	357.99586132	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1605	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g340	i0	95.262	102.555774925962	1013	48	100	0	1	1013	3180	2168	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	103889	1605	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20570844	20570844	PRJNA1036688_P_NODE_657_length_890_cov_46.409144_g462_i0	PRJNA1036688	657	890	46.409144	413.0413816	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1242	0	NTclustered	gi\|225696227\|gb\|FJ805894.1\|	259957	g462	i0	91.871	135.68202247191	898	60	99	11	1	889	2591	1698	Uncultured Chroococcidiopsis sp. clone NA2_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	120757	1242	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23121986	23121986	PRJNA1036688_P_NODE_999_length_705_cov_19.285928_g765_i0	PRJNA1036688	999	705	19.285928	135.9657924	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	747	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g765	i0	86.014	141.46524822695	715	78	100	15	1	705	3411	2709	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	99733	747	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24395728	24395728	PRJNA1036688_P_NODE_6020_length_239_cov_1.787129_g5728_i0	PRJNA1036688	6020	239	1.787129	4.27123831	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	359	1.13e-94	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g5728	i0	94.093	89.8493723849372	237	12	99	1	3	239	2151727	2151961	Leptolyngbya sp. 7M chromosome	blastn	21474	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
25234344	25234344	PRJNA1036688_P_NODE_940_length_726_cov_13.277213_g712_i0	PRJNA1036688	940	726	13.277213	96.39256638	Nostocales	1161	Bacteria	Bacteria	989	0	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g712	i0	91.865	159.789256198347	713	49	97	9	20	726	821	112	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	116007	989	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis

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