metadata: contig_metadata: 7 rows where bioproject = "PRJDB9741", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJDB9741", tax_kingdom = "Metazoa" 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
16587713	16587713	PRJDB9741_P_NODE_15614_length_185_cov_2.551471_g15297_i0	PRJDB9741	15614	185	2.551471	4.72022135	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	69.3	3.17e-13	NR	KAJ8030924.1	206669	g15297	i0	65.4	0.843243243243243	52	18	84.3	0	30	185	1	52	KAJ8030924.1 Profilin-1A [Holothuria leucospilota]	diamond	156	69.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
26684194	26684194	PRJDB9741_P_NODE_37561_length_162_cov_0.902655_g37244_i0	PRJDB9741	37561	162	0.902655	1.4623011	Acanthaster planci	133434	Echinodermata	other_Eukaryota	60.1	9.3e-9	NR	XP_022094920.1	133434	g37244	i0	47.3	1.01851851851852	55	25	96.3	2	5	160	455	508	XP_022094920.1 papilin-like [Acanthaster planci]	diamond	165	60.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
29900369	29900369	PRJDB9741_P_NODE_26251_length_168_cov_1.966387_g25934_i0	PRJDB9741	26251	168	1.966387	3.30353016	Metazoa	33208	Echinodermata	other_Eukaryota	58.5	8.34e-9	NR	XP_038052584.1	46514	g25934	i0	55.6	2.57142857142857	45	19	80.4	1	34	168	1	44	XP_038052584.1 40S ribosomal protein S10-like [Patiria miniata]	diamond	432	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30215975	30215975	PRJDB9741_P_NODE_2672_length_442_cov_2.055980_g2358_i0	PRJDB9741	2672	442	2.05598	9.0874316	Metazoa	33208	Echinodermata	other_Eukaryota	136	2.37e-38	NR	XP_071499965.1	105358	g2358	i0	70.1	21.5226244343891	97	29	65.8	0	2	292	27	123	XP_071499965.1 large ribosomal subunit protein eL31-like [Diadema antillarum]	diamond	9513	137	0.992700729927007	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30443420	30443420	PRJDB9741_P_NODE_37793_length_162_cov_0.902655_g37476_i0	PRJDB9741	37793	162	0.902655	1.4623011	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	57.4	8.45e-8	NR	XP_033112690.1	1529436	g37476	i0	52.4	5.01851851851852	42	20	77.8	0	126	1	124	165	XP_033112690.1 N-acylethanolamine-hydrolyzing acid amidase-like [Anneissia japonica]	diamond	813	57.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
31296377	31296377	PRJDB9741_P_NODE_38215_length_162_cov_0.902655_g37898_i0	PRJDB9741	38215	162	0.902655	1.4623011	Patiria miniata	46514	Echinodermata	other_Eukaryota	41.2	0.0439	NR	XP_038069641.1	46514	g37898	i0	38.9	3	54	32	98.1	1	161	3	14	67	XP_038069641.1 E3 ubiquitin-protein ligase RBBP6-like [Patiria miniata]	diamond	486	41.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
32435633	32435633	PRJDB9741_P_NODE_30019_length_166_cov_0.871795_g29702_i0	PRJDB9741	30019	166	0.871795	1.4471797	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	45.4	0.00148	NR	KAJ8047209.1	206669	g29702	i0	73.3	3.79518072289157	30	8	54.2	0	165	76	135	164	KAJ8047209.1 Histone deacetylase 11 [Holothuria leucospilota]	diamond	630	45.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota

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