contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA335774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1665445 | 1665445 | PRJNA335774_P_NODE_47662_length_242_cov_0.893491_g47510_i0 | PRJNA335774 | 47662 | 242 | 0.893491 | 2.16224822 | Pecten maximus | 6579 | Mollusca | Mollusca | 161 | 3.47e-35 | NTclustered | gi|1835552186|ref|XM_033872714.1| | 6579 | g47510 | i0 | 79.079 | 26.0165289256198 | 239 | 46 | 98 | 4 | 2 | 238 | 1938 | 1702 | PREDICTED: Pecten maximus DNA topoisomerase 2-alpha-like (LOC117317785), transcript variant X1, mRNA | blastn | 6296 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 1665533 | 1665533 | PRJNA335774_P_NODE_6822_length_540_cov_7.884368_g6671_i0 | PRJNA335774 | 6822 | 540 | 7.884368 | 42.5755872 | Mya arenaria | 6604 | Mollusca | Mollusca | 320 | 1.32e-82 | NTclustered | gi|2427451445|ref|XM_052935098.1| | 6604 | g6671 | i0 | 79.775 | 22.9074074074074 | 445 | 87 | 82 | 2 | 43 | 484 | 525 | 81 | PREDICTED: Mya arenaria 40S ribosomal protein S14a (LOC128225079), mRNA | blastn | 12370 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 1665599 | 1665599 | PRJNA335774_P_NODE_9222_length_475_cov_1.291045_g9070_i0 | PRJNA335774 | 9222 | 475 | 1.291045 | 6.13246375 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 250 | 1.5299999999999998e-61 | NTclustered | gi|2868688395|ref|XM_070347769.1| | 31220 | g9070 | i0 | 85.957 | 48.8147368421053 | 235 | 31 | 49 | 2 | 242 | 475 | 705 | 472 | PREDICTED: Littorina saxatilis GTP-binding nuclear protein Ran (LOC138975111), transcript variant X2, mRNA | blastn | 23187 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 2941126 | 2941126 | PRJNA335774_P_NODE_32243_length_278_cov_0.985366_g32091_i0 | PRJNA335774 | 32243 | 278 | 0.985366 | 2.73931748 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 62.1 | 4.25e-5 | NTclustered | gi|2364495683|ref|XM_052361784.1| | 45954 | g32091 | i0 | 92.857 | 0.302158273381295 | 42 | 3 | 15 | 0 | 53 | 94 | 206 | 165 | PREDICTED: Dreissena polymorpha myosin essential light chain, striated adductor muscle-like (LOC127835386), mRNA | blastn | 84 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 4217204 | 4217204 | PRJNA335774_P_NODE_1024_length_1133_cov_1.775472_g963_i0 | PRJNA335774 | 1024 | 1133 | 1.775472 | 20.11609776 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 610 | 1.5199999999999993e-169 | NTclustered | gi|1397655111|ref|XM_025254853.1| | 400727 | g963 | i0 | 78.675 | 75.2903795233892 | 966 | 171 | 83 | 28 | 184 | 1129 | 2822 | 1872 | PREDICTED: Pomacea canaliculata myosin heavy chain, striated muscle-like (LOC112574048), mRNA | blastn | 85304 | 610 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 6172511 | 6172511 | PRJNA335774_P_NODE_2325_length_838_cov_1.409150_g2205_i0 | PRJNA335774 | 2325 | 838 | 1.40915 | 11.808677 | Magallana | 147004 | Mollusca | Mollusca | 551 | 6.8199999999999975e-152 | NTclustered | gi|2751300383|ref|XM_011447624.4| | 29159 | g2205 | i0 | 79.974 | 38.4200477326969 | 759 | 143 | 90 | 9 | 1 | 756 | 292 | 1044 | PREDICTED: Magallana gigas small ribosomal subunit protein RACK1 (LOC105341228), mRNA | blastn | 32196 | 556 | 0.991007194244604 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 6767607 | 6767607 | PRJNA335774_P_NODE_12606_length_415_cov_2.605263_g12454_i0 | PRJNA335774 | 12606 | 415 | 2.605263 | 10.81184145 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 195 | 6.269999999999999e-45 | NTclustered | gi|2868671985|ref|XM_070345200.1| | 31220 | g12454 | i0 | 79.443 | 61.2313253012048 | 287 | 49 | 68 | 7 | 56 | 337 | 146 | 427 | PREDICTED: Littorina saxatilis small ribosomal subunit protein eS25-like (LOC138972551), mRNA | blastn | 25411 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 9318144 | 9318144 | PRJNA335774_P_NODE_18248_length_355_cov_2.503546_g18096_i0 | PRJNA335774 | 18248 | 355 | 2.503546 | 8.8875883000000009 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 231 | 4.02e-56 | NTclustered | gi|1397655111|ref|XM_025254853.1| | 400727 | g18096 | i0 | 79.07 | 9.00281690140845 | 344 | 66 | 96 | 4 | 11 | 351 | 5050 | 4710 | PREDICTED: Pomacea canaliculata myosin heavy chain, striated muscle-like (LOC112574048), mRNA | blastn | 3196 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 9318926 | 9318926 | PRJNA335774_P_NODE_7928_length_506_cov_1.251732_g7776_i0 | PRJNA335774 | 7928 | 506 | 1.251732 | 6.33376392 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 6.36e-6 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g7776 | i0 | 97.368 | 0.41304347826087 | 38 | 1 | 8 | 0 | 294 | 331 | 32069438 | 32069475 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 209 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9997772 | 9997772 | PRJNA335774_P_NODE_29928_length_288_cov_0.776744_g29776_i0 | PRJNA335774 | 29928 | 288 | 0.776744 | 2.23702272 | Metazoa | 33208 | Mollusca | Mollusca | 171 | 7.05e-38 | NTclustered | gi|2194124276|ref|XM_046718142.1| | 36100 | g29776 | i0 | 78.707 | 15.8576388888889 | 263 | 51 | 90 | 5 | 29 | 288 | 3823 | 3563 | PREDICTED: Haliotis rubra eukaryotic translation initiation factor 5B-like (LOC124282177), mRNA | blastn | 4567 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 13144314 | 13144314 | PRJNA335774_P_NODE_46071_length_243_cov_1.247059_g45919_i0 | PRJNA335774 | 46071 | 243 | 1.247059 | 3.03035337 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2502140036|ref|XM_013239253.2| | 6526 | g45919 | i0 | 100 | 0.123456790123457 | 30 | 0 | 12 | 0 | 91 | 120 | 1959 | 1930 | PREDICTED: Biomphalaria glabrata U11/U12 small nuclear ribonucleoprotein 25 kDa protein-like (LOC106078396), transcript variant X1, mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 15097506 | 15097506 | PRJNA335774_P_NODE_37592_length_256_cov_0.994536_g37440_i0 | PRJNA335774 | 37592 | 256 | 0.994536 | 2.54601216 | Haliotis | 6452 | Mollusca | Mollusca | 274 | 4.5599999999999997e-69 | NTclustered | gi|2245653637|ref|XM_046513517.2| | 6454 | g37440 | i0 | 90.431 | 80.5234375 | 209 | 18 | 81 | 2 | 49 | 256 | 1421 | 1214 | PREDICTED: Haliotis rufescens tubulin alpha-1A chain-like (LOC124144221), mRNA | blastn | 20614 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 15693291 | 15693291 | PRJNA335774_P_NODE_39113_length_251_cov_0.865169_g38961_i0 | PRJNA335774 | 39113 | 251 | 0.865169 | 2.17157419 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g38961 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 5 | 32 | 24623149 | 24623176 | 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 | |
| 15693295 | 15693295 | PRJNA335774_P_NODE_39273_length_251_cov_0.865169_g39121_i0 | PRJNA335774 | 39273 | 251 | 0.865169 | 2.17157419 | Aplysia californica | 6500 | Mollusca | Mollusca | 220 | 5.89e-53 | NTclustered | gi|1897932155|ref|XM_035971079.1| | 6500 | g39121 | i0 | 83.475 | 59.6334661354582 | 236 | 39 | 94 | 0 | 13 | 248 | 2612 | 2377 | PREDICTED: Aplysia californica calcium-transporting ATPase sarcoplasmic/endoplasmic reticulum type (LOC101846151), mRNA | blastn | 14968 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 15693389 | 15693389 | PRJNA335774_P_NODE_43713_length_246_cov_0.890173_g43561_i0 | PRJNA335774 | 43713 | 246 | 0.890173 | 2.18982558 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1835491654|ref|XM_033893785.1| | 6579 | g43561 | i0 | 100 | 0.235772357723577 | 29 | 0 | 12 | 0 | 94 | 122 | 438 | 466 | PREDICTED: Pecten maximus tRNA (guanine(26)-N(2))-dimethyltransferase-like (LOC117334272), transcript variant X2, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 18241643 | 18241643 | PRJNA335774_P_NODE_13855_length_399_cov_0.944785_g13703_i0 | PRJNA335774 | 13855 | 399 | 0.944785 | 3.76969215 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 134 | 1.33e-26 | NTclustered | gi|2616675258|ref|XM_060698203.1| | 129788 | g13703 | i0 | 88.496 | 1.68170426065163 | 113 | 10 | 28 | 2 | 182 | 291 | 347 | 235 | PREDICTED: Ruditapes philippinarum ornithine decarboxylase antizyme 1-like (LOC132715212), mRNA | blastn | 671 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 19516221 | 19516221 | PRJNA335774_P_NODE_29036_length_291_cov_2.784404_g28884_i0 | PRJNA335774 | 29036 | 291 | 2.784404 | 8.10261564 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2572411827|ref|XM_059320587.1| | 109671 | g28884 | i0 | 96.774 | 0.106529209621993 | 31 | 1 | 11 | 0 | 20 | 50 | 2135 | 2165 | PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 20791536 | 20791536 | PRJNA335774_P_NODE_15717_length_378_cov_1.659016_g15565_i0 | PRJNA335774 | 15717 | 378 | 1.659016 | 6.27108048 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 401 | 3.099999999999999e-107 | NTclustered | gi|2245706711|ref|XM_048385483.1| | 6454 | g15565 | i0 | 89.13 | 82.9338624338624 | 322 | 35 | 85 | 0 | 57 | 378 | 39 | 360 | PREDICTED: Haliotis rufescens tubulin beta chain-like (LOC124142795), transcript variant X3, mRNA | blastn | 31349 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 20791670 | 20791670 | PRJNA335774_P_NODE_21737_length_330_cov_2.443580_g21585_i0 | PRJNA335774 | 21737 | 330 | 2.44358 | 8.063814 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 346 | 1.2699999999999999e-90 | NTclustered | gi|2868682307|ref|XM_070325706.1| | 31220 | g21585 | i0 | 87.375 | 76.5181818181818 | 301 | 38 | 91 | 0 | 10 | 310 | 218 | 518 | PREDICTED: Littorina saxatilis ubiquitin-ribosomal protein eS31 fusion protein (LOC138953797), mRNA | blastn | 25251 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 20791680 | 20791680 | PRJNA335774_P_NODE_22317_length_327_cov_0.964567_g22165_i0 | PRJNA335774 | 22317 | 327 | 0.964567 | 3.15413409 | Liolophura japonica | 13599 | Mollusca | Mollusca | 122 | 2.3099999999999999e-23 | NTclustered | gi|2724258914|ref|XM_064755315.1| | 13599 | g22165 | i0 | 75.954 | 3.03669724770642 | 262 | 49 | 78 | 12 | 28 | 282 | 2724 | 2470 | PREDICTED: Liolophura japonica rootletin-like (LOC135475426), transcript variant X2, mRNA | blastn | 993 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 22066703 | 22066703 | PRJNA335774_P_NODE_23898_length_318_cov_1.126531_g23746_i0 | PRJNA335774 | 23898 | 318 | 1.126531 | 3.58236858 | Haliotis asinina | 109174 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2793389343|ref|XM_067806475.1| | 109174 | g23746 | i0 | 96.97 | 0.415094339622642 | 33 | 1 | 10 | 0 | 275 | 307 | 7390 | 7358 | PREDICTED: Haliotis asinina neurogenic locus Notch protein-like (LOC137273682), transcript variant X1, mRNA | blastn | 132 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 24616448 | 24616448 | PRJNA335774_P_NODE_2660_length_794_cov_1.299584_g2532_i0 | PRJNA335774 | 2660 | 794 | 1.299584 | 10.31869696 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 355 | 5.42e-93 | NTclustered | gi|2868622250|ref|XM_070342082.1| | 31220 | g2532 | i0 | 75.425 | 76.7909319899244 | 765 | 170 | 95 | 15 | 8 | 763 | 3776 | 3021 | PREDICTED: Littorina saxatilis myosin heavy chain, striated muscle-like (LOC138969316), mRNA | blastn | 60972 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 24616538 | 24616538 | PRJNA335774_P_NODE_30460_length_285_cov_1.452830_g30308_i0 | PRJNA335774 | 30460 | 285 | 1.45283 | 4.1405655 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 309 | 1.41e-79 | NTclustered | gi|2868688395|ref|XM_070347769.1| | 31220 | g30308 | i0 | 86.525 | 99.4736842105263 | 282 | 36 | 99 | 2 | 3 | 283 | 663 | 383 | PREDICTED: Littorina saxatilis GTP-binding nuclear protein Ran (LOC138975111), transcript variant X2, mRNA | blastn | 28350 | 309 | 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);;