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

4 rows where analysis = "diamond", bioproject = "PRJNA450343" 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
27234126	27234126	PRJNA450343_P_NODE_2003_length_389_cov_2.867647_g1935_i0	PRJNA450343	2003	389	2.867647	11.15514683	Lineus longissimus	88925	Nemertea	other_Eukaryota	43.5	0.0197	NR	XP_064644876.1	88925	g1935	i0	28.6	0.701799485861183	91	60	70.2	2	91	363	21	106	XP_064644876.1 normal mucosa of esophagus-specific gene 1 protein-like [Lineus longissimus]	diamond	273	43.5	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
28434156	28434156	PRJNA450343_P_NODE_10866_length_167_cov_0.864407_g10798_i0	PRJNA450343	10866	167	0.864407	1.44355969	Lineus longissimus	88925	Nemertea	other_Eukaryota	58.2	2.29e-8	NR	XP_064628939.1	88925	g10798	i0	57.4	0.844311377245509	47	20	84.4	0	153	13	160	206	XP_064628939.1 ras-related and estrogen-regulated growth inhibitor-like [Lineus longissimus]	diamond	141	58.2	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Lineus	Lineus longissimus
28623723	28623723	PRJNA450343_P_NODE_6147_length_216_cov_0.934132_g6079_i0	PRJNA450343	6147	216	0.934132	2.01772512	Cerebratulus lacteus	6221	Nemertea	other_Eukaryota	135	1.1e-37	NR	ALI58375.1	6221	g6079	i0	85.9	1.97222222222222	71	10	98.6	0	213	1	181	251	ALI58375.1 ribosomal protein S4, partial [Cerebratulus lacteus]	diamond	426	135	1	Eukaryota	Opisthokonta	Metazoa	Nemertea	Pilidiophora	Heteronemertea	Lineidae	Cerebratulus	Cerebratulus lacteus
31751102	31751102	PRJNA450343_P_NODE_9857_length_173_cov_1.645161_g9789_i0	PRJNA450343	9857	173	1.645161	2.84612853	Lineus longissimus	88925	Nemertea	other_Eukaryota	54.7	8.7e-7	NR	XP_064622370.1	88925	g9789	i0	54.8	0.728323699421965	42	19	72.8	0	172	47	353	394	XP_064622370.1 small ribosomal subunit protein uS5m-like [Lineus longissimus]	diamond	126	54.7	1	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);;