contig_metadata
28 rows where bioproject = "PRJNA312615", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4206045 | 4206045 | PRJNA312615_P_NODE_8744_length_417_cov_2.869565_g8594_i0 | PRJNA312615 | 8744 | 417 | 2.869565 | 11.96608605 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 2.29e-36 | NR | XP_045157389.2 | 6596 | g8594 | i0 | 68.1 | 7.1726618705036 | 91 | 29 | 65.5 | 0 | 407 | 135 | 1 | 91 | XP_045157389.2 LOW QUALITY PROTEIN: 60S ribosomal protein L37-like [Mercenaria mercenaria] | diamond | 2991 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 9306645 | 9306645 | PRJNA312615_P_NODE_53348_length_165_cov_2.637931_g53197_i0 | PRJNA312615 | 53348 | 165 | 2.637931 | 4.35258615 | Aplysia californica | 6500 | Mollusca | Mollusca | 91.6 | 2.92e-14 | NTclustered | gi|1897934918|ref|XM_035971617.1| | 6500 | g53197 | i0 | 91.045 | 28.5454545454545 | 67 | 6 | 41 | 0 | 99 | 165 | 1362 | 1428 | PREDICTED: Aplysia californica dynein heavy chain 7, axonemal-like (LOC101846299), mRNA | blastn | 4710 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 11856481 | 11856481 | PRJNA312615_P_NODE_16050_length_306_cov_4.365759_g15899_i0 | PRJNA312615 | 16050 | 306 | 4.365759 | 13.35922254 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 60.2 | 1.71e-4 | NTclustered | gi|2868609750|ref|XM_070343994.1| | 31220 | g15899 | i0 | 97.143 | 0.209150326797386 | 35 | 1 | 11 | 0 | 272 | 306 | 1421 | 1387 | PREDICTED: Littorina saxatilis tubulin beta-4B chain-like (LOC138971279), mRNA | blastn | 64 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 14407341 | 14407341 | PRJNA312615_P_NODE_43272_length_186_cov_1.116788_g43121_i0 | PRJNA312615 | 43272 | 186 | 1.116788 | 2.07722568 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 215 | 1.92e-51 | NTclustered | gi|2868661765|ref|XM_070355016.1| | 31220 | g43121 | i0 | 90.683 | 89.247311827957 | 161 | 15 | 87 | 0 | 10 | 170 | 777 | 617 | PREDICTED: Littorina saxatilis ATP synthase subunit beta, mitochondrial-like (LOC138981875), mRNA | blastn | 16600 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 26884578 | 26884578 | PRJNA312615_P_NODE_15021_length_317_cov_1.570896_g14870_i0 | PRJNA312615 | 15021 | 317 | 1.570896 | 4.97974032 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 51.6 | 1.42e-5 | NR | RUS74546.1 | 188477 | g14870 | i0 | 45.6 | 0.643533123028391 | 68 | 34 | 64.4 | 1 | 77 | 280 | 52 | 116 | RUS74546.1 hypothetical protein EGW08_017694, partial [Elysia chlorotica] | diamond | 204 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 27800931 | 27800931 | PRJNA312615_P_NODE_27544_length_233_cov_1.108696_g27393_i0 | PRJNA312615 | 27544 | 233 | 1.108696 | 2.58326168 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 48.5 | 3.04e-4 | NR | XP_041375551.1 | 1735272 | g27393 | i0 | 41.3 | 2.48497854077253 | 63 | 37 | 81.1 | 0 | 195 | 7 | 2 | 64 | XP_041375551.1 importin-4-like [Gigantopelta aegis] | diamond | 579 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28228564 | 28228564 | PRJNA312615_P_NODE_21346_length_264_cov_1.106977_g21195_i0 | PRJNA312615 | 21346 | 264 | 1.106977 | 2.92241928 | Opisthokonta | 33154 | Mollusca | Mollusca | 120 | 6.579999999999999e-31 | NR | CAG5136775.1 | 100452 | g21195 | i0 | 65.5 | 1.97727272727273 | 87 | 30 | 98.9 | 0 | 1 | 261 | 198 | 284 | CAG5136775.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 522 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 28323401 | 28323401 | PRJNA312615_P_NODE_27126_length_235_cov_1.091398_g26975_i0 | PRJNA312615 | 27126 | 235 | 1.091398 | 2.5647853 | Ostreidae | 6563 | Mollusca | Mollusca | 66.2 | 6.62e-11 | NR | XP_022313052.1 | 6565 | g26975 | i0 | 39.7 | 2.79574468085106 | 73 | 42 | 90.6 | 1 | 218 | 6 | 8 | 80 | XP_022313052.1 exosome complex component RRP40-like [Crassostrea virginica] | diamond | 657 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 28369060 | 28369060 | PRJNA312615_P_NODE_33986_length_210_cov_1.583851_g33835_i0 | PRJNA312615 | 33986 | 210 | 1.583851 | 3.3260871 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 71.2 | 2.1e-12 | NR | KAK7484063.1 | 370345 | g33835 | i0 | 52.4 | 0.9 | 63 | 30 | 90 | 0 | 20 | 208 | 140 | 202 | KAK7484063.1 hypothetical protein BaRGS_00024675 [Batillaria attramentaria] | diamond | 189 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 28607719 | 28607719 | PRJNA312615_P_NODE_37067_length_202_cov_0.928105_g36916_i0 | PRJNA312615 | 37067 | 202 | 0.928105 | 1.8747721 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 1.31e-5 | NR | XP_041378880.1 | 1735272 | g36916 | i0 | 48.3 | 6.37128712871287 | 58 | 30 | 86.1 | 0 | 181 | 8 | 30 | 87 | XP_041378880.1 programmed cell death protein 5-like [Gigantopelta aegis] | diamond | 1287 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28810806 | 28810806 | PRJNA312615_P_NODE_53688_length_165_cov_0.965517_g53537_i0 | PRJNA312615 | 53688 | 165 | 0.965517 | 1.59310305 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.3 | 1.06e-6 | NR | XP_033745667.1 | 6579 | g53537 | i0 | 56.1 | 1.49090909090909 | 41 | 18 | 74.5 | 0 | 41 | 163 | 282 | 322 | XP_033745667.1 uncharacterized protein LOC117331179 [Pecten maximus] | diamond | 246 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 28874238 | 28874238 | PRJNA312615_P_NODE_13828_length_331_cov_1.343972_g13677_i0 | PRJNA312615 | 13828 | 331 | 1.343972 | 4.44854732 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 57.8 | 5.31e-7 | NR | XP_029640763.1 | 2607531 | g13677 | i0 | 37.8 | 0.81570996978852 | 90 | 50 | 81.6 | 2 | 314 | 45 | 289 | 372 | XP_029640763.1 polyadenylate-binding protein 4-like [Octopus sinensis] | diamond | 270 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 29207786 | 29207786 | PRJNA312615_P_NODE_23029_length_254_cov_1.492683_g22878_i0 | PRJNA312615 | 23029 | 254 | 1.492683 | 3.79141482 | Metazoa | 33208 | Mollusca | Mollusca | 121 | 4.27e-31 | NR | XP_064617664.1 | 13599 | g22878 | i0 | 65.1 | 10.7834645669291 | 83 | 29 | 98 | 0 | 6 | 254 | 115 | 197 | XP_064617664.1 glutathionyl-hydroquinone reductase YqjG-like isoform X2 [Liolophura japonica] | diamond | 2739 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 29617724 | 29617724 | PRJNA312615_P_NODE_10950_length_374_cov_0.932308_g10800_i0 | PRJNA312615 | 10950 | 374 | 0.932308 | 3.48683192 | Bivalvia | 6544 | Mollusca | Mollusca | 97.1 | 1.71e-20 | NR | XP_052105175.1 | 6549 | g10800 | i0 | 37.6 | 16.8128342245989 | 117 | 73 | 93.9 | 0 | 351 | 1 | 1328 | 1444 | XP_052105175.1 cytoplasmic dynein 1 heavy chain 1-like isoform X1 [Mytilus californianus] | diamond | 6288 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 29789808 | 29789808 | PRJNA312615_P_NODE_30791_length_220_cov_2.257310_g30640_i0 | PRJNA312615 | 30791 | 220 | 2.25731 | 4.966082 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 47 | 3.74e-4 | NR | KAH3711329.1 | 45954 | g30640 | i0 | 38.6 | 3.36818181818182 | 57 | 35 | 77.7 | 0 | 220 | 50 | 91 | 147 | KAH3711329.1 hypothetical protein DPMN_070834 [Dreissena polymorpha] | diamond | 741 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30565415 | 30565415 | PRJNA312615_P_NODE_43013_length_186_cov_2.218978_g42862_i0 | PRJNA312615 | 43013 | 186 | 2.218978 | 4.12729908 | Opisthokonta | 33154 | Mollusca | Mollusca | 74.3 | 7.25e-14 | NR | XP_014774067.2 | 37653 | g42862 | i0 | 60.4 | 14.0161290322581 | 48 | 19 | 77.4 | 0 | 43 | 186 | 5 | 52 | XP_014774067.2 replication factor C subunit 5 [Octopus bimaculoides] | diamond | 2607 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 30927522 | 30927522 | PRJNA312615_P_NODE_13634_length_333_cov_3.010563_g13483_i0 | PRJNA312615 | 13634 | 333 | 3.010563 | 10.02517479 | Magallana gigas | 29159 | Mollusca | Mollusca | 68.6 | 6.78e-11 | NR | XP_034318848.2 | 29159 | g13483 | i0 | 43.8 | 8.84684684684685 | 73 | 40 | 64.9 | 1 | 103 | 318 | 74 | 146 | XP_034318848.2 procathepsin L [Magallana gigas] | diamond | 2946 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31148084 | 31148084 | PRJNA312615_P_NODE_20255_length_271_cov_0.702703_g20104_i0 | PRJNA312615 | 20255 | 271 | 0.702703 | 1.90432513 | Elysia crispata | 231223 | Mollusca | Mollusca | 42.4 | 0.0353 | NR | KAK3764005.1 | 231223 | g20104 | i0 | 30.4 | 0.874538745387454 | 79 | 44 | 75.3 | 2 | 10 | 213 | 22 | 100 | KAK3764005.1 hypothetical protein RRG08_004369 [Elysia crispata] | diamond | 237 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 31464953 | 31464953 | PRJNA312615_P_NODE_25836_length_241_cov_0.791667_g25685_i0 | PRJNA312615 | 25836 | 241 | 0.791667 | 1.90791747 | Aplysia californica | 6500 | Mollusca | Mollusca | 60.1 | 2.87e-8 | NR | XP_005095836.1 | 6500 | g25685 | i0 | 32.9 | 1.96680497925311 | 79 | 47 | 98.3 | 1 | 241 | 5 | 154 | 226 | XP_005095836.1 26S proteasome non-ATPase regulatory subunit 1 [Aplysia californica] | diamond | 474 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 31464955 | 31464955 | PRJNA312615_P_NODE_32436_length_215_cov_1.198795_g32285_i0 | PRJNA312615 | 32436 | 215 | 1.198795 | 2.57740925 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 89.7 | 7.03e-19 | NR | KAK7498760.1 | 370345 | g32285 | i0 | 60.9 | 0.962790697674419 | 69 | 26 | 94.9 | 1 | 3 | 206 | 298 | 366 | KAK7498760.1 hypothetical protein BaRGS_00009852, partial [Batillaria attramentaria] | diamond | 207 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 31654327 | 31654327 | PRJNA312615_P_NODE_14717_length_320_cov_1.797048_g14566_i0 | PRJNA312615 | 14717 | 320 | 1.797048 | 5.7505536 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 147 | 1.7399999999999999e-38 | NR | CAE1240546.1 | 158019 | g14566 | i0 | 69.6 | 6.834375 | 102 | 31 | 95.6 | 0 | 1 | 306 | 901 | 1002 | CAE1240546.1 CCT3 [Acanthosepion pharaonis] | diamond | 2187 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31988358 | 31988358 | PRJNA312615_P_NODE_24918_length_245_cov_1.040816_g24767_i0 | PRJNA312615 | 24918 | 245 | 1.040816 | 2.5499992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 9.6e-33 | NR | XP_005099417.1 | 6500 | g24767 | i0 | 72 | 24.1102040816327 | 75 | 21 | 91.8 | 0 | 225 | 1 | 29 | 103 | XP_005099417.1 ubiquitin-conjugating enzyme E2-17 kDa isoform X1 [Aplysia californica] | diamond | 5907 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 32115122 | 32115122 | PRJNA312615_P_NODE_27218_length_234_cov_1.929730_g27067_i0 | PRJNA312615 | 27218 | 234 | 1.92973 | 4.5155682 | Unionidae | 47526 | Mollusca | Mollusca | 96.7 | 1.67e-21 | NR | KAL3885451.1 | 1069815 | g27067 | i0 | 68.2 | 2.52564102564103 | 66 | 21 | 84.6 | 0 | 199 | 2 | 10 | 75 | KAL3885451.1 hypothetical protein ACJMK2_025508, partial [Sinanodonta woodiana] | diamond | 591 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 32224075 | 32224075 | PRJNA312615_P_NODE_18418_length_284_cov_1.842553_g18267_i0 | PRJNA312615 | 18418 | 284 | 1.842553 | 5.23285052 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 60.5 | 3.38e-8 | NR | XP_060588978.1 | 129788 | g18267 | i0 | 48.3 | 2.65140845070423 | 60 | 31 | 63.4 | 0 | 185 | 6 | 22 | 81 | XP_060588978.1 proprotein convertase subtilisin/kexin type 5-like [Ruditapes philippinarum] | diamond | 753 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 32319226 | 32319226 | PRJNA312615_P_NODE_17039_length_297_cov_1.233871_g16888_i0 | PRJNA312615 | 17039 | 297 | 1.233871 | 3.66459687 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 80.5 | 3.57e-15 | NR | KAK3086654.1 | 66713 | g16888 | i0 | 41.9 | 3.75757575757576 | 93 | 54 | 93.9 | 0 | 19 | 297 | 242 | 334 | KAK3086654.1 hypothetical protein FSP39_021442 [Pinctada imbricata] | diamond | 1116 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 32368367 | 32368367 | PRJNA312615_P_NODE_51739_length_167_cov_0.864407_g51588_i0 | PRJNA312615 | 51739 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.9 | 7.64e-12 | NR | KAH9502515.1 | 55810 | g51588 | i0 | 62.3 | 1.90419161676647 | 53 | 20 | 95.2 | 0 | 160 | 2 | 693 | 745 | KAH9502515.1 hypothetical protein Btru_068881 [Bulinus truncatus] | diamond | 318 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 32399914 | 32399914 | PRJNA312615_P_NODE_56939_length_163_cov_0.894737_g56788_i0 | PRJNA312615 | 56939 | 163 | 0.894737 | 1.45842131 | Mytilus | 6548 | Mollusca | Mollusca | 64.7 | 1.9e-10 | NR | VDI41404.1 | 29158 | g56788 | i0 | 54.9 | 2.83435582822086 | 51 | 23 | 93.9 | 0 | 163 | 11 | 182 | 232 | VDI41404.1 calcium/calmodulin-dependent protein kinase IV [Mytilus galloprovincialis] | diamond | 462 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 32666409 | 32666409 | PRJNA312615_P_NODE_36560_length_203_cov_1.383117_g36409_i0 | PRJNA312615 | 36560 | 203 | 1.383117 | 2.80772751 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 53.1 | 4.63e-6 | NR | XP_070174997.1 | 31220 | g36409 | i0 | 41.8 | 0.990147783251232 | 67 | 39 | 99 | 0 | 3 | 203 | 420 | 486 | XP_070174997.1 serine hydroxymethyltransferase, mitochondrial-like [Littorina saxatilis] | diamond | 201 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis |
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);;