contig_metadata
27 rows where bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4910725 | 4910725 | PRJNA408129_S_NODE_21764_length_174_cov_3.131387_g21746_i0 | PRJNA408129 | 21764 | 174 | 3.131387 | 5.44861338 | Pocillopora | 46730 | Cnidaria | other_Eukaryota | 154 | 3.9e-33 | NTclustered | gi|1524902315|ref|XM_027203704.1| | 46731 | g21746 | i0 | 83.636 | 68.448275862069 | 165 | 25 | 94 | 2 | 11 | 174 | 295 | 132 | PREDICTED: Pocillopora damicornis ubiquitin-60S ribosomal protein L40 (LOC113686101), mRNA | blastn | 11910 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 9346447 | 9346447 | PRJNA408129_S_NODE_14768_length_196_cov_5.710692_g14750_i0 | PRJNA408129 | 14768 | 196 | 5.710692 | 11.19295632 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2918369539|emb|OZ237721.1| | 317547 | g14750 | i0 | 100 | 0.428571428571429 | 28 | 0 | 14 | 0 | 160 | 187 | 15411343 | 15411370 | Eunicella cavolini genome assembly, chromosome: 5 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15721069 | 15721069 | PRJNA408129_S_NODE_18113_length_184_cov_3.149660_g18095_i0 | PRJNA408129 | 18113 | 184 | 3.14966 | 5.7953744 | Craspedacusta sowerbii | 128124 | Cnidaria | other_Eukaryota | 339 | 1.08e-88 | NTclustered | gi|1100820113|gb|KY083050.1| | 128124 | g18095 | i0 | 100 | 100.108695652174 | 183 | 0 | 99 | 0 | 2 | 184 | 16 | 198 | Craspedacusta sowerbyi isolate AGC1001 large subunit ribosomal RNA gene, partial sequence | blastn | 18420 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Limnomedusae | Olindiidae | Craspedacusta | Craspedacusta sowerbii | |
| 17660241 | 17660241 | PRJNA408129_S_NODE_11894_length_210_cov_6.312139_g11876_i0 | PRJNA408129 | 11894 | 210 | 6.312139 | 13.2554919 | Acropora | 6127 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2113819634|ref|XM_029341279.2| | 45264 | g11876 | i0 | 96.97 | 0.314285714285714 | 33 | 1 | 16 | 0 | 23 | 55 | 389 | 357 | PREDICTED: Acropora millepora piggyBac transposable element-derived protein 4-like (LOC114962323), mRNA | blastn | 66 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 24644732 | 24644732 | PRJNA408129_S_NODE_17620_length_186_cov_1.724832_g17602_i0 | PRJNA408129 | 17620 | 186 | 1.724832 | 3.20818752 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g17602 | i0 | 100 | 0.155913978494624 | 29 | 0 | 16 | 0 | 14 | 42 | 8470354 | 8470382 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26885907 | 26885907 | PRJNA408129_S_NODE_5261_length_263_cov_8.216814_g5243_i0 | PRJNA408129 | 5261 | 263 | 8.216814 | 21.61022082 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 56.2 | 8.04e-7 | NR | KAK3730803.1 | 3060491 | g5243 | i0 | 43.1 | 8.50950570342205 | 72 | 40 | 82.1 | 1 | 227 | 12 | 296 | 366 | KAK3730803.1 hypothetical protein QZH41_001164 [Actinostola sp. cb2023] | diamond | 2238 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 26965582 | 26965582 | PRJNA408129_S_NODE_9282_length_226_cov_4.920635_g9264_i0 | PRJNA408129 | 9282 | 226 | 4.920635 | 11.1206351 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 69.7 | 9.6e-12 | NR | CAB4014746.1 | 317549 | g9264 | i0 | 52.9 | 13.3274336283186 | 68 | 26 | 90.3 | 2 | 205 | 2 | 1163 | 1224 | CAB4014746.1 DNA polymerase [Paramuricea clavata] | diamond | 3012 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27360148 | 27360148 | PRJNA408129_S_NODE_1263_length_367_cov_8.503030_g1245_i0 | PRJNA408129 | 1263 | 367 | 8.50303 | 31.2061201 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 9.61e-6 | NR | XP_065648980.1 | 6087 | g1245 | i0 | 50 | 1.9700272479564 | 52 | 26 | 42.5 | 0 | 167 | 12 | 231 | 282 | XP_065648980.1 uncharacterized protein LOC100213181 isoform X2 [Hydra vulgaris] | diamond | 723 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 27770710 | 27770710 | PRJNA408129_S_NODE_24524_length_168_cov_2.167939_g24506_i0 | PRJNA408129 | 24524 | 168 | 2.167939 | 3.64213752 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 53.9 | 1.58e-6 | NR | CAB4028238.1 | 317549 | g24506 | i0 | 50 | 3.42857142857143 | 54 | 24 | 92.9 | 2 | 168 | 13 | 144 | 196 | CAB4028238.1 DNA polymerase [Paramuricea clavata] | diamond | 576 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 27991649 | 27991649 | PRJNA408129_S_NODE_34125_length_152_cov_3.504348_g34107_i0 | PRJNA408129 | 34125 | 152 | 3.504348 | 5.32660896 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 50.4 | 2.02e-5 | NR | CAB4017999.1 | 317549 | g34107 | i0 | 44.7 | 0.927631578947368 | 47 | 26 | 92.8 | 0 | 7 | 147 | 53 | 99 | CAB4017999.1 Gastrula zinc finger [Paramuricea clavata] | diamond | 141 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28639853 | 28639853 | PRJNA408129_S_NODE_24747_length_167_cov_5.007692_g24729_i0 | PRJNA408129 | 24747 | 167 | 5.007692 | 8.36284564 | root | 1 | Root_unresolved | Root_unresolved | 57 | 7.77e-8 | NR | CAB4008445.1 | 317549 | g24729 | i0 | 50.9 | 7.61676646706587 | 53 | 26 | 95.2 | 0 | 165 | 7 | 55 | 107 | CAB4008445.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1272 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28843827 | 28843827 | PRJNA408129_S_NODE_20108_length_178_cov_6.163121_g20090_i0 | PRJNA408129 | 20108 | 178 | 6.163121 | 10.97035538 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 42.7 | 0.0158 | NR | XP_065652610.1 | 6087 | g20090 | i0 | 48.6 | 3.53932584269663 | 35 | 18 | 59 | 0 | 68 | 172 | 166 | 200 | XP_065652610.1 uncharacterized protein LOC136079876 [Hydra vulgaris] | diamond | 630 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28906927 | 28906927 | PRJNA408129_S_NODE_11008_length_215_cov_7.230337_g10990_i0 | PRJNA408129 | 11008 | 215 | 7.230337 | 15.54522455 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 42.4 | 0.0302 | NR | XP_028394409.1 | 151771 | g10990 | i0 | 33.8 | 0.906976744186046 | 65 | 43 | 90.7 | 0 | 198 | 4 | 153 | 217 | XP_028394409.1 uncharacterized protein LOC114518589 [Dendronephthya gigantea] | diamond | 195 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 28906931 | 28906931 | PRJNA408129_S_NODE_22888_length_171_cov_6.044776_g22870_i0 | PRJNA408129 | 22888 | 171 | 6.044776 | 10.33656696 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 52.4 | 5.79e-6 | NR | KXJ08474.1 | 2652724 | g22870 | i0 | 54.3 | 0.807017543859649 | 46 | 21 | 80.7 | 0 | 153 | 16 | 397 | 442 | KXJ08474.1 Uncharacterized protein K02A2.6, partial [Exaiptasia diaphana] | diamond | 138 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28923656 | 28923656 | PRJNA408129_S_NODE_7728_length_238_cov_4.238806_g7710_i0 | PRJNA408129 | 7728 | 238 | 4.238806 | 10.08835828 | Pocilloporidae | 46729 | Cnidaria | other_Eukaryota | 115 | 1.32e-29 | NR | RMX36968.1 | 46731 | g7710 | i0 | 70.4 | 2.68487394957983 | 71 | 21 | 89.5 | 0 | 228 | 16 | 173 | 243 | RMX36968.1 hypothetical protein pdam_00005043 [Pocillopora damicornis] | diamond | 639 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 29317577 | 29317577 | PRJNA408129_S_NODE_3849_length_286_cov_4.650602_g3831_i0 | PRJNA408129 | 3849 | 286 | 4.650602 | 13.30072172 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 73.2 | 1.28e-12 | NR | CAB3994490.1 | 317549 | g3831 | i0 | 44.3 | 1.77272727272727 | 88 | 49 | 92.3 | 0 | 19 | 282 | 168 | 255 | CAB3994490.1 DNA polymerase [Paramuricea clavata] | diamond | 507 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 29365916 | 29365916 | PRJNA408129_S_NODE_13669_length_201_cov_4.646341_g13651_i0 | PRJNA408129 | 13669 | 201 | 4.646341 | 9.33914541 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 65.1 | 2.74e-10 | NR | XP_065654750.1 | 6087 | g13651 | i0 | 46.7 | 10.8805970149254 | 60 | 32 | 89.6 | 0 | 2 | 181 | 406 | 465 | XP_065654750.1 zinc finger MYM-type protein 1-like [Hydra vulgaris] | diamond | 2187 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29492096 | 29492096 | PRJNA408129_S_NODE_21330_length_175_cov_3.297101_g21312_i0 | PRJNA408129 | 21330 | 175 | 3.297101 | 5.76992675 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 50.8 | 1.77e-5 | NR | XP_065647926.1 | 6087 | g21312 | i0 | 48.6 | 2.43428571428571 | 35 | 18 | 60 | 0 | 67 | 171 | 199 | 233 | XP_065647926.1 uncharacterized protein LOC136077150 [Hydra vulgaris] | diamond | 426 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29601473 | 29601473 | PRJNA408129_S_NODE_31990_length_155_cov_2.661017_g31972_i0 | PRJNA408129 | 31990 | 155 | 2.661017 | 4.12457635 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 41.2 | 0.0397 | NR | KXJ09041.1 | 2652724 | g31972 | i0 | 51.5 | 0.638709677419355 | 33 | 16 | 63.9 | 0 | 45 | 143 | 143 | 175 | KXJ09041.1 hypothetical protein AC249_AIPGENE26933 [Exaiptasia diaphana] | diamond | 99 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30423449 | 30423449 | PRJNA408129_S_NODE_7393_length_241_cov_3.088235_g7375_i0 | PRJNA408129 | 7393 | 241 | 3.088235 | 7.44264635 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 44.7 | 0.00588 | NR | XP_068749352.1 | 246305 | g7375 | i0 | 65.6 | 0.398340248962656 | 32 | 11 | 39.8 | 0 | 47 | 142 | 178 | 209 | XP_068749352.1 uncharacterized protein [Montipora capricornis] | diamond | 96 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 30439920 | 30439920 | PRJNA408129_S_NODE_22793_length_172_cov_1.333333_g22775_i0 | PRJNA408129 | 22793 | 172 | 1.333333 | 2.29333276 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 65.1 | 1.88e-10 | NR | CAH3196018.1 | 104178 | g22775 | i0 | 89.2 | 12.1046511627907 | 37 | 4 | 64.5 | 0 | 160 | 50 | 96 | 132 | CAH3196018.1 unnamed protein product, partial [Porites evermanni] | diamond | 2082 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30549407 | 30549407 | PRJNA408129_S_NODE_19633_length_180_cov_1.867133_g19615_i0 | PRJNA408129 | 19633 | 180 | 1.867133 | 3.3608394 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 45.8 | 0.00135 | NR | XP_068720538.1 | 246305 | g19615 | i0 | 54.1 | 1.88333333333333 | 37 | 17 | 61.7 | 0 | 67 | 177 | 294 | 330 | XP_068720538.1 uncharacterized protein C17orf113-like [Montipora capricornis] | diamond | 339 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 31149344 | 31149344 | PRJNA408129_S_NODE_1035_length_383_cov_21.661850_g1017_i0 | PRJNA408129 | 1035 | 383 | 21.66185 | 82.9648855 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 44.7 | 0.0377 | NR | XP_065070248.1 | 499914 | g1017 | i0 | 39.3 | 0.438642297650131 | 56 | 34 | 43.9 | 0 | 175 | 8 | 1279 | 1334 | XP_065070248.1 glycogen debranching enzyme-like [Rhopilema esculentum] | diamond | 168 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31181071 | 31181071 | PRJNA408129_S_NODE_6255_length_251_cov_6.191589_g6237_i0 | PRJNA408129 | 6255 | 251 | 6.191589 | 15.54088839 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 98.2 | 9.69e-22 | NR | CAB4016997.1 | 317549 | g6237 | i0 | 56.6 | 4.91235059760956 | 83 | 36 | 99.2 | 0 | 251 | 3 | 374 | 456 | CAB4016997.1 Hypothetical predicted protein [Paramuricea clavata] | diamond | 1233 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31229429 | 31229429 | PRJNA408129_S_NODE_10215_length_220_cov_4.377049_g10197_i0 | PRJNA408129 | 10215 | 220 | 4.377049 | 9.6295078 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 54.7 | 1.59e-6 | NR | CAH3107083.1 | 46732 | g10197 | i0 | 36.2 | 5.64545454545455 | 69 | 43 | 92.7 | 1 | 216 | 13 | 198 | 266 | CAH3107083.1 unnamed protein product, partial [Pocillopora meandrina] | diamond | 1242 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 32288908 | 32288908 | PRJNA408129_S_NODE_1659_length_347_cov_8.054839_g1641_i0 | PRJNA408129 | 1659 | 347 | 8.054839 | 27.95029133 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 54.3 | 1.04e-5 | NR | XP_044163394.1 | 45264 | g1641 | i0 | 38.8 | 0.579250720461095 | 67 | 41 | 57.9 | 0 | 117 | 317 | 1 | 67 | XP_044163394.1 uncharacterized protein LOC122947848 [Acropora millepora] | diamond | 201 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32415228 | 32415228 | PRJNA408129_S_NODE_16979_length_188_cov_2.463576_g16961_i0 | PRJNA408129 | 16979 | 188 | 2.463576 | 4.63152288 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 65.1 | 2.33e-10 | NR | XP_066919861.1 | 252671 | g16961 | i0 | 52.6 | 1.81914893617021 | 57 | 27 | 91 | 0 | 15 | 185 | 547 | 603 | XP_066919861.1 NADPH-dependent diflavin oxidoreductase 1-like [Clytia hemisphaerica] | diamond | 342 | 65.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);;