metadata: contig_metadata: 5 rows where bioproject = "PRJNA596870" and tax

5 rows where bioproject = "PRJNA596870" 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
26731239	26731239	PRJNA596870_P_NODE_23341_length_280_cov_1.227053_g23208_i0	PRJNA596870	23341	280	1.227053	3.4357484	Lytechinus variegatus	7654	Echinodermata	other_Eukaryota	66.2	1.75e-10	NR	XP_041480235.1	7654	g23208	i0	39.1	0.985714285714286	92	56	98.6	0	1	276	122	213	XP_041480235.1 trypsin-like [Lytechinus variegatus]	diamond	276	66.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27648626	27648626	PRJNA596870_P_NODE_2124_length_788_cov_1.613986_g2009_i0	PRJNA596870	2124	788	1.613986	12.71820968	Lytechinus pictus	7653	Echinodermata	other_Eukaryota	69.3	2.95e-9	NR	XP_063962432.1	7653	g2009	i0	30.1	1.30583756345178	113	75	41.5	2	129	455	865	977	XP_063962432.1 zonadhesin-like isoform X2 [Lytechinus pictus]	diamond	1029	69.3	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus pictus
27914301	27914301	PRJNA596870_P_NODE_40065_length_241_cov_0.916667_g39932_i0	PRJNA596870	40065	241	0.916667	2.20916747	Metazoa	33208	Echinodermata	other_Eukaryota	57	2.8e-7	NR	XP_033645102.1	7604	g39932	i0	91.7	6.87136929460581	24	2	29.9	0	239	168	276	299	XP_033645102.1 transcription elongation factor A protein 1-like [Asterias rubens]	diamond	1656	57	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
29227411	29227411	PRJNA596870_P_NODE_22149_length_286_cov_1.084507_g22016_i0	PRJNA596870	22149	286	1.084507	3.10169002	Apostichopus japonicus	307972	Echinodermata	other_Eukaryota	103	2.6099999999999994e-23	NR	PIK55378.1	307972	g22016	i0	47.1	0.891608391608392	85	45	89.2	0	1	255	326	410	PIK55378.1 putative leishmanolysin-like peptidase [Apostichopus japonicus]	diamond	255	103	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Holothuroidea	Aspidochirotida	Stichopodidae	Apostichopus	Apostichopus japonicus
30396211	30396211	PRJNA596870_P_NODE_26373_length_264_cov_2.015707_g26240_i0	PRJNA596870	26373	264	2.015707	5.32146648	Asterias rubens	7604	Echinodermata	other_Eukaryota	85.1	1.02e-18	NR	XP_033634976.1	7604	g26240	i0	56	3.70454545454545	84	37	95.5	0	255	4	2	85	XP_033634976.1 40S ribosomal protein S15-like [Asterias rubens]	diamond	978	85.1	1	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);;