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

5 rows where bioproject = "PRJNA1085664" 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
193542	193542	PRJNA1085664_S_NODE_26221_length_172_cov_5.224806_g25802_i0	PRJNA1085664	26221	172	5.224806	8.98666632	Ascoidea rubescens	54195	Fungi	Fungi	60.2	8.62e-5	NTclustered	gi\|1147181152\|ref\|XM_020192680.1\|	1344418	g25802	i0	94.737	0.22093023255814	38	2	22	0	96	133	2735	2772	Ascoidea rubescens DSM 1968 uncharacterized protein (ASCRUDRAFT_74425), mRNA	blastn	38	60.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Ascoideaceae	Ascoidea	Ascoidea rubescens
17595118	17595118	PRJNA1085664_S_NODE_18934_length_200_cov_1.426752_g18515_i0	PRJNA1085664	18934	200	1.426752	2.853504	Mycosphaerellales	2726947	Fungi	Fungi	318	1.55e-82	NTclustered	gi\|284159107\|gb\|GU214694.1\|	438378	g18515	i0	95.5	100	200	7	100	1	1	200	4136	4333	Ramularia uredinicola strain CPC 10813 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	20000	318	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia uredinicola
21870349	21870349	PRJNA1085664_S_NODE_18878_length_200_cov_2.248408_g18459_i0	PRJNA1085664	18878	200	2.248408	4.496816	Penicilliopsis zonata	41063	Fungi	Fungi	110	1.02e-19	NTclustered	gi\|1249078766\|ref\|XM_022724715.1\|	1073090	g18459	i0	87.368	6.79	95	12	48	0	7	101	197	291	Penicilliopsis zonata CBS 506.65 hypothetical protein (ASPZODRAFT_141064), partial mRNA	blastn	1358	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicilliopsis	Penicilliopsis zonata
27352216	27352216	PRJNA1085664_S_NODE_22443_length_185_cov_1.352113_g22024_i0	PRJNA1085664	22443	185	1.352113	2.50140905	Apiospora arundinis	335852	Fungi	Fungi	42.4	0.0225	NR	KAK6815822.1	335852	g22024	i0	41.2	0.827027027027027	51	21	68.1	1	39	164	132	182	KAK6815822.1 hypothetical protein PG987_016588 [Apiospora arundinis]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Apiosporaceae	Apiospora	Apiospora arundinis
29341278	29341278	PRJNA1085664_S_NODE_28229_length_167_cov_1.137097_g27810_i0	PRJNA1085664	28229	167	1.137097	1.89895199	Eutypa lata UCREL1	1287681	Fungi	Fungi	87	2.8e-18	NR	EMR61791.1	1287681	g27810	i0	93	0.772455089820359	43	3	77.2	0	3	131	416	458	EMR61791.1 putative major facilitator superfamily transporter protein [Eutypa lata UCREL1]	diamond	129	87	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Diatrypaceae	Eutypa	Eutypa lata

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