metadata: contig_metadata: 8 rows where bioproject = "PRJNA401346" and tax

8 rows where bioproject = "PRJNA401346" 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
3631922	3631922	PRJNA401346_P_NODE_3783_length_270_cov_4.799043_g3762_i0	PRJNA401346	3783	270	4.799043	12.9574161	Fungi	4751	Fungi	Fungi	121	6.689999999999999e-23	NTclustered	gi\|2432138713\|ref\|XM_053107478.1\|	110093	g3762	i0	84.252	9.62962962962963	127	16	46	3	6	130	24	148	Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA	blastn	2600	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
5517907	5517907	PRJNA401346_P_NODE_1425_length_400_cov_1.238938_g1404_i0	PRJNA401346	1425	400	1.238938	4.955752	Polychytrium aggregatum	110093	Fungi	Fungi	187	1.0099999999999999e-42	NTclustered	gi\|2432157378\|ref\|XM_053107751.1\|	110093	g1404	i0	76.438	3.6425	365	75	90	9	7	364	547	187	Polychytrium aggregatum ribosomal protein L6, alpha-beta domain-containing protein (BJ171DRAFT_426015), partial mRNA	blastn	1457	187	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
24640536	24640536	PRJNA401346_P_NODE_1680_length_375_cov_4.308917_g1659_i0	PRJNA401346	1680	375	4.308917	16.15843875	Fungi	4751	Fungi	Fungi	139	3.26e-40	NR	XP_052971640.1	110093	g1659	i0	77.9	20.248	86	19	68.8	0	355	98	4	89	XP_052971640.1 60S ribosomal protein L37 [Polychytrium aggregatum]	diamond	7593	140	0.992857142857143	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
25307238	25307238	PRJNA401346_P_NODE_1940_length_354_cov_1.225256_g1919_i0	PRJNA401346	1940	354	1.225256	4.33740624	Opisthokonta	33154	Fungi	Fungi	95.9	4.82e-22	NR	KAI9031166.1	82268	g1919	i0	62.2	3.6271186440678	74	25	61	2	2	217	85	157	KAI9031166.1 putative ubiquitin/ribosomal protein S27a fusion protein [Hyaloraphidium curvatum]	diamond	1284	95.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
27976503	27976503	PRJNA401346_P_NODE_6805_length_207_cov_1.753425_g6784_i0	PRJNA401346	6805	207	1.753425	3.62958975	Rhizophydiales	451442	Fungi	Fungi	98.6	8.1e-23	NR	KAJ3081187.1	2654861	g6784	i0	73.8	11.768115942029	61	16	88.4	0	3	185	210	270	KAJ3081187.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Quaeritorhiza haematococci]	diamond	2436	98.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci
29949113	29949113	PRJNA401346_P_NODE_7811_length_204_cov_0.895105_g7790_i0	PRJNA401346	7811	204	0.895105	1.8260142	Rhizophlyctis rosea	64517	Fungi	Fungi	54.3	8.74e-7	NR	KAJ3036186.1	64517	g7790	i0	54.7	3.08823529411765	53	21	77.9	2	200	42	141	190	KAJ3036186.1 Ubiquitin carboxyl-terminal hydrolase isozyme L3, partial [Rhizophlyctis rosea]	diamond	630	54.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
31197563	31197563	PRJNA401346_P_NODE_7535_length_205_cov_0.888889_g7514_i0	PRJNA401346	7535	205	0.888889	1.82222245	Fungi	4751	Fungi	Fungi	112	4.92e-27	NR	KAJ3402983.1	4814	g7514	i0	67.6	11.9414634146341	68	22	99.5	0	204	1	289	356	KAJ3402983.1 pre-mRNA-processing factor 17 [Chytriomyces hyalinus]	diamond	2448	112	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces hyalinus
31402811	31402811	PRJNA401346_P_NODE_5956_length_215_cov_1.181818_g5935_i0	PRJNA401346	5956	215	1.181818	2.5409087	Synchytrium microbalum	1806994	Fungi	Fungi	62	4.08e-9	NR	XP_031026017.1	1806994	g5935	i0	52.2	8.83255813953488	67	27	86.5	2	214	29	379	445	XP_031026017.1 uncharacterized protein SmJEL517_g02067 [Synchytrium microbalum]	diamond	1899	62	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum

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