metadata: contig_metadata: 9 rows where bioproject = "PRJNA734348" and tax

9 rows where bioproject = "PRJNA734348" 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
717591	717591	PRJNA734348_P_NODE_148941_length_202_cov_9.713178_g148243_i0	PRJNA734348	148941	202	9.713178	19.62061956	Spizellomyces sp.	110146	Fungi	Fungi	106	1.33e-18	NTclustered	gi\|1866582619\|gb\|MT730794.1\|	110146	g148243	i0	76.887	49.2970297029703	212	34	100	13	1	202	4951	5157	Spizellomyces sp. isolate JEL0722 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	9958	106	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces sp.
12197574	12197574	PRJNA734348_P_NODE_42550_length_308_cov_3.178723_g41853_i0	PRJNA734348	42550	308	3.178723	9.79046684	Orpinomyces sp. OUS1	301046	Fungi	Fungi	119	2.7900000000000003e-22	NTclustered	gi\|55859492\|emb\|AJ864475.1\|	301046	g41853	i0	89.362	32.3441558441558	94	10	31	0	1	94	4631	4724	Orpinomyces sp. OUS1 partial 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and partial 28S rRNA, clone V5-1	blastn	9962	119	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Orpinomyces	Orpinomyces sp. OUS1
23670114	23670114	PRJNA734348_P_NODE_11899_length_656_cov_5.142367_g11248_i0	PRJNA734348	11899	656	5.142367	33.73392752	Piromyces sp.	45796	Fungi	Fungi	623	1.1e-173	NTclustered	gi\|1388116266\|gb\|MH043820.1\|	45796	g11248	i0	100	99.6615853658537	337	0	51	0	320	656	582	246	Piromyces sp. strain B5 Glycosyl hydrolase family 43 mRNA, partial cds	blastn	65378	623	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Piromyces	Piromyces sp.
27115456	27115456	PRJNA734348_P_NODE_62742_length_277_cov_1.225490_g62045_i0	PRJNA734348	62742	277	1.22549	3.3946073	Piromyces finnis	1754191	Fungi	Fungi	43.1	0.0426	NR	ORX43352.1	1754191	g62045	i0	28.9	0.974729241877256	90	61	94.2	1	271	11	471	560	ORX43352.1 hypothetical protein BCR36DRAFT_373851, partial [Piromyces finnis]	diamond	270	43.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Piromyces	Piromyces finnis
29999616	29999616	PRJNA734348_P_NODE_50371_length_289_cov_2.828704_g49674_i0	PRJNA734348	50371	289	2.828704	8.17495456	Eukaryota	2759	Fungi	Fungi	82.4	1.42e-17	NR	KAI9022518.1	82268	g49674	i0	65.5	4.02768166089965	55	19	57.1	0	210	46	1	55	KAI9022518.1 protein BUD31 [Hyaloraphidium curvatum]	diamond	1164	82.8	0.995169082125604	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
30062483	30062483	PRJNA734348_P_NODE_100811_length_249_cov_0.875000_g100113_i0	PRJNA734348	100811	249	0.875	2.17875	Chytridiomycetes	451435	Fungi	Fungi	93.6	5.27e-20	NR	KAJ3147480.1	109894	g100113	i0	54.3	9.75903614457831	81	37	97.6	0	247	5	2548	2628	KAJ3147480.1 Dynein heavy chain 1, axonemal [Geranomyces variabilis]	diamond	2430	93.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Geranomyces	Geranomyces variabilis
30589487	30589487	PRJNA734348_P_NODE_73953_length_266_cov_1.419689_g73255_i0	PRJNA734348	73953	266	1.419689	3.77637274	Fimicolochytrium jonesii	1396493	Fungi	Fungi	54.7	3.1e-6	NR	XP_052923198.1	1396493	g73255	i0	59	0.43984962406015	39	16	44	0	228	112	734	772	XP_052923198.1 E1-E2 ATPase-domain-containing protein [Fimicolochytrium jonesii]	diamond	117	54.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
30779148	30779148	PRJNA734348_P_NODE_149254_length_201_cov_5.398438_g148556_i0	PRJNA734348	149254	201	5.398438	10.85086038	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	94	4.980000000000001e-21	NR	KAH9254230.1	1357716	g148556	i0	70.1	4	67	17	100	2	1	201	204	267	KAH9254230.1 hypothetical protein BASA81_007831 [Batrachochytrium salamandrivorans]	diamond	804	94	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
32329062	32329062	PRJNA734348_P_NODE_91519_length_251_cov_1.674157_g90821_i0	PRJNA734348	91519	251	1.674157	4.20213407	Chytriomyces sp. MP71	1882861	Fungi	Fungi	80.1	2.08e-17	NR	KAI8609126.1	1882861	g90821	i0	61.7	6.51394422310757	60	23	71.7	0	72	251	25	84	KAI8609126.1 tryptophan synthase beta subunit-like PLP-dependent enzyme [Chytriomyces sp. MP71]	diamond	1635	80.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces sp. MP71

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