metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Zoopagomycota"

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
26596909	26596909	PRJNA1160211_S_NODE_181121_length_333_cov_1.996154_g179888_i0	PRJNA1160211	181121	333	1.996154	6.64719282	Coemansia sp. RSA 455	2663915	Fungi	Fungi	80.5	4.09e-15	NR	KAJ2236155.1	2663915	g179888	i0	40.7	7.64864864864865	108	33	97.3	1	325	2	86	162	KAJ2236155.1 hypothetical protein GGI13_008530, partial [Coemansia sp. RSA 455]	diamond	2547	80.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 455
26787344	26787344	PRJNA1160211_S_NODE_35621_length_627_cov_3.805054_g34498_i0	PRJNA1160211	35621	627	3.805054	23.85768858	Syncephalis fuscata	1851187	Fungi	Fungi	49.3	0.00421	NR	KAI9595585.1	1851187	g34498	i0	50	0.416267942583732	48	18	23	2	483	626	267	308	KAI9595585.1 hypothetical protein BDF19DRAFT_440943 [Syncephalis fuscata]	diamond	261	49.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis fuscata
27545956	27545956	PRJNA1160211_S_NODE_164444_length_355_cov_1.407801_g163211_i0	PRJNA1160211	164444	355	1.407801	4.99769355	Piptocephalis tieghemiana	1286916	Fungi	Fungi	70.5	1.08e-12	NR	KAI9227560.1	1286916	g163211	i0	58.7	1.06478873239437	63	26	53.2	0	348	160	51	113	KAI9227560.1 MAG: Prefoldin [Piptocephalis tieghemiana]	diamond	378	70.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis tieghemiana
30261822	30261822	PRJNA1160211_S_NODE_149132_length_376_cov_2.518152_g147899_i0	PRJNA1160211	149132	376	2.518152	9.46825152	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	111	4.0700000000000005e-27	NR	KAI9295824.1	1314799	g147899	i0	54.2	1.30851063829787	83	35	66.2	1	354	106	203	282	KAI9295824.1 putative aspartic endopeptidase, partial [Neoconidiobolus thromboides FSU 785]	diamond	492	111	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
32316971	32316971	PRJNA1160211_S_NODE_221799_length_287_cov_13.752336_g220566_i0	PRJNA1160211	221799	287	13.752336	39.46920432	Ramicandelaber brevisporus	304332	Fungi	Fungi	68.6	4.98e-13	NR	KAI8872367.1	304332	g220566	i0	71.7	0.480836236933798	46	13	48.1	0	282	145	9	54	KAI8872367.1 40S ribosomal protein S28, partial [Ramicandelaber brevisporus]	diamond	138	68.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus

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