metadata: contig_metadata: 4 rows where bioproject = "PRJNA415856" and tax

4 rows where bioproject = "PRJNA415856" 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
2970084	2970084	PRJNA415856_P_NODE_38323_length_166_cov_0.871795_g38062_i0	PRJNA415856	38323	166	0.871795	1.4471797	Metazoa	33208	Echinodermata	other_Eukaryota	111	8.43e-27	NR	XP_041458150.1	7654	g38062	i0	87.3	7.93373493975904	55	7	99.4	0	2	166	27	81	XP_041458150.1 rho-related protein racA-like [Lytechinus variegatus]	diamond	1317	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
30738998	30738998	PRJNA415856_P_NODE_21834_length_189_cov_1.664286_g21573_i0	PRJNA415856	21834	189	1.664286	3.14550054	Patiria miniata	46514	Echinodermata	other_Eukaryota	78.6	4.24e-15	NR	XP_038048621.1	46514	g21573	i0	55.7	1.93650793650794	61	27	96.8	0	184	2	671	731	XP_038048621.1 glycogen debranching enzyme-like [Patiria miniata]	diamond	366	78.6	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Valvatida	Asterinidae	Patiria	Patiria miniata
30755773	30755773	PRJNA415856_P_NODE_14614_length_227_cov_1.719101_g14353_i0	PRJNA415856	14614	227	1.719101	3.90235927	Metazoa	33208	Echinodermata	other_Eukaryota	50.1	7.89e-5	NR	XP_033627944.1	7604	g14353	i0	41.9	2.96035242290749	74	42	96.5	1	2	220	288	361	XP_033627944.1 ankyrin repeat domain-containing protein 13D-like [Asterias rubens]	diamond	672	50.1	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
32873180	32873180	PRJNA415856_P_NODE_15860_length_218_cov_2.349112_g15599_i0	PRJNA415856	15860	218	2.349112	5.12106416	Metazoa	33208	Echinodermata	other_Eukaryota	124	1.42e-32	NR	AIP87511.1	7654	g15599	i0	79.2	10.7614678899083	72	15	99.1	0	3	218	205	276	AIP87511.1 karyopherin alpha 6, partial [Lytechinus variegatus]	diamond	2346	124	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);;