contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA854078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2117029 | 2117029 | PRJNA854078_P_NODE_11842_length_274_cov_1.149254_g11630_i0 | PRJNA854078 | 11842 | 274 | 1.149254 | 3.14895596 | Physella acuta | 109671 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2572412036|ref|XM_059320643.1| | 109671 | g11630 | i0 | 100 | 0.211678832116788 | 29 | 0 | 11 | 0 | 178 | 206 | 1687 | 1715 | PREDICTED: Physella acuta serine/arginine repetitive matrix protein 1-like (LOC131956225), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 5062826 | 5062826 | PRJNA854078_P_NODE_2244_length_638_cov_5.615929_g2041_i0 | PRJNA854078 | 2244 | 638 | 5.615929 | 35.82962702 | Metazoa | 33208 | Mollusca | Mollusca | 425 | 3.24e-114 | NTclustered | gi|304561050|gb|HM163175.1| | 6500 | g2041 | i0 | 83.857 | 67.9592476489028 | 446 | 72 | 70 | 0 | 19 | 464 | 325 | 770 | Aplysia californica calmodulin-like mRNA, partial sequence | blastn | 43358 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 7219908 | 7219908 | PRJNA854078_P_NODE_6786_length_362_cov_2.411765_g6574_i0 | PRJNA854078 | 6786 | 362 | 2.411765 | 8.7305893 | Lottia gigantea | 225164 | Mollusca | Mollusca | 291 | 6.68e-74 | NTclustered | gi|676441220|ref|XM_009051178.1| | 225164 | g6574 | i0 | 81.461 | 90.4640883977901 | 356 | 64 | 98 | 2 | 8 | 362 | 1436 | 1082 | Lottia gigantea hypothetical protein mRNA | blastn | 32748 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 8494620 | 8494620 | PRJNA854078_P_NODE_5827_length_391_cov_2.735849_g5615_i0 | PRJNA854078 | 5827 | 391 | 2.735849 | 10.69716959 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 272 | 2.6399999999999996e-68 | NTclustered | gi|2669127327|ref|XM_062740740.1| | 36930 | g5615 | i0 | 79.381 | 73.7442455242967 | 388 | 79 | 99 | 1 | 1 | 388 | 419 | 33 | PREDICTED: Saccostrea cucullata ubiquitin-ribosomal protein eL40 fusion protein (LOC134258198), mRNA | blastn | 28834 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 8494626 | 8494626 | PRJNA854078_P_NODE_6327_length_375_cov_1.274834_g6115_i0 | PRJNA854078 | 6327 | 375 | 1.274834 | 4.7806275 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.65e-5 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g6115 | i0 | 80.488 | 0.834666666666667 | 82 | 16 | 22 | 0 | 141 | 222 | 18832786 | 18832867 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 313 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11045394 | 11045394 | PRJNA854078_P_NODE_6809_length_362_cov_1.065744_g6597_i0 | PRJNA854078 | 6809 | 362 | 1.065744 | 3.85799328 | Argopecten irradians | 31199 | Mollusca | Mollusca | 76.8 | 2.04e-9 | NTclustered | gi|2835344959|ref|XM_069286508.1| | 31199 | g6597 | i0 | 94 | 1.6243093922651901 | 50 | 3 | 14 | 0 | 171 | 220 | 6651 | 6602 | PREDICTED: Argopecten irradians uncharacterized protein (LOC138336890), mRNA | blastn | 588 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 12714350 | 12714350 | PRJNA854078_P_NODE_16770_length_239_cov_4.024096_g16558_i0 | PRJNA854078 | 16770 | 239 | 4.024096 | 9.61758944 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2669119147|ref|XM_062736641.1| | 36930 | g16558 | i0 | 100 | 0.242677824267782 | 29 | 0 | 12 | 0 | 57 | 85 | 2353 | 2381 | PREDICTED: Saccostrea cucullata uncharacterized LOC134254077 (LOC134254077), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 17419883 | 17419883 | PRJNA854078_P_NODE_1574_length_761_cov_1.696221_g1384_i0 | PRJNA854078 | 1574 | 761 | 1.696221 | 12.90824181 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 165 | 9.4e-36 | NTclustered | gi|2616585348|ref|XM_060722064.1| | 129788 | g1384 | i0 | 72.251 | 9.78843626806833 | 573 | 145 | 74 | 12 | 196 | 761 | 3116 | 2551 | PREDICTED: Ruditapes philippinarum myosin heavy chain, striated muscle-like (LOC132735150), transcript variant X10, mRNA | blastn | 7449 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 17419900 | 17419900 | PRJNA854078_P_NODE_1794_length_713_cov_2.631250_g1596_i0 | PRJNA854078 | 1794 | 713 | 2.63125 | 18.7608125 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 0.002 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g1596 | i0 | 97.059 | 0.94249649368864 | 34 | 1 | 5 | 0 | 72 | 105 | 22237722 | 22237689 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 672 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17419924 | 17419924 | PRJNA854078_P_NODE_4814_length_433_cov_1.044444_g4602_i0 | PRJNA854078 | 4814 | 433 | 1.044444 | 4.52244252 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 54.7 | 0.012 | NTclustered | gi|1914624425|ref|XM_029799907.2| | 2607531 | g4602 | i0 | 100 | 0.133949191685912 | 29 | 0 | 7 | 0 | 324 | 352 | 1685 | 1713 | PREDICTED: Octopus sinensis protein FAM76B (LOC115229571), transcript variant X2, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 17419933 | 17419933 | PRJNA854078_P_NODE_5634_length_398_cov_18.753846_g5422_i0 | PRJNA854078 | 5634 | 398 | 18.753846 | 74.64030708 | Aplysia californica | 6500 | Mollusca | Mollusca | 156 | 2.82e-33 | NTclustered | gi|871245195|ref|XM_005102366.2| | 6500 | g5422 | i0 | 83.432 | 1.48241206030151 | 169 | 27 | 42 | 1 | 44 | 212 | 853 | 686 | PREDICTED: Aplysia californica helicase SRCAP-like (LOC101860347), mRNA | blastn | 590 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 17419949 | 17419949 | PRJNA854078_P_NODE_7234_length_350_cov_2.678700_g7022_i0 | PRJNA854078 | 7234 | 350 | 2.6787 | 9.37545 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 191 | 6.72e-44 | NTclustered | gi|2694129250|ref|XM_063541376.1| | 6551 | g7022 | i0 | 79.699 | 4.06571428571429 | 266 | 53 | 76 | 1 | 11 | 276 | 428 | 164 | PREDICTED: Mytilus trossulus dynein light chain 2, cytoplasmic-like (LOC134681737), mRNA | blastn | 1423 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 17812272 | 17812272 | PRJNA854078_P_NODE_9034_length_313_cov_1.283333_g8822_i0 | PRJNA854078 | 9034 | 313 | 1.283333 | 4.01683229 | Metazoa | 33208 | Mollusca | Mollusca | 209 | 1.64e-49 | NTclustered | gi|1835452215|ref|XM_033891393.1| | 6579 | g8822 | i0 | 79.661 | 15.220447284345 | 295 | 56 | 94 | 4 | 1 | 293 | 1221 | 1513 | PREDICTED: Pecten maximus AP-1 complex subunit beta-1-like (LOC117332477), mRNA | blastn | 4764 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 22518369 | 22518369 | PRJNA854078_P_NODE_10238_length_294_cov_1.149321_g10026_i0 | PRJNA854078 | 10238 | 294 | 1.149321 | 3.37900374 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 278 | 4.13e-70 | NTclustered | gi|2616654774|ref|XM_060745390.1| | 129788 | g10026 | i0 | 84.982 | 93.9591836734694 | 273 | 41 | 93 | 0 | 22 | 294 | 1424 | 1152 | PREDICTED: Ruditapes philippinarum tubulin beta chain-like (LOC132754715), mRNA | blastn | 27624 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 22518476 | 22518476 | PRJNA854078_P_NODE_598_length_1226_cov_2.221162_g476_i0 | PRJNA854078 | 598 | 1226 | 2.221162 | 27.23144612 | Mytilus californianus | 6549 | Mollusca | Mollusca | 80.5 | 5.74e-10 | NTclustered | gi|2334622051|ref|XM_052204670.1| | 6549 | g476 | i0 | 80.18 | 0.0905383360522023 | 111 | 19 | 9 | 2 | 977 | 1084 | 3601 | 3491 | PREDICTED: Mytilus californianus dentin sialophosphoprotein-like (LOC127700936), mRNA | blastn | 111 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 24186333 | 24186333 | PRJNA854078_P_NODE_7099_length_353_cov_2.410714_g6887_i0 | PRJNA854078 | 7099 | 353 | 2.410714 | 8.50982042 | Metazoa | 33208 | Mollusca | Mollusca | 63.9 | 1.54e-5 | NTclustered | gi|2751300715|ref|XM_034455183.2| | 29159 | g6887 | i0 | 95.122 | 14.8980169971671 | 41 | 0 | 11 | 2 | 35 | 73 | 1323 | 1283 | PREDICTED: Magallana gigas clusterin-associated protein 1 homolog (LOC105333862), transcript variant X1, mRNA | blastn | 5259 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 25067831 | 25067831 | PRJNA854078_P_NODE_640_length_1197_cov_10.387011_g512_i0 | PRJNA854078 | 640 | 1197 | 10.387011 | 124.33252167 | Lottia gigantea | 225164 | Mollusca | Mollusca | 869 | 0 | NTclustered | gi|676492495|ref|XM_009067688.1| | 225164 | g512 | i0 | 79.95 | 100.322472848789 | 1202 | 223 | 99 | 16 | 1 | 1193 | 168 | 1360 | Lottia gigantea hypothetical protein mRNA | blastn | 120086 | 869 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 25461468 | 25461468 | PRJNA854078_P_NODE_8540_length_321_cov_1.794355_g8328_i0 | PRJNA854078 | 8540 | 321 | 1.794355 | 5.75987955 | Veneridae | 6592 | Mollusca | Mollusca | 265 | 3.55e-66 | NTclustered | gi|2442039890|ref|XM_045358071.2| | 6596 | g8328 | i0 | 82.68 | 93.2180685358256 | 306 | 45 | 94 | 8 | 13 | 314 | 954 | 653 | PREDICTED: Mercenaria mercenaria myosin heavy chain, striated muscle-like (LOC123564457), transcript variant X2, mRNA | blastn | 29923 | 267 | 0.99250936329588 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria |
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);;