metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Priapulida"

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
28597099	28597099	PRJNA641707_P_NODE_185227_length_199_cov_8.940000_g182564_i0	PRJNA641707	185227	199	8.94	17.7906	Priapulus caudatus	37621	Priapulida	other_Eukaryota	45.4	0.00241	NR	XP_014662007.1	37621	g182564	i0	57.6	0.49748743718593	33	14	49.7	0	198	100	972	1004	XP_014662007.1 PREDICTED: cadherin-related tumor suppressor-like, partial [Priapulus caudatus]	diamond	99	45.4	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
28956949	28956949	PRJNA641707_P_NODE_99308_length_246_cov_4.324873_g96645_i0	PRJNA641707	99308	246	4.324873	10.63918758	Metazoa	33208	Priapulida	other_Eukaryota	66.2	2.07e-10	NR	XP_014666275.1	37621	g96645	i0	78.8	1.20731707317073	33	7	40.2	0	243	145	220	252	XP_014666275.1 PREDICTED: peroxisomal multifunctional enzyme type 2-like [Priapulus caudatus]	diamond	297	66.2	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
28988521	28988521	PRJNA641707_P_NODE_193968_length_198_cov_7.530201_g191305_i0	PRJNA641707	193968	198	7.530201	14.90979798	Metazoa	33208	Priapulida	other_Eukaryota	105	2.09e-26	NR	XP_014672890.1	37621	g191305	i0	71.2	28.7424242424242	73	12	97	1	7	198	18	90	XP_014672890.1 PREDICTED: ER lumen protein-retaining receptor 2 [Priapulus caudatus]	diamond	5691	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29398685	29398685	PRJNA641707_P_NODE_198189_length_197_cov_16.891892_g195526_i0	PRJNA641707	198189	197	16.891892	33.27702724	Metazoa	33208	Priapulida	other_Eukaryota	52	1.09e-5	NR	XP_014668508.1	37621	g195526	i0	61.3	1.91878172588832	31	12	47.2	0	193	101	138	168	XP_014668508.1 PREDICTED: probable serine incorporator isoform X2 [Priapulus caudatus]	diamond	378	52	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29417729	29417729	PRJNA641707_P_NODE_118969_length_245_cov_9.285714_g116306_i0	PRJNA641707	118969	245	9.285714	22.7499993	Priapulus caudatus	37621	Priapulida	other_Eukaryota	44.7	0.00813	NR	XP_014673105.1	37621	g116306	i0	69.7	2.02040816326531	33	9	39.2	1	148	243	766	798	XP_014673105.1 PREDICTED: WD repeat-containing protein 19-like [Priapulus caudatus]	diamond	495	44.7	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29449350	29449350	PRJNA641707_P_NODE_333990_length_153_cov_2.788462_g331327_i0	PRJNA641707	333990	153	2.788462	4.26634686	Priapulus caudatus	37621	Priapulida	other_Eukaryota	44.3	0.00324	NR	XP_014668067.1	37621	g331327	i0	56.8	3.23529411764706	37	13	72.5	1	43	153	595	628	XP_014668067.1 PREDICTED: dedicator of cytokinesis protein 7-like [Priapulus caudatus]	diamond	495	44.3	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29904081	29904081	PRJNA641707_P_NODE_29311_length_400_cov_5.279202_g26705_i0	PRJNA641707	29311	400	5.279202	21.116808	Metazoa	33208	Priapulida	other_Eukaryota	56.6	3.09e-6	NR	XP_014674831.1	37621	g26705	i0	66.7	1.485	33	11	24.8	0	206	108	2147	2179	XP_014674831.1 PREDICTED: LOW QUALITY PROTEIN: filamin-A-like [Priapulus caudatus]	diamond	594	56.6	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31104389	31104389	PRJNA641707_P_NODE_175915_length_200_cov_10.701987_g173252_i0	PRJNA641707	175915	200	10.701987	21.403974	Metazoa	33208	Priapulida	other_Eukaryota	42	0.0404	NR	XP_014669624.1	37621	g173252	i0	59.4	0.945	32	12	46.5	1	10	102	119	150	XP_014669624.1 PREDICTED: ras GTPase-activating protein 1-like [Priapulus caudatus]	diamond	189	42.4	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31376850	31376850	PRJNA641707_P_NODE_228536_length_190_cov_14.460993_g225873_i0	PRJNA641707	228536	190	14.460993	27.4758867	Priapulus caudatus	37621	Priapulida	other_Eukaryota	69.7	5.58e-12	NR	XP_014661859.1	37621	g225873	i0	55.9	0.931578947368421	59	26	93.2	0	179	3	659	717	XP_014661859.1 PREDICTED: ubiquitin carboxyl-terminal hydrolase 24-like [Priapulus caudatus]	diamond	177	69.7	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
32799120	32799120	PRJNA641707_P_NODE_335760_length_152_cov_4.417476_g333097_i0	PRJNA641707	335760	152	4.417476	6.71456352	Priapulus caudatus	37621	Priapulida	other_Eukaryota	67	2.9099999999999998e-11	NR	XP_014675302.1	37621	g333097	i0	63.3	0.967105263157895	49	18	96.7	0	147	1	409	457	XP_014675302.1 PREDICTED: delta(14)-sterol reductase-like [Priapulus caudatus]	diamond	147	67	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus

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