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

9 rows where analysis = "diamond", bioproject = "PRJNA564013" 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
13306431	13306431	PRJNA564013_P_NODE_52011_length_549_cov_144.022541_g49252_i0	PRJNA564013	52011	549	144.022541	790.68375009	Metazoa	33208	Mollusca	Mollusca	217	3.0799999999999997e-69	NR	XP_034334635.1	29159	g49252	i0	68	8.9672131147541	147	47	80.3	0	481	41	1	147	XP_034334635.1 large ribosomal subunit protein uL15 [Magallana gigas]	diamond	4923	217	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
26604224	26604224	PRJNA564013_P_NODE_64781_length_499_cov_21.420091_g61979_i0	PRJNA564013	64781	499	21.420091	106.88625409	Mytilus galloprovincialis	29158	Mollusca	Mollusca	94	2e-21	NR	CAQ63457.1	29158	g61979	i0	61.8	1.34669338677355	76	29	45.7	0	366	139	1	76	CAQ63457.1 ribosomal protein [Mytilus galloprovincialis]	diamond	672	94	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus galloprovincialis
27995330	27995330	PRJNA564013_P_NODE_39045_length_620_cov_2.053667_g36346_i0	PRJNA564013	39045	620	2.053667	12.7327354	Ruditapes philippinarum	129788	Mollusca	Mollusca	108	1.26e-23	NR	XP_060602359.1	129788	g36346	i0	58.5	0.396774193548387	82	34	39.7	0	185	430	402	483	XP_060602359.1 lipoamide acyltransferase component of branched-chain alpha-keto acid dehydrogenase complex, mitochondrial-like [Ruditapes philippinarum]	diamond	246	108	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
29163689	29163689	PRJNA564013_P_NODE_123589_length_378_cov_12.637224_g120743_i0	PRJNA564013	123589	378	12.637224	47.76870672	Dreissena polymorpha	45954	Mollusca	Mollusca	58.9	3.82e-7	NR	XP_052261935.1	45954	g120743	i0	27	1	126	68	81.7	2	332	24	594	718	XP_052261935.1 uncharacterized protein LOC127865910 isoform X2 [Dreissena polymorpha]	diamond	378	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
29353037	29353037	PRJNA564013_P_NODE_40229_length_612_cov_6.880218_g37522_i0	PRJNA564013	40229	612	6.880218	42.10693416	Pecten maximus	6579	Mollusca	Mollusca	48.1	0.0136	NR	XP_033725242.1	6579	g37522	i0	34.7	0.352941176470588	72	45	35.3	1	33	248	1057	1126	XP_033725242.1 uncharacterized protein LOC117315207 [Pecten maximus]	diamond	216	48.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
29668286	29668286	PRJNA564013_P_NODE_172490_length_331_cov_10.340741_g169640_i0	PRJNA564013	172490	331	10.340741	34.22785271	Mya arenaria	6604	Mollusca	Mollusca	49.3	5.21e-4	NR	WAR17464.1	6604	g169640	i0	71.4	0.489425981873112	28	8	25.4	0	309	226	607	634	WAR17464.1 ZN347-like protein [Mya arenaria]	diamond	162	49.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
30332514	30332514	PRJNA564013_P_NODE_373732_length_173_cov_14.107143_g370880_i0	PRJNA564013	373732	173	14.107143	24.40535739	Pinctada imbricata	66713	Mollusca	Mollusca	53.5	2.25e-6	NR	KAK3107113.1	66713	g370880	i0	66.7	0.624277456647399	36	12	62.4	0	5	112	589	624	KAK3107113.1 hypothetical protein FSP39_007409 [Pinctada imbricata]	diamond	108	53.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pterioida	Pteriidae	Pinctada	Pinctada imbricata
30946269	30946269	PRJNA564013_P_NODE_319274_length_214_cov_1.647059_g316422_i0	PRJNA564013	319274	214	1.647059	3.52470626	Metazoa	33208	Mollusca	Mollusca	69.7	7.79e-12	NR	XP_025090905.1	400727	g316422	i0	51.9	3.79906542056075	54	25	75.7	1	3	164	788	840	XP_025090905.1 LOW QUALITY PROTEIN: EF-hand calcium-binding domain-containing protein 5-like [Pomacea canaliculata]	diamond	813	70.1	0.994293865905849	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
32622157	32622157	PRJNA564013_P_NODE_94680_length_419_cov_17.709497_g91847_i0	PRJNA564013	94680	419	17.709497	74.20279243	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	59.3	3.76e-7	NR	XP_059167302.1	109671	g91847	i0	36.8	2.61336515513127	76	48	54.4	0	251	24	212	287	XP_059167302.1 uncharacterized protein LOC131949420 [Physella acuta]	diamond	1095	59.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta

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