contig_metadata
26 rows where bioproject = "PRJNA1120771", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6131467 | 6131467 | PRJNA1120771_S_NODE_5705_length_409_cov_28.825137_g5305_i0 | PRJNA1120771 | 5705 | 409 | 28.825137 | 117.89481033 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 91.7 | 1.4e-20 | NR | KAK2556285.1 | 6130 | g5305 | i0 | 60 | 5.00977995110024 | 75 | 30 | 55 | 0 | 391 | 167 | 25 | 99 | KAK2556285.1 60S acidic ribosomal protein P2 [Acropora cervicornis] | diamond | 2049 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 6654583 | 6654583 | PRJNA1120771_S_NODE_5966_length_403_cov_2.841667_g5566_i0 | PRJNA1120771 | 5966 | 403 | 2.841667 | 11.45191801 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 152 | 4.72e-44 | NR | XP_001624448.1 | 45351 | g5566 | i0 | 64.2 | 4.65260545905707 | 106 | 38 | 78.9 | 0 | 6 | 323 | 75 | 180 | XP_001624448.1 ADP-ribosylation factor-like protein 3 [Nematostella vectensis] | diamond | 1875 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 10480334 | 10480334 | PRJNA1120771_S_NODE_4269_length_455_cov_6.902913_g3872_i0 | PRJNA1120771 | 4269 | 455 | 6.902913 | 31.40825415 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 102 | 4.32e-17 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g3872 | i0 | 91.892 | 0.415384615384615 | 74 | 4 | 16 | 2 | 54 | 126 | 3616 | 3544 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 189 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 15056271 | 15056271 | PRJNA1120771_S_NODE_9952_length_336_cov_3.563140_g9552_i0 | PRJNA1120771 | 9952 | 336 | 3.56314 | 11.9721504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2917940744|emb|OZ237568.1| | 6108 | g9552 | i0 | 100 | 6.60119047619048 | 29 | 0 | 9 | 0 | 82 | 110 | 11753100 | 11753128 | Anemonia sulcata genome assembly, chromosome: 14 | blastn | 2218 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 15579582 | 15579582 | PRJNA1120771_S_NODE_41693_length_178_cov_10.600000_g41293_i0 | PRJNA1120771 | 41693 | 178 | 10.6 | 18.868 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g41293 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 1 | 28 | 1 | 28 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15579584 | 15579584 | PRJNA1120771_S_NODE_4233_length_456_cov_21.602906_g3836_i0 | PRJNA1120771 | 4233 | 456 | 21.602906 | 98.50925136 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 159 | 9.65e-47 | NR | XP_065067292.1 | 499914 | g3836 | i0 | 60 | 1.71710526315789 | 130 | 49 | 85.5 | 1 | 454 | 65 | 45 | 171 | XP_065067292.1 large ribosomal subunit protein eL20-like [Rhopilema esculentum] | diamond | 783 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 20154945 | 20154945 | PRJNA1120771_S_NODE_35916_length_204_cov_5.540373_g35516_i0 | PRJNA1120771 | 35916 | 204 | 5.540373 | 11.30236092 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g35516 | i0 | 100 | 1.25490196078431 | 28 | 0 | 14 | 0 | 2 | 29 | 7611486 | 7611459 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 256 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 20678017 | 20678017 | PRJNA1120771_S_NODE_18537_length_269_cov_1.535398_g18137_i0 | PRJNA1120771 | 18537 | 269 | 1.535398 | 4.13022062 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 106 | 2.8300000000000004e-27 | NR | XP_001637717.1 | 45351 | g18137 | i0 | 68.2 | 1.46096654275093 | 66 | 21 | 73.6 | 0 | 269 | 72 | 62 | 127 | XP_001637717.1 adenosine 5'-monophosphoramidase HINT1 isoform X2 [Nematostella vectensis] | diamond | 393 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 20678078 | 20678078 | PRJNA1120771_S_NODE_25357_length_238_cov_1.548718_g24957_i0 | PRJNA1120771 | 25357 | 238 | 1.548718 | 3.68594884 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g24957 | i0 | 94.286 | 0.147058823529412 | 35 | 1 | 15 | 1 | 204 | 238 | 34 | 1 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 20678210 | 20678210 | PRJNA1120771_S_NODE_997_length_882_cov_12.166865_g773_i0 | PRJNA1120771 | 997 | 882 | 12.166865 | 107.3117493 | Heteropolypus sp. | 3097316 | Cnidaria | other_Eukaryota | 163 | 3.94e-35 | NTclustered | gi|2689317291|gb|PP410741.1| | 3097316 | g773 | i0 | 88.321 | 40.6678004535147 | 137 | 15 | 16 | 1 | 321 | 457 | 2188 | 2053 | Heteropolypus sp. voucher RB-19-192 large subunit ribosomal RNA gene, partial sequence | blastn | 35869 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Coralliidae | Heteropolypus | Heteropolypus sp. | |
| 24502658 | 24502658 | PRJNA1120771_S_NODE_6320_length_395_cov_4.051136_g5920_i0 | PRJNA1120771 | 6320 | 395 | 4.051136 | 16.0019872 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|2519002640|ref|XM_057452941.1| | 13093 | g5920 | i0 | 100 | 0.0734177215189873 | 29 | 0 | 7 | 0 | 27 | 55 | 794 | 766 | PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130647178 (LOC130647178), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26647628 | 26647628 | PRJNA1120771_S_NODE_14061_length_297_cov_3.555118_g13661_i0 | PRJNA1120771 | 14061 | 297 | 3.5551179999999998 | 10.55870046 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 86.7 | 7.08e-18 | NR | XP_027039128.1 | 46731 | g13661 | i0 | 71.4 | 1.90909090909091 | 63 | 18 | 63.6 | 0 | 297 | 109 | 237 | 299 | XP_027039128.1 elongation factor 1-beta-like [Pocillopora damicornis] | diamond | 567 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 26753229 | 26753229 | PRJNA1120771_S_NODE_19581_length_263_cov_2.804545_g19181_i0 | PRJNA1120771 | 19581 | 263 | 2.804545 | 7.37595335 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 114 | 2.29e-30 | NR | XP_020631066.1 | 48498 | g19181 | i0 | 71.3 | 3.87832699619772 | 87 | 25 | 99.2 | 0 | 3 | 263 | 57 | 143 | XP_020631066.1 40S ribosomal protein S25-like [Orbicella faveolata] | diamond | 1020 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 26837995 | 26837995 | PRJNA1120771_S_NODE_11161_length_323_cov_3.571429_g10761_i0 | PRJNA1120771 | 11161 | 323 | 3.571429 | 11.53571567 | root | 1 | Root_unresolved | Root_unresolved | 62.8 | 8.75e-9 | NR | XP_028403818.1 | 151771 | g10761 | i0 | 50.9 | 5.20123839009288 | 53 | 26 | 49.2 | 0 | 322 | 164 | 602 | 654 | XP_028403818.1 E3 ubiquitin-protein ligase TRIM71-like [Dendronephthya gigantea] | diamond | 1680 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27386375 | 27386375 | PRJNA1120771_S_NODE_3003_length_524_cov_20.189189_g2626_i0 | PRJNA1120771 | 3003 | 524 | 20.189189 | 105.79135036 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 56.2 | 3.49e-6 | NR | XP_031572584.1 | 6105 | g2626 | i0 | 35.7 | 0.480916030534351 | 84 | 54 | 48.1 | 0 | 519 | 268 | 97 | 180 | XP_031572584.1 translocon-associated protein subunit beta-like [Actinia tenebrosa] | diamond | 252 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27438879 | 27438879 | PRJNA1120771_S_NODE_36343_length_203_cov_2.175000_g35943_i0 | PRJNA1120771 | 36343 | 203 | 2.175 | 4.41525 | Acropora | 6127 | Cnidaria | other_Eukaryota | 59.3 | 3.19e-8 | NR | XP_044178630.1 | 45264 | g35943 | i0 | 51.7 | 2.57142857142857 | 58 | 28 | 85.7 | 0 | 16 | 189 | 1187 | 1244 | XP_044178630.1 LOW QUALITY PROTEIN: uncharacterized protein LOC114959691 [Acropora millepora] | diamond | 522 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27891215 | 27891215 | PRJNA1120771_S_NODE_12785_length_308_cov_2.626415_g12385_i0 | PRJNA1120771 | 12785 | 308 | 2.626415 | 8.0893582 | Acropora cervicornis | 6130 | Cnidaria | other_Eukaryota | 73.6 | 1.18e-12 | NR | KAK2573626.1 | 6130 | g12385 | i0 | 54.7 | 0.623376623376623 | 64 | 28 | 61.4 | 1 | 303 | 115 | 526 | 589 | KAK2573626.1 V-type proton ATPase catalytic subunit A [Acropora cervicornis] | diamond | 192 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28617732 | 28617732 | PRJNA1120771_S_NODE_30887_length_219_cov_1.869318_g30487_i0 | PRJNA1120771 | 30887 | 219 | 1.869318 | 4.09380642 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 76.6 | 3.16e-14 | NR | XP_029186207.2 | 45264 | g30487 | i0 | 60.6 | 0.904109589041096 | 66 | 26 | 90.4 | 0 | 198 | 1 | 533 | 598 | XP_029186207.2 very long-chain specific acyl-CoA dehydrogenase, mitochondrial-like [Acropora millepora] | diamond | 198 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28870079 | 28870079 | PRJNA1120771_S_NODE_14028_length_297_cov_6.129921_g13628_i0 | PRJNA1120771 | 14028 | 297 | 6.129921 | 18.20586537 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 43.5 | 0.0383 | NR | XP_048590084.1 | 45351 | g13628 | i0 | 51.2 | 0.414141414141414 | 41 | 19 | 40.4 | 1 | 31 | 150 | 529 | 569 | XP_048590084.1 stimulated by retinoic acid gene 6 protein-like isoform X3 [Nematostella vectensis] | diamond | 123 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29206925 | 29206925 | PRJNA1120771_S_NODE_19589_length_263_cov_2.581818_g19189_i0 | PRJNA1120771 | 19589 | 263 | 2.581818 | 6.79018134 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92.8 | 2.2400000000000003e-21 | NR | XP_012553648.1 | 6087 | g19189 | i0 | 54.1 | 18.5475285171103 | 85 | 39 | 97 | 0 | 263 | 9 | 97 | 181 | XP_012553648.1 large ribosomal subunit protein uL22 isoform X1 [Hydra vulgaris] | diamond | 4878 | 93.6 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30101551 | 30101551 | PRJNA1120771_S_NODE_22392_length_250_cov_2.468599_g21992_i0 | PRJNA1120771 | 22392 | 250 | 2.468599 | 6.1714975 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 62 | 6.87e-9 | NR | CAH3169352.1 | 104759 | g21992 | i0 | 81 | 3.54 | 42 | 8 | 50.4 | 0 | 247 | 122 | 1629 | 1670 | CAH3169352.1 unnamed protein product [Porites lobata] | diamond | 885 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 31270847 | 31270847 | PRJNA1120771_S_NODE_21275_length_255_cov_1.650943_g20875_i0 | PRJNA1120771 | 21275 | 255 | 1.650943 | 4.20990465 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 75.9 | 1.1e-14 | NR | XP_065057176.1 | 499914 | g20875 | i0 | 52.6 | 2.55294117647059 | 78 | 30 | 83.5 | 1 | 3 | 215 | 121 | 198 | XP_065057176.1 large ribosomal subunit protein uL13-like [Rhopilema esculentum] | diamond | 651 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31418152 | 31418152 | PRJNA1120771_S_NODE_17076_length_277_cov_5.944444_g16676_i0 | PRJNA1120771 | 17076 | 277 | 5.944444 | 16.46610988 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 126 | 1.2699999999999998e-31 | NR | XP_044163784.1 | 45264 | g16676 | i0 | 78.5 | 2.11191335740072 | 65 | 14 | 70.4 | 0 | 1 | 195 | 545 | 609 | XP_044163784.1 asparagine--tRNA ligase, cytoplasmic-like isoform X1 [Acropora millepora] | diamond | 585 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32346638 | 32346638 | PRJNA1120771_S_NODE_8839_length_351_cov_2.480519_g8439_i0 | PRJNA1120771 | 8839 | 351 | 2.480519 | 8.70662169 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 69.7 | 4.67e-11 | NR | XP_031551869.1 | 6105 | g8439 | i0 | 39.8 | 0.709401709401709 | 83 | 50 | 70.9 | 0 | 7 | 255 | 120 | 202 | XP_031551869.1 uncharacterized protein LOC116289133 [Actinia tenebrosa] | diamond | 249 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32399003 | 32399003 | PRJNA1120771_S_NODE_38459_length_195_cov_6.203947_g38059_i0 | PRJNA1120771 | 38459 | 195 | 6.203947 | 12.09769665 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 56.2 | 3.11e-7 | NR | KAK2557037.1 | 6130 | g38059 | i0 | 75.7 | 10.1846153846154 | 37 | 9 | 56.9 | 0 | 3 | 113 | 285 | 321 | KAK2557037.1 Elongation factor 1-beta [Acropora cervicornis] | diamond | 1986 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 32819741 | 32819741 | PRJNA1120771_S_NODE_14320_length_295_cov_6.750000_g13920_i0 | PRJNA1120771 | 14320 | 295 | 6.75 | 19.9125 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 60.1 | 5.07e-8 | NR | XP_066930400.1 | 252671 | g13920 | i0 | 76.5 | 0.345762711864407 | 34 | 8 | 34.6 | 0 | 2 | 103 | 327 | 360 | XP_066930400.1 mannose-1-phosphate guanyltransferase beta-like [Clytia hemisphaerica] | diamond | 102 | 60.1 | 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);;