contig_metadata
21 rows where bioproject = "PRJDB4941", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8937223 | 8937223 | PRJDB4941_P_NODE_22608_length_213_cov_1.237805_g21840_i0 | PRJDB4941 | 22608 | 213 | 1.237805 | 2.63652465 | Mytilus californianus | 6549 | Mollusca | Mollusca | 200 | 6.33e-47 | NTclustered | gi|2334616260|ref|XM_052239736.1| | 6549 | g21840 | i0 | 83.568 | 32.3521126760563 | 213 | 35 | 100 | 0 | 1 | 213 | 334 | 546 | PREDICTED: Mytilus californianus ras-related protein Rab-10-like (LOC127731014), mRNA | blastn | 6891 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 15312441 | 15312441 | PRJDB4941_P_NODE_24213_length_205_cov_1.333333_g23445_i0 | PRJDB4941 | 24213 | 205 | 1.333333 | 2.73333265 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|1914664621|ref|XM_036504900.1| | 2607531 | g23445 | i0 | 96.875 | 0.15609756097561 | 32 | 1 | 16 | 0 | 165 | 196 | 367 | 398 | PREDICTED: Octopus sinensis uncharacterized LOC118764308 (LOC118764308), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 15312731 | 15312731 | PRJDB4941_P_NODE_39933_length_163_cov_0.912281_g39165_i0 | PRJDB4941 | 39933 | 163 | 0.912281 | 1.48701803 | Metazoa | 33208 | Mollusca | Mollusca | 102 | 4.02e-24 | NR | XP_022300531.1 | 6565 | g39165 | i0 | 85.2 | 69.5337423312883 | 54 | 8 | 99.4 | 0 | 1 | 162 | 180 | 233 | XP_022300531.1 mannose-1-phosphate guanyltransferase beta-like [Crassostrea virginica] | diamond | 11334 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 17559436 | 17559436 | PRJDB4941_P_NODE_13314_length_296_cov_2.218623_g12546_i0 | PRJDB4941 | 13314 | 296 | 2.218623 | 6.56712408 | Liolophura japonica | 13599 | Mollusca | Mollusca | 155 | 5.69e-42 | NR | XP_064611039.1 | 13599 | g12546 | i0 | 70.1 | 8.93918918918919 | 97 | 28 | 98.3 | 1 | 1 | 291 | 477 | 572 | XP_064611039.1 LOW QUALITY PROTEIN: phosphoenolpyruvate carboxykinase [GTP]-like [Liolophura japonica] | diamond | 2646 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 22962310 | 22962310 | PRJDB4941_P_NODE_28299_length_188_cov_1.338129_g27531_i0 | PRJDB4941 | 28299 | 188 | 1.338129 | 2.51568252 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g27531 | i0 | 100 | 1.36702127659574 | 30 | 0 | 16 | 0 | 3 | 32 | 13450676 | 13450647 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 257 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24236531 | 24236531 | PRJDB4941_P_NODE_6920_length_469_cov_2.195238_g6152_i0 | PRJDB4941 | 6920 | 469 | 2.195238 | 10.29566622 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.046 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g6152 | i0 | 100 | 0.656716417910448 | 28 | 0 | 6 | 0 | 219 | 246 | 24543521 | 24543548 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 308 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26773396 | 26773396 | PRJDB4941_P_NODE_25921_length_197_cov_1.824324_g25153_i0 | PRJDB4941 | 25921 | 197 | 1.824324 | 3.59391828 | Metazoa | 33208 | Mollusca | Mollusca | 102 | 1.4399999999999994e-23 | NR | XP_033739710.1 | 6579 | g25153 | i0 | 79.7 | 8.48223350253807 | 59 | 12 | 89.8 | 0 | 177 | 1 | 233 | 291 | XP_033739710.1 staphylococcal nuclease domain-containing protein 1-like [Pecten maximus] | diamond | 1671 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27095648 | 27095648 | PRJDB4941_P_NODE_27562_length_191_cov_1.126761_g26794_i0 | PRJDB4941 | 27562 | 191 | 1.126761 | 2.15211351 | Liolophura japonica | 13599 | Mollusca | Mollusca | 62.8 | 1.51e-9 | NR | XP_064607948.1 | 13599 | g26794 | i0 | 47.6 | 1.94764397905759 | 63 | 33 | 99 | 0 | 2 | 190 | 47 | 109 | XP_064607948.1 26S proteasome non-ATPase regulatory subunit 13-like [Liolophura japonica] | diamond | 372 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27285373 | 27285373 | PRJDB4941_P_NODE_31303_length_177_cov_1.625000_g30535_i0 | PRJDB4941 | 31303 | 177 | 1.625 | 2.87625 | Magallana gigas | 29159 | Mollusca | Mollusca | 55.1 | 6.74e-7 | NR | XP_065925947.1 | 29159 | g30535 | i0 | 56 | 4.06779661016949 | 50 | 22 | 84.7 | 0 | 2 | 151 | 834 | 883 | XP_065925947.1 sucrase-isomaltase, intestinal-like [Magallana gigas] | diamond | 720 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 27759389 | 27759389 | PRJDB4941_P_NODE_14684_length_278_cov_2.270742_g13916_i0 | PRJDB4941 | 14684 | 278 | 2.270742 | 6.31266276 | Patella caerulea | 87958 | Mollusca | Mollusca | 119 | 5.06e-29 | NR | KAK6187667.1 | 87958 | g13916 | i0 | 58.7 | 0.992805755395683 | 92 | 38 | 99.3 | 0 | 277 | 2 | 915 | 1006 | KAK6187667.1 hypothetical protein SNE40_005643 [Patella caerulea] | diamond | 276 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28832505 | 28832505 | PRJDB4941_P_NODE_29428_length_184_cov_1.162963_g28660_i0 | PRJDB4941 | 29428 | 184 | 1.162963 | 2.13985192 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 48.5 | 7.74e-5 | NR | KAJ8307558.1 | 220873 | g28660 | i0 | 43.9 | 3.75 | 57 | 28 | 92.9 | 2 | 172 | 2 | 46 | 98 | KAJ8307558.1 hypothetical protein KUTeg_015642, partial [Tegillarca granosa] | diamond | 690 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 28858147 | 28858147 | PRJDB4941_P_NODE_37528_length_165_cov_1.568966_g36760_i0 | PRJDB4941 | 37528 | 165 | 1.568966 | 2.5887939 | Gastropoda | 6448 | Mollusca | Mollusca | 86.7 | 2.64e-19 | NR | KAK7505760.1 | 370345 | g36760 | i0 | 70.6 | 3.70909090909091 | 51 | 15 | 92.7 | 0 | 154 | 2 | 1 | 51 | KAK7505760.1 hypothetical protein BaRGS_00003031 [Batillaria attramentaria] | diamond | 612 | 87.4 | 0.991990846681922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 29647173 | 29647173 | PRJDB4941_P_NODE_21490_length_219_cov_1.835294_g20722_i0 | PRJDB4941 | 21490 | 219 | 1.835294 | 4.01929386 | Metazoa | 33208 | Mollusca | Mollusca | 59.3 | 3.54e-8 | NR | CAI9744319.1 | 6645 | g20722 | i0 | 45.3 | 7.47945205479452 | 64 | 35 | 87.7 | 0 | 2 | 193 | 110 | 173 | CAI9744319.1 Hypothetical predicted protein [Octopus vulgaris] | diamond | 1638 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 31322025 | 31322025 | PRJDB4941_P_NODE_13675_length_291_cov_1.549587_g12907_i0 | PRJDB4941 | 13675 | 291 | 1.549587 | 4.50929817 | Metazoa | 33208 | Mollusca | Mollusca | 144 | 3.59e-39 | NR | XP_045204774.1 | 6596 | g12907 | i0 | 71.1 | 4 | 97 | 28 | 100 | 0 | 291 | 1 | 45 | 141 | XP_045204774.1 probable phosphoglycerate kinase isoform X3 [Mercenaria mercenaria] | diamond | 1164 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32087249 | 32087249 | PRJDB4941_P_NODE_13018_length_301_cov_2.000000_g12250_i0 | PRJDB4941 | 13018 | 301 | 2 | 6.02 | Lymnaea stagnalis | 6523 | Mollusca | Mollusca | 59.3 | 1.01e-7 | NR | CAL1528939.1 | 6523 | g12250 | i0 | 38.5 | 0.906976744186046 | 91 | 54 | 89.7 | 2 | 1 | 270 | 108 | 197 | CAL1528939.1 unnamed protein product [Lymnaea stagnalis] | diamond | 273 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 32144612 | 32144612 | PRJDB4941_P_NODE_31078_length_178_cov_1.612403_g30310_i0 | PRJDB4941 | 31078 | 178 | 1.612403 | 2.87007734 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92.8 | 3.34e-20 | NR | XP_050395124.1 | 6465 | g30310 | i0 | 77.6 | 2.93258426966292 | 58 | 13 | 97.8 | 0 | 3 | 176 | 126 | 183 | XP_050395124.1 T-complex protein 1 subunit alpha [Patella vulgata] | diamond | 522 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32530446 | 32530446 | PRJDB4941_P_NODE_34239_length_169_cov_0.866667_g33471_i0 | PRJDB4941 | 34239 | 169 | 0.866667 | 1.46466723 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 73.2 | 1.81e-13 | NR | XP_041357808.1 | 1735272 | g33471 | i0 | 61.8 | 0.976331360946746 | 55 | 21 | 97.6 | 0 | 167 | 3 | 219 | 273 | XP_041357808.1 transmembrane protein 164-like [Gigantopelta aegis] | diamond | 165 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 32624743 | 32624743 | PRJDB4941_P_NODE_34720_length_168_cov_2.016807_g33952_i0 | PRJDB4941 | 34720 | 168 | 2.016807 | 3.38823576 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 53.9 | 1.5e-6 | NR | XP_052212415.1 | 45954 | g33952 | i0 | 46.8 | 2.51785714285714 | 47 | 25 | 83.9 | 0 | 14 | 154 | 383 | 429 | XP_052212415.1 uncharacterized protein LOC127831467 [Dreissena polymorpha] | diamond | 423 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32807792 | 32807792 | PRJDB4941_P_NODE_12060_length_318_cov_1.089219_g11292_i0 | PRJDB4941 | 12060 | 318 | 1.089219 | 3.46371642 | Metazoa | 33208 | Mollusca | Mollusca | 190 | 1.24e-53 | NR | XP_050409149.1 | 6465 | g11292 | i0 | 87.6 | 28.688679245283 | 105 | 13 | 99.1 | 0 | 3 | 317 | 917 | 1021 | XP_050409149.1 NAD(P) transhydrogenase, mitochondrial isoform X1 [Patella vulgata] | diamond | 9123 | 190 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32807803 | 32807803 | PRJDB4941_P_NODE_39400_length_163_cov_1.763158_g38632_i0 | PRJDB4941 | 39400 | 163 | 1.763158 | 2.87394754 | Mollusca | 6447 | Mollusca | Mollusca | 41.2 | 0.0452 | NR | WAR25753.1 | 6604 | g38632 | i0 | 38.8 | 4.01226993865031 | 49 | 30 | 90.2 | 0 | 156 | 10 | 403 | 451 | WAR25753.1 COG5-like protein, partial [Mya arenaria] | diamond | 654 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32839228 | 32839228 | PRJDB4941_P_NODE_24680_length_203_cov_1.019481_g23912_i0 | PRJDB4941 | 24680 | 203 | 1.019481 | 2.06954643 | Metazoa | 33208 | Mollusca | Mollusca | 42.7 | 0.0225 | NR | KAK7088059.1 | 31220 | g23912 | i0 | 59.5 | 1.16748768472906 | 37 | 15 | 54.7 | 0 | 65 | 175 | 232 | 268 | KAK7088059.1 hypothetical protein V1264_022029 [Littorina saxatilis] | diamond | 237 | 42.7 | 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);;