metadata: contig_metadata: 10 rows where bioproject = "PRJNA454154" and tax

10 rows where bioproject = "PRJNA454154" 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
11920750	11920750	PRJNA454154_S_NODE_630_length_154_cov_4.794872_g627_i0	PRJNA454154	630	154	4.794872	7.38410288	Cordyceps militaris	73501	Fungi	Fungi	82.4	1.61e-11	NTclustered	gi\|573977989\|ref\|XM_006666877.1\|	983644	g627	i0	81.188	0.655844155844156	101	19	66	0	3	103	382	482	Cordyceps militaris CM01 cyclophilin (CCM_01722), partial mRNA	blastn	101	82.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Cordyceps	Cordyceps militaris
13195563	13195563	PRJNA454154_S_NODE_471_length_172_cov_7.437037_g468_i0	PRJNA454154	471	172	7.437037	12.79170364	Sordaria macrospora	5147	Fungi	Fungi	226	8.029999999999998e-55	NTclustered	gi\|2749640791\|ref\|XM_003348129.2\|	5147	g468	i0	91.018	95.3488372093023	167	15	97	0	6	172	462	628	Sordaria macrospora uncharacterized protein (SMAC4_04022), mRNA	blastn	16400	226	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Sordariaceae	Sordaria	Sordaria macrospora
19567749	19567749	PRJNA454154_S_NODE_76_length_306_cov_25.527881_g73_i0	PRJNA454154	76	306	25.527881	78.11531586	Middelhovenomyces tepae	45597	Fungi	Fungi	159	1.6299999999999999e-34	NTclustered	gi\|390195117\|gb\|JQ689063.1\|	45597	g73	i0	79.032	54.6601307189542	248	41	79	11	12	254	1235	1476	Candida tepae strain NRRL Y-17670 26S ribosomal RNA gene, partial sequence	blastn	16726	159	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Dipodascaceae	Middelhovenomyces	Middelhovenomyces tepae
20219663	20219663	PRJNA454154_S_NODE_256_length_207_cov_3.994118_g253_i0	PRJNA454154	256	207	3.994118	8.26782426	Eukaryota	2759	Fungi	Fungi	364	2.0499999999999993e-96	NTclustered	gi\|514829572\|gb\|KC771883.1\|	4929	g253	i0	99.015	81.4299516908213	203	2	98	0	1	203	114	316	Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence	blastn	16856	364	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma guilliermondii
24668138	24668138	PRJNA454154_S_NODE_60_length_345_cov_20.480519_g57_i0	PRJNA454154	60	345	20.480519	70.65779055	uncultured Geomyces	526445	Fungi	Fungi	122	2.45e-23	NTclustered	gi\|511488227\|gb\|JX898643.1\|	526445	g57	i0	85.039	37.3884057971014	127	12	36	6	12	135	314	192	Uncultured Geomyces clone GMW_D06-13 28S ribosomal RNA gene, partial sequence	blastn	12899	122	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes		Myxotrichaceae		uncultured Geomyces
27629598	27629598	PRJNA454154_S_NODE_264_length_205_cov_2.142857_g261_i0	PRJNA454154	264	205	2.142857	4.39285685	root	1	Root_unresolved	Root_unresolved	45.1	0.00165	NR	PCD39121.1	5518	g261	i0	57.1	2.18048780487805	35	15	51.2	0	192	88	95	129	PCD39121.1 hypothetical protein FGRA07_00392 [Fusarium graminearum]	diamond	447	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium graminearum
27897280	27897280	PRJNA454154_S_NODE_325_length_193_cov_1.557692_g322_i0	PRJNA454154	325	193	1.557692	3.00634556	Saccharomycopsis crataegensis	43959	Fungi	Fungi	67.8	1.44e-12	NR	XP_064850582.1	43959	g322	i0	74.4	2.6580310880829	43	11	66.8	0	192	64	84	126	XP_064850582.1 profilin [Saccharomycopsis crataegensis]	diamond	513	67.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Saccharomycopsidaceae	Saccharomycopsis	Saccharomycopsis crataegensis
29113512	29113512	PRJNA454154_S_NODE_688_length_150_cov_2.486726_g685_i0	PRJNA454154	688	150	2.486726	3.730089	Ascomycota	4890	Fungi	Fungi	60.1	6.61e-9	NR	XP_018734185.1	796027	g685	i0	57.8	7.32	45	19	90	0	150	16	249	293	XP_018734185.1 Ymc1p [Sugiyamaella lignohabitans]	diamond	1098	60.5	0.993388429752066	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales	Trichomonascaceae	Sugiyamaella	Sugiyamaella lignohabitans
30755919	30755919	PRJNA454154_S_NODE_634_length_154_cov_1.188034_g631_i0	PRJNA454154	634	154	1.188034	1.82957236	Opisthokonta	33154	Fungi	Fungi	77.8	1.11e-16	NR	KAG4304737.1	42067	g631	i0	68	7.83116883116883	50	16	97.4	0	150	1	43	92	KAG4304737.1 hypothetical protein PORY_001790 [Pneumocystis oryctolagi]	diamond	1206	78.2	0.994884910485933	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pneumocystomycetes	Pneumocystales	Pneumocystaceae	Pneumocystis	Pneumocystis oryctolagi
32020632	32020632	PRJNA454154_S_NODE_298_length_197_cov_3.056250_g295_i0	PRJNA454154	298	197	3.05625	6.0208125	Fungi	4751	Fungi	Fungi	62	2.55e-10	NR	KAF8422077.1	160517	g295	i0	71.1	16.4467005076142	45	13	68.5	0	196	62	79	123	KAF8422077.1 ribosomal L29 protein-domain-containing protein [Tirmania nivea]	diamond	3240	62	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Pezizaceae	Tirmania	Tirmania nivea

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