metadata: contig_metadata: 8 rows where bioproject = "PRJNA345071", tax_kingdom = "Fungi" and tax

8 rows where bioproject = "PRJNA345071", 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
15695917	15695917	PRJNA345071_P_NODE_1713_length_425_cov_2.931818_g1673_i0	PRJNA345071	1713	425	2.931818	12.4602265	Fungi	4751	Fungi	Fungi	250	4.73e-75	NR	OMJ21786.1	133412	g1673	i0	89.4	29.8588235294118	141	15	99.5	0	1	423	185	325	OMJ21786.1 Chaperone protein ClpB1 [Smittium culicis]	diamond	12690	252	0.992063492063492	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
20794690	20794690	PRJNA345071_P_NODE_1957_length_404_cov_1.410876_g1917_i0	PRJNA345071	1957	404	1.410876	5.69993904	Basidiobolus ranarum	34480	Fungi	Fungi	178	2.3199999999999994e-54	NR	KAK9687413.1	34480	g1917	i0	70.1	0.995049504950495	134	37	97.3	1	10	402	35	168	KAK9687413.1 hypothetical protein K7432_014802, partial [Basidiobolus ranarum]	diamond	402	178	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
24022196	24022196	PRJNA345071_P_NODE_9239_length_247_cov_0.896552_g9199_i0	PRJNA345071	9239	247	0.896552	2.21448344	Eukaryota	2759	Fungi	Fungi	149	7.28e-41	NR	KAJ1674015.1	68401	g9199	i0	81.7	40.834008097166	82	15	99.6	0	247	2	136	217	KAJ1674015.1 succinate dehydrogenase flavoprotein subunit, partial [Spiromyces aspiralis]	diamond	10086	149	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
28165858	28165858	PRJNA345071_P_NODE_825_length_571_cov_1.997992_g785_i0	PRJNA345071	825	571	1.997992	11.40853432	Fungi	4751	Fungi	Fungi	184	3.45e-50	NR	KAJ1927678.1	78921	g785	i0	55.1	15.4045534150613	198	81	99.8	1	571	2	357	554	KAJ1927678.1 hypothetical protein IWQ60_002734 [Tieghemiomyces parasiticus]	diamond	8796	185	0.994594594594595	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
28386765	28386765	PRJNA345071_P_NODE_9966_length_245_cov_0.906977_g9926_i0	PRJNA345071	9966	245	0.906977	2.22209365	Eukaryota	2759	Fungi	Fungi	116	2.5e-30	NR	PVU87124.1	61424	g9926	i0	70	12.6857142857143	80	24	98	0	244	5	109	188	PVU87124.1 hypothetical protein BB559_006221 [Furculomyces boomerangus]	diamond	3108	117	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
29428531	29428531	PRJNA345071_P_NODE_5649_length_280_cov_1.386473_g5609_i0	PRJNA345071	5649	280	1.386473	3.8821244	Coemansia	4863	Fungi	Fungi	108	6.640000000000001e-27	NR	KAJ2886098.1	417176	g5609	i0	73.4	5.88214285714286	79	20	83.6	1	278	45	113	191	KAJ2886098.1 60S ribosomal protein L6, partial [Coemansia aciculifera]	diamond	1647	108	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia aciculifera
30454148	30454148	PRJNA345071_P_NODE_2133_length_390_cov_0.917981_g2093_i0	PRJNA345071	2133	390	0.917981	3.5801259	Coemansia mojavensis	4864	Fungi	Fungi	48.9	3.88e-4	NR	KAI9471764.1	4864	g2093	i0	46	0.384615384615385	50	26	38.5	1	15	164	75	123	KAI9471764.1 calmodulin 3 [Coemansia mojavensis]	diamond	150	48.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia mojavensis
30485546	30485546	PRJNA345071_P_NODE_4253_length_306_cov_1.330472_g4213_i0	PRJNA345071	4253	306	1.330472	4.07124432	Syncephalis plumigaleata	1851185	Fungi	Fungi	132	6.93e-38	NR	KAI8053047.1	1851185	g4213	i0	66	1.95098039215686	100	33	97.1	1	304	8	1	100	KAI8053047.1 60S ribosomal protein L44 [Syncephalis plumigaleata]	diamond	597	132	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis plumigaleata

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