metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB10320" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB10320" 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
2563391	2563391	PRJEB10320_P_NODE_15703_length_228_cov_1.647668_g15445_i0	PRJEB10320	15703	228	1.647668	3.75668304	Pomacea canaliculata	400727	Mollusca	Mollusca	71.3	5.61e-8	NTclustered	gi\|1397721537\|ref\|XM_025252141.1\|	400727	g15445	i0	92	0.43859649122807	50	4	22	0	28	77	669	718	PREDICTED: Pomacea canaliculata uncharacterized LOC112572451 (LOC112572451), transcript variant X1, mRNA	blastn	100	71.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
2563430	2563430	PRJEB10320_P_NODE_25643_length_161_cov_1.269841_g25385_i0	PRJEB10320	25643	161	1.269841	2.04444401	Gigantopelta aegis	1735272	Mollusca	Mollusca	126	7.77e-25	NTclustered	gi\|2034292936\|ref\|XM_041520969.1\|	1735272	g25385	i0	80.864	47.6149068322981	162	29	100	2	1	161	342	182	PREDICTED: Gigantopelta aegis tubulin beta-4B chain-like (LOC121389373), mRNA	blastn	7666	126	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
4810397	4810397	PRJEB10320_P_NODE_9204_length_327_cov_1.441781_g8946_i0	PRJEB10320	9204	327	1.441781	4.71462387	Haliotis	6452	Mollusca	Mollusca	62.1	5.11e-5	NTclustered	gi\|2245713663\|ref\|XM_046510094.2\|	6454	g8946	i0	100	5.22018348623853	33	0	10	0	283	315	805	837	PREDICTED: Haliotis rufescens zinc finger protein mnm-2-like (LOC124141900), transcript variant X2, mRNA	blastn	1707	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
5115914	5115914	PRJEB10320_P_NODE_21165_length_185_cov_1.260000_g20907_i0	PRJEB10320	21165	185	1.26	2.331	Octopus sinensis	2607531	Mollusca	Mollusca	62.1	2.62e-5	NTclustered	gi\|1914620967\|ref\|XM_036509864.1\|	2607531	g20907	i0	89.796	0.52972972972973	49	4	26	1	100	148	592	639	PREDICTED: Octopus sinensis glycine-rich protein DOT1-like (LOC118766475), transcript variant X2, mRNA	blastn	98	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
5115960	5115960	PRJEB10320_P_NODE_6925_length_392_cov_2.588235_g6670_i0	PRJEB10320	6925	392	2.588235	10.1458812	Lottia gigantea	225164	Mollusca	Mollusca	54.7	0.01	NTclustered	gi\|676443756\|ref\|XM_009051963.1\|	225164	g6670	i0	96.97	0.084183673469387807	33	0	8	1	113	145	1370	1401	Lottia gigantea hypothetical protein partial mRNA	blastn	33	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
6391728	6391728	PRJEB10320_P_NODE_6726_length_399_cov_1.203297_g6471_i0	PRJEB10320	6726	399	1.203297	4.80115503	Lottia gigantea	225164	Mollusca	Mollusca	60.2	2.28e-4	NTclustered	gi\|676458457\|ref\|XM_009056734.1\|	225164	g6471	i0	85	0.150375939849624	60	7	15	2	217	276	221	278	Lottia gigantea hypothetical protein partial mRNA	blastn	60	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
10216274	10216274	PRJEB10320_P_NODE_15209_length_233_cov_2.752525_g14951_i0	PRJEB10320	15209	233	2.752525	6.41338325	Ctena cf. galapagana NHMUK 20210086	2892552	Mollusca	Mollusca	134	7.240000000000001e-27	NTclustered	gi\|2129023951\|gb\|OL361786.1\|	2892552	g14951	i0	90.909	8.98712446351931	99	9	42	0	130	228	4050	4148	Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	2094	134	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Lucinida	Lucinidae	Ctena	Ctena cf. galapagana NHMUK 20210086
11491554	11491554	PRJEB10320_P_NODE_27830_length_153_cov_0.872881_g27572_i0	PRJEB10320	27830	153	0.872881	1.33550793	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.003	NTclustered	gi\|2912992646\|dbj\|AP039597.1\|	145626	g27572	i0	100	0.555555555555556	29	0	19	0	94	122	55242988	55243016	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence	blastn	85	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
15315805	15315805	PRJEB10320_P_NODE_6913_length_393_cov_1.751397_g6658_i0	PRJEB10320	6913	393	1.751397	6.88299021	Saccostrea echinata	191078	Mollusca	Mollusca	63.9	1.74e-5	NTclustered	gi\|2628553184\|ref\|XM_061338251.1\|	191078	g6658	i0	87.273	0.139949109414758	55	7	14	0	338	392	1205	1259	PREDICTED: Saccostrea echinata dynein assembly factor with WD repeat domains 1-like (LOC133202434), mRNA	blastn	55	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
16590366	16590366	PRJEB10320_P_NODE_10574_length_299_cov_1.859848_g10316_i0	PRJEB10320	10574	299	1.859848	5.56094552	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.028	NTclustered	gi\|2912983111\|dbj\|AP039588.1\|	145626	g10316	i0	100	0.0936454849498328	28	0	9	0	163	190	92497192	92497165	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
22965425	22965425	PRJEB10320_P_NODE_26079_length_159_cov_1.403226_g25821_i0	PRJEB10320	26079	159	1.403226	2.23112934	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	128	2.13e-25	NTclustered	gi\|1207937899\|ref\|XM_021502813.1\|	6573	g25821	i0	88.073	49.8930817610063	109	11	68	2	52	159	216	109	PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L27a-like (LOC110453724), mRNA	blastn	7933	128	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
22965457	22965457	PRJEB10320_P_NODE_7219_length_381_cov_5.864162_g6964_i0	PRJEB10320	7219	381	5.864162	22.34245722	Aplysia californica	6500	Mollusca	Mollusca	65.8	4.67e-6	NTclustered	gi\|1897937734\|ref\|XM_013087444.2\|	6500	g6964	i0	97.368	0.194225721784777	38	1	10	0	316	353	2242	2205	PREDICTED: Aplysia californica serine-rich adhesin for platelets (LOC101859357), mRNA	blastn	74	65.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
23934911	23934911	PRJEB10320_P_NODE_4779_length_486_cov_11.893570_g4537_i0	PRJEB10320	4779	486	11.89357	57.8027502	Metazoa	33208	Mollusca	Mollusca	281	5.55e-71	NTclustered	gi\|2442058763\|ref\|XM_045347307.2\|	6596	g4537	i0	79.592	80	392	80	81	0	17	408	590	199	PREDICTED: Mercenaria mercenaria uncharacterized LOC123556531 (LOC123556531), mRNA	blastn	38880	281	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria

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