metadata: contig_metadata: 14 rows where bioproject = "PRJNA1132896", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA1132896", tax_clade = "Opisthokonta" 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
7409665	7409665	PRJNA1132896_P_NODE_2986_length_323_cov_1.196000_g2895_i0	PRJNA1132896	2986	323	1.196	3.86308	Eukaryota	2759	Fungi	Fungi	145	5.769999999999998e-42	NR	KAJ1987619.1	215637	g2895	i0	74.5	5.73993808049536	102	23	94.7	2	309	4	3	101	KAJ1987619.1 40S ribosomal protein S11-B [Dimargaris cristalligena]	diamond	1854	146	0.993150684931507	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
8684842	8684842	PRJNA1132896_P_NODE_1787_length_401_cov_3.329268_g1696_i0	PRJNA1132896	1787	401	3.329268	13.35036468	Fungi	4751	Fungi	Fungi	243	2.12e-59	NTclustered	gi\|2028327270\|ref\|XM_040888737.1\|	61395	g1696	i0	78.372	64.7980049875312	393	72	96	10	8	392	646	259	Linderina pennispora 40S ribosomal protein S2 (DL89DRAFT_270502), mRNA	blastn	25984	244	0.995901639344262	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
26869839	26869839	PRJNA1132896_P_NODE_1041_length_509_cov_2.036697_g950_i0	PRJNA1132896	1041	509	2.036697	10.36678773	Basidiobolomycetes	1399768	Fungi	Fungi	208	2.19e-65	NR	KAI8872435.1	304332	g950	i0	67.1	4.81532416502947	164	53	96.1	1	491	3	1	164	KAI8872435.1 ribosomal protein L18e [Ramicandelaber brevisporus]	diamond	2451	208	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
27691597	27691597	PRJNA1132896_P_NODE_1544_length_427_cov_1.115819_g1453_i0	PRJNA1132896	1544	427	1.115819	4.76454713	Zoopagomycota	1913638	Fungi	Fungi	90.1	8.1e-18	NR	RKP37703.1	215637	g1453	i0	38.2	8.6768149882904	144	67	99.8	5	2	427	465	588	RKP37703.1 Aspartate/glutamate/uridylate kinase [Dimargaris cristalligena]	diamond	3705	90.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
28080941	28080941	PRJNA1132896_P_NODE_65_length_1807_cov_4.243945_g49_i0	PRJNA1132896	65	1807	4.243945	76.68808615	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	201	2.38e-52	NR	ORX91654.1	1314790	g49	i0	27.4	1.06585500830105	642	396	98	18	1787	18	54	677	ORX91654.1 hypothetical protein K493DRAFT_264315, partial [Basidiobolus meristosporus CBS 931.73]	diamond	1926	201	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
29017712	29017712	PRJNA1132896_P_NODE_1488_length_433_cov_1.708333_g1397_i0	PRJNA1132896	1488	433	1.708333	7.39708189	Fungi	4751	Fungi	Fungi	162	1.66e-47	NR	KAI8865751.1	304332	g1397	i0	61.4	17.2170900692841	127	49	88	0	2	382	3	129	KAI8865751.1 ribosomal protein L13e [Ramicandelaber brevisporus]	diamond	7455	163	0.993865030674847	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
29123296	29123296	PRJNA1132896_P_NODE_69_length_1757_cov_4.361045_g53_i0	PRJNA1132896	69	1757	4.361045	76.62356065	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	209	3.8599999999999984e-55	NR	ORX91654.1	1314790	g53	i0	27.4	1.08594194649972	636	389	99.4	17	12	1757	35	651	ORX91654.1 hypothetical protein K493DRAFT_264315, partial [Basidiobolus meristosporus CBS 931.73]	diamond	1908	209	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
29912566	29912566	PRJNA1132896_P_NODE_1671_length_412_cov_1.480826_g1580_i0	PRJNA1132896	1671	412	1.480826	6.10100312	Coemansia sp. RSA 2611	2761403	Fungi	Fungi	45.1	0.0283	NR	KAJ2371264.1	2761403	g1580	i0	43.6	0.400485436893204	55	31	40	0	409	245	143	197	KAJ2371264.1 hypothetical protein H4S02_009619, partial [Coemansia sp. RSA 2611]	diamond	165	45.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2611
30196551	30196551	PRJNA1132896_P_NODE_5072_length_274_cov_0.970149_g4981_i0	PRJNA1132896	5072	274	0.970149	2.65820826	Coemansia sp. RSA 1933	2512254	Fungi	Fungi	125	4.589999999999999e-31	NR	KAJ2551982.1	2512254	g4981	i0	65.5	3.83211678832117	87	30	95.3	0	273	13	10	96	KAJ2551982.1 proteasome regulatory particle base subunit [Coemansia sp. RSA 1933]	diamond	1050	125	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1933
30733791	30733791	PRJNA1132896_P_NODE_5174_length_272_cov_1.547739_g5083_i0	PRJNA1132896	5174	272	1.547739	4.20985008	Smittium megazygosporum	133381	Fungi	Fungi	60.5	3.06e-8	NR	PVV00305.1	133381	g5083	i0	78.9	1.61029411764706	38	8	41.9	0	272	159	227	264	PVV00305.1 hypothetical protein BB560_005319 [Smittium megazygosporum]	diamond	438	60.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
30849276	30849276	PRJNA1132896_P_NODE_5254_length_271_cov_1.530303_g5163_i0	PRJNA1132896	5254	271	1.530303	4.14712113	Opisthokonta	33154	Fungi	Fungi	97.8	2.2100000000000003e-21	NR	KAI8321826.1	61414	g5163	i0	45.9	7.15129151291513	85	45	94.1	1	260	6	173	256	KAI8321826.1 translation initiation factor eIF-3b [Martensiomyces pterosporus]	diamond	1938	97.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Martensiomyces	Martensiomyces pterosporus
30891980	30891980	PRJNA1132896_P_NODE_10574_length_231_cov_2.778481_g10483_i0	PRJNA1132896	10574	231	2.778481	6.41829111	Basidiobolus ranarum	34480	Fungi	Fungi	42.4	0.0447	NR	KAK9728054.1	34480	g10483	i0	35.3	0.662337662337662	51	30	66.2	1	155	3	1	48	KAK9728054.1 hypothetical protein K7432_001370 [Basidiobolus ranarum]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
31987547	31987547	PRJNA1132896_P_NODE_2138_length_370_cov_4.976431_g2047_i0	PRJNA1132896	2138	370	4.976431	18.4127947	Zoopagomycota	1913638	Fungi	Fungi	151	5.98e-44	NR	OMH82466.1	1213189	g2047	i0	76.6	2.2864864864864902	94	22	76.2	0	86	367	1	94	OMH82466.1 60S ribosomal protein L12 [Zancudomyces culisetae]	diamond	846	152	0.993421052631579	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
32209159	32209159	PRJNA1132896_P_NODE_8938_length_245_cov_0.895349_g8847_i0	PRJNA1132896	8938	245	0.895349	2.19360505	Fungi	4751	Fungi	Fungi	49.7	1.4e-4	NR	KAI0225318.1	348617	g8847	i0	37.5	1.3469387755102	56	35	68.6	0	242	75	390	445	KAI0225318.1 bifunctional 4-alpha-glucanotransferase/amylo-alpha-1,6-glucosidase [Massospora cicadina]	diamond	330	49.7	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);;