metadata: contig_metadata: 15 rows where bioproject = "PRJEB81327" and tax

15 rows where bioproject = "PRJEB81327" 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
2689894	2689894	PRJEB81327_P_NODE_35763_length_268_cov_1.974359_g35155_i0	PRJEB81327	35763	268	1.974359	5.29128212	Entomophthora muscae	34485	Fungi	Fungi	283	7.989999999999999e-72	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g35155	i0	87.854	49.9589552238806	247	22	91	7	1	243	1812	2054	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	13389	283	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
9067076	9067076	PRJEB81327_P_NODE_31248_length_276_cov_1.512315_g30640_i0	PRJEB81327	31248	276	1.512315	4.1739894	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	119	7.4899999999999995e-31	NR	ORX92683.1	1314790	g30640	i0	78.1	3.18478260869565	73	16	79.3	0	221	3	76	148	ORX92683.1 NIF-domain-containing protein [Basidiobolus meristosporus CBS 931.73]	diamond	879	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
20540494	20540494	PRJEB81327_P_NODE_13417_length_369_cov_1.040541_g12809_i0	PRJEB81327	13417	369	1.040541	3.83959629	Linderina pennispora	61395	Fungi	Fungi	248	4.1699999999999995e-61	NTclustered	gi\|2028317494\|ref\|XM_040891298.1\|	61395	g12809	i0	81.911	32.2059620596206	293	53	79	0	74	366	426	134	Linderina pennispora 60S ribosomal protein L23 (DL89DRAFT_321716), partial mRNA	blastn	11884	248	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
26900491	26900491	PRJEB81327_P_NODE_15101_length_347_cov_1.200730_g14493_i0	PRJEB81327	15101	347	1.20073	4.1665331	root	1	Root_unresolved	Root_unresolved	122	2.22e-33	NR	KXN73393.1	796925	g14493	i0	51.3	3.95965417867435	115	56	99.4	0	3	347	2	116	KXN73393.1 profilin-2 [Conidiobolus coronatus NRRL 28638]	diamond	1374	122	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
28353403	28353403	PRJEB81327_P_NODE_30706_length_277_cov_1.421569_g30098_i0	PRJEB81327	30706	277	1.421569	3.93774613	Fungi	4751	Fungi	Fungi	83.2	5.26e-18	NR	KAK9761654.1	34480	g30098	i0	54.5	3.85559566787004	88	34	95.3	3	1	264	3	84	KAK9761654.1 hypothetical protein K7432_013291 [Basidiobolus ranarum]	diamond	1068	83.6	0.995215311004785	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
28360625	28360625	PRJEB81327_P_NODE_65866_length_240_cov_2.269461_g65258_i0	PRJEB81327	65866	240	2.269461	5.4467064	Kickxella alabastrina	61397	Fungi	Fungi	43.9	0.0139	NR	XP_051391944.1	61397	g65258	i0	47.6	1.775	63	30	77.5	3	213	28	45	105	XP_051391944.1 uncharacterized protein BX661DRAFT_14085 [Kickxella alabastrina]	diamond	426	43.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
28550379	28550379	PRJEB81327_P_NODE_10927_length_412_cov_1.625369_g10319_i0	PRJEB81327	10927	412	1.625369	6.69652028	Dimargaris verticillata	2761393	Fungi	Fungi	163	1.48e-44	NR	KAJ1979173.1	2761393	g10319	i0	66.1	1.8495145631068	127	43	92.5	0	17	397	1	127	KAJ1979173.1 hypothetical protein H4R34_002928 [Dimargaris verticillata]	diamond	762	163	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris verticillata
29718160	29718160	PRJEB81327_P_NODE_11450_length_401_cov_1.878049_g10842_i0	PRJEB81327	11450	401	1.878049	7.53097649	Ramicandelaber brevisporus	304332	Fungi	Fungi	98.6	1.37e-23	NR	KAI8872700.1	304332	g10842	i0	41	0.875311720698254	117	61	87.5	1	379	29	13	121	KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus]	diamond	351	98.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
30690396	30690396	PRJEB81327_P_NODE_42193_length_257_cov_2.271739_g41585_i0	PRJEB81327	42193	257	2.271739	5.83836923	Fungi	4751	Fungi	Fungi	99.8	1.72e-25	NR	PVU85825.1	61424	g41585	i0	80.6	5.76653696498054	62	11	71.2	1	8	190	6	67	PVU85825.1 hypothetical protein BB559_006802 [Furculomyces boomerangus]	diamond	1482	99.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
30887354	30887354	PRJEB81327_P_NODE_17514_length_323_cov_1.212000_g16906_i0	PRJEB81327	17514	323	1.212	3.91476	Dispira parvispora	1520584	Fungi	Fungi	139	1.02e-39	NR	KAJ1951137.1	1520584	g16906	i0	68.8	4.75541795665635	96	30	89.2	0	321	34	24	119	KAJ1951137.1 40S ribosomal protein S17.e.B [Dispira parvispora]	diamond	1536	139	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira parvispora
31234768	31234768	PRJEB81327_P_NODE_13495_length_368_cov_1.044068_g12887_i0	PRJEB81327	13495	368	1.044068	3.84217024	Coemansia reversa NRRL 1564	763665	Fungi	Fungi	139	9.01e-39	NR	PIA15838.1	763665	g12887	i0	59.8	4.94836956521739	122	48	99.5	1	368	3	4	124	PIA15838.1 ribosomal protein L13e [Coemansia reversa NRRL 1564]	diamond	1821	139	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
31583029	31583029	PRJEB81327_P_NODE_17836_length_320_cov_1.773279_g17228_i0	PRJEB81327	17836	320	1.773279	5.6744928	Furculomyces boomerangus	61424	Fungi	Fungi	83.2	1.79e-17	NR	PVU86898.1	61424	g17228	i0	39	0.984375	105	63	97.5	1	313	2	4	108	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	315	83.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
31962394	31962394	PRJEB81327_P_NODE_14738_length_351_cov_0.830935_g14130_i0	PRJEB81327	14738	351	0.830935	2.91658185	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	153	2.9699999999999993e-43	NR	KXN74832.1	796925	g14130	i0	67.2	1.98290598290598	116	34	99.1	1	3	350	62	173	KXN74832.1 60S ribosomal protein L5 [Conidiobolus coronatus NRRL 28638]	diamond	696	153	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
32405506	32405506	PRJEB81327_P_NODE_36919_length_266_cov_2.041451_g36311_i0	PRJEB81327	36919	266	2.041451	5.43025966	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	65.9	3.29e-10	NR	KXN68014.1	796925	g36311	i0	42.5	1.93984962406015	80	44	90.2	1	262	23	141	218	KXN68014.1 WD40 repeat-like protein [Conidiobolus coronatus NRRL 28638]	diamond	516	65.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
32902565	32902565	PRJEB81327_P_NODE_22160_length_296_cov_1.237668_g21552_i0	PRJEB81327	22160	296	1.237668	3.66349728	Fungi	4751	Fungi	Fungi	123	2.07e-34	NR	KAK9762495.1	34480	g21552	i0	75.3	22.6418918918919	77	19	78	0	294	64	16	92	KAK9762495.1 60S ribosomal protein L43 [Basidiobolus ranarum]	diamond	6702	124	0.991935483870968	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum

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