contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1253303" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 359313 | 359313 | PRJNA1253303_P_NODE_3001_length_311_cov_1.201681_g2979_i0 | PRJNA1253303 | 3001 | 311 | 1.201681 | 3.73722791 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 364 | 3.289999999999999e-96 | NTclustered | gi|2616635104|ref|XM_060736297.1| | 129788 | g2979 | i0 | 88.197 | 48.0610932475884 | 305 | 36 | 98 | 0 | 1 | 305 | 203 | 507 | PREDICTED: Ruditapes philippinarum small ribosomal subunit protein eS12-like (LOC132746991), mRNA | blastn | 14947 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 1052583 | 1052583 | PRJNA1253303_P_NODE_2521_length_332_cov_1.660232_g2499_i0 | PRJNA1253303 | 2521 | 332 | 1.660232 | 5.51197024 | Metazoa | 33208 | Mollusca | Mollusca | 496 | 1.2e-135 | NTclustered | gi|1928112766|gb|MT947789.1| | 6523 | g2499 | i0 | 100 | 79.9096385542169 | 268 | 0 | 81 | 0 | 65 | 332 | 19 | 286 | Lymnaea stagnalis isolate Lsta_466444 hypothetical protein mRNA, complete cds | blastn | 26530 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 2910137 | 2910137 | PRJNA1253303_P_NODE_4263_length_269_cov_1.489796_g4241_i0 | PRJNA1253303 | 4263 | 269 | 1.489796 | 4.00755124 | Meretrix meretrix | 291251 | Mollusca | Mollusca | 303 | 6.16e-78 | NTclustered | gi|1031915601|gb|KU301769.1| | 291251 | g4241 | i0 | 87.452 | 10.0855018587361 | 263 | 33 | 98 | 0 | 3 | 265 | 39 | 301 | Meretrix meretrix QM protein mRNA, complete cds | blastn | 2713 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Meretrix | Meretrix meretrix | |
| 2910153 | 2910153 | PRJNA1253303_P_NODE_4863_length_253_cov_1.627778_g4841_i0 | PRJNA1253303 | 4863 | 253 | 1.627778 | 4.11827834 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 213 | 9.95e-51 | NTclustered | gi|2034296730|ref|XM_041506630.1| | 1735272 | g4841 | i0 | 82.186 | 15.4150197628458 | 247 | 44 | 98 | 0 | 7 | 253 | 552 | 306 | PREDICTED: Gigantopelta aegis ribosome biogenesis protein NSA2 homolog (LOC121378455), mRNA | blastn | 3900 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 4186633 | 4186633 | PRJNA1253303_P_NODE_7904_length_244_cov_0.912281_g7882_i0 | PRJNA1253303 | 7904 | 244 | 0.912281 | 2.22596564 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 130 | 9.88e-26 | NTclustered | gi|2442081054|ref|XM_045360689.2| | 6596 | g7882 | i0 | 76.695 | 0.967213114754098 | 236 | 53 | 96 | 2 | 11 | 244 | 70 | 305 | PREDICTED: Mercenaria mercenaria 60S ribosomal protein L36-like (LOC123566514), mRNA | blastn | 236 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 5462715 | 5462715 | PRJNA1253303_P_NODE_145_length_1100_cov_14.365141_g132_i0 | PRJNA1253303 | 145 | 1100 | 14.365141 | 158.016551 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 2013 | 0 | NTclustered | gi|1824661622|ref|NC_046410.1| | 45949 | g132 | i0 | 99.727 | 50.6218181818182 | 1100 | 2 | 100 | 1 | 1 | 1100 | 5404 | 4306 | Corbicula fluminea mitochondrion, complete genome | blastn | 55684 | 2013 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 6737265 | 6737265 | PRJNA1253303_P_NODE_7986_length_243_cov_1.370588_g7964_i0 | PRJNA1253303 | 7986 | 243 | 1.370588 | 3.33052884 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 132 | 2.7300000000000003e-26 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g7964 | i0 | 81.935 | 0.637860082304527 | 155 | 28 | 64 | 0 | 18 | 172 | 12459858 | 12459704 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 155 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8012918 | 8012918 | PRJNA1253303_P_NODE_5307_length_252_cov_0.871508_g5285_i0 | PRJNA1253303 | 5307 | 252 | 0.871508 | 2.19620016 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 464 | 2.4799999999999998e-126 | NTclustered | gi|406679533|gb|JQ781172.1| | 45949 | g5285 | i0 | 100 | 54.9484126984127 | 251 | 0 | 99 | 0 | 2 | 252 | 551 | 301 | Corbicula fluminea voucher BATOL 242.1A elongation factor 1 alpha gene, partial cds | blastn | 13847 | 464 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 8012965 | 8012965 | PRJNA1253303_P_NODE_7367_length_245_cov_1.808140_g7345_i0 | PRJNA1253303 | 7367 | 245 | 1.80814 | 4.429943 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 231 | 2.65e-56 | NTclustered | gi|2442018265|ref|XM_045319064.2| | 6596 | g7345 | i0 | 84.454 | 0.971428571428571 | 238 | 33 | 96 | 4 | 1 | 235 | 33 | 269 | PREDICTED: Mercenaria mercenaria 60S ribosomal protein L12-like (LOC123536159), mRNA | blastn | 238 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 8012968 | 8012968 | PRJNA1253303_P_NODE_747_length_561_cov_2.590164_g725_i0 | PRJNA1253303 | 747 | 561 | 2.590164 | 14.53082004 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 409 | 2.85e-109 | NTclustered | gi|2616670019|ref|XM_060695428.1| | 129788 | g725 | i0 | 82.721 | 72.3351158645276 | 463 | 76 | 82 | 4 | 101 | 561 | 1551 | 1091 | PREDICTED: Ruditapes philippinarum elongation factor 1-alpha (LOC132712989), transcript variant X2, mRNA | blastn | 40580 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 9287726 | 9287726 | PRJNA1253303_P_NODE_8328_length_242_cov_0.923077_g8306_i0 | PRJNA1253303 | 8328 | 242 | 0.923077 | 2.23384634 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 379 | 8.800000000000001e-101 | NTclustered | gi|1001822956|gb|KT781099.1| | 45949 | g8306 | i0 | 95.021 | 45.6487603305785 | 241 | 12 | 99 | 0 | 2 | 242 | 467 | 227 | Corbicula fluminea heat shock protein 90 mRNA, complete cds | blastn | 11047 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 10563566 | 10563566 | PRJNA1253303_P_NODE_6329_length_249_cov_0.886364_g6307_i0 | PRJNA1253303 | 6329 | 249 | 0.886364 | 2.20704636 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 460 | 3.16e-125 | NTclustered | gi|194594386|gb|EU660782.1| | 45949 | g6307 | i0 | 100 | 99.9759036144578 | 249 | 0 | 100 | 0 | 1 | 249 | 626 | 874 | Corbicula fluminea isolate CfI1 18S ribosomal RNA gene, partial sequence | blastn | 24894 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 13113244 | 13113244 | PRJNA1253303_P_NODE_1671_length_393_cov_1.459375_g1649_i0 | PRJNA1253303 | 1671 | 393 | 1.459375 | 5.73534375 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 399 | 1.1699999999999998e-106 | NTclustered | gi|2616579303|ref|XM_060720318.1| | 129788 | g1649 | i0 | 85.347 | 7.14249363867684 | 389 | 54 | 98 | 3 | 7 | 393 | 67 | 454 | PREDICTED: Ruditapes philippinarum small ribosomal subunit protein uS10 (LOC132733657), mRNA | blastn | 2807 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 13113270 | 13113270 | PRJNA1253303_P_NODE_2811_length_319_cov_0.878049_g2789_i0 | PRJNA1253303 | 2811 | 319 | 0.878049 | 2.80097631 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 475 | 1.5e-129 | NTclustered | gi|619498806|gb|KJ461738.1| | 45949 | g2789 | i0 | 93.691 | 86.4137931034483 | 317 | 20 | 99 | 0 | 1 | 317 | 1836 | 1520 | Corbicula fluminea clone 01024008 heat shock protein 70 (HSP70) mRNA, complete cds | blastn | 27566 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 14388567 | 14388567 | PRJNA1253303_P_NODE_4792_length_255_cov_1.417582_g4770_i0 | PRJNA1253303 | 4792 | 255 | 1.417582 | 3.6148341 | Magallana angulata | 2784310 | Mollusca | Mollusca | 239 | 1.66e-58 | NTclustered | gi|2416975210|ref|XM_052827149.1| | 2784310 | g4770 | i0 | 92.262 | 59.1882352941176 | 168 | 13 | 66 | 0 | 88 | 255 | 1516 | 1349 | PREDICTED: Crassostrea angulata tubulin alpha-1A chain-like (LOC128163529), mRNA | blastn | 15093 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 15662349 | 15662349 | PRJNA1253303_P_NODE_5553_length_251_cov_0.876404_g5531_i0 | PRJNA1253303 | 5553 | 251 | 0.876404 | 2.19977404 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 459 | 1.1499999999999996e-124 | NTclustered | gi|1824661622|ref|NC_046410.1| | 45949 | g5531 | i0 | 99.602 | 15.6215139442231 | 251 | 1 | 100 | 0 | 1 | 251 | 15242 | 14992 | Corbicula fluminea mitochondrion, complete genome | blastn | 3921 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 18211152 | 18211152 | PRJNA1253303_P_NODE_4015_length_277_cov_0.901961_g3993_i0 | PRJNA1253303 | 4015 | 277 | 0.901961 | 2.49843197 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 139 | 1.9000000000000003e-28 | NTclustered | gi|2364399209|ref|XM_052410257.1| | 45954 | g3993 | i0 | 90.476 | 5.17328519855596 | 105 | 10 | 38 | 0 | 24 | 128 | 587 | 483 | PREDICTED: Dreissena polymorpha 60S ribosomal protein L10-like (LOC127868455), mRNA | blastn | 1433 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 19485554 | 19485554 | PRJNA1253303_P_NODE_996_length_489_cov_1.081731_g974_i0 | PRJNA1253303 | 996 | 489 | 1.081731 | 5.28966459 | Ostrea edulis | 37623 | Mollusca | Mollusca | 374 | 8.959999999999997e-99 | NTclustered | gi|2507384176|ref|XM_048903695.2| | 37623 | g974 | i0 | 80.864 | 25.4969325153374 | 486 | 83 | 98 | 9 | 1 | 481 | 1083 | 603 | PREDICTED: Ostrea edulis 60S ribosomal protein L3-like (LOC125669256), mRNA | blastn | 12468 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 22036128 | 22036128 | PRJNA1253303_P_NODE_4078_length_275_cov_1.297030_g4056_i0 | PRJNA1253303 | 4078 | 275 | 1.29703 | 3.5668325 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 350 | 8e-92 | NTclustered | gi|2442031565|ref|XM_045328087.2| | 6596 | g4056 | i0 | 89.781 | 11.8290909090909 | 274 | 26 | 99 | 2 | 1 | 272 | 380 | 107 | PREDICTED: Mercenaria mercenaria 40S ribosomal protein S27 (LOC123542300), mRNA | blastn | 3253 | 350 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 23311699 | 23311699 | PRJNA1253303_P_NODE_5819_length_250_cov_1.254237_g5797_i0 | PRJNA1253303 | 5819 | 250 | 1.254237 | 3.1355925 | Liolophura japonica | 13599 | Mollusca | Mollusca | 171 | 5.99e-38 | NTclustered | gi|2724228812|ref|XM_064739343.1| | 13599 | g5797 | i0 | 79.916 | 64.552 | 239 | 43 | 95 | 4 | 1 | 238 | 684 | 918 | PREDICTED: Liolophura japonica heat shock cognate 71 kDa protein-like (LOC135462013), mRNA | blastn | 16138 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 25278679 | 25278679 | PRJNA1253303_P_NODE_4140_length_273_cov_1.560000_g4118_i0 | PRJNA1253303 | 4140 | 273 | 1.56 | 4.2588 | Corbicula | 45948 | Mollusca | Mollusca | 505 | 1.6e-138 | NTclustered | gi|85540743|gb|DQ343848.1| | 45949 | g4118 | i0 | 100 | 100.18315018315 | 273 | 0 | 100 | 0 | 1 | 273 | 818 | 1090 | Corbicula fluminea 28S ribosomal RNA gene, partial sequence | blastn | 27350 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea |
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);;