metadata: contig_metadata: 6 rows where bioproject = "PRJNA683902", tax_clade = "Opisthokonta" and tax

6 rows where bioproject = "PRJNA683902", 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
19792105	19792105	PRJNA683902_S_NODE_10756_length_424_cov_3.180879_g10314_i0	PRJNA683902	10756	424	3.180879	13.48692696	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.011	NTclustered	gi\|2913001038\|dbj\|AP039608.1\|	145626	g10314	i0	100	0.0683962264150943	29	0	7	0	201	229	9147465	9147493	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
22342493	22342493	PRJNA683902_S_NODE_16178_length_286_cov_1.538153_g15734_i0	PRJNA683902	16178	286	1.538153	4.39911758	Pomacea canaliculata	400727	Mollusca	Mollusca	138	2e-39	NR	XP_025086345.1	400727	g15734	i0	66.3	2.98951048951049	95	32	99.7	0	1	285	4	98	XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata]	diamond	855	138	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
22853104	22853104	PRJNA683902_S_NODE_39518_length_151_cov_1.745614_g39074_i0	PRJNA683902	39518	151	1.745614	2.63587714	Opisthokonta	33154	Mollusca	Mollusca	147	5.489999999999999e-31	NTclustered	gi\|1207933972\|ref\|XM_021500702.1\|	6573	g39074	i0	84.932	88.4304635761589	146	20	96	2	7	151	597	741	PREDICTED: Mizuhopecten yessoensis ATP synthase subunit beta, mitochondrial (LOC110452283), mRNA	blastn	13353	147	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
27410099	27410099	PRJNA683902_S_NODE_20603_length_233_cov_1.571429_g20159_i0	PRJNA683902	20603	233	1.571429	3.66142957	Mollusca	6447	Mollusca	Mollusca	109	1.32e-26	NR	KAL5014826.1	13268	g20159	i0	60	7.7381974248927	75	30	96.6	0	232	8	155	229	KAL5014826.1 hypothetical protein ScPMuIL_009096 [Solemya velum]	diamond	1803	109	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
27966518	27966518	PRJNA683902_S_NODE_31845_length_172_cov_1.444444_g31401_i0	PRJNA683902	31845	172	1.444444	2.48444368	Magallana gigas	29159	Mollusca	Mollusca	52.8	4.06e-6	NR	XP_034318849.2	29159	g31401	i0	41.8	1.74418604651163	55	32	95.9	0	1	165	190	244	XP_034318849.2 procathepsin L [Magallana gigas]	diamond	300	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
30082028	30082028	PRJNA683902_S_NODE_16332_length_283_cov_3.085366_g15888_i0	PRJNA683902	16332	283	3.085366	8.73158578	Dreissena polymorpha	45954	Mollusca	Mollusca	62	9.81e-9	NR	KAH3698300.1	45954	g15888	i0	55.1	0.731448763250883	69	23	73.1	1	23	229	378	438	KAH3698300.1 hypothetical protein DPMN_085819, partial [Dreissena polymorpha]	diamond	207	62	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha

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