metadata: contig_metadata: 4 rows where bioproject = "PRJNA1199330", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA1199330", tax_kingdom = "Fungi" 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
20726271	20726271	PRJNA1199330_P_NODE_105757_length_249_cov_1.789773_g105058_i0	PRJNA1199330	105757	249	1.789773	4.45653477	Zoopagomycota	1913638	Fungi	Fungi	155	2.97e-42	NR	KAJ1675994.1	68401	g105058	i0	85.5	36	83	12	100	0	249	1	278	360	KAJ1675994.1 lysyl-tRNA synthetase [Spiromyces aspiralis]	diamond	8964	155	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
27736254	27736254	PRJNA1199330_P_NODE_102884_length_251_cov_1.752809_g102185_i0	PRJNA1199330	102884	251	1.752809	4.39955059	Smittium mucronatum	133383	Fungi	Fungi	53.5	5.94e-7	NR	OLY84590.1	133383	g102185	i0	37.8	0.884462151394422	74	44	86.1	1	223	8	1	74	OLY84590.1 hypothetical protein AYI68_g1238 [Smittium mucronatum]	diamond	222	53.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
28323054	28323054	PRJNA1199330_P_NODE_122826_length_227_cov_2.025974_g122127_i0	PRJNA1199330	122826	227	2.025974	4.59896098	Coemansia	4863	Fungi	Fungi	58.9	2.79e-8	NR	KAJ2840190.1	327750	g122127	i0	56.9	4.74449339207048	58	23	74	1	180	13	1	58	KAJ2840190.1 hypothetical protein FBU31_000561 [Coemansia sp. 'formosensis']	diamond	1077	58.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. 'formosensis'
31323699	31323699	PRJNA1199330_P_NODE_60675_length_290_cov_1.437788_g59976_i0	PRJNA1199330	60675	290	1.437788	4.1695852	Coemansia	4863	Fungi	Fungi	47	5.79e-4	NR	KAJ2631256.1	2663881	g59976	i0	38.8	1.92413793103448	67	38	66.2	2	237	46	11	77	KAJ2631256.1 hypothetical protein GGF44_003971, partial [Coemansia sp. RSA 1694]	diamond	558	47	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1694

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