metadata: contig_metadata: 10 rows where bioproject = "PRJEB673", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJEB673", 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
2685034	2685034	PRJEB673_P_NODE_8343_length_285_cov_1.312000_g7994_i0	PRJEB673	8343	285	1.312	3.7392	Eukaryota	2759	Fungi	Fungi	149	4.66e-44	NR	KAI8872601.1	304332	g7994	i0	73.4	5.93684210526316	94	25	98.9	0	283	2	20	113	KAI8872601.1 40S ribosomal protein S13 [Ramicandelaber brevisporus]	diamond	1692	150	0.993333333333333	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
12888529	12888529	PRJEB673_P_NODE_7211_length_322_cov_1.254355_g6862_i0	PRJEB673	7211	322	1.254355	4.0390231	Syncephalis pseudoplumigaleata	1712513	Fungi	Fungi	107	1.73e-26	NR	RKP27899.1	1712513	g6862	i0	49.1	3.1304347826087	112	46	96	2	13	321	30	139	RKP27899.1 ribosomal protein S13 [Syncephalis pseudoplumigaleata]	diamond	1008	107	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis pseudoplumigaleata
16297946	16297946	PRJEB673_P_NODE_3273_length_552_cov_1.765957_g2957_i0	PRJEB673	3273	552	1.765957	9.74808264	Opisthokonta	33154	Fungi	Fungi	162	1.47e-46	NR	KAI8865751.1	304332	g2957	i0	61.4	15.3097826086957	127	49	69	0	519	139	3	129	KAI8865751.1 ribosomal protein L13e [Ramicandelaber brevisporus]	diamond	8451	163	0.993865030674847	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
16711601	16711601	PRJEB673_P_NODE_5734_length_369_cov_1.622754_g5385_i0	PRJEB673	5734	369	1.622754	5.98796226	Linderina pennispora	61395	Fungi	Fungi	158	7.22e-34	NTclustered	gi\|2028324920\|ref\|XM_040888337.1\|	61395	g5385	i0	82.584	3.85907859078591	178	31	48	0	189	366	226	403	Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA	blastn	1424	158	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
29118616	29118616	PRJEB673_P_NODE_7369_length_318_cov_1.434629_g7020_i0	PRJEB673	7369	318	1.434629	4.56212022	Furculomyces boomerangus	61424	Fungi	Fungi	67.4	4.84e-11	NR	PVU85138.1	61424	g7020	i0	73.2	4.25471698113208	41	11	38.7	0	123	1	122	162	PVU85138.1 hypothetical protein BB559_007195 [Furculomyces boomerangus]	diamond	1353	67.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29118617	29118617	PRJEB673_P_NODE_8169_length_294_cov_1.370656_g7820_i0	PRJEB673	8169	294	1.370656	4.02972864	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	152	1.88e-44	NR	ORX96007.1	1314790	g7820	i0	74.5	6	98	25	100	0	294	1	34	131	ORX96007.1 ribosomal protein L18e [Basidiobolus meristosporus CBS 931.73]	diamond	1764	152	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
29876272	29876272	PRJEB673_P_NODE_9571_length_193_cov_1.265823_g9222_i0	PRJEB673	9571	193	1.265823	2.44303839	Smittium megazygosporum	133381	Fungi	Fungi	78.2	5.51e-15	NR	PVU85322.1	133381	g9222	i0	58.7	0.979274611398964	63	26	97.9	0	191	3	134	196	PVU85322.1 hypothetical protein BB560_007060 [Smittium megazygosporum]	diamond	189	78.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
30319034	30319034	PRJEB673_P_NODE_11932_length_157_cov_1.655738_g11583_i0	PRJEB673	11932	157	1.655738	2.59950866	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	57	5.38e-8	NR	ORY04609.1	1314790	g11583	i0	56.9	0.974522292993631	51	22	97.5	0	5	157	66	116	ORY04609.1 F1 complex, OSCP/delta subunit of ATPase [Basidiobolus meristosporus CBS 931.73]	diamond	153	57	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
31835550	31835550	PRJEB673_P_NODE_5097_length_400_cov_1.682192_g4748_i0	PRJEB673	5097	400	1.682192	6.728768	Coemansia sp. RSA 552	2663883	Fungi	Fungi	119	5.979999999999999e-32	NR	KAJ2162350.1	2663883	g4748	i0	54.3	3.0825	105	44	75.8	1	89	391	4	108	KAJ2162350.1 60S ribosomal protein L33 [Coemansia sp. RSA 552]	diamond	1233	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 552
32595086	32595086	PRJEB673_P_NODE_8720_length_242_cov_1.545894_g8371_i0	PRJEB673	8720	242	1.545894	3.74106348	Smittium culicis	133412	Fungi	Fungi	78.2	1.38e-16	NR	OMJ15099.1	133412	g8371	i0	70.2	1.72314049586777	47	14	58.3	0	242	102	61	107	OMJ15099.1 60S ribosomal protein L33-A [Smittium culicis]	diamond	417	78.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis

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