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

5 rows where analysis = "diamond", bioproject = "PRJNA1008624" 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	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
27192390	27192390	PRJNA1008624_P_NODE_26382_length_171_cov_1.090164_g26194_i0	PRJNA1008624	26382	171	1.090164	1.86418044	Cyanobacteria bacterium P01_A01_bin.80	3023253	Bacteria	Bacteria	50.4	1.77e-5	NR	MEM7578254.1	3023253	g26194	i0	77.8	0.473684210526316	27	6	47.4	85	5	140	166	MEM7578254.1 hypothetical protein [Cyanobacteria bacterium P01_A01_bin.80]	diamond	81	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.80
27255703	27255703	PRJNA1008624_P_NODE_26823_length_169_cov_1.691667_g26635_i0	PRJNA1008624	26823	169	1.691667	2.85891723	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	70.1	3.12e-12	NR	MCE2664493.1	2904984	g26635	i0	51	0.905325443786982	51	25	90.5	168	16	752	802	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	153	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
29465682	29465682	PRJNA1008624_P_NODE_31450_length_166_cov_0.888889_g31262_i0	PRJNA1008624	31450	166	0.888889	1.47555574	Microcystis sp. M	1127	Bacteria	Bacteria	53.9	1.44e-6	NR	WP_287729196.1	2771171	g31262	i0	57.4	0.849397590361446	47	20	84.9	6	146	75	121	WP_287729196.1 hypothetical protein [Microcystis sp. M061S2]	diamond	141	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M061S2
29718411	29718411	PRJNA1008624_P_NODE_31210_length_166_cov_0.888889_g31022_i0	PRJNA1008624	31210	166	0.888889	1.47555574	Sphaerospermopsis sp.	3100406	Bacteria	Bacteria	62	2.2e-10	NR	MEB3151458.1	3100406	g31022	i0	55.6	0.975903614457831	54	24	97.6	3	164	32	85	MEB3151458.1 hypothetical protein [Sphaerospermopsis sp.]	diamond	162	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis sp.
32500808	32500808	PRJNA1008624_P_NODE_33019_length_165_cov_0.896552_g32831_i0	PRJNA1008624	33019	165	0.896552	1.4793108	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	71.6	8.57e-13	NR	MEB3301968.1	2847862	g32831	i0	63.5	0.945454545454545	52	19	94.5	7	162	440	491	MEB3301968.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	156	71.6	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);;