metadata: contig_metadata: 6 rows where bioproject = "PRJNA415856" and tax

6 rows where bioproject = "PRJNA415856" 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
27138362	27138362	PRJNA415856_P_NODE_9442_length_291_cov_2.053719_g9181_i0	PRJNA415856	9442	291	2.053719	5.97632229	Gaertneriomyces semiglobifer	109897	Fungi	Fungi	97.8	9.96e-24	NR	KAI9005300.1	109897	g9181	i0	60.9	4.55670103092783	87	34	89.7	0	264	4	2	88	KAI9005300.1 translation protein SH3-like domain-containing protein [Gaertneriomyces semiglobifer]	diamond	1326	97.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Gaertneriomyces	Gaertneriomyces semiglobifer
27959928	27959928	PRJNA415856_P_NODE_40145_length_165_cov_1.405172_g39884_i0	PRJNA415856	40145	165	1.405172	2.3185338	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	91.7	3.22e-20	NR	KAH9258597.1	1357716	g39884	i0	81.5	0.981818181818182	54	10	98.2	0	164	3	304	357	KAH9258597.1 hypothetical protein BASA81_003099 [Batrachochytrium salamandrivorans]	diamond	162	91.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
29632997	29632997	PRJNA415856_P_NODE_16330_length_215_cov_2.849398_g16069_i0	PRJNA415856	16330	215	2.849398	6.1262057	Fimicolochytrium jonesii	1396493	Fungi	Fungi	73.2	9.56e-14	NR	XP_052921473.1	1396493	g16069	i0	56.5	0.962790697674419	69	30	96.3	0	215	9	8	76	XP_052921473.1 Snf7-domain-containing protein [Fimicolochytrium jonesii]	diamond	207	73.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
30250412	30250412	PRJNA415856_P_NODE_29612_length_175_cov_1.531746_g29351_i0	PRJNA415856	29612	175	1.531746	2.6805555	Fungi	4751	Fungi	Fungi	47	4.65e-4	NR	KAI9011192.1	109897	g29351	i0	86.4	1.57714285714286	22	3	37.7	0	74	9	402	423	KAI9011192.1 S-adenosyl-L-methionine-dependent methyltransferase [Gaertneriomyces semiglobifer]	diamond	276	47.4	0.991561181434599	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Gaertneriomyces	Gaertneriomyces semiglobifer
30455083	30455083	PRJNA415856_P_NODE_4253_length_476_cov_2.384075_g3997_i0	PRJNA415856	4253	476	2.384075	11.348197	Rhizoclosmatium globosum	329046	Fungi	Fungi	47.4	0.00732	NR	ORY50952.1	329046	g3997	i0	38.3	0.510504201680672	81	42	47.9	2	458	231	197	274	ORY50952.1 hypothetical protein BCR33DRAFT_498941 [Rhizoclosmatium globosum]	diamond	243	47.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Rhizoclosmatium	Rhizoclosmatium globosum
30833857	30833857	PRJNA415856_P_NODE_44054_length_164_cov_0.886957_g43793_i0	PRJNA415856	44054	164	0.886957	1.45460948	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	93.2	2.14e-20	NR	KAH9261424.1	1357716	g43793	i0	90.6	0.969512195121951	53	5	97	0	159	1	257	309	KAH9261424.1 hypothetical protein BASA81_000068 [Batrachochytrium salamandrivorans]	diamond	159	93.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans

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