metadata: contig_metadata: 5 rows where bioproject = "PRJNA982720" and tax

5 rows where bioproject = "PRJNA982720" 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
3514856	3514856	PRJNA982720_S_NODE_3263_length_338_cov_4.030189_g3235_i0	PRJNA982720	3263	338	4.030189	13.62203882	Cylindricascospora bacillispora	51660	Fungi	Fungi	54.7	0.009	NTclustered	gi\|228015422\|ref\|NC_012621.1\|	51660	g3235	i0	100	0.0857988165680473	29	0	9	0	273	301	27381	27409	Nakaseomyces bacillisporus mitochondrion, complete genome	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Cylindricascospora	Cylindricascospora bacillispora
16267161	16267161	PRJNA982720_S_NODE_1733_length_387_cov_3.175159_g1705_i0	PRJNA982720	1733	387	3.175159	12.28786533	Sarocladium implicatum	1610689	Fungi	Fungi	307	7.140000000000001e-79	NTclustered	gi\|761546238\|ref\|NC_026534.1\|	1610689	g1705	i0	81.818	2.45478036175711	396	45	98	17	10	387	2355	1969	Acremonium implicatum mitochondrion, complete genome	blastn	950	307	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
28510705	28510705	PRJNA982720_S_NODE_8267_length_256_cov_3.426230_g8239_i0	PRJNA982720	8267	256	3.42623	8.7711488	Fusarium oxysporum	5507	Fungi	Fungi	109	3.48e-26	NR	KAJ4050974.1	5507	g8239	i0	86.4	0.69140625	59	8	69.1	0	3	179	89	147	KAJ4050974.1 hypothetical protein NW753_007579 [Fusarium oxysporum]	diamond	177	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
30342813	30342813	PRJNA982720_S_NODE_6052_length_286_cov_4.342723_g6024_i0	PRJNA982720	6052	286	4.342723	12.42018778	Sarocladium strictum	5046	Fungi	Fungi	156	2.8599999999999993e-43	NR	KAK0391662.1	5046	g6024	i0	92.3	1.63636363636364	78	6	81.8	0	53	286	20	97	KAK0391662.1 hypothetical protein NLU13_1161 [Sarocladium strictum]	diamond	468	156	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31194965	31194965	PRJNA982720_S_NODE_9315_length_245_cov_2.558140_g9287_i0	PRJNA982720	9315	245	2.55814	6.267443	Sarocladium implicatum	1610689	Fungi	Fungi	47	0.00115	NR	KAH8170626.1	1610689	g9287	i0	33.9	0.722448979591837	59	39	72.2	0	63	239	1	59	KAH8170626.1 hypothetical protein LIA77_09407 [Sarocladium implicatum]	diamond	177	47	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum

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