metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA734348" and tax

6 rows where analysis = "diamond", 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
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);;