metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA811237" 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
3359673	3359673	PRJNA811237_S_NODE_14063_length_214_cov_4.624242_g13823_i0	PRJNA811237	14063	214	4.624242	9.89587788	Haliotis rufescens	6454	Mollusca	Mollusca	141	3.91e-29	NTclustered	gi\|2245627539\|ref\|XM_046475395.2\|	6454	g13823	i0	90.566	44.6495327102804	106	10	50	0	1	106	1404	1509	PREDICTED: Haliotis rufescens tubulin alpha-1A chain-like (LOC124114697), mRNA	blastn	9555	141	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
3359705	3359705	PRJNA811237_S_NODE_2023_length_505_cov_3.019737_g1784_i0	PRJNA811237	2023	505	3.019737	15.24967185	Mytilus trossulus	6551	Mollusca	Mollusca	124	1.03e-23	NTclustered	gi\|2694132578\|ref\|XM_063542695.1\|	6551	g1784	i0	82.069	9.28910891089109	145	26	29	0	2	146	429	573	PREDICTED: Mytilus trossulus small ribosomal subunit protein uS9 (LOC134683410), mRNA	blastn	4691	124	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
3359710	3359710	PRJNA811237_S_NODE_21823_length_183_cov_1.343284_g21583_i0	PRJNA811237	21823	183	1.343284	2.45820972	Perna viridis	73031	Mollusca	Mollusca	257	3.08e-64	NTclustered	gi\|56967588\|gb\|AY850128.1\|	73031	g21583	i0	97.973	0.808743169398907	148	3	81	0	10	157	25	172	Perna viridis clone GM8 microsatellite sequence	blastn	148	257	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Perna	Perna viridis
3359739	3359739	PRJNA811237_S_NODE_29583_length_165_cov_3.284483_g29343_i0	PRJNA811237	29583	165	3.284483	5.41939695	Littorina saxatilis	31220	Mollusca	Mollusca	93.5	8.13e-15	NTclustered	gi\|2868620583\|ref\|XM_070341250.1\|	31220	g29343	i0	83.168	1.22424242424242	101	17	61	0	65	165	102	202	PREDICTED: Littorina saxatilis small ribosomal subunit protein uS3 (LOC138968656), transcript variant X2, mRNA	blastn	202	93.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
4637277	4637277	PRJNA811237_S_NODE_29824_length_165_cov_1.318966_g29584_i0	PRJNA811237	29824	165	1.318966	2.1762939	Biomphalaria glabrata	6526	Mollusca	Mollusca	60.2	8.25e-5	NTclustered	gi\|2502134919\|ref\|XM_056013775.1\|	6526	g29584	i0	100	1.11515151515152	32	0	19	0	82	113	233	264	PREDICTED: Biomphalaria glabrata guanine nucleotide-binding protein-like 3 homolog (LOC106077405), transcript variant X5, mRNA	blastn	184	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
4637295	4637295	PRJNA811237_S_NODE_34724_length_161_cov_2.142857_g34484_i0	PRJNA811237	34724	161	2.142857	3.44999977	Mya arenaria	6604	Mollusca	Mollusca	52.8	0.013	NTclustered	gi\|2427432187\|ref\|XM_052932339.1\|	6604	g34484	i0	100	0.173913043478261	28	0	17	0	134	161	331	304	PREDICTED: Mya arenaria tenascin-like (LOC128223094), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
7187054	7187054	PRJNA811237_S_NODE_21846_length_183_cov_1.141791_g21606_i0	PRJNA811237	21846	183	1.141791	2.08947753	Bradybaena similaris	145626	Mollusca	Mollusca	60.2	9.31e-5	NTclustered	gi\|2912993551\|dbj\|AP039598.1\|	145626	g21606	i0	90.909	1.22950819672131	44	4	24	0	71	114	63433612	63433655	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence	blastn	225	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
7187065	7187065	PRJNA811237_S_NODE_25846_length_171_cov_1.254098_g25606_i0	PRJNA811237	25846	171	1.254098	2.14450758	Ruditapes philippinarum	129788	Mollusca	Mollusca	106	1.08e-18	NTclustered	gi\|2616619385\|ref\|XM_060731797.1\|	129788	g25606	i0	86.598	8.12865497076023	97	11	56	2	74	169	442	347	PREDICTED: Ruditapes philippinarum dynein light chain Tctex-type 1 (LOC132743263), mRNA	blastn	1390	106	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
8461814	8461814	PRJNA811237_S_NODE_15107_length_209_cov_1.768750_g14867_i0	PRJNA811237	15107	209	1.76875	3.6966875	Saccostrea cuccullata	36930	Mollusca	Mollusca	176	1.04e-39	NTclustered	gi\|2669062950\|ref\|XM_062710474.1\|	36930	g14867	i0	82.524	93.0717703349282	206	30	97	6	1	203	1441	1643	PREDICTED: Saccostrea cucullata actin-like (LOC134228780), mRNA	blastn	19452	176	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
11012662	11012662	PRJNA811237_S_NODE_11809_length_228_cov_1.782123_g11569_i0	PRJNA811237	11809	228	1.782123	4.06324044	Mytilus californianus	6549	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2334608986\|ref\|XM_052206883.1\|	6549	g11569	i0	94.444	0.157894736842105	36	2	16	0	102	137	2645	2610	PREDICTED: Mytilus californianus RING finger protein 11-like (LOC127702581), mRNA	blastn	36	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
11012690	11012690	PRJNA811237_S_NODE_2009_length_507_cov_5.949782_g1770_i0	PRJNA811237	2009	507	5.949782	30.16539474	Aplysia californica	6500	Mollusca	Mollusca	289	3.47e-73	NTclustered	gi\|1897919841\|ref\|XM_013080763.2\|	6500	g1770	i0	78.889	84.5404339250493	450	77	87	17	63	503	62	502	PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA	blastn	42862	289	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
11012733	11012733	PRJNA811237_S_NODE_36369_length_155_cov_5.283019_g36129_i0	PRJNA811237	36369	155	5.283019	8.18867945	Ruditapes philippinarum	129788	Mollusca	Mollusca	159	7.3e-35	NTclustered	gi\|2616637443\|ref\|XM_060737498.1\|	129788	g36129	i0	85.526	10.5161290322581	152	22	98	0	4	155	928	777	PREDICTED: Ruditapes philippinarum tubulin alpha-1A chain (LOC132747962), mRNA	blastn	1630	159	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
11427407	11427407	PRJNA811237_S_NODE_2449_length_462_cov_1.864407_g2210_i0	PRJNA811237	2449	462	1.864407	8.61356034	Metazoa	33208	Mollusca	Mollusca	56.5	0.003	NTclustered	gi\|2694097628\|ref\|XM_063586004.1\|	6551	g2210	i0	100	0.826839826839827	30	0	6	0	214	243	512	483	PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA	blastn	382	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
13562420	13562420	PRJNA811237_S_NODE_34611_length_162_cov_0.884956_g34371_i0	PRJNA811237	34611	162	0.884956	1.43362872	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	147	6.009999999999999e-31	NTclustered	gi\|1207906213\|ref\|XM_021494508.1\|	6573	g34371	i0	83.23	1.99382716049383	161	26	99	1	1	160	245	85	PREDICTED: Mizuhopecten yessoensis NEDD8 (LOC110448328), mRNA	blastn	323	147	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
13562449	13562449	PRJNA811237_S_NODE_7991_length_265_cov_2.337963_g7751_i0	PRJNA811237	7991	265	2.337963	6.19560195	Littorina saxatilis	31220	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|2868609750\|ref\|XM_070343994.1\|	31220	g7751	i0	100	0.532075471698113	29	0	11	0	235	263	1418	1390	PREDICTED: Littorina saxatilis tubulin beta-4B chain-like (LOC138971279), mRNA	blastn	141	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
13562456	13562456	PRJNA811237_S_NODE_9491_length_248_cov_1.532663_g9251_i0	PRJNA811237	9491	248	1.532663	3.80100424	Aplysia californica	6500	Mollusca	Mollusca	106	1.7e-18	NTclustered	gi\|1897920673\|ref\|XM_005095879.3\|	6500	g9251	i0	93.056	4.13306451612903	72	5	29	0	177	248	824	753	PREDICTED: Aplysia californica ras-related protein Rab-7a (LOC101862261), transcript variant X1, mRNA	blastn	1025	106	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
15251634	15251634	PRJNA811237_S_NODE_29012_length_166_cov_0.871795_g28772_i0	PRJNA811237	29012	166	0.871795	1.4471797	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	2.99e-4	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g28772	i0	100	6.50602409638554	31	0	19	0	59	89	28635091	28635061	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	1080	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
17387172	17387172	PRJNA811237_S_NODE_34154_length_162_cov_0.902655_g33914_i0	PRJNA811237	34154	162	0.902655	1.4623011	Bradybaena similaris	145626	Mollusca	Mollusca	62.1	2.24e-5	NTclustered	gi\|2912998575\|dbj\|AP039604.1\|	145626	g33914	i0	100	0.41358024691358	33	0	20	0	118	150	38364658	38364626	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence	blastn	67	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
20349937	20349937	PRJNA811237_S_NODE_14036_length_215_cov_1.024096_g13796_i0	PRJNA811237	14036	215	1.024096	2.2018064	root	1	Root_unresolved	Root_unresolved	58.4	4.07e-4	NTclustered	gi\|2868623207\|ref\|XM_070342511.1\|	31220	g13796	i0	100	5.15348837209302	31	0	14	0	180	210	15	45	PREDICTED: Littorina saxatilis uncharacterized protein (LOC138969654), mRNA	blastn	1108	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis

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