metadata: contig_metadata: 8 rows where bioproject = "PRJNA789095", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA789095", tax_clade = "Opisthokonta" 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
16073494	16073494	PRJNA789095_P_NODE_52473_length_280_cov_1.487923_g51139_i0	PRJNA789095	52473	280	1.487923	4.1661844	Eukaryota	2759	Fungi	Fungi	154	7.05e-47	NR	XP_052966078.1	110093	g51139	i0	82.6	8.21785714285714	86	15	92.1	0	260	3	1	86	XP_052966078.1 60S ribosomal protein L37 [Polychytrium aggregatum]	diamond	2301	154	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
19898430	19898430	PRJNA789095_P_NODE_72956_length_244_cov_0.900585_g71622_i0	PRJNA789095	72956	244	0.900585	2.1974274	Fungi	4751	Fungi	Fungi	124	4.09e-33	NR	KAI8926684.1	281842	g71622	i0	72.8	22.733606557377	81	22	99.6	0	2	244	73	153	KAI8926684.1 ribosomal family S4e-domain-containing protein [Entophlyctis helioformis]	diamond	5547	124	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis helioformis
26895730	26895730	PRJNA789095_P_NODE_74841_length_242_cov_0.911243_g73507_i0	PRJNA789095	74841	242	0.911243	2.20520806	Gonapodya sp. JEL	2107737	Fungi	Fungi	97.4	2.1200000000000003e-21	NR	KAJ3341685.1	2725673	g73507	i0	63.8	0.991735537190083	80	24	99.2	1	242	3	117	191	KAJ3341685.1 hypothetical protein HDU93_004319 [Gonapodya sp. JEL0774]	diamond	240	97.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya sp. JEL0774
28736722	28736722	PRJNA789095_P_NODE_53907_length_277_cov_1.205882_g52573_i0	PRJNA789095	53907	277	1.205882	3.34029314	Chytridiomycota	4761	Fungi	Fungi	58.9	1.17e-7	NR	KAJ3109062.1	261098	g52573	i0	33.7	8.3826714801443991	83	55	89.9	0	1	249	662	744	KAJ3109062.1 hypothetical protein HDU97_009180 [Phlyctochytrium planicorne]	diamond	2322	59.3	0.993254637436762	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium planicorne
29043395	29043395	PRJNA789095_P_NODE_31368_length_375_cov_2.738411_g30035_i0	PRJNA789095	31368	375	2.738411	10.26904125	Hyaloraphidium curvatum	82268	Fungi	Fungi	47	7.77e-4	NR	KAI9002827.1	82268	g30035	i0	40.4	0.456	57	34	45.6	0	126	296	37	93	KAI9002827.1 hypothetical protein DFJ74DRAFT_695070 [Hyaloraphidium curvatum]	diamond	171	47	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
29484998	29484998	PRJNA789095_P_NODE_70810_length_246_cov_0.890173_g69476_i0	PRJNA789095	70810	246	0.890173	2.18982558	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	67.8	5.92e-11	NR	KAH9258068.1	1357716	g69476	i0	38.8	0.975609756097561	80	49	97.6	0	244	5	1311	1390	KAH9258068.1 hypothetical protein BASA81_003631 [Batrachochytrium salamandrivorans]	diamond	240	67.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30179987	30179987	PRJNA789095_P_NODE_70792_length_246_cov_0.890173_g69458_i0	PRJNA789095	70792	246	0.890173	2.18982558	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	45.4	0.00429	NR	KAH9260806.1	1357716	g69458	i0	35.2	1.07317073170732	88	38	96.3	5	240	4	32	109	KAH9260806.1 hypothetical protein BASA81_001273 [Batrachochytrium salamandrivorans]	diamond	264	45.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
31001679	31001679	PRJNA789095_P_NODE_66334_length_251_cov_0.865169_g65000_i0	PRJNA789095	66334	251	0.865169	2.17157419	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	83.6	1.8e-16	NR	KAH9254574.1	1357716	g65000	i0	50	0.908366533864542	76	38	90.8	0	230	3	1884	1959	KAH9254574.1 hypothetical protein BASA81_007331 [Batrachochytrium salamandrivorans]	diamond	228	83.6	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);;