contig_metadata
26 rows where bioproject = "PRJNA1002816", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10356086 | 10356086 | PRJNA1002816_P_NODE_19249_length_246_cov_0.890173_g19089_i0 | PRJNA1002816 | 19249 | 246 | 0.890173 | 2.18982558 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 106 | 6.02e-26 | NR | KAF1741254.1 | 59785 | g19089 | i0 | 76.1 | 0.865853658536585 | 71 | 17 | 86.6 | 0 | 33 | 245 | 1 | 71 | KAF1741254.1 hypothetical protein MXB_511, partial [Myxobolus squamalis] | diamond | 213 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 12906603 | 12906603 | PRJNA1002816_P_NODE_1831_length_839_cov_4.404700_g1697_i0 | PRJNA1002816 | 1831 | 839 | 4.4047 | 36.955433 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 508 | 5.16e-172 | NR | KAK2573715.1 | 6130 | g1697 | i0 | 94.9 | 164.084624553039 | 256 | 13 | 91.5 | 0 | 70 | 837 | 431 | 686 | KAK2573715.1 Tubulin beta chain [Acropora cervicornis] | diamond | 137667 | 513 | 0.990253411306043 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 14181523 | 14181523 | PRJNA1002816_P_NODE_17732_length_250_cov_1.564972_g17572_i0 | PRJNA1002816 | 17732 | 250 | 1.564972 | 3.91243 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 121 | 7.02e-30 | NR | PFX21430.1 | 50429 | g17572 | i0 | 74.1 | 22.932 | 81 | 21 | 97.2 | 0 | 6 | 248 | 124 | 204 | PFX21430.1 Very long-chain specific acyl-CoA dehydrogenase, mitochondrial [Stylophora pistillata] | diamond | 5733 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 16729808 | 16729808 | PRJNA1002816_P_NODE_17734_length_250_cov_1.531073_g17574_i0 | PRJNA1002816 | 17734 | 250 | 1.531073 | 3.8276825 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 134 | 1e-36 | NR | XP_057311356.1 | 13093 | g17574 | i0 | 82.1 | 1.932 | 78 | 14 | 93.6 | 0 | 235 | 2 | 42 | 119 | XP_057311356.1 40S ribosomal protein S2-like [Hydractinia symbiolongicarpus] | diamond | 483 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 20554135 | 20554135 | PRJNA1002816_P_NODE_3077_length_648_cov_1.212174_g2920_i0 | PRJNA1002816 | 3077 | 648 | 1.212174 | 7.85488752 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 245 | 4.03e-77 | NR | XP_032231229.1 | 45351 | g2920 | i0 | 58 | 8.00462962962963 | 193 | 80 | 89.4 | 1 | 647 | 69 | 147 | 338 | XP_032231229.1 serine/threonine-protein kinase Aurora-2 [Nematostella vectensis] | diamond | 5187 | 247 | 0.991902834008097 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26622823 | 26622823 | PRJNA1002816_P_NODE_18501_length_248_cov_0.880000_g18341_i0 | PRJNA1002816 | 18501 | 248 | 0.88 | 2.1824 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 48.9 | 2.32e-4 | NR | KII73527.1 | 669202 | g18341 | i0 | 44.8 | 0.701612903225806 | 58 | 31 | 69 | 1 | 248 | 78 | 200 | 257 | KII73527.1 Translocon-associated protein subunit alpha [Thelohanellus kitauei] | diamond | 174 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 27445583 | 27445583 | PRJNA1002816_P_NODE_18463_length_248_cov_0.880000_g18303_i0 | PRJNA1002816 | 18463 | 248 | 0.88 | 2.1824 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 110 | 2.51e-26 | NR | XP_066913420.1 | 252671 | g18303 | i0 | 65.9 | 2.9758064516129 | 82 | 28 | 99.2 | 0 | 246 | 1 | 323 | 404 | XP_066913420.1 glycerol kinase 3-like [Clytia hemisphaerica] | diamond | 738 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27627450 | 27627450 | PRJNA1002816_P_NODE_18564_length_248_cov_0.880000_g18404_i0 | PRJNA1002816 | 18564 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 95.5 | 8.99e-21 | NR | XP_028404504.1 | 151771 | g18404 | i0 | 56 | 2.03225806451613 | 84 | 35 | 99.2 | 1 | 248 | 3 | 118 | 201 | XP_028404504.1 dolichyl pyrophosphate Man9GlcNAc2 alpha-1,3-glucosyltransferase-like [Dendronephthya gigantea] | diamond | 504 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27729808 | 27729808 | PRJNA1002816_P_NODE_14764_length_283_cov_1.538095_g14604_i0 | PRJNA1002816 | 14764 | 283 | 1.538095 | 4.35280885 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 142 | 1.4199999999999998e-37 | NR | XP_027055263.1 | 46731 | g14604 | i0 | 64.8 | 5.80918727915194 | 91 | 32 | 96.5 | 0 | 9 | 281 | 7 | 97 | XP_027055263.1 lariat debranching enzyme B-like [Pocillopora damicornis] | diamond | 1644 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 27824326 | 27824326 | PRJNA1002816_P_NODE_14624_length_285_cov_1.216981_g14464_i0 | PRJNA1002816 | 14624 | 285 | 1.216981 | 3.46839585 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 150 | 1.1199999999999999e-40 | NR | KAF0988596.1 | 69463 | g14464 | i0 | 74.7 | 2 | 95 | 24 | 100 | 0 | 285 | 1 | 129 | 223 | KAF0988596.1 hypothetical protein HZS_5168, partial [Henneguya salminicola] | diamond | 570 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 28321876 | 28321876 | PRJNA1002816_P_NODE_14866_length_282_cov_1.483254_g14706_i0 | PRJNA1002816 | 14866 | 282 | 1.483254 | 4.18277628 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52 | 3.25e-5 | NR | XP_020618282.1 | 48498 | g14706 | i0 | 43.4 | 2.92553191489362 | 53 | 26 | 53.2 | 3 | 262 | 113 | 310 | 361 | XP_020618282.1 uncharacterized protein LOC110056177 [Orbicella faveolata] | diamond | 825 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 28771339 | 28771339 | PRJNA1002816_P_NODE_11507_length_327_cov_2.047244_g11347_i0 | PRJNA1002816 | 11507 | 327 | 2.047244 | 6.69448788 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 47.4 | 0.00235 | NR | XP_031575079.1 | 6105 | g11347 | i0 | 51.2 | 0.394495412844037 | 43 | 20 | 38.5 | 1 | 8 | 133 | 501 | 543 | XP_031575079.1 pikachurin-like [Actinia tenebrosa] | diamond | 129 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29465625 | 29465625 | PRJNA1002816_P_NODE_19350_length_245_cov_1.790698_g19190_i0 | PRJNA1002816 | 19350 | 245 | 1.790698 | 4.3872101 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 89.4 | 3.46e-20 | NR | KAF1742831.1 | 59785 | g19190 | i0 | 62 | 0.96734693877551 | 79 | 30 | 96.7 | 0 | 238 | 2 | 25 | 103 | KAF1742831.1 hypothetical protein MXB_2240 [Myxobolus squamalis] | diamond | 237 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 29497561 | 29497561 | PRJNA1002816_P_NODE_12590_length_312_cov_0.966527_g12430_i0 | PRJNA1002816 | 12590 | 312 | 0.966527 | 3.01556424 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 57.8 | 3.75e-7 | NR | KAF0991847.1 | 69463 | g12430 | i0 | 28.6 | 0.942307692307692 | 98 | 70 | 94.2 | 0 | 4 | 297 | 54 | 151 | KAF0991847.1 LOW QUALITY PROTEIN: hypothetical protein HZS_6379 [Henneguya salminicola] | diamond | 294 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 29591935 | 29591935 | PRJNA1002816_P_NODE_20270_length_243_cov_0.905882_g20110_i0 | PRJNA1002816 | 20270 | 243 | 0.905882 | 2.20129326 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 52 | 1.49e-5 | NR | KAF0988209.1 | 69463 | g20110 | i0 | 36.1 | 0.888888888888889 | 72 | 37 | 88.9 | 1 | 232 | 17 | 89 | 151 | KAF0988209.1 hypothetical protein HZS_7049 [Henneguya salminicola] | diamond | 216 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 29655050 | 29655050 | PRJNA1002816_P_NODE_18970_length_247_cov_0.885057_g18810_i0 | PRJNA1002816 | 18970 | 247 | 0.885057 | 2.18609079 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 58.9 | 6.03e-8 | NR | KAF0987188.1 | 69463 | g18810 | i0 | 42.9 | 0.765182186234818 | 63 | 36 | 76.5 | 0 | 191 | 3 | 164 | 226 | KAF0987188.1 hypothetical protein HZS_2428, partial [Henneguya salminicola] | diamond | 189 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 29908253 | 29908253 | PRJNA1002816_P_NODE_5911_length_467_cov_1.114213_g5751_i0 | PRJNA1002816 | 5911 | 467 | 1.114213 | 5.20337471 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 58.5 | 1.15e-6 | NR | XP_068689828.1 | 591990 | g5751 | i0 | 27.8 | 1.94646680942184 | 108 | 70 | 64.9 | 3 | 467 | 165 | 467 | 573 | XP_068689828.1 transmembrane protease serine 9-like [Montipora foliosa] | diamond | 909 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 30192342 | 30192342 | PRJNA1002816_P_NODE_14952_length_281_cov_1.480769_g14792_i0 | PRJNA1002816 | 14952 | 281 | 1.480769 | 4.16096089 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 83.2 | 2.85e-18 | NR | XP_065056435.1 | 499914 | g14792 | i0 | 73.6 | 0.565836298932384 | 53 | 14 | 56.6 | 0 | 161 | 3 | 5 | 57 | XP_065056435.1 large ribosomal subunit protein eL33-like [Rhopilema esculentum] | diamond | 159 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 30753734 | 30753734 | PRJNA1002816_P_NODE_10494_length_344_cov_1.472325_g10334_i0 | PRJNA1002816 | 10494 | 344 | 1.472325 | 5.064798 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 224 | 1.56e-66 | NR | XP_065666900.1 | 6087 | g10334 | i0 | 93.8 | 145.002906976744 | 113 | 7 | 98.5 | 0 | 339 | 1 | 540 | 652 | XP_065666900.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3B isoform X2 [Hydra vulgaris] | diamond | 49881 | 225 | 0.995555555555556 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30848537 | 30848537 | PRJNA1002816_P_NODE_5954_length_465_cov_1.431122_g5794_i0 | PRJNA1002816 | 5954 | 465 | 1.431122 | 6.6547173 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 65.9 | 1.99e-10 | NR | XP_031572029.1 | 6105 | g5794 | i0 | 56.1 | 4.64516129032258 | 57 | 25 | 36.8 | 0 | 293 | 463 | 54 | 110 | XP_031572029.1 keratinocyte-associated protein 2-like [Actinia tenebrosa] | diamond | 2160 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30855905 | 30855905 | PRJNA1002816_P_NODE_20274_length_243_cov_0.905882_g20114_i0 | PRJNA1002816 | 20274 | 243 | 0.905882 | 2.20129326 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 119 | 4.26e-32 | NR | KII72468.1 | 669202 | g20114 | i0 | 66.2 | 0.950617283950617 | 77 | 26 | 95.1 | 0 | 233 | 3 | 1 | 77 | KII72468.1 60S ribosomal protein L17 [Thelohanellus kitauei] | diamond | 231 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 31741032 | 31741032 | PRJNA1002816_P_NODE_16277_length_265_cov_1.546875_g16117_i0 | PRJNA1002816 | 16277 | 265 | 1.546875 | 4.09921875 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 77.8 | 2.33e-14 | NR | KAF0990824.1 | 69463 | g16117 | i0 | 52.9 | 0.962264150943396 | 85 | 39 | 96.2 | 1 | 264 | 10 | 846 | 929 | KAF0990824.1 hypothetical protein HZS_6693, partial [Henneguya salminicola] | diamond | 255 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31741034 | 31741034 | PRJNA1002816_P_NODE_16917_length_257_cov_2.146739_g16757_i0 | PRJNA1002816 | 16917 | 257 | 2.146739 | 5.51711923 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 52 | 2.34e-5 | NR | KII63683.1 | 669202 | g16757 | i0 | 58.5 | 0.478599221789883 | 41 | 17 | 47.9 | 0 | 255 | 133 | 202 | 242 | KII63683.1 Sugar phosphate exchanger 2 [Thelohanellus kitauei] | diamond | 123 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 31923481 | 31923481 | PRJNA1002816_P_NODE_18857_length_247_cov_0.885057_g18697_i0 | PRJNA1002816 | 18857 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 43.5 | 0.0195 | NR | XP_065672199.1 | 6087 | g18697 | i0 | 70.4 | 10.9311740890688 | 27 | 8 | 32.8 | 0 | 83 | 3 | 277 | 303 | XP_065672199.1 zinc finger MYM-type protein 1-like [Hydra vulgaris] | diamond | 2700 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31994281 | 31994281 | PRJNA1002816_P_NODE_13338_length_302_cov_1.008734_g13178_i0 | PRJNA1002816 | 13338 | 302 | 1.008734 | 3.04637668 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 128 | 2.48e-34 | NR | KAF1745360.1 | 59785 | g13178 | i0 | 58.6 | 0.983443708609272 | 99 | 41 | 98.3 | 0 | 300 | 4 | 78 | 176 | KAF1745360.1 hypothetical protein MXB_4621 [Myxobolus squamalis] | diamond | 297 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 32500745 | 32500745 | PRJNA1002816_P_NODE_17579_length_251_cov_0.865169_g17419_i0 | PRJNA1002816 | 17579 | 251 | 0.865169 | 2.17157419 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 84.7 | 8.72e-18 | NR | KAF1745320.1 | 59785 | g17419 | i0 | 52.6 | 0.932270916334661 | 78 | 29 | 83.7 | 1 | 24 | 233 | 1 | 78 | KAF1745320.1 hypothetical protein MXB_4403, partial [Myxobolus squamalis] | diamond | 234 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis |
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);;