metadata: contig_metadata: 20 rows where bioproject = "PRJNA229468" and tax

20 rows where bioproject = "PRJNA229468" 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
1056629	1056629	PRJNA229468_S_NODE_1081_length_166_cov_1.743590_g1068_i0	PRJNA229468	1081	166	1.74359	2.8943594	root	1	Root_unresolved	Root_unresolved	252	1.28e-62	NTclustered	gi\|1206256888\|emb\|LT841236.1\|	42551	g1068	i0	100	93.8012048192771	136	0	99	0	30	165	4696	4831	Fusarium oxysporum f. sp. dianthi partial 18S rRNA gene for 18S ribosomal RNA, strain Fod008	blastn	15571	252	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
1056631	1056631	PRJNA229468_S_NODE_581_length_212_cov_0.938650_g568_i0	PRJNA229468	581	212	0.93865	1.989938	root	1	Root_unresolved	Root_unresolved	387	4.5e-103	NTclustered	gi\|1389182097\|gb\|CP029160.1\|	4932	g568	i0	99.528	112.867924528302	212	1	100	0	1	212	3881942	3882153	Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence	blastn	23928	387	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
2331836	2331836	PRJNA229468_S_NODE_1222_length_162_cov_1.035398_g1209_i0	PRJNA229468	1222	162	1.035398	1.67734476	Sordariomycetes	147550	Fungi	Fungi	233	4.49e-57	NTclustered	gi\|2798605368\|gb\|PQ285334.1\|	5127	g1209	i0	99.231	80.2469135802469	130	0	80	1	34	162	136	265	Fusarium fujikuroi isolate PB33 large subunit ribosomal RNA gene, partial sequence	blastn	13000	233	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium fujikuroi
2331837	2331837	PRJNA229468_S_NODE_722_length_193_cov_2.777778_g709_i0	PRJNA229468	722	193	2.777778	5.36111154	Eukaryota	2759	Fungi	Fungi	90.1	1.72e-19	NR	KAH6661833.1	394676	g709	i0	62.9	8.48704663212435	62	23	96.4	0	188	3	136	197	KAH6661833.1 putative zinc-binding alcohol dehydrogenase [Halenospora varia]	diamond	1638	90.9	0.991199119911991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Tricladiaceae	Halenospora	Halenospora varia
8020690	8020690	PRJNA229468_S_NODE_527_length_219_cov_1.200000_g514_i0	PRJNA229468	527	219	1.2	2.628	Pneumocystis	4753	Fungi	Fungi	70.1	3.79e-13	NR	CCJ30885.1	42068	g514	i0	80	60.7534246575342	40	8	54.8	0	120	1	31	70	CCJ30885.1 unnamed protein product [Pneumocystis jirovecii]	diamond	13305	70.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis jirovecii
9295357	9295357	PRJNA229468_S_NODE_1108_length_166_cov_0.863248_g1095_i0	PRJNA229468	1108	166	0.863248	1.43299168	Tricharina praecox	43433	Fungi	Fungi	95.3	2.28e-15	NTclustered	gi\|2323975453\|ref\|XM_051485962.1\|	43433	g1095	i0	87.654	1.48192771084337	81	10	49	0	2	82	96	16	Tricharina praecox small GTP-binding protein (BZA05DRAFT_425477), partial mRNA	blastn	246	95.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Pyronemataceae	Tricharina	Tricharina praecox
10571343	10571343	PRJNA229468_S_NODE_849_length_181_cov_1.590909_g836_i0	PRJNA229468	849	181	1.590909	2.87954529	Colletotrichum godetiae	1209918	Fungi	Fungi	63.9	7.1e-6	NTclustered	gi\|2608539393\|ref\|XM_060566575.1\|	1209918	g836	i0	95.122	0.823204419889503	41	1	22	1	20	59	2191	2231	Colletotrichum godetiae uncharacterized protein (BDP55DRAFT_295298), mRNA	blastn	149	63.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum godetiae
11259788	11259788	PRJNA229468_S_NODE_1029_length_168_cov_2.394958_g1016_i0	PRJNA229468	1029	168	2.394958	4.02352944	Fungi	4751	Fungi	Fungi	305	9.81e-79	NTclustered	gi\|307707117\|gb\|HQ174215.1\|	5507	g1016	i0	99.405	100	168	1	100	0	1	168	739	572	Fusarium oxysporum clone P10 18S ribosomal RNA gene, partial sequence	blastn	16800	305	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
13809996	13809996	PRJNA229468_S_NODE_811_length_184_cov_1.622222_g798_i0	PRJNA229468	811	184	1.622222	2.98488848	Sordariomycetes	147550	Fungi	Fungi	340	2.99e-89	NTclustered	gi\|307707117\|gb\|HQ174215.1\|	5507	g798	i0	100	100	184	0	100	0	1	184	1589	1406	Fusarium oxysporum clone P10 18S ribosomal RNA gene, partial sequence	blastn	18400	340	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
13809997	13809997	PRJNA229468_S_NODE_871_length_179_cov_2.423077_g858_i0	PRJNA229468	871	179	2.423077	4.33730783	Hypocreales	5125	Fungi	Fungi	272	1.07e-68	NTclustered	gi\|1473254020\|gb\|MH866964.1\|	5128	g858	i0	99.338	84.3575418994413	151	0	84	1	30	179	635	785	Fusarium sambucinum culture CBS:187.34 strain CBS 187.34 large subunit ribosomal RNA gene, partial sequence	blastn	15100	272	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium sambucinum
21458302	21458302	PRJNA229468_S_NODE_417_length_243_cov_3.056701_g404_i0	PRJNA229468	417	243	3.056701	7.42778343	Fusarium	5506	Fungi	Fungi	399	6.789999999999999e-107	NTclustered	gi\|2798605368\|gb\|PQ285334.1\|	5127	g404	i0	96.311	100.411522633745	244	8	100	1	1	243	197	440	Fusarium fujikuroi isolate PB33 large subunit ribosomal RNA gene, partial sequence	blastn	24400	399	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium fujikuroi
23319337	23319337	PRJNA229468_S_NODE_639_length_203_cov_1.824675_g626_i0	PRJNA229468	639	203	1.824675	3.70409025	Ogataea haglerorum	1937702	Fungi	Fungi	86.1	1.74e-12	NTclustered	gi\|2085299524\|ref\|XM_043196467.1\|	1937702	g626	i0	86.076	0.389162561576355	79	11	39	0	95	173	204	126	Ogataea haglerorum uncharacterized protein (KL911_001501), partial mRNA	blastn	79	86.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Ogataea	Ogataea haglerorum
24008527	24008527	PRJNA229468_S_NODE_759_length_189_cov_1.457143_g746_i0	PRJNA229468	759	189	1.457143	2.75400027	Eukaryota	2759	Fungi	Fungi	110	4.07e-28	NR	KAI9781418.1	315204	g746	i0	80.6	12.7936507936508	62	12	98.4	0	188	3	143	204	KAI9781418.1 MAG: 60S ribosomal protein L11 [Geoglossum umbratile]	diamond	2418	111	0.990990990990991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Geoglossomycetes	Geoglossales	Geoglossaceae	Geoglossum	Geoglossum umbratile
24593514	24593514	PRJNA229468_S_NODE_600_length_209_cov_1.593750_g587_i0	PRJNA229468	600	209	1.59375	3.3309375	Henningerozyma blattae	1071379	Fungi	Fungi	185	1.7299999999999994e-42	NTclustered	gi\|444319335\|ref\|XM_004180277.1\|	1071380	g587	i0	83.173	34.4688995215311	208	29	98	6	1	205	247	43	Henningerozyma blattae CBS 6284 40S ribosomal protein uS11 (TBLA0D03060), partial mRNA	blastn	7204	185	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Henningerozyma	Henningerozyma blattae
25282658	25282658	PRJNA229468_S_NODE_820_length_184_cov_0.911111_g807_i0	PRJNA229468	820	184	0.911111	1.67644424	Eukaryota	2759	Fungi	Fungi	324	3.01e-84	NTclustered	gi\|2264686569\|gb\|ON935460.1\|	5127	g807	i0	98.37	100	184	3	100	0	1	184	214	31	Fusarium fujikuroi isolate X2dd small subunit ribosomal RNA gene, partial sequence	blastn	18400	324	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium fujikuroi
27516350	27516350	PRJNA229468_S_NODE_283_length_295_cov_2.174797_g270_i0	PRJNA229468	283	295	2.174797	6.41565115	Parachaetomium inaequale	2588326	Fungi	Fungi	89.4	5.32e-20	NR	KAK4040879.1	2588326	g270	i0	46.9	1.95254237288136	96	46	97.6	1	6	293	72	162	KAK4040879.1 Mss4-like protein [Parachaetomium inaequale]	diamond	576	89.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Chaetomiaceae	Parachaetomium	Parachaetomium inaequale
27611200	27611200	PRJNA229468_S_NODE_1224_length_162_cov_0.902655_g1211_i0	PRJNA229468	1224	162	0.902655	1.4623011	Saccharomycopsis crataegensis	43959	Fungi	Fungi	49.7	4.54e-5	NR	XP_064855757.1	43959	g1211	i0	72.7	0.611111111111111	33	9	61.1	0	162	64	194	226	XP_064855757.1 glutamate--cysteine ligase [Saccharomycopsis crataegensis]	diamond	99	49.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Saccharomycopsidaceae	Saccharomycopsis	Saccharomycopsis crataegensis
28274006	28274006	PRJNA229468_S_NODE_1146_length_164_cov_1.330435_g1133_i0	PRJNA229468	1146	164	1.330435	2.1819134	Aspergillus terreus NIH2624	341663	Fungi	Fungi	67	3.09e-11	NR	XP_001216521.1	341663	g1133	i0	64.2	2.92682926829268	53	19	97	0	5	163	289	341	XP_001216521.1 uncharacterized protein ATEG_07900 [Aspergillus terreus NIH2624]	diamond	480	67	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus terreus
31654045	31654045	PRJNA229468_S_NODE_537_length_216_cov_1.221557_g524_i0	PRJNA229468	537	216	1.221557	2.63856312	Pneumocystis oryctolagi	42067	Fungi	Fungi	80.1	4.7e-16	NR	KAG4306012.1	42067	g524	i0	59	2.54166666666667	61	25	84.7	0	26	208	126	186	KAG4306012.1 hypothetical protein PORY_000922 [Pneumocystis oryctolagi]	diamond	549	80.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis oryctolagi
32526588	32526588	PRJNA229468_S_NODE_699_length_196_cov_1.687075_g686_i0	PRJNA229468	699	196	1.687075	3.306667	Ascomycota	4890	Fungi	Fungi	50.8	1.03e-5	NR	KAK0384808.1	5046	g686	i0	38.5	5.60204081632653	65	39	99.5	1	196	2	12	75	KAK0384808.1 hypothetical protein NLU13_7286 [Sarocladium strictum]	diamond	1098	50.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum

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