metadata: contig_metadata: 9 rows where bioproject = "PRJNA493244", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA493244", 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
4927909	4927909	PRJNA493244_P_NODE_1426684_length_261_cov_1.870000_g1403559_i0	PRJNA493244	1426684	261	1.87	4.8807	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.024	NTclustered	gi\|382930299\|gb\|JF831808.1\|	1168218	g1403559	i0	100	2.25287356321839	28	0	11	0	234	261	229	202	Bonamia sp. ex Ostrea edulis clone SF05602BA1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	588	52.8	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia sp. ex Ostrea edulis
9385152	9385152	PRJNA493244_P_NODE_551408_length_681_cov_10.040323_g530474_i0	PRJNA493244	551408	681	10.040323	68.37459963	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	253	9.729999999999999e-74	NR	SPQ96340.1	37360	g530474	i0	58.4	1.9295154185022	219	91	96.5	0	25	681	902	1120	SPQ96340.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1314	253	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
13210744	13210744	PRJNA493244_P_NODE_453851_length_775_cov_10.526611_g434552_i0	PRJNA493244	453851	775	10.526611	81.58123525	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	94.7	7.98e-20	NR	CEO99344.1	37360	g434552	i0	39.2	1.22322580645161	158	89	61.2	4	699	226	31	181	CEO99344.1 hypothetical protein PBRA_001250, partial [Plasmodiophora brassicae]	diamond	948	94.7	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
14484135	14484135	PRJNA493244_P_NODE_137312_length_1371_cov_18.946565_g128421_i0	PRJNA493244	137312	1371	18.946565	259.75740615	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	431	1.19e-139	NR	CEO96359.1	37360	g128421	i0	54.2	2.54485776805252	389	178	85.1	0	1361	195	455	843	CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae]	diamond	3489	431	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
15128005	15128005	PRJNA493244_P_NODE_1698252_length_204_cov_0.895105_g1675127_i0	PRJNA493244	1698252	204	0.895105	1.8260142	Minchinia	38078	SAR_Eukaryotes	SAR_Eukaryotes	99	2.25e-16	NTclustered	gi\|41584536\|gb\|AY449710.1\|	262226	g1675127	i0	85.714	49.828431372549	98	8	47	6	14	108	1549	1643	Minchinia tapetis small subunit ribosomal RNA gene, partial sequence	blastn	10165	99	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida	Haplosporidiidae	Minchinia	Minchinia tapetis
24682528	24682528	PRJNA493244_P_NODE_186060_length_1218_cov_24.219533_g174912_i0	PRJNA493244	186060	1218	24.219533	294.99391194	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	191	2.68e-49	NR	SPQ96340.1	37360	g174912	i0	54.7	1.72413793103448	179	80	44.1	1	1036	500	944	1121	SPQ96340.1 unnamed protein product [Plasmodiophora brassicae]	diamond	2100	191	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
26839521	26839521	PRJNA493244_P_NODE_798641_length_507_cov_9.786996_g775967_i0	PRJNA493244	798641	507	9.786996	49.62006972	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	47.4	0.00956	NR	CEP01219.1	37360	g775967	i0	55.3	1.42011834319527	38	17	22.5	0	441	328	280	317	CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae]	diamond	720	47.4	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30171123	30171123	PRJNA493244_P_NODE_12112_length_2622_cov_6.980867_g10734_i0	PRJNA493244	12112	2622	6.980867	183.03833274	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	695	1.0099999999999996e-227	NR	CEP00171.1	37360	g10734	i0	44	0.979405034324943	856	452	96.1	11	102	2621	11	855	CEP00171.1 hypothetical protein PBRA_007905 [Plasmodiophora brassicae]	diamond	2568	695	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30361279	30361279	PRJNA493244_P_NODE_1049512_length_385_cov_39.216049_g1026399_i0	PRJNA493244	1049512	385	39.216049	150.98178865	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	87.8	1.45e-19	NR	CEO99483.1	37360	g1026399	i0	78.8	5.55584415584416	52	11	40.5	0	27	182	59	110	CEO99483.1 hypothetical protein PBRA_001389, partial [Plasmodiophora brassicae]	diamond	2139	87.8	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);;