metadata: contig_metadata: 9 rows where bioproject = "PRJNA608660", tax_clade = "Opisthokonta" and tax

9 rows where bioproject = "PRJNA608660", tax_clade = "Opisthokonta" 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
3135578	3135578	PRJNA608660_P_NODE_31303_length_228_cov_1.162011_g30947_i0	PRJNA608660	31303	228	1.162011	2.64938508	Crassostrea virginica	6565	Mollusca	Mollusca	52.8	0.02	NTclustered	gi\|1242830407\|ref\|XM_022440510.1\|	6565	g30947	i0	96.774	0.271929824561404	31	1	14	0	93	123	743	713	PREDICTED: Crassostrea virginica U3 small nucleolar RNA-interacting protein 2-like (LOC111106001), transcript variant X2, mRNA	blastn	62	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
6963140	6963140	PRJNA608660_P_NODE_46906_length_167_cov_0.881356_g46549_i0	PRJNA608660	46906	167	0.881356	1.47186452	Bradybaena similaris	145626	Mollusca	Mollusca	62.1	2.33e-5	NTclustered	gi\|2912998575\|dbj\|AP039604.1\|	145626	g46549	i0	84.375	0.754491017964072	64	9	38	1	8	71	31164981	31165043	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence	blastn	126	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
8237598	8237598	PRJNA608660_P_NODE_11147_length_446_cov_4.793451_g10800_i0	PRJNA608660	11147	446	4.793451	21.37879146	Bradybaena similaris	145626	Mollusca	Mollusca	62.1	7.17e-5	NTclustered	gi\|2912993551\|dbj\|AP039598.1\|	145626	g10800	i0	94.872	28.8340807174888	39	2	10	0	219	257	29114687	29114649	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence	blastn	12860	62.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18436853	18436853	PRJNA608660_P_NODE_44355_length_173_cov_0.879032_g43998_i0	PRJNA608660	44355	173	0.879032	1.52072536	Physella acuta	109671	Mollusca	Mollusca	165	1.79e-36	NTclustered	gi\|2572453128\|ref\|XR_009385722.1\|	109671	g43998	i0	83.908	71.2832369942196	174	27	100	1	1	173	486	659	PREDICTED: Physella acuta small subunit ribosomal RNA (LOC131934416), rRNA	blastn	12332	165	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
26668341	26668341	PRJNA608660_P_NODE_40901_length_185_cov_1.183824_g40544_i0	PRJNA608660	40901	185	1.183824	2.1900744	Lymnaea stagnalis	6523	Mollusca	Mollusca	42.4	0.0233	NR	CAL1531800.1	6523	g40544	i0	46.3	0.664864864864865	41	19	61.6	1	62	175	137	177	CAL1531800.1 unnamed protein product, partial [Lymnaea stagnalis]	diamond	123	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
27029979	27029979	PRJNA608660_P_NODE_31582_length_226_cov_2.853107_g31226_i0	PRJNA608660	31582	226	2.853107	6.44802182	Metazoa	33208	Mollusca	Mollusca	123	3.54e-32	NR	XP_013070859.1	6526	g31226	i0	85.9	19.5663716814159	71	9	94.2	1	10	222	245	314	XP_013070859.1 casein kinase I isoform X2 [Biomphalaria glabrata]	diamond	4422	124	0.991935483870968	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27409526	27409526	PRJNA608660_P_NODE_32043_length_224_cov_1.245714_g31687_i0	PRJNA608660	32043	224	1.245714	2.79039936	Mollusca	6447	Mollusca	Mollusca	47.4	6.89e-4	NR	KAL5009466.1	13268	g31687	i0	62.5	4.16517857142857	40	14	53.6	1	102	221	795	833	KAL5009466.1 hypothetical protein ScPMuIL_011771 [Solemya velum]	diamond	933	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
30142933	30142933	PRJNA608660_P_NODE_41932_length_181_cov_1.272727_g41575_i0	PRJNA608660	41932	181	1.272727	2.30363587	Liolophura japonica	13599	Mollusca	Mollusca	41.6	0.0424	NR	XP_064610839.1	13599	g41575	i0	40	0.828729281767956	50	26	79.6	2	19	162	111	158	XP_064610839.1 uncharacterized protein LOC135475035 [Liolophura japonica]	diamond	150	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica
32230053	32230053	PRJNA608660_P_NODE_8498_length_512_cov_4.872570_g8163_i0	PRJNA608660	8498	512	4.87257	24.9475584	Pinctada imbricata	66713	Mollusca	Mollusca	49.7	0.00148	NR	KAK3099525.1	66713	g8163	i0	36.8	0.3984375	68	32	39.8	2	375	172	15	71	KAK3099525.1 hypothetical protein FSP39_005772 [Pinctada imbricata]	diamond	204	49.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata

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