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

9 rows where analysis = "diamond", bioproject = "PRJNA1120203" 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
5378642	5378642	PRJNA1120203_P_NODE_88725_length_247_cov_0.885057_g87709_i0	PRJNA1120203	88725	247	0.885057	2.18609079	Oidiodendron maius Zn	913774	Fungi	Fungi	126	3.3499999999999993e-34	NR	KIM93694.1	913774	g87709	i0	79.3	0.995951417004049	82	16	99.6	1	2	247	95	175	KIM93694.1 glycoside hydrolase family 11 protein, partial [Oidiodendron maius Zn]	diamond	246	126	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes		Myxotrichaceae	Oidiodendron	Oidiodendron maius
28070054	28070054	PRJNA1120203_P_NODE_87865_length_248_cov_0.880000_g86849_i0	PRJNA1120203	87865	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	73.9	3.99e-13	NR	KAA8914437.1	44093	g86849	i0	45.5	4.8508064516129	77	35	93.1	2	248	18	312	381	KAA8914437.1 hypothetical protein TRICI_002880 [Trichomonascus ciferrii]	diamond	1203	73.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Trichomonascus	Trichomonascus ciferrii
30722746	30722746	PRJNA1120203_P_NODE_86534_length_248_cov_0.880000_g85518_i0	PRJNA1120203	86534	248	0.88	2.1824	Sordariomycetes	147550	Fungi	Fungi	112	3.67e-28	NR	KAJ3545760.1	57161	g85518	i0	61.3	1.94758064516129	80	30	96.8	1	3	242	69	147	KAJ3545760.1 hypothetical protein NM208_g2345 [Fusarium decemcellulare]	diamond	483	112	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium decemcellulare
30754496	30754496	PRJNA1120203_P_NODE_63934_length_282_cov_0.966507_g62918_i0	PRJNA1120203	63934	282	0.966507	2.72554974	Ascomycota	4890	Fungi	Fungi	113	1.03e-26	NR	KAF2501492.1	390894	g62918	i0	60.2	13.8723404255319	93	22	97.9	2	5	280	64	142	KAF2501492.1 WD40 repeat-like protein [Lophium mytilinum]	diamond	3912	113	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mytilinidiales	Mytilinidiaceae	Lophium	Lophium mytilinum
30975762	30975762	PRJNA1120203_P_NODE_74794_length_258_cov_1.200000_g73778_i0	PRJNA1120203	74794	258	1.2	3.096	Sordariomycetes	147550	Fungi	Fungi	139	4.699999999999999e-38	NR	XP_036581634.1	5467	g73778	i0	74.4	16.7325581395349	86	19	96.5	1	2	250	25	110	XP_036581634.1 oligosaccharyl transferase subunit [Colletotrichum truncatum]	diamond	4317	140	0.992857142857143	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum truncatum
31207056	31207056	PRJNA1120203_P_NODE_83035_length_249_cov_1.500000_g82019_i0	PRJNA1120203	83035	249	1.5	3.735	Xylariales sp. AK1849	1907220	Fungi	Fungi	77	2.91e-14	NR	KAI0123583.1	1907220	g82019	i0	63.5	2.40963855421687	63	22	75.9	1	247	59	345	406	KAI0123583.1 DUF6 domain protein [Xylariales sp. AK1849]	diamond	600	77	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales			Xylariales sp. AK1849
31333904	31333904	PRJNA1120203_P_NODE_78856_length_251_cov_0.865169_g77840_i0	PRJNA1120203	78856	251	0.865169	2.17157419	Hortaea werneckii	91943	Fungi	Fungi	164	7.23e-45	NR	KAI6827603.1	91943	g77840	i0	98.8	1.9840637450199201	83	1	99.2	0	249	1	506	588	KAI6827603.1 hypothetical protein KC358_g7450 [Hortaea werneckii]	diamond	498	164	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
31618662	31618662	PRJNA1120203_P_NODE_79556_length_251_cov_0.865169_g78540_i0	PRJNA1120203	79556	251	0.865169	2.17157419	Exophiala oligosperma	215243	Fungi	Fungi	174	8.41e-49	NR	XP_016262833.1	215243	g78540	i0	95.2	0.99203187250996006	83	4	99.2	0	250	2	192	274	XP_016262833.1 uncharacterized protein PV06_06149 [Exophiala oligosperma]	diamond	249	174	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala oligosperma
31903322	31903322	PRJNA1120203_P_NODE_84897_length_249_cov_0.875000_g83881_i0	PRJNA1120203	84897	249	0.875	2.17875	Pneumocystis jirovecii	42068	Fungi	Fungi	55.1	1.84e-6	NR	CCJ31553.1	42068	g83881	i0	100	0.289156626506024	24	0	28.9	0	139	210	3	26	CCJ31553.1 unnamed protein product, partial [Pneumocystis jirovecii]	diamond	72	55.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis jirovecii

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