metadata: contig_metadata: 10 rows where bioproject = "PRJNA615175", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA615175", 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
5698743	5698743	PRJNA615175_P_NODE_4445_length_734_cov_3.487141_g4285_i0	PRJNA615175	4445	734	3.487141	25.59561494	Furculomyces boomerangus	61424	Fungi	Fungi	190	6.85e-57	NR	PVU93144.1	61424	g4285	i0	45.5	5.73433242506812	200	106	81.3	2	3	599	14	211	PVU93144.1 hypothetical protein BB559_003414 [Furculomyces boomerangus]	diamond	4209	190	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
26668554	26668554	PRJNA615175_P_NODE_3061_length_888_cov_6.229448_g2925_i0	PRJNA615175	3061	888	6.229448	55.31749824	Entomophthora muscae	34485	Fungi	Fungi	74.7	3.18e-11	NR	KAJ9055780.1	34485	g2925	i0	59.3	0.182432432432432	54	20	18.2	1	322	483	160	211	KAJ9055780.1 hypothetical protein DSO57_1000638 [Entomophthora muscae]	diamond	162	74.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
26872156	26872156	PRJNA615175_P_NODE_35941_length_233_cov_2.881250_g35773_i0	PRJNA615175	35941	233	2.88125	6.7133125	Eukaryota	2759	Fungi	Fungi	85.1	2e-17	NR	PVU90220.1	61424	g35773	i0	53.2	11.8969957081545	77	36	99.1	0	3	233	146	222	PVU90220.1 hypothetical protein BB559_004724 [Furculomyces boomerangus]	diamond	2772	85.5	0.9953216374269	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
28406816	28406816	PRJNA615175_P_NODE_18926_length_320_cov_3.287449_g18758_i0	PRJNA615175	18926	320	3.287449	10.5198368	Martensiomyces pterosporus	61414	Fungi	Fungi	57.4	6.62e-7	NR	KAI8322302.1	61414	g18758	i0	31.6	0.740625	79	49	71.3	2	2	229	17	93	KAI8322302.1 WD40 repeat-like protein [Martensiomyces pterosporus]	diamond	237	57.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Martensiomyces	Martensiomyces pterosporus
28975185	28975185	PRJNA615175_P_NODE_9788_length_470_cov_3.415617_g9620_i0	PRJNA615175	9788	470	3.415617	16.0533999	Basidiobolus ranarum	34480	Fungi	Fungi	172	7e-49	NR	KAK9722475.1	34480	g9620	i0	54.7	1.8	139	56	88.7	2	466	50	276	407	KAK9722475.1 Coproporphyrinogen-III oxidase [Basidiobolus ranarum]	diamond	846	172	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30283292	30283292	PRJNA615175_P_NODE_12152_length_412_cov_2.899705_g11984_i0	PRJNA615175	12152	412	2.899705	11.9467846	Fungi	4751	Fungi	Fungi	160	1.93e-45	NR	ORX90512.1	1314790	g11984	i0	52.6	4.92961165048544	133	62	96.8	1	3	401	194	325	ORX90512.1 Aldo/keto reductase [Basidiobolus meristosporus CBS 931.73]	diamond	2031	160	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
30333535	30333535	PRJNA615175_P_NODE_20012_length_310_cov_3.126582_g19844_i0	PRJNA615175	20012	310	3.126582	9.6924042	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	127	2.4e-35	NR	KAI9296627.1	1314799	g19844	i0	65	1.93548387096774	100	35	96.8	0	6	305	32	131	KAI9296627.1 ribosomal protein L32e [Neoconidiobolus thromboides FSU 785]	diamond	600	127	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
30378057	30378057	PRJNA615175_P_NODE_26472_length_260_cov_1.647059_g26304_i0	PRJNA615175	26472	260	1.647059	4.2823534	Fungi	4751	Fungi	Fungi	71.6	3.27e-14	NR	OMJ11733.1	133412	g26304	i0	71.4	2.90769230769231	42	12	48.5	0	258	133	29	70	OMJ11733.1 Diphthamide biosynthesis protein 3 [Smittium culicis]	diamond	756	71.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
30820051	30820051	PRJNA615175_P_NODE_11634_length_424_cov_1.729345_g11466_i0	PRJNA615175	11634	424	1.729345	7.3324228	Eukaryota	2759	Fungi	Fungi	142	1.9699999999999993e-40	NR	KAI9469285.1	4864	g11466	i0	60.8	14.2783018867925	120	46	84.2	1	359	3	1	120	KAI9469285.1 ribosomal L27e protein family-domain-containing protein [Coemansia mojavensis]	diamond	6054	143	0.993006993006993	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia mojavensis
30933447	30933447	PRJNA615175_P_NODE_4334_length_745_cov_4.627976_g4175_i0	PRJNA615175	4334	745	4.627976	34.4784212	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	270	3.9099999999999985e-87	NR	KXN74832.1	796925	g4175	i0	54.5	3.92214765100671	244	111	98.3	0	745	14	45	288	KXN74832.1 60S ribosomal protein L5 [Conidiobolus coronatus NRRL 28638]	diamond	2922	270	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus

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