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

11 rows where bioproject = "PRJEB81171", 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
6517524	6517524	PRJEB81171_P_NODE_2306_length_437_cov_3.631868_g2180_i0	PRJEB81171	2306	437	3.631868	15.87126316	Solemya velum	13268	Mollusca	Mollusca	176	7.229999999999999e-54	NR	KAL5014429.1	13268	g2180	i0	76.3	9.02059496567506	114	26	77.6	1	12	350	19	132	KAL5014429.1 hypothetical protein ScPMuIL_008699 [Solemya velum]	diamond	3942	176	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
12892908	12892908	PRJEB81171_P_NODE_5391_length_289_cov_1.083333_g5264_i0	PRJEB81171	5391	289	1.083333	3.13083237	Metazoa	33208	Mollusca	Mollusca	184	9.349999999999999e-56	NR	CAG2218263.1	6550	g5264	i0	85.3	11.8339100346021	95	14	98.6	0	287	3	63	157	CAG2218263.1 CTSZ [Mytilus edulis]	diamond	3420	184	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
13750072	13750072	PRJEB81171_P_NODE_6251_length_275_cov_1.287129_g6124_i0	PRJEB81171	6251	275	1.287129	3.53960475	Crassostrea virginica	6565	Mollusca	Mollusca	63.5	2.68e-9	NR	XP_022315151.1	6565	g6124	i0	56.6	2.31272727272727	53	21	57.8	1	116	274	715	765	XP_022315151.1 receptor-type tyrosine-protein phosphatase alpha-like isoform X4 [Crassostrea virginica]	diamond	636	63.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
17990887	17990887	PRJEB81171_P_NODE_1875_length_481_cov_2.982843_g1751_i0	PRJEB81171	1875	481	2.982843	14.34747483	Bivalvia	6544	Mollusca	Mollusca	127	7.009999999999999e-34	NR	NP_001292298.1	29159	g1751	i0	61.9	17.1580041580042	97	37	60.5	0	474	184	1	97	NP_001292298.1 40S ribosomal protein S10-like [Magallana gigas]	diamond	8253	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
23091333	23091333	PRJEB81171_P_NODE_3079_length_375_cov_4.672185_g2952_i0	PRJEB81171	3079	375	4.672185	17.52069375	Potamilus streckersoni	2493646	Mollusca	Mollusca	131	6.709999999999999e-37	NR	KAK3592046.1	2493646	g2952	i0	70.3	2.44	91	24	70.4	1	361	98	1	91	KAK3592046.1 hypothetical protein CHS0354_019301 [Potamilus streckersoni]	diamond	915	131	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Unionida	Unionidae	Potamilus	Potamilus streckersoni
28826839	28826839	PRJEB81171_P_NODE_7208_length_259_cov_2.919355_g7081_i0	PRJEB81171	7208	259	2.919355	7.56112945	Opisthokonta	33154	Mollusca	Mollusca	91.7	9.61e-20	NR	KAL5019610.1	13268	g7081	i0	52.5	5.59459459459459	80	36	92.7	1	12	251	40	117	KAL5019610.1 hypothetical protein ScPMuIL_002502 [Solemya velum]	diamond	1449	91.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Solemyida	Solemyidae	Solemya	Solemya velum
29024185	29024185	PRJEB81171_P_NODE_4488_length_314_cov_1.265560_g4361_i0	PRJEB81171	4488	314	1.26556	3.9738584	Mactra antiquata	2302425	Mollusca	Mollusca	129	4.83e-35	NR	KAL4224502.1	2302425	g4361	i0	63.3	17.6369426751592	98	36	93.6	0	5	298	38	135	KAL4224502.1 ribosomal 40S subunit protein S10A [Mactra antiquata]	diamond	5538	129	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Mactridae	Mactra	Mactra antiquata
29654866	29654866	PRJEB81171_P_NODE_5210_length_292_cov_1.022831_g5083_i0	PRJEB81171	5210	292	1.022831	2.98666652	Bradybaena similaris	145626	Mollusca	Mollusca	43.1	0.0461	NR	BFZ17186.1	145626	g5083	i0	63	0.277397260273973	27	10	27.7	0	50	130	322	348	BFZ17186.1 hypothetical protein BsWGS_20225 [Bradybaena similaris]	diamond	81	43.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
29749705	29749705	PRJEB81171_P_NODE_8431_length_249_cov_1.681818_g8304_i0	PRJEB81171	8431	249	1.681818	4.18772682	Ylistrum balloti	509963	Mollusca	Mollusca	70.1	4.17e-13	NR	XP_060077350.1	509963	g8304	i0	54	6.83132530120482	63	28	74.7	1	60	245	12	74	XP_060077350.1 uncharacterized protein LOC132556910 [Ylistrum balloti]	diamond	1701	70.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
30319182	30319182	PRJEB81171_P_NODE_7912_length_252_cov_0.871508_g7785_i0	PRJEB81171	7912	252	0.871508	2.19620016	Pecten maximus	6579	Mollusca	Mollusca	45.4	0.00491	NR	XP_033729482.1	6579	g7785	i0	53.7	0.976190476190476	41	18	48.8	1	219	97	1121	1160	XP_033729482.1 uncharacterized protein LOC117318627 [Pecten maximus]	diamond	246	45.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Pecten	Pecten maximus
31955027	31955027	PRJEB81171_P_NODE_4377_length_318_cov_1.265306_g4250_i0	PRJEB81171	4377	318	1.265306	4.02367308	Metazoa	33208	Mollusca	Mollusca	100	2.7e-23	NR	XP_064612187.1	13599	g4250	i0	49.5	3.87735849056604	105	42	91.5	3	318	28	122	223	XP_064612187.1 LOW QUALITY PROTEIN: phosphatidylinositol transfer protein alpha isoform-like [Liolophura japonica]	diamond	1233	100	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Polyplacophora	Chitonida	Chitonidae	Liolophura	Liolophura japonica

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