metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
12361699	12361699	PRJNA904835_P_NODE_25170_length_397_cov_0.947531_g24914_i0	PRJNA904835	25170	397	0.947531	3.76169807	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.4	3.29e-21	NR	VDI55118.1	29158	g24914	i0	41.8	3.03022670025189	134	73	98.2	3	3	392	580	712	VDI55118.1 helicase MOV-10 [Mytilus galloprovincialis]	diamond	1203	99.8	0.995991983967936	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
27751091	27751091	PRJNA904835_P_NODE_31964_length_345_cov_1.415441_g31708_i0	PRJNA904835	31964	345	1.415441	4.88327145	Haliotis cracherodii	6455	Mollusca	Mollusca	127	1.04e-31	NR	XP_071118545.1	6455	g31708	i0	54.5	1.98260869565217	112	49	96.5	2	11	343	178	288	XP_071118545.1 actin, non-muscle 6.2-like [Haliotis cracherodii]	diamond	684	127	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis cracherodii
28161517	28161517	PRJNA904835_P_NODE_40965_length_295_cov_1.022523_g40709_i0	PRJNA904835	40965	295	1.022523	3.01644285	Pinctada imbricata	66713	Mollusca	Mollusca	45.8	0.00581	NR	KAK3084398.1	66713	g40709	i0	45.6	0.976271186440678	57	21	58	1	4	174	417	463	KAK3084398.1 hypothetical protein FSP39_012906 [Pinctada imbricata]	diamond	288	45.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
28319119	28319119	PRJNA904835_P_NODE_13906_length_560_cov_1.301848_g13654_i0	PRJNA904835	13906	560	1.301848	7.2903488	Pomacea canaliculata	400727	Mollusca	Mollusca	58.9	1.75e-6	NR	XP_025099691.1	400727	g13654	i0	35.1	1.40357142857143	94	54	46.6	2	558	298	294	387	XP_025099691.1 zonadhesin-like [Pomacea canaliculata]	diamond	786	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
28887407	28887407	PRJNA904835_P_NODE_51408_length_250_cov_0.870056_g51152_i0	PRJNA904835	51408	250	0.870056	2.17514	Tegillarca granosa	220873	Mollusca	Mollusca	49.3	2.04e-4	NR	KAJ8309725.1	220873	g51152	i0	36.8	0.912	76	45	88.8	2	228	7	482	556	KAJ8309725.1 hypothetical protein KUTeg_011590 [Tegillarca granosa]	diamond	228	49.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
29140344	29140344	PRJNA904835_P_NODE_55549_length_245_cov_0.895349_g55293_i0	PRJNA904835	55549	245	0.895349	2.19360505	Bradybaena similaris	145626	Mollusca	Mollusca	47.4	9.19e-4	NR	BFZ03507.1	145626	g55293	i0	24.3	2.55918367346939	70	53	85.7	0	5	214	723	792	BFZ03507.1 hypothetical protein BsWGS_06545 [Bradybaena similaris]	diamond	627	47.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
30909079	30909079	PRJNA904835_P_NODE_22414_length_423_cov_1.320000_g22159_i0	PRJNA904835	22414	423	1.32	5.5836	Argopecten irradians	31199	Mollusca	Mollusca	104	8.079999999999999e-23	NR	XP_069103063.1	31199	g22159	i0	47.3	0.780141843971631	110	58	78	0	354	25	462	571	XP_069103063.1 uncharacterized protein [Argopecten irradians]	diamond	330	104	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
30948327	30948327	PRJNA904835_P_NODE_27214_length_379_cov_1.506536_g26958_i0	PRJNA904835	27214	379	1.506536	5.70977144	Metazoa	33208	Mollusca	Mollusca	88.6	2.7e-18	NR	XP_046378985.1	6454	g26958	i0	46.2	3.33245382585752	91	48	72	1	276	4	1	90	XP_046378985.1 E3 ubiquitin-protein ligase CHIP-like [Haliotis rufescens]	diamond	1263	88.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
31478144	31478144	PRJNA904835_P_NODE_50676_length_251_cov_0.865169_g50420_i0	PRJNA904835	50676	251	0.865169	2.17157419	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	159	1.08e-46	NR	XP_021359635.1	6573	g50420	i0	91.8	1.75697211155378	73	6	87.3	0	251	33	197	269	XP_021359635.1 cytochrome b-c1 complex subunit Rieske, mitochondrial-like [Mizuhopecten yessoensis]	diamond	441	159	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis

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