metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
177171	177171	PRJNA1059246_P_NODE_45901_length_308_cov_1.140426_g45275_i0	PRJNA1059246	45901	308	1.140426	3.51251208	Polychytrium aggregatum	110093	Fungi	Fungi	209	1.61e-49	NTclustered	gi\|2432135035\|ref\|XM_053109818.1\|	110093	g45275	i0	79.1	12.2922077922078	311	59	100	6	1	308	1858	1551	Polychytrium aggregatum Aldehyde/histidinol dehydrogenase (BJ171DRAFT_492375), mRNA	blastn	3786	209	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
9104912	9104912	PRJNA1059246_P_NODE_58928_length_260_cov_1.486631_g58302_i0	PRJNA1059246	58928	260	1.486631	3.8652406	Fimicolochytrium jonesii	1396493	Fungi	Fungi	198	2.88e-46	NTclustered	gi\|2432057423\|ref\|XM_053069416.1\|	1396493	g58302	i0	82.128	35.45	235	39	89	3	21	252	828	594	Fimicolochytrium jonesii hsp71-like protein (EV422DRAFT_516945), mRNA	blastn	9217	198	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
12930521	12930521	PRJNA1059246_P_NODE_18751_length_529_cov_5.460526_g18134_i0	PRJNA1059246	18751	529	5.460526	28.88618254	Fimicolochytrium jonesii	1396493	Fungi	Fungi	357	9.82e-94	NTclustered	gi\|2432072949\|ref\|XM_053073468.1\|	1396493	g18134	i0	81.306	88.2759924385633	444	79	84	4	58	499	688	247	Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA	blastn	46698	357	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
12930539	12930539	PRJNA1059246_P_NODE_20031_length_508_cov_4.993103_g19413_i0	PRJNA1059246	20031	508	4.993103	25.36496324	Synchytrium microbalum	1806994	Fungi	Fungi	411	7.119999999999999e-110	NTclustered	gi\|1759154564\|ref\|XM_031169821.1\|	1806994	g19413	i0	83.447	85.3582677165354	441	73	87	0	58	498	453	13	Synchytrium microbalum uncharacterized protein (SmJEL517_g03893), partial mRNA	blastn	43362	411	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium microbalum
16754042	16754042	PRJNA1059246_P_NODE_42794_length_322_cov_1.863454_g42168_i0	PRJNA1059246	42794	322	1.863454	6.00032188	Polychytrium aggregatum	110093	Fungi	Fungi	189	2.2099999999999993e-43	NTclustered	gi\|2432155310\|ref\|XM_053111519.1\|	110093	g42168	i0	82.407	46.2267080745342	216	38	67	0	3	218	193	408	Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA	blastn	14885	189	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
20137935	20137935	PRJNA1059246_P_NODE_46656_length_304_cov_1.774892_g46030_i0	PRJNA1059246	46656	304	1.774892	5.39567168	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|2432131855\|ref\|XM_053109379.1\|	110093	g46030	i0	100	0.190789473684211	29	0	10	0	106	134	4041	4013	Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_488495), mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
20578008	20578008	PRJNA1059246_P_NODE_27357_length_423_cov_2.088571_g26732_i0	PRJNA1059246	27357	423	2.088571	8.83465533	Polychytrium aggregatum	110093	Fungi	Fungi	198	4.95e-46	NTclustered	gi\|2432152064\|ref\|XM_053105682.1\|	110093	g26732	i0	79.016	55.7446808510638	305	52	71	8	17	315	358	656	Polychytrium aggregatum ribosomal protein L10e/L16 (BJ171DRAFT_137240), mRNA	blastn	23580	198	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
21854111	21854111	PRJNA1059246_P_NODE_54478_length_275_cov_1.930693_g53852_i0	PRJNA1059246	54478	275	1.930693	5.30940575	Fimicolochytrium jonesii	1396493	Fungi	Fungi	122	1.9e-23	NTclustered	gi\|2432058563\|ref\|XM_053065718.1\|	1396493	g53852	i0	79.651	2.97818181818182	172	33	62	2	104	274	80	250	Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA	blastn	819	122	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
24402881	24402881	PRJNA1059246_P_NODE_26640_length_430_cov_1.630252_g26015_i0	PRJNA1059246	26640	430	1.630252	7.0100836	Polychytrium aggregatum	110093	Fungi	Fungi	152	3.98e-32	NTclustered	gi\|2432132805\|ref\|XM_053109589.1\|	110093	g26015	i0	81.622	0.816279069767442	185	32	43	2	247	430	627	444	Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_490208), mRNA	blastn	351	152	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum

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