contig_metadata
16 rows where bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545300 | 545300 | PRJNA561212_P_NODE_18301_length_266_cov_1.062176_g18090_i0 | PRJNA561212 | 18301 | 266 | 1.062176 | 2.82538816 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1826624574|ref|XM_033249209.1| | 1529436 | g18090 | i0 | 100 | 0.21804511278195499 | 29 | 0 | 11 | 0 | 65 | 93 | 599 | 571 | PREDICTED: Anneissia japonica nose resistant to fluoxetine protein 6-like (LOC117107506), transcript variant X2, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 4958796 | 4958796 | PRJNA561212_P_NODE_15624_length_285_cov_1.396226_g15413_i0 | PRJNA561212 | 15624 | 285 | 1.396226 | 3.9792441 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 121 | 9.01e-33 | NR | XP_022100426.1 | 133434 | g15413 | i0 | 77.3 | 3.49473684210526 | 66 | 15 | 69.5 | 0 | 207 | 10 | 6 | 71 | XP_022100426.1 peptidyl-prolyl cis-trans isomerase-like [Acanthaster planci] | diamond | 996 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 8198146 | 8198146 | PRJNA561212_P_NODE_10347_length_343_cov_1.392593_g10136_i0 | PRJNA561212 | 10347 | 343 | 1.392593 | 4.77659399 | root | 1 | Root_unresolved | Root_unresolved | 205 | 1.7800000000000001e-63 | NR | XP_041473682.1 | 7654 | g10136 | i0 | 82.6 | 223.128279883382 | 109 | 19 | 95.3 | 0 | 8 | 334 | 1 | 109 | XP_041473682.1 ras-related protein Rac1 [Lytechinus variegatus] | diamond | 76533 | 207 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 10749584 | 10749584 | PRJNA561212_P_NODE_13109_length_308_cov_1.668085_g12898_i0 | PRJNA561212 | 13109 | 308 | 1.668085 | 5.1377018 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 5.2399999999999995e-30 | NR | XP_063957111.1 | 7653 | g12898 | i0 | 62.2 | 20.5032467532468 | 98 | 34 | 92.5 | 2 | 299 | 15 | 131 | 228 | XP_063957111.1 myb-related protein B-like [Lytechinus pictus] | diamond | 6315 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 18397209 | 18397209 | PRJNA561212_P_NODE_1555_length_871_cov_2.231830_g1372_i0 | PRJNA561212 | 1555 | 871 | 2.23183 | 19.4392393 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 302 | 5.62e-100 | NR | XP_071509452.1 | 105358 | g1372 | i0 | 66.2 | 1.52583237657865 | 222 | 72 | 76.5 | 3 | 798 | 133 | 3 | 221 | XP_071509452.1 peroxiredoxin-6-like [Diadema antillarum] | diamond | 1329 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 18982085 | 18982085 | PRJNA561212_P_NODE_23515_length_247_cov_0.879310_g23304_i0 | PRJNA561212 | 23515 | 247 | 0.87931 | 2.1718957 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 58.4 | 4.8e-4 | NTclustered | gi|1752406687|ref|XM_030975445.1| | 7668 | g23304 | i0 | 97.059 | 12.0485829959514 | 34 | 1 | 14 | 0 | 109 | 142 | 1986 | 2019 | PREDICTED: Strongylocentrotus purpuratus CCR4-NOT transcription complex subunit 10 (LOC575687), transcript variant X1, mRNA | blastn | 2976 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 21532704 | 21532704 | PRJNA561212_P_NODE_14337_length_296_cov_0.883408_g14126_i0 | PRJNA561212 | 14337 | 296 | 0.883408 | 2.61488768 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1752351012|ref|XM_030981071.1| | 7668 | g14126 | i0 | 96.774 | 0.827702702702703 | 31 | 1 | 10 | 0 | 82 | 112 | 1100 | 1130 | PREDICTED: Strongylocentrotus purpuratus nuclear pore complex protein Nup98-Nup96 (LOC593572), transcript variant X2, mRNA | blastn | 245 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 23497932 | 23497932 | PRJNA561212_P_NODE_8839_length_370_cov_0.838384_g8628_i0 | PRJNA561212 | 8839 | 370 | 0.838384 | 3.1020208 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 274 | 6.889999999999998e-69 | NTclustered | gi|2919369550|ref|XM_071652004.1| | 105358 | g8628 | i0 | 80.791 | 27.3756756756757 | 354 | 64 | 95 | 3 | 10 | 361 | 578 | 929 | PREDICTED: Diadema antillarum calreticulin-like (LOC139741415), mRNA | blastn | 10129 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 24771482 | 24771482 | PRJNA561212_P_NODE_10000_length_349_cov_1.072464_g9789_i0 | PRJNA561212 | 10000 | 349 | 1.072464 | 3.74289936 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 128 | 5.32e-25 | NTclustered | gi|2707408381|ref|XM_054893204.2| | 7653 | g9789 | i0 | 83.333 | 4.91404011461318 | 138 | 23 | 40 | 0 | 10 | 147 | 460 | 597 | PREDICTED: Lytechinus pictus dynein light chain 2, cytoplasmic-like (LOC129254696), mRNA | blastn | 1715 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27173731 | 27173731 | PRJNA561212_P_NODE_302_length_1707_cov_1.711138_g234_i0 | PRJNA561212 | 302 | 1707 | 1.711138 | 29.20912566 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 67 | 1.66e-8 | NR | XP_022088391.1 | 133434 | g234 | i0 | 44.3 | 0.996485061511424 | 70 | 39 | 12.3 | 0 | 1119 | 1328 | 147 | 216 | XP_022088391.1 LIM and SH3 domain protein 1-like isoform X3 [Acanthaster planci] | diamond | 1701 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27440984 | 27440984 | PRJNA561212_P_NODE_25303_length_243_cov_0.917647_g25092_i0 | PRJNA561212 | 25303 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.9 | 7.79e-14 | NR | XP_038078053.1 | 46514 | g25092 | i0 | 58.7 | 1.69135802469136 | 63 | 25 | 76.5 | 1 | 232 | 47 | 193 | 255 | XP_038078053.1 uncharacterized protein LOC119745626 [Patiria miniata] | diamond | 411 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28166953 | 28166953 | PRJNA561212_P_NODE_1165_length_995_cov_2.087852_g1006_i0 | PRJNA561212 | 1165 | 995 | 2.087852 | 20.7741274 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 280 | 1.77e-86 | NR | XP_033641862.1 | 7604 | g1006 | i0 | 45.8 | 2.00804020100503 | 334 | 175 | 99.2 | 2 | 988 | 2 | 70 | 402 | XP_033641862.1 protein mono-ADP-ribosyltransferase PARP3-like [Asterias rubens] | diamond | 1998 | 280 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28419606 | 28419606 | PRJNA561212_P_NODE_18226_length_266_cov_1.528497_g18015_i0 | PRJNA561212 | 18226 | 266 | 1.528497 | 4.06580202 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 48.9 | 2.86e-4 | NR | XP_022084493.1 | 133434 | g18015 | i0 | 39.8 | 3.84586466165414 | 88 | 40 | 92.5 | 5 | 254 | 9 | 105 | 185 | XP_022084493.1 piRNA biogenesis protein EXD1-like [Acanthaster planci] | diamond | 1023 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30900701 | 30900701 | PRJNA561212_P_NODE_16894_length_276_cov_1.108374_g16683_i0 | PRJNA561212 | 16894 | 276 | 1.108374 | 3.05911224 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 102 | 5e-24 | NR | XP_033105668.1 | 1529436 | g16683 | i0 | 58.3 | 2.72826086956522 | 84 | 35 | 91.3 | 0 | 18 | 269 | 196 | 279 | XP_033105668.1 60S ribosomal protein L5-like [Anneissia japonica] | diamond | 753 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31248151 | 31248151 | PRJNA561212_P_NODE_5915_length_453_cov_3.742105_g5704_i0 | PRJNA561212 | 5915 | 453 | 3.742105 | 16.95173565 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 50.8 | 4.69e-4 | NR | XP_071510199.1 | 105358 | g5704 | i0 | 38.8 | 2.56291390728477 | 67 | 37 | 42.4 | 3 | 309 | 118 | 369 | 434 | XP_071510199.1 uncharacterized protein [Diadema antillarum] | diamond | 1161 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32260744 | 32260744 | PRJNA561212_P_NODE_14158_length_297_cov_2.031250_g13947_i0 | PRJNA561212 | 14158 | 297 | 2.03125 | 6.0328125 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 137 | 8.449999999999999e-38 | NR | XP_033639471.1 | 7604 | g13947 | i0 | 66.7 | 0.939393939393939 | 93 | 31 | 93.9 | 0 | 11 | 289 | 113 | 205 | XP_033639471.1 isopentenyl-diphosphate Delta-isomerase 1-like [Asterias rubens] | diamond | 279 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens |
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);;