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

10 rows where analysis = "diamond", bioproject = "PRJNA981359" 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
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
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
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
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

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