metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB39269" 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
27090069	27090069	PRJEB39269_P_NODE_70022_length_168_cov_1.271318_g69617_i0	PRJEB39269	70022	168	1.271318	2.13581424	Teratosphaeriaceae	668547	Fungi	Fungi	45.4	0.00147	NR	RMZ32029.1	91943	g69617	i0	75	0.839285714285714	24	6	42.9	0	92	163	322	345	RMZ32029.1 hypothetical protein D0859_03855 [Hortaea werneckii]	diamond	141	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
27254477	27254477	PRJEB39269_P_NODE_49623_length_195_cov_1.166667_g49218_i0	PRJEB39269	49623	195	1.166667	2.27500065	Parastagonospora nodorum	13684	Fungi	Fungi	43.9	0.00609	NR	KAH5515148.1	13684	g49218	i0	33.3	1.01538461538462	66	37	90.8	1	2	178	122	187	KAH5515148.1 hypothetical protein HBI52_107880 [Parastagonospora nodorum]	diamond	198	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Parastagonospora	Parastagonospora nodorum
27570431	27570431	PRJEB39269_P_NODE_37944_length_223_cov_2.788043_g37539_i0	PRJEB39269	37944	223	2.788043	6.21733589	Metschnikowia pulcherrima	27326	Fungi	Fungi	126	2.08e-35	NR	KAJ8133701.1	27326	g37539	i0	98.6	0.928251121076233	69	1	92.8	0	16	222	1	69	KAJ8133701.1 hypothetical protein OY671_013085, partial [Metschnikowia pulcherrima]	diamond	207	126	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
28233264	28233264	PRJEB39269_P_NODE_61666_length_176_cov_1.197080_g61261_i0	PRJEB39269	61666	176	1.19708	2.1068608	Metschnikowia pulcherrima	27326	Fungi	Fungi	90.5	1.89e-21	NR	KAJ8134622.1	27326	g61261	i0	95.8	0.818181818181818	48	2	81.8	0	3	146	12	59	KAJ8134622.1 hypothetical protein OY671_012165, partial [Metschnikowia pulcherrima]	diamond	144	90.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
29212512	29212512	PRJEB39269_P_NODE_39469_length_219_cov_1.244444_g39064_i0	PRJEB39269	39469	219	1.244444	2.72533236	Metschnikowia pulcherrima	27326	Fungi	Fungi	150	1.14e-44	NR	KAJ8135802.1	27326	g39064	i0	95.9	1	73	3	100	0	1	219	16	88	KAJ8135802.1 hypothetical protein OY671_010985, partial [Metschnikowia pulcherrima]	diamond	219	150	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
29338717	29338717	PRJEB39269_P_NODE_84629_length_155_cov_1.482759_g84224_i0	PRJEB39269	84629	155	1.482759	2.29827645	Metschnikowia pulcherrima	27326	Fungi	Fungi	107	1.2900000000000002e-27	NR	KAJ8137499.1	27326	g84224	i0	100	0.987096774193548	51	0	98.7	0	154	2	115	165	KAJ8137499.1 hypothetical protein OY671_009288, partial [Metschnikowia pulcherrima]	diamond	153	107	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
29685597	29685597	PRJEB39269_P_NODE_91370_length_150_cov_1.477477_g90965_i0	PRJEB39269	91370	150	1.477477	2.2162155	Metschnikowia pulcherrima	27326	Fungi	Fungi	88.2	1.65e-20	NR	KAJ8134985.1	27326	g90965	i0	89.8	0.98	49	5	98	0	149	3	100	148	KAJ8134985.1 hypothetical protein OY671_011802, partial [Metschnikowia pulcherrima]	diamond	147	88.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
30096420	30096420	PRJEB39269_P_NODE_61152_length_177_cov_0.797101_g60747_i0	PRJEB39269	61152	177	0.797101	1.41086877	Xanthoria sp. 2 TBL-2	2527712	Fungi	Fungi	42	0.028	NR	KAI4274937.1	2903222	g60747	i0	40	0.76271186440678	45	27	76.3	0	4	138	186	230	KAI4274937.1 MAG: hypothetical protein L6R38_006002 [Xanthoria sp. 2 TBL-2021]	diamond	135	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Teloschistales	Teloschistaceae	Xanthoria	Xanthoria sp. 2 TBL-2021
30318257	30318257	PRJEB39269_P_NODE_50912_length_192_cov_2.444444_g50507_i0	PRJEB39269	50912	192	2.444444	4.69333248	Metschnikowia pulcherrima	27326	Fungi	Fungi	122	5.42e-33	NR	KAJ8137541.1	27326	g50507	i0	92.2	1	64	5	100	0	192	1	47	110	KAJ8137541.1 hypothetical protein OY671_009246, partial [Metschnikowia pulcherrima]	diamond	192	122	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
30854790	30854790	PRJEB39269_P_NODE_70974_length_167_cov_1.281250_g70569_i0	PRJEB39269	70974	167	1.28125	2.1396875	Acrodontium crateriforme	150365	Fungi	Fungi	98.6	2.22e-22	NR	WPH00512.1	150365	g70569	i0	92.7	0.988023952095808	55	4	98.8	0	166	2	218	272	WPH00512.1 putative MFS monosaccharide transporter [Acrodontium crateriforme]	diamond	165	98.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Acrodontium	Acrodontium crateriforme
31360674	31360674	PRJEB39269_P_NODE_79556_length_159_cov_1.450000_g79151_i0	PRJEB39269	79556	159	1.45	2.3055	Metschnikowia pulcherrima	27326	Fungi	Fungi	101	3.85e-26	NR	KAJ8136271.1	27326	g79151	i0	100	0.981132075471698	52	0	98.1	0	3	158	47	98	KAJ8136271.1 hypothetical protein OY671_010516, partial [Metschnikowia pulcherrima]	diamond	156	101	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Metschnikowiaceae	Metschnikowia	Metschnikowia pulcherrima
31550544	31550544	PRJEB39269_P_NODE_42316_length_211_cov_1.668605_g41911_i0	PRJEB39269	42316	211	1.668605	3.52075655	Penicillium subrubescens	1316194	Fungi	Fungi	44.3	0.00672	NR	XP_057011473.1	1316194	g41911	i0	73.1	0.739336492890995	26	7	37	0	36	113	376	401	XP_057011473.1 tryptophan synthase beta chain 1 [Penicillium subrubescens]	diamond	156	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium subrubescens
31993152	31993152	PRJEB39269_P_NODE_36338_length_228_cov_16.476190_g35933_i0	PRJEB39269	36338	228	16.47619	37.5657132	Neonectria ditissima	78410	Fungi	Fungi	43.5	0.0162	NR	KPM41533.1	78410	g35933	i0	36.4	0.868421052631579	66	42	86.8	0	3	200	36	101	KPM41533.1 hypothetical protein AK830_g5050 [Neonectria ditissima]	diamond	198	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Neonectria	Neonectria ditissima
32656828	32656828	PRJEB39269_P_NODE_16780_length_342_cov_4.930693_g16375_i0	PRJEB39269	16780	342	4.930693	16.86297006	Cylindrodendrum hubeiense	595255	Fungi	Fungi	44.7	0.022	NR	KAF7542442.1	595255	g16375	i0	31.3	0.701754385964912	80	50	70.2	2	26	265	79	153	KAF7542442.1 hypothetical protein G7Z17_g11565 [Cylindrodendrum hubeiense]	diamond	240	44.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Cylindrodendrum	Cylindrodendrum hubeiense

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