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

5 rows where bioproject = "PRJNA1199330", 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
27799287	27799287	PRJNA1199330_P_NODE_93844_length_259_cov_2.494624_g93145_i0	PRJNA1199330	93844	259	2.494624	6.46107616	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	51.2	4.63e-5	NR	CEO96066.1	37360	g93145	i0	44.4	1.81853281853282	72	36	82.2	3	258	46	272	340	CEO96066.1 hypothetical protein PBRA_004756 [Plasmodiophora brassicae]	diamond	471	51.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29251290	29251290	PRJNA1199330_P_NODE_51909_length_301_cov_2.640351_g51210_i0	PRJNA1199330	51909	301	2.640351	7.94745651	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	59.3	9.65e-8	NR	CEP02636.1	37360	g51210	i0	41.8	1.95348837209302	67	39	66.8	0	81	281	2	68	CEP02636.1 hypothetical protein PBRA_002603 [Plasmodiophora brassicae]	diamond	588	59.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30294127	30294127	PRJNA1199330_P_NODE_69172_length_282_cov_2.717703_g68473_i0	PRJNA1199330	69172	282	2.717703	7.66392246	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	119	3.4400000000000003e-29	NR	CEO94321.1	37360	g68473	i0	56.8	0.936170212765957	88	38	93.6	0	2	265	363	450	CEO94321.1 hypothetical protein PBRA_000107 [Plasmodiophora brassicae]	diamond	264	119	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32557851	32557851	PRJNA1199330_P_NODE_12919_length_573_cov_5.868000_g12239_i0	PRJNA1199330	12919	573	5.868	33.62364	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	108	6.12e-26	NR	SPQ99214.1	37360	g12239	i0	38.3	2.16230366492147	141	76	73.8	2	546	124	26	155	SPQ99214.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1239	109	0.990825688073395	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32903883	32903883	PRJNA1199330_P_NODE_11540_length_609_cov_6.438433_g10867_i0	PRJNA1199330	11540	609	6.438433	39.21005697	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	103	7.66e-24	NR	SPQ99214.1	37360	g10867	i0	37.9	3.47290640394089	140	76	69	2	567	148	27	155	SPQ99214.1 unnamed protein product [Plasmodiophora brassicae]	diamond	2115	104	0.990384615384615	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);;