metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA861969" 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
8499269	8499269	PRJNA861969_P_NODE_27107_length_266_cov_1.212435_g26876_i0	PRJNA861969	27107	266	1.212435	3.2250771	Opisthokonta	33154	Fungi	Fungi	97.1	4.03e-21	NR	KAJ8517180.1	34470	g26876	i0	63.1	22.5789473684211	65	24	73.3	0	196	2	674	738	KAJ8517180.1 hypothetical protein ONZ45_g5596 [Pleurotus djamor]	diamond	6006	97.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus djamor
27339734	27339734	PRJNA861969_P_NODE_42143_length_240_cov_2.077844_g41912_i0	PRJNA861969	42143	240	2.077844	4.9868256	Rhodotorula diobovata	5288	Fungi	Fungi	54.7	2.13e-6	NR	TNY21277.1	5288	g41912	i0	100	0.4625	37	0	46.3	0	128	238	1	37	TNY21277.1 major facilitator superfamily domain-containing protein [Rhodotorula diobovata]	diamond	111	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula diobovata
27529042	27529042	PRJNA861969_P_NODE_30243_length_252_cov_1.536313_g30012_i0	PRJNA861969	30243	252	1.536313	3.87150876	Cyphobasidiales sp. Tagirdzhanova-	2801448	Fungi	Fungi	75.5	9.46e-14	NR	CAD6573442.1	2778381	g30012	i0	50.6	0.964285714285714	81	31	95.2	2	2	241	240	312	CAD6573442.1 MAG: Protein cbp3, mitochondrial [Cyphobasidiales sp. Tagirdzhanova-0007]	diamond	243	75.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cyphobasidiales			Cyphobasidiales sp. Tagirdzhanova-0007
27813472	27813472	PRJNA861969_P_NODE_25104_length_275_cov_1.396040_g24873_i0	PRJNA861969	25104	275	1.39604	3.83911	Trichosporon asahii var. asahii CBS 2479	1186058	Fungi	Fungi	46.6	0.00242	NR	XP_014183348.1	1186058	g24873	i0	60.3	0.632727272727273	58	19	58.9	3	3	164	653	710	XP_014183348.1 hypothetical protein A1Q1_06269 [Trichosporon asahii var. asahii CBS 2479]	diamond	174	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Trichosporon	Trichosporon asahii
28042430	28042430	PRJNA861969_P_NODE_30825_length_251_cov_0.865169_g30594_i0	PRJNA861969	30825	251	0.865169	2.17157419	Fungi	4751	Fungi	Fungi	44.7	0.00852	NR	KIR52642.1	1296112	g30594	i0	35.9	2.18725099601594	64	39	74.1	1	188	3	294	357	KIR52642.1 cytochrome P450 [Cryptococcus gattii Ru294]	diamond	549	45.1	0.991130820399113	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus gattii
28191859	28191859	PRJNA861969_P_NODE_26766_length_267_cov_1.587629_g26535_i0	PRJNA861969	26766	267	1.587629	4.23896943	Leucosporidium creatinivorum	106004	Fungi	Fungi	134	1.26e-35	NR	ORY60411.1	106004	g26535	i0	88.8	0.898876404494382	80	9	89.9	0	241	2	176	255	ORY60411.1 coiled-coil domain-containing protein 55-domain containing protein [Leucosporidium creatinivorum]	diamond	240	134	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Leucosporidiales	Leucosporidiaceae	Leucosporidium	Leucosporidium creatinivorum
28642447	28642447	PRJNA861969_P_NODE_28627_length_259_cov_1.655914_g28396_i0	PRJNA861969	28627	259	1.655914	4.28881726	Basidiomycota	5204	Fungi	Fungi	154	2.849999999999999e-43	NR	XP_013246251.1	1037660	g28396	i0	83.5	17.9189189189189	85	14	98.5	0	4	258	214	298	XP_013246251.1 kinase-like protein [Tilletiaria anomala UBC 951]	diamond	4641	155	0.993548387096774	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Georgefischeriales	Tilletiariaceae	Tilletiaria	Tilletiaria anomala
28981687	28981687	PRJNA861969_P_NODE_36028_length_246_cov_0.890173_g35797_i0	PRJNA861969	36028	246	0.890173	2.18982558	Vanrija pseudolonga	143232	Fungi	Fungi	64.7	6.63e-10	NR	XP_062625019.1	143232	g35797	i0	45.5	0.804878048780488	66	19	80.5	1	202	5	146	194	XP_062625019.1 Endo-1,4-beta-xylanase A [Vanrija pseudolonga]	diamond	198	64.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
32710268	32710268	PRJNA861969_P_NODE_38280_length_244_cov_0.900585_g38049_i0	PRJNA861969	38280	244	0.900585	2.1974274	Naganishia friedmannii	89922	Fungi	Fungi	79.7	1.21e-15	NR	KAJ9096435.1	89922	g38049	i0	87.2	0.479508196721311	39	5	48	0	118	2	101	139	KAJ9096435.1 hypothetical protein QFC21_005257 [Naganishia friedmannii]	diamond	117	79.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia friedmannii
32742004	32742004	PRJNA861969_P_NODE_38940_length_243_cov_1.752941_g38709_i0	PRJNA861969	38940	243	1.752941	4.25964663	Malassezia arunalokei	1514897	Fungi	Fungi	59.3	5.33e-8	NR	WFD17365.1	1514897	g38709	i0	90.3	0.382716049382716	31	3	38.3	0	95	3	285	315	WFD17365.1 UTP--glucose-1-phosphate uridylyltransferase [Malassezia arunalokei]	diamond	93	59.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei

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