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

7 rows where bioproject = "PRJNA1136505", 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
2307302	2307302	PRJNA1136505_P_NODE_35682_length_590_cov_2.092843_g28865_i0	PRJNA1136505	35682	590	2.092843	12.3477737	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	272	9.12e-86	NR	CEO98167.1	37360	g28865	i0	65.6	62.2474576271186	195	67	99.2	0	586	2	160	354	CEO98167.1 hypothetical protein PBRA_006281 [Plasmodiophora brassicae]	diamond	36726	272	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
5387719	5387719	PRJNA1136505_P_NODE_27145_length_785_cov_2.084270_g20550_i0	PRJNA1136505	27145	785	2.08427	16.3615195	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	295	2.92e-97	NR	CEP02495.1	37360	g20550	i0	62.1	13.6356687898089	235	88	89.4	1	34	735	8	242	CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae]	diamond	10704	295	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
8685082	8685082	PRJNA1136505_P_NODE_151327_length_242_cov_1.822485_g144467_i0	PRJNA1136505	151327	242	1.822485	4.4104137	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	102	2.4199999999999998e-23	NR	CEP01082.1	37360	g144467	i0	66.7	1.00413223140496	81	26	99.2	1	3	242	281	361	CEP01082.1 hypothetical protein PBRA_008394 [Plasmodiophora brassicae]	diamond	243	102	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
18136235	18136235	PRJNA1136505_P_NODE_35495_length_593_cov_2.038462_g28679_i0	PRJNA1136505	35495	593	2.038462	12.08807966	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	182	9.809999999999997e-55	NR	CEP03147.1	37360	g28679	i0	62.7	21.6627318718381	142	52	71.3	1	169	591	9	150	CEP03147.1 hypothetical protein PBRA_009365 [Plasmodiophora brassicae]	diamond	12846	183	0.994535519125683	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29806598	29806598	PRJNA1136505_P_NODE_81771_length_322_cov_3.172691_g74911_i0	PRJNA1136505	81771	322	3.172691	10.21606502	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	106	5.66e-25	NR	CEO95355.1	37360	g74911	i0	66.2	1.7888198757764	74	21	68.9	1	100	321	227	296	CEO95355.1 hypothetical protein PBRA_004121 [Plasmodiophora brassicae]	diamond	576	107	0.990654205607477	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30070268	30070268	PRJNA1136505_P_NODE_123092_length_259_cov_1.413978_g116232_i0	PRJNA1136505	123092	259	1.413978	3.66220302	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	66.2	2.36e-10	NR	SPR00297.1	37360	g116232	i0	48.9	4.07722007722008	92	30	99.6	3	2	259	90	170	SPR00297.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1056	66.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32220133	32220133	PRJNA1136505_P_NODE_52178_length_429_cov_1.879213_g45319_i0	PRJNA1136505	52178	429	1.879213	8.06182377	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	57.4	2.27e-6	NR	SPQ98635.1	37360	g45319	i0	52	0.34965034965035	50	24	35	0	429	280	342	391	SPQ98635.1 unnamed protein product [Plasmodiophora brassicae]	diamond	150	57.4	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);;