contig_metadata
26 rows where bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5768600 | 5768600 | PRJNA683669_P_NODE_2685_length_803_cov_1.793151_g2490_i0 | PRJNA683669 | 2685 | 803 | 1.793151 | 14.39900253 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 224 | 1.26e-64 | NR | XP_071496317.1 | 105358 | g2490 | i0 | 56 | 0.713574097135741 | 191 | 73 | 67.6 | 2 | 3 | 545 | 335 | 524 | XP_071496317.1 uncharacterized protein [Diadema antillarum] | diamond | 573 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 8318171 | 8318171 | PRJNA683669_P_NODE_30807_length_245_cov_0.895349_g30575_i0 | PRJNA683669 | 30807 | 245 | 0.895349 | 2.19360505 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1752368514|ref|XM_030988441.1| | 7668 | g30575 | i0 | 100 | 0.575510204081633 | 29 | 0 | 12 | 0 | 214 | 242 | 931 | 959 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115925142 (LOC115925142), mRNA | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 10869015 | 10869015 | PRJNA683669_P_NODE_3129_length_742_cov_1.539611_g2920_i0 | PRJNA683669 | 3129 | 742 | 1.539611 | 11.42391362 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 77.8 | 1.69e-12 | NR | XP_033113752.1 | 1529436 | g2920 | i0 | 39.7 | 0.46900269541779 | 116 | 63 | 45.3 | 4 | 688 | 353 | 200 | 312 | XP_033113752.1 lupus La protein-like [Anneissia japonica] | diamond | 348 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 12144319 | 12144319 | PRJNA683669_P_NODE_21330_length_280_cov_1.859903_g21098_i0 | PRJNA683669 | 21330 | 280 | 1.859903 | 5.2077284 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 60.2 | 1.54e-4 | NTclustered | gi|1229140653|ref|XM_022226767.1| | 133434 | g21098 | i0 | 92.857 | 0.15 | 42 | 2 | 15 | 1 | 60 | 101 | 2796 | 2836 | PREDICTED: Acanthaster planci MTSS1-like protein (LOC110974858), mRNA | blastn | 42 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 17242801 | 17242801 | PRJNA683669_P_NODE_10554_length_396_cov_1.359133_g10323_i0 | PRJNA683669 | 10554 | 396 | 1.359133 | 5.38216668 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 149 | 3.4e-40 | NR | XP_071495196.1 | 105358 | g10323 | i0 | 65.1 | 2.5 | 106 | 35 | 80.3 | 2 | 72 | 389 | 7 | 110 | XP_071495196.1 calreticulin-like [Diadema antillarum] | diamond | 990 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 19792033 | 19792033 | PRJNA683669_P_NODE_6216_length_514_cov_11.258503_g5986_i0 | PRJNA683669 | 6216 | 514 | 11.258503 | 57.86870542 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 206 | 2.66e-64 | NR | XP_041460284.1 | 7654 | g5986 | i0 | 62.9 | 6.82295719844358 | 167 | 61 | 96.9 | 1 | 499 | 2 | 8 | 174 | XP_041460284.1 60S ribosomal protein L9-like isoform X1 [Lytechinus variegatus] | diamond | 3507 | 207 | 0.995169082125604 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 22342157 | 22342157 | PRJNA683669_P_NODE_10198_length_402_cov_2.103343_g9967_i0 | PRJNA683669 | 10198 | 402 | 2.103343 | 8.45543886 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.039 | NTclustered | gi|1944919279|ref|XM_038216504.1| | 46514 | g9967 | i0 | 100 | 0.557213930348259 | 28 | 0 | 7 | 0 | 100 | 127 | 1397 | 1370 | PREDICTED: Patiria miniata uncharacterized LOC119740973 (LOC119740973), transcript variant X2, mRNA | blastn | 224 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 24891078 | 24891078 | PRJNA683669_P_NODE_200_length_2195_cov_2.180019_g171_i0 | PRJNA683669 | 200 | 2195 | 2.180019 | 47.85141705 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 439 | 1.06e-141 | NR | XP_041453243.1 | 7654 | g171 | i0 | 50 | 3.25694760820046 | 462 | 224 | 63.1 | 1 | 364 | 1749 | 138 | 592 | XP_041453243.1 solute carrier family 28 member 3-like [Lytechinus variegatus] | diamond | 7149 | 441 | 0.99546485260771 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26797339 | 26797339 | PRJNA683669_P_NODE_34201_length_241_cov_0.916667_g33969_i0 | PRJNA683669 | 34201 | 241 | 0.916667 | 2.20916747 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 98.6 | 7.86e-22 | NR | XP_022084091.1 | 133434 | g33969 | i0 | 55 | 9.75933609958506 | 80 | 35 | 98.3 | 1 | 3 | 239 | 596 | 675 | XP_022084091.1 probable ATP-dependent RNA helicase DHX35 [Acanthaster planci] | diamond | 2352 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27113587 | 27113587 | PRJNA683669_P_NODE_7022_length_483_cov_1.056098_g6791_i0 | PRJNA683669 | 7022 | 483 | 1.056098 | 5.10095334 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 94.4 | 5.37e-20 | NR | XP_041480163.1 | 7654 | g6791 | i0 | 38.2 | 0.813664596273292 | 131 | 74 | 79.5 | 2 | 13 | 396 | 148 | 274 | XP_041480163.1 trypsin-like [Lytechinus variegatus] | diamond | 393 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27599503 | 27599503 | PRJNA683669_P_NODE_19004_length_296_cov_1.381166_g18772_i0 | PRJNA683669 | 19004 | 296 | 1.381166 | 4.08825136 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 63.2 | 4.62e-9 | NR | XP_071479928.1 | 105358 | g18772 | i0 | 29.3 | 3.47635135135135 | 92 | 62 | 90.2 | 1 | 9 | 275 | 388 | 479 | XP_071479928.1 mitochondrial sodium/calcium exchanger protein-like [Diadema antillarum] | diamond | 1029 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27682764 | 27682764 | PRJNA683669_P_NODE_9604_length_413_cov_1.241176_g9373_i0 | PRJNA683669 | 9604 | 413 | 1.241176 | 5.12605688 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 91.7 | 2.14e-18 | NR | XP_033105774.1 | 1529436 | g9373 | i0 | 46.9 | 4.29297820823245 | 98 | 44 | 66.1 | 3 | 77 | 349 | 5521 | 5617 | XP_033105774.1 uncharacterized protein LOC117108037 [Anneissia japonica] | diamond | 1773 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27788839 | 27788839 | PRJNA683669_P_NODE_244_length_2089_cov_5.206349_g206_i0 | PRJNA683669 | 244 | 2089 | 5.206349 | 108.76063061 | root | 1 | Root_unresolved | Root_unresolved | 429 | 3.12e-142 | NR | XP_041465361.1 | 7654 | g206 | i0 | 69.2 | 15.0861656294878 | 302 | 92 | 43.2 | 1 | 528 | 1430 | 26 | 327 | XP_041465361.1 hydroxymethylglutaryl-CoA lyase, mitochondrial-like [Lytechinus variegatus] | diamond | 31515 | 432 | 0.993055555555556 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28092839 | 28092839 | PRJNA683669_P_NODE_6785_length_490_cov_2.031175_g6554_i0 | PRJNA683669 | 6785 | 490 | 2.031175 | 9.9527575 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 108 | 4.8e-24 | NR | XP_033105774.1 | 1529436 | g6554 | i0 | 41.3 | 1.57959183673469 | 150 | 86 | 90.6 | 1 | 462 | 19 | 5795 | 5944 | XP_033105774.1 uncharacterized protein LOC117108037 [Anneissia japonica] | diamond | 774 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29304225 | 29304225 | PRJNA683669_P_NODE_21649_length_278_cov_1.595122_g21417_i0 | PRJNA683669 | 21649 | 278 | 1.595122 | 4.43443916 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 49.3 | 2.95e-4 | NR | XP_063963159.1 | 7653 | g21417 | i0 | 40.8 | 1.81294964028777 | 49 | 29 | 52.9 | 0 | 195 | 49 | 24 | 72 | XP_063963159.1 mucin-3B-like [Lytechinus pictus] | diamond | 504 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30524478 | 30524478 | PRJNA683669_P_NODE_6493_length_503_cov_1.074419_g6262_i0 | PRJNA683669 | 6493 | 503 | 1.074419 | 5.40432757 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 77 | 5.98e-13 | NR | XP_785055.4 | 7668 | g6262 | i0 | 29.3 | 0.876739562624254 | 147 | 96 | 85.9 | 3 | 481 | 50 | 339 | 480 | XP_785055.4 LOW QUALITY PROTEIN: lysosome membrane protein 2 [Strongylocentrotus purpuratus] | diamond | 441 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30630750 | 30630750 | PRJNA683669_P_NODE_7373_length_471_cov_1.912060_g7142_i0 | PRJNA683669 | 7373 | 471 | 1.91206 | 9.0058026 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 108 | 6.28e-24 | NR | XP_030831805.1 | 7668 | g7142 | i0 | 36 | 2.92993630573248 | 150 | 94 | 94.3 | 2 | 449 | 6 | 572 | 721 | XP_030831805.1 tRNA (cytosine(34)-C(5))-methyltransferase [Strongylocentrotus purpuratus] | diamond | 1380 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30745671 | 30745671 | PRJNA683669_P_NODE_29454_length_247_cov_0.885057_g29222_i0 | PRJNA683669 | 29454 | 247 | 0.885057 | 2.18609079 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 82.4 | 5.56e-18 | NR | XP_038060845.1 | 46514 | g29222 | i0 | 67.2 | 2.13765182186235 | 61 | 19 | 72.9 | 1 | 246 | 67 | 53 | 113 | XP_038060845.1 small nuclear ribonucleoprotein Sm D3-like [Patiria miniata] | diamond | 528 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31104691 | 31104691 | PRJNA683669_P_NODE_12755_length_362_cov_1.598616_g12524_i0 | PRJNA683669 | 12755 | 362 | 1.598616 | 5.78698992 | root | 1 | Root_unresolved | Root_unresolved | 144 | 1.91e-38 | NR | KAJ8042215.1 | 206669 | g12524 | i0 | 57.1 | 5.88397790055249 | 119 | 50 | 98.6 | 1 | 6 | 362 | 155 | 272 | KAJ8042215.1 DnaJ-like subfamily A member 2 [Holothuria leucospilota] | diamond | 2130 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31262855 | 31262855 | PRJNA683669_P_NODE_32675_length_243_cov_0.905882_g32443_i0 | PRJNA683669 | 32675 | 243 | 0.905882 | 2.20129326 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 74.3 | 1.58e-13 | NR | KAJ8046356.1 | 206669 | g32443 | i0 | 44.4 | 7.71604938271605 | 81 | 38 | 91.4 | 1 | 6 | 227 | 133 | 213 | KAJ8046356.1 Mitochondrial substrate carrier family protein ucpB [Holothuria leucospilota] | diamond | 1875 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31472789 | 31472789 | PRJNA683669_P_NODE_18096_length_304_cov_1.333333_g17864_i0 | PRJNA683669 | 18096 | 304 | 1.333333 | 4.05333232 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 47.8 | 0.00134 | NR | XP_022112183.1 | 133434 | g17864 | i0 | 36.8 | 0.858552631578947 | 87 | 44 | 85.9 | 2 | 262 | 2 | 599 | 674 | XP_022112183.1 actin cytoskeleton-regulatory complex protein PAN1-like isoform X2 [Acanthaster planci] | diamond | 261 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31472811 | 31472811 | PRJNA683669_P_NODE_3196_length_734_cov_1.140696_g2987_i0 | PRJNA683669 | 3196 | 734 | 1.140696 | 8.37270864 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 116 | 9.51e-26 | NR | XP_038054398.1 | 46514 | g2987 | i0 | 43.3 | 1.43869209809264 | 178 | 87 | 70.3 | 5 | 26 | 541 | 461 | 630 | XP_038054398.1 dnaJ homolog subfamily C member 2-like [Patiria miniata] | diamond | 1056 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31662256 | 31662256 | PRJNA683669_P_NODE_27757_length_249_cov_0.875000_g27525_i0 | PRJNA683669 | 27757 | 249 | 0.875 | 2.17875 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 69.7 | 3.17e-12 | NR | PIK42818.1 | 307972 | g27525 | i0 | 54.1 | 4.06024096385542 | 61 | 23 | 67.5 | 1 | 5 | 172 | 122 | 182 | PIK42818.1 putative calcineurin subunit B type 2 isoform X1 [Apostichopus japonicus] | diamond | 1011 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32390085 | 32390085 | PRJNA683669_P_NODE_14919_length_336_cov_0.657795_g14688_i0 | PRJNA683669 | 14919 | 336 | 0.657795 | 2.2101912 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 53.5 | 1.95e-5 | NR | XP_063971397.1 | 7653 | g14688 | i0 | 75 | 0.5 | 28 | 7 | 25 | 0 | 327 | 244 | 2100 | 2127 | XP_063971397.1 fibrillin-2-like isoform X3 [Lytechinus pictus] | diamond | 168 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 32642559 | 32642559 | PRJNA683669_P_NODE_18460_length_301_cov_1.245614_g18228_i0 | PRJNA683669 | 18460 | 301 | 1.245614 | 3.74929814 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 59.3 | 1.06e-7 | NR | XP_033101657.1 | 1529436 | g18228 | i0 | 51.6 | 1.2358803986711 | 62 | 26 | 57.8 | 1 | 192 | 19 | 273 | 334 | XP_033101657.1 synaptotagmin-7-like isoform X3 [Anneissia japonica] | diamond | 372 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32674143 | 32674143 | PRJNA683669_P_NODE_2860_length_777_cov_4.075284_g2658_i0 | PRJNA683669 | 2860 | 777 | 4.075284 | 31.66495668 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 49.7 | 0.00959 | NR | XP_071495430.1 | 105358 | g2658 | i0 | 26.8 | 0.532818532818533 | 138 | 69 | 49.8 | 5 | 390 | 4 | 1212 | 1326 | XP_071495430.1 cadherin EGF LAG seven-pass G-type receptor 3-like [Diadema antillarum] | diamond | 414 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum |
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);;