metadata: contig_metadata: 6 rows where bioproject = "PRJNA1158727", tax_kingdom = "Metazoa" and tax

6 rows where bioproject = "PRJNA1158727", 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
9232240	9232240	PRJNA1158727_P_NODE_155728_length_243_cov_2.370588_g148266_i0	PRJNA1158727	155728	243	2.370588	5.76052884	Echinodermata	7586	Echinodermata	other_Eukaryota	111	2.02e-26	NR	XP_033642011.1	7604	g148266	i0	65.8	8.81481481481481	76	25	92.6	1	241	17	364	439	XP_033642011.1 methylenetetrahydrofolate reductase-like [Asterias rubens]	diamond	2142	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
21983202	21983202	PRJNA1158727_P_NODE_76478_length_350_cov_2.505415_g69017_i0	PRJNA1158727	76478	350	2.505415	8.7689525	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	130	1.19e-34	NR	XP_033125693.1	1529436	g69017	i0	65.2	2.32285714285714	92	32	78.9	0	3	278	168	259	XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica]	diamond	813	130	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
28259673	28259673	PRJNA1158727_P_NODE_97926_length_297_cov_1.084821_g90465_i0	PRJNA1158727	97926	297	1.084821	3.22191837	Echinodermata	7586	Echinodermata	other_Eukaryota	79.3	1.08e-15	NR	XP_030834943.1	7668	g90465	i0	59.3	4.28282828282828	54	22	54.5	0	162	1	46	99	XP_030834943.1 H/ACA ribonucleoprotein complex subunit 1 [Strongylocentrotus purpuratus]	diamond	1272	79.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
29377163	29377163	PRJNA1158727_P_NODE_109689_length_280_cov_1.144928_g102228_i0	PRJNA1158727	109689	280	1.144928	3.2057984	Holothuria leucospilota	206669	Echinodermata	other_Eukaryota	92.8	1.03e-19	NR	KAJ8036133.1	206669	g102228	i0	52.4	1.74642857142857	84	40	90	0	272	21	356	439	KAJ8036133.1 CUGBP Elav-like family member 3 [Holothuria leucospilota]	diamond	489	92.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Holothuriidae	Holothuria	Holothuria leucospilota
31494207	31494207	PRJNA1158727_P_NODE_98996_length_295_cov_1.036036_g91535_i0	PRJNA1158727	98996	295	1.036036	3.0563062	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	43.9	0.0188	NR	XP_041457186.1	7654	g91535	i0	63	0.274576271186441	27	10	27.5	0	83	3	106	132	XP_041457186.1 high mobility group protein 1 homolog [Lytechinus variegatus]	diamond	81	43.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
32316908	32316908	PRJNA1158727_P_NODE_151859_length_245_cov_0.895349_g144397_i0	PRJNA1158727	151859	245	0.895349	2.19360505	Acanthaster planci	133434	Echinodermata	other_Eukaryota	68.6	3.04e-11	NR	XP_022111004.1	133434	g144397	i0	52	1.95918367346939	50	24	61.2	0	94	243	528	577	XP_022111004.1 protein neuralized-like [Acanthaster planci]	diamond	480	68.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci

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