metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA600413" 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
9503545	9503545	PRJNA600413_P_NODE_82488_length_178_cov_1.581395_g81787_i0	PRJNA600413	82488	178	1.581395	2.8148831	Cephalopoda	6605	Mollusca	Mollusca	95.9	3.01e-21	NR	XP_052825161.1	37653	g81787	i0	72.9	24.8932584269663	59	16	99.4	0	177	1	732	790	XP_052825161.1 liprin-beta-1 isoform X4 [Octopus bimaculoides]	diamond	4431	95.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
18425534	18425534	PRJNA600413_P_NODE_16515_length_354_cov_4.773770_g15814_i0	PRJNA600413	16515	354	4.77377	16.8991458	Elysia marginata	1093978	Mollusca	Mollusca	69.3	2.52e-12	NR	GFR64128.1	1093978	g15814	i0	63.3	2.8728813559322	49	18	41.5	0	345	199	42	90	GFR64128.1 endonuclease-reverse transcriptase [Elysia marginata]	diamond	1017	69.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
26840346	26840346	PRJNA600413_P_NODE_52421_length_205_cov_1.397436_g51720_i0	PRJNA600413	52421	205	1.397436	2.8647438	Metazoa	33208	Mollusca	Mollusca	53.1	4.96e-6	NR	XP_055860289.1	6526	g51720	i0	54.5	3.49756097560976	44	18	61.5	1	7	132	521	564	XP_055860289.1 uncharacterized protein LOC129921730 [Biomphalaria glabrata]	diamond	717	53.5	0.992523364485981	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27251251	27251251	PRJNA600413_P_NODE_92563_length_172_cov_1.642276_g91862_i0	PRJNA600413	92563	172	1.642276	2.82471472	Metazoa	33208	Mollusca	Mollusca	57.4	7.89e-8	NR	XP_063436638.1	6551	g91862	i0	45.6	10.5872093023256	57	27	99.4	2	2	172	68	120	XP_063436638.1 uncharacterized protein LOC134718077 [Mytilus trossulus]	diamond	1821	57.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus trossulus
27553579	27553579	PRJNA600413_P_NODE_116604_length_165_cov_1.146552_g115903_i0	PRJNA600413	116604	165	1.146552	1.8918108	Plakobranchus ocellatus	259542	Mollusca	Mollusca	67.4	1.8e-11	NR	GFO40356.1	259542	g115903	i0	56.6	4.85454545454545	53	22	94.5	1	163	8	69	121	GFO40356.1 endonuclease-reverse transcriptase [Plakobranchus ocellatus]	diamond	801	67.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
27837841	27837841	PRJNA600413_P_NODE_13404_length_398_cov_3.458453_g12705_i0	PRJNA600413	13404	398	3.458453	13.76464294	Ostrea edulis	37623	Mollusca	Mollusca	43.5	0.0471	NR	XP_048729451.1	37623	g12705	i0	33.3	0.452261306532663	60	40	45.2	0	97	276	17	76	XP_048729451.1 perlucin-like protein isoform X2 [Ostrea edulis]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
27837844	27837844	PRJNA600413_P_NODE_138044_length_162_cov_1.353982_g137343_i0	PRJNA600413	138044	162	1.353982	2.19345084	Plakobranchus ocellatus	259542	Mollusca	Mollusca	53.1	2.17e-6	NR	GFO09874.1	259542	g137343	i0	69.2	2.88888888888889	39	12	72.2	0	36	152	181	219	GFO09874.1 Pol polyprotein [Plakobranchus ocellatus]	diamond	468	53.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
28185098	28185098	PRJNA600413_P_NODE_28426_length_266_cov_1.760369_g27725_i0	PRJNA600413	28426	266	1.760369	4.68258154	Octopus sinensis	2607531	Mollusca	Mollusca	74.7	2.32e-13	NR	XP_029654626.1	2607531	g27725	i0	42.5	0.981203007518797	87	50	98.1	0	2	262	15	101	XP_029654626.1 uncharacterized protein LOC115228103 [Octopus sinensis]	diamond	261	74.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus sinensis
28753661	28753661	PRJNA600413_P_NODE_72207_length_185_cov_1.264706_g71506_i0	PRJNA600413	72207	185	1.264706	2.3397061	Elysia marginata	1093978	Mollusca	Mollusca	76.3	6.63e-16	NR	GFR84715.1	1093978	g71506	i0	54.1	0.989189189189189	61	28	98.9	0	183	1	60	120	GFR84715.1 RNA-directed DNA polymerase from mobile element jockey-like [Elysia marginata]	diamond	183	76.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
30680024	30680024	PRJNA600413_P_NODE_55953_length_200_cov_1.291391_g55252_i0	PRJNA600413	55953	200	1.291391	2.582782	Potamilus streckersoni	2493646	Mollusca	Mollusca	70.9	2.16e-12	NR	KAK3589668.1	2493646	g55252	i0	43.8	1.905	64	36	96	0	6	197	89	152	KAK3589668.1 hypothetical protein CHS0354_015172 [Potamilus streckersoni]	diamond	381	70.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
30946464	30946464	PRJNA600413_P_NODE_91154_length_173_cov_1.250000_g90453_i0	PRJNA600413	91154	173	1.25	2.1625	Venerida	6580	Mollusca	Mollusca	82.4	1.47e-16	NR	XP_060581194.1	129788	g90453	i0	70.2	5.93063583815029	57	17	98.8	0	3	173	392	448	XP_060581194.1 LOW QUALITY PROTEIN: alpha-aminoadipic semialdehyde dehydrogenase-like [Ruditapes philippinarum]	diamond	1026	82.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
31312191	31312191	PRJNA600413_P_NODE_73015_length_184_cov_1.755556_g72314_i0	PRJNA600413	73015	184	1.755556	3.23022304	Sinanodonta woodiana	1069815	Mollusca	Mollusca	58.9	2.13e-8	NR	KAL3890953.1	1069815	g72314	i0	65.8	1.85869565217391	38	13	62	0	183	70	35	72	KAL3890953.1 hypothetical protein ACJMK2_003222 [Sinanodonta woodiana]	diamond	342	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Sinanodonta	Sinanodonta woodiana
31515601	31515601	PRJNA600413_P_NODE_96516_length_170_cov_1.363636_g95815_i0	PRJNA600413	96516	170	1.363636	2.3181812	root	1	Root_unresolved	Root_unresolved	42.4	0.0186	NR	CAI9717498.1	6645	g95815	i0	39.6	2.4	53	31	91.8	1	157	2	89	141	CAI9717498.1 Hypothetical predicted protein [Octopus vulgaris]	diamond	408	42.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus vulgaris
31818261	31818261	PRJNA600413_P_NODE_69237_length_187_cov_1.195652_g68536_i0	PRJNA600413	69237	187	1.195652	2.23586924	Mya arenaria	6604	Mollusca	Mollusca	68.9	1.04e-11	NR	WAR17805.1	6604	g68536	i0	59.6	2.74331550802139	57	23	91.4	0	171	1	1020	1076	WAR17805.1 hypothetical protein MAR_032399 [Mya arenaria]	diamond	513	68.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
32387844	32387844	PRJNA600413_P_NODE_33859_length_245_cov_2.403061_g33158_i0	PRJNA600413	33859	245	2.403061	5.88749945	Elysia marginata	1093978	Mollusca	Mollusca	65.1	2.63e-10	NR	GFS11891.1	1093978	g33158	i0	80	3.86938775510204	35	7	42.9	0	115	11	90	124	GFS11891.1 endonuclease-reverse transcriptase [Elysia marginata]	diamond	948	65.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata

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