metadata: contig_metadata: 5 rows where bioproject = "PRJNA662254" and tax

5 rows where bioproject = "PRJNA662254" 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
14657165	14657165	PRJNA662254_P_NODE_1512_length_1432_cov_5.189110_g1212_i0	PRJNA662254	1512	1432	5.18911	74.3080552	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	728	1.23e-261	NR	ADK90073.1	862247	g1212	i0	77.3	31.3805865921788	453	102	94.9	1	3	1361	3	454	ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12]	diamond	44937	731	0.995896032831737	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
28565685	28565685	PRJNA662254_P_NODE_11987_length_476_cov_1.903226_g11336_i0	PRJNA662254	11987	476	1.903226	9.05935576	Paramarteilia canceri	2844372	SAR_Eukaryotes	SAR_Eukaryotes	50.8	7.33e-5	NR	MES1905048.1	2844372	g11336	i0	35.7	0.441176470588235	70	45	44.1	0	264	473	18	87	MES1905048.1 non-histone protein [Paramarteilia canceri]	diamond	210	50.8	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Paramyxida	Marteiliidae	Paramarteilia	Paramarteilia canceri
29650998	29650998	PRJNA662254_P_NODE_37150_length_275_cov_1.410891_g36499_i0	PRJNA662254	37150	275	1.410891	3.87995025	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	131	1.1e-34	NR	CEO94287.1	37360	g36499	i0	69.2	28.7890909090909	91	27	99.3	1	274	2	131	220	CEO94287.1 hypothetical protein PBRA_000072 [Plasmodiophora brassicae]	diamond	7917	132	0.992424242424242	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30681489	30681489	PRJNA662254_P_NODE_11793_length_480_cov_1.577396_g11142_i0	PRJNA662254	11793	480	1.577396	7.5715008	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	88.6	4.84e-17	NR	CEO95180.1	37360	g11142	i0	33.5	1.025	164	104	99.4	3	1	477	88	251	CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae]	diamond	492	88.6	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32862467	32862467	PRJNA662254_P_NODE_10120_length_523_cov_1.326667_g9472_i0	PRJNA662254	10120	523	1.326667	6.93846841	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	69.3	3.55e-10	NR	CEP03425.1	37360	g9472	i0	39.1	0.923518164435946	161	71	90.6	6	14	487	383	519	CEP03425.1 hypothetical protein PBRA_003185 [Plasmodiophora brassicae]	diamond	483	69.3	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);;