metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1166865" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
2864368	2864368	PRJNA1166865_P_NODE_70123_length_262_cov_1.629630_g69882_i0	PRJNA1166865	70123	262	1.62963	4.2696306	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.024	NTclustered	gi\|2912997258\|dbj\|AP039602.1\|	145626	g69882	i0	100	0.961832061068702	28	0	11	0	78	105	34843254	34843227	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence	blastn	252	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
7967306	7967306	PRJNA1166865_P_NODE_89527_length_244_cov_0.900585_g89286_i0	PRJNA1166865	89527	244	0.900585	2.1974274	Aplysia californica	6500	Mollusca	Mollusca	60.2	1.32e-4	NTclustered	gi\|1897930882\|ref\|XM_013084885.2\|	6500	g89286	i0	94.737	0.467213114754098	38	2	16	0	47	84	581	618	PREDICTED: Aplysia californica ras-like GTP-binding protein Rho1 (LOC101856971), transcript variant X3, mRNA	blastn	114	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
9240575	9240575	PRJNA1166865_P_NODE_33508_length_373_cov_4.050000_g33267_i0	PRJNA1166865	33508	373	4.05	15.1065	Haliotis asinina	109174	Mollusca	Mollusca	52.8	0.035	NTclustered	gi\|2793383640\|ref\|XM_067803051.1\|	109174	g33267	i0	100	0.0750670241286863	28	0	8	0	98	125	809	782	PREDICTED: Haliotis asinina potassium voltage-gated channel protein Shaw-like (LOC137268485), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
9240698	9240698	PRJNA1166865_P_NODE_38228_length_351_cov_6.420863_g37987_i0	PRJNA1166865	38228	351	6.420863	22.53722913	Biomphalaria glabrata	6526	Mollusca	Mollusca	204	8.65e-48	NTclustered	gi\|2502109311\|ref\|XM_013241081.2\|	6526	g37987	i0	87.5	40.1595441595442	176	22	50	0	142	317	302	127	PREDICTED: Biomphalaria glabrata 60S ribosomal protein L27a-like (LOC106079852), mRNA	blastn	14096	204	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
9241821	9241821	PRJNA1166865_P_NODE_83968_length_247_cov_0.885057_g83727_i0	PRJNA1166865	83968	247	0.885057	2.18609079	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2912988862\|dbj\|AP039593.1\|	145626	g83727	i0	100	0.11336032388664	28	0	11	0	210	237	45142035	45142008	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11242837	11242837	PRJNA1166865_P_NODE_23089_length_447_cov_2.093583_g22848_i0	PRJNA1166865	23089	447	2.093583	9.35831601	Metazoa	33208	Mollusca	Mollusca	821	0	NTclustered	gi\|1928112764\|gb\|MT947788.1\|	6523	g22848	i0	99.776	99.8568232662192	447	1	100	0	1	447	91	537	Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds	blastn	44636	826	0.993946731234867	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
16889159	16889159	PRJNA1166865_P_NODE_10214_length_664_cov_2.225042_g9986_i0	PRJNA1166865	10214	664	2.225042	14.77427888	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	0.001	NTclustered	gi\|2912995509\|dbj\|AP039600.1\|	145626	g9986	i0	100	0.0466867469879518	31	0	5	0	280	310	64398506	64398476	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence	blastn	31	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
16890451	16890451	PRJNA1166865_P_NODE_61594_length_282_cov_1.349282_g61353_i0	PRJNA1166865	61594	282	1.349282	3.80497524	Haliotis rufescens	6454	Mollusca	Mollusca	82.4	3.32e-11	NTclustered	gi\|2245640163\|ref\|XM_046489965.2\|	6454	g61353	i0	87.671	1.14893617021277	73	6	25	1	18	87	487	559	PREDICTED: Haliotis rufescens mediator of RNA polymerase II transcription subunit 15-like (LOC124126508), mRNA	blastn	324	82.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
18164986	18164986	PRJNA1166865_P_NODE_60975_length_283_cov_1.833333_g60734_i0	PRJNA1166865	60975	283	1.833333	5.18833239	Haliotis cracherodii	6455	Mollusca	Mollusca	150	8.999999999999999e-32	NTclustered	gi\|2911810121\|ref\|XM_071238133.1\|	6455	g60734	i0	78.279	7.45229681978799	244	45	85	6	2	241	321	560	PREDICTED: Haliotis cracherodii large ribosomal subunit protein uL23-like (LOC139456427), mRNA	blastn	2109	150	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis cracherodii
19439069	19439069	PRJNA1166865_P_NODE_50996_length_309_cov_1.305085_g50755_i0	PRJNA1166865	50996	309	1.305085	4.03271265	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.008	NTclustered	gi\|2912991694\|dbj\|AP039596.1\|	145626	g50755	i0	100	0.184466019417476	29	0	9	0	144	172	27680836	27680808	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence	blastn	57	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19439783	19439783	PRJNA1166865_P_NODE_81116_length_248_cov_0.880000_g80875_i0	PRJNA1166865	81116	248	0.88	2.1824	Ylistrum balloti	509963	Mollusca	Mollusca	202	2.0999999999999998e-47	NTclustered	gi\|2592059352\|ref\|XM_060209051.1\|	509963	g80875	i0	82.819	15.375	227	37	91	2	1	226	236	11	PREDICTED: Ylistrum balloti dynein light chain LC6, flagellar outer arm (LOC132545371), mRNA	blastn	3813	202	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
21989763	21989763	PRJNA1166865_P_NODE_49438_length_313_cov_3.841667_g49197_i0	PRJNA1166865	49438	313	3.841667	12.02441771	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	185	2.7699999999999994e-42	NTclustered	gi\|1207980183\|ref\|XM_021483941.1\|	6573	g49197	i0	79.004	1.02875399361022	281	52	88	5	2	277	303	25	PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L3-B-like (LOC110440810), mRNA	blastn	322	185	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
24539616	24539616	PRJNA1166865_P_NODE_74700_length_251_cov_1.730337_g74459_i0	PRJNA1166865	74700	251	1.730337	4.34314587	Bradybaena similaris	145626	Mollusca	Mollusca	65.8	2.92e-6	NTclustered	gi\|2912999747\|dbj\|AP039606.1\|	145626	g74459	i0	100	13.1713147410359	35	0	14	0	217	251	9333315	9333281	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence	blastn	3306	65.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris

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