contig_metadata
17 rows where bioproject = "PRJNA902848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1247154 | 1247154 | PRJNA902848_P_NODE_8821_length_300_cov_1.797357_g8771_i0 | PRJNA902848 | 8821 | 300 | 1.797357 | 5.392071 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 324 | 5.36e-84 | NTclustered | gi|2427418402|ref|XM_052927352.1| | 6604 | g8771 | i0 | 86.242 | 99.15 | 298 | 41 | 99 | 0 | 3 | 300 | 108 | 405 | PREDICTED: Mya arenaria tubulin beta chain-like (LOC128219534), mRNA | blastn | 29745 | 327 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 3432888 | 3432888 | PRJNA902848_P_NODE_923_length_688_cov_26.328455_g877_i0 | PRJNA902848 | 923 | 688 | 26.328455 | 181.1397704 | Physella acuta | 109671 | Mollusca | Mollusca | 1227 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g877 | i0 | 98.837 | 42.8808139534884 | 688 | 8 | 100 | 0 | 1 | 688 | 1899 | 2586 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 29502 | 1227 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 5985256 | 5985256 | PRJNA902848_P_NODE_165_length_1281_cov_5.458609_g144_i0 | PRJNA902848 | 165 | 1281 | 5.458609 | 69.92478129 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 87.9 | 3.59e-12 | NTclustered | gi|1207941491|ref|XM_021504762.1| | 6573 | g144 | i0 | 94.643 | 0.238875878220141 | 56 | 3 | 4 | 0 | 259 | 314 | 252 | 197 | PREDICTED: Mizuhopecten yessoensis neuropeptide-like protein 29 (LOC110454942), mRNA | blastn | 306 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 7260275 | 7260275 | PRJNA902848_P_NODE_7926_length_312_cov_7.347280_g7876_i0 | PRJNA902848 | 7926 | 312 | 7.34728 | 22.9235136 | Physella acuta | 109671 | Mollusca | Mollusca | 555 | 1.8199999999999994e-153 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g7876 | i0 | 98.718 | 4.53846153846154 | 312 | 4 | 100 | 0 | 1 | 312 | 3405 | 3716 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 1416 | 555 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 10175673 | 10175673 | PRJNA902848_P_NODE_5768_length_353_cov_0.960714_g5718_i0 | PRJNA902848 | 5768 | 353 | 0.960714 | 3.39132042 | Mytilus | 6548 | Mollusca | Mollusca | 174 | 6.83e-39 | NTclustered | gi|2334803060|ref|XM_052219055.1| | 6549 | g5718 | i0 | 76.803 | 3.61473087818697 | 319 | 69 | 90 | 5 | 35 | 350 | 449 | 765 | PREDICTED: Mytilus californianus fructose-bisphosphate aldolase-like (LOC127712554), transcript variant X1, mRNA | blastn | 1276 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 10175727 | 10175727 | PRJNA902848_P_NODE_8808_length_300_cov_11.704846_g8758_i0 | PRJNA902848 | 8808 | 300 | 11.704846 | 35.114538 | Metazoa | 33208 | Mollusca | Mollusca | 555 | 1.7399999999999995e-153 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g8758 | i0 | 100 | 54.0566666666667 | 300 | 0 | 100 | 0 | 1 | 300 | 1526 | 1825 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 16217 | 555 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 16184744 | 16184744 | PRJNA902848_P_NODE_15633_length_249_cov_0.886364_g15583_i0 | PRJNA902848 | 15633 | 249 | 0.886364 | 2.20704636 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 150 | 7.77e-32 | NTclustered | gi|2868614015|ref|XM_070321681.1| | 31220 | g15583 | i0 | 79.524 | 8.09638554216867 | 210 | 43 | 84 | 0 | 3 | 212 | 326 | 117 | PREDICTED: Littorina saxatilis eukaryotic translation elongation factor 2-like (LOC138949893), mRNA | blastn | 2016 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 20008740 | 20008740 | PRJNA902848_P_NODE_4676_length_380_cov_2.530945_g4626_i0 | PRJNA902848 | 4676 | 380 | 2.530945 | 9.6175909999999991 | Magallana gigas | 29159 | Mollusca | Mollusca | 303 | 9.06e-78 | NTclustered | gi|2751229756|ref|XM_034453253.2| | 29159 | g4626 | i0 | 81.167 | 37.4210526315789 | 377 | 71 | 99 | 0 | 3 | 379 | 706 | 330 | PREDICTED: Magallana gigas tubulin alpha-1A chain (LOC105329348), mRNA | blastn | 14220 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 21284139 | 21284139 | PRJNA902848_P_NODE_8097_length_310_cov_1.316456_g8047_i0 | PRJNA902848 | 8097 | 310 | 1.316456 | 4.0810136 | Lottia gigantea | 225164 | Mollusca | Mollusca | 346 | 1.19e-90 | NTclustered | gi|676476747|ref|XM_009062645.1| | 225164 | g8047 | i0 | 89.963 | 64.5225806451613 | 269 | 26 | 87 | 1 | 38 | 306 | 344 | 77 | Lottia gigantea hypothetical protein partial mRNA | blastn | 20002 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 22558799 | 22558799 | PRJNA902848_P_NODE_14538_length_251_cov_0.876404_g14488_i0 | PRJNA902848 | 14538 | 251 | 0.876404 | 2.19977404 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 248 | 2.7e-61 | NTclustered | gi|2694002732|ref|XM_063566204.1| | 6551 | g14488 | i0 | 85.185 | 90.9641434262948 | 243 | 34 | 96 | 2 | 10 | 251 | 488 | 247 | PREDICTED: Mytilus trossulus tubulin alpha-1A chain (LOC134706872), mRNA | blastn | 22832 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 22558876 | 22558876 | PRJNA902848_P_NODE_17838_length_246_cov_0.901734_g17788_i0 | PRJNA902848 | 17838 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.1 | 6.97e-19 | NR | XP_052765036.1 | 6604 | g17788 | i0 | 57 | 3.59756097560976 | 79 | 29 | 96.3 | 1 | 240 | 4 | 97 | 170 | XP_052765036.1 uncharacterized protein LOC128206531 isoform X1 [Mya arenaria] | diamond | 885 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 25108035 | 25108035 | PRJNA902848_P_NODE_18680_length_244_cov_0.912281_g18630_i0 | PRJNA902848 | 18680 | 244 | 0.912281 | 2.22596564 | Patella vulgata | 6465 | Mollusca | Mollusca | 220 | 5.699999999999998e-53 | NTclustered | gi|2296482255|ref|XM_050548424.1| | 6465 | g18630 | i0 | 84.444 | 4.04918032786885 | 225 | 34 | 92 | 1 | 16 | 240 | 1152 | 929 | PREDICTED: Patella vulgata 26S proteasome regulatory subunit 4 (LOC126820441), mRNA | blastn | 988 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 29045488 | 29045488 | PRJNA902848_P_NODE_10548_length_278_cov_1.995122_g10498_i0 | PRJNA902848 | 10548 | 278 | 1.995122 | 5.54643916 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 43.5 | 0.00961 | NR | KAL4219916.1 | 2302425 | g10498 | i0 | 31.9 | 1.96402877697842 | 91 | 57 | 93.9 | 2 | 272 | 12 | 10 | 99 | KAL4219916.1 hypothetical protein ACF0H5_020328 [Mactra antiquata] | diamond | 546 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 29771408 | 29771408 | PRJNA902848_P_NODE_13251_length_253_cov_0.866667_g13201_i0 | PRJNA902848 | 13251 | 253 | 0.866667 | 2.19266751 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 115 | 7.54e-28 | NR | XP_041354624.1 | 1735272 | g13201 | i0 | 63.1 | 0.99604743083004 | 84 | 31 | 99.6 | 0 | 253 | 2 | 161 | 244 | XP_041354624.1 nuclear fragile X mental retardation-interacting protein 1-like [Gigantopelta aegis] | diamond | 252 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30442737 | 30442737 | PRJNA902848_P_NODE_10013_length_285_cov_1.103774_g9963_i0 | PRJNA902848 | 10013 | 285 | 1.103774 | 3.1457559 | Metazoa | 33208 | Mollusca | Mollusca | 175 | 9.33e-53 | NR | XP_065923949.1 | 29159 | g9963 | i0 | 89.5 | 194.157894736842 | 95 | 10 | 100 | 0 | 285 | 1 | 43 | 137 | XP_065923949.1 ras-related protein Rab-8A isoform X1 [Magallana gigas] | diamond | 55335 | 176 | 0.994318181818182 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 31699392 | 31699392 | PRJNA902848_P_NODE_14657_length_251_cov_0.876404_g14607_i0 | PRJNA902848 | 14657 | 251 | 0.876404 | 2.19977404 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 75.9 | 8.69e-14 | NR | RUS78787.1 | 188477 | g14607 | i0 | 42.2 | 0.99203187250996006 | 83 | 44 | 99.2 | 1 | 1 | 249 | 181 | 259 | RUS78787.1 hypothetical protein EGW08_013437 [Elysia chlorotica] | diamond | 249 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 32427083 | 32427083 | PRJNA902848_P_NODE_9319_length_293_cov_1.063636_g9269_i0 | PRJNA902848 | 9319 | 293 | 1.063636 | 3.11645348 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 111 | 5.71e-26 | NR | XP_041351713.1 | 1735272 | g9269 | i0 | 54.2 | 0.982935153583618 | 96 | 43 | 98.3 | 1 | 4 | 291 | 227 | 321 | XP_041351713.1 uncharacterized protein LOC121370501 [Gigantopelta aegis] | diamond | 288 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis |
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);;