metadata: contig_metadata: 14 rows where bioproject = "PRJNA733995" and tax

14 rows where bioproject = "PRJNA733995" 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
4545163	4545163	PRJNA733995_P_NODE_8584_length_293_cov_1.195455_g8537_i0	PRJNA733995	8584	293	1.195455	3.50268315	Colacogloea effusa	2792658	Fungi	Fungi	180	1.19e-40	NTclustered	gi\|2577098242\|gb\|OQ930182.1\|	2792658	g8537	i0	80	16.5904436860068	250	44	84	6	3	249	354	108	Colacogloea effusa voucher NS_21_110 from Netherlands RNA polymerase II second largest subunit (RPB2) gene, partial cds	blastn	4861	180	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes		Colacogloeaceae	Colacogloea	Colacogloea effusa
5820264	5820264	PRJNA733995_P_NODE_8365_length_297_cov_1.718750_g8318_i0	PRJNA733995	8365	297	1.71875	5.1046875	Cutaneotrichosporon cutaneum	5554	Fungi	Fungi	213	1.2e-50	NTclustered	gi\|921328105\|dbj\|AB919827.1\|	5554	g8318	i0	80.727	26.2895622895623	275	51	92	2	1	274	2557	2830	Trichosporon cutaneum gene for DNA-directed RNA polymerase ii largest subunit, putative (RPB1), complete sequence, strain: JCM 1462	blastn	7808	213	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Cutaneotrichosporon	Cutaneotrichosporon cutaneum
8849771	8849771	PRJNA733995_P_NODE_6647_length_333_cov_1.103846_g6600_i0	PRJNA733995	6647	333	1.103846	3.67580718	root	1	Root_unresolved	Root_unresolved	63.9	1.45e-5	NTclustered	gi\|1102541568\|ref\|XM_019193438.1\|	1296100	g6600	i0	97.368	21.2582582582583	38	0	11	1	275	312	423	387	Kwoniella bestiolae CBS 10118 uncharacterized protein (I302_107430), partial mRNA	blastn	7079	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella bestiolae
12676337	12676337	PRJNA733995_P_NODE_14070_length_231_cov_2.645570_g14023_i0	PRJNA733995	14070	231	2.64557	6.1112667	Opisthokonta	33154	Fungi	Fungi	427	2.9399999999999998e-115	NTclustered	gi\|915512619\|gb\|KP825402.1\|	76775	g14023	i0	100	99.987012987013	231	0	100	0	1	231	62	292	Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence	blastn	23097	427	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
16019110	16019110	PRJNA733995_P_NODE_10193_length_271_cov_1.989899_g10146_i0	PRJNA733995	10193	271	1.989899	5.39262629	Stereum hirsutum	40492	Fungi	Fungi	130	1.12e-25	NTclustered	gi\|618803920\|ref\|XM_007304678.1\|	721885	g10146	i0	98.63	0.269372693726937	73	1	27	0	17	89	869	797	Stereum hirsutum FP-91666 SS1 Clavaminate synthase-like protein (STEHIDRAFT_131526), partial mRNA	blastn	73	130	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
18568380	18568380	PRJNA733995_P_NODE_12355_length_249_cov_0.875000_g12308_i0	PRJNA733995	12355	249	0.875	2.17875	Heterobasidion irregulare	984962	Fungi	Fungi	52.8	0.023	NTclustered	gi\|1374419597\|gb\|AC277418.1\|	984962	g12308	i0	100	0.112449799196787	28	0	11	0	147	174	743	770	Heterobasidion irregulare strain TC 32-1 clone FGHH17-N19, complete sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Bondarzewiaceae	Heterobasidion	Heterobasidion irregulare
19843521	19843521	PRJNA733995_P_NODE_10636_length_266_cov_1.196891_g10589_i0	PRJNA733995	10636	266	1.196891	3.18373006	Kwoniella bestiolae	324769	Fungi	Fungi	56.5	0.002	NTclustered	gi\|1102530744\|ref\|XM_019188046.1\|	1296100	g10589	i0	97.059	0.12781954887218	34	0	12	1	65	97	2899	2866	Kwoniella bestiolae CBS 10118 uncharacterized protein (I302_102673), partial mRNA	blastn	34	56.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella bestiolae
22394146	22394146	PRJNA733995_P_NODE_12378_length_249_cov_0.875000_g12331_i0	PRJNA733995	12378	249	0.875	2.17875	Malassezia globosa	76773	Fungi	Fungi	455	1.47e-123	NTclustered	gi\|164661824\|ref\|XM_001731983.1\|	425265	g12331	i0	99.598	1	249	1	100	0	1	249	533	285	Malassezia globosa CBS 7966 uncharacterized protein (MGL_1303), partial mRNA	blastn	249	455	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
23669636	23669636	PRJNA733995_P_NODE_11339_length_258_cov_1.167568_g11292_i0	PRJNA733995	11339	258	1.167568	3.01232544	Kockovaella imperatae	4999	Fungi	Fungi	182	2.87e-41	NTclustered	gi\|1227119409\|ref\|XM_022015524.1\|	4999	g11292	i0	79.457	2.97286821705426	258	51	99	2	1	257	1185	929	Kockovaella imperatae putative endopeptidase (BD324DRAFT_622890), mRNA	blastn	767	182	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cuniculitremaceae	Kockovaella	Kockovaella imperatae
26608965	26608965	PRJNA733995_P_NODE_13461_length_243_cov_0.905882_g13414_i0	PRJNA733995	13461	243	0.905882	2.20129326	Russula vinacea	517384	Fungi	Fungi	42	0.0089	NR	KAH9980804.1	517384	g13414	i0	44.4	0.555555555555556	45	25	55.6	0	82	216	15	59	KAH9980804.1 hypothetical protein BJV77DRAFT_1046921 [Russula vinacea]	diamond	135	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula vinacea
26767560	26767560	PRJNA733995_P_NODE_7341_length_317_cov_1.262295_g7294_i0	PRJNA733995	7341	317	1.262295	4.00147515	Auriscalpium vulgare	40419	Fungi	Fungi	44.3	0.0237	NR	KAI0044408.1	40419	g7294	i0	32.6	0.899053627760252	95	60	86.1	2	27	299	297	391	KAI0044408.1 Metallo-dependent hydrolase [Auriscalpium vulgare]	diamond	285	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Auriscalpiaceae	Auriscalpium	Auriscalpium vulgare
26957282	26957282	PRJNA733995_P_NODE_10482_length_268_cov_1.200000_g10435_i0	PRJNA733995	10482	268	1.2	3.216	Rhodotorula sp. CCFEE 5	1853554	Fungi	Fungi	80.1	3.56e-15	NR	TKA58087.1	1965284	g10435	i0	58	0.772388059701492	69	29	77.2	0	209	3	661	729	TKA58087.1 hypothetical protein B0A53_00489 [Rhodotorula sp. CCFEE 5036]	diamond	207	80.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula sp. CCFEE 5036
27494830	27494830	PRJNA733995_P_NODE_2043_length_627_cov_1.832130_g1996_i0	PRJNA733995	2043	627	1.83213	11.4874551	Mixia osmundae IAM 14324	764103	Fungi	Fungi	91.7	1.49e-17	NR	XP_014569727.1	764103	g1996	i0	31.2	1.04306220095694	218	118	93.3	7	27	611	290	498	XP_014569727.1 glycosyltransferase family 47 protein [Mixia osmundae IAM 14324]	diamond	654	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Mixiomycetes	Mixiales	Mixiaceae	Mixia	Mixia osmundae
30905598	30905598	PRJNA733995_P_NODE_3994_length_438_cov_1.476712_g3947_i0	PRJNA733995	3994	438	1.476712	6.46799856	Collybiopsis luxurians FD-317 M1	944289	Fungi	Fungi	50.4	5.83e-4	NR	KIK60310.1	944289	g3947	i0	47.2	0.363013698630137	53	28	36.3	0	160	2	419	471	KIK60310.1 hypothetical protein GYMLUDRAFT_225825 [Collybiopsis luxurians FD-317 M1]	diamond	159	50.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Collybiopsis	Collybiopsis luxurians

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