contig_metadata
24 rows where bioproject = "PRJNA278119", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371290 | 371290 | PRJNA278119_P_NODE_31241_length_177_cov_1.625000_g30992_i0 | PRJNA278119 | 31241 | 177 | 1.625 | 2.87625 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.4 | 3.59e-25 | NR | KAF1741798.1 | 59785 | g30992 | i0 | 86.4 | 2 | 59 | 8 | 100 | 0 | 177 | 1 | 14 | 72 | KAF1741798.1 hypothetical protein MXB_1522, partial [Myxobolus squamalis] | diamond | 354 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 1646397 | 1646397 | PRJNA278119_P_NODE_9302_length_385_cov_2.282738_g9055_i0 | PRJNA278119 | 9302 | 385 | 2.282738 | 8.7885413 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|2729081272|ref|XM_065203100.1| | 499914 | g9055 | i0 | 100 | 0.0753246753246753 | 29 | 0 | 8 | 0 | 71 | 99 | 887 | 859 | PREDICTED: Rhopilema esculentum putative nuclease HARBI1 (LOC135686772), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 4198694 | 4198694 | PRJNA278119_P_NODE_7964_length_420_cov_6.854447_g7717_i0 | PRJNA278119 | 7964 | 420 | 6.854447 | 28.7886774 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 2.42e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g7717 | i0 | 100 | 1.58571428571429 | 32 | 0 | 8 | 0 | 267 | 298 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 8024333 | 8024333 | PRJNA278119_P_NODE_11307_length_344_cov_1.057627_g11060_i0 | PRJNA278119 | 11307 | 344 | 1.057627 | 3.63823688 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 125 | 2.63e-31 | NR | ADR10432.1 | 35630 | g11060 | i0 | 79.3 | 4.29941860465116 | 82 | 17 | 71.5 | 0 | 1 | 246 | 384 | 465 | ADR10432.1 elongation factor 1 alpha [Hydractinia echinata] | diamond | 1479 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia echinata | |
| 8024531 | 8024531 | PRJNA278119_P_NODE_24647_length_199_cov_1.300000_g24398_i0 | PRJNA278119 | 24647 | 199 | 1.3 | 2.587 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 107 | 4.69e-25 | NR | XP_065646874.1 | 6087 | g24398 | i0 | 68.8 | 9.66331658291457 | 64 | 20 | 96.5 | 0 | 6 | 197 | 456 | 519 | XP_065646874.1 valine--tRNA ligase isoform X4 [Hydra vulgaris] | diamond | 1923 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 9299087 | 9299087 | PRJNA278119_P_NODE_10648_length_356_cov_2.185668_g10401_i0 | PRJNA278119 | 10648 | 356 | 2.185668 | 7.78097808 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.8 | 0.034 | NTclustered | gi|1176100932|ref|XM_020765523.1| | 48498 | g10401 | i0 | 100 | 0.0786516853932584 | 28 | 0 | 8 | 0 | 220 | 247 | 94 | 67 | PREDICTED: Orbicella faveolata 26S proteasome complex subunit SEM1-like (LOC110058861), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 22047895 | 22047895 | PRJNA278119_P_NODE_39618_length_166_cov_1.324786_g39369_i0 | PRJNA278119 | 39618 | 166 | 1.324786 | 2.19914476 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 79.3 | 1.6e-15 | NR | XP_057295029.1 | 13093 | g39369 | i0 | 72.2 | 1.95180722891566 | 54 | 15 | 97.6 | 0 | 164 | 3 | 41 | 94 | XP_057295029.1 sarcoplasmic/endoplasmic reticulum calcium ATPase 1-like [Hydractinia symbiolongicarpus] | diamond | 324 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 23323370 | 23323370 | PRJNA278119_P_NODE_34299_length_169_cov_2.141667_g34050_i0 | PRJNA278119 | 34299 | 169 | 2.141667 | 3.61941723 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 73.1 | 1.08e-8 | NTclustered | gi|2202637102|ref|XM_046993911.1| | 2897299 | g34050 | i0 | 83.333 | 1.67455621301775 | 78 | 13 | 46 | 0 | 89 | 166 | 655 | 578 | PREDICTED: Xenia sp. Carnegie-2017 ras-related protein ORAB-1-like (LOC124443420), mRNA | blastn | 283 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 23323620 | 23323620 | PRJNA278119_P_NODE_8639_length_402_cov_1.801700_g8392_i0 | PRJNA278119 | 8639 | 402 | 1.8017 | 7.242834 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 185 | 1.66e-51 | NR | XP_027043019.1 | 46731 | g8392 | i0 | 76.2 | 59.7388059701493 | 122 | 28 | 90.3 | 1 | 363 | 1 | 1 | 122 | XP_027043019.1 elongation factor 2-like [Pocillopora damicornis] | diamond | 24015 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 26933578 | 26933578 | PRJNA278119_P_NODE_16282_length_262_cov_1.995305_g16033_i0 | PRJNA278119 | 16282 | 262 | 1.995305 | 5.2276991 | Porites | 46719 | Cnidaria | other_Eukaryota | 44.3 | 0.0129 | NR | CAH3015529.1 | 104178 | g16033 | i0 | 45.3 | 1.69465648854962 | 53 | 28 | 60.7 | 1 | 36 | 194 | 230 | 281 | CAH3015529.1 unnamed protein product, partial [Porites evermanni] | diamond | 444 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 27358719 | 27358719 | PRJNA278119_P_NODE_23503_length_204_cov_1.032258_g23254_i0 | PRJNA278119 | 23503 | 204 | 1.032258 | 2.10580632 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 42.4 | 0.0324 | NR | XP_028395127.1 | 151771 | g23254 | i0 | 38.6 | 0.838235294117647 | 57 | 35 | 83.8 | 0 | 177 | 7 | 952 | 1008 | XP_028395127.1 uncharacterized protein LOC114519232 isoform X2 [Dendronephthya gigantea] | diamond | 171 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27642955 | 27642955 | PRJNA278119_P_NODE_30064_length_181_cov_0.977273_g29815_i0 | PRJNA278119 | 30064 | 181 | 0.977273 | 1.76886413 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 50.4 | 3.54e-6 | NR | XP_031564870.1 | 6105 | g29815 | i0 | 58.8 | 0.56353591160221 | 34 | 14 | 56.4 | 0 | 79 | 180 | 8 | 41 | XP_031564870.1 cytochrome B5-like protein [Actinia tenebrosa] | diamond | 102 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27895226 | 27895226 | PRJNA278119_P_NODE_24645_length_199_cov_1.306667_g24396_i0 | PRJNA278119 | 24645 | 199 | 1.306667 | 2.60026733 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 48.1 | 2.5e-4 | NR | CAB3977173.1 | 317549 | g24396 | i0 | 52.6 | 0.57286432160804 | 38 | 18 | 57.3 | 0 | 197 | 84 | 288 | 325 | CAB3977173.1 uncharacterized MFS-type transporter isoform X2 [Paramuricea clavata] | diamond | 114 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27976114 | 27976114 | PRJNA278119_P_NODE_6825_length_456_cov_1.936118_g6578_i0 | PRJNA278119 | 6825 | 456 | 1.936118 | 8.82869808 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 3.7e-29 | NR | XP_031554712.1 | 6105 | g6578 | i0 | 55.1 | 10.4144736842105 | 98 | 44 | 64.5 | 0 | 294 | 1 | 49 | 146 | XP_031554712.1 GTP-binding protein ypt1-like [Actinia tenebrosa] | diamond | 4749 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28400537 | 28400537 | PRJNA278119_P_NODE_22286_length_210_cov_0.968944_g22037_i0 | PRJNA278119 | 22286 | 210 | 0.968944 | 2.0347824 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 102 | 1.16e-23 | NR | XP_027039344.1 | 46731 | g22037 | i0 | 68.5 | 5.21428571428571 | 73 | 20 | 100 | 1 | 210 | 1 | 39 | 111 | XP_027039344.1 3-phosphoinositide-dependent protein kinase 1-like, partial [Pocillopora damicornis] | diamond | 1095 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28621660 | 28621660 | PRJNA278119_P_NODE_18427_length_237_cov_1.632979_g18178_i0 | PRJNA278119 | 18427 | 237 | 1.632979 | 3.87016023 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 42.4 | 0.0462 | NR | XP_058948997.2 | 203993 | g18178 | i0 | 32.8 | 0.848101265822785 | 67 | 44 | 84.8 | 1 | 229 | 29 | 436 | 501 | XP_058948997.2 E3 ubiquitin-protein ligase TRIM71-like [Pocillopora verrucosa] | diamond | 201 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 28796899 | 28796899 | PRJNA278119_P_NODE_3247_length_674_cov_3.633600_g3012_i0 | PRJNA278119 | 3247 | 674 | 3.6336 | 24.490464 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 176 | 5.27e-49 | NR | PFX18144.1 | 50429 | g3012 | i0 | 66.9 | 9.64985163204748 | 127 | 42 | 56.5 | 0 | 136 | 516 | 331 | 457 | PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] | diamond | 6504 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28905483 | 28905483 | PRJNA278119_P_NODE_31708_length_176_cov_1.259843_g31459_i0 | PRJNA278119 | 31708 | 176 | 1.259843 | 2.21732368 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 73.2 | 1.74e-13 | NR | CAB4034507.1 | 317549 | g31459 | i0 | 52.6 | 0.971590909090909 | 57 | 27 | 97.2 | 0 | 173 | 3 | 227 | 283 | CAB4034507.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 171 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29979290 | 29979290 | PRJNA278119_P_NODE_16071_length_265_cov_1.203704_g15822_i0 | PRJNA278119 | 16071 | 265 | 1.203704 | 3.1898156 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 132 | 2.64e-35 | NR | XP_001633281.1 | 45351 | g15822 | i0 | 72.8 | 2.02641509433962 | 92 | 21 | 99.6 | 1 | 1 | 264 | 193 | 284 | XP_001633281.1 malate dehydrogenase, cytoplasmic [Nematostella vectensis] | diamond | 537 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30073944 | 30073944 | PRJNA278119_P_NODE_30812_length_179_cov_0.869231_g30563_i0 | PRJNA278119 | 30812 | 179 | 0.869231 | 1.55592349 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 107 | 1.28e-25 | NR | XP_027058921.1 | 46731 | g30563 | i0 | 76.3 | 0.988826815642458 | 59 | 14 | 98.9 | 0 | 1 | 177 | 247 | 305 | XP_027058921.1 dipeptidyl peptidase 1-like [Pocillopora damicornis] | diamond | 177 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31071371 | 31071371 | PRJNA278119_P_NODE_235_length_1921_cov_5.008547_g180_i0 | PRJNA278119 | 235 | 1921 | 5.008547 | 96.21418787 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 256 | 2.2e-69 | NR | XP_065668839.1 | 6087 | g180 | i0 | 28.7 | 3.7339927121291 | 600 | 381 | 92.8 | 14 | 1810 | 29 | 481 | 1039 | XP_065668839.1 uncharacterized protein LOC100208544 isoform X8 [Hydra vulgaris] | diamond | 7173 | 258 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31085163 | 31085163 | PRJNA278119_P_NODE_32455_length_174_cov_1.248000_g32206_i0 | PRJNA278119 | 32455 | 174 | 1.248 | 2.17152 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 42 | 0.0225 | NR | CAH3197546.1 | 104178 | g32206 | i0 | 42.9 | 0.724137931034483 | 42 | 20 | 65.5 | 1 | 120 | 7 | 69 | 110 | CAH3197546.1 unnamed protein product [Porites evermanni] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 31812491 | 31812491 | PRJNA278119_P_NODE_43117_length_164_cov_1.078261_g42868_i0 | PRJNA278119 | 43117 | 164 | 1.078261 | 1.76834804 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 59.3 | 1.6e-8 | NR | XP_057309343.1 | 13093 | g42868 | i0 | 63.6 | 6.07317073170732 | 44 | 16 | 80.5 | 0 | 133 | 2 | 71 | 114 | XP_057309343.1 60S acidic ribosomal protein P0-like [Hydractinia symbiolongicarpus] | diamond | 996 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31843965 | 31843965 | PRJNA278119_P_NODE_14857_length_282_cov_1.437768_g14608_i0 | PRJNA278119 | 14857 | 282 | 1.437768 | 4.05450576 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 50.8 | 7.83e-5 | NR | XP_022802777.1 | 50429 | g14608 | i0 | 42.9 | 1.63829787234043 | 77 | 40 | 79.8 | 3 | 226 | 2 | 72 | 146 | XP_022802777.1 cathepsin B-like cysteine proteinase 4 [Stylophora pistillata] | diamond | 462 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;