contig_metadata
18 rows where bioproject = "PRJNA1126198", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5384365 | 5384365 | PRJNA1126198_P_NODE_197905_length_293_cov_1.754545_g197185_i0 | PRJNA1126198 | 197905 | 293 | 1.754545 | 5.14081685 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2519013294|ref|XM_057458058.1| | 13093 | g197185 | i0 | 100 | 0.296928327645051 | 29 | 0 | 10 | 0 | 136 | 164 | 5596 | 5568 | PREDICTED: Hydractinia symbiolongicarpus dedicator of cytokinesis protein 1-like (LOC130655320), transcript variant X2, mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 7408099 | 7408099 | PRJNA1126198_P_NODE_19426_length_496_cov_6.919622_g18732_i0 | PRJNA1126198 | 19426 | 496 | 6.919622 | 34.32132512 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 132 | 7.11e-36 | NR | XP_046849006.1 | 2897299 | g18732 | i0 | 52 | 2.51612903225806 | 148 | 66 | 89.5 | 1 | 27 | 470 | 1 | 143 | XP_046849006.1 60S ribosomal protein L24-like [Xenia sp. Carnegie-2017] | diamond | 1248 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 10484534 | 10484534 | PRJNA1126198_P_NODE_10409_length_587_cov_2.838521_g9740_i0 | PRJNA1126198 | 10409 | 587 | 2.838521 | 16.66211827 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 220 | 2.23e-70 | NR | XP_028410526.1 | 151771 | g9740 | i0 | 75 | 3.74105621805792 | 148 | 35 | 74.6 | 1 | 585 | 148 | 1 | 148 | XP_028410526.1 60S ribosomal protein L27a-like [Dendronephthya gigantea] | diamond | 2196 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 11760298 | 11760298 | PRJNA1126198_P_NODE_438090_length_245_cov_0.901163_g437369_i0 | PRJNA1126198 | 438090 | 245 | 0.901163 | 2.20784935 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940720|emb|OZ237562.1| | 6108 | g437369 | i0 | 100 | 0.828571428571429 | 30 | 0 | 12 | 0 | 5 | 34 | 14348385 | 14348356 | Anemonia sulcata genome assembly, chromosome: 8 | blastn | 203 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 16858992 | 16858992 | PRJNA1126198_P_NODE_467674_length_242_cov_0.923077_g466953_i0 | PRJNA1126198 | 467674 | 242 | 0.923077 | 2.23384634 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1176089270|ref|XM_020759344.1| | 48498 | g466953 | i0 | 94.595 | 0.735537190082645 | 37 | 0 | 14 | 2 | 86 | 120 | 2162 | 2126 | PREDICTED: Orbicella faveolata uncharacterized LOC110053151 (LOC110053151), mRNA | blastn | 178 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19407676 | 19407676 | PRJNA1126198_P_NODE_484356_length_232_cov_3.547170_g483635_i0 | PRJNA1126198 | 484356 | 232 | 3.54717 | 8.2294344 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 121 | 5.61e-23 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g483635 | i0 | 86.486 | 49.5862068965517 | 111 | 13 | 48 | 2 | 1 | 111 | 341 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 11504 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 21432098 | 21432098 | PRJNA1126198_P_NODE_12757_length_554_cov_1.199584_g12077_i0 | PRJNA1126198 | 12757 | 554 | 1.199584 | 6.64569536 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 242 | 3.81e-74 | NR | XP_028395867.1 | 151771 | g12077 | i0 | 61.4 | 1.9927797833935 | 184 | 71 | 99.6 | 0 | 554 | 3 | 274 | 457 | XP_028395867.1 serine palmitoyltransferase 2-like [Dendronephthya gigantea] | diamond | 1104 | 242 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27133093 | 27133093 | PRJNA1126198_P_NODE_140322_length_318_cov_1.265306_g139603_i0 | PRJNA1126198 | 140322 | 318 | 1.265306 | 4.02367308 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 43.5 | 0.0358 | NR | XP_028514195.1 | 2652724 | g139603 | i0 | 33.9 | 1.11320754716981 | 59 | 37 | 55.7 | 1 | 106 | 282 | 3 | 59 | XP_028514195.1 uncharacterized protein LOC114574810 [Exaiptasia diaphana] | diamond | 354 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27344132 | 27344132 | PRJNA1126198_P_NODE_87843_length_352_cov_1.677419_g87125_i0 | PRJNA1126198 | 87843 | 352 | 1.677419 | 5.90451488 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 127 | 2.1699999999999997e-31 | NR | XP_031570598.1 | 6105 | g87125 | i0 | 53 | 48.8693181818182 | 117 | 55 | 99.7 | 0 | 1 | 351 | 242 | 358 | XP_031570598.1 methylenetetrahydrofolate reductase-like isoform X1 [Actinia tenebrosa] | diamond | 17202 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28322645 | 28322645 | PRJNA1126198_P_NODE_278106_length_271_cov_1.272727_g277385_i0 | PRJNA1126198 | 278106 | 271 | 1.272727 | 3.44909017 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 135 | 8.809999999999999e-38 | NR | XP_029195686.1 | 45264 | g277385 | i0 | 68.9 | 13.8929889298893 | 90 | 28 | 99.6 | 0 | 271 | 2 | 15 | 104 | XP_029195686.1 60S ribosomal protein L19-like [Acropora millepora] | diamond | 3765 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28575254 | 28575254 | PRJNA1126198_P_NODE_3547_length_958_cov_5.209040_g3043_i0 | PRJNA1126198 | 3547 | 958 | 5.20904 | 49.9026032 | Anthoathecata | 406427 | Cnidaria | other_Eukaryota | 82 | 3.16e-14 | NR | XP_004207962.1 | 6087 | g3043 | i0 | 26.7 | 2.32985386221294 | 172 | 121 | 52.9 | 3 | 294 | 800 | 23 | 192 | XP_004207962.1 bactericidal permeability-increasing protein [Hydra vulgaris] | diamond | 2232 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28712530 | 28712530 | PRJNA1126198_P_NODE_101287_length_342_cov_0.925651_g100568_i0 | PRJNA1126198 | 101287 | 342 | 0.925651 | 3.16572642 | Aurelia sp. KA-2 | 3229085 | Cnidaria | other_Eukaryota | 212 | 4.51e-63 | NR | BBE28384.1 | 2212398 | g100568 | i0 | 89.4 | 22.7982456140351 | 113 | 12 | 99.1 | 0 | 2 | 340 | 108 | 220 | BBE28384.1 GTP-binding protein [Aurelia sp. KA-2018] | diamond | 7797 | 212 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Semaeostomeae | Ulmaridae | Aurelia | Aurelia sp. KA-2018 | |
| 29112177 | 29112177 | PRJNA1126198_P_NODE_215268_length_288_cov_1.088372_g214547_i0 | PRJNA1126198 | 215268 | 288 | 1.088372 | 3.13451136 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 69.7 | 2.04e-11 | NR | XP_027037040.1 | 46731 | g214547 | i0 | 42.5 | 11.9583333333333 | 73 | 41 | 75 | 1 | 70 | 285 | 250 | 322 | XP_027037040.1 P2X purinoceptor 4-like [Pocillopora damicornis] | diamond | 3444 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 29743292 | 29743292 | PRJNA1126198_P_NODE_297330_length_266_cov_1.616580_g296609_i0 | PRJNA1126198 | 297330 | 266 | 1.61658 | 4.3001028 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 1.28e-39 | NR | XP_031556809.1 | 6105 | g296609 | i0 | 79.3 | 4.89473684210526 | 87 | 18 | 98.1 | 0 | 266 | 6 | 748 | 834 | XP_031556809.1 dihydropyrimidine dehydrogenase [NADP(+)]-like [Actinia tenebrosa] | diamond | 1302 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29869872 | 29869872 | PRJNA1126198_P_NODE_493851_length_220_cov_4.231293_g493129_i0 | PRJNA1126198 | 493851 | 220 | 4.231293 | 9.3088446 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 57.4 | 1.95e-7 | NR | CAH3122183.1 | 104759 | g493129 | i0 | 57.8 | 5.97272727272727 | 45 | 17 | 58.6 | 1 | 85 | 213 | 642 | 686 | CAH3122183.1 unnamed protein product [Porites lobata] | diamond | 1314 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29880942 | 29880942 | PRJNA1126198_P_NODE_9111_length_614_cov_1.380776_g8448_i0 | PRJNA1126198 | 9111 | 614 | 1.380776 | 8.47796464 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 49.3 | 0.00348 | NR | XP_028407573.1 | 151771 | g8448 | i0 | 29.7 | 0.674267100977199 | 138 | 95 | 67.4 | 2 | 558 | 145 | 110 | 245 | XP_028407573.1 transmembrane protein 198-like isoform X2 [Dendronephthya gigantea] | diamond | 414 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30880840 | 30880840 | PRJNA1126198_P_NODE_12874_length_552_cov_5.574113_g12194_i0 | PRJNA1126198 | 12874 | 552 | 5.574113 | 30.76910376 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 175 | 2.41e-52 | NR | XP_057307393.1 | 13093 | g12194 | i0 | 61.8 | 14.75 | 144 | 55 | 78.3 | 0 | 540 | 109 | 25 | 168 | XP_057307393.1 40S ribosomal protein S15-like [Hydractinia symbiolongicarpus] | diamond | 8142 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32283563 | 32283563 | PRJNA1126198_P_NODE_465479_length_242_cov_1.443787_g464758_i0 | PRJNA1126198 | 465479 | 242 | 1.443787 | 3.49396454 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 89.7 | 1.06e-18 | NR | XP_032229762.2 | 45351 | g464758 | i0 | 62 | 0.979338842975207 | 79 | 28 | 96.7 | 2 | 3 | 236 | 477 | 554 | XP_032229762.2 nucleolar RNA helicase 2 [Nematostella vectensis] | diamond | 237 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis |
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);;