contig_metadata
17 rows where bioproject = "PRJEB39643" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15359855 | 15359855 | PRJEB39643_P_NODE_157133_length_226_cov_2.013072_g156939_i0 | PRJEB39643 | 157133 | 226 | 2.013072 | 4.54954272 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 118 | 6.33e-29 | NR | XP_033647700.1 | 7604 | g156939 | i0 | 73.3 | 6.96902654867257 | 75 | 20 | 99.6 | 0 | 225 | 1 | 441 | 515 | XP_033647700.1 cytosolic 10-formyltetrahydrofolate dehydrogenase-like isoform X2 [Asterias rubens] | diamond | 1575 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 15360571 | 15360571 | PRJEB39643_P_NODE_7473_length_749_cov_3.866864_g7306_i0 | PRJEB39643 | 7473 | 749 | 3.866864 | 28.96281136 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 363 | 4.03e-124 | NR | XP_033125693.1 | 1529436 | g7306 | i0 | 67.9 | 31.9065420560748 | 249 | 75 | 99.7 | 1 | 749 | 3 | 11 | 254 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 23898 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 15360615 | 15360615 | PRJEB39643_P_NODE_78273_length_271_cov_2.898990_g78080_i0 | PRJEB39643 | 78273 | 271 | 2.89899 | 7.8562629 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 173 | 4.13e-50 | NR | XP_033624214.1 | 7604 | g78080 | i0 | 88.9 | 23.7564575645756 | 90 | 10 | 99.6 | 0 | 2 | 271 | 103 | 192 | XP_033624214.1 isocitrate dehydrogenase [NADP], mitochondrial-like [Asterias rubens] | diamond | 6438 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 16635196 | 16635196 | PRJEB39643_P_NODE_75354_length_273_cov_1.540000_g75161_i0 | PRJEB39643 | 75354 | 273 | 1.54 | 4.2042 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 64.7 | 1e-9 | NR | XP_022095731.1 | 133434 | g75161 | i0 | 50 | 2.63736263736264 | 60 | 30 | 65.9 | 0 | 200 | 21 | 713 | 772 | XP_022095731.1 AP-2 complex subunit beta-like isoform X2 [Acanthaster planci] | diamond | 720 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 18841045 | 18841045 | PRJEB39643_P_NODE_13555_length_512_cov_3.758542_g13364_i0 | PRJEB39643 | 13555 | 512 | 3.758542 | 19.24373504 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 268 | 6.619999999999997e-88 | NR | XP_033125693.1 | 1529436 | g13364 | i0 | 71.2 | 1.9921875 | 170 | 49 | 99.6 | 0 | 510 | 1 | 77 | 246 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 1020 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26900294 | 26900294 | PRJEB39643_P_NODE_117101_length_253_cov_1.711111_g116908_i0 | PRJEB39643 | 117101 | 253 | 1.711111 | 4.32911083 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 96.3 | 6.86e-22 | NR | XP_041475610.1 | 7654 | g116908 | i0 | 51.2 | 1.99209486166008 | 84 | 40 | 98.4 | 1 | 5 | 253 | 166 | 249 | XP_041475610.1 carrier protein YMC2, mitochondrial-like [Lytechinus variegatus] | diamond | 504 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27222828 | 27222828 | PRJEB39643_P_NODE_142743_length_243_cov_4.282353_g142550_i0 | PRJEB39643 | 142743 | 243 | 4.282353 | 10.40611779 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 87.8 | 4.69e-18 | NR | XP_033099608.1 | 1529436 | g142550 | i0 | 56.3 | 4.8641975308642 | 80 | 34 | 97.5 | 1 | 6 | 242 | 431 | 510 | XP_033099608.1 26S proteasome non-ATPase regulatory subunit 3-like [Anneissia japonica] | diamond | 1182 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27254505 | 27254505 | PRJEB39643_P_NODE_133843_length_247_cov_1.770115_g133650_i0 | PRJEB39643 | 133843 | 247 | 1.770115 | 4.37218405 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 110 | 4.21e-26 | NR | XP_041478235.1 | 7654 | g133650 | i0 | 69.1 | 4.89473684210526 | 81 | 25 | 98.4 | 0 | 247 | 5 | 322 | 402 | XP_041478235.1 glycine--tRNA ligase-like [Lytechinus variegatus] | diamond | 1209 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27343098 | 27343098 | PRJEB39643_P_NODE_24903_length_366_cov_2.102389_g24710_i0 | PRJEB39643 | 24903 | 366 | 2.102389 | 7.69474374 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.00282 | NR | XP_041453006.1 | 7654 | g24710 | i0 | 32.1 | 3.09836065573771 | 56 | 38 | 45.9 | 0 | 352 | 185 | 105 | 160 | XP_041453006.1 alpha-N-acetylgalactosamine-specific lectin-like [Lytechinus variegatus] | diamond | 1134 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27816723 | 27816723 | PRJEB39643_P_NODE_59364_length_281_cov_1.480769_g59171_i0 | PRJEB39643 | 59364 | 281 | 1.480769 | 4.16096089 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 49.7 | 1.06e-4 | NR | XP_033642187.1 | 7604 | g59171 | i0 | 31.3 | 1.91103202846975 | 96 | 44 | 96.1 | 4 | 273 | 4 | 33 | 112 | XP_033642187.1 riboflavin-binding protein-like [Asterias rubens] | diamond | 537 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27886212 | 27886212 | PRJEB39643_P_NODE_21905_length_389_cov_2.689873_g21712_i0 | PRJEB39643 | 21905 | 389 | 2.689873 | 10.46360597 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 71.6 | 1.51e-11 | NR | XP_038074150.1 | 46514 | g21712 | i0 | 41.5 | 0.724935732647815 | 94 | 52 | 71 | 2 | 388 | 113 | 69 | 161 | XP_038074150.1 circularly permutated Ras protein 1-like [Patiria miniata] | diamond | 282 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28770284 | 28770284 | PRJEB39643_P_NODE_33487_length_321_cov_1.935484_g33294_i0 | PRJEB39643 | 33487 | 321 | 1.935484 | 6.21290364 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 67.8 | 1.5e-10 | NR | XP_038074150.1 | 46514 | g33294 | i0 | 39.4 | 8.11214953271028 | 94 | 44 | 86.9 | 3 | 281 | 3 | 295 | 376 | XP_038074150.1 circularly permutated Ras protein 1-like [Patiria miniata] | diamond | 2604 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30001953 | 30001953 | PRJEB39643_P_NODE_158771_length_213_cov_4.328571_g158577_i0 | PRJEB39643 | 158771 | 213 | 4.328571 | 9.21985623 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 73.6 | 2.35e-13 | NR | XP_022087887.1 | 133434 | g158577 | i0 | 49.3 | 3 | 71 | 26 | 100 | 1 | 1 | 213 | 56 | 116 | XP_022087887.1 ribosome biogenesis protein BRX1 homolog isoform X1 [Acanthaster planci] | diamond | 639 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30159521 | 30159521 | PRJEB39643_P_NODE_157452_length_226_cov_2.013072_g157258_i0 | PRJEB39643 | 157452 | 226 | 2.013072 | 4.54954272 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 59.7 | 1.32e-8 | NR | XP_071506697.1 | 105358 | g157258 | i0 | 50 | 1.55309734513274 | 52 | 24 | 69 | 1 | 67 | 222 | 42 | 91 | XP_071506697.1 apolipoprotein D-like [Diadema antillarum] | diamond | 351 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30791624 | 30791624 | PRJEB39643_P_NODE_103854_length_259_cov_1.655914_g103661_i0 | PRJEB39643 | 103854 | 259 | 1.655914 | 4.28881726 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 73.2 | 8.44e-13 | NR | XP_038070778.1 | 46514 | g103661 | i0 | 52.9 | 0.590733590733591 | 51 | 24 | 59.1 | 0 | 155 | 3 | 547 | 597 | XP_038070778.1 protein neuralized-like [Patiria miniata] | diamond | 153 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31012879 | 31012879 | PRJEB39643_P_NODE_72335_length_274_cov_2.149254_g72142_i0 | PRJEB39643 | 72335 | 274 | 2.149254 | 5.88895596 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 46.6 | 0.0025 | NR | XP_022092098.1 | 133434 | g72142 | i0 | 43.1 | 3.06569343065693 | 58 | 18 | 54.7 | 4 | 19 | 168 | 1522 | 1572 | XP_022092098.1 NFX1-type zinc finger-containing protein 1-like isoform X1 [Acanthaster planci] | diamond | 840 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32119899 | 32119899 | PRJEB39643_P_NODE_125438_length_250_cov_1.740113_g125245_i0 | PRJEB39643 | 125438 | 250 | 1.740113 | 4.3502825 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 42.7 | 0.0408 | NR | XP_063953424.1 | 7653 | g125245 | i0 | 36.7 | 0.588 | 49 | 29 | 58.8 | 1 | 180 | 34 | 205 | 251 | XP_063953424.1 tigger transposable element-derived protein 1-like [Lytechinus pictus] | diamond | 147 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus |
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);;