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

17 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
1063635	1063635	PRJNA312107_P_NODE_10161_length_226_cov_3.175141_g9995_i0	PRJNA312107	10161	226	3.175141	7.17581866	Microcystis	1125	Bacteria	Bacteria	418	1.7199999999999998e-112	NTclustered	gi\|119352232\|gb\|EF121241.1\|	1126	g9995	i0	100	101	226	0	100	0	1	226	549	774	Microcystis aeruginosa strain SPC 777 16S ribosomal RNA gene, partial sequence	blastn	22826	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
1652344	1652344	PRJNA312107_P_NODE_15422_length_186_cov_1.518248_g15256_i0	PRJNA312107	15422	186	1.518248	2.82394128	Edaphophycus epilithus	2989703	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|2075814060\|gb\|MZ700338.1\|	2866019	g15256	i0	100	126.10752688172	186	0	100	0	1	186	2020	2205	Cyanobacteria bacterium FBCC-A205 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23456	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Edaphophycus	Edaphophycus epilithus
2928253	2928253	PRJNA312107_P_NODE_23803_length_164_cov_0.904348_g23637_i0	PRJNA312107	23803	164	0.904348	1.48313072	uncultured Nostoc sp.	340711	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|1766756934\|gb\|MK685841.1\|	340711	g23637	i0	93.293	172.073170731707	164	11	100	0	1	164	287	124	Uncultured Nostoc sp. clone pJSJ2-3 PsbA (psbA) gene, partial cds	blastn	28220	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.
6755332	6755332	PRJNA312107_P_NODE_8606_length_244_cov_1.569231_g8440_i0	PRJNA312107	8606	244	1.569231	3.82892364	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	370	5.35e-98	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g8440	i0	94.561	103.430327868852	239	13	98	0	1	239	1244100	1243862	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	25237	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
8030776	8030776	PRJNA312107_P_NODE_12547_length_206_cov_0.828025_g12381_i0	PRJNA312107	12547	206	0.828025	1.7057315	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	309	9.68e-80	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g12381	i0	93.689	214.699029126214	206	13	100	0	1	206	273	478	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	44228	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
8716223	8716223	PRJNA312107_P_NODE_11407_length_215_cov_0.927711_g11241_i0	PRJNA312107	11407	215	0.927711	1.99457865	Cyanophyceae	3028117	Bacteria	Bacteria	283	6.17e-72	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g11241	i0	90.654	128.827906976744	214	19	99	1	1	213	2726	2939	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	27698	285	0.992982456140351	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8716227	8716227	PRJNA312107_P_NODE_14267_length_193_cov_1.590278_g14101_i0	PRJNA312107	14267	193	1.590278	3.06923654	Cyanophyceae	3028117	Bacteria	Bacteria	259	9.13e-65	NTclustered	gi\|2117893480\|dbj\|AP024987.1\|	1285375	g14101	i0	100	157.181347150259	140	0	76	0	54	193	362787	362648	Cyanobacterium endosymbiont of Braarudosphaera bigelowii CPSB-1 DNA, complete genome	blastn	30336	261	0.992337164750958	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Candidatus Atelocyanobacterium	Candidatus Atelocyanobacterium thalassae
8716233	8716233	PRJNA312107_P_NODE_15827_length_184_cov_1.111111_g15661_i0	PRJNA312107	15827	184	1.111111	2.04444424	Acaryochloris	155977	Bacteria	Bacteria	193	8.86e-45	NTclustered	gi\|470482548\|ref\|NR_076538.1\|	155978	g15661	i0	95.798	104.29347826087	119	5	65	0	1	119	1301	1419	Acaryochloris marina strain MBIC11017 23S ribosomal RNA gene, complete sequence	blastn	19190	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
9991782	9991782	PRJNA312107_P_NODE_16388_length_181_cov_1.060606_g16222_i0	PRJNA312107	16388	181	1.060606	1.91969686	Cyanophyceae	3028117	Bacteria	Bacteria	255	1.09e-63	NTclustered	gi\|940620467\|gb\|KR676347.1\|	945751	g16222	i0	92.265	235.972375690608	181	13	100	1	1	181	2591	2770	Calenema singularis LEGE 06188 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	42711	257	0.992217898832685	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Calenema	Calenema singularis
11856301	11856301	PRJNA312107_P_NODE_5410_length_304_cov_2.831373_g5244_i0	PRJNA312107	5410	304	2.831373	8.60737392	Spirirestis rafaelensis	293980	Bacteria	Bacteria	492	1.41e-134	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g5244	i0	95.765	254.529605263158	307	10	100	2	1	304	329	23	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	77377	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
13131344	13131344	PRJNA312107_P_NODE_20231_length_168_cov_0.873950_g20065_i0	PRJNA312107	20231	168	0.87395	1.468236	Plectolyngbya salina	3016459	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|2106138548\|gb\|OK382088.1\|	2880696	g20065	i0	97.024	170.02380952381	168	5	100	0	1	168	2147	1980	Plectolyngbya salina FBCC-A1477 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28564	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya salina
15091341	15091341	PRJNA312107_P_NODE_15932_length_183_cov_1.552239_g15766_i0	PRJNA312107	15932	183	1.552239	2.84059737	Hassallia	482629	Bacteria	Bacteria	300	5.040000000000001e-77	NTclustered	gi\|1519336825\|gb\|MK211226.1\|	2489140	g15766	i0	96.175	250.677595628415	183	7	100	0	1	183	2200	2382	Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	45874	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia byssoidea
17641263	17641263	PRJNA312107_P_NODE_1154_length_651_cov_3.081395_g1005_i0	PRJNA312107	1154	651	3.081395	20.05988145	Nostoc	1177	Bacteria	Bacteria	929	0	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g1005	i0	94.253	315.519201228879	609	33	99	2	40	648	2143434	2144040	Nostoc piscinale CENA21 chromosome	blastn	205403	933	0.995712754555198	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
20189696	20189696	PRJNA312107_P_NODE_14416_length_192_cov_1.454545_g14250_i0	PRJNA312107	14416	192	1.454545	2.7927264	root	1	Root_unresolved	Root_unresolved	355	1.13e-93	NTclustered	gi\|1667280853\|gb\|MK968507.1\|	1211	g14250	i0	100	117.838541666667	192	0	100	0	1	192	377	186	Uncultured cyanobacterium clone illumina55 16S ribosomal RNA gene, partial sequence	blastn	22625	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21465361	21465361	PRJNA312107_P_NODE_4557_length_330_cov_1.590747_g4391_i0	PRJNA312107	4557	330	1.590747	5.2494651	Microcystis	1125	Bacteria	Bacteria	603	6.839999999999998e-168	NTclustered	gi\|1566846205\|dbj\|LC455583.1\|	1126	g4391	i0	99.696	141.672727272727	329	1	99	0	2	330	344	16	Microcystis aeruginosa NIES-3804 gene for 23S ribosomal RNA, partial sequence	blastn	46752	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
22740416	22740416	PRJNA312107_P_NODE_25378_length_162_cov_1.380531_g25212_i0	PRJNA312107	25378	162	1.380531	2.23646022	Cyanophyceae	3028117	Bacteria	Bacteria	200	4.549999999999998e-47	NTclustered	gi\|46409892\|gb\|AY584517.1\|	251221	g25212	i0	88.957	179.283950617284	163	17	100	1	1	162	1369	1207	Gloeobacter violaceus PCC 7421 23S ribosomal RNA gene, partial sequence	blastn	29044	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
23329721	23329721	PRJNA312107_P_NODE_6119_length_287_cov_1.680672_g5953_i0	PRJNA312107	6119	287	1.680672	4.82352864	Spirirestis rafaelensis	293980	Bacteria	Bacteria	436	6.2699999999999985e-118	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g5953	i0	94.097	180.428571428571	288	16	100	1	1	287	326	613	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	51783	436	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);;