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

10 rows where bioproject = "PRJNA812715", 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
27243981	27243981	PRJNA812715_P_NODE_72343_length_300_cov_1.017621_g70543_i0	PRJNA812715	72343	300	1.017621	3.052863	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	163	4.82e-45	NR	KAJ8021737.1	206669	g70543	i0	80	5.98	100	20	100	0	300	1	58	157	KAJ8021737.1 hypothetical protein HOLleu_39026 [Holothuria leucospilota]	diamond	1794	163	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
27307326	27307326	PRJNA812715_P_NODE_108263_length_248_cov_0.880000_g106462_i0	PRJNA812715	108263	248	0.88	2.1824	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	65.1	4.32e-10	NR	XP_033106639.1	1529436	g106462	i0	47	0.798387096774194	66	34	78.6	1	195	1	37	102	XP_033106639.1 phytanoyl-CoA dioxygenase, peroxisomal-like [Anneissia japonica]	diamond	198	65.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28601932	28601932	PRJNA812715_P_NODE_92307_length_265_cov_1.244792_g90506_i0	PRJNA812715	92307	265	1.244792	3.2986988	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	102	2.2899999999999998e-23	NR	XP_033107834.1	1529436	g90506	i0	53.4	1.9811320754717	88	40	99.6	1	265	2	279	365	XP_033107834.1 gastric triacylglycerol lipase-like [Anneissia japonica]	diamond	525	102	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28949321	28949321	PRJNA812715_P_NODE_107708_length_248_cov_0.880000_g105907_i0	PRJNA812715	107708	248	0.88	2.1824	Diadema antillarum	105358	Echinodermata	other_Eukaryota	70.5	6.77e-12	NR	XP_071505533.1	105358	g105907	i0	43	0.955645161290323	79	44	95.6	1	237	1	176	253	XP_071505533.1 metabotropic glutamate receptor 2-like [Diadema antillarum]	diamond	237	70.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum
29012595	29012595	PRJNA812715_P_NODE_90288_length_268_cov_1.579487_g88487_i0	PRJNA812715	90288	268	1.579487	4.23302516	Acanthaster planci	133434	Echinodermata	other_Eukaryota	130	3.39e-33	NR	XP_022095477.1	133434	g88487	i0	72.6	7.54477611940298	84	22	92.9	1	252	4	115	198	XP_022095477.1 serine/threonine-protein kinase RIO2-like [Acanthaster planci]	diamond	2022	130	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
29706466	29706466	PRJNA812715_P_NODE_61790_length_332_cov_1.745174_g59991_i0	PRJNA812715	61790	332	1.745174	5.79397768	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	93.2	7.06e-21	NR	KAJ8019445.1	206669	g59991	i0	49.4	0.731927710843373	81	41	73.2	0	331	89	99	179	KAJ8019445.1 Proliferation-associated protein 2G4 [Holothuria leucospilota]	diamond	243	93.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
31159783	31159783	PRJNA812715_P_NODE_79675_length_285_cov_1.240566_g77875_i0	PRJNA812715	79675	285	1.240566	3.5356131	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	48.9	3.85e-4	NR	PIK60857.1	307972	g77875	i0	31.9	1.88421052631579	94	64	98.9	0	3	284	151	244	PIK60857.1 putative 85/88 kDa calcium-independent phospholipase A2 [Apostichopus japonicus]	diamond	537	48.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
31643162	31643162	PRJNA812715_P_NODE_57836_length_347_cov_1.116788_g56037_i0	PRJNA812715	57836	347	1.116788	3.87525436	Opisthokonta	33154	Echinodermata	other_Eukaryota	83.2	2.62e-16	NR	XP_041477878.1	7654	g56037	i0	52.1	6.63976945244957	73	35	63.1	0	260	42	219	291	XP_041477878.1 actin-related protein 2/3 complex subunit 2-like [Lytechinus variegatus]	diamond	2304	83.6	0.995215311004785	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
32520679	32520679	PRJNA812715_P_NODE_118919_length_242_cov_0.911243_g117118_i0	PRJNA812715	118919	242	0.911243	2.20520806	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	85.5	1.15e-17	NR	XP_798718.2	7668	g117118	i0	65.8	1.77272727272727	73	24	90.5	1	9	227	82	153	XP_798718.2 transmembrane protein 165 [Strongylocentrotus purpuratus]	diamond	429	85.5	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
32749761	32749761	PRJNA812715_P_NODE_54900_length_359_cov_1.076923_g53101_i0	PRJNA812715	54900	359	1.076923	3.86615357	Metazoa	33208	Echinodermata	other_Eukaryota	105	1.4399999999999994e-23	NR	XP_033626614.1	7604	g53101	i0	46.2	5.79944289693593	106	57	88.6	0	2	319	671	776	XP_033626614.1 gamma-tubulin complex component 2-like [Asterias rubens]	diamond	2082	106	0.990566037735849	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);;