metadata: contig_metadata: 11 rows where bioproject = "PRJDB14274", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJDB14274", 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
7660872	7660872	PRJDB14274_S_NODE_7507_length_231_cov_1.517647_g7429_i0	PRJDB14274	7507	231	1.517647	3.50576457	Metazoa	33208	Echinodermata	other_Eukaryota	116	3.9199999999999995e-30	NR	XP_041475269.1	7654	g7429	i0	72	1.94805194805195	75	21	97.4	0	4	228	148	222	XP_041475269.1 ATP-dependent Clp protease proteolytic subunit, mitochondrial-like [Lytechinus variegatus]	diamond	450	117	0.991452991452991	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
16585354	16585354	PRJDB14274_S_NODE_10234_length_202_cov_1.120567_g10156_i0	PRJDB14274	10234	202	1.120567	2.26354534	Diadema antillarum	105358	Echinodermata	other_Eukaryota	54.7	0.005	NTclustered	gi\|2919441174\|ref\|XM_071638947.1\|	105358	g10156	i0	100	1.14356435643564	29	0	14	0	113	141	526	498	PREDICTED: Diadema antillarum marginal zone B- and B1-cell-specific protein-like (LOC139727976), mRNA	blastn	231	54.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
17860402	17860402	PRJDB14274_S_NODE_6175_length_253_cov_1.151042_g6097_i0	PRJDB14274	6175	253	1.151042	2.91213626	Diadema antillarum	105358	Echinodermata	other_Eukaryota	67.6	8.2e-7	NTclustered	gi\|2919480452\|ref\|XM_071645794.1\|	105358	g6097	i0	100	12.9367588932806	36	0	14	0	9	44	10601	10566	PREDICTED: Diadema antillarum helicase domino-like (LOC139735020), mRNA	blastn	3273	67.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
27406023	27406023	PRJDB14274_S_NODE_963_length_613_cov_2.143116_g888_i0	PRJDB14274	963	613	2.143116	13.13730108	Metazoa	33208	Echinodermata	other_Eukaryota	114	4.15e-26	NR	AAL05452.1	7594	g888	i0	41.5	15.8319738988581	183	90	83.2	5	511	2	55	233	AAL05452.1 cyclin B [Patiria pectinifera]	diamond	9705	114	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria pectinifera
28138110	28138110	PRJDB14274_S_NODE_6225_length_252_cov_1.162304_g6147_i0	PRJDB14274	6225	252	1.162304	2.92900608	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	91.7	2.38e-19	NR	PIK37567.1	307972	g6147	i0	48.2	3.91666666666667	83	43	98.8	0	2	250	263	345	PIK37567.1 hypothetical protein BSL78_25594 [Apostichopus japonicus]	diamond	987	91.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
28289703	28289703	PRJDB14274_S_NODE_5226_length_273_cov_1.613208_g5148_i0	PRJDB14274	5226	273	1.613208	4.40405784	Opisthokonta	33154	Echinodermata	other_Eukaryota	59.7	5.89e-8	NR	XP_030854918.1	7668	g5148	i0	47.5	4.43956043956044	80	35	80.2	2	273	55	323	402	XP_030854918.1 E3 ubiquitin-protein ligase synoviolin A [Strongylocentrotus purpuratus]	diamond	1212	60.1	0.993344425956739	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29047762	29047762	PRJDB14274_S_NODE_3348_length_335_cov_1.423358_g3270_i0	PRJDB14274	3348	335	1.423358	4.7682493	Metazoa	33208	Echinodermata	other_Eukaryota	70.5	1.87e-11	NR	XP_071499753.1	105358	g3270	i0	37.1	1.8089552238806	116	63	94.9	3	334	17	113	228	XP_071499753.1 tumor susceptibility gene 101 protein-like [Diadema antillarum]	diamond	606	70.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
30853872	30853872	PRJDB14274_S_NODE_5934_length_258_cov_0.949239_g5856_i0	PRJDB14274	5934	258	0.949239	2.44903662	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	68.2	4.66e-11	NR	KAJ8031873.1	206669	g5856	i0	58.9	1.25581395348837	56	23	65.1	0	254	87	176	231	KAJ8031873.1 Gastric triacylglycerol lipase [Holothuria leucospilota]	diamond	324	68.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
32150510	32150510	PRJDB14274_S_NODE_8938_length_212_cov_1.291391_g8860_i0	PRJDB14274	8938	212	1.291391	2.73774892	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	74.7	1.33e-14	NR	XP_033103497.1	1529436	g8860	i0	49.3	10.5990566037736	69	35	97.6	0	1	207	80	148	XP_033103497.1 dual specificity protein phosphatase 1B-like isoform X2 [Anneissia japonica]	diamond	2247	74.7	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32340497	32340497	PRJDB14274_S_NODE_4659_length_287_cov_2.146018_g4581_i0	PRJDB14274	4659	287	2.146018	6.15907166	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	49.3	7.05e-5	NR	XP_054769073.1	7653	g4581	i0	46.2	1.63066202090592	52	28	54.4	0	284	129	76	127	XP_054769073.1 EF-hand domain-containing protein D2 homolog [Lytechinus pictus]	diamond	468	49.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
32397837	32397837	PRJDB14274_S_NODE_9659_length_206_cov_1.586207_g9581_i0	PRJDB14274	9659	206	1.586207	3.26758642	Metazoa	33208	Echinodermata	other_Eukaryota	73.6	3.19e-13	NR	XP_063960127.1	7653	g9581	i0	55.2	2.63592233009709	67	30	97.6	0	204	4	2610	2676	XP_063960127.1 E3 ubiquitin-protein ligase UBR5-like [Lytechinus pictus]	diamond	543	74.3	0.990578734858681	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus

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