metadata: contig_metadata: 5 rows where bioproject = "PRJEB75230", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJEB75230", 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
7788617	7788617	PRJEB75230_P_NODE_140567_length_248_cov_0.811429_g140385_i0	PRJEB75230	140567	248	0.811429	2.01234392	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	138	4.45e-40	NR	CEO95284.1	37360	g140385	i0	81.5	178.33064516129	81	15	98	0	6	248	33	113	CEO95284.1 hypothetical protein PBRA_004050 [Plasmodiophora brassicae]	diamond	44226	139	0.992805755395683	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
26781126	26781126	PRJEB75230_P_NODE_134421_length_249_cov_0.875000_g134239_i0	PRJEB75230	134421	249	0.875	2.17875	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	48.5	1.05e-4	NR	CEO99711.1	37360	g134239	i0	88.5	0.313253012048193	26	3	31.3	0	123	46	109	134	CEO99711.1 hypothetical protein PBRA_007444 [Plasmodiophora brassicae]	diamond	78	48.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28929036	28929036	PRJEB75230_P_NODE_185048_length_236_cov_2.834356_g184866_i0	PRJEB75230	185048	236	2.834356	6.68908016	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	108	6.38e-28	NR	SPQ93437.1	37360	g184866	i0	62.8	3.95338983050847	78	27	99.2	1	1	234	32	107	SPQ93437.1 unnamed protein product [Plasmodiophora brassicae]	diamond	933	108	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30950684	30950684	PRJEB75230_P_NODE_18754_length_391_cov_0.968553_g18572_i0	PRJEB75230	18754	391	0.968553	3.78704223	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	50.1	5.59e-4	NR	SPQ96640.1	37360	g18572	i0	29	1.05882352941176	138	73	94.4	5	8	376	1371	1498	SPQ96640.1 unnamed protein product [Plasmodiophora brassicae]	diamond	414	50.1	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32657709	32657709	PRJEB75230_P_NODE_50560_length_311_cov_1.483193_g50378_i0	PRJEB75230	50560	311	1.483193	4.61273023	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	66.2	3.61e-10	NR	SPQ94171.1	37360	g50378	i0	44.2	1.48553054662379	77	43	74.3	0	236	6	157	233	SPQ94171.1 unnamed protein product [Plasmodiophora brassicae]	diamond	462	66.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);;