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

5 rows where bioproject = "PRJNA615175" 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
25376153	25376153	PRJNA615175_P_NODE_16300_length_348_cov_3.330909_g16132_i0	PRJNA615175	16300	348	3.330909	11.59156332	Anneissia japonica	1529436	Echinodermata	other_Eukaryota	137	1.9199999999999999e-38	NR	XP_033123568.1	1529436	g16132	i0	62.6	1.85344827586207	107	40	92.2	0	26	346	55	161	XP_033123568.1 60S ribosomal protein L23a-like [Anneissia japonica]	diamond	645	137	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Crinoidea	Comatulida	Comatulidae	Anneissia	Anneissia japonica
27693843	27693843	PRJNA615175_P_NODE_22724_length_288_cov_1.958140_g22556_i0	PRJNA615175	22724	288	1.95814	5.6394432	Metazoa	33208	Echinodermata	other_Eukaryota	107	1.0099999999999999e-24	NR	XP_041481845.1	7654	g22556	i0	56.8	3.9375	95	40	97.9	1	286	5	191	285	XP_041481845.1 uncharacterized protein LOC121429016 [Lytechinus variegatus]	diamond	1134	107	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Temnopleuroida	Toxopneustidae	Lytechinus	Lytechinus variegatus
27725512	27725512	PRJNA615175_P_NODE_5804_length_635_cov_3.398577_g5639_i0	PRJNA615175	5804	635	3.398577	21.58096395	Echinodermata	7586	Echinodermata	other_Eukaryota	66.2	9.42e-9	NR	XP_033643009.1	7604	g5639	i0	28.6	1.92283464566929	189	98	76.1	6	489	7	245	424	XP_033643009.1 calcium-binding mitochondrial carrier protein SCaMC-2-like isoform X2 [Asterias rubens]	diamond	1221	66.2	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Asteroidea	Forcipulatida	Asteriidae	Asterias	Asterias rubens
30820054	30820054	PRJNA615175_P_NODE_27074_length_256_cov_1.256831_g26906_i0	PRJNA615175	27074	256	1.256831	3.21748736	Metazoa	33208	Echinodermata	other_Eukaryota	97.8	5.89e-22	NR	XP_030854236.1	7668	g26906	i0	50	4.95703125	90	39	98.4	2	1	252	266	355	XP_030854236.1 uncharacterized protein LOC100893311 [Strongylocentrotus purpuratus]	diamond	1269	97.8	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Camarodonta	Strongylocentrotidae	Strongylocentrotus	Strongylocentrotus purpuratus
31280950	31280950	PRJNA615175_P_NODE_26395_length_261_cov_1.228723_g26227_i0	PRJNA615175	26395	261	1.228723	3.20696703	Diadema antillarum	105358	Echinodermata	other_Eukaryota	142	7.26e-39	NR	XP_071502845.1	105358	g26227	i0	72.1	6.91954022988506	86	24	98.9	0	3	260	251	336	XP_071502845.1 ADP-ribosylhydrolase ARH1-like [Diadema antillarum]	diamond	1806	142	1	Eukaryota	Opisthokonta	Metazoa	Echinodermata	Echinoidea	Diadematoida	Diadematidae	Diadema	Diadema antillarum

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