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

3 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
26714899	26714899	PRJNA904835_P_NODE_53961_length_247_cov_0.885057_g53705_i0	PRJNA904835	53961	247	0.885057	2.18609079	Planktothrix	54304	Bacteria	Bacteria	61.6	8.88e-9	NR	WP_079680667.1	1729650	g53705	i0	42.3	7.57894736842105	78	44	93.5	1	1	231	764	841	WP_079680667.1 Calx-beta domain-containing protein [Planktothrix sp. PCC 11201]	diamond	1872	62	0.993548387096774	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. PCC 11201
31580566	31580566	PRJNA904835_P_NODE_28956_length_366_cov_1.313993_g28700_i0	PRJNA904835	28956	366	1.313993	4.80921438	Nostocales	1161	Bacteria	Bacteria	93.2	2.33e-20	NR	WP_015199028.1	1170562	g28700	i0	49.5	3.86065573770492	93	44	76.2	2	280	2	37	126	WP_015199028.1 hypothetical protein [Calothrix sp. PCC 6303]	diamond	1413	94	0.991489361702128	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
32585382	32585382	PRJNA904835_P_NODE_54959_length_246_cov_0.890173_g54703_i0	PRJNA904835	54959	246	0.890173	2.18982558	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	96.7	1.17e-22	NR	MBX9694001.1	2847862	g54703	i0	87.5	0.585365853658537	48	6	58.5	0	145	2	1	48	MBX9694001.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	144	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium

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