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

9 rows where analysis = "blastn", bioproject = "PRJNA540466" 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
1783623	1783623	PRJNA540466_S_NODE_58622_length_248_cov_2.502857_g58073_i0	PRJNA540466	58622	248	2.502857	6.20708536	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g58073	i0	86.026	44.508064516129	229	25	91	5	24	248	2910	3135	Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	11038	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2393957	2393957	PRJNA540466_S_NODE_55762_length_253_cov_1.033333_g55213_i0	PRJNA540466	55762	253	1.033333	2.61433249	Nostocales	1161	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g55213	i0	83.133	6.68379446640316	249	36	97	6	8	253	6448728	6448973	Nostoc sp. HK-01 DNA, complete genome	blastn	1691	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
5611915	5611915	PRJNA540466_S_NODE_47525_length_270_cov_0.878173_g46976_i0	PRJNA540466	47525	270	0.878173	2.3710671	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	425	1.27e-114	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g46976	i0	95.185	129.892592592593	270	12	99	1	2	270	795110	795379	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	35071	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5612103	5612103	PRJNA540466_S_NODE_70265_length_214_cov_4.510638_g69716_i0	PRJNA540466	70265	214	4.510638	9.65276532	Aliterella chasmolithica	2739056	Bacteria	Bacteria	353	4.609999999999999e-93	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g69716	i0	100	103.976635514019	191	0	89	0	24	214	1969	2159	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	22251	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
8160709	8160709	PRJNA540466_S_NODE_22607_length_374_cov_1.617940_g22058_i0	PRJNA540466	22607	374	1.61794	6.0510956	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	488	2.29e-133	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g22058	i0	93.846	181.71122994652401	325	18	87	2	1	325	451872	451550	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	67960	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
15146487	15146487	PRJNA540466_S_NODE_16232_length_435_cov_3.651934_g15685_i0	PRJNA540466	16232	435	3.651934	15.8859129	Synechococcus	1129	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|2638507609\|emb\|OY986433.1\|	2789857	g15685	i0	100	0.128735632183908	28	0	6	0	140	167	918291	918264	Synechococcus sp. CBW1107 isolate KAC_106 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
19634410	19634410	PRJNA540466_S_NODE_7076_length_605_cov_1.447368_g6606_i0	PRJNA540466	7076	605	1.447368	8.7565764	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	935	0	NTclustered	gi\|225696247\|gb\|FJ805914.1\|	259957	g6606	i0	96.791	112.009917355372	561	16	92	2	47	605	2819	2259	Uncultured Chroococcidiopsis sp. clone AN1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67766	935	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22795641	22795641	PRJNA540466_S_NODE_34498_length_309_cov_2.203390_g33949_i0	PRJNA540466	34498	309	2.20339	6.8084751	Chroococcidiopsis	54298	Bacteria	Bacteria	279	1.22e-70	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g33949	i0	82.958	2.01294498381877	311	51	100	2	1	309	328942	329252	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	622	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
25344820	25344820	PRJNA540466_S_NODE_55220_length_254_cov_1.165746_g54671_i0	PRJNA540466	55220	254	1.165746	2.96099484	Cyanophyceae	3028117	Bacteria	Bacteria	403	5.53e-108	NTclustered	gi\|225696200\|gb\|FJ805867.1\|	259957	g54671	i0	96.341	97.9133858267717	246	8	96	1	10	254	501	256	Uncultured Chroococcidiopsis sp. clone A2_9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24870	405	0.995061728395062	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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