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

5 rows where analysis = "blastn", bioproject = "PRJNA770361" 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
746242	746242	PRJNA770361_P_NODE_11361_length_280_cov_1.120773_g11266_i0	PRJNA770361	11361	280	1.120773	3.1381644	Zychaea mexicana	64656	Fungi	Fungi	58.4	5.55e-4	NTclustered	gi\|2432135667\|ref\|XM_053128783.1\|	64656	g11266	i0	100	1.11071428571429	31	0	11	0	1	31	2440	2470	Zychaea mexicana uncharacterized protein (BDB00DRAFT_924655), partial mRNA	blastn	311	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
4574624	4574624	PRJNA770361_P_NODE_16444_length_247_cov_0.896552_g16349_i0	PRJNA770361	16444	247	0.896552	2.21448344	Umbelopsis ramanniana	41833	Fungi	Fungi	207	4.4999999999999994e-49	NTclustered	gi\|2323687859\|ref\|XM_051588854.1\|	1314678	g16349	i0	81.928	80.5344129554656	249	41	100	4	1	247	472	718	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_239961), mRNA	blastn	19892	207	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
8859545	8859545	PRJNA770361_P_NODE_5187_length_413_cov_1.688235_g5092_i0	PRJNA770361	5187	413	1.688235	6.97241055	Fungi	4751	Fungi	Fungi	248	4.72e-61	NTclustered	gi\|2432162706\|ref\|XM_053128187.1\|	64656	g5092	i0	82.456	32.2832929782082	285	48	69	2	3	286	369	86	Zychaea mexicana ribosomal protein S11-domain-containing protein (BDB00DRAFT_882879), partial mRNA	blastn	13333	248	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
9674918	9674918	PRJNA770361_P_NODE_7508_length_343_cov_1.155556_g7413_i0	PRJNA770361	7508	343	1.155556	3.96355708	Gamsiella multidivaricata	101098	Fungi	Fungi	246	1.39e-60	NTclustered	gi\|2323763537\|ref\|XM_051553260.1\|	101098	g7413	i0	80.878	39.2069970845481	319	55	92	6	28	343	834	1149	Gamsiella multidivaricata fructose-bisphosphate aldolase, class II (BC939DRAFT_433702), mRNA	blastn	13448	246	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
23699400	23699400	PRJNA770361_P_NODE_6159_length_377_cov_3.476974_g6064_i0	PRJNA770361	6159	377	3.476974	13.10819198	Lichtheimia ornata	688661	Fungi	Fungi	67.6	1.28e-6	NTclustered	gi\|2553570039\|ref\|XM_058484812.1\|	688661	g6064	i0	95.238	3.36074270557029	42	2	11	0	177	218	318	277	Lichtheimia ornata uncharacterized protein (O0I10_004760), partial mRNA	blastn	1267	67.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata

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