contig_metadata
24 rows where bioproject = "PRJNA399711", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 413352 | 413352 | PRJNA399711_P_NODE_1401_length_335_cov_3.644295_g1336_i0 | PRJNA399711 | 1401 | 335 | 3.644295 | 12.20838825 | Mytilus californianus | 6549 | Mollusca | Mollusca | 82.4 | 4.03e-11 | NTclustered | gi|2334751649|ref|XM_052207013.1| | 6549 | g1336 | i0 | 74.112 | 6.85671641791045 | 197 | 51 | 61 | 0 | 11 | 207 | 1816 | 2012 | PREDICTED: Mytilus californianus DNA-directed RNA polymerase II subunit RPB1-like (LOC127702715), transcript variant X3, mRNA | blastn | 2297 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 11892213 | 11892213 | PRJNA399711_P_NODE_10690_length_193_cov_2.115385_g10624_i0 | PRJNA399711 | 10690 | 193 | 2.115385 | 4.08269305 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 9.94e-5 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g10624 | i0 | 100 | 9.41450777202073 | 32 | 0 | 17 | 0 | 129 | 160 | 36272037 | 36272006 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 1817 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16991114 | 16991114 | PRJNA399711_P_NODE_4494_length_247_cov_2.900000_g4428_i0 | PRJNA399711 | 4494 | 247 | 2.9 | 7.163 | Magallana gigas | 29159 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|605059530|gb|KJ184342.1| | 29159 | g4428 | i0 | 100 | 0.566801619433198 | 28 | 0 | 11 | 0 | 14 | 41 | 1625 | 1652 | Crassostrea gigas FUT2 (FUT2) gene, complete cds | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 25565437 | 25565437 | PRJNA399711_S_NODE_9833_length_347_cov_97.403226_g9691_i0 | PRJNA399711 | 9833 | 347 | 97.403226 | 337.98919422 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.033 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g9691 | i0 | 100 | 0.0806916426512968 | 28 | 0 | 8 | 0 | 235 | 262 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25698362 | 25698362 | PRJNA399711_S_NODE_1554_length_601_cov_29.331560_g1459_i0 | PRJNA399711 | 1554 | 601 | 29.33156 | 176.2826756 | Mytilus californianus | 6549 | Mollusca | Mollusca | 102 | 5.82e-17 | NTclustered | gi|2334751649|ref|XM_052207013.1| | 6549 | g1459 | i0 | 72.394 | 7.10648918469218 | 355 | 87 | 60 | 11 | 243 | 591 | 1886 | 1537 | PREDICTED: Mytilus californianus DNA-directed RNA polymerase II subunit RPB1-like (LOC127702715), transcript variant X3, mRNA | blastn | 4271 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 25700049 | 25700049 | PRJNA399711_S_NODE_53090_length_195_cov_1.715190_g52948_i0 | PRJNA399711 | 53090 | 195 | 1.71519 | 3.3446205 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g52948 | i0 | 96.875 | 0.328205128205128 | 32 | 1 | 16 | 0 | 159 | 190 | 8068705 | 8068736 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25834738 | 25834738 | PRJNA399711_S_NODE_20499_length_273_cov_4.894068_g20357_i0 | PRJNA399711 | 20499 | 273 | 4.894068 | 13.36080564 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g20357 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 73 | 100 | 62740403 | 62740430 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25971020 | 25971020 | PRJNA399711_S_NODE_21044_length_270_cov_17.167382_g20902_i0 | PRJNA399711 | 21044 | 270 | 17.167382 | 46.3519314 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|1835561024|ref|XM_033907209.1| | 6579 | g20902 | i0 | 100 | 0.103703703703704 | 28 | 0 | 10 | 0 | 26 | 53 | 249 | 222 | PREDICTED: Pecten maximus ATP-dependent DNA/RNA helicase DHX36-like (LOC117344464), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 25972298 | 25972298 | PRJNA399711_S_NODE_51196_length_197_cov_6.087500_g51054_i0 | PRJNA399711 | 51196 | 197 | 6.0875 | 11.992375 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2913002619|dbj|AP039638.1| | 145626 | g51054 | i0 | 96.97 | 0.16751269035533 | 33 | 1 | 17 | 0 | 129 | 161 | 27999 | 28031 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored29, sequence | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26033151 | 26033151 | PRJNA399711_S_NODE_81724_length_166_cov_18.806202_g81582_i0 | PRJNA399711 | 81724 | 166 | 18.806202 | 31.21829532 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2427265949|ref|XM_014933751.2| | 37653 | g81582 | i0 | 100 | 7.67469879518072 | 29 | 0 | 17 | 0 | 138 | 166 | 1768 | 1740 | PREDICTED: Octopus bimaculoides regulator of G-protein signaling 12 (LOC106882916), transcript variant X5, mRNA | blastn | 1274 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 26169023 | 26169023 | PRJNA399711_S_NODE_29093_length_241_cov_8.745098_g28951_i0 | PRJNA399711 | 29093 | 241 | 8.745098 | 21.07568618 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1897916392|ref|XM_013079538.2| | 6500 | g28951 | i0 | 100 | 0.605809128630705 | 29 | 0 | 12 | 0 | 72 | 100 | 1480 | 1452 | PREDICTED: Aplysia californica rhomboid-related protein 2 (LOC101845073), mRNA | blastn | 146 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 26244343 | 26244343 | PRJNA399711_S_NODE_47118_length_203_cov_5.674699_g46976_i0 | PRJNA399711 | 47118 | 203 | 5.674699 | 11.51963897 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2034339108|ref|XR_005959157.1| | 1735272 | g46976 | i0 | 100 | 0.147783251231527 | 30 | 0 | 15 | 0 | 172 | 201 | 327 | 298 | PREDICTED: Gigantopelta aegis uncharacterized LOC121382365 (LOC121382365), ncRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 26244760 | 26244760 | PRJNA399711_S_NODE_57958_length_188_cov_22.423841_g57816_i0 | PRJNA399711 | 57958 | 188 | 22.423841 | 42.15682108 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 58.4 | 3.46e-4 | NTclustered | gi|1914637952|ref|XM_029791933.2| | 2607531 | g57816 | i0 | 94.595 | 4.49468085106383 | 37 | 2 | 20 | 0 | 47 | 83 | 925 | 889 | PREDICTED: Octopus sinensis zinc finger protein 345-like (LOC115221721), transcript variant X1, mRNA | blastn | 845 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 26245922 | 26245922 | PRJNA399711_S_NODE_90638_length_160_cov_5.626016_g90496_i0 | PRJNA399711 | 90638 | 160 | 5.626016 | 9.0016256 | Mytilus californianus | 6549 | Mollusca | Mollusca | 198 | 1.61e-46 | NTclustered | gi|2334624425|ref|XM_052210017.1| | 6549 | g90496 | i0 | 89.375 | 32.50625 | 160 | 13 | 100 | 3 | 1 | 160 | 3933 | 3778 | PREDICTED: Mytilus californianus mesoderm induction early response protein 1-like (LOC127705673), mRNA | blastn | 5201 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 26381305 | 26381305 | PRJNA399711_S_NODE_79863_length_168_cov_2.702290_g79721_i0 | PRJNA399711 | 79863 | 168 | 2.70229 | 4.5398472 | Aplysia californica | 6500 | Mollusca | Mollusca | 63.9 | 6.52e-6 | NTclustered | gi|1897929389|ref|XM_005101438.3| | 6500 | g79721 | i0 | 95 | 0.446428571428571 | 40 | 2 | 24 | 0 | 129 | 168 | 259 | 298 | PREDICTED: Aplysia californica 26S proteasome non-ATPase regulatory subunit 14 (LOC101864533), mRNA | blastn | 75 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 26381756 | 26381756 | PRJNA399711_S_NODE_93871_length_158_cov_7.000000_g93729_i0 | PRJNA399711 | 93871 | 158 | 7 | 11.06 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.013 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g93729 | i0 | 100 | 0.177215189873418 | 28 | 0 | 18 | 0 | 77 | 104 | 67127969 | 67127942 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26516120 | 26516120 | PRJNA399711_S_NODE_41192_length_213_cov_8.698864_g41050_i0 | PRJNA399711 | 41192 | 213 | 8.698864 | 18.52858032 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g41050 | i0 | 100 | 0.136150234741784 | 29 | 0 | 14 | 0 | 184 | 212 | 58146806 | 58146778 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 32952342 | 32952342 | PRJNA399711_S_NODE_90794_length_160_cov_4.398374_g90652_i0 | PRJNA399711 | 90794 | 160 | 4.398374 | 7.0373984 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 44.3 | 0.00278 | NR | XP_046355967.1 | 6454 | g90652 | i0 | 56.1 | 4.40625 | 41 | 18 | 76.9 | 0 | 158 | 36 | 165 | 205 | XP_046355967.1 pre-mRNA-splicing factor SPF27-like [Haliotis rufescens] | diamond | 705 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32969140 | 32969140 | PRJNA399711_S_NODE_34538_length_227_cov_3.552632_g34396_i0 | PRJNA399711 | 34538 | 227 | 3.552632 | 8.06447464 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 46.6 | 0.00102 | NR | BFZ08772.1 | 145626 | g34396 | i0 | 60 | 0.462555066079295 | 35 | 14 | 46.3 | 0 | 220 | 116 | 184 | 218 | BFZ08772.1 hypothetical protein BsWGS_11812 [Bradybaena similaris] | diamond | 105 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 33003217 | 33003217 | PRJNA399711_S_NODE_51867_length_196_cov_6.496855_g51725_i0 | PRJNA399711 | 51867 | 196 | 6.496855 | 12.7338358 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 71.2 | 1.71e-12 | NR | RUS88711.1 | 188477 | g51725 | i0 | 47.6 | 1.92857142857143 | 63 | 33 | 96.4 | 0 | 6 | 194 | 145 | 207 | RUS88711.1 hypothetical protein EGW08_003526 [Elysia chlorotica] | diamond | 378 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 33020386 | 33020386 | PRJNA399711_S_NODE_76084_length_171_cov_2.253731_g75942_i0 | PRJNA399711 | 76084 | 171 | 2.253731 | 3.85388001 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 57.4 | 2.1e-8 | NR | KAJ8309193.1 | 220873 | g75942 | i0 | 82.8 | 2.96491228070175 | 29 | 5 | 50.9 | 0 | 3 | 89 | 67 | 95 | KAJ8309193.1 hypothetical protein KUTeg_014067 [Tegillarca granosa] | diamond | 507 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 33088387 | 33088387 | PRJNA399711_S_NODE_33590_length_229_cov_4.984375_g33448_i0 | PRJNA399711 | 33590 | 229 | 4.984375 | 11.41421875 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 66.2 | 1.55e-10 | NR | XP_029657608.1 | 2607531 | g33448 | i0 | 50 | 4.28384279475982 | 72 | 35 | 93 | 1 | 3 | 215 | 414 | 485 | XP_029657608.1 uncharacterized protein LOC115231815 [Octopus sinensis] | diamond | 981 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 33105371 | 33105371 | PRJNA399711_S_NODE_21046_length_270_cov_16.218884_g20904_i0 | PRJNA399711 | 21046 | 270 | 16.218884 | 43.7909868 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0196 | NR | XP_067657806.1 | 109174 | g20904 | i0 | 35.4 | 1.42222222222222 | 65 | 36 | 71.1 | 2 | 240 | 49 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 33146056 | 33146056 | PRJNA399711_S_NODE_33711_length_229_cov_3.067708_g33569_i0 | PRJNA399711 | 33711 | 229 | 3.067708 | 7.02505132 | Metazoa | 33208 | Mollusca | Mollusca | 119 | 5.04e-33 | NR | XP_014777882.1 | 37653 | g33569 | i0 | 75.7 | 7.75545851528384 | 74 | 18 | 96.9 | 0 | 227 | 6 | 8 | 81 | XP_014777882.1 60S ribosomal protein L37 [Octopus bimaculoides] | diamond | 1776 | 119 | 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);;