metadata: contig_metadata: 5 rows where bioproject = "PRJDB4470", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJDB4470", 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
1283611	1283611	PRJDB4470_P_NODE_26682_length_453_cov_0.950495_g25544_i0	PRJDB4470	26682	453	0.950495	4.30574235	Entomophthora muscae	34485	Fungi	Fungi	300	1.42e-76	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g25544	i0	87.313	38.4150110375276	268	27	58	7	190	453	2061	1797	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	17402	300	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
15009200	15009200	PRJDB4470_P_NODE_39852_length_345_cov_1.033784_g38700_i0	PRJDB4470	39852	345	1.033784	3.5665548	Conidiobolus	34487	Fungi	Fungi	76.8	1.94e-9	NTclustered	gi\|2127863504\|ref\|NC_058638.1\|	1368622	g38700	i0	77.273	16.7333333333333	132	28	38	1	213	342	19995	20126	Conidiobolus mycophagus culture ATCC:16201 mitochondrion, complete genome	blastn	5773	76.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus mycophagus
16284077	16284077	PRJDB4470_P_NODE_79313_length_200_cov_2.026490_g78158_i0	PRJDB4470	79313	200	2.02649	4.05298	Conidiobolus	34487	Fungi	Fungi	278	2.63e-70	NTclustered	gi\|2127863466\|ref\|NC_058636.1\|	1167813	g78158	i0	92.746	78.37	193	12	97	2	2	194	14534	14344	Conidiobolus chlamydosporus culture ATCC:12242 mitochondrion, complete genome	blastn	15674	278	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus chlamydosporus
22658238	22658238	PRJDB4470_P_NODE_118098_length_163_cov_1.254386_g116943_i0	PRJDB4470	118098	163	1.254386	2.04464918	Ancylistaceae	34486	Fungi	Fungi	115	1.7100000000000003e-21	NTclustered	gi\|2127863542\|ref\|NC_058640.1\|	1167814	g116943	i0	81.633	33.0552147239264	147	20	89	6	1	145	5520	5661	Conidiobolus polytocus culture ATCC:12244 mitochondrion, complete genome	blastn	5388	115	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus polytocus
32213859	32213859	PRJDB4470_P_NODE_101338_length_169_cov_0.866667_g100183_i0	PRJDB4470	101338	169	0.866667	1.46466723	Smittium mucronatum	133383	Fungi	Fungi	89.4	2.05e-20	NR	OLY83758.1	133383	g100183	i0	73.2	9.94082840236686	56	15	99.4	0	1	168	50	105	OLY83758.1 40S ribosomal protein S17-B, partial [Smittium mucronatum]	diamond	1680	89.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum

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