metadata: contig_metadata: 14 rows where bioproject = "PRJNA1174207", tax_kingdom = "Fungi" and tax

14 rows where bioproject = "PRJNA1174207", 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
315456	315456	PRJNA1174207_P_NODE_16701_length_350_cov_3.137184_g16172_i0	PRJNA1174207	16701	350	3.137184	10.980144	Fungi	4751	Fungi	Fungi	89.7	1.39e-18	NR	KAK9762048.1	34480	g16172	i0	68	5.32285714285714	50	16	42.9	0	346	197	283	332	KAK9762048.1 white collar 2 type of transcription factor [Basidiobolus ranarum]	diamond	1863	90.1	0.995560488346282	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
2866469	2866469	PRJNA1174207_P_NODE_27823_length_274_cov_1.004975_g27294_i0	PRJNA1174207	27823	274	1.004975	2.7536315	Pandora neoaphidis	76017	Fungi	Fungi	505	1.61e-138	NTclustered	gi\|1390219702\|gb\|MH366634.1\|	76017	g27294	i0	100	57.6569343065693	273	0	99	0	2	274	685	413	Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence	blastn	15798	505	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis
13069273	13069273	PRJNA1174207_P_NODE_30571_length_262_cov_1.629630_g30042_i0	PRJNA1174207	30571	262	1.62963	4.2696306	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	122	4.68e-33	NR	KXN71722.1	796925	g30042	i0	72.4	1.99236641221374	87	24	99.6	0	2	262	18	104	KXN71722.1 ribosomal protein L11 [Conidiobolus coronatus NRRL 28638]	diamond	522	122	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
19441354	19441354	PRJNA1174207_P_NODE_14656_length_379_cov_1.477124_g14127_i0	PRJNA1174207	14656	379	1.477124	5.59829996	Dispira parvispora	1520584	Fungi	Fungi	157	1.54e-45	NR	KAJ1950723.1	1520584	g14127	i0	65	5.84168865435356	123	43	97.4	0	373	5	1	123	KAJ1950723.1 60S ribosomal protein L10A [Dispira parvispora]	diamond	2214	157	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora
26616494	26616494	PRJNA1174207_P_NODE_35201_length_249_cov_0.875000_g34672_i0	PRJNA1174207	35201	249	0.875	2.17875	Fungi	4751	Fungi	Fungi	68.6	2.38e-11	NR	OMH79187.1	1213189	g34672	i0	47.8	5.28915662650602	67	34	80.7	1	201	1	6	71	OMH79187.1 putative quinone oxidoreductase [Zancudomyces culisetae]	diamond	1317	68.9	0.995645863570392	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
26933192	26933192	PRJNA1174207_P_NODE_21502_length_308_cov_1.259574_g20973_i0	PRJNA1174207	21502	308	1.259574	3.87948792	Fungi	4751	Fungi	Fungi	108	1.27e-25	NR	KAJ1992004.1	215637	g20973	i0	53.5	3.92532467532468	101	46	98.4	1	304	2	114	213	KAJ1992004.1 hypothetical protein H4R33_001162 [Dimargaris cristalligena]	diamond	1209	109	0.990825688073395	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
29471789	29471789	PRJNA1174207_P_NODE_3530_length_961_cov_3.306306_g3096_i0	PRJNA1174207	3530	961	3.306306	31.77360066	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	207	3.7899999999999995e-61	NR	ORY02900.1	1314790	g3096	i0	44	0.930280957336108	298	150	92.7	5	40	930	18	299	ORY02900.1 beta-Ig-H3/fasciclin [Basidiobolus meristosporus CBS 931.73]	diamond	894	207	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
30154261	30154261	PRJNA1174207_P_NODE_41152_length_241_cov_1.726190_g40623_i0	PRJNA1174207	41152	241	1.72619	4.1601179	Opisthokonta	33154	Fungi	Fungi	114	1.23e-28	NR	KAJ1958873.1	4866	g40623	i0	71.3	27.8464730290456	80	23	99.6	0	240	1	23	102	KAJ1958873.1 translation termination factor eRF1, partial [Dipsacomyces acuminosporus]	diamond	6711	114	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Dipsacomyces	Dipsacomyces acuminosporus
31114523	31114523	PRJNA1174207_P_NODE_10055_length_483_cov_1.241463_g9529_i0	PRJNA1174207	10055	483	1.241463	5.99626629	Smittium culicis	133412	Fungi	Fungi	77.8	1.02e-14	NR	OMJ16535.1	133412	g9529	i0	44	4.40993788819876	116	49	72	3	3	350	54	153	OMJ16535.1 Eukaryotic translation initiation factor 5A [Smittium culicis]	diamond	2130	77.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
31228619	31228619	PRJNA1174207_P_NODE_40655_length_242_cov_0.911243_g40126_i0	PRJNA1174207	40655	242	0.911243	2.20520806	Zoopagomycota	1913638	Fungi	Fungi	48.5	1.45e-4	NR	OLY79241.1	133383	g40126	i0	44.7	2.28099173553719	47	26	58.3	0	102	242	99	145	OLY79241.1 Nicotinamide phosphoribosyltransferase, partial [Smittium mucronatum]	diamond	552	48.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
31873751	31873751	PRJNA1174207_P_NODE_8757_length_526_cov_3.000000_g8233_i0	PRJNA1174207	8757	526	3	15.78	Coemansia sp. RSA 2336	2512256	Fungi	Fungi	66.2	3.42e-10	NR	KAJ2450672.1	2512256	g8233	i0	28.8	0.872623574144487	153	100	86.7	4	33	488	1	145	KAJ2450672.1 cofilin [Coemansia sp. RSA 2336]	diamond	459	66.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2336
31905377	31905377	PRJNA1174207_P_NODE_39937_length_243_cov_0.905882_g39408_i0	PRJNA1174207	39937	243	0.905882	2.20129326	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	104	6.35e-24	NR	ORX87269.1	1314790	g39408	i0	57.5	6.91358024691358	80	34	98.8	0	2	241	271	350	ORX87269.1 PLP-dependent transferase [Basidiobolus meristosporus CBS 931.73]	diamond	1680	104	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
32304640	32304640	PRJNA1174207_P_NODE_39879_length_243_cov_0.905882_g39350_i0	PRJNA1174207	39879	243	0.905882	2.20129326	Fungi	4751	Fungi	Fungi	102	1.24e-25	NR	PVU84961.1	61424	g39350	i0	62.5	4.28395061728395	80	28	98.8	1	4	243	3	80	PVU84961.1 hypothetical protein BB559_007280 [Furculomyces boomerangus]	diamond	1041	102	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
32538455	32538455	PRJNA1174207_P_NODE_30679_length_262_cov_1.243386_g30150_i0	PRJNA1174207	30679	262	1.243386	3.25767132	Mycoemilia scoparia	417184	Fungi	Fungi	58.5	3.3e-8	NR	KAJ1917368.1	417184	g30150	i0	35.6	9.22900763358779	87	54	97.3	2	2	256	34	120	KAJ1917368.1 delta subunit of the central stalk of mitochondrial F1F0 ATP synthase, atp16 [Mycoemilia scoparia]	diamond	2418	58.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia

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