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

11 rows where analysis = "blastn", bioproject = "PRJNA520845" 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
5594838	5594838	PRJNA520845_P_NODE_243145_length_245_cov_2.238372_g241646_i0	PRJNA520845	243145	245	2.238372	5.4840114	Cyanobium gracile	59930	Bacteria	Bacteria	104	6.02e-18	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g241646	i0	84.259	12.1102040816327	108	15	44	2	21	127	2340077	2339971	Cyanobium gracile PCC 6307, complete genome	blastn	2967	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
6214858	6214858	PRJNA520845_P_NODE_168825_length_286_cov_2.516432_g167326_i0	PRJNA520845	168825	286	2.516432	7.19699552	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	62.1	4.39e-5	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g167326	i0	97.222	8.80769230769231	36	1	13	0	8	43	2846804	2846839	Nostoc sp. PCC 7524, complete genome	blastn	2519	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
11971657	11971657	PRJNA520845_P_NODE_75730_length_427_cov_0.870056_g74231_i0	PRJNA520845	75730	427	0.870056	3.71513912	Kovacikia minuta	2931930	Bacteria	Bacteria	263	1.75e-65	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g74231	i0	78.5	1.02107728337237	400	86	94	0	27	426	1184622	1185021	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	436	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
12590176	12590176	PRJNA520845_P_NODE_136190_length_320_cov_1.404858_g134691_i0	PRJNA520845	136190	320	1.404858	4.4955456	Chroococcidiopsis	54298	Bacteria	Bacteria	569	6.699999999999998e-158	NTclustered	gi\|485099067\|ref\|NR_102464.1\|	251229	g134691	i0	98.75	98.003125	320	4	100	0	1	320	324	5	Chroococcidiopsis thermalis PCC 7203 16S ribosomal RNA, partial sequence	blastn	31361	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13244244	13244244	PRJNA520845_P_NODE_217831_length_250_cov_1.683616_g216332_i0	PRJNA520845	217831	250	1.683616	4.20904	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	281	2.65e-71	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g216332	i0	87.347	26.56	245	31	99	0	3	247	1597032	1597276	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	6640	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
15791033	15791033	PRJNA520845_P_NODE_145953_length_309_cov_1.487288_g144454_i0	PRJNA520845	145953	309	1.487288	4.59571992	[Phormidium] sp. ETS-05	222819	Bacteria	Bacteria	58.4	6.2e-4	NTclustered	gi\|1951309134\|gb\|CP051168.1\|	222819	g144454	i0	100	0.100323624595469	31	0	10	0	30	60	3722644	3722614	[Phormidium] sp. ETS-05 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Koinonema	[Phormidium] sp. ETS-05
16414131	16414131	PRJNA520845_P_NODE_177693_length_279_cov_2.660194_g176194_i0	PRJNA520845	177693	279	2.660194	7.42194126	Synechococcus	1129	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|147846875\|emb\|CT971583.1\|	32051	g176194	i0	96.875	0.229390681003584	32	0	11	1	1	31	1058719	1058750	Synechococcus WH7803 complete genome sequence	blastn	64	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 7803
18342573	18342573	PRJNA520845_P_NODE_239395_length_246_cov_0.890173_g237896_i0	PRJNA520845	239395	246	0.890173	2.18982558	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	65.8	2.85e-6	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g237896	i0	97.368	1.02032520325203	38	1	15	0	1	38	1821285	1821248	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	251	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
19618947	19618947	PRJNA520845_P_NODE_78016_length_420_cov_2.527378_g76517_i0	PRJNA520845	78016	420	2.527378	10.6149876	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	704	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g76517	i0	96.905	116.204761904762	420	13	100	0	1	420	2769	2350	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48806	704	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20894314	20894314	PRJNA520845_P_NODE_50377_length_527_cov_1.616740_g48885_i0	PRJNA520845	50377	527	1.61674	8.5202198	[Phormidium] sp. ETS-05	222819	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1951309134\|gb\|CP051168.1\|	222819	g48885	i0	100	0.0588235294117647	31	0	6	0	485	515	3722614	3722644	[Phormidium] sp. ETS-05 chromosome, complete genome	blastn	31	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Koinonema	[Phormidium] sp. ETS-05
21513729	21513729	PRJNA520845_P_NODE_261017_length_242_cov_0.911243_g259518_i0	PRJNA520845	261017	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	444	3.08e-120	NTclustered	gi\|169787972\|emb\|AM501739.1\|	1211	g259518	i0	100	100.165289256198	240	0	99	0	3	242	835	596	Uncultured cyanobacterium partial 16S rRNA gene, clone 16B_215	blastn	24240	444	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);;