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

10 rows where analysis = "diamond", bioproject = "PRJNA1111077" 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
2765577	2765577	PRJNA1111077_P_NODE_32723_length_247_cov_1.137931_g32502_i0	PRJNA1111077	32723	247	1.137931	2.81068957	Metazoa	33208	Mollusca	Mollusca	122	4.82e-31	NR	XP_063427957.1	6551	g32502	i0	76.3	25.1902834008097	80	19	97.2	0	6	245	172	251	XP_063427957.1 methylmalonate-semialdehyde/malonate-semialdehyde dehydrogenase [acylating], mitochondrial-like isoform X2 [Mytilus trossulus]	diamond	6222	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
5317797	5317797	PRJNA1111077_P_NODE_33725_length_246_cov_0.890173_g33504_i0	PRJNA1111077	33725	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	137	3.68e-37	NR	XP_064616951.1	13599	g33504	i0	80.2	13.8292682926829	81	16	98.8	0	245	3	227	307	XP_064616951.1 deoxyhypusine synthase-like [Liolophura japonica]	diamond	3402	137	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
27194092	27194092	PRJNA1111077_P_NODE_37902_length_228_cov_4.883871_g37681_i0	PRJNA1111077	37902	228	4.883871	11.13522588	Ruditapes philippinarum	129788	Mollusca	Mollusca	80.1	4.39e-17	NR	XP_060563191.1	129788	g37681	i0	72.7	2.97368421052632	55	14	72.4	1	166	2	7	60	XP_060563191.1 small ribosomal subunit protein eS12-like [Ruditapes philippinarum]	diamond	678	80.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
28330999	28330999	PRJNA1111077_P_NODE_34106_length_245_cov_0.895349_g33885_i0	PRJNA1111077	34106	245	0.895349	2.19360505	Haliotis asinina	109174	Mollusca	Mollusca	77.8	1.11e-14	NR	XP_067661214.1	109174	g33885	i0	56.9	1.44489795918367	58	25	71	0	67	240	176	233	XP_067661214.1 uncharacterized protein [Haliotis asinina]	diamond	354	77.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
30067695	30067695	PRJNA1111077_P_NODE_24372_length_272_cov_1.547739_g24151_i0	PRJNA1111077	24372	272	1.547739	4.20985008	Elysia marginata	1093978	Mollusca	Mollusca	107	2.2000000000000004e-28	NR	GFS19501.1	1093978	g24151	i0	77.8	4.16911764705882	54	12	59.6	0	236	75	1	54	GFS19501.1 40S ribosomal protein S29 [Elysia marginata]	diamond	1134	107	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
30573032	30573032	PRJNA1111077_P_NODE_26573_length_264_cov_2.078534_g26352_i0	PRJNA1111077	26573	264	2.078534	5.48732976	Plakobranchus ocellatus	259542	Mollusca	Mollusca	121	8.39e-32	NR	GFO28288.1	259542	g26352	i0	67	2	88	29	100	0	1	264	160	247	GFO28288.1 40S ribosomal protein s4 [Plakobranchus ocellatus]	diamond	528	121	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
31047518	31047518	PRJNA1111077_P_NODE_33135_length_247_cov_0.862069_g32914_i0	PRJNA1111077	33135	247	0.862069	2.12931043	Pomacea canaliculata	400727	Mollusca	Mollusca	62	5.7e-9	NR	XP_025098906.1	400727	g32914	i0	51.9	2.55060728744939	54	25	65.6	1	36	197	227	279	XP_025098906.1 uncharacterized protein LOC112566770 [Pomacea canaliculata]	diamond	630	62	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
31490102	31490102	PRJNA1111077_P_NODE_15216_length_310_cov_3.493671_g14995_i0	PRJNA1111077	15216	310	3.493671	10.8303801	Elysia marginata	1093978	Mollusca	Mollusca	42.7	0.0193	NR	GFR89773.1	1093978	g14995	i0	56.3	0.309677419354839	32	13	30	1	56	148	71	102	GFR89773.1 endonuclease domain of the non-LTR retrotransposon LINE-1 [Elysia marginata]	diamond	96	42.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
31521642	31521642	PRJNA1111077_P_NODE_26896_length_263_cov_1.621053_g26675_i0	PRJNA1111077	26896	263	1.621053	4.26336939	Liolophura japonica	13599	Mollusca	Mollusca	56.6	6.26e-7	NR	XP_064594452.1	13599	g26675	i0	42.4	1.57414448669202	66	38	75.3	0	40	237	760	825	XP_064594452.1 EF-hand calcium-binding domain-containing protein 6-like isoform X2 [Liolophura japonica]	diamond	414	56.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
32597128	32597128	PRJNA1111077_P_NODE_18900_length_290_cov_2.036866_g18679_i0	PRJNA1111077	18900	290	2.036866	5.9069114	Lottia gigantea	225164	Mollusca	Mollusca	44.3	0.0177	NR	XP_009060892.1	225164	g18679	i0	52.6	0.76551724137931	38	13	37.2	2	1	108	24	58	XP_009060892.1 hypothetical protein LOTGIDRAFT_219211 [Lottia gigantea]	diamond	222	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea

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