metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA1034995" 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
27098320	27098320	PRJNA1034995_S_NODE_14082_length_526_cov_27.573499_g13936_i0	PRJNA1034995	14082	526	27.573499	145.03660474	Crassostrea virginica	6565	Mollusca	Mollusca	52	5.38e-5	NR	XP_022311995.1	6565	g13936	i0	64.1	0.222433460076046	39	14	22.2	0	99	215	85	123	XP_022311995.1 uncharacterized protein LOC111117215 [Crassostrea virginica]	diamond	117	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
27446254	27446254	PRJNA1034995_S_NODE_25823_length_308_cov_20.513208_g25667_i0	PRJNA1034995	25823	308	20.513208	63.18068064	Mytilus edulis	6550	Mollusca	Mollusca	114	6.88e-27	NR	CAG2231418.1	6550	g25667	i0	55.9	8.89285714285714	102	45	99.4	0	2	307	52	153	CAG2231418.1 unnamed protein product [Mytilus edulis]	diamond	2739	114	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27667189	27667189	PRJNA1034995_S_NODE_36184_length_226_cov_5.950820_g36028_i0	PRJNA1034995	36184	226	5.95082	13.4488532	Pomacea canaliculata	400727	Mollusca	Mollusca	54.7	1.8e-6	NR	XP_025113848.1	400727	g36028	i0	92.3	1.34070796460177	26	2	34.5	0	2	79	294	319	XP_025113848.1 tubulin alpha-1 chain-like [Pomacea canaliculata]	diamond	303	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
28108885	28108885	PRJNA1034995_S_NODE_16425_length_455_cov_26.912621_g16272_i0	PRJNA1034995	16425	455	26.912621	122.45242555	Plakobranchus ocellatus	259542	Mollusca	Mollusca	47	0.0106	NR	GFO21201.1	259542	g16272	i0	42.2	0.567032967032967	45	26	29.7	0	227	93	23	67	GFO21201.1 hypothetical protein PoB_004770600 [Plakobranchus ocellatus]	diamond	258	47	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
28961777	28961777	PRJNA1034995_S_NODE_44588_length_184_cov_1.546099_g44432_i0	PRJNA1034995	44588	184	1.546099	2.84482216	Mercenaria mercenaria	6596	Mollusca	Mollusca	56.2	2.88e-7	NR	XP_053385515.1	6596	g44432	i0	59	2.10326086956522	39	16	63.6	0	182	66	1334	1372	XP_053385515.1 uncharacterized protein LOC128550456 [Mercenaria mercenaria]	diamond	387	56.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
29490181	29490181	PRJNA1034995_S_NODE_41450_length_198_cov_1.483871_g41294_i0	PRJNA1034995	41450	198	1.483871	2.93806458	Mytilus	6548	Mollusca	Mollusca	46.2	0.00123	NR	CAG2233860.1	6550	g41294	i0	45.8	4.3030303030303	48	26	72.7	0	43	186	148	195	CAG2233860.1 unnamed protein product [Mytilus edulis]	diamond	852	46.6	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
30983185	30983185	PRJNA1034995_S_NODE_14334_length_517_cov_21.647679_g14186_i0	PRJNA1034995	14334	517	21.647679	111.91850043	Littorina saxatilis	31220	Mollusca	Mollusca	53.5	4.92e-5	NR	KAK7105128.1	31220	g14186	i0	52	0.290135396518375	50	24	29	0	217	68	173	222	KAK7105128.1 hypothetical protein V1264_019730 [Littorina saxatilis]	diamond	150	53.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
31900058	31900058	PRJNA1034995_S_NODE_46177_length_177_cov_16.410448_g46021_i0	PRJNA1034995	46177	177	16.410448	29.04649296	Elysia crispata	231223	Mollusca	Mollusca	41.6	0.0331	NR	KAK3725784.1	231223	g46021	i0	51.7	0.491525423728814	29	14	49.2	0	21	107	85	113	KAK3725784.1 hypothetical protein RRG08_030014 [Elysia crispata]	diamond	87	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata
32216540	32216540	PRJNA1034995_S_NODE_49018_length_167_cov_14.217742_g48862_i0	PRJNA1034995	49018	167	14.217742	23.74362914	Elysia crispata	231223	Mollusca	Mollusca	41.6	0.0294	NR	KAK3725784.1	231223	g48862	i0	51.7	0.520958083832335	29	14	52.1	0	21	107	85	113	KAK3725784.1 hypothetical protein RRG08_030014 [Elysia crispata]	diamond	87	41.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata
32493395	32493395	PRJNA1034995_S_NODE_40399_length_203_cov_1.437500_g40243_i0	PRJNA1034995	40399	203	1.4375	2.918125	Metazoa	33208	Mollusca	Mollusca	58.2	7.44e-8	NR	XP_050404757.1	6465	g40243	i0	100	47.4827586206897	27	0	39.9	0	2	82	152	178	XP_050404757.1 DNA repair protein RAD51 homolog 1 [Patella vulgata]	diamond	9639	58.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
32658653	32658653	PRJNA1034995_S_NODE_17340_length_435_cov_8.548469_g17185_i0	PRJNA1034995	17340	435	8.548469	37.18584015	Elysia crispata	231223	Mollusca	Mollusca	43.5	0.033	NR	KAK3776571.1	231223	g17185	i0	37.5	0.496551724137931	72	37	49	3	347	135	10	74	KAK3776571.1 hypothetical protein RRG08_037077 [Elysia crispata]	diamond	216	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata
32690317	32690317	PRJNA1034995_S_NODE_14220_length_521_cov_22.508368_g14073_i0	PRJNA1034995	14220	521	22.508368	117.26859728	Crassostrea virginica	6565	Mollusca	Mollusca	53.1	1.96e-5	NR	XP_022311995.1	6565	g14073	i0	51.1	0.259117082533589	45	22	25.9	0	465	331	79	123	XP_022311995.1 uncharacterized protein LOC111117215 [Crassostrea virginica]	diamond	135	53.1	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);;