metadata: contig_metadata: 12 rows where bioproject = "PRJNA408129", tax_kingdom = "Metazoa" and tax

12 rows where bioproject = "PRJNA408129", 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
2358175	2358175	PRJNA408129_S_NODE_262_length_494_cov_20.199125_g245_i0	PRJNA408129	262	494	20.199125	99.7836775	Metazoa	33208	Echinodermata	other_Eukaryota	114	4.14e-26	NR	XP_041469585.1	7654	g245	i0	81.7	5.78137651821862	71	13	43.1	0	4	216	655	725	XP_041469585.1 heat shock protein HSP 90-beta-like [Lytechinus variegatus]	diamond	2856	114	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
4245509	4245509	PRJNA408129_S_NODE_2644_length_313_cov_9.177536_g2626_i0	PRJNA408129	2644	313	9.177536	28.72568768	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	103	5.1199999999999996e-23	NR	XP_063971153.1	7653	g2626	i0	55.4	2.49201277955272	83	37	79.6	0	19	267	554	636	XP_063971153.1 uncharacterized protein LOC129263814 [Lytechinus pictus]	diamond	780	103	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
14447225	14447225	PRJNA408129_S_NODE_1292_length_365_cov_6.356707_g1274_i0	PRJNA408129	1292	365	6.356707	23.20198055	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	56.5	0.003	NTclustered	gi\|1752404521\|ref\|XM_781694.5\|	7668	g1274	i0	96.97	0.0904109589041096	33	1	9	0	3	35	1649	1681	PREDICTED: Strongylocentrotus purpuratus aldehyde dehydrogenase, mitochondrial (LOC581706), mRNA	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
28338866	28338866	PRJNA408129_S_NODE_3906_length_285_cov_5.100806_g3888_i0	PRJNA408129	3906	285	5.100806	14.5372971	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	54.7	3.78e-6	NR	XP_063963902.1	7653	g3888	i0	82.1	0.294736842105263	28	5	29.5	0	174	91	388	415	XP_063963902.1 uncharacterized protein LOC135156187 [Lytechinus pictus]	diamond	84	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
28496830	28496830	PRJNA408129_S_NODE_2167_length_328_cov_7.938144_g2149_i0	PRJNA408129	2167	328	7.938144	26.03711232	Diadema antillarum	105358	Echinodermata	other_Eukaryota	102	5.64e-25	NR	XP_071480145.1	105358	g2149	i0	53.5	0.786585365853659	86	40	78.7	0	324	67	93	178	XP_071480145.1 peptidyl-tRNA hydrolase 2, mitochondrial-like [Diadema antillarum]	diamond	258	102	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
28639852	28639852	PRJNA408129_S_NODE_23627_length_170_cov_1.676692_g23609_i0	PRJNA408129	23627	170	1.676692	2.8503764	Echinodermata	7586	Echinodermata	other_Eukaryota	45.4	0.00156	NR	KAJ8018801.1	206669	g23609	i0	54.5	1.18235294117647	33	15	58.2	0	45	143	34	66	KAJ8018801.1 hypothetical protein HOLleu_43011 [Holothuria leucospilota]	diamond	201	45.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29538553	29538553	PRJNA408129_S_NODE_7770_length_238_cov_2.064677_g7752_i0	PRJNA408129	7770	238	2.064677	4.91393126	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	49.7	1.25e-4	NR	KAJ8041484.1	206669	g7752	i0	46.7	0.756302521008403	60	30	75.6	1	30	209	128	185	KAJ8041484.1 hypothetical protein HOLleu_12311 [Holothuria leucospilota]	diamond	180	49.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
29997569	29997569	PRJNA408129_S_NODE_20791_length_177_cov_1.271429_g20773_i0	PRJNA408129	20791	177	1.271429	2.25042933	Metazoa	33208	Echinodermata	other_Eukaryota	42	0.0299	NR	XP_071476076.1	105358	g20773	i0	51.4	1.28813559322034	35	17	59.3	0	168	64	84	118	XP_071476076.1 uncharacterized protein [Diadema antillarum]	diamond	228	42.4	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30012506	30012506	PRJNA408129_S_NODE_8011_length_236_cov_2.623116_g7993_i0	PRJNA408129	8011	236	2.623116	6.19055376	Asterias rubens	7604	Echinodermata	other_Eukaryota	56.6	2.59e-7	NR	XP_033643243.1	7604	g7993	i0	83.3	1.14406779661017	30	5	38.1	0	234	145	203	232	XP_033643243.1 proteasome subunit beta type-1-like [Asterias rubens]	diamond	270	56.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
30123607	30123607	PRJNA408129_S_NODE_18792_length_182_cov_3.468966_g18774_i0	PRJNA408129	18792	182	3.468966	6.31351812	Metazoa	33208	Echinodermata	other_Eukaryota	48.1	1.06e-4	NR	XP_022106393.1	133434	g18774	i0	38.6	2.37362637362637	57	34	94	1	172	2	97	152	XP_022106393.1 uncharacterized protein LOC110987709 [Acanthaster planci]	diamond	432	48.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
30170177	30170177	PRJNA408129_S_NODE_1012_length_386_cov_5.051576_g994_i0	PRJNA408129	1012	386	5.051576	19.49908336	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	59.3	1.75e-7	NR	KAJ8025218.1	206669	g994	i0	53.3	0.349740932642487	45	21	35	0	1	135	210	254	KAJ8025218.1 Cation-dependent mannose-6-phosphate receptor [Holothuria leucospilota]	diamond	135	59.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32035406	32035406	PRJNA408129_S_NODE_13338_length_203_cov_2.289157_g13320_i0	PRJNA408129	13338	203	2.289157	4.64698871	Acanthaster planci	133434	Echinodermata	other_Eukaryota	45.1	0.00341	NR	XP_022109481.1	133434	g13320	i0	40	0.812807881773399	55	29	81.3	2	198	34	226	276	XP_022109481.1 uncharacterized protein K02A2.6-like [Acanthaster planci]	diamond	165	45.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci

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