metadata: contig_metadata: 14 rows where bioproject = "PRJNA1196438" and tax

14 rows where bioproject = "PRJNA1196438" 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
5426874	5426874	PRJNA1196438_P_NODE_83045_length_227_cov_6.396104_g82618_i0	PRJNA1196438	83045	227	6.396104	14.51915608	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.02	NTclustered	gi\|2913001816\|dbj\|AP039609.1\|	145626	g82618	i0	100	0.123348017621145	28	0	12	0	63	90	48008488	48008461	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
6700872	6700872	PRJNA1196438_P_NODE_3026_length_557_cov_1.723140_g2622_i0	PRJNA1196438	3026	557	1.72314	9.5978898	Ylistrum balloti	509963	Mollusca	Mollusca	420	1.3099999999999998e-112	NTclustered	gi\|2592059858\|ref\|XM_060209328.1\|	509963	g2622	i0	81.569	94.4398563734291	510	92	91	2	26	534	530	22	PREDICTED: Ylistrum balloti actin-2-like (LOC132545630), mRNA	blastn	52603	420	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Ylistrum	Ylistrum balloti
6701275	6701275	PRJNA1196438_P_NODE_62946_length_254_cov_1.585635_g62519_i0	PRJNA1196438	62946	254	1.585635	4.0275129	Haliotis rubra	36100	Mollusca	Mollusca	91.6	4.89e-14	NTclustered	gi\|2194081198\|ref\|XR_006896929.1\|	36100	g62519	i0	94.828	0.228346456692913	58	3	23	0	53	110	2786	2729	PREDICTED: Haliotis rubra uncharacterized LOC124271049 (LOC124271049), ncRNA	blastn	58	91.6	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
18174499	18174499	PRJNA1196438_P_NODE_14835_length_312_cov_4.267782_g14409_i0	PRJNA1196438	14835	312	4.267782	13.31547984	Haliotis rufescens	6454	Mollusca	Mollusca	52.8	0.029	NTclustered	gi\|2245624946\|ref\|XM_048386631.1\|	6454	g14409	i0	96.774	0.496794871794872	31	1	10	0	25	55	10816	10846	PREDICTED: Haliotis rufescens RNA-binding protein 33-like (LOC124145510), transcript variant X1, mRNA	blastn	155	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rufescens
19449367	19449367	PRJNA1196438_P_NODE_58536_length_260_cov_2.336898_g58109_i0	PRJNA1196438	58536	260	2.336898	6.0759348	Pomacea canaliculata	400727	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|1397648266\|ref\|XM_025224619.1\|	400727	g58109	i0	96.97	3.75	33	0	13	1	188	220	881	912	PREDICTED: Pomacea canaliculata calumenin-like (LOC112556018), transcript variant X1, mRNA	blastn	975	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Architaenioglossa	Ampullariidae	Pomacea	Pomacea canaliculata
19449442	19449442	PRJNA1196438_P_NODE_6396_length_399_cov_2.251534_g5974_i0	PRJNA1196438	6396	399	2.251534	8.98362066	Mercenaria mercenaria	6596	Mollusca	Mollusca	52.8	0.038	NTclustered	gi\|2442020962\|ref\|XM_053528760.1\|	6596	g5974	i0	100	0.0701754385964912	28	0	7	0	97	124	1657	1684	PREDICTED: Mercenaria mercenaria uncharacterized LOC123539826 (LOC123539826), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
22000355	22000355	PRJNA1196438_P_NODE_7818_length_370_cov_2.144781_g7396_i0	PRJNA1196438	7818	370	2.144781	7.9356897	Metazoa	33208	Mollusca	Mollusca	216	1.05e-69	NR	XP_022334205.1	6565	g7396	i0	82.1	13.9297297297297	123	22	99.7	0	369	1	41	163	XP_022334205.1 peptidyl-prolyl cis-trans isomerase-like [Crassostrea virginica]	diamond	5154	218	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
23275658	23275658	PRJNA1196438_P_NODE_6639_length_393_cov_3.021875_g6217_i0	PRJNA1196438	6639	393	3.021875	11.87596875	Mya arenaria	6604	Mollusca	Mollusca	54.7	0.01	NTclustered	gi\|2427467042\|ref\|XM_052939866.1\|	6604	g6217	i0	100	0.147582697201018	29	0	7	0	255	283	938	966	PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Myidae	Mya	Mya arenaria
27376209	27376209	PRJNA1196438_P_NODE_19303_length_312_cov_3.129707_g18877_i0	PRJNA1196438	19303	312	3.129707	9.76468584	Mollusca	6447	Mollusca	Mollusca	43.9	0.0284	NR	CAG2190094.1	6550	g18877	i0	41.5	0.730769230769231	41	24	39.4	0	3	125	102	142	CAG2190094.1 unnamed protein product [Mytilus edulis]	diamond	228	43.9	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus edulis
27755068	27755068	PRJNA1196438_P_NODE_48984_length_275_cov_1.306931_g48557_i0	PRJNA1196438	48984	275	1.306931	3.59406025	Opisthokonta	33154	Mollusca	Mollusca	119	7.039999999999999e-32	NR	XP_011427026.1	29159	g48557	i0	71.4	31.8763636363636	84	24	91.6	0	254	3	8	91	XP_011427026.1 calmodulin [Magallana gigas]	diamond	8766	119	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
29188525	29188525	PRJNA1196438_P_NODE_84529_length_220_cov_4.789116_g84101_i0	PRJNA1196438	84529	220	4.789116	10.5360552	Plakobranchus ocellatus	259542	Mollusca	Mollusca	44.7	0.006	NR	GFO29940.1	259542	g84101	i0	54.8	2.00454545454545	31	14	42.3	0	142	50	501	531	GFO29940.1 Zinc finger protein [Plakobranchus ocellatus]	diamond	441	44.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Plakobranchus	Plakobranchus ocellatus
30186128	30186128	PRJNA1196438_P_NODE_10992_length_322_cov_1.132530_g10566_i0	PRJNA1196438	10992	322	1.13253	3.6467466	Metazoa	33208	Mollusca	Mollusca	133	2.9699999999999993e-34	NR	XP_053383287.1	6596	g10566	i0	61.7	27.0186335403727	107	40	98.8	1	320	3	378	484	XP_053383287.1 dihydrolipoyllysine-residue acetyltransferase component of pyruvate dehydrogenase complex, mitochondrial-like [Mercenaria mercenaria]	diamond	8700	134	0.992537313432836	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Mercenaria	Mercenaria mercenaria
30451841	30451841	PRJNA1196438_P_NODE_12353_length_312_cov_8.882845_g11927_i0	PRJNA1196438	12353	312	8.882845	27.7144764	Elysia crispata	231223	Mollusca	Mollusca	43.5	0.0428	NR	KAK3796143.1	231223	g11927	i0	48.8	0.394230769230769	41	21	39.4	0	284	162	162	202	KAK3796143.1 hypothetical protein RRG08_018144 [Elysia crispata]	diamond	123	43.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia crispata
30672641	30672641	PRJNA1196438_P_NODE_26813_length_301_cov_5.293860_g26387_i0	PRJNA1196438	26813	301	5.29386	15.9345186	Elysia marginata	1093978	Mollusca	Mollusca	44.3	0.022	NR	GFR78263.1	1093978	g26387	i0	37.3	0.667774086378738	67	39	66.8	1	97	297	518	581	GFR78263.1 ankyrin [Elysia marginata]	diamond	201	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Plakobranchidae	Elysia	Elysia marginata

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