metadata: contig_metadata: 14 rows where bioproject = "PRJNA753112" and tax

14 rows where bioproject = "PRJNA753112" 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
10933215	10933215	PRJNA753112_P_NODE_5569_length_578_cov_4.958416_g5230_i0	PRJNA753112	5569	578	4.958416	28.65964448	uncultured Ascomycota	175243	Fungi	Fungi	856	0	NTclustered	gi\|313483124\|gb\|HQ433129.1\|	175243	g5230	i0	95.064	100.384083044983	547	21	94	6	36	578	836	292	Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	58022	856	1	Eukaryota	Opisthokonta	Fungi	Ascomycota					uncultured Ascomycota
16031641	16031641	PRJNA753112_P_NODE_25713_length_269_cov_1.387755_g25371_i0	PRJNA753112	25713	269	1.387755	3.73306095	Daldinia decipiens	326647	Fungi	Fungi	54.7	0.007	NTclustered	gi\|2272156782\|ref\|XM_049239457.1\|	326647	g25371	i0	100	0.315985130111524	29	0	11	0	121	149	331	359	Daldinia decipiens Aldo/keto reductase (F4813DRAFT_193046), mRNA	blastn	85	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Daldinia	Daldinia decipiens
17779355	17779355	PRJNA753112_P_NODE_24774_length_274_cov_1.189055_g24432_i0	PRJNA753112	24774	274	1.189055	3.2580107	Ascomycota	4890	Fungi	Fungi	496	9.67e-136	NTclustered	gi\|1758161116\|gb\|MN543960.1\|	5081	g24432	i0	99.27	99.4124087591241	274	2	100	0	1	274	529	802	Penicillium sp. isolate CLE107 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	27239	501	0.99001996007984	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium sp.
19053367	19053367	PRJNA753112_P_NODE_27355_length_260_cov_1.454545_g27013_i0	PRJNA753112	27355	260	1.454545	3.781817	Cladosporium	5498	Fungi	Fungi	481	2.55e-131	NTclustered	gi\|283827952\|gb\|EU019262.2\|	29917	g27013	i0	100	80.5115384615385	260	0	100	0	1	260	3275	3016	Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence	blastn	20933	481	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
20328177	20328177	PRJNA753112_P_NODE_32756_length_244_cov_0.912281_g32414_i0	PRJNA753112	32756	244	0.912281	2.22596564	Dothideomycetes	147541	Fungi	Fungi	451	1.86e-122	NTclustered	gi\|910265363\|gb\|KT309625.1\|	5454	g32414	i0	100	100	244	0	100	0	1	244	267	24	Didymella rabiei culture-collection ICMP:10299 28S ribosomal RNA gene, partial sequence	blastn	24400	451	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Ascochyta	Ascochyta rabiei
27347411	27347411	PRJNA753112_P_NODE_19043_length_311_cov_2.441176_g18701_i0	PRJNA753112	19043	311	2.441176	7.59205736	Eukaryota	2759	Fungi	Fungi	96.7	9.8e-21	NR	CAI7483938.1	4932	g18701	i0	48.9	23.6430868167203	94	47	90.7	1	23	304	562	654	CAI7483938.1 BAD_collapsed_G0055650.mRNA.1.CDS.1 [Saccharomyces cerevisiae]	diamond	7353	97.4	0.992813141683778	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
27463822	27463822	PRJNA753112_P_NODE_27623_length_258_cov_3.508108_g27281_i0	PRJNA753112	27623	258	3.508108	9.05091864	Zymoseptoria tritici IPO323	336722	Fungi	Fungi	42.7	0.041	NR	XP_003857253.1	336722	g27281	i0	39.4	0.767441860465116	66	39	75.6	1	257	63	8	73	XP_003857253.1 uncharacterized protein MYCGRDRAFT_89604 [Zymoseptoria tritici IPO323]	diamond	198	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Zymoseptoria	Zymoseptoria tritici
27558217	27558217	PRJNA753112_P_NODE_34444_length_233_cov_2.012500_g34102_i0	PRJNA753112	34444	233	2.0125	4.689125	Tortispora caseinolytica NRRL Y-17796	767744	Fungi	Fungi	92	5.790000000000001e-21	NR	ODV88784.1	767744	g34102	i0	63.2	2.92274678111588	76	28	97.9	0	3	230	41	116	ODV88784.1 hypothetical protein CANCADRAFT_128660 [Tortispora caseinolytica NRRL Y-17796]	diamond	681	92	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Trigonopsidomycetes	Trigonopsidales	Trigonopsidaceae	Tortispora	Tortispora caseinolytica
28063523	28063523	PRJNA753112_P_NODE_10965_length_410_cov_1.635015_g10623_i0	PRJNA753112	10965	410	1.635015	6.7035615	Cladosporium halotolerans	1052096	Fungi	Fungi	140	3.42e-39	NR	XP_069228100.1	1052096	g10623	i0	53	0.965853658536585	132	62	96.6	0	10	405	66	197	XP_069228100.1 60S ribosomal protein uL13 [Cladosporium halotolerans]	diamond	396	140	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29042559	29042559	PRJNA753112_P_NODE_16728_length_332_cov_1.444015_g16386_i0	PRJNA753112	16728	332	1.444015	4.7941298	Cladobotryum mycophilum	491253	Fungi	Fungi	43.9	0.0421	NR	KAK5987266.1	491253	g16386	i0	41.5	0.478915662650602	53	31	47.9	0	261	103	1476	1528	KAK5987266.1 Chromatin remodeling factor mit1 [Cladobotryum mycophilum]	diamond	159	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Cladobotryum	Cladobotryum mycophilum
30094174	30094174	PRJNA753112_P_NODE_10072_length_428_cov_1.273239_g9730_i0	PRJNA753112	10072	428	1.273239	5.44946292	Trichomeriaceae	1233474	Fungi	Fungi	53.1	1.41e-5	NR	XP_064730136.1	1635080	g9730	i0	34.4	4.14953271028037	61	40	42.8	0	428	246	7	67	XP_064730136.1 uncharacterized protein PMZ80_005999 [Knufia obscura]	diamond	1776	53.5	0.992523364485981	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
31674477	31674477	PRJNA753112_P_NODE_30717_length_248_cov_1.737143_g30375_i0	PRJNA753112	30717	248	1.737143	4.30811464	Fungi	4751	Fungi	Fungi	111	6.89e-27	NR	XP_024663182.1	45607	g30375	i0	68.9	4.68145161290323	74	23	89.5	0	223	2	13	86	XP_024663182.1 ATP-dependent RNA helicase eIF4A [Wickerhamiella sorbophila]	diamond	1161	112	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Wickerhamiella	Wickerhamiella sorbophila
32487528	32487528	PRJNA753112_P_NODE_32759_length_244_cov_0.912281_g32417_i0	PRJNA753112	32759	244	0.912281	2.22596564	Trichomonascus ciferrii	44093	Fungi	Fungi	53.5	6.16e-6	NR	KAA8911182.1	44093	g32417	i0	41.3	1.77049180327869	75	33	78.7	2	53	244	1207	1281	KAA8911182.1 hypothetical protein TRICI_003904 [Trichomonascus ciferrii]	diamond	432	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Trichomonascus	Trichomonascus ciferrii
32613668	32613668	PRJNA753112_P_NODE_20740_length_298_cov_1.804444_g20398_i0	PRJNA753112	20740	298	1.804444	5.37724312	Lipomyces arxii	56418	Fungi	Fungi	70.5	7.76e-13	NR	XP_066769882.1	56418	g20398	i0	40.7	1.76174496644295	86	51	86.6	0	289	32	61	146	XP_066769882.1 ribosomal protein S27a-domain-containing protein [Lipomyces arxii]	diamond	525	70.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces arxii

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