metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA939415" 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
27821970	27821970	PRJNA939415_P_NODE_73164_length_261_cov_1.303191_g72742_i0	PRJNA939415	73164	261	1.303191	3.40132851	Veneridae	6592	Mollusca	Mollusca	124	1.29e-30	NR	XP_053387379.1	6596	g72742	i0	64.7	17.6091954022989	85	30	97.7	0	3	257	545	629	XP_053387379.1 cytoplasmic aconitate hydratase-like isoform X2 [Mercenaria mercenaria]	diamond	4596	124	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
27972724	27972724	PRJNA939415_P_NODE_67125_length_266_cov_4.927461_g66703_i0	PRJNA939415	67125	266	4.927461	13.10704626	Plakobranchus ocellatus	259542	Mollusca	Mollusca	54.3	1.23e-6	NR	GFN96569.1	259542	g66703	i0	47.3	1.22932330827068	55	29	62	0	83	247	61	115	GFN96569.1 reverse transcriptase [Plakobranchus ocellatus]	diamond	327	54.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
28351588	28351588	PRJNA939415_P_NODE_98446_length_237_cov_2.609756_g98024_i0	PRJNA939415	98446	237	2.609756	6.18512172	Patella caerulea	87958	Mollusca	Mollusca	63.9	1.16e-9	NR	KAK6167067.1	87958	g98024	i0	51.8	0.708860759493671	56	26	69.6	1	55	219	160	215	KAK6167067.1 hypothetical protein SNE40_021174 [Patella caerulea]	diamond	168	63.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella caerulea
29708837	29708837	PRJNA939415_P_NODE_41270_length_292_cov_4.598174_g40848_i0	PRJNA939415	41270	292	4.598174	13.42666808	Patella vulgata	6465	Mollusca	Mollusca	45.1	0.0107	NR	XP_050407816.1	6465	g40848	i0	33.9	0.636986301369863	62	35	63.7	1	29	214	1526	1581	XP_050407816.1 uncharacterized protein LOC126823207 [Patella vulgata]	diamond	186	45.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
29968831	29968831	PRJNA939415_P_NODE_34591_length_309_cov_3.783898_g34169_i0	PRJNA939415	34591	309	3.783898	11.69224482	Metazoa	33208	Mollusca	Mollusca	51.6	6.11e-5	NR	RUS77001.1	188477	g34169	i0	37.3	23.9708737864078	75	47	72.8	0	83	307	71	145	RUS77001.1 hypothetical protein EGW08_015226 [Elysia chlorotica]	diamond	7407	51.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia chlorotica
30593681	30593681	PRJNA939415_P_NODE_34353_length_310_cov_1.966245_g33931_i0	PRJNA939415	34353	310	1.966245	6.0953595	Mercenaria mercenaria	6596	Mollusca	Mollusca	59.3	7.54e-8	NR	XP_045191421.1	6596	g33931	i0	82.1	0.551612903225806	28	5	27.1	0	248	165	178	205	XP_045191421.1 uncharacterized protein LOC123548316 isoform X1 [Mercenaria mercenaria]	diamond	171	59.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
31011459	31011459	PRJNA939415_P_NODE_74574_length_259_cov_3.263441_g74152_i0	PRJNA939415	74574	259	3.263441	8.45231219	root	1	Root_unresolved	Root_unresolved	135	1.11e-34	NR	XP_005108363.1	6500	g74152	i0	75.6	40.0888030888031	86	21	99.6	0	1	258	447	532	XP_005108363.1 ribonucleoside-diphosphate reductase large subunit [Aplysia californica]	diamond	10383	135	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
31984868	31984868	PRJNA939415_P_NODE_85158_length_249_cov_2.857955_g84736_i0	PRJNA939415	85158	249	2.857955	7.11630795	Mactra antiquata	2302425	Mollusca	Mollusca	43.1	0.0206	NR	KAL4229756.1	2302425	g84736	i0	68	0.301204819277108	25	8	30.1	0	6	80	30	54	KAL4229756.1 ubiquitin-conjugating enzyme E2 K [Mactra antiquata]	diamond	75	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
32371686	32371686	PRJNA939415_P_NODE_110239_length_205_cov_5.810606_g109817_i0	PRJNA939415	110239	205	5.810606	11.9117423	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.3	0.00496	NR	XP_046354537.1	6454	g109817	i0	42.4	1.77073170731707	66	35	96.6	1	6	203	144	206	XP_046354537.1 60S ribosomal protein L13-like [Haliotis rufescens]	diamond	363	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
32743541	32743541	PRJNA939415_P_NODE_51600_length_282_cov_2.038278_g51178_i0	PRJNA939415	51600	282	2.038278	5.74794396	Mactra antiquata	2302425	Mollusca	Mollusca	48.9	3.99e-4	NR	KAL4235350.1	2302425	g51178	i0	43.1	1.40425531914894	65	36	68.1	1	6	197	548	612	KAL4235350.1 hypothetical protein ACF0H5_006985 [Mactra antiquata]	diamond	396	48.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata

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