metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax_clade = "Cyanobacteriota/Melainabacteria group"

6 rows where analysis = "diamond", bioproject = "PRJNA986547" 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
3524801	3524801	PRJNA986547_P_NODE_7123_length_260_cov_3.491979_g7041_i0	PRJNA986547	7123	260	3.491979	9.0791454	Bacteria	2	Bacteria	Bacteria	121	6.84e-30	NR	WP_193869696.1	54306	g7041	i0	66.7	9.20769230769231	81	27	93.5	0	1	243	119	199	WP_193869696.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Planktothrix mougeotii]	diamond	2394	122	0.991803278688525	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
27089772	27089772	PRJNA986547_P_NODE_9462_length_248_cov_2.142857_g9380_i0	PRJNA986547	9462	248	2.142857	5.31428536	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	143	4.36e-39	NR	MEE3350530.1	3022870	g9380	i0	74.4	7.93548387096774	82	21	99.2	0	3	248	52	133	MEE3350530.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium]	diamond	1968	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
28005827	28005827	PRJNA986547_P_NODE_16785_length_202_cov_4.682171_g16703_i0	PRJNA986547	16785	202	4.682171	9.45798542	Aliterella atlantica	1827278	Bacteria	Bacteria	83.6	2.9e-17	NR	WP_045054240.1	1827278	g16703	i0	72.1	1.00990099009901	68	16	99.5	2	201	1	206	271	WP_045054240.1 DNA repair protein RecO [Aliterella atlantica]	diamond	204	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29836835	29836835	PRJNA986547_P_NODE_7731_length_256_cov_2.797814_g7649_i0	PRJNA986547	7731	256	2.797814	7.16240384	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	96.3	9.41e-23	NR	MBL8086383.1	2711154	g7649	i0	72.6	0.85546875	73	16	80.9	2	49	255	56	128	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	219	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32460985	32460985	PRJNA986547_P_NODE_2739_length_310_cov_4.645570_g2657_i0	PRJNA986547	2739	310	4.64557	14.401267	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	101	2.0399999999999994e-24	NR	HEY9780001.1	3088178	g2657	i0	100	0.483870967741935	50	0	48.4	0	1	150	102	151	HEY9780001.1 LptA/OstA family protein [Leptolyngbyaceae cyanobacterium]	diamond	150	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
32556089	32556089	PRJNA986547_P_NODE_13259_length_233_cov_4.425000_g13177_i0	PRJNA986547	13259	233	4.425	10.31025	Cyanobacteria bacterium UBA11367	2055774	Bacteria	Bacteria	80.5	5.07e-16	NR	HBE16399.1	2055774	g13177	i0	51.5	2.78111587982833	66	32	85	0	6	203	7	72	HBE16399.1 DNA methyltransferase [Cyanobacteria bacterium UBA11367]	diamond	648	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11367

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