metadata: contig_metadata: 11 rows where bioproject = "PRJNA506002", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA506002", 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
4310817	4310817	PRJNA506002_S_NODE_31784_length_303_cov_1.134783_g31538_i0	PRJNA506002	31784	303	1.134783	3.43839249	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	6.07e-4	NTclustered	gi\|2912999222\|dbj\|AP039605.1\|	145626	g31538	i0	100	0.102310231023102	31	0	10	0	165	195	27498841	27498811	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
7488593	7488593	PRJNA506002_S_NODE_20106_length_345_cov_0.845588_g19860_i0	PRJNA506002	20106	345	0.845588	2.9172786	Metazoa	33208	Mollusca	Mollusca	60.2	1.95e-4	NTclustered	gi\|2912995509\|dbj\|AP039600.1\|	145626	g19860	i0	100	4.12173913043478	32	0	9	0	90	121	55726714	55726683	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence	blastn	1422	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
8137194	8137194	PRJNA506002_S_NODE_56147_length_251_cov_0.921348_g55901_i0	PRJNA506002	56147	251	0.921348	2.31258348	Mya arenaria	6604	Mollusca	Mollusca	54.7	0.006	NTclustered	gi\|2427501516\|ref\|XM_052952213.1\|	6604	g55901	i0	100	2.77290836653386	29	0	12	0	8	36	143	171	PREDICTED: Mya arenaria uncharacterized LOC128237033 (LOC128237033), mRNA	blastn	696	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
8137233	8137233	PRJNA506002_S_NODE_61067_length_246_cov_1.190751_g60821_i0	PRJNA506002	61067	246	1.190751	2.92924746	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2912995509\|dbj\|AP039600.1\|	145626	g60821	i0	100	0.569105691056911	28	0	11	0	191	218	51243484	51243511	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11962547	11962547	PRJNA506002_S_NODE_20490_length_343_cov_1.314815_g20244_i0	PRJNA506002	20490	343	1.314815	4.50981545	Dreissena polymorpha	45954	Mollusca	Mollusca	52.8	0.032	NTclustered	gi\|1880642401\|gb\|MT483676.1\|	45954	g20244	i0	100	0.0816326530612245	28	0	8	0	316	343	8360	8387	Dreissena polymorpha isolate DM1270 mitochondrion	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
11962735	11962735	PRJNA506002_S_NODE_42910_length_276_cov_1.068966_g42664_i0	PRJNA506002	42910	276	1.068966	2.95034616	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.025	NTclustered	gi\|2912993551\|dbj\|AP039598.1\|	145626	g42664	i0	100	0.101449275362319	28	0	10	0	1	28	57685719	57685746	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
28466825	28466825	PRJNA506002_S_NODE_62426_length_245_cov_0.895349_g62180_i0	PRJNA506002	62426	245	0.895349	2.19360505	Octopus bimaculoides	37653	Mollusca	Mollusca	57.4	2.65e-7	NR	XP_052824391.1	37653	g62180	i0	43.4	0.930612244897959	76	36	91.8	2	2	226	833	902	XP_052824391.1 transducin-like enhancer protein 4 [Octopus bimaculoides]	diamond	228	57.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
29050605	29050605	PRJNA506002_S_NODE_52068_length_258_cov_0.843243_g51822_i0	PRJNA506002	52068	258	0.843243	2.17556694	Bivalvia	6544	Mollusca	Mollusca	100	2.93e-22	NR	XP_022335857.1	6565	g51822	i0	69.7	9.5	66	20	76.7	0	30	227	700	765	XP_022335857.1 uncharacterized protein LOC111132345 [Crassostrea virginica]	diamond	2451	101	0.99009900990099	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30456605	30456605	PRJNA506002_S_NODE_36373_length_290_cov_5.677419_g36127_i0	PRJNA506002	36373	290	5.677419	16.4645151	Haliotis asinina	109174	Mollusca	Mollusca	43.9	0.0239	NR	XP_067657806.1	109174	g36127	i0	35.4	1.32413793103448	65	36	66.2	2	80	271	144	203	XP_067657806.1 uncharacterized protein [Haliotis asinina]	diamond	384	43.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
31467777	31467777	PRJNA506002_S_NODE_49256_length_263_cov_1.042105_g49010_i0	PRJNA506002	49256	263	1.042105	2.74073615	Elysia marginata	1093978	Mollusca	Mollusca	66.6	9.9e-12	NR	GFS15725.1	1093978	g49010	i0	51.9	6.26235741444867	54	26	61.6	0	3	164	16	69	GFS15725.1 hypothetical protein ElyMa_003194900 [Elysia marginata]	diamond	1647	66.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
31941851	31941851	PRJNA506002_S_NODE_20097_length_345_cov_0.988971_g19851_i0	PRJNA506002	20097	345	0.988971	3.41194995	Littorina saxatilis	31220	Mollusca	Mollusca	161	4.91e-47	NR	KAK7113090.1	31220	g19851	i0	83.9	3.23478260869565	93	15	80.9	0	280	2	39	131	KAK7113090.1 hypothetical protein V1264_012441 [Littorina saxatilis]	diamond	1116	161	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis

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