metadata: contig_metadata: 7 rows where bioproject = "PRJNA669701" and tax

7 rows where bioproject = "PRJNA669701" 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
9564500	9564500	PRJNA669701_P_NODE_62408_length_310_cov_2.957806_g62013_i0	PRJNA669701	62408	310	2.957806	9.1691986	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	67.8	1.3099999999999999e-10	NR	CEO95180.1	37360	g62013	i0	55.4	2.85483870967742	56	25	54.2	0	172	5	542	597	CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae]	diamond	885	67.8	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
10839298	10839298	PRJNA669701_P_NODE_122229_length_247_cov_0.885057_g121834_i0	PRJNA669701	122229	247	0.885057	2.18609079	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	125	2.1399999999999997e-31	NR	SPQ95420.1	37360	g121834	i0	82.3	3.80161943319838	79	14	96	0	10	246	19	97	SPQ95420.1 unnamed protein product [Plasmodiophora brassicae]	diamond	939	125	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27694173	27694173	PRJNA669701_P_NODE_129964_length_244_cov_1.801170_g129569_i0	PRJNA669701	129964	244	1.80117	4.3948548	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.4	4.4e-5	NR	MES1921872.1	126728	g129569	i0	43.9	1.38934426229508	57	25	65.2	2	164	6	25	78	MES1921872.1 54S ribosomal protein L23, mitochondrial [Bonamia ostreae]	diamond	339	50.4	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae
27902728	27902728	PRJNA669701_P_NODE_98105_length_261_cov_1.515957_g97710_i0	PRJNA669701	98105	261	1.515957	3.95664777	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	70.1	1.08e-11	NR	CEO99569.1	37360	g97710	i0	40.7	0.988505747126437	86	49	98.9	1	3	260	415	498	CEO99569.1 hypothetical protein PBRA_007302 [Plasmodiophora brassicae]	diamond	258	70.1	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28218399	28218399	PRJNA669701_P_NODE_64946_length_306_cov_1.193133_g64551_i0	PRJNA669701	64946	306	1.193133	3.65098698	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	68.6	6.98e-11	NR	SPR01254.1	37360	g64551	i0	32.7	1.99019607843137	101	68	99	0	305	3	3425	3525	SPR01254.1 unnamed protein product [Plasmodiophora brassicae]	diamond	609	68.6	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
31250653	31250653	PRJNA669701_P_NODE_136255_length_243_cov_0.905882_g135860_i0	PRJNA669701	136255	243	0.905882	2.20129326	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	47.8	1.91e-4	NR	CEO94324.1	37360	g135860	i0	83.3	0.37037037037037	30	5	37	0	243	154	104	133	CEO94324.1 hypothetical protein PBRA_000109 [Plasmodiophora brassicae]	diamond	90	47.8	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32453125	32453125	PRJNA669701_P_NODE_143319_length_240_cov_2.658683_g142924_i0	PRJNA669701	143319	240	2.658683	6.3808392	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	65.1	3.85e-10	NR	SPQ99877.1	37360	g142924	i0	50	3.575	72	26	88.8	2	23	235	115	177	SPQ99877.1 unnamed protein product [Plasmodiophora brassicae]	diamond	858	65.1	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);;