metadata: contig_metadata: 10 rows where bioproject = "PRJNA1245487", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA1245487", tax_clade = "Sar" and tax_phylum = "Endomyxa"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11829721	11829721	PRJNA1245487_P_NODE_18590_length_257_cov_1.385870_g18252_i0	PRJNA1245487	18590	257	1.38587	3.5616859	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	108	6.3099999999999996e-27	NR	CEO97184.1	37360	g18252	i0	67.1	0.992217898832685	85	25	99.2	2	255	1	18	99	CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae]	diamond	255	108	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
20752579	20752579	PRJNA1245487_P_NODE_16117_length_280_cov_1.227053_g15779_i0	PRJNA1245487	16117	280	1.227053	3.4357484	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	135	4.079999999999999e-37	NR	CEO96095.1	37360	g15779	i0	59.1	0.996428571428571	93	38	99.6	0	1	279	79	171	CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae]	diamond	279	135	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28589630	28589630	PRJNA1245487_P_NODE_19547_length_251_cov_1.314607_g19209_i0	PRJNA1245487	19547	251	1.314607	3.29966357	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	64.3	7.84e-10	NR	CEO98723.1	37360	g19209	i0	41.3	0.956175298804781	80	40	95.6	1	242	3	161	233	CEO98723.1 hypothetical protein PBRA_006837 [Plasmodiophora brassicae]	diamond	240	64.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28639350	28639350	PRJNA1245487_P_NODE_15647_length_285_cov_1.471698_g15309_i0	PRJNA1245487	15647	285	1.471698	4.1943393	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	121	7.11e-33	NR	CEO99151.1	37360	g15309	i0	70.2	19.5684210526316	84	25	88.4	0	33	284	3	86	CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae]	diamond	5577	122	0.991803278688525	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29473259	29473259	PRJNA1245487_P_NODE_12950_length_321_cov_1.858871_g12612_i0	PRJNA1245487	12950	321	1.858871	5.96697591	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	79.3	1.32e-14	NR	CEO98408.1	37360	g12612	i0	41.7	1.00934579439252	108	59	100	2	1	321	295	399	CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae]	diamond	324	79.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29870544	29870544	PRJNA1245487_P_NODE_17091_length_270_cov_1.492386_g16753_i0	PRJNA1245487	17091	270	1.492386	4.0294422	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	121	4.649999999999999e-31	NR	SPR01659.1	37360	g16753	i0	64	2.96666666666667	89	32	98.9	0	269	3	9	97	SPR01659.1 unnamed protein product [Plasmodiophora brassicae]	diamond	801	122	0.991803278688525	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30958382	30958382	PRJNA1245487_P_NODE_14494_length_298_cov_1.733333_g14156_i0	PRJNA1245487	14494	298	1.733333	5.16533234	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	91.3	1.79e-19	NR	CEO97682.1	37360	g14156	i0	48	2.01342281879195	100	50	99.7	2	1	297	200	298	CEO97682.1 hypothetical protein PBRA_005796 [Plasmodiophora brassicae]	diamond	600	91.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31970105	31970105	PRJNA1245487_P_NODE_12278_length_332_cov_1.621622_g11940_i0	PRJNA1245487	12278	332	1.621622	5.38378504	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	157	4.97e-46	NR	CEP01997.1	37360	g11940	i0	75.8	0.894578313253012	99	24	89.5	0	298	2	1	99	CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae]	diamond	297	157	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32602827	32602827	PRJNA1245487_P_NODE_11500_length_346_cov_2.098901_g11162_i0	PRJNA1245487	11500	346	2.098901	7.26219746	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	154	8.77e-45	NR	CEP03344.1	37360	g11162	i0	65.2	0.997109826589595	115	40	99.7	0	2	346	73	187	CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae]	diamond	345	154	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32665666	32665666	PRJNA1245487_P_NODE_3340_length_684_cov_1.579378_g3015_i0	PRJNA1245487	3340	684	1.579378	10.80294552	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	223	2.93e-65	NR	CEO95180.1	37360	g3015	i0	51.1	1.98245614035088	227	106	99.6	3	682	2	286	507	CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae]	diamond	1356	223	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae

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