contig_metadata
17 rows where bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2219965 | 2219965 | PRJNA971676_P_NODE_17862_length_247_cov_0.885057_g17773_i0 | PRJNA971676 | 17862 | 247 | 0.885057 | 2.18609079 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 118 | 1.92e-29 | NR | EDO48974.1 | 45351 | g17773 | i0 | 69.5 | 13.9433198380567 | 82 | 25 | 99.6 | 0 | 246 | 1 | 17 | 98 | EDO48974.1 predicted protein, partial [Nematostella vectensis] | diamond | 3444 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 6370559 | 6370559 | PRJNA971676_P_NODE_2745_length_469_cov_1.166667_g2656_i0 | PRJNA971676 | 2745 | 469 | 1.166667 | 5.47166823 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 6.58e-67 | NR | CAH3194281.1 | 104178 | g2656 | i0 | 65.1 | 38.6545842217484 | 152 | 52 | 97.2 | 1 | 1 | 456 | 30 | 180 | CAH3194281.1 unnamed protein product, partial [Porites evermanni] | diamond | 18129 | 212 | 0.995283018867924 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 14972492 | 14972492 | PRJNA971676_P_NODE_15512_length_249_cov_3.113636_g15423_i0 | PRJNA971676 | 15512 | 249 | 3.113636 | 7.75295364 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 134 | 7.82e-27 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g15423 | i0 | 86.777 | 50.3775100401606 | 121 | 14 | 49 | 2 | 1 | 121 | 351 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12544 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 25170863 | 25170863 | PRJNA971676_P_NODE_3060_length_448_cov_2.362667_g2971_i0 | PRJNA971676 | 3060 | 448 | 2.362667 | 10.58474816 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 196 | 1.19e-58 | NR | XP_066919708.1 | 252671 | g2971 | i0 | 70.8 | 5.49776785714286 | 137 | 40 | 91.7 | 0 | 413 | 3 | 1 | 137 | XP_066919708.1 large ribosomal subunit protein uL4B-like [Clytia hemisphaerica] | diamond | 2463 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 27348514 | 27348514 | PRJNA971676_P_NODE_18543_length_246_cov_0.890173_g18454_i0 | PRJNA971676 | 18543 | 246 | 0.890173 | 2.18982558 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 49.3 | 1.88e-4 | NR | XP_031570089.1 | 6105 | g18454 | i0 | 42.1 | 2.09756097560976 | 57 | 31 | 67.1 | 1 | 225 | 61 | 254 | 310 | XP_031570089.1 protein CLP1 homolog [Actinia tenebrosa] | diamond | 516 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27373947 | 27373947 | PRJNA971676_P_NODE_22963_length_241_cov_0.916667_g22874_i0 | PRJNA971676 | 22963 | 241 | 0.916667 | 2.20916747 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 80.5 | 1.86e-15 | NR | XP_015778081.1 | 70779 | g22874 | i0 | 48.8 | 1.99170124481328 | 80 | 40 | 98.3 | 1 | 237 | 1 | 499 | 578 | XP_015778081.1 PREDICTED: uncharacterized protein LOC107355977 isoform X2 [Acropora digitifera] | diamond | 480 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27537890 | 27537890 | PRJNA971676_P_NODE_14743_length_250_cov_0.870056_g14654_i0 | PRJNA971676 | 14743 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 120 | 8.95e-32 | NR | XP_029179839.1 | 45264 | g14654 | i0 | 61.4 | 31.872 | 83 | 32 | 99.6 | 0 | 250 | 2 | 81 | 163 | XP_029179839.1 ras-related protein Rab-38-like [Acropora millepora] | diamond | 7968 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29267898 | 29267898 | PRJNA971676_P_NODE_14569_length_251_cov_0.865169_g14480_i0 | PRJNA971676 | 14569 | 251 | 0.865169 | 2.17157419 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 68.9 | 5.74e-12 | NR | XP_047131876.1 | 6087 | g14480 | i0 | 58.9 | 1.48207171314741 | 56 | 22 | 66.9 | 1 | 203 | 36 | 89 | 143 | XP_047131876.1 uncharacterized protein LOC124810917 [Hydra vulgaris] | diamond | 372 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29463407 | 29463407 | PRJNA971676_P_NODE_12230_length_265_cov_1.572917_g12141_i0 | PRJNA971676 | 12230 | 265 | 1.572917 | 4.16823005 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 75.9 | 1.89e-14 | NR | XP_068744302.1 | 246305 | g12141 | i0 | 47.1 | 2.83018867924528 | 85 | 45 | 96.2 | 0 | 9 | 263 | 2 | 86 | XP_068744302.1 LOW QUALITY PROTEIN: V-type proton ATPase subunit E-like [Montipora capricornis] | diamond | 750 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 30720959 | 30720959 | PRJNA971676_P_NODE_11254_length_274_cov_1.552239_g11165_i0 | PRJNA971676 | 11254 | 274 | 1.552239 | 4.25313486 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 97.1 | 4.13e-21 | NR | XP_057301240.1 | 13093 | g11165 | i0 | 49.4 | 0.908759124087591 | 83 | 42 | 90.9 | 0 | 2 | 250 | 255 | 337 | XP_057301240.1 2',5'-phosphodiesterase 12-like [Hydractinia symbiolongicarpus] | diamond | 249 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31802044 | 31802044 | PRJNA971676_P_NODE_20057_length_245_cov_0.895349_g19968_i0 | PRJNA971676 | 20057 | 245 | 0.895349 | 2.19360505 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 47 | 0.00123 | NR | XP_001634379.2 | 45351 | g19968 | i0 | 37.7 | 3.96734693877551 | 69 | 41 | 84.5 | 1 | 2 | 208 | 409 | 475 | XP_001634379.2 extracellular calcium-sensing receptor [Nematostella vectensis] | diamond | 972 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31928723 | 31928723 | PRJNA971676_P_NODE_22317_length_242_cov_0.911243_g22228_i0 | PRJNA971676 | 22317 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 121 | 1.87e-30 | NR | XP_031552768.1 | 6105 | g22228 | i0 | 74.4 | 12.7685950413223 | 78 | 20 | 96.7 | 0 | 238 | 5 | 143 | 220 | XP_031552768.1 glutathione reductase, mitochondrial-like [Actinia tenebrosa] | diamond | 3090 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32017387 | 32017387 | PRJNA971676_P_NODE_14678_length_250_cov_1.305085_g14589_i0 | PRJNA971676 | 14678 | 250 | 1.305085 | 3.2627125 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 132 | 3.4e-37 | NR | EDO42040.1 | 45351 | g14589 | i0 | 73.5 | 8.772 | 83 | 22 | 99.6 | 0 | 250 | 2 | 53 | 135 | EDO42040.1 predicted protein [Nematostella vectensis] | diamond | 2193 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32118737 | 32118737 | PRJNA971676_P_NODE_16638_length_248_cov_0.880000_g16549_i0 | PRJNA971676 | 16638 | 248 | 0.88 | 2.1824 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 48.9 | 2.52e-4 | NR | XP_020609478.1 | 48498 | g16549 | i0 | 37 | 3.10887096774194 | 81 | 42 | 87.1 | 2 | 2 | 217 | 218 | 298 | XP_020609478.1 uncharacterized protein LOC110048052 isoform X1 [Orbicella faveolata] | diamond | 771 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32435348 | 32435348 | PRJNA971676_P_NODE_9419_length_293_cov_0.922727_g9330_i0 | PRJNA971676 | 9419 | 293 | 0.922727 | 2.70359011 | Acropora | 6127 | Cnidaria | other_Eukaryota | 44.7 | 0.0148 | NR | XP_044168355.1 | 45264 | g9330 | i0 | 48.8 | 1.2901023890785 | 43 | 20 | 44 | 1 | 134 | 6 | 17 | 57 | XP_044168355.1 myoferlin-like isoform X3 [Acropora millepora] | diamond | 378 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32498515 | 32498515 | PRJNA971676_P_NODE_20399_length_244_cov_0.900585_g20310_i0 | PRJNA971676 | 20399 | 244 | 0.900585 | 2.1974274 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 97.4 | 2.1e-21 | NR | XP_057312503.1 | 13093 | g20310 | i0 | 60.8 | 1.94262295081967 | 79 | 31 | 97.1 | 0 | 3 | 239 | 127 | 205 | XP_057312503.1 gelsolin, cytoplasmic-like [Hydractinia symbiolongicarpus] | diamond | 474 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32555639 | 32555639 | PRJNA971676_P_NODE_9779_length_288_cov_1.809302_g9690_i0 | PRJNA971676 | 9779 | 288 | 1.809302 | 5.21078976 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 73.2 | 1.07e-12 | NR | CAH3186858.1 | 104178 | g9690 | i0 | 41.6 | 2.77083333333333 | 89 | 50 | 92.7 | 2 | 274 | 8 | 235 | 321 | CAH3186858.1 unnamed protein product [Porites evermanni] | diamond | 798 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;