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

14 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax_kingdom = "Fungi"

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
6065830	6065830	PRJNA981359_S_NODE_41105_length_300_cov_1.030837_g41005_i0	PRJNA981359	41105	300	1.030837	3.092511	Sarocladium strictum	5046	Fungi	Fungi	112	1.2900000000000002e-27	NR	KAK0386942.1	5046	g41005	i0	92.6	0.54	54	4	54	0	274	113	24	77	KAK0386942.1 hypothetical protein NLU13_5255 [Sarocladium strictum]	diamond	162	112	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
26773130	26773130	PRJNA981359_S_NODE_60301_length_260_cov_4.331551_g60201_i0	PRJNA981359	60301	260	4.331551	11.2620326	Lepraria neglecta	209136	Fungi	Fungi	42.7	0.0138	NR	KAK3171190.1	209136	g60201	i0	29.7	0.738461538461539	64	45	73.8	0	40	231	9	72	KAK3171190.1 hypothetical protein OEA41_003274 [Lepraria neglecta]	diamond	192	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Lecanorales	Stereocaulaceae	Lepraria	Lepraria neglecta
26773132	26773132	PRJNA981359_S_NODE_76941_length_223_cov_5.366667_g76841_i0	PRJNA981359	76941	223	5.366667	11.96766741	Pleurotus djamor	34470	Fungi	Fungi	42.7	0.0191	NR	KAJ8501405.1	34470	g76841	i0	43.3	1.5067264573991	60	31	80.7	1	181	2	24	80	KAJ8501405.1 hypothetical protein ONZ45_g12158 [Pleurotus djamor]	diamond	336	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus djamor
26804696	26804696	PRJNA981359_S_NODE_58701_length_263_cov_3.810526_g58601_i0	PRJNA981359	58701	263	3.810526	10.02168338	Lipomyces starkeyi	29829	Fungi	Fungi	45.1	0.00448	NR	KAK9315014.1	29829	g58601	i0	81	4.52851711026616	21	4	24	0	14	76	63	83	KAK9315014.1 ADP-ribosylation factor family-domain-containing protein [Lipomyces starkeyi]	diamond	1191	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces starkeyi
26836580	26836580	PRJNA981359_S_NODE_33901_length_317_cov_1.918033_g33801_i0	PRJNA981359	33901	317	1.918033	6.08016461	Penicillium subrubescens	1316194	Fungi	Fungi	43.9	0.0224	NR	XP_057009268.1	1316194	g33801	i0	49	0.482649842271293	51	25	48.3	1	18	170	94	143	XP_057009268.1 uncharacterized protein N7473_005523 [Penicillium subrubescens]	diamond	153	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium subrubescens
27221736	27221736	PRJNA981359_S_NODE_34662_length_315_cov_2.297521_g34562_i0	PRJNA981359	34662	315	2.297521	7.23719115	Sordariales	5139	Fungi	Fungi	48.9	6.03e-4	NR	XP_009853391.1	510951	g34562	i0	45.5	1.25714285714286	66	31	62.9	2	263	66	551	611	XP_009853391.1 uncharacterized protein NEUTE1DRAFT_148061 [Neurospora tetrasperma FGSC 2508]	diamond	396	49.3	0.991886409736308	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Sordariaceae	Neurospora	Neurospora tetrasperma
27601259	27601259	PRJNA981359_S_NODE_24284_length_345_cov_1.147059_g24184_i0	PRJNA981359	24284	345	1.147059	3.95735355	Basidiomycota	5204	Fungi	Fungi	149	6.57e-41	NR	CEQ40168.1	5005	g24184	i0	67.6	2.66086956521739	102	31	88.7	1	1	306	302	401	CEQ40168.1 SPOSA6832_01756, partial [Sporobolomyces salmonicolor]	diamond	918	149	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmonicolor
28763129	28763129	PRJNA981359_S_NODE_15387_length_382_cov_2.847896_g15287_i0	PRJNA981359	15387	382	2.847896	10.87896272	Sarocladium strictum	5046	Fungi	Fungi	250	1.37e-76	NR	KAK0383134.1	5046	g15287	i0	96.9	0.99738219895288	127	3	99.7	1	2	382	168	293	KAK0383134.1 hypothetical protein NLU13_9047 [Sarocladium strictum]	diamond	381	250	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29022224	29022224	PRJNA981359_S_NODE_20128_length_360_cov_1.400697_g20028_i0	PRJNA981359	20128	360	1.400697	5.0425092	Sarocladium	284134	Fungi	Fungi	126	2.5699999999999997e-32	NR	KAK0383585.1	5046	g20028	i0	89.4	1.64166666666667	66	7	55	0	358	161	278	343	KAK0383585.1 hypothetical protein NLU13_9496 [Sarocladium strictum]	diamond	591	127	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29142380	29142380	PRJNA981359_S_NODE_49149_length_282_cov_3.358852_g49049_i0	PRJNA981359	49149	282	3.358852	9.47196264	Malassezia restricta	76775	Fungi	Fungi	89.7	3.08e-21	NR	XP_027484810.1	76775	g49049	i0	66	1.07446808510638	47	16	50	0	22	162	33	79	XP_027484810.1 uncharacterized protein MRET_2819 [Malassezia restricta]	diamond	303	89.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30500271	30500271	PRJNA981359_S_NODE_42693_length_296_cov_2.260090_g42593_i0	PRJNA981359	42693	296	2.26009	6.6898664	Sarocladium strictum	5046	Fungi	Fungi	164	1.43e-44	NR	KAK0392733.1	5046	g42593	i0	87.8	0.993243243243243	98	10	98.3	2	291	1	35	131	KAK0392733.1 hypothetical protein NLU13_2228 [Sarocladium strictum]	diamond	294	164	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
32467031	32467031	PRJNA981359_S_NODE_21839_length_353_cov_3.657143_g21739_i0	PRJNA981359	21839	353	3.657143	12.90971479	Sordariomycetes	147550	Fungi	Fungi	53.1	5.85e-6	NR	KAF5234284.1	282268	g21739	i0	37.3	1.91218130311615	83	43	62.9	2	352	131	7	89	KAF5234284.1 hypothetical protein FAUST_7744 [Fusarium austroamericanum]	diamond	675	53.5	0.992523364485981	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium austroamericanum
32649827	32649827	PRJNA981359_S_NODE_31520_length_323_cov_3.432000_g31420_i0	PRJNA981359	31520	323	3.432	11.08536	Stachybotrys chartarum IBT 7711	1280523	Fungi	Fungi	173	5.52e-49	NR	KEY70682.1	1280523	g31420	i0	71.7	0.984520123839009	106	30	98.5	0	322	5	326	431	KEY70682.1 hypothetical protein S7711_09869 [Stachybotrys chartarum IBT 7711]	diamond	318	173	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Stachybotryaceae	Stachybotrys	Stachybotrys chartarum
32901915	32901915	PRJNA981359_S_NODE_7280_length_453_cov_1.247368_g7181_i0	PRJNA981359	7280	453	1.247368	5.65057704	Thecaphora frezii	1269715	Fungi	Fungi	47	7.66e-4	NR	UOP57098.1	1269715	g7181	i0	47.7	0.291390728476821	44	23	29.1	0	301	170	31	74	UOP57098.1 hypothetical protein [Thecaphora frezii]	diamond	132	47	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Urocystidales	Glomosporiaceae	Thecaphora	Thecaphora frezii

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