metadata: contig_metadata: 9 rows where bioproject = "PRJNA437204", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA437204", tax_clade = "Opisthokonta" 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
2983808	2983808	PRJNA437204_P_NODE_68463_length_267_cov_1.587629_g68164_i0	PRJNA437204	68463	267	1.587629	4.23896943	Priapulus caudatus	37621	Priapulida	other_Eukaryota	244	3.76e-60	NTclustered	gi\|957829796\|ref\|XM_014809339.1\|	37621	g68164	i0	83.333	11.0337078651685	270	39	100	5	1	267	2760	3026	PREDICTED: Priapulus caudatus splicing factor 3B subunit 1-like (LOC106807090), mRNA	blastn	2946	244	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
18285301	18285301	PRJNA437204_P_NODE_9795_length_542_cov_3.923241_g9497_i0	PRJNA437204	9795	542	3.923241	21.26396622	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	179	6.27e-54	NR	XP_014672145.1	37621	g9497	i0	48.9	16.4114391143911	176	87	95.8	2	24	542	2	177	XP_014672145.1 PREDICTED: 60S ribosomal protein L9-like isoform X2 [Priapulus caudatus]	diamond	8895	180	0.994444444444444	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
20835048	20835048	PRJNA437204_P_NODE_8257_length_580_cov_1.530572_g7961_i0	PRJNA437204	8257	580	1.530572	8.8773176	Priapulus caudatus	37621	Priapulida	other_Eukaryota	446	2.25e-120	NTclustered	gi\|957824943\|ref\|XM_014806747.1\|	37621	g7961	i0	81.019	56.8706896551724	569	100	97	8	16	580	973	409	PREDICTED: Priapulus caudatus NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial-like (LOC106805230), transcript variant X2, mRNA	blastn	32985	446	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
24659968	24659968	PRJNA437204_P_NODE_98520_length_247_cov_0.885057_g98221_i0	PRJNA437204	98520	247	0.885057	2.18609079	Priapulus caudatus	37621	Priapulida	other_Eukaryota	141	4.63e-29	NTclustered	gi\|957858457\|ref\|XM_014822816.1\|	37621	g98221	i0	84.892	6.46558704453441	139	21	56	0	10	148	1710	1572	PREDICTED: Priapulus caudatus brain tumor protein-like (LOC106818100), partial mRNA	blastn	1597	141	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29965977	29965977	PRJNA437204_P_NODE_32711_length_346_cov_3.347985_g32412_i0	PRJNA437204	32711	346	3.347985	11.5840281	Metazoa	33208	Priapulida	other_Eukaryota	68.9	7.86e-11	NR	XP_014672976.1	37621	g32412	i0	36.8	2.55780346820809	95	59	81.5	1	2	283	236	330	XP_014672976.1 PREDICTED: moesin/ezrin/radixin homolog 1-like [Priapulus caudatus]	diamond	885	68.9	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
30818998	30818998	PRJNA437204_P_NODE_105774_length_246_cov_0.890173_g105475_i0	PRJNA437204	105774	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	74.7	1.96e-13	NR	XP_014664776.1	37621	g105475	i0	48.8	15.8170731707317	82	41	98.8	1	245	3	16	97	XP_014664776.1 PREDICTED: dual specificity protein phosphatase CDC14A-like [Priapulus caudatus]	diamond	3891	74.7	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
30882096	30882096	PRJNA437204_P_NODE_47274_length_306_cov_1.982833_g46975_i0	PRJNA437204	47274	306	1.982833	6.06746898	Metazoa	33208	Priapulida	other_Eukaryota	127	4.23e-34	NR	XP_014667732.1	37621	g46975	i0	78.1	64.6372549019608	73	16	71.6	0	305	87	173	245	XP_014667732.1 PREDICTED: peroxiredoxin-4-like [Priapulus caudatus]	diamond	19779	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31546186	31546186	PRJNA437204_P_NODE_102816_length_246_cov_0.890173_g102517_i0	PRJNA437204	102816	246	0.890173	2.18982558	Metazoa	33208	Priapulida	other_Eukaryota	68.6	8.87e-12	NR	XP_014665795.1	37621	g102517	i0	46.3	4.65853658536585	95	37	98.8	3	2	244	14	108	XP_014665795.1 PREDICTED: Golgi SNAP receptor complex member 1-like [Priapulus caudatus]	diamond	1146	68.6	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
32210406	32210406	PRJNA437204_P_NODE_13438_length_479_cov_1.327586_g13139_i0	PRJNA437204	13438	479	1.327586	6.35913694	root	1	Root_unresolved	Root_unresolved	226	1.06e-69	NR	XP_014671740.1	37621	g13139	i0	66.9	40.3402922755741	157	52	98.3	0	9	479	7	163	XP_014671740.1 PREDICTED: adenosylhomocysteinase-like [Priapulus caudatus]	diamond	19323	226	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);;