metadata: contig_metadata: 13 rows where bioproject = "PRJNA801875" and tax

13 rows where bioproject = "PRJNA801875" 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
3351989	3351989	PRJNA801875_P_NODE_323_length_801_cov_2.544386_g238_i0	PRJNA801875	323	801	2.544386	20.38053186	Fungi	4751	Fungi	Fungi	326	1.86e-108	NR	RKP05545.1	78915	g238	i0	65.4	7.98876404494382	266	91	99.6	1	4	801	40	304	RKP05545.1 small nucleolar RNA, C/D box 21 [Thamnocephalis sphaerospora]	diamond	6399	326	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
17379463	17379463	PRJNA801875_P_NODE_2574_length_212_cov_5.700565_g2471_i0	PRJNA801875	2574	212	5.700565	12.0851978	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	120	1.51e-33	NR	ORX88884.1	1314790	g2471	i0	84.4	3.62264150943396	64	10	90.6	0	21	212	1	64	ORX88884.1 60S ribosomal protein L37 [Basidiobolus meristosporus CBS 931.73]	diamond	768	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
18652571	18652571	PRJNA801875_P_NODE_575_length_574_cov_3.395176_g475_i0	PRJNA801875	575	574	3.395176	19.48831024	Opisthokonta	33154	Fungi	Fungi	323	2.2799999999999996e-109	NR	KAK9680365.1	34480	g475	i0	78.9	53.6236933797909	190	40	99.3	0	572	3	50	239	KAK9680365.1 translation elongation factor 2 [Basidiobolus ranarum]	diamond	30780	323	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
26769267	26769267	PRJNA801875_P_NODE_2441_length_222_cov_1.491979_g2338_i0	PRJNA801875	2441	222	1.491979	3.31219338	Coemansia sp. RSA 988	2761391	Fungi	Fungi	73.2	4.95e-13	NR	KAJ2077102.1	2761391	g2338	i0	59.6	1.54054054054054	57	23	77	0	1	171	329	385	KAJ2077102.1 nuclear localization sequence binding protein [Coemansia sp. RSA 988]	diamond	342	73.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 988
27157520	27157520	PRJNA801875_P_NODE_2822_length_201_cov_0.945783_g2719_i0	PRJNA801875	2822	201	0.945783	1.90102383	Coemansia	4863	Fungi	Fungi	71.6	1.02e-12	NR	KAJ2794389.1	1286919	g2719	i0	46.5	4.29850746268657	71	32	97	1	2	196	223	293	KAJ2794389.1 Uroporphyrinogen decarboxylase in heme biosynthesis [Coemansia helicoidea]	diamond	864	71.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia helicoidea
27338763	27338763	PRJNA801875_P_NODE_4783_length_150_cov_1.339130_g4680_i0	PRJNA801875	4783	150	1.33913	2.008695	Entomophthora muscae	34485	Fungi	Fungi	42	0.00635	NR	KAJ9052102.1	34485	g4680	i0	41.2	1.02	51	24	90	2	14	148	10	60	KAJ9052102.1 hypothetical protein DSO57_1037550 [Entomophthora muscae]	diamond	153	42	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
27623002	27623002	PRJNA801875_P_NODE_1784_length_280_cov_2.530612_g1681_i0	PRJNA801875	1784	280	2.530612	7.0857136	Thamnocephalis sphaerospora	78915	Fungi	Fungi	108	1.62e-26	NR	RKP10674.1	78915	g1681	i0	64.9	2.57142857142857	74	26	79.3	0	5	226	137	210	RKP10674.1 small subunit ribosomal protein SAe, partial [Thamnocephalis sphaerospora]	diamond	720	108	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
27695142	27695142	PRJNA801875_P_NODE_1344_length_341_cov_3.127451_g1241_i0	PRJNA801875	1344	341	3.127451	10.66460791	Basidiobolus	4859	Fungi	Fungi	166	1.64e-50	NR	KAK9763929.1	34480	g1241	i0	75.7	4.67155425219941	107	26	94.1	0	335	15	22	128	KAK9763929.1 60S ribosomal protein L18, variant 2 [Basidiobolus ranarum]	diamond	1593	167	0.994011976047904	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
28190954	28190954	PRJNA801875_P_NODE_726_length_503_cov_3.098291_g624_i0	PRJNA801875	726	503	3.098291	15.58440373	Mycoemilia scoparia	417184	Fungi	Fungi	241	4.06e-78	NR	KAJ1916006.1	417184	g624	i0	67.5	0.990059642147117	166	54	99	0	2	499	34	199	KAJ1916006.1 60S ribosomal protein L16A [Mycoemilia scoparia]	diamond	498	241	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia
29494584	29494584	PRJNA801875_P_NODE_1330_length_344_cov_1.970874_g1227_i0	PRJNA801875	1330	344	1.970874	6.77980656	Zoopagomycota	1913638	Fungi	Fungi	99	9.81e-22	NR	KAJ9054115.1	34485	g1227	i0	49.1	8.06686046511628	116	50	99.4	3	3	344	20	128	KAJ9054115.1 Type I HSP40 co-chaperone [Entomophthora muscae]	diamond	2775	99	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
29580133	29580133	PRJNA801875_P_NODE_4490_length_154_cov_1.932773_g4387_i0	PRJNA801875	4490	154	1.932773	2.97647042	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	73.9	1.1e-13	NR	KXN72447.1	796925	g4387	i0	70.2	0.915584415584416	47	14	91.6	0	5	145	67	113	KXN72447.1 DEAD-domain-containing protein [Conidiobolus coronatus NRRL 28638]	diamond	141	73.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
30402160	30402160	PRJNA801875_P_NODE_3673_length_171_cov_1.161765_g3570_i0	PRJNA801875	3673	171	1.161765	1.98661815	Dispira simplex	2789359	Fungi	Fungi	53.9	1.65e-6	NR	KAJ1653781.1	2789359	g3570	i0	46.9	5.40350877192982	49	26	86	0	153	7	205	253	KAJ1653781.1 hypothetical protein IWQ61_006162, partial [Dispira simplex]	diamond	924	53.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira simplex
31887356	31887356	PRJNA801875_P_NODE_3497_length_175_cov_2.214286_g3394_i0	PRJNA801875	3497	175	2.214286	3.8750005	Massospora cicadina	348617	Fungi	Fungi	73.9	2.43e-15	NR	KAI0242418.1	348617	g3394	i0	64.3	0.96	56	20	96	0	170	3	12	67	KAI0242418.1 ribosomal protein L36 [Massospora cicadina]	diamond	168	73.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina

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