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

5 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax_phylum = "Basidiomycota"

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
6214025	6214025	PRJNA506002_S_NODE_38485_length_285_cov_4.924528_g38239_i0	PRJNA506002	38485	285	4.924528	14.0349048	Phenoliferia sp. Uapishka_3	3038894	Fungi	Fungi	59.3	8.72e-8	NR	KAK4705419.1	3038894	g38239	i0	55.1	0.515789473684211	49	21	51.6	1	33	179	121	168	KAK4705419.1 hypothetical protein P7C70_g780, partial [Phenoliferia sp. Uapishka_3]	diamond	147	59.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Kriegeriales	Kriegeriaceae	Phenoliferia	Phenoliferia sp. Uapishka_3
24709851	24709851	PRJNA506002_S_NODE_30660_length_306_cov_1.648069_g30414_i0	PRJNA506002	30660	306	1.648069	5.04309114	Malassezia pachydermatis	77020	Fungi	Fungi	179	4.6099999999999996e-54	NR	XP_017990928.1	77020	g30414	i0	87.9	4.85294117647059	99	12	97.1	0	8	304	172	270	XP_017990928.1 proteasome endopeptidase complex beta subunit [Malassezia pachydermatis]	diamond	1485	179	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis
27819272	27819272	PRJNA506002_S_NODE_26244_length_320_cov_1.157895_g25998_i0	PRJNA506002	26244	320	1.157895	3.705264	Kwoniella	490731	Fungi	Fungi	47.8	0.00157	NR	XP_031862267.1	1734106	g25998	i0	51.2	1.425	43	18	37.5	1	2	121	584	626	XP_031862267.1 uncharacterized protein CI109_105511 [Kwoniella shandongensis]	diamond	456	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella shandongensis
28940496	28940496	PRJNA506002_S_NODE_29808_length_308_cov_3.719149_g29562_i0	PRJNA506002	29808	308	3.719149	11.45497892	Rhodotorula toruloides	5286	Fungi	Fungi	49.7	3.05e-4	NR	KAJ8294897.1	5286	g29562	i0	38.4	0.711038961038961	73	43	71.1	1	226	8	65	135	KAJ8294897.1 Serine/threonine-protein kinase SCH9 [Rhodotorula toruloides]	diamond	219	49.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula toruloides
30661243	30661243	PRJNA506002_S_NODE_45633_length_270_cov_1.172589_g45387_i0	PRJNA506002	45633	270	1.172589	3.1659903	root	1	Root_unresolved	Root_unresolved	51.2	2.59e-5	NR	GJN94735.1	86838	g45387	i0	65.7	3.12222222222222	35	12	38.9	0	2	106	153	187	GJN94735.1 hypothetical protein Rhopal_007826-T1 [Rhodotorula paludigena]	diamond	843	51.6	0.992248062015504	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula paludigena

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