contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2073934 | 2073934 | PRJNA800090_P_NODE_181022_length_232_cov_2.073620_g178837_i0 | PRJNA800090 | 181022 | 232 | 2.07362 | 4.8107984 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 126 | 1.2099999999999999e-24 | NTclustered | gi|2442043959|ref|XM_045303941.2| | 6596 | g178837 | i0 | 77.725 | 14.2370689655172 | 211 | 44 | 91 | 3 | 3 | 213 | 918 | 711 | PREDICTED: Mercenaria mercenaria calreticulin-like (LOC123525149), mRNA | blastn | 3303 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 2075353 | 2075353 | PRJNA800090_P_NODE_66042_length_423_cov_1.906780_g63858_i0 | PRJNA800090 | 66042 | 423 | 1.90678 | 8.0656794 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 141 | 8.45e-29 | NTclustered | gi|1914669191|ref|XM_036506310.1| | 2607531 | g63858 | i0 | 74.167 | 11.063829787234 | 360 | 84 | 84 | 8 | 27 | 381 | 1258 | 1613 | PREDICTED: Octopus sinensis serine/threonine-protein kinase 26 (LOC115216674), transcript variant X10, mRNA | blastn | 4680 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 4626399 | 4626399 | PRJNA800090_P_NODE_173684_length_235_cov_1.710843_g171499_i0 | PRJNA800090 | 173684 | 235 | 1.710843 | 4.02048105 | Haliotis asinina | 109174 | Mollusca | Mollusca | 69.4 | 2.09e-7 | NTclustered | gi|2793397844|ref|XM_067810916.1| | 109174 | g171499 | i0 | 80.682 | 1.49787234042553 | 88 | 17 | 37 | 0 | 148 | 235 | 754 | 667 | PREDICTED: Haliotis asinina 26S proteasome non-ATPase regulatory subunit 14 (LOC137278529), transcript variant X3, mRNA | blastn | 352 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 5901048 | 5901048 | PRJNA800090_P_NODE_152125_length_254_cov_1.556757_g149940_i0 | PRJNA800090 | 152125 | 254 | 1.556757 | 3.95416278 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g149940 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 227 | 254 | 56994007 | 56994034 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11001971 | 11001971 | PRJNA800090_P_NODE_178789_length_233_cov_1.756098_g176604_i0 | PRJNA800090 | 178789 | 233 | 1.756098 | 4.09170834 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|1207966085|ref|XM_021517915.1| | 6573 | g176604 | i0 | 94.118 | 0.291845493562232 | 34 | 2 | 15 | 0 | 19 | 52 | 2116 | 2149 | PREDICTED: Mizuhopecten yessoensis protein SMG7-like (LOC110463379), transcript variant X3, mRNA | blastn | 68 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 11003537 | 11003537 | PRJNA800090_P_NODE_71009_length_404_cov_1.743284_g68824_i0 | PRJNA800090 | 71009 | 404 | 1.743284 | 7.04286736 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.039 | NTclustered | gi|2572305681|ref|XM_059294116.1| | 109671 | g68824 | i0 | 100 | 0.0693069306930693 | 28 | 0 | 7 | 0 | 192 | 219 | 4494 | 4467 | PREDICTED: Physella acuta pneumococcal serine-rich repeat protein-like (LOC131936970), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 12279705 | 12279705 | PRJNA800090_P_NODE_95930_length_334_cov_2.120755_g93745_i0 | PRJNA800090 | 95930 | 334 | 2.120755 | 7.0833217 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2911823750|ref|XM_071242813.1| | 6455 | g93745 | i0 | 100 | 0.167664670658683 | 28 | 0 | 8 | 0 | 304 | 331 | 3973 | 4000 | PREDICTED: Haliotis cracherodii centrosomal protein of 152 kDa-like (LOC139461212), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 13550733 | 13550733 | PRJNA800090_P_NODE_137731_length_268_cov_2.814070_g135546_i0 | PRJNA800090 | 137731 | 268 | 2.81407 | 7.5417076 | Patella vulgata | 6465 | Mollusca | Mollusca | 167 | 8.4e-37 | NTclustered | gi|2506310253|ref|XM_050538833.2| | 6465 | g135546 | i0 | 81.308 | 53.1828358208955 | 214 | 33 | 79 | 6 | 7 | 218 | 356 | 148 | PREDICTED: Patella vulgata ras-related C3 botulinum toxin substrate 1 (LOC126812443), mRNA | blastn | 14253 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 14829098 | 14829098 | PRJNA800090_S_NODE_25192_length_253_cov_1.625000_g25080_i0 | PRJNA800090 | 25192 | 253 | 1.625 | 4.11125 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g25080 | i0 | 96.97 | 0.130434782608696 | 33 | 0 | 13 | 1 | 5 | 37 | 39065351 | 39065382 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16102955 | 16102955 | PRJNA800090_S_NODE_15733_length_305_cov_1.673729_g15621_i0 | PRJNA800090 | 15733 | 305 | 1.673729 | 5.10487345 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 73.1 | 2.18e-8 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g15621 | i0 | 82.222 | 39.8360655737705 | 90 | 11 | 28 | 5 | 119 | 204 | 10934451 | 10934363 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 12150 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17376430 | 17376430 | PRJNA800090_P_NODE_176594_length_234_cov_1.278788_g174409_i0 | PRJNA800090 | 176594 | 234 | 1.278788 | 2.99236392 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 241 | 4.17e-59 | NTclustered | gi|2868610422|ref|XM_070346796.1| | 31220 | g174409 | i0 | 91.429 | 76.8974358974359 | 175 | 15 | 75 | 0 | 12 | 186 | 274 | 100 | PREDICTED: Littorina saxatilis tubulin beta chain-like (LOC138974102), mRNA | blastn | 17994 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 17376599 | 17376599 | PRJNA800090_P_NODE_184914_length_231_cov_0.888889_g182729_i0 | PRJNA800090 | 184914 | 231 | 0.888889 | 2.05333359 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g182729 | i0 | 100 | 0.125541125541126 | 29 | 0 | 13 | 0 | 153 | 181 | 54643550 | 54643578 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19923920 | 19923920 | PRJNA800090_P_NODE_136816_length_269_cov_2.880000_g134631_i0 | PRJNA800090 | 136816 | 269 | 2.88 | 7.7472 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 5.3e-4 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g134631 | i0 | 97.059 | 0.342007434944238 | 34 | 1 | 13 | 0 | 16 | 49 | 56967502 | 56967469 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 92 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21200370 | 21200370 | PRJNA800090_P_NODE_171217_length_237_cov_0.869048_g169032_i0 | PRJNA800090 | 171217 | 237 | 0.869048 | 2.05964376 | Lottia gigantea | 225164 | Mollusca | Mollusca | 200 | 7.18e-47 | NTclustered | gi|676429220|ref|XM_009047281.1| | 225164 | g169032 | i0 | 85.279 | 83.2447257383966 | 197 | 25 | 82 | 3 | 19 | 213 | 120 | 314 | Lottia gigantea hypothetical protein mRNA | blastn | 19729 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 22474626 | 22474626 | PRJNA800090_P_NODE_152678_length_253_cov_2.804348_g150493_i0 | PRJNA800090 | 152678 | 253 | 2.804348 | 7.09500044 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g150493 | i0 | 96.97 | 0.130434782608696 | 33 | 0 | 13 | 1 | 5 | 37 | 39065351 | 39065382 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25024926 | 25024926 | PRJNA800090_P_NODE_190400_length_229_cov_0.900000_g188215_i0 | PRJNA800090 | 190400 | 229 | 0.9 | 2.061 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 145 | 3.28e-30 | NTclustered | gi|1242767990|ref|XM_022467655.1| | 6565 | g188215 | i0 | 85.714 | 58.1222707423581 | 140 | 16 | 60 | 2 | 78 | 215 | 737 | 600 | PREDICTED: Crassostrea virginica myosin heavy chain, striated muscle-like (LOC111124621), transcript variant X4, mRNA | blastn | 13310 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 25447174 | 25447174 | PRJNA800090_P_NODE_171040_length_237_cov_0.958333_g168855_i0 | PRJNA800090 | 171040 | 237 | 0.958333 | 2.27124921 | Ostreidae | 6563 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|366047569|dbj|AB474183.1| | 29159 | g168855 | i0 | 96.97 | 1.11392405063291 | 33 | 1 | 14 | 0 | 33 | 65 | 407 | 375 | Crassostrea gigas shelk2 mRNA for poly-Ala protein Shelk2, complete cds | blastn | 264 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas |
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);;