metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
647609	647609	PRJNA675331_P_NODE_10561_length_308_cov_1.302128_g10389_i0	PRJNA675331	10561	308	1.302128	4.01055424	Magallana gigas	29159	Mollusca	Mollusca	237	7.39e-58	NTclustered	gi\|2751308838\|ref\|XM_034474057.2\|	29159	g10389	i0	80.519	12.8149350649351	308	60	100	0	1	308	788	1095	PREDICTED: Magallana gigas V-type proton ATPase subunit B (LOC105328999), mRNA	blastn	3947	237	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Magallana	Magallana gigas
1923898	1923898	PRJNA675331_P_NODE_3382_length_508_cov_2.326437_g3212_i0	PRJNA675331	3382	508	2.326437	11.81829996	Placida dendritica	71497	Mollusca	Mollusca	115	6.2500000000000006e-21	NTclustered	gi\|969822382\|gb\|KT950958.1\|	71497	g3212	i0	93.506	13.003937007874	77	5	15	0	1	77	272	348	Placida dendritica isolate PdContig22473 actin mRNA, partial cds	blastn	6606	115	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Limapontiidae	Placida	Placida dendritica
6272475	6272475	PRJNA675331_P_NODE_22185_length_244_cov_0.900585_g22013_i0	PRJNA675331	22185	244	0.900585	2.1974274	Metazoa	33208	Mollusca	Mollusca	52.8	0.022	NTclustered	gi\|2912988862\|dbj\|AP039593.1\|	145626	g22013	i0	96.875	0.245901639344262	32	0	13	1	127	158	52545509	52545539	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence	blastn	60	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
9576300	9576300	PRJNA675331_P_NODE_14908_length_272_cov_1.110553_g14736_i0	PRJNA675331	14908	272	1.110553	3.02070416	Saccostrea cuccullata	36930	Mollusca	Mollusca	52.8	0.025	NTclustered	gi\|2669155244\|ref\|XM_062754907.1\|	36930	g14736	i0	100	0.102941176470588	28	0	10	0	90	117	1225	1252	PREDICTED: Saccostrea cucullata MFS-type transporter SLC18B1-like (LOC134272701), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea cuccullata
10851813	10851813	PRJNA675331_P_NODE_6669_length_375_cov_0.754967_g6497_i0	PRJNA675331	6669	375	0.754967	2.83112625	Physella acuta	109671	Mollusca	Mollusca	375	1.86e-99	NTclustered	gi\|2572435431\|ref\|XM_059286265.1\|	109671	g6497	i0	86.246	87.4	349	45	93	3	1	347	481	134	PREDICTED: Physella acuta tubulin alpha-1A chain-like (LOC131929887), mRNA	blastn	32775	375	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
13401813	13401813	PRJNA675331_P_NODE_14811_length_272_cov_2.216080_g14639_i0	PRJNA675331	14811	272	2.21608	6.0277376	Paralepetopsis sp. SWA-2009	702832	Mollusca	Mollusca	193	1.41e-44	NTclustered	gi\|290751121\|gb\|FJ977808.1\|	702832	g14639	i0	82.648	64.9852941176471	219	36	80	2	11	228	7	224	Paralepetopsis sp. SWA-2009 voucher MCZ:Mala:378647 myosin heavy chain type II gene, partial cds	blastn	17676	193	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Neolepetopsidae	Paralepetopsis	Paralepetopsis sp. SWA-2009
14676795	14676795	PRJNA675331_P_NODE_12852_length_285_cov_0.985849_g12680_i0	PRJNA675331	12852	285	0.985849	2.80966965	Haliotis rubra	36100	Mollusca	Mollusca	60.2	1.57e-4	NTclustered	gi\|2194140883\|ref\|XM_046726467.1\|	36100	g12680	i0	94.737	0.76140350877193	38	2	13	0	119	156	182	145	PREDICTED: Haliotis rubra prostatic spermine-binding protein-like (LOC124289800), mRNA	blastn	217	60.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis rubra
15950483	15950483	PRJNA675331_P_NODE_16173_length_263_cov_2.431579_g16001_i0	PRJNA675331	16173	263	2.431579	6.39505277	Saccostrea echinata	191078	Mollusca	Mollusca	195	3.77e-45	NTclustered	gi\|2628600388\|ref\|XM_061310142.1\|	191078	g16001	i0	80.153	20.0380228136882	262	50	99	2	1	261	430	170	PREDICTED: Saccostrea echinata large ribosomal subunit protein uL16-like (LOC133175045), mRNA	blastn	5270	195	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Ostreida	Ostreidae	Saccostrea	Saccostrea echinata
18500078	18500078	PRJNA675331_P_NODE_835_length_972_cov_1.837597_g709_i0	PRJNA675331	835	972	1.837597	17.86144284	Haliotis asinina	109174	Mollusca	Mollusca	143	5.68e-29	NTclustered	gi\|2793396688\|ref\|XM_067810295.1\|	109174	g709	i0	73.35	6.61213991769547	409	100	42	9	235	638	1117	713	PREDICTED: Haliotis asinina tropomyosin (LOC137278132), transcript variant X12, mRNA	blastn	6427	143	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Lepetellida	Haliotidae	Haliotis	Haliotis asinina
21570691	21570691	PRJNA675331_P_NODE_12117_length_291_cov_1.412844_g11945_i0	PRJNA675331	12117	291	1.412844	4.11137604	Metazoa	33208	Mollusca	Mollusca	52.8	0.027	NTclustered	gi\|1897939493\|ref\|XM_013088196.2\|	6500	g11945	i0	100	0.673539518900344	28	0	10	0	228	255	2470	2443	PREDICTED: Aplysia californica uncharacterized LOC106013173 (LOC106013173), mRNA	blastn	196	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
21570718	21570718	PRJNA675331_P_NODE_8277_length_340_cov_1.722846_g8105_i0	PRJNA675331	8277	340	1.722846	5.8576764	Octopus	6643	Mollusca	Mollusca	73.1	2.47e-8	NTclustered	gi\|2427226720\|ref\|XM_014927986.2\|	37653	g8105	i0	78.899	0.641176470588235	109	21	32	2	1	108	358	465	PREDICTED: Octopus bimaculoides dynein light chain Tctex-type 1 (LOC106878696), mRNA	blastn	218	73.1	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Cephalopoda	Octopoda	Octopodidae	Octopus	Octopus bimaculoides

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