metadata: contig_metadata: 10 rows where bioproject = "PRJNA599026" and tax

10 rows where bioproject = "PRJNA599026" 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
17149108	17149108	PRJNA599026_S_NODE_19854_length_233_cov_2.771739_g19398_i0	PRJNA599026	19854	233	2.771739	6.45815187	Tieghemiomyces parasiticus	78921	Fungi	Fungi	103	9.3e-24	NR	KAJ1924964.1	78921	g19398	i0	68.6	0.901287553648069	70	22	90.1	0	3	212	627	696	KAJ1924964.1 hypothetical protein IWQ60_004873 [Tieghemiomyces parasiticus]	diamond	210	103	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
29177583	29177583	PRJNA599026_S_NODE_2189_length_643_cov_3.255892_g1798_i0	PRJNA599026	2189	643	3.255892	20.93538556	Eukaryota	2759	Fungi	Fungi	89.7	9.57e-17	NR	KAK9721171.1	34480	g1798	i0	41.9	1.63297045101089	117	60	50.9	2	478	152	434	550	KAK9721171.1 hypothetical protein K7432_003643 [Basidiobolus ranarum]	diamond	1050	90.5	0.991160220994475	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30333121	30333121	PRJNA599026_S_NODE_25152_length_214_cov_1.545455_g24696_i0	PRJNA599026	25152	214	1.545455	3.3072737	Dimargaris verticillata	2761393	Fungi	Fungi	57.8	1.3e-7	NR	KAJ1985120.1	2761393	g24696	i0	63.9	1.51401869158878	36	13	50.5	0	189	82	845	880	KAJ1985120.1 ATP binding [Dimargaris verticillata]	diamond	324	57.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris verticillata
31027903	31027903	PRJNA599026_S_NODE_18435_length_240_cov_1.335079_g17979_i0	PRJNA599026	18435	240	1.335079	3.2041896	Coemansia erecta	147472	Fungi	Fungi	63.9	1.06e-9	NR	KAJ2841552.1	147472	g17979	i0	50.7	8.4625	67	33	83.8	0	206	6	46	112	KAJ2841552.1 glycine decarboxylase subunit P, partial [Coemansia erecta]	diamond	2031	63.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia erecta
31153763	31153763	PRJNA599026_S_NODE_65635_length_162_cov_2.707965_g65179_i0	PRJNA599026	65635	162	2.707965	4.3869033	Coemansia mojavensis	4864	Fungi	Fungi	59.7	1.26e-8	NR	KAI9478945.1	4864	g65179	i0	81.3	0.592592592592593	32	6	59.3	0	62	157	156	187	KAI9478945.1 Oxct1b protein [Coemansia mojavensis]	diamond	96	59.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia mojavensis
31167138	31167138	PRJNA599026_S_NODE_36715_length_187_cov_2.217391_g36259_i0	PRJNA599026	36715	187	2.217391	4.14652117	Eukaryota	2759	Fungi	Fungi	81.3	4.73e-16	NR	KAJ1981700.1	215637	g36259	i0	68.6	22.299465240641705	51	16	81.8	0	7	159	9	59	KAJ1981700.1 Nucleolar GTP-binding protein 1 [Dimargaris cristalligena]	diamond	4170	81.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
31610261	31610261	PRJNA599026_S_NODE_16576_length_250_cov_2.029851_g16120_i0	PRJNA599026	16576	250	2.029851	5.0746275	Coemansia	4863	Fungi	Fungi	51.2	4.13e-5	NR	KAJ2725712.1	2663910	g16120	i0	37.5	4.464	64	39	75.6	1	191	3	981	1044	KAJ2725712.1 valine--tRNA ligase [Coemansia sp. Benny D115]	diamond	1116	51.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. Benny D115
31736569	31736569	PRJNA599026_S_NODE_35817_length_189_cov_1.457143_g35361_i0	PRJNA599026	35817	189	1.457143	2.75400027	Eukaryota	2759	Fungi	Fungi	78.2	3.55e-15	NR	KAI9474714.1	4864	g35361	i0	59.2	28.3650793650794	49	20	77.8	0	189	43	18	66	KAI9474714.1 Inosine/uridine-preferring nucleoside hydrolase domain-containing protein [Coemansia mojavensis]	diamond	5361	78.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia mojavensis
32179813	32179813	PRJNA599026_S_NODE_19058_length_237_cov_1.356383_g18602_i0	PRJNA599026	19058	237	1.356383	3.21462771	Zoopagomycota	1913638	Fungi	Fungi	70.9	4.37e-12	NR	OLY82966.1	133383	g18602	i0	75.6	3.63291139240506	41	10	51.9	0	177	55	214	254	OLY82966.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase [Smittium mucronatum]	diamond	861	70.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
32401304	32401304	PRJNA599026_S_NODE_12819_length_278_cov_1.336245_g12363_i0	PRJNA599026	12819	278	1.336245	3.7147611	Opisthokonta	33154	Fungi	Fungi	106	2.71e-24	NR	KAK9727570.1	34480	g12363	i0	86.8	10.8561151079137	53	7	57.2	0	1	159	753	805	KAK9727570.1 Pre-mRNA-splicing factor ATP-dependent RNA helicase PRP16 [Basidiobolus ranarum]	diamond	3018	106	1	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);;