metadata: contig_metadata: 29 rows where bioproject = "PRJNA638138", tax_kingdom = "Metazoa" and tax

29 rows where bioproject = "PRJNA638138", tax_kingdom = "Metazoa" 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
1885725	1885725	PRJNA638138_P_NODE_6542_length_389_cov_4.310127_g6327_i0	PRJNA638138	6542	389	4.310127	16.76639403	Mytilus edulis	6550	Mollusca	Mollusca	222	2.68e-53	NTclustered	gi\|2912330725\|ref\|XM_071278780.1\|	6550	g6327	i0	81.887	13.6298200514139	265	46	68	2	5	268	879	616	PREDICTED: Mytilus edulis soma ferritin-like (LOC139491251), mRNA	blastn	5302	222	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
4437209	4437209	PRJNA638138_P_NODE_33584_length_242_cov_0.911243_g33369_i0	PRJNA638138	33584	242	0.911243	2.20520806	Atrina pectinata	49198	Mollusca	Mollusca	442	1.1099999999999995e-119	NTclustered	gi\|2337352613\|gb\|ON193523.1\|	49198	g33369	i0	99.587	2	242	1	100	0	1	242	7297	7056	Atrina pectinata mitochondrion, complete genome	blastn	484	442	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pinnidae	Atrina	Atrina pectinata
5712904	5712904	PRJNA638138_P_NODE_14025_length_290_cov_1.419355_g13810_i0	PRJNA638138	14025	290	1.419355	4.1161295	Pectinidae	6566	Mollusca	Mollusca	154	1.16e-46	NR	XP_021365005.1	6573	g13810	i0	85.9	4.32413793103448	85	12	87.9	0	8	262	18	102	XP_021365005.1 40S ribosomal protein S21-like [Mizuhopecten yessoensis]	diamond	1254	155	0.993548387096774	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
6988097	6988097	PRJNA638138_P_NODE_9306_length_340_cov_1.112360_g9091_i0	PRJNA638138	9306	340	1.11236	3.782024	Magallana gigas	29159	Mollusca	Mollusca	167	3.79e-51	NR	XP_011442817.1	29159	g9091	i0	89.4	0.997058823529412	113	10	98.8	2	340	5	4	115	XP_011442817.1 small ribosomal subunit protein eS25 [Magallana gigas]	diamond	339	167	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
8262535	8262535	PRJNA638138_P_NODE_17147_length_265_cov_1.604167_g16932_i0	PRJNA638138	17147	265	1.604167	4.25104255	Lottia gigantea	225164	Mollusca	Mollusca	132	3.02e-26	NTclustered	gi\|676469251\|ref\|XM_009060224.1\|	225164	g16932	i0	83.571	3.86037735849057	140	23	53	0	125	264	317	178	Lottia gigantea hypothetical protein mRNA	blastn	1023	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
8262655	8262655	PRJNA638138_P_NODE_27247_length_246_cov_0.890173_g27032_i0	PRJNA638138	27247	246	0.890173	2.18982558	Pinctada	50425	Mollusca	Mollusca	153	1.22e-44	NR	AAN85578.1	50426	g27032	i0	92.5	1.95121951219512	80	6	97.6	0	244	5	125	204	AAN85578.1 QM protein [Pinctada fucata]	diamond	480	153	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada fucata
12088706	12088706	PRJNA638138_P_NODE_17130_length_265_cov_2.005208_g16915_i0	PRJNA638138	17130	265	2.005208	5.3138012	Ostrea edulis	37623	Mollusca	Mollusca	145	5.05e-42	NR	XP_048773811.1	37623	g16915	i0	79.5	2.98867924528302	88	18	99.6	0	2	265	2	89	XP_048773811.1 60S ribosomal protein L9-like [Ostrea edulis]	diamond	792	145	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
13363465	13363465	PRJNA638138_P_NODE_15431_length_279_cov_1.121359_g15216_i0	PRJNA638138	15431	279	1.121359	3.12859161	Metazoa	33208	Mollusca	Mollusca	141	4.3e-39	NR	AFS50755.1	13268	g15216	i0	75.3	11	93	20	100	1	1	279	114	203	AFS50755.1 elongation factor 1 alpha, partial [Solemya velum]	diamond	3069	141	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
14638272	14638272	PRJNA638138_P_NODE_22552_length_249_cov_0.875000_g22337_i0	PRJNA638138	22552	249	0.875	2.17875	Saccostrea echinata	191078	Mollusca	Mollusca	292	1.2199999999999999e-74	NTclustered	gi\|2628410228\|ref\|XM_061316054.1\|	191078	g22337	i0	88.75	48.3734939759036	240	25	96	2	5	243	966	728	PREDICTED: Saccostrea echinata tropomyosin (LOC133181565), transcript variant X1, mRNA	blastn	12045	292	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
14638364	14638364	PRJNA638138_P_NODE_31212_length_244_cov_0.900585_g30997_i0	PRJNA638138	31212	244	0.900585	2.1974274	Atrina pectinata	49198	Mollusca	Mollusca	440	4.019999999999999e-119	NTclustered	gi\|435856621\|ref\|NC_020028.1\|	49198	g30997	i0	99.18	2	244	2	100	0	1	244	15416	15173	Atrina pectinata mitochondrion, complete genome	blastn	488	440	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pinnidae	Atrina	Atrina pectinata
18461390	18461390	PRJNA638138_P_NODE_17715_length_261_cov_1.515957_g17500_i0	PRJNA638138	17715	261	1.515957	3.95664777	Crassostrea virginica	6565	Mollusca	Mollusca	187	6.2499999999999984e-43	NTclustered	gi\|1242739027\|ref\|XM_022468134.1\|	6565	g17500	i0	81.498	17.3984674329502	227	42	87	0	33	259	322	96	PREDICTED: Crassostrea virginica 60S ribosomal protein L19-like (LOC111124874), mRNA	blastn	4541	187	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
18461391	18461391	PRJNA638138_P_NODE_17875_length_260_cov_1.470588_g17660_i0	PRJNA638138	17875	260	1.470588	3.8235288	Bivalvia	6544	Mollusca	Mollusca	102	1.54e-26	NR	OWF50552.1	6573	g17660	i0	100	1.17692307692308	50	0	57.7	0	7	156	31	80	OWF50552.1 60S ribosomal protein L39 [Mizuhopecten yessoensis]	diamond	306	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
19006693	19006693	PRJNA638138_P_NODE_12815_length_301_cov_1.346491_g12600_i0	PRJNA638138	12815	301	1.346491	4.05293791	Metazoa	33208	Mollusca	Mollusca	514	2.97e-141	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g12600	i0	99.644	93.3554817275748	281	1	93	0	1	281	214	494	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	28100	514	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
22286604	22286604	PRJNA638138_P_NODE_35898_length_241_cov_0.916667_g35683_i0	PRJNA638138	35898	241	0.916667	2.20916747	Atrina pectinata	49198	Mollusca	Mollusca	440	3.959999999999999e-119	NTclustered	gi\|2337352613\|gb\|ON193523.1\|	49198	g35683	i0	100	1.97510373443983	238	0	99	0	4	241	2336	2099	Atrina pectinata mitochondrion, complete genome	blastn	476	440	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pinnidae	Atrina	Atrina pectinata
22286631	22286631	PRJNA638138_P_NODE_5758_length_412_cov_1.303835_g5543_i0	PRJNA638138	5758	412	1.303835	5.3718002	Pinctada imbricata	66713	Mollusca	Mollusca	359	2.08e-94	NTclustered	gi\|321375245\|gb\|HQ629952.1\|	66713	g5543	i0	82.555	6.16747572815534	407	71	99	0	6	412	562	156	Pinctada martensi activated C kinase 1 receptor (RACK1) mRNA, complete cds	blastn	2541	359	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
23561859	23561859	PRJNA638138_P_NODE_11199_length_318_cov_0.853061_g10984_i0	PRJNA638138	11199	318	0.853061	2.71273398	Ruditapes philippinarum	129788	Mollusca	Mollusca	267	9.78e-67	NTclustered	gi\|2616655350\|ref\|XM_060745695.1\|	129788	g10984	i0	81.962	26.5786163522013	316	56	99	1	3	318	552	238	PREDICTED: Ruditapes philippinarum ubiquitin-ribosomal protein eS31 fusion protein (LOC132754941), transcript variant X2, mRNA	blastn	8452	267	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
23562180	23562180	PRJNA638138_P_NODE_8459_length_352_cov_1.103943_g8244_i0	PRJNA638138	8459	352	1.103943	3.88587936	Argopecten irradians	31199	Mollusca	Mollusca	187	1.92e-58	NR	XP_069129600.1	31199	g8244	i0	77.2	4.91761363636364	114	26	97.2	0	349	8	22	135	XP_069129600.1 large ribosomal subunit protein eL21-like [Argopecten irradians]	diamond	1731	187	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
27428908	27428908	PRJNA638138_P_NODE_33843_length_242_cov_0.911243_g33628_i0	PRJNA638138	33843	242	0.911243	2.20520806	Elysia marginata	1093978	Mollusca	Mollusca	54.3	2.7e-6	NR	GFS00228.1	1093978	g33628	i0	46.7	1.11570247933884	45	24	55.8	0	145	11	194	238	GFS00228.1 Pol polyprotein [Elysia marginata]	diamond	270	54.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
27725662	27725662	PRJNA638138_P_NODE_16004_length_274_cov_1.532338_g15789_i0	PRJNA638138	16004	274	1.532338	4.19860612	Bivalvia	6544	Mollusca	Mollusca	142	9.59e-41	NR	XP_033745912.1	6579	g15789	i0	84.8	2.59489051094891	79	12	86.5	0	2	238	98	176	XP_033745912.1 60S ribosomal protein L18a-like [Pecten maximus]	diamond	711	142	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
28375798	28375798	PRJNA638138_P_NODE_35926_length_241_cov_0.916667_g35711_i0	PRJNA638138	35926	241	0.916667	2.20916747	Pinctada imbricata	66713	Mollusca	Mollusca	52.4	1.43e-5	NR	KAK3093097.1	66713	g35711	i0	77.8	0.448132780082988	36	7	44.8	1	3	110	250	284	KAK3093097.1 hypothetical protein FSP39_011036 [Pinctada imbricata]	diamond	108	52.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
28735660	28735660	PRJNA638138_P_NODE_33507_length_242_cov_0.911243_g33292_i0	PRJNA638138	33507	242	0.911243	2.20520806	Ostreidae	6563	Mollusca	Mollusca	48.1	4.26e-4	NR	XP_011433036.3	29159	g33292	i0	38.3	2.02066115702479	81	44	99.2	2	1	240	47	122	XP_011433036.3 NADH-ubiquinone oxidoreductase 20 kDa subunit [Magallana gigas]	diamond	489	48.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
28817571	28817571	PRJNA638138_P_NODE_15748_length_276_cov_1.517241_g15533_i0	PRJNA638138	15748	276	1.517241	4.18758516	Ostrea edulis	37623	Mollusca	Mollusca	162	6.49e-49	NR	AFJ91753.1	37623	g15533	i0	84.6	1.97826086956522	91	14	98.9	0	3	275	37	127	AFJ91753.1 ribosomal protein L18, partial [Ostrea edulis]	diamond	546	162	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
29020111	29020111	PRJNA638138_P_NODE_15548_length_278_cov_1.126829_g15333_i0	PRJNA638138	15548	278	1.126829	3.13258462	Bivalvia	6544	Mollusca	Mollusca	102	3.9e-24	NR	OWF44472.1	6573	g15333	i0	50.5	2.94604316546763	91	45	98.2	0	274	2	61	151	OWF44472.1 Sphingomyelin synthase-related protein 1 [Mizuhopecten yessoensis]	diamond	819	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
29764971	29764971	PRJNA638138_P_NODE_22531_length_249_cov_0.875000_g22316_i0	PRJNA638138	22531	249	0.875	2.17875	Tegillarca granosa	220873	Mollusca	Mollusca	72	4.08e-14	NR	KAJ8320407.1	220873	g22316	i0	81	1.01204819277108	42	8	50.6	0	3	128	67	108	KAJ8320407.1 hypothetical protein KUTeg_001994 [Tegillarca granosa]	diamond	252	72	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
30504278	30504278	PRJNA638138_P_NODE_28773_length_245_cov_0.895349_g28558_i0	PRJNA638138	28773	245	0.895349	2.19360505	Bivalvia	6544	Mollusca	Mollusca	55.1	1.73e-6	NR	XP_053372623.1	6596	g28558	i0	49.1	2.33877551020408	57	28	69.8	1	74	244	753	808	XP_053372623.1 nodal modulator 2-like [Mercenaria mercenaria]	diamond	573	55.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
30693785	30693785	PRJNA638138_P_NODE_29913_length_244_cov_0.900585_g29698_i0	PRJNA638138	29913	244	0.900585	2.1974274	Lepetellida	2315723	Mollusca	Mollusca	103	1.5099999999999998e-23	NR	KAK6178302.1	87958	g29698	i0	61.7	1.99180327868852	81	31	99.6	0	2	244	571	651	KAK6178302.1 hypothetical protein SNE40_013103 [Patella caerulea]	diamond	486	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea
31756142	31756142	PRJNA638138_P_NODE_32337_length_243_cov_0.905882_g32122_i0	PRJNA638138	32337	243	0.905882	2.20129326	Bradybaena similaris	145626	Mollusca	Mollusca	68.6	3.12e-11	NR	BFY97169.1	145626	g32122	i0	42.7	4.03703703703704	82	46	100	1	1	243	41	122	BFY97169.1 hypothetical protein BsWGS_00209 [Bradybaena similaris]	diamond	981	68.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
31914325	31914325	PRJNA638138_P_NODE_30237_length_244_cov_0.900585_g30022_i0	PRJNA638138	30237	244	0.900585	2.1974274	Littorina saxatilis	31220	Mollusca	Mollusca	75.9	8.3e-14	NR	KAK7093131.1	31220	g30022	i0	47.6	2.76639344262295	84	36	93.4	1	8	235	292	375	KAK7093131.1 hypothetical protein V1264_008778 [Littorina saxatilis]	diamond	675	75.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
32338371	32338371	PRJNA638138_P_NODE_29639_length_245_cov_0.895349_g29424_i0	PRJNA638138	29639	245	0.895349	2.19360505	Opisthokonta	33154	Mollusca	Mollusca	52	2.06e-5	NR	XP_052065948.1	6549	g29424	i0	50	14.5224489795918	46	23	56.3	0	167	30	175	220	XP_052065948.1 actin nucleation-promoting factor WASL-like isoform X2 [Mytilus californianus]	diamond	3558	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus

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