metadata: contig_metadata: 21 rows where bioproject = "PRJNA401346" and tax

21 rows where bioproject = "PRJNA401346" and tax_phylum = "Ascomycota"

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
5517958	5517958	PRJNA401346_P_NODE_3165_length_290_cov_1.803493_g3144_i0	PRJNA401346	3165	290	1.803493	5.2301297	Fungi	4751	Fungi	Fungi	139	1.1399999999999999e-40	NR	XP_002143100.1	4952	g3144	i0	78	10.0551724137931	82	18	84.8	0	269	24	1	82	XP_002143100.1 40S ribosomal protein eS27 [Yarrowia lipolytica]	diamond	2916	139	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
6792000	6792000	PRJNA401346_P_NODE_5766_length_220_cov_1.075472_g5745_i0	PRJNA401346	5766	220	1.075472	2.3660384	Arxiozyma heterogenica	278026	Fungi	Fungi	148	2.4199999999999997e-31	NTclustered	gi\|2724981776\|ref\|XM_064858557.1\|	278026	g5745	i0	80.628	46.7272727272727	191	37	87	0	29	219	1535	1345	Arxiozyma heterogenica Hsp70 family ATPase SSC1 (PWA37_001944), partial mRNA	blastn	10280	148	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Arxiozyma	Arxiozyma heterogenica
6792092	6792092	PRJNA401346_P_NODE_886_length_493_cov_2.157407_g865_i0	PRJNA401346	886	493	2.157407	10.63601651	Neurospora tetraspora	94610	Fungi	Fungi	348	5.48e-91	NTclustered	gi\|2669806330\|ref\|XM_062825930.1\|	94610	g865	i0	81.422	81.2657200811359	436	72	87	7	1	430	1128	1560	Neurospora tetraspora translation elongation factor EF-1 alpha (B0H65DRAFT_448950), mRNA	blastn	40064	348	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Sordariaceae	Neurospora	Neurospora tetraspora
7459027	7459027	PRJNA401346_P_NODE_6286_length_209_cov_0.864865_g6265_i0	PRJNA401346	6286	209	0.864865	1.80756785	Eukaryota	2759	Fungi	Fungi	78.6	5.72e-15	NR	NP_593482.1	4896	g6265	i0	54.5	8.6555023923445	55	25	78.9	0	198	34	127	181	NP_593482.1 exonuclease II Exo2 [Schizosaccharomyces pombe]	diamond	1809	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe
9342350	9342350	PRJNA401346_P_NODE_2368_length_326_cov_1.464151_g2347_i0	PRJNA401346	2368	326	1.464151	4.77313226	Mycothermus thermophilus	85995	Fungi	Fungi	158	6.31e-34	NTclustered	gi\|2837782370\|ref\|XM_069366206.1\|	85995	g2347	i0	84.848	40.3773006134969	165	15	48	9	49	205	289	451	Mycothermus thermophilus 60S ribosomal protein uL22 (VTJ04DRAFT_7836), partial mRNA	blastn	13163	158	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Chaetomiaceae	Mycothermus	Mycothermus thermophilus
13168039	13168039	PRJNA401346_P_NODE_5611_length_223_cov_1.580247_g5590_i0	PRJNA401346	5611	223	1.580247	3.52395081	Cadophora gregata	51156	Fungi	Fungi	139	1.48e-28	NTclustered	gi\|2553643576\|ref\|XM_058499481.1\|	51156	g5590	i0	82.317	19.4215246636771	164	25	73	4	2	163	634	795	Cadophora gregata cross-pathway control WD-repeat protein cpc2 (CPC2), partial mRNA	blastn	4331	139	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Ploettnerulaceae	Cadophora	Cadophora gregata
15108869	15108869	PRJNA401346_P_NODE_8772_length_201_cov_0.914286_g8751_i0	PRJNA401346	8772	201	0.914286	1.83771486	Dothideomycetes	147541	Fungi	Fungi	110	1.02e-19	NTclustered	gi\|2837753652\|ref\|XM_069374347.1\|	1052096	g8751	i0	78.571	18.9154228855721	168	34	83	2	35	201	407	241	Cladosporium halotolerans Nascent polypeptide-associated complex subunit alpha (egd2), mRNA	blastn	3802	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
17658647	17658647	PRJNA401346_P_NODE_6394_length_209_cov_0.864865_g6373_i0	PRJNA401346	6394	209	0.864865	1.80756785	Pleosporales	92860	Fungi	Fungi	135	7.239999999999998e-35	NR	XP_043165507.1	119953	g6373	i0	98.5	13.1052631578947	66	1	94.7	0	199	2	660	725	XP_043165507.1 uncharacterized protein ALTATR162_LOCUS1970 [Alternaria atra]	diamond	2739	135	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria atra
18265788	18265788	PRJNA401346_P_NODE_1455_length_396_cov_2.400000_g1434_i0	PRJNA401346	1455	396	2.4	9.504	Saitoella complicata	5606	Fungi	Fungi	172	2.79e-38	NTclustered	gi\|1102185804\|ref\|XM_019169189.1\|	698492	g1434	i0	84.358	11.2676767676768	179	24	45	4	183	359	204	28	Saitoella complicata NRRL Y-17804 ribosomal protein S28e (SAICODRAFT_52993), partial mRNA	blastn	4462	172	1	Eukaryota	Opisthokonta	Fungi	Ascomycota				Saitoella	Saitoella complicata
20815803	20815803	PRJNA401346_P_NODE_1337_length_412_cov_1.091168_g1316_i0	PRJNA401346	1337	412	1.091168	4.49561216	Pichia kudriavzevii	4909	Fungi	Fungi	278	5.999999999999999e-70	NTclustered	gi\|1679372880\|ref\|XM_029467756.1\|	4909	g1316	i0	81.481	9.66019417475728	351	53	84	11	11	355	389	45	Pichia kudriavzevii uncharacterized protein (C5L36_0E02020), partial mRNA	blastn	3980	278	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Pichia	Pichia kudriavzevii
22090788	22090788	PRJNA401346_P_NODE_7378_length_206_cov_0.882759_g7357_i0	PRJNA401346	7378	206	0.882759	1.81848354	Wickerhamiella sorbophila	45607	Fungi	Fungi	52.8	0.018	NTclustered	gi\|1383777407\|ref\|XM_024810011.1\|	45607	g7357	i0	100	0.135922330097087	28	0	14	0	175	202	172	145	[Candida] sorbophila Putative transcription initiation factor TFIID subunit (B9G98_03454), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Wickerhamiella	Wickerhamiella sorbophila
22758050	22758050	PRJNA401346_P_NODE_8738_length_201_cov_0.914286_g8717_i0	PRJNA401346	8738	201	0.914286	1.83771486	Aspergillus	5052	Fungi	Fungi	176	9.94e-40	NTclustered	gi\|1800290083\|ref\|XM_032078489.1\|	1506151	g8717	i0	86.335	47.4328358208955	161	22	80	0	18	178	272	432	Aspergillus pseudonomiae 60S ribosomal protein uL5 (BDV37DRAFT_116434), mRNA	blastn	9534	176	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus pseudonomiae
23366226	23366226	PRJNA401346_P_NODE_1139_length_442_cov_0.889764_g1118_i0	PRJNA401346	1139	442	0.889764	3.93275688	Aureobasidium subglaciale	1042127	Fungi	Fungi	289	2.99e-73	NTclustered	gi\|915682163\|ref\|XM_013484862.1\|	1043005	g1118	i0	82.216	75.1742081447964	343	53	77	6	50	388	615	277	Aureobasidium subglaciale EXF-2481 uncharacterized protein (AUEXF2481DRAFT_452160), mRNA	blastn	33227	289	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium subglaciale
25307239	25307239	PRJNA401346_P_NODE_3820_length_269_cov_1.538462_g3799_i0	PRJNA401346	3820	269	1.538462	4.13846278	Candidozyma	3303203	Fungi	Fungi	220	6.38e-53	NTclustered	gi\|1383851160\|ref\|XM_024857686.1\|	418784	g3799	i0	85.116	19.6802973977695	215	32	80	0	33	247	299	85	[Candida] pseudohaemulonii 60S ribosomal protein L44 (C7M61_002308), partial mRNA	blastn	5294	220	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Candidozyma	Candidozyma pseudohaemuli
27281884	27281884	PRJNA401346_P_NODE_6083_length_212_cov_1.271523_g6062_i0	PRJNA401346	6083	212	1.271523	2.69562876	Eukaryota	2759	Fungi	Fungi	95.5	7.1e-23	NR	KAG9542518.1	46634	g6062	i0	68.8	53.6462264150943	64	20	90.6	0	203	12	4	67	KAG9542518.1 ras-related protein-like protein, partial [Aureobasidium melanogenum]	diamond	11373	95.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
27675917	27675917	PRJNA401346_P_NODE_4584_length_249_cov_1.111702_g4563_i0	PRJNA401346	4584	249	1.111702	2.76813798	Lizonia empirigonia	1496277	Fungi	Fungi	158	8.05e-48	NR	KAF1365574.1	1496277	g4563	i0	85.5	1	83	12	100	0	1	249	44	126	KAF1365574.1 Aegerolysin family protein [Lizonia empirigonia]	diamond	249	158	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes		Pseudoperisporiaceae	Lizonia	Lizonia empirigonia
28734377	28734377	PRJNA401346_P_NODE_7587_length_205_cov_0.888889_g7566_i0	PRJNA401346	7587	205	0.888889	1.82222245	Eukaryota	2759	Fungi	Fungi	99.8	6.019999999999999e-23	NR	KAA8571655.1	38448	g7566	i0	76.5	26.8682926829268	68	16	99.5	0	1	204	190	257	KAA8571655.1 hypothetical protein EYC84_001646 [Monilinia fructicola]	diamond	5508	100	0.998	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae	Monilinia	Monilinia fructicola
28780585	28780585	PRJNA401346_P_NODE_2667_length_310_cov_1.285141_g2646_i0	PRJNA401346	2667	310	1.285141	3.9839371	Lizonia empirigonia	1496277	Fungi	Fungi	162	2.73e-49	NR	KAF1365574.1	1496277	g2646	i0	78.1	0.929032258064516	96	21	92.9	0	309	22	40	135	KAF1365574.1 Aegerolysin family protein [Lizonia empirigonia]	diamond	288	162	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes		Pseudoperisporiaceae	Lizonia	Lizonia empirigonia
28906827	28906827	PRJNA401346_P_NODE_8508_length_202_cov_0.907801_g8487_i0	PRJNA401346	8508	202	0.907801	1.83375802	Erysiphe pulchra	225359	Fungi	Fungi	92.4	7.05e-20	NR	POS85527.1	225359	g8487	i0	86.7	0.668316831683168	45	6	66.8	0	201	67	1659	1703	POS85527.1 hypothetical protein EPUL_003889 [Erysiphe pulchra]	diamond	135	92.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Erysiphe	Erysiphe pulchra
29632858	29632858	PRJNA401346_P_NODE_8050_length_203_cov_0.901408_g8029_i0	PRJNA401346	8050	203	0.901408	1.82985824	Erysiphe necator	52586	Fungi	Fungi	124	1.09e-32	NR	KAI6245205.1	52586	g8029	i0	94	0.990147783251232	67	4	99	0	201	1	194	260	KAI6245205.1 Mitochondrial phosphate carrier protein [Erysiphe necator]	diamond	201	124	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Erysiphe	Erysiphe necator
31103083	31103083	PRJNA401346_P_NODE_8275_length_203_cov_0.894366_g8254_i0	PRJNA401346	8275	203	0.894366	1.81556298	Fusarium	5506	Fungi	Fungi	42.4	0.0305	NR	KAF5687264.1	48490	g8254	i0	38.3	1.38916256157635	47	24	62.1	1	62	187	238	284	KAF5687264.1 e3 ubiquitin ligase ARI4 [Fusarium circinatum]	diamond	282	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium circinatum

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