metadata: contig_metadata: 18 rows where bioproject = "PRJNA745553" and tax

18 rows where bioproject = "PRJNA745553" 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
724000	724000	PRJNA745553_S_NODE_11581_length_359_cov_33.755245_g11386_i0	PRJNA745553	11581	359	33.755245	121.18132955	Haliotis rubra	36100	Mollusca	Mollusca	58.4	7.31e-4	NTclustered	gi\|2194079676\|ref\|XM_046725280.1\|	36100	g11386	i0	94.737	0.105849582172702	38	1	11	1	97	134	316	352	PREDICTED: Haliotis rubra ecdysone-induced protein 75B-like (LOC124288704), mRNA	blastn	38	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
724306	724306	PRJNA745553_S_NODE_29521_length_217_cov_7.465278_g29326_i0	PRJNA745553	29521	217	7.465278	16.19965326	Crassostrea virginica	6565	Mollusca	Mollusca	52.8	0.019	NTclustered	gi\|1242809517\|ref\|XM_022489879.1\|	6565	g29326	i0	100	0.129032258064516	28	0	13	0	5	32	403	376	PREDICTED: Crassostrea virginica probable ATP-dependent RNA helicase DDX27 (LOC111138077), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
724405	724405	PRJNA745553_S_NODE_6901_length_449_cov_5.795213_g6707_i0	PRJNA745553	6901	449	5.795213	26.02050637	Mytilus californianus	6549	Mollusca	Mollusca	58.4	0.001	NTclustered	gi\|2334630686\|ref\|XR_007989291.1\|	6549	g6707	i0	97.059	0.0757238307349666	34	1	8	0	359	392	160	127	PREDICTED: Mytilus californianus uncharacterized LOC127717681 (LOC127717681), ncRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
5828063	5828063	PRJNA745553_S_NODE_725_length_836_cov_4.114024_g624_i0	PRJNA745553	725	836	4.114024	34.39324064	Pecten maximus	6579	Mollusca	Mollusca	72.4	2.44e-10	NR	XP_033740227.1	6579	g624	i0	50	0.215311004784689	60	30	21.5	0	263	84	370	429	XP_033740227.1 baculoviral IAP repeat-containing protein 3-like [Pecten maximus]	diamond	180	72.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
8377472	8377472	PRJNA745553_S_NODE_1727_length_680_cov_3.326194_g1567_i0	PRJNA745553	1727	680	3.326194	22.6181192	Metazoa	33208	Mollusca	Mollusca	300	4.16e-99	NR	XP_046363152.1	6454	g1567	i0	63.8	34.7558823529412	218	70	92.2	2	3	629	82	299	XP_046363152.1 cathepsin Z-like [Haliotis rufescens]	diamond	23634	301	0.996677740863787	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
9652490	9652490	PRJNA745553_S_NODE_12528_length_347_cov_1.992701_g12333_i0	PRJNA745553	12528	347	1.992701	6.91467247	Haliotis rubra	36100	Mollusca	Mollusca	52.8	0.033	NTclustered	gi\|2194124140\|ref\|XM_046718080.1\|	36100	g12333	i0	100	0.0806916426512968	28	0	8	0	114	141	402	429	PREDICTED: Haliotis rubra uncharacterized LOC124282110 (LOC124282110), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
10928045	10928045	PRJNA745553_S_NODE_13669_length_333_cov_1.130769_g13474_i0	PRJNA745553	13669	333	1.130769	3.76546077	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	52.8	0.031	NTclustered	gi\|1207949258\|ref\|XM_021508902.1\|	6573	g13474	i0	100	0.168168168168168	28	0	8	0	227	254	2031	2058	PREDICTED: Mizuhopecten yessoensis major vault protein-like (LOC110457569), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
10928378	10928378	PRJNA745553_S_NODE_5709_length_481_cov_7.156863_g5515_i0	PRJNA745553	5709	481	7.156863	34.42451103	Lottia digitalis	225159	Mollusca	Mollusca	150	1.6199999999999998e-31	NTclustered	gi\|82697844\|gb\|DQ248942.1\|	225159	g5515	i0	91.667	22.7713097713098	108	9	22	0	351	458	4809	4702	Lottia digitalis external transcribed spacer 1, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and external transcribed spacer 2, complete sequence	blastn	10953	150	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia digitalis
17302326	17302326	PRJNA745553_S_NODE_24394_length_250_cov_11.796610_g24199_i0	PRJNA745553	24394	250	11.79661	29.491525	Anadara broughtonii	148819	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2170965484\|dbj\|LC593126.1\|	148819	g24199	i0	100	0.46	30	0	12	0	221	250	58	29	Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds	blastn	115	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Anadara	Anadara broughtonii
20325142	20325142	PRJNA745553_S_NODE_27416_length_237_cov_2.054878_g27221_i0	PRJNA745553	27416	237	2.054878	4.87006086	Stylommatophora	6527	Mollusca	Mollusca	292	1.15e-74	NTclustered	gi\|1700712081\|gb\|MN022672.1\|	145599	g27221	i0	94.681	75.8143459915612	188	10	79	0	23	210	1122	1309	Vitrina pellucida 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17968	292	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Vitrinidae	Vitrina	Vitrina pellucida
24950824	24950824	PRJNA745553_S_NODE_28460_length_229_cov_5.256410_g28265_i0	PRJNA745553	28460	229	5.25641	12.0371789	Physella acuta	109671	Mollusca	Mollusca	106	1.55e-18	NTclustered	gi\|2572320127\|ref\|XM_059297186.1\|	109671	g28265	i0	86.458	13.1310043668122	96	13	42	0	1	96	1365	1460	PREDICTED: Physella acuta tubulin alpha-1A chain (LOC131938941), mRNA	blastn	3007	106	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
27178967	27178967	PRJNA745553_S_NODE_11942_length_355_cov_1.663121_g11747_i0	PRJNA745553	11942	355	1.663121	5.90407955	Mactra antiquata	2302425	Mollusca	Mollusca	66.2	7.89e-10	NR	KAL4240157.1	2302425	g11747	i0	34.1	1.46197183098592	88	57	74.4	1	63	326	666	752	KAL4240157.1 hypothetical protein ACF0H5_000951 [Mactra antiquata]	diamond	519	66.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
28474009	28474009	PRJNA745553_S_NODE_18466_length_287_cov_3.785047_g18271_i0	PRJNA745553	18466	287	3.785047	10.86308489	Acanthosepion pharaonis	158019	Mollusca	Mollusca	43.5	0.0354	NR	CAE1236277.1	158019	g18271	i0	41.8	0.825783972125436	79	38	82.6	2	42	278	1363	1433	CAE1236277.1 unnamed protein product [Acanthosepion pharaonis]	diamond	237	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
29863145	29863145	PRJNA745553_S_NODE_15391_length_314_cov_2.759336_g15196_i0	PRJNA745553	15391	314	2.759336	8.66431504	Pecten maximus	6579	Mollusca	Mollusca	65.5	9.02e-10	NR	XP_033732660.1	6579	g15196	i0	45.6	1.29936305732484	68	37	65	0	20	223	787	854	XP_033732660.1 uncharacterized protein C05D11.1-like isoform X2 [Pecten maximus]	diamond	408	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
30189013	30189013	PRJNA745553_S_NODE_25732_length_245_cov_1.976744_g25537_i0	PRJNA745553	25732	245	1.976744	4.8430228	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	9.95e-23	NR	XP_041377661.1	1735272	g25537	i0	65.7	2.43673469387755	70	23	84.5	1	221	15	2405	2474	XP_041377661.1 serine/threonine-protein kinase mTOR-like isoform X2 [Gigantopelta aegis]	diamond	597	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
30316001	30316001	PRJNA745553_S_NODE_13492_length_335_cov_1.351145_g13297_i0	PRJNA745553	13492	335	1.351145	4.52633575	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.6	0.0036	NR	WAR20483.1	6604	g13297	i0	55.6	3.72537313432836	36	16	32.2	0	332	225	112	147	WAR20483.1 SRSF4-like protein, partial [Mya arenaria]	diamond	1248	46.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
31168319	31168319	PRJNA745553_S_NODE_6435_length_461_cov_1.317010_g6241_i0	PRJNA745553	6435	461	1.31701	6.0714161	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	133	9.52e-34	NR	XP_070206760.1	31220	g6241	i0	53.2	1.99783080260304	154	69	98.3	2	455	3	221	374	XP_070206760.1 cleavage stimulation factor subunit 1-like [Littorina saxatilis]	diamond	921	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
31727759	31727759	PRJNA745553_S_NODE_18457_length_287_cov_4.242991_g18262_i0	PRJNA745553	18457	287	4.242991	12.17738417	Bradybaena similaris	145626	Mollusca	Mollusca	65.5	6.61e-10	NR	BFZ17741.1	145626	g18262	i0	37.1	1.82926829268293	89	54	93	2	281	15	1213	1299	BFZ17741.1 hypothetical protein BsWGS_20780 [Bradybaena similaris]	diamond	525	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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