metadata: contig_metadata: 9 rows where bioproject = "PRJNA438572", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA438572", 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
23387302	23387302	PRJNA438572_P_NODE_3499_length_527_cov_1.814978_g3381_i0	PRJNA438572	3499	527	1.814978	9.56493406	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	477	7.199999999999998e-130	NTclustered	gi\|1752411115\|ref\|XM_030977236.1\|	7668	g3381	i0	83.832	332.628083491461	501	81	95	0	1	501	1447	1947	PREDICTED: Strongylocentrotus purpuratus polyubiquitin-C (LOC754856), mRNA	blastn	175295	477	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
24661128	24661128	PRJNA438572_P_NODE_1200_length_853_cov_6.564103_g1107_i0	PRJNA438572	1200	853	6.564103	55.99179859	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	289	1.29e-94	NR	XP_033118288.1	1529436	g1107	i0	60.4	3.32356389214537	235	93	82.6	0	779	75	9	243	XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica]	diamond	2835	289	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
24661336	24661336	PRJNA438572_P_NODE_24640_length_242_cov_0.875740_g24521_i0	PRJNA438572	24640	242	0.87574	2.1192908	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	130	9.79e-26	NTclustered	gi\|2037969611\|ref\|XM_041596785.1\|	7654	g24521	i0	76.987	37.2066115702479	239	47	97	8	1	235	560	326	PREDICTED: Lytechinus variegatus 60S ribosomal protein L10a-like (LOC121405821), mRNA	blastn	9004	130	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27107414	27107414	PRJNA438572_P_NODE_21062_length_247_cov_0.896552_g20943_i0	PRJNA438572	21062	247	0.896552	2.21448344	Asterias rubens	7604	Echinodermata	other_Eukaryota	57.4	1.24e-7	NR	XP_033633728.1	7604	g20943	i0	36	0.910931174089069	75	47	89.9	1	245	24	97	171	XP_033633728.1 cell division control protein 42 homolog [Asterias rubens]	diamond	225	57.4	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
29665023	29665023	PRJNA438572_P_NODE_22970_length_244_cov_0.912281_g22851_i0	PRJNA438572	22970	244	0.912281	2.22596564	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	50.1	3.16e-5	NR	KAJ8042825.1	206669	g22851	i0	47.4	0.959016393442623	78	40	94.7	1	11	241	68	145	KAJ8042825.1 Coiled-coil domain-containing protein 86 [Holothuria leucospilota]	diamond	234	50.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
30202129	30202129	PRJNA438572_P_NODE_18332_length_251_cov_0.876404_g18213_i0	PRJNA438572	18332	251	0.876404	2.19977404	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	101	7.689999999999999e-23	NR	XP_033113302.1	1529436	g18213	i0	52.5	4.85258964143426	80	38	95.6	0	2	241	249	328	XP_033113302.1 probable tubulin polyglutamylase TTLL2 [Anneissia japonica]	diamond	1218	101	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
32004286	32004286	PRJNA438572_P_NODE_20198_length_248_cov_0.891429_g20079_i0	PRJNA438572	20198	248	0.891429	2.21074392	Asterias rubens	7604	Echinodermata	other_Eukaryota	51.6	2.86e-5	NR	XP_033638508.1	7604	g20079	i0	41	1.20967741935484	39	23	47.2	0	177	61	226	264	XP_033638508.1 uncharacterized protein LOC117299155 [Asterias rubens]	diamond	300	51.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32527113	32527113	PRJNA438572_P_NODE_17099_length_253_cov_0.866667_g16980_i0	PRJNA438572	17099	253	0.866667	2.19266751	Echinodermata	7586	Echinodermata	other_Eukaryota	91.3	2.56e-19	NR	XP_033628619.1	7604	g16980	i0	47.7	6.29644268774704	86	43	99.6	2	2	253	35	120	XP_033628619.1 acyl-CoA 6-desaturase-like [Asterias rubens]	diamond	1593	91.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32621399	32621399	PRJNA438572_P_NODE_10100_length_323_cov_0.936000_g9981_i0	PRJNA438572	10100	323	0.936	3.02328	root	1	Root_unresolved	Root_unresolved	132	4.05e-33	NR	XP_041465213.1	7654	g9981	i0	57.5	14.8142414860681	106	45	98.5	0	320	3	149	254	XP_041465213.1 peroxisomal multifunctional enzyme type 2-like [Lytechinus variegatus]	diamond	4785	133	0.992481203007519	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus

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