metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA1065838" 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
28425287	28425287	PRJNA1065838_S_NODE_34886_length_164_cov_0.904348_g34784_i0	PRJNA1065838	34886	164	0.904348	1.48313072	Exophiala spinifera	91928	Fungi	Fungi	90.1	2.59e-19	NR	XP_016237266.1	91928	g34784	i0	79.6	0.98780487804878	54	11	98.8	0	2	163	395	448	XP_016237266.1 uncharacterized protein PV08_04241 [Exophiala spinifera]	diamond	162	90.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala spinifera
29940931	29940931	PRJNA1065838_S_NODE_34691_length_164_cov_1.582609_g34589_i0	PRJNA1065838	34691	164	1.582609	2.59547876	Colletotrichum musicola	2175873	Fungi	Fungi	41.6	0.0102	NR	KAF6802596.1	2175873	g34589	i0	52.6	0.695121951219512	38	18	69.5	0	152	39	63	100	KAF6802596.1 hypothetical protein CMUS01_15313 [Colletotrichum musicola]	diamond	114	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum musicola
29940934	29940934	PRJNA1065838_S_NODE_36411_length_162_cov_0.902655_g36309_i0	PRJNA1065838	36411	162	0.902655	1.4623011	Sarocladium strictum	5046	Fungi	Fungi	96.7	1.17e-21	NR	KAL2202512.1	5046	g36309	i0	77.4	7.85185185185185	53	12	98.1	0	3	161	403	455	KAL2202512.1 adenosine deaminase [Sarocladium strictum]	diamond	1272	96.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31046871	31046871	PRJNA1065838_S_NODE_34375_length_165_cov_0.879310_g34273_i0	PRJNA1065838	34375	165	0.87931	1.4508615	Cladobotryum mycophilum	491253	Fungi	Fungi	52.8	3.58e-6	NR	KAK5994702.1	491253	g34273	i0	63	5.96363636363636	46	12	83.6	1	142	5	199	239	KAK5994702.1 hypothetical protein PT974_04689 [Cladobotryum mycophilum]	diamond	984	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Cladobotryum	Cladobotryum mycophilum

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