metadata: contig_metadata: 10 rows where bioproject = "PRJNA594101", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA594101", 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
10068041	10068041	PRJNA594101_S_NODE_6088_length_660_cov_79.238501_g5798_i0	PRJNA594101	6088	660	79.238501	522.9741066	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	228	3.2e-72	NR	CEP02281.1	37360	g5798	i0	61.1	4.66363636363636	203	76	92.3	2	1	609	2	201	CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae]	diamond	3078	228	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
13321217	13321217	PRJNA594101_S_NODE_5571_length_688_cov_3.437398_g5284_i0	PRJNA594101	5571	688	3.437398	23.64929824	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	146	6.44e-40	NR	CEO95460.1	37360	g5284	i0	42.4	14.2848837209302	205	115	88.1	3	637	32	8	212	CEO95460.1 hypothetical protein PBRA_004187 [Plasmodiophora brassicae]	diamond	9828	147	0.993197278911565	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
18990827	18990827	PRJNA594101_S_NODE_7055_length_615_cov_2.031365_g6759_i0	PRJNA594101	7055	615	2.031365	12.49289475	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	229	1.04e-72	NR	CEP00705.1	37360	g6759	i0	57.7	0.88780487804878	182	76	88.8	1	1	546	6	186	CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae]	diamond	546	229	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27174361	27174361	PRJNA594101_S_NODE_32342_length_302_cov_3.043668_g32040_i0	PRJNA594101	32342	302	3.043668	9.19187736	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	75.5	2.06e-14	NR	CEP01202.1	37360	g32040	i0	45.2	1.66887417218543	84	44	83.4	1	302	51	90	171	CEP01202.1 hypothetical protein PBRA_008514 [Plasmodiophora brassicae]	diamond	504	75.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27459131	27459131	PRJNA594101_S_NODE_20583_length_370_cov_1.269360_g20281_i0	PRJNA594101	20583	370	1.26936	4.696632	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	54.7	8.28e-6	NR	CEO95785.1	37360	g20281	i0	34.1	0.713513513513514	88	57	70.5	1	102	362	29	116	CEO95785.1 hypothetical protein PBRA_004498 [Plasmodiophora brassicae]	diamond	264	54.7	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27869315	27869315	PRJNA594101_S_NODE_5805_length_675_cov_2.139535_g5516_i0	PRJNA594101	5805	675	2.139535	14.44186125	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	248	6.32e-76	NR	CEP00750.1	37360	g5516	i0	52.7	0.986666666666667	222	104	98.2	1	1	663	226	447	CEP00750.1 hypothetical protein PBRA_001804 [Plasmodiophora brassicae]	diamond	666	248	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28058846	28058846	PRJNA594101_S_NODE_43185_length_265_cov_2.000000_g42883_i0	PRJNA594101	43185	265	2	5.3	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	68.2	5.5e-11	NR	CEO95512.1	37360	g42883	i0	37.6	0.962264150943396	85	53	96.2	0	2	256	92	176	CEO95512.1 hypothetical protein PBRA_004238 [Plasmodiophora brassicae]	diamond	255	68.2	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28943265	28943265	PRJNA594101_S_NODE_46988_length_255_cov_1.538462_g46686_i0	PRJNA594101	46988	255	1.538462	3.9230781	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	70.9	3.12e-12	NR	CEO97494.1	37360	g46686	i0	45.3	1.6	75	38	85.9	2	229	11	176	249	CEO97494.1 hypothetical protein PBRA_000839 [Plasmodiophora brassicae]	diamond	408	70.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29826893	29826893	PRJNA594101_S_NODE_19431_length_380_cov_0.882736_g19129_i0	PRJNA594101	19431	380	0.882736	3.3543968	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	82.4	7.45e-16	NR	CEO97494.1	37360	g19129	i0	46.1	0.702631578947368	89	46	68.7	1	94	354	102	190	CEO97494.1 hypothetical protein PBRA_000839 [Plasmodiophora brassicae]	diamond	267	82.4	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30679871	30679871	PRJNA594101_S_NODE_54313_length_244_cov_2.631579_g54011_i0	PRJNA594101	54313	244	2.631579	6.42105276	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	55.1	1.73e-6	NR	CEO99227.1	37360	g54011	i0	57.4	1.63524590163934	47	20	57.8	0	193	53	752	798	CEO99227.1 hypothetical protein PBRA_001133 [Plasmodiophora brassicae]	diamond	399	55.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);;