metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA832865" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA832865" 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
824009	824009	PRJNA832865_S_NODE_96501_length_250_cov_0.870056_g91415_i0	PRJNA832865	96501	250	0.870056	2.17514	Eukaryota	2759	Fungi	Fungi	76.6	1.72e-14	NR	KAK7745200.1	117547	g91415	i0	80	45.528	45	9	54	0	114	248	124	168	KAK7745200.1 Small subunit processome complex component [Diatrype stigma]	diamond	11382	77	0.994805194805195	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Diatrypaceae	Diatrype	Diatrype stigma
26674437	26674437	PRJNA832865_S_NODE_89761_length_257_cov_2.043478_g84675_i0	PRJNA832865	89761	257	2.043478	5.25173846	Aspergillus carlsbadensis	1810906	Fungi	Fungi	42	0.0167	NR	KAJ0422817.1	1810906	g84675	i0	33.3	0.700389105058366	60	32	67.7	2	56	229	30	83	KAJ0422817.1 hypothetical protein BJY00DRAFT_66280 [Aspergillus carlsbadensis]	diamond	180	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus carlsbadensis
28326282	28326282	PRJNA832865_S_NODE_46306_length_377_cov_1.963816_g41220_i0	PRJNA832865	46306	377	1.963816	7.40358632	Eurotiales	5042	Fungi	Fungi	70.5	3.31e-11	NR	KAJ5341398.1	5074	g41220	i0	40.9	9.82758620689655	93	49	74	2	48	326	643	729	KAJ5341398.1 hypothetical protein N7541_010522 [Penicillium brevicompactum]	diamond	3705	71.2	0.990168539325843	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium brevicompactum
28579141	28579141	PRJNA832865_S_NODE_55847_length_335_cov_1.442748_g50761_i0	PRJNA832865	55847	335	1.442748	4.8332058	Opisthokonta	33154	Fungi	Fungi	45.8	0.00911	NR	KAI3133297.1	5082	g50761	i0	60	3.41194029850746	30	12	26.9	0	245	334	1133	1162	KAI3133297.1 hypothetical protein CBS147326_5100 [Penicillium roqueforti]	diamond	1143	45.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium roqueforti
28633871	28633871	PRJNA832865_S_NODE_45587_length_381_cov_2.165584_g40501_i0	PRJNA832865	45587	381	2.165584	8.25087504	Colletotrichum gloeosporioides 23	1314770	Fungi	Fungi	42	0.0341	NR	KAH9240229.1	1314770	g40501	i0	42.5	0.31496062992126	40	23	31.5	0	146	27	9	48	KAH9240229.1 hypothetical protein K456DRAFT_1038704 [Colletotrichum gloeosporioides 23]	diamond	120	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum gloeosporioides
28854457	28854457	PRJNA832865_S_NODE_106728_length_243_cov_1.358824_g101642_i0	PRJNA832865	106728	243	1.358824	3.30194232	Colletotrichum chrysophilum	1836956	Fungi	Fungi	43.5	0.0154	NR	KAK1838269.1	1836956	g101642	i0	50	0.962962962962963	38	19	46.9	0	220	107	50	87	KAK1838269.1 hypothetical protein CCHR01_19103 [Colletotrichum chrysophilum]	diamond	234	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum chrysophilum
30402605	30402605	PRJNA832865_S_NODE_91353_length_255_cov_1.269231_g86267_i0	PRJNA832865	91353	255	1.269231	3.23653905	Peziza echinospora	61495	Fungi	Fungi	43.5	0.0197	NR	KAI5809941.1	61495	g86267	i0	37.5	0.658823529411765	56	27	65.9	1	24	191	140	187	KAI5809941.1 hypothetical protein DFH27DRAFT_537034 [Peziza echinospora]	diamond	168	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Pezizaceae	Peziza	Peziza echinospora
30623154	30623154	PRJNA832865_S_NODE_76233_length_282_cov_0.961722_g71147_i0	PRJNA832865	76233	282	0.961722	2.71205604	Aspergillus glaucus CBS 516.65	1160497	Fungi	Fungi	45.4	0.00633	NR	XP_022402039.1	1160497	g71147	i0	28.4	0.787234042553192	74	38	77.7	2	248	30	123	182	XP_022402039.1 uncharacterized protein ASPGLDRAFT_57473 [Aspergillus glaucus CBS 516.65]	diamond	222	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus glaucus
31255259	31255259	PRJNA832865_S_NODE_93235_length_252_cov_1.664804_g88149_i0	PRJNA832865	93235	252	1.664804	4.19530608	Phlyctema vagabunda	108571	Fungi	Fungi	42.7	0.0414	NR	KAL3423403.1	108571	g88149	i0	29.5	0.928571428571429	78	47	86.9	2	20	238	447	521	KAL3423403.1 XPG domain-containing protein [Phlyctema vagabunda]	diamond	234	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Dermateaceae	Phlyctema	Phlyctema vagabunda
31729652	31729652	PRJNA832865_S_NODE_62557_length_314_cov_1.024896_g57471_i0	PRJNA832865	62557	314	1.024896	3.21817344	Apodospora peruviana	516989	Fungi	Fungi	75.9	2.03e-13	NR	KAK3318978.1	516989	g57471	i0	42	0.955414012738854	100	50	95.5	2	310	11	845	936	KAK3318978.1 hypothetical protein B0H66DRAFT_582413 [Apodospora peruviana]	diamond	300	75.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Lasiosphaeriaceae	Apodospora	Apodospora peruviana
32181343	32181343	PRJNA832865_S_NODE_84038_length_267_cov_1.278351_g78952_i0	PRJNA832865	84038	267	1.278351	3.41319717	Hypocreales	5125	Fungi	Fungi	43.5	0.0267	NR	PTD03603.1	5516	g78952	i0	43.9	3.68539325842697	41	23	46.1	0	203	81	492	532	PTD03603.1 hypothetical protein FCULG_00002613 [Fusarium culmorum]	diamond	984	43.9	0.990888382687927	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium culmorum
32867202	32867202	PRJNA832865_S_NODE_87560_length_261_cov_1.228723_g82474_i0	PRJNA832865	87560	261	1.228723	3.20696703	Hypoxylon sp. CI-4A	1001833	Fungi	Fungi	43.1	0.0327	NR	OTB01380.1	1001833	g82474	i0	39.7	0.666666666666667	58	35	66.7	0	179	6	65	122	OTB01380.1 hypothetical protein M426DRAFT_220371 [Hypoxylon sp. CI-4A]	diamond	174	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Hypoxylon	Hypoxylon sp. CI-4A

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