metadata: contig_metadata: 5 rows where bioproject = "PRJNA492406", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA492406", 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
26981459	26981459	PRJNA492406_P_NODE_22282_length_272_cov_1.542714_g21983_i0	PRJNA492406	22282	272	1.542714	4.19618208	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	56.6	6.17e-7	NR	XP_041465397.1	7654	g21983	i0	36.8	0.75	68	40	75	1	67	270	24	88	XP_041465397.1 cathepsin B-like [Lytechinus variegatus]	diamond	204	56.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27345450	27345450	PRJNA492406_P_NODE_25643_length_255_cov_1.664835_g25344_i0	PRJNA492406	25643	255	1.664835	4.24532925	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.1	5.42e-4	NR	XP_022101930.1	133434	g25344	i0	41.5	1.62352941176471	65	38	76.5	0	47	241	369	433	XP_022101930.1 coiled-coil domain-containing protein 39-like [Acanthaster planci]	diamond	414	48.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
28592373	28592373	PRJNA492406_P_NODE_20447_length_281_cov_1.783654_g20148_i0	PRJNA492406	20447	281	1.783654	5.01206774	Acanthaster planci	133434	Echinodermata	other_Eukaryota	49.3	2.88e-4	NR	XP_022109953.1	133434	g20148	i0	35.4	0.693950177935943	65	39	66.2	1	268	83	294	358	XP_022109953.1 macrophage mannose receptor 1-like [Acanthaster planci]	diamond	195	49.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Acanthasteridae	Acanthaster	Acanthaster planci
28797515	28797515	PRJNA492406_P_NODE_19227_length_287_cov_1.294393_g18928_i0	PRJNA492406	19227	287	1.294393	3.71490791	Metazoa	33208	Echinodermata	other_Eukaryota	48.9	4.1e-4	NR	XP_054756371.2	7653	g18928	i0	35.1	5.52961672473868	77	48	78.4	2	274	50	106	182	XP_054756371.2 heterogeneous nuclear ribonucleoproteins A2/B1-like isoform X1 [Lytechinus pictus]	diamond	1587	48.9	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
32873380	32873380	PRJNA492406_P_NODE_23660_length_265_cov_1.604167_g23361_i0	PRJNA492406	23660	265	1.604167	4.25104255	Metazoa	33208	Echinodermata	other_Eukaryota	82.8	3.91e-17	NR	XP_041477894.1	7654	g23361	i0	55.9	1.55094339622642	68	30	77	0	2	205	153	220	XP_041477894.1 elongation factor 1-beta-like [Lytechinus variegatus]	diamond	411	82.8	1	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);;