metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax_phylum = "Mucoromycota"

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
8081277	8081277	PRJNA431371_P_NODE_13907_length_341_cov_0.951493_g13834_i0	PRJNA431371	13907	341	0.951493	3.24459113	Rhizopus microsporus	58291	Fungi	Fungi	126	1.87e-24	NTclustered	gi\|1331194877\|ref\|XM_023608490.1\|	1340429	g13834	i0	84.375	5.82991202346041	128	20	38	0	144	271	197	324	Rhizopus microsporus ATCC 52813 ribosomal protein 60S (RHIMIDRAFT_236167), partial mRNA	blastn	1988	126	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
9356163	9356163	PRJNA431371_P_NODE_1388_length_843_cov_1.938961_g1323_i0	PRJNA431371	1388	843	1.938961	16.34544123	Phycomyces blakesleeanus	4837	Fungi	Fungi	492	4.22e-134	NTclustered	gi\|1069963941\|ref\|XM_018434159.1\|	763407	g1323	i0	78.674	32.0094899169632	769	142	90	20	33	787	938	178	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	26984	492	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
15730632	15730632	PRJNA431371_P_NODE_14773_length_332_cov_1.189189_g14700_i0	PRJNA431371	14773	332	1.189189	3.94810748	Mycotypha africana	64632	Fungi	Fungi	237	8.04e-58	NTclustered	gi\|2432559218\|ref\|XM_053077043.1\|	64632	g14700	i0	79.641	26.0120481927711	334	64	100	4	1	332	437	106	Mycotypha africana ADP-ribosylation factor (BDF20DRAFT_815080), partial mRNA	blastn	8636	237	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
15731129	15731129	PRJNA431371_P_NODE_5633_length_507_cov_2.917051_g5560_i0	PRJNA431371	5633	507	2.917051	14.78944857	Cokeromyces recurvatus	90255	Fungi	Fungi	305	3.45e-78	NTclustered	gi\|2324087667\|ref\|XM_051530092.1\|	90255	g5560	i0	79.015	12.6331360946746	467	82	91	11	1	459	65	523	Cokeromyces recurvatus putative ribosomal protein L10 (BX663DRAFT_527823), partial mRNA	blastn	6405	305	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
16390630	16390630	PRJNA431371_P_NODE_5853_length_499_cov_1.739437_g5780_i0	PRJNA431371	5853	499	1.739437	8.67979063	Fungi	4751	Fungi	Fungi	324	9.36e-84	NTclustered	gi\|2432173028\|ref\|XM_053123822.1\|	64656	g5780	i0	79.362	52.248496993988	470	89	93	7	1	466	163	628	Zychaea mexicana ADP-ribosylation factor (BDB00DRAFT_827935), mRNA	blastn	26072	324	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana

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