metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA896554" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA896554" 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
23822446	23822446	PRJNA896554_P_NODE_141159_length_261_cov_1.638298_g133619_i0	PRJNA896554	141159	261	1.638298	4.27595778	Acanthaster planci	133434	Echinodermata	other_Eukaryota	143	5.55e-39	NR	XP_022081699.1	133434	g133619	i0	76.7	6.83908045977012	86	20	98.9	0	3	260	233	318	XP_022081699.1 pyruvate dehydrogenase E1 component subunit alpha, mitochondrial-like isoform X3 [Acanthaster planci]	diamond	1785	143	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
23823504	23823504	PRJNA896554_P_NODE_34019_length_1077_cov_10.489044_g27686_i0	PRJNA896554	34019	1077	10.489044	112.96700388	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	289	1.85e-93	NR	XP_033118288.1	1529436	g27686	i0	60.4	2.63231197771588	235	93	65.5	0	84	788	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
27126179	27126179	PRJNA896554_P_NODE_78982_length_405_cov_0.900602_g71442_i0	PRJNA896554	78982	405	0.900602	3.6474381	Metazoa	33208	Echinodermata	other_Eukaryota	121	6.7200000000000006e-29	NR	PIK55781.1	307972	g71442	i0	47.4	32.5407407407407	135	65	100	3	1	405	199	327	PIK55781.1 putative long-chain-fatty-acid--CoA ligase 4-like, partial [Apostichopus japonicus]	diamond	13179	121	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
28800079	28800079	PRJNA896554_P_NODE_60987_length_528_cov_2.485714_g53460_i0	PRJNA896554	60987	528	2.485714	13.12456992	Metazoa	33208	Echinodermata	other_Eukaryota	103	4.58e-25	NR	XP_038058372.1	46514	g53460	i0	66.7	6.94318181818182	72	24	40.9	0	458	243	29	100	XP_038058372.1 protein transport protein Sec61 subunit gamma [Patiria miniata]	diamond	3666	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30379721	30379721	PRJNA896554_P_NODE_96992_length_340_cov_1.153558_g89452_i0	PRJNA896554	96992	340	1.153558	3.9220972	Opisthokonta	33154	Echinodermata	other_Eukaryota	130	1.5299999999999999e-34	NR	XP_033639471.1	7604	g89452	i0	60.2	2.7	103	41	90.9	0	32	340	51	153	XP_033639471.1 isopentenyl-diphosphate Delta-isomerase 1-like [Asterias rubens]	diamond	918	131	0.99236641221374	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
30403645	30403645	PRJNA896554_P_NODE_170073_length_243_cov_0.905882_g162533_i0	PRJNA896554	170073	243	0.905882	2.20129326	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	47	2.08e-4	NR	KAJ8043773.1	206669	g162533	i0	51.1	1.19753086419753	47	23	58	0	206	66	53	99	KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota]	diamond	291	47	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
30592677	30592677	PRJNA896554_P_NODE_134593_length_270_cov_1.172589_g127053_i0	PRJNA896554	134593	270	1.172589	3.1659903	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	127	1.2699999999999998e-31	NR	XP_041456296.1	7654	g127053	i0	71.1	3	90	26	100	0	270	1	905	994	XP_041456296.1 acyl-CoA dehydrogenase family member 10-like [Lytechinus variegatus]	diamond	810	127	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
31224573	31224573	PRJNA896554_P_NODE_145415_length_256_cov_1.262295_g137875_i0	PRJNA896554	145415	256	1.262295	3.2314752	Strongylocentrotus purpuratus	7668	Echinodermata	other_Eukaryota	63.9	1.43e-9	NR	XP_030830145.1	7668	g137875	i0	53.7	0.78515625	67	22	78.5	1	205	5	2	59	XP_030830145.1 ubiquitin-like modifier-activating enzyme 5 [Strongylocentrotus purpuratus]	diamond	201	63.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
32047190	32047190	PRJNA896554_P_NODE_133698_length_271_cov_1.409091_g126158_i0	PRJNA896554	133698	271	1.409091	3.81863661	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	73.2	1.06e-12	NR	KAJ8019865.1	206669	g126158	i0	42.9	0.85239852398524	77	43	85.2	1	16	246	1228	1303	KAJ8019865.1 A disintegrin and metalloproteinase with thrombospondin motifs 9 [Holothuria leucospilota]	diamond	231	73.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota

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