metadata: contig_metadata: 10 rows where bioproject = "PRJNA478247", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA478247", 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
447834	447834	PRJNA478247_P_NODE_501_length_639_cov_5.498361_g406_i0	PRJNA478247	501	639	5.498361	35.13452679	Eukaryota	2759	Fungi	Fungi	264	1.21e-86	NR	OMH78596.1	1213189	g406	i0	70.4	8.81220657276995	189	56	88.7	0	606	40	2	190	OMH78596.1 40S ribosomal protein S9 [Zancudomyces culisetae]	diamond	5631	266	0.992481203007519	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
1722528	1722528	PRJNA478247_P_NODE_642_length_544_cov_4.260194_g537_i0	PRJNA478247	642	544	4.260194	23.17545536	Dispira simplex	2789359	Fungi	Fungi	224	1.19e-69	NR	KAJ1657582.1	2789359	g537	i0	68.3	0.904411764705882	164	49	89.9	2	491	3	7	168	KAJ1657582.1 hypothetical protein IWQ61_003036 [Dispira simplex]	diamond	492	224	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira simplex
17025039	17025039	PRJNA478247_P_NODE_2294_length_222_cov_1.611399_g2188_i0	PRJNA478247	2294	222	1.611399	3.57730578	Linderina pennispora	61395	Fungi	Fungi	167	6.739999999999999e-37	NTclustered	gi\|2028324920\|ref\|XM_040888337.1\|	61395	g2188	i0	83.158	62.963963963964	190	25	85	5	15	202	606	422	Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA	blastn	13978	167	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora
18299352	18299352	PRJNA478247_P_NODE_835_length_456_cov_2.257611_g730_i0	PRJNA478247	835	456	2.257611	10.29470616	Kickxellaceae	4862	Fungi	Fungi	166	4.51e-46	NR	KAJ1966075.1	4866	g730	i0	71.3	9.23684210526316	108	31	71.1	0	456	133	203	310	KAJ1966075.1 citrate (Si)-synthase [Dipsacomyces acuminosporus]	diamond	4212	167	0.994011976047904	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Dipsacomyces	Dipsacomyces acuminosporus
26696320	26696320	PRJNA478247_P_NODE_2981_length_179_cov_1.540000_g2875_i0	PRJNA478247	2981	179	1.54	2.7566	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	68.6	7.43e-12	NR	KAI9292875.1	1314799	g2875	i0	54.8	4.29050279329609	62	24	97.2	1	178	5	93	154	KAI9292875.1 Aldo/keto reductase [Neoconidiobolus thromboides FSU 785]	diamond	768	68.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
27297523	27297523	PRJNA478247_P_NODE_1403_length_321_cov_4.390411_g1297_i0	PRJNA478247	1403	321	4.390411	14.09321931	Syncephalis plumigaleata	1851185	Fungi	Fungi	133	6.189999999999999e-38	NR	KAI8053047.1	1851185	g1297	i0	66	1.89719626168224	100	33	92.5	1	309	13	1	100	KAI8053047.1 60S ribosomal protein L44 [Syncephalis plumigaleata]	diamond	609	133	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata
28086859	28086859	PRJNA478247_P_NODE_1045_length_394_cov_8.408219_g939_i0	PRJNA478247	1045	394	8.408219	33.12838286	Tieghemiomyces parasiticus	78921	Fungi	Fungi	96.3	1.55e-22	NR	KAJ1929896.1	78921	g939	i0	36.9	0.928934010152284	122	68	92.1	3	12	374	5	118	KAJ1929896.1 cofilin [Tieghemiomyces parasiticus]	diamond	366	96.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
29192185	29192185	PRJNA478247_P_NODE_2809_length_189_cov_2.312500_g2703_i0	PRJNA478247	2809	189	2.3125	4.370625	Zancudomyces culisetae	1213189	Fungi	Fungi	60.1	3.13e-9	NR	OMH81599.1	1213189	g2703	i0	58.5	0.841269841269841	53	21	82.5	1	25	180	1	53	OMH81599.1 Translationally-controlled tumor protein-like protein [Zancudomyces culisetae]	diamond	159	60.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
29649759	29649759	PRJNA478247_P_NODE_2830_length_188_cov_2.081761_g2724_i0	PRJNA478247	2830	188	2.081761	3.91371068	Coemansia	4863	Fungi	Fungi	59.3	8.14e-10	NR	KAJ2558075.1	2663887	g2724	i0	54.7	4.22872340425532	53	24	84.6	0	186	28	17	69	KAJ2558075.1 60S ribosomal protein L10, partial [Coemansia sp. RSA 1822]	diamond	795	59.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1822
30013194	30013194	PRJNA478247_P_NODE_1611_length_289_cov_2.053846_g1505_i0	PRJNA478247	1611	289	2.053846	5.93561494	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	119	3.7899999999999997e-32	NR	KAI9292941.1	1314799	g1505	i0	64	10.0276816608997	89	32	92.4	0	21	287	4	92	KAI9292941.1 ribosomal protein L24 [Neoconidiobolus thromboides FSU 785]	diamond	2898	119	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides

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