metadata: contig_metadata: 10 rows where bioproject = "PRJNA870096" and tax

10 rows where bioproject = "PRJNA870096" 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
3400936	3400936	PRJNA870096_S_NODE_47323_length_256_cov_3.516432_g45659_i0	PRJNA870096	47323	256	3.516432	9.00206592	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	95.9	5.17e-24	NR	CEP01456.1	37360	g45659	i0	70	3.48046875	60	18	70.3	0	202	23	1	60	CEP01456.1 hypothetical protein PBRA_002062 [Plasmodiophora brassicae]	diamond	891	95.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28760422	28760422	PRJNA870096_S_NODE_105727_length_172_cov_1.666667_g104063_i0	PRJNA870096	105727	172	1.666667	2.86666724	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.00545	NR	CEO95868.1	37360	g104063	i0	44.7	0.662790697674419	38	21	66.3	0	39	152	405	442	CEO95868.1 hypothetical protein PBRA_004581 [Plasmodiophora brassicae]	diamond	114	43.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28791921	28791921	PRJNA870096_S_NODE_146007_length_150_cov_1.093458_g144343_i0	PRJNA870096	146007	150	1.093458	1.640187	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	79	1.64e-15	NR	CEP00050.1	37360	g144343	i0	69.4	3.92	49	15	98	0	149	3	383	431	CEP00050.1 hypothetical protein PBRA_007784 [Plasmodiophora brassicae]	diamond	588	79	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29328820	29328820	PRJNA870096_S_NODE_55669_length_235_cov_2.250000_g54005_i0	PRJNA870096	55669	235	2.25	5.2875	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	70.9	4.19e-12	NR	CEO98361.1	37360	g54005	i0	63.5	0.663829787234043	52	19	66.4	0	235	80	672	723	CEO98361.1 hypothetical protein PBRA_006475 [Plasmodiophora brassicae]	diamond	156	70.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29644189	29644189	PRJNA870096_S_NODE_14130_length_487_cov_18.614865_g12494_i0	PRJNA870096	14130	487	18.614865000000002	90.65439255	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	155	2.51e-45	NR	SPQ93437.1	37360	g12494	i0	67.6	4.79876796714579	111	36	68.4	0	421	89	34	144	SPQ93437.1 unnamed protein product [Plasmodiophora brassicae]	diamond	2337	155	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29675865	29675865	PRJNA870096_S_NODE_97610_length_179_cov_0.933824_g95946_i0	PRJNA870096	97610	179	0.933824	1.67154496	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	102	9.199999999999999e-24	NR	CEO95344.1	37360	g95946	i0	74.6	5.93296089385475	59	15	98.9	0	2	178	237	295	CEO95344.1 hypothetical protein PBRA_004110 [Plasmodiophora brassicae]	diamond	1062	102	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30157825	30157825	PRJNA870096_S_NODE_95572_length_180_cov_2.007299_g93908_i0	PRJNA870096	95572	180	2.007299	3.6131382	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.3	2.23e-15	NR	CEO95857.1	37360	g93908	i0	57.4	5.48333333333333	54	23	90	0	9	170	133	186	CEO95857.1 hypothetical protein PBRA_004570 [Plasmodiophora brassicae]	diamond	987	76.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30497623	30497623	PRJNA870096_S_NODE_7713_length_671_cov_2.883758_g6274_i0	PRJNA870096	7713	671	2.883758	19.35001618	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	46.2	0.028	NR	SPQ96098.1	37360	g6274	i0	31.9	0.84053651266766	94	53	39.8	4	667	401	85	172	SPQ96098.1 unnamed protein product [Plasmodiophora brassicae]	diamond	564	46.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32331828	32331828	PRJNA870096_S_NODE_84179_length_191_cov_3.243243_g82515_i0	PRJNA870096	84179	191	3.243243	6.19459413	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	64.3	4.55e-10	NR	CEP00925.1	37360	g82515	i0	50.8	2.96858638743455	63	21	99	2	191	3	614	666	CEP00925.1 hypothetical protein PBRA_008237 [Plasmodiophora brassicae]	diamond	567	64.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32907325	32907325	PRJNA870096_S_NODE_125480_length_159_cov_1.241379_g123816_i0	PRJNA870096	125480	159	1.241379	1.97379261	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.9	2.36e-8	NR	CEO96297.1	37360	g123816	i0	51	1.92452830188679	51	25	96.2	0	153	1	109	159	CEO96297.1 hypothetical protein PBRA_004968 [Plasmodiophora brassicae]	diamond	306	58.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);;