contig_metadata
22 rows where bioproject = "PRJNA896758", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8525724 | 8525724 | PRJNA896758_P_NODE_9367_length_373_cov_1.283333_g8977_i0 | PRJNA896758 | 9367 | 373 | 1.283333 | 4.78683209 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 156 | 1.91e-46 | NR | PIK36410.1 | 307972 | g8977 | i0 | 84.4 | 6.90080428954424 | 96 | 15 | 77.2 | 0 | 2 | 289 | 32 | 127 | PIK36410.1 putative caltractin [Apostichopus japonicus] | diamond | 2574 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 13626533 | 13626533 | PRJNA896758_P_NODE_12071_length_331_cov_1.492248_g11681_i0 | PRJNA896758 | 12071 | 331 | 1.492248 | 4.93934088 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|1826621245|ref|XM_033243672.1| | 1529436 | g11681 | i0 | 100 | 0.0845921450151057 | 28 | 0 | 8 | 0 | 280 | 307 | 989 | 1016 | PREDICTED: Anneissia japonica acetylcholinesterase-like (LOC117103167), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 14900779 | 14900779 | PRJNA896758_P_NODE_22372_length_249_cov_0.875000_g21982_i0 | PRJNA896758 | 22372 | 249 | 0.875 | 2.17875 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1826614684|ref|XM_033244415.1| | 1529436 | g21982 | i0 | 100 | 0.224899598393574 | 28 | 0 | 11 | 0 | 101 | 128 | 700 | 727 | PREDICTED: Anneissia japonica uncharacterized LOC117103791 (LOC117103791), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 14900811 | 14900811 | PRJNA896758_P_NODE_2592_length_717_cov_6.914596_g2230_i0 | PRJNA896758 | 2592 | 717 | 6.914596 | 49.57765332 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 178 | 1.13e-39 | NTclustered | gi|1752399365|ref|XM_011667624.2| | 7668 | g2230 | i0 | 83.077 | 31.2050209205021 | 195 | 33 | 27 | 0 | 238 | 432 | 389 | 583 | PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA | blastn | 22374 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 16175595 | 16175595 | PRJNA896758_P_NODE_23193_length_247_cov_1.925287_g22803_i0 | PRJNA896758 | 23193 | 247 | 1.925287 | 4.75545889 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 178 | 3.53e-40 | NTclustered | gi|2919410114|ref|XM_071633354.1| | 105358 | g22803 | i0 | 81.081 | 2.7165991902834 | 222 | 42 | 90 | 0 | 26 | 247 | 1326 | 1105 | PREDICTED: Diadema antillarum endoplasmic reticulum chaperone BiP-like (LOC139722029), mRNA | blastn | 671 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 18724287 | 18724287 | PRJNA896758_P_NODE_20855_length_253_cov_1.105556_g20465_i0 | PRJNA896758 | 20855 | 253 | 1.105556 | 2.79705668 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 86.1 | 2.26e-12 | NTclustered | gi|2707358909|ref|XM_064097368.1| | 7653 | g20465 | i0 | 87.013 | 1.3399209486166 | 77 | 8 | 30 | 2 | 34 | 109 | 1118 | 1193 | PREDICTED: Lytechinus pictus procathepsin L-like (LOC129256996), transcript variant X1, mRNA | blastn | 339 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 22549589 | 22549589 | PRJNA896758_P_NODE_11178_length_343_cov_2.529630_g10788_i0 | PRJNA896758 | 11178 | 343 | 2.52963 | 8.6766309 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1834269133|ref|XM_033787016.1| | 7604 | g10788 | i0 | 100 | 0.0816326530612245 | 28 | 0 | 8 | 0 | 292 | 319 | 364 | 337 | PREDICTED: Asterias rubens ubiquinone biosynthesis protein COQ4 homolog, mitochondrial-like (LOC117302994), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 23824999 | 23824999 | PRJNA896758_P_NODE_21079_length_251_cov_1.297753_g20689_i0 | PRJNA896758 | 21079 | 251 | 1.297753 | 3.25736003 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 154 | 6.06e-33 | NTclustered | gi|1944910261|ref|XM_038211987.1| | 46514 | g20689 | i0 | 90.517 | 9.13147410358566 | 116 | 11 | 46 | 0 | 48 | 163 | 3022 | 2907 | PREDICTED: Patiria miniata cilia- and flagella-associated protein 57-like (LOC119737549), mRNA | blastn | 2292 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 25098794 | 25098794 | PRJNA896758_P_NODE_1460_length_960_cov_4.750846_g1149_i0 | PRJNA896758 | 1460 | 960 | 4.750846 | 45.6081216 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 120 | 5.07e-26 | NR | KAJ8031642.1 | 206669 | g1149 | i0 | 36.5 | 2.509375 | 181 | 106 | 55 | 5 | 689 | 162 | 3340 | 3516 | KAJ8031642.1 IgGFc-binding protein [Holothuria leucospilota] | diamond | 2409 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28318962 | 28318962 | PRJNA896758_P_NODE_3666_length_601_cov_1.939394_g3284_i0 | PRJNA896758 | 3666 | 601 | 1.939394 | 11.65575794 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 74.7 | 1.21e-11 | NR | XP_030840786.1 | 7668 | g3284 | i0 | 32.1 | 4.66722129783694 | 162 | 75 | 78.4 | 6 | 560 | 90 | 556 | 687 | XP_030840786.1 uncharacterized protein LOC576169 [Strongylocentrotus purpuratus] | diamond | 2805 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28350513 | 28350513 | PRJNA896758_P_NODE_11506_length_339_cov_0.954887_g11116_i0 | PRJNA896758 | 11506 | 339 | 0.954887 | 3.23706693 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 47.8 | 0.00201 | NR | XP_022088701.1 | 133434 | g11116 | i0 | 33.3 | 1.32743362831858 | 75 | 39 | 61.1 | 2 | 215 | 9 | 376 | 445 | XP_022088701.1 neurogenic locus notch homolog protein 3-like isoform X1 [Acanthaster planci] | diamond | 450 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28579424 | 28579424 | PRJNA896758_P_NODE_24087_length_246_cov_0.890173_g23697_i0 | PRJNA896758 | 24087 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 43.5 | 0.0213 | NR | XP_038072281.1 | 46514 | g23697 | i0 | 37.7 | 4.90243902439024 | 53 | 29 | 64.6 | 2 | 163 | 5 | 679 | 727 | XP_038072281.1 uncharacterized protein LOC119740886 isoform X5 [Patiria miniata] | diamond | 1206 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29550201 | 29550201 | PRJNA896758_P_NODE_25170_length_244_cov_0.900585_g24780_i0 | PRJNA896758 | 25170 | 244 | 0.900585 | 2.1974274 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 54.3 | 3.11e-6 | NR | XP_022103382.1 | 133434 | g24780 | i0 | 42.3 | 2.15163934426229 | 71 | 36 | 81.1 | 2 | 12 | 209 | 46 | 116 | XP_022103382.1 excitatory amino acid transporter 3-like [Acanthaster planci] | diamond | 525 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29613208 | 29613208 | PRJNA896758_P_NODE_8190_length_396_cov_1.978328_g7800_i0 | PRJNA896758 | 8190 | 396 | 1.978328 | 7.83417888 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 48.9 | 1.12e-4 | NR | KAJ8025155.1 | 206669 | g7800 | i0 | 39.5 | 1.34090909090909 | 86 | 37 | 62.9 | 3 | 251 | 3 | 2 | 75 | KAJ8025155.1 Acyl-CoA-binding protein-like [Holothuria leucospilota] | diamond | 531 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29960857 | 29960857 | PRJNA896758_P_NODE_10551_length_352_cov_1.738351_g10161_i0 | PRJNA896758 | 10551 | 352 | 1.738351 | 6.11899552 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 48.9 | 8.69e-4 | NR | XP_038074297.1 | 46514 | g10161 | i0 | 38 | 0.605113636363636 | 71 | 44 | 60.5 | 0 | 352 | 140 | 103 | 173 | XP_038074297.1 fibropellin-1-like isoform X2 [Patiria miniata] | diamond | 213 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31003613 | 31003613 | PRJNA896758_P_NODE_12014_length_332_cov_1.185328_g11624_i0 | PRJNA896758 | 12014 | 332 | 1.185328 | 3.93528896 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 103 | 7.19e-24 | NR | XP_033112682.1 | 1529436 | g11624 | i0 | 44 | 0.984939759036145 | 109 | 50 | 98.5 | 3 | 3 | 329 | 99 | 196 | XP_033112682.1 WSC domain-containing protein ARB_07867-like [Anneissia japonica] | diamond | 327 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31643466 | 31643466 | PRJNA896758_P_NODE_8716_length_384_cov_2.202572_g8326_i0 | PRJNA896758 | 8716 | 384 | 2.202572 | 8.45787648 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 97.4 | 1.5699999999999994e-23 | NR | XP_001176097.1 | 7668 | g8326 | i0 | 93.6 | 6.9921875 | 47 | 3 | 36.7 | 0 | 15 | 155 | 51 | 97 | XP_001176097.1 protein transport protein Sec61 subunit beta [Strongylocentrotus purpuratus] | diamond | 2685 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31801603 | 31801603 | PRJNA896758_P_NODE_15077_length_294_cov_1.615385_g14687_i0 | PRJNA896758 | 15077 | 294 | 1.615385 | 4.7492319 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 51.2 | 7.44e-5 | NR | XP_022087759.1 | 133434 | g14687 | i0 | 35.7 | 3.03061224489796 | 98 | 56 | 100 | 2 | 1 | 294 | 847 | 937 | XP_022087759.1 phospholipase DDHD2-like [Acanthaster planci] | diamond | 891 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31864839 | 31864839 | PRJNA896758_P_NODE_15117_length_294_cov_1.045249_g14727_i0 | PRJNA896758 | 15117 | 294 | 1.045249 | 3.07303206 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 60.5 | 3.93e-8 | NR | XP_030828121.1 | 7668 | g14727 | i0 | 39.4 | 2 | 99 | 55 | 99 | 2 | 293 | 3 | 144 | 239 | XP_030828121.1 F-box/LRR-repeat protein 5-like [Strongylocentrotus purpuratus] | diamond | 588 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32015542 | 32015542 | PRJNA896758_P_NODE_26758_length_237_cov_2.975610_g26368_i0 | PRJNA896758 | 26758 | 237 | 2.97561 | 7.0521957 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 141 | 6.56e-38 | NR | XP_030850470.1 | 7668 | g26368 | i0 | 85.9 | 3.9493670886076 | 78 | 11 | 98.7 | 0 | 235 | 2 | 209 | 286 | XP_030850470.1 CAAX prenyl protease 1 homolog [Strongylocentrotus purpuratus] | diamond | 936 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32268855 | 32268855 | PRJNA896758_P_NODE_6258_length_455_cov_1.290576_g5869_i0 | PRJNA896758 | 6258 | 455 | 1.290576 | 5.8721208 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 66.2 | 2.56e-9 | NR | XP_071497447.1 | 105358 | g5869 | i0 | 36.3 | 1.58241758241758 | 80 | 49 | 52.7 | 2 | 1 | 240 | 283 | 360 | XP_071497447.1 LOW QUALITY PROTEIN: uncharacterized protein [Diadema antillarum] | diamond | 720 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32773799 | 32773799 | PRJNA896758_P_NODE_12160_length_330_cov_1.198444_g11770_i0 | PRJNA896758 | 12160 | 330 | 1.198444 | 3.9548652 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 62 | 1.89e-8 | NR | XP_038064829.1 | 46514 | g11770 | i0 | 37.1 | 3.26363636363636 | 97 | 40 | 70.9 | 4 | 245 | 12 | 7050 | 7144 | XP_038064829.1 uncharacterized protein LOC119735195 [Patiria miniata] | diamond | 1077 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;