contig_metadata
22 rows where bioproject = "PRJNA763243", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5846932 | 5846932 | PRJNA763243_P_NODE_43645_length_268_cov_1.543590_g43299_i0 | PRJNA763243 | 43645 | 268 | 1.54359 | 4.1368212 | Argopecten irradians | 31199 | Mollusca | Mollusca | 91.6 | 5.2e-14 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g43299 | i0 | 98.077 | 23.5410447761194 | 52 | 1 | 35 | 0 | 4 | 55 | 1391 | 1442 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 6309 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 7583129 | 7583129 | PRJNA763243_P_NODE_13586_length_415_cov_1.514620_g13241_i0 | PRJNA763243 | 13586 | 415 | 1.51462 | 6.285673 | Metazoa | 33208 | Mollusca | Mollusca | 756 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g13241 | i0 | 99.518 | 99.978313253012 | 415 | 2 | 100 | 0 | 1 | 415 | 1182 | 1596 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 41491 | 756 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 8858364 | 8858364 | PRJNA763243_P_NODE_4507_length_657_cov_1.736301_g4199_i0 | PRJNA763243 | 4507 | 657 | 1.736301 | 11.40749757 | Metazoa | 33208 | Mollusca | Mollusca | 1203 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g4199 | i0 | 99.847 | 99.738203957382 | 654 | 1 | 99 | 0 | 1 | 654 | 678 | 25 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 65528 | 1208 | 0.995860927152318 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 22420908 | 22420908 | PRJNA763243_P_NODE_54798_length_248_cov_1.760000_g54452_i0 | PRJNA763243 | 54798 | 248 | 1.76 | 4.3648 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g54452 | i0 | 96.97 | 0.483870967741935 | 33 | 1 | 13 | 0 | 9 | 41 | 23183629 | 23183661 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 120 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23696782 | 23696782 | PRJNA763243_P_NODE_63639_length_241_cov_0.916667_g63293_i0 | PRJNA763243 | 63639 | 241 | 0.916667 | 2.20916747 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 69.4 | 2.15e-7 | NTclustered | gi|2442051071|ref|XM_053540373.1| | 6596 | g63293 | i0 | 87.5 | 3.04149377593361 | 64 | 3 | 27 | 4 | 141 | 204 | 9539 | 9597 | PREDICTED: Mercenaria mercenaria E3 ubiquitin-protein ligase rnf213-alpha-like (LOC123550949), transcript variant X6, mRNA | blastn | 733 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 26619599 | 26619599 | PRJNA763243_P_NODE_19961_length_354_cov_0.782918_g19615_i0 | PRJNA763243 | 19961 | 354 | 0.782918 | 2.77152972 | Metazoa | 33208 | Mollusca | Mollusca | 164 | 3.17e-44 | NR | XP_048255660.1 | 6454 | g19615 | i0 | 70 | 35.4491525423729 | 110 | 33 | 93.2 | 0 | 352 | 23 | 172 | 281 | XP_048255660.1 dihydropyrimidine dehydrogenase [NADP(+)]-like isoform X2 [Haliotis rufescens] | diamond | 12549 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27821117 | 27821117 | PRJNA763243_P_NODE_18424_length_366_cov_1.040956_g18079_i0 | PRJNA763243 | 18424 | 366 | 1.040956 | 3.80989896 | Mollusca | 6447 | Mollusca | Mollusca | 55.5 | 5.6e-6 | NR | XP_046574834.1 | 36100 | g18079 | i0 | 27 | 6.5327868852459 | 111 | 59 | 89.3 | 4 | 19 | 345 | 593 | 683 | XP_046574834.1 LOW QUALITY PROTEIN: sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like [Haliotis rubra] | diamond | 2391 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 27937698 | 27937698 | PRJNA763243_P_NODE_61845_length_242_cov_1.822485_g61499_i0 | PRJNA763243 | 61845 | 242 | 1.822485 | 4.4104137 | Liolophura japonica | 13599 | Mollusca | Mollusca | 52.4 | 1.52e-5 | NR | XP_064597702.1 | 13599 | g61499 | i0 | 51.4 | 0.45867768595041303 | 37 | 18 | 45.9 | 0 | 1 | 111 | 2199 | 2235 | XP_064597702.1 uncharacterized protein LOC135464136 [Liolophura japonica] | diamond | 111 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27969115 | 27969115 | PRJNA763243_P_NODE_21585_length_343_cov_1.677778_g21239_i0 | PRJNA763243 | 21585 | 343 | 1.677778 | 5.75477854 | Solemya velum | 13268 | Mollusca | Mollusca | 43.5 | 0.0177 | NR | KAL5006478.1 | 13268 | g21239 | i0 | 28 | 0.935860058309038 | 107 | 52 | 91.8 | 4 | 19 | 333 | 36 | 119 | KAL5006478.1 hypothetical protein ScPMuIL_015284 [Solemya velum] | diamond | 321 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 28095442 | 28095442 | PRJNA763243_P_NODE_50025_length_254_cov_2.198895_g49679_i0 | PRJNA763243 | 50025 | 254 | 2.198895 | 5.5851933 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 42.7 | 0.043 | NR | XP_041356232.1 | 1735272 | g49679 | i0 | 43.8 | 0.377952755905512 | 32 | 18 | 37.8 | 0 | 4 | 99 | 222 | 253 | XP_041356232.1 neurogenic locus Notch protein-like [Gigantopelta aegis] | diamond | 96 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 29052467 | 29052467 | PRJNA763243_P_NODE_38848_length_280_cov_1.140097_g38502_i0 | PRJNA763243 | 38848 | 280 | 1.140097 | 3.1922716 | Veneridae | 6592 | Mollusca | Mollusca | 85.5 | 5.72e-17 | NR | XP_053402675.1 | 6596 | g38502 | i0 | 48.9 | 10.8 | 92 | 45 | 98.6 | 1 | 277 | 2 | 1757 | 1846 | XP_053402675.1 sacsin-like [Mercenaria mercenaria] | diamond | 3024 | 86.3 | 0.990730011587486 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29105979 | 29105979 | PRJNA763243_P_NODE_45768_length_263_cov_1.942105_g45422_i0 | PRJNA763243 | 45768 | 263 | 1.942105 | 5.10773615 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 118 | 2.77e-31 | NR | XP_025078139.1 | 400727 | g45422 | i0 | 69.9 | 1.893536121673 | 83 | 25 | 94.7 | 0 | 15 | 263 | 1 | 83 | XP_025078139.1 60S ribosomal protein L17-like [Pomacea canaliculata] | diamond | 498 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 29137679 | 29137679 | PRJNA763243_P_NODE_72149_length_210_cov_5.664234_g71803_i0 | PRJNA763243 | 72149 | 210 | 5.664234 | 11.8948914 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 89 | 1.26e-18 | NR | XP_055862496.1 | 6526 | g71803 | i0 | 69.7 | 2.82857142857143 | 66 | 17 | 94.3 | 2 | 206 | 9 | 105 | 167 | XP_055862496.1 major vault protein-like [Biomphalaria glabrata] | diamond | 594 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 30401208 | 30401208 | PRJNA763243_P_NODE_65893_length_235_cov_3.012346_g65547_i0 | PRJNA763243 | 65893 | 235 | 3.012346 | 7.0790131 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 47 | 0.00101 | NR | KAK3599741.1 | 2493646 | g65547 | i0 | 39.1 | 1.17446808510638 | 46 | 28 | 58.7 | 0 | 96 | 233 | 68 | 113 | KAK3599741.1 hypothetical protein CHS0354_037216 [Potamilus streckersoni] | diamond | 276 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 30410727 | 30410727 | PRJNA763243_P_NODE_41633_length_273_cov_1.135000_g41287_i0 | PRJNA763243 | 41633 | 273 | 1.135 | 3.09855 | root | 1 | Root_unresolved | Root_unresolved | 59.3 | 7.7e-8 | NR | WAR04417.1 | 6604 | g41287 | i0 | 54.3 | 4.78021978021978 | 46 | 21 | 50.5 | 0 | 266 | 129 | 67 | 112 | WAR04417.1 AGRG2-like protein, partial [Mya arenaria] | diamond | 1305 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30663116 | 30663116 | PRJNA763243_P_NODE_40973_length_274_cov_5.024876_g40627_i0 | PRJNA763243 | 40973 | 274 | 5.024876 | 13.76816024 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.1 | 1.27e-21 | NR | CAI9726150.1 | 6645 | g40627 | i0 | 57.6 | 6.59124087591241 | 85 | 34 | 93.1 | 1 | 269 | 15 | 268 | 350 | CAI9726150.1 ribosomal L3 [Octopus vulgaris] | diamond | 1806 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 31421643 | 31421643 | PRJNA763243_P_NODE_62476_length_242_cov_0.911243_g62130_i0 | PRJNA763243 | 62476 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 87 | 6.83e-18 | NR | XP_009046637.1 | 225164 | g62130 | i0 | 51.9 | 4.89669421487603 | 79 | 37 | 97.9 | 1 | 237 | 1 | 323 | 400 | XP_009046637.1 hypothetical protein LOTGIDRAFT_138069 [Lottia gigantea] | diamond | 1185 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 31507125 | 31507125 | PRJNA763243_P_NODE_8876_length_498_cov_1.065882_g8534_i0 | PRJNA763243 | 8876 | 498 | 1.065882 | 5.30809236 | Patella vulgata | 6465 | Mollusca | Mollusca | 50.4 | 0.00103 | NR | XP_050418822.1 | 6465 | g8534 | i0 | 26.6 | 1.76506024096386 | 139 | 92 | 77.7 | 2 | 447 | 61 | 630 | 768 | XP_050418822.1 putative leucine-rich repeat-containing protein DDB_G0290503 [Patella vulgata] | diamond | 879 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32022692 | 32022692 | PRJNA763243_P_NODE_2178_length_888_cov_3.398773_g1940_i0 | PRJNA763243 | 2178 | 888 | 3.398773 | 30.18110424 | Ostreidae | 6563 | Mollusca | Mollusca | 52 | 0.0026 | NR | XP_022336279.1 | 6565 | g1940 | i0 | 75 | 1.03716216216216 | 28 | 7 | 9.5 | 0 | 30 | 113 | 422 | 449 | XP_022336279.1 uncharacterized protein LOC111132753 [Crassostrea virginica] | diamond | 921 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 32085908 | 32085908 | PRJNA763243_P_NODE_63018_length_241_cov_3.428571_g62672_i0 | PRJNA763243 | 63018 | 241 | 3.428571 | 8.26285611 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 1.28e-9 | NR | XP_050411629.1 | 6465 | g62672 | i0 | 45.5 | 2.93775933609959 | 77 | 30 | 95.9 | 3 | 238 | 8 | 101 | 165 | XP_050411629.1 stabilin-2 [Patella vulgata] | diamond | 708 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 32361321 | 32361321 | PRJNA763243_P_NODE_62239_length_242_cov_0.911243_g61893_i0 | PRJNA763243 | 62239 | 242 | 0.911243 | 2.20520806 | Patella caerulea | 87958 | Mollusca | Mollusca | 82.8 | 2.13e-16 | NR | KAK6189066.1 | 87958 | g61893 | i0 | 56.9 | 1.78512396694215 | 72 | 31 | 89.3 | 0 | 241 | 26 | 43 | 114 | KAK6189066.1 hypothetical protein SNE40_005111 [Patella caerulea] | diamond | 432 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 32843897 | 32843897 | PRJNA763243_P_NODE_66460_length_233_cov_4.250000_g66114_i0 | PRJNA763243 | 66460 | 233 | 4.25 | 9.9025 | Metazoa | 33208 | Mollusca | Mollusca | 44.7 | 0.00696 | NR | CAC5364806.1 | 42192 | g66114 | i0 | 62.5 | 1.42918454935622 | 24 | 9 | 30.9 | 0 | 10 | 81 | 206 | 229 | CAC5364806.1 unnamed protein product [Mytilus coruscus] | diamond | 333 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus |
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);;