metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA976345" 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
17526757	17526757	PRJNA976345_P_NODE_6114_length_737_cov_108.233618_g4779_i0	PRJNA976345	6114	737	108.233618	797.68176466	Blyttiomyces helicus	388810	Fungi	Fungi	58.9	1.61e-6	NR	RKO83586.1	388810	g4779	i0	44.4	0.256445047489824	63	34	25.2	1	403	588	107	169	RKO83586.1 hypothetical protein BDK51DRAFT_23192, partial [Blyttiomyces helicus]	diamond	189	58.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces helicus
26645957	26645957	PRJNA976345_P_NODE_44081_length_261_cov_1.575221_g42473_i0	PRJNA976345	44081	261	1.575221	4.1113268100000004	Chytriomyces sp. MP71	1882861	Fungi	Fungi	62.8	1.43e-9	NR	KAI8620744.1	1882861	g42473	i0	43.8	0.735632183908046	64	27	73.6	2	193	2	159	213	KAI8620744.1 hypothetical protein BC830DRAFT_1097358 [Chytriomyces sp. MP71]	diamond	192	62.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces sp. MP71
29047246	29047246	PRJNA976345_P_NODE_11788_length_500_cov_2.301075_g10237_i0	PRJNA976345	11788	500	2.301075	11.505375	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	60.1	3.67e-7	NR	KAH9250866.1	1357716	g10237	i0	42.9	0.42	70	39	42	1	291	500	236	304	KAH9250866.1 hypothetical protein BASA81_011254 [Batrachochytrium salamandrivorans]	diamond	210	60.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30500038	30500038	PRJNA976345_P_NODE_63093_length_225_cov_1.973684_g61485_i0	PRJNA976345	63093	225	1.973684	4.440789	Gonapodya sp. JEL	2107737	Fungi	Fungi	76.6	3.1e-16	NR	KAJ3340834.1	2725673	g61485	i0	80	1.82666666666667	45	9	60	0	1	135	41	85	KAJ3340834.1 60S ribosomal protein L37 [Gonapodya sp. JEL0774]	diamond	411	76.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya sp. JEL0774
32781859	32781859	PRJNA976345_P_NODE_197740_length_150_cov_2.173913_g196132_i0	PRJNA976345	197740	150	2.173913	3.2608695	Neocallimastix	4756	Fungi	Fungi	50.1	2.79e-5	NR	ORY79220.1	1754190	g196132	i0	45.8	1.92	48	26	96	0	150	7	1831	1878	ORY79220.1 hypothetical protein LY90DRAFT_664829 [Neocallimastix californiae]	diamond	288	50.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Neocallimastix	Neocallimastix californiae

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