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

9 rows where analysis = "blastn", bioproject = "PRJNA484127" 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
2999015	2999015	PRJNA484127_P_NODE_11643_length_361_cov_1.593750_g11494_i0	PRJNA484127	11643	361	1.59375	5.7534375	Trametes versicolor	5325	Fungi	Fungi	261	5.22e-65	NTclustered	gi\|636620234\|ref\|XM_008043061.1\|	717944	g11494	i0	80.055	50.2216066481994	366	62	99	9	3	361	561	200	Trametes versicolor FP-101664 SS1 S-adenosyl-L-homocysteine hydrolase (TRAVEDRAFT_151784), mRNA	blastn	18130	263	0.992395437262357	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes versicolor
4275592	4275592	PRJNA484127_P_NODE_27724_length_260_cov_1.219251_g27575_i0	PRJNA484127	27724	260	1.219251	3.1700526	Kalmanozyma brasiliensis	1392244	Fungi	Fungi	267	7.77e-67	NTclustered	gi\|1023180611\|ref\|XM_016435223.1\|	1365824	g27575	i0	86.235	92.4807692307692	247	32	95	2	1	246	907	1152	Kalmanozyma brasiliensis GHG001 Helicase, C-terminal (PSEUBRA_002040), partial mRNA	blastn	24045	267	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Kalmanozyma	Kalmanozyma brasiliensis
10652000	10652000	PRJNA484127_P_NODE_11929_length_358_cov_1.129825_g11780_i0	PRJNA484127	11929	358	1.129825	4.0447735	Pseudozyma flocculosa	84751	Fungi	Fungi	54.7	0.009	NTclustered	gi\|630966689\|ref\|XM_007881562.1\|	1277687	g11780	i0	100	0.0810055865921788	29	0	8	0	56	84	132	104	Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_04038), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
11927134	11927134	PRJNA484127_P_NODE_24190_length_274_cov_1.427861_g24041_i0	PRJNA484127	24190	274	1.427861	3.91233914	Malassezia restricta	76775	Fungi	Fungi	462	9.81e-126	NTclustered	gi\|1546630931\|ref\|XM_027627126.1\|	76775	g24041	i0	97.08	1	274	8	100	0	1	274	1379	1106	Malassezia restricta translation factor GUF1, mitochondrial (MRET_0499), partial mRNA	blastn	274	462	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
11927250	11927250	PRJNA484127_P_NODE_30390_length_252_cov_0.871508_g30241_i0	PRJNA484127	30390	252	0.871508	2.19620016	Apiotrichum brassicae	82513	Fungi	Fungi	89.8	1.74e-13	NTclustered	gi\|921330227\|dbj\|AB920018.1\|	82513	g30241	i0	90.909	0.468253968253968	66	6	26	0	14	79	979	1044	Trichosporon brassicae gene for Ras2, complete sequence, strain: JCM 1599	blastn	118	89.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Apiotrichum	Apiotrichum brassicae
14476912	14476912	PRJNA484127_P_NODE_15452_length_324_cov_3.988048_g15303_i0	PRJNA484127	15452	324	3.988048	12.92127552	Moesziomyces antarcticus	84753	Fungi	Fungi	224	6.089999999999998e-54	NTclustered	gi\|955499118\|ref\|XM_014803449.1\|	84753	g15303	i0	80.986	74.2561728395062	284	52	87	2	6	288	977	1259	Moesziomyces antarcticus succinate dehydrogenase (PAN0_002d1282), partial mRNA	blastn	24059	224	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Moesziomyces	Moesziomyces antarcticus
17025570	17025570	PRJNA484127_P_NODE_1334_length_910_cov_5.776583_g1220_i0	PRJNA484127	1334	910	5.776583	52.5669053	Tilletiopsis washingtonensis	58919	Fungi	Fungi	394	1.3299999999999997e-104	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g1220	i0	80	18.5307692307692	540	102	59	6	141	677	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
18300422	18300422	PRJNA484127_P_NODE_8955_length_399_cov_2.794479_g8806_i0	PRJNA484127	8955	399	2.794479	11.14997121	Pseudomicrostroma glucosiphilum	1684307	Fungi	Fungi	62.1	6.35e-5	NTclustered	gi\|1418631245\|ref\|XM_025492137.1\|	1684307	g8806	i0	89.796	0.932330827067669	49	4	12	1	63	110	1668	1620	Pseudomicrostroma glucosiphilum hypothetical protein (BCV69DRAFT_281849), mRNA	blastn	372	62.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Pseudomicrostroma	Pseudomicrostroma glucosiphilum
24049163	24049163	PRJNA484127_P_NODE_17339_length_311_cov_1.424370_g17190_i0	PRJNA484127	17339	311	1.42437	4.4297907	Fungi	4751	Fungi	Fungi	209	1.63e-49	NTclustered	gi\|1423571536\|ref\|XM_025741846.1\|	58919	g17190	i0	79.599	20.2282958199357	299	55	95	5	1	296	750	455	Tilletiopsis washingtonensis putative RPL23A-60S large subunit ribosomal protein L23.e (FA09DRAFT_328627), mRNA	blastn	6291	209	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);;