metadata: contig_metadata: 8 rows where bioproject = "PRJNA380416", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA380416", 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
402048	402048	PRJNA380416_P_NODE_13341_length_162_cov_0.902655_g13194_i0	PRJNA380416	13341	162	0.902655	1.4623011	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	2.9e-4	NTclustered	gi\|2912990805\|dbj\|AP039595.1\|	145626	g13194	i0	97.059	0.209876543209877	34	1	21	0	27	60	10542472	10542505	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
5505682	5505682	PRJNA380416_P_NODE_7945_length_203_cov_0.993506_g7798_i0	PRJNA380416	7945	203	0.993506	2.01681718	Lottia gigantea	225164	Mollusca	Mollusca	193	9.99e-45	NTclustered	gi\|676493537\|ref\|XM_009068023.1\|	225164	g7798	i0	89.032	74.1970443349754	155	17	76	0	2	156	205	51	Lottia gigantea hypothetical protein mRNA	blastn	15062	193	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
26758384	26758384	PRJNA380416_P_NODE_11861_length_166_cov_0.871795_g11714_i0	PRJNA380416	11861	166	0.871795	1.4471797	Magallana gigas	29159	Mollusca	Mollusca	42.7	0.0122	NR	XP_011435447.1	29159	g11714	i0	50	0.542168674698795	30	15	54.2	0	116	27	32	61	XP_011435447.1 phospholipid scramblase 1 [Magallana gigas]	diamond	90	42.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
27565817	27565817	PRJNA380416_P_NODE_4444_length_279_cov_1.713043_g4297_i0	PRJNA380416	4444	279	1.713043	4.77938997	Mytilus	6548	Mollusca	Mollusca	50.4	1.08e-4	NR	CAG2244785.1	6550	g4297	i0	29.1	3.75268817204301	86	58	89.2	1	7	255	250	335	CAG2244785.1 CYPD [Mytilus edulis]	diamond	1047	50.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
28117179	28117179	PRJNA380416_P_NODE_3825_length_306_cov_1.455253_g3678_i0	PRJNA380416	3825	306	1.455253	4.45307418	Elysia marginata	1093978	Mollusca	Mollusca	125	1.05e-31	NR	GFS10275.1	1093978	g3678	i0	63.4	0.911764705882353	93	34	91.2	0	3	281	24	116	GFS10275.1 reductase-related protein [Elysia marginata]	diamond	279	125	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
28323629	28323629	PRJNA380416_P_NODE_13126_length_163_cov_0.894737_g12979_i0	PRJNA380416	13126	163	0.894737	1.45842131	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.1	5.73e-16	NR	XP_046361411.1	6454	g12979	i0	72.2	8.92638036809816	54	15	99.4	0	1	162	278	331	XP_046361411.1 fructose-bisphosphate aldolase [Haliotis rufescens]	diamond	1455	80.5	0.995031055900621	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
29159432	29159432	PRJNA380416_P_NODE_12189_length_165_cov_0.879310_g12042_i0	PRJNA380416	12189	165	0.87931	1.4508615	Pomacea canaliculata	400727	Mollusca	Mollusca	51.6	9.84e-6	NR	XP_025105735.1	400727	g12042	i0	43.4	6.78181818181818	53	30	96.4	0	162	4	222	274	XP_025105735.1 calcium-binding protein LPS1-alpha-like [Pomacea canaliculata]	diamond	1119	51.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
30517361	30517361	PRJNA380416_P_NODE_13593_length_162_cov_0.902655_g13446_i0	PRJNA380416	13593	162	0.902655	1.4623011	Gigantopelta aegis	1735272	Mollusca	Mollusca	47	4.06e-4	NR	XP_041353713.1	1735272	g13446	i0	42.2	1.72222222222222	45	25	83.3	1	141	7	113	156	XP_041353713.1 TNF receptor-associated factor 3-like [Gigantopelta aegis]	diamond	279	47	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);;