contig_metadata
17 rows where bioproject = "PRJNA615175", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4978013 | 4978013 | PRJNA615175_P_NODE_7844_length_536_cov_79.332613_g7678_i0 | PRJNA615175 | 7844 | 536 | 79.332613 | 425.22280568 | Bivalvia | 6544 | Mollusca | Mollusca | 161 | 8.379999999999998e-35 | NTclustered | gi|2334761650|ref|XM_052209352.1| | 6549 | g7678 | i0 | 83.24 | 16.8246268656716 | 179 | 26 | 33 | 3 | 304 | 480 | 204 | 28 | PREDICTED: Mytilus californianus 60S ribosomal protein L27a-like (LOC127705074), mRNA | blastn | 9018 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 4978014 | 4978014 | PRJNA615175_P_NODE_8124_length_526_cov_1.123620_g7957_i0 | PRJNA615175 | 8124 | 526 | 1.12362 | 5.9102412 | Metazoa | 33208 | Mollusca | Mollusca | 961 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g7957 | i0 | 99.62 | 100 | 526 | 2 | 100 | 0 | 1 | 526 | 1577 | 1052 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 52600 | 961 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 8248389 | 8248389 | PRJNA615175_P_NODE_8127_length_525_cov_9.893805_g7960_i0 | PRJNA615175 | 8127 | 525 | 9.893805 | 51.94247625 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.014 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g7960 | i0 | 96.875 | 0.060952380952381 | 32 | 1 | 6 | 0 | 1 | 32 | 8 | 39 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 17173098 | 17173098 | PRJNA615175_P_NODE_9194_length_489_cov_1.480769_g9026_i0 | PRJNA615175 | 9194 | 489 | 1.480769 | 7.24096041 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.048 | NTclustered | gi|2441971836|ref|XM_045309525.2| | 6596 | g9026 | i0 | 100 | 0.0572597137014315 | 28 | 0 | 6 | 0 | 366 | 393 | 437 | 410 | PREDICTED: Mercenaria mercenaria calcineurin subunit B type 1 (LOC123529266), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 22272358 | 22272358 | PRJNA615175_P_NODE_5118_length_680_cov_7.655684_g4955_i0 | PRJNA615175 | 5118 | 680 | 7.655684 | 52.0586512 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 292 | 7.629999999999997e-96 | NR | XP_033735994.1 | 6579 | g4955 | i0 | 70.2 | 19.9147058823529 | 198 | 57 | 87.4 | 1 | 5 | 598 | 23 | 218 | XP_033735994.1 40S ribosomal protein SA-like [Pecten maximus] | diamond | 13542 | 294 | 0.993197278911565 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 23547353 | 23547353 | PRJNA615175_P_NODE_1779_length_1136_cov_5.315146_g1675_i0 | PRJNA615175 | 1779 | 1136 | 5.315146 | 60.38005856 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 100 | 6.83e-19 | NR | KAK3583377.1 | 2493646 | g1675 | i0 | 26.8 | 0.91637323943662 | 347 | 219 | 85.8 | 12 | 983 | 9 | 1008 | 1341 | KAK3583377.1 hypothetical protein CHS0354_040339 [Potamilus streckersoni] | diamond | 1041 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 26795526 | 26795526 | PRJNA615175_P_NODE_28381_length_250_cov_1.740113_g28213_i0 | PRJNA615175 | 28381 | 250 | 1.740113 | 4.3502825 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 42.7 | 0.0405 | NR | XP_048258786.1 | 6454 | g28213 | i0 | 42.9 | 0.756 | 63 | 29 | 73.2 | 2 | 223 | 41 | 433 | 490 | XP_048258786.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit B-like [Haliotis rufescens] | diamond | 189 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27365091 | 27365091 | PRJNA615175_P_NODE_14843_length_367_cov_1.571429_g14675_i0 | PRJNA615175 | 14843 | 367 | 1.571429 | 5.76714443 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 66.6 | 4.98e-10 | NR | XP_062620131.1 | 36930 | g14675 | i0 | 37.5 | 0.784741144414169 | 96 | 59 | 78.5 | 1 | 290 | 3 | 221 | 315 | XP_062620131.1 putative E3 ubiquitin-protein ligase UBR7 [Saccostrea cuccullata] | diamond | 288 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 27378041 | 27378041 | PRJNA615175_P_NODE_4263_length_751_cov_4.876106_g4104_i0 | PRJNA615175 | 4263 | 751 | 4.876106 | 36.61955606 | Haliotis | 6452 | Mollusca | Mollusca | 49.7 | 0.00689 | NR | XP_048247156.1 | 6454 | g4104 | i0 | 41.9 | 0.595206391478029 | 74 | 42 | 29.6 | 1 | 135 | 356 | 313 | 385 | XP_048247156.1 ankyrin repeat and KH domain-containing protein 1-like isoform X1 [Haliotis rufescens] | diamond | 447 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27585873 | 27585873 | PRJNA615175_P_NODE_10164_length_460_cov_3.049096_g9996_i0 | PRJNA615175 | 10164 | 460 | 3.049096 | 14.0258416 | Solemya velum | 13268 | Mollusca | Mollusca | 110 | 8.62e-25 | NR | KAL5021154.1 | 13268 | g9996 | i0 | 40.2 | 1.0695652173913 | 164 | 75 | 99.1 | 6 | 459 | 4 | 150 | 302 | KAL5021154.1 hypothetical protein ScPMuIL_000309 [Solemya velum] | diamond | 492 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 27882948 | 27882948 | PRJNA615175_P_NODE_15325_length_360_cov_3.013937_g15157_i0 | PRJNA615175 | 15325 | 360 | 3.013937 | 10.8501732 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 7.709999999999999e-23 | NR | XP_033736180.1 | 6579 | g15157 | i0 | 54.1 | 12.075 | 85 | 38 | 70 | 1 | 4 | 255 | 306 | 390 | XP_033736180.1 phospholipase B1, membrane-associated-like [Pecten maximus] | diamond | 4347 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 28514490 | 28514490 | PRJNA615175_P_NODE_8867_length_499_cov_4.446009_g8699_i0 | PRJNA615175 | 8867 | 499 | 4.446009 | 22.18558491 | Metazoa | 33208 | Mollusca | Mollusca | 190 | 1.78e-58 | NR | XP_052283353.1 | 45954 | g8699 | i0 | 61.4 | 3.76352705410822 | 158 | 60 | 94.4 | 1 | 499 | 29 | 14 | 171 | XP_052283353.1 soma ferritin-like [Dreissena polymorpha] | diamond | 1878 | 191 | 0.994764397905759 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28659469 | 28659469 | PRJNA615175_P_NODE_35847_length_236_cov_4.564417_g35679_i0 | PRJNA615175 | 35847 | 236 | 4.564417 | 10.77202412 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 98.2 | 4.189999999999999e-23 | NR | XP_045177822.1 | 6596 | g35679 | i0 | 56.6 | 1.95762711864407 | 76 | 33 | 96.6 | 0 | 230 | 3 | 149 | 224 | XP_045177822.1 bax inhibitor 1-like [Mercenaria mercenaria] | diamond | 462 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30301944 | 30301944 | PRJNA615175_P_NODE_3992_length_779_cov_3.984419_g3837_i0 | PRJNA615175 | 3992 | 779 | 3.984419 | 31.03862401 | Lottia gigantea | 225164 | Mollusca | Mollusca | 261 | 9.78e-80 | NR | XP_009064151.1 | 225164 | g3837 | i0 | 51 | 9.03465982028241 | 263 | 123 | 99.7 | 4 | 778 | 2 | 305 | 565 | XP_009064151.1 hypothetical protein LOTGIDRAFT_235910 [Lottia gigantea] | diamond | 7038 | 261 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 31185883 | 31185883 | PRJNA615175_P_NODE_18435_length_325_cov_1.575397_g18267_i0 | PRJNA615175 | 18435 | 325 | 1.575397 | 5.12004025 | Aplysia californica | 6500 | Mollusca | Mollusca | 72.4 | 3.94e-12 | NR | XP_035828693.1 | 6500 | g18267 | i0 | 38.4 | 4.67076923076923 | 112 | 53 | 93.2 | 7 | 325 | 23 | 113 | 219 | XP_035828693.1 fibropellin-1 [Aplysia californica] | diamond | 1518 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 31913622 | 31913622 | PRJNA615175_P_NODE_14677_length_369_cov_3.902027_g14509_i0 | PRJNA615175 | 14677 | 369 | 3.902027 | 14.39847963 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 45.4 | 0.0174 | NR | XP_062582681.1 | 36930 | g14509 | i0 | 32.4 | 0.910569105691057 | 68 | 34 | 45.5 | 1 | 2 | 169 | 1134 | 1201 | XP_062582681.1 uncharacterized protein LOC134244433 [Saccostrea cuccullata] | diamond | 336 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 32419977 | 32419977 | PRJNA615175_P_NODE_739_length_1571_cov_5.249666_g682_i0 | PRJNA615175 | 739 | 1571 | 5.249666 | 82.47225286 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 87.4 | 4.37e-14 | NR | XP_022302014.1 | 6565 | g682 | i0 | 30.6 | 0.473583704646722 | 248 | 147 | 43.5 | 9 | 849 | 166 | 116 | 358 | XP_022302014.1 uncharacterized protein LOC111110005 [Crassostrea virginica] | diamond | 744 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica |
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);;