contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 617732 | 617732 | PRJNA641991_P_NODE_1861_length_225_cov_3.312500_g1820_i0 | PRJNA641991 | 1861 | 225 | 3.3125 | 7.453125 | Patella vulgata | 6465 | Mollusca | Mollusca | 148 | 2.4799999999999996e-31 | NTclustered | gi|2506339294|ref|XM_050559146.2| | 6465 | g1820 | i0 | 88.525 | 33.8488888888889 | 122 | 14 | 54 | 0 | 104 | 225 | 1527 | 1406 | PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain-like (LOC130010330), mRNA | blastn | 7616 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 617758 | 617758 | PRJNA641991_S_NODE_14081_length_162_cov_1.805310_g13962_i0 | PRJNA641991 | 14081 | 162 | 1.80531 | 2.9246022 | Physella acuta | 109671 | Mollusca | Mollusca | 300 | 4.36e-77 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g13962 | i0 | 100 | 3.44444444444444 | 162 | 0 | 100 | 0 | 1 | 162 | 3507 | 3668 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 558 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 617795 | 617795 | PRJNA641991_S_NODE_7661_length_201_cov_1.000000_g7542_i0 | PRJNA641991 | 7661 | 201 | 1 | 2.01 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 143 | 1.01e-29 | NTclustered | gi|2502112072|ref|XM_013228045.2| | 6526 | g7542 | i0 | 80.423 | 3.07462686567164 | 189 | 35 | 94 | 2 | 14 | 201 | 813 | 626 | PREDICTED: Biomphalaria glabrata speckle-type POZ protein-like (LOC106068615), transcript variant X1, mRNA | blastn | 618 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 617798 | 617798 | PRJNA641991_S_NODE_8421_length_193_cov_1.576389_g8302_i0 | PRJNA641991 | 8421 | 193 | 1.576389 | 3.04243077 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 9.94e-5 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g8302 | i0 | 100 | 0.911917098445596 | 32 | 0 | 17 | 0 | 2 | 33 | 72718772 | 72718741 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 176 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1893976 | 1893976 | PRJNA641991_P_NODE_882_length_359_cov_1.316129_g841_i0 | PRJNA641991 | 882 | 359 | 1.316129 | 4.72490311 | Yoldia hyperborea | 1421154 | Mollusca | Mollusca | 73.1 | 2.61e-8 | NTclustered | gi|2732679548|gb|PP541907.1| | 1421154 | g841 | i0 | 93.75 | 0.133704735376045 | 48 | 3 | 13 | 0 | 19 | 66 | 11890 | 11843 | Yoldia hyperborea mitochondrion, complete genome | blastn | 48 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Nuculanida sp. | Yoldiidae | Yoldia | Yoldia hyperborea | |
| 2433545 | 2433545 | PRJNA641991_S_NODE_3362_length_287_cov_4.457983_g3243_i0 | PRJNA641991 | 3362 | 287 | 4.457983 | 12.79441121 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.59e-4 | NTclustered | gi|2364461295|ref|XM_052427394.1| | 45954 | g3243 | i0 | 100 | 5.54703832752613 | 32 | 0 | 11 | 0 | 102 | 133 | 1616 | 1585 | PREDICTED: Dreissena polymorpha uncharacterized LOC127880161 (LOC127880161), mRNA | blastn | 1592 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 3168604 | 3168604 | PRJNA641991_S_NODE_10263_length_178_cov_1.186047_g10144_i0 | PRJNA641991 | 10263 | 178 | 1.186047 | 2.11116366 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g10144 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 23 | 50 | 72205154 | 72205127 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5721303 | 5721303 | PRJNA641991_S_NODE_12105_length_167_cov_0.864407_g11986_i0 | PRJNA641991 | 12105 | 167 | 0.864407 | 1.44355969 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 75 | 2.99e-9 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g11986 | i0 | 92.453 | 35.6347305389222 | 53 | 3 | 31 | 1 | 1 | 52 | 18896175 | 18896227 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 5951 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5721328 | 5721328 | PRJNA641991_S_NODE_7105_length_207_cov_1.613924_g6986_i0 | PRJNA641991 | 7105 | 207 | 1.613924 | 3.34082268 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 165 | 2.23e-36 | NTclustered | gi|2693983665|ref|XM_063553461.1| | 6551 | g6986 | i0 | 81.773 | 79.9130434782609 | 203 | 31 | 97 | 6 | 2 | 201 | 1042 | 1241 | PREDICTED: Mytilus trossulus actin, adductor muscle (LOC134692851), mRNA | blastn | 16542 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 6996356 | 6996356 | PRJNA641991_S_NODE_5666_length_228_cov_1.139665_g5547_i0 | PRJNA641991 | 5666 | 228 | 1.139665 | 2.5984362 | Patella vulgata | 6465 | Mollusca | Mollusca | 187 | 5.339999999999998e-43 | NTclustered | gi|2506326383|ref|XM_050545779.2| | 6465 | g5547 | i0 | 82.775 | 21.8333333333333 | 209 | 36 | 92 | 0 | 20 | 228 | 4087 | 3879 | PREDICTED: Patella vulgata probable global transcription activator SNF2L2 (LOC126818384), transcript variant X1, mRNA | blastn | 4978 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 8271042 | 8271042 | PRJNA641991_S_NODE_1727_length_397_cov_6.505747_g1608_i0 | PRJNA641991 | 1727 | 397 | 6.505747 | 25.82781559 | Yoldia hyperborea | 1421154 | Mollusca | Mollusca | 73.1 | 2.92e-8 | NTclustered | gi|2732679548|gb|PP541907.1| | 1421154 | g1608 | i0 | 93.75 | 0.120906801007557 | 48 | 3 | 12 | 0 | 333 | 380 | 11843 | 11890 | Yoldia hyperborea mitochondrion, complete genome | blastn | 48 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Nuculanida sp. | Yoldiidae | Yoldia | Yoldia hyperborea | |
| 10822002 | 10822002 | PRJNA641991_S_NODE_3689_length_275_cov_10.933628_g3570_i0 | PRJNA641991 | 3689 | 275 | 10.933628 | 30.067477 | Haliotis diversicolor | 36095 | Mollusca | Mollusca | 189 | 1.8499999999999993e-43 | NTclustered | gi|363894933|gb|JN997413.1| | 36095 | g3570 | i0 | 84.103 | 21.0290909090909 | 195 | 31 | 71 | 0 | 24 | 218 | 263 | 69 | Haliotis diversicolor putative tubulin beta chain (TUBB) mRNA, complete cds | blastn | 5783 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis diversicolor | |
| 10822015 | 10822015 | PRJNA641991_S_NODE_5529_length_230_cov_3.011050_g5410_i0 | PRJNA641991 | 5529 | 230 | 3.01105 | 6.925415 | Lottia gigantea | 225164 | Mollusca | Mollusca | 198 | 2.49e-46 | NTclustered | gi|676453046|ref|XM_009054981.1| | 225164 | g5410 | i0 | 88.024 | 24.8304347826087 | 167 | 20 | 73 | 0 | 58 | 224 | 124 | 290 | Lottia gigantea hypothetical protein mRNA | blastn | 5711 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 10822018 | 10822018 | PRJNA641991_S_NODE_649_length_645_cov_3.196309_g545_i0 | PRJNA641991 | 649 | 645 | 3.196309 | 20.61619305 | Patella vulgata | 6465 | Mollusca | Mollusca | 316 | 2.0599999999999999e-81 | NTclustered | gi|2296492132|ref|XM_050552576.1| | 6465 | g545 | i0 | 80.045 | 6.21550387596899 | 441 | 77 | 67 | 8 | 212 | 645 | 660 | 224 | PREDICTED: Patella vulgata S-phase kinase-associated protein 1 (LOC130010351), mRNA | blastn | 4009 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 10822024 | 10822024 | PRJNA641991_S_NODE_7169_length_206_cov_4.197452_g7050_i0 | PRJNA641991 | 7169 | 206 | 4.197452 | 8.64675112 | Lottia gigantea | 225164 | Mollusca | Mollusca | 213 | 7.81e-51 | NTclustered | gi|676453046|ref|XM_009054981.1| | 225164 | g7050 | i0 | 90.244 | 27.3300970873786 | 164 | 15 | 80 | 1 | 1 | 164 | 282 | 120 | Lottia gigantea hypothetical protein mRNA | blastn | 5630 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 11361810 | 11361810 | PRJNA641991_S_NODE_9049_length_187_cov_12.217391_g8930_i0 | PRJNA641991 | 9049 | 187 | 12.217391 | 22.84652117 | Metazoa | 33208 | Mollusca | Mollusca | 159 | 9.169999999999999e-35 | NTclustered | gi|2334673389|ref|XM_052235946.1| | 6549 | g8930 | i0 | 88.06 | 68.0374331550802 | 134 | 16 | 72 | 0 | 1 | 134 | 1350 | 1483 | PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127728525), mRNA | blastn | 12723 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 13912395 | 13912395 | PRJNA641991_P_NODE_2431_length_195_cov_1.397260_g2390_i0 | PRJNA641991 | 2431 | 195 | 1.39726 | 2.724657 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|1242837483|ref|XM_022444164.1| | 6565 | g2390 | i0 | 100 | 5.43589743589744 | 30 | 0 | 15 | 0 | 46 | 75 | 422 | 393 | PREDICTED: Crassostrea virginica suppressor of tumorigenicity 7 protein homolog (LOC111108353), transcript variant X1, mRNA | blastn | 1060 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 14646679 | 14646679 | PRJNA641991_P_NODE_992_length_334_cov_3.785965_g951_i0 | PRJNA641991 | 992 | 334 | 3.785965 | 12.6451231 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 104 | 8.57e-18 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g951 | i0 | 78.488 | 7.97604790419162 | 172 | 27 | 51 | 8 | 166 | 334 | 3686 | 3522 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 2664 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 15186870 | 15186870 | PRJNA641991_S_NODE_5192_length_236_cov_2.128342_g5073_i0 | PRJNA641991 | 5192 | 236 | 2.128342 | 5.02288712 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|1242781760|ref|XM_022475024.1| | 6565 | g5073 | i0 | 100 | 1.44067796610169 | 28 | 0 | 12 | 0 | 191 | 218 | 435 | 462 | PREDICTED: Crassostrea virginica uncharacterized LOC111129000 (LOC111129000), mRNA | blastn | 340 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 15920603 | 15920603 | PRJNA641991_S_NODE_10673_length_175_cov_1.214286_g10554_i0 | PRJNA641991 | 10673 | 175 | 1.214286 | 2.1250005 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 115 | 1.85e-21 | NTclustered | gi|1207920271|ref|XM_021493376.1| | 6573 | g10554 | i0 | 81.507 | 1.66857142857143 | 146 | 21 | 82 | 6 | 2 | 144 | 285 | 143 | PREDICTED: Mizuhopecten yessoensis protein SET-like (LOC110447586), mRNA | blastn | 292 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 19744631 | 19744631 | PRJNA641991_S_NODE_3556_length_280_cov_1.861472_g3437_i0 | PRJNA641991 | 3556 | 280 | 1.861472 | 5.2121216 | Patella vulgata | 6465 | Mollusca | Mollusca | 167 | 8.83e-37 | NTclustered | gi|2506339511|ref|XM_050561182.2| | 6465 | g3437 | i0 | 89.552 | 39.1857142857143 | 134 | 11 | 47 | 1 | 1 | 131 | 1311 | 1444 | PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain (LOC126830781), mRNA | blastn | 10972 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 19744644 | 19744644 | PRJNA641991_S_NODE_5296_length_234_cov_2.940541_g5177_i0 | PRJNA641991 | 5296 | 234 | 2.940541 | 6.88086594 | Patella vulgata | 6465 | Mollusca | Mollusca | 148 | 2.6e-31 | NTclustered | gi|2506339294|ref|XM_050559146.2| | 6465 | g5177 | i0 | 88.525 | 32.5470085470085 | 122 | 14 | 52 | 0 | 113 | 234 | 1527 | 1406 | PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain-like (LOC130010330), mRNA | blastn | 7616 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 23570520 | 23570520 | PRJNA641991_S_NODE_7459_length_203_cov_1.246753_g7340_i0 | PRJNA641991 | 7459 | 203 | 1.246753 | 2.53090859 | Lottia gigantea | 225164 | Mollusca | Mollusca | 185 | 1.67e-42 | NTclustered | gi|676441926|ref|XM_009051394.1| | 225164 | g7340 | i0 | 83.168 | 16.6600985221675 | 202 | 34 | 99 | 0 | 2 | 203 | 138 | 339 | Lottia gigantea hypothetical protein mRNA | blastn | 3382 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 24844073 | 24844073 | PRJNA641991_P_NODE_1260_length_286_cov_2.118143_g1219_i0 | PRJNA641991 | 1260 | 286 | 2.118143 | 6.05788898 | Mytilus edulis | 6550 | Mollusca | Mollusca | 300 | 8.55e-77 | NTclustered | gi|2912438933|ref|XM_071270510.1| | 6550 | g1219 | i0 | 85.664 | 100.713286713287 | 286 | 39 | 99 | 2 | 1 | 285 | 1178 | 1462 | PREDICTED: Mytilus edulis tubulin beta-4B chain-like (LOC139485864), transcript variant X1, mRNA | blastn | 28804 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 24844101 | 24844101 | PRJNA641991_S_NODE_13760_length_163_cov_0.894737_g13641_i0 | PRJNA641991 | 13760 | 163 | 0.894737 | 1.45842131 | Patella vulgata | 6465 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2506334046|ref|XM_050552151.2| | 6465 | g13641 | i0 | 100 | 0.177914110429448 | 29 | 0 | 18 | 0 | 14 | 42 | 392 | 420 | PREDICTED: Patella vulgata protein PFC0760c (LOC126823359), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata |
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);;