metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
10176048	10176048	PRJNA904835_P_NODE_51788_length_250_cov_0.870056_g51532_i0	PRJNA904835	51788	250	0.870056	2.17514	Fusarium	5506	Fungi	Fungi	82	3.69e-16	NR	KAH7225561.1	5507	g51532	i0	56.3	3.072	64	28	76.8	0	1	192	299	362	KAH7225561.1 hypothetical protein BKA60DRAFT_630889 [Fusarium oxysporum]	diamond	768	82.4	0.995145631067961	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
26746564	26746564	PRJNA904835_P_NODE_53981_length_247_cov_0.885057_g53725_i0	PRJNA904835	53981	247	0.885057	2.18609079	Mycosphaerellales	2726947	Fungi	Fungi	117	6.77e-30	NR	CAK4028062.1	111012	g53725	i0	69.1	3.91093117408907	81	25	98.4	0	245	3	83	163	CAK4028062.1 Dolichyl-diphosphooligosaccharide--glycosyltransferase subunit 2 [Lecanosticta acicola]	diamond	966	118	0.991525423728814	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Lecanosticta	Lecanosticta acicola
30340784	30340784	PRJNA904835_P_NODE_52472_length_249_cov_0.875000_g52216_i0	PRJNA904835	52472	249	0.875	2.17875	Trematosphaeria pertusa	390896	Fungi	Fungi	122	1.0500000000000001e-30	NR	XP_033683011.1	390896	g52216	i0	72.7	1.83132530120482	77	21	92.8	0	18	248	355	431	XP_033683011.1 uncharacterized protein BU26DRAFT_519791 [Trematosphaeria pertusa]	diamond	456	122	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Trematosphaeriaceae	Trematosphaeria	Trematosphaeria pertusa
30403875	30403875	PRJNA904835_P_NODE_45673_length_273_cov_1.155000_g45417_i0	PRJNA904835	45673	273	1.155	3.15315	Exserohilum turcica Et28A	671987	Fungi	Fungi	43.1	0.039	NR	XP_008020587.1	671987	g45417	i0	34.3	0.736263736263736	67	43	73.6	1	56	256	386	451	XP_008020587.1 uncharacterized protein SETTUDRAFT_177909 [Exserohilum turcica Et28A]	diamond	201	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Exserohilum	Exserohilum turcicum
30726912	30726912	PRJNA904835_P_NODE_36134_length_320_cov_1.404858_g35878_i0	PRJNA904835	36134	320	1.404858	4.4955456	root	1	Root_unresolved	Root_unresolved	55.1	4.28e-6	NR	XP_066827723.1	1775926	g35878	i0	38.7	3.459375	62	38	58.1	0	15	200	59	120	XP_066827723.1 uncharacterized protein LODBEIA_P07850 [Lodderomyces beijingensis]	diamond	1107	55.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Lodderomyces	Lodderomyces beijingensis
30821737	30821737	PRJNA904835_P_NODE_22814_length_419_cov_1.326590_g22559_i0	PRJNA904835	22814	419	1.32659	5.5584121	root	1	Root_unresolved	Root_unresolved	54.7	1.68e-5	NR	CAG9990404.1	160290	g22559	i0	32.1	1.42482100238663	106	72	75.9	0	319	2	427	532	CAG9990404.1 unnamed protein product [Clonostachys byssicola]	diamond	597	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Clonostachys	Clonostachys byssicola
31232288	31232288	PRJNA904835_P_NODE_52635_length_249_cov_0.875000_g52379_i0	PRJNA904835	52635	249	0.875	2.17875	Ascomycota	4890	Fungi	Fungi	42.7	0.0389	NR	KEY72267.1	1280523	g52379	i0	34.9	2.20481927710843	63	35	68.7	1	236	66	294	356	KEY72267.1 hypothetical protein S7711_00266 [Stachybotrys chartarum IBT 7711]	diamond	549	43.1	0.990719257540603	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Stachybotryaceae	Stachybotrys	Stachybotrys chartarum
31699433	31699433	PRJNA904835_P_NODE_52597_length_249_cov_0.875000_g52341_i0	PRJNA904835	52597	249	0.875	2.17875	Fusarium oxysporum f. sp. cubense race 1	1229664	Fungi	Fungi	178	8.1e-50	NR	ENH71498.1	1229664	g52341	i0	100	1	83	0	100	0	1	249	240	322	ENH71498.1 Ankyrin-1 [Fusarium oxysporum f. sp. cubense race 1]	diamond	249	178	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
32174159	32174159	PRJNA904835_P_NODE_45458_length_274_cov_1.149254_g45202_i0	PRJNA904835	45458	274	1.149254	3.14895596	Remersonia thermophila	72144	Fungi	Fungi	57.4	3.93e-7	NR	XP_070865895.1	72144	g45202	i0	36.1	2.75912408759124	83	49	86.5	1	255	19	922	1004	XP_070865895.1 hypothetical protein VTJ83DRAFT_4445 [Remersonia thermophila]	diamond	756	57.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales		Remersonia	Remersonia thermophila
32395534	32395534	PRJNA904835_P_NODE_8139_length_757_cov_1.818713_g7917_i0	PRJNA904835	8139	757	1.818713	13.76765741	Fusarium odoratissimum	2502994	Fungi	Fungi	147	3.25e-41	NR	EMT62165.1	2502994	g7917	i0	95	0.634081902245707	80	4	31.7	0	441	202	1	80	EMT62165.1 hypothetical protein FOC4_g10015249 [Fusarium odoratissimum]	diamond	480	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium odoratissimum
32490549	32490549	PRJNA904835_P_NODE_42199_length_289_cov_1.069444_g41943_i0	PRJNA904835	42199	289	1.069444	3.09069316	Kluyveromyces marxianus DMKU3-1	4911	Fungi	Fungi	73.2	1.08e-12	NR	XP_022674247.1	1003335	g41943	i0	38.1	1.00692041522491	97	56	98.6	3	3	287	54	148	XP_022674247.1 actin-related protein 1 [Kluyveromyces marxianus DMKU3-1042]	diamond	291	73.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Kluyveromyces	Kluyveromyces marxianus

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