contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2148210 | 2148210 | PRJNA896758_P_NODE_24982_length_244_cov_0.900585_g24592_i0 | PRJNA896758 | 24982 | 244 | 0.900585 | 2.1974274 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g24592 | i0 | 94.444 | 0.385245901639344 | 36 | 2 | 15 | 0 | 157 | 192 | 56131985 | 56132020 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 94 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4701450 | 4701450 | PRJNA896758_P_NODE_3604_length_606_cov_1.091932_g3222_i0 | PRJNA896758 | 3604 | 606 | 1.091932 | 6.61710792 | Todarodes pacificus | 6637 | Mollusca | Mollusca | 89.8 | 4.57e-13 | NTclustered | gi|315439551|gb|GU338005.1| | 6637 | g3222 | i0 | 77.419 | 0.541254125412541 | 155 | 32 | 25 | 3 | 431 | 583 | 3328 | 3175 | Todarodes pacificus myosin heavy chain mRNA, complete cds | blastn | 328 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Oegopsida | Ommastrephidae | Todarodes | Todarodes pacificus | |
| 4701466 | 4701466 | PRJNA896758_P_NODE_6184_length_457_cov_2.695312_g5795_i0 | PRJNA896758 | 6184 | 457 | 2.695312 | 12.31757584 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g5795 | i0 | 97.059 | 0.150984682713348 | 34 | 0 | 7 | 1 | 160 | 193 | 47680270 | 47680302 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 69 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5072034 | 5072034 | PRJNA896758_P_NODE_4664_length_527_cov_4.167401_g4277_i0 | PRJNA896758 | 4664 | 527 | 4.167401 | 21.96220327 | Metazoa | 33208 | Mollusca | Mollusca | 289 | 3.62e-73 | NTclustered | gi|2912445588|ref|XM_071273934.1| | 6550 | g4277 | i0 | 90.09 | 41.8273244781784 | 222 | 22 | 42 | 0 | 5 | 226 | 1290 | 1511 | PREDICTED: Mytilus edulis tubulin alpha-1A chain-like (LOC139488384), mRNA | blastn | 22043 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 7621972 | 7621972 | PRJNA896758_P_NODE_21366_length_251_cov_0.865169_g20976_i0 | PRJNA896758 | 21366 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g20976 | i0 | 100 | 0.446215139442231 | 28 | 0 | 11 | 0 | 41 | 68 | 54957175 | 54957202 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7622006 | 7622006 | PRJNA896758_P_NODE_7206_length_421_cov_2.991379_g6816_i0 | PRJNA896758 | 7206 | 421 | 2.991379 | 12.59370559 | Metazoa | 33208 | Mollusca | Mollusca | 195 | 6.36e-45 | NTclustered | gi|2506339511|ref|XM_050561182.2| | 6465 | g6816 | i0 | 86.932 | 36.8456057007126 | 176 | 20 | 41 | 3 | 2 | 174 | 1269 | 1444 | PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain (LOC126830781), mRNA | blastn | 15512 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 8525606 | 8525606 | PRJNA896758_P_NODE_18487_length_270_cov_1.954315_g18097_i0 | PRJNA896758 | 18487 | 270 | 1.954315 | 5.2766505 | Physella acuta | 109671 | Mollusca | Mollusca | 89.8 | 1.89e-13 | NTclustered | gi|2572361009|ref|XM_059307084.1| | 109671 | g18097 | i0 | 98.039 | 0.188888888888889 | 51 | 1 | 19 | 0 | 169 | 219 | 180 | 230 | PREDICTED: Physella acuta histone H1-delta-like (LOC131946370), mRNA | blastn | 51 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 9800646 | 9800646 | PRJNA896758_P_NODE_18348_length_271_cov_1.611111_g17958_i0 | PRJNA896758 | 18348 | 271 | 1.611111 | 4.36611081 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.34e-4 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g17958 | i0 | 100 | 0.538745387453875 | 31 | 0 | 11 | 0 | 241 | 271 | 45522373 | 45522343 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 146 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9800740 | 9800740 | PRJNA896758_P_NODE_6648_length_440_cov_2.198910_g6258_i0 | PRJNA896758 | 6648 | 440 | 2.19891 | 9.675204 | Physella acuta | 109671 | Mollusca | Mollusca | 791 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g6258 | i0 | 99.768 | 4.63636363636364 | 431 | 1 | 98 | 0 | 1 | 431 | 3339 | 3769 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 2040 | 791 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 11076293 | 11076293 | PRJNA896758_P_NODE_11709_length_336_cov_1.239544_g11319_i0 | PRJNA896758 | 11709 | 336 | 1.239544 | 4.16486784 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 6.81e-4 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g11319 | i0 | 84.375 | 0.547619047619048 | 64 | 4 | 18 | 5 | 254 | 314 | 16381743 | 16381803 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 184 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11076387 | 11076387 | PRJNA896758_P_NODE_24529_length_245_cov_0.895349_g24139_i0 | PRJNA896758 | 24529 | 245 | 0.895349 | 2.19360505 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|1835543038|ref|XM_033878593.1| | 6579 | g24139 | i0 | 96.774 | 0.126530612244898 | 31 | 1 | 13 | 0 | 110 | 140 | 1445 | 1475 | PREDICTED: Pecten maximus uncharacterized transmembrane protein DDB_G0289901-like (LOC117323397), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 11076472 | 11076472 | PRJNA896758_P_NODE_8649_length_386_cov_0.833866_g8259_i0 | PRJNA896758 | 8649 | 386 | 0.833866 | 3.21872276 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2427467042|ref|XM_052939866.1| | 6604 | g8259 | i0 | 100 | 0.150259067357513 | 29 | 0 | 8 | 0 | 237 | 265 | 966 | 938 | 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 | |
| 13626519 | 13626519 | PRJNA896758_P_NODE_10811_length_349_cov_1.003623_g10421_i0 | PRJNA896758 | 10811 | 349 | 1.003623 | 3.50264427 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2616583798|ref|XM_060721647.1| | 129788 | g10421 | i0 | 100 | 0.656160458452722 | 29 | 0 | 8 | 0 | 43 | 71 | 3696 | 3668 | PREDICTED: Ruditapes philippinarum arginine-glutamic acid dipeptide repeats protein-like (LOC132734792), transcript variant X6, mRNA | blastn | 229 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 17450998 | 17450998 | PRJNA896758_P_NODE_14694_length_299_cov_1.190265_g14304_i0 | PRJNA896758 | 14694 | 299 | 1.190265 | 3.55889235 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.28e-5 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g14304 | i0 | 88.462 | 1.05016722408027 | 52 | 6 | 17 | 0 | 139 | 190 | 50034671 | 50034620 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 314 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17451104 | 17451104 | PRJNA896758_P_NODE_4534_length_534_cov_13.876356_g4147_i0 | PRJNA896758 | 4534 | 534 | 13.876356 | 74.09974104 | Pinctada maxima | 104660 | Mollusca | Mollusca | 54.7 | 0.015 | NTclustered | gi|452883237|gb|KC494057.1| | 104660 | g4147 | i0 | 96.875 | 0.0599250936329588 | 32 | 1 | 6 | 0 | 381 | 412 | 293 | 262 | Pinctada maxima KRMPx3 (KRMPx3) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada maxima | |
| 17451128 | 17451128 | PRJNA896758_P_NODE_9974_length_361_cov_2.652778_g9584_i0 | PRJNA896758 | 9974 | 361 | 2.652778 | 9.57652858 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 283 | 1.11e-71 | NTclustered | gi|2187522883|ref|XM_046511445.1| | 6454 | g9584 | i0 | 80.939 | 95.7229916897507 | 362 | 65 | 99 | 4 | 2 | 361 | 474 | 115 | PREDICTED: Haliotis rufescens tubulin beta chain-like (LOC124142786), mRNA | blastn | 34556 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 18724273 | 18724273 | PRJNA896758_P_NODE_18915_length_267_cov_2.175258_g18525_i0 | PRJNA896758 | 18915 | 267 | 2.175258 | 5.80793886 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g18525 | i0 | 100 | 0.104868913857678 | 28 | 0 | 10 | 0 | 147 | 174 | 37957223 | 37957196 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18724364 | 18724364 | PRJNA896758_P_NODE_6315_length_453_cov_1.121053_g5925_i0 | PRJNA896758 | 6315 | 453 | 1.121053 | 5.07837009 | Haliotis rubra | 36100 | Mollusca | Mollusca | 250 | 1.45e-61 | NTclustered | gi|2194112554|ref|XM_046712337.1| | 36100 | g5925 | i0 | 90.155 | 40.3443708609271 | 193 | 18 | 43 | 1 | 3 | 195 | 1327 | 1518 | PREDICTED: Haliotis rubra tubulin alpha-1A chain-like (LOC124276689), mRNA | blastn | 18276 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 21274683 | 21274683 | PRJNA896758_P_NODE_10537_length_352_cov_2.207885_g10147_i0 | PRJNA896758 | 10537 | 352 | 2.207885 | 7.7717552 | Solen grandis | 165599 | Mollusca | Mollusca | 235 | 3.0799999999999996e-57 | NTclustered | gi|402483941|gb|JX294851.1| | 165599 | g10147 | i0 | 92.638 | 224.880681818182 | 163 | 12 | 46 | 0 | 184 | 346 | 653 | 491 | Solen grandis polyubiquitin mRNA, partial cds | blastn | 79158 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Adapedonta | Solenidae | Solen | Solen grandis | |
| 21274747 | 21274747 | PRJNA896758_P_NODE_20357_length_257_cov_1.239130_g19967_i0 | PRJNA896758 | 20357 | 257 | 1.23913 | 3.1845641 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g19967 | i0 | 100 | 0.108949416342412 | 28 | 0 | 11 | 0 | 219 | 246 | 64711512 | 64711539 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21274820 | 21274820 | PRJNA896758_P_NODE_4717_length_524_cov_1.181818_g4329_i0 | PRJNA896758 | 4717 | 524 | 1.181818 | 6.19272632 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 2.37e-5 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g4329 | i0 | 100 | 0.238549618320611 | 34 | 0 | 6 | 0 | 396 | 429 | 39623740 | 39623773 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 125 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22549761 | 22549761 | PRJNA896758_P_NODE_9358_length_373_cov_1.540000_g8968_i0 | PRJNA896758 | 9358 | 373 | 1.54 | 5.7442 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g8968 | i0 | 100 | 0.0777479892761394 | 29 | 0 | 8 | 0 | 323 | 351 | 36311531 | 36311503 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25098907 | 25098907 | PRJNA896758_P_NODE_3460_length_619_cov_3.214286_g3079_i0 | PRJNA896758 | 3460 | 619 | 3.214286 | 19.89643034 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 250 | 2.03e-61 | NTclustered | gi|2616619385|ref|XM_060731797.1| | 129788 | g3079 | i0 | 81.639 | 24.8206785137318 | 305 | 52 | 49 | 4 | 305 | 607 | 442 | 140 | PREDICTED: Ruditapes philippinarum dynein light chain Tctex-type 1 (LOC132743263), mRNA | blastn | 15364 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 25098914 | 25098914 | PRJNA896758_P_NODE_3960_length_574_cov_15.127745_g3578_i0 | PRJNA896758 | 3960 | 574 | 15.127745000000001 | 86.8332563 | Aplysia californica | 6500 | Mollusca | Mollusca | 289 | 3.97e-73 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g3578 | i0 | 78.889 | 74.6724738675958 | 450 | 77 | 77 | 17 | 65 | 505 | 62 | 502 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 42862 | 289 | 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);;