metadata: contig_metadata: 29 rows where bioproject = "PRJNA1180292" and tax

29 rows where bioproject = "PRJNA1180292" 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
1592542	1592542	PRJNA1180292_P_NODE_3982_length_345_cov_1.036765_g3850_i0	PRJNA1180292	3982	345	1.036765	3.57683925	root	1	Root_unresolved	Root_unresolved	187	2.059999999999999e-55	NR	XP_022290279.1	6565	g3850	i0	84.3	101.6	108	17	93.9	0	3	326	273	380	XP_022290279.1 isocitrate dehydrogenase [NADP] cytoplasmic-like [Crassostrea virginica]	diamond	35052	188	0.99468085106383	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
2868699	2868699	PRJNA1180292_P_NODE_5463_length_299_cov_1.035398_g5331_i0	PRJNA1180292	5463	299	1.035398	3.09584002	Patella vulgata	6465	Mollusca	Mollusca	252	2.55e-62	NTclustered	gi\|2506343322\|ref\|XM_050562954.2\|	6465	g5331	i0	81.879	9.81270903010033	298	54	99	0	2	299	3303	3600	PREDICTED: Patella vulgata splicing factor 3B subunit 1 (LOC126832243), transcript variant X1, mRNA	blastn	2934	252	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
2868704	2868704	PRJNA1180292_P_NODE_5743_length_291_cov_1.082569_g5611_i0	PRJNA1180292	5743	291	1.082569	3.15027579	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.027	NTclustered	gi\|2912997258\|dbj\|AP039602.1\|	145626	g5611	i0	96.774	0.106529209621993	31	1	11	0	261	291	57848686	57848716	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
4144810	4144810	PRJNA1180292_P_NODE_6284_length_280_cov_1.507246_g6152_i0	PRJNA1180292	6284	280	1.507246	4.2202888	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.026	NTclustered	gi\|2912991694\|dbj\|AP039596.1\|	145626	g6152	i0	100	0.1	28	0	10	0	24	51	27170673	27170700	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
9245745	9245745	PRJNA1180292_P_NODE_3308_length_378_cov_0.822951_g3176_i0	PRJNA1180292	3308	378	0.822951	3.11075478	Mya arenaria	6604	Mollusca	Mollusca	54.7	0.01	NTclustered	gi\|2427467042\|ref\|XM_052939866.1\|	6604	g3176	i0	100	0.153439153439153	29	0	8	0	219	247	938	966	PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
10521544	10521544	PRJNA1180292_P_NODE_6949_length_268_cov_1.200000_g6817_i0	PRJNA1180292	6949	268	1.2	3.216	Metazoa	33208	Mollusca	Mollusca	109	1.74e-25	NR	XP_033730583.1	6579	g6817	i0	57.5	18.6828358208955	87	37	97.4	0	265	5	414	500	XP_033730583.1 bifunctional glutamate/proline--tRNA ligase-like [Pecten maximus]	diamond	5007	109	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
13071445	13071445	PRJNA1180292_P_NODE_10191_length_248_cov_0.891429_g10059_i0	PRJNA1180292	10191	248	0.891429	2.21074392	Metazoa	33208	Mollusca	Mollusca	120	3.46e-30	NR	XP_046577520.1	36100	g10059	i0	69.1	4.8991935483871	81	25	98	0	245	3	351	431	XP_046577520.1 ERO1-like protein beta isoform X2 [Haliotis rubra]	diamond	1215	121	0.991735537190083	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
13071460	13071460	PRJNA1180292_P_NODE_11631_length_245_cov_0.906977_g11499_i0	PRJNA1180292	11631	245	0.906977	2.22209365	Opisthokonta	33154	Mollusca	Mollusca	123	7.749999999999999e-31	NR	XP_062619255.1	36930	g11499	i0	77.3	19.0285714285714	75	17	91.8	0	237	13	293	367	XP_062619255.1 cystathionine beta-synthase-like isoform X2 [Saccostrea cuccullata]	diamond	4662	123	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
14346854	14346854	PRJNA1180292_P_NODE_10612_length_247_cov_0.896552_g10480_i0	PRJNA1180292	10612	247	0.896552	2.21448344	Bulinus truncatus	55810	Mollusca	Mollusca	117	5.919999999999999e-31	NR	KAH9525053.1	55810	g10480	i0	70.7	7.83400809716599	82	24	99.6	0	1	246	51	132	KAH9525053.1 Eukaryotic translation initiation factor 1A, X-chromosomal [Bulinus truncatus]	diamond	1935	117	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Bulinus	Bulinus truncatus
15068940	15068940	PRJNA1180292_P_NODE_13212_length_237_cov_2.378049_g13080_i0	PRJNA1180292	13212	237	2.378049	5.63597613	Metazoa	33208	Mollusca	Mollusca	161	3.3899999999999995e-35	NTclustered	gi\|2334780997\|ref\|XM_052213963.1\|	6549	g13080	i0	79.487	25.1054852320675	234	42	97	6	1	231	860	1090	PREDICTED: Mytilus californianus S-adenosylmethionine synthase-like (LOC127708817), mRNA	blastn	5950	161	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
16894989	16894989	PRJNA1180292_P_NODE_4854_length_315_cov_1.301653_g4722_i0	PRJNA1180292	4854	315	1.301653	4.10020695	Mercenaria mercenaria	6596	Mollusca	Mollusca	76.8	1.75e-9	NTclustered	gi\|2442001482\|ref\|XM_053522755.1\|	6596	g4722	i0	80.374	2.63174603174603	107	15	35	6	6	112	406	306	PREDICTED: Mercenaria mercenaria keratin-associated protein 19-2-like (LOC123528192), transcript variant X2, mRNA	blastn	829	76.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
17619029	17619029	PRJNA1180292_P_NODE_2714_length_413_cov_1.367647_g2582_i0	PRJNA1180292	2714	413	1.367647	5.64838211	Pecten maximus	6579	Mollusca	Mollusca	166	5.929999999999999e-47	NR	XP_033750985.1	6579	g2582	i0	73.7	0.995157384987893	137	36	99.5	0	413	3	212	348	XP_033750985.1 tropomyosin isoform X5 [Pecten maximus]	diamond	411	166	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
20719207	20719207	PRJNA1180292_P_NODE_2117_length_467_cov_1.868020_g1985_i0	PRJNA1180292	2117	467	1.86802	8.7236534	Littorina saxatilis	31220	Mollusca	Mollusca	305	3.15e-78	NTclustered	gi\|2868633896\|ref\|XM_070320054.1\|	31220	g1985	i0	78.618	26.9036402569593	463	97	99	2	6	467	321	782	PREDICTED: Littorina saxatilis small ribosomal subunit protein uS7-like (LOC138948500), mRNA	blastn	12564	305	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
22718128	22718128	PRJNA1180292_P_NODE_11798_length_245_cov_0.906977_g11666_i0	PRJNA1180292	11798	245	0.906977	2.22209365	Metazoa	33208	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2751266908\|ref\|XM_011434352.4\|	29159	g11666	i0	100	0.342857142857143	28	0	11	0	29	56	1925	1898	PREDICTED: Magallana gigas RNA-binding protein 5 (LOC105331958), mRNA	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
27407661	27407661	PRJNA1180292_P_NODE_12823_length_242_cov_0.923077_g12691_i0	PRJNA1180292	12823	242	0.923077	2.23384634	Mytilus	6548	Mollusca	Mollusca	48.9	2.35e-4	NR	CAG2242920.1	6550	g12691	i0	34.7	3.71900826446281	75	45	93	2	225	1	203	273	CAG2242920.1 unnamed protein product [Mytilus edulis]	diamond	900	48.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27975717	27975717	PRJNA1180292_P_NODE_4545_length_325_cov_3.210317_g4413_i0	PRJNA1180292	4545	325	3.210317	10.43353025	Mollusca	6447	Mollusca	Mollusca	122	3.53e-33	NR	XP_050403034.1	6465	g4413	i0	72.1	4.61538461538461	86	23	78.5	1	70	324	1	86	XP_050403034.1 40S ribosomal protein S12 [Patella vulgata]	diamond	1500	122	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
28354579	28354579	PRJNA1180292_P_NODE_2266_length_453_cov_1.739474_g2134_i0	PRJNA1180292	2266	453	1.739474	7.87981722	Aplysiida	6497	Mollusca	Mollusca	60.5	2.12e-7	NR	XP_005104498.1	6500	g2134	i0	51	2.31788079470199	49	23	31.8	1	101	244	475	523	XP_005104498.1 zinc finger protein 652-B isoform X22 [Aplysia californica]	diamond	1050	60.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
28398649	28398649	PRJNA1180292_P_NODE_7626_length_255_cov_1.714286_g7494_i0	PRJNA1180292	7626	255	1.714286	4.3714293	Mya arenaria	6604	Mollusca	Mollusca	47.8	3.65e-4	NR	WAQ95906.1	6604	g7494	i0	44.4	0.635294117647059	54	27	60	1	101	253	57	110	WAQ95906.1 ANGL4-like protein [Mya arenaria]	diamond	162	47.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
29459424	29459424	PRJNA1180292_P_NODE_10690_length_247_cov_0.896552_g10558_i0	PRJNA1180292	10690	247	0.896552	2.21448344	Metazoa	33208	Mollusca	Mollusca	145	1.3399999999999996e-42	NR	XP_052106788.1	6549	g10558	i0	79	18.6923076923077	81	17	98.4	0	245	3	36	116	XP_052106788.1 peptidyl-prolyl cis-trans isomerase FKBP2-like [Mytilus californianus]	diamond	4617	146	0.993150684931507	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
29629676	29629676	PRJNA1180292_P_NODE_4990_length_311_cov_1.638655_g4858_i0	PRJNA1180292	4990	311	1.638655	5.09621705	Haliotis discus discus	91233	Mollusca	Mollusca	119	2.38e-29	NR	ALY11013.1	91233	g4858	i0	83.5	3.94533762057878	103	17	99.4	0	3	311	256	358	ALY11013.1 calreticulin [Haliotis discus discus]	diamond	1227	119	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis discus
30059615	30059615	PRJNA1180292_P_NODE_7291_length_261_cov_2.973404_g7159_i0	PRJNA1180292	7291	261	2.973404	7.76058444	Metazoa	33208	Mollusca	Mollusca	111	6.56e-29	NR	XP_069122665.1	31199	g7159	i0	83.9	12.0689655172414	62	10	71.3	0	188	3	2	63	XP_069122665.1 eukaryotic translation initiation factor 5A-like [Argopecten irradians]	diamond	3150	111	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
30281367	30281367	PRJNA1180292_P_NODE_6712_length_272_cov_1.417085_g6580_i0	PRJNA1180292	6712	272	1.417085	3.8544712	Metazoa	33208	Mollusca	Mollusca	136	7.39e-36	NR	XP_022340362.1	6565	g6580	i0	66.7	17.8566176470588	90	30	99.3	0	271	2	117	206	XP_022340362.1 aldehyde dehydrogenase family 3 member B1-like isoform X2 [Crassostrea virginica]	diamond	4857	136	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30957063	30957063	PRJNA1180292_P_NODE_10354_length_248_cov_0.891429_g10222_i0	PRJNA1180292	10354	248	0.891429	2.21074392	Sinanodonta woodiana	1069815	Mollusca	Mollusca	70.5	4.76e-12	NR	KAL3876563.1	1069815	g10222	i0	38.8	1.94758064516129	80	49	96.8	0	5	244	196	275	KAL3876563.1 hypothetical protein ACJMK2_034401 [Sinanodonta woodiana]	diamond	483	70.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Sinanodonta	Sinanodonta woodiana
32063626	32063626	PRJNA1180292_P_NODE_11838_length_244_cov_1.818713_g11706_i0	PRJNA1180292	11838	244	1.818713	4.43765972	Pomacea canaliculata	400727	Mollusca	Mollusca	63.2	2.36e-9	NR	PVD19910.1	400727	g11706	i0	43.8	1.9672131147541	80	42	98.4	1	240	1	210	286	PVD19910.1 hypothetical protein C0Q70_20404 [Pomacea canaliculata]	diamond	480	63.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
32557757	32557757	PRJNA1180292_P_NODE_3619_length_360_cov_1.087108_g3487_i0	PRJNA1180292	3619	360	1.087108	3.9135888	Metazoa	33208	Mollusca	Mollusca	82	5.15e-16	NR	XP_069123765.1	31199	g3487	i0	38.7	2.8	106	58	82.5	3	351	55	157	262	XP_069123765.1 elastase-1-like [Argopecten irradians]	diamond	1008	82.8	0.990338164251208	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
32601482	32601482	PRJNA1180292_P_NODE_740_length_809_cov_15.782609_g620_i0	PRJNA1180292	740	809	15.782609	127.68130681	Magallana gigas	29159	Mollusca	Mollusca	194	5.43e-58	NR	XP_034312378.1	29159	g620	i0	54.6	4.23856613102596	183	80	66.7	2	806	267	28	210	XP_034312378.1 glutathione peroxidase-like isoform X1 [Magallana gigas]	diamond	3429	194	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
32664254	32664254	PRJNA1180292_P_NODE_1360_length_589_cov_2.788760_g1228_i0	PRJNA1180292	1360	589	2.78876	16.4257964	Crassostrea virginica	6565	Mollusca	Mollusca	57.4	7.05e-6	NR	XP_022336975.1	6565	g1228	i0	24.5	0.789473684210526	155	98	77.4	2	584	129	5	143	XP_022336975.1 E3 ubiquitin-protein ligase TRAIP-like [Crassostrea virginica]	diamond	465	57.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
32777812	32777812	PRJNA1180292_P_NODE_11200_length_246_cov_0.901734_g11068_i0	PRJNA1180292	11200	246	0.901734	2.21826564	Octopus	6643	Mollusca	Mollusca	78.2	5.08e-16	NR	XP_052832541.1	37653	g11068	i0	39.5	2.96341463414634	81	49	98.8	0	244	2	30	110	XP_052832541.1 protein FAM136A [Octopus bimaculoides]	diamond	729	78.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
32790151	32790151	PRJNA1180292_P_NODE_8000_length_253_cov_0.866667_g7868_i0	PRJNA1180292	8000	253	0.866667	2.19266751	Candidula unifasciata	100452	Mollusca	Mollusca	43.1	0.031	NR	CAG5116958.1	100452	g7868	i0	38.6	0.675889328063241	57	30	61.7	1	188	33	1104	1160	CAG5116958.1 unnamed protein product, partial [Candidula unifasciata]	diamond	171	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata

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