contig_metadata
28 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3839696 | 3839696 | PRJEB10320_P_NODE_17284_length_213_cov_2.342697_g17026_i0 | PRJEB10320 | 17284 | 213 | 2.342697 | 4.98994461 | Halitholus cirratus | 1622219 | Cnidaria | other_Eukaryota | 115 | 2.36e-21 | NTclustered | gi|766544753|gb|KP113580.1| | 1622219 | g17026 | i0 | 75.385 | 46 | 195 | 43 | 90 | 5 | 1 | 191 | 8 | 201 | Halitholus cirratus isolate C histone H3 (H3) gene, partial cds | blastn | 9798 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Pandeidae | Halitholus | Halitholus cirratus | |
| 12461556 | 12461556 | PRJEB10320_P_NODE_13430_length_255_cov_1.518182_g13172_i0 | PRJEB10320 | 13430 | 255 | 1.518182 | 3.8713641 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1524871334|ref|XM_027187216.1| | 46731 | g13172 | i0 | 100 | 0.219607843137255 | 28 | 0 | 11 | 0 | 94 | 121 | 408 | 381 | PREDICTED: Pocillopora damicornis replication stress response regulator SDE2-like (LOC113671008), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 27279594 | 27279594 | PRJEB10320_P_NODE_16023_length_225_cov_1.131579_g15765_i0 | PRJEB10320 | 16023 | 225 | 1.131579 | 2.54605275 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 52.4 | 1.04e-5 | NR | XP_022782209.1 | 50429 | g15765 | i0 | 41.5 | 1.74666666666667 | 65 | 36 | 86.7 | 1 | 24 | 218 | 1 | 63 | XP_022782209.1 vacuolar protein sorting-associated protein VTA1 homolog [Stylophora pistillata] | diamond | 393 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27406118 | 27406118 | PRJEB10320_P_NODE_23183_length_173_cov_1.427536_g22925_i0 | PRJEB10320 | 23183 | 173 | 1.427536 | 2.46963728 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 83.6 | 3.16e-18 | NR | XP_068679419.1 | 591990 | g22925 | i0 | 78.9 | 4.94219653179191 | 57 | 12 | 98.8 | 0 | 172 | 2 | 72 | 128 | XP_068679419.1 small ribosomal subunit protein eS7-like [Montipora foliosa] | diamond | 855 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 27690435 | 27690435 | PRJEB10320_P_NODE_10864_length_294_cov_1.471042_g10606_i0 | PRJEB10320 | 10864 | 294 | 1.471042 | 4.32486348 | Acropora | 6127 | Cnidaria | other_Eukaryota | 57 | 2.54e-7 | NR | KAK2560801.1 | 6130 | g10606 | i0 | 54.9 | 1.47959183673469 | 51 | 22 | 51 | 1 | 288 | 139 | 19 | 69 | KAK2560801.1 Histone H1.0 [Acropora cervicornis] | diamond | 435 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 27728124 | 27728124 | PRJEB10320_P_NODE_304_length_1610_cov_4.099683_g64_i1 | PRJEB10320 | 304 | 1610 | 4.099683 | 66.0048963 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 451 | 3.19e-149 | NR | XP_065052198.1 | 499914 | g64 | i1 | 57.3 | 0.786335403726708 | 422 | 172 | 78.4 | 2 | 1 | 1263 | 187 | 601 | XP_065052198.1 uncharacterized protein LOC135681586 [Rhopilema esculentum] | diamond | 1266 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27759641 | 27759641 | PRJEB10320_P_NODE_20944_length_186_cov_2.086093_g20686_i0 | PRJEB10320 | 20944 | 186 | 2.086093 | 3.88013298 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 86.3 | 1.48e-19 | NR | XP_047129063.1 | 6087 | g20686 | i0 | 55.7 | 0.983870967741935 | 61 | 27 | 98.4 | 0 | 2 | 184 | 1 | 61 | XP_047129063.1 large ribosomal subunit protein eL24 isoform X1 [Hydra vulgaris] | diamond | 183 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27879505 | 27879505 | PRJEB10320_P_NODE_14865_length_237_cov_1.470297_g14607_i0 | PRJEB10320 | 14865 | 237 | 1.470297 | 3.48460389 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 1.5399999999999999e-34 | NR | XP_065685003.1 | 6087 | g14607 | i0 | 75.6 | 56.2278481012658 | 78 | 19 | 98.7 | 0 | 236 | 3 | 191 | 268 | XP_065685003.1 protein henna isoform X2 [Hydra vulgaris] | diamond | 13326 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28454099 | 28454099 | PRJEB10320_P_NODE_21986_length_180_cov_1.379310_g21728_i0 | PRJEB10320 | 21986 | 180 | 1.37931 | 2.482758 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 66.6 | 5.74e-11 | NR | CAH3018639.1 | 104178 | g21728 | i0 | 62.5 | 1.58333333333333 | 48 | 18 | 80 | 0 | 179 | 36 | 367 | 414 | CAH3018639.1 unnamed protein product, partial [Porites evermanni] | diamond | 285 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28574074 | 28574074 | PRJEB10320_P_NODE_10207_length_306_cov_1.461255_g9949_i0 | PRJEB10320 | 10207 | 306 | 1.461255 | 4.4714403 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 142 | 3.8e-39 | NR | XP_028411061.1 | 151771 | g9949 | i0 | 75 | 9.02941176470588 | 92 | 23 | 90.2 | 0 | 31 | 306 | 3 | 94 | XP_028411061.1 60S ribosomal protein L5-like [Dendronephthya gigantea] | diamond | 2763 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 28574078 | 28574078 | PRJEB10320_P_NODE_24527_length_166_cov_1.618321_g24269_i0 | PRJEB10320 | 24527 | 166 | 1.618321 | 2.68641286 | Hydrozoa | 6074 | Cnidaria | other_Eukaryota | 57.8 | 6.52e-8 | NR | XP_012557544.1 | 6087 | g24269 | i0 | 45.5 | 3.65060240963855 | 55 | 30 | 99.4 | 0 | 165 | 1 | 270 | 324 | XP_012557544.1 DAP3-binding cell death enhancer 1 isoform X2 [Hydra vulgaris] | diamond | 606 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28794934 | 28794934 | PRJEB10320_P_NODE_25267_length_163_cov_0.898438_g25009_i0 | PRJEB10320 | 25267 | 163 | 0.898438 | 1.46445394 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 70.1 | 1.1e-12 | NR | KAK2570237.1 | 6130 | g25009 | i0 | 56.6 | 11.7055214723926 | 53 | 23 | 97.5 | 0 | 160 | 2 | 146 | 198 | KAK2570237.1 Uridine phosphorylase 1, partial [Acropora cervicornis] | diamond | 1908 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28864339 | 28864339 | PRJEB10320_P_NODE_27828_length_153_cov_0.923729_g27570_i0 | PRJEB10320 | 27828 | 153 | 0.923729 | 1.41330537 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 57.8 | 4.01e-9 | NR | XP_046857974.1 | 2897299 | g27570 | i0 | 69.4 | 27.921568627451 | 36 | 11 | 70.6 | 0 | 10 | 117 | 18 | 53 | XP_046857974.1 40S ribosomal protein S27 [Xenia sp. Carnegie-2017] | diamond | 4272 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 29016503 | 29016503 | PRJEB10320_P_NODE_24568_length_166_cov_1.435115_g24310_i0 | PRJEB10320 | 24568 | 166 | 1.435115 | 2.3822909 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 2.97e-15 | NR | XP_044169536.1 | 45264 | g24310 | i0 | 64.8 | 1.93373493975904 | 54 | 19 | 97.6 | 0 | 164 | 3 | 428 | 481 | XP_044169536.1 inositol-3-phosphate synthase 1-A-like [Acropora millepora] | diamond | 321 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29369629 | 29369629 | PRJEB10320_P_NODE_16749_length_218_cov_2.010929_g16491_i0 | PRJEB10320 | 16749 | 218 | 2.010929 | 4.38382522 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 46.2 | 0.00159 | NR | PFX32089.1 | 50429 | g16491 | i0 | 53.1 | 1.34862385321101 | 49 | 21 | 67.4 | 1 | 2 | 148 | 453 | 499 | PFX32089.1 60S ribosomal protein L4-B [Stylophora pistillata] | diamond | 294 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30374620 | 30374620 | PRJEB10320_P_NODE_28012_length_152_cov_1.367521_g27754_i0 | PRJEB10320 | 28012 | 152 | 1.367521 | 2.07863192 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 5.95e-14 | NR | XP_031575458.1 | 6105 | g27754 | i0 | 75.5 | 56.1118421052632 | 49 | 12 | 96.7 | 0 | 151 | 5 | 66 | 114 | XP_031575458.1 neo-calmodulin [Actinia tenebrosa] | diamond | 8529 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30569594 | 30569594 | PRJEB10320_P_NODE_14193_length_245_cov_1.685714_g13935_i0 | PRJEB10320 | 14193 | 245 | 1.685714 | 4.1299993 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 55.1 | 1.67e-6 | NR | KAK3725766.1 | 3060491 | g13935 | i0 | 45.5 | 4.0530612244898 | 66 | 33 | 79.6 | 2 | 3 | 197 | 137 | 200 | KAK3725766.1 hypothetical protein QZH41_010623 [Actinostola sp. cb2023] | diamond | 993 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 30885786 | 30885786 | PRJEB10320_P_NODE_94_length_2200_cov_3.703002_g64_i0 | PRJEB10320 | 94 | 2200 | 3.703002 | 81.466044 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 622 | 5.6099999999999986e-213 | NR | XP_065052198.1 | 499914 | g64 | i0 | 56.8 | 1.46181818181818 | 579 | 241 | 78.7 | 3 | 2078 | 348 | 30 | 601 | XP_065052198.1 uncharacterized protein LOC135681586 [Rhopilema esculentum] | diamond | 3216 | 622 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31006057 | 31006057 | PRJEB10320_P_NODE_11334_length_285_cov_3.152000_g11076_i0 | PRJEB10320 | 11334 | 285 | 3.152 | 8.9832 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 148 | 1.83e-39 | NR | XP_020623343.1 | 48498 | g11076 | i0 | 72.3 | 9.77894736842105 | 94 | 26 | 98.9 | 0 | 3 | 284 | 417 | 510 | XP_020623343.1 NADP-dependent malic enzyme-like [Orbicella faveolata] | diamond | 2787 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31227146 | 31227146 | PRJEB10320_P_NODE_6575_length_405_cov_2.000000_g6320_i0 | PRJEB10320 | 6575 | 405 | 2 | 8.1 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 158 | 2.64e-45 | NR | XP_031549886.1 | 6105 | g6320 | i0 | 61.8 | 12.1555555555556 | 123 | 47 | 91.1 | 0 | 2 | 370 | 105 | 227 | XP_031549886.1 40S ribosomal protein S3a [Actinia tenebrosa] | diamond | 4923 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31265040 | 31265040 | PRJEB10320_P_NODE_3115_length_608_cov_1.211169_g2901_i0 | PRJEB10320 | 3115 | 608 | 1.211169 | 7.36390752 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 99 | 4.6e-20 | NR | XP_066914400.1 | 252671 | g2901 | i0 | 48.2 | 2.56085526315789 | 83 | 43 | 41 | 0 | 251 | 3 | 16 | 98 | XP_066914400.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 1557 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 31328220 | 31328220 | PRJEB10320_P_NODE_26296_length_158_cov_1.626016_g26038_i0 | PRJEB10320 | 26296 | 158 | 1.626016 | 2.56910528 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 59.7 | 1.14e-8 | NR | XP_057293703.1 | 13093 | g26038 | i0 | 55.3 | 0.892405063291139 | 47 | 21 | 89.2 | 0 | 18 | 158 | 8 | 54 | XP_057293703.1 crystallin J1A-like [Hydractinia symbiolongicarpus] | diamond | 141 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31739283 | 31739283 | PRJEB10320_P_NODE_22997_length_174_cov_1.438849_g22739_i0 | PRJEB10320 | 22997 | 174 | 1.438849 | 2.50359726 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 76.3 | 3.82e-16 | NR | NP_001296690.1 | 6087 | g22739 | i0 | 70 | 4.43103448275862 | 50 | 15 | 86.2 | 0 | 156 | 7 | 6 | 55 | NP_001296690.1 60S ribosomal protein L35a-like [Hydra vulgaris] | diamond | 771 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31859754 | 31859754 | PRJEB10320_P_NODE_22197_length_179_cov_1.083333_g21939_i0 | PRJEB10320 | 22197 | 179 | 1.083333 | 1.93916607 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 90.9 | 1.46e-20 | NR | KAK2548347.1 | 6130 | g21939 | i0 | 62.7 | 7.91061452513966 | 59 | 22 | 98.9 | 0 | 179 | 3 | 97 | 155 | KAK2548347.1 Inorganic pyrophosphatase [Acropora cervicornis] | diamond | 1416 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 31986301 | 31986301 | PRJEB10320_P_NODE_4798_length_486_cov_1.596452_g4556_i0 | PRJEB10320 | 4798 | 486 | 1.596452 | 7.75875672 | root | 1 | Root_unresolved | Root_unresolved | 159 | 2.31e-43 | NR | XP_022798405.1 | 50429 | g4556 | i0 | 51.5 | 9.16666666666667 | 167 | 69 | 99.4 | 3 | 3 | 485 | 235 | 395 | XP_022798405.1 carboxypeptidase D-like [Stylophora pistillata] | diamond | 4455 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32239812 | 32239812 | PRJEB10320_P_NODE_8458_length_345_cov_3.067742_g8200_i0 | PRJEB10320 | 8458 | 345 | 3.067742 | 10.5837099 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 3.57e-5 | NR | KAJ7380757.1 | 174260 | g8200 | i0 | 40.2 | 2.09565217391304 | 82 | 38 | 71.3 | 3 | 9 | 254 | 460 | 530 | KAJ7380757.1 hypothetical protein OS493_007135 [Desmophyllum pertusum] | diamond | 723 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32277532 | 32277532 | PRJEB10320_P_NODE_21199_length_185_cov_1.006667_g20941_i0 | PRJEB10320 | 21199 | 185 | 1.006667 | 1.86233395 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 82 | 1.19e-16 | NR | CAB4031625.1 | 317549 | g20941 | i0 | 56.7 | 6.74594594594595 | 60 | 26 | 97.3 | 0 | 184 | 5 | 225 | 284 | CAB4031625.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1248 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32435838 | 32435838 | PRJEB10320_P_NODE_4599_length_497_cov_2.465368_g4361_i0 | PRJEB10320 | 4599 | 497 | 2.465368 | 12.25287896 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 83.2 | 1.97e-15 | NR | XP_066936201.1 | 252671 | g4361 | i0 | 36 | 1.59356136820926 | 136 | 59 | 82.1 | 2 | 490 | 83 | 228 | 335 | XP_066936201.1 crystallin J1A-like [Clytia hemisphaerica] | diamond | 792 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;