metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJEB12366" and tax

18 rows where analysis = "blastn", bioproject = "PRJEB12366" 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
20744	20744	PRJEB12366_P_NODE_1421_length_723_cov_2.406977_g1275_i0	PRJEB12366	1421	723	2.406977	17.40244371	Patella vulgata	6465	Mollusca	Mollusca	403	1.7299999999999993e-107	NTclustered	gi\|2506330923\|ref\|XM_050549233.2\|	6465	g1275	i0	81.044	17.298755186722	517	88	71	9	149	660	658	147	PREDICTED: Patella vulgata ras-related protein Rab-1A (LOC126820989), mRNA	blastn	12507	403	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
20766	20766	PRJEB12366_P_NODE_18581_length_159_cov_1.290323_g18391_i0	PRJEB12366	18581	159	1.290323	2.05161357	Gigantopelta aegis	1735272	Mollusca	Mollusca	126	7.65e-25	NTclustered	gi\|2034328624\|ref\|XM_041506353.1\|	1735272	g18391	i0	83.212	21.9748427672956	137	23	86	0	23	159	2245	2109	PREDICTED: Gigantopelta aegis CCR4-NOT transcription complex subunit 3-like (LOC121378270), transcript variant X2, mRNA	blastn	3494	126	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
3846943	3846943	PRJEB12366_P_NODE_10284_length_235_cov_2.200000_g10094_i0	PRJEB12366	10284	235	2.2	5.17	Mytilus trossulus	6551	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2694125536\|ref\|XM_063540198.1\|	6551	g10094	i0	100	0.25531914893617	30	0	13	0	38	67	362	391	PREDICTED: Mytilus trossulus pre-rRNA 2'-O-ribose RNA methyltransferase FTSJ3-like (LOC134680905), transcript variant X1, mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
5123193	5123193	PRJEB12366_P_NODE_8125_length_274_cov_2.008368_g7935_i0	PRJEB12366	8125	274	2.008368	5.50292832	Lottia gigantea	225164	Mollusca	Mollusca	185	2.3799999999999993e-42	NTclustered	gi\|676437355\|ref\|XM_009049929.1\|	225164	g7935	i0	81.818	4.15693430656934	220	40	80	0	55	274	1270	1489	Lottia gigantea hypothetical protein mRNA	blastn	1139	185	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
6398866	6398866	PRJEB12366_P_NODE_14206_length_190_cov_2.058065_g14016_i0	PRJEB12366	14206	190	2.058065	3.9103235	Ostrea edulis	37623	Mollusca	Mollusca	141	3.39e-29	NTclustered	gi\|2507433913\|ref\|XM_056148367.1\|	37623	g14016	i0	81.871	16.3421052631579	171	27	89	3	22	190	2643	2475	PREDICTED: Ostrea edulis peripheral plasma membrane protein CASK-like (LOC125658791), transcript variant X10, mRNA	blastn	3105	141	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
6398870	6398870	PRJEB12366_P_NODE_14786_length_186_cov_1.059603_g14596_i0	PRJEB12366	14786	186	1.059603	1.97086158	Dreissena polymorpha	45954	Mollusca	Mollusca	67.6	5.68e-7	NTclustered	gi\|2364417029\|ref\|XM_052415233.1\|	45954	g14596	i0	97.436	20.9838709677419	39	1	21	0	19	57	513	551	PREDICTED: Dreissena polymorpha myoneurin-like (LOC127871938), transcript variant X26, mRNA	blastn	3903	67.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
8947737	8947737	PRJEB12366_P_NODE_16788_length_170_cov_2.066667_g16598_i0	PRJEB12366	16788	170	2.066667	3.5133339	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.004	NTclustered	gi\|2912986657\|dbj\|AP039591.1\|	145626	g16598	i0	96.875	0.188235294117647	32	1	19	0	32	63	5845533	5845564	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence	blastn	32	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11498762	11498762	PRJEB12366_P_NODE_12670_length_205_cov_1.829412_g12480_i0	PRJEB12366	12670	205	1.829412	3.7502946	Pomacea canaliculata	400727	Mollusca	Mollusca	54.7	0.005	NTclustered	gi\|1397743743\|ref\|XM_025223003.1\|	400727	g12480	i0	96.97	0.321951219512195	33	0	16	1	48	79	263	231	PREDICTED: Pomacea canaliculata collagen alpha-5(IV) chain-like (LOC112554929), mRNA	blastn	66	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
11498770	11498770	PRJEB12366_P_NODE_14850_length_185_cov_1.786667_g14660_i0	PRJEB12366	14850	185	1.786667	3.30533395	Saccostrea cuccullata	36930	Mollusca	Mollusca	52.8	0.016	NTclustered	gi\|2669156586\|ref\|XM_062755599.1\|	36930	g14660	i0	100	0.151351351351351	28	0	15	0	132	159	1420	1393	PREDICTED: Saccostrea cucullata MFS-type transporter SLC18B1-like (LOC134273402), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
12464775	12464775	PRJEB12366_P_NODE_12850_length_203_cov_1.791667_g12660_i0	PRJEB12366	12850	203	1.791667	3.63708401	Haliotis	6452	Mollusca	Mollusca	54.7	0.005	NTclustered	gi\|2194145353\|ref\|XM_046728706.1\|	36100	g12660	i0	96.875	0.45320197044335	32	1	16	0	19	50	992	961	PREDICTED: Haliotis rubra putative ferric-chelate reductase 1 (LOC124291655), mRNA	blastn	92	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
12774403	12774403	PRJEB12366_P_NODE_3991_length_423_cov_2.654639_g3801_i0	PRJEB12366	3991	423	2.654639	11.22912297	Ostrea edulis	37623	Mollusca	Mollusca	270	1.03e-67	NTclustered	gi\|2507408796\|ref\|XM_048872020.2\|	37623	g3801	i0	78.282	3.23640661938534	419	91	99	0	3	421	815	397	PREDICTED: Ostrea edulis ruvB-like 2 (LOC125645964), mRNA	blastn	1369	270	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
14048928	14048928	PRJEB12366_P_NODE_8832_length_260_cov_2.115556_g8642_i0	PRJEB12366	8832	260	2.115556	5.5004456	Lottia gigantea	225164	Mollusca	Mollusca	231	2.84e-56	NTclustered	gi\|676474662\|ref\|XM_009061969.1\|	225164	g8642	i0	82.692	99.2730769230769	260	45	100	0	1	260	1310	1051	Lottia gigantea hypothetical protein mRNA	blastn	25811	231	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
16597557	16597557	PRJEB12366_P_NODE_16614_length_172_cov_1.153285_g16424_i0	PRJEB12366	16614	172	1.153285	1.9836502	Patella vulgata	6465	Mollusca	Mollusca	158	2.9699999999999993e-34	NTclustered	gi\|2506312222\|ref\|XM_050536427.2\|	6465	g16424	i0	84.375	9.45348837209302	160	25	93	0	4	163	8023	8182	PREDICTED: Patella vulgata dynein axonemal heavy chain 5 (LOC126810974), mRNA	blastn	1626	158	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
17563501	17563501	PRJEB12366_P_NODE_7594_length_286_cov_1.553785_g7404_i0	PRJEB12366	7594	286	1.553785	4.4438251	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	56.5	0.002	NTclustered	gi\|2427250251\|ref\|XM_014920720.2\|	37653	g7404	i0	100	7.78671328671329	30	0	10	0	251	280	3182	3153	PREDICTED: Octopus bimaculoides serine-rich adhesin for platelets (LOC106873380), transcript variant X1, mRNA	blastn	2227	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
17872377	17872377	PRJEB12366_P_NODE_18935_length_157_cov_1.614754_g18745_i0	PRJEB12366	18935	157	1.614754	2.53516378	Lottia gigantea	225164	Mollusca	Mollusca	113	5.860000000000001e-21	NTclustered	gi\|676493117\|ref\|XM_009067888.1\|	225164	g18745	i0	82.812	0.815286624203822	128	20	81	2	17	143	570	696	Lottia gigantea hypothetical protein mRNA	blastn	128	113	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
20421419	20421419	PRJEB12366_P_NODE_19717_length_153_cov_1.355932_g19527_i0	PRJEB12366	19717	153	1.355932	2.07457596	Mya arenaria	6604	Mollusca	Mollusca	132	1.5600000000000002e-26	NTclustered	gi\|2427472095\|ref\|XM_052941856.1\|	6604	g19527	i0	84.286	25.8104575163399	140	16	90	6	13	149	185	321	PREDICTED: Mya arenaria ADP-ribosylation factor-like protein 1 (LOC128229937), mRNA	blastn	3949	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
24246618	24246618	PRJEB12366_S_NODE_3060_length_164_cov_1.240310_g3052_i0	PRJEB12366	3060	164	1.24031	2.0341084	Argopecten irradians	31199	Mollusca	Mollusca	132	1.71e-26	NTclustered	gi\|2835350600\|ref\|XM_069247595.1\|	31199	g3052	i0	96.25	49.030487804878	80	3	49	0	1	80	1363	1442	PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA	blastn	8041	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
25211716	25211716	PRJEB12366_P_NODE_16800_length_170_cov_1.777778_g16610_i0	PRJEB12366	16800	170	1.777778	3.0222226	Octopus	6643	Mollusca	Mollusca	141	2.95e-29	NTclustered	gi\|2427242809\|ref\|XM_052967902.1\|	37653	g16610	i0	87.2	68.2058823529412	125	14	73	2	39	162	460	337	PREDICTED: Octopus bimaculoides calcium/calmodulin-dependent protein kinase type II delta chain (LOC106874089), transcript variant X2, mRNA	blastn	11595	141	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides

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