metadata: contig_metadata: 29 rows where bioproject = "PRJDB9741", tax_clade = "Opisthokonta" and tax

29 rows where bioproject = "PRJDB9741", tax_clade = "Opisthokonta" 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
3837225	3837225	PRJDB9741_P_NODE_42884_length_153_cov_2.355769_g42567_i0	PRJDB9741	42884	153	2.355769	3.60432657	Saccostrea echinata	191078	Mollusca	Mollusca	60.2	7.49e-5	NTclustered	gi\|2628580761\|ref\|XM_061306332.1\|	191078	g42567	i0	92.683	20.359477124183	41	3	27	0	70	110	165	205	PREDICTED: Saccostrea echinata transcription elongation factor SPT6-like (LOC133171567), mRNA	blastn	3115	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
6389130	6389130	PRJDB9741_P_NODE_24566_length_171_cov_1.278689_g24249_i0	PRJDB9741	24566	171	1.278689	2.18655819	Doryteuthis gahi	1051064	Mollusca	Mollusca	115	1.8e-21	NTclustered	gi\|23168245\|gb\|AY083911.1\|	1051064	g24249	i0	89.362	0.549707602339181	94	6	55	2	34	127	320	409	Loligo gahi Lgah9 microsatellite sequence	blastn	94	115	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Doryteuthis	Doryteuthis gahi
6389314	6389314	PRJDB9741_P_NODE_8846_length_213_cov_1.073171_g8529_i0	PRJDB9741	8846	213	1.073171	2.28585423	Pectinidae	6566	Mollusca	Mollusca	72.4	6.25e-14	NR	OWF39386.1	6573	g8529	i0	65.1	4.43661971830986	63	22	88.7	0	1	189	69	131	OWF39386.1 40S ribosomal protein S24 [Mizuhopecten yessoensis]	diamond	945	72.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
7663198	7663198	PRJDB9741_P_NODE_21447_length_175_cov_2.325397_g21130_i0	PRJDB9741	21447	175	2.325397	4.06944475	Uroteuthis chinensis	78424	Mollusca	Mollusca	52.8	0.015	NTclustered	gi\|288189914\|gb\|FJ980015.1\|	78424	g21130	i0	100	0.16	28	0	16	0	4	31	397	370	Uroteuthis chinensis clone 06 microsatellite sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Uroteuthis	Uroteuthis chinensis
12764619	12764619	PRJDB9741_P_NODE_5931_length_258_cov_2.296651_g5614_i0	PRJDB9741	5931	258	2.296651	5.92535958	Bradybaena similaris	145626	Mollusca	Mollusca	84.2	8.33e-12	NTclustered	gi\|2913002590\|dbj\|AP039619.1\|	145626	g5614	i0	79.07	1	129	21	49	6	38	163	251355	251230	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored10, sequence	blastn	258	84.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
14039163	14039163	PRJDB9741_P_NODE_7992_length_222_cov_3.283237_g7675_i0	PRJDB9741	7992	222	3.283237	7.28878614	Opisthokonta	33154	Mollusca	Mollusca	92.8	1.82e-21	NR	XP_035827098.1	6500	g7675	i0	66.7	1.78378378378378	66	22	89.2	0	200	3	16	81	XP_035827098.1 60S ribosomal protein L17 isoform X1 [Aplysia californica]	diamond	396	92.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
15313138	15313138	PRJDB9741_P_NODE_30793_length_165_cov_2.327586_g30476_i0	PRJDB9741	30793	165	2.327586	3.8405169	Sepioteuthis lessoniana	34570	Mollusca	Mollusca	91.6	2.92e-14	NTclustered	gi\|290771289\|dbj\|AB520798.1\|	34570	g30476	i0	87.342	5.02424242424242	79	10	48	0	51	129	149	71	Sepioteuthis lessoniana DNA, Sepioth-SINE1 sequence, clone: 4	blastn	829	91.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Myopsida	Loliginidae	Sepioteuthis	Sepioteuthis lessoniana
23934273	23934273	PRJDB9741_P_NODE_35079_length_163_cov_1.789474_g34762_i0	PRJDB9741	35079	163	1.789474	2.91684262	Ruditapes	186463	Mollusca	Mollusca	302	1.22e-77	NTclustered	gi\|2710387645\|dbj\|LC807132.1\|	129788	g34762	i0	100	74.8159509202454	163	0	100	0	1	163	309	147	Ruditapes philippinarum IDEA_shell301 gene for 28S rRNA, partial sequence	blastn	12195	302	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
24236920	24236920	PRJDB9741_P_NODE_4240_length_316_cov_1.936330_g3924_i0	PRJDB9741	4240	316	1.93633	6.1188028	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	127	7.53e-36	NR	XP_045157389.2	6596	g3924	i0	68.1	7.85126582278481	91	29	86.4	0	25	297	1	91	XP_045157389.2 LOW QUALITY PROTEIN: 60S ribosomal protein L37-like [Mercenaria mercenaria]	diamond	2481	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
25207903	25207903	PRJDB9741_P_NODE_17780_length_182_cov_1.225564_g17463_i0	PRJDB9741	17780	182	1.225564	2.23052648	Metazoa	33208	Mollusca	Mollusca	52.8	0.015	NTclustered	gi\|2442025540\|ref\|XM_045322421.2\|	6596	g17463	i0	100	0.604395604395604	28	0	15	0	101	128	1335	1308	PREDICTED: Mercenaria mercenaria lariat debranching enzyme A-like (LOC123538372), mRNA	blastn	110	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
27221948	27221948	PRJDB9741_P_NODE_21923_length_175_cov_1.071429_g21606_i0	PRJDB9741	21923	175	1.071429	1.87500075	Saccostrea echinata	191078	Mollusca	Mollusca	47.4	3.56e-4	NR	XP_061178134.1	191078	g21606	i0	41.7	2.57142857142857	48	28	82.3	0	32	175	30	77	XP_061178134.1 uncharacterized protein LOC133186815 isoform X2 [Saccostrea echinata]	diamond	450	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
27632897	27632897	PRJDB9741_P_NODE_37804_length_162_cov_0.902655_g37487_i0	PRJDB9741	37804	162	0.902655	1.4623011	Haliotis rufescens	6454	Mollusca	Mollusca	50.8	1.77e-5	NR	XP_048251276.1	6454	g37487	i0	46.3	1	54	27	100	2	162	1	356	407	XP_048251276.1 inversin-like [Haliotis rufescens]	diamond	162	50.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
27879437	27879437	PRJDB9741_P_NODE_6125_length_254_cov_1.712195_g5808_i0	PRJDB9741	6125	254	1.712195	4.3489753	Opisthokonta	33154	Mollusca	Mollusca	101	1.15e-24	NR	XP_052220461.1	45954	g5808	i0	68.8	4.73622047244094	64	20	75.6	0	63	254	16	79	XP_052220461.1 40S ribosomal protein S5 [Dreissena polymorpha]	diamond	1203	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
28485338	28485338	PRJDB9741_P_NODE_16587_length_184_cov_1.244444_g16270_i0	PRJDB9741	16587	184	1.244444	2.28977696	Aplysia californica	6500	Mollusca	Mollusca	50.4	2.46e-5	NR	XP_005095748.1	6500	g16270	i0	46.3	1.80978260869565	54	23	88	1	164	3	1	48	XP_005095748.1 probable glutathione S-transferase [Aplysia californica]	diamond	333	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
28510936	28510936	PRJDB9741_P_NODE_40267_length_161_cov_0.910714_g39950_i0	PRJDB9741	40267	161	0.910714	1.46624954	Metazoa	33208	Mollusca	Mollusca	74.3	6.9e-14	NR	VDI47634.1	29158	g39950	i0	55.8	8.75776397515528	52	23	96.9	0	4	159	170	221	VDI47634.1 obg-like ATPase 1, partial [Mytilus galloprovincialis]	diamond	1410	74.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
29022445	29022445	PRJDB9741_P_NODE_22448_length_174_cov_1.400000_g22131_i0	PRJDB9741	22448	174	1.4	2.436	Pomacea canaliculata	400727	Mollusca	Mollusca	63.5	6.59e-10	NR	XP_025095604.1	400727	g22131	i0	56.1	0.982758620689655	57	25	98.3	0	173	3	545	601	XP_025095604.1 LOW QUALITY PROTEIN: sodium/hydrogen exchanger 9B2-like [Pomacea canaliculata]	diamond	171	63.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
29116962	29116962	PRJDB9741_P_NODE_43489_length_151_cov_2.186275_g43172_i0	PRJDB9741	43489	151	2.186275	3.30127525	Ruditapes philippinarum	129788	Mollusca	Mollusca	43.1	0.00785	NR	XP_060596007.1	129788	g43172	i0	64	0.993377483443709	25	9	49.7	0	112	38	146	170	XP_060596007.1 putative uncharacterized protein DDB_G0288537 isoform X1 [Ruditapes philippinarum]	diamond	150	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
29274492	29274492	PRJDB9741_P_NODE_19589_length_178_cov_2.767442_g19272_i0	PRJDB9741	19589	178	2.767442	4.92604676	Elysia marginata	1093978	Mollusca	Mollusca	87.8	3.72e-21	NR	GFS19501.1	1093978	g19272	i0	79.1	0.72471910112359506	43	9	72.5	0	129	1	1	43	GFS19501.1 40S ribosomal protein S29 [Elysia marginata]	diamond	129	87.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
29337863	29337863	PRJDB9741_P_NODE_31389_length_165_cov_1.318966_g31072_i0	PRJDB9741	31389	165	1.318966	2.1762939	Elysia chlorotica	188477	Mollusca	Mollusca	45.4	0.0015	NR	RUS68674.1	188477	g31072	i0	38.5	0.945454545454545	52	32	94.5	0	165	10	345	396	RUS68674.1 hypothetical protein EGW08_023562 [Elysia chlorotica]	diamond	156	45.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica
29495661	29495661	PRJDB9741_P_NODE_23490_length_172_cov_1.804878_g23173_i0	PRJDB9741	23490	172	1.804878	3.10439016	Dreissena polymorpha	45954	Mollusca	Mollusca	83.6	7.65e-19	NR	KAH3809748.1	45954	g23173	i0	57.1	0.976744186046512	56	24	97.7	0	169	2	44	99	KAH3809748.1 hypothetical protein DPMN_138126 [Dreissena polymorpha]	diamond	168	83.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
29552641	29552641	PRJDB9741_P_NODE_12130_length_194_cov_1.406897_g11813_i0	PRJDB9741	12130	194	1.406897	2.72938018	Metazoa	33208	Mollusca	Mollusca	80.1	1.39e-16	NR	XP_045177422.1	6596	g11813	i0	59.4	16.2216494845361	64	26	99	0	193	2	30	93	XP_045177422.1 40S ribosomal protein S10-like isoform X1 [Mercenaria mercenaria]	diamond	3147	80.5	0.995031055900621	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29811290	29811290	PRJDB9741_P_NODE_4431_length_308_cov_1.536680_g4115_i0	PRJDB9741	4431	308	1.53668	4.7329744	Batillaria attramentaria	370345	Mollusca	Mollusca	68.2	2.12e-11	NR	KAK7498057.1	370345	g4115	i0	42.6	1.97727272727273	101	53	98.4	2	2	304	104	199	KAK7498057.1 hypothetical protein BaRGS_00010645 [Batillaria attramentaria]	diamond	609	68.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Batillariidae	Batillaria	Batillaria attramentaria
30152707	30152707	PRJDB9741_P_NODE_17232_length_183_cov_1.141791_g16915_i0	PRJDB9741	17232	183	1.141791	2.08947753	Cephalopoda	6605	Mollusca	Mollusca	78.6	2.19e-15	NR	CAE1177328.1	158019	g16915	i0	61.7	13.6229508196721	60	23	98.4	0	2	181	153	212	CAE1177328.1 unnamed protein product [Acanthosepion pharaonis]	diamond	2493	79	0.994936708860759	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
30285696	30285696	PRJDB9741_P_NODE_21392_length_175_cov_2.944444_g21075_i0	PRJDB9741	21392	175	2.944444	5.152777	Mactra antiquata	2302425	Mollusca	Mollusca	89.7	8.95e-20	NR	KAL4229593.1	2302425	g21075	i0	60.3	2.86285714285714	58	23	99.4	0	174	1	9	66	KAL4229593.1 LIM and SH3 domain protein 1 [Mactra antiquata]	diamond	501	89.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
30822405	30822405	PRJDB9741_P_NODE_3454_length_364_cov_1.879365_g3138_i0	PRJDB9741	3454	364	1.879365	6.8408886	Pinctada imbricata	66713	Mollusca	Mollusca	122	3.0599999999999996e-32	NR	KAK3086084.1	66713	g3138	i0	57.7	1.83791208791209	111	45	91.5	1	364	32	57	165	KAK3086084.1 hypothetical protein FSP39_013270 [Pinctada imbricata]	diamond	669	122	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
31106633	31106633	PRJDB9741_P_NODE_38795_length_161_cov_2.705357_g38478_i0	PRJDB9741	38795	161	2.705357	4.35562477	Batillaria attramentaria	370345	Mollusca	Mollusca	60.1	1.84e-9	NR	KAK7503715.1	370345	g38478	i0	62.3	0.987577639751553	53	18	95	1	159	7	104	156	KAK7503715.1 hypothetical protein BaRGS_00004838 [Batillaria attramentaria]	diamond	159	60.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Batillariidae	Batillaria	Batillaria attramentaria
32055568	32055568	PRJDB9741_P_NODE_6458_length_247_cov_1.590909_g6141_i0	PRJDB9741	6458	247	1.590909	3.92954523	Gigantopelta aegis	1735272	Mollusca	Mollusca	95.9	2.4600000000000003e-21	NR	XP_041379194.1	1735272	g6141	i0	60.5	1.96761133603239	81	32	98.4	0	245	3	111	191	XP_041379194.1 LOW QUALITY PROTEIN: 60S ribosomal protein L4-B-like, partial [Gigantopelta aegis]	diamond	486	95.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
32303107	32303107	PRJDB9741_P_NODE_10179_length_206_cov_2.700637_g9862_i0	PRJDB9741	10179	206	2.700637	5.56331222	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52	1.24e-5	NR	VDI48492.1	29158	g9862	i0	43.1	2.76699029126214	58	31	81.6	1	195	28	523	580	VDI48492.1 Hypothetical predicted protein [Mytilus galloprovincialis]	diamond	570	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
32776278	32776278	PRJDB9741_P_NODE_34100_length_164_cov_0.886957_g33783_i0	PRJDB9741	34100	164	0.886957	1.45460948	Metazoa	33208	Mollusca	Mollusca	83.2	4.65e-18	NR	XP_053383937.1	6596	g33783	i0	75.5	6.80487804878049	53	13	97	0	164	6	106	158	XP_053383937.1 ADP-ribosylation factor-like protein 1 isoform X1 [Mercenaria mercenaria]	diamond	1116	83.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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