metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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
2879905	2879905	PRJNA1204310_P_NODE_27723_length_351_cov_3.820144_g27426_i0	PRJNA1204310	27723	351	3.820144	13.40870544	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.033	NTclustered	gi\|2912996298\|dbj\|AP039601.1\|	145626	g27426	i0	100	0.0797720797720798	28	0	8	0	96	123	42811777	42811750	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
2880249	2880249	PRJNA1204310_P_NODE_42323_length_285_cov_1.353774_g42026_i0	PRJNA1204310	42323	285	1.353774	3.8582559	Physella acuta	109671	Mollusca	Mollusca	152	2.52e-32	NTclustered	gi\|2572415817\|ref\|XM_059321795.1\|	109671	g42026	i0	86.331	49.0877192982456	139	19	49	0	1	139	1765	1627	PREDICTED: Physella acuta myosin heavy chain, striated muscle-like (LOC131957096), transcript variant X11, mRNA	blastn	13990	152	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta
5432614	5432614	PRJNA1204310_P_NODE_45285_length_274_cov_1.552239_g44988_i0	PRJNA1204310	45285	274	1.552239	4.25313486	Patella vulgata	6465	Mollusca	Mollusca	58.4	5.41e-4	NTclustered	gi\|2506334046\|ref\|XM_050552151.2\|	6465	g44988	i0	97.059	0.124087591240876	34	1	12	0	10	43	387	420	PREDICTED: Patella vulgata protein PFC0760c (LOC126823359), mRNA	blastn	34	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Patellidae	Patella	Patella vulgata
11248371	11248371	PRJNA1204310_P_NODE_44689_length_276_cov_2.290640_g44392_i0	PRJNA1204310	44689	276	2.29064	6.3221664	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|2912986657\|dbj\|AP039591.1\|	145626	g44392	i0	100	0.210144927536232	29	0	11	0	4	32	19099794	19099822	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11807278	11807278	PRJNA1204310_P_NODE_14590_length_464_cov_4.102302_g14293_i0	PRJNA1204310	14590	464	4.102302	19.03468128	Bradybaena similaris	145626	Mollusca	Mollusca	54.7	0.013	NTclustered	gi\|2912987826\|dbj\|AP039592.1\|	145626	g14293	i0	92.308	0.144396551724138	39	1	8	2	119	156	35823029	35822992	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence	blastn	67	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
13083198	13083198	PRJNA1204310_P_NODE_51471_length_253_cov_0.866667_g51174_i0	PRJNA1204310	51471	253	0.866667	2.19266751	Gigantopelta aegis	1735272	Mollusca	Mollusca	100	8.08e-17	NTclustered	gi\|2034316249\|ref\|XM_041499828.1\|	1735272	g51174	i0	81.818	2.94861660079051	121	20	47	2	106	225	850	731	PREDICTED: Gigantopelta aegis collagen alpha-5(IV) chain-like (LOC121373292), transcript variant X1, mRNA	blastn	746	100	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Neomphalida	Peltospiridae	Gigantopelta	Gigantopelta aegis
16906519	16906519	PRJNA1204310_P_NODE_43374_length_281_cov_1.725962_g43077_i0	PRJNA1204310	43374	281	1.725962	4.84995322	Mizuhopecten yessoensis	6573	Mollusca	Mollusca	54.7	0.007	NTclustered	gi\|1207908107\|ref\|XM_021504756.1\|	6573	g43077	i0	100	0.615658362989324	29	0	10	0	115	143	1602	1630	PREDICTED: Mizuhopecten yessoensis serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit B-like (LOC110454921), transcript variant X3, mRNA	blastn	173	54.7	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Mizuhopecten	Mizuhopecten yessoensis
18181035	18181035	PRJNA1204310_P_NODE_47175_length_267_cov_1.376289_g46878_i0	PRJNA1204310	47175	267	1.376289	3.67469163	Lottia gigantea	225164	Mollusca	Mollusca	84.2	8.66e-12	NTclustered	gi\|676464526\|ref\|XM_009058702.1\|	225164	g46878	i0	88.406	4.91760299625468	69	8	26	0	143	211	215	283	Lottia gigantea hypothetical protein mRNA	blastn	1313	84.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Lottiidae	Lottia	Lottia gigantea
19455773	19455773	PRJNA1204310_P_NODE_58476_length_246_cov_0.901734_g58179_i0	PRJNA1204310	58476	246	0.901734	2.21826564	Octopus bimaculoides	37653	Mollusca	Mollusca	56.5	0.002	NTclustered	gi\|2427246276\|ref\|XM_052968490.1\|	37653	g58179	i0	92.5	3.90243902439024	40	1	16	2	170	209	1073	1036	PREDICTED: Octopus bimaculoides sal-like protein 3 (LOC106878625), mRNA	blastn	960	56.5	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);;