metadata: contig_metadata: 6 rows where bioproject = "PRJNA556842" and tax_clade = "Cyanobacteriota/Melainabacteria group"

6 rows where bioproject = "PRJNA556842" 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
5625687	5625687	PRJNA556842_P_NODE_7945_length_293_cov_2.945312_g7441_i0	PRJNA556842	7945	293	2.945312	8.62976416	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	427	3.86e-115	NTclustered	gi\|225696213\|gb\|FJ805880.1\|	259957	g7441	i0	93.426	146.938566552901	289	18	98	1	6	293	2243	1955	Uncultured Chroococcidiopsis sp. clone A3_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43053	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6899710	6899710	PRJNA556842_P_NODE_3806_length_488_cov_4.215078_g3319_i0	PRJNA556842	3806	488	4.215078	20.56958064	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	763	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g3319	i0	94.898	110.549180327869	490	22	100	3	1	488	2732	2244	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53948	763	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15824551	15824551	PRJNA556842_P_NODE_3773_length_491_cov_3.127753_g3287_i0	PRJNA556842	3773	491	3.127753	15.35726723	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	649	0	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g3287	i0	90.631	141.494908350306	491	42	100	4	1	491	3343	3829	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69474	649	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
18373550	18373550	PRJNA556842_P_NODE_16075_length_163_cov_2.857143_g15570_i0	PRJNA556842	16075	163	2.857143	4.65714309	Aliterella chasmolithica	2739056	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g15570	i0	98.773	107.920245398773	163	2	100	0	1	163	2142	1980	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	17591	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
18975518	18975518	PRJNA556842_P_NODE_13415_length_188_cov_3.284768_g12910_i0	PRJNA556842	13415	188	3.284768	6.17536384	Chroococcidiopsis	54298	Bacteria	Bacteria	315	1.8599999999999999e-81	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g12910	i0	96.809	222.824468085106	188	6	100	0	1	188	792937	793124	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	41891	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
22198685	22198685	PRJNA556842_P_NODE_16458_length_160_cov_2.902439_g15953_i0	PRJNA556842	16458	160	2.902439	4.6439024	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	274	2.5999999999999997e-69	NTclustered	gi\|376315525\|gb\|JQ323130.1\|	259957	g15953	i0	97.531	107.20625	162	0	100	4	1	160	160	1	Uncultured Chroococcidiopsis sp. clone C19 16S ribosomal RNA gene, partial sequence	blastn	17153	274	1	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);;