metadata: contig_metadata: 4 rows where bioproject = "PRJNA1196438", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA1196438", tax_kingdom = "Fungi" and tax_phylum = "Chytridiomycota"

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
26755782	26755782	PRJNA1196438_P_NODE_67261_length_250_cov_0.881356_g66834_i0	PRJNA1196438	67261	250	0.881356	2.20339	Polychytrium aggregatum	110093	Fungi	Fungi	44.7	0.00812	NR	XP_052962884.1	110093	g66834	i0	35.3	1.152	68	42	81.6	1	243	40	28	93	XP_052962884.1 uncharacterized protein BJ171DRAFT_229782 [Polychytrium aggregatum]	diamond	288	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
28525399	28525399	PRJNA1196438_P_NODE_64727_length_252_cov_1.737430_g64300_i0	PRJNA1196438	64727	252	1.73743	4.3783236	Gonapodya sp. JEL	2107737	Fungi	Fungi	43.5	0.023	NR	KAJ3328791.1	2725673	g64300	i0	51.7	0.345238095238095	29	14	34.5	0	237	151	499	527	KAJ3328791.1 Leucine-rich repeat serine/threonine-protein kinase 2 [Gonapodya sp. JEL0774]	diamond	87	43.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya sp. JEL0774
29251246	29251246	PRJNA1196438_P_NODE_72829_length_245_cov_0.906977_g72402_i0	PRJNA1196438	72829	245	0.906977	2.22209365	Piromyces finnis	1754191	Fungi	Fungi	43.5	0.017	NR	ORX47904.1	1754191	g72402	i0	29.9	0.942857142857143	77	39	94.3	1	235	5	72	133	ORX47904.1 LIM-domain-containing protein [Piromyces finnis]	diamond	231	43.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Piromyces	Piromyces finnis
30565013	30565013	PRJNA1196438_P_NODE_73893_length_244_cov_0.912281_g73466_i0	PRJNA1196438	73893	244	0.912281	2.22596564	Opisthokonta	33154	Fungi	Fungi	44.7	0.00816	NR	KAJ3029212.1	64517	g73466	i0	39.1	8.87704918032787	92	44	98.4	3	2	241	561	652	KAJ3029212.1 AP-2 complex subunit beta [Rhizophlyctis rosea]	diamond	2166	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea

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