contig_metadata
21 rows where bioproject = "PRJNA473641", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1719970 | 1719970 | PRJNA473641_P_NODE_24762_length_242_cov_0.911243_g24679_i0 | PRJNA473641 | 24762 | 242 | 0.911243 | 2.20520806 | Haliotis asinina | 109174 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2793372167|ref|XM_067797417.1| | 109174 | g24679 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 14 | 41 | 1194 | 1221 | PREDICTED: Haliotis asinina thioredoxin domain-containing protein-like (LOC137259801), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 2995442 | 2995442 | PRJNA473641_P_NODE_12063_length_295_cov_1.040541_g11980_i0 | PRJNA473641 | 12063 | 295 | 1.040541 | 3.06959595 | Metazoa | 33208 | Mollusca | Mollusca | 171 | 2.3399999999999997e-47 | NR | CAG2218899.1 | 6550 | g11980 | i0 | 81.3 | 18.7016949152542 | 96 | 18 | 97.6 | 0 | 292 | 5 | 582 | 677 | CAG2218899.1 ACO [Mytilus edulis] | diamond | 5517 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 8097925 | 8097925 | PRJNA473641_P_NODE_13767_length_279_cov_1.014563_g13684_i0 | PRJNA473641 | 13767 | 279 | 1.014563 | 2.83063077 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2427486998|ref|XM_052947381.1| | 6604 | g13684 | i0 | 100 | 0.405017921146953 | 29 | 0 | 10 | 0 | 109 | 137 | 711 | 739 | PREDICTED: Mya arenaria calponin homolog OV9M-like (LOC128233620), mRNA | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 8097966 | 8097966 | PRJNA473641_P_NODE_15227_length_266_cov_1.056995_g15144_i0 | PRJNA473641 | 15227 | 266 | 1.056995 | 2.8116067 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g15144 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 209 | 236 | 48676555 | 48676582 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9372877 | 9372877 | PRJNA473641_P_NODE_24168_length_243_cov_0.905882_g24085_i0 | PRJNA473641 | 24168 | 243 | 0.905882 | 2.20129326 | Patella caerulea | 87958 | Mollusca | Mollusca | 255 | 1.5600000000000001e-63 | NTclustered | gi|669205829|gb|KF494230.1| | 87958 | g24085 | i0 | 85.833 | 81.2098765432099 | 240 | 34 | 99 | 0 | 1 | 240 | 558 | 797 | Patella caerulea beta-tubulin mRNA, partial cds | blastn | 19734 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 14473740 | 14473740 | PRJNA473641_P_NODE_24412_length_243_cov_0.905882_g24329_i0 | PRJNA473641 | 24412 | 243 | 0.905882 | 2.20129326 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2034330529|ref|XM_041507349.1| | 1735272 | g24329 | i0 | 96.875 | 0.263374485596708 | 32 | 1 | 13 | 0 | 60 | 91 | 2741 | 2710 | PREDICTED: Gigantopelta aegis acyl-coenzyme A synthetase ACSM3, mitochondrial-like (LOC121378952), transcript variant X1, mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 15747807 | 15747807 | PRJNA473641_P_NODE_2553_length_531_cov_2.237991_g2470_i0 | PRJNA473641 | 2553 | 531 | 2.237991 | 11.88373221 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 199 | 2.8e-62 | NR | XP_070189609.1 | 31220 | g2470 | i0 | 65.3 | 4.25423728813559 | 150 | 51 | 84.7 | 1 | 7 | 456 | 1 | 149 | XP_070189609.1 superoxide dismutase [Cu-Zn]-like [Littorina saxatilis] | diamond | 2259 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 18296892 | 18296892 | PRJNA473641_P_NODE_6735_length_364_cov_0.725086_g6652_i0 | PRJNA473641 | 6735 | 364 | 0.725086 | 2.6393130400000002 | Metazoa | 33208 | Mollusca | Mollusca | 82 | 5.57e-16 | NR | XHY98683.1 | 97200 | g6652 | i0 | 54.1 | 2.8021978021978 | 85 | 39 | 70.1 | 0 | 363 | 109 | 20 | 104 | XHY98683.1 cytochrome c oxidase subunit III [Cepaea hortensis] | diamond | 1020 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cepaea | Cepaea hortensis | |
| 20846722 | 20846722 | PRJNA473641_P_NODE_23777_length_243_cov_0.905882_g23694_i0 | PRJNA473641 | 23777 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 3.64e-5 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g23694 | i0 | 89.583 | 0.197530864197531 | 48 | 5 | 20 | 0 | 149 | 196 | 5670876 | 5670829 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 48 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23397048 | 23397048 | PRJNA473641_P_NODE_13919_length_277_cov_1.509804_g13836_i0 | PRJNA473641 | 13919 | 277 | 1.509804 | 4.18215708 | Physella acuta | 109671 | Mollusca | Mollusca | 239 | 1.82e-58 | NTclustered | gi|2572417298|ref|XM_059322395.1| | 109671 | g13836 | i0 | 85.59 | 33.4837545126354 | 229 | 32 | 82 | 1 | 1 | 228 | 842 | 1070 | PREDICTED: Physella acuta serine/threonine-protein phosphatase alpha-2 isoform (LOC131957656), transcript variant X2, mRNA | blastn | 9275 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 27392408 | 27392408 | PRJNA473641_P_NODE_25723_length_241_cov_0.916667_g25640_i0 | PRJNA473641 | 25723 | 241 | 0.916667 | 2.20916747 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 54.7 | 2.2e-6 | NR | XP_052251345.1 | 45954 | g25640 | i0 | 41.3 | 1.79253112033195 | 75 | 37 | 90.9 | 3 | 234 | 16 | 246 | 315 | XP_052251345.1 UBX domain-containing protein 6-like [Dreissena polymorpha] | diamond | 432 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28023825 | 28023825 | PRJNA473641_P_NODE_4145_length_438_cov_1.326027_g4062_i0 | PRJNA473641 | 4145 | 438 | 1.326027 | 5.80799826 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 94.7 | 8.63e-22 | NR | KAH3866887.1 | 45954 | g4062 | i0 | 57.7 | 0.486301369863014 | 71 | 30 | 48.6 | 0 | 205 | 417 | 60 | 130 | KAH3866887.1 hypothetical protein DPMN_030010 [Dreissena polymorpha] | diamond | 213 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28212920 | 28212920 | PRJNA473641_P_NODE_19826_length_248_cov_0.880000_g19743_i0 | PRJNA473641 | 19826 | 248 | 0.88 | 2.1824 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 61.2 | 1.16e-8 | NR | XP_041363619.1 | 1735272 | g19743 | i0 | 44.3 | 1.80241935483871 | 79 | 43 | 95.6 | 1 | 2 | 238 | 242 | 319 | XP_041363619.1 synaptotagmin-15-like [Gigantopelta aegis] | diamond | 447 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28576626 | 28576626 | PRJNA473641_P_NODE_18007_length_250_cov_0.870056_g17924_i0 | PRJNA473641 | 18007 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Mollusca | Mollusca | 123 | 1.63e-33 | NR | XP_022345525.1 | 6565 | g17924 | i0 | 73.2 | 1.968 | 82 | 22 | 98.4 | 0 | 2 | 247 | 10 | 91 | XP_022345525.1 soma ferritin-like [Crassostrea virginica] | diamond | 492 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29460422 | 29460422 | PRJNA473641_P_NODE_1630_length_642_cov_1.397188_g1548_i0 | PRJNA473641 | 1630 | 642 | 1.397188 | 8.96994696 | Metazoa | 33208 | Mollusca | Mollusca | 252 | 7.59e-75 | NR | XP_055862496.1 | 6526 | g1548 | i0 | 59 | 15.4158878504673 | 210 | 82 | 98.1 | 2 | 13 | 642 | 432 | 637 | XP_055862496.1 major vault protein-like [Biomphalaria glabrata] | diamond | 9897 | 253 | 0.99604743083004 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29855120 | 29855120 | PRJNA473641_P_NODE_22031_length_245_cov_1.343023_g21948_i0 | PRJNA473641 | 22031 | 245 | 1.343023 | 3.29040635 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 70.5 | 6.06e-12 | NR | XP_045204505.2 | 6596 | g21948 | i0 | 60 | 1.83673469387755 | 50 | 20 | 61.2 | 0 | 8 | 157 | 377 | 426 | XP_045204505.2 argininosuccinate synthase-like [Mercenaria mercenaria] | diamond | 450 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29934576 | 29934576 | PRJNA473641_P_NODE_20171_length_248_cov_0.880000_g20088_i0 | PRJNA473641 | 20171 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Mollusca | Mollusca | 127 | 6.69e-33 | NR | XP_064595148.1 | 13599 | g20088 | i0 | 72 | 15.8709677419355 | 82 | 23 | 99.2 | 0 | 246 | 1 | 196 | 277 | XP_064595148.1 S-adenosylmethionine synthase-like [Liolophura japonica] | diamond | 3936 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 30392586 | 30392586 | PRJNA473641_P_NODE_18713_length_249_cov_0.875000_g18630_i0 | PRJNA473641 | 18713 | 249 | 0.875 | 2.17875 | Mya arenaria | 6604 | Mollusca | Mollusca | 48.9 | 2.69e-4 | NR | XP_052787882.1 | 6604 | g18630 | i0 | 60.6 | 1.19277108433735 | 33 | 13 | 39.8 | 0 | 242 | 144 | 962 | 994 | XP_052787882.1 adenylate kinase isoenzyme 5-like isoform X10 [Mya arenaria] | diamond | 297 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32479233 | 32479233 | PRJNA473641_P_NODE_23799_length_243_cov_0.905882_g23716_i0 | PRJNA473641 | 23799 | 243 | 0.905882 | 2.20129326 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 74.3 | 2.69e-13 | NR | CAE1274822.1 | 158019 | g23716 | i0 | 71.1 | 0.555555555555556 | 45 | 13 | 55.6 | 0 | 2 | 136 | 416 | 460 | CAE1274822.1 psd [Acanthosepion pharaonis] | diamond | 135 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32699748 | 32699748 | PRJNA473641_P_NODE_3720_length_457_cov_1.593750_g3637_i0 | PRJNA473641 | 3720 | 457 | 1.59375 | 7.2834375 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 93.6 | 2.98e-21 | NR | KAH3866887.1 | 45954 | g3637 | i0 | 57.7 | 0.466083150984683 | 71 | 30 | 46.6 | 0 | 327 | 115 | 60 | 130 | KAH3866887.1 hypothetical protein DPMN_030010 [Dreissena polymorpha] | diamond | 213 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32857268 | 32857268 | PRJNA473641_P_NODE_22500_length_245_cov_0.895349_g22417_i0 | PRJNA473641 | 22500 | 245 | 0.895349 | 2.19360505 | Argopecten irradians | 31199 | Mollusca | Mollusca | 42.7 | 0.0365 | NR | XP_069107634.1 | 31199 | g22417 | i0 | 29.4 | 0.83265306122449 | 68 | 39 | 72.2 | 1 | 67 | 243 | 92 | 159 | XP_069107634.1 uncharacterized protein [Argopecten irradians] | diamond | 204 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians |
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);;