contig_metadata
14 rows where bioproject = "PRJNA1146029", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290057 | 290057 | PRJNA1146029_P_NODE_17081_length_249_cov_1.727273_g16800_i0 | PRJNA1146029 | 17081 | 249 | 1.727273 | 4.30090977 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 135 | 8.529999999999999e-37 | NR | XP_020614539.1 | 48498 | g16800 | i0 | 74.4 | 12.8433734939759 | 82 | 21 | 98.8 | 0 | 2 | 247 | 170 | 251 | XP_020614539.1 retinal dehydrogenase 1-like [Orbicella faveolata] | diamond | 3198 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 290092 | 290092 | PRJNA1146029_P_NODE_18881_length_246_cov_1.780347_g18600_i0 | PRJNA1146029 | 18881 | 246 | 1.780347 | 4.37965362 | root | 1 | Root_unresolved | Root_unresolved | 96.3 | 5.58e-21 | NR | XP_048585650.1 | 45351 | g18600 | i0 | 50 | 19.1341463414634 | 84 | 37 | 98.8 | 2 | 245 | 3 | 24 | 105 | XP_048585650.1 scavenger receptor cysteine-rich domain-containing group B protein [Nematostella vectensis] | diamond | 4707 | 97.1 | 0.991761071060762 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 3584087 | 3584087 | PRJNA1146029_P_NODE_15323_length_255_cov_1.604396_g15042_i0 | PRJNA1146029 | 15323 | 255 | 1.604396 | 4.0912098 | Corymorpha | 264057 | Cnidaria | other_Eukaryota | 220 | 6e-53 | NTclustered | gi|166407147|gb|EU272563.1| | 498525 | g15042 | i0 | 83.607 | 89.478431372549 | 244 | 30 | 95 | 7 | 1 | 242 | 1025 | 1260 | Corymorpha bigelowi voucher KUNHM 2829 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22817 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Corymorphidae | Corymorpha | Corymorpha bigelowi | |
| 6667944 | 6667944 | PRJNA1146029_P_NODE_15366_length_255_cov_1.269231_g15085_i0 | PRJNA1146029 | 15366 | 255 | 1.269231 | 3.23653905 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 235 | 2.1399999999999997e-57 | NTclustered | gi|1778059731|ref|XM_031711301.1| | 6105 | g15085 | i0 | 83.333 | 101.380392156863 | 252 | 42 | 99 | 0 | 1 | 252 | 356 | 105 | PREDICTED: Actinia tenebrosa ubiquitin-40S ribosomal protein S27a (LOC116302103), mRNA | blastn | 25852 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 10493667 | 10493667 | PRJNA1146029_P_NODE_14029_length_264_cov_1.612565_g13748_i0 | PRJNA1146029 | 14029 | 264 | 1.612565 | 4.2571716 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 169 | 2.3e-37 | NTclustered | gi|2782902330|ref|XM_067068799.1| | 252671 | g13748 | i0 | 79.92 | 36.6666666666667 | 249 | 34 | 91 | 11 | 21 | 261 | 414 | 654 | PREDICTED: Clytia hemisphaerica ATP synthase subunit beta, mitochondrial-like (LOC136812302), mRNA | blastn | 9680 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 20159976 | 20159976 | PRJNA1146029_P_NODE_11156_length_283_cov_1.833333_g10875_i0 | PRJNA1146029 | 11156 | 283 | 1.833333 | 5.18833239 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 72.4 | 2.25e-12 | NR | XP_028406564.1 | 151771 | g10875 | i0 | 50.8 | 0.68904593639576 | 65 | 30 | 66.8 | 1 | 223 | 35 | 466 | 530 | XP_028406564.1 uncharacterized protein LOC114529037 [Dendronephthya gigantea] | diamond | 195 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 20691772 | 20691772 | PRJNA1146029_P_NODE_8937_length_304_cov_1.363636_g8656_i0 | PRJNA1146029 | 8937 | 304 | 1.363636 | 4.14545344 | Dendrogramma enigmatica | 1960159 | Cnidaria | other_Eukaryota | 78.7 | 4.67e-10 | NTclustered | gi|1150186410|gb|KU716075.1| | 1960159 | g8656 | i0 | 84.337 | 16.7532894736842 | 83 | 10 | 27 | 3 | 154 | 234 | 744 | 825 | Dendrogramma enigmatica 28S ribosomal RNA gene, partial sequence | blastn | 5093 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Siphonophorae | Rhodaliidae | Dendrogramma | Dendrogramma enigmatica | |
| 27533426 | 27533426 | PRJNA1146029_P_NODE_7283_length_331_cov_2.294574_g7005_i0 | PRJNA1146029 | 7283 | 331 | 2.294574 | 7.59503994 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 199 | 7.71e-63 | NR | CAH3123479.1 | 104759 | g7005 | i0 | 87.9 | 30.5438066465257 | 107 | 13 | 97 | 0 | 325 | 5 | 37 | 143 | CAH3123479.1 unnamed protein product [Porites lobata] | diamond | 10110 | 201 | 0.990049751243781 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 28712846 | 28712846 | PRJNA1146029_P_NODE_4527_length_406_cov_1.156156_g4249_i0 | PRJNA1146029 | 4527 | 406 | 1.156156 | 4.69399336 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 60.5 | 9.53e-8 | NR | XP_031574635.1 | 6105 | g4249 | i0 | 26.9 | 1.64778325123153 | 119 | 80 | 84.2 | 4 | 405 | 64 | 159 | 275 | XP_031574635.1 uncharacterized protein LOC116308369 [Actinia tenebrosa] | diamond | 669 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30185776 | 30185776 | PRJNA1146029_P_NODE_3532_length_454_cov_2.454068_g3254_i0 | PRJNA1146029 | 3532 | 454 | 2.454068 | 11.14146872 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 5.82e-37 | NR | XP_002166962.3 | 6087 | g3254 | i0 | 71.4 | 17.9867841409692 | 84 | 22 | 55.5 | 1 | 3 | 254 | 246 | 327 | XP_002166962.3 cathepsin B [Hydra vulgaris] | diamond | 8166 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30260400 | 30260400 | PRJNA1146029_P_NODE_13412_length_269_cov_1.306122_g13131_i0 | PRJNA1146029 | 13412 | 269 | 1.306122 | 3.51346818 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 60.8 | 2.2e-8 | NR | RMX38937.1 | 46731 | g13131 | i0 | 32.1 | 0.936802973977695 | 84 | 49 | 90.3 | 3 | 250 | 8 | 358 | 436 | RMX38937.1 hypothetical protein pdam_00016421 [Pocillopora damicornis] | diamond | 252 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31777287 | 31777287 | PRJNA1146029_P_NODE_10957_length_285_cov_1.018868_g10676_i0 | PRJNA1146029 | 10957 | 285 | 1.018868 | 2.9037738 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 50.8 | 8.61e-5 | NR | XP_057302071.1 | 13093 | g10676 | i0 | 82.8 | 0.926315789473684 | 29 | 5 | 30.5 | 0 | 285 | 199 | 408 | 436 | XP_057302071.1 probable ATP-dependent RNA helicase ddx6 [Hydractinia symbiolongicarpus] | diamond | 264 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32093693 | 32093693 | PRJNA1146029_P_NODE_3138_length_482_cov_0.889976_g2861_i0 | PRJNA1146029 | 3138 | 482 | 0.889976 | 4.28968432 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 63.5 | 2.2e-8 | NR | XP_020606083.1 | 48498 | g2861 | i0 | 46.9 | 0.504149377593361 | 81 | 32 | 46.7 | 4 | 76 | 300 | 146 | 221 | XP_020606083.1 fibropellin-1-like [Orbicella faveolata] | diamond | 243 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32378595 | 32378595 | PRJNA1146029_P_NODE_8719_length_308_cov_1.310638_g8438_i0 | PRJNA1146029 | 8719 | 308 | 1.310638 | 4.03676504 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 80.9 | 3.43e-15 | NR | CAH3034567.1 | 46732 | g8438 | i0 | 44.7 | 1.00324675324675 | 103 | 51 | 95.5 | 2 | 15 | 308 | 2401 | 2502 | CAH3034567.1 unnamed protein product [Pocillopora meandrina] | diamond | 309 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina |
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);;