metadata: contig_metadata: 8 rows where bioproject = "PRJNA493828", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA493828", 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
4301596	4301596	PRJNA493828_P_NODE_29304_length_258_cov_1.551351_g28885_i0	PRJNA493828	29304	258	1.551351	4.00248558	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	70.9	1.27e-13	NR	CEO95757.1	37360	g28885	i0	57.7	0.906976744186046	78	32	89.5	1	235	5	1	78	CEO95757.1 hypothetical protein PBRA_004470 [Plasmodiophora brassicae]	diamond	234	70.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
15134403	15134403	PRJNA493828_P_NODE_12392_length_330_cov_1.848249_g11973_i0	PRJNA493828	12392	330	1.848249	6.0992217	Paramarteilia	1871453	SAR_Eukaryotes	SAR_Eukaryotes	58.4	6.68e-4	NTclustered	gi\|2228688988\|gb\|ON320521.1\|	2844372	g11973	i0	100	10.0787878787879	31	0	9	0	300	330	6249	6219	Paramarteilia canceri voucher s-1-16-13 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence	blastn	3326	58.4	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Paramyxida	Marteiliidae	Paramarteilia	Paramarteilia canceri
28276880	28276880	PRJNA493828_P_NODE_35066_length_247_cov_0.885057_g34647_i0	PRJNA493828	35066	247	0.885057	2.18609079	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	82	5.8e-16	NR	SPQ96570.1	37360	g34647	i0	53.2	0.959514170040486	79	36	96	1	243	7	368	445	SPQ96570.1 unnamed protein product [Plasmodiophora brassicae]	diamond	237	82	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29113641	29113641	PRJNA493828_P_NODE_44148_length_226_cov_2.627451_g43729_i0	PRJNA493828	44148	226	2.627451	5.93803926	Endomyxa	2604748	SAR_Eukaryotes	SAR_Eukaryotes	111	1.98e-28	NR	CEO98386.1	37360	g43729	i0	76.7	6.78318584070797	73	17	96.9	0	8	226	1	73	CEO98386.1 hypothetical protein PBRA_006500 [Plasmodiophora brassicae]	diamond	1533	111	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30139706	30139706	PRJNA493828_P_NODE_38172_length_243_cov_0.905882_g37753_i0	PRJNA493828	38172	243	0.905882	2.20129326	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	115	3.14e-28	NR	CEP03572.1	37360	g37753	i0	70.9	0.975308641975309	79	23	97.5	0	2	238	116	194	CEP03572.1 hypothetical protein PBRA_009457 [Plasmodiophora brassicae]	diamond	237	115	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31372663	31372663	PRJNA493828_P_NODE_39796_length_241_cov_0.916667_g39377_i0	PRJNA493828	39796	241	0.916667	2.20916747	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	127	4.88e-33	NR	CEO99505.1	37360	g39377	i0	76.8	0.858921161825726	69	16	85.9	0	241	35	59	127	CEO99505.1 hypothetical protein PBRA_007238 [Plasmodiophora brassicae]	diamond	207	127	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32052362	32052362	PRJNA493828_P_NODE_34378_length_248_cov_0.880000_g33959_i0	PRJNA493828	34378	248	0.88	2.1824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	75.9	8.39e-14	NR	CEO98408.1	37360	g33959	i0	54.3	1.91129032258065	81	31	94.4	3	236	3	102	179	CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae]	diamond	474	76.3	0.99475753604194	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32463852	32463852	PRJNA493828_P_NODE_16499_length_308_cov_1.340426_g16080_i0	PRJNA493828	16499	308	1.340426	4.12851208	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	155	2.3e-46	NR	CEP02737.1	37360	g16080	i0	68.6	1.97727272727273	102	32	99.4	0	1	306	48	149	CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae]	diamond	609	155	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);;