contig_metadata
16 rows where bioproject = "PRJNA721440", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7088957 | 7088957 | PRJNA721440_S_NODE_9246_length_210_cov_4.099379_g9120_i0 | PRJNA721440 | 9246 | 210 | 4.099379 | 8.6086959 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 134 | 6.4000000000000005e-27 | NTclustered | gi|2518959458|ref|XM_057433663.1| | 13093 | g9120 | i0 | 82.39 | 30.5047619047619 | 159 | 23 | 75 | 5 | 1 | 157 | 765 | 920 | PREDICTED: Hydractinia symbiolongicarpus endoplasmic reticulum chaperone BiP-like (LOC130612358), mRNA | blastn | 6406 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 22387600 | 22387600 | PRJNA721440_S_NODE_7378_length_229_cov_1.661111_g7252_i0 | PRJNA721440 | 7378 | 229 | 1.661111 | 3.80394419 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 110 | 4.37e-26 | NR | XP_044179780.1 | 45264 | g7252 | i0 | 69.3 | 15.6419213973799 | 75 | 23 | 98.3 | 0 | 227 | 3 | 1064 | 1138 | XP_044179780.1 splicing factor 3B subunit 1-like isoform X2 [Acropora millepora] | diamond | 3582 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27020434 | 27020434 | PRJNA721440_S_NODE_6822_length_236_cov_1.620321_g6696_i0 | PRJNA721440 | 6822 | 236 | 1.620321 | 3.82395756 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 42.4 | 0.0477 | NR | CAH3039316.1 | 46732 | g6696 | i0 | 32.8 | 0.851694915254237 | 67 | 40 | 82.6 | 2 | 204 | 10 | 156 | 219 | CAH3039316.1 unnamed protein product [Pocillopora meandrina] | diamond | 201 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 27030856 | 27030856 | PRJNA721440_S_NODE_13782_length_182_cov_1.187970_g13656_i0 | PRJNA721440 | 13782 | 182 | 1.18797 | 2.1621054 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 1.4e-19 | NR | XP_057297950.1 | 13093 | g13656 | i0 | 73.3 | 9.85714285714286 | 60 | 16 | 98.9 | 0 | 182 | 3 | 310 | 369 | XP_057297950.1 S-adenosylmethionine synthase-like isoform X2 [Hydractinia symbiolongicarpus] | diamond | 1794 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28010324 | 28010324 | PRJNA721440_S_NODE_5685_length_253_cov_1.235294_g5559_i0 | PRJNA721440 | 5685 | 253 | 1.235294 | 3.12529382 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 83.2 | 3.56e-17 | NR | XP_031550539.1 | 6105 | g5559 | i0 | 63.5 | 2.98814229249012 | 63 | 21 | 74.7 | 1 | 227 | 39 | 178 | 238 | XP_031550539.1 GTP:AMP phosphotransferase AK3, mitochondrial-like [Actinia tenebrosa] | diamond | 756 | 84 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28736323 | 28736323 | PRJNA721440_S_NODE_20727_length_158_cov_2.311927_g20601_i0 | PRJNA721440 | 20727 | 158 | 2.311927 | 3.65284466 | root | 1 | Root_unresolved | Root_unresolved | 92.8 | 2.26e-20 | NR | CAH3174034.1 | 104178 | g20601 | i0 | 84.6 | 9.87341772151899 | 52 | 8 | 98.7 | 0 | 2 | 157 | 33 | 84 | CAH3174034.1 unnamed protein product, partial [Porites evermanni] | diamond | 1560 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28820215 | 28820215 | PRJNA721440_S_NODE_14688_length_178_cov_1.209302_g14562_i0 | PRJNA721440 | 14688 | 178 | 1.209302 | 2.15255756 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 52.8 | 4.19e-6 | NR | XP_012559882.1 | 6087 | g14562 | i0 | 53.2 | 0.792134831460674 | 47 | 22 | 79.2 | 0 | 2 | 142 | 241 | 287 | XP_012559882.1 uncharacterized protein LOC105846064 [Hydra vulgaris] | diamond | 141 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29672719 | 29672719 | PRJNA721440_S_NODE_12190_length_190_cov_2.198582_g12064_i0 | PRJNA721440 | 12190 | 190 | 2.198582 | 4.1773058 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 47.8 | 2.51e-4 | NR | XP_001627114.1 | 45351 | g12064 | i0 | 47.1 | 1.24736842105263 | 51 | 23 | 74.2 | 1 | 25 | 165 | 1 | 51 | XP_001627114.1 gamma-interferon-inducible lysosomal thiol reductase [Nematostella vectensis] | diamond | 237 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 29873027 | 29873027 | PRJNA721440_S_NODE_13191_length_185_cov_1.147059_g13065_i0 | PRJNA721440 | 13191 | 185 | 1.147059 | 2.12205915 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0238 | NR | XP_047136249.1 | 6087 | g13065 | i0 | 41.9 | 3.84324324324324 | 43 | 25 | 69.7 | 0 | 1 | 129 | 540 | 582 | XP_047136249.1 protein disulfide-isomerase A4 [Hydra vulgaris] | diamond | 711 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29988917 | 29988917 | PRJNA721440_S_NODE_17151_length_168_cov_3.495798_g17025_i0 | PRJNA721440 | 17151 | 168 | 3.495798 | 5.87294064 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 47 | 4.45e-4 | NR | NP_001296588.1 | 6087 | g17025 | i0 | 41.5 | 2.42857142857143 | 53 | 31 | 94.6 | 0 | 168 | 10 | 631 | 683 | NP_001296588.1 striatin-3-like [Hydra vulgaris] | diamond | 408 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30020637 | 30020637 | PRJNA721440_S_NODE_17171_length_168_cov_3.058824_g17045_i0 | PRJNA721440 | 17171 | 168 | 3.058824 | 5.13882432 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 41.2 | 0.0375 | NR | CAB3982855.1 | 317549 | g17045 | i0 | 41.2 | 0.910714285714286 | 51 | 30 | 91.1 | 0 | 2 | 154 | 61 | 111 | CAB3982855.1 probable RNA-binding 18 [Paramuricea clavata] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30463211 | 30463211 | PRJNA721440_S_NODE_9173_length_211_cov_1.456790_g9047_i0 | PRJNA721440 | 9173 | 211 | 1.45679 | 3.0738269 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 41.2 | 0.0384 | NR | KAF0985319.1 | 69463 | g9047 | i0 | 43.1 | 0.725118483412322 | 51 | 22 | 62.6 | 2 | 26 | 157 | 17 | 67 | KAF0985319.1 hypothetical protein HZS_6860 [Henneguya salminicola] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 30810351 | 30810351 | PRJNA721440_S_NODE_19634_length_162_cov_3.681416_g19508_i0 | PRJNA721440 | 19634 | 162 | 3.681416 | 5.96389392 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 53.1 | 2.58e-6 | NR | XP_020609598.1 | 48498 | g19508 | i0 | 55.6 | 5.01851851851852 | 54 | 22 | 96.3 | 1 | 5 | 160 | 477 | 530 | XP_020609598.1 copine-3-like isoform X2 [Orbicella faveolata] | diamond | 813 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 30820866 | 30820866 | PRJNA721440_S_NODE_13994_length_181_cov_1.257576_g13868_i0 | PRJNA721440 | 13994 | 181 | 1.257576 | 2.27621256 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 45.8 | 0.0013 | NR | XP_028403723.1 | 151771 | g13868 | i0 | 51.1 | 2.48618784530387 | 47 | 22 | 77.9 | 1 | 143 | 3 | 186 | 231 | XP_028403723.1 LMBR1 domain-containing protein 2-like [Dendronephthya gigantea] | diamond | 450 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31125951 | 31125951 | PRJNA721440_S_NODE_5615_length_254_cov_2.712195_g5489_i0 | PRJNA721440 | 5615 | 254 | 2.712195 | 6.8889753 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 43.9 | 0.0148 | NR | XP_068701096.1 | 591990 | g5489 | i0 | 38.3 | 0.55511811023622 | 47 | 29 | 55.5 | 0 | 86 | 226 | 113 | 159 | XP_068701096.1 type I iodothyronine deiodinase-like [Montipora foliosa] | diamond | 141 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31442513 | 31442513 | PRJNA721440_S_NODE_8296_length_219_cov_1.594118_g8170_i0 | PRJNA721440 | 8296 | 219 | 1.594118 | 3.49111842 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 83.6 | 1.17e-16 | NR | XP_065069341.1 | 499914 | g8170 | i0 | 58.3 | 3.94520547945205 | 72 | 30 | 98.6 | 0 | 219 | 4 | 526 | 597 | XP_065069341.1 structural maintenance of chromosomes protein 2-like [Rhopilema esculentum] | diamond | 864 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;