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

8 rows where analysis = "blastn", bioproject = "PRJEB80557" 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
996535	996535	PRJEB80557_S_NODE_28721_length_180_cov_2.320611_g28325_i0	PRJEB80557	28721	180	2.320611	4.1770998	Planktothrix	54304	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g28325	i0	100	13.0111111111111	180	0	100	0	1	180	1339606	1339427	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	2342	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
3965196	3965196	PRJEB80557_S_NODE_17944_length_223_cov_1.494253_g17548_i0	PRJEB80557	17944	223	1.494253	3.33218419	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	359	1.04e-94	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g17548	i0	95.928	197.632286995516	221	9	99	0	1	221	1777	1557	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44072	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5241803	5241803	PRJEB80557_S_NODE_37985_length_158_cov_2.146789_g37589_i0	PRJEB80557	37985	158	2.146789	3.39192662	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g37589	i0	95.57	370.5	158	7	100	0	1	158	4626771	4626928	Leptolyngbya sp. 7M chromosome	blastn	58539	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6099742	6099742	PRJEB80557_S_NODE_5045_length_383_cov_2.859281_g4649_i0	PRJEB80557	5045	383	2.859281	10.95104623	Cyanophyceae	3028117	Bacteria	Bacteria	643	4.739999999999999e-180	NTclustered	gi\|341941936\|gb\|JN225554.1\|	1211	g4649	i0	99.16	93.2297650130548	357	3	93	0	4	360	625	269	Uncultured cyanobacterium clone GSY-XJ20 16S ribosomal RNA gene, partial sequence	blastn	35707	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20122979	20122979	PRJEB80557_S_NODE_12276_length_264_cov_1.627907_g11880_i0	PRJEB80557	12276	264	1.627907	4.29767448	Cyanophyceae	3028117	Bacteria	Bacteria	346	9.880000000000002e-91	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g11880	i0	90.262	189.234848484848	267	22	100	4	1	264	1852300	1852565	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	49958	348	0.994252873563218	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
20123113	20123113	PRJEB80557_S_NODE_5436_length_372_cov_1.702786_g5040_i0	PRJEB80557	5436	372	1.702786	6.33436392	Planktothrix	54304	Bacteria	Bacteria	645	1.2799999999999994e-180	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g5040	i0	99.437	11.6612903225806	355	2	95	0	18	372	879285	878931	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	4338	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
20539979	20539979	PRJEB80557_S_NODE_18457_length_220_cov_2.257310_g18061_i0	PRJEB80557	18457	220	2.25731	4.966082	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	348	2.2200000000000005e-91	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18061	i0	98.969	94.15	194	2	88	0	23	216	1861157	1860964	Calothrix sp. PCC 7716 DNA, complete genome	blastn	20713	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
24364910	24364910	PRJEB80557_S_NODE_2440_length_506_cov_3.479212_g2048_i0	PRJEB80557	2440	506	3.479212	17.60481272	Aliterella chasmolithica	2739056	Bacteria	Bacteria	702	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2048	i0	92.813	127.571146245059	487	31	96	4	22	506	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	64551	702	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica

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