metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax_phylum = "Nemertea"

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
28435687	28435687	PRJNA532380_P_NODE_8846_length_316_cov_3.258427_g8521_i0	PRJNA532380	8846	316	3.258427	10.29662932	Lineus longissimus	88925	Nemertea	other_Eukaryota	76.6	1.96e-15	NR	XP_064651935.1	88925	g8521	i0	55.4	2.81012658227848	74	33	70.3	0	314	93	45	118	XP_064651935.1 ATPase inhibitor mai-2, mitochondrial-like isoform X3 [Lineus longissimus]	diamond	888	76.6	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
29050764	29050764	PRJNA532380_P_NODE_4348_length_487_cov_4.668950_g4023_i0	PRJNA532380	4348	487	4.66895	22.7377865	Metazoa	33208	Nemertea	other_Eukaryota	195	8.96e-61	NR	ALI58372.1	6221	g4023	i0	61.1	2.85831622176591	157	59	95.5	2	18	482	1	157	ALI58372.1 cytochrome c oxidase subunit Va [Cerebratulus lacteus]	diamond	1392	196	0.994897959183674	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Cerebratulus	Cerebratulus lacteus
29666657	29666657	PRJNA532380_P_NODE_810_length_1154_cov_26.523982_g670_i0	PRJNA532380	810	1154	26.523982	306.08675228	Lineus longissimus	88925	Nemertea	other_Eukaryota	279	2.8499999999999997e-88	NR	XP_064640518.1	88925	g670	i0	69.4	6.51213171577123	180	55	46.8	0	490	1029	125	304	XP_064640518.1 cytochrome c1, heme protein, mitochondrial-like [Lineus longissimus]	diamond	7515	279	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
31419840	31419840	PRJNA532380_P_NODE_32596_length_163_cov_0.912281_g32271_i0	PRJNA532380	32596	163	0.912281	1.48701803	Metazoa	33208	Nemertea	other_Eukaryota	80.5	1.37e-17	NR	XP_064652031.1	88925	g32271	i0	79.6	8.11656441717791	49	10	90.2	0	2	148	92	140	XP_064652031.1 profilin-like [Lineus longissimus]	diamond	1323	80.9	0.995055624227441	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus

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