metadata: contig_metadata: 5 rows where bioproject = "PRJNA798511", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA798511", 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
26895947	26895947	PRJNA798511_P_NODE_100081_length_243_cov_0.905882_g95815_i0	PRJNA798511	100081	243	0.905882	2.20129326	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	46.2	0.00218	NR	KAH9274363.1	1357716	g95815	i0	39.5	1.87654320987654	76	34	80.2	2	211	17	210	284	KAH9274363.1 hypothetical protein BASA83_003361 [Batrachochytrium salamandrivorans]	diamond	456	46.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
27812312	27812312	PRJNA798511_P_NODE_75404_length_276_cov_4.463054_g71138_i0	PRJNA798511	75404	276	4.463054	12.31802904	Hyaloraphidium curvatum	82268	Fungi	Fungi	44.7	0.0111	NR	KAI9002993.1	82268	g71138	i0	27.5	0.989130434782609	91	47	81.5	3	49	273	174	261	KAI9002993.1 hypothetical protein DFJ74DRAFT_442765 [Hyaloraphidium curvatum]	diamond	273	44.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
28285439	28285439	PRJNA798511_P_NODE_48266_length_366_cov_1.313993_g44000_i0	PRJNA798511	48266	366	1.313993	4.80921438	Fimicolochytrium jonesii	1396493	Fungi	Fungi	143	1.27e-37	NR	XP_052927050.1	1396493	g44000	i0	59.5	3.9672131147541	121	48	98.4	1	365	6	327	447	XP_052927050.1 D-isomer specific 2-hydroxyacid dehydrogenase [Fimicolochytrium jonesii]	diamond	1452	143	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
30180222	30180222	PRJNA798511_P_NODE_31552_length_515_cov_0.993213_g27304_i0	PRJNA798511	31552	515	0.993213	5.11504695	Blyttiomyces helicus	388810	Fungi	Fungi	209	9.86e-62	NR	RKO85499.1	388810	g27304	i0	61.2	2.99417475728155	170	62	96.7	3	508	11	189	358	RKO85499.1 armadillo-type protein [Blyttiomyces helicus]	diamond	1542	209	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces helicus
31507866	31507866	PRJNA798511_P_NODE_98196_length_244_cov_0.900585_g93930_i0	PRJNA798511	98196	244	0.900585	2.1974274	Hyaloraphidium curvatum	82268	Fungi	Fungi	129	1.2599999999999999e-34	NR	KAI9026238.1	82268	g93930	i0	74.7	1.94262295081967	79	20	97.1	0	241	5	45	123	KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum]	diamond	474	129	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum

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