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

21 rows where analysis = "blastn", bioproject = "PRJNA826497" 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
820628	820628	PRJNA826497_S_NODE_11561_length_179_cov_4.041096_g11521_i0	PRJNA826497	11561	179	4.041096	7.23356184	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	305	1.05e-78	NTclustered	gi\|225696189\|gb\|FJ805856.1\|	259957	g11521	i0	97.753	148.22905027933	178	3	99	1	1	177	3283	3106	Uncultured Chroococcidiopsis sp. clone AR2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26533	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3371502	3371502	PRJNA826497_S_NODE_7623_length_202_cov_4.662722_g7583_i0	PRJNA826497	7623	202	4.662722	9.41869844	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	178	2.7799999999999993e-40	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g7583	i0	84.153	77.6386138613861	183	29	91	0	20	202	2364812	2364994	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	15683	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
4648995	4648995	PRJNA826497_S_NODE_14184_length_168_cov_3.303704_g14144_i0	PRJNA826497	14184	168	3.303704	5.55022272	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	130	6.34e-26	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g14144	i0	86.957	1.63690476190476	115	15	68	0	54	168	2042321	2042435	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	275	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5923886	5923886	PRJNA826497_S_NODE_7785_length_201_cov_3.833333_g7745_i0	PRJNA826497	7785	201	3.833333	7.70499933	Halotia branconii	1620816	Bacteria	Bacteria	239	1.25e-58	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g7745	i0	88.718	11.6169154228856	195	22	97	0	5	199	712227	712033	Halotia branconii CENA392 chromosome, complete genome	blastn	2335	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
6332325	6332325	PRJNA826497_S_NODE_8545_length_196_cov_3.343558_g8505_i0	PRJNA826497	8545	196	3.343558	6.55337368	Limnospira	2596745	Bacteria	Bacteria	363	6.899999999999998e-96	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g8505	i0	100	6.69897959183673	196	0	100	0	1	196	2628592	2628397	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1313	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
7198757	7198757	PRJNA826497_S_NODE_166_length_583_cov_158.221818_g141_i0	PRJNA826497	166	583	158.221818	922.43319894	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	859	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g141	i0	94.326	121.481989708405	564	27	96	4	23	582	2089	1527	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	70824	859	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8473520	8473520	PRJNA826497_S_NODE_167_length_583_cov_134.561818_g142_i0	PRJNA826497	167	583	134.561818	784.49539894	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	732	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g142	i0	90.265	154.114922813036	565	48	96	6	23	582	2089	1527	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	89849	732	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8473573	8473573	PRJNA826497_S_NODE_8627_length_195_cov_9.691358_g8587_i0	PRJNA826497	8627	195	9.691358	18.8981481	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	255	1.2e-63	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g8587	i0	90.306	114.507692307692	196	17	99	2	2	195	1859	2054	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	22329	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9748680	9748680	PRJNA826497_S_NODE_488_length_405_cov_118.768817_g448_i0	PRJNA826497	488	405	118.768817	481.01370885	Hassallia byssoidea	482630	Bacteria	Bacteria	503	8.919999999999998e-138	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g448	i0	93.976	199.032098765432	332	20	82	0	74	405	1950	2281	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	80608	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
10156749	10156749	PRJNA826497_S_NODE_3768_length_244_cov_3.620853_g3728_i0	PRJNA826497	3768	244	3.620853	8.83488132	Cyanophyceae	3028117	Bacteria	Bacteria	228	3.409999999999999e-55	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g3728	i0	83.673	35.6229508196721	245	36	99	3	1	243	3756297	3756055	Oscillatoria acuminata PCC 6304, complete genome	blastn	8692	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
11024326	11024326	PRJNA826497_S_NODE_12969_length_173_cov_3.250000_g12929_i0	PRJNA826497	12969	173	3.25	5.6225	Microcystis aeruginosa	1126	Bacteria	Bacteria	198	1.7599999999999998e-46	NTclustered	gi\|1787232413\|gb\|CP046973.1\|	2686288	g12929	i0	87.283	85.5953757225434	173	22	100	0	1	173	514951	514779	Microcystis aeruginosa FD4 chromosome, complete genome	blastn	14808	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
11024395	11024395	PRJNA826497_S_NODE_6949_length_208_cov_2.274286_g6909_i0	PRJNA826497	6949	208	2.274286	4.73051488	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	174	3.73e-39	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g6909	i0	82.902	0.927884615384615	193	33	93	0	3	195	5459210	5459402	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	193	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
12299847	12299847	PRJNA826497_S_NODE_2190_length_278_cov_36.432653_g2150_i0	PRJNA826497	2190	278	36.432653	101.28277534	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	472	1.6599999999999998e-128	NTclustered	gi\|225696239\|gb\|FJ805906.1\|	259957	g2150	i0	100	125.561151079137	255	0	92	0	23	277	2168	1914	Uncultured Chroococcidiopsis sp. clone NA3_9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	34906	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12707768	12707768	PRJNA826497_S_NODE_170_length_582_cov_135.714026_g145_i0	PRJNA826497	170	582	135.714026	789.85563132	Chroococcidiopsidales	1890505	Bacteria	Bacteria	693	0	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g145	i0	89.007	102.979381443299	564	56	96	5	23	581	2089	1527	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	59934	695	0.997122302158273	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16530867	16530867	PRJNA826497_S_NODE_10673_length_183_cov_6.140000_g10633_i0	PRJNA826497	10673	183	6.14	11.2362	Hassallia	482629	Bacteria	Bacteria	239	1.11e-58	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g10633	i0	90.71	225.732240437158	183	11	98	5	1	180	2366	2187	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	41309	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
17398949	17398949	PRJNA826497_S_NODE_1174_length_324_cov_3.591065_g1134_i0	PRJNA826497	1174	324	3.591065	11.6350506	Nostoc sp. TCL26-01	2576904	Bacteria	Bacteria	159	1.74e-34	NTclustered	gi\|1866654106\|gb\|CP040297.1\|	2576904	g1134	i0	76.527	0.959876543209877	311	62	95	11	3	311	4593157	4593458	Nostoc sp. TCL26-01 chromosome, complete genome	blastn	311	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
17398970	17398970	PRJNA826497_S_NODE_17234_length_158_cov_2.816000_g17194_i0	PRJNA826497	17234	158	2.816	4.44928	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	274	2.56e-69	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g17194	i0	98.089	140.424050632911	157	3	99	0	2	158	2549	2393	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	22187	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21222721	21222721	PRJNA826497_S_NODE_837_length_353_cov_5.118750_g797_i0	PRJNA826497	837	353	5.11875	18.0691875	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	521	2.1199999999999993e-143	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g797	i0	93.484	134.538243626062	353	19	99	3	4	353	3027	3378	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	47492	521	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22497333	22497333	PRJNA826497_S_NODE_10198_length_186_cov_2.470588_g10158_i0	PRJNA826497	10198	186	2.470588	4.59529368	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	246	6.8e-61	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g10158	i0	90.761	151.188172043011	184	17	99	0	3	186	4055788	4055971	Gloeocapsa sp. PCC 7428, complete genome	blastn	28121	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
22497335	22497335	PRJNA826497_S_NODE_10358_length_185_cov_3.052632_g10318_i0	PRJNA826497	10358	185	3.052632	5.6473692	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	263	6.7e-66	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g10318	i0	92.513	109.762162162162	187	9	100	4	1	185	2961	2778	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	20306	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24179857	24179857	PRJNA826497_S_NODE_16239_length_161_cov_2.812500_g16199_i0	PRJNA826497	16239	161	2.8125	4.528125	Nodosilinea	1120752	Bacteria	Bacteria	80.5	6.14e-11	NTclustered	gi\|1890430064\|gb\|MT885329.1\|	1123966	g16199	i0	83.721	8.67080745341615	86	13	53	1	5	90	2018	2102	Nodosilinea epilithica strain Prim-5-5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	1396	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea epilithica

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