contig_metadata
27 rows where bioproject = "PRJNA915212" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9823052 | 9823052 | PRJNA915212_P_NODE_5588_length_251_cov_0.985149_g5550_i0 | PRJNA915212 | 5588 | 251 | 0.985149 | 2.47272399 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 145 | 3.7099999999999997e-38 | NR | XP_047143150.1 | 6087 | g5550 | i0 | 86.6 | 30.4183266932271 | 82 | 11 | 98 | 0 | 5 | 250 | 49 | 130 | XP_047143150.1 probable aconitate hydratase, mitochondrial isoform X1 [Hydra vulgaris] | diamond | 7635 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13648798 | 13648798 | PRJNA915212_P_NODE_7811_length_209_cov_0.956250_g7773_i0 | PRJNA915212 | 7811 | 209 | 0.95625 | 1.9985625 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 113 | 1.25e-27 | NR | XP_066919504.1 | 252671 | g7773 | i0 | 72.1 | 3.93301435406699 | 68 | 19 | 97.6 | 0 | 4 | 207 | 45 | 112 | XP_066919504.1 glutathione reductase, mitochondrial-like [Clytia hemisphaerica] | diamond | 822 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 20021803 | 20021803 | PRJNA915212_P_NODE_2236_length_439_cov_2.358974_g2200_i0 | PRJNA915212 | 2236 | 439 | 2.358974 | 10.35589586 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 175 | 5.75e-53 | NR | XP_057307393.1 | 13093 | g2200 | i0 | 62.9 | 33.5740318906606 | 140 | 52 | 95.7 | 0 | 11 | 430 | 29 | 168 | XP_057307393.1 40S ribosomal protein S15-like [Hydractinia symbiolongicarpus] | diamond | 14739 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 21297124 | 21297124 | PRJNA915212_P_NODE_2337_length_430_cov_1.845144_g2301_i0 | PRJNA915212 | 2337 | 430 | 1.845144 | 7.9341192 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 166 | 5.13e-50 | NR | XP_068702776.1 | 591990 | g2301 | i0 | 61.8 | 8.31627906976744 | 131 | 50 | 91.4 | 0 | 21 | 413 | 3 | 133 | XP_068702776.1 large ribosomal subunit protein eL32-like [Montipora foliosa] | diamond | 3576 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 23847428 | 23847428 | PRJNA915212_P_NODE_539_length_908_cov_2.525029_g517_i0 | PRJNA915212 | 539 | 908 | 2.525029 | 22.92726332 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 221 | 1.97e-67 | NR | XP_031549886.1 | 6105 | g517 | i0 | 69.1 | 32.2235682819383 | 162 | 48 | 53.5 | 2 | 895 | 410 | 1 | 160 | XP_031549886.1 40S ribosomal protein S3a [Actinia tenebrosa] | diamond | 29259 | 222 | 0.995495495495496 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 26683583 | 26683583 | PRJNA915212_P_NODE_2801_length_384_cov_1.167164_g2765_i0 | PRJNA915212 | 2801 | 384 | 1.167164 | 4.48190976 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 94.4 | 1.28e-19 | NR | XP_027048858.1 | 46731 | g2765 | i0 | 38.7 | 1.859375 | 119 | 70 | 93 | 1 | 28 | 384 | 331 | 446 | XP_027048858.1 serine/threonine/tyrosine-interacting-like protein 1 [Pocillopora damicornis] | diamond | 714 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 26778809 | 26778809 | PRJNA915212_P_NODE_10301_length_180_cov_1.473282_g10263_i0 | PRJNA915212 | 10301 | 180 | 1.473282 | 2.6519076 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 46.2 | 2.06e-4 | NR | KAK2561471.1 | 6130 | g10263 | i0 | 51.4 | 3.55 | 35 | 17 | 58.3 | 0 | 5 | 109 | 70 | 104 | KAK2561471.1 Dynein light chain roadblock-type 2 [Acropora cervicornis] | diamond | 639 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 26898117 | 26898117 | PRJNA915212_P_NODE_7001_length_221_cov_1.180233_g6963_i0 | PRJNA915212 | 7001 | 221 | 1.180233 | 2.60831493 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 52.4 | 8.57e-6 | NR | XP_046850234.1 | 2897299 | g6963 | i0 | 39.7 | 3 | 73 | 39 | 97.7 | 2 | 217 | 2 | 167 | 235 | XP_046850234.1 pyridoxal phosphate homeostasis protein-like [Xenia sp. Carnegie-2017] | diamond | 663 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 27751383 | 27751383 | PRJNA915212_P_NODE_4864_length_272_cov_1.264574_g4826_i0 | PRJNA915212 | 4864 | 272 | 1.264574 | 3.43964128 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 58.9 | 4.17e-8 | NR | XP_028409959.1 | 151771 | g4826 | i0 | 65.2 | 0.507352941176471 | 46 | 15 | 49.6 | 1 | 135 | 1 | 34 | 79 | XP_028409959.1 tubulin polymerization-promoting protein family member 2-like [Dendronephthya gigantea] | diamond | 138 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27782899 | 27782899 | PRJNA915212_P_NODE_4404_length_289_cov_1.062500_g4366_i0 | PRJNA915212 | 4404 | 289 | 1.0625 | 3.070625 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 117 | 3.76e-28 | NR | XP_065067104.1 | 499914 | g4366 | i0 | 69.1 | 1.88927335640138 | 81 | 24 | 83 | 1 | 285 | 46 | 399 | 479 | XP_065067104.1 protein DD3-3-like [Rhopilema esculentum] | diamond | 546 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27845736 | 27845736 | PRJNA915212_P_NODE_4104_length_302_cov_1.189723_g4066_i0 | PRJNA915212 | 4104 | 302 | 1.189723 | 3.59296346 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 47 | 0.00243 | NR | XP_020622494.1 | 48498 | g4066 | i0 | 32.9 | 0.78476821192053 | 79 | 53 | 78.5 | 0 | 38 | 274 | 560 | 638 | XP_020622494.1 alpha-actinin-like [Orbicella faveolata] | diamond | 237 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 28295180 | 28295180 | PRJNA915212_P_NODE_9226_length_191_cov_1.436620_g9188_i0 | PRJNA915212 | 9226 | 191 | 1.43662 | 2.7439442 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 73.2 | 1.06e-14 | NR | XP_015757388.1 | 70779 | g9188 | i0 | 88.4 | 2.63874345549738 | 43 | 5 | 67.5 | 0 | 61 | 189 | 3 | 45 | XP_015757388.1 PREDICTED: 60S ribosomal protein L30-like [Acropora digitifera] | diamond | 504 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 28445942 | 28445942 | PRJNA915212_P_NODE_8626_length_198_cov_1.711409_g8588_i0 | PRJNA915212 | 8626 | 198 | 1.711409 | 3.38858982 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 62 | 3.28e-9 | NR | XP_028401692.1 | 151771 | g8588 | i0 | 49.2 | 1.90909090909091 | 63 | 30 | 92.4 | 1 | 188 | 6 | 943 | 1005 | XP_028401692.1 DNA-directed RNA polymerase II subunit RPB1-like isoform X2 [Dendronephthya gigantea] | diamond | 378 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 28508979 | 28508979 | PRJNA915212_P_NODE_10147_length_182_cov_0.827068_g10109_i0 | PRJNA915212 | 10147 | 182 | 0.827068 | 1.50526376 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 62 | 2.62e-9 | NR | XP_066925925.1 | 252671 | g10109 | i0 | 46.8 | 1.02197802197802 | 62 | 31 | 98.9 | 2 | 181 | 2 | 170 | 231 | XP_066925925.1 gelsolin, cytoplasmic-like [Clytia hemisphaerica] | diamond | 186 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28579538 | 28579538 | PRJNA915212_P_NODE_5827_length_245_cov_1.040816_g5789_i0 | PRJNA915212 | 5827 | 245 | 1.040816 | 2.5499992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 6.74e-28 | NR | XP_028414324.1 | 151771 | g5789 | i0 | 62 | 2.70612244897959 | 79 | 30 | 96.7 | 0 | 242 | 6 | 474 | 552 | XP_028414324.1 protein DD3-3-like [Dendronephthya gigantea] | diamond | 663 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29084736 | 29084736 | PRJNA915212_P_NODE_5348_length_257_cov_1.471154_g5310_i0 | PRJNA915212 | 5348 | 257 | 1.471154 | 3.78086578 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 89.4 | 1.83e-18 | NR | XP_028414460.1 | 151771 | g5310 | i0 | 58.6 | 2.45136186770428 | 70 | 29 | 81.7 | 0 | 46 | 255 | 3847 | 3916 | XP_028414460.1 dynein heavy chain 6, axonemal-like [Dendronephthya gigantea] | diamond | 630 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29645182 | 29645182 | PRJNA915212_P_NODE_13370_length_164_cov_0.886957_g13332_i0 | PRJNA915212 | 13370 | 164 | 0.886957 | 1.45460948 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 48.9 | 8.45e-5 | NR | XP_027056545.1 | 46731 | g13332 | i0 | 50 | 0.878048780487805 | 48 | 24 | 87.8 | 0 | 146 | 3 | 414 | 461 | XP_027056545.1 equilibrative nucleoside transporter 1-like [Pocillopora damicornis] | diamond | 144 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 29652574 | 29652574 | PRJNA915212_P_NODE_14530_length_162_cov_0.902655_g14492_i0 | PRJNA915212 | 14530 | 162 | 0.902655 | 1.4623011 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 56.2 | 2.2e-7 | NR | PFX23654.1 | 50429 | g14492 | i0 | 69.7 | 2.83333333333333 | 33 | 10 | 61.1 | 0 | 99 | 1 | 107 | 139 | PFX23654.1 Crooked neck-like protein 1 [Stylophora pistillata] | diamond | 459 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30024770 | 30024770 | PRJNA915212_P_NODE_13991_length_163_cov_0.894737_g13953_i0 | PRJNA915212 | 13991 | 163 | 0.894737 | 1.45842131 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 65.1 | 1.59e-10 | NR | XP_028410485.1 | 151771 | g13953 | i0 | 43.4 | 3.60736196319018 | 53 | 30 | 97.5 | 0 | 3 | 161 | 223 | 275 | XP_028410485.1 E3 ubiquitin-protein ligase CHFR-like [Dendronephthya gigantea] | diamond | 588 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30372526 | 30372526 | PRJNA915212_P_NODE_14852_length_161_cov_0.910714_g14814_i0 | PRJNA915212 | 14852 | 161 | 0.910714 | 1.46624954 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 70.9 | 1.46e-12 | NR | KXJ26381.1 | 2652724 | g14814 | i0 | 62.3 | 3.95031055900621 | 53 | 20 | 98.8 | 0 | 2 | 160 | 103 | 155 | KXJ26381.1 T-complex protein 1 subunit beta [Exaiptasia diaphana] | diamond | 636 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 31295790 | 31295790 | PRJNA915212_P_NODE_7395_length_215_cov_1.228916_g7357_i0 | PRJNA915212 | 7395 | 215 | 1.228916 | 2.6421694 | root | 1 | Root_unresolved | Root_unresolved | 57.8 | 8.76e-8 | NR | CAH3184274.1 | 104759 | g7357 | i0 | 44.8 | 4.42325581395349 | 58 | 32 | 80.9 | 0 | 175 | 2 | 6 | 63 | CAH3184274.1 unnamed protein product [Porites lobata] | diamond | 951 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32111024 | 32111024 | PRJNA915212_P_NODE_5798_length_245_cov_1.994898_g5760_i0 | PRJNA915212 | 5798 | 245 | 1.994898 | 4.8875001 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 55.8 | 1.24e-7 | NR | KAJ7377012.1 | 174260 | g5760 | i0 | 42.4 | 4.26122448979592 | 85 | 45 | 99.2 | 4 | 3 | 245 | 2 | 86 | KAJ7377012.1 hypothetical protein OS493_031285 [Desmophyllum pertusum] | diamond | 1044 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32205908 | 32205908 | PRJNA915212_P_NODE_11738_length_167_cov_0.864407_g11700_i0 | PRJNA915212 | 11738 | 167 | 0.864407 | 1.44355969 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 86.7 | 4.46e-18 | NR | KXJ29993.1 | 2652724 | g11700 | i0 | 70.9 | 12.8263473053892 | 55 | 16 | 98.8 | 0 | 1 | 165 | 440 | 494 | KXJ29993.1 Glycine amidinotransferase, mitochondrial [Exaiptasia diaphana] | diamond | 2142 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32205922 | 32205922 | PRJNA915212_P_NODE_6598_length_228_cov_1.139665_g6560_i0 | PRJNA915212 | 6598 | 228 | 1.139665 | 2.5984362 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 55.1 | 9.28e-7 | NR | XP_068678994.1 | 591990 | g6560 | i0 | 57.4 | 0.710526315789474 | 54 | 23 | 71.1 | 0 | 163 | 2 | 59 | 112 | XP_068678994.1 large ribosomal subunit protein eL6-like [Montipora foliosa] | diamond | 162 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 32395802 | 32395802 | PRJNA915212_P_NODE_14259_length_162_cov_0.902655_g14221_i0 | PRJNA915212 | 14259 | 162 | 0.902655 | 1.4623011 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 86.3 | 5.57e-18 | NR | XP_027059822.1 | 46731 | g14221 | i0 | 66 | 9.48148148148148 | 53 | 18 | 98.1 | 0 | 2 | 160 | 547 | 599 | XP_027059822.1 alkyldihydroxyacetonephosphate synthase, peroxisomal-like [Pocillopora damicornis] | diamond | 1536 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 32529874 | 32529874 | PRJNA915212_P_NODE_3919_length_310_cov_1.452107_g3881_i0 | PRJNA915212 | 3919 | 310 | 1.452107 | 4.5015317 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 2.8e-8 | NR | XP_065647040.1 | 6087 | g3881 | i0 | 38.4 | 7.3741935483871 | 73 | 45 | 70.6 | 0 | 302 | 84 | 46 | 118 | XP_065647040.1 myotrophin isoform X2 [Hydra vulgaris] | diamond | 2286 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32616982 | 32616982 | PRJNA915212_P_NODE_12280_length_166_cov_0.871795_g12242_i0 | PRJNA915212 | 12280 | 166 | 0.871795 | 1.4471797 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 46.2 | 8.04e-4 | NR | XP_028391311.1 | 151771 | g12242 | i0 | 38.2 | 0.993975903614458 | 55 | 34 | 99.4 | 0 | 2 | 166 | 918 | 972 | XP_028391311.1 RRP12-like protein [Dendronephthya gigantea] | diamond | 165 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;