contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA825466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3371246 | 3371246 | PRJNA825466_P_NODE_19043_length_249_cov_0.875000_g18942_i0 | PRJNA825466 | 19043 | 249 | 0.875 | 2.17875 | Metazoa | 33208 | Mollusca | Mollusca | 139 | 2.2199999999999996e-37 | NR | XP_046381574.1 | 6454 | g18942 | i0 | 79.5 | 42.1807228915663 | 83 | 17 | 100 | 0 | 249 | 1 | 141 | 223 | XP_046381574.1 eukaryotic initiation factor 4A-I-like isoform X2 [Haliotis rufescens] | diamond | 10503 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 3780054 | 3780054 | PRJNA825466_P_NODE_15123_length_257_cov_1.532609_g15022_i0 | PRJNA825466 | 15123 | 257 | 1.532609 | 3.93880513 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 143 | 8.139999999999999e-38 | NR | XP_045165411.2 | 6596 | g15022 | i0 | 81.2 | 6.94552529182879 | 85 | 16 | 99.2 | 0 | 1 | 255 | 70 | 154 | XP_045165411.2 heat shock protein 70 B2-like [Mercenaria mercenaria] | diamond | 1785 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 21630157 | 21630157 | PRJNA825466_P_NODE_7717_length_310_cov_2.578059_g7616_i0 | PRJNA825466 | 7717 | 310 | 2.578059 | 7.9919829 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 81.6 | 1.8e-15 | NR | XP_052236566.1 | 45954 | g7616 | i0 | 76.6 | 211.335483870968 | 47 | 11 | 45.5 | 0 | 162 | 302 | 1367 | 1413 | XP_052236566.1 histone-lysine N-methyltransferase SETD1B-like [Dreissena polymorpha] | diamond | 65514 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27031425 | 27031425 | PRJNA825466_P_NODE_26722_length_243_cov_0.894118_g26621_i0 | PRJNA825466 | 26722 | 243 | 0.894118 | 2.17270674 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 5.28e-29 | NR | CAL1540518.1 | 6523 | g26621 | i0 | 69.6 | 25.358024691358 | 79 | 24 | 97.5 | 0 | 239 | 3 | 134 | 212 | CAL1540518.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 6162 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 27465432 | 27465432 | PRJNA825466_P_NODE_12863_length_270_cov_1.553299_g12762_i0 | PRJNA825466 | 12863 | 270 | 1.553299 | 4.1939073 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 60.8 | 2.15e-8 | NR | XP_046340859.2 | 6454 | g12762 | i0 | 39.3 | 0.988888888888889 | 89 | 50 | 97.8 | 2 | 269 | 6 | 306 | 391 | XP_046340859.2 putative ankyrin repeat protein RF_0381 [Haliotis rufescens] | diamond | 267 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 28096738 | 28096738 | PRJNA825466_P_NODE_17005_length_251_cov_0.865169_g16904_i0 | PRJNA825466 | 17005 | 251 | 0.865169 | 2.17157419 | Elysia marginata | 1093978 | Mollusca | Mollusca | 59.7 | 4.52e-8 | NR | GFR60011.1 | 1093978 | g16904 | i0 | 44.1 | 2.8207171314741 | 68 | 33 | 76.5 | 2 | 193 | 2 | 2184 | 2250 | GFR60011.1 proactivator polypeptide, partial [Elysia marginata] | diamond | 708 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 29170408 | 29170408 | PRJNA825466_P_NODE_29309_length_240_cov_2.520958_g29208_i0 | PRJNA825466 | 29309 | 240 | 2.520958 | 6.0502992 | Lottia gigantea | 225164 | Mollusca | Mollusca | 54.7 | 2.18e-6 | NR | XP_009065200.1 | 225164 | g29208 | i0 | 39.7 | 0.85 | 68 | 40 | 83.8 | 1 | 36 | 236 | 44 | 111 | XP_009065200.1 hypothetical protein LOTGIDRAFT_155388 [Lottia gigantea] | diamond | 204 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 29305124 | 29305124 | PRJNA825466_P_NODE_14409_length_261_cov_1.632979_g14308_i0 | PRJNA825466 | 14409 | 261 | 1.632979 | 4.26207519 | Metazoa | 33208 | Mollusca | Mollusca | 98.2 | 4.26e-23 | NR | XP_046374831.1 | 6454 | g14308 | i0 | 61.8 | 25.5402298850575 | 89 | 32 | 100 | 2 | 261 | 1 | 84 | 172 | XP_046374831.1 40S ribosomal protein S7-like [Haliotis rufescens] | diamond | 6666 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 29580409 | 29580409 | PRJNA825466_P_NODE_16950_length_251_cov_0.865169_g16849_i0 | PRJNA825466 | 16950 | 251 | 0.865169 | 2.17157419 | Mytilus edulis | 6550 | Mollusca | Mollusca | 44.3 | 0.00979 | NR | CAG2203023.1 | 6550 | g16849 | i0 | 48.1 | 1.29083665338645 | 54 | 27 | 64.5 | 1 | 164 | 3 | 129 | 181 | CAG2203023.1 PACRG-like protein [Mytilus edulis] | diamond | 324 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29643513 | 29643513 | PRJNA825466_P_NODE_3370_length_406_cov_1.753754_g3269_i0 | PRJNA825466 | 3370 | 406 | 1.753754 | 7.12024124 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 87.8 | 3.76e-17 | NR | VDI48492.1 | 29158 | g3269 | i0 | 36.6 | 2.09113300492611 | 142 | 80 | 97.5 | 3 | 3 | 398 | 336 | 477 | VDI48492.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 849 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 29738332 | 29738332 | PRJNA825466_P_NODE_13690_length_265_cov_1.750000_g13589_i0 | PRJNA825466 | 13690 | 265 | 1.75 | 4.6375 | Lottia gigantea | 225164 | Mollusca | Mollusca | 75.5 | 1.28e-13 | NR | XP_009044110.1 | 225164 | g13589 | i0 | 47.3 | 3.46415094339623 | 74 | 39 | 83.8 | 0 | 1 | 222 | 33 | 106 | XP_009044110.1 hypothetical protein LOTGIDRAFT_152422 [Lottia gigantea] | diamond | 918 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 30094550 | 30094550 | PRJNA825466_P_NODE_5132_length_350_cov_1.111913_g5031_i0 | PRJNA825466 | 5132 | 350 | 1.111913 | 3.8916955 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.3 | 1.73e-15 | NR | XP_011424456.2 | 29159 | g5031 | i0 | 47.2 | 2.91428571428571 | 89 | 45 | 75.4 | 2 | 1 | 264 | 1 | 88 | XP_011424456.2 ubiquitin-like-conjugating enzyme ATG3 [Magallana gigas] | diamond | 1020 | 81.6 | 0.996323529411765 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31792619 | 31792619 | PRJNA825466_P_NODE_14597_length_260_cov_1.561497_g14496_i0 | PRJNA825466 | 14597 | 260 | 1.561497 | 4.0598922 | Mya arenaria | 6604 | Mollusca | Mollusca | 42.7 | 0.0205 | NR | XP_052816452.1 | 6604 | g14496 | i0 | 58.3 | 0.415384615384615 | 36 | 15 | 41.5 | 0 | 258 | 151 | 99 | 134 | XP_052816452.1 60S ribosomal protein L14-like [Mya arenaria] | diamond | 108 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;