metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA506002" 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
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);;