contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_phylum = "Mollusca"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2406093 | 2406093 | PRJNA561212_P_NODE_17302_length_273_cov_1.165000_g17091_i0 | PRJNA561212 | 17302 | 273 | 1.165 | 3.18045 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|1207907783|ref|XM_021503088.1| | 6573 | g17091 | i0 | 92.308 | 1.3003663003663 | 39 | 1 | 14 | 1 | 86 | 124 | 5801 | 5837 | PREDICTED: Mizuhopecten yessoensis centrosomal protein of 131 kDa-like (LOC110453882), mRNA | blastn | 355 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 3096410 | 3096410 | PRJNA561212_P_NODE_2543_length_688_cov_1.891057_g2339_i0 | PRJNA561212 | 2543 | 688 | 1.891057 | 13.01047216 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.7 | 0.019 | NTclustered | gi|1835503412|ref|XM_033884798.1| | 6579 | g2339 | i0 | 96.875 | 0.0465116279069767 | 32 | 1 | 5 | 0 | 233 | 264 | 3046 | 3015 | PREDICTED: Pecten maximus proteoglycan 4-like (LOC117327689), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 6923410 | 6923410 | PRJNA561212_P_NODE_19906_length_254_cov_2.005525_g19695_i0 | PRJNA561212 | 19906 | 254 | 2.005525 | 5.0940335 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g19695 | i0 | 100 | 1.87795275590551 | 29 | 0 | 11 | 0 | 131 | 159 | 35434615 | 35434587 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 477 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6923558 | 6923558 | PRJNA561212_P_NODE_5046_length_492_cov_3.682578_g4835_i0 | PRJNA561212 | 5046 | 492 | 3.682578 | 18.11828376 | Mytilus edulis | 6550 | Mollusca | Mollusca | 340 | 9.15e-89 | NTclustered | gi|2912438933|ref|XM_071270510.1| | 6550 | g4835 | i0 | 82.294 | 72.0121951219512 | 401 | 64 | 80 | 7 | 85 | 480 | 1619 | 1221 | PREDICTED: Mytilus edulis tubulin beta-4B chain-like (LOC139485864), transcript variant X1, mRNA | blastn | 35430 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 6923588 | 6923588 | PRJNA561212_P_NODE_7106_length_412_cov_2.398230_g6895_i0 | PRJNA561212 | 7106 | 412 | 2.39823 | 9.8807076 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 2.37e-4 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g6895 | i0 | 92.683 | 0.0995145631067961 | 41 | 3 | 10 | 0 | 78 | 118 | 13871606 | 13871566 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 41 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8198313 | 8198313 | PRJNA561212_P_NODE_2187_length_737_cov_2.640060_g1991_i0 | PRJNA561212 | 2187 | 737 | 2.64006 | 19.4572422 | Pecten maximus | 6579 | Mollusca | Mollusca | 71.3 | 2.04e-7 | NTclustered | gi|1835473492|ref|XM_033869187.1| | 6579 | g1991 | i0 | 87.097 | 0.175033921302578 | 62 | 8 | 8 | 0 | 374 | 435 | 442 | 503 | PREDICTED: Pecten maximus cathepsin L1-like (LOC117315052), mRNA | blastn | 129 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 14574233 | 14574233 | PRJNA561212_P_NODE_12172_length_319_cov_0.865854_g11961_i0 | PRJNA561212 | 12172 | 319 | 0.865854 | 2.76207426 | Mya arenaria | 6604 | Mollusca | Mollusca | 289 | 2.09e-73 | NTclustered | gi|2427460903|ref|XM_052938019.1| | 6604 | g11961 | i0 | 83.495 | 96.2601880877743 | 309 | 51 | 97 | 0 | 11 | 319 | 686 | 994 | PREDICTED: Mya arenaria tubulin beta chain (LOC128227458), transcript variant X1, mRNA | blastn | 30707 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 15848344 | 15848344 | PRJNA561212_P_NODE_2593_length_681_cov_2.064145_g2389_i0 | PRJNA561212 | 2593 | 681 | 2.064145 | 14.05682745 | Liolophura japonica | 13599 | Mollusca | Mollusca | 54.7 | 0.019 | NTclustered | gi|2724241218|ref|XM_064745838.1| | 13599 | g2389 | i0 | 100 | 0.0425844346549192 | 29 | 0 | 4 | 0 | 469 | 497 | 2077 | 2049 | PREDICTED: Liolophura japonica ubiquitin carboxyl-terminal hydrolase MINDY-2-like (LOC135467913), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 17123135 | 17123135 | PRJNA561212_P_NODE_23654_length_246_cov_1.248555_g23443_i0 | PRJNA561212 | 23654 | 246 | 1.248555 | 3.0714453 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 67.6 | 7.94e-7 | NTclustered | gi|2364268467|ref|XM_052408548.1| | 45954 | g23443 | i0 | 82.667 | 1.92682926829268 | 75 | 13 | 30 | 0 | 137 | 211 | 2225 | 2299 | PREDICTED: Dreissena polymorpha uncharacterized LOC127867416 (LOC127867416), mRNA | blastn | 474 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 18397130 | 18397130 | PRJNA561212_P_NODE_11275_length_330_cov_1.143969_g11064_i0 | PRJNA561212 | 11275 | 330 | 1.143969 | 3.7750977 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g11064 | i0 | 100 | 0.0848484848484849 | 28 | 0 | 8 | 0 | 176 | 203 | 13152250 | 13152277 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22222384 | 22222384 | PRJNA561212_P_NODE_15978_length_283_cov_0.923810_g15767_i0 | PRJNA561212 | 15978 | 283 | 0.92381 | 2.6143823 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2427425130|ref|XM_052930172.1| | 6604 | g15767 | i0 | 100 | 0.204946996466431 | 29 | 0 | 10 | 0 | 77 | 105 | 123 | 95 | PREDICTED: Mya arenaria prostatic spermine-binding protein-like (LOC128221567), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 22222513 | 22222513 | PRJNA561212_P_NODE_25758_length_242_cov_0.923077_g25547_i0 | PRJNA561212 | 25758 | 242 | 0.923077 | 2.23384634 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g25547 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 204 | 231 | 32725599 | 32725626 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24771540 | 24771540 | PRJNA561212_P_NODE_13260_length_307_cov_0.846154_g13049_i0 | PRJNA561212 | 13260 | 307 | 0.846154 | 2.59769278 | Mytilus edulis | 6550 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2912312928|ref|XM_071281426.1| | 6550 | g13049 | i0 | 100 | 0.0944625407166124 | 29 | 0 | 9 | 0 | 148 | 176 | 767 | 739 | PREDICTED: Mytilus edulis uncharacterized protein (LOC139493193), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 24771546 | 24771546 | PRJNA561212_P_NODE_13840_length_300_cov_5.594714_g13629_i0 | PRJNA561212 | 13840 | 300 | 5.594714 | 16.784142 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|1897936549|ref|XM_005106389.3| | 6500 | g13629 | i0 | 100 | 0.0933333333333333 | 28 | 0 | 9 | 0 | 66 | 93 | 3646 | 3673 | PREDICTED: Aplysia californica RRP12-like protein (LOC101856684), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;