metadata: contig_metadata: 25 rows where bioproject = "PRJNA1074407" and tax

25 rows where bioproject = "PRJNA1074407" 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
10391521	10391521	PRJNA1074407_P_NODE_111789_length_310_cov_1.282700_g107951_i0	PRJNA1074407	111789	310	1.2827	3.97637	Dreissena polymorpha	45954	Mollusca	Mollusca	65.8	3.72e-6	NTclustered	gi\|2364439800\|ref\|XM_052421432.1\|	45954	g107951	i0	95.122	1.79354838709677	41	2	13	0	60	100	82	122	PREDICTED: Dreissena polymorpha uncharacterized transmembrane protein DDB_G0285607-like (LOC127876301), mRNA	blastn	556	65.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
11669344	11669344	PRJNA1074407_P_NODE_85050_length_409_cov_1.127976_g81214_i0	PRJNA1074407	85050	409	1.127976	4.61342184	Mytilus californianus	6549	Mollusca	Mollusca	52.8	0.039	NTclustered	gi\|2334748714\|ref\|XM_052206278.1\|	6549	g81214	i0	100	0.0684596577017115	28	0	7	0	10	37	1735	1762	PREDICTED: Mytilus californianus charged multivesicular body protein 4b-like (LOC127702171), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Mytilida	Mytilidae	Mytilus	Mytilus californianus
12941888	12941888	PRJNA1074407_P_NODE_107151_length_324_cov_1.864542_g103313_i0	PRJNA1074407	107151	324	1.864542	6.04111608	Littorina saxatilis	31220	Mollusca	Mollusca	211	4.74e-50	NTclustered	gi\|2868681933\|ref\|XM_070325520.1\|	31220	g103313	i0	80.935	31.608024691358	278	43	84	10	36	308	8901	9173	PREDICTED: Littorina saxatilis cytoplasmic dynein 1 heavy chain 1-like (LOC138953643), transcript variant X2, mRNA	blastn	10241	211	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
12942131	12942131	PRJNA1074407_P_NODE_119571_length_288_cov_1.897674_g115733_i0	PRJNA1074407	119571	288	1.897674	5.46530112	Metazoa	33208	Mollusca	Mollusca	96.7	7.54e-21	NR	XP_013087830.2	6526	g115733	i0	86	18.5416666666667	50	7	52.1	0	288	139	275	324	XP_013087830.2 2-oxoglutarate dehydrogenase complex component E1-like isoform X2 [Biomphalaria glabrata]	diamond	5340	97.4	0.992813141683778	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata
15490992	15490992	PRJNA1074407_P_NODE_115933_length_298_cov_1.466667_g112095_i0	PRJNA1074407	115933	298	1.466667	4.37066766	Bradybaena similaris	145626	Mollusca	Mollusca	60.2	1.66e-4	NTclustered	gi\|2912991694\|dbj\|AP039596.1\|	145626	g112095	i0	92.857	7.7986577181208	42	2	14	1	15	55	45596136	45596177	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence	blastn	2324	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
16767423	16767423	PRJNA1074407_P_NODE_75214_length_459_cov_1.240933_g71379_i0	PRJNA1074407	75214	459	1.240933	5.69588247	Littorina saxatilis	31220	Mollusca	Mollusca	182	5.44e-41	NTclustered	gi\|2868688207\|ref\|XM_070347684.1\|	31220	g71379	i0	88.158	25.0936819172113	152	18	33	0	3	154	677	828	PREDICTED: Littorina saxatilis protein yippee-like 1 (LOC138975036), transcript variant X1, mRNA	blastn	11518	182	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
18040993	18040993	PRJNA1074407_P_NODE_28735_length_1082_cov_2.685828_g25748_i0	PRJNA1074407	28735	1082	2.685828	29.06065896	Mya arenaria	6604	Mollusca	Mollusca	54.7	0.031	NTclustered	gi\|2427467042\|ref\|XM_052939866.1\|	6604	g25748	i0	100	0.0536044362292052	29	0	3	0	620	648	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
18041716	18041716	PRJNA1074407_P_NODE_56775_length_602_cov_2.158790_g52974_i0	PRJNA1074407	56775	602	2.15879	12.9959158	Bradybaena similaris	145626	Mollusca	Mollusca	56.5	0.005	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g52974	i0	97.059	0.0564784053156146	34	0	5	1	488	520	10695198	10695165	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	34	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
19314074	19314074	PRJNA1074407_P_NODE_118416_length_291_cov_2.591743_g114578_i0	PRJNA1074407	118416	291	2.591743	7.54197213	Crassostrea virginica	6565	Mollusca	Mollusca	75	5.75e-9	NTclustered	gi\|1242790991\|ref\|XM_022479981.1\|	6565	g114578	i0	81.053	0.326460481099656	95	17	32	1	197	290	659	565	PREDICTED: Crassostrea virginica homeobox protein caupolican-like (LOC111132203), mRNA	blastn	95	75	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
23140447	23140447	PRJNA1074407_P_NODE_107459_length_323_cov_2.064000_g103621_i0	PRJNA1074407	107459	323	2.064	6.66672	Octopus bimaculoides	37653	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2427234852\|ref\|XM_052966633.1\|	37653	g103621	i0	90.698	0.532507739938081	43	3	13	1	172	214	8354	8313	PREDICTED: Octopus bimaculoides semaphorin-1A (LOC106872300), transcript variant X4, mRNA	blastn	172	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
23141152	23141152	PRJNA1074407_P_NODE_145639_length_240_cov_1.449102_g141801_i0	PRJNA1074407	145639	240	1.449102	3.4778448	Ruditapes philippinarum	129788	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2616645869\|ref\|XM_060741898.1\|	129788	g141801	i0	100	0.116666666666667	28	0	12	0	181	208	3491	3464	PREDICTED: Ruditapes philippinarum uncharacterized LOC132751680 (LOC132751680), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Venerida	Veneridae	Ruditapes	Ruditapes philippinarum
23142910	23142910	PRJNA1074407_P_NODE_84239_length_412_cov_2.227139_g80403_i0	PRJNA1074407	84239	412	2.227139	9.17581268	Octopus bimaculoides	37653	Mollusca	Mollusca	52.8	0.04	NTclustered	gi\|2427271833\|ref\|XM_014921945.2\|	37653	g80403	i0	100	0.0679611650485437	28	0	7	0	46	73	195	222	PREDICTED: Octopus bimaculoides coiled-coil domain-containing protein 125 (LOC106874275), transcript variant X1, mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides
24416461	24416461	PRJNA1074407_P_NODE_79260_length_436_cov_9.195592_g75424_i0	PRJNA1074407	79260	436	9.195592	40.09278112	Mollusca environmental sample	653389	Mollusca	Mollusca	329	1.74e-85	NTclustered	gi\|156254524\|gb\|EF528299.1\|	653389	g75424	i0	91.597	54.3394495412844	238	20	55	0	199	436	761	998	Uncultured mollusc isolate XenLSU7 28S ribosomal RNA gene, partial sequence	blastn	23692	329	1	Eukaryota	Opisthokonta	Metazoa	Mollusca					Mollusca environmental sample
27098984	27098984	PRJNA1074407_P_NODE_113262_length_306_cov_0.978541_g109424_i0	PRJNA1074407	113262	306	0.978541	2.99433546	Lottia gigantea	225164	Mollusca	Mollusca	69.7	2.6e-11	NR	XP_009052976.1	225164	g109424	i0	66	3.12745098039216	50	17	49	0	5	154	697	746	XP_009052976.1 hypothetical protein LOTGIDRAFT_227052 [Lottia gigantea]	diamond	957	69.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
27478206	27478206	PRJNA1074407_P_NODE_146123_length_240_cov_0.910180_g142285_i0	PRJNA1074407	146123	240	0.91018	2.184432	Haliotis rubra	36100	Mollusca	Mollusca	52	1.93e-5	NR	XP_046573907.1	36100	g142285	i0	52.6	1.5125	57	27	71.3	0	29	199	22	78	XP_046573907.1 toll-like receptor 4 [Haliotis rubra]	diamond	363	52	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
27478214	27478214	PRJNA1074407_P_NODE_43563_length_773_cov_6.861429_g39957_i0	PRJNA1074407	43563	773	6.861429	53.03884617	Magallana gigas	29159	Mollusca	Mollusca	192	5.09e-58	NR	XP_034312381.1	29159	g39957	i0	59	6.86934023285899	156	63	60.2	1	46	510	11	166	XP_034312381.1 glutathione peroxidase-like isoform X4 [Magallana gigas]	diamond	5310	192	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
28835855	28835855	PRJNA1074407_P_NODE_110548_length_314_cov_1.116183_g106710_i0	PRJNA1074407	110548	314	1.116183	3.50481462	Haliotis asinina	109174	Mollusca	Mollusca	74.7	5.31e-13	NR	XP_067663404.1	109174	g106710	i0	50	4.31847133757962	84	40	80.3	1	6	257	1491	1572	XP_067663404.1 transcriptional regulator ATRX homolog isoform X1 [Haliotis asinina]	diamond	1356	74.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
28930691	28930691	PRJNA1074407_P_NODE_138228_length_247_cov_0.873563_g134390_i0	PRJNA1074407	138228	247	0.873563	2.15770061	Dreissena polymorpha	45954	Mollusca	Mollusca	57.8	1.97e-7	NR	XP_052249385.1	45954	g134390	i0	50	1.71255060728745	48	24	58.3	0	243	100	467	514	XP_052249385.1 dual specificity tyrosine-phosphorylation-regulated kinase 2-like [Dreissena polymorpha]	diamond	423	57.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Myida	Dreissenidae	Dreissena	Dreissena polymorpha
29206500	29206500	PRJNA1074407_P_NODE_135609_length_249_cov_0.863636_g131771_i0	PRJNA1074407	135609	249	0.863636	2.15045364	Mollusca	6447	Mollusca	Mollusca	58.5	1.02e-7	NR	CAG5116547.1	100452	g131771	i0	56	3.79518072289157	50	19	56.6	1	241	101	97	146	CAG5116547.1 unnamed protein product [Candidula unifasciata]	diamond	945	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Geomitridae	Candidula	Candidula unifasciata
29561958	29561958	PRJNA1074407_P_NODE_100550_length_346_cov_1.391941_g96712_i0	PRJNA1074407	100550	346	1.391941	4.81611586	Lymnaea stagnalis	6523	Mollusca	Mollusca	44.3	0.0332	NR	CAL1538401.1	6523	g96712	i0	35	0.893063583815029	103	54	80.6	2	282	4	252	351	CAL1538401.1 unnamed protein product [Lymnaea stagnalis]	diamond	309	44.3	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis
30216790	30216790	PRJNA1074407_P_NODE_143472_length_242_cov_1.171598_g139634_i0	PRJNA1074407	143472	242	1.171598	2.83526716	Metazoa	33208	Mollusca	Mollusca	47.8	6.41e-4	NR	XP_022308208.1	6565	g139634	i0	37.5	5.55371900826446	80	41	96.7	3	237	4	853	925	XP_022308208.1 coatomer subunit alpha-like isoform X1 [Crassostrea virginica]	diamond	1344	47.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Crassostrea	Crassostrea virginica
30320726	30320726	PRJNA1074407_P_NODE_66172_length_518_cov_1.705618_g62346_i0	PRJNA1074407	66172	518	1.705618	8.83510124	Physella acuta	109671	Mollusca	Mollusca	206	1.03e-60	NR	XP_059178145.1	109671	g62346	i0	54.7	4.98069498069498	172	77	99.6	1	1	516	253	423	XP_059178145.1 aarF domain-containing protein kinase 1-like [Physella acuta]	diamond	2580	206	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
30564136	30564136	PRJNA1074407_P_NODE_143233_length_242_cov_1.763314_g139395_i0	PRJNA1074407	143233	242	1.763314	4.26721988	Ostreidae	6563	Mollusca	Mollusca	85.9	2.4e-17	NR	XP_034299132.2	29159	g139395	i0	52.5	4.61157024793388	80	38	99.2	0	242	3	88	167	XP_034299132.2 exosome complex exonuclease RRP44 [Magallana gigas]	diamond	1116	86.7	0.990772779700115	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
30627464	30627464	PRJNA1074407_P_NODE_113633_length_305_cov_0.982759_g109795_i0	PRJNA1074407	113633	305	0.982759	2.99741495	Metazoa	33208	Mollusca	Mollusca	118	8.01e-30	NR	XP_070180684.1	31220	g109795	i0	66.7	2.64590163934426	90	30	88.5	0	304	35	235	324	XP_070180684.1 stress-induced-phosphoprotein 1-like isoform X2 [Littorina saxatilis]	diamond	807	118	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Littorinimorpha	Littorinidae	Littorina	Littorina saxatilis
32366992	32366992	PRJNA1074407_P_NODE_112599_length_308_cov_0.970213_g108761_i0	PRJNA1074407	112599	308	0.970213	2.98825604	Metazoa	33208	Mollusca	Mollusca	108	5.07e-26	NR	CAL1530741.1	6523	g108761	i0	57.4	2.97077922077922	101	42	98.4	1	3	305	104	203	CAL1530741.1 unnamed protein product [Lymnaea stagnalis]	diamond	915	109	0.990825688073395	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lymnaeidae	Lymnaea	Lymnaea stagnalis

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