contig_metadata
14 rows where bioproject = "PRJNA1188114", tax_phylum = "Mollusca" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1594733 | 1594733 | PRJNA1188114_P_NODE_822_length_478_cov_4.785548_g770_i0 | PRJNA1188114 | 822 | 478 | 4.785548 | 22.87491944 | Aplysia californica | 6500 | Mollusca | Mollusca | 294 | 7.000000000000001e-75 | NTclustered | gi|1897919841|ref|XM_013080763.2| | 6500 | g770 | i0 | 79.111 | 89.8054393305439 | 450 | 76 | 92 | 17 | 25 | 465 | 62 | 502 | PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA | blastn | 42927 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 7973311 | 7973311 | PRJNA1188114_P_NODE_4927_length_206_cov_1.617834_g4875_i0 | PRJNA1188114 | 4927 | 206 | 1.617834 | 3.33273804 | Metazoa | 33208 | Mollusca | Mollusca | 120 | 1.04e-30 | NR | NP_001295770.1 | 29159 | g4875 | i0 | 79.4 | 13.8640776699029 | 68 | 14 | 99 | 0 | 205 | 2 | 229 | 296 | NP_001295770.1 glutamine synthetase 2 cytoplasmic-like [Magallana gigas] | diamond | 2856 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 9247848 | 9247848 | PRJNA1188114_P_NODE_1068_length_418_cov_2.168022_g1016_i0 | PRJNA1188114 | 1068 | 418 | 2.168022 | 9.06233196 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 89.8 | 3.07e-13 | NTclustered | gi|1397659794|ref|XM_025226100.1| | 400727 | g1016 | i0 | 86.747 | 5.61004784688995 | 83 | 8 | 20 | 2 | 87 | 169 | 855 | 776 | PREDICTED: Pomacea canaliculata skin secretory protein xP2-like (LOC112556759), mRNA | blastn | 2345 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 14349073 | 14349073 | PRJNA1188114_P_NODE_4892_length_207_cov_0.968354_g4840_i0 | PRJNA1188114 | 4892 | 207 | 0.968354 | 2.00449278 | Metazoa | 33208 | Mollusca | Mollusca | 121 | 1.4099999999999998e-31 | NR | XP_046356896.2 | 6454 | g4840 | i0 | 82.6 | 5 | 69 | 12 | 100 | 0 | 207 | 1 | 161 | 229 | XP_046356896.2 very-long-chain enoyl-CoA reductase-like [Haliotis rufescens] | diamond | 1035 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 15069778 | 15069778 | PRJNA1188114_P_NODE_11792_length_168_cov_1.285714_g11740_i0 | PRJNA1188114 | 11792 | 168 | 1.285714 | 2.15999952 | Metazoa | 33208 | Mollusca | Mollusca | 104 | 3.84e-18 | NTclustered | gi|1897920673|ref|XM_005095879.3| | 6500 | g11740 | i0 | 92.958 | 3.70833333333333 | 71 | 5 | 42 | 0 | 64 | 134 | 818 | 748 | PREDICTED: Aplysia californica ras-related protein Rab-7a (LOC101862261), transcript variant X1, mRNA | blastn | 623 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 19446051 | 19446051 | PRJNA1188114_P_NODE_3656_length_230_cov_1.127072_g3604_i0 | PRJNA1188114 | 3656 | 230 | 1.127072 | 2.5922656 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 58.4 | 4.41e-4 | NTclustered | gi|2427251553|ref|XM_052969724.1| | 37653 | g3604 | i0 | 100 | 1.25652173913043 | 31 | 0 | 13 | 0 | 23 | 53 | 2942 | 2912 | PREDICTED: Octopus bimaculoides transcription factor mef2A (LOC106870467), mRNA | blastn | 289 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 21996741 | 21996741 | PRJNA1188114_P_NODE_4958_length_205_cov_4.500000_g4906_i0 | PRJNA1188114 | 4958 | 205 | 4.5 | 9.225 | Metazoa | 33208 | Mollusca | Mollusca | 97.1 | 2.65e-24 | NR | CAL1533184.1 | 6523 | g4906 | i0 | 79.7 | 1.58048780487805 | 59 | 12 | 86.3 | 0 | 28 | 204 | 17 | 75 | CAL1533184.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 324 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 26945683 | 26945683 | PRJNA1188114_P_NODE_14302_length_165_cov_1.318966_g14250_i0 | PRJNA1188114 | 14302 | 165 | 1.318966 | 2.1762939 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 82.4 | 1.29e-16 | NR | KAK6986869.1 | 6526 | g14250 | i0 | 72.7 | 9 | 55 | 15 | 100 | 0 | 165 | 1 | 124 | 178 | KAK6986869.1 T-complex protein 1 subunit beta, partial [Biomphalaria glabrata] | diamond | 1485 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27281148 | 27281148 | PRJNA1188114_P_NODE_4723_length_210_cov_1.267081_g4671_i0 | PRJNA1188114 | 4723 | 210 | 1.267081 | 2.6608701 | Metazoa | 33208 | Mollusca | Mollusca | 48.1 | 2.86e-4 | NR | XP_059166324.1 | 109671 | g4671 | i0 | 63 | 4.35714285714286 | 27 | 10 | 38.6 | 0 | 83 | 3 | 281 | 307 | XP_059166324.1 sulfotransferase 1E1-like isoform X4 [Physella acuta] | diamond | 915 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 29566924 | 29566924 | PRJNA1188114_P_NODE_12550_length_167_cov_0.864407_g12498_i0 | PRJNA1188114 | 12550 | 167 | 0.864407 | 1.44355969 | Pecten maximus | 6579 | Mollusca | Mollusca | 67.4 | 1.78e-11 | NR | XP_033757081.1 | 6579 | g12498 | i0 | 63.6 | 2.96407185628743 | 55 | 19 | 98.8 | 1 | 166 | 2 | 103 | 156 | XP_033757081.1 pyridoxal phosphate homeostasis protein-like [Pecten maximus] | diamond | 495 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 29756340 | 29756340 | PRJNA1188114_P_NODE_9511_length_177_cov_1.585938_g9459_i0 | PRJNA1188114 | 9511 | 177 | 1.585938 | 2.80711026 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 99.4 | 2.51e-23 | NR | CAC5403910.1 | 42192 | g9459 | i0 | 77.6 | 3.93220338983051 | 58 | 12 | 98.3 | 1 | 176 | 3 | 129 | 185 | CAC5403910.1 BRX1 [Mytilus coruscus] | diamond | 696 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31924641 | 31924641 | PRJNA1188114_P_NODE_6577_length_189_cov_1.450000_g6525_i0 | PRJNA1188114 | 6577 | 189 | 1.45 | 2.7405 | Magallana | 147004 | Mollusca | Mollusca | 53.9 | 1.94e-6 | NR | XP_019920313.3 | 29159 | g6525 | i0 | 43.1 | 2.82539682539683 | 58 | 32 | 90.5 | 1 | 187 | 17 | 52 | 109 | XP_019920313.3 peroxidase-like protein [Magallana gigas] | diamond | 534 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 32840824 | 32840824 | PRJNA1188114_P_NODE_8640_length_181_cov_1.469697_g8588_i0 | PRJNA1188114 | 8640 | 181 | 1.469697 | 2.66015157 | Metazoa | 33208 | Mollusca | Mollusca | 77 | 1.36e-14 | NR | XP_053376443.1 | 6596 | g8588 | i0 | 74 | 29.4033149171271 | 50 | 13 | 82.9 | 0 | 1 | 150 | 1453 | 1502 | XP_053376443.1 helicase domino-like [Mercenaria mercenaria] | diamond | 5322 | 77.4 | 0.994832041343669 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 32853402 | 32853402 | PRJNA1188114_P_NODE_16080_length_164_cov_0.886957_g16028_i0 | PRJNA1188114 | 16080 | 164 | 0.886957 | 1.45460948 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 60.1 | 9.53e-9 | NR | XP_041366930.1 | 1735272 | g16028 | i0 | 62.5 | 1.75609756097561 | 48 | 18 | 87.8 | 0 | 20 | 163 | 149 | 196 | XP_041366930.1 phospholipase B1, membrane-associated-like [Gigantopelta aegis] | diamond | 288 | 60.1 | 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);;