metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
27983454	27983454	PRJNA1086823_P_NODE_10105_length_271_cov_2.757576_g9988_i0	PRJNA1086823	10105	271	2.757576	7.47303096	Coemansia sp. RSA 552	2663883	Fungi	Fungi	184	2.0399999999999997e-57	NR	KAJ2160949.1	2663883	g9988	i0	93.3	6.97416974169742	90	6	99.6	0	2	271	28	117	KAJ2160949.1 cytochrome P450 cyp2 [Coemansia sp. RSA 552]	diamond	1890	184	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 552
28574789	28574789	PRJNA1086823_P_NODE_3407_length_418_cov_4.866667_g3290_i0	PRJNA1086823	3407	418	4.866667	20.34266806	Harpellales	61421	Fungi	Fungi	109	2.36e-27	NR	PVU86898.1	61424	g3290	i0	40.1	2.93540669856459	137	81	97.6	1	410	3	4	140	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	1227	109	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
28764172	28764172	PRJNA1086823_P_NODE_17207_length_245_cov_0.906977_g17090_i0	PRJNA1086823	17207	245	0.906977	2.22209365	Eukaryota	2759	Fungi	Fungi	65.5	3.84e-10	NR	OLY85799.1	133383	g17090	i0	42.7	10.0530612244898	82	39	90.6	2	231	10	379	460	OLY85799.1 Vacuolar protein sorting/targeting protein 10 [Smittium mucronatum]	diamond	2463	65.9	0.993930197268589	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
29932761	29932761	PRJNA1086823_P_NODE_411_length_1133_cov_3.005660_g337_i0	PRJNA1086823	411	1133	3.00566	34.0541278	Fungi	4751	Fungi	Fungi	345	2.44e-113	NR	KAJ1917657.1	78921	g337	i0	53.1	25.7555163283319	335	154	88.4	3	1131	130	19	351	KAJ1917657.1 60S ribosomal protein L4B [Tieghemiomyces parasiticus]	diamond	29181	347	0.994236311239193	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
30162049	30162049	PRJNA1086823_P_NODE_3612_length_408_cov_11.340299_g3495_i0	PRJNA1086823	3612	408	11.340299	46.26841992	Ramicandelaber brevisporus	304332	Fungi	Fungi	99	1.0799999999999999e-23	NR	KAI8872700.1	304332	g3495	i0	41	0.860294117647059	117	61	86	1	31	381	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	351	99	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
31141371	31141371	PRJNA1086823_P_NODE_17195_length_245_cov_0.906977_g17078_i0	PRJNA1086823	17195	245	0.906977	2.22209365	Entomophthora muscae	34485	Fungi	Fungi	112	1.62e-26	NR	KAJ9050048.1	34485	g17078	i0	85.7	0.857142857142857	70	7	82	1	44	244	737	806	KAJ9050048.1 hypothetical protein DSO57_1018193 [Entomophthora muscae]	diamond	210	112	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
32090684	32090684	PRJNA1086823_P_NODE_3138_length_432_cov_2.052925_g3021_i0	PRJNA1086823	3138	432	2.052925	8.868636	Furculomyces boomerangus	61424	Fungi	Fungi	119	4.769999999999999e-31	NR	PVU86898.1	61424	g3021	i0	42	1.98611111111111	143	82	98.6	1	427	2	4	146	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	858	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
32249193	32249193	PRJNA1086823_P_NODE_12258_length_253_cov_0.866667_g12141_i0	PRJNA1086823	12258	253	0.866667	2.19266751	Entomophthora muscae	34485	Fungi	Fungi	95.9	3.3100000000000003e-21	NR	KAJ9055523.1	34485	g12141	i0	55.1	0.924901185770751	78	34	92.5	1	252	19	296	372	KAJ9055523.1 hypothetical protein DSO57_1003221 [Entomophthora muscae]	diamond	234	95.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae

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