metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1188114" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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
7973311	7973311	PRJNA1188114_P_NODE_4927_length_206_cov_1.617834_g4875_i0	PRJNA1188114	4927	206	1.617834	3.33273804	Metazoa	33208	Mollusca	Mollusca	120	1.04e-30	NR	NP_001295770.1	29159	g4875	i0	79.4	13.8640776699029	68	14	99	0	205	2	229	296	NP_001295770.1 glutamine synthetase 2 cytoplasmic-like [Magallana gigas]	diamond	2856	120	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
14349073	14349073	PRJNA1188114_P_NODE_4892_length_207_cov_0.968354_g4840_i0	PRJNA1188114	4892	207	0.968354	2.00449278	Metazoa	33208	Mollusca	Mollusca	121	1.4099999999999998e-31	NR	XP_046356896.2	6454	g4840	i0	82.6	5	69	12	100	0	207	1	161	229	XP_046356896.2 very-long-chain enoyl-CoA reductase-like [Haliotis rufescens]	diamond	1035	121	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
21996741	21996741	PRJNA1188114_P_NODE_4958_length_205_cov_4.500000_g4906_i0	PRJNA1188114	4958	205	4.5	9.225	Metazoa	33208	Mollusca	Mollusca	97.1	2.65e-24	NR	CAL1533184.1	6523	g4906	i0	79.7	1.58048780487805	59	12	86.3	0	28	204	17	75	CAL1533184.1 unnamed protein product, partial [Lymnaea stagnalis]	diamond	324	97.8	0.992842535787321	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
26945683	26945683	PRJNA1188114_P_NODE_14302_length_165_cov_1.318966_g14250_i0	PRJNA1188114	14302	165	1.318966	2.1762939	Biomphalaria glabrata	6526	Mollusca	Mollusca	82.4	1.29e-16	NR	KAK6986869.1	6526	g14250	i0	72.7	9	55	15	100	0	165	1	124	178	KAK6986869.1 T-complex protein 1 subunit beta, partial [Biomphalaria glabrata]	diamond	1485	82.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27281148	27281148	PRJNA1188114_P_NODE_4723_length_210_cov_1.267081_g4671_i0	PRJNA1188114	4723	210	1.267081	2.6608701	Metazoa	33208	Mollusca	Mollusca	48.1	2.86e-4	NR	XP_059166324.1	109671	g4671	i0	63	4.35714285714286	27	10	38.6	0	83	3	281	307	XP_059166324.1 sulfotransferase 1E1-like isoform X4 [Physella acuta]	diamond	915	48.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
29566924	29566924	PRJNA1188114_P_NODE_12550_length_167_cov_0.864407_g12498_i0	PRJNA1188114	12550	167	0.864407	1.44355969	Pecten maximus	6579	Mollusca	Mollusca	67.4	1.78e-11	NR	XP_033757081.1	6579	g12498	i0	63.6	2.96407185628743	55	19	98.8	1	166	2	103	156	XP_033757081.1 pyridoxal phosphate homeostasis protein-like [Pecten maximus]	diamond	495	67.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
29756340	29756340	PRJNA1188114_P_NODE_9511_length_177_cov_1.585938_g9459_i0	PRJNA1188114	9511	177	1.585938	2.80711026	Mytilus coruscus	42192	Mollusca	Mollusca	99.4	2.51e-23	NR	CAC5403910.1	42192	g9459	i0	77.6	3.93220338983051	58	12	98.3	1	176	3	129	185	CAC5403910.1 BRX1 [Mytilus coruscus]	diamond	696	99.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus coruscus
31924641	31924641	PRJNA1188114_P_NODE_6577_length_189_cov_1.450000_g6525_i0	PRJNA1188114	6577	189	1.45	2.7405	Magallana	147004	Mollusca	Mollusca	53.9	1.94e-6	NR	XP_019920313.3	29159	g6525	i0	43.1	2.82539682539683	58	32	90.5	1	187	17	52	109	XP_019920313.3 peroxidase-like protein [Magallana gigas]	diamond	534	54.3	0.992633517495396	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
32840824	32840824	PRJNA1188114_P_NODE_8640_length_181_cov_1.469697_g8588_i0	PRJNA1188114	8640	181	1.469697	2.66015157	Metazoa	33208	Mollusca	Mollusca	77	1.36e-14	NR	XP_053376443.1	6596	g8588	i0	74	29.4033149171271	50	13	82.9	0	1	150	1453	1502	XP_053376443.1 helicase domino-like [Mercenaria mercenaria]	diamond	5322	77.4	0.994832041343669	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
32853402	32853402	PRJNA1188114_P_NODE_16080_length_164_cov_0.886957_g16028_i0	PRJNA1188114	16080	164	0.886957	1.45460948	Gigantopelta aegis	1735272	Mollusca	Mollusca	60.1	9.53e-9	NR	XP_041366930.1	1735272	g16028	i0	62.5	1.75609756097561	48	18	87.8	0	20	163	149	196	XP_041366930.1 phospholipase B1, membrane-associated-like [Gigantopelta aegis]	diamond	288	60.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis

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