metadata: contig_metadata: 10 rows where bioproject = "PRJNA854078", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA854078", tax_kingdom = "Fungi" 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
2117131	2117131	PRJNA854078_P_NODE_6662_length_365_cov_11.051370_g6450_i0	PRJNA854078	6662	365	11.05137	40.3375005	Violaceomyces palustris	1673888	Fungi	Fungi	147	3.38e-43	NR	PWN48859.1	1673888	g6450	i0	73.7	2.35068493150685	95	24	77.3	1	360	79	14	108	PWN48859.1 FK506 binding protein [Violaceomyces palustris]	diamond	858	147	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Violaceomycetales	Violaceomycetaceae	Violaceomyces	Violaceomyces palustris
3392371	3392371	PRJNA854078_P_NODE_16423_length_242_cov_0.911243_g16211_i0	PRJNA854078	16423	242	0.911243	2.20520806	Malassezia restricta	76775	Fungi	Fungi	425	1.11e-114	NTclustered	gi\|1546630805\|ref\|XM_027627063.1\|	76775	g16211	i0	98.347	1	242	4	100	0	1	242	252	493	Malassezia restricta prohibitin 2 (MRET_0436), partial mRNA	blastn	242	425	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
4670168	4670168	PRJNA854078_P_NODE_3564_length_504_cov_1.605568_g3352_i0	PRJNA854078	3564	504	1.605568	8.09206272	Kwoniella shivajii	564305	Fungi	Fungi	60.2	2.94e-4	NTclustered	gi\|2670910157\|ref\|XM_062933529.1\|	564305	g3352	i0	100	0.0634920634920635	32	0	6	0	182	213	823	854	Kwoniella shivajii uncharacterized protein (IL334_001776), partial mRNA	blastn	32	60.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella shivajii
8494545	8494545	PRJNA854078_P_NODE_1227_length_861_cov_3.470812_g1052_i0	PRJNA854078	1227	861	3.470812	29.88369132	Suillus clintonianus	1904413	Fungi	Fungi	60.2	5.18e-4	NTclustered	gi\|2033522291\|ref\|XM_041355278.1\|	1904413	g1052	i0	100	0.0371660859465738	32	0	4	0	631	662	479	510	Suillus clintonianus Haloacid dehalogenase-like hydrolase-domain-containing protein (DEU56DRAFT_857252), mRNA	blastn	32	60.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus clintonianus
16144450	16144450	PRJNA854078_P_NODE_17253_length_202_cov_5.069767_g17041_i0	PRJNA854078	17253	202	5.069767	10.24092934	Microbotryum lychnidis-dioicae p1A1 Lamole	683840	Fungi	Fungi	76.6	1.2e-16	NR	KDE08017.1	683840	g17041	i0	71.7	2.85148514851485	60	16	89.1	1	7	186	1	59	KDE08017.1 40S ribosomal protein S30 [Microbotryum lychnidis-dioicae p1A1 Lamole]	diamond	576	76.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Microbotryales	Microbotryaceae	Microbotryum	Microbotryum lychnidis-dioicae
27189532	27189532	PRJNA854078_P_NODE_16822_length_237_cov_2.945122_g16610_i0	PRJNA854078	16822	237	2.945122	6.97993914	root	1	Root_unresolved	Root_unresolved	44.3	0.00965	NR	XP_052943187.1	4972	g16610	i0	30.7	2.41772151898734	75	49	94.9	1	7	231	163	234	XP_052943187.1 WD40-repeat-containing domain protein [Dioszegia hungarica]	diamond	573	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
27631983	27631983	PRJNA854078_P_NODE_16664_length_241_cov_0.916667_g16452_i0	PRJNA854078	16664	241	0.916667	2.20916747	Fungi	4751	Fungi	Fungi	70.5	4.98e-13	NR	RSH90135.1	1890683	g16452	i0	50	8.01659751037344	76	35	94.6	2	240	13	81	153	RSH90135.1 Eukaryotic translation initiation factor 5A [Saitozyma podzolica]	diamond	1932	70.9	0.994358251057828	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Trimorphomycetaceae	Saitozyma	Saitozyma podzolica
30054876	30054876	PRJNA854078_P_NODE_15531_length_245_cov_0.895349_g15319_i0	PRJNA854078	15531	245	0.895349	2.19360505	Ceratobasidium sp. AG-Ba	170446	Fungi	Fungi	43.9	0.015	NR	QRV83963.1	170446	g15319	i0	57.1	2.58367346938775	42	18	51.4	0	137	12	4	45	QRV83963.1 acyl-CoA dehydrogenase [Ceratobasidium sp. AG-Ba]	diamond	633	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-Ba
30212892	30212892	PRJNA854078_P_NODE_3032_length_545_cov_2.451271_g2820_i0	PRJNA854078	3032	545	2.451271	13.35942695	Mycena alexandri	1745969	Fungi	Fungi	77.4	3.25e-13	NR	KAJ7034170.1	1745969	g2820	i0	40.3	2.64220183486239	124	66	66.6	5	527	165	18	136	KAJ7034170.1 P-loop containing nucleoside triphosphate hydrolase protein [Mycena alexandri]	diamond	1440	77.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena alexandri
31793202	31793202	PRJNA854078_P_NODE_7697_length_339_cov_1.157895_g7485_i0	PRJNA854078	7697	339	1.157895	3.92526405	Tulasnella sp. 332	2600222	Fungi	Fungi	97.8	5.77e-21	NR	KAG8888563.1	2600222	g7485	i0	46.8	3.58407079646018	109	54	96.5	1	1	327	560	664	KAG8888563.1 Phospholipase C [Tulasnella sp. 332]	diamond	1215	97.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 332

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