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

8 rows where bioproject = "PRJNA564013", 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
1828392	1828392	PRJNA564013_P_NODE_80942_length_450_cov_17.727506_g78116_i0	PRJNA564013	80942	450	17.727506	79.773777	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	201	2.64e-62	NR	CEO95269.1	37360	g78116	i0	71	0.92	138	40	92	0	11	424	2	139	CEO95269.1 hypothetical protein PBRA_004035 [Plasmodiophora brassicae]	diamond	414	201	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
20954398	20954398	PRJNA564013_P_NODE_48597_length_565_cov_45.347222_g45845_i0	PRJNA564013	48597	565	45.347222	256.2118043	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	248	1.7699999999999998e-72	NR	SPQ95869.1	37360	g45845	i0	67.7	1.93805309734513	186	60	98.8	0	559	2	385	570	SPQ95869.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1095	248	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
24772812	24772812	PRJNA564013_P_NODE_10780_length_1062_cov_45.371628_g9067_i0	PRJNA564013	10780	1062	45.371628	481.84668936	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	307	8.859999999999997e-93	NR	CEP02514.1	37360	g9067	i0	70.1	0.596045197740113	211	63	59.6	0	292	924	245	455	CEP02514.1 hypothetical protein PBRA_009098 [Plasmodiophora brassicae]	diamond	633	307	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27566861	27566861	PRJNA564013_P_NODE_24804_length_752_cov_12.659913_g22387_i0	PRJNA564013	24804	752	12.659913	95.20254576	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	9.41e-22	NR	CEO99253.1	37360	g22387	i0	36.4	5.86436170212766	239	128	94.5	9	11	721	212	428	CEO99253.1 hypothetical protein PBRA_001159 [Plasmodiophora brassicae]	diamond	4410	105	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28532175	28532175	PRJNA564013_P_NODE_78827_length_456_cov_10.445570_g76003_i0	PRJNA564013	78827	456	10.44557	47.6317992	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	48.5	0.00297	NR	CEO95431.1	37360	g76003	i0	65.7	0.453947368421053	35	12	23	0	195	91	345	379	CEO95431.1 hypothetical protein PBRA_004157 [Plasmodiophora brassicae]	diamond	207	48.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28942724	28942724	PRJNA564013_P_NODE_313748_length_217_cov_2.294872_g310896_i0	PRJNA564013	313748	217	2.294872	4.97987224	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	65.1	3.51e-10	NR	CEP02632.1	37360	g310896	i0	51.5	0.912442396313364	66	31	91.2	1	16	213	251	315	CEP02632.1 hypothetical protein PBRA_002599 [Plasmodiophora brassicae]	diamond	198	65.1	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29794806	29794806	PRJNA564013_P_NODE_329011_length_209_cov_1.533784_g326159_i0	PRJNA564013	329011	209	1.533784	3.20560856	Spongospora subterranea	70186	SAR_Eukaryotes	SAR_Eukaryotes	59.3	3.36e-8	NR	YP_009350053.1	70186	g326159	i0	53.3	2.55502392344498	60	28	86.1	0	1	180	384	443	YP_009350053.1 NADH dehydrogenase subunit 2 [Spongospora subterranea]	diamond	534	59.3	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Spongospora	Spongospora subterranea
32779495	32779495	PRJNA564013_P_NODE_238860_length_271_cov_1.895238_g236008_i0	PRJNA564013	238860	271	1.895238	5.13609498	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	125	4.189999999999999e-31	NR	SPR00538.1	37360	g236008	i0	68.5	7.88191881918819	89	28	98.5	0	4	270	432	520	SPR00538.1 unnamed protein product [Plasmodiophora brassicae]	diamond	2136	125	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);;