metadata: contig_metadata: 7 rows where bioproject = "PRJNA1242190", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA1242190", tax_kingdom = "Metazoa" 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
6728629	6728629	PRJNA1242190_S_NODE_10546_length_266_cov_2.103627_g10539_i0	PRJNA1242190	10546	266	2.103627	5.59564782	Mytilus trossulus	6551	Mollusca	Mollusca	58.4	5.23e-4	NTclustered	gi\|2694105785\|ref\|XM_063588182.1\|	6551	g10539	i0	94.595	0.139097744360902	37	2	14	0	224	260	726	762	PREDICTED: Mytilus trossulus heterogeneous nuclear ribonucleoprotein U-like protein 1 (LOC134724873), mRNA	blastn	37	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
15653984	15653984	PRJNA1242190_S_NODE_9913_length_274_cov_1.333333_g9906_i0	PRJNA1242190	9913	274	1.333333	3.65333242	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	132	8.3e-35	NR	KAH9514130.1	55810	g9906	i0	64	16.8394160583942	89	32	97.4	0	267	1	240	328	KAH9514130.1 hypothetical protein Btru_030358 [Bulinus truncatus]	diamond	4614	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Bulinus	Bulinus truncatus
19476909	19476909	PRJNA1242190_S_NODE_10336_length_269_cov_1.193878_g10329_i0	PRJNA1242190	10336	269	1.193878	3.21153182	Metazoa	33208	Mollusca	Mollusca	74.7	2.91e-13	NR	XP_014777605.1	37653	g10329	i0	42.3	2.37546468401487	71	41	79.2	0	268	56	938	1008	XP_014777605.1 2-oxoglutarate dehydrogenase complex component E1 isoform X1 [Octopus bimaculoides]	diamond	639	74.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
26756893	26756893	PRJNA1242190_S_NODE_13761_length_242_cov_0.869822_g13754_i0	PRJNA1242190	13761	242	0.869822	2.10496924	Haliotis rubra	36100	Mollusca	Mollusca	57	8.04e-8	NR	XP_046582455.1	36100	g13754	i0	38.8	1.66115702479339	67	41	83.1	0	21	221	93	159	XP_046582455.1 calmodulin-like [Haliotis rubra]	diamond	402	57	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
26820611	26820611	PRJNA1242190_S_NODE_9561_length_278_cov_3.653659_g9554_i0	PRJNA1242190	9561	278	3.653659	10.15717202	Ostrea edulis	37623	Mollusca	Mollusca	46.2	0.00114	NR	XP_056005100.1	37623	g9554	i0	45.9	0.399280575539568	37	20	39.9	0	40	150	96	132	XP_056005100.1 uncharacterized protein LOC130050128 isoform X2 [Ostrea edulis]	diamond	111	46.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
29568173	29568173	PRJNA1242190_S_NODE_7490_length_310_cov_1.991561_g7483_i0	PRJNA1242190	7490	310	1.991561	6.1738391	Gigantopelta aegis	1735272	Mollusca	Mollusca	76.3	1.52e-15	NR	XP_041352657.1	1735272	g7483	i0	38.5	2.66129032258065	91	55	87.1	1	295	26	3	93	XP_041352657.1 cystatin-A-like [Gigantopelta aegis]	diamond	825	76.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
32096705	32096705	PRJNA1242190_S_NODE_14118_length_222_cov_6.389262_g14111_i0	PRJNA1242190	14118	222	6.389262	14.18416164	Ostrea edulis	37623	Mollusca	Mollusca	44.7	0.00606	NR	XP_056011300.1	37623	g14111	i0	40.7	0.797297297297297	59	35	79.7	0	218	42	1008	1066	XP_056011300.1 dystonin-like isoform X3 [Ostrea edulis]	diamond	177	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis

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