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

9 rows where analysis = "diamond", bioproject = "PRJNA745553" 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
5828063	5828063	PRJNA745553_S_NODE_725_length_836_cov_4.114024_g624_i0	PRJNA745553	725	836	4.114024	34.39324064	Pecten maximus	6579	Mollusca	Mollusca	72.4	2.44e-10	NR	XP_033740227.1	6579	g624	i0	50	0.215311004784689	60	30	21.5	0	263	84	370	429	XP_033740227.1 baculoviral IAP repeat-containing protein 3-like [Pecten maximus]	diamond	180	72.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
8377472	8377472	PRJNA745553_S_NODE_1727_length_680_cov_3.326194_g1567_i0	PRJNA745553	1727	680	3.326194	22.6181192	Metazoa	33208	Mollusca	Mollusca	300	4.16e-99	NR	XP_046363152.1	6454	g1567	i0	63.8	34.7558823529412	218	70	92.2	2	3	629	82	299	XP_046363152.1 cathepsin Z-like [Haliotis rufescens]	diamond	23634	301	0.996677740863787	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
27178967	27178967	PRJNA745553_S_NODE_11942_length_355_cov_1.663121_g11747_i0	PRJNA745553	11942	355	1.663121	5.90407955	Mactra antiquata	2302425	Mollusca	Mollusca	66.2	7.89e-10	NR	KAL4240157.1	2302425	g11747	i0	34.1	1.46197183098592	88	57	74.4	1	63	326	666	752	KAL4240157.1 hypothetical protein ACF0H5_000951 [Mactra antiquata]	diamond	519	66.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
28474009	28474009	PRJNA745553_S_NODE_18466_length_287_cov_3.785047_g18271_i0	PRJNA745553	18466	287	3.785047	10.86308489	Acanthosepion pharaonis	158019	Mollusca	Mollusca	43.5	0.0354	NR	CAE1236277.1	158019	g18271	i0	41.8	0.825783972125436	79	38	82.6	2	42	278	1363	1433	CAE1236277.1 unnamed protein product [Acanthosepion pharaonis]	diamond	237	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Sepiida	Sepiidae	Acanthosepion	Acanthosepion pharaonis
29863145	29863145	PRJNA745553_S_NODE_15391_length_314_cov_2.759336_g15196_i0	PRJNA745553	15391	314	2.759336	8.66431504	Pecten maximus	6579	Mollusca	Mollusca	65.5	9.02e-10	NR	XP_033732660.1	6579	g15196	i0	45.6	1.29936305732484	68	37	65	0	20	223	787	854	XP_033732660.1 uncharacterized protein C05D11.1-like isoform X2 [Pecten maximus]	diamond	408	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
30189013	30189013	PRJNA745553_S_NODE_25732_length_245_cov_1.976744_g25537_i0	PRJNA745553	25732	245	1.976744	4.8430228	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	9.95e-23	NR	XP_041377661.1	1735272	g25537	i0	65.7	2.43673469387755	70	23	84.5	1	221	15	2405	2474	XP_041377661.1 serine/threonine-protein kinase mTOR-like isoform X2 [Gigantopelta aegis]	diamond	597	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
30316001	30316001	PRJNA745553_S_NODE_13492_length_335_cov_1.351145_g13297_i0	PRJNA745553	13492	335	1.351145	4.52633575	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.6	0.0036	NR	WAR20483.1	6604	g13297	i0	55.6	3.72537313432836	36	16	32.2	0	332	225	112	147	WAR20483.1 SRSF4-like protein, partial [Mya arenaria]	diamond	1248	46.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
31168319	31168319	PRJNA745553_S_NODE_6435_length_461_cov_1.317010_g6241_i0	PRJNA745553	6435	461	1.31701	6.0714161	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	133	9.52e-34	NR	XP_070206760.1	31220	g6241	i0	53.2	1.99783080260304	154	69	98.3	2	455	3	221	374	XP_070206760.1 cleavage stimulation factor subunit 1-like [Littorina saxatilis]	diamond	921	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
31727759	31727759	PRJNA745553_S_NODE_18457_length_287_cov_4.242991_g18262_i0	PRJNA745553	18457	287	4.242991	12.17738417	Bradybaena similaris	145626	Mollusca	Mollusca	65.5	6.61e-10	NR	BFZ17741.1	145626	g18262	i0	37.1	1.82926829268293	89	54	93	2	281	15	1213	1299	BFZ17741.1 hypothetical protein BsWGS_20780 [Bradybaena similaris]	diamond	525	65.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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