metadata: contig_metadata: 14 rows where bioproject = "PRJNA1136505", tax_kingdom = "Metazoa" and tax

14 rows where bioproject = "PRJNA1136505", 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
11763134	11763134	PRJNA1136505_P_NODE_26570_length_805_cov_1.978142_g20002_i0	PRJNA1136505	26570	805	1.978142	15.9240431	Diadema antillarum	105358	Echinodermata	other_Eukaryota	215	3.38e-63	NR	XP_071507109.1	105358	g20002	i0	62.8	7.38633540372671	180	66	66.7	1	266	802	38	217	XP_071507109.1 succinate--CoA ligase [ADP-forming] subunit beta, mitochondrial-like [Diadema antillarum]	diamond	5946	215	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
16861578	16861578	PRJNA1136505_P_NODE_122314_length_260_cov_1.347594_g115454_i0	PRJNA1136505	122314	260	1.347594	3.5037444	Diadema antillarum	105358	Echinodermata	other_Eukaryota	108	2.17e-25	NR	XP_071482115.1	105358	g115454	i0	65.1	0.992307692307692	86	25	99.2	1	2	259	414	494	XP_071482115.1 delta-aminolevulinic acid dehydratase-like [Diadema antillarum]	diamond	258	108	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
21961237	21961237	PRJNA1136505_P_NODE_132298_length_250_cov_1.276836_g125438_i0	PRJNA1136505	132298	250	1.276836	3.19209	Metazoa	33208	Echinodermata	other_Eukaryota	121	7.509999999999999e-31	NR	XP_038051692.1	46514	g125438	i0	74.1	18.468	81	18	97.2	1	3	245	97	174	XP_038051692.1 ras-related GTP-binding protein C-like [Patiria miniata]	diamond	4617	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
26753511	26753511	PRJNA1136505_P_NODE_113961_length_270_cov_1.553299_g107101_i0	PRJNA1136505	113961	270	1.553299	4.1939073	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	55.5	1.77e-6	NR	XP_041460690.1	7654	g107101	i0	44.6	0.622222222222222	56	31	62.2	0	19	186	331	386	XP_041460690.1 LOW QUALITY PROTEIN: acylamino-acid-releasing enzyme-like [Lytechinus variegatus]	diamond	168	55.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
28049492	28049492	PRJNA1136505_P_NODE_26145_length_820_cov_1.887550_g19606_i0	PRJNA1136505	26145	820	1.88755	15.47791	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	61.2	1.13e-6	NR	XP_033126206.1	1529436	g19606	i0	33	0.409756097560976	112	59	37.3	5	716	411	179	284	XP_033126206.1 neurogenic locus notch homolog protein 1-like [Anneissia japonica]	diamond	336	61.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28144433	28144433	PRJNA1136505_P_NODE_150005_length_243_cov_0.905882_g143145_i0	PRJNA1136505	150005	243	0.905882	2.20129326	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	79.7	3.26e-15	NR	XP_033106107.1	1529436	g143145	i0	46.3	1.96296296296296	80	39	98.8	1	2	241	253	328	XP_033106107.1 phosphatidylserine synthase 2-like isoform X2 [Anneissia japonica]	diamond	477	79.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
29333124	29333124	PRJNA1136505_P_NODE_32989_length_638_cov_0.872566_g26208_i0	PRJNA1136505	32989	638	0.872566	5.56697108	Metazoa	33208	Echinodermata	other_Eukaryota	245	1.17e-77	NR	XP_071502326.1	105358	g26208	i0	54.5	4.01567398119122	213	95	99.2	1	6	638	73	285	XP_071502326.1 uncharacterized protein [Diadema antillarum]	diamond	2562	245	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30386714	30386714	PRJNA1136505_P_NODE_41533_length_515_cov_1.565611_g34681_i0	PRJNA1136505	41533	515	1.565611	8.06289665	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	129	5.96e-34	NR	XP_003731734.2	7668	g34681	i0	47.4	0.786407766990291	135	71	78.6	0	2	406	24	158	XP_003731734.2 leucine-rich melanocyte differentiation-associated protein [Strongylocentrotus purpuratus]	diamond	405	129	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
30596384	30596384	PRJNA1136505_P_NODE_137913_length_248_cov_0.880000_g131053_i0	PRJNA1136505	137913	248	0.88	2.1824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	59.7	4.29e-8	NR	XP_063971712.1	7653	g131053	i0	37	4.95967741935484	73	44	88.3	1	219	1	1146	1216	XP_063971712.1 GATOR1 complex protein DEPDC5-like isoform X3 [Lytechinus pictus]	diamond	1230	60.1	0.993344425956739	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
30733827	30733827	PRJNA1136505_P_NODE_38514_length_550_cov_2.834382_g31679_i0	PRJNA1136505	38514	550	2.834382	15.589101	Asterias rubens	7604	Echinodermata	other_Eukaryota	81.6	3.29e-15	NR	XP_033625166.1	7604	g31679	i0	34.4	0.872727272727273	160	95	87.3	4	32	511	20	169	XP_033625166.1 peroxisomal membrane protein 11A-like [Asterias rubens]	diamond	480	81.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
31608035	31608035	PRJNA1136505_P_NODE_100376_length_288_cov_1.074419_g93516_i0	PRJNA1136505	100376	288	1.074419	3.09432672	Echinodermata	7586	Echinodermata	other_Eukaryota	131	1.6200000000000002e-33	NR	XP_030839291.1	7668	g93516	i0	62.8	11.75	94	35	97.9	0	284	3	418	511	XP_030839291.1 uridine-cytidine kinase-like 1 isoform X3 [Strongylocentrotus purpuratus]	diamond	3384	131	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31966812	31966812	PRJNA1136505_P_NODE_98518_length_290_cov_1.682028_g91658_i0	PRJNA1136505	98518	290	1.682028	4.8778812	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	88.6	5.08e-18	NR	KAJ8036127.1	206669	g91658	i0	53.6	1.00344827586207	97	33	97.2	4	6	287	455	542	KAJ8036127.1 hypothetical protein HOLleu_20006 [Holothuria leucospilota]	diamond	291	88.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32156956	32156956	PRJNA1136505_P_NODE_72818_length_345_cov_1.132353_g65958_i0	PRJNA1136505	72818	345	1.132353	3.90661785	Diadema antillarum	105358	Echinodermata	other_Eukaryota	58.5	3.62e-7	NR	XP_071492134.1	105358	g65958	i0	33.9	0.973913043478261	112	64	93	4	23	343	183	289	XP_071492134.1 sortilin-related receptor-like [Diadema antillarum]	diamond	336	58.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
32304324	32304324	PRJNA1136505_P_NODE_45179_length_480_cov_1.113022_g38320_i0	PRJNA1136505	45179	480	1.113022	5.3425056	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	196	1.53e-54	NR	XP_033640302.1	7604	g38320	i0	60.4	71.525	159	63	99.4	0	479	3	957	1115	XP_033640302.1 cullin-associated NEDD8-dissociated protein 1-like isoform X2 [Asterias rubens]	diamond	34332	197	0.99492385786802	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens

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