contig_metadata
18 rows where bioproject = "PRJNA1025141", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6107339 | 6107339 | PRJNA1025141_P_NODE_1885_length_600_cov_1.715370_g1825_i0 | PRJNA1025141 | 1885 | 600 | 1.71537 | 10.29222 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 211 | 1.78e-66 | NR | XP_031572794.1 | 6105 | g1825 | i0 | 74.5 | 19.505 | 141 | 36 | 70.5 | 0 | 582 | 160 | 20 | 160 | XP_031572794.1 40S ribosomal protein S16-like [Actinia tenebrosa] | diamond | 11703 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 6540875 | 6540875 | PRJNA1025141_P_NODE_1046_length_809_cov_4.330163_g996_i0 | PRJNA1025141 | 1046 | 809 | 4.330163 | 35.03101867 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 264 | 1.13e-84 | NR | XP_029185028.1 | 45264 | g996 | i0 | 58.7 | 18.0370828182942 | 230 | 93 | 85.3 | 1 | 695 | 6 | 33 | 260 | XP_029185028.1 60S ribosomal protein L7a-like [Acropora millepora] | diamond | 14592 | 264 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 9090409 | 9090409 | PRJNA1025141_P_NODE_5508_length_343_cov_0.925926_g5447_i0 | PRJNA1025141 | 5508 | 343 | 0.925926 | 3.17592618 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 151 | 6.73e-44 | NR | XP_057310049.1 | 13093 | g5447 | i0 | 81.6 | 6.62099125364431 | 76 | 14 | 66.5 | 0 | 9 | 236 | 109 | 184 | XP_057310049.1 cysteine-rich protein 2-like [Hydractinia symbiolongicarpus] | diamond | 2271 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 12916509 | 12916509 | PRJNA1025141_P_NODE_3171_length_459_cov_1.564767_g3110_i0 | PRJNA1025141 | 3171 | 459 | 1.564767 | 7.18228053 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 89.4 | 6.13e-19 | NR | CAH3197546.1 | 104178 | g3110 | i0 | 40.8 | 0.673202614379085 | 103 | 59 | 67.3 | 2 | 88 | 396 | 75 | 175 | CAH3197546.1 unnamed protein product [Porites evermanni] | diamond | 309 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 15465561 | 15465561 | PRJNA1025141_P_NODE_3373_length_445_cov_1.118280_g3312_i0 | PRJNA1025141 | 3373 | 445 | 1.11828 | 4.976346 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 112 | 1.97e-25 | NR | XP_065053426.1 | 499914 | g3312 | i0 | 52.7 | 5.19101123595506 | 112 | 53 | 75.5 | 0 | 1 | 336 | 510 | 621 | XP_065053426.1 heat shock cognate 71 kDa protein-like [Rhopilema esculentum] | diamond | 2310 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 16739740 | 16739740 | PRJNA1025141_P_NODE_3694_length_423_cov_1.334286_g3633_i0 | PRJNA1025141 | 3694 | 423 | 1.334286 | 5.64402978 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 195 | 2.99e-59 | NR | XP_020626502.1 | 48498 | g3633 | i0 | 65.2 | 6.8936170212766 | 138 | 48 | 97.9 | 0 | 1 | 414 | 39 | 176 | XP_020626502.1 ras-related C3 botulinum toxin substrate 1-like [Orbicella faveolata] | diamond | 2916 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 26686694 | 26686694 | PRJNA1025141_P_NODE_5881_length_331_cov_0.802326_g5820_i0 | PRJNA1025141 | 5881 | 331 | 0.802326 | 2.65569906 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 89.7 | 3.33e-18 | NR | XP_066925925.1 | 252671 | g5820 | i0 | 42.6 | 1.9214501510574 | 108 | 59 | 95.2 | 3 | 323 | 9 | 182 | 289 | XP_066925925.1 gelsolin, cytoplasmic-like [Clytia hemisphaerica] | diamond | 636 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 26774013 | 26774013 | PRJNA1025141_P_NODE_6881_length_304_cov_0.965368_g6820_i0 | PRJNA1025141 | 6881 | 304 | 0.965368 | 2.93471872 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 136 | 1.6999999999999996e-38 | NR | XP_020620004.1 | 48498 | g6820 | i0 | 69.3 | 2.99013157894737 | 101 | 31 | 99.7 | 0 | 303 | 1 | 22 | 122 | XP_020620004.1 60S ribosomal protein L17-like [Orbicella faveolata] | diamond | 909 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 26939934 | 26939934 | PRJNA1025141_P_NODE_9602_length_251_cov_0.865169_g9541_i0 | PRJNA1025141 | 9602 | 251 | 0.865169 | 2.17157419 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 58.9 | 8.49e-8 | NR | XP_048580138.1 | 45351 | g9541 | i0 | 54.9 | 7.50597609561753 | 51 | 22 | 59.8 | 1 | 243 | 94 | 14 | 64 | XP_048580138.1 uncharacterized protein LOC5520382 [Nematostella vectensis] | diamond | 1884 | 59.3 | 0.993254637436762 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 26971604 | 26971604 | PRJNA1025141_P_NODE_10042_length_249_cov_1.312500_g9981_i0 | PRJNA1025141 | 10042 | 249 | 1.3125 | 3.268125 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 79.7 | 3.41e-15 | NR | XP_031564393.1 | 6105 | g9981 | i0 | 50.6 | 0.927710843373494 | 77 | 36 | 92.8 | 1 | 233 | 3 | 145 | 219 | XP_031564393.1 counting factor 60-like [Actinia tenebrosa] | diamond | 231 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27192913 | 27192913 | PRJNA1025141_P_NODE_1782_length_619_cov_2.430403_g1722_i0 | PRJNA1025141 | 1782 | 619 | 2.430403 | 15.04419457 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 75.1 | 7.78e-14 | NR | KXJ22858.1 | 2652724 | g1722 | i0 | 75.5 | 0.867528271405493 | 49 | 12 | 23.7 | 0 | 31 | 177 | 47 | 95 | KXJ22858.1 Thymosin beta-12 [Exaiptasia diaphana] | diamond | 537 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27192918 | 27192918 | PRJNA1025141_P_NODE_5142_length_356_cov_1.420495_g5081_i0 | PRJNA1025141 | 5142 | 356 | 1.420495 | 5.0569622 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 59.3 | 2.28e-7 | NR | RMX60893.1 | 46731 | g5081 | i0 | 37.1 | 1.63483146067416 | 97 | 57 | 80.9 | 3 | 2 | 289 | 134 | 227 | RMX60893.1 hypothetical protein pdam_00003494 [Pocillopora damicornis] | diamond | 582 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28645785 | 28645785 | PRJNA1025141_P_NODE_10867_length_247_cov_0.885057_g10806_i0 | PRJNA1025141 | 10867 | 247 | 0.885057 | 2.18609079 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 53.9 | 3.97e-6 | NR | RMX45460.1 | 46731 | g10806 | i0 | 49 | 1.80971659919028 | 49 | 25 | 59.5 | 0 | 99 | 245 | 11 | 59 | RMX45460.1 hypothetical protein pdam_00023239 [Pocillopora damicornis] | diamond | 447 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28763988 | 28763988 | PRJNA1025141_P_NODE_2467_length_520_cov_3.691275_g2406_i0 | PRJNA1025141 | 2467 | 520 | 3.691275 | 19.19463 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 175 | 1.6e-52 | NR | XP_057307393.1 | 13093 | g2406 | i0 | 61.8 | 15.6576923076923 | 144 | 55 | 83.1 | 0 | 508 | 77 | 25 | 168 | XP_057307393.1 40S ribosomal protein S15-like [Hydractinia symbiolongicarpus] | diamond | 8142 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29237806 | 29237806 | PRJNA1025141_P_NODE_8849_length_261_cov_1.058511_g8788_i0 | PRJNA1025141 | 8849 | 261 | 1.058511 | 2.76271371 | root | 1 | Root_unresolved | Root_unresolved | 74.7 | 2.1e-13 | NR | XP_028407759.1 | 151771 | g8788 | i0 | 68.9 | 2.58620689655172 | 45 | 14 | 51.7 | 0 | 85 | 219 | 273 | 317 | XP_028407759.1 arginine kinase-like [Dendronephthya gigantea] | diamond | 675 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29553188 | 29553188 | PRJNA1025141_P_NODE_8830_length_261_cov_1.228723_g8769_i0 | PRJNA1025141 | 8830 | 261 | 1.228723 | 3.20696703 | Acropora | 6127 | Cnidaria | other_Eukaryota | 90.1 | 3.58e-19 | NR | KAK2573205.1 | 6130 | g8769 | i0 | 73.1 | 1.19540229885057 | 52 | 14 | 59.8 | 0 | 1 | 156 | 43 | 94 | KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] | diamond | 312 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30343633 | 30343633 | PRJNA1025141_P_NODE_2432_length_524_cov_0.949002_g2371_i0 | PRJNA1025141 | 2432 | 524 | 0.949002 | 4.97277048 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 280 | 1.4399999999999993e-87 | NR | PFX27191.1 | 50429 | g2371 | i0 | 94.4 | 41.1297709923664 | 143 | 8 | 81.9 | 0 | 96 | 524 | 481 | 623 | PFX27191.1 Ras-related protein Rab-1A [Stylophora pistillata] | diamond | 21552 | 281 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31520480 | 31520480 | PRJNA1025141_P_NODE_9036_length_257_cov_1.222826_g8975_i0 | PRJNA1025141 | 9036 | 257 | 1.222826 | 3.14266282 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 97.1 | 1.46e-22 | NR | KII73805.1 | 669202 | g8975 | i0 | 51.8 | 2.90661478599222 | 85 | 41 | 99.2 | 0 | 2 | 256 | 6 | 90 | KII73805.1 40S ribosomal protein S6 [Thelohanellus kitauei] | diamond | 747 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei |
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);;