metadata: contig_metadata: 9 rows where bioproject = "PRJNA342843" and tax

9 rows where bioproject = "PRJNA342843" 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
4898118	4898118	PRJNA342843_S_NODE_11644_length_178_cov_6.124088_g11494_i0	PRJNA342843	11644	178	6.124088	10.90087664	root	1	Root_unresolved	Root_unresolved	324	2.89e-84	NTclustered	gi\|2582615798\|ref\|XR_009468002.1\|	5061	g11494	i0	100	98.4494382022472	175	0	98	0	4	178	2793	2619	Aspergillus niger 28S ribosomal RNA (28S rRNA), partial rRNA	blastn	17524	324	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus niger
4898149	4898149	PRJNA342843_S_NODE_15344_length_152_cov_1.432432_g15194_i0	PRJNA342843	15344	152	1.432432	2.17729664	root	1	Root_unresolved	Root_unresolved	281	1.46e-71	NTclustered	gi\|283827952\|gb\|EU019262.2\|	29917	g15194	i0	100	99.9276315789474	152	0	100	0	1	152	2571	2420	Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence	blastn	15189	281	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
6173165	6173165	PRJNA342843_S_NODE_10565_length_190_cov_1.812081_g10415_i0	PRJNA342843	10565	190	1.812081	3.4429539	Penicillium	5073	Fungi	Fungi	318	1.46e-82	NTclustered	gi\|1395777247\|gb\|MH443374.1\|	5081	g10415	i0	96.859	100.478947368421	191	5	100	1	1	190	1031	841	Penicillium sp. strain ERL13-5 large subunit ribosomal RNA gene, partial sequence	blastn	19091	318	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium sp.
12548790	12548790	PRJNA342843_S_NODE_11330_length_182_cov_1.148936_g11180_i0	PRJNA342843	11330	182	1.148936	2.09106352	Hypocreales	5125	Fungi	Fungi	209	8.68e-50	NTclustered	gi\|2749493244\|gb\|PP952401.1\|	51453	g11180	i0	87.432	100.450549450549	183	22	100	1	1	182	7896	8078	Trichoderma reesei mitochondrion, complete genome	blastn	18282	211	0.990521327014218	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma reesei
12548801	12548801	PRJNA342843_S_NODE_12310_length_173_cov_1.000000_g12160_i0	PRJNA342843	12310	173	1	1.73	Saccharomyces	4930	Fungi	Fungi	320	3.61e-83	NTclustered	gi\|488162\|gb\|U00062.1\|YSCH8179	4932	g12160	i0	100	8.97687861271676	173	0	100	0	1	173	38785	38613	Saccharomyces cerevisiae chromosome VIII cosmid 8179	blastn	1553	320	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
17647969	17647969	PRJNA342843_S_NODE_7854_length_230_cov_1.185185_g7704_i0	PRJNA342843	7854	230	1.185185	2.7259255	Nectriaceae	110618	Fungi	Fungi	359	1.0799999999999999e-94	NTclustered	gi\|1859735559\|gb\|MT644877.1\|	29855	g7704	i0	94.783	100.008695652174	230	12	100	0	1	230	3620	3849	Nectria cinnabarina isolate DM1152 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	23002	359	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Nectria	Nectria cinnabarina
20196355	20196355	PRJNA342843_S_NODE_12936_length_168_cov_0.968504_g12786_i0	PRJNA342843	12936	168	0.968504	1.62708672	Parengyodontium	1892809	Fungi	Fungi	122	1.06e-23	NTclustered	gi\|1125812533\|ref\|NC_032302.1\|	37998	g12786	i0	97.222	0.857142857142857	72	2	43	0	12	83	4754	4825	Parengyodontium album voucher ATCC:56482 mitochondrion, complete genome	blastn	144	122	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Parengyodontium	Parengyodontium album
22747166	22747166	PRJNA342843_S_NODE_10058_length_196_cov_1.283871_g9908_i0	PRJNA342843	10058	196	1.283871	2.51638716	Fusarium	5506	Fungi	Fungi	363	6.899999999999998e-96	NTclustered	gi\|270741092\|gb\|FJ883667.1\|	698999	g9908	i0	100	99.9081632653061	196	0	100	0	1	196	228	33	Fusarium sp. DB 40 28S ribosomal RNA gene, partial sequence; 28S-18S ribosomal RNA intergenic spacer, complete sequence; and 18S ribosomal RNA gene, partial sequence	blastn	19582	363	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium sp. DB 40
25296508	25296508	PRJNA342843_S_NODE_13620_length_163_cov_1.196721_g13470_i0	PRJNA342843	13620	163	1.196721	1.95065523	Fusarium	5506	Fungi	Fungi	241	2.7000000000000008e-59	NTclustered	gi\|1839127146\|gb\|MT010921.1\|	48493	g13470	i0	93.252	94.2515337423313	163	11	100	0	1	163	22131	21969	Fusarium lactis culture CBS:411.97 strain CBS 411.97 mitochondrion, complete genome	blastn	15363	241	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium lactis

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