metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA879314" and tax_phylum = "Cnidaria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16160527	16160527	PRJNA879314_P_NODE_4873_length_252_cov_1.592179_g4823_i0	PRJNA879314	4873	252	1.592179	4.01229108	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	153	4.29e-43	NR	KAF0991085.1	69463	g4823	i0	95.2	1.97619047619048	83	4	98.8	0	3	251	116	198	KAF0991085.1 hypothetical protein HZS_2859, partial [Henneguya salminicola]	diamond	498	153	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
26802044	26802044	PRJNA879314_P_NODE_7601_length_248_cov_0.891429_g7551_i0	PRJNA879314	7601	248	0.891429	2.21074392	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	158	1.27e-47	NR	KAF0986127.1	69463	g7551	i0	96.3	0.991935483870968	82	3	99.2	0	1	246	66	147	KAF0986127.1 hypothetical protein HZS_7156 [Henneguya salminicola]	diamond	246	158	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
26928777	26928777	PRJNA879314_P_NODE_8722_length_246_cov_0.901734_g8672_i0	PRJNA879314	8722	246	0.901734	2.21826564	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	112	9.66e-30	NR	KAF1741624.1	59785	g8672	i0	64.2	0.98780487804878	81	29	98.8	0	246	4	37	117	KAF1741624.1 hypothetical protein MXB_3329 [Myxobolus squamalis]	diamond	243	112	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
27149677	27149677	PRJNA879314_P_NODE_10342_length_243_cov_0.917647_g10292_i0	PRJNA879314	10342	243	0.917647	2.22988221	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	107	7.3e-28	NR	KAF0992106.1	69463	g10292	i0	71.8	0.876543209876543	71	20	87.7	0	3	215	57	127	KAF0992106.1 hypothetical protein HZS_2137 [Henneguya salminicola]	diamond	213	107	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
27624170	27624170	PRJNA879314_P_NODE_2184_length_319_cov_0.951220_g2134_i0	PRJNA879314	2184	319	0.95122	3.0343918	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	160	7.42e-48	NR	KII67427.1	669202	g2134	i0	67	1.99373040752351	106	35	99.7	0	319	2	62	167	KII67427.1 Phosphatidylethanolamine-binding protein F40A3.3 [Thelohanellus kitauei]	diamond	636	160	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei
29454894	29454894	PRJNA879314_P_NODE_11510_length_228_cov_2.012903_g11460_i0	PRJNA879314	11510	228	2.012903	4.5894188400000004	Myxobolus squamalis	59785	Cnidaria	other_Eukaryota	124	7.309999999999999e-32	NR	KAF1743716.1	59785	g11460	i0	77.3	0.986842105263158	75	17	98.7	0	228	4	105	179	KAF1743716.1 hypothetical protein MXB_4876 [Myxobolus squamalis]	diamond	225	124	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
30466361	30466361	PRJNA879314_P_NODE_3353_length_277_cov_1.495098_g3303_i0	PRJNA879314	3353	277	1.495098	4.14142146	Henneguya salminicola	69463	Cnidaria	other_Eukaryota	121	6.459999999999999e-31	NR	KAF0992879.1	69463	g3303	i0	54.5	0.953068592057762	88	40	95.3	0	6	269	159	246	KAF0992879.1 hypothetical protein HZS_3711, partial [Henneguya salminicola]	diamond	264	121	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Henneguya	Henneguya salminicola
30726752	30726752	PRJNA879314_P_NODE_3274_length_279_cov_2.218447_g3224_i0	PRJNA879314	3274	279	2.218447	6.18946713	Myxobolus	35588	Cnidaria	other_Eukaryota	139	5.54e-40	NR	KAF1742241.1	59785	g3224	i0	80.6	3.01075268817204	93	17	98.9	1	277	2	25	117	KAF1742241.1 hypothetical protein MXB_1441 [Myxobolus squamalis]	diamond	840	139	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Myxobolus	Myxobolus squamalis
32584786	32584786	PRJNA879314_P_NODE_10399_length_243_cov_0.917647_g10349_i0	PRJNA879314	10399	243	0.917647	2.22988221	Thelohanellus kitauei	669202	Cnidaria	other_Eukaryota	79.3	1.18e-16	NR	KII61387.1	669202	g10349	i0	79.2	0.592592592592593	48	10	59.3	0	17	160	95	142	KII61387.1 60S ribosomal protein L26 [Thelohanellus kitauei]	diamond	144	79.3	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Myxozoa	Bivalvulida	Myxobolidae	Thelohanellus	Thelohanellus kitauei

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);;