metadata: contig_metadata: 13 rows where bioproject = "PRJNA704949", tax_clade = "Opisthokonta" and tax

13 rows where bioproject = "PRJNA704949", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"

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
695158	695158	PRJNA704949_P_NODE_2160401_length_162_cov_1.380531_g2145062_i0	PRJNA704949	2160401	162	1.380531	2.23646022	Diadema antillarum	105358	Echinodermata	other_Eukaryota	106	1.02e-18	NTclustered	gi\|2919566695\|ref\|XM_071625631.1\|	105358	g2145062	i0	87.097	0.574074074074074	93	12	57	0	7	99	1510	1602	PREDICTED: Diadema antillarum ragulator complex protein LAMTOR2-like (LOC139713910), mRNA	blastn	93	106	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
26713877	26713877	PRJNA704949_P_NODE_1679521_length_186_cov_2.270073_g1664182_i0	PRJNA704949	1679521	186	2.270073	4.22233578	Metazoa	33208	Echinodermata	other_Eukaryota	59.7	1.79e-8	NR	XP_033634735.1	7604	g1664182	i0	68.4	1.87096774193548	38	12	61.3	0	30	143	522	559	XP_033634735.1 cartilage oligomeric matrix protein-like [Asterias rubens]	diamond	348	59.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
26956165	26956165	PRJNA704949_P_NODE_1020382_length_257_cov_1.500000_g1005047_i0	PRJNA704949	1020382	257	1.5	3.855	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	63.5	2.07e-9	NR	XP_033111719.1	1529436	g1005047	i0	46.9	0.945525291828794	81	40	91.1	2	23	256	73	153	XP_033111719.1 uncharacterized protein LOC117112688, partial [Anneissia japonica]	diamond	243	63.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
27177864	27177864	PRJNA704949_P_NODE_224882_length_557_cov_2.545276_g210527_i0	PRJNA704949	224882	557	2.545276	14.17718732	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	58.5	2.79e-6	NR	XP_030853897.1	7668	g210527	i0	33.3	0.484739676840215	90	48	47.9	3	57	323	442	520	XP_030853897.1 pappalysin-1 [Strongylocentrotus purpuratus]	diamond	270	58.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
27789025	27789025	PRJNA704949_P_NODE_1325164_length_218_cov_1.230769_g1309827_i0	PRJNA704949	1325164	218	1.230769	2.68307642	Echinodermata	7586	Echinodermata	other_Eukaryota	89.7	4.62e-19	NR	XP_030833558.1	7668	g1309827	i0	62.5	5.88990825688073	72	27	99.1	0	2	217	200	271	XP_030833558.1 ammonium transporter Rh type B-A isoform X2 [Strongylocentrotus purpuratus]	diamond	1284	90.5	0.991160220994475	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
28030686	28030686	PRJNA704949_P_NODE_1683765_length_186_cov_1.518248_g1668426_i0	PRJNA704949	1683765	186	1.518248	2.82394128	Diadema antillarum	105358	Echinodermata	other_Eukaryota	49.3	8.48e-5	NR	XP_071500307.1	105358	g1668426	i0	48.2	0.903225806451613	56	22	88.7	3	181	17	625	674	XP_071500307.1 pappalysin-1-like [Diadema antillarum]	diamond	168	49.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
28694018	28694018	PRJNA704949_P_NODE_2107307_length_164_cov_0.904348_g2091968_i0	PRJNA704949	2107307	164	0.904348	1.48313072	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	57	1.18e-7	NR	KAJ8046311.1	206669	g2091968	i0	78.1	4.15243902439024	32	7	58.5	0	3	98	417	448	KAJ8046311.1 Ubiquitin carboxyl-terminal hydrolase 19 [Holothuria leucospilota]	diamond	681	57	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29230770	29230770	PRJNA704949_P_NODE_2079789_length_165_cov_0.896552_g2064450_i0	PRJNA704949	2079789	165	0.896552	1.4793108	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	58.2	4.62e-8	NR	PIK46528.1	307972	g2064450	i0	55.1	0.890909090909091	49	22	89.1	0	14	160	577	625	PIK46528.1 putative ras GTPase-activating protein 3, partial [Apostichopus japonicus]	diamond	147	58.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
29367730	29367730	PRJNA704949_P_NODE_1451949_length_205_cov_1.666667_g1436611_i0	PRJNA704949	1451949	205	1.666667	3.41666735	Aspidochirotida	7682	Echinodermata	other_Eukaryota	116	2.23e-28	NR	KAJ8039315.1	206669	g1436611	i0	78.8	17.4292682926829	66	14	96.6	0	7	204	848	913	KAJ8039315.1 Pre-mRNA-splicing factor ATP-dependent RNA helicase DHX16 [Holothuria leucospilota]	diamond	3573	116	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29609233	29609233	PRJNA704949_P_NODE_577850_length_357_cov_2.750000_g562534_i0	PRJNA704949	577850	357	2.75	9.8175	Asterias rubens	7604	Echinodermata	other_Eukaryota	81.3	4.71e-15	NR	XP_033624642.1	7604	g562534	i0	40.4	1.78991596638655	99	54	79.8	3	4	288	74	171	XP_033624642.1 macrophage mannose receptor 1-like [Asterias rubens]	diamond	639	81.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
29704026	29704026	PRJNA704949_P_NODE_939510_length_270_cov_2.352941_g924176_i0	PRJNA704949	939510	270	2.352941	6.3529407	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	65.5	5.15e-10	NR	XP_063966125.1	7653	g924176	i0	43.8	0.988888888888889	89	45	94.4	3	12	266	702	789	XP_063966125.1 uncharacterized protein LOC135156774 [Lytechinus pictus]	diamond	267	65.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
31188786	31188786	PRJNA704949_P_NODE_401495_length_429_cov_1.731579_g386383_i0	PRJNA704949	401495	429	1.731579	7.42847391	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	50.1	4.17e-4	NR	XP_033119204.1	1529436	g386383	i0	59.5	0.258741258741259	37	15	25.9	0	111	1	1	37	XP_033119204.1 inosine triphosphate pyrophosphatase-like isoform X2 [Anneissia japonica]	diamond	111	50.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32675154	32675154	PRJNA704949_P_NODE_1931000_length_169_cov_0.866667_g1915661_i0	PRJNA704949	1931000	169	0.866667	1.46466723	Patiria miniata	46514	Echinodermata	other_Eukaryota	51.6	1.03e-5	NR	XP_038049847.1	46514	g1915661	i0	43.1	1.57988165680473	51	28	90.5	1	159	7	106	155	XP_038049847.1 anosmin-1-like isoform X2 [Patiria miniata]	diamond	267	51.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata

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