contig_metadata
26 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153581 | 153581 | PRJNA1005695_P_NODE_3361_length_873_cov_4.616250_g2730_i0 | PRJNA1005695 | 3361 | 873 | 4.61625 | 40.2998625 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 535 | 1.6399999999999992e-182 | NR | KAK2573715.1 | 6130 | g2730 | i0 | 95.1 | 148.515463917526 | 268 | 13 | 92.1 | 0 | 69 | 872 | 431 | 698 | KAK2573715.1 Tubulin beta chain [Acropora cervicornis] | diamond | 129654 | 540 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 7806233 | 7806233 | PRJNA1005695_P_NODE_6387_length_623_cov_4.034545_g5561_i0 | PRJNA1005695 | 6387 | 623 | 4.034545 | 25.13521535 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.017 | NTclustered | gi|2744889029|ref|XM_065810454.1| | 6087 | g5561 | i0 | 100 | 0.0930979133226324 | 29 | 0 | 5 | 0 | 381 | 409 | 2276 | 2248 | PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 14182301 | 14182301 | PRJNA1005695_P_NODE_38252_length_245_cov_2.500000_g37400_i0 | PRJNA1005695 | 38252 | 245 | 2.5 | 6.125 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 180 | 9.72e-41 | NTclustered | gi|2202634487|ref|XM_046993075.1| | 2897299 | g37400 | i0 | 81.448 | 33.6285714285714 | 221 | 39 | 91 | 1 | 1 | 219 | 917 | 1137 | PREDICTED: Xenia sp. Carnegie-2017 polyubiquitin (LOC124442587), mRNA | blastn | 8239 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15456160 | 15456160 | PRJNA1005695_P_NODE_27713_length_284_cov_1.478673_g26861_i0 | PRJNA1005695 | 27713 | 284 | 1.478673 | 4.19943132 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 124 | 9.61e-31 | NR | RMX41568.1 | 46731 | g26861 | i0 | 64.4 | 12.4225352112676 | 90 | 32 | 95.1 | 0 | 271 | 2 | 405 | 494 | RMX41568.1 hypothetical protein pdam_00008636 [Pocillopora damicornis] | diamond | 3528 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 20554652 | 20554652 | PRJNA1005695_P_NODE_22557_length_316_cov_1.810700_g21705_i0 | PRJNA1005695 | 22557 | 316 | 1.8107 | 5.721812 | Clytia sp. 3 AFC-2016 | 1886627 | Cnidaria | other_Eukaryota | 80.5 | 1.36e-10 | NTclustered | gi|1069323992|gb|KX665509.1| | 1886627 | g21705 | i0 | 78.169 | 14.7753164556962 | 142 | 20 | 42 | 10 | 179 | 312 | 1735 | 1597 | Clytia sp. 3 AFC-2016 voucher MZUSP:2801 28S ribosomal RNA gene, partial sequence | blastn | 4669 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia sp. 3 AFC-2016 | |
| 23105638 | 23105638 | PRJNA1005695_P_NODE_13759_length_412_cov_2.250737_g12907_i0 | PRJNA1005695 | 13759 | 412 | 2.250737 | 9.27303644 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 158 | 1.26e-44 | NR | XP_065066472.1 | 499914 | g12907 | i0 | 67.9 | 21.6917475728155 | 112 | 35 | 80.8 | 1 | 3 | 335 | 113 | 224 | XP_065066472.1 small ribosomal subunit protein uS2-like [Rhopilema esculentum] | diamond | 8937 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27097636 | 27097636 | PRJNA1005695_P_NODE_26302_length_292_cov_1.214612_g25450_i0 | PRJNA1005695 | 26302 | 292 | 1.214612 | 3.54666704 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 66.6 | 2.71e-10 | NR | XP_068694517.1 | 591990 | g25450 | i0 | 57.8 | 0.934931506849315 | 45 | 19 | 46.2 | 0 | 2 | 136 | 353 | 397 | XP_068694517.1 fibropellin-1-like [Montipora foliosa] | diamond | 273 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 27184895 | 27184895 | PRJNA1005695_P_NODE_30462_length_270_cov_2.375635_g29610_i0 | PRJNA1005695 | 30462 | 270 | 2.375635 | 6.4142145 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 69.7 | 8.03e-13 | NR | XP_031572029.1 | 6105 | g29610 | i0 | 57.4 | 1.42222222222222 | 61 | 24 | 67.8 | 1 | 268 | 86 | 66 | 124 | XP_031572029.1 keratinocyte-associated protein 2-like [Actinia tenebrosa] | diamond | 384 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27255679 | 27255679 | PRJNA1005695_P_NODE_32383_length_262_cov_1.587302_g31531_i0 | PRJNA1005695 | 32383 | 262 | 1.587302 | 4.15873124 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 43.9 | 0.0193 | NR | XP_031571620.1 | 6105 | g31531 | i0 | 32.5 | 0.881679389312977 | 77 | 45 | 80.2 | 2 | 259 | 50 | 837 | 913 | XP_031571620.1 5'-3' exoribonuclease 1-like [Actinia tenebrosa] | diamond | 231 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27311738 | 27311738 | PRJNA1005695_P_NODE_6803_length_602_cov_3.332703_g5972_i0 | PRJNA1005695 | 6803 | 602 | 3.332703 | 20.06287206 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 122 | 2.7000000000000003e-28 | NR | XP_065051037.1 | 499914 | g5972 | i0 | 50.8 | 3.12956810631229 | 120 | 52 | 59.8 | 1 | 550 | 191 | 571 | 683 | XP_065051037.1 serine/arginine repetitive matrix protein 2-like [Rhopilema esculentum] | diamond | 1884 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27350830 | 27350830 | PRJNA1005695_P_NODE_35683_length_251_cov_0.876404_g34831_i0 | PRJNA1005695 | 35683 | 251 | 0.876404 | 2.19977404 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 86.7 | 1.46e-17 | NR | XP_057307799.1 | 13093 | g34831 | i0 | 53.4 | 1.76892430278884 | 73 | 34 | 87.3 | 0 | 26 | 244 | 213 | 285 | XP_057307799.1 serine/threonine-protein kinase 10-like [Hydractinia symbiolongicarpus] | diamond | 444 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 27603386 | 27603386 | PRJNA1005695_P_NODE_27204_length_287_cov_0.962617_g26352_i0 | PRJNA1005695 | 27204 | 287 | 0.962617 | 2.76271079 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 81.6 | 1.31e-15 | NR | CAB4018530.1 | 317549 | g26352 | i0 | 50 | 4.26480836236934 | 80 | 40 | 83.6 | 0 | 244 | 5 | 415 | 494 | CAB4018530.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 1224 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28076690 | 28076690 | PRJNA1005695_P_NODE_33145_length_259_cov_1.161290_g32293_i0 | PRJNA1005695 | 33145 | 259 | 1.16129 | 3.0077411 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 55.8 | 1.09e-6 | NR | CAH3036359.1 | 104759 | g32293 | i0 | 41.9 | 3.91505791505792 | 74 | 39 | 81.1 | 1 | 4 | 213 | 277 | 350 | CAH3036359.1 unnamed protein product [Porites lobata] | diamond | 1014 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 28226935 | 28226935 | PRJNA1005695_P_NODE_31406_length_266_cov_2.020725_g30554_i0 | PRJNA1005695 | 31406 | 266 | 2.020725 | 5.3751285 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 159 | 5.3899999999999985e-43 | NR | XP_065666900.1 | 6087 | g30554 | i0 | 77.3 | 3.96992481203007 | 88 | 20 | 99.2 | 0 | 264 | 1 | 644 | 731 | XP_065666900.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3B isoform X2 [Hydra vulgaris] | diamond | 1056 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28424243 | 28424243 | PRJNA1005695_P_NODE_25006_length_300_cov_1.634361_g24154_i0 | PRJNA1005695 | 25006 | 300 | 1.634361 | 4.903083 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 110 | 1.66e-25 | NR | KXJ05542.1 | 2652724 | g24154 | i0 | 49.5 | 0.99 | 99 | 50 | 99 | 0 | 297 | 1 | 29 | 127 | KXJ05542.1 Retrovirus-related Pol polyprotein from transposon 297, partial [Exaiptasia diaphana] | diamond | 297 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 29426801 | 29426801 | PRJNA1005695_P_NODE_28889_length_278_cov_1.521951_g28037_i0 | PRJNA1005695 | 28889 | 278 | 1.521951 | 4.23102378 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 43.1 | 0.0429 | NR | XP_057292051.1 | 13093 | g28037 | i0 | 36.5 | 1.06834532374101 | 52 | 33 | 56.1 | 0 | 276 | 121 | 262 | 313 | XP_057292051.1 uncharacterized protein LOC130614634 [Hydractinia symbiolongicarpus] | diamond | 297 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29869116 | 29869116 | PRJNA1005695_P_NODE_35011_length_252_cov_1.385475_g34159_i0 | PRJNA1005695 | 35011 | 252 | 1.385475 | 3.491397 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 139 | 1.4399999999999998e-37 | NR | KAK2570543.1 | 6130 | g34159 | i0 | 72.3 | 25.6904761904762 | 83 | 23 | 98.8 | 0 | 251 | 3 | 275 | 357 | KAK2570543.1 Histone-binding protein RBBP7 [Acropora cervicornis] | diamond | 6474 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30192385 | 30192385 | PRJNA1005695_P_NODE_33472_length_257_cov_2.391304_g32620_i0 | PRJNA1005695 | 33472 | 257 | 2.391304 | 6.14565128 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 53.5 | 6.75e-6 | NR | XP_066912682.1 | 252671 | g32620 | i0 | 41.4 | 0.67704280155642 | 58 | 30 | 67.7 | 2 | 182 | 9 | 95 | 148 | XP_066912682.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 174 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30508422 | 30508422 | PRJNA1005695_P_NODE_10013_length_491_cov_1.818182_g9162_i0 | PRJNA1005695 | 10013 | 491 | 1.818182 | 8.92727362 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 58.9 | 1.16e-6 | NR | XP_047145869.1 | 6087 | g9162 | i0 | 33.7 | 2.4989816700611 | 98 | 58 | 59.3 | 3 | 485 | 195 | 893 | 984 | XP_047145869.1 neurogenic locus notch homolog protein 2 isoform X2 [Hydra vulgaris] | diamond | 1227 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30508443 | 30508443 | PRJNA1005695_P_NODE_24693_length_302_cov_1.646288_g23841_i0 | PRJNA1005695 | 24693 | 302 | 1.646288 | 4.97178976 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 45.4 | 0.00835 | NR | EDO48633.1 | 45351 | g23841 | i0 | 32.9 | 0.844370860927152 | 85 | 52 | 83.4 | 2 | 261 | 10 | 394 | 474 | EDO48633.1 predicted protein, partial [Nematostella vectensis] | diamond | 255 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30571373 | 30571373 | PRJNA1005695_P_NODE_27293_length_286_cov_1.877934_g26441_i0 | PRJNA1005695 | 27293 | 286 | 1.877934 | 5.37089124 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 86.7 | 6.99e-18 | NR | CAH3196460.1 | 104178 | g26441 | i0 | 51.4 | 1.51048951048951 | 72 | 35 | 75.5 | 0 | 216 | 1 | 14 | 85 | CAH3196460.1 unnamed protein product [Porites evermanni] | diamond | 432 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30753750 | 30753750 | PRJNA1005695_P_NODE_24054_length_306_cov_2.806867_g23202_i0 | PRJNA1005695 | 24054 | 306 | 2.806867 | 8.58901302 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 116 | 1.26e-27 | NR | PFX16342.1 | 50429 | g23202 | i0 | 58.5 | 6.34313725490196 | 94 | 39 | 92.2 | 0 | 303 | 22 | 494 | 587 | PFX16342.1 hypothetical protein AWC38_SpisGene19392 [Stylophora pistillata] | diamond | 1941 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30950947 | 30950947 | PRJNA1005695_P_NODE_30734_length_269_cov_1.877551_g29882_i0 | PRJNA1005695 | 30734 | 269 | 1.877551 | 5.05061219 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 43.1 | 0.0374 | NR | CAH3023949.1 | 104178 | g29882 | i0 | 34.3 | 0.780669144981413 | 70 | 46 | 78.1 | 0 | 264 | 55 | 17 | 86 | CAH3023949.1 unnamed protein product [Porites evermanni] | diamond | 210 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32279292 | 32279292 | PRJNA1005695_P_NODE_37999_length_246_cov_0.901734_g37147_i0 | PRJNA1005695 | 37999 | 246 | 0.901734 | 2.21826564 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 72.4 | 1.19e-12 | NR | XP_004207984.3 | 6087 | g37147 | i0 | 39 | 1.8780487804878 | 77 | 34 | 78 | 1 | 209 | 18 | 315 | 391 | XP_004207984.3 piggyBac transposable element-derived protein 3-like [Hydra vulgaris] | diamond | 462 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32398284 | 32398284 | PRJNA1005695_P_NODE_32639_length_261_cov_1.404255_g31787_i0 | PRJNA1005695 | 32639 | 261 | 1.404255 | 3.66510555 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 43.1 | 0.035 | NR | KAK2567278.1 | 6130 | g31787 | i0 | 37.1 | 1.96551724137931 | 89 | 49 | 94.3 | 2 | 260 | 15 | 694 | 782 | KAK2567278.1 Pre-mRNA-splicing factor SYF1 [Acropora cervicornis] | diamond | 513 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 32902632 | 32902632 | PRJNA1005695_P_NODE_31940_length_264_cov_1.476440_g31088_i0 | PRJNA1005695 | 31940 | 264 | 1.47644 | 3.8978016 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 47.4 | 0.0011 | NR | RMX48965.1 | 46731 | g31088 | i0 | 35.9 | 3.54545454545455 | 78 | 48 | 86.4 | 1 | 3 | 230 | 405 | 482 | RMX48965.1 hypothetical protein pdam_00008291 [Pocillopora damicornis] | diamond | 936 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;