metadata: contig_metadata: 11 rows where bioproject = "PRJNA588137", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA588137", 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
4392252	4392252	PRJNA588137_S_NODE_4644_length_280_cov_2.231884_g4611_i0	PRJNA588137	4644	280	2.231884	6.2492752	Kwoniella dendrophila	4975	Fungi	Fungi	206	1.8699999999999998e-48	NTclustered	gi\|2752982483\|ref\|XM_066217289.1\|	1295534	g4611	i0	82.5	12.0678571428571	240	37	85	5	1	237	315	78	Kwoniella dendrophila CBS 6074 60S ribosomal protein L44 (L201_001500), partial mRNA	blastn	3379	206	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella dendrophila
5668518	5668518	PRJNA588137_S_NODE_8145_length_247_cov_0.885057_g8112_i0	PRJNA588137	8145	247	0.885057	2.18609079	Malassezia restricta	76775	Fungi	Fungi	167	7.64e-37	NTclustered	gi\|1546634206\|ref\|XM_027628763.1\|	76775	g8112	i0	100	0.364372469635628	90	0	36	0	153	242	1	90	Malassezia restricta S-adenosylmethionine-dependent methyltransferase (MRET_2136), partial mRNA	blastn	90	167	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
6942973	6942973	PRJNA588137_S_NODE_9786_length_244_cov_0.900585_g9753_i0	PRJNA588137	9786	244	0.900585	2.1974274	Malassezia restricta	76775	Fungi	Fungi	451	1.86e-122	NTclustered	gi\|1546632222\|ref\|XM_027627771.1\|	76775	g9753	i0	100	1	244	0	100	0	1	244	812	569	Malassezia restricta ubiquitin-activating enzyme E1 C (MRET_1144), partial mRNA	blastn	244	451	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
9493202	9493202	PRJNA588137_S_NODE_6588_length_251_cov_0.865169_g6555_i0	PRJNA588137	6588	251	0.865169	2.17157419	Malassezia restricta	76775	Fungi	Fungi	442	1.1599999999999995e-119	NTclustered	gi\|1546630503\|ref\|XM_027626912.1\|	76775	g6555	i0	98.406	1	251	4	100	0	1	251	731	481	Malassezia restricta metallo-beta-lactamase superfamily protein (MRET_0285), partial mRNA	blastn	251	442	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
20966882	20966882	PRJNA588137_S_NODE_11097_length_241_cov_0.916667_g11064_i0	PRJNA588137	11097	241	0.916667	2.20916747	Malassezia restricta	76775	Fungi	Fungi	444	3.06e-120	NTclustered	gi\|1546637369\|ref\|XM_027630327.1\|	76775	g11064	i0	100	0.995850622406639	240	0	99	0	1	240	363	124	Malassezia restricta DUF775 domain protein (MRET_3700), partial mRNA	blastn	240	444	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
23517161	23517161	PRJNA588137_S_NODE_8399_length_247_cov_0.885057_g8366_i0	PRJNA588137	8399	247	0.885057	2.18609079	Malassezia restricta	76775	Fungi	Fungi	457	4.05e-124	NTclustered	gi\|1546630953\|ref\|XM_027627137.1\|	76775	g8366	i0	100	1.65182186234818	247	0	100	0	1	247	214	460	Malassezia restricta ATP-dependent RNA helicase DDX19/DBP5 (MRET_0510), partial mRNA	blastn	408	457	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27459069	27459069	PRJNA588137_S_NODE_10103_length_243_cov_0.905882_g10070_i0	PRJNA588137	10103	243	0.905882	2.20129326	Hydnomerulius pinastri MD-312	994086	Fungi	Fungi	59.3	7.27e-9	NR	KIJ68101.1	994086	g10070	i0	72.7	3.49382716049383	33	9	40.7	0	99	1	102	134	KIJ68101.1 hypothetical protein HYDPIDRAFT_148404 [Hydnomerulius pinastri MD-312]	diamond	849	59.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales		Leucogyrophana	Leucogyrophana pinastri
28861523	28861523	PRJNA588137_S_NODE_7368_length_249_cov_0.875000_g7335_i0	PRJNA588137	7368	249	0.875	2.17875	Basidiomycota	5204	Fungi	Fungi	146	7.74e-39	NR	SCZ87470.1	289078	g7335	i0	79.3	11.8433734939759	82	17	98.8	0	246	1	270	351	SCZ87470.1 BZ3500_MvSof-1268-A1-R1_Chr2-2g04936 [Microbotryum saponariae]	diamond	2949	147	0.993197278911565	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Microbotryales	Microbotryaceae	Microbotryum	Microbotryum saponariae
29587528	29587528	PRJNA588137_S_NODE_8750_length_246_cov_0.890173_g8717_i0	PRJNA588137	8750	246	0.890173	2.18982558	Ustilaginales	5267	Fungi	Fungi	56.6	5.09e-7	NR	KAJ1029514.1	117174	g8717	i0	49	3.81707317073171	49	25	59.8	0	156	10	210	258	KAJ1029514.1 hypothetical protein NDA13_002761 [Ustilago tritici]	diamond	939	56.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Ustilago	Ustilago tritici
31533647	31533647	PRJNA588137_S_NODE_6976_length_250_cov_0.870056_g6943_i0	PRJNA588137	6976	250	0.870056	2.17514	Crepidotus variabilis	179855	Fungi	Fungi	48.5	6.17e-5	NR	KAF9534419.1	179855	g6943	i0	82.1	0.672	28	4	32.4	1	99	19	1	28	KAF9534419.1 hypothetical protein CPB83DRAFT_902343 [Crepidotus variabilis]	diamond	168	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Crepidotaceae	Crepidotus	Crepidotus variabilis
32053026	32053026	PRJNA588137_S_NODE_7238_length_249_cov_0.875000_g7205_i0	PRJNA588137	7238	249	0.875	2.17875	Agaricales	5338	Fungi	Fungi	95.5	1.15e-20	NR	KAF4571458.1	28995	g7205	i0	53.1	2.97590361445783	81	22	97.6	1	7	249	168	232	KAF4571458.1 hypothetical protein EYR36_008795 [Pleurotus pulmonarius]	diamond	741	95.9	0.995828988529718	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius

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