contig_metadata
18 rows where bioproject = "PRJNA1108487", tax_kingdom = "Metazoa" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3571124 | 3571124 | PRJNA1108487_P_NODE_2803_length_405_cov_4.572289_g2737_i0 | PRJNA1108487 | 2803 | 405 | 4.572289 | 18.51777045 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|1834271362|ref|XM_033781777.1| | 7604 | g2737 | i0 | 96.97 | 1.77777777777778 | 33 | 0 | 8 | 1 | 373 | 405 | 3698 | 3667 | PREDICTED: Asterias rubens multidrug resistance-associated protein 5-like (LOC117298494), mRNA | blastn | 720 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 9141063 | 9141063 | PRJNA1108487_P_NODE_528_length_879_cov_15.125310_g475_i0 | PRJNA1108487 | 528 | 879 | 15.12531 | 132.9514749 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 296 | 1.9e-97 | NR | XP_030830317.1 | 7668 | g475 | i0 | 63.9 | 14.580204778157 | 238 | 83 | 80.5 | 3 | 77 | 784 | 11 | 247 | XP_030830317.1 60S ribosomal protein L7 [Strongylocentrotus purpuratus] | diamond | 12816 | 297 | 0.996632996632997 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 10416889 | 10416889 | PRJNA1108487_P_NODE_9469_length_249_cov_0.886364_g9403_i0 | PRJNA1108487 | 9469 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 156 | 5.36e-46 | NR | NP_001116984.1 | 7668 | g9403 | i0 | 93.9 | 85.9156626506024 | 82 | 5 | 98.8 | 0 | 2 | 247 | 4 | 85 | NP_001116984.1 rab11 GTPase homolog SUrab11p [Strongylocentrotus purpuratus] | diamond | 21393 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 12499416 | 12499416 | PRJNA1108487_P_NODE_11070_length_243_cov_0.917647_g11004_i0 | PRJNA1108487 | 11070 | 243 | 0.917647 | 2.22988221 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 83.6 | 8.15e-17 | NR | XP_033121718.1 | 1529436 | g11004 | i0 | 51.4 | 0.91358024691358 | 74 | 35 | 90.1 | 1 | 241 | 23 | 277 | 350 | XP_033121718.1 cAMP-dependent protein kinase catalytic subunit PRKX-like [Anneissia japonica] | diamond | 222 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26719174 | 26719174 | PRJNA1108487_P_NODE_9661_length_248_cov_0.891429_g9595_i0 | PRJNA1108487 | 9661 | 248 | 0.891429 | 2.21074392 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 45.8 | 0.00328 | NR | XP_030843226.1 | 7668 | g9595 | i0 | 47.3 | 1.33064516129032 | 55 | 28 | 66.5 | 1 | 82 | 246 | 33 | 86 | XP_030843226.1 ATP-dependent RNA helicase DDX54 [Strongylocentrotus purpuratus] | diamond | 330 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 26972712 | 26972712 | PRJNA1108487_P_NODE_10002_length_247_cov_0.896552_g9936_i0 | PRJNA1108487 | 10002 | 247 | 0.896552 | 2.21448344 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 43.9 | 0.0153 | NR | XP_038055681.1 | 46514 | g9936 | i0 | 28.6 | 1.02024291497976 | 84 | 52 | 92.3 | 2 | 4 | 231 | 436 | 519 | XP_038055681.1 spartin-like [Patiria miniata] | diamond | 252 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27059019 | 27059019 | PRJNA1108487_P_NODE_8722_length_252_cov_0.871508_g8656_i0 | PRJNA1108487 | 8722 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 51.6 | 3.35e-5 | NR | XP_071490410.1 | 105358 | g8656 | i0 | 49.1 | 5.02380952380952 | 55 | 28 | 65.5 | 0 | 231 | 67 | 6778 | 6832 | XP_071490410.1 uncharacterized protein [Diadema antillarum] | diamond | 1266 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27627863 | 27627863 | PRJNA1108487_P_NODE_5384_length_306_cov_1.339056_g5318_i0 | PRJNA1108487 | 5384 | 306 | 1.339056 | 4.09751136 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 110 | 1.24e-25 | NR | KAJ8047707.1 | 206669 | g5318 | i0 | 59.3 | 1.90196078431373 | 91 | 34 | 89.2 | 2 | 274 | 2 | 233 | 320 | KAJ8047707.1 Protein DD3-3 [Holothuria leucospilota] | diamond | 582 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28385431 | 28385431 | PRJNA1108487_P_NODE_2326_length_445_cov_1.887097_g2260_i0 | PRJNA1108487 | 2326 | 445 | 1.887097 | 8.39758165 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 61.6 | 6.39e-8 | NR | XP_038076121.1 | 46514 | g2260 | i0 | 32 | 4.17303370786517 | 150 | 83 | 97.8 | 6 | 436 | 2 | 161 | 296 | XP_038076121.1 procathepsin L-like [Patiria miniata] | diamond | 1857 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28425876 | 28425876 | PRJNA1108487_P_NODE_4446_length_331_cov_1.209302_g4380_i0 | PRJNA1108487 | 4446 | 331 | 1.209302 | 4.00278962 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 45.1 | 0.0152 | NR | XP_033108530.1 | 1529436 | g4380 | i0 | 31.6 | 2.47432024169184 | 76 | 52 | 68.9 | 0 | 71 | 298 | 362 | 437 | XP_033108530.1 solute carrier family 43 member 3-like isoform X1 [Anneissia japonica] | diamond | 819 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29269304 | 29269304 | PRJNA1108487_P_NODE_4309_length_335_cov_2.011450_g4243_i0 | PRJNA1108487 | 4309 | 335 | 2.01145 | 6.7383575 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 102 | 4.959999999999999e-23 | NR | XP_033647761.1 | 7604 | g4243 | i0 | 44.1 | 3.01791044776119 | 111 | 57 | 99.4 | 2 | 334 | 2 | 301 | 406 | XP_033647761.1 dipeptidyl peptidase 1-like [Asterias rubens] | diamond | 1011 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29341496 | 29341496 | PRJNA1108487_P_NODE_9149_length_250_cov_0.881356_g9083_i0 | PRJNA1108487 | 9149 | 250 | 0.881356 | 2.20339 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 64.7 | 1.62e-10 | NR | XP_038052086.1 | 46514 | g9083 | i0 | 41.8 | 1.548 | 67 | 37 | 80.4 | 1 | 1 | 201 | 97 | 161 | XP_038052086.1 protein cereblon-like [Patiria miniata] | diamond | 387 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29814912 | 29814912 | PRJNA1108487_P_NODE_3751_length_356_cov_1.102473_g3685_i0 | PRJNA1108487 | 3751 | 356 | 1.102473 | 3.92480388 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 70.1 | 3.77e-11 | NR | XP_033637046.1 | 7604 | g3685 | i0 | 38 | 1.82022471910112 | 108 | 58 | 89.3 | 5 | 335 | 18 | 1852 | 1952 | XP_033637046.1 sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like isoform X1 [Asterias rubens] | diamond | 648 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29878308 | 29878308 | PRJNA1108487_P_NODE_10471_length_245_cov_0.906977_g10405_i0 | PRJNA1108487 | 10471 | 245 | 0.906977 | 2.22209365 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 50.4 | 7.19e-5 | NR | XP_071476231.1 | 105358 | g10405 | i0 | 46.7 | 0.73469387755102 | 60 | 31 | 72.2 | 1 | 180 | 4 | 68 | 127 | XP_071476231.1 leucine-rich repeat-containing protein 27-like [Diadema antillarum] | diamond | 180 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29909937 | 29909937 | PRJNA1108487_P_NODE_5911_length_293_cov_2.481818_g5845_i0 | PRJNA1108487 | 5911 | 293 | 2.481818 | 7.27172674 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 89.4 | 1.62e-18 | NR | XP_033119996.1 | 1529436 | g5845 | i0 | 62.1 | 5.2320819112628 | 66 | 22 | 64.5 | 1 | 293 | 105 | 322 | 387 | XP_033119996.1 cathepsin D-like [Anneissia japonica] | diamond | 1533 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29972947 | 29972947 | PRJNA1108487_P_NODE_7111_length_271_cov_1.575758_g7045_i0 | PRJNA1108487 | 7111 | 271 | 1.575758 | 4.27030418 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 61.2 | 1.71e-8 | NR | KAJ8019604.1 | 206669 | g7045 | i0 | 50.8 | 0.653136531365314 | 59 | 29 | 65.3 | 0 | 202 | 26 | 6 | 64 | KAJ8019604.1 Myosin light chain kinase, smooth muscle [Holothuria leucospilota] | diamond | 177 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30510023 | 30510023 | PRJNA1108487_P_NODE_10713_length_244_cov_0.912281_g10647_i0 | PRJNA1108487 | 10713 | 244 | 0.912281 | 2.22596564 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 87 | 9.89e-18 | NR | XP_071492197.1 | 105358 | g10647 | i0 | 60.6 | 0.872950819672131 | 71 | 27 | 87.3 | 1 | 31 | 243 | 443 | 512 | XP_071492197.1 probable phospholipid-transporting ATPase IA [Diadema antillarum] | diamond | 213 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30722391 | 30722391 | PRJNA1108487_P_NODE_10934_length_243_cov_0.917647_g10868_i0 | PRJNA1108487 | 10934 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 5.66e-38 | NR | XP_030842170.1 | 7668 | g10868 | i0 | 87.5 | 19.7530864197531 | 80 | 10 | 98.8 | 0 | 242 | 3 | 472 | 551 | XP_030842170.1 fidgetin-like protein 1 [Strongylocentrotus purpuratus] | diamond | 4800 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;