contig_metadata
14 rows where bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1092509 | 1092509 | PRJNA450343_P_NODE_1621_length_434_cov_13.740260_g1553_i0 | PRJNA450343 | 1621 | 434 | 13.74026 | 59.6327284 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 396 | 1.68e-105 | NTclustered | gi|2038000226|ref|XM_041613234.1| | 7654 | g1553 | i0 | 84.406 | 69.168202764977 | 404 | 61 | 93 | 2 | 1 | 403 | 501 | 99 | PREDICTED: Lytechinus variegatus ubiquitin-40S ribosomal protein S27a (LOC121418982), mRNA | blastn | 30019 | 399 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 6816783 | 6816783 | PRJNA450343_P_NODE_12766_length_163_cov_0.894737_g12698_i0 | PRJNA450343 | 12766 | 163 | 0.894737 | 1.45842131 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 139 | 1.01e-28 | NTclustered | gi|2919374413|ref|XM_071625007.1| | 105358 | g12698 | i0 | 82.39 | 77.601226993865 | 159 | 28 | 98 | 0 | 1 | 159 | 2005 | 1847 | PREDICTED: Diadema antillarum urease subunit alpha-like (LOC139713260), mRNA | blastn | 12649 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 13192663 | 13192663 | PRJNA450343_P_NODE_891_length_601_cov_1.681159_g827_i0 | PRJNA450343 | 891 | 601 | 1.681159 | 10.10376559 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 84.2 | 2.11e-11 | NTclustered | gi|2919464631|ref|XM_071643143.1| | 105358 | g827 | i0 | 96.078 | 0.479201331114809 | 51 | 2 | 8 | 0 | 1 | 51 | 383 | 433 | PREDICTED: Diadema antillarum gamma-aminobutyric acid receptor-associated protein (LOC139732270), mRNA | blastn | 288 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 14467702 | 14467702 | PRJNA450343_P_NODE_5232_length_232_cov_1.180328_g5164_i0 | PRJNA450343 | 5232 | 232 | 1.180328 | 2.73836096 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 139 | 5.29e-38 | NR | XP_041458658.1 | 7654 | g5164 | i0 | 84.4 | 16.926724137931 | 77 | 12 | 99.6 | 0 | 231 | 1 | 247 | 323 | XP_041458658.1 procathepsin L-like [Lytechinus variegatus] | diamond | 3927 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 20218709 | 20218709 | PRJNA450343_P_NODE_10296_length_169_cov_1.700000_g10228_i0 | PRJNA450343 | 10296 | 169 | 1.7 | 2.873 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.4 | 1.5400000000000001e-22 | NR | XP_033647297.1 | 7604 | g10228 | i0 | 85.2 | 50.2011834319527 | 54 | 8 | 95.9 | 0 | 164 | 3 | 550 | 603 | XP_033647297.1 isoleucine--tRNA ligase, cytoplasmic-like [Asterias rubens] | diamond | 8484 | 99.8 | 0.995991983967936 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 23391312 | 23391312 | PRJNA450343_P_NODE_8479_length_186_cov_3.700730_g8411_i0 | PRJNA450343 | 8479 | 186 | 3.70073 | 6.8833578 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 135 | 1.53e-27 | NTclustered | gi|1826636548|ref|XM_033259799.1| | 1529436 | g8411 | i0 | 85.827 | 1.84408602150538 | 127 | 18 | 68 | 0 | 60 | 186 | 240 | 366 | PREDICTED: Anneissia japonica serine/threonine-protein phosphatase 4 catalytic subunit (LOC117115853), mRNA | blastn | 343 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26981107 | 26981107 | PRJNA450343_P_NODE_13822_length_161_cov_0.910714_g13754_i0 | PRJNA450343 | 13822 | 161 | 0.910714 | 1.46624954 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 73.2 | 2.15e-13 | NR | PIK36780.1 | 307972 | g13754 | i0 | 61.8 | 2.04968944099379 | 55 | 19 | 98.8 | 1 | 3 | 161 | 236 | 290 | PIK36780.1 hypothetical protein BSL78_26389 [Apostichopus japonicus] | diamond | 330 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27377103 | 27377103 | PRJNA450343_P_NODE_13103_length_162_cov_2.256637_g13035_i0 | PRJNA450343 | 13103 | 162 | 2.256637 | 3.65575194 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 43.5 | 0.00684 | NR | KAJ8038107.1 | 206669 | g13035 | i0 | 52 | 1.7962962962963 | 50 | 22 | 88.9 | 1 | 147 | 4 | 262 | 311 | KAJ8038107.1 Cytochrome b-c1 complex subunit 2, mitochondrial [Holothuria leucospilota] | diamond | 291 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27440254 | 27440254 | PRJNA450343_P_NODE_11443_length_166_cov_0.871795_g11375_i0 | PRJNA450343 | 11443 | 166 | 0.871795 | 1.4471797 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 61.2 | 3.32e-9 | NR | XP_038065191.1 | 46514 | g11375 | i0 | 57.8 | 4.01204819277108 | 45 | 18 | 79.5 | 1 | 147 | 16 | 266 | 310 | XP_038065191.1 sulfotransferase 1C2-like isoform X3 [Patiria miniata] | diamond | 666 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30202225 | 30202225 | PRJNA450343_P_NODE_9052_length_181_cov_1.545455_g8984_i0 | PRJNA450343 | 9052 | 181 | 1.545455 | 2.79727355 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 50.8 | 2.32e-5 | NR | XP_033108491.1 | 1529436 | g8984 | i0 | 34.4 | 1.01104972375691 | 61 | 33 | 91.2 | 2 | 13 | 177 | 1375 | 1434 | XP_033108491.1 fibropellin-1-like [Anneissia japonica] | diamond | 183 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31577770 | 31577770 | PRJNA450343_P_NODE_5056_length_236_cov_0.957219_g4988_i0 | PRJNA450343 | 5056 | 236 | 0.957219 | 2.25903684 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 45.1 | 0.00541 | NR | XP_030829916.1 | 7668 | g4988 | i0 | 55.9 | 4.66525423728814 | 34 | 14 | 41.9 | 1 | 4 | 102 | 2710 | 2743 | XP_030829916.1 low-density lipoprotein receptor-related protein 1 [Strongylocentrotus purpuratus] | diamond | 1101 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31656137 | 31656137 | PRJNA450343_P_NODE_2797_length_323_cov_1.532847_g2729_i0 | PRJNA450343 | 2797 | 323 | 1.532847 | 4.95109581 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 80.5 | 4.74e-15 | NR | XP_033097464.1 | 1529436 | g2729 | i0 | 41.7 | 0.891640866873065 | 96 | 55 | 89.2 | 1 | 290 | 3 | 324 | 418 | XP_033097464.1 cytochrome b-c1 complex subunit 2, mitochondrial-like [Anneissia japonica] | diamond | 288 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31909400 | 31909400 | PRJNA450343_P_NODE_3697_length_277_cov_2.451754_g3629_i0 | PRJNA450343 | 3697 | 277 | 2.451754 | 6.79135858 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 112 | 6.919999999999999e-28 | NR | PIK51398.1 | 307972 | g3629 | i0 | 73.7 | 0.823104693140794 | 76 | 20 | 82.3 | 0 | 10 | 237 | 198 | 273 | PIK51398.1 hypothetical protein BSL78_11720 [Apostichopus japonicus] | diamond | 228 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32590185 | 32590185 | PRJNA450343_P_NODE_5359_length_230_cov_0.845304_g5291_i0 | PRJNA450343 | 5359 | 230 | 0.84530400000000006 | 1.9441992 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 105 | 4.96e-26 | NR | XP_033625406.1 | 7604 | g5291 | i0 | 60.5 | 4.87826086956522 | 76 | 30 | 99.1 | 0 | 230 | 3 | 71 | 146 | XP_033625406.1 translin-like [Asterias rubens] | diamond | 1122 | 105 | 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);;