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

24 rows where analysis = "blastn", bioproject = "PRJNA977246" 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
3501708	3501708	PRJNA977246_S_NODE_22683_length_282_cov_7233.256917_g21691_i0	PRJNA977246	22683	282	7233.256917	20397.78450594	Aliterella chasmolithica	2739056	Bacteria	Bacteria	361	3.81e-95	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g21691	i0	94.444	99.3262411347518	234	13	83	0	1	234	2198	1965	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	28010	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6054323	6054323	PRJNA977246_S_NODE_19565_length_314_cov_33.547368_g18573_i0	PRJNA977246	19565	314	33.547368	105.33873552	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	276	1.6e-69	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g18573	i0	82.595	205.882165605096	316	51	100	4	1	314	3747	3434	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	64647	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
6054464	6054464	PRJNA977246_S_NODE_24585_length_265_cov_8082.084746_g23593_i0	PRJNA977246	24585	265	8082.084746	21417.5245769	Microcoleus vaginatus	119532	Bacteria	Bacteria	353	5.929999999999999e-93	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g23593	i0	98.039	67.2905660377358	204	3	81	1	12	215	4754153	4753951	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	17832	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
8603675	8603675	PRJNA977246_S_NODE_10207_length_478_cov_2037.527840_g9279_i0	PRJNA977246	10207	478	2037.52784	9739.3830752	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	298	5.41e-76	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g9279	i0	79.904	156.914225941423	418	74	86	8	64	476	1223467	1223055	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	75005	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
10197443	10197443	PRJNA977246_S_NODE_20008_length_309_cov_34.557143_g19016_i0	PRJNA977246	20008	309	34.557143	106.78157187	Cyanophyceae	3028117	Bacteria	Bacteria	424	5.31e-114	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g19016	i0	91.586	152.62783171521	309	23	100	2	1	309	1390	1085	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	47162	425	0.997647058823529	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
12430246	12430246	PRJNA977246_S_NODE_19030_length_320_cov_6597.890034_g18038_i0	PRJNA977246	19030	320	6597.890034	21113.2481088	Aliterella chasmolithica	2739056	Bacteria	Bacteria	335	2.659999999999999e-87	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g18038	i0	90.038	145.390625	261	22	81	4	12	270	2449	2191	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	46525	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
12431106	12431106	PRJNA977246_S_NODE_7990_length_553_cov_6.872137_g7152_i0	PRJNA977246	7990	553	6.872137	38.00291761	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	669	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g7152	i0	88.849	498.399638336347	556	47	100	11	1	553	2150913	2151456	Leptolyngbya sp. 7M chromosome	blastn	275615	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
12748048	12748048	PRJNA977246_S_NODE_27470_length_243_cov_4.088785_g26478_i0	PRJNA977246	27470	243	4.088785	9.93574755	Oculatella	1240886	Bacteria	Bacteria	316	7.03e-82	NTclustered	gi\|1300933890\|gb\|MG652620.1\|	1963209	g26478	i0	90.123	258.753086419753	243	24	100	0	1	243	2241	1999	Oculatella ucrainica KZ-5-4-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	62877	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella ucrainica
13705041	13705041	PRJNA977246_S_NODE_35571_length_199_cov_1.882353_g34579_i0	PRJNA977246	35571	199	1.882353	3.74588247	Tolypothrix sp. PCC 7910	2099387	Bacteria	Bacteria	147	7.699999999999999e-31	NTclustered	gi\|1826566097\|gb\|CP050440.1\|	2099387	g34579	i0	81.183	2.03517587939698	186	32	93	3	1	185	6077391	6077208	Tolypothrix sp. PCC 7910 chromosome, complete genome	blastn	405	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7910
13705462	13705462	PRJNA977246_S_NODE_8191_length_544_cov_3557.176699_g7341_i0	PRJNA977246	8191	544	3557.176699	19351.04124256	Aliterella chasmolithica	2739056	Bacteria	Bacteria	841	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g7341	i0	97.938	104.341911764706	485	10	89	0	49	533	1965	2449	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	56762	841	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14022833	14022833	PRJNA977246_S_NODE_34051_length_205_cov_10380.267045_g33059_i0	PRJNA977246	34051	205	10380.267045	21279.54744225	root	1	Root_unresolved	Root_unresolved	193	1.01e-44	NTclustered	gi\|470482548\|ref\|NR_076538.1\|	155978	g33059	i0	89.542	115.643902439024	153	14	74	1	49	199	3	155	Acaryochloris marina strain MBIC11017 23S ribosomal RNA gene, complete sequence	blastn	23707	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
14978663	14978663	PRJNA977246_S_NODE_11432_length_447_cov_8.806220_g10479_i0	PRJNA977246	11432	447	8.80622	39.3638034	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	787	0	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g10479	i0	98.434	116.413870246085	447	7	100	0	1	447	505	59	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52037	787	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16254157	16254157	PRJNA977246_S_NODE_29533_length_229_cov_8.775000_g28541_i0	PRJNA977246	29533	229	8.775	20.09475	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	329	8.43e-86	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g28541	i0	92.576	126.764192139738	229	17	100	0	1	229	1624	1852	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	29029	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16254297	16254297	PRJNA977246_S_NODE_34833_length_202_cov_2.976879_g33841_i0	PRJNA977246	34833	202	2.976879	6.01329558	Phormidium nigroviride	482564	Bacteria	Bacteria	300	5.69e-77	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g33841	i0	95.699	20.4455445544554	186	8	92	0	1	186	2348881	2349066	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	4130	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
16254738	16254738	PRJNA977246_S_NODE_8873_length_520_cov_18.767821_g7997_i0	PRJNA977246	8873	520	18.767821	97.5926692	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	710	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g7997	i0	93.018	124.373076923077	487	33	93	1	22	507	1619	2105	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	64674	710	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16571510	16571510	PRJNA977246_S_NODE_43373_length_170_cov_485.170213_g42381_i0	PRJNA977246	43373	170	485.170213	824.7893621	Cyanophyceae	3028117	Bacteria	Bacteria	303	3.55e-78	NTclustered	gi\|1566846274\|dbj\|LC455654.1\|	77022	g42381	i0	98.824	164.888235294118	170	2	100	0	1	170	1842	2011	Cylindrospermopsis raciborskii NIES-1260 gene for 23S ribosomal RNA, partial sequence	blastn	28031	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis raciborskii
17529098	17529098	PRJNA977246_S_NODE_22574_length_283_cov_7193.381890_g21582_i0	PRJNA977246	22574	283	7193.38189	20357.2707487	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	359	1.37e-94	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g21582	i0	94.421	162.575971731449	233	13	82	0	1	233	1468	1236	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	46009	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
18802832	18802832	PRJNA977246_S_NODE_22335_length_285_cov_7377.535156_g21343_i0	PRJNA977246	22335	285	7377.535156	21025.9751946	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	407	4.88e-109	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g21343	i0	97.872	162.382456140351	235	5	82	0	1	235	1468	1234	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	46279	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
20077441	20077441	PRJNA977246_S_NODE_14076_length_393_cov_14.082418_g13091_i0	PRJNA977246	14076	393	14.082418	55.34390274	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	497	4.02e-136	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g13091	i0	90.885	124.758269720102	373	31	94	3	22	392	1619	1990	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	49030	497	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21353111	21353111	PRJNA977246_S_NODE_20877_length_300_cov_2.464945_g19885_i0	PRJNA977246	20877	300	2.464945	7.394835	Gloeobacter violaceus	33072	Bacteria	Bacteria	239	1.9999999999999993e-58	NTclustered	gi\|46409892\|gb\|AY584517.1\|	251221	g19885	i0	82.105	573.13	285	46	95	4	15	298	133	413	Gloeobacter violaceus PCC 7421 23S ribosomal RNA gene, partial sequence	blastn	171939	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
22628353	22628353	PRJNA977246_S_NODE_28638_length_235_cov_2.432039_g27646_i0	PRJNA977246	28638	235	2.432039	5.71529165	Sphaerospermopsis torques-reginae	984207	Bacteria	Bacteria	63.9	9.73e-6	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g27646	i0	97.297	2.38723404255319	37	1	16	0	95	131	735905	735941	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	561	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
23903758	23903758	PRJNA977246_S_NODE_26859_length_247_cov_781.467890_g25867_i0	PRJNA977246	26859	247	781.46789	1930.2256883	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	322	1.54e-83	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g25867	i0	95.522	94.1740890688259	201	9	81	0	14	214	2066	1866	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23261	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24220359	24220359	PRJNA977246_S_NODE_14079_length_393_cov_12.035714_g13094_i0	PRJNA977246	14079	393	12.035714	47.30035602	Oscillatoriales	1150	Bacteria	Bacteria	606	6.399999999999998e-169	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g13094	i0	97.207	149.895674300254	358	10	91	0	1	358	2088	1731	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	58909	612	0.990196078431373	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25495456	25495456	PRJNA977246_S_NODE_38140_length_188_cov_3.490566_g37148_i0	PRJNA977246	38140	188	3.490566	6.56226408	Macrochaete	1844958	Bacteria	Bacteria	289	1.13e-73	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g37148	i0	98.182	89.186170212766	165	3	88	0	24	188	409	573	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	16767	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured 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);;