contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA448207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5542777 | 5542777 | PRJNA448207_S_NODE_2545_length_286_cov_1.079812_g2534_i0 | PRJNA448207 | 2545 | 286 | 1.079812 | 3.08826232 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 144 | 2.62e-40 | NR | KAJ7325621.1 | 174260 | g2534 | i0 | 66.3 | 15.9545454545455 | 95 | 31 | 99.7 | 1 | 286 | 2 | 109 | 202 | KAJ7325621.1 Thioredoxin reductase 2, mitochondrial [Desmophyllum pertusum] | diamond | 4563 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 26632867 | 26632867 | PRJNA448207_P_NODE_21601_length_276_cov_1.650246_g21438_i0 | PRJNA448207 | 21601 | 276 | 1.650246 | 4.55467896 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 85.9 | 3.67e-17 | NR | KAK3752022.1 | 3060491 | g21438 | i0 | 45.3 | 0.934782608695652 | 86 | 43 | 89.1 | 1 | 254 | 9 | 5 | 90 | KAK3752022.1 hypothetical protein QZH41_009342 [Actinostola sp. cb2023] | diamond | 258 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 26871199 | 26871199 | PRJNA448207_S_NODE_1661_length_339_cov_1.259398_g1650_i0 | PRJNA448207 | 1661 | 339 | 1.259398 | 4.26935922 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 83.6 | 1.47e-17 | NR | XP_028395959.1 | 151771 | g1650 | i0 | 45.6 | 8.06194690265487 | 103 | 48 | 87.6 | 3 | 298 | 2 | 4 | 102 | XP_028395959.1 mitochondrial import receptor subunit TOM20 homolog [Dendronephthya gigantea] | diamond | 2733 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27850260 | 27850260 | PRJNA448207_P_NODE_11624_length_365_cov_2.510274_g11462_i0 | PRJNA448207 | 11624 | 365 | 2.510274 | 9.1625001 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 75.1 | 3.48e-14 | NR | CAH3193345.1 | 104178 | g11462 | i0 | 48.9 | 7.41369863013699 | 92 | 38 | 68.2 | 2 | 116 | 364 | 54 | 145 | CAH3193345.1 unnamed protein product [Porites evermanni] | diamond | 2706 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28276075 | 28276075 | PRJNA448207_P_NODE_27886_length_248_cov_0.880000_g27723_i0 | PRJNA448207 | 27886 | 248 | 0.88 | 2.1824 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 65.9 | 2.85e-10 | NR | XP_031556644.1 | 6105 | g27723 | i0 | 43.1 | 1.74193548387097 | 65 | 37 | 78.6 | 0 | 40 | 234 | 46 | 110 | XP_031556644.1 endothelin-converting enzyme 1-like [Actinia tenebrosa] | diamond | 432 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 28576594 | 28576594 | PRJNA448207_S_NODE_1667_length_339_cov_0.868421_g1656_i0 | PRJNA448207 | 1667 | 339 | 0.868421 | 2.94394719 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 66.6 | 4.72e-10 | NR | XP_001634017.1 | 45351 | g1656 | i0 | 41.3 | 2.02654867256637 | 75 | 42 | 64.6 | 1 | 1 | 219 | 336 | 410 | XP_001634017.1 kelch-like protein diablo [Nematostella vectensis] | diamond | 687 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28907411 | 28907411 | PRJNA448207_P_NODE_10028_length_391_cov_0.968553_g9866_i0 | PRJNA448207 | 10028 | 391 | 0.968553 | 3.78704223 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 78.6 | 6.16e-14 | NR | XP_057290680.1 | 13093 | g9866 | i0 | 51.9 | 2.18670076726343 | 133 | 60 | 99 | 3 | 387 | 1 | 255 | 387 | XP_057290680.1 protein crumbs-like [Hydractinia symbiolongicarpus] | diamond | 855 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 29097236 | 29097236 | PRJNA448207_P_NODE_33248_length_241_cov_0.916667_g33085_i0 | PRJNA448207 | 33248 | 241 | 0.916667 | 2.20916747 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 82.4 | 3.74e-17 | NR | KII75121.1 | 669202 | g33085 | i0 | 53.4 | 0.908713692946058 | 73 | 34 | 90.9 | 0 | 241 | 23 | 34 | 106 | KII75121.1 Histone H5 [Thelohanellus kitauei] | diamond | 219 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 29286443 | 29286443 | PRJNA448207_P_NODE_19489_length_291_cov_1.412844_g19326_i0 | PRJNA448207 | 19489 | 291 | 1.412844 | 4.11137604 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 69.3 | 2.95e-11 | NR | XP_022784780.1 | 50429 | g19326 | i0 | 64.1 | 2.02061855670103 | 39 | 14 | 40.2 | 0 | 287 | 171 | 707 | 745 | XP_022784780.1 endothelin-converting enzyme homolog isoform X5 [Stylophora pistillata] | diamond | 588 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29791573 | 29791573 | PRJNA448207_P_NODE_13991_length_338_cov_1.316981_g13828_i0 | PRJNA448207 | 13991 | 338 | 1.316981 | 4.45139578 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 76.6 | 9.95e-14 | NR | XP_066935725.1 | 252671 | g13828 | i0 | 43.5 | 0.816568047337278 | 92 | 51 | 80.8 | 1 | 46 | 318 | 168 | 259 | XP_066935725.1 chymotrypsinogen B-like [Clytia hemisphaerica] | diamond | 276 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30265914 | 30265914 | PRJNA448207_P_NODE_13932_length_339_cov_0.913534_g13769_i0 | PRJNA448207 | 13932 | 339 | 0.913534 | 3.09688026 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 73.2 | 1.28e-12 | NR | XP_031559674.1 | 6105 | g13769 | i0 | 30.6 | 0.982300884955752 | 111 | 76 | 97.3 | 1 | 331 | 2 | 65 | 175 | XP_031559674.1 testis-specific serine/threonine-protein kinase 3-like [Actinia tenebrosa] | diamond | 333 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30597678 | 30597678 | PRJNA448207_P_NODE_20493_length_284_cov_1.241706_g20330_i0 | PRJNA448207 | 20493 | 284 | 1.241706 | 3.52644504 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 110 | 6.9e-26 | NR | XP_028414461.1 | 151771 | g20330 | i0 | 61.1 | 4.8169014084507 | 90 | 30 | 95.1 | 2 | 273 | 4 | 17 | 101 | XP_028414461.1 protein DD3-3-like [Dendronephthya gigantea] | diamond | 1368 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30882152 | 30882152 | PRJNA448207_S_NODE_2614_length_282_cov_1.770335_g2603_i0 | PRJNA448207 | 2614 | 282 | 1.770335 | 4.9923447 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 166 | 1.5599999999999998e-45 | NR | XP_065666900.1 | 6087 | g2603 | i0 | 78.5 | 3.95744680851064 | 93 | 20 | 98.9 | 0 | 280 | 2 | 640 | 732 | XP_065666900.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3B isoform X2 [Hydra vulgaris] | diamond | 1116 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31339960 | 31339960 | PRJNA448207_P_NODE_10856_length_377_cov_1.131579_g10694_i0 | PRJNA448207 | 10856 | 377 | 1.131579 | 4.26605283 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 150 | 9.5e-40 | NR | XP_020618818.1 | 48498 | g10694 | i0 | 60 | 1.03448275862069 | 130 | 45 | 99.5 | 3 | 377 | 3 | 16 | 143 | XP_020618818.1 pre-rRNA-processing protein TSR1 homolog [Orbicella faveolata] | diamond | 390 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 31466707 | 31466707 | PRJNA448207_P_NODE_27716_length_248_cov_0.880000_g27553_i0 | PRJNA448207 | 27716 | 248 | 0.88 | 2.1824 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 98.6 | 9.03e-22 | NR | CAB4008039.1 | 317549 | g27553 | i0 | 54.2 | 1.00403225806452 | 83 | 37 | 99.2 | 1 | 2 | 247 | 88 | 170 | CAB4008039.1 Meprin A subunit beta, partial [Paramuricea clavata] | diamond | 249 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 31529932 | 31529932 | PRJNA448207_P_NODE_10996_length_375_cov_1.019868_g10834_i0 | PRJNA448207 | 10996 | 375 | 1.019868 | 3.824505 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 132 | 5.609999999999999e-35 | NR | XP_002154724.4 | 6087 | g10834 | i0 | 64.4 | 3.256 | 101 | 35 | 80.8 | 1 | 375 | 73 | 194 | 293 | XP_002154724.4 deoxyhypusine hydroxylase [Hydra vulgaris] | diamond | 1221 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31704194 | 31704194 | PRJNA448207_S_NODE_1977_length_317_cov_1.893443_g1966_i0 | PRJNA448207 | 1977 | 317 | 1.893443 | 6.00221431 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 65.5 | 9.41e-10 | NR | XP_031551489.1 | 6105 | g1966 | i0 | 50 | 8.35646687697161 | 66 | 30 | 59.6 | 1 | 129 | 317 | 351 | 416 | XP_031551489.1 coiled-coil and C2 domain-containing protein 1-like [Actinia tenebrosa] | diamond | 2649 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32352611 | 32352611 | PRJNA448207_S_NODE_2119_length_307_cov_1.461538_g2108_i0 | PRJNA448207 | 2119 | 307 | 1.461538 | 4.48692166 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 110 | 5.01e-28 | NR | XP_029186058.2 | 45264 | g2108 | i0 | 49 | 15.0586319218241 | 96 | 49 | 93.8 | 0 | 300 | 13 | 5 | 100 | XP_029186058.2 adenylate kinase isoenzyme 6-like [Acropora millepora] | diamond | 4623 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 32558714 | 32558714 | PRJNA448207_S_NODE_3639_length_247_cov_0.885057_g3628_i0 | PRJNA448207 | 3639 | 247 | 0.885057 | 2.18609079 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 68.6 | 2.03e-11 | NR | KAK2568481.1 | 6130 | g3628 | i0 | 56.5 | 3.04858299595142 | 62 | 27 | 75.3 | 0 | 50 | 235 | 203 | 264 | KAK2568481.1 Protein Hikeshi [Acropora cervicornis] | diamond | 753 | 68.9 | 0.995645863570392 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 32699613 | 32699613 | PRJNA448207_P_NODE_26400_length_250_cov_0.870056_g26237_i0 | PRJNA448207 | 26400 | 250 | 0.870056 | 2.17514 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 77.4 | 2.61e-14 | NR | KAF0989789.1 | 69463 | g26237 | i0 | 45.7 | 0.972 | 81 | 44 | 97.2 | 0 | 4 | 246 | 1318 | 1398 | KAF0989789.1 hypothetical protein HZS_6390, partial [Henneguya salminicola] | diamond | 243 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 32747412 | 32747412 | PRJNA448207_P_NODE_31400_length_243_cov_0.905882_g31237_i0 | PRJNA448207 | 31400 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 82 | 4.98e-17 | NR | XP_032240405.2 | 45351 | g31237 | i0 | 44.4 | 3.97530864197531 | 81 | 44 | 100 | 1 | 1 | 243 | 47 | 126 | XP_032240405.2 rRNA N6-adenosine-methyltransferase METTL5 [Nematostella vectensis] | diamond | 966 | 82 | 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);;