contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508631 | 508631 | PRJNA541476_P_NODE_20801_length_279_cov_1.165049_g20595_i0 | PRJNA541476 | 20801 | 279 | 1.165049 | 3.25048671 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g20595 | i0 | 92.308 | 0.139784946236559 | 39 | 0 | 14 | 2 | 96 | 134 | 59023201 | 59023236 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 39 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 508892 | 508892 | PRJNA541476_P_NODE_30341_length_250_cov_1.757062_g30135_i0 | PRJNA541476 | 30341 | 250 | 1.757062 | 4.392655 | Lottia gigantea | 225164 | Mollusca | Mollusca | 152 | 2.17e-32 | NTclustered | gi|676463422|ref|XM_009058344.1| | 225164 | g30135 | i0 | 77.778 | 33.584 | 252 | 52 | 100 | 4 | 1 | 250 | 529 | 280 | Lottia gigantea hypothetical protein mRNA | blastn | 8396 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 1118432 | 1118432 | PRJNA541476_P_NODE_26241_length_259_cov_1.107527_g26035_i0 | PRJNA541476 | 26241 | 259 | 1.107527 | 2.86849493 | Mollusca | 6447 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g26035 | i0 | 100 | 0.335907335907336 | 29 | 0 | 11 | 0 | 193 | 221 | 69555035 | 69555063 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1783956 | 1783956 | PRJNA541476_P_NODE_19502_length_284_cov_1.630332_g19296_i0 | PRJNA541476 | 19502 | 284 | 1.630332 | 4.63014288 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.64e-4 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g19296 | i0 | 97.059 | 0.785211267605634 | 34 | 1 | 12 | 0 | 109 | 142 | 23136479 | 23136512 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 223 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2394015 | 2394015 | PRJNA541476_P_NODE_30802_length_250_cov_0.881356_g30596_i0 | PRJNA541476 | 30802 | 250 | 0.881356 | 2.20339 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g30596 | i0 | 90.698 | 0.624 | 43 | 1 | 16 | 3 | 17 | 56 | 18117737 | 18117695 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 156 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 3059323 | 3059323 | PRJNA541476_P_NODE_14143_length_316_cov_1.279835_g13937_i0 | PRJNA541476 | 14143 | 316 | 1.279835 | 4.0442786 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g13937 | i0 | 100 | 0.0886075949367089 | 28 | 0 | 9 | 0 | 98 | 125 | 54588441 | 54588468 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5612302 | 5612302 | PRJNA541476_P_NODE_16885_length_297_cov_4.683036_g16679_i0 | PRJNA541476 | 16885 | 297 | 4.683036 | 13.90861692 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g16679 | i0 | 100 | 0.0942760942760943 | 28 | 0 | 9 | 0 | 264 | 291 | 36324034 | 36324007 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7496678 | 7496678 | PRJNA541476_P_NODE_29706_length_251_cov_0.876404_g29500_i0 | PRJNA541476 | 29706 | 251 | 0.876404 | 2.19977404 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1897928413|ref|XM_013083847.2| | 6500 | g29500 | i0 | 89.13 | 0.466135458167331 | 46 | 2 | 18 | 3 | 199 | 242 | 6205 | 6161 | PREDICTED: Aplysia californica inactive tyrosine-protein kinase 7 (LOC101855346), mRNA | blastn | 117 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 9436666 | 9436666 | PRJNA541476_P_NODE_11688_length_339_cov_2.263158_g11482_i0 | PRJNA541476 | 11688 | 339 | 2.263158 | 7.67210562 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 171 | 8.47e-38 | NTclustered | gi|2616494203|ref|XM_060723955.1| | 129788 | g11482 | i0 | 80.263 | 15.0412979351032 | 228 | 43 | 67 | 2 | 21 | 247 | 171 | 397 | PREDICTED: Ruditapes philippinarum dynein light chain 1, cytoplasmic (LOC132736749), mRNA | blastn | 5099 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 10046992 | 10046992 | PRJNA541476_P_NODE_30108_length_251_cov_0.865169_g29902_i0 | PRJNA541476 | 30108 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|1897917526|ref|XM_005093775.3| | 6500 | g29902 | i0 | 100 | 0.585657370517928 | 28 | 0 | 11 | 0 | 98 | 125 | 1510 | 1537 | PREDICTED: Aplysia californica nucleolin (LOC101855087), mRNA | blastn | 147 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 10712940 | 10712940 | PRJNA541476_P_NODE_2989_length_675_cov_6.951827_g2798_i0 | PRJNA541476 | 2989 | 675 | 6.951827 | 46.92483225 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 0.001 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g2798 | i0 | 97.143 | 0.0518518518518519 | 35 | 0 | 5 | 1 | 604 | 637 | 22816919 | 22816953 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10713322 | 10713322 | PRJNA541476_P_NODE_40669_length_240_cov_2.185629_g40463_i0 | PRJNA541476 | 40669 | 240 | 2.185629 | 5.2455096 | Patella vulgata | 6465 | Mollusca | Mollusca | 150 | 7.439999999999998e-32 | NTclustered | gi|2506326049|ref|XM_050547117.2| | 6465 | g40463 | i0 | 79.63 | 7.14583333333333 | 216 | 39 | 89 | 5 | 7 | 220 | 325 | 113 | PREDICTED: Patella vulgata cell division cycle 5-like protein (LOC126819210), mRNA | blastn | 1715 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 13262439 | 13262439 | PRJNA541476_P_NODE_21471_length_276_cov_1.295567_g21265_i0 | PRJNA541476 | 21471 | 276 | 1.295567 | 3.57576492 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g21265 | i0 | 100 | 0.318840579710145 | 28 | 0 | 10 | 0 | 117 | 144 | 31041329 | 31041302 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 88 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13872398 | 13872398 | PRJNA541476_P_NODE_30271_length_250_cov_2.418079_g30065_i0 | PRJNA541476 | 30271 | 250 | 2.418079 | 6.0451975 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.35e-4 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g30065 | i0 | 100 | 26.248 | 32 | 0 | 13 | 0 | 32 | 63 | 32947254 | 32947285 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 6562 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14537617 | 14537617 | PRJNA541476_P_NODE_29912_length_251_cov_0.870787_g29706_i0 | PRJNA541476 | 29912 | 251 | 0.870787 | 2.18567537 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.36e-4 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g29706 | i0 | 97.143 | 0.653386454183267 | 35 | 1 | 14 | 0 | 135 | 169 | 69142996 | 69142962 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 164 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16421331 | 16421331 | PRJNA541476_P_NODE_26893_length_256_cov_2.491803_g26687_i0 | PRJNA541476 | 26893 | 256 | 2.491803 | 6.37901568 | Magallana | 147004 | Mollusca | Mollusca | 466 | 7.01e-127 | NTclustered | gi|28375710|dbj|AB102757.1| | 29159 | g26687 | i0 | 99.606 | 100.91796875 | 254 | 1 | 99 | 0 | 3 | 256 | 2329 | 2582 | Crassostrea gigas genes for ITS2, 28S rRNA, partial sequence, country: Japan: Okinawa (Haneji inland sea) | blastn | 25835 | 470 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 16421346 | 16421346 | PRJNA541476_P_NODE_34513_length_246_cov_2.491329_g34307_i0 | PRJNA541476 | 34513 | 246 | 2.491329 | 6.12866934 | Metazoa | 33208 | Mollusca | Mollusca | 455 | 1.4500000000000002e-123 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g34307 | i0 | 100 | 99.9674796747967 | 246 | 0 | 100 | 0 | 1 | 246 | 1342 | 1587 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 24592 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 19634484 | 19634484 | PRJNA541476_P_NODE_11976_length_336_cov_1.904943_g11770_i0 | PRJNA541476 | 11976 | 336 | 1.904943 | 6.40060848 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 4.07e-6 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g11770 | i0 | 100 | 7.95238095238095 | 35 | 0 | 10 | 0 | 198 | 232 | 35783140 | 35783106 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 2672 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19635014 | 19635014 | PRJNA541476_P_NODE_3236_length_649_cov_1.987847_g3044_i0 | PRJNA541476 | 3236 | 649 | 1.987847 | 12.90112703 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g3044 | i0 | 89.13 | 0.120184899845917 | 46 | 3 | 7 | 2 | 359 | 402 | 28022390 | 28022345 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 78 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20910425 | 20910425 | PRJNA541476_P_NODE_13497_length_321_cov_4.794355_g13291_i0 | PRJNA541476 | 13497 | 321 | 4.794355 | 15.38987955 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 8.31e-8 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g13291 | i0 | 97.561 | 9.08411214953271 | 41 | 1 | 13 | 0 | 51 | 91 | 28868469 | 28868509 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 2916 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22185290 | 22185290 | PRJNA541476_P_NODE_17818_length_292_cov_1.602740_g17612_i0 | PRJNA541476 | 17818 | 292 | 1.60274 | 4.6800008 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g17612 | i0 | 92.5 | 0.136986301369863 | 40 | 2 | 13 | 1 | 97 | 135 | 39677821 | 39677782 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23460651 | 23460651 | PRJNA541476_P_NODE_14519_length_313_cov_1.358333_g14313_i0 | PRJNA541476 | 14519 | 313 | 1.358333 | 4.25158229 | Magallana angulata | 2784310 | Mollusca | Mollusca | 579 | 1.0899999999999999e-160 | NTclustered | gi|2416874841|ref|XR_008241671.1| | 2784310 | g14313 | i0 | 100 | 94.8434504792332 | 313 | 0 | 100 | 0 | 1 | 313 | 2153 | 1841 | PREDICTED: Crassostrea angulata large subunit ribosomal RNA (LOC128170120), rRNA | blastn | 29686 | 579 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 24070512 | 24070512 | PRJNA541476_P_NODE_23679_length_267_cov_3.489691_g23473_i0 | PRJNA541476 | 23679 | 267 | 3.489691 | 9.31747497 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g23473 | i0 | 100 | 0.209737827715356 | 28 | 0 | 10 | 0 | 181 | 208 | 53968441 | 53968414 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24734414 | 24734414 | PRJNA541476_P_NODE_16080_length_302_cov_2.030568_g15874_i0 | PRJNA541476 | 16080 | 302 | 2.030568 | 6.13231536 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|2427276265|ref|XM_052975183.1| | 37653 | g15874 | i0 | 96.774 | 0.102649006622517 | 31 | 1 | 10 | 0 | 217 | 247 | 4537 | 4507 | PREDICTED: Octopus bimaculoides multidrug resistance-associated protein 1 (LOC106867613), mRNA | blastn | 31 | 52.8 | 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);;