contig_metadata
17 rows where bioproject = "PRJNA951388", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934768 | 934768 | PRJNA951388_S_NODE_2261_length_492_cov_41.205251_g2135_i0 | PRJNA951388 | 2261 | 492 | 41.205251 | 202.72983492 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 247 | 3.72e-78 | NR | XP_022083118.1 | 133434 | g2135 | i0 | 81.4 | 6.15243902439024 | 145 | 27 | 88.4 | 0 | 2 | 436 | 252 | 396 | XP_022083118.1 actin-related protein 2-B isoform X1 [Acanthaster planci] | diamond | 3027 | 247 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 13688399 | 13688399 | PRJNA951388_S_NODE_3231_length_439_cov_16.101093_g3104_i0 | PRJNA951388 | 3231 | 439 | 16.101093 | 70.68379827 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 191 | 1.15e-54 | NR | XP_071479759.1 | 105358 | g3104 | i0 | 71.4 | 24.2118451025057 | 119 | 34 | 81.3 | 0 | 437 | 81 | 476 | 594 | XP_071479759.1 lysine--tRNA ligase-like [Diadema antillarum] | diamond | 10629 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 22940516 | 22940516 | PRJNA951388_S_NODE_6798_length_326_cov_2.173913_g6671_i0 | PRJNA951388 | 6798 | 326 | 2.173913 | 7.08695638 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 87 | 8.59e-20 | NR | XP_033627414.1 | 7604 | g6671 | i0 | 44.1 | 10.5 | 93 | 49 | 85.6 | 2 | 25 | 303 | 3 | 92 | XP_033627414.1 mitochondrial import inner membrane translocase subunit Tim10-like [Asterias rubens] | diamond | 3423 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 25160888 | 25160888 | PRJNA951388_S_NODE_640_length_761_cov_10.968023_g532_i0 | PRJNA951388 | 640 | 761 | 10.968023 | 83.46665503 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 260 | 1.2699999999999998e-82 | NR | XP_033641303.1 | 7604 | g532 | i0 | 85.1 | 53.6688567674113 | 148 | 22 | 58.3 | 0 | 3 | 446 | 180 | 327 | XP_033641303.1 rRNA 2'-O-methyltransferase fibrillarin-like [Asterias rubens] | diamond | 40842 | 262 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27727537 | 27727537 | PRJNA951388_S_NODE_7584_length_308_cov_2.621277_g7457_i0 | PRJNA951388 | 7584 | 308 | 2.621277 | 8.07353316 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 167 | 2.54e-47 | NR | XP_033647305.1 | 7604 | g7457 | i0 | 80.4 | 65.5616883116883 | 102 | 20 | 99.4 | 0 | 2 | 307 | 112 | 213 | XP_033647305.1 ruvB-like 1 [Asterias rubens] | diamond | 20193 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27759028 | 27759028 | PRJNA951388_S_NODE_1884_length_523_cov_14.913333_g1761_i0 | PRJNA951388 | 1884 | 523 | 14.913333 | 77.99673159 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 104 | 5.76e-25 | NR | XP_041481392.1 | 7654 | g1761 | i0 | 43.3 | 3.95219885277247 | 141 | 75 | 78 | 3 | 58 | 465 | 5 | 145 | XP_041481392.1 endothelial differentiation-related factor 1-like [Lytechinus variegatus] | diamond | 2067 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28509986 | 28509986 | PRJNA951388_S_NODE_3207_length_440_cov_9.493188_g3080_i0 | PRJNA951388 | 3207 | 440 | 9.493188 | 41.7700272 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 88.6 | 2.95e-17 | NR | XP_071507319.1 | 105358 | g3080 | i0 | 43 | 2.33863636363636 | 114 | 62 | 77.7 | 1 | 19 | 360 | 441 | 551 | XP_071507319.1 bifunctional coenzyme A synthase-like [Diadema antillarum] | diamond | 1029 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28825447 | 28825447 | PRJNA951388_S_NODE_8888_length_281_cov_3.331731_g8761_i0 | PRJNA951388 | 8888 | 281 | 3.331731 | 9.36216411 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 43.5 | 0.0313 | NR | XP_038065468.1 | 46514 | g8761 | i0 | 32.8 | 0.715302491103203 | 67 | 43 | 71.5 | 1 | 13 | 213 | 8 | 72 | XP_038065468.1 ubiquitin-associated and SH3 domain-containing protein B-like [Patiria miniata] | diamond | 201 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29899360 | 29899360 | PRJNA951388_S_NODE_2451_length_481_cov_18.634804_g2324_i0 | PRJNA951388 | 2451 | 481 | 18.634804 | 89.63340724 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 155 | 3.18e-45 | NR | XP_071481764.1 | 105358 | g2324 | i0 | 54.3 | 6.98544698544699 | 127 | 58 | 79.2 | 0 | 473 | 93 | 25 | 151 | XP_071481764.1 ubiquitin-conjugating enzyme E2 L5-like [Diadema antillarum] | diamond | 3360 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29994135 | 29994135 | PRJNA951388_S_NODE_11211_length_244_cov_2.251462_g11084_i0 | PRJNA951388 | 11211 | 244 | 2.251462 | 5.49356728 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 47 | 3.58e-4 | NR | XP_030853394.1 | 7668 | g11084 | i0 | 36.4 | 2.70491803278689 | 55 | 35 | 67.6 | 0 | 188 | 24 | 54 | 108 | XP_030853394.1 general transcription factor 3C polypeptide 6-like isoform X1 [Strongylocentrotus purpuratus] | diamond | 660 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29994137 | 29994137 | PRJNA951388_S_NODE_1491_length_564_cov_8.482688_g1370_i0 | PRJNA951388 | 1491 | 564 | 8.482688 | 47.84236032 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 97.1 | 1.4500000000000002e-21 | NR | XP_071476142.1 | 105358 | g1370 | i0 | 44.9 | 2.52659574468085 | 89 | 49 | 47.3 | 0 | 397 | 131 | 81 | 169 | XP_071476142.1 E3 ubiquitin-protein ligase RNF126-like isoform X2 [Diadema antillarum] | diamond | 1425 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30342101 | 30342101 | PRJNA951388_S_NODE_792_length_708_cov_4.971654_g679_i0 | PRJNA951388 | 792 | 708 | 4.971654 | 35.19931032 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 82 | 1.11e-14 | NR | XP_041457575.1 | 7654 | g679 | i0 | 30 | 1.00423728813559 | 237 | 125 | 84.7 | 8 | 38 | 637 | 21 | 253 | XP_041457575.1 inhibitor of growth protein 1-like [Lytechinus variegatus] | diamond | 711 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30506158 | 30506158 | PRJNA951388_S_NODE_2853_length_458_cov_4.768831_g2726_i0 | PRJNA951388 | 2853 | 458 | 4.768831 | 21.84124598 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 184 | 1.37e-50 | NR | KAJ8044098.1 | 206669 | g2726 | i0 | 57.2 | 31.5720524017467 | 152 | 65 | 99.6 | 0 | 456 | 1 | 164 | 315 | KAJ8044098.1 AP-1 complex subunit beta-1 [Holothuria leucospilota] | diamond | 14460 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31352844 | 31352844 | PRJNA951388_S_NODE_9956_length_262_cov_1.687831_g9829_i0 | PRJNA951388 | 9956 | 262 | 1.687831 | 4.42211722 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 60.1 | 3.76e-8 | NR | XP_022085052.1 | 133434 | g9829 | i0 | 36.1 | 3.50381679389313 | 72 | 46 | 82.4 | 0 | 225 | 10 | 55 | 126 | XP_022085052.1 serine/threonine-protein phosphatase 1 regulatory subunit 10-like isoform X1 [Acanthaster planci] | diamond | 918 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31675490 | 31675490 | PRJNA951388_S_NODE_11477_length_240_cov_5.143713_g11350_i0 | PRJNA951388 | 11477 | 240 | 5.143713 | 12.3449112 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 88.6 | 2.46e-18 | NR | XP_030838847.1 | 7668 | g11350 | i0 | 46.8 | 8.8625 | 79 | 42 | 98.8 | 0 | 3 | 239 | 374 | 452 | XP_030838847.1 DNA primase large subunit [Strongylocentrotus purpuratus] | diamond | 2127 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31953680 | 31953680 | PRJNA951388_S_NODE_8557_length_288_cov_2.051163_g8430_i0 | PRJNA951388 | 8557 | 288 | 2.051163 | 5.90734944 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 63.2 | 4.44e-9 | NR | XP_033643961.1 | 7604 | g8430 | i0 | 38.5 | 2.02083333333333 | 96 | 55 | 99 | 2 | 1 | 285 | 168 | 260 | XP_033643961.1 DNA-directed RNA polymerase III subunit RPC1-like [Asterias rubens] | diamond | 582 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32270359 | 32270359 | PRJNA951388_S_NODE_6498_length_333_cov_8.638462_g6371_i0 | PRJNA951388 | 6498 | 333 | 8.638462 | 28.76607846 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 81.3 | 3.08e-15 | NR | XP_022106049.1 | 133434 | g6371 | i0 | 41.5 | 0.846846846846847 | 94 | 55 | 84.7 | 0 | 332 | 51 | 440 | 533 | XP_022106049.1 mitochondrial-processing peptidase subunit alpha-like [Acanthaster planci] | diamond | 282 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;