contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA927284" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6005058 | 6005058 | PRJNA927284_P_NODE_8265_length_169_cov_1.800000_g8058_i0 | PRJNA927284 | 8265 | 169 | 1.8 | 3.042 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 91.3 | 1.01e-19 | NR | XP_033120417.1 | 1529436 | g8058 | i0 | 75 | 7.93491124260355 | 56 | 14 | 99.4 | 0 | 168 | 1 | 144 | 199 | XP_033120417.1 serine--tRNA ligase, cytoplasmic-like [Anneissia japonica] | diamond | 1341 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 7279924 | 7279924 | PRJNA927284_P_NODE_5006_length_257_cov_14.692982_g4799_i0 | PRJNA927284 | 5006 | 257 | 14.692982 | 37.76096374 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 119 | 7.18e-29 | NR | KAJ8024785.1 | 206669 | g4799 | i0 | 60.7 | 3.91050583657588 | 84 | 31 | 98.1 | 1 | 255 | 4 | 1482 | 1563 | KAJ8024785.1 Granulin [Holothuria leucospilota] | diamond | 1005 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 8554736 | 8554736 | PRJNA927284_P_NODE_987_length_771_cov_14.274933_g853_i0 | PRJNA927284 | 987 | 771 | 14.274933 | 110.05973343 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 270 | 2.21e-88 | NR | XP_071501442.1 | 105358 | g853 | i0 | 78.1 | 1.93385214007782 | 169 | 37 | 65.8 | 0 | 88 | 594 | 11 | 179 | XP_071501442.1 peroxiredoxin-5, mitochondrial-like [Diadema antillarum] | diamond | 1491 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 11105432 | 11105432 | PRJNA927284_P_NODE_29_length_3201_cov_5.305801_g24_i0 | PRJNA927284 | 29 | 3201 | 5.305801 | 169.83869001 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 231 | 8.17e-58 | NR | XP_038072281.1 | 46514 | g24 | i0 | 31 | 1.89315838800375 | 642 | 359 | 57.7 | 24 | 2249 | 402 | 247 | 830 | XP_038072281.1 uncharacterized protein LOC119740886 isoform X5 [Patiria miniata] | diamond | 6060 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 18753402 | 18753402 | PRJNA927284_P_NODE_1275_length_666_cov_2.811617_g1130_i0 | PRJNA927284 | 1275 | 666 | 2.811617 | 18.72536922 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 367 | 9.88e-114 | NR | XP_071487821.1 | 105358 | g1130 | i0 | 80.1 | 4.86486486486486 | 216 | 43 | 97.3 | 0 | 664 | 17 | 1449 | 1664 | XP_071487821.1 dual oxidase 2-like [Diadema antillarum] | diamond | 3240 | 367 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 26620366 | 26620366 | PRJNA927284_P_NODE_5201_length_250_cov_2.285068_g4994_i0 | PRJNA927284 | 5201 | 250 | 2.285068 | 5.71267 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 97.4 | 7.079999999999999e-23 | NR | XP_038050724.1 | 46514 | g4994 | i0 | 62.7 | 3.54 | 59 | 22 | 70.8 | 0 | 73 | 249 | 1 | 59 | XP_038050724.1 uncharacterized protein YwbO-like [Patiria miniata] | diamond | 885 | 97.8 | 0.995910020449898 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26810430 | 26810430 | PRJNA927284_P_NODE_641_length_990_cov_2.362123_g539_i0 | PRJNA927284 | 641 | 990 | 2.362123 | 23.3850177 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 63.9 | 5.36e-7 | NR | XP_041458355.1 | 7654 | g539 | i0 | 29.4 | 3.23030303030303 | 194 | 81 | 56.4 | 7 | 982 | 425 | 1008 | 1153 | XP_041458355.1 cubilin-like [Lytechinus variegatus] | diamond | 3198 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26968589 | 26968589 | PRJNA927284_P_NODE_3182_length_366_cov_2.186944_g2977_i0 | PRJNA927284 | 3182 | 366 | 2.186944 | 8.00421504 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 134 | 1.75e-36 | NR | XP_071509452.1 | 105358 | g2977 | i0 | 85.1 | 7.35245901639344 | 74 | 11 | 60.7 | 0 | 140 | 361 | 126 | 199 | XP_071509452.1 peroxiredoxin-6-like [Diadema antillarum] | diamond | 2691 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27095134 | 27095134 | PRJNA927284_P_NODE_4002_length_309_cov_1.714286_g3795_i0 | PRJNA927284 | 4002 | 309 | 1.714286 | 5.29714374 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 94 | 2.77e-20 | NR | XP_033631212.1 | 7604 | g3795 | i0 | 51.5 | 2.81553398058252 | 99 | 45 | 93.2 | 2 | 1 | 288 | 251 | 349 | XP_033631212.1 uncharacterized WD repeat-containing protein all2124-like [Asterias rubens] | diamond | 870 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27498846 | 27498846 | PRJNA927284_P_NODE_2983_length_383_cov_1.974576_g2781_i0 | PRJNA927284 | 2983 | 383 | 1.974576 | 7.56262608 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 85.9 | 4.74e-17 | NR | XP_033631673.1 | 7604 | g2781 | i0 | 43.9 | 0.838120104438642 | 107 | 52 | 77.5 | 1 | 12 | 308 | 211 | 317 | XP_033631673.1 crystallin J1A-like [Asterias rubens] | diamond | 321 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27688599 | 27688599 | PRJNA927284_P_NODE_2244_length_464_cov_2.029885_g2052_i0 | PRJNA927284 | 2244 | 464 | 2.029885 | 9.4186664 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 80.1 | 6.6e-15 | NR | PIK40874.1 | 307972 | g2052 | i0 | 32.5 | 1.95905172413793 | 154 | 97 | 96.3 | 5 | 9 | 455 | 20 | 171 | PIK40874.1 hypothetical protein BSL78_22273 [Apostichopus japonicus] | diamond | 909 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27751546 | 27751546 | PRJNA927284_P_NODE_484_length_1163_cov_4.569665_g397_i0 | PRJNA927284 | 484 | 1163 | 4.569665 | 53.14520395 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 191 | 1.1699999999999995e-55 | NR | XP_033112156.1 | 1529436 | g397 | i0 | 55.8 | 4.31040412725709 | 163 | 71 | 42 | 1 | 100 | 588 | 11 | 172 | XP_033112156.1 peptidoglycan recognition protein 1-like isoform X2 [Anneissia japonica] | diamond | 5013 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28477568 | 28477568 | PRJNA927284_P_NODE_1446_length_616_cov_3.165247_g1290_i0 | PRJNA927284 | 1446 | 616 | 3.165247 | 19.49792152 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 108 | 5.020000000000001e-27 | NR | XP_033116872.1 | 1529436 | g1290 | i0 | 56 | 0.443181818181818 | 91 | 40 | 44.3 | 0 | 72 | 344 | 3 | 93 | XP_033116872.1 SH3 domain-binding glutamic acid-rich-like protein 3 isoform X2 [Anneissia japonica] | diamond | 273 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28698748 | 28698748 | PRJNA927284_P_NODE_1967_length_505_cov_2.081933_g1780_i0 | PRJNA927284 | 1967 | 505 | 2.081933 | 10.51376165 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 93.2 | 3.08e-19 | NR | XP_022098938.1 | 133434 | g1780 | i0 | 32.3 | 3.01188118811881 | 167 | 111 | 99.2 | 1 | 1 | 501 | 146 | 310 | XP_022098938.1 crystallin J1A-like isoform X2 [Acanthaster planci] | diamond | 1521 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 29495115 | 29495115 | PRJNA927284_P_NODE_1030_length_750_cov_2.557559_g167_i1 | PRJNA927284 | 1030 | 750 | 2.557559 | 19.1816925 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 358 | 2.8999999999999995e-113 | NR | XP_041461067.1 | 7654 | g167 | i1 | 66.5 | 10.336 | 251 | 80 | 98.8 | 2 | 6 | 746 | 535 | 785 | XP_041461067.1 UDP-N-acetylglucosamine--peptide N-acetylglucosaminyltransferase 110 kDa subunit-like isoform X2 [Lytechinus variegatus] | diamond | 7752 | 358 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29866875 | 29866875 | PRJNA927284_P_NODE_9351_length_150_cov_2.157025_g9144_i0 | PRJNA927284 | 9351 | 150 | 2.157025 | 3.2355375 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 97.1 | 7.52e-22 | NR | XP_033101753.1 | 1529436 | g9144 | i0 | 94 | 10 | 50 | 3 | 100 | 0 | 1 | 150 | 382 | 431 | XP_033101753.1 T-complex protein 1 subunit beta-like [Anneissia japonica] | diamond | 1500 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29898500 | 29898500 | PRJNA927284_P_NODE_7771_length_178_cov_2.536913_g7564_i0 | PRJNA927284 | 7771 | 178 | 2.536913 | 4.51570514 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 85.1 | 3.03e-18 | NR | KAJ8027122.1 | 206669 | g7564 | i0 | 74.1 | 1.95505617977528 | 58 | 14 | 97.8 | 1 | 176 | 3 | 117 | 173 | KAJ8027122.1 Pre-mRNA-splicing factor syf2 [Holothuria leucospilota] | diamond | 348 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30404360 | 30404360 | PRJNA927284_P_NODE_7453_length_184_cov_2.032258_g7246_i0 | PRJNA927284 | 7453 | 184 | 2.032258 | 3.73935472 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47.4 | 3.91e-4 | NR | XP_071486704.1 | 105358 | g7246 | i0 | 90.5 | 0.684782608695652 | 21 | 2 | 34.2 | 0 | 1 | 63 | 314 | 334 | XP_071486704.1 eukaryotic translation initiation factor 3 subunit I-like [Diadema antillarum] | diamond | 126 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31137520 | 31137520 | PRJNA927284_P_NODE_1215_length_684_cov_2.229008_g1073_i0 | PRJNA927284 | 1215 | 684 | 2.229008 | 15.24641472 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 349 | 1.7599999999999996e-118 | NR | XP_063966314.1 | 7653 | g1073 | i0 | 78.9 | 37.9122807017544 | 228 | 47 | 99.6 | 1 | 683 | 3 | 52 | 279 | XP_063966314.1 stomatin-like isoform X2 [Lytechinus pictus] | diamond | 25932 | 349 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 31794538 | 31794538 | PRJNA927284_P_NODE_2277_length_459_cov_19.986047_g2085_i0 | PRJNA927284 | 2277 | 459 | 19.986047 | 91.73595573 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 80.9 | 2.14e-14 | NR | XP_033109470.1 | 1529436 | g2085 | i0 | 45 | 1.48366013071895 | 80 | 36 | 47.1 | 2 | 345 | 130 | 2185 | 2264 | XP_033109470.1 fibrillin-1-like isoform X1 [Anneissia japonica] | diamond | 681 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31801754 | 31801754 | PRJNA927284_P_NODE_8537_length_164_cov_2.422222_g8330_i0 | PRJNA927284 | 8537 | 164 | 2.422222 | 3.97244408 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 80.1 | 8.06e-16 | NR | XP_033637122.1 | 7604 | g8330 | i0 | 70 | 1.86585365853659 | 50 | 15 | 91.5 | 0 | 13 | 162 | 42 | 91 | XP_033637122.1 L-threonine ammonia-lyase-like [Asterias rubens] | diamond | 306 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31921280 | 31921280 | PRJNA927284_P_NODE_2377_length_446_cov_2.000000_g2183_i0 | PRJNA927284 | 2377 | 446 | 2 | 8.92 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 73.2 | 2.19e-12 | NR | PIK40874.1 | 307972 | g2183 | i0 | 32 | 2.03139013452915 | 153 | 93 | 96.2 | 5 | 438 | 10 | 20 | 171 | PIK40874.1 hypothetical protein BSL78_22273 [Apostichopus japonicus] | diamond | 906 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;