metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA385073" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA385073" 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
20807929	20807929	PRJNA385073_P_NODE_54057_length_244_cov_0.900585_g53895_i0	PRJNA385073	54057	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87	5.12e-19	NR	XP_052092744.1	6549	g53895	i0	65.6	5.1516393442623	61	21	75	0	183	1	11	71	XP_052092744.1 40S ribosomal protein S5 [Mytilus californianus]	diamond	1257	87.4	0.995423340961098	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
27123349	27123349	PRJNA385073_P_NODE_53922_length_244_cov_0.900585_g53760_i0	PRJNA385073	53922	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.8	1.22e-8	NR	KAJ8309578.1	220873	g53760	i0	51.6	3.29508196721311	62	22	76.2	1	58	243	75	128	KAJ8309578.1 hypothetical protein KUTeg_014452 [Tegillarca granosa]	diamond	804	61.2	0.993464052287582	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Arcoida	Arcidae	Tegillarca	Tegillarca granosa
27675712	27675712	PRJNA385073_P_NODE_60104_length_238_cov_2.484848_g59942_i0	PRJNA385073	60104	238	2.484848	5.91393824	Gigantopelta aegis	1735272	Mollusca	Mollusca	46.2	0.00207	NR	XP_041356789.1	1735272	g59942	i0	34.8	0.869747899159664	69	44	87	1	209	3	783	850	XP_041356789.1 zinc finger protein 493-like [Gigantopelta aegis]	diamond	207	46.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
28180406	28180406	PRJNA385073_P_NODE_40546_length_252_cov_2.558659_g40384_i0	PRJNA385073	40546	252	2.558659	6.44782068	Elysia marginata	1093978	Mollusca	Mollusca	63.5	1.98e-9	NR	GFS05764.1	1093978	g40384	i0	41	2.96428571428571	83	47	98.8	1	4	252	357	437	GFS05764.1 reverse transcriptase [Elysia marginata]	diamond	747	63.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata
31324340	31324340	PRJNA385073_P_NODE_46495_length_248_cov_0.880000_g46333_i0	PRJNA385073	46495	248	0.88	2.1824	Metazoa	33208	Mollusca	Mollusca	111	1.89e-26	NR	XP_060580391.1	129788	g46333	i0	75.4	4.69354838709677	65	16	78.6	0	197	3	1	65	XP_060580391.1 serine--tRNA ligase, cytoplasmic-like [Ruditapes philippinarum]	diamond	1164	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
31908501	31908501	PRJNA385073_P_NODE_53637_length_244_cov_0.900585_g53475_i0	PRJNA385073	53637	244	0.900585	2.1974274	Littorina saxatilis	31220	Mollusca	Mollusca	58.9	7.21e-8	NR	XP_070180729.1	31220	g53475	i0	66.7	1.65983606557377	48	16	59	0	144	1	5	52	XP_070180729.1 26S proteasome regulatory subunit 10B [Littorina saxatilis]	diamond	405	58.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
31956938	31956938	PRJNA385073_P_NODE_51277_length_245_cov_1.098837_g51115_i0	PRJNA385073	51277	245	1.098837	2.69215065	Metazoa	33208	Mollusca	Mollusca	165	1.71e-45	NR	CAG2248152.1	6550	g51115	i0	100	112.077551020408	81	0	99.2	0	243	1	538	618	CAG2248152.1 PSMC2 [Mytilus edulis]	diamond	27459	165	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
32558471	32558471	PRJNA385073_P_NODE_2139_length_758_cov_3.010219_g2000_i0	PRJNA385073	2139	758	3.010219	22.81746002	Metazoa	33208	Mollusca	Mollusca	196	1.3199999999999998e-57	NR	XP_014770628.1	37653	g2000	i0	51.9	4.36939313984169	183	82	72.4	2	16	564	158	334	XP_014770628.1 procathepsin L [Octopus bimaculoides]	diamond	3312	196	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides

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