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

11 rows where bioproject = "PRJNA495391", 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
476888	476888	PRJNA495391_S_NODE_53741_length_169_cov_2.037313_g52689_i0	PRJNA495391	53741	169	2.037313	3.44305897	Mya arenaria	6604	Mollusca	Mollusca	60.2	8.43e-5	NTclustered	gi\|2427447585\|ref\|XM_052924905.1\|	6604	g52689	i0	100	0.633136094674556	32	0	19	0	24	55	566	597	PREDICTED: Mya arenaria 60S ribosomal protein L18-like (LOC128217635), mRNA	blastn	107	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
5579271	5579271	PRJNA495391_S_NODE_12765_length_335_cov_2.473333_g11713_i0	PRJNA495391	12765	335	2.473333	8.28566555	Metazoa	33208	Mollusca	Mollusca	146	2.92e-39	NR	XP_050399022.1	6465	g11713	i0	84	38.4537313432836	81	13	72.5	0	47	289	370	450	XP_050399022.1 cysteine desulfurase [Patella vulgata]	diamond	12882	146	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
14504582	14504582	PRJNA495391_S_NODE_17412_length_287_cov_2.396825_g16360_i0	PRJNA495391	17412	287	2.396825	6.87888775	Dreissena polymorpha	45954	Mollusca	Mollusca	69.4	2.64e-7	NTclustered	gi\|2364394871\|ref\|XR_008043607.1\|	45954	g16360	i0	100	0.226480836236934	37	0	13	0	56	92	462	498	PREDICTED: Dreissena polymorpha uncharacterized LOC127867677 (LOC127867677), ncRNA	blastn	65	69.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
14505270	14505270	PRJNA495391_S_NODE_42952_length_187_cov_2.506579_g41900_i0	PRJNA495391	42952	187	2.506579	4.68730273	Mercenaria mercenaria	6596	Mollusca	Mollusca	171	4.24e-38	NTclustered	gi\|2442079979\|ref\|XM_045300417.2\|	6596	g41900	i0	84.091	65.5828877005348	176	28	94	0	12	187	1290	1115	PREDICTED: Mercenaria mercenaria tubulin alpha chain, testis-specific-like (LOC123522907), mRNA	blastn	12264	171	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
15779117	15779117	PRJNA495391_S_NODE_40033_length_194_cov_1.220126_g38981_i0	PRJNA495391	40033	194	1.220126	2.36704444	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	158	3.45e-34	NTclustered	gi\|1207980043\|ref\|XM_021483868.1\|	6573	g38981	i0	84.049	21.6752577319588	163	26	84	0	3	165	124	286	PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L10-like (LOC110440716), mRNA	blastn	4205	158	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
26601895	26601895	PRJNA495391_S_NODE_28501_length_226_cov_2.141361_g27449_i0	PRJNA495391	28501	226	2.141361	4.83947586	Ruditapes philippinarum	129788	Mollusca	Mollusca	70.1	2.11e-12	NR	XP_060553710.1	129788	g27449	i0	52.9	0.929203539823009	70	30	90.3	2	204	1	160	228	XP_060553710.1 uncharacterized protein LOC132714801 [Ruditapes philippinarum]	diamond	210	70.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
26792229	26792229	PRJNA495391_S_NODE_24521_length_243_cov_2.336538_g23469_i0	PRJNA495391	24521	243	2.336538	5.67778734	Saccostrea echinata	191078	Mollusca	Mollusca	54.3	1.79e-6	NR	XP_061187457.1	191078	g23469	i0	61	0.506172839506173	41	15	50.6	1	4	126	170	209	XP_061187457.1 glutathione S-transferase Mu 3-like [Saccostrea echinata]	diamond	123	54.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
27076994	27076994	PRJNA495391_S_NODE_63342_length_158_cov_0.967480_g62290_i0	PRJNA495391	63342	158	0.96748	1.5286184	Littorina saxatilis	31220	Mollusca	Mollusca	43.1	0.00411	NR	KAK7111740.1	31220	g62290	i0	54.8	24.1329113924051	31	14	58.9	0	125	33	65	95	KAK7111740.1 hypothetical protein V1264_011322 [Littorina saxatilis]	diamond	3813	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
28971809	28971809	PRJNA495391_S_NODE_25088_length_240_cov_2.795122_g24036_i0	PRJNA495391	25088	240	2.795122	6.7082928	Plakobranchus ocellatus	259542	Mollusca	Mollusca	51.6	1.89e-5	NR	GFN96214.1	259542	g24036	i0	54.1	4.175	37	17	46.3	0	1	111	181	217	GFN96214.1 endonuclease-reverse transcriptase [Plakobranchus ocellatus]	diamond	1002	51.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
30123915	30123915	PRJNA495391_S_NODE_64012_length_157_cov_1.426230_g62960_i0	PRJNA495391	64012	157	1.42623	2.2391811	Bivalvia	6544	Mollusca	Mollusca	68.6	9.13e-12	NR	XP_022305564.1	6565	g62960	i0	56	7.64331210191083	50	22	95.5	0	7	156	355	404	XP_022305564.1 uncharacterized protein K02A2.6-like [Crassostrea virginica]	diamond	1200	68.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
32621642	32621642	PRJNA495391_S_NODE_37160_length_200_cov_2.636364_g36108_i0	PRJNA495391	37160	200	2.636364	5.272728	Metazoa	33208	Mollusca	Mollusca	71.2	2.29e-13	NR	XP_041375579.1	1735272	g36108	i0	58.2	2.58	55	23	82.5	0	168	4	21	75	XP_041375579.1 uncharacterized protein LOC121388345 [Gigantopelta aegis]	diamond	516	71.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis

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