metadata: contig_metadata: 11 rows where bioproject = "PRJNA800090", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA800090", 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
17797907	17797907	PRJNA800090_P_NODE_143354_length_263_cov_1.005155_g141169_i0	PRJNA800090	143354	263	1.005155	2.64355765	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	86.7	7.68e-20	NR	CEP02593.1	37360	g141169	i0	60.9	2.36121673003802	69	27	78.7	0	2	208	36	104	CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae]	diamond	621	86.7	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
18649549	18649549	PRJNA800090_P_NODE_177075_length_234_cov_0.884848_g174890_i0	PRJNA800090	177075	234	0.884848	2.07054432	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	72.4	4.53e-13	NR	CEO97184.1	37360	g174890	i0	60.9	0.82051282051282	64	20	76.9	2	180	1	1	63	CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae]	diamond	192	72.4	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
19923223	19923223	PRJNA800090_P_NODE_105376_length_316_cov_1.020243_g103191_i0	PRJNA800090	105376	316	1.020243	3.22396788	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	145	1.9699999999999993e-40	NR	SPQ93792.1	37360	g103191	i0	72	2.65822784810127	93	26	88.3	0	23	301	156	248	SPQ93792.1 unnamed protein product [Plasmodiophora brassicae]	diamond	840	145	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
23749590	23749590	PRJNA800090_P_NODE_126459_length_283_cov_1.023364_g124274_i0	PRJNA800090	126459	283	1.023364	2.89612012	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	108	3.3e-25	NR	CEO95240.1	37360	g124274	i0	62.1	4.02826855123675	95	35	99.6	1	2	283	766	860	CEO95240.1 hypothetical protein PBRA_004006 [Plasmodiophora brassicae]	diamond	1140	108	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27085794	27085794	PRJNA800090_P_NODE_33402_length_655_cov_1.617747_g31278_i0	PRJNA800090	33402	655	1.617747	10.59624285	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	239	7.66e-72	NR	CEO97171.1	37360	g31278	i0	54.5	2.02442748091603	220	97	99.8	2	654	1	324	542	CEO97171.1 hypothetical protein PBRA_005775 [Plasmodiophora brassicae]	diamond	1326	239	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27947497	27947497	PRJNA800090_P_NODE_166305_length_241_cov_1.424419_g164120_i0	PRJNA800090	166305	241	1.424419	3.43284979	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	97.8	1.6000000000000002e-23	NR	CEO97031.1	37360	g164120	i0	58.7	11.1161825726141	75	31	93.4	0	3	227	103	177	CEO97031.1 hypothetical protein PBRA_005636 [Plasmodiophora brassicae]	diamond	2679	98.6	0.991886409736308	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28231336	28231336	PRJNA800090_P_NODE_126906_length_282_cov_1.713615_g124721_i0	PRJNA800090	126906	282	1.713615	4.8323943	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	71.2	3.69e-12	NR	CEO99909.1	37360	g124721	i0	76.2	1.30851063829787	42	10	44.7	0	282	157	278	319	CEO99909.1 hypothetical protein PBRA_007643 [Plasmodiophora brassicae]	diamond	369	71.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29462639	29462639	PRJNA800090_P_NODE_170990_length_237_cov_1.166667_g168805_i0	PRJNA800090	170990	237	1.166667	2.76500079	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	2.05e-18	NR	CEP03344.1	37360	g168805	i0	56.6	1.89873417721519	76	33	96.2	0	233	6	3	78	CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae]	diamond	450	85.9	0.990686845168801	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29548599	29548599	PRJNA800090_P_NODE_165150_length_242_cov_1.618497_g162965_i0	PRJNA800090	165150	242	1.618497	3.91676274	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	53.5	5.46e-6	NR	SPQ93497.1	37360	g162965	i0	44.4	1.56198347107438	63	25	76.9	3	6	191	301	354	SPQ93497.1 unnamed protein product [Plasmodiophora brassicae]	diamond	378	53.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30180390	30180390	PRJNA800090_P_NODE_148032_length_258_cov_1.523810_g145847_i0	PRJNA800090	148032	258	1.52381	3.9314298	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	124	1.18e-34	NR	CEP03336.1	37360	g145847	i0	76.9	1.80232558139535	78	18	90.7	0	234	1	7	84	CEP03336.1 hypothetical protein PBRA_003096 [Plasmodiophora brassicae]	diamond	465	124	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30252788	30252788	PRJNA800090_P_NODE_192612_length_228_cov_0.918239_g190427_i0	PRJNA800090	192612	228	0.918239	2.09358492	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	112	8.61e-30	NR	CEP00725.1	37360	g190427	i0	71.6	7.84210526315789	74	21	97.4	0	226	5	4	77	CEP00725.1 hypothetical protein PBRA_001779 [Plasmodiophora brassicae]	diamond	1788	112	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);;