metadata: contig_metadata: 5 rows where bioproject = "PRJNA169559", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA169559", 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
15668042	15668042	PRJNA169559_P_NODE_6313_length_676_cov_43.783617_g4862_i0	PRJNA169559	6313	676	43.783617	295.97725092	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	226	1.56e-71	NR	CEP02281.1	37360	g4862	i0	59.8	5.48520710059172	204	79	90.5	2	670	59	1	201	CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae]	diamond	3708	226	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
20766530	20766530	PRJNA169559_P_NODE_27657_length_278_cov_3.393574_g25581_i0	PRJNA169559	27657	278	3.393574	9.43413572	Arachnula sp. CL12	862247	SAR_Eukaryotes	SAR_Eukaryotes	151	1.25e-41	NR	ADK90073.1	862247	g25581	i0	69.2	5.89208633093525	91	28	98.2	0	1	273	293	383	ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12]	diamond	1638	151	1	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
28481346	28481346	PRJNA169559_P_NODE_8086_length_597_cov_1.952465_g6479_i0	PRJNA169559	8086	597	1.952465	11.65621605	root	1	Root_unresolved	Root_unresolved	102	2.0500000000000003e-21	NR	CEP00208.1	37360	g6479	i0	35.6	7.04020100502513	202	111	99.5	4	2	595	875	1061	CEP00208.1 hypothetical protein PBRA_007942 [Plasmodiophora brassicae]	diamond	4203	103	0.990291262135922	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30390314	30390314	PRJNA169559_P_NODE_31653_length_258_cov_1.676856_g29577_i0	PRJNA169559	31653	258	1.676856	4.32628848	Bonamia ostreae	126728	SAR_Eukaryotes	SAR_Eukaryotes	50.1	2.5e-5	NR	MES1919336.1	126728	g29577	i0	76.7	0.709302325581395	30	7	34.9	0	255	166	89	118	MES1919336.1 hypothetical protein [Bonamia ostreae]	diamond	183	50.1	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae
31165680	31165680	PRJNA169559_P_NODE_30235_length_264_cov_1.425532_g28159_i0	PRJNA169559	30235	264	1.425532	3.76340448	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0186	NR	CEP02185.1	37360	g28159	i0	82.6	3.77272727272727	23	4	26.1	0	190	258	104	126	CEP02185.1 hypothetical protein PBRA_002450 [Plasmodiophora brassicae]	diamond	996	43.9	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);;