metadata: contig_metadata: 9 rows where bioproject = "PRJNA846110", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA846110", tax_clade = "Opisthokonta" 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
5936253	5936253	PRJNA846110_P_NODE_25325_length_247_cov_1.597701_g25080_i0	PRJNA846110	25325	247	1.597701	3.94632147	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	63.9	1.03e-5	NTclustered	gi\|2707410035\|ref\|XM_054909153.2\|	7653	g25080	i0	93.182	0.356275303643725	44	1	17	2	205	247	1695	1737	PREDICTED: Lytechinus pictus low-density lipoprotein receptor-related protein 12-like (LOC129271897), transcript variant X2, mRNA	blastn	88	63.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
7211041	7211041	PRJNA846110_P_NODE_10246_length_337_cov_1.015152_g10002_i0	PRJNA846110	10246	337	1.015152	3.42106224	Asterias rubens	7604	Echinodermata	other_Eukaryota	239	2.27e-58	NTclustered	gi\|1834300654\|ref\|XM_033770377.1\|	7604	g10002	i0	83.019	81.5756676557863	265	43	78	2	31	294	7871	7608	PREDICTED: Asterias rubens CCR4-NOT transcription complex subunit 1-like (LOC117289308), mRNA	blastn	27491	239	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
11036844	11036844	PRJNA846110_P_NODE_4509_length_490_cov_1.247002_g4265_i0	PRJNA846110	4509	490	1.247002	6.1103098	Diadema antillarum	105358	Echinodermata	other_Eukaryota	73.6	9.47e-12	NR	XP_071507007.1	105358	g4265	i0	55.3	0.287755102040816	47	21	28.8	0	147	7	24	70	XP_071507007.1 uncharacterized protein [Diadema antillarum]	diamond	141	73.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
28602332	28602332	PRJNA846110_P_NODE_21507_length_255_cov_2.346154_g21262_i0	PRJNA846110	21507	255	2.346154	5.9826927	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	73.9	4.43e-13	NR	XP_030835098.1	7668	g21262	i0	51.5	4.91764705882353	68	33	80	0	248	45	837	904	XP_030835098.1 uncharacterized protein LOC115921621 [Strongylocentrotus purpuratus]	diamond	1254	73.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29115949	29115949	PRJNA846110_P_NODE_14908_length_288_cov_1.079070_g14663_i0	PRJNA846110	14908	288	1.07907	3.1077216	Metazoa	33208	Echinodermata	other_Eukaryota	50.4	1.18e-4	NR	XP_063966229.1	7653	g14663	i0	42.1	5.4375	76	43	78.1	1	33	257	134	209	XP_063966229.1 uncharacterized protein LOC135156785 [Lytechinus pictus]	diamond	1566	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
29706877	29706877	PRJNA846110_P_NODE_24670_length_248_cov_0.920000_g24425_i0	PRJNA846110	24670	248	0.92	2.2816	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	45.4	0.00455	NR	XP_030852090.1	7668	g24425	i0	55.2	0.701612903225806	29	13	35.1	0	240	154	315	343	XP_030852090.1 uncharacterized protein LOC100893985 isoform X2 [Strongylocentrotus purpuratus]	diamond	174	45.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31223626	31223626	PRJNA846110_P_NODE_24255_length_249_cov_0.875000_g24010_i0	PRJNA846110	24255	249	0.875	2.17875	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	65.9	3e-10	NR	XP_030841581.1	7668	g24010	i0	48.5	3.97590361445783	66	34	79.5	0	25	222	1104	1169	XP_030841581.1 uncharacterized protein LOC115924065 [Strongylocentrotus purpuratus]	diamond	990	65.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
32014583	32014583	PRJNA846110_P_NODE_22098_length_252_cov_2.111732_g21853_i0	PRJNA846110	22098	252	2.111732	5.32156464	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	73.9	4.47e-13	NR	XP_033125960.1	1529436	g21853	i0	58.3	0.714285714285714	60	17	69	2	174	1	674	727	XP_033125960.1 neurogenic locus notch homolog protein 2-like [Anneissia japonica]	diamond	180	73.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32457742	32457742	PRJNA846110_P_NODE_8799_length_357_cov_3.436620_g8555_i0	PRJNA846110	8799	357	3.43662	12.2687334	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	110	1.85e-25	NR	PIK43826.1	307972	g8555	i0	48.2	0.941176470588235	112	58	94.1	0	7	342	712	823	PIK43826.1 hypothetical protein BSL78_19311 [Apostichopus japonicus]	diamond	336	110	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus

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