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

21 rows where analysis = "blastn", bioproject = "PRJNA624323" 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
596358	596358	PRJNA624323_P_NODE_4881_length_329_cov_1.781250_g4719_i0	PRJNA624323	4881	329	1.78125	5.8603125	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	333	9.869999999999998e-87	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g4719	i0	85.152	96.2401215805471	330	44	100	5	1	329	6760727	6760402	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	31663	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
1150180	1150180	PRJNA624323_P_NODE_6141_length_290_cov_1.760369_g5979_i0	PRJNA624323	6141	290	1.760369	5.1050701	Chroococcidiopsis	54298	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g5979	i0	100	107.824137931034	290	0	100	0	1	290	1242	1531	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	31269	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
1872372	1872372	PRJNA624323_P_NODE_162_length_1423_cov_72.499259_g19_i5	PRJNA624323	162	1423	72.499259	1031.66445557	Nostoc sp. C117	3349875	Bacteria	Bacteria	2058	0	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g19	i5	92.982	299.121574139143	1425	79	99	16	1	1415	148375	146962	Nostoc sp. C117 chromosome, complete genome	blastn	425650	2058	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
2425374	2425374	PRJNA624323_P_NODE_1482_length_598_cov_33.590476_g522_i3	PRJNA624323	1482	598	33.590476	200.87104648	Gloeocapsopsis	693222	Bacteria	Bacteria	1037	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g522	i3	97.997	102.750836120401	599	9	100	3	1	598	2711	3307	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	61445	1037	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
4423953	4423953	PRJNA624323_P_NODE_4204_length_356_cov_1.282686_g4042_i0	PRJNA624323	4204	356	1.282686	4.56636216	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	315	3.89e-81	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g4042	i0	83.728	151.269662921348	338	49	94	5	2	337	4829045	4828712	Leptolyngbya sp. 7M chromosome	blastn	53852	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4423969	4423969	PRJNA624323_P_NODE_8084_length_250_cov_0.870056_g7922_i0	PRJNA624323	8084	250	0.870056	2.17514	Nodularia sphaerocarpa	137816	Bacteria	Bacteria	145	3.63e-30	NTclustered	gi\|2198613447\|gb\|CP060140.1\|	2761619	g7922	i0	79.524	1.504	210	38	82	3	43	248	712905	713113	Nodularia sphaerocarpa UHCC 0038 chromosome, complete genome	blastn	376	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sphaerocarpa
5699899	5699899	PRJNA624323_P_NODE_1045_length_700_cov_32.149920_g522_i2	PRJNA624323	1045	700	32.14992	225.04944	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	1225	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g522	i2	98.288	108.311428571429	701	9	100	3	1	700	2924	3622	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	75818	1225	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
6253882	6253882	PRJNA624323_P_NODE_845_length_763_cov_28.639130_g522_i1	PRJNA624323	845	763	28.63913	218.5165619	Chroococcaceae	1890464	Bacteria	Bacteria	1090	0	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g522	i1	92.651	125.407601572739	762	49	99	6	1	760	960	1716	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	95686	1090	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
6974809	6974809	PRJNA624323_P_NODE_2006_length_518_cov_4.988764_g1847_i0	PRJNA624323	2006	518	4.988764	25.84179752	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	857	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g1847	i0	96.525	166.005791505792	518	18	100	0	1	518	1991	1474	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	85991	857	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7527973	7527973	PRJNA624323_P_NODE_5926_length_296_cov_1.443946_g5764_i0	PRJNA624323	5926	296	1.443946	4.27408016	Cyanophyceae	3028117	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|1053098980\|gb\|KT715348.1\|	1211	g5764	i0	100	99.8885135135135	296	0	100	0	1	296	305	600	Uncultured cyanobacterium clone G79 16S ribosomal RNA gene, partial sequence	blastn	29567	547	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8249576	8249576	PRJNA624323_P_NODE_9527_length_241_cov_0.916667_g9365_i0	PRJNA624323	9527	241	0.916667	2.20916747	Tolypothrix sp. PCC 7910	2099387	Bacteria	Bacteria	241	4.310000000000001e-59	NTclustered	gi\|1826566097\|gb\|CP050440.1\|	2099387	g9365	i0	85.294	26.7676348547718	238	30	98	4	1	236	6215316	6215082	Tolypothrix sp. PCC 7910 chromosome, complete genome	blastn	6451	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7910
8803064	8803064	PRJNA624323_P_NODE_147_length_1441_cov_67.994883_g19_i4	PRJNA624323	147	1441	67.994883	979.80626403	Nostoc	1177	Bacteria	Bacteria	2030	0	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g19	i4	92.431	290.378903539209	1440	82	99	21	1	1426	1738851	1737425	Nostoc cf. commune SO-36 DNA, complete genome	blastn	418436	2030	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
10078681	10078681	PRJNA624323_P_NODE_8268_length_249_cov_0.875000_g8106_i0	PRJNA624323	8268	249	0.875	2.17875	Chlorogloeopsis	1123	Bacteria	Bacteria	187	5.919999999999998e-43	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g8106	i0	82.791	4.13253012048193	215	31	86	3	1	215	2476643	2476851	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	1029	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
12075715	12075715	PRJNA624323_P_NODE_2650_length_453_cov_5.850000_g2489_i0	PRJNA624323	2650	453	5.85	26.5005	Aliterella chasmolithica	2739056	Bacteria	Bacteria	616	1.2399999999999999e-171	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2489	i0	91.209	116.348785871965	455	36	100	4	1	453	2428	1976	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52706	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12629207	12629207	PRJNA624323_P_NODE_9950_length_226_cov_3.019608_g9788_i0	PRJNA624323	9950	226	3.019608	6.82431408	root	1	Root_unresolved	Root_unresolved	418	1.7199999999999998e-112	NTclustered	gi\|1214568504\|dbj\|LC176673.1\|	1211	g9788	i0	100	99.8407079646018	226	0	100	0	1	226	188	413	Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: MIU_SFDB_3_20	blastn	22564	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13350549	13350549	PRJNA624323_P_NODE_651_length_855_cov_32.739130_g522_i0	PRJNA624323	651	855	32.73913	279.9195615	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1325	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g522	i0	94.645	105.445614035088	859	39	100	5	1	855	2968	2113	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	90156	1325	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16452967	16452967	PRJNA624323_P_NODE_9433_length_241_cov_2.226190_g9271_i0	PRJNA624323	9433	241	2.22619	5.3651179	Gloeocapsopsis	693222	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g9271	i0	98.755	282.510373443983	241	3	100	0	1	241	5037	4797	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	68085	429	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
17728035	17728035	PRJNA624323_P_NODE_6134_length_290_cov_2.336406_g5972_i0	PRJNA624323	6134	290	2.336406	6.7755774	root	1	Root_unresolved	Root_unresolved	534	2.19e-147	NTclustered	gi\|379334531\|gb\|JQ579927.1\|	1211	g5972	i0	100	99.6551724137931	289	0	99	0	2	290	608	320	Uncultured cyanobacterium clone FII-TR132 16S ribosomal RNA gene, partial sequence	blastn	28900	534	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22273509	22273509	PRJNA624323_P_NODE_9118_length_243_cov_4.670588_g8956_i0	PRJNA624323	9118	243	4.670588	11.34952884	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	448	2.39e-121	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g8956	i0	100	155.205761316872	242	0	99	0	2	243	5575194	5575435	Anabaena sp. YBS01 chromosome, complete genome	blastn	37715	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
23548852	23548852	PRJNA624323_P_NODE_1739_length_558_cov_7.008247_g1580_i0	PRJNA624323	1739	558	7.008247	39.10601826	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	959	0	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g1580	i0	97.67	208.693548387097	558	13	100	0	1	558	1897	2454	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	116451	959	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
23548856	23548856	PRJNA624323_P_NODE_2659_length_453_cov_1.886842_g2498_i0	PRJNA624323	2659	453	1.886842	8.54739426	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	793	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2498	i0	98.234	57.364238410596	453	8	100	0	1	453	3680972	3681424	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25986	793	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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