metadata: contig_metadata: 6 rows where bioproject = "PRJNA724039", tax_clade = "Sar" and tax

6 rows where bioproject = "PRJNA724039", 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
711016	711016	PRJNA724039_S_NODE_10721_length_197_cov_3.043750_g10514_i0	PRJNA724039	10721	197	3.04375	5.9961875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	124	1.92e-35	NR	CEP00957.1	37360	g10514	i0	88.7	5.6497461928934	62	7	94.4	0	196	11	20	81	CEP00957.1 hypothetical protein PBRA_008269 [Plasmodiophora brassicae]	diamond	1113	125	0.992	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
711062	711062	PRJNA724039_S_NODE_13921_length_171_cov_2.768657_g13714_i0	PRJNA724039	13921	171	2.768657	4.73440347	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	78.6	1.06e-15	NR	CEO96095.1	37360	g13714	i0	62.5	0.982456140350877	56	21	98.2	0	2	169	92	147	CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae]	diamond	168	78.6	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
1987064	1987064	PRJNA724039_S_NODE_11502_length_190_cov_1.686275_g11295_i0	PRJNA724039	11502	190	1.686275	3.2039225	Polymyxa betae	41456	SAR_Eukaryotes	SAR_Eukaryotes	154	4.35e-33	NTclustered	gi\|2127897050\|ref\|NC_059071.1\|	41456	g11295	i0	84.713	106.731578947368	157	20	82	4	1	155	19993	20147	Polymyxa betae isolate A26-41 genome assembly, organelle: mitochondrion	blastn	20279	154	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Polymyxa	Polymyxa betae
7571983	7571983	PRJNA724039_S_NODE_15826_length_160_cov_2.918699_g15619_i0	PRJNA724039	15826	160	2.918699	4.6699184	Plasmodiophora brassicae	37360	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.25e-16	NR	CEO96095.1	37360	g15619	i0	68.6	0.95625	51	16	95.6	0	153	1	145	195	CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae]	diamond	153	80.9	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
27473398	27473398	PRJNA724039_S_NODE_14943_length_165_cov_1.781250_g14736_i0	PRJNA724039	14943	165	1.78125	2.9390625	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	91.7	6.55e-22	NR	CEO99151.1	37360	g14736	i0	79.6	47.1272727272727	54	11	98.2	0	2	163	91	144	CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae]	diamond	7776	92.4	0.992424242424242	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32686149	32686149	PRJNA724039_S_NODE_14120_length_170_cov_1.736842_g13913_i0	PRJNA724039	14120	170	1.736842	2.9526314	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	93.6	4.1100000000000006e-21	NR	CEP01219.1	37360	g13913	i0	69.6	70.1647058823529	56	17	98.8	0	3	170	7	62	CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae]	diamond	11928	94	0.995744680851064	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);;