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

6 rows where analysis = "diamond", bioproject = "PRJNA909412" 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
27624865	27624865	PRJNA909412_P_NODE_1404_length_465_cov_3.636150_g1265_i0	PRJNA909412	1404	465	3.63615	16.9080975	Leptolyngbya sp. FACHB-261	2692806	Bacteria	Bacteria	69.3	1.94e-10	NR	WP_190800488.1	2692806	g1265	i0	43.8	1.24516129032258	89	50	57.4	0	310	44	304	392	WP_190800488.1 N-acetylmuramoyl-L-alanine amidase [Leptolyngbya sp. FACHB-261]	diamond	579	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-261
27727292	27727292	PRJNA909412_P_NODE_6484_length_206_cov_1.958084_g6343_i0	PRJNA909412	6484	206	1.958084	4.03365304	root	1	Root_unresolved	Root_unresolved	60.1	1.18e-8	NR	WP_225895220.1	1552121	g6343	i0	64.4	1.38349514563107	45	16	65.5	0	140	6	128	172	WP_225895220.1 CAP domain-containing protein [Leptolyngbya sp. NIES-2104]	diamond	285	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
28382486	28382486	PRJNA909412_P_NODE_13546_length_160_cov_2.066116_g13405_i0	PRJNA909412	13546	160	2.066116	3.3057856	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	57	1.12e-7	NR	MBC7542495.1	2762020	g13405	i0	65.1	0.80625	43	15	80.6	0	132	4	247	289	MBC7542495.1 DUF2252 family protein [Candidatus Sericytochromatia bacterium]	diamond	129	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28389881	28389881	PRJNA909412_P_NODE_12066_length_164_cov_1.664000_g11925_i0	PRJNA909412	12066	164	1.664	2.72896	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	70.1	1.6e-13	NR	WP_226578900.1	467598	g11925	i0	66.7	6.01829268292683	48	12	80.5	2	163	32	92	139	WP_226578900.1 CAP family protein [Microseira wollei]	diamond	987	70.5	0.994326241134752	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
30182378	30182378	PRJNA909412_P_NODE_14912_length_155_cov_3.405172_g14771_i0	PRJNA909412	14912	155	3.405172	5.2780166	Cyanobacteria bacterium TGS_CYA1	2835643	Bacteria	Bacteria	41.2	0.0396	NR	MCW5824826.1	2835643	g14771	i0	70.4	0.52258064516129	27	8	52.3	0	2	82	409	435	MCW5824826.1 L-serine ammonia-lyase [Cyanobacteria bacterium TGS_CYA1]	diamond	81	41.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium TGS_CYA1
31762745	31762745	PRJNA909412_P_NODE_14957_length_155_cov_2.922414_g14816_i0	PRJNA909412	14957	155	2.922414	4.5297417	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	41.6	0.0288	NR	HEY9878470.1	3088178	g14816	i0	83.3	0.464516129032258	24	4	46.5	0	80	9	55	78	HEY9878470.1 aldo/keto reductase [Leptolyngbyaceae cyanobacterium]	diamond	72	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium

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