metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax_phylum = "Mollusca"

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
27070285	27070285	PRJNA1129273_P_NODE_7522_length_265_cov_1.598958_g7242_i0	PRJNA1129273	7522	265	1.598958	4.2372387	Mytilus galloprovincialis	29158	Mollusca	Mollusca	70.5	8.82e-12	NR	VDI64002.1	29158	g7242	i0	39.7	1.68679245283019	78	47	88.3	0	235	2	39	116	VDI64002.1 nesprin-1, partial [Mytilus galloprovincialis]	diamond	447	70.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
28617938	28617938	PRJNA1129273_P_NODE_2567_length_477_cov_2.287129_g2291_i0	PRJNA1129273	2567	477	2.287129	10.90960533	Mytilus galloprovincialis	29158	Mollusca	Mollusca	103	3.85e-25	NR	CAQ63457.1	29158	g2291	i0	63.4	1.41509433962264	112	40	69.8	1	67	399	1	112	CAQ63457.1 ribosomal protein [Mytilus galloprovincialis]	diamond	675	103	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
29206991	29206991	PRJNA1129273_P_NODE_8129_length_257_cov_1.494565_g7849_i0	PRJNA1129273	8129	257	1.494565	3.84103205	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.5	2.3e-17	NR	BFZ24888.1	145626	g7849	i0	54.8	9.73540856031128	84	36	95.7	2	3	248	209	292	BFZ24888.1 hypothetical protein BsWGS_27927 [Bradybaena similaris]	diamond	2502	85.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
31112783	31112783	PRJNA1129273_P_NODE_8135_length_257_cov_1.326087_g7855_i0	PRJNA1129273	8135	257	1.326087	3.40804359	Physella acuta	109671	Mollusca	Mollusca	43.1	0.0312	NR	XP_059140420.1	109671	g7855	i0	34.9	0.735408560311284	63	41	73.5	0	39	227	20	82	XP_059140420.1 serpin B6-like [Physella acuta]	diamond	189	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
31524193	31524193	PRJNA1129273_P_NODE_1856_length_593_cov_1.959615_g1586_i0	PRJNA1129273	1856	593	1.959615	11.62051695	Pomacea canaliculata	400727	Mollusca	Mollusca	49.7	0.00317	NR	XP_025105735.1	400727	g1586	i0	37	1.1079258010118	73	46	36.9	0	9	227	222	294	XP_025105735.1 calcium-binding protein LPS1-alpha-like [Pomacea canaliculata]	diamond	657	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
31935132	31935132	PRJNA1129273_P_NODE_7377_length_267_cov_1.561856_g7097_i0	PRJNA1129273	7377	267	1.561856	4.17015552	Potamilus streckersoni	2493646	Mollusca	Mollusca	85.1	3.85e-17	NR	KAK3596371.1	2493646	g7097	i0	48.8	1.91011235955056	86	41	96.6	1	266	9	109	191	KAK3596371.1 hypothetical protein CHS0354_036922 [Potamilus streckersoni]	diamond	510	85.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni

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