contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4722161 | 4722161 | PRJNA911178_P_NODE_89624_length_378_cov_2.144262_g87154_i0 | PRJNA911178 | 89624 | 378 | 2.144262 | 8.10531036 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 207 | 5.25e-65 | NR | XP_038051326.1 | 46514 | g87154 | i0 | 75 | 40.3650793650794 | 124 | 31 | 98.4 | 0 | 372 | 1 | 117 | 240 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 15258 | 208 | 0.995192307692308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 7628784 | 7628784 | PRJNA911178_P_NODE_70106_length_421_cov_1.416667_g67644_i0 | PRJNA911178 | 70106 | 421 | 1.416667 | 5.96416807 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 181 | 3.879999999999999e-54 | NR | XP_033125693.1 | 1529436 | g67644 | i0 | 66.1 | 20.1947743467933 | 118 | 40 | 84.1 | 0 | 418 | 65 | 142 | 259 | XP_033125693.1 40S ribosomal protein S4, X isoform-like [Anneissia japonica] | diamond | 8502 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26866491 | 26866491 | PRJNA911178_P_NODE_235881_length_253_cov_1.422222_g233407_i0 | PRJNA911178 | 235881 | 253 | 1.422222 | 3.59822166 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 69.7 | 1.29e-11 | NR | XP_071489463.1 | 105358 | g233407 | i0 | 49.2 | 2.8695652173913 | 65 | 33 | 77.1 | 0 | 51 | 245 | 77 | 141 | XP_071489463.1 tectonic-1-like [Diadema antillarum] | diamond | 726 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27245683 | 27245683 | PRJNA911178_P_NODE_233063_length_254_cov_2.033149_g230589_i0 | PRJNA911178 | 233063 | 254 | 2.033149 | 5.16419846 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 72.8 | 7.26e-13 | NR | KAJ8047614.1 | 206669 | g230589 | i0 | 48.6 | 0.874015748031496 | 74 | 35 | 86.2 | 2 | 219 | 1 | 139 | 210 | KAJ8047614.1 hypothetical protein HOLleu_06656 [Holothuria leucospilota] | diamond | 222 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28192872 | 28192872 | PRJNA911178_P_NODE_237326_length_252_cov_1.698324_g234852_i0 | PRJNA911178 | 237326 | 252 | 1.698324 | 4.27977648 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 49.3 | 2.11e-4 | NR | XP_022106754.1 | 133434 | g234852 | i0 | 46.6 | 2.16666666666667 | 58 | 30 | 67.9 | 1 | 49 | 219 | 136 | 193 | XP_022106754.1 metabotropic glutamate receptor-like [Acanthaster planci] | diamond | 546 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28200277 | 28200277 | PRJNA911178_P_NODE_149646_length_305_cov_1.655172_g147173_i0 | PRJNA911178 | 149646 | 305 | 1.655172 | 5.0482746 | root | 1 | Root_unresolved | Root_unresolved | 104 | 2.1899999999999998e-25 | NR | KAJ8046287.1 | 206669 | g147173 | i0 | 47.3 | 3.11803278688525 | 110 | 47 | 98.4 | 5 | 6 | 305 | 10 | 118 | KAJ8046287.1 hypothetical protein HOLleu_04908 [Holothuria leucospilota] | diamond | 951 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28350903 | 28350903 | PRJNA911178_P_NODE_245646_length_250_cov_0.870056_g243172_i0 | PRJNA911178 | 245646 | 250 | 0.870056 | 2.17514 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 61.6 | 8.72e-9 | NR | XP_033101551.1 | 1529436 | g243172 | i0 | 41.3 | 0.9 | 75 | 41 | 86.4 | 2 | 218 | 3 | 5 | 79 | XP_033101551.1 GPI transamidase component PIG-T-like [Anneissia japonica] | diamond | 225 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28414243 | 28414243 | PRJNA911178_P_NODE_271546_length_245_cov_0.895349_g269072_i0 | PRJNA911178 | 271546 | 245 | 0.895349 | 2.19360505 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 45.4 | 0.00418 | NR | XP_041468214.1 | 7654 | g269072 | i0 | 39.7 | 1.89795918367347 | 78 | 46 | 95.5 | 1 | 3 | 236 | 232 | 308 | XP_041468214.1 UPF0394 inner membrane protein YeeE-like [Lytechinus variegatus] | diamond | 465 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28958504 | 28958504 | PRJNA911178_P_NODE_127768_length_326_cov_1.620553_g125296_i0 | PRJNA911178 | 127768 | 326 | 1.620553 | 5.28300278 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 125 | 6.16e-31 | NR | XP_041467936.1 | 7654 | g125296 | i0 | 78.3 | 6.98466257668712 | 69 | 15 | 63.5 | 0 | 321 | 115 | 288 | 356 | XP_041467936.1 serine palmitoyltransferase 2-like [Lytechinus variegatus] | diamond | 2277 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29084704 | 29084704 | PRJNA911178_P_NODE_285428_length_242_cov_1.763314_g282954_i0 | PRJNA911178 | 285428 | 242 | 1.763314 | 4.26721988 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 67 | 1.06e-10 | NR | XP_033642721.1 | 7604 | g282954 | i0 | 40.7 | 4.38842975206612 | 81 | 46 | 97.9 | 1 | 3 | 239 | 2372 | 2452 | XP_033642721.1 ATP-binding cassette sub-family A member 2-like isoform X2 [Asterias rubens] | diamond | 1062 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29393050 | 29393050 | PRJNA911178_P_NODE_262749_length_247_cov_0.885057_g260275_i0 | PRJNA911178 | 262749 | 247 | 0.885057 | 2.18609079 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 72.4 | 1.42e-12 | NR | XP_033624259.1 | 7604 | g260275 | i0 | 53.4 | 1.65182186234818 | 58 | 27 | 70.4 | 0 | 8 | 181 | 300 | 357 | XP_033624259.1 carnitine O-palmitoyltransferase 1, liver isoform-like [Asterias rubens] | diamond | 408 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 29400300 | 29400300 | PRJNA911178_P_NODE_266489_length_246_cov_0.890173_g264015_i0 | PRJNA911178 | 266489 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 111 | 3.2e-26 | NR | XP_041475330.1 | 7654 | g264015 | i0 | 63 | 11.7560975609756 | 81 | 30 | 98.8 | 0 | 243 | 1 | 2288 | 2368 | XP_041475330.1 dynein heavy chain 7, axonemal-like isoform X1 [Lytechinus variegatus] | diamond | 2892 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30221380 | 30221380 | PRJNA911178_P_NODE_225372_length_258_cov_1.643243_g222898_i0 | PRJNA911178 | 225372 | 258 | 1.643243 | 4.23956694 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 70.9 | 5.64e-12 | NR | XP_063960606.1 | 7653 | g222898 | i0 | 39.5 | 4.43023255813953 | 76 | 41 | 82.6 | 1 | 215 | 3 | 511 | 586 | XP_063960606.1 uncharacterized protein LOC129268408 [Lytechinus pictus] | diamond | 1143 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30379837 | 30379837 | PRJNA911178_P_NODE_30852_length_613_cov_1.103704_g28496_i0 | PRJNA911178 | 30852 | 613 | 1.103704 | 6.76570552 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 84 | 6.77e-15 | NR | XP_033633275.1 | 7604 | g28496 | i0 | 45.5 | 1.76182707993475 | 88 | 40 | 43.1 | 2 | 605 | 342 | 206 | 285 | XP_033633275.1 cubilin-like [Asterias rubens] | diamond | 1080 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30632042 | 30632042 | PRJNA911178_P_NODE_271653_length_245_cov_0.895349_g269179_i0 | PRJNA911178 | 271653 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.2 | 2e-10 | NR | XP_030854961.1 | 7668 | g269179 | i0 | 45.7 | 9.04897959183674 | 81 | 36 | 99.2 | 1 | 2 | 244 | 700 | 772 | XP_030854961.1 peroxisome assembly factor 2 [Strongylocentrotus purpuratus] | diamond | 2217 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30695343 | 30695343 | PRJNA911178_P_NODE_260873_length_247_cov_0.885057_g258399_i0 | PRJNA911178 | 260873 | 247 | 0.885057 | 2.18609079 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 95.9 | 7.650000000000001e-21 | NR | KAJ8022034.1 | 206669 | g258399 | i0 | 59 | 5.5748987854251 | 78 | 30 | 94.7 | 1 | 236 | 3 | 12 | 87 | KAJ8022034.1 hypothetical protein HOLleu_39407 [Holothuria leucospilota] | diamond | 1377 | 96.7 | 0.991726990692865 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31699637 | 31699637 | PRJNA911178_P_NODE_273957_length_244_cov_2.830409_g271483_i0 | PRJNA911178 | 273957 | 244 | 2.830409 | 6.90619796 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47 | 0.00117 | NR | XP_071476032.1 | 105358 | g271483 | i0 | 43.6 | 0.676229508196721 | 55 | 30 | 66.4 | 1 | 164 | 3 | 382 | 436 | XP_071476032.1 uncharacterized protein [Diadema antillarum] | diamond | 165 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 31706985 | 31706985 | PRJNA911178_P_NODE_264157_length_246_cov_1.751445_g261683_i0 | PRJNA911178 | 264157 | 246 | 1.751445 | 4.3085547 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 71.6 | 2.52e-12 | NR | XP_033639952.1 | 7604 | g261683 | i0 | 46.8 | 8.45121951219512 | 77 | 34 | 93.9 | 2 | 232 | 2 | 115 | 184 | XP_033639952.1 ATP-binding cassette sub-family F member 2-like [Asterias rubens] | diamond | 2079 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31794249 | 31794249 | PRJNA911178_P_NODE_260377_length_247_cov_0.948276_g257903_i0 | PRJNA911178 | 260377 | 247 | 0.948276 | 2.34224172 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 68.9 | 4.87e-12 | NR | XP_030834981.1 | 7668 | g257903 | i0 | 51.4 | 5.18623481781376 | 70 | 33 | 85 | 1 | 225 | 16 | 126 | 194 | XP_030834981.1 sushi, nidogen and EGF-like domain-containing protein 1 [Strongylocentrotus purpuratus] | diamond | 1281 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31889253 | 31889253 | PRJNA911178_P_NODE_122117_length_332_cov_2.509653_g119645_i0 | PRJNA911178 | 122117 | 332 | 2.509653 | 8.33204796 | Pseudocentrotus depressus | 7678 | Echinodermata | other_Eukaryota | 92.4 | 2.82e-19 | NR | BAJ23935.1 | 7678 | g119645 | i0 | 43 | 14.6114457831325 | 107 | 61 | 96.7 | 0 | 3 | 323 | 48 | 154 | BAJ23935.1 eukaryotic translation elongation factor 1 alpha, partial [Pseudocentrotus depressus] | diamond | 4851 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinidae | Pseudocentrotus | Pseudocentrotus depressus |
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);;