metadata: contig_metadata: 6 rows where bioproject = "PRJNA1174234", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA1174234", 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
12519618	12519618	PRJNA1174234_P_NODE_4030_length_664_cov_9.590525_g3842_i0	PRJNA1174234	4030	664	9.590525	63.681086	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	229	7.91e-73	NR	CEP02281.1	37360	g3842	i0	61.3	4.66716867469879	204	76	92.2	2	15	626	1	201	CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae]	diamond	3099	229	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
26850835	26850835	PRJNA1174234_P_NODE_11841_length_400_cov_1.868502_g11645_i0	PRJNA1174234	11841	400	1.868502	7.474008	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	123	2.7799999999999998e-31	NR	CEO99741.1	37360	g11645	i0	57.1	4.1175	112	45	84	1	3	338	138	246	CEO99741.1 hypothetical protein PBRA_007475 [Plasmodiophora brassicae]	diamond	1647	123	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27217541	27217541	PRJNA1174234_P_NODE_28502_length_254_cov_1.270718_g28306_i0	PRJNA1174234	28502	254	1.270718	3.22762372	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	71.2	3.2e-12	NR	CEO98421.1	37360	g28306	i0	44.4	4.37007874015748	72	40	85	0	3	218	115	186	CEO98421.1 hypothetical protein PBRA_006535 [Plasmodiophora brassicae]	diamond	1110	71.6	0.994413407821229	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29440258	29440258	PRJNA1174234_P_NODE_34890_length_242_cov_0.911243_g34694_i0	PRJNA1174234	34890	242	0.911243	2.20520806	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	117	1.32e-29	NR	CEP03329.1	37360	g34694	i0	78.9	17.0454545454545	76	15	94.2	1	1	228	25	99	CEP03329.1 hypothetical protein PBRA_003089 [Plasmodiophora brassicae]	diamond	4125	117	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30166768	30166768	PRJNA1174234_P_NODE_21912_length_295_cov_1.076577_g21716_i0	PRJNA1174234	21912	295	1.076577	3.17590215	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	114	1.71e-28	NR	SPR00725.1	37360	g21716	i0	51	0.996610169491525	98	48	99.7	0	2	295	95	192	SPR00725.1 unnamed protein product [Plasmodiophora brassicae]	diamond	294	114	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31924596	31924596	PRJNA1174234_P_NODE_18197_length_323_cov_1.232000_g18001_i0	PRJNA1174234	18197	323	1.232	3.97936	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	145	9.63e-38	NR	SPQ99078.1	37360	g18001	i0	72.3	2.76780185758514	94	26	87.3	0	322	41	496	589	SPQ99078.1 unnamed protein product [Plasmodiophora brassicae]	diamond	894	145	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);;