metadata: contig_metadata: 22 rows where bioproject = "PRJNA896973", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

22 rows where bioproject = "PRJNA896973", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_superkingdom = "Bacteria"

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
2148424	2148424	PRJNA896973_P_NODE_17822_length_272_cov_2.452261_g17728_i0	PRJNA896973	17822	272	2.452261	6.67014992	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	492	1.24e-134	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g17728	i0	99.265	37.8713235294118	272	2	100	0	1	272	2914263	2914534	Allocoleopsis franciscana PCC 7113, complete genome	blastn	10301	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
2148657	2148657	PRJNA896973_P_NODE_29042_length_224_cov_5.079470_g28948_i0	PRJNA896973	29042	224	5.07947	11.3780128	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	409	1.03e-109	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g28948	i0	99.554	169.044642857143	224	1	100	0	1	224	2624246	2624023	Allocoleopsis franciscana PCC 7113, complete genome	blastn	37866	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
3795956	3795956	PRJNA896973_P_NODE_28063_length_241_cov_0.916667_g27969_i0	PRJNA896973	28063	241	0.916667	2.20916747	Nostocales	1161	Bacteria	Bacteria	366	6.82e-97	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g27969	i0	94.191	90.7136929460581	241	13	100	1	1	241	3601435	3601196	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	21862	368	0.994565217391304	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
4701687	4701687	PRJNA896973_P_NODE_18544_length_268_cov_1.425641_g18450_i0	PRJNA896973	18544	268	1.425641	3.82071788	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	331	2.8100000000000006e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g18450	i0	89.695	94.9328358208955	262	23	97	4	1	260	3680258	3680517	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	25442	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4701710	4701710	PRJNA896973_P_NODE_19484_length_262_cov_9.455026_g19390_i0	PRJNA896973	19484	262	9.455026	24.77216812	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	451	2.02e-122	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g19390	i0	97.719	142.450381679389	263	5	100	1	1	262	464	202	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	37322	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
5976277	5976277	PRJNA896973_P_NODE_11685_length_323_cov_1.332000_g11591_i0	PRJNA896973	11685	323	1.332	4.30236	Nostoc sp. C117	3349875	Bacteria	Bacteria	586	6.72e-163	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g11591	i0	99.381	294.839009287926	323	2	100	0	1	323	148082	147760	Nostoc sp. C117 chromosome, complete genome	blastn	95233	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
7251471	7251471	PRJNA896973_P_NODE_29046_length_224_cov_4.225166_g28952_i0	PRJNA896973	29046	224	4.225166	9.46437184	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	289	1.39e-73	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28952	i0	90.135	67.53125	223	21	99	1	2	224	3679805	3680026	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15127	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
7251615	7251615	PRJNA896973_S_NODE_3046_length_222_cov_5.865772_g3032_i0	PRJNA896973	3046	222	5.865772	13.02201384	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	254	5.03e-63	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g3032	i0	89.604	142.711711711712	202	18	91	3	9	209	480	281	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	31682	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
8525869	8525869	PRJNA896973_P_NODE_16787_length_279_cov_1.495146_g16693_i0	PRJNA896973	16787	279	1.495146	4.17145734	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	265	3.03e-66	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g16693	i0	84.502	12.4336917562724	271	38	96	4	11	278	4917951	4917682	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	3469	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
8526124	8526124	PRJNA896973_P_NODE_28747_length_231_cov_2.632911_g28653_i0	PRJNA896973	28747	231	2.632911	6.08202441	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	377	3e-100	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g28653	i0	97.309	123.545454545455	223	4	96	2	10	231	2481	2702	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28539	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8896967	8896967	PRJNA896973_S_NODE_2667_length_248_cov_0.942857_g2653_i0	PRJNA896973	2667	248	0.942857	2.33828536	Limnospira	2596745	Bacteria	Bacteria	425	1.15e-114	NTclustered	gi\|2301599811\|gb\|CP019998.1\|	459495	g2653	i0	99.571	7.32661290322581	233	1	94	0	16	248	4954160	4953928	Arthrospira platensis C1 chromosome, complete genome	blastn	1817	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
16546552	16546552	PRJNA896973_P_NODE_3233_length_561_cov_6.659836_g3141_i0	PRJNA896973	3233	561	6.659836	37.36167996	root	1	Root_unresolved	Root_unresolved	1027	0	NTclustered	gi\|327533403\|gb\|HQ821782.1\|	1211	g3141	i0	99.643	114.003565062389	561	2	100	0	1	561	838	278	Uncultured cyanobacterium clone OO.P4.IT.8.ab1 16S ribosomal RNA gene, partial sequence	blastn	63956	1031	0.996120271580989	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18724816	18724816	PRJNA896973_P_NODE_415_length_1257_cov_10.396115_g377_i0	PRJNA896973	415	1257	10.396115	130.67916555	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	2226	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g377	i0	98.648	121.696101829753	1257	15	100	1	1	1257	1756	502	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	152972	2226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
20370322	20370322	PRJNA896973_P_NODE_13516_length_304_cov_2.961039_g13422_i0	PRJNA896973	13516	304	2.961039	9.00155856	Cyanophyceae	3028117	Bacteria	Bacteria	320	7.03e-83	NTclustered	gi\|2531337825\|gb\|CP116619.1\|	3023083	g13422	i0	85.948	142.513157894737	306	36	100	6	1	304	1998759	1999059	Trichocoleus desertorum NBK24 chromosome	blastn	43324	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
22921662	22921662	PRJNA896973_P_NODE_5198_length_458_cov_1.467532_g5104_i0	PRJNA896973	5198	458	1.467532	6.72129656	Sphaerospermopsis	752201	Bacteria	Bacteria	734	0	NTclustered	gi\|1566846007\|dbj\|LC455644.1\|	531300	g5104	i0	95.815	259.24672489083	454	19	99	0	5	458	1665	1212	Sphaerospermopsis reniformis NIES-1692 gene for 23S ribosomal RNA, partial sequence	blastn	118735	739	0.993234100135318	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis reniformis
25099020	25099020	PRJNA896973_P_NODE_13000_length_309_cov_7.961864_g12906_i0	PRJNA896973	13000	309	7.961864	24.60215976	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	571	1.7899999999999995e-158	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g12906	i0	100	140.52427184466	309	0	100	0	1	309	2323	2015	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	43422	571	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
25470710	25470710	PRJNA896973_P_NODE_15120_length_290_cov_2.981567_g15026_i0	PRJNA896973	15120	290	2.981567	8.6465443	Nostocales	1161	Bacteria	Bacteria	531	2.83e-146	NTclustered	gi\|1438457454\|gb\|MH702210.1\|	2291554	g15026	i0	99.655	108.48275862069	290	1	100	0	1	290	455	744	Anabaena sp. MACC-187 16S ribosomal RNA gene, partial sequence	blastn	31460	531	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. MACC-187
26707222	26707222	PRJNA896973_P_NODE_26581_length_243_cov_0.905882_g26487_i0	PRJNA896973	26581	243	0.905882	2.20129326	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	161	5.52e-46	NR	HEY9757324.1	3088181	g26487	i0	98.8	0.987654320987654	80	1	98.8	0	3	242	206	285	HEY9757324.1 acyltransferase [Oculatellaceae cyanobacterium]	diamond	240	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27181950	27181950	PRJNA896973_P_NODE_10042_length_344_cov_1.302583_g9948_i0	PRJNA896973	10042	344	1.302583	4.48088552	Prochlorococcus marinus	1219	Bacteria	Bacteria	42.4	0.0118	NR	WP_269611066.1	1219	g9948	i0	41	0.340116279069767	39	23	34	0	119	3	10	48	WP_269611066.1 hypothetical protein [Prochlorococcus marinus]	diamond	117	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
27814080	27814080	PRJNA896973_S_NODE_2544_length_251_cov_5.865169_g2530_i0	PRJNA896973	2544	251	5.865169	14.72157419	Leptolyngbya sp. BC13	47254	Bacteria	Bacteria	51.6	3.02e-5	NR	WP_121970628.1	2029589	g2530	i0	74.3	0.418326693227092	35	9	41.8	0	24	128	459	493	WP_121970628.1 efflux RND transporter periplasmic adaptor subunit [Leptolyngbya sp. BC1307]	diamond	105	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BC1307
29361013	29361013	PRJNA896973_S_NODE_2149_length_270_cov_1.954315_g2135_i0	PRJNA896973	2149	270	1.954315	5.2766505	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	53.9	9.49e-7	NR	MBC7998577.1	2052166	g2135	i0	42.6	0.677777777777778	61	34	66.7	1	228	49	65	125	MBC7998577.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	183	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31572882	31572882	PRJNA896973_P_NODE_17776_length_273_cov_1.180000_g17682_i0	PRJNA896973	17776	273	1.18	3.2214	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	184	2.0999999999999998e-55	NR	HEY9756780.1	3088181	g17682	i0	96.7	1	91	3	100	0	273	1	22	112	HEY9756780.1 DUF4384 domain-containing protein [Oculatellaceae cyanobacterium]	diamond	273	184	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium

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