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

4 rows where analysis = "diamond", bioproject = "PRJNA898105" 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
27403516	27403516	PRJNA898105_P_NODE_7283_length_246_cov_0.890173_g7083_i0	PRJNA898105	7283	246	0.890173	2.18982558	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	152	2.6799999999999993e-42	NR	RTL39754.1	2052166	g7083	i0	96.3	1.97560975609756	81	3	98.8	0	244	2	59	139	RTL39754.1 MAG: aspartate kinase [Candidatus Melainabacteria bacterium]	diamond	486	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30814001	30814001	PRJNA898105_P_NODE_8334_length_241_cov_0.916667_g8134_i0	PRJNA898105	8334	241	0.916667	2.20916747	Cyanobacteria bacterium SZAS LIN-3	2807732	Bacteria	Bacteria	89.7	1.17e-19	NR	MBS1993300.1	2807732	g8134	i0	61.4	0.871369294605809	70	27	87.1	0	212	3	38	107	MBS1993300.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-3]	diamond	210	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-3
31604422	31604422	PRJNA898105_P_NODE_7676_length_244_cov_0.900585_g7476_i0	PRJNA898105	7676	244	0.900585	2.1974274	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	117	4.33e-32	NR	MBW4636756.1	2839657	g7476	i0	95.2	2.28688524590164	62	3	76.2	0	58	243	1	62	MBW4636756.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	558	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32616533	32616533	PRJNA898105_P_NODE_5900_length_254_cov_1.701657_g5700_i0	PRJNA898105	5900	254	1.701657	4.32220878	Nostoc cycadae	246795	Bacteria	Bacteria	79.3	5.1e-15	NR	WP_103125825.1	246795	g5700	i0	47.6	2.00787401574803	84	41	96.9	2	247	2	162	244	WP_103125825.1 TniQ family protein [Nostoc cycadae]	diamond	510	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc cycadae

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