contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21873052 | 21873052 | PRJNA1092581_P_NODE_17318_length_667_cov_5.649832_g16806_i0 | PRJNA1092581 | 17318 | 667 | 5.649832 | 37.68437944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 345 | 6.469999999999999e-118 | NR | CAL1540518.1 | 6523 | g16806 | i0 | 84.6 | 45.4362818590705 | 195 | 29 | 87.7 | 1 | 44 | 628 | 34 | 227 | CAL1540518.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 30306 | 345 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 26750651 | 26750651 | PRJNA1092581_P_NODE_115781_length_230_cov_4.872611_g115248_i0 | PRJNA1092581 | 115781 | 230 | 4.872611 | 11.2070053 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 64.3 | 7.6e-10 | NR | KAH3698300.1 | 45954 | g115248 | i0 | 62.3 | 1.56521739130435 | 61 | 18 | 79.6 | 1 | 218 | 36 | 383 | 438 | KAH3698300.1 hypothetical protein DPMN_085819, partial [Dreissena polymorpha] | diamond | 360 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27699723 | 27699723 | PRJNA1092581_P_NODE_44864_length_405_cov_2.174699_g44331_i0 | PRJNA1092581 | 44864 | 405 | 2.174699 | 8.80753095 | Pinctada fucata | 50426 | Mollusca | Mollusca | 72.8 | 7.3e-12 | NR | AJD81433.1 | 50426 | g44331 | i0 | 50 | 0.444444444444444 | 60 | 29 | 43.7 | 1 | 374 | 198 | 631 | 690 | AJD81433.1 granulin epithelin precursor variant 2 [Pinctada fucata] | diamond | 180 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada fucata | |
| 27817285 | 27817285 | PRJNA1092581_P_NODE_63604_length_331_cov_2.418605_g63071_i0 | PRJNA1092581 | 63604 | 331 | 2.418605 | 8.00558255 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.5 | 2.35e-7 | NR | KAH9523289.1 | 55810 | g63071 | i0 | 69 | 2.17522658610272 | 42 | 13 | 38.1 | 0 | 151 | 276 | 100 | 141 | KAH9523289.1 hypothetical protein Btru_066312 [Bulinus truncatus] | diamond | 720 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 28385388 | 28385388 | PRJNA1092581_P_NODE_76666_length_296_cov_8.744395_g76133_i0 | PRJNA1092581 | 76666 | 296 | 8.744395 | 25.8834092 | Planorbidae | 6524 | Mollusca | Mollusca | 124 | 6.949999999999999e-31 | NR | XP_013084692.2 | 6526 | g76133 | i0 | 71.6 | 8.71621621621622 | 88 | 20 | 84.1 | 1 | 19 | 267 | 214 | 301 | XP_013084692.2 transcription factor Dp-1-like isoform X2 [Biomphalaria glabrata] | diamond | 2580 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29206542 | 29206542 | PRJNA1092581_P_NODE_18489_length_647_cov_5.472125_g17973_i0 | PRJNA1092581 | 18489 | 647 | 5.472125 | 35.40464875 | Metazoa | 33208 | Mollusca | Mollusca | 88.6 | 2.69e-16 | NR | XP_065932269.1 | 29159 | g17973 | i0 | 36.8 | 2.258114374034 | 163 | 86 | 75.1 | 4 | 22 | 507 | 813 | 959 | XP_065932269.1 coronin-7 [Magallana gigas] | diamond | 1461 | 89.4 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 30004485 | 30004485 | PRJNA1092581_P_NODE_40991_length_426_cov_104.563739_g40458_i0 | PRJNA1092581 | 40991 | 426 | 104.563739 | 445.44152814 | Elysia marginata | 1093978 | Mollusca | Mollusca | 49.3 | 1.86e-4 | NR | GFS14131.1 | 1093978 | g40458 | i0 | 68.4 | 0.267605633802817 | 38 | 9 | 24.6 | 1 | 426 | 322 | 30 | 67 | GFS14131.1 60S acidic ribosomal protein P2 [Elysia marginata] | diamond | 114 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 30509881 | 30509881 | PRJNA1092581_P_NODE_125513_length_205_cov_5.848485_g124980_i0 | PRJNA1092581 | 125513 | 205 | 5.848485 | 11.98939425 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 82.4 | 2.31e-16 | NR | BFZ08560.1 | 145626 | g124980 | i0 | 72.2 | 0.790243902439024 | 54 | 15 | 79 | 0 | 18 | 179 | 65 | 118 | BFZ08560.1 hypothetical protein BsWGS_11599 [Bradybaena similaris] | diamond | 162 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 30604618 | 30604618 | PRJNA1092581_P_NODE_48113_length_389_cov_2.727848_g47580_i0 | PRJNA1092581 | 48113 | 389 | 2.727848 | 10.61132872 | Aplysia californica | 6500 | Mollusca | Mollusca | 92 | 1.05e-18 | NR | XP_012938109.1 | 6500 | g47580 | i0 | 41.3 | 0.97172236503856 | 126 | 61 | 94.9 | 4 | 369 | 1 | 192 | 307 | XP_012938109.1 uncharacterized protein LOC101859330 [Aplysia californica] | diamond | 378 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 30627503 | 30627503 | PRJNA1092581_P_NODE_83133_length_282_cov_7.076555_g82600_i0 | PRJNA1092581 | 83133 | 282 | 7.076555 | 19.9558851 | Metazoa | 33208 | Mollusca | Mollusca | 102 | 5.1199999999999996e-23 | NR | KAL5011878.1 | 13268 | g82600 | i0 | 53.9 | 3.72340425531915 | 89 | 41 | 94.7 | 0 | 268 | 2 | 370 | 458 | KAL5011878.1 hypothetical protein ScPMuIL_010429 [Solemya velum] | diamond | 1050 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 31173064 | 31173064 | PRJNA1092581_P_NODE_128235_length_197_cov_4.258065_g127702_i0 | PRJNA1092581 | 128235 | 197 | 4.258065 | 8.38838805 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 42.7 | 0.02 | NR | XP_061175729.1 | 191078 | g127702 | i0 | 37 | 0.822335025380711 | 54 | 34 | 82.2 | 0 | 197 | 36 | 16 | 69 | XP_061175729.1 uncharacterized protein LOC133184658 [Saccostrea echinata] | diamond | 162 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 31932445 | 31932445 | PRJNA1092581_P_NODE_96997_length_257_cov_7.559783_g96464_i0 | PRJNA1092581 | 96997 | 257 | 7.559783 | 19.42864231 | Elysia marginata | 1093978 | Mollusca | Mollusca | 49.3 | 5.15e-5 | NR | GFR66183.1 | 1093978 | g96464 | i0 | 44.4 | 1.93774319066148 | 54 | 30 | 63 | 0 | 171 | 10 | 74 | 127 | GFR66183.1 hypothetical protein ElyMa_001963200 [Elysia marginata] | diamond | 498 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31955401 | 31955401 | PRJNA1092581_P_NODE_33697_length_475_cov_4.330846_g33165_i0 | PRJNA1092581 | 33697 | 475 | 4.330846 | 20.5715185 | Opisthokonta | 33154 | Mollusca | Mollusca | 131 | 2.21e-36 | NR | XP_052255822.1 | 45954 | g33165 | i0 | 68.5 | 5.29894736842105 | 92 | 29 | 58.1 | 0 | 410 | 135 | 1 | 92 | XP_052255822.1 probable 60S ribosomal protein L37-A [Dreissena polymorpha] | diamond | 2517 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32249287 | 32249287 | PRJNA1092581_P_NODE_95438_length_260_cov_2.684492_g94905_i0 | PRJNA1092581 | 95438 | 260 | 2.684492 | 6.9796792 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 45.8 | 0.00373 | NR | XP_013072243.2 | 6526 | g94905 | i0 | 35.4 | 1.5 | 65 | 36 | 68.1 | 1 | 27 | 203 | 431 | 495 | XP_013072243.2 ribosomal protein S6 kinase-related protein-like isoform X2 [Biomphalaria glabrata] | diamond | 390 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 32493600 | 32493600 | PRJNA1092581_P_NODE_37019_length_451_cov_8.095238_g36487_i0 | PRJNA1092581 | 37019 | 451 | 8.095238 | 36.50952338 | Metazoa | 33208 | Mollusca | Mollusca | 59.3 | 5.55e-7 | NR | VDI24661.1 | 29158 | g36487 | i0 | 30.6 | 9.51219512195122 | 98 | 68 | 65.2 | 0 | 113 | 406 | 161 | 258 | VDI24661.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 4290 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis |
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);;