metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA168635" 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
1639282	1639282	PRJNA168635_P_NODE_22662_length_174_cov_24.952000_g22246_i0	PRJNA168635	22662	174	24.952	43.41648	Mercenaria mercenaria	6596	Mollusca	Mollusca	200	4.939999999999998e-47	NTclustered	gi\|2442022969\|ref\|XR_006683622.2\|	6596	g22246	i0	87.861	115.442528735632	173	18	98	3	3	173	17	188	PREDICTED: Mercenaria mercenaria U2 spliceosomal RNA (LOC123537683), ncRNA	blastn	20087	200	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
6156954	6156954	PRJNA168635_P_NODE_18385_length_188_cov_1.474820_g17969_i0	PRJNA168635	18385	188	1.47482	2.7726616	Metazoa	33208	Mollusca	Mollusca	106	1.22e-18	NTclustered	gi\|1517521404\|gb\|MK190973.1\|	13016	g17969	i0	92	39.7712765957447	75	6	40	0	2	76	26	100	Codakia orbicularis voucher SDSM:115656 large subunit ribosomal RNA gene, partial sequence	blastn	7477	106	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Lucinida	Lucinidae	Codakia	Codakia orbicularis
6157115	6157115	PRJNA168635_P_NODE_6505_length_331_cov_5878.375887_g6094_i0	PRJNA168635	6505	331	5878.375887	19457.42418597	root	1	Root_unresolved	Root_unresolved	595	1.1499999999999998e-165	NTclustered	gi\|2913002568\|dbj\|AP039611.1\|	145626	g6094	i0	99.094	252.012084592145	331	3	100	0	1	331	1724850	1724520	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence	blastn	83416	595	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
9292388	9292388	PRJNA168635_P_NODE_1308_length_687_cov_27.338558_g991_i0	PRJNA168635	1308	687	27.338558	187.81589346	Leptochiton asellus	211853	Mollusca	Mollusca	174	1.4e-38	NTclustered	gi\|34369208\|gb\|AY145414.1\|	211853	g991	i0	84.239	11.9344978165939	184	23	26	6	505	686	2717	2538	Leptochiton asellus 28S ribosomal RNA gene, partial sequence	blastn	8199	174	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Lepidopleurida	Lepidopleuridae	Leptochiton	Leptochiton asellus
9292662	9292662	PRJNA168635_P_NODE_3008_length_480_cov_6.828306_g2616_i0	PRJNA168635	3008	480	6.828306	32.7758688	Donax veruinus	457701	Mollusca	Mollusca	195	7.34e-45	NTclustered	gi\|1104599615\|gb\|KX713380.1\|	457701	g2616	i0	83.333	33.6	222	26	45	10	184	397	1080	862	Donax veruinus voucher BivAToL-68 28S ribosomal RNA gene, complete sequence	blastn	16128	195	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Cardiida	Donacidae	Donax	Donax veruinus
10568476	10568476	PRJNA168635_P_NODE_18509_length_187_cov_6.028986_g18093_i0	PRJNA168635	18509	187	6.028986	11.27420382	Pomacea canaliculata	400727	Mollusca	Mollusca	147	7.139999999999999e-31	NTclustered	gi\|1397687357\|ref\|XR_003099045.1\|	400727	g18093	i0	81.522	67.3208556149733	184	29	97	5	1	182	4	184	PREDICTED: Pomacea canaliculata U2 spliceosomal RNA (LOC112563412), ncRNA	blastn	12589	147	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
14393623	14393623	PRJNA168635_P_NODE_24092_length_171_cov_2.196721_g23676_i0	PRJNA168635	24092	171	2.196721	3.75639291	Mercenaria mercenaria	6596	Mollusca	Mollusca	67.6	5.11e-7	NTclustered	gi\|2441981947\|ref\|XM_045313915.2\|	6596	g23676	i0	90.385	0.543859649122807	52	3	29	1	3	52	230	179	PREDICTED: Mercenaria mercenaria 60S ribosomal protein L27-like (LOC123532469), mRNA	blastn	93	67.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
16356574	16356574	PRJNA168635_P_NODE_1453_length_656_cov_7.296540_g1118_i0	PRJNA168635	1453	656	7.29654	47.8653024	Diplommatina	563695	Mollusca	Mollusca	126	3.79e-24	NTclustered	gi\|318065603\|gb\|HM753386.1\|	928744	g1118	i0	95	12.2073170731707	80	4	12	0	4	83	673	594	Diplommatina acme isolate 4046 28S ribosomal RNA gene, partial sequence	blastn	8008	126	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Diplommatinidae	Diplommatina	Diplommatina acme
18216294	18216294	PRJNA168635_P_NODE_29435_length_164_cov_3.417391_g29019_i0	PRJNA168635	29435	164	3.417391	5.60452124	Patella vulgata	6465	Mollusca	Mollusca	95.3	2.24e-15	NTclustered	gi\|2506326614\|ref\|XR_007679844.2\|	6465	g29019	i0	82.456	50.5975609756098	114	14	68	6	53	164	140	31	PREDICTED: Patella vulgata U2 spliceosomal RNA (LOC126819892), ncRNA	blastn	8298	95.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
18905825	18905825	PRJNA168635_P_NODE_7535_length_307_cov_6530.891473_g7123_i0	PRJNA168635	7535	307	6530.891473	20049.83682211	root	1	Root_unresolved	Root_unresolved	568	2.3e-157	NTclustered	gi\|2913002568\|dbj\|AP039611.1\|	145626	g7123	i0	100	251.276872964169	307	0	100	0	1	307	1724547	1724853	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence	blastn	77142	568	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19490419	19490419	PRJNA168635_P_NODE_21296_length_178_cov_2.279070_g20880_i0	PRJNA168635	21296	178	2.27907	4.0567446	Bradybaena similaris	145626	Mollusca	Mollusca	191	3.06e-44	NTclustered	gi\|2913002590\|dbj\|AP039619.1\|	145626	g20880	i0	86.441	270.685393258427	177	20	98	4	5	178	252040	251865	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored10, sequence	blastn	48182	191	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
24006362	24006362	PRJNA168635_P_NODE_8439_length_290_cov_20.419087_g8024_i0	PRJNA168635	8439	290	20.419087	59.2153523	Lucinidae	42655	Mollusca	Mollusca	222	1.9299999999999999e-53	NTclustered	gi\|2127706950\|gb\|OL339379.1\|	244476	g8024	i0	87	71.5758620689655	200	22	68	4	4	201	3021	3218	Divaricella irpex voucher UF 432892 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	20757	222	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Lucinida	Lucinidae	Divaricella	Divaricella irpex
24590580	24590580	PRJNA168635_P_NODE_14640_length_210_cov_6.490683_g14224_i0	PRJNA168635	14640	210	6.490683	13.6304343	Aplysia californica	6500	Mollusca	Mollusca	52.8	0.018	NTclustered	gi\|1897936549\|ref\|XM_005106389.3\|	6500	g14224	i0	100	0.133333333333333	28	0	13	0	1	28	3646	3673	PREDICTED: Aplysia californica RRP12-like protein (LOC101856684), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
24590986	24590986	PRJNA168635_P_NODE_5980_length_346_cov_6.101010_g5572_i0	PRJNA168635	5980	346	6.10101	21.1094946	Ctena sp. NHMUK 20210085	2896859	Mollusca	Mollusca	213	1.42e-50	NTclustered	gi\|2152694531\|gb\|OL584018.1\|	2896859	g5572	i0	84.141	47.1531791907514	227	28	64	8	2	224	2974	3196	Ctena sp. NHMUK 20210085 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	16315	213	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Lucinida	Lucinidae	Ctena	Ctena sp. NHMUK 20210085

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