contig_metadata
23 rows where bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2873458 | 2873458 | PRJNA1196384_S_NODE_3663_length_206_cov_2.065089_g3599_i0 | PRJNA1196384 | 3663 | 206 | 2.065089 | 4.25408334 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 111 | 2.93e-20 | NTclustered | gi|2160869370|ref|XM_045311120.1| | 6596 | g3599 | i0 | 91.358 | 3.98058252427184 | 81 | 7 | 39 | 0 | 7 | 87 | 291 | 371 | PREDICTED: Mercenaria mercenaria FAU ubiquitin-like and ribosomal protein S30 (LOC123530348), transcript variant X1, mRNA | blastn | 820 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 2873533 | 2873533 | PRJNA1196384_S_NODE_8083_length_152_cov_3.608696_g8019_i0 | PRJNA1196384 | 8083 | 152 | 3.608696 | 5.48521792 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 158 | 2.56e-34 | NTclustered | gi|2868618654|ref|XM_070344692.1| | 31220 | g8019 | i0 | 85.526 | 9.78947368421053 | 152 | 20 | 99 | 2 | 1 | 151 | 188 | 338 | PREDICTED: Littorina saxatilis small ribosomal subunit protein uS15 (LOC138971860), mRNA | blastn | 1488 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 5425813 | 5425813 | PRJNA1196384_S_NODE_1025_length_378_cov_2.659824_g961_i0 | PRJNA1196384 | 1025 | 378 | 2.659824 | 10.05413472 | Bivalvia | 6544 | Mollusca | Mollusca | 201 | 8.93e-61 | NR | XP_022332497.1 | 6565 | g961 | i0 | 75.2 | 6.92857142857143 | 125 | 31 | 99.2 | 0 | 377 | 3 | 1 | 125 | XP_022332497.1 60S ribosomal protein L4-like [Crassostrea virginica] | diamond | 2619 | 202 | 0.995049504950495 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 10526516 | 10526516 | PRJNA1196384_S_NODE_889_length_408_cov_2.358491_g825_i0 | PRJNA1196384 | 889 | 408 | 2.358491 | 9.62264328 | Opisthokonta | 33154 | Mollusca | Mollusca | 130 | 8.37e-36 | NR | XP_052283933.1 | 45954 | g825 | i0 | 55.8 | 10.4411764705882 | 120 | 50 | 86 | 1 | 396 | 46 | 12 | 131 | XP_052283933.1 60S ribosomal protein L22-like [Dreissena polymorpha] | diamond | 4260 | 131 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 11801290 | 11801290 | PRJNA1196384_S_NODE_790_length_432_cov_4.405063_g726_i0 | PRJNA1196384 | 790 | 432 | 4.405063 | 19.02987216 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 206 | 3.02e-48 | NTclustered | gi|2502173393|ref|XM_056030510.1| | 6526 | g726 | i0 | 78.616 | 5.0787037037037 | 318 | 62 | 73 | 5 | 111 | 425 | 517 | 203 | PREDICTED: Biomphalaria glabrata 40S ribosomal protein S20-like (LOC106075322), mRNA | blastn | 2194 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 13076250 | 13076250 | PRJNA1196384_S_NODE_1171_length_357_cov_6.956250_g1107_i0 | PRJNA1196384 | 1171 | 357 | 6.95625 | 24.8338125 | Neomphalida | 3120499 | Mollusca | Mollusca | 207 | 1.42e-65 | NR | GFN93885.1 | 259542 | g1107 | i0 | 83.9 | 3.96638655462185 | 118 | 19 | 99.2 | 0 | 356 | 3 | 2 | 119 | GFN93885.1 ribosomal protein l15 [Plakobranchus ocellatus] | diamond | 1416 | 209 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 13796514 | 13796514 | PRJNA1196384_S_NODE_311_length_639_cov_4.023256_g257_i0 | PRJNA1196384 | 311 | 639 | 4.023256 | 25.70860584 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 181 | 1.9299999999999994e-54 | NR | XP_052229778.1 | 45954 | g257 | i0 | 68.8 | 3.33333333333333 | 141 | 44 | 66.2 | 0 | 471 | 49 | 30 | 170 | XP_052229778.1 60S ribosomal protein L23a-like [Dreissena polymorpha] | diamond | 2130 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 15625480 | 15625480 | PRJNA1196384_S_NODE_473_length_540_cov_9.099404_g411_i0 | PRJNA1196384 | 473 | 540 | 9.099404 | 49.1367816 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 83.6 | 4.36e-15 | NR | CAC5394559.1 | 42192 | g411 | i0 | 37.1 | 1.55 | 143 | 77 | 72.2 | 3 | 512 | 123 | 346 | 488 | CAC5394559.1 RAB32 [Mytilus coruscus] | diamond | 837 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 16345662 | 16345662 | PRJNA1196384_S_NODE_3073_length_222_cov_1.248649_g3009_i0 | PRJNA1196384 | 3073 | 222 | 1.248649 | 2.77200078 | Metazoa | 33208 | Mollusca | Mollusca | 409 | 1.0100000000000001e-109 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g3009 | i0 | 100 | 99.4324324324324 | 221 | 0 | 99 | 0 | 2 | 222 | 457 | 237 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 22074 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 26806662 | 26806662 | PRJNA1196384_S_NODE_841_length_419_cov_4.837696_g777_i0 | PRJNA1196384 | 841 | 419 | 4.837696 | 20.26994624 | Metazoa | 33208 | Mollusca | Mollusca | 165 | 1.35e-49 | NR | XP_022289768.1 | 6565 | g777 | i0 | 68.6 | 6.93078758949881 | 121 | 38 | 86.6 | 0 | 417 | 55 | 14 | 134 | XP_022289768.1 60S ribosomal protein L32-like [Crassostrea virginica] | diamond | 2904 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 26851167 | 26851167 | PRJNA1196384_S_NODE_7541_length_156_cov_1.638655_g7477_i0 | PRJNA1196384 | 7541 | 156 | 1.638655 | 2.5563018 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 86.7 | 3.47e-18 | NR | CAE1301636.1 | 158019 | g7477 | i0 | 80.4 | 0.980769230769231 | 51 | 10 | 98.1 | 0 | 154 | 2 | 293 | 343 | CAE1301636.1 GDI1_2 [Acanthosepion pharaonis] | diamond | 153 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 27091469 | 27091469 | PRJNA1196384_S_NODE_5462_length_176_cov_1.028777_g5398_i0 | PRJNA1196384 | 5462 | 176 | 1.028777 | 1.81064752 | Mollusca | 6447 | Mollusca | Mollusca | 80.1 | 1.02e-15 | NR | CAI9715682.1 | 6645 | g5398 | i0 | 66.1 | 2.86363636363636 | 56 | 19 | 95.5 | 0 | 172 | 5 | 544 | 599 | CAI9715682.1 sorting-associated 35-like [Octopus vulgaris] | diamond | 504 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28083078 | 28083078 | PRJNA1196384_S_NODE_3305_length_215_cov_1.325843_g3241_i0 | PRJNA1196384 | 3305 | 215 | 1.325843 | 2.85056245 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 49.3 | 1.93e-5 | NR | BFZ16647.1 | 145626 | g3241 | i0 | 60 | 0.488372093023256 | 35 | 14 | 48.8 | 0 | 208 | 104 | 68 | 102 | BFZ16647.1 hypothetical protein BsWGS_19686 [Bradybaena similaris] | diamond | 105 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 28083079 | 28083079 | PRJNA1196384_S_NODE_4225_length_194_cov_1.382166_g4161_i0 | PRJNA1196384 | 4225 | 194 | 1.382166 | 2.68140204 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 53.1 | 4.12e-6 | NR | KAK3598520.1 | 2493646 | g4161 | i0 | 39.1 | 0.989690721649485 | 64 | 35 | 95.9 | 2 | 189 | 4 | 557 | 618 | KAK3598520.1 hypothetical protein CHS0354_005801 [Potamilus streckersoni] | diamond | 192 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 28323027 | 28323027 | PRJNA1196384_S_NODE_3326_length_214_cov_4.237288_g3262_i0 | PRJNA1196384 | 3326 | 214 | 4.237288 | 9.06779632 | Mytilus | 6548 | Mollusca | Mollusca | 114 | 4.46e-29 | NR | XP_063424927.1 | 6551 | g3262 | i0 | 80.3 | 18.6728971962617 | 71 | 14 | 99.5 | 0 | 214 | 2 | 42 | 112 | XP_063424927.1 large ribosomal subunit protein eL8-like [Mytilus trossulus] | diamond | 3996 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 28733697 | 28733697 | PRJNA1196384_S_NODE_4447_length_190_cov_1.274510_g4383_i0 | PRJNA1196384 | 4447 | 190 | 1.27451 | 2.421569 | Metazoa | 33208 | Mollusca | Mollusca | 42.7 | 0.0193 | NR | KAH9523908.1 | 55810 | g4383 | i0 | 37.1 | 9.3 | 62 | 32 | 88.4 | 2 | 1 | 168 | 2690 | 2750 | KAH9523908.1 hypothetical protein Btru_047381 [Bulinus truncatus] | diamond | 1767 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 29396642 | 29396642 | PRJNA1196384_S_NODE_3669_length_206_cov_1.591716_g3605_i0 | PRJNA1196384 | 3669 | 206 | 1.591716 | 3.27893496 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 2.3e-5 | NR | XP_050407696.1 | 6465 | g3605 | i0 | 43.5 | 5.97087378640777 | 69 | 38 | 99 | 1 | 206 | 3 | 271 | 339 | XP_050407696.1 legumain [Patella vulgata] | diamond | 1230 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29491306 | 29491306 | PRJNA1196384_S_NODE_3650_length_206_cov_4.970414_g3586_i0 | PRJNA1196384 | 3650 | 206 | 4.970414 | 10.23905284 | Mollusca | 6447 | Mollusca | Mollusca | 70.5 | 2.01e-13 | NR | XP_050403034.1 | 6465 | g3586 | i0 | 77.3 | 1.92233009708738 | 44 | 10 | 64.1 | 0 | 75 | 206 | 12 | 55 | XP_050403034.1 40S ribosomal protein S12 [Patella vulgata] | diamond | 396 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29585798 | 29585798 | PRJNA1196384_S_NODE_3990_length_199_cov_0.962963_g3926_i0 | PRJNA1196384 | 3990 | 199 | 0.962963 | 1.91629637 | Metazoa | 33208 | Mollusca | Mollusca | 42.7 | 0.0213 | NR | OWF35520.1 | 6573 | g3926 | i0 | 34.3 | 3.76884422110553 | 67 | 42 | 98 | 2 | 198 | 4 | 545 | 611 | OWF35520.1 Protein DD3-3 [Mizuhopecten yessoensis] | diamond | 750 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 29883099 | 29883099 | PRJNA1196384_S_NODE_5431_length_176_cov_1.669065_g5367_i0 | PRJNA1196384 | 5431 | 176 | 1.669065 | 2.9375544 | Liolophura japonica | 13599 | Mollusca | Mollusca | 84.3 | 6.42e-18 | NR | XP_064603681.1 | 13599 | g5367 | i0 | 60.3 | 0.988636363636364 | 58 | 23 | 98.9 | 0 | 176 | 3 | 173 | 230 | XP_064603681.1 countin-1-like [Liolophura japonica] | diamond | 174 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31734777 | 31734777 | PRJNA1196384_S_NODE_3957_length_199_cov_2.018519_g3893_i0 | PRJNA1196384 | 3957 | 199 | 2.018519 | 4.01685281 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 2.6199999999999996e-31 | NR | KAI8770767.1 | 6526 | g3893 | i0 | 89.2 | 10.7788944723618 | 65 | 7 | 98 | 0 | 3 | 197 | 427 | 491 | KAI8770767.1 eukaryotic initiation factor 4A-I [Biomphalaria glabrata] | diamond | 2145 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 32159039 | 32159039 | PRJNA1196384_S_NODE_2698_length_236_cov_1.693467_g2634_i0 | PRJNA1196384 | 2698 | 236 | 1.693467 | 3.99658212 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 51.2 | 3.42e-5 | NR | CAC5413870.1 | 42192 | g2634 | i0 | 42.2 | 1.5635593220339 | 45 | 26 | 57.2 | 0 | 159 | 25 | 337 | 381 | CAC5413870.1 unnamed protein product [Mytilus coruscus] | diamond | 369 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 32462741 | 32462741 | PRJNA1196384_S_NODE_7579_length_156_cov_1.285714_g7515_i0 | PRJNA1196384 | 7579 | 156 | 1.285714 | 2.00571384 | Metazoa | 33208 | Mollusca | Mollusca | 43.5 | 0.00605 | NR | KAK7493863.1 | 370345 | g7515 | i0 | 40.8 | 2.76923076923077 | 49 | 29 | 94.2 | 0 | 8 | 154 | 616 | 664 | KAK7493863.1 hypothetical protein BaRGS_00015004 [Batillaria attramentaria] | diamond | 432 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria |
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);;