metadata: contig_metadata: 4 rows where bioproject = "PRJNA596870", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA596870", 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
8221667	8221667	PRJNA596870_P_NODE_31027_length_249_cov_2.602273_g30894_i0	PRJNA596870	31027	249	2.602273	6.47965977	Eukaryota	2759	Fungi	Fungi	102	3.08e-26	NR	PVU93367.1	133385	g30894	i0	75	4.80722891566265	64	16	77.1	0	192	1	6	69	PVU93367.1 hypothetical protein BB561_003307 [Smittium simulii]	diamond	1197	103	0.990291262135922	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium simulii
26604758	26604758	PRJNA596870_P_NODE_29201_length_251_cov_0.865169_g29068_i0	PRJNA596870	29201	251	0.865169	2.17157419	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	102	2.4299999999999998e-23	NR	ORY04308.1	1314790	g29068	i0	52.9	2.03187250996016	85	38	99.2	1	251	3	350	434	ORY04308.1 hypothetical protein K493DRAFT_333945 [Basidiobolus meristosporus CBS 931.73]	diamond	510	102	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
27174408	27174408	PRJNA596870_P_NODE_15522_length_333_cov_0.888462_g15389_i0	PRJNA596870	15522	333	0.888462	2.95857846	Piptocephalis cylindrospora	1907219	Fungi	Fungi	92.8	2.4e-20	NR	RKP11742.1	1907219	g15389	i0	41.2	0.918918918918919	102	59	91.9	1	28	333	93	193	RKP11742.1 ClpP/crotonase-like domain-containing protein [Piptocephalis cylindrospora]	diamond	306	92.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis cylindrospora
28027473	28027473	PRJNA596870_P_NODE_33905_length_247_cov_0.885057_g33772_i0	PRJNA596870	33905	247	0.885057	2.18609079	Coemansia sp. RSA 27	2012158	Fungi	Fungi	62.8	6.89e-10	NR	KAJ1845083.1	2849858	g33772	i0	54.2	0.582995951417004	48	19	58.3	1	196	53	124	168	KAJ1845083.1 hypothetical protein LPJ70_002660, partial [Coemansia sp. RSA 2708]	diamond	144	62.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2708

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