metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA733995" and tax

9 rows where analysis = "blastn", 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

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