contig_metadata
19 rows where bioproject = "PRJEB8827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25530200 | 25530200 | PRJEB8827g_S_NODE_1337_length_265_cov_1.186957_g1316_i0 | PRJEB8827 | 1337 | 265 | 1.186957 | 3.14543605 | Patella vulgata | 6465 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2506320687|ref|XM_050541306.2| | 6465 | g1316 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 214 | 241 | 2900 | 2873 | PREDICTED: Patella vulgata multidrug and toxin extrusion protein 1 (LOC126815593), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 25530253 | 25530253 | PRJEB8827g_S_NODE_4201_length_182_cov_4.034014_g4180_i0 | PRJEB8827 | 4201 | 182 | 4.034014 | 7.34190548 | Argopecten irradians | 31199 | Mollusca | Mollusca | 110 | 9.06e-20 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g4180 | i0 | 95.588 | 38.8626373626374 | 68 | 3 | 37 | 0 | 115 | 182 | 1442 | 1375 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 7073 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 25665494 | 25665494 | PRJEB8827d_S_NODE_14610_length_166_cov_2.122137_g14606_i0 | PRJEB8827 | 14610 | 166 | 2.122137 | 3.52274742 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g14606 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 113 | 140 | 8953149 | 8953122 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25666150 | 25666150 | PRJEB8827g_S_NODE_1090_length_284_cov_104.626506_g1069_i0 | PRJEB8827 | 1090 | 284 | 104.626506 | 297.13927704 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 135 | 2.53e-27 | NTclustered | gi|2034271035|ref|XR_005960499.1| | 1735272 | g1069 | i0 | 81.111 | 12.6056338028169 | 180 | 24 | 62 | 8 | 77 | 251 | 3686 | 3512 | PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA | blastn | 3580 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 25666258 | 25666258 | PRJEB8827h_S_NODE_1402_length_261_cov_1567.553097_g1383_i0 | PRJEB8827 | 1402 | 261 | 1567.553097 | 4091.31358317 | Metazoa | 33208 | Mollusca | Mollusca | 85.1 | 1.36e-19 | NR | XP_021374431.1 | 6573 | g1383 | i0 | 76.3 | 5.5632183908046 | 59 | 11 | 67.8 | 1 | 259 | 83 | 19 | 74 | XP_021374431.1 60S ribosomal protein L38 [Mizuhopecten yessoensis] | diamond | 1452 | 85.5 | 0.9953216374269 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 26074646 | 26074646 | PRJEB8827h_S_NODE_1845_length_239_cov_2.107843_g1826_i0 | PRJEB8827 | 1845 | 239 | 2.107843 | 5.03774477 | Physella acuta | 109671 | Mollusca | Mollusca | 76.8 | 1.27e-9 | NTclustered | gi|2572310488|ref|XM_059295099.1| | 109671 | g1826 | i0 | 84.416 | 1.35983263598326 | 77 | 12 | 32 | 0 | 163 | 239 | 1513 | 1437 | PREDICTED: Physella acuta protein transport protein Sec61 subunit alpha (LOC131937566), mRNA | blastn | 325 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 26210856 | 26210856 | PRJEB8827h_S_NODE_1054_length_288_cov_9.458498_g1035_i0 | PRJEB8827 | 1054 | 288 | 9.458498 | 27.24047424 | Argopecten irradians | 31199 | Mollusca | Mollusca | 143 | 1.54e-29 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g1035 | i0 | 93.684 | 35.0868055555556 | 95 | 6 | 33 | 0 | 3 | 97 | 1348 | 1442 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 10105 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26210879 | 26210879 | PRJEB8827h_S_NODE_2054_length_232_cov_5.548223_g2035_i0 | PRJEB8827 | 2054 | 232 | 5.548223 | 12.87187736 | Aplysia californica | 6500 | Mollusca | Mollusca | 145 | 3.33e-30 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g2035 | i0 | 80.749 | 5.56896551724138 | 187 | 34 | 80 | 2 | 1 | 186 | 317 | 502 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 1292 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 26345939 | 26345939 | PRJEB8827c_S_NODE_2959_length_153_cov_2.864407_g2946_i0 | PRJEB8827 | 2959 | 153 | 2.864407 | 4.38254271 | Argopecten irradians | 31199 | Mollusca | Mollusca | 128 | 2.02e-25 | NTclustered | gi|2835350600|ref|XM_069247595.1| | 31199 | g2946 | i0 | 93.103 | 59.0980392156863 | 87 | 6 | 57 | 0 | 67 | 153 | 1442 | 1356 | PREDICTED: Argopecten irradians tubulin beta-4B chain-like (LOC138306988), mRNA | blastn | 9042 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26346729 | 26346729 | PRJEB8827h_S_NODE_2247_length_227_cov_2.536458_g2228_i0 | PRJEB8827 | 2247 | 227 | 2.536458 | 5.75775966 | Mytilus californianus | 6549 | Mollusca | Mollusca | 132 | 2.52e-26 | NTclustered | gi|2334663290|ref|XM_052233325.1| | 6549 | g2228 | i0 | 79.275 | 0.850220264317181 | 193 | 36 | 85 | 4 | 36 | 227 | 745 | 556 | PREDICTED: Mytilus californianus 33 kDa inner dynein arm light chain, axonemal-like (LOC127726028), mRNA | blastn | 193 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 26434152 | 26434152 | PRJEB8827h_S_NODE_719_length_329_cov_306.244898_g700_i0 | PRJEB8827 | 719 | 329 | 306.244898 | 1007.54571442 | root | 1 | Root_unresolved | Root_unresolved | 137 | 8.31e-28 | NTclustered | gi|2913002568|dbj|AP039611.1| | 145626 | g700 | i0 | 97.5 | 58.9787234042553 | 80 | 2 | 24 | 0 | 149 | 228 | 1432579 | 1432500 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, sequence_id: unanchored2, sequence | blastn | 19404 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26483025 | 26483025 | PRJEB8827h_S_NODE_968_length_296_cov_2.942529_g949_i0 | PRJEB8827 | 968 | 296 | 2.942529 | 8.70988584 | Patella vulgata | 6465 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2506320687|ref|XM_050541306.2| | 6465 | g949 | i0 | 100 | 0.0945945945945946 | 28 | 0 | 9 | 0 | 176 | 203 | 2900 | 2873 | PREDICTED: Patella vulgata multidrug and toxin extrusion protein 1 (LOC126815593), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 31804198 | 31804198 | PRJEB8827_P_NODE_257_length_333_cov_287.088816_g235_i0 | PRJEB8827 | 257 | 333 | 287.088816 | 956.00575728 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 48.9 | 7.53e-4 | NR | CAE1236275.1 | 158019 | g235 | i0 | 47.8 | 0.828828828828829 | 92 | 40 | 78.4 | 4 | 60 | 320 | 2123 | 2211 | CAE1236275.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 276 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32991867 | 32991867 | PRJEB8827h_S_NODE_13611_length_187_cov_5.361842_g13592_i0 | PRJEB8827 | 13611 | 187 | 5.361842 | 10.02664454 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.7 | 0.015 | NR | XP_046354537.1 | 6454 | g13592 | i0 | 48.1 | 3.94652406417112 | 52 | 27 | 83.4 | 0 | 2 | 157 | 155 | 206 | XP_046354537.1 60S ribosomal protein L13-like [Haliotis rufescens] | diamond | 738 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 33016438 | 33016438 | PRJEB8827b_S_NODE_13324_length_189_cov_2.240260_g13272_i0 | PRJEB8827 | 13324 | 189 | 2.24026 | 4.2340914 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 61.2 | 3e-10 | NR | XP_045157640.1 | 6596 | g13272 | i0 | 71.8 | 1.88888888888889 | 39 | 11 | 61.9 | 0 | 188 | 72 | 66 | 104 | XP_045157640.1 thioredoxin-like [Mercenaria mercenaria] | diamond | 357 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 33042909 | 33042909 | PRJEB8827f_S_NODE_900_length_377_cov_4.345029_g880_i0 | PRJEB8827 | 900 | 377 | 4.345029 | 16.38075933 | Mytilus | 6548 | Mollusca | Mollusca | 44.7 | 0.0339 | NR | CAG2212025.1 | 6550 | g880 | i0 | 29.5 | 1.51193633952255 | 95 | 56 | 75.6 | 2 | 6 | 290 | 653 | 736 | CAG2212025.1 unnamed protein product [Mytilus edulis] | diamond | 570 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 33102055 | 33102055 | PRJEB8827h_S_NODE_44846_length_157_cov_2.950820_g44827_i0 | PRJEB8827 | 44846 | 157 | 2.95082 | 4.6327874 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 45.4 | 5.38e-4 | NR | CAG5119186.1 | 100452 | g44827 | i0 | 46.5 | 0.821656050955414 | 43 | 21 | 82.2 | 2 | 9 | 137 | 99 | 139 | CAG5119186.1 unnamed protein product [Candidula unifasciata] | diamond | 129 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 33111082 | 33111082 | PRJEB8827h_S_NODE_41894_length_162_cov_4.291339_g41875_i0 | PRJEB8827 | 41894 | 162 | 4.291339 | 6.95196918 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 3.28e-6 | NR | XP_045181538.2 | 6596 | g41875 | i0 | 72.7 | 2.81481481481481 | 44 | 10 | 81.5 | 1 | 154 | 23 | 253 | 294 | XP_045181538.2 60S ribosomal protein L5-like [Mercenaria mercenaria] | diamond | 456 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 33135838 | 33135838 | PRJEB8827c_S_NODE_191_length_266_cov_4.160173_g178_i0 | PRJEB8827 | 191 | 266 | 4.160173 | 11.06606018 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0183 | NR | XP_067657806.1 | 109174 | g178 | i0 | 35.4 | 1.44360902255639 | 65 | 36 | 72.2 | 2 | 238 | 47 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina |
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);;