metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJNA596867" and tax

3 rows where analysis = "diamond", bioproject = "PRJNA596867" and tax_kingdom = "Fungi"

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
20970222	20970222	PRJNA596867_P_NODE_11457_length_251_cov_0.865169_g11382_i0	PRJNA596867	11457	251	0.865169	2.17157419	Ceratobasidiaceae	5250	Fungi	Fungi	186	1.1399999999999999e-54	NR	QRW00063.1	170446	g11382	i0	97.6	4.9601593625498	83	2	99.2	0	249	1	98	180	QRW00063.1 Fatty acid desaturase [Ceratobasidium sp. AG-Ba]	diamond	1245	187	0.994652406417112	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-Ba
27900873	27900873	PRJNA596867_P_NODE_12645_length_248_cov_0.880000_g12570_i0	PRJNA596867	12645	248	0.88	2.1824	Lecanicillium fungicola	93591	Fungi	Fungi	43.1	0.0295	NR	KAJ2971225.1	93591	g12570	i0	38.9	0.653225806451613	54	31	62.9	1	29	184	815	868	KAJ2971225.1 hypothetical protein NQ176_g7800 [Lecanicillium fungicola]	diamond	162	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Zarea	Zarea fungicola
31407164	31407164	PRJNA596867_P_NODE_3836_length_388_cov_0.882540_g3761_i0	PRJNA596867	3836	388	0.88254	3.4242552	Rhizophagus clarus	94130	Fungi	Fungi	44.3	0.0138	NR	GBC08281.1	94130	g3761	i0	59.5	0.572164948453608	37	5	20.9	1	307	387	31	67	GBC08281.1 hypothetical protein RclHR1_00800008 [Rhizophagus clarus]	diamond	222	44.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus

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