metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1164198" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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
6689888	6689888	PRJNA1164198_P_NODE_20806_length_272_cov_1.532663_g20537_i0	PRJNA1164198	20806	272	1.532663	4.16884336	Mytilus coruscus	42192	Mollusca	Mollusca	113	5.01e-28	NR	CAC5423815.1	42192	g20537	i0	71.1	4.03676470588235	76	22	83.8	0	39	266	195	270	CAC5423815.1 RP-S12e [Mytilus coruscus]	diamond	1098	113	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
7965175	7965175	PRJNA1164198_P_NODE_14647_length_323_cov_1.480000_g14378_i0	PRJNA1164198	14647	323	1.48	4.7804	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	123	4.45e-30	NR	XP_046335871.2	6454	g14378	i0	63.3	6.59442724458204	90	33	83.6	0	272	3	44	133	XP_046335871.2 protein disulfide-isomerase A4-like [Haliotis rufescens]	diamond	2130	123	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
26775018	26775018	PRJNA1164198_P_NODE_4881_length_568_cov_1.569697_g4631_i0	PRJNA1164198	4881	568	1.569697	8.91587896	Stylommatophora	6527	Mollusca	Mollusca	198	1.2100000000000004e-59	NR	CAG5118462.1	100452	g4631	i0	50.3	6.02112676056338	189	91	98.2	1	2	559	84	272	CAG5118462.1 unnamed protein product [Candidula unifasciata]	diamond	3420	199	0.994974874371859	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
27956522	27956522	PRJNA1164198_P_NODE_11645_length_364_cov_1.879725_g11377_i0	PRJNA1164198	11645	364	1.879725	6.842199	Littorina saxatilis	31220	Mollusca	Mollusca	45.1	0.0209	NR	XP_070176500.1	31220	g11377	i0	47.6	0.346153846153846	42	22	34.6	0	290	165	506	547	XP_070176500.1 uncharacterized protein [Littorina saxatilis]	diamond	126	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
28240442	28240442	PRJNA1164198_P_NODE_19206_length_283_cov_1.085714_g18937_i0	PRJNA1164198	19206	283	1.085714	3.07257062	Acanthosepion pharaonis	158019	Mollusca	Mollusca	43.5	0.0327	NR	CAE1247056.1	158019	g18937	i0	51	1.01766784452297	96	27	95.4	4	12	281	73	154	CAE1247056.1 unnamed protein product [Acanthosepion pharaonis]	diamond	288	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
30849565	30849565	PRJNA1164198_P_NODE_21394_length_268_cov_3.707692_g21125_i0	PRJNA1164198	21394	268	3.707692	9.93661456	Mollusca	6447	Mollusca	Mollusca	120	9.21e-32	NR	XP_045183074.1	6596	g21125	i0	67.4	4.82462686567164	86	28	96.3	0	258	1	1	86	XP_045183074.1 40S ribosomal protein S8-like [Mercenaria mercenaria]	diamond	1293	120	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
30893696	30893696	PRJNA1164198_P_NODE_24354_length_253_cov_0.866667_g24085_i0	PRJNA1164198	24354	253	0.866667	2.19266751	Mya arenaria	6604	Mollusca	Mollusca	45.1	0.00657	NR	XP_052765402.1	6604	g24085	i0	40.4	1.11462450592885	47	23	55.7	2	228	88	414	455	XP_052765402.1 multiple epidermal growth factor-like domains protein 10 [Mya arenaria]	diamond	282	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
31810450	31810450	PRJNA1164198_P_NODE_23017_length_259_cov_1.209677_g22748_i0	PRJNA1164198	23017	259	1.209677	3.13306343	Pomacea canaliculata	400727	Mollusca	Mollusca	104	1.39e-24	NR	PVD19081.1	400727	g22748	i0	92.7	13.1003861003861	55	4	63.7	0	1	165	97	151	PVD19081.1 hypothetical protein C0Q70_21640 [Pomacea canaliculata]	diamond	3393	105	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
32114627	32114627	PRJNA1164198_P_NODE_26978_length_248_cov_1.234286_g26709_i0	PRJNA1164198	26978	248	1.234286	3.06102928	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.1	7.57e-12	NR	KAH3852037.1	45954	g26709	i0	42.9	2.73387096774194	77	40	89.5	2	25	246	253	328	KAH3852037.1 hypothetical protein DPMN_094530, partial [Dreissena polymorpha]	diamond	678	70.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
32506739	32506739	PRJNA1164198_P_NODE_24179_length_253_cov_0.866667_g23910_i0	PRJNA1164198	24179	253	0.866667	2.19266751	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	86.3	1.97e-17	NR	OWF48565.1	6573	g23910	i0	55.8	4.12648221343874	86	33	98.4	3	251	3	590	673	OWF48565.1 DNA-directed RNA polymerase I subunit RPA2 [Mizuhopecten yessoensis]	diamond	1044	86.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis

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