metadata: contig_metadata: 6 rows where bioproject = "PRJNA534016", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA534016", 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
14536254	14536254	PRJNA534016_P_NODE_12032_length_263_cov_1.621053_g11942_i0	PRJNA534016	12032	263	1.621053	4.26336939	Smittium megazygosporum	133381	Fungi	Fungi	157	3.3e-42	NR	PVV04033.1	133381	g11942	i0	72.4	6.9467680608365	87	24	99.2	0	2	262	183	269	PVV04033.1 hypothetical protein BB560_001470 [Smittium megazygosporum]	diamond	1827	157	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
19633550	19633550	PRJNA534016_P_NODE_14356_length_250_cov_0.870056_g14266_i0	PRJNA534016	14356	250	0.870056	2.17514	Dispira parvispora	1520584	Fungi	Fungi	125	2.8199999999999996e-32	NR	KAJ1960968.1	1520584	g14266	i0	70.2	2.016	84	24	99.6	1	249	1	38	121	KAJ1960968.1 hypothetical protein IWQ62_004028 [Dispira parvispora]	diamond	504	125	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora
22184201	22184201	PRJNA534016_P_NODE_10178_length_277_cov_4.004902_g10088_i0	PRJNA534016	10178	277	4.004902	11.09357854	Opisthokonta	33154	Fungi	Fungi	97.8	1.0799999999999999e-23	NR	ORX98739.1	1314790	g10088	i0	57.4	34.6570397111913	94	36	97.5	2	270	1	1	94	ORX98739.1 ubiquitin-domain-containing protein [Basidiobolus meristosporus CBS 931.73]	diamond	9600	98.2	0.995926680244399	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
22184368	22184368	PRJNA534016_P_NODE_5758_length_347_cov_15.208029_g5668_i0	PRJNA534016	5758	347	15.208029	52.77186063	Linderina pennispora	61395	Fungi	Fungi	67.6	1.17e-6	NTclustered	gi\|2028322024\|ref\|XM_040883861.1\|	61395	g5668	i0	90.566	0.397694524495677	53	2	15	1	86	138	445	396	Linderina pennispora uncharacterized protein (DL89DRAFT_178148), mRNA	blastn	138	67.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
31563422	31563422	PRJNA534016_P_NODE_10476_length_275_cov_2.123762_g10386_i0	PRJNA534016	10476	275	2.123762	5.8403455	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	72.8	1.49e-12	NR	KAI9293949.1	1314799	g10386	i0	37.4	2.08363636363636	91	43	99.3	1	3	275	510	586	KAI9293949.1 Coatomer, beta' subunit [Neoconidiobolus thromboides FSU 785]	diamond	573	72.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
32495731	32495731	PRJNA534016_P_NODE_11939_length_264_cov_1.319372_g11849_i0	PRJNA534016	11939	264	1.319372	3.48314208	root	1	Root_unresolved	Root_unresolved	66.2	2.48e-10	NR	KAI8057826.1	1851185	g11849	i0	36.4	9.48863636363636	88	53	97.7	2	6	263	206	292	KAI8057826.1 phosphoesterase family-domain-containing protein [Syncephalis plumigaleata]	diamond	2505	66.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata

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