metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax

9 rows where analysis = "diamond", 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
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);;