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

7 rows where bioproject = "PRJNA533623", 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
22182694	22182694	PRJNA533623_P_NODE_18358_length_547_cov_28.701646_g16621_i0	PRJNA533623	18358	547	28.701646	156.99800362	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	106	4.6e-25	NR	CEP00705.1	37360	g16621	i0	80	0.83363802559415	70	13	37.8	1	230	436	94	163	CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae]	diamond	456	106	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27993852	27993852	PRJNA533623_P_NODE_2005_length_1472_cov_2.871013_g1305_i0	PRJNA533623	2005	1472	2.871013	42.26131136	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	368	3.13e-109	NR	SPR02116.1	37360	g1305	i0	36.5	1.24524456521739	611	260	98.4	6	1471	23	1629	2239	SPR02116.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1833	368	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28861105	28861105	PRJNA533623_P_NODE_47008_length_308_cov_3.085020_g45230_i0	PRJNA533623	47008	308	3.08502	9.5018616	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	68.9	4.97e-11	NR	CEO95788.1	37360	g45230	i0	36.8	2.9025974025974	76	48	74	0	45	272	553	628	CEO95788.1 hypothetical protein PBRA_004501 [Plasmodiophora brassicae]	diamond	894	69.3	0.994227994227994	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29477437	29477437	PRJNA533623_P_NODE_75270_length_206_cov_1.793103_g73489_i0	PRJNA533623	75270	206	1.793103	3.69379218	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	98.2	3.6899999999999996e-23	NR	CEO95700.1	37360	g73489	i0	64.1	3.72815533980583	64	23	93.2	0	14	205	184	247	CEO95700.1 hypothetical protein PBRA_004413 [Plasmodiophora brassicae]	diamond	768	98.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29761775	29761775	PRJNA533623_P_NODE_63531_length_241_cov_3.611111_g61750_i0	PRJNA533623	63531	241	3.611111	8.70277751	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	48.1	4.06e-4	NR	CEO94886.1	37360	g61750	i0	36.7	1.23236514522822	49	31	61	0	239	93	38	86	CEO94886.1 hypothetical protein PBRA_003699 [Plasmodiophora brassicae]	diamond	297	48.1	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30124104	30124104	PRJNA533623_P_NODE_37012_length_363_cov_4.526490_g35240_i0	PRJNA533623	37012	363	4.52649	16.4311587	Plasmodiophorida	37357	SAR_Eukaryotes	SAR_Eukaryotes	73.9	1.67e-12	NR	CAL69922.1	37360	g35240	i0	34.8	1.56198347107438	92	55	76	1	289	14	9	95	CAL69922.1 hypothetical protein [Plasmodiophora brassicae]	diamond	567	74.3	0.994616419919246	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30457333	30457333	PRJNA533623_P_NODE_78433_length_196_cov_5.962963_g76652_i0	PRJNA533623	78433	196	5.962963	11.68740748	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	69.7	6.36e-12	NR	SPQ95616.1	37360	g76652	i0	57.9	1.74489795918367	57	24	87.2	0	20	190	2590	2646	SPQ95616.1 unnamed protein product [Plasmodiophora brassicae]	diamond	342	69.7	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);;