metadata: contig_metadata: 21 rows where bioproject = "PRJNA169559" and tax

21 rows where bioproject = "PRJNA169559" 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
5468559	5468559	PRJNA169559_P_NODE_9565_length_549_cov_4.980769_g7841_i0	PRJNA169559	9565	549	4.980769	27.34442181	Metazoa	33208	Mollusca	Mollusca	163	1.19e-47	NR	XP_052229778.1	45954	g7841	i0	54.1	3.15300546448087	170	77	92.3	1	533	27	1	170	XP_052229778.1 60S ribosomal protein L23a-like [Dreissena polymorpha]	diamond	1731	163	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
6742522	6742522	PRJNA169559_P_NODE_1086_length_1558_cov_5.109876_g575_i0	PRJNA169559	1086	1558	5.109876	79.61186808	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.045	NTclustered	gi\|2912990805\|dbj\|AP039595.1\|	145626	g575	i0	100	0.0186136071887035	29	0	2	0	1240	1268	3575528	3575500	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
6742897	6742897	PRJNA169559_P_NODE_8646_length_578_cov_4.945355_g6989_i0	PRJNA169559	8646	578	4.945355	28.5841519	Opisthokonta	33154	Mollusca	Mollusca	128	3.33e-33	NR	KAL4224502.1	2302425	g6989	i0	62.2	19.6349480968858	98	37	50.9	0	570	277	38	135	KAL4224502.1 ribosomal 40S subunit protein S10A [Mactra antiquata]	diamond	11349	128	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
8018194	8018194	PRJNA169559_P_NODE_13827_length_451_cov_5.376777_g11914_i0	PRJNA169559	13827	451	5.376777	24.24926427	Metazoa	33208	Mollusca	Mollusca	176	8.439999999999998e-54	NR	KAL5014429.1	13268	g11914	i0	76.3	10.2305986696231	114	26	75.2	1	440	102	19	132	KAL5014429.1 hypothetical protein ScPMuIL_008699 [Solemya velum]	diamond	4614	176	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
11843450	11843450	PRJNA169559_P_NODE_13590_length_455_cov_2.077465_g11683_i0	PRJNA169559	13590	455	2.077465	9.45246575	Bradybaena similaris	145626	Mollusca	Mollusca	63.9	2.04e-5	NTclustered	gi\|2912981848\|dbj\|AP039587.1\|	145626	g11683	i0	93.023	0.0945054945054945	43	3	9	0	137	179	91386534	91386576	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence	blastn	43	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18216544	18216544	PRJNA169559_P_NODE_11075_length_506_cov_3.882600_g9262_i0	PRJNA169559	11075	506	3.8826	19.645956	Mollusca	6447	Mollusca	Mollusca	121	1.0699999999999999e-31	NR	XP_048745035.2	37623	g9262	i0	43	3.04150197628458	128	70	75.9	1	103	486	32	156	XP_048745035.2 eukaryotic translation initiation factor 5A-1-like [Ostrea edulis]	diamond	1539	122	0.991803278688525	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
18216590	18216590	PRJNA169559_P_NODE_17315_length_408_cov_5.303430_g15325_i0	PRJNA169559	17315	408	5.30343	21.6379944	Potamilus streckersoni	2493646	Mollusca	Mollusca	130	2.13e-36	NR	KAK3592046.1	2493646	g15325	i0	69.2	2.24264705882353	91	25	64.7	1	384	121	1	91	KAK3592046.1 hypothetical protein CHS0354_019301 [Potamilus streckersoni]	diamond	915	130	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
18216832	18216832	PRJNA169559_P_NODE_47255_length_181_cov_2.026316_g45178_i0	PRJNA169559	47255	181	2.026316	3.66763196	Gigantopelta aegis	1735272	Mollusca	Mollusca	92.4	1.16e-20	NR	XP_041375463.1	1735272	g45178	i0	72.9	2.93370165745856	59	16	97.8	0	3	179	223	281	XP_041375463.1 cathepsin Z-like [Gigantopelta aegis]	diamond	531	92.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
20766676	20766676	PRJNA169559_P_NODE_46957_length_186_cov_2.522293_g44880_i0	PRJNA169559	46957	186	2.522293	4.69146498	Aplysia californica	6500	Mollusca	Mollusca	52.8	0.016	NTclustered	gi\|1897936549\|ref\|XM_005106389.3\|	6500	g44880	i0	100	0.150537634408602	28	0	15	0	136	163	3673	3646	PREDICTED: Aplysia californica RRP12-like protein (LOC101856684), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
28368700	28368700	PRJNA169559_P_NODE_9746_length_544_cov_2.679612_g8014_i0	PRJNA169559	9746	544	2.679612	14.57708928	Elysia chlorotica	188477	Mollusca	Mollusca	99.8	1.9300000000000001e-22	NR	RUS84494.1	188477	g8014	i0	35.5	2.81801470588235	172	103	90.4	4	495	4	5	176	RUS84494.1 hypothetical protein EGW08_007733 [Elysia chlorotica]	diamond	1533	99.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica
28575990	28575990	PRJNA169559_P_NODE_48807_length_153_cov_2.266129_g46730_i0	PRJNA169559	48807	153	2.266129	3.46717737	Mytilus	6548	Mollusca	Mollusca	41.6	0.0279	NR	XP_052105198.1	6549	g46730	i0	50	2.11764705882353	36	14	70.6	1	118	11	257	288	XP_052105198.1 von Willebrand factor A domain-containing protein 5A-like [Mytilus californianus]	diamond	324	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
28747679	28747679	PRJNA169559_P_NODE_1987_length_1174_cov_2.775546_g1207_i0	PRJNA169559	1987	1174	2.775546	32.58491004	Crassostrea virginica	6565	Mollusca	Mollusca	50.4	0.0102	NR	XP_022332114.1	6565	g1207	i0	40	0.191652470187394	75	41	18.4	2	577	362	153	226	XP_022332114.1 ribosome biogenesis protein NOP53-like isoform X1 [Crassostrea virginica]	diamond	225	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
29000648	29000648	PRJNA169559_P_NODE_45668_length_206_cov_2.389831_g43591_i0	PRJNA169559	45668	206	2.389831	4.92305186	Patella vulgata	6465	Mollusca	Mollusca	44.7	0.00484	NR	XP_050397070.1	6465	g43591	i0	51.4	0.509708737864078	35	17	51	0	204	100	316	350	XP_050397070.1 carnitine O-palmitoyltransferase 1, liver isoform [Patella vulgata]	diamond	105	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
29095118	29095118	PRJNA169559_P_NODE_7088_length_637_cov_3.657895_g5558_i0	PRJNA169559	7088	637	3.657895	23.30079115	Crassostrea virginica	6565	Mollusca	Mollusca	49.7	0.00381	NR	XP_022332114.1	6565	g5558	i0	40	0.353218210361067	75	41	33.9	2	71	286	153	226	XP_022332114.1 ribosome biogenesis protein NOP53-like isoform X1 [Crassostrea virginica]	diamond	225	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
29252621	29252621	PRJNA169559_P_NODE_29549_length_267_cov_2.016807_g27473_i0	PRJNA169559	29549	267	2.016807	5.38487469	Solemya velum	13268	Mollusca	Mollusca	53.1	1.15e-5	NR	KAL5008572.1	13268	g27473	i0	36.8	0.853932584269663	76	42	84.3	2	16	240	81	151	KAL5008572.1 hypothetical protein ScPMuIL_014153 [Solemya velum]	diamond	228	53.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
29726204	29726204	PRJNA169559_P_NODE_2770_length_994_cov_3.058031_g1801_i0	PRJNA169559	2770	994	3.058031	30.39682814	Crassostrea virginica	6565	Mollusca	Mollusca	50.4	0.0073	NR	XP_022332114.1	6565	g1801	i0	40	0.22635814889336	75	41	21.7	2	577	362	153	226	XP_022332114.1 ribosome biogenesis protein NOP53-like isoform X1 [Crassostrea virginica]	diamond	225	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30010897	30010897	PRJNA169559_P_NODE_3831_length_857_cov_2.961353_g2685_i0	PRJNA169559	3831	857	2.961353	25.37879521	Crassostrea virginica	6565	Mollusca	Mollusca	50.4	0.00511	NR	XP_022332114.1	6565	g2685	i0	40	0.262543757292882	75	41	25.2	2	787	572	153	226	XP_022332114.1 ribosome biogenesis protein NOP53-like isoform X1 [Crassostrea virginica]	diamond	225	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30786850	30786850	PRJNA169559_P_NODE_35254_length_247_cov_1.252294_g33177_i0	PRJNA169559	35254	247	1.252294	3.09316618	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.7	0.00863	NR	KAI8782171.1	6526	g33177	i0	79.2	5.75708502024291	24	5	29.1	0	1	72	3883	3906	KAI8782171.1 dynein heavy chain 12, axonemal, partial [Biomphalaria glabrata]	diamond	1422	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
31970462	31970462	PRJNA169559_P_NODE_46978_length_186_cov_1.624204_g44901_i0	PRJNA169559	46978	186	1.624204	3.02101944	Mactra antiquata	2302425	Mollusca	Mollusca	63.5	7.69e-10	NR	KAL4221267.1	2302425	g44901	i0	76.9	0.629032258064516	39	9	62.9	0	3	119	333	371	KAL4221267.1 Beta-enolase [Mactra antiquata]	diamond	117	63.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
32413585	32413585	PRJNA169559_P_NODE_46599_length_192_cov_1.840491_g44522_i0	PRJNA169559	46599	192	1.840491	3.53374272	Aplysia californica	6500	Mollusca	Mollusca	41.6	0.0484	NR	XP_005098370.2	6500	g44522	i0	44.4	0.703125	45	25	70.3	0	140	6	472	516	XP_005098370.2 cocaine esterase [Aplysia californica]	diamond	135	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
32809774	32809774	PRJNA169559_P_NODE_2860_length_979_cov_2.085263_g1874_i0	PRJNA169559	2860	979	2.085263	20.41472477	root	1	Root_unresolved	Root_unresolved	208	1.7999999999999998e-57	NR	CAG5125521.1	100452	g1874	i0	45.4	10.9458631256384	238	117	69.6	2	971	291	8	243	CAG5125521.1 unnamed protein product [Candidula unifasciata]	diamond	10716	208	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);;