contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA938397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26866989 | 26866989 | PRJNA938397_S_NODE_24941_length_221_cov_4.244565_g24700_i0 | PRJNA938397 | 24941 | 221 | 4.244565 | 9.38048865 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 62.4 | 3.18e-9 | NR | XP_071490566.1 | 105358 | g24700 | i0 | 47.2 | 0.719457013574661 | 53 | 28 | 71.9 | 0 | 14 | 172 | 362 | 414 | XP_071490566.1 adipocyte plasma membrane-associated protein-like isoform X2 [Diadema antillarum] | diamond | 159 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27309665 | 27309665 | PRJNA938397_S_NODE_15543_length_278_cov_7.323651_g15302_i0 | PRJNA938397 | 15543 | 278 | 7.323651 | 20.35974978 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 45.4 | 0.00595 | NR | PIK52322.1 | 307972 | g15302 | i0 | 60.5 | 1.27338129496403 | 38 | 15 | 41 | 0 | 3 | 116 | 296 | 333 | PIK52322.1 putative secretory carrier-associated membrane protein 1 [Apostichopus japonicus] | diamond | 354 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27790298 | 27790298 | PRJNA938397_S_NODE_38164_length_178_cov_3.163121_g37923_i0 | PRJNA938397 | 38164 | 178 | 3.163121 | 5.63035538 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 61.6 | 3.27e-9 | NR | XP_041456043.1 | 7654 | g37923 | i0 | 51 | 4.24719101123596 | 51 | 25 | 86 | 0 | 3 | 155 | 494 | 544 | XP_041456043.1 protein C12orf4 homolog [Lytechinus variegatus] | diamond | 756 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28067278 | 28067278 | PRJNA938397_S_NODE_23045_length_230_cov_5.948187_g22804_i0 | PRJNA938397 | 23045 | 230 | 5.948187 | 13.6808301 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 50.8 | 3.04e-5 | NR | XP_022083802.1 | 133434 | g22804 | i0 | 61.1 | 1.35652173913043 | 36 | 14 | 47 | 0 | 4 | 111 | 188 | 223 | XP_022083802.1 ropporin-1-like protein [Acanthaster planci] | diamond | 312 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28548174 | 28548174 | PRJNA938397_S_NODE_40387_length_173_cov_1.632353_g40146_i0 | PRJNA938397 | 40387 | 173 | 1.632353 | 2.82397069 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 54.3 | 1.2e-6 | NR | XP_033636350.1 | 7604 | g40146 | i0 | 50 | 3.84971098265896 | 40 | 20 | 69.4 | 0 | 152 | 33 | 525 | 564 | XP_033636350.1 dnaJ homolog subfamily C member 21-like [Asterias rubens] | diamond | 666 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28572445 | 28572445 | PRJNA938397_S_NODE_36587_length_182_cov_3.786207_g36346_i0 | PRJNA938397 | 36587 | 182 | 3.786207 | 6.89089674 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 43.1 | 0.0119 | NR | XP_030852922.1 | 7668 | g36346 | i0 | 40.4 | 0.93956043956044 | 57 | 33 | 94 | 1 | 1 | 171 | 158 | 213 | XP_030852922.1 receptor-type tyrosine-protein phosphatase eta [Strongylocentrotus purpuratus] | diamond | 171 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29053252 | 29053252 | PRJNA938397_S_NODE_36488_length_182_cov_6.772414_g36247_i0 | PRJNA938397 | 36488 | 182 | 6.772414 | 12.32579348 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 80.1 | 1.34e-16 | NR | KAJ8035869.1 | 206669 | g36247 | i0 | 75 | 6.37912087912088 | 48 | 12 | 79.1 | 0 | 37 | 180 | 1 | 48 | KAJ8035869.1 Charged multivesicular body protein 5 [Holothuria leucospilota] | diamond | 1161 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29273970 | 29273970 | PRJNA938397_S_NODE_29629_length_202_cov_15.975758_g29388_i0 | PRJNA938397 | 29629 | 202 | 15.975758 | 32.27103116 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 44.3 | 0.00626 | NR | XP_071494862.1 | 105358 | g29388 | i0 | 32.1 | 1.61881188118812 | 56 | 37 | 81.7 | 1 | 1 | 165 | 311 | 366 | XP_071494862.1 uncharacterized protein [Diadema antillarum] | diamond | 327 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29526804 | 29526804 | PRJNA938397_S_NODE_26750_length_213_cov_7.892045_g26509_i0 | PRJNA938397 | 26750 | 213 | 7.892045 | 16.81005585 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 52.4 | 9.74e-6 | NR | XP_063971177.1 | 7653 | g26509 | i0 | 45.6 | 2.87323943661972 | 68 | 37 | 95.8 | 0 | 3 | 206 | 230 | 297 | XP_063971177.1 ADP-ribosylation factor GTPase-activating protein 2-like isoform X2 [Lytechinus pictus] | diamond | 612 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29684287 | 29684287 | PRJNA938397_S_NODE_33630_length_190_cov_3.934641_g33389_i0 | PRJNA938397 | 33630 | 190 | 3.934641 | 7.4758179 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 54.3 | 1.29e-6 | NR | XP_041481966.1 | 7654 | g33389 | i0 | 44.8 | 2.74736842105263 | 58 | 32 | 91.6 | 0 | 190 | 17 | 211 | 268 | XP_041481966.1 ankyrin repeat domain-containing protein 45-like [Lytechinus variegatus] | diamond | 522 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30568850 | 30568850 | PRJNA938397_S_NODE_8993_length_349_cov_4.897436_g8752_i0 | PRJNA938397 | 8993 | 349 | 4.897436 | 17.09205164 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 102 | 9.03e-23 | NR | XP_041475184.1 | 7654 | g8752 | i0 | 64.6 | 3.34383954154728 | 79 | 23 | 67.9 | 1 | 337 | 101 | 461 | 534 | XP_041475184.1 sterol carrier protein 2-like [Lytechinus variegatus] | diamond | 1167 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30909803 | 30909803 | PRJNA938397_S_NODE_36554_length_182_cov_4.420690_g36313_i0 | PRJNA938397 | 36554 | 182 | 4.42069 | 8.0456558 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 73.9 | 2.68e-15 | NR | KAJ8048943.1 | 206669 | g36313 | i0 | 51.8 | 2.85164835164835 | 56 | 27 | 92.3 | 0 | 175 | 8 | 36 | 91 | KAJ8048943.1 Signal peptidase complex subunit 1 [Holothuria leucospilota] | diamond | 519 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31130551 | 31130551 | PRJNA938397_S_NODE_21635_length_237_cov_12.260000_g21394_i0 | PRJNA938397 | 21635 | 237 | 12.26 | 29.0562 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 64.3 | 8.43e-10 | NR | XP_038073301.1 | 46514 | g21394 | i0 | 44.4 | 0.79746835443038 | 63 | 33 | 79.7 | 1 | 10 | 198 | 356 | 416 | XP_038073301.1 angio-associated migratory cell protein-like [Patiria miniata] | diamond | 189 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 31454211 | 31454211 | PRJNA938397_S_NODE_12316_length_308_cov_21.900369_g12075_i0 | PRJNA938397 | 12316 | 308 | 21.900369 | 67.45313652 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 90.1 | 1.58e-18 | NR | XP_781522.4 | 7668 | g12075 | i0 | 82.4 | 38.7272727272727 | 51 | 9 | 49.7 | 0 | 305 | 153 | 433 | 483 | XP_781522.4 dihydrolipoyllysine-residue succinyltransferase component of 2-oxoglutarate dehydrogenase complex, mitochondrial [Strongylocentrotus purpuratus] | diamond | 11928 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31580731 | 31580731 | PRJNA938397_S_NODE_37456_length_180_cov_2.062937_g37215_i0 | PRJNA938397 | 37456 | 180 | 2.062937 | 3.7132866 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 46.2 | 8.92e-4 | NR | XP_033645064.1 | 7604 | g37215 | i0 | 40 | 2.91666666666667 | 45 | 27 | 75 | 0 | 5 | 139 | 227 | 271 | XP_033645064.1 replication protein A 32 kDa subunit-B-like isoform X2 [Asterias rubens] | diamond | 525 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32016402 | 32016402 | PRJNA938397_S_NODE_23958_length_225_cov_21.925532_g23717_i0 | PRJNA938397 | 23958 | 225 | 21.925532 | 49.332447 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 72 | 3.5e-13 | NR | XP_038048861.1 | 46514 | g23717 | i0 | 66.7 | 7.68 | 48 | 16 | 64 | 0 | 222 | 79 | 179 | 226 | XP_038048861.1 V-type proton ATPase subunit E-like [Patiria miniata] | diamond | 1728 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32079671 | 32079671 | PRJNA938397_S_NODE_14758_length_285_cov_6.387097_g14517_i0 | PRJNA938397 | 14758 | 285 | 6.387097 | 18.20322645 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 87.8 | 9.02e-18 | NR | XP_022109458.1 | 133434 | g14517 | i0 | 55.6 | 2.27368421052632 | 72 | 31 | 75.8 | 1 | 285 | 70 | 551 | 621 | XP_022109458.1 LOW QUALITY PROTEIN: acetolactate synthase-like protein [Acanthaster planci] | diamond | 648 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32522989 | 32522989 | PRJNA938397_S_NODE_41479_length_170_cov_8.270677_g41238_i0 | PRJNA938397 | 41479 | 170 | 8.270677 | 14.0601509 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 90.9 | 2.35e-20 | NR | XP_033625968.1 | 7604 | g41238 | i0 | 82 | 3.54705882352941 | 50 | 9 | 88.2 | 0 | 167 | 18 | 225 | 274 | XP_033625968.1 proteasome subunit beta type-5-like [Asterias rubens] | diamond | 603 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 32907672 | 32907672 | PRJNA938397_S_NODE_26700_length_213_cov_12.414773_g26459_i0 | PRJNA938397 | 26700 | 213 | 12.414773 | 26.44346649 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 78.6 | 5.66e-16 | NR | XP_071504339.1 | 105358 | g26459 | i0 | 76.1 | 3.92957746478873 | 46 | 11 | 64.8 | 0 | 204 | 67 | 152 | 197 | XP_071504339.1 LIM and SH3 domain protein 1-like [Diadema antillarum] | diamond | 837 | 79.3 | 0.991172761664565 | 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);;