contig_metadata
21 rows where bioproject = "PRJNA716463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3259654 | 3259654 | PRJNA716463_P_NODE_6723_length_426_cov_9.334278_g6311_i0 | PRJNA716463 | 6723 | 426 | 9.334278 | 39.76402428 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 129 | 1.3099999999999998e-31 | NR | PFX23400.1 | 50429 | g6311 | i0 | 75.5 | 0.661971830985915 | 94 | 23 | 66.2 | 0 | 2 | 283 | 458 | 551 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 282 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 9637295 | 9637295 | PRJNA716463_P_NODE_95868_length_255_cov_1.917582_g95451_i0 | PRJNA716463 | 95868 | 255 | 1.917582 | 4.8898341 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g95451 | i0 | 100 | 0.43921568627451 | 28 | 0 | 11 | 0 | 12 | 39 | 15962562 | 15962589 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 22385156 | 22385156 | PRJNA716463_P_NODE_2598_length_588_cov_3.988350_g2215_i0 | PRJNA716463 | 2598 | 588 | 3.98835 | 23.451498 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 128 | 1.2e-30 | NR | PFX23400.1 | 50429 | g2215 | i0 | 70.4 | 0.551020408163265 | 108 | 32 | 55.1 | 0 | 584 | 261 | 444 | 551 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 324 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 26735030 | 26735030 | PRJNA716463_P_NODE_11521_length_350_cov_4.429603_g11106_i0 | PRJNA716463 | 11521 | 350 | 4.429603 | 15.5036105 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 150 | 7.21e-40 | NR | PFX23400.1 | 50429 | g11106 | i0 | 77.3 | 1.02 | 119 | 24 | 99.4 | 1 | 3 | 350 | 410 | 528 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 357 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27336619 | 27336619 | PRJNA716463_P_NODE_7043_length_420_cov_4.170029_g6631_i0 | PRJNA716463 | 7043 | 420 | 4.170029 | 17.5141218 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 87.8 | 4.49e-17 | NR | PFX23400.1 | 50429 | g6631 | i0 | 89.8 | 0.35 | 49 | 5 | 35 | 0 | 418 | 272 | 417 | 465 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 147 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27652446 | 27652446 | PRJNA716463_P_NODE_7904_length_404_cov_3.341390_g7491_i0 | PRJNA716463 | 7904 | 404 | 3.34139 | 13.4992156 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 124 | 6.32e-30 | NR | PFX23400.1 | 50429 | g7491 | i0 | 74.4 | 0.668316831683168 | 90 | 23 | 66.8 | 0 | 325 | 56 | 458 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 270 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28346860 | 28346860 | PRJNA716463_P_NODE_42986_length_296_cov_3.901345_g42569_i0 | PRJNA716463 | 42986 | 296 | 3.901345 | 11.5479812 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 80.1 | 5.13e-15 | NR | PFX23400.1 | 50429 | g42569 | i0 | 82.4 | 0.516891891891892 | 51 | 9 | 51.7 | 0 | 1 | 153 | 486 | 536 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 153 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28725785 | 28725785 | PRJNA716463_P_NODE_59347_length_284_cov_2.023697_g58930_i0 | PRJNA716463 | 59347 | 284 | 2.023697 | 5.74729948 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 88.2 | 6.35e-18 | NR | PFX23400.1 | 50429 | g58930 | i0 | 77.4 | 0.654929577464789 | 62 | 14 | 65.5 | 0 | 2 | 187 | 486 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 186 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28947050 | 28947050 | PRJNA716463_P_NODE_55628_length_286_cov_7.694836_g55211_i0 | PRJNA716463 | 55628 | 286 | 7.694836 | 22.00723096 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 70.5 | 1.1e-11 | NR | PFX23400.1 | 50429 | g55211 | i0 | 60.6 | 0.692307692307692 | 66 | 26 | 69.2 | 0 | 285 | 88 | 486 | 551 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 198 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29041712 | 29041712 | PRJNA716463_P_NODE_1788_length_683_cov_7.765574_g1133_i1 | PRJNA716463 | 1788 | 683 | 7.765574 | 53.03887042 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 97.4 | 2.9e-19 | NR | PFX23400.1 | 50429 | g1133 | i1 | 81 | 0.276720351390922 | 63 | 12 | 27.7 | 0 | 335 | 523 | 474 | 536 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 189 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29451643 | 29451643 | PRJNA716463_P_NODE_1490_length_735_cov_7.592145_g1133_i0 | PRJNA716463 | 1490 | 735 | 7.592145 | 55.80226575 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 72.4 | 1.65e-10 | NR | PFX23400.1 | 50429 | g1133 | i0 | 75.5 | 0.216326530612245 | 53 | 13 | 21.6 | 0 | 335 | 493 | 474 | 526 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 159 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29988861 | 29988861 | PRJNA716463_P_NODE_2791_length_571_cov_9.202811_g1133_i3 | PRJNA716463 | 2791 | 571 | 9.202811 | 52.54805081 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 102 | 1.33e-21 | NR | PFX23400.1 | 50429 | g1133 | i3 | 73 | 0.388791593695271 | 74 | 20 | 38.9 | 0 | 335 | 556 | 474 | 547 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 222 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30336750 | 30336750 | PRJNA716463_P_NODE_100752_length_250_cov_4.158192_g100335_i0 | PRJNA716463 | 100752 | 250 | 4.158192 | 10.39548 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 113 | 6.050000000000001e-27 | NR | PFX23400.1 | 50429 | g100335 | i0 | 69.8 | 1.032 | 86 | 23 | 99.6 | 1 | 249 | 1 | 478 | 563 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 258 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30378856 | 30378856 | PRJNA716463_P_NODE_122152_length_222_cov_5.879195_g121734_i0 | PRJNA716463 | 122152 | 222 | 5.879195 | 13.0518129 | root | 1 | Root_unresolved | Root_unresolved | 120 | 1.03e-29 | NR | PFX23400.1 | 50429 | g121734 | i0 | 87.8 | 1.98648648648649 | 74 | 9 | 100 | 0 | 222 | 1 | 399 | 472 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 441 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30715457 | 30715457 | PRJNA716463_P_NODE_76534_length_271_cov_2.474747_g76117_i0 | PRJNA716463 | 76534 | 271 | 2.474747 | 6.70656437 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 132 | 7.3299999999999985e-34 | NR | PFX23400.1 | 50429 | g76117 | i0 | 82 | 0.985239852398524 | 89 | 16 | 98.5 | 0 | 2 | 268 | 451 | 539 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 267 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30842003 | 30842003 | PRJNA716463_P_NODE_8454_length_394_cov_4.517134_g8041_i0 | PRJNA716463 | 8454 | 394 | 4.517134 | 17.79750796 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 84.3 | 5.57e-16 | NR | PFX23400.1 | 50429 | g8041 | i0 | 68.1 | 0.548223350253807 | 72 | 23 | 54.8 | 0 | 217 | 2 | 459 | 530 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 216 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31157520 | 31157520 | PRJNA716463_P_NODE_56555_length_286_cov_1.981221_g56138_i0 | PRJNA716463 | 56555 | 286 | 1.981221 | 5.66629206 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 72 | 3.24e-12 | NR | CAB4008471.1 | 317549 | g56138 | i0 | 54.7 | 0.786713286713287 | 75 | 30 | 78.7 | 2 | 267 | 43 | 610 | 680 | CAB4008471.1 ephrin type-A receptor 4-like [Paramuricea clavata] | diamond | 225 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 32423213 | 32423213 | PRJNA716463_P_NODE_2639_length_584_cov_5.013699_g2254_i0 | PRJNA716463 | 2639 | 584 | 5.013699 | 29.28000216 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 128 | 1.16e-30 | NR | PFX23400.1 | 50429 | g2254 | i0 | 86.1 | 0.405821917808219 | 79 | 11 | 40.6 | 0 | 189 | 425 | 457 | 535 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 237 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32644015 | 32644015 | PRJNA716463_P_NODE_84400_length_265_cov_2.052083_g83983_i0 | PRJNA716463 | 84400 | 265 | 2.052083 | 5.43801995 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 150 | 2.32e-40 | NR | PFX23400.1 | 50429 | g83983 | i0 | 88.6 | 0.99622641509434 | 88 | 10 | 99.6 | 0 | 1 | 264 | 440 | 527 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 264 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32707211 | 32707211 | PRJNA716463_P_NODE_8000_length_402_cov_5.799392_g7587_i0 | PRJNA716463 | 8000 | 402 | 5.799392 | 23.31355584 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 121 | 5.599999999999998e-29 | NR | PFX23400.1 | 50429 | g7587 | i0 | 54.7 | 1.1044776119403 | 148 | 36 | 91.8 | 3 | 2 | 370 | 433 | 574 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 444 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32864661 | 32864661 | PRJNA716463_P_NODE_2120_length_637_cov_10.159574_g1745_i0 | PRJNA716463 | 2120 | 637 | 10.159574 | 64.71648638 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 97.8 | 1.37e-19 | NR | PFX23400.1 | 50429 | g1745 | i0 | 68.2 | 0.400313971742543 | 85 | 27 | 40 | 0 | 407 | 153 | 318 | 402 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 255 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata |
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);;