metadata: contig_metadata: 10 rows where bioproject = "PRJNA976345", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA976345", 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
948330	948330	PRJNA976345_P_NODE_28501_length_316_cov_1.964413_g26897_i0	PRJNA976345	28501	316	1.964413	6.20754508	Spizellomyces punctatus	109760	Fungi	Fungi	259	1.6200000000000003e-64	NTclustered	gi\|1027028346\|ref\|XM_016756817.1\|	645134	g26897	i0	82.653	21.9398734177215	294	49	93	2	24	316	1684	1392	Spizellomyces punctatus DAOM BR117 ADP,ATP carrier protein 1, mitochondrial, variant (SPPG_08669), partial mRNA	blastn	6933	259	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
4777068	4777068	PRJNA976345_P_NODE_75744_length_210_cov_1.908571_g74136_i0	PRJNA976345	75744	210	1.908571	4.0079991	Rhizophydium sp. JEL385	382560	Fungi	Fungi	355	1.25e-93	NTclustered	gi\|94995412\|gb\|DQ485560.1\|	382560	g74136	i0	97.143	98.6380952380952	210	6	100	0	1	210	237	28	Rhizophydium sp. JEL385 strain JEL-385 28S ribosomal RNA gene, partial sequence	blastn	20714	355	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Rhizophydiaceae	Rhizophydium	Rhizophydium sp. JEL385
8600778	8600778	PRJNA976345_P_NODE_145047_length_168_cov_2.338346_g143439_i0	PRJNA976345	145047	168	2.338346	3.92842128	Blyttiomyces helicus	388810	Fungi	Fungi	134	4.9000000000000005e-27	NTclustered	gi\|2177203077\|gb\|OM238190.1\|	388810	g143439	i0	81.287	71.7797619047619	171	26	100	4	1	168	1032	865	Blyttiomyces helicus strain Perch Fen small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	12059	134	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces helicus
9876281	9876281	PRJNA976345_P_NODE_18688_length_390_cov_2.450704_g17093_i0	PRJNA976345	18688	390	2.450704	9.5577456	Spizellomyces punctatus	109760	Fungi	Fungi	56.5	0.003	NTclustered	gi\|1026991975\|ref\|XM_016753480.1\|	645134	g17093	i0	96.97	0.0846153846153846	33	1	8	0	131	163	172	140	Spizellomyces punctatus DAOM BR117 ribosomal protein L29 (SPPG_05257), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
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
21350813	21350813	PRJNA976345_P_NODE_65157_length_222_cov_2.540107_g63549_i0	PRJNA976345	65157	222	2.540107	5.63903754	Synchytrium microbalum	1806994	Fungi	Fungi	56.5	0.002	NTclustered	gi\|1759143207\|ref\|XM_031166982.1\|	1806994	g63549	i0	100	0.765765765765766	30	0	14	0	60	89	2611	2582	Synchytrium microbalum uncharacterized protein (SmJEL517_g01054), partial mRNA	blastn	170	56.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
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);;