metadata: contig_metadata: 15 rows where bioproject = "PRJNA854078", tax_kingdom = "Metazoa" and tax

15 rows where bioproject = "PRJNA854078", 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
5944859	5944859	PRJNA854078_P_NODE_1485_length_785_cov_2.556180_g1297_i0	PRJNA854078	1485	785	2.55618	20.066013	Asteroidea	7588	Echinodermata	other_Eukaryota	353	1.66e-118	NR	XP_033633413.1	7604	g1297	i0	66.3	16.0165605095541	261	87	99.4	1	6	785	108	368	XP_033633413.1 isocitrate dehydrogenase [NAD] subunit beta, mitochondrial-like [Asterias rubens]	diamond	12573	356	0.991573033707865	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
7219903	7219903	PRJNA854078_P_NODE_6386_length_373_cov_1.026667_g6174_i0	PRJNA854078	6386	373	1.026667	3.82946791	Diadema antillarum	105358	Echinodermata	other_Eukaryota	159	1.33e-43	NR	XP_071496815.1	105358	g6174	i0	61.5	4.85790884718499	122	47	98.1	0	5	370	102	223	XP_071496815.1 tRNA-dihydrouridine(20) synthase [NAD(P)+]-like [Diadema antillarum]	diamond	1812	159	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
14869670	14869670	PRJNA854078_P_NODE_3012_length_547_cov_2.487342_g2800_i0	PRJNA854078	3012	547	2.487342	13.60576074	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	291	1.05e-73	NTclustered	gi\|2037937404\|ref\|XM_041617748.1\|	7654	g2800	i0	80.789	54.0566727605119	380	65	69	7	93	467	158	534	PREDICTED: Lytechinus variegatus ras-related protein Rac1 (LOC121422598), mRNA	blastn	29569	291	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
22518457	22518457	PRJNA854078_P_NODE_3938_length_479_cov_5.763547_g3726_i0	PRJNA854078	3938	479	5.763547	27.60739013	Paracentrotus lividus	7656	Echinodermata	other_Eukaryota	272	3.2899999999999993e-68	NTclustered	gi\|557665\|emb\|X76081.1\|	7656	g3726	i0	79.839	74.7912317327766	372	75	78	0	1	372	104	475	P.lividus H3.3 Histone mRNA	blastn	35825	272	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Echinidae	Paracentrotus	Paracentrotus lividus
25461461	25461461	PRJNA854078_P_NODE_460_length_1366_cov_1.924981_g358_i0	PRJNA854078	460	1366	1.924981	26.29524046	Asterias rubens	7604	Echinodermata	other_Eukaryota	501	8.05e-173	NR	XP_033631755.1	7604	g358	i0	56	4.61200585651537	420	182	92.2	1	1366	107	13	429	XP_033631755.1 adenylosuccinate synthetase isozyme 1-like [Asterias rubens]	diamond	6300	501	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
26738075	26738075	PRJNA854078_P_NODE_7381_length_346_cov_4.549451_g7169_i0	PRJNA854078	7381	346	4.549451	15.74110046	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	110	1.96e-27	NR	XP_033102066.1	1529436	g7169	i0	59.3	3.10404624277457	86	35	74.6	0	7	264	149	234	XP_033102066.1 probable Bax inhibitor 1 [Anneissia japonica]	diamond	1074	110	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
26738076	26738076	PRJNA854078_P_NODE_7961_length_333_cov_2.073077_g7749_i0	PRJNA854078	7961	333	2.073077	6.90334641	Diadema antillarum	105358	Echinodermata	other_Eukaryota	107	1.18e-24	NR	XP_071506062.1	105358	g7749	i0	53.2	5.9009009009009	109	51	98.2	0	330	4	225	333	XP_071506062.1 annexin-B12-like [Diadema antillarum]	diamond	1965	107	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27055134	27055134	PRJNA854078_P_NODE_11982_length_272_cov_1.547739_g11770_i0	PRJNA854078	11982	272	1.547739	4.20985008	Diadema antillarum	105358	Echinodermata	other_Eukaryota	98.2	3.84e-23	NR	XP_071506697.1	105358	g11770	i0	53.8	1.00367647058824	91	39	97.1	2	266	3	51	141	XP_071506697.1 apolipoprotein D-like [Diadema antillarum]	diamond	273	98.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
29368518	29368518	PRJNA854078_P_NODE_5929_length_388_cov_1.412698_g5717_i0	PRJNA854078	5929	388	1.412698	5.48126824	Metazoa	33208	Echinodermata	other_Eukaryota	105	2.0199999999999994e-23	NR	XP_033642153.1	7604	g5717	i0	46.5	5.90721649484536	127	67	98.2	1	4	384	279	404	XP_033642153.1 ATP-dependent RNA helicase DDX19A-like [Asterias rubens]	diamond	2292	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
29423234	29423234	PRJNA854078_P_NODE_9149_length_311_cov_2.079832_g8937_i0	PRJNA854078	9149	311	2.079832	6.46827752	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	63.5	3.75e-9	NR	XP_033107655.1	1529436	g8937	i0	58.8	0.491961414790997	51	21	49.2	0	310	158	259	309	XP_033107655.1 translocation protein SEC62-like [Anneissia japonica]	diamond	153	63.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
29683881	29683881	PRJNA854078_P_NODE_15610_length_245_cov_0.895349_g15398_i0	PRJNA854078	15610	245	0.895349	2.19360505	Echinodermata	7586	Echinodermata	other_Eukaryota	98.6	8.6e-22	NR	XP_038074412.1	46514	g15398	i0	54.2	9	83	36	99.2	1	244	2	533	615	XP_038074412.1 advillin-like isoform X2 [Patiria miniata]	diamond	2205	99	0.995959595959596	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30466071	30466071	PRJNA854078_P_NODE_12513_length_266_cov_1.196891_g12301_i0	PRJNA854078	12513	266	1.196891	3.18373006	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	56.6	6.63e-7	NR	XP_041455129.1	7654	g12301	i0	31.2	9.38345864661654	93	59	99.2	2	1	264	928	1020	XP_041455129.1 uncharacterized protein LOC121407938 [Lytechinus variegatus]	diamond	2496	57	0.992982456140351	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30939889	30939889	PRJNA854078_P_NODE_7394_length_346_cov_1.692308_g7182_i0	PRJNA854078	7394	346	1.692308	5.85538568	Diadema antillarum	105358	Echinodermata	other_Eukaryota	76.6	1.46e-13	NR	XP_071495332.1	105358	g7182	i0	44.9	1.50867052023121	89	41	73.7	2	327	73	320	404	XP_071495332.1 sodium-coupled neutral amino acid transporter 7-like [Diadema antillarum]	diamond	522	76.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
32489686	32489686	PRJNA854078_P_NODE_14479_length_249_cov_1.312500_g14267_i0	PRJNA854078	14479	249	1.3125	3.268125	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	56.2	7.18e-7	NR	XP_063959288.1	7653	g14267	i0	40	5.13253012048193	60	35	72.3	1	23	202	756	814	XP_063959288.1 sortilin-related receptor-like [Lytechinus pictus]	diamond	1278	56.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
32710207	32710207	PRJNA854078_P_NODE_16480_length_241_cov_1.821429_g16268_i0	PRJNA854078	16480	241	1.821429	4.38964389	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	42.7	0.0363	NR	XP_030831332.1	7668	g16268	i0	35	0.995850622406639	80	39	97.1	4	239	6	847	915	XP_030831332.1 Golgi apparatus protein 1 [Strongylocentrotus purpuratus]	diamond	240	42.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus

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