contig_metadata
23 rows where bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022451 | 2022451 | PRJNA770361_P_NODE_4562_length_441_cov_1.057065_g4467_i0 | PRJNA770361 | 4562 | 441 | 1.057065 | 4.66165665 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 348 | 4.860000000000001e-91 | NTclustered | gi|1229132981|ref|XM_022254371.1| | 133434 | g4467 | i0 | 82.126 | 80.4353741496599 | 414 | 66 | 93 | 5 | 32 | 441 | 859 | 450 | PREDICTED: Acanthaster planci catalase-like (LOC110989757), mRNA | blastn | 35472 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 12225989 | 12225989 | PRJNA770361_P_NODE_1410_length_790_cov_2.610879_g1323_i0 | PRJNA770361 | 1410 | 790 | 2.610879 | 20.6259441 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 293 | 5.489999999999999e-96 | NR | XP_041452746.1 | 7654 | g1323 | i0 | 56.4 | 6.52784810126582 | 250 | 109 | 94.9 | 0 | 786 | 37 | 1 | 250 | XP_041452746.1 proteasome subunit alpha type-1-like [Lytechinus variegatus] | diamond | 5157 | 295 | 0.993220338983051 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 20332794 | 20332794 | PRJNA770361_P_NODE_15856_length_249_cov_0.886364_g15761_i0 | PRJNA770361 | 15856 | 249 | 0.886364 | 2.20704636 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 237 | 5.8e-58 | NTclustered | gi|1229189121|ref|XM_022252716.1| | 133434 | g15761 | i0 | 84.082 | 93.4417670682731 | 245 | 39 | 98 | 0 | 4 | 248 | 11 | 255 | PREDICTED: Acanthaster planci histone H3.3 (LOC110988833), mRNA | blastn | 23267 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 23699372 | 23699372 | PRJNA770361_P_NODE_4259_length_456_cov_1.992167_g4164_i0 | PRJNA770361 | 4259 | 456 | 1.992167 | 9.08428152 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 115 | 1.09e-26 | NR | BAD02370.1 | 7594 | g4164 | i0 | 45.8 | 8.90131578947368 | 131 | 71 | 86.2 | 0 | 64 | 456 | 116 | 246 | BAD02370.1 phosphoinositide dependent kinase-1 [Patiria pectinifera] | diamond | 4059 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria pectinifera | |
| 26736275 | 26736275 | PRJNA770361_P_NODE_10641_length_289_cov_1.444444_g10546_i0 | PRJNA770361 | 10641 | 289 | 1.444444 | 4.17444316 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 68.9 | 4.1e-11 | NR | XP_071483338.1 | 105358 | g10546 | i0 | 33.3 | 14.4913494809689 | 93 | 62 | 96.5 | 0 | 288 | 10 | 62 | 154 | XP_071483338.1 transducin beta-like protein 3 [Diadema antillarum] | diamond | 4188 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27084891 | 27084891 | PRJNA770361_P_NODE_10102_length_296_cov_2.390135_g10007_i0 | PRJNA770361 | 10102 | 296 | 2.390135 | 7.0747996 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 43.1 | 0.0484 | NR | XP_033119743.1 | 1529436 | g10007 | i0 | 31 | 0.881756756756757 | 87 | 59 | 87.2 | 1 | 3 | 260 | 299 | 385 | XP_033119743.1 putative sodium-coupled neutral amino acid transporter 7 [Anneissia japonica] | diamond | 261 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27084912 | 27084912 | PRJNA770361_P_NODE_8562_length_322_cov_1.240964_g8467_i0 | PRJNA770361 | 8562 | 322 | 1.240964 | 3.99590408 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 124 | 2.0099999999999997e-30 | NR | XP_071510596.1 | 105358 | g8467 | i0 | 48.6 | 2.93478260869565 | 105 | 54 | 97.8 | 0 | 8 | 322 | 59 | 163 | XP_071510596.1 1,4-alpha-glucan-branching enzyme-like [Diadema antillarum] | diamond | 945 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27369629 | 27369629 | PRJNA770361_P_NODE_4563_length_441_cov_1.029891_g4468_i0 | PRJNA770361 | 4563 | 441 | 1.029891 | 4.54181931 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 61.6 | 3.3e-8 | NR | PIK49191.1 | 307972 | g4468 | i0 | 30.4 | 0.693877551020408 | 102 | 70 | 68.7 | 1 | 347 | 45 | 28 | 129 | PIK49191.1 putative hypoxanthine-guanine phosphoribosyltransferase isoform X1 [Apostichopus japonicus] | diamond | 306 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27622061 | 27622061 | PRJNA770361_P_NODE_5944_length_385_cov_1.426282_g5849_i0 | PRJNA770361 | 5944 | 385 | 1.426282 | 5.4911857 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 69.3 | 2.36e-11 | NR | XP_071502917.1 | 105358 | g5849 | i0 | 51 | 1.57402597402597 | 98 | 47 | 75.6 | 1 | 26 | 316 | 1 | 98 | XP_071502917.1 coiled-coil domain-containing protein 124-like [Diadema antillarum] | diamond | 606 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28010623 | 28010623 | PRJNA770361_P_NODE_16625_length_247_cov_0.896552_g16530_i0 | PRJNA770361 | 16625 | 247 | 0.896552 | 2.21448344 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 95.1 | 1.43e-20 | NR | XP_022106844.1 | 133434 | g16530 | i0 | 58.1 | 2.79352226720648 | 74 | 31 | 89.9 | 0 | 2 | 223 | 329 | 402 | XP_022106844.1 uncharacterized aarF domain-containing protein kinase 5-like isoform X2 [Acanthaster planci] | diamond | 690 | 95.5 | 0.995811518324607 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28253329 | 28253329 | PRJNA770361_P_NODE_4986_length_421_cov_2.241379_g4891_i0 | PRJNA770361 | 4986 | 421 | 2.241379 | 9.43620559 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 92 | 1.93e-19 | NR | XP_071493707.1 | 105358 | g4891 | i0 | 36.2 | 2.89311163895487 | 138 | 83 | 96.9 | 3 | 411 | 4 | 12 | 146 | XP_071493707.1 uridine-cytidine kinase 2-B-like [Diadema antillarum] | diamond | 1218 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28316613 | 28316613 | PRJNA770361_P_NODE_18586_length_243_cov_0.917647_g18491_i0 | PRJNA770361 | 18586 | 243 | 0.917647 | 2.22988221 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 82 | 5.61e-16 | NR | XP_033624966.1 | 7604 | g18491 | i0 | 48.1 | 1 | 81 | 40 | 97.5 | 1 | 1 | 237 | 526 | 606 | XP_033624966.1 disintegrin and metalloproteinase domain-containing protein 10-like [Asterias rubens] | diamond | 243 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28790040 | 28790040 | PRJNA770361_P_NODE_12007_length_271_cov_1.575758_g11912_i0 | PRJNA770361 | 12007 | 271 | 1.575758 | 4.27030418 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 67.8 | 2.5e-11 | NR | XP_038055908.1 | 46514 | g11912 | i0 | 63.8 | 0.96309963099631 | 47 | 16 | 52 | 1 | 1 | 141 | 28 | 73 | XP_038055908.1 fibrillin-1-like [Patiria miniata] | diamond | 261 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30021801 | 30021801 | PRJNA770361_P_NODE_3531_length_501_cov_2.016355_g3436_i0 | PRJNA770361 | 3531 | 501 | 2.016355 | 10.10193855 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 92.8 | 8.47e-19 | NR | XP_030830623.1 | 7668 | g3436 | i0 | 34.6 | 0.970059880239521 | 162 | 98 | 95.8 | 4 | 2 | 481 | 85 | 240 | XP_030830623.1 apoptosis-inducing factor 2 [Strongylocentrotus purpuratus] | diamond | 486 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30157370 | 30157370 | PRJNA770361_P_NODE_2632_length_582_cov_3.306483_g2538_i0 | PRJNA770361 | 2632 | 582 | 3.306483 | 19.243731060000002 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 115 | 1.63e-28 | NR | XP_003730859.1 | 7668 | g2538 | i0 | 39.6 | 2.12886597938144 | 149 | 87 | 75.8 | 2 | 441 | 1 | 9 | 156 | XP_003730859.1 NEDD8-conjugating enzyme Ubc12 [Strongylocentrotus purpuratus] | diamond | 1239 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30338060 | 30338060 | PRJNA770361_P_NODE_2552_length_592_cov_2.319846_g2458_i0 | PRJNA770361 | 2552 | 592 | 2.319846 | 13.73348832 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 97.1 | 1.88e-20 | NR | XP_033110122.1 | 1529436 | g2458 | i0 | 34.4 | 3.41047297297297 | 189 | 114 | 92.7 | 3 | 1 | 549 | 103 | 287 | XP_033110122.1 tetraspanin-5-like [Anneissia japonica] | diamond | 2019 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30527121 | 30527121 | PRJNA770361_P_NODE_8613_length_321_cov_1.258065_g8518_i0 | PRJNA770361 | 8613 | 321 | 1.258065 | 4.03838865 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 55.5 | 3.09e-6 | NR | XP_033626678.1 | 7604 | g8518 | i0 | 34 | 1.98130841121495 | 106 | 68 | 99.1 | 2 | 319 | 2 | 399 | 502 | XP_033626678.1 fatty acid amide hydrolase-like [Asterias rubens] | diamond | 636 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30536771 | 30536771 | PRJNA770361_P_NODE_18073_length_244_cov_0.912281_g17978_i0 | PRJNA770361 | 18073 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.8 | 1.62e-8 | NR | XP_022104156.1 | 133434 | g17978 | i0 | 56.1 | 5.16393442622951 | 66 | 29 | 81.1 | 0 | 214 | 17 | 1044 | 1109 | XP_022104156.1 eukaryotic translation initiation factor 4 gamma 3-like isoform X1 [Acanthaster planci] | diamond | 1260 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30969695 | 30969695 | PRJNA770361_P_NODE_7214_length_349_cov_2.300725_g7119_i0 | PRJNA770361 | 7214 | 349 | 2.300725 | 8.02953025 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 97.8 | 6.709999999999999e-23 | NR | XP_071476142.1 | 105358 | g7119 | i0 | 44.9 | 3.85959885386819 | 89 | 49 | 76.5 | 0 | 311 | 45 | 81 | 169 | XP_071476142.1 E3 ubiquitin-protein ligase RNF126-like isoform X2 [Diadema antillarum] | diamond | 1347 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31190319 | 31190319 | PRJNA770361_P_NODE_2655_length_580_cov_1.879684_g2561_i0 | PRJNA770361 | 2655 | 580 | 1.879684 | 10.9021672 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 58.5 | 2.74e-6 | NR | XP_030836923.1 | 7668 | g2561 | i0 | 38.2 | 0.393103448275862 | 76 | 44 | 37.8 | 1 | 314 | 96 | 84 | 159 | XP_030836923.1 TBC1 domain family member 17 [Strongylocentrotus purpuratus] | diamond | 228 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31231705 | 31231705 | PRJNA770361_P_NODE_5235_length_411_cov_2.585799_g5140_i0 | PRJNA770361 | 5235 | 411 | 2.585799 | 10.62763389 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 157 | 2.81e-42 | NR | XP_033643480.1 | 7604 | g5140 | i0 | 57.1 | 5.7956204379562 | 133 | 57 | 97.1 | 0 | 400 | 2 | 160 | 292 | XP_033643480.1 WD repeat-containing protein 46-like [Asterias rubens] | diamond | 2382 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31832669 | 31832669 | PRJNA770361_P_NODE_4597_length_439_cov_1.617486_g4502_i0 | PRJNA770361 | 4597 | 439 | 1.617486 | 7.10076354 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 54.3 | 2.86e-5 | NR | XP_033643489.1 | 7604 | g4502 | i0 | 29.4 | 1.94077448747153 | 136 | 93 | 92.9 | 1 | 411 | 4 | 907 | 1039 | XP_033643489.1 rab GTPase-activating protein 1-like isoform X2 [Asterias rubens] | diamond | 852 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32654742 | 32654742 | PRJNA770361_P_NODE_740_length_1060_cov_5.170213_g681_i0 | PRJNA770361 | 740 | 1060 | 5.170213 | 54.8042578 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 196 | 4.809999999999999e-56 | NR | KAJ8036487.1 | 206669 | g681 | i0 | 35.9 | 3.52075471698113 | 323 | 193 | 87.7 | 6 | 951 | 22 | 11 | 332 | KAJ8036487.1 Cathepsin L [Holothuria leucospilota] | diamond | 3732 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;