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

8 rows where bioproject = "PRJEB39643", 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
6436104	6436104	PRJEB39643_P_NODE_28986_length_341_cov_15.074627_g28793_i0	PRJEB39643	28986	341	15.074627	51.40447807	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	154	4.61e-46	NR	CEP03336.1	37360	g28793	i0	73.5	16.5483870967742	102	27	89.7	0	307	2	6	107	CEP03336.1 hypothetical protein PBRA_003096 [Plasmodiophora brassicae]	diamond	5643	154	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
15359885	15359885	PRJEB39643_P_NODE_1593_length_1441_cov_23.554094_g1533_i0	PRJEB39643	1593	1441	23.554094	339.41449454	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	726	7.99e-261	NR	ADK90073.1	862247	g1533	i0	79	17.9521165857044	443	93	92.2	0	3	1331	5	447	ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12]	diamond	25869	733	0.990450204638472	Eukaryota	Sar	Endomyxa		Vampyrellida	Leptophryidae	Arachnula	Arachnula sp. CL12
15360019	15360019	PRJEB39643_P_NODE_26053_length_358_cov_22.498246_g25860_i0	PRJEB39643	26053	358	22.498246	80.54372068	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	138	7.7e-40	NR	CEO99864.1	37360	g25860	i0	62.6	43.0977653631285	107	38	89.7	1	350	30	1	105	CEO99864.1 hypothetical protein PBRA_007598 [Plasmodiophora brassicae]	diamond	15429	138	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
21734937	21734937	PRJEB39643_P_NODE_58518_length_282_cov_1.177033_g58325_i0	PRJEB39643	58518	282	1.177033	3.31923306	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	6.04e-34	NR	CEO95284.1	37360	g58325	i0	76.9	1.70212765957447	78	18	83	0	47	280	23	100	CEO95284.1 hypothetical protein PBRA_004050 [Plasmodiophora brassicae]	diamond	480	124	0.991935483870968	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
24283542	24283542	PRJEB39643_P_NODE_16720_length_449_cov_2.890957_g16527_i0	PRJEB39643	16720	449	2.8909570000000002	12.98039693	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	163	1.41e-48	NR	SPQ93437.1	37360	g16527	i0	68.4	2.28507795100223	117	35	78.2	1	449	99	33	147	SPQ93437.1 unnamed protein product [Plasmodiophora brassicae]	diamond	1026	163	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
26589954	26589954	PRJEB39643_P_NODE_73161_length_274_cov_1.532338_g72968_i0	PRJEB39643	73161	274	1.532338	4.19860612	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	90.5	8.71e-19	NR	CEO95656.1	37360	g72968	i0	48.9	0.963503649635037	88	36	94.2	3	2	259	488	568	CEO95656.1 hypothetical protein PBRA_004382 [Plasmodiophora brassicae]	diamond	264	90.5	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
29742277	29742277	PRJEB39643_P_NODE_119530_length_252_cov_1.720670_g119337_i0	PRJEB39643	119530	252	1.72067	4.3360884	root	1	Root_unresolved	Root_unresolved	76.3	6.59e-14	NR	SPQ98236.1	37360	g119337	i0	42.9	3.89285714285714	84	46	97.6	1	251	6	134	217	SPQ98236.1 unnamed protein product [Plasmodiophora brassicae]	diamond	981	76.6	0.996083550913838	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
30184693	30184693	PRJEB39643_P_NODE_146032_length_242_cov_1.822485_g145839_i0	PRJEB39643	146032	242	1.822485	4.4104137	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	60.8	1.51e-8	NR	CEP00414.1	37360	g145839	i0	50	1.74793388429752	50	25	62	0	152	3	265	314	CEP00414.1 hypothetical protein PBRA_001468 [Plasmodiophora brassicae]	diamond	423	60.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);;