metadata: contig_metadata: 10 rows where bioproject = "PRJNA1002816", tax_kingdom = "Metazoa" and tax

10 rows where bioproject = "PRJNA1002816", 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
19278357	19278357	PRJNA1002816_P_NODE_13536_length_299_cov_1.668142_g13376_i0	PRJNA1002816	13536	299	1.668142	4.98774458	Acanthaster planci	133434	Echinodermata	other_Eukaryota	161	4.429999999999999e-35	NTclustered	gi\|1229142055\|ref\|XM_022227528.1\|	133434	g13376	i0	79.911	12.2140468227425	224	41	74	4	13	234	434	213	PREDICTED: Acanthaster planci small nuclear ribonucleoprotein Sm D2 (LOC110975231), mRNA	blastn	3652	161	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27192339	27192339	PRJNA1002816_P_NODE_5902_length_467_cov_1.368020_g5742_i0	PRJNA1002816	5902	467	1.36802	6.3886534	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	166	3.4e-46	NR	KAJ8031873.1	206669	g5742	i0	54.2	0.982869379014989	153	68	97.6	2	465	10	131	282	KAJ8031873.1 Gastric triacylglycerol lipase [Holothuria leucospilota]	diamond	459	166	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
27508606	27508606	PRJNA1002816_P_NODE_6643_length_440_cov_1.531335_g6483_i0	PRJNA1002816	6643	440	1.531335	6.737874	Acanthaster planci	133434	Echinodermata	other_Eukaryota	79.3	5.42e-14	NR	XP_022103981.1	133434	g6483	i0	42	0.6	88	51	60	0	169	432	47	134	XP_022103981.1 dystroglycan-like [Acanthaster planci]	diamond	264	79.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
27855685	27855685	PRJNA1002816_P_NODE_13725_length_296_cov_1.565022_g13565_i0	PRJNA1002816	13725	296	1.565022	4.63246512	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	50.8	1.04e-4	NR	XP_030836930.1	7668	g13565	i0	41.7	1.09459459459459	108	41	97.3	5	293	6	312	409	XP_030836930.1 nuclear pore complex protein Nup98-Nup96 isoform X1 [Strongylocentrotus purpuratus]	diamond	324	50.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
28676787	28676787	PRJNA1002816_P_NODE_11927_length_321_cov_1.241935_g11767_i0	PRJNA1002816	11927	321	1.241935	3.98661135	Asterias rubens	7604	Echinodermata	other_Eukaryota	105	8.07e-24	NR	XP_033630607.1	7604	g11767	i0	51.6	2.52336448598131	95	46	88.8	0	35	319	22	116	XP_033630607.1 serine/threonine-protein phosphatase 5-like [Asterias rubens]	diamond	810	105	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
28763864	28763864	PRJNA1002816_P_NODE_3627_length_595_cov_1.423372_g3469_i0	PRJNA1002816	3627	595	1.423372	8.4690634	Metazoa	33208	Echinodermata	other_Eukaryota	144	2.95e-36	NR	XP_787078.3	7668	g3469	i0	44.9	5.83865546218487	207	102	99.8	5	1	594	341	544	XP_787078.3 sodium-dependent multivitamin transporter [Strongylocentrotus purpuratus]	diamond	3474	144	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29560566	29560566	PRJNA1002816_P_NODE_20010_length_243_cov_1.788235_g19850_i0	PRJNA1002816	20010	243	1.788235	4.34541105	Acanthaster planci	133434	Echinodermata	other_Eukaryota	134	2.11e-34	NR	XP_022090731.1	133434	g19850	i0	74.7	2.93827160493827	79	20	97.5	0	243	7	157	235	XP_022090731.1 glycine--tRNA ligase-like [Acanthaster planci]	diamond	714	134	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
30445356	30445356	PRJNA1002816_P_NODE_6913_length_431_cov_1.357542_g6753_i0	PRJNA1002816	6913	431	1.357542	5.85100602	Acanthaster planci	133434	Echinodermata	other_Eukaryota	192	3.82e-57	NR	XP_022095197.1	133434	g6753	i0	62.7	67.2111368909513	142	53	98.8	0	3	428	191	332	XP_022095197.1 COP9 signalosome complex subunit 2 [Acanthaster planci]	diamond	28968	192	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
31804307	31804307	PRJNA1002816_P_NODE_15017_length_280_cov_1.859903_g14857_i0	PRJNA1002816	15017	280	1.859903	5.2077284	Diadema antillarum	105358	Echinodermata	other_Eukaryota	47.8	7.51e-4	NR	XP_071506286.1	105358	g14857	i0	36.4	0.707142857142857	66	41	69.6	1	279	85	20	85	XP_071506286.1 arpin-like [Diadema antillarum]	diamond	198	47.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
32271733	32271733	PRJNA1002816_P_NODE_6578_length_442_cov_2.241192_g6418_i0	PRJNA1002816	6578	442	2.241192	9.90606864	Asteroidea	7588	Echinodermata	other_Eukaryota	111	2.89e-25	NR	XP_033647407.1	7604	g6418	i0	40.8	2.99321266968326	147	82	98.4	3	3	437	121	264	XP_033647407.1 titin homolog [Asterias rubens]	diamond	1323	112	0.991071428571429	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);;