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

14 rows where bioproject = "PRJNA685607", 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
16479137	16479137	PRJNA685607_P_NODE_42673_length_293_cov_2.995455_g42314_i0	PRJNA685607	42673	293	2.995455	8.77668315	Fungi	4751	Fungi	Fungi	231	3.25e-56	NTclustered	gi\|358030843\|dbj\|AB609155.1\|	68401	g42314	i0	84.454	11.2866894197952	238	33	81	4	58	293	802	1037	Spiromyces aspiralis EF2 gene for translation elongation factor 2, partial cds, strain: NRRL 22631	blastn	3307	231	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
19793260	19793260	PRJNA685607_P_NODE_43256_length_292_cov_1.397260_g42897_i0	PRJNA685607	43256	292	1.39726	4.0799992	Fungi	4751	Fungi	Fungi	112	1.54e-26	NR	OMJ09862.1	133412	g42897	i0	52	11.2294520547945	100	45	99.7	1	291	1	168	267	OMJ09862.1 Polyadenylate-binding protein, cytoplasmic and nuclear [Smittium culicis]	diamond	3279	112	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
21068797	21068797	PRJNA685607_P_NODE_5957_length_630_cov_3.165171_g5612_i0	PRJNA685607	5957	630	3.165171	19.9405773	Eukaryota	2759	Fungi	Fungi	313	5.879999999999997e-106	NR	KXN70993.1	796925	g5612	i0	73.2	17.2666666666667	198	53	94.3	0	610	17	1	198	KXN70993.1 putative ribosomal protein L10 [Conidiobolus coronatus NRRL 28638]	diamond	10878	316	0.990506329113924	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
27903250	27903250	PRJNA685607_P_NODE_43605_length_291_cov_1.412844_g43246_i0	PRJNA685607	43605	291	1.412844	4.11137604	Dimargaris cristalligena	215637	Fungi	Fungi	84.7	5.42e-18	NR	KAJ1985724.1	215637	g43246	i0	62.7	6.89690721649485	67	25	69.1	0	291	91	124	190	KAJ1985724.1 60S ribosomal protein L18 [Dimargaris cristalligena]	diamond	2007	84.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
28566494	28566494	PRJNA685607_P_NODE_86787_length_244_cov_0.900585_g86428_i0	PRJNA685607	86787	244	0.900585	2.1974274	Coemansia interrupta	1126814	Fungi	Fungi	51.6	2.87e-5	NR	KAJ2778139.1	1126814	g86428	i0	32.9	6.33196721311475	76	50	93.4	1	241	14	314	388	KAJ2778139.1 hypothetical protein GGI15_004268 [Coemansia interrupta]	diamond	1545	51.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia interrupta
29103433	29103433	PRJNA685607_P_NODE_46188_length_286_cov_1.154930_g45829_i0	PRJNA685607	46188	286	1.15493	3.3030998	Coemansia nantahalensis	2789366	Fungi	Fungi	80.1	8.56e-16	NR	KAJ2770598.1	2789366	g45829	i0	44.8	6.3041958041958	87	45	88.1	2	270	19	1	87	KAJ2770598.1 Exosome non-catalytic core component [Coemansia nantahalensis]	diamond	1803	80.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia nantahalensis
29777810	29777810	PRJNA685607_P_NODE_60511_length_258_cov_1.664865_g60152_i0	PRJNA685607	60511	258	1.664865	4.2953517	Eukaryota	2759	Fungi	Fungi	50.4	4.77e-5	NR	ORY04908.1	1314790	g60152	i0	49.3	2.98837209302326	67	31	74.4	3	207	16	1	67	ORY04908.1 40S ribosomal protein S7 [Basidiobolus meristosporus CBS 931.73]	diamond	771	50.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
30188500	30188500	PRJNA685607_P_NODE_75932_length_247_cov_1.689655_g75573_i0	PRJNA685607	75932	247	1.689655	4.17344785	Fungi	4751	Fungi	Fungi	73.2	1.6e-13	NR	KAJ1675887.1	68401	g75573	i0	74	1.97975708502024	50	13	60.7	0	96	245	80	129	KAJ1675887.1 60S ribosomal protein L6 [Spiromyces aspiralis]	diamond	489	73.9	0.990527740189445	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
30315469	30315469	PRJNA685607_P_NODE_10252_length_487_cov_3.077295_g9896_i0	PRJNA685607	10252	487	3.077295	14.98642665	Fungi	4751	Fungi	Fungi	164	7.829999999999998e-48	NR	KAI8865751.1	304332	g9896	i0	62.2	8.22381930184805	127	48	78.2	0	461	81	3	129	KAI8865751.1 ribosomal protein L13e [Ramicandelaber brevisporus]	diamond	4005	164	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
30335401	30335401	PRJNA685607_P_NODE_21552_length_367_cov_1.207483_g21193_i0	PRJNA685607	21552	367	1.207483	4.43146261	Dimargaris verticillata	2761393	Fungi	Fungi	129	3.89e-36	NR	KAJ1983667.1	2761393	g21193	i0	67.4	6.43324250681199	86	28	70.3	0	41	298	4	89	KAJ1983667.1 60S ribosomal protein L43 [Dimargaris verticillata]	diamond	2361	129	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris verticillata
30536108	30536108	PRJNA685607_P_NODE_75673_length_248_cov_0.880000_g75314_i0	PRJNA685607	75673	248	0.88	2.1824	Zoopagomycota	1913638	Fungi	Fungi	99	7.48e-23	NR	RKP10886.1	78915	g75314	i0	60.3	7.99596774193548	73	29	88.3	0	221	3	1	73	RKP10886.1 inorganic diphosphatase [Thamnocephalis sphaerospora]	diamond	1983	99	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
30852042	30852042	PRJNA685607_P_NODE_12034_length_457_cov_1.804688_g11677_i0	PRJNA685607	12034	457	1.804688	8.24742416	Eukaryota	2759	Fungi	Fungi	178	4.17e-53	NR	RKP10016.1	78915	g11677	i0	61.2	9.62363238512035	147	55	96.5	1	16	456	1	145	RKP10016.1 40S ribosomal protein S6-B [Thamnocephalis sphaerospora]	diamond	4398	179	0.994413407821229	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
31262868	31262868	PRJNA685607_P_NODE_83355_length_245_cov_0.895349_g82996_i0	PRJNA685607	83355	245	0.895349	2.19360505	Eukaryota	2759	Fungi	Fungi	105	2.64e-24	NR	KAI9292045.1	1314799	g82996	i0	61.7	5.95102040816327	81	31	99.2	0	1	243	324	404	KAI9292045.1 T-complex protein 1 subunit alpha [Neoconidiobolus thromboides FSU 785]	diamond	1458	106	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
32642624	32642624	PRJNA685607_P_NODE_4260_length_753_cov_3.655882_g3939_i0	PRJNA685607	4260	753	3.655882	27.52879146	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	312	3.169999999999999e-104	NR	ORX80989.1	1314790	g3939	i0	63.4	5.86852589641434	246	86	97.2	2	2	733	1	244	ORX80989.1 ribosomal protein S3Ae [Basidiobolus meristosporus CBS 931.73]	diamond	4419	312	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus

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