contig_metadata
21 rows where bioproject = "PRJNA685607", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942224 | 1942224 | PRJNA685607_P_NODE_15162_length_417_cov_0.895349_g14804_i0 | PRJNA685607 | 15162 | 417 | 0.895349 | 3.73360533 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 172 | 2.1199999999999998e-48 | NR | XP_027043473.1 | 46731 | g14804 | i0 | 58.2 | 3.86330935251799 | 134 | 56 | 96.4 | 0 | 9 | 410 | 24 | 157 | XP_027043473.1 protein disulfide-isomerase 2-like [Pocillopora damicornis] | diamond | 1611 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 3727894 | 3727894 | PRJNA685607_P_NODE_10963_length_475_cov_1.034826_g10607_i0 | PRJNA685607 | 10963 | 475 | 1.034826 | 4.9154235 | root | 1 | Root_unresolved | Root_unresolved | 222 | 3.66e-66 | NR | XP_031560481.1 | 6105 | g10607 | i0 | 69.6 | 151.117894736842 | 158 | 48 | 99.8 | 0 | 474 | 1 | 176 | 333 | XP_031560481.1 stress-70 protein, mitochondrial-like [Actinia tenebrosa] | diamond | 71781 | 224 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 13420229 | 13420229 | PRJNA685607_P_NODE_25151_length_348_cov_2.574545_g24792_i0 | PRJNA685607 | 25151 | 348 | 2.574545 | 8.9594166 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 228 | 5.0999999999999985e-55 | NTclustered | gi|2782899435|ref|XM_067068137.1| | 252671 | g24792 | i0 | 88.021 | 86.2672413793103 | 192 | 23 | 65 | 0 | 1 | 192 | 350 | 541 | PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA | blastn | 30021 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 17244204 | 17244204 | PRJNA685607_P_NODE_13894_length_431_cov_1.229050_g13536_i0 | PRJNA685607 | 13894 | 431 | 1.22905 | 5.2972055 | root | 1 | Root_unresolved | Root_unresolved | 212 | 5.69e-67 | NR | XP_031575254.1 | 6105 | g13536 | i0 | 73.3 | 58.5939675174014 | 131 | 35 | 91.2 | 0 | 36 | 428 | 1 | 131 | XP_031575254.1 60S ribosomal protein L10-like [Actinia tenebrosa] | diamond | 25254 | 214 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 17753921 | 17753921 | PRJNA685607_P_NODE_11874_length_460_cov_1.056848_g11517_i0 | PRJNA685607 | 11874 | 460 | 1.056848 | 4.8615008 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 162 | 7.22e-46 | NR | XP_066934560.1 | 252671 | g11517 | i0 | 53 | 3.87391304347826 | 149 | 59 | 95.2 | 3 | 440 | 3 | 2 | 142 | XP_066934560.1 COP9 signalosome complex subunit 5-like [Clytia hemisphaerica] | diamond | 1782 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 21578564 | 21578564 | PRJNA685607_P_NODE_48837_length_280_cov_2.217391_g48478_i0 | PRJNA685607 | 48837 | 280 | 2.217391 | 6.2086948 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.2 | 2.13e-11 | NR | XP_020602859.1 | 48498 | g48478 | i0 | 40.2 | 6.27857142857143 | 92 | 44 | 88.9 | 3 | 26 | 274 | 130 | 219 | XP_020602859.1 gamma-interferon-inducible lysosomal thiol reductase-like [Orbicella faveolata] | diamond | 1758 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 26670435 | 26670435 | PRJNA685607_P_NODE_87621_length_244_cov_0.900585_g87262_i0 | PRJNA685607 | 87621 | 244 | 0.900585 | 2.1974274 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 43.9 | 0.0153 | NR | KXJ11189.1 | 2652724 | g87262 | i0 | 34.6 | 3.75 | 78 | 50 | 95.9 | 1 | 234 | 1 | 148 | 224 | KXJ11189.1 Sentrin-specific protease 2 [Exaiptasia diaphana] | diamond | 915 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26955518 | 26955518 | PRJNA685607_P_NODE_79702_length_246_cov_0.890173_g79343_i0 | PRJNA685607 | 79702 | 246 | 0.890173 | 2.18982558 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 100 | 1.4000000000000002e-23 | NR | KAF1741254.1 | 59785 | g79343 | i0 | 62.7 | 2.81707317073171 | 75 | 28 | 91.5 | 0 | 226 | 2 | 156 | 230 | KAF1741254.1 hypothetical protein MXB_511, partial [Myxobolus squamalis] | diamond | 693 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 27662628 | 27662628 | PRJNA685607_P_NODE_77064_length_247_cov_0.885057_g76705_i0 | PRJNA685607 | 77064 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 1.01e-26 | NR | WBU87331.1 | 51769 | g76705 | i0 | 58 | 4.93117408906883 | 81 | 32 | 98.4 | 1 | 1 | 243 | 34 | 112 | WBU87331.1 glutathione reductase, partial [Anemonia viridis] | diamond | 1218 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia viridis | |
| 27745846 | 27745846 | PRJNA685607_P_NODE_88224_length_243_cov_1.358824_g87865_i0 | PRJNA685607 | 88224 | 243 | 1.358824 | 3.30194232 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 87.8 | 7.32e-19 | NR | XP_001639308.1 | 45351 | g87865 | i0 | 55 | 0.987654320987654 | 80 | 36 | 98.8 | 0 | 2 | 241 | 178 | 257 | XP_001639308.1 60S ribosomal protein L7a [Nematostella vectensis] | diamond | 240 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28230531 | 28230531 | PRJNA685607_P_NODE_45086_length_288_cov_1.358140_g44727_i0 | PRJNA685607 | 45086 | 288 | 1.35814 | 3.9114432 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 127 | 4.42e-35 | NR | RMX60987.1 | 46731 | g44727 | i0 | 66.7 | 84.9479166666667 | 96 | 32 | 100 | 0 | 1 | 288 | 32 | 127 | RMX60987.1 hypothetical protein pdam_00014180, partial [Pocillopora damicornis] | diamond | 24465 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28724445 | 28724445 | PRJNA685607_P_NODE_77407_length_247_cov_0.885057_g77048_i0 | PRJNA685607 | 77407 | 247 | 0.885057 | 2.18609079 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 63.9 | 1.33e-9 | NR | XP_066916646.1 | 252671 | g77048 | i0 | 36.8 | 0.825910931174089 | 68 | 42 | 81.4 | 1 | 47 | 247 | 51 | 118 | XP_066916646.1 E3 ubiquitin-protein ligase arih1-like [Clytia hemisphaerica] | diamond | 204 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 29209705 | 29209705 | PRJNA685607_P_NODE_21629_length_366_cov_2.529010_g21270_i0 | PRJNA685607 | 21629 | 366 | 2.52901 | 9.2561766 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 177 | 2.0599999999999998e-54 | NR | XP_028410526.1 | 151771 | g21270 | i0 | 69.9 | 8.07377049180328 | 123 | 35 | 99.2 | 1 | 4 | 366 | 9 | 131 | XP_028410526.1 60S ribosomal protein L27a-like [Dendronephthya gigantea] | diamond | 2955 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30757336 | 30757336 | PRJNA685607_P_NODE_18234_length_389_cov_1.234177_g17876_i0 | PRJNA685607 | 18234 | 389 | 1.234177 | 4.80094853 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 99.8 | 1.53e-23 | NR | KAF0988714.1 | 69463 | g17876 | i0 | 50.5 | 1.53470437017995 | 99 | 49 | 76.3 | 0 | 46 | 342 | 21 | 119 | KAF0988714.1 hypothetical protein HZS_4947, partial [Henneguya salminicola] | diamond | 597 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31536183 | 31536183 | PRJNA685607_P_NODE_70096_length_249_cov_1.522727_g69737_i0 | PRJNA685607 | 70096 | 249 | 1.522727 | 3.79159023 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 98.2 | 1.24e-21 | NR | XP_048582040.1 | 45351 | g69737 | i0 | 54.5 | 2.78313253012048 | 77 | 35 | 92.8 | 0 | 18 | 248 | 647 | 723 | XP_048582040.1 WASH complex subunit 4 [Nematostella vectensis] | diamond | 693 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32042140 | 32042140 | PRJNA685607_P_NODE_19918_length_377_cov_1.013158_g19560_i0 | PRJNA685607 | 19918 | 377 | 1.013158 | 3.81960566 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 191 | 4.2799999999999997e-60 | NR | XP_065065749.1 | 499914 | g19560 | i0 | 76.7 | 4.61538461538461 | 116 | 27 | 92.3 | 0 | 28 | 375 | 1 | 116 | XP_065065749.1 small ribosomal subunit protein uS8 [Rhopilema esculentum] | diamond | 1740 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 32358800 | 32358800 | PRJNA685607_P_NODE_78419_length_247_cov_0.885057_g78060_i0 | PRJNA685607 | 78419 | 247 | 0.885057 | 2.18609079 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 68.9 | 4.2e-12 | NR | CAH3169612.1 | 104759 | g78060 | i0 | 51.4 | 1.74898785425101 | 72 | 34 | 86.2 | 1 | 243 | 31 | 12 | 83 | CAH3169612.1 unnamed protein product [Porites lobata] | diamond | 432 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32358801 | 32358801 | PRJNA685607_P_NODE_87039_length_244_cov_0.900585_g86680_i0 | PRJNA685607 | 87039 | 244 | 0.900585 | 2.1974274 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 50.8 | 5.39e-5 | NR | XP_020895539.1 | 2652724 | g86680 | i0 | 47.1 | 0.627049180327869 | 51 | 26 | 62.7 | 1 | 1 | 153 | 416 | 465 | XP_020895539.1 LOW QUALITY PROTEIN: major vault protein-like [Exaiptasia diaphana] | diamond | 153 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 32485256 | 32485256 | PRJNA685607_P_NODE_35519_length_312_cov_1.991632_g35160_i0 | PRJNA685607 | 35519 | 312 | 1.991632 | 6.21389184 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 70.9 | 2.53e-12 | NR | XP_020611657.1 | 48498 | g35160 | i0 | 54.5 | 2.59615384615385 | 55 | 25 | 52.9 | 0 | 12 | 176 | 139 | 193 | XP_020611657.1 cysteine-rich protein 2-like [Orbicella faveolata] | diamond | 810 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32560234 | 32560234 | PRJNA685607_P_NODE_97259_length_239_cov_3.301205_g96900_i0 | PRJNA685607 | 97259 | 239 | 3.301205 | 7.88987995 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 86.7 | 2.08e-19 | NR | XP_065656335.1 | 6087 | g96900 | i0 | 71.7 | 6.84100418410042 | 60 | 17 | 75.3 | 0 | 200 | 21 | 28 | 87 | XP_065656335.1 small ribosomal subunit protein eS26 isoform X2 [Hydra vulgaris] | diamond | 1635 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32843248 | 32843248 | PRJNA685607_P_NODE_48460_length_281_cov_1.471154_g48101_i0 | PRJNA685607 | 48460 | 281 | 1.471154 | 4.13394274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 77.8 | 2.81e-14 | NR | XP_068758773.1 | 246305 | g48101 | i0 | 51.9 | 3.4270462633452 | 79 | 37 | 84.3 | 1 | 238 | 2 | 100 | 177 | XP_068758773.1 exportin-T-like [Montipora capricornis] | diamond | 963 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis |
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);;