contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12463251 | 12463251 | PRJEB11748_P_NODE_288810_length_225_cov_2.134146_g286627_i0 | PRJEB11748 | 288810 | 225 | 2.134146 | 4.8018285 | Liolophura japonica | 13599 | Mollusca | Mollusca | 58.9 | 5.76e-8 | NR | XP_064608521.1 | 13599 | g286627 | i0 | 48 | 1 | 75 | 33 | 92 | 1 | 221 | 15 | 496 | 570 | XP_064608521.1 cartilage oligomeric matrix protein-like [Liolophura japonica] | diamond | 225 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 26589438 | 26589438 | PRJEB11748_P_NODE_359321_length_193_cov_2.674242_g357138_i0 | PRJEB11748 | 359321 | 193 | 2.674242 | 5.16128706 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 92.4 | 5.7e-20 | NR | BFZ14692.1 | 145626 | g357138 | i0 | 75 | 1.98963730569948 | 64 | 11 | 91.7 | 1 | 12 | 188 | 116 | 179 | BFZ14692.1 hypothetical protein BsWGS_17732 [Bradybaena similaris] | diamond | 384 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26900197 | 26900197 | PRJEB11748_P_NODE_40281_length_686_cov_27.280000_g38252_i0 | PRJEB11748 | 40281 | 686 | 27.28 | 187.1408 | Ostreidae | 6563 | Mollusca | Mollusca | 66.2 | 1.5e-8 | NR | XP_048757533.2 | 37623 | g38252 | i0 | 40.7 | 1.52623906705539 | 91 | 45 | 39.8 | 3 | 409 | 681 | 155 | 236 | XP_048757533.2 F-box/WD repeat-containing protein 8-like [Ostrea edulis] | diamond | 1047 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 26900198 | 26900198 | PRJEB11748_P_NODE_42341_length_667_cov_5.351485_g40288_i0 | PRJEB11748 | 42341 | 667 | 5.351485 | 35.69440495 | Metazoa | 33208 | Mollusca | Mollusca | 66.2 | 7.66e-9 | NR | XP_052217269.1 | 45954 | g40288 | i0 | 62.5 | 1.72713643178411 | 48 | 15 | 21.6 | 1 | 1 | 144 | 263 | 307 | XP_052217269.1 COP9 signalosome complex subunit 6-like [Dreissena polymorpha] | diamond | 1152 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27506943 | 27506943 | PRJEB11748_P_NODE_114143_length_389_cov_4.182927_g111969_i0 | PRJEB11748 | 114143 | 389 | 4.182927 | 16.27158603 | Aplysia californica | 6500 | Mollusca | Mollusca | 50.4 | 6.84e-5 | NR | XP_035829361.1 | 6500 | g111969 | i0 | 41.7 | 1.3573264781491 | 60 | 35 | 46.3 | 0 | 157 | 336 | 68 | 127 | XP_035829361.1 uncharacterized protein LOC118478942 [Aplysia californica] | diamond | 528 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 28106668 | 28106668 | PRJEB11748_P_NODE_290145_length_224_cov_4.711656_g287962_i0 | PRJEB11748 | 290145 | 224 | 4.711656 | 10.55410944 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 45.8 | 0.00243 | NR | XP_053408213.1 | 6596 | g287962 | i0 | 57.9 | 1.05803571428571 | 38 | 16 | 50.9 | 0 | 33 | 146 | 342 | 379 | XP_053408213.1 uncharacterized protein LOC123561013 [Mercenaria mercenaria] | diamond | 237 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29306430 | 29306430 | PRJEB11748_P_NODE_195049_length_288_cov_2.180617_g192866_i0 | PRJEB11748 | 195049 | 288 | 2.180617 | 6.28017696 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 64.3 | 1.62e-9 | NR | KAL3886229.1 | 1069815 | g192866 | i0 | 40.7 | 1.88541666666667 | 91 | 52 | 93.8 | 2 | 271 | 2 | 520 | 609 | KAL3886229.1 hypothetical protein ACJMK2_026236 [Sinanodonta woodiana] | diamond | 543 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 29426471 | 29426471 | PRJEB11748_P_NODE_205429_length_279_cov_3.692661_g203246_i0 | PRJEB11748 | 205429 | 279 | 3.692661 | 10.30252419 | Neomphalida | 3120499 | Mollusca | Mollusca | 60.1 | 4.61e-8 | NR | XP_009047509.1 | 225164 | g203246 | i0 | 60.9 | 0.870967741935484 | 46 | 18 | 49.5 | 0 | 8 | 145 | 935 | 980 | XP_009047509.1 hypothetical protein LOTGIDRAFT_172386 [Lottia gigantea] | diamond | 243 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 30032975 | 30032975 | PRJEB11748_P_NODE_274511_length_232_cov_8.654971_g272328_i0 | PRJEB11748 | 274511 | 232 | 8.654971 | 20.07953272 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 47 | 0.00104 | NR | XP_041379350.1 | 1735272 | g272328 | i0 | 70 | 0.387931034482759 | 30 | 9 | 38.8 | 0 | 194 | 105 | 988 | 1017 | XP_041379350.1 ankyrin repeat and KH domain-containing protein 1-like [Gigantopelta aegis] | diamond | 90 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30032983 | 30032983 | PRJEB11748_P_NODE_285691_length_226_cov_12.466667_g283508_i0 | PRJEB11748 | 285691 | 226 | 12.466667 | 28.17466742 | Aplysia californica | 6500 | Mollusca | Mollusca | 43.9 | 0.0116 | NR | XP_005095057.1 | 6500 | g283508 | i0 | 33.9 | 0.823008849557522 | 62 | 34 | 73 | 1 | 219 | 55 | 216 | 277 | XP_005095057.1 uncharacterized protein LOC101853152 isoform X2 [Aplysia californica] | diamond | 186 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30690083 | 30690083 | PRJEB11748_P_NODE_338073_length_203_cov_2.852113_g335890_i0 | PRJEB11748 | 338073 | 203 | 2.852113 | 5.78978939 | Opisthokonta | 33154 | Mollusca | Mollusca | 42 | 0.0425 | NR | XP_061169143.1 | 191078 | g335890 | i0 | 37.7 | 1.92118226600985 | 61 | 35 | 85.7 | 1 | 202 | 29 | 1268 | 1328 | XP_061169143.1 ankyrin-3-like [Saccostrea echinata] | diamond | 390 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 30759650 | 30759650 | PRJEB11748_P_NODE_258174_length_242_cov_1.662983_g255991_i0 | PRJEB11748 | 258174 | 242 | 1.662983 | 4.02441886 | Elysia crispata | 231223 | Mollusca | Mollusca | 40.8 | 0.0472 | NR | KAK3742144.1 | 231223 | g255991 | i0 | 45 | 0.495867768595041 | 40 | 19 | 45.9 | 1 | 7 | 117 | 45 | 84 | KAK3742144.1 hypothetical protein RRG08_008545 [Elysia crispata] | diamond | 120 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 30974681 | 30974681 | PRJEB11748_P_NODE_352834_length_196_cov_5.955556_g350651_i0 | PRJEB11748 | 352834 | 196 | 5.955556 | 11.67288976 | Metazoa | 33208 | Mollusca | Mollusca | 72.4 | 2.5e-13 | NR | KAH9508382.1 | 55810 | g350651 | i0 | 56.4 | 31.6683673469388 | 55 | 24 | 84.2 | 0 | 170 | 6 | 67 | 121 | KAH9508382.1 kinesin-like protein kif13a [Bulinus truncatus] | diamond | 6207 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 31258934 | 31258934 | PRJEB11748_P_NODE_135155_length_355_cov_3.380952_g132977_i0 | PRJEB11748 | 135155 | 355 | 3.380952 | 12.0023796 | Opisthokonta | 33154 | Mollusca | Mollusca | 45.4 | 0.0155 | NR | XP_048253870.1 | 6454 | g132977 | i0 | 23.2 | 2.0112676056338 | 112 | 53 | 94.6 | 1 | 4 | 339 | 627 | 705 | XP_048253870.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit B-like [Haliotis rufescens] | diamond | 714 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 31296646 | 31296646 | PRJEB11748_P_NODE_127115_length_367_cov_4.856209_g124938_i0 | PRJEB11748 | 127115 | 367 | 4.856209 | 17.82228703 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 45.1 | 0.0224 | NR | RUS88711.1 | 188477 | g124938 | i0 | 45.5 | 0.719346049046321 | 44 | 24 | 36 | 0 | 98 | 229 | 119 | 162 | RUS88711.1 hypothetical protein EGW08_003526 [Elysia chlorotica] | diamond | 264 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 31454928 | 31454928 | PRJEB11748_P_NODE_162296_length_320_cov_21.440154_g160113_i0 | PRJEB11748 | 162296 | 320 | 21.440154 | 68.6084928 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 45.8 | 0.00725 | NR | XP_041350937.1 | 1735272 | g160113 | i0 | 51.1 | 0.440625 | 47 | 22 | 44.1 | 1 | 295 | 155 | 451 | 496 | XP_041350937.1 annexin A13-like [Gigantopelta aegis] | diamond | 141 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 31733264 | 31733264 | PRJEB11748_P_NODE_8297_length_1682_cov_24.985811_g7454_i0 | PRJEB11748 | 8297 | 1682 | 24.985811000000002 | 420.26134102 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 235 | 8.810000000000001e-63 | NR | XP_034305264.2 | 29159 | g7454 | i0 | 54.8 | 27.5475624256837 | 208 | 93 | 36.9 | 1 | 807 | 187 | 1330 | 1537 | XP_034305264.2 multidrug resistance-associated protein 1 [Magallana gigas] | diamond | 46335 | 236 | 0.995762711864407 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31828087 | 31828087 | PRJEB11748_P_NODE_160497_length_322_cov_85.724138_g158315_i0 | PRJEB11748 | 160497 | 322 | 85.724138 | 276.03172436 | Ostreidae | 6563 | Mollusca | Mollusca | 47.4 | 0.00232 | NR | XP_062596870.1 | 36930 | g158315 | i0 | 53.7 | 1.5 | 41 | 19 | 38.2 | 0 | 59 | 181 | 21 | 61 | XP_062596870.1 ras-specific guanine nucleotide-releasing factor 1-like [Saccostrea cuccullata] | diamond | 483 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 32340890 | 32340890 | PRJEB11748_P_NODE_164219_length_318_cov_9.066148_g162036_i0 | PRJEB11748 | 164219 | 318 | 9.066148 | 28.83035064 | Elysia marginata | 1093978 | Mollusca | Mollusca | 49.3 | 3.75e-4 | NR | GFR61369.1 | 1093978 | g162036 | i0 | 45.5 | 4.17924528301887 | 44 | 24 | 41.5 | 0 | 45 | 176 | 163 | 206 | GFR61369.1 RNA-directed DNA polymerase from mobile element jockey [Elysia marginata] | diamond | 1329 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 32562543 | 32562543 | PRJEB11748_P_NODE_311379_length_214_cov_3.065359_g309196_i0 | PRJEB11748 | 311379 | 214 | 3.065359 | 6.55986826 | Ostrea edulis | 37623 | Mollusca | Mollusca | 43.5 | 0.0136 | NR | XP_048753373.2 | 37623 | g309196 | i0 | 33.3 | 0.883177570093458 | 63 | 36 | 86.9 | 3 | 190 | 5 | 237 | 294 | XP_048753373.2 piggyBac transposable element-derived protein 3-like [Ostrea edulis] | diamond | 189 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis |
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);;