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

9 rows where analysis = "blastn", bioproject = "PRJNA448207" 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
2989479	2989479	PRJNA448207_P_NODE_3163_length_667_cov_2.112795_g3009_i0	PRJNA448207	3163	667	2.112795	14.09234265	Epithele typhae	378194	Fungi	Fungi	56.5	0.005	NTclustered	gi\|2234731225\|ref\|XM_048014583.1\|	378194	g3009	i0	100	0.0449775112443778	30	0	4	0	370	399	1529	1500	Epithele typhae uncharacterized protein (BXZ73DRAFT_100474), partial mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Epitheliaceae	Epithele	Epithele typhae
6195319	6195319	PRJNA448207_P_NODE_23105_length_266_cov_1.559585_g22942_i0	PRJNA448207	23105	266	1.559585	4.1484961	Fungi	4751	Fungi	Fungi	270	6.1699999999999986e-68	NTclustered	gi\|630971763\|ref\|XM_007884099.1\|	1277687	g22942	i0	85.714	84.2481203007519	259	33	97	4	1	257	841	1097	Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_06556), partial mRNA	blastn	22410	270	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
6816413	6816413	PRJNA448207_P_NODE_21646_length_276_cov_1.325123_g21483_i0	PRJNA448207	21646	276	1.325123	3.65733948	Malassezia globosa	76773	Fungi	Fungi	390	4.7399999999999996e-104	NTclustered	gi\|164662402\|ref\|XM_001732271.1\|	425265	g21483	i0	91.582	1.07608695652174	297	4	100	1	1	276	1371	1075	Malassezia globosa CBS 7966 uncharacterized protein (MGL_0098), partial mRNA	blastn	297	390	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
10642534	10642534	PRJNA448207_P_NODE_21109_length_280_cov_1.091787_g20946_i0	PRJNA448207	21109	280	1.091787	3.0570036	Tilletiopsis washingtonensis	58919	Fungi	Fungi	54.7	0.007	NTclustered	gi\|1423573848\|ref\|XM_025745160.1\|	58919	g20946	i0	100	0.103571428571429	29	0	10	0	106	134	559	587	Tilletiopsis washingtonensis AAA-domain-containing protein (FA09DRAFT_359765), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
13192575	13192575	PRJNA448207_S_NODE_551_length_535_cov_1.911255_g540_i0	PRJNA448207	551	535	1.911255	10.22521425	Tilletiopsis washingtonensis	58919	Fungi	Fungi	331	6.03e-86	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g540	i0	80.178	24.781308411215	449	83	83	6	89	534	55	500	Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA	blastn	13258	331	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
16394766	16394766	PRJNA448207_P_NODE_15673_length_322_cov_2.473896_g15510_i0	PRJNA448207	15673	322	2.473896	7.96594512	root	1	Root_unresolved	Root_unresolved	595	1.1099999999999995e-165	NTclustered	gi\|2500415392\|gb\|OQ926588.1\|	5358	g15510	i0	100	100	322	0	100	0	1	322	16	337	Lentinus crinitus isolate SP001 small subunit ribosomal RNA gene, partial sequence	blastn	32200	595	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lentinus	Lentinus crinitus
21494042	21494042	PRJNA448207_P_NODE_18077_length_302_cov_1.532751_g17914_i0	PRJNA448207	18077	302	1.532751	4.62890802	Malassezia	55193	Fungi	Fungi	558	1.36e-154	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g17914	i0	100	36	302	0	100	0	1	302	1317	1618	Malassezia restricta mitochondrion, complete genome	blastn	10872	558	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
22115526	22115526	PRJNA448207_S_NODE_1058_length_409_cov_1.898810_g1047_i0	PRJNA448207	1058	409	1.89881	7.7661329	Pseudomicrostroma glucosiphilum	1684307	Fungi	Fungi	62.1	6.53e-5	NTclustered	gi\|1418631245\|ref\|XM_025492137.1\|	1684307	g1047	i0	89.796	0.909535452322738	49	4	12	1	89	136	1668	1620	Pseudomicrostroma glucosiphilum hypothetical protein (BCV69DRAFT_281849), mRNA	blastn	372	62.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Pseudomicrostroma	Pseudomicrostroma glucosiphilum
23390760	23390760	PRJNA448207_P_NODE_1639_length_892_cov_3.467643_g1522_i0	PRJNA448207	1639	892	3.467643	30.93137556	Tilletiopsis washingtonensis	58919	Fungi	Fungi	394	1.2999999999999999e-104	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g1522	i0	80	18.9047085201794	540	102	60	6	89	625	55	591	Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA	blastn	16863	394	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis

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