metadata: contig_metadata: 6 rows where bioproject = "PRJNA1233465" and tax

6 rows where bioproject = "PRJNA1233465" 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
32941010	32941010	PRJNA1233465e_S_NODE_43105_length_274_cov_1.360000_g41795_i0	PRJNA1233465	43105	274	1.36	3.7264	Coemansia	4863	Fungi	Fungi	61.2	1.71e-8	NR	KAJ2847727.1	2650707	g41795	i0	46.4	7.01824817518248	69	33	75.5	1	258	52	728	792	KAJ2847727.1 Signal transduction protein [Coemansia brasiliensis]	diamond	1923	61.6	0.993506493506494	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia brasiliensis
32951006	32951006	PRJNA1233465f_S_NODE_130498_length_213_cov_1.085366_g128218_i0	PRJNA1233465	130498	213	1.085366	2.31182958	Ramicandelaber brevisporus	304332	Fungi	Fungi	42.4	0.0335	NR	KAI8871784.1	304332	g128218	i0	32.8	0.816901408450704	58	38	80.3	1	2	172	142	199	KAI8871784.1 hypothetical protein GQ42DRAFT_161779 [Ramicandelaber brevisporus]	diamond	174	42.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
32984112	32984112	PRJNA1233465d_S_NODE_148163_length_157_cov_2.888889_g147052_i0	PRJNA1233465	148163	157	2.888889	4.53555573	Kickxella alabastrina	61397	Fungi	Fungi	43.5	0.00636	NR	KAJ1887149.1	61397	g147052	i0	40.4	0.898089171974522	47	28	89.8	0	13	153	72	118	KAJ1887149.1 snoRNA-binding rRNA-processing protein utp10, partial [Kickxella alabastrina]	diamond	141	43.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Kickxella	Kickxella alabastrina
33009396	33009396	PRJNA1233465f_S_NODE_176123_length_187_cov_2.927536_g173843_i0	PRJNA1233465	176123	187	2.927536	5.47449232	Coemansia	4863	Fungi	Fungi	61.2	5.34e-9	NR	KAJ2483733.1	2512255	g173843	i0	55.1	2.27807486631016	49	22	78.6	0	159	13	730	778	KAJ2483733.1 Signal transduction protein [Coemansia sp. RSA 2320]	diamond	426	61.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2320
33094754	33094754	PRJNA1233465f_S_NODE_211494_length_174_cov_1.008000_g209214_i0	PRJNA1233465	211494	174	1.008	1.75392	root	1	Root_unresolved	Root_unresolved	66.6	1.52e-12	NR	KAJ2843423.1	147472	g209214	i0	52	5.32758620689655	50	24	86.2	0	14	163	9	58	KAJ2843423.1 hypothetical protein J3B02_005270, partial [Coemansia erecta]	diamond	927	67	0.994029850746269	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia erecta
33120062	33120062	PRJNA1233465b_S_NODE_297943_length_175_cov_2.984127_g296258_i0	PRJNA1233465	297943	175	2.984127	5.22222225	Furculomyces boomerangus	61424	Fungi	Fungi	44.3	7.53e-4	NR	PVU88833.1	61424	g296258	i0	59.5	0.634285714285714	37	13	60	1	174	70	49	85	PVU88833.1 hypothetical protein BB559_005374 [Furculomyces boomerangus]	diamond	111	44.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus

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