metadata: contig_metadata: 10 rows where bioproject = "PRJNA672101", tax_phylum = "Mollusca" and tax

10 rows where bioproject = "PRJNA672101", tax_phylum = "Mollusca" and tax_superkingdom = "Eukaryota"

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
641783	641783	PRJNA672101_S_NODE_17101_length_299_cov_4.053097_g17070_i0	PRJNA672101	17101	299	4.053097	12.11876003	Littorina saxatilis	31220	Mollusca	Mollusca	52.8	0.028	NTclustered	gi\|2868691237\|ref\|XM_070349129.1\|	31220	g17070	i0	100	0.468227424749164	28	0	9	0	1	28	604	577	PREDICTED: Littorina saxatilis uncharacterized protein (LOC138976286), mRNA	blastn	140	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
12120985	12120985	PRJNA672101_S_NODE_13630_length_321_cov_1.435484_g13599_i0	PRJNA672101	13630	321	1.435484	4.60790364	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.03	NTclustered	gi\|2912990805\|dbj\|AP039595.1\|	145626	g13599	i0	92.105	0.118380062305296	38	2	12	1	174	211	8954359	8954323	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence	blastn	38	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19768646	19768646	PRJNA672101_S_NODE_15936_length_306_cov_2.064378_g15905_i0	PRJNA672101	15936	306	2.064378	6.31699668	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.008	NTclustered	gi\|2913000417\|dbj\|AP039607.1\|	145626	g15905	i0	96.875	0.209150326797386	32	1	10	0	216	247	8068705	8068736	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence	blastn	64	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
26808946	26808946	PRJNA672101_S_NODE_9881_length_349_cov_4.032609_g9850_i0	PRJNA672101	9881	349	4.032609	14.07380541	Metazoa	33208	Mollusca	Mollusca	123	1.0799999999999999e-32	NR	NP_001298203.1	6526	g9850	i0	62.1	14.7507163323782	95	34	81.7	2	345	61	99	191	NP_001298203.1 ras-related C3 botulinum toxin substrate 1 [Biomphalaria glabrata]	diamond	5148	123	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
27378408	27378408	PRJNA672101_S_NODE_13823_length_319_cov_5.308943_g13792_i0	PRJNA672101	13823	319	5.308943	16.93552817	Patella	6463	Mollusca	Mollusca	61.2	2.95e-8	NR	XP_050409853.1	6465	g13792	i0	46.3	2.51097178683386	80	36	74.3	2	80	316	376	449	XP_050409853.1 oxysterol-binding protein 1 isoform X2 [Patella vulgata]	diamond	801	61.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
28818311	28818311	PRJNA672101_S_NODE_20608_length_282_cov_9.598086_g20577_i0	PRJNA672101	20608	282	9.598086	27.06660252	Haliotis asinina	109174	Mollusca	Mollusca	43.5	0.0296	NR	XP_067657806.1	109174	g20577	i0	35.4	1.36170212765957	65	36	68.1	2	217	26	144	203	XP_067657806.1 uncharacterized protein [Haliotis asinina]	diamond	384	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
30081586	30081586	PRJNA672101_S_NODE_9312_length_354_cov_4.384342_g9281_i0	PRJNA672101	9312	354	4.384342	15.52057068	Ostrea edulis	37623	Mollusca	Mollusca	104	2.4699999999999994e-23	NR	XP_048766942.2	37623	g9281	i0	51.9	0.898305084745763	106	51	89.8	0	352	35	743	848	XP_048766942.2 major vault protein-like [Ostrea edulis]	diamond	318	104	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Ostrea	Ostrea edulis
31073227	31073227	PRJNA672101_S_NODE_7335_length_374_cov_5.116279_g7304_i0	PRJNA672101	7335	374	5.116279	19.13488346	root	1	Root_unresolved	Root_unresolved	133	9.539999999999999e-34	NR	XP_021361175.1	6573	g7304	i0	52.3	5.98395721925134	128	52	99.5	4	374	3	395	517	XP_021361175.1 putative aminopeptidase W07G4.4 isoform X1 [Mizuhopecten yessoensis]	diamond	2238	133	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
31345781	31345781	PRJNA672101_S_NODE_23136_length_271_cov_3.358586_g23105_i0	PRJNA672101	23136	271	3.358586	9.10176806	Batillaria attramentaria	370345	Mollusca	Mollusca	90.5	8.6e-21	NR	KAK7450082.1	370345	g23105	i0	57.3	2.72324723247232	82	34	90.8	1	3	248	63	143	KAK7450082.1 hypothetical protein BaRGS_00039983 [Batillaria attramentaria]	diamond	738	90.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Batillariidae	Batillaria	Batillaria attramentaria
31788291	31788291	PRJNA672101_S_NODE_25177_length_263_cov_3.352632_g25146_i0	PRJNA672101	25177	263	3.352632	8.81742216	Haliotis asinina	109174	Mollusca	Mollusca	52	2.58e-5	NR	XP_067663859.1	109174	g25146	i0	67.7	0.35361216730038	31	10	35.4	0	249	157	219	249	XP_067663859.1 uncharacterized protein NMB1327-like [Haliotis asinina]	diamond	93	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina

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