metadata: contig_metadata: 5 rows where bioproject = "PRJNA385396", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA385396", 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
6784452	6784452	PRJNA385396_P_NODE_12286_length_260_cov_1.641711_g12194_i0	PRJNA385396	12286	260	1.641711	4.2684486	Metazoa	33208	Mollusca	Mollusca	95.1	1.8e-20	NR	XP_022331369.1	6565	g12194	i0	57.5	10.1538461538462	80	34	92.3	0	21	260	3971	4050	XP_022331369.1 uncharacterized protein LOC111129343 isoform X1 [Crassostrea virginica]	diamond	2640	95.9	0.991657977059437	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
8060181	8060181	PRJNA385396_P_NODE_18947_length_244_cov_0.900585_g18855_i0	PRJNA385396	18947	244	0.900585	2.1974274	Bradybaena similaris	145626	Mollusca	Mollusca	63.9	1.02e-5	NTclustered	gi\|2912985489\|dbj\|AP039590.1\|	145626	g18855	i0	95	0.163934426229508	40	2	16	0	189	228	50958931	50958970	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence	blastn	40	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
30770469	30770469	PRJNA385396_P_NODE_13034_length_253_cov_1.711111_g12942_i0	PRJNA385396	13034	253	1.711111	4.32911083	Octopus sinensis	2607531	Mollusca	Mollusca	47.8	6.13e-4	NR	XP_029654711.1	2607531	g12942	i0	56.8	0.438735177865613	37	14	41.5	1	9	113	33	69	XP_029654711.1 uncharacterized protein LOC115228213 [Octopus sinensis]	diamond	111	47.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
31419252	31419252	PRJNA385396_P_NODE_10276_length_281_cov_2.221154_g10184_i0	PRJNA385396	10276	281	2.221154	6.24144274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.5	3.4e-16	NR	CAG2198022.1	6550	g10184	i0	51.9	1.72953736654804	81	37	84.3	1	1	237	19	99	CAG2198022.1 GST [Mytilus edulis]	diamond	486	80.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
32273635	32273635	PRJNA385396_P_NODE_7098_length_323_cov_3.072000_g7006_i0	PRJNA385396	7098	323	3.072	9.92256	Opisthokonta	33154	Mollusca	Mollusca	132	1.7100000000000002e-36	NR	XP_022291847.1	6565	g7006	i0	62.1	10.7925696594427	103	39	95.7	0	14	322	8	110	XP_022291847.1 60S ribosomal protein L13a-like [Crassostrea virginica]	diamond	3486	132	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica

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