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

7 rows where bioproject = "PRJNA934332", 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
2185965	2185965	PRJNA934332_P_NODE_5802_length_280_cov_1.864734_g5715_i0	PRJNA934332	5802	280	1.864734	5.2212552	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	151	1.1e-44	NR	CEO97530.1	37360	g5715	i0	76.3	2.98928571428571	93	22	99.6	0	1	279	1	93	CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae]	diamond	837	152	0.993421052631579	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
20037267	20037267	PRJNA934332_P_NODE_5616_length_284_cov_1.094787_g5529_i0	PRJNA934332	5616	284	1.094787	3.10919508	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	122	8.43e-30	NR	CEO96359.1	37360	g5529	i0	54.3	0.992957746478873	94	43	99.3	0	2	283	548	641	CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae]	diamond	282	122	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27088299	27088299	PRJNA934332_P_NODE_3582_length_341_cov_1.708955_g3495_i0	PRJNA934332	3582	341	1.708955	5.82753655	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	71.2	9.18e-12	NR	CEO99594.1	37360	g3495	i0	29	0.941348973607038	107	75	93.3	1	20	337	5	111	CEO99594.1 hypothetical protein PBRA_007327 [Plasmodiophora brassicae]	diamond	321	71.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28509359	28509359	PRJNA934332_P_NODE_6007_length_277_cov_1.171569_g5920_i0	PRJNA934332	6007	277	1.171569	3.24524613	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	78.2	2.01e-14	NR	CEP00087.1	37360	g5920	i0	43.4	2.014440433213	99	46	97.5	2	276	7	1303	1400	CEP00087.1 hypothetical protein PBRA_007821 [Plasmodiophora brassicae]	diamond	558	78.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29266903	29266903	PRJNA934332_P_NODE_4909_length_299_cov_1.566372_g4822_i0	PRJNA934332	4909	299	1.566372	4.68345228	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	117	1.16e-29	NR	CEO97280.1	37360	g4822	i0	59.6	2.96989966555184	99	40	99.3	0	3	299	136	234	CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae]	diamond	888	117	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30278101	30278101	PRJNA934332_P_NODE_8832_length_248_cov_0.880000_g8745_i0	PRJNA934332	8832	248	0.88	2.1824	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	72	1.95e-12	NR	SPQ97132.1	37360	g8745	i0	43.9	1.98387096774194	82	46	99.2	0	3	248	421	502	SPQ97132.1 unnamed protein product [Plasmodiophora brassicae]	diamond	492	72	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31320453	31320453	PRJNA934332_P_NODE_3915_length_330_cov_1.198444_g3828_i0	PRJNA934332	3915	330	1.198444	3.9548652	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	136	6.63e-35	NR	CEO97171.1	37360	g3828	i0	63.6	1	110	39	99.1	1	1	327	277	386	CEO97171.1 hypothetical protein PBRA_005775 [Plasmodiophora brassicae]	diamond	330	136	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);;