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

14 rows where analysis = "diamond", bioproject = "PRJNA312107" 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
26680196	26680196	PRJNA312107_P_NODE_19501_length_168_cov_1.025210_g19335_i0	PRJNA312107	19501	168	1.02521	1.7223528	Ophiocordyceps	474995	Fungi	Fungi	43.5	0.00715	NR	RDA95982.1	2039874	g19335	i0	45.5	1.17857142857143	33	16	55.4	1	38	130	38	70	RDA95982.1 hypothetical protein CP533_5872 [Ophiocordyceps camponoti-saundersi (nom. inval.)]	diamond	198	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Ophiocordyceps	Ophiocordyceps camponoti-saundersi (nom. inval.)
26870662	26870662	PRJNA312107_P_NODE_23701_length_164_cov_0.904348_g23535_i0	PRJNA312107	23701	164	0.904348	1.48313072	Trichomeriaceae	1233474	Fungi	Fungi	103	6.4899999999999996e-24	NR	XP_064728698.1	1635080	g23535	i0	83.3	2.96341463414634	54	9	98.8	0	162	1	484	537	XP_064728698.1 uncharacterized protein PMZ80_007025 [Knufia obscura]	diamond	486	103	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
27232255	27232255	PRJNA312107_P_NODE_23623_length_164_cov_0.904348_g23457_i0	PRJNA312107	23623	164	0.904348	1.48313072	Alternaria alternata	5599	Fungi	Fungi	103	5.02e-26	NR	KAH6863882.1	5599	g23457	i0	100	0.98780487804878	54	0	98.8	0	163	2	83	136	KAH6863882.1 hypothetical protein B0T12DRAFT_17280 [Alternaria alternata]	diamond	162	103	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria alternata
27439773	27439773	PRJNA312107_P_NODE_20503_length_167_cov_0.881356_g20337_i0	PRJNA312107	20503	167	0.881356	1.47186452	Ascomycota	4890	Fungi	Fungi	102	1.5199999999999995e-23	NR	KAI7618305.1	91943	g20337	i0	94.5	45.4491017964072	55	3	98.8	0	165	1	231	285	KAI7618305.1 hypothetical protein KC319_g19153, partial [Hortaea werneckii]	diamond	7590	103	0.990291262135922	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
27863825	27863825	PRJNA312107_P_NODE_9245_length_236_cov_0.978610_g9079_i0	PRJNA312107	9245	236	0.97861	2.3095196	Aspergillus varians	176181	Fungi	Fungi	42	0.0237	NR	KAL4788479.1	176181	g9079	i0	38.6	0.724576271186441	57	31	72.5	1	198	28	27	79	KAL4788479.1 hypothetical protein BJX76DRAFT_116599 [Aspergillus varians]	diamond	171	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus varians
28495566	28495566	PRJNA312107_P_NODE_25787_length_162_cov_0.920354_g25621_i0	PRJNA312107	25787	162	0.920354	1.49097348	Epicoccum nigrum	105696	Fungi	Fungi	114	7.34e-28	NR	KAG9206674.1	105696	g25621	i0	98.1	1	54	1	100	0	1	162	52	105	KAG9206674.1 hypothetical protein G6514_003514 [Epicoccum nigrum]	diamond	162	114	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Epicoccum	Epicoccum nigrum
28937558	28937558	PRJNA312107_P_NODE_21108_length_167_cov_0.881356_g20942_i0	PRJNA312107	21108	167	0.881356	1.47186452	Hyaloscypha sp. PMI_1271	2614599	Fungi	Fungi	85.1	1.54e-17	NR	KAH8755138.1	2614599	g20942	i0	78.2	0.988023952095808	55	12	98.8	0	3	167	142	196	KAH8755138.1 hypothetical protein F5882DRAFT_367736 [Hyaloscypha sp. PMI_1271]	diamond	165	85.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Hyaloscyphaceae	Hyaloscypha	Hyaloscypha sp. PMI_1271
29112986	29112986	PRJNA312107_P_NODE_25528_length_162_cov_0.920354_g25362_i0	PRJNA312107	25528	162	0.920354	1.49097348	Hypocreales	5125	Fungi	Fungi	82.4	1.17e-16	NR	KAL2210795.1	5046	g25362	i0	70	8.38888888888889	50	15	92.6	0	160	11	398	447	KAL2210795.1 histidine acid phosphatase [Sarocladium strictum]	diamond	1359	82.8	0.995169082125604	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29365555	29365555	PRJNA312107_P_NODE_23769_length_164_cov_0.904348_g23603_i0	PRJNA312107	23769	164	0.904348	1.48313072	Pleosporales	92860	Fungi	Fungi	89.7	3.5e-19	NR	KAI4949194.1	1187941	g23603	i0	74.1	2.96341463414634	54	12	98.8	1	1	162	503	554	KAI4949194.1 hypothetical protein J4E91_005658 [Alternaria rosae]	diamond	486	89.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria rosae
29631785	29631785	PRJNA312107_P_NODE_23230_length_165_cov_0.896552_g23064_i0	PRJNA312107	23230	165	0.896552	1.4793108	Lecanicillium sp. MT-2	1756136	Fungi	Fungi	102	1.6299999999999994e-23	NR	KAK3191042.1	1964301	g23064	i0	90.6	0.963636363636364	53	5	96.4	0	160	2	560	612	KAK3191042.1 hypothetical protein K4F52_002992 [Lecanicillium sp. MT-2017a]	diamond	159	102	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Lecanicillium	Lecanicillium sp. MT-2017a
29631786	29631786	PRJNA312107_P_NODE_24410_length_163_cov_1.359649_g24244_i0	PRJNA312107	24410	163	1.359649	2.21622787	Podospora australis	1536484	Fungi	Fungi	41.2	0.0438	NR	KAK4186062.1	1536484	g24244	i0	41.7	0.662576687116564	36	21	66.3	0	42	149	609	644	KAK4186062.1 hypothetical protein QBC35DRAFT_453660 [Podospora australis]	diamond	108	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Podosporaceae	Podospora	Podospora australis
30579524	30579524	PRJNA312107_P_NODE_21573_length_166_cov_0.888889_g21407_i0	PRJNA312107	21573	166	0.888889	1.47555574	Lecanicillium sp. MT-2	1756136	Fungi	Fungi	92.4	4.17e-20	NR	KAK3191859.1	1964301	g21407	i0	77.8	1.95180722891566	54	12	97.6	0	1	162	645	698	KAK3191859.1 hypothetical protein K4F52_001902 [Lecanicillium sp. MT-2017a]	diamond	324	92.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Lecanicillium	Lecanicillium sp. MT-2017a
32034178	32034178	PRJNA312107_P_NODE_25958_length_162_cov_0.920354_g25792_i0	PRJNA312107	25958	162	0.920354	1.49097348	Hortaea werneckii	91943	Fungi	Fungi	41.6	0.00917	NR	RMZ14196.1	91943	g25792	i0	69	2.14814814814815	29	9	53.7	0	63	149	53	81	RMZ14196.1 hypothetical protein D0864_00250 [Hortaea werneckii]	diamond	348	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Hortaea	Hortaea werneckii
32886673	32886673	PRJNA312107_P_NODE_18900_length_169_cov_0.866667_g18734_i0	PRJNA312107	18900	169	0.866667	1.46466723	Valsa sordida	252740	Fungi	Fungi	53.5	2.07e-6	NR	ROV89038.1	252740	g18734	i0	49.1	0.976331360946746	55	28	97.6	0	167	3	308	362	ROV89038.1 hypothetical protein VSDG_08717 [Cytospora chrysosperma]	diamond	165	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Cytosporaceae	Cytospora	Cytospora chrysosperma

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