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

6 rows where bioproject = "PRJNA939415" 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
26898617	26898617	PRJNA939415_P_NODE_56981_length_277_cov_1.137255_g56559_i0	PRJNA939415	56981	277	1.137255	3.15019635	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	43.5	0.0288	NR	SPQ97734.1	37360	g56559	i0	33.3	0.877256317689531	81	53	87.7	1	21	263	144	223	SPQ97734.1 unnamed protein product [Plasmodiophora brassicae]	diamond	243	43.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29614216	29614216	PRJNA939415_P_NODE_60270_length_273_cov_3.490000_g59848_i0	PRJNA939415	60270	273	3.49	9.5277	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	50.8	6.82e-5	NR	CEP02334.1	37360	g59848	i0	34.6	0.89010989010989	81	49	87.9	2	255	16	119	196	CEP02334.1 hypothetical protein PBRA_008918 [Plasmodiophora brassicae]	diamond	243	50.8	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30119691	30119691	PRJNA939415_P_NODE_34232_length_310_cov_2.261603_g33810_i0	PRJNA939415	34232	310	2.261603	7.0109693	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	95.9	1.37e-20	NR	AVG22644.1	37360	g33810	i0	88	5.00322580645161	50	6	48.4	0	150	1	128	177	AVG22644.1 MAPK6 [Plasmodiophora brassicae]	diamond	1551	95.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30373094	30373094	PRJNA939415_P_NODE_98752_length_236_cov_4.883436_g98330_i0	PRJNA939415	98752	236	4.883436	11.52490896	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	97.4	1.9600000000000003e-21	NR	CEP00899.1	37360	g98330	i0	60.3	0.991525423728814	78	31	99.2	0	1	234	74	151	CEP00899.1 hypothetical protein PBRA_008211 [Plasmodiophora brassicae]	diamond	234	97.4	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32174884	32174884	PRJNA939415_P_NODE_107738_length_216_cov_9.818182_g107316_i0	PRJNA939415	107738	216	9.818182	21.20727312	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	47	3.43e-4	NR	CEO97530.1	37360	g107316	i0	73.1	0.361111111111111	26	7	36.1	0	79	2	9	34	CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae]	diamond	78	47	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32900718	32900718	PRJNA939415_P_NODE_49040_length_284_cov_4.289100_g48618_i0	PRJNA939415	49040	284	4.2891	12.181044	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	68.2	6.77e-11	NR	CEP02694.1	37360	g48618	i0	50.6	0.813380281690141	77	37	81.3	1	284	54	232	307	CEP02694.1 hypothetical protein PBRA_002661 [Plasmodiophora brassicae]	diamond	231	68.2	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);;