metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA591127" 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
27142535	27142535	PRJNA591127_P_NODE_19502_length_197_cov_1.981250_g19333_i0	PRJNA591127	19502	197	1.98125	3.9030625	Neoconidiobolus thromboides FSU 785	1314799	Fungi	Fungi	43.5	0.0106	NR	KAI9298149.1	1314799	g19333	i0	75	0.730964467005076	24	6	36.5	0	74	3	149	172	KAI9298149.1 delta6 fatty acid elongase [Neoconidiobolus thromboides FSU 785]	diamond	144	43.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
27205859	27205859	PRJNA591127_P_NODE_6922_length_280_cov_1.765432_g6754_i0	PRJNA591127	6922	280	1.765432	4.9432096	Smittium mucronatum	133383	Fungi	Fungi	90.9	1.09e-20	NR	OLY82642.1	133383	g6754	i0	48.4	1.99285714285714	93	48	99.6	0	280	2	54	146	OLY82642.1 60S ribosomal protein L12 [Smittium mucronatum]	diamond	558	90.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
27314586	27314586	PRJNA591127_P_NODE_23243_length_179_cov_4.492958_g23074_i0	PRJNA591127	23243	179	4.492958	8.04239482	Eukaryota	2759	Fungi	Fungi	95.1	6.14e-22	NR	OLY79614.1	133383	g23074	i0	79.7	7.91061452513966	59	12	98.9	0	177	1	48	106	OLY79614.1 40S ribosomal protein S0 [Smittium mucronatum]	diamond	1416	95.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
27837625	27837625	PRJNA591127_P_NODE_10724_length_225_cov_1.218085_g10556_i0	PRJNA591127	10724	225	1.218085	2.74069125	Furculomyces boomerangus	61424	Fungi	Fungi	58.9	1.34e-8	NR	PVU86898.1	61424	g10556	i0	38.4	0.973333333333333	73	44	96	1	5	220	4	76	PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus]	diamond	219	58.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
30743187	30743187	PRJNA591127_P_NODE_16954_length_197_cov_2.637500_g16785_i0	PRJNA591127	16954	197	2.6375	5.195875	Smittium megazygosporum	133381	Fungi	Fungi	68.9	1.16e-11	NR	PVV04126.1	133381	g16785	i0	94.1	2.04060913705584	34	2	51.8	0	102	1	204	237	PVV04126.1 hypothetical protein BB560_001381 [Smittium megazygosporum]	diamond	402	68.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum

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