metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA796753" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA796753" 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
2056705	2056705	PRJNA796753_P_NODE_4662_length_622_cov_9.224044_g4358_i0	PRJNA796753	4662	622	9.224044	57.37355368	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	221	4.43e-70	NR	CEO98730.1	37360	g4358	i0	58.6	10.0418006430868	186	74	89.2	2	602	48	1	184	CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae]	diamond	6246	221	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
4609232	4609232	PRJNA796753_P_NODE_9564_length_447_cov_1.676471_g9252_i0	PRJNA796753	9564	447	1.676471	7.49382537	root	1	Root_unresolved	Root_unresolved	203	1.87e-57	NR	CEO97849.1	37360	g9252	i0	67.6	7.02013422818792	148	48	99.3	0	447	4	820	967	CEO97849.1 hypothetical protein PBRA_005963 [Plasmodiophora brassicae]	diamond	3138	204	0.995098039215686	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
9709001	9709001	PRJNA796753_P_NODE_45008_length_247_cov_0.885057_g44696_i0	PRJNA796753	45008	247	0.885057	2.18609079	Bonamia ostreae	126728	SAR_Eukaryotes	SAR_Eukaryotes	149	1.78e-43	NR	MES1920066.1	126728	g44696	i0	86.3	131.538461538462	80	11	97.2	0	3	242	22	101	MES1920066.1 hypothetical protein [Bonamia ostreae]	diamond	32490	149	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae
12696299	12696299	PRJNA796753_P_NODE_23690_length_307_cov_3.384615_g23378_i0	PRJNA796753	23690	307	3.384615	10.39076805	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	160	1.08e-48	NR	CEP03336.1	37360	g23378	i0	79	27.3224755700326	100	21	97.7	0	304	5	11	110	CEP03336.1 hypothetical protein PBRA_003096 [Plasmodiophora brassicae]	diamond	8388	160	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
18632327	18632327	PRJNA796753_P_NODE_7315_length_503_cov_5.820930_g7005_i0	PRJNA796753	7315	503	5.82093	29.2792779	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	173	6.689999999999999e-52	NR	CEO99768.1	37360	g7005	i0	55.2	1.88469184890656	163	61	91.8	4	502	41	2	161	CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae]	diamond	948	174	0.994252873563218	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
28799670	28799670	PRJNA796753_P_NODE_42987_length_249_cov_0.875000_g42675_i0	PRJNA796753	42987	249	0.875	2.17875	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	47.8	6.76e-4	NR	SPR00736.1	37360	g42675	i0	31.3	1.8433734939759	80	54	96.4	1	248	9	101	179	SPR00736.1 unnamed protein product [Plasmodiophora brassicae]	diamond	459	47.8	1	Eukaryota	Sar	Endomyxa	Phytomyxea	Plasmodiophorida	Plasmodiophoridae	Plasmodiophora	Plasmodiophora brassicae
32371062	32371062	PRJNA796753_P_NODE_23599_length_308_cov_1.310638_g23287_i0	PRJNA796753	23599	308	1.310638	4.03676504	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	45.1	0.00846	NR	CEO95549.1	37360	g23287	i0	32.3	1.10064935064935	62	41	60.4	1	289	104	93	153	CEO95549.1 hypothetical protein PBRA_004275 [Plasmodiophora brassicae]	diamond	339	45.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);;