metadata: contig_metadata: 6 rows where bioproject = "PRJNA889065" and tax

6 rows where bioproject = "PRJNA889065" 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
4691786	4691786	PRJNA889065_S_NODE_29724_length_177_cov_1.343284_g29486_i0	PRJNA889065	29724	177	1.343284	2.37761268	Paramarteilia canceri	2844372	SAR_Eukaryotes	SAR_Eukaryotes	68.2	1.69e-11	NR	MES1902520.1	2844372	g29486	i0	53.7	0.915254237288136	54	25	91.5	0	177	16	551	604	MES1902520.1 Piwi-like protein 2 [Paramarteilia canceri]	diamond	162	68.2	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Paramyxida	Marteiliidae	Paramarteilia	Paramarteilia canceri
27276878	27276878	PRJNA889065_S_NODE_22043_length_207_cov_2.164634_g21805_i0	PRJNA889065	22043	207	2.164634	4.48079238	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	55.5	2.54e-7	NR	CEO98614.1	37360	g21805	i0	46.4	1	69	36	98.6	1	2	205	67	135	CEO98614.1 hypothetical protein PBRA_006727 [Plasmodiophora brassicae]	diamond	207	55.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27497996	27497996	PRJNA889065_S_NODE_6463_length_371_cov_4.027439_g6225_i0	PRJNA889065	6463	371	4.027439	14.94179869	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	113	2.92e-28	NR	SPR00426.1	37360	g6225	i0	49.5	1.76280323450135	109	50	87.3	2	6	329	129	233	SPR00426.1 unnamed protein product [Plasmodiophora brassicae]	diamond	654	113	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28381933	28381933	PRJNA889065_S_NODE_12266_length_275_cov_1.245690_g12028_i0	PRJNA889065	12266	275	1.24569	3.4256475	Marteilia pararefringens	2184066	SAR_Eukaryotes	SAR_Eukaryotes	51.6	1.78e-5	NR	MEN2495836.1	2184066	g12028	i0	45.9	0.665454545454545	61	33	66.5	0	4	186	92	152	MEN2495836.1 hypothetical protein [Marteilia pararefringens]	diamond	183	51.6	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Paramyxida	Marteiliidae	Marteilia	Marteilia pararefringens
28982087	28982087	PRJNA889065_S_NODE_18008_length_229_cov_1.951613_g17770_i0	PRJNA889065	18008	229	1.951613	4.46919377	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	48.5	2.81e-4	NR	SPQ97415.1	37360	g17770	i0	45.6	0.746724890829694	57	29	74.7	1	226	56	319	373	SPQ97415.1 unnamed protein product [Plasmodiophora brassicae]	diamond	171	48.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31264072	31264072	PRJNA889065_S_NODE_18475_length_226_cov_2.573770_g18237_i0	PRJNA889065	18475	226	2.57377	5.8167202	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	1.07e-26	NR	MES1920870.1	126728	g18237	i0	64.9	7.83185840707965	74	26	98.2	0	3	224	46	119	MES1920870.1 Protein arginine N-methyltransferase 1 [Bonamia ostreae]	diamond	1770	106	0.990566037735849	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae

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