contig_metadata
15 rows where bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622768 | 622768 | PRJNA657343_P_NODE_12641_length_246_cov_1.553299_g12617_i0 | PRJNA657343 | 12641 | 246 | 1.553299 | 3.82111554 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 102 | 9.939999999999999e-24 | NR | XP_033629045.1 | 7604 | g12617 | i0 | 59.7 | 9.26829268292683 | 77 | 31 | 93.9 | 0 | 238 | 8 | 252 | 328 | XP_033629045.1 proliferation-associated protein 2G4-like [Asterias rubens] | diamond | 2280 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 14652033 | 14652033 | PRJNA657343_P_NODE_3432_length_399_cov_13.802857_g3409_i0 | PRJNA657343 | 3432 | 399 | 13.802857 | 55.07339943 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 191 | 7.429999999999999e-60 | NR | XP_041471426.1 | 7654 | g3409 | i0 | 73.2 | 10.6165413533835 | 127 | 34 | 95.5 | 0 | 387 | 7 | 10 | 136 | XP_041471426.1 40S ribosomal protein S16-like [Lytechinus variegatus] | diamond | 4236 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 22300379 | 22300379 | PRJNA657343_P_NODE_36578_length_168_cov_0.873950_g36554_i0 | PRJNA657343 | 36578 | 168 | 0.87395 | 1.468236 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 67.6 | 5.04e-7 | NTclustered | gi|1944848411|ref|XM_038193245.1| | 46514 | g36554 | i0 | 95.238 | 1.75 | 42 | 2 | 25 | 0 | 13 | 54 | 2266 | 2307 | PREDICTED: Patiria miniata tetratricopeptide repeat protein 25-like (LOC119722858), transcript variant X6, mRNA | blastn | 294 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 24850698 | 24850698 | PRJNA657343_S_NODE_620_length_614_cov_153.442478_g603_i0 | PRJNA657343 | 620 | 614 | 153.442478 | 942.13681492 | Ophiomastix wendtii | 7623 | Echinodermata | other_Eukaryota | 1044 | 0 | NTclustered | gi|401712733|gb|JX160103.1| | 7623 | g603 | i0 | 98.02 | 51.2947882736156 | 606 | 2 | 98 | 5 | 6 | 608 | 369 | 967 | Ophiocoma wendtii clone 00156 G-cadherin mRNA, partial cds | blastn | 31495 | 1044 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Ophiuroidea | Amphilepidida | Ophiocomidae | Ophiomastix | Ophiomastix wendtii | |
| 26860201 | 26860201 | PRJNA657343_P_NODE_8001_length_291_cov_1.632231_g7977_i0 | PRJNA657343 | 8001 | 291 | 1.632231 | 4.74979221 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 66.2 | 2.17e-11 | NR | XP_071479790.1 | 105358 | g7977 | i0 | 49.1 | 0.56701030927835006 | 55 | 25 | 56.7 | 1 | 5 | 169 | 77 | 128 | XP_071479790.1 NADH dehydrogenase [ubiquinone] iron-sulfur protein 6, mitochondrial-like [Diadema antillarum] | diamond | 165 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28281291 | 28281291 | PRJNA657343_P_NODE_29946_length_179_cov_1.569231_g29922_i0 | PRJNA657343 | 29946 | 179 | 1.569231 | 2.80892349 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 47.8 | 2.7e-4 | NR | XP_038065428.1 | 46514 | g29922 | i0 | 48.3 | 0.972067039106145 | 58 | 28 | 97.2 | 1 | 176 | 3 | 62 | 117 | XP_038065428.1 signal recognition particle subunit SRP72-like [Patiria miniata] | diamond | 174 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28502541 | 28502541 | PRJNA657343_P_NODE_23407_length_195_cov_2.739726_g23383_i0 | PRJNA657343 | 23407 | 195 | 2.739726 | 5.3424657 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 65.5 | 1.64e-10 | NR | XP_033100697.1 | 1529436 | g23383 | i0 | 51.7 | 3.63076923076923 | 58 | 28 | 89.2 | 0 | 194 | 21 | 271 | 328 | XP_033100697.1 protein ABHD13-like [Anneissia japonica] | diamond | 708 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28597374 | 28597374 | PRJNA657343_P_NODE_9687_length_271_cov_2.229730_g9663_i0 | PRJNA657343 | 9687 | 271 | 2.22973 | 6.0425683 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 84.3 | 2.22e-17 | NR | XP_071480603.1 | 105358 | g9663 | i0 | 57.4 | 1.49446494464945 | 68 | 28 | 75.3 | 1 | 207 | 4 | 185 | 251 | XP_071480603.1 uncharacterized protein [Diadema antillarum] | diamond | 405 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29935764 | 29935764 | PRJNA657343_P_NODE_28211_length_183_cov_1.522388_g28187_i0 | PRJNA657343 | 28211 | 183 | 1.522388 | 2.78597004 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 62.8 | 1.43e-9 | NR | XP_022108681.1 | 133434 | g28187 | i0 | 59.3 | 43.9180327868852 | 54 | 22 | 88.5 | 0 | 7 | 168 | 342 | 395 | XP_022108681.1 dual specificity protein phosphatase 10-like [Acanthaster planci] | diamond | 8037 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30144175 | 30144175 | PRJNA657343_P_NODE_19812_length_208_cov_1.905660_g19788_i0 | PRJNA657343 | 19812 | 208 | 1.90566 | 3.9637728 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 67.8 | 6.68e-12 | NR | XP_022102328.1 | 133434 | g19788 | i0 | 56.9 | 2.82692307692308 | 65 | 28 | 93.8 | 0 | 204 | 10 | 57 | 121 | XP_022102328.1 dual specificity protein phosphatase 19-like isoform X2 [Acanthaster planci] | diamond | 588 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30156499 | 30156499 | PRJNA657343_P_NODE_22052_length_200_cov_1.311258_g22028_i0 | PRJNA657343 | 22052 | 200 | 1.311258 | 2.622516 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 62.8 | 1.84e-9 | NR | XP_030847121.1 | 7668 | g22028 | i0 | 43.1 | 6.63 | 58 | 28 | 87 | 1 | 12 | 185 | 602 | 654 | XP_030847121.1 IgGFc-binding protein-like, partial [Strongylocentrotus purpuratus] | diamond | 1326 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30902885 | 30902885 | PRJNA657343_P_NODE_22654_length_198_cov_1.302013_g22630_i0 | PRJNA657343 | 22654 | 198 | 1.302013 | 2.57798574 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 73.6 | 2.74e-13 | NR | KAJ8037242.1 | 206669 | g22630 | i0 | 50.7 | 4.10606060606061 | 67 | 30 | 97 | 1 | 194 | 3 | 252 | 318 | KAJ8037242.1 Phospholipase B-like 1 [Holothuria leucospilota] | diamond | 813 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31724784 | 31724784 | PRJNA657343_P_NODE_44477_length_162_cov_0.920354_g44453_i0 | PRJNA657343 | 44477 | 162 | 0.920354 | 1.49097348 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 53.5 | 1.98e-6 | NR | XP_033644713.1 | 7604 | g44453 | i0 | 44 | 0.925925925925926 | 50 | 28 | 92.6 | 0 | 162 | 13 | 514 | 563 | XP_033644713.1 structural maintenance of chromosomes protein 6-like [Asterias rubens] | diamond | 150 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32085053 | 32085053 | PRJNA657343_P_NODE_9698_length_271_cov_1.792793_g9674_i0 | PRJNA657343 | 9698 | 271 | 1.792793 | 4.85846903 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 74.7 | 1.07e-13 | NR | XP_038055717.1 | 46514 | g9674 | i0 | 43.7 | 1.92619926199262 | 87 | 46 | 95.2 | 2 | 11 | 268 | 106 | 190 | XP_038055717.1 START domain-containing protein 10-like [Patiria miniata] | diamond | 522 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32262985 | 32262985 | PRJNA657343_P_NODE_20618_length_205_cov_1.903846_g20594_i0 | PRJNA657343 | 20618 | 205 | 1.903846 | 3.9028843 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 44.7 | 0.00477 | NR | XP_033107432.1 | 1529436 | g20594 | i0 | 44.2 | 0.629268292682927 | 43 | 24 | 62.9 | 0 | 74 | 202 | 126 | 168 | XP_033107432.1 sorting nexin-2-like [Anneissia japonica] | diamond | 129 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica |
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);;