contig_metadata
26 rows where bioproject = "PRJNA1102048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7397786 | 7397786 | PRJNA1102048_P_NODE_12806_length_251_cov_0.865169_g12702_i0 | PRJNA1102048 | 12806 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|70887808|gb|AC165428.1| | 7668 | g12702 | i0 | 94.444 | 1.41434262948207 | 36 | 0 | 14 | 1 | 126 | 159 | 481019 | 481054 | Strongylocentrotus purpuratus BAC clone contig containing Eve, the hox cluster, cholinesterase, and COLP5alpha genes, complete sequence | blastn | 355 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 7397790 | 7397790 | PRJNA1102048_P_NODE_14426_length_247_cov_2.643678_g14322_i0 | PRJNA1102048 | 14426 | 247 | 2.643678 | 6.52988466 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 172 | 1.64e-38 | NTclustered | gi|2707444094|ref|XM_054906737.2| | 7653 | g14322 | i0 | 80.909 | 59.7165991902834 | 220 | 40 | 89 | 2 | 29 | 247 | 147 | 365 | PREDICTED: Lytechinus pictus ras-related C3 botulinum toxin substrate 1-like (LOC129269263), transcript variant X1, mRNA | blastn | 14750 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 10415102 | 10415102 | PRJNA1102048_P_NODE_16369_length_243_cov_2.923529_g16265_i0 | PRJNA1102048 | 16369 | 243 | 2.923529 | 7.10417547 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 128 | 3.54e-25 | NTclustered | gi|1752359748|ref|XM_030984758.1| | 7668 | g16265 | i0 | 84.496 | 6.39506172839506 | 129 | 20 | 53 | 0 | 1 | 129 | 354 | 226 | PREDICTED: Strongylocentrotus purpuratus NHP2-like protein 1 (LOC587294), mRNA | blastn | 1554 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 12965653 | 12965653 | PRJNA1102048_P_NODE_931_length_762_cov_2.373004_g839_i0 | PRJNA1102048 | 931 | 762 | 2.373004 | 18.08229048 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 288 | 6.66e-95 | NR | XP_038051326.1 | 46514 | g839 | i0 | 59 | 18.6574803149606 | 234 | 96 | 92.1 | 0 | 728 | 27 | 13 | 246 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 14217 | 288 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 15514407 | 15514407 | PRJNA1102048_P_NODE_4693_length_394_cov_1.482866_g4589_i0 | PRJNA1102048 | 4693 | 394 | 1.482866 | 5.84249204 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 173 | 5.49e-51 | NR | KAJ8038900.1 | 206669 | g4589 | i0 | 65.9 | 2.01015228426396 | 132 | 41 | 99 | 2 | 392 | 3 | 94 | 223 | KAJ8038900.1 60S ribosomal protein L5 [Holothuria leucospilota] | diamond | 792 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 21422019 | 21422019 | PRJNA1102048_P_NODE_14157_length_248_cov_0.880000_g14053_i0 | PRJNA1102048 | 14157 | 248 | 0.88 | 2.1824 | Asteroidea | 7588 | Echinodermata | other_Eukaryota | 142 | 4.64e-37 | NR | XP_033638890.1 | 7604 | g14053 | i0 | 74.4 | 7.91129032258065 | 82 | 21 | 99.2 | 0 | 248 | 3 | 628 | 709 | XP_033638890.1 dihydropyrimidinase-like isoform X2 [Asterias rubens] | diamond | 1962 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 21422039 | 21422039 | PRJNA1102048_P_NODE_8577_length_296_cov_3.381166_g8473_i0 | PRJNA1102048 | 8577 | 296 | 3.381166 | 10.00825136 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 144 | 2.27e-40 | NR | XP_033125693.1 | 1529436 | g8473 | i0 | 66 | 3.79054054054054 | 94 | 32 | 95.3 | 0 | 295 | 14 | 166 | 259 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 1122 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26624450 | 26624450 | PRJNA1102048_P_NODE_17921_length_239_cov_2.632530_g17817_i0 | PRJNA1102048 | 17921 | 239 | 2.63253 | 6.2917467 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 43.9 | 0.0142 | NR | KAJ8041353.1 | 206669 | g17817 | i0 | 39.3 | 2.17154811715481 | 56 | 34 | 70.3 | 0 | 3 | 170 | 263 | 318 | KAJ8041353.1 F-actin-uncapping protein LRRC16A [Holothuria leucospilota] | diamond | 519 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 26687787 | 26687787 | PRJNA1102048_P_NODE_7001_length_327_cov_1.212598_g6897_i0 | PRJNA1102048 | 7001 | 327 | 1.212598 | 3.96519546 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 177 | 1.28e-50 | NR | KAJ8045576.1 | 206669 | g6897 | i0 | 76.6 | 15.7064220183486 | 107 | 25 | 98.2 | 0 | 325 | 5 | 231 | 337 | KAJ8045576.1 Methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial [Holothuria leucospilota] | diamond | 5136 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27153362 | 27153362 | PRJNA1102048_P_NODE_8682_length_295_cov_1.094595_g8578_i0 | PRJNA1102048 | 8682 | 295 | 1.094595 | 3.22905525 | Asteroidea | 7588 | Echinodermata | other_Eukaryota | 134 | 1.52e-35 | NR | XP_033626720.1 | 7604 | g8578 | i0 | 60 | 1.93220338983051 | 95 | 37 | 96.6 | 1 | 293 | 9 | 108 | 201 | XP_033626720.1 uncharacterized protein LOC117289624 isoform X2 [Asterias rubens] | diamond | 570 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27343710 | 27343710 | PRJNA1102048_P_NODE_7643_length_314_cov_2.473029_g7539_i0 | PRJNA1102048 | 7643 | 314 | 2.473029 | 7.76531106 | root | 1 | Root_unresolved | Root_unresolved | 101 | 3.03e-25 | NR | XP_033627483.1 | 7604 | g7539 | i0 | 79.4 | 2.68471337579618 | 68 | 14 | 65 | 0 | 305 | 102 | 1 | 68 | XP_033627483.1 60S acidic ribosomal protein P2-like [Asterias rubens] | diamond | 843 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27501544 | 27501544 | PRJNA1102048_P_NODE_4723_length_393_cov_1.343750_g4619_i0 | PRJNA1102048 | 4723 | 393 | 1.34375 | 5.2809375 | root | 1 | Root_unresolved | Root_unresolved | 66.2 | 1.14e-9 | NR | XP_038074569.1 | 46514 | g4619 | i0 | 35.6 | 1.6412213740458 | 135 | 68 | 98.5 | 6 | 3 | 389 | 447 | 568 | XP_038074569.1 dye-decolorizing peroxidase msp1-like [Patiria miniata] | diamond | 645 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27785753 | 27785753 | PRJNA1102048_P_NODE_17104_length_242_cov_0.911243_g17000_i0 | PRJNA1102048 | 17104 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 69.3 | 1.55e-11 | NR | XP_071490513.1 | 105358 | g17000 | i0 | 42.4 | 8.4297520661157 | 66 | 37 | 80.6 | 1 | 1 | 195 | 325 | 390 | XP_071490513.1 acid phosphatase type 7-like [Diadema antillarum] | diamond | 2040 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 28425804 | 28425804 | PRJNA1102048_P_NODE_15606_length_245_cov_0.895349_g15502_i0 | PRJNA1102048 | 15606 | 245 | 0.895349 | 2.19360505 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 60.5 | 2.06e-8 | NR | XP_038072562.1 | 46514 | g15502 | i0 | 52.5 | 0.489795918367347 | 40 | 19 | 49 | 0 | 191 | 72 | 20 | 59 | XP_038072562.1 egl nine homolog 1-like [Patiria miniata] | diamond | 120 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29215265 | 29215265 | PRJNA1102048_P_NODE_7329_length_320_cov_1.352227_g7225_i0 | PRJNA1102048 | 7329 | 320 | 1.352227 | 4.3271264 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 112 | 1.33e-26 | NR | KAJ8043112.1 | 206669 | g7225 | i0 | 51.6 | 0.853125 | 91 | 43 | 85.3 | 1 | 46 | 318 | 161 | 250 | KAJ8043112.1 Nucleoredoxin [Holothuria leucospilota] | diamond | 273 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29648010 | 29648010 | PRJNA1102048_P_NODE_3890_length_432_cov_5.228412_g3786_i0 | PRJNA1102048 | 3890 | 432 | 5.228412 | 22.58673984 | root | 1 | Root_unresolved | Root_unresolved | 137 | 1.99e-38 | NR | KAJ8033962.1 | 206669 | g3786 | i0 | 53.1 | 7.14583333333333 | 130 | 61 | 90.3 | 0 | 396 | 7 | 1 | 130 | KAJ8033962.1 40S ribosomal protein S12 [Holothuria leucospilota] | diamond | 3087 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30343893 | 30343893 | PRJNA1102048_P_NODE_12532_length_251_cov_2.573034_g12428_i0 | PRJNA1102048 | 12532 | 251 | 2.573034 | 6.45831534 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 3.08e-14 | NR | XP_041485260.1 | 7654 | g12428 | i0 | 48.6 | 2.59362549800797 | 72 | 34 | 86.1 | 2 | 216 | 1 | 4 | 72 | XP_041485260.1 cysteine-rich protein 1-like [Lytechinus variegatus] | diamond | 651 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30722363 | 30722363 | PRJNA1102048_P_NODE_6314_length_343_cov_12.974074_g6210_i0 | PRJNA1102048 | 6314 | 343 | 12.974074 | 44.50107382 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 125 | 1.0699999999999999e-34 | NR | XP_022087362.1 | 133434 | g6210 | i0 | 65.5 | 6.13119533527697 | 87 | 30 | 76.1 | 0 | 319 | 59 | 3 | 89 | XP_022087362.1 probable 60S ribosomal protein L37-A isoform X2 [Acanthaster planci] | diamond | 2103 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30825906 | 30825906 | PRJNA1102048_P_NODE_14214_length_248_cov_0.880000_g14110_i0 | PRJNA1102048 | 14214 | 248 | 0.88 | 2.1824 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 69.7 | 1.26e-11 | NR | XP_041479340.1 | 7654 | g14110 | i0 | 48.3 | 35.5282258064516 | 89 | 39 | 99.2 | 1 | 247 | 2 | 481 | 569 | XP_041479340.1 chloride channel protein 2-like isoform X1 [Lytechinus variegatus] | diamond | 8811 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30857455 | 30857455 | PRJNA1102048_P_NODE_13534_length_249_cov_1.636364_g13430_i0 | PRJNA1102048 | 13534 | 249 | 1.636364 | 4.07454636 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 109 | 2.98e-28 | NR | XP_033642920.1 | 7604 | g13430 | i0 | 63.1 | 2.01204819277108 | 84 | 30 | 100 | 1 | 249 | 1 | 65 | 148 | XP_033642920.1 peptidyl-prolyl cis-trans isomerase Pin1-like [Asterias rubens] | diamond | 501 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31047428 | 31047428 | PRJNA1102048_P_NODE_7855_length_310_cov_1.616034_g7751_i0 | PRJNA1102048 | 7855 | 310 | 1.616034 | 5.0097054 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 117 | 1.39e-28 | NR | XP_022096246.1 | 133434 | g7751 | i0 | 53.9 | 2.92258064516129 | 102 | 47 | 98.7 | 0 | 3 | 308 | 148 | 249 | XP_022096246.1 nucleoredoxin-like [Acanthaster planci] | diamond | 906 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31733920 | 31733920 | PRJNA1102048_P_NODE_6337_length_343_cov_1.137037_g6233_i0 | PRJNA1102048 | 6337 | 343 | 1.137037 | 3.90003691 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 4.82e-5 | NR | XP_033640528.1 | 7604 | g6233 | i0 | 43 | 4.05830903790087 | 79 | 40 | 67.3 | 3 | 111 | 341 | 655 | 730 | XP_033640528.1 gamma-aminobutyric acid type B receptor subunit 1-like isoform X4 [Asterias rubens] | diamond | 1392 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31774334 | 31774334 | PRJNA1102048_P_NODE_16377_length_243_cov_2.541176_g16273_i0 | PRJNA1102048 | 16377 | 243 | 2.541176 | 6.17505768 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 55.8 | 1.92e-7 | NR | XP_038071266.1 | 46514 | g16273 | i0 | 48 | 1.2962962962963 | 50 | 26 | 61.7 | 0 | 241 | 92 | 86 | 135 | XP_038071266.1 cystatin-A-like [Patiria miniata] | diamond | 315 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32082031 | 32082031 | PRJNA1102048_P_NODE_14038_length_248_cov_1.320000_g13934_i0 | PRJNA1102048 | 14038 | 248 | 1.32 | 3.2736 | root | 1 | Root_unresolved | Root_unresolved | 100 | 1.1099999999999999e-23 | NR | XP_041462087.1 | 7654 | g13934 | i0 | 66.3 | 60.1814516129032 | 83 | 26 | 98 | 1 | 4 | 246 | 1 | 83 | XP_041462087.1 40S ribosomal protein S3a-like [Lytechinus variegatus] | diamond | 14925 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32185837 | 32185837 | PRJNA1102048_P_NODE_8238_length_303_cov_1.743478_g8134_i0 | PRJNA1102048 | 8238 | 303 | 1.743478 | 5.28273834 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 143 | 4.9199999999999996e-40 | NR | XP_033125693.1 | 1529436 | g8134 | i0 | 64.9 | 3.72277227722772 | 94 | 33 | 93.1 | 0 | 295 | 14 | 166 | 259 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 1128 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32902991 | 32902991 | PRJNA1102048_P_NODE_15920_length_244_cov_1.783626_g15816_i0 | PRJNA1102048 | 15920 | 244 | 1.783626 | 4.35204744 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 57.4 | 2.43e-7 | NR | XP_071502678.1 | 105358 | g15816 | i0 | 51.8 | 1.40163934426229 | 56 | 23 | 68.9 | 1 | 70 | 237 | 138 | 189 | XP_071502678.1 protein YIPF3-like [Diadema antillarum] | diamond | 342 | 57.4 | 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);;