metadata: contig_metadata: 7 rows where bioproject = "PRJNA950981", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA950981", 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
2209143	2209143	PRJNA950981_P_NODE_12742_length_288_cov_1.451163_g12566_i0	PRJNA950981	12742	288	1.451163	4.17934944	Arachnula sp. CL12	862247	SAR_Eukaryotes	SAR_Eukaryotes	172	1.63e-49	NR	ADK90073.1	862247	g12566	i0	81.3	6	96	18	100	0	1	288	188	283	ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12]	diamond	1728	172	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
27657612	27657612	PRJNA950981_P_NODE_20724_length_244_cov_0.912281_g20548_i0	PRJNA950981	20724	244	0.912281	2.22596564	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	58.2	4.52e-8	NR	CEP01202.1	37360	g20548	i0	52.8	1.30327868852459	53	25	65.2	0	4	162	119	171	CEP01202.1 hypothetical protein PBRA_008514 [Plasmodiophora brassicae]	diamond	318	58.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30625697	30625697	PRJNA950981_P_NODE_18713_length_248_cov_1.200000_g18537_i0	PRJNA950981	18713	248	1.2	2.976	Bonamia ostreae	126728	SAR_Eukaryotes	SAR_Eukaryotes	58.5	2.18e-8	NR	MES1922792.1	126728	g18537	i0	34.6	2.92741935483871	81	46	89.5	1	232	11	63	143	MES1922792.1 DnaJ-related protein scj1 [Bonamia ostreae]	diamond	726	58.5	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae
31137693	31137693	PRJNA950981_P_NODE_2935_length_558_cov_2.237113_g2762_i0	PRJNA950981	2935	558	2.237113	12.48309054	root	1	Root_unresolved	Root_unresolved	293	2.23e-94	NR	CEO94801.1	37360	g2762	i0	79.5	51.7795698924731	185	38	99.5	0	3	557	101	285	CEO94801.1 hypothetical protein PBRA_003614 [Plasmodiophora brassicae]	diamond	28893	293	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31169345	31169345	PRJNA950981_P_NODE_3115_length_543_cov_2.536170_g2942_i0	PRJNA950981	3115	543	2.53617	13.7714031	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	187	1.24e-56	NR	CEP02281.1	37360	g2942	i0	57.8	7.03867403314917	180	73	99.4	2	3	542	6	182	CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae]	diamond	3822	187	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32111969	32111969	PRJNA950981_P_NODE_20678_length_244_cov_0.912281_g20502_i0	PRJNA950981	20678	244	0.912281	2.22596564	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	144	7.519999999999999e-38	NR	CEO98004.1	37360	g20502	i0	82.7	0.995901639344262	81	14	99.6	0	243	1	1550	1630	CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae]	diamond	243	144	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32869805	32869805	PRJNA950981_P_NODE_19460_length_247_cov_0.896552_g19284_i0	PRJNA950981	19460	247	0.896552	2.21448344	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	101	1.2099999999999999e-24	NR	CEP03344.1	37360	g19284	i0	67.7	0.789473684210526	65	21	78.9	0	2	196	126	190	CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae]	diamond	195	101	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);;