metadata: contig_metadata: 28 rows where bioproject = "PRJNA340009" and tax

28 rows where bioproject = "PRJNA340009" 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
1666631	1666631	PRJNA340009_P_NODE_25502_length_243_cov_12.917526_g25195_i0	PRJNA340009	25502	243	12.917526	31.38958818	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2913001038\|dbj\|AP039608.1\|	145626	g25195	i0	100	0.11522633744856	28	0	12	0	101	128	26307746	26307719	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
1666817	1666817	PRJNA340009_P_NODE_42362_length_196_cov_3.469388_g42055_i0	PRJNA340009	42362	196	3.469388	6.80000048	Patella vulgata	6465	Mollusca	Mollusca	52.8	0.017	NTclustered	gi\|2506337845\|ref\|XM_050558418.2\|	6465	g42055	i0	100	0.285714285714286	28	0	14	0	102	129	475	448	PREDICTED: Patella vulgata cyclin-L1 (LOC126828569), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
1667098	1667098	PRJNA340009_P_NODE_68542_length_164_cov_1.591304_g68235_i0	PRJNA340009	68542	164	1.591304	2.60973856	Bradybaena similaris	145626	Mollusca	Mollusca	62.1	2.27e-5	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g68235	i0	92.857	20.4085365853659	42	3	26	0	98	139	37798284	37798325	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	3347	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
2345267	2345267	PRJNA340009_P_NODE_16842_length_291_cov_1.574380_g16535_i0	PRJNA340009	16842	291	1.57438	4.5814458	Gemmula	394107	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|211838488\|gb\|EU820736.1\|	571837	g16535	i0	100	1.09278350515464	29	0	10	0	76	104	296	268	Gemmula sp. 06 NP-2008 voucher 40940 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial	blastn	318	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neogastropoda	Turridae	Gemmula	Gemmula sp. 06 NP-2008
2943065	2943065	PRJNA340009_P_NODE_61003_length_168_cov_1.336134_g60696_i0	PRJNA340009	61003	168	1.336134	2.24470512	Aplysia californica	6500	Mollusca	Mollusca	119	1.37e-22	NTclustered	gi\|1897914720\|ref\|XM_013091443.2\|	6500	g60696	i0	89.362	46.9166666666667	94	10	56	0	1	94	1373	1466	PREDICTED: Aplysia californica tubulin alpha-1A chain (LOC101853836), mRNA	blastn	7882	119	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
2943209	2943209	PRJNA340009_P_NODE_74803_length_162_cov_0.902655_g74496_i0	PRJNA340009	74803	162	0.902655	1.4623011	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.001	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g74496	i0	96.97	0.203703703703704	33	1	20	0	114	146	22422496	22422464	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	33	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
6770254	6770254	PRJNA340009_P_NODE_906_length_968_cov_2.215452_g681_i0	PRJNA340009	906	968	2.215452	21.44557536	root	1	Root_unresolved	Root_unresolved	390	1.4699999999999995e-129	NR	XP_005099373.3	6500	g681	i0	70.9	45.551652892562	265	77	82.1	0	174	968	35	299	XP_005099373.3 propionyl-CoA carboxylase beta chain, mitochondrial [Aplysia californica]	diamond	44094	392	0.994897959183674	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
10595987	10595987	PRJNA340009_P_NODE_48789_length_185_cov_2.330882_g48482_i0	PRJNA340009	48789	185	2.330882	4.3121317	Cipangopaludina cathayensis	570432	Mollusca	Mollusca	73.1	1.21e-8	NTclustered	gi\|1379249280\|gb\|MH236185.1\|	570432	g48482	i0	74.86	1.6972972972973	179	35	95	8	1	175	1860	2032	Cipangopaludina cathayensis isolate Wuhu01 large subunit ribosomal RNA gene, partial sequence	blastn	314	73.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Viviparidae	Cipangopaludina	Cipangopaludina cathayensis
11871224	11871224	PRJNA340009_P_NODE_76350_length_161_cov_0.910714_g76043_i0	PRJNA340009	76350	161	0.910714	1.46624954	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.004	NTclustered	gi\|2912986657\|dbj\|AP039591.1\|	145626	g76043	i0	100	1.2360248447205	29	0	18	0	6	34	60444106	60444134	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence	blastn	199	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
13145827	13145827	PRJNA340009_P_NODE_42511_length_196_cov_1.918367_g42204_i0	PRJNA340009	42511	196	1.918367	3.75999932	Argopecten irradians	31199	Mollusca	Mollusca	132	2.12e-26	NTclustered	gi\|2835350600\|ref\|XM_069247595.1\|	31199	g42204	i0	96.25	41.5663265306122	80	3	41	0	105	184	1442	1363	PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA	blastn	8147	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
16969816	16969816	PRJNA340009_P_NODE_62814_length_167_cov_0.864407_g62507_i0	PRJNA340009	62814	167	0.864407	1.44355969	Mercenaria mercenaria	6596	Mollusca	Mollusca	193	7.909999999999999e-45	NTclustered	gi\|2442026498\|ref\|XM_053530395.1\|	6596	g62507	i0	94.444	4.36526946107784	126	5	75	1	40	165	983	860	PREDICTED: Mercenaria mercenaria uncharacterized LOC123538848 (LOC123538848), mRNA	blastn	729	193	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
18243504	18243504	PRJNA340009_P_NODE_16375_length_294_cov_6.457143_g16068_i0	PRJNA340009	16375	294	6.457143	18.98400042	Bradybaena similaris	145626	Mollusca	Mollusca	67.6	9.74e-7	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g16068	i0	100	30.7517006802721	36	0	17	0	10	45	62039081	62039046	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	9041	67.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18244079	18244079	PRJNA340009_P_NODE_69555_length_164_cov_0.886957_g69248_i0	PRJNA340009	69555	164	0.886957	1.45460948	Mytilus trossulus	6551	Mollusca	Mollusca	154	3.65e-33	NTclustered	gi\|2694137160\|ref\|XM_063544444.1\|	6551	g69248	i0	86.014	20.3048780487805	143	20	87	0	9	151	1047	905	PREDICTED: Mytilus trossulus ruvB-like 2 (LOC134685059), transcript variant X1, mRNA	blastn	3330	154	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
19518172	19518172	PRJNA340009_P_NODE_55956_length_174_cov_12.112000_g55649_i0	PRJNA340009	55956	174	12.112	21.07488	Patella vulgata	6465	Mollusca	Mollusca	143	8.439999999999998e-30	NTclustered	gi\|2506322976\|ref\|XM_050547475.2\|	6465	g55649	i0	84.247	30.764367816092	146	23	84	0	29	174	1223	1078	PREDICTED: Patella vulgata actin, cytoplasmic (LOC126819440), mRNA	blastn	5353	143	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
21471758	21471758	PRJNA340009_P_NODE_41237_length_199_cov_0.800000_g40930_i0	PRJNA340009	41237	199	0.8	1.592	Gastropoda	6448	Mollusca	Mollusca	300	5.5900000000000004e-77	NTclustered	gi\|81302008\|gb\|DQ256745.1\|	157727	g40930	i0	95.263	147.814070351759	190	8	95	1	11	199	2295	2484	Sarasinula plebeia 28S large subunit ribosomal RNA gene, partial sequence	blastn	29415	300	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Systellommatophora	Veronicellidae	Sarasinula	Sarasinula plebeia
22068669	22068669	PRJNA340009_P_NODE_42378_length_196_cov_3.292517_g42071_i0	PRJNA340009	42378	196	3.292517	6.45333332	Biomphalaria glabrata	6526	Mollusca	Mollusca	52.8	0.017	NTclustered	gi\|2502139577\|ref\|XM_056015784.1\|	6526	g42071	i0	100	0.285714285714286	28	0	14	0	131	158	843	870	PREDICTED: Biomphalaria glabrata protein unc-45 homolog B-like (LOC106064105), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
22068914	22068914	PRJNA340009_P_NODE_6218_length_438_cov_3.046272_g5911_i0	PRJNA340009	6218	438	3.046272	13.34267136	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.003	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g5911	i0	90.698	2.05707762557078	43	3	10	1	110	152	15285507	15285548	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	901	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
23344293	23344293	PRJNA340009_P_NODE_56219_length_174_cov_2.240000_g55912_i0	PRJNA340009	56219	174	2.24	3.8976	Lottia gigantea	225164	Mollusca	Mollusca	187	3.85e-43	NTclustered	gi\|676493537\|ref\|XM_009068023.1\|	225164	g55912	i0	88.387	86.1149425287356	155	18	89	0	13	167	205	51	Lottia gigantea hypothetical protein mRNA	blastn	14984	187	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
26870794	26870794	PRJNA340009_P_NODE_12121_length_335_cov_1.006993_g11814_i0	PRJNA340009	12121	335	1.006993	3.37342655	Opisthokonta	33154	Mollusca	Mollusca	67.8	1.81e-10	NR	CAL1535444.1	6523	g11814	i0	42.5	3.65373134328358	80	39	71.6	1	328	89	730	802	CAL1535444.1 unnamed protein product, partial [Lymnaea stagnalis]	diamond	1224	68.2	0.994134897360704	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
29316801	29316801	PRJNA340009_P_NODE_63389_length_166_cov_4.324786_g63082_i0	PRJNA340009	63389	166	4.324786	7.17914476	Pecten maximus	6579	Mollusca	Mollusca	49.3	3.87e-5	NR	XP_033725222.1	6579	g63082	i0	53.2	0.849397590361446	47	21	84.9	1	158	18	115	160	XP_033725222.1 uncharacterized protein LOC117315187 [Pecten maximus]	diamond	141	49.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
29916899	29916899	PRJNA340009_P_NODE_25611_length_243_cov_2.417526_g25304_i0	PRJNA340009	25611	243	2.417526	5.87458818	Mya arenaria	6604	Mollusca	Mollusca	73.2	4.38e-13	NR	XP_052776588.1	6604	g25304	i0	62.3	1.30864197530864	53	20	65.4	0	169	11	213	265	XP_052776588.1 UDP-sugar transporter sqv-7-like [Mya arenaria]	diamond	318	73.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
30359545	30359545	PRJNA340009_P_NODE_33352_length_217_cov_2.428571_g33045_i0	PRJNA340009	33352	217	2.428571	5.26999907	Haliotis rufescens	6454	Mollusca	Mollusca	44.7	0.00583	NR	XP_048248442.1	6454	g33045	i0	41.5	0.732718894009217	53	31	73.3	0	58	216	386	438	XP_048248442.1 WD repeat and FYVE domain-containing protein 3-like isoform X1 [Haliotis rufescens]	diamond	159	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
30502719	30502719	PRJNA340009_P_NODE_7853_length_398_cov_50.378223_g7546_i0	PRJNA340009	7853	398	50.378223	200.50532754	root	1	Root_unresolved	Root_unresolved	173	1.69e-52	NR	XP_033735668.1	6579	g7546	i0	85.7	14.035175879397	98	14	73.9	0	397	104	67	164	XP_033735668.1 peptidyl-prolyl cis-trans isomerase-like [Pecten maximus]	diamond	5586	173	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
30611691	30611691	PRJNA340009_P_NODE_55193_length_175_cov_8.626984_g54886_i0	PRJNA340009	55193	175	8.626984	15.097222	Mactra antiquata	2302425	Mollusca	Mollusca	57.8	1.91e-8	NR	KAL4235966.1	2302425	g54886	i0	55.1	1.68	49	22	84	0	175	29	70	118	KAL4235966.1 Transmembrane protein 18 [Mactra antiquata]	diamond	294	57.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
31054444	31054444	PRJNA340009_P_NODE_23435_length_252_cov_2.261084_g23128_i0	PRJNA340009	23435	252	2.261084	5.69793168	Candidula unifasciata	100452	Mollusca	Mollusca	47.4	8.74e-4	NR	CAG5133355.1	100452	g23128	i0	86.4	0.261904761904762	22	3	26.2	0	86	151	130	151	CAG5133355.1 unnamed protein product [Candidula unifasciata]	diamond	66	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
31514325	31514325	PRJNA340009_P_NODE_42756_length_195_cov_8.397260_g42449_i0	PRJNA340009	42756	195	8.39726	16.374657	Opisthokonta	33154	Mollusca	Mollusca	46.2	0.00124	NR	CAG2224203.1	6550	g42449	i0	48.4	8.07692307692308	31	16	47.7	0	13	105	706	736	CAG2224203.1 G-protein coupled receptor GRL101 [Mytilus edulis]	diamond	1575	46.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
31545847	31545847	PRJNA340009_P_NODE_22536_length_256_cov_7.154589_g22229_i0	PRJNA340009	22536	256	7.154589	18.31574784	Mytilus	6548	Mollusca	Mollusca	74.7	2.45e-13	NR	XP_052061000.1	6549	g22229	i0	66	6.4453125	50	17	58.6	0	50	199	2	51	XP_052061000.1 uncharacterized protein LOC127701221 isoform X7 [Mytilus californianus]	diamond	1650	75.1	0.994673768308922	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
31591878	31591878	PRJNA340009_P_NODE_23816_length_250_cov_6.149254_g23509_i0	PRJNA340009	23816	250	6.149254	15.373135	Magallana angulata	2784310	Mollusca	Mollusca	72.4	1.31e-12	NR	XP_052692741.1	2784310	g23509	i0	50.7	0.876	73	29	79.2	1	221	24	177	249	XP_052692741.1 uncharacterized protein LOC128171017 [Magallana angulata]	diamond	219	72.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana angulata

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