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

14 rows where bioproject = "PRJNA917598", 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
3446083	3446083	PRJNA917598_P_NODE_10923_length_720_cov_2.233385_g10023_i0	PRJNA917598	10923	720	2.233385	16.080372	Fungi	4751	Fungi	Fungi	257	1.81e-83	NR	KAJ9052662.1	34485	g10023	i0	69.7	7.34166666666667	195	57	80.8	2	720	139	8	201	KAJ9052662.1 ribosomal protein S8A [Entomophthora muscae]	diamond	5286	257	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
5079399	5079399	PRJNA917598_P_NODE_17284_length_564_cov_1.248473_g16349_i0	PRJNA917598	17284	564	1.248473	7.04138772	Eukaryota	2759	Fungi	Fungi	290	8.709999999999999e-90	NR	KAI8326243.1	61414	g16349	i0	77	42.8829787234043	183	42	97.3	0	3	551	366	548	KAI8326243.1 putative EFT2-translation elongation factor eEF2 [Martensiomyces pterosporus]	diamond	24186	290	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Martensiomyces	Martensiomyces pterosporus
7274741	7274741	PRJNA917598_P_NODE_62766_length_286_cov_1.103286_g61822_i0	PRJNA917598	62766	286	1.103286	3.15539796	Entomophaga aulicae	39303	Fungi	Fungi	63.9	1.22e-5	NTclustered	gi\|1373048\|gb\|U35394.1\|EAU35394	39303	g61822	i0	93.182	0.153846153846154	44	2	15	1	36	78	6017	6060	Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes	blastn	44	63.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophaga	Entomophaga aulicae
11099686	11099686	PRJNA917598_P_NODE_48229_length_330_cov_1.653696_g47285_i0	PRJNA917598	48229	330	1.653696	5.4571968	Piptocephalis cylindrospora	1907219	Fungi	Fungi	143	5.629999999999999e-37	NR	RKP13412.1	1907219	g47285	i0	62.6	11.6818181818182	107	37	96.4	2	5	322	563	667	RKP13412.1 elongation factor 2 [Piptocephalis cylindrospora]	diamond	3855	143	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis cylindrospora
21653878	21653878	PRJNA917598_P_NODE_83497_length_249_cov_0.875000_g82553_i0	PRJNA917598	83497	249	0.875	2.17875	Fungi	4751	Fungi	Fungi	113	4.910000000000001e-27	NR	KAJ1969850.1	1520584	g82553	i0	67.1	1.96385542168675	82	25	98.8	1	4	249	342	421	KAJ1969850.1 hypothetical protein IWQ62_000348 [Dispira parvispora]	diamond	489	113	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora
26866661	26866661	PRJNA917598_P_NODE_71921_length_268_cov_1.271795_g70977_i0	PRJNA917598	71921	268	1.271795	3.4084106	Ramicandelaber brevisporus	304332	Fungi	Fungi	54.7	1.53e-6	NR	KAI8870321.1	304332	g70977	i0	39.1	1.55597014925373	69	41	76.1	1	51	254	21	89	KAI8870321.1 MSF1-domain-containing protein [Ramicandelaber brevisporus]	diamond	417	54.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
28793028	28793028	PRJNA917598_P_NODE_89907_length_245_cov_0.895349_g88963_i0	PRJNA917598	89907	245	0.895349	2.19360505	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	67.4	2.39e-12	NR	KAI9293982.1	1314799	g88963	i0	64.6	0.587755102040816	48	17	58.8	0	9	152	3	50	KAI9293982.1 DNA binding protein [Neoconidiobolus thromboides FSU 785]	diamond	144	67.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
29148140	29148140	PRJNA917598_P_NODE_64409_length_283_cov_1.100000_g63465_i0	PRJNA917598	64409	283	1.1	3.113	Eukaryota	2759	Fungi	Fungi	76.6	3.9e-15	NR	PVU86898.1	61424	g63465	i0	44.4	5.14134275618375	81	45	85.9	0	281	39	84	164	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	1455	76.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29620911	29620911	PRJNA917598_P_NODE_95870_length_241_cov_0.916667_g94926_i0	PRJNA917598	95870	241	0.916667	2.20916747	Eukaryota	2759	Fungi	Fungi	43.9	0.0137	NR	PVU99981.1	61424	g94926	i0	80	2.20331950207469	20	4	24.9	0	189	130	330	349	PVU99981.1 hypothetical protein BB559_000239 [Furculomyces boomerangus]	diamond	531	44.3	0.99097065462754	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29803458	29803458	PRJNA917598_P_NODE_79431_length_251_cov_1.297753_g78487_i0	PRJNA917598	79431	251	1.297753	3.25736003	Coemansia reversa NRRL 1564	763665	Fungi	Fungi	77	9.26e-15	NR	PIA16217.1	763665	g78487	i0	52.9	2.97609561752988	87	36	98	2	250	5	167	253	PIA16217.1 putative vacuolar ATP synthase subunit D [Coemansia reversa NRRL 1564]	diamond	747	77	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
29842369	29842369	PRJNA917598_P_NODE_46171_length_338_cov_0.939623_g45227_i0	PRJNA917598	46171	338	0.939623	3.17592574	Fungi	4751	Fungi	Fungi	75.5	1.15e-14	NR	KAJ1992648.1	215637	g45227	i0	60.7	16.3934911242604	61	24	54.1	0	329	147	38	98	KAJ1992648.1 60S ribosomal protein L24 [Dimargaris cristalligena]	diamond	5541	75.9	0.994729907773386	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
30285093	30285093	PRJNA917598_P_NODE_89692_length_245_cov_0.895349_g88748_i0	PRJNA917598	89692	245	0.895349	2.19360505	Eukaryota	2759	Fungi	Fungi	47	0.00117	NR	KAJ2874040.1	417176	g88748	i0	65.6	5.73061224489796	32	11	39.2	0	149	244	222	253	KAJ2874040.1 hypothetical protein GGH93_002727 [Coemansia aciculifera]	diamond	1404	47	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia aciculifera
30316818	30316818	PRJNA917598_P_NODE_96012_length_241_cov_0.916667_g95068_i0	PRJNA917598	96012	241	0.916667	2.20916747	Fungi	4751	Fungi	Fungi	77	3.15e-14	NR	KAI8051525.1	1851185	g95068	i0	64.9	18.7219917012448	57	20	71	0	2	172	747	803	KAI8051525.1 P-loop containing nucleoside triphosphate hydrolase protein [Syncephalis plumigaleata]	diamond	4512	77.4	0.994832041343669	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata
30719713	30719713	PRJNA917598_P_NODE_95474_length_241_cov_0.916667_g94530_i0	PRJNA917598	95474	241	0.916667	2.20916747	Linderina pennispora	61395	Fungi	Fungi	120	6.54e-33	NR	KAJ1941459.1	61395	g94530	i0	69.6	2.95020746887967	79	24	98.3	0	3	239	43	121	KAJ1941459.1 40S ribosomal protein, partial [Linderina pennispora]	diamond	711	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora

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