metadata: contig_metadata: 4 rows where bioproject = "PRJNA596870" and tax_clade = "Cyanobacteriota/Melainabacteria group"

4 rows where bioproject = "PRJNA596870" 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
28640812	28640812	PRJNA596870_P_NODE_23247_length_280_cov_1.690821_g23114_i0	PRJNA596870	23247	280	1.690821	4.7342988	Cyanophyceae	3028117	Bacteria	Bacteria	167	4.13e-49	NR	WP_250123871.1	155894	g23114	i0	79.6	1.98214285714286	93	19	99.6	0	1	279	3	95	WP_250123871.1 alpha/beta fold hydrolase [Chroococcidiopsis sp. CCMEE 29]	diamond	555	168	0.994047619047619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
30693465	30693465	PRJNA596870_P_NODE_38093_length_243_cov_0.905882_g37960_i0	PRJNA596870	38093	243	0.905882	2.20129326	Cyanophyceae	3028117	Bacteria	Bacteria	152	1.2299999999999999e-40	NR	WP_414585984.1	1680591	g37960	i0	91.3	14.8148148148148	80	7	98.8	0	242	3	298	377	WP_414585984.1 acyl-CoA dehydrogenase [Scytonema sp. PCC 10023]	diamond	3600	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023
31248844	31248844	PRJNA596870_P_NODE_30535_length_250_cov_0.870056_g30402_i0	PRJNA596870	30535	250	0.870056	2.17514	Okeania sp. SIO3I5	2607805	Bacteria	Bacteria	82	2.65e-16	NR	WP_293142780.1	2607805	g30402	i0	53	1.992	83	36	97.2	2	3	245	18	99	WP_293142780.1 zinc-binding dehydrogenase [Okeania sp. SIO3I5]	diamond	498	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO3I5
32116485	32116485	PRJNA596870_P_NODE_23398_length_280_cov_1.024155_g23265_i0	PRJNA596870	23398	280	1.024155	2.867634	Bacillati	1783272	Bacteria	Bacteria	85.1	7.42e-17	NR	OGI00057.1	1801606	g23265	i0	52.2	2.79642857142857	92	44	98.6	0	2	277	57	148	OGI00057.1 MAG: sodium-translocating pyrophosphatase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	783	85.9	0.990686845168801	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium GWF2_37_15

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