contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132502 | 132502 | PRJEB66218_P_NODE_217381_length_207_cov_0.890411_g214951_i0 | PRJEB66218 | 217381 | 207 | 0.890411 | 1.84315077 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 58.4 | 3.89e-4 | NTclustered | gi|1397691824|ref|XM_025239464.1| | 400727 | g214951 | i0 | 94.737 | 1.1207729468599 | 38 | 0 | 18 | 2 | 103 | 139 | 469 | 505 | PREDICTED: Pomacea canaliculata 5-hydroxytryptamine receptor-like (LOC112564566), transcript variant X1, mRNA | blastn | 232 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 3545393 | 3545393 | PRJEB66218_P_NODE_37443_length_579_cov_149.743243_g35054_i0 | PRJEB66218 | 37443 | 579 | 149.743243 | 867.01337697 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 167 | 1.96e-36 | NTclustered | gi|1772640078|gb|MN644814.1| | 6523 | g35054 | i0 | 92.308 | 20.2020725388601 | 117 | 9 | 20 | 0 | 14 | 130 | 2775 | 2659 | Lymnaea stagnalis isolate lyms2 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence. | blastn | 11697 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 3956570 | 3956570 | PRJEB66218_P_NODE_106564_length_295_cov_1.329060_g104135_i0 | PRJEB66218 | 106564 | 295 | 1.32906 | 3.920727 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 69.4 | 2.72e-7 | NTclustered | gi|1207947024|ref|XM_021507704.1| | 6573 | g104135 | i0 | 100 | 7.49152542372881 | 37 | 0 | 13 | 0 | 191 | 227 | 5422 | 5458 | PREDICTED: Mizuhopecten yessoensis E3 ubiquitin-protein ligase RBBP6-like (LOC110456758), mRNA | blastn | 2210 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 5233825 | 5233825 | PRJEB66218_P_NODE_144485_length_246_cov_2.551351_g142056_i0 | PRJEB66218 | 144485 | 246 | 2.551351 | 6.27632346 | Mya arenaria | 6604 | Mollusca | Mollusca | 278 | 3.37e-70 | NTclustered | gi|2427433625|ref|XM_052932938.1| | 6604 | g142056 | i0 | 87.764 | 95.0934959349593 | 237 | 29 | 96 | 0 | 6 | 242 | 581 | 817 | PREDICTED: Mya arenaria actin, adductor muscle (LOC128223661), mRNA | blastn | 23393 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 5235122 | 5235122 | PRJEB66218_P_NODE_222225_length_206_cov_0.896552_g219795_i0 | PRJEB66218 | 222225 | 206 | 0.896552 | 1.84689712 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g219795 | i0 | 100 | 0.140776699029126 | 29 | 0 | 14 | 0 | 124 | 152 | 8505315 | 8505343 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7785428 | 7785428 | PRJEB66218_P_NODE_28467_length_695_cov_1.936909_g26183_i0 | PRJEB66218 | 28467 | 695 | 1.936909 | 13.46151755 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 60.2 | 4.15e-4 | NTclustered | gi|2868653294|ref|XM_070329413.1| | 31220 | g26183 | i0 | 87.273 | 0.20431654676259 | 55 | 3 | 8 | 4 | 425 | 478 | 2017 | 2068 | PREDICTED: Littorina saxatilis polycystin-2-like (LOC138958303), mRNA | blastn | 142 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 8647700 | 8647700 | PRJEB66218_P_NODE_211227_length_208_cov_0.884354_g208797_i0 | PRJEB66218 | 211227 | 208 | 0.884354 | 1.83945632 | Opisthokonta | 33154 | Mollusca | Mollusca | 58.4 | 3.92e-4 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g208797 | i0 | 100 | 4.19230769230769 | 31 | 0 | 15 | 0 | 6 | 36 | 29285750 | 29285780 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 872 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10334990 | 10334990 | PRJEB66218_P_NODE_181009_length_220_cov_1.792453_g178579_i0 | PRJEB66218 | 181009 | 220 | 1.792453 | 3.9433966 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g178579 | i0 | 100 | 0.127272727272727 | 28 | 0 | 13 | 0 | 179 | 206 | 40460841 | 40460814 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12885812 | 12885812 | PRJEB66218_P_NODE_195651_length_212_cov_1.086093_g193221_i0 | PRJEB66218 | 195651 | 212 | 1.086093 | 2.30251716 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2427395627|ref|XM_052919925.1| | 6604 | g193221 | i0 | 100 | 0.273584905660377 | 29 | 0 | 14 | 0 | 89 | 117 | 802 | 774 | PREDICTED: Mya arenaria ATP-dependent RNA helicase DDX4-like (LOC128213857), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 14159283 | 14159283 | PRJEB66218_P_NODE_126512_length_266_cov_1.609756_g124083_i0 | PRJEB66218 | 126512 | 266 | 1.609756 | 4.28195096 | Lyonsia floridana | 192014 | Mollusca | Mollusca | 63.9 | 1.12e-5 | NTclustered | gi|557884338|gb|KC429451.1| | 192014 | g124083 | i0 | 83.333 | 1.37593984962406 | 72 | 9 | 26 | 3 | 6 | 75 | 626 | 556 | Lyonsia floridana voucher BivAToL-248 28S ribosomal RNA gene, partial sequence | blastn | 366 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lyonsiidae | Lyonsia | Lyonsia floridana | ||
| 14159736 | 14159736 | PRJEB66218_P_NODE_146132_length_245_cov_1.304348_g143703_i0 | PRJEB66218 | 146132 | 245 | 1.304348 | 3.1956526 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2507332674|ref|XR_008800178.1| | 37623 | g143703 | i0 | 100 | 0.914285714285714 | 28 | 0 | 11 | 0 | 132 | 159 | 7382 | 7355 | PREDICTED: Ostrea edulis uncharacterized LOC130051910 (LOC130051910), transcript variant X2, ncRNA | blastn | 224 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 14162902 | 14162902 | PRJEB66218_P_NODE_83732_length_343_cov_1.826241_g81305_i0 | PRJEB66218 | 83732 | 343 | 1.826241 | 6.26400663 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g81305 | i0 | 100 | 0.0845481049562682 | 29 | 0 | 8 | 0 | 290 | 318 | 36432203 | 36432231 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16297403 | 16297403 | PRJEB66218_P_NODE_250793_length_167_cov_4.367925_g248361_i0 | PRJEB66218 | 250793 | 167 | 4.367925 | 7.29443475 | Saccostrea | 33508 | Mollusca | Mollusca | 104 | 3.81e-18 | NTclustered | gi|2669107797|ref|XM_062733005.1| | 36930 | g248361 | i0 | 79.333 | 10.251497005988 | 150 | 29 | 89 | 2 | 5 | 153 | 769 | 621 | PREDICTED: Saccostrea cucullata ATP synthase subunit alpha, mitochondrial-like (LOC134250655), mRNA | blastn | 1712 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 17572827 | 17572827 | PRJEB66218_P_NODE_46054_length_505_cov_3.268018_g43638_i0 | PRJEB66218 | 46054 | 505 | 3.268018 | 16.5034909 | Metazoa | 33208 | Mollusca | Mollusca | 257 | 9.75e-64 | NTclustered | gi|23304764|emb|AJ492925.1| | 6550 | g43638 | i0 | 78.365 | 87.6039603960396 | 416 | 76 | 81 | 11 | 76 | 484 | 2993 | 2585 | Mytilus edulis h4 gene for histone H4 and h3 gene for histone H3, cluster UW27 | blastn | 44240 | 259 | 0.992277992277992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 17982253 | 17982253 | PRJEB66218_P_NODE_116195_length_280_cov_1.570776_g113766_i0 | PRJEB66218 | 116195 | 280 | 1.570776 | 4.3981728 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 62.1 | 4.29e-5 | NTclustered | gi|1914635704|ref|XM_029790946.2| | 2607531 | g113766 | i0 | 92.857 | 3.66428571428571 | 42 | 3 | 15 | 0 | 194 | 235 | 2224 | 2265 | PREDICTED: Octopus sinensis mucin-5AC (LOC115220797), transcript variant X7, mRNA | blastn | 1026 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 19256995 | 19256995 | PRJEB66218_P_NODE_150556_length_241_cov_1.444444_g148127_i0 | PRJEB66218 | 150556 | 241 | 1.444444 | 3.48111004 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 4.66e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g148127 | i0 | 97.059 | 3.48547717842324 | 34 | 1 | 14 | 0 | 82 | 115 | 19705916 | 19705949 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 840 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19257837 | 19257837 | PRJEB66218_P_NODE_200156_length_210_cov_2.610738_g197726_i0 | PRJEB66218 | 200156 | 210 | 2.610738 | 5.4825498 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 62.1 | 3.06e-5 | NTclustered | gi|1697432384|ref|XM_029778678.1| | 2607531 | g197726 | i0 | 100 | 1.08571428571429 | 33 | 0 | 16 | 0 | 1 | 33 | 1255 | 1287 | PREDICTED: Octopus sinensis uncharacterized transmembrane protein DDB_G0289901-like (LOC115210209), mRNA | blastn | 228 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 21396923 | 21396923 | PRJEB66218_P_NODE_29217_length_683_cov_1.972669_g26920_i0 | PRJEB66218 | 29217 | 683 | 1.972669 | 13.47332927 | Metazoa | 33208 | Mollusca | Mollusca | 475 | 3.409999999999999e-129 | NTclustered | gi|2868689553|ref|XM_070348318.1| | 31220 | g26920 | i0 | 80.349 | 34.6427525622255 | 631 | 120 | 92 | 4 | 51 | 679 | 6330 | 5702 | PREDICTED: Littorina saxatilis pre-mRNA-processing-splicing factor 8 (LOC138975601), mRNA | blastn | 23661 | 479 | 0.991649269311065 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 21807295 | 21807295 | PRJEB66218_P_NODE_110858_length_288_cov_1.392070_g108429_i0 | PRJEB66218 | 110858 | 288 | 1.39207 | 4.0091616 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2364504203|ref|XM_052365519.1| | 45954 | g108429 | i0 | 100 | 0.201388888888889 | 29 | 0 | 10 | 0 | 254 | 282 | 1656 | 1684 | PREDICTED: Dreissena polymorpha transmembrane protease serine 12-like (LOC127838016), mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 23084722 | 23084722 | PRJEB66218_P_NODE_242999_length_200_cov_2.194245_g240568_i0 | PRJEB66218 | 242999 | 200 | 2.194245 | 4.38849 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|1697373228|ref|XM_029798093.1| | 2607531 | g240568 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 61 | 88 | 451 | 478 | PREDICTED: Octopus sinensis uncharacterized LOC115227180 (LOC115227180), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 23085127 | 23085127 | PRJEB66218_P_NODE_35359_length_603_cov_1.608856_g32979_i0 | PRJEB66218 | 35359 | 603 | 1.608856 | 9.70140168 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g32979 | i0 | 96.97 | 0.054726368159204 | 33 | 1 | 5 | 0 | 351 | 383 | 21969534 | 21969566 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24358100 | 24358100 | PRJEB66218_P_NODE_202120_length_210_cov_0.872483_g199690_i0 | PRJEB66218 | 202120 | 210 | 0.872483 | 1.8322143 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g199690 | i0 | 100 | 0.138095238095238 | 29 | 0 | 14 | 0 | 107 | 135 | 41643302 | 41643274 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24358574 | 24358574 | PRJEB66218_P_NODE_233820_length_203_cov_1.605634_g231389_i0 | PRJEB66218 | 233820 | 203 | 1.605634 | 3.25943702 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2628521745|ref|XM_061333771.1| | 191078 | g231389 | i0 | 100 | 0.285714285714286 | 30 | 0 | 15 | 0 | 168 | 197 | 1910 | 1939 | PREDICTED: Saccostrea echinata meckelin-like (LOC133197653), mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 24358787 | 24358787 | PRJEB66218_P_NODE_249800_length_175_cov_293.140351_g247368_i0 | PRJEB66218 | 249800 | 175 | 293.140351 | 512.99561425 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 86.1 | 1.45e-12 | NTclustered | gi|1697405627|ref|XR_003882427.1| | 2607531 | g247368 | i0 | 84.884 | 37.4 | 86 | 12 | 49 | 1 | 1 | 85 | 23 | 108 | PREDICTED: Octopus sinensis U2 spliceosomal RNA (LOC115220039), ncRNA | blastn | 6545 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis |
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);;