contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27020651 | 27020651 | PRJNA725806_P_NODE_192402_length_151_cov_2.692982_g192100_i0 | PRJNA725806 | 192402 | 151 | 2.692982 | 4.06640282 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 70.9 | 1.28e-12 | NR | XP_071502567.1 | 105358 | g192100 | i0 | 61.2 | 0.973509933774834 | 49 | 19 | 97.4 | 0 | 2 | 148 | 286 | 334 | XP_071502567.1 insulin-degrading enzyme-like [Diadema antillarum] | diamond | 147 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27652700 | 27652700 | PRJNA725806_P_NODE_46244_length_254_cov_8.188940_g45947_i0 | PRJNA725806 | 46244 | 254 | 8.18894 | 20.7999076 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 43.9 | 0.0167 | NR | XP_033109815.1 | 1529436 | g45947 | i0 | 36.6 | 0.838582677165354 | 71 | 42 | 82.7 | 2 | 26 | 235 | 545 | 613 | XP_033109815.1 pentatricopeptide repeat domain-containing protein 3, mitochondrial-like [Anneissia japonica] | diamond | 213 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28410407 | 28410407 | PRJNA725806_P_NODE_78826_length_214_cov_7.305085_g78525_i0 | PRJNA725806 | 78826 | 214 | 7.305085 | 15.6328819 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 77 | 2.12e-14 | NR | XP_041457071.1 | 7654 | g78525 | i0 | 67.3 | 0.771028037383178 | 55 | 9 | 64.5 | 1 | 73 | 210 | 439 | 493 | XP_041457071.1 putative phospholipase B-like 2 [Lytechinus variegatus] | diamond | 165 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28410413 | 28410413 | PRJNA725806_P_NODE_89366_length_205_cov_5.851190_g89064_i0 | PRJNA725806 | 89366 | 205 | 5.85119 | 11.9949395 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 68.6 | 5.71e-12 | NR | XP_033123873.1 | 1529436 | g89064 | i0 | 87.5 | 1.40487804878049 | 32 | 4 | 46.8 | 0 | 164 | 69 | 12 | 43 | XP_033123873.1 methylthioribulose-1-phosphate dehydratase-like [Anneissia japonica] | diamond | 288 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28663039 | 28663039 | PRJNA725806_P_NODE_95967_length_200_cov_3.809816_g95665_i0 | PRJNA725806 | 95967 | 200 | 3.809816 | 7.619632 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 57.4 | 1.43e-7 | NR | XP_038078323.1 | 46514 | g95665 | i0 | 74.2 | 0.465 | 31 | 8 | 46.5 | 0 | 95 | 3 | 140 | 170 | XP_038078323.1 polycomb protein SCMH1-like [Patiria miniata] | diamond | 93 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28947294 | 28947294 | PRJNA725806_P_NODE_126028_length_181_cov_1.298611_g125726_i0 | PRJNA725806 | 126028 | 181 | 1.298611 | 2.35048591 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 51.2 | 1.69e-5 | NR | KAJ8051046.1 | 206669 | g125726 | i0 | 56.3 | 1.59116022099448 | 32 | 14 | 53 | 0 | 4 | 99 | 73 | 104 | KAJ8051046.1 hypothetical protein HOLleu_04468 [Holothuria leucospilota] | diamond | 288 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 29294377 | 29294377 | PRJNA725806_P_NODE_56609_length_239_cov_4.113861_g56312_i0 | PRJNA725806 | 56609 | 239 | 4.113861 | 9.83212779 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 47.8 | 6.13e-4 | NR | XP_038052454.1 | 46514 | g56312 | i0 | 58.1 | 0.702928870292887 | 31 | 13 | 38.9 | 0 | 2 | 94 | 1 | 31 | XP_038052454.1 zinc finger protein 729-like [Patiria miniata] | diamond | 168 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30052106 | 30052106 | PRJNA725806_P_NODE_26411_length_296_cov_5.590734_g26114_i0 | PRJNA725806 | 26411 | 296 | 5.590734 | 16.54857264 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 43.9 | 0.0264 | NR | XP_041454220.1 | 7654 | g26114 | i0 | 32.9 | 0.800675675675676 | 79 | 47 | 80.1 | 2 | 276 | 40 | 46 | 118 | XP_041454220.1 pollen-specific leucine-rich repeat extensin-like protein 1 isoform X2 [Lytechinus variegatus] | diamond | 237 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30273727 | 30273727 | PRJNA725806_P_NODE_3612_length_479_cov_5.135747_g3347_i0 | PRJNA725806 | 3612 | 479 | 5.135747 | 24.60022813 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 56.2 | 8.26e-6 | NR | XP_033102039.1 | 1529436 | g3347 | i0 | 26.8 | 2.01043841336117 | 97 | 71 | 60.8 | 0 | 431 | 141 | 470 | 566 | XP_033102039.1 uncharacterized protein LOC117105102 [Anneissia japonica] | diamond | 963 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31642635 | 31642635 | PRJNA725806_P_NODE_108516_length_191_cov_5.668831_g108214_i0 | PRJNA725806 | 108516 | 191 | 5.668831 | 10.82746721 | Aspidochirotida | 7682 | Echinodermata | other_Eukaryota | 94 | 1.7e-20 | NR | KAJ8037346.1 | 206669 | g108214 | i0 | 92.3 | 2.45026178010471 | 52 | 4 | 81.7 | 0 | 157 | 2 | 682 | 733 | KAJ8037346.1 Sodium/calcium exchanger 3 [Holothuria leucospilota] | diamond | 468 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31917171 | 31917171 | PRJNA725806_P_NODE_107157_length_192_cov_4.877419_g106855_i0 | PRJNA725806 | 107157 | 192 | 4.877419 | 9.36464448 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 45.4 | 0.00215 | NR | XP_033631004.1 | 7604 | g106855 | i0 | 44.4 | 0.84375 | 54 | 30 | 84.4 | 0 | 31 | 192 | 259 | 312 | XP_033631004.1 retinoid-inducible serine carboxypeptidase-like isoform X2 [Asterias rubens] | diamond | 162 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31917198 | 31917198 | PRJNA725806_P_NODE_38217_length_269_cov_1.982759_g37920_i0 | PRJNA725806 | 38217 | 269 | 1.982759 | 5.33362171 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 46.6 | 0.00227 | NR | XP_041467375.1 | 7654 | g37920 | i0 | 75.9 | 0.323420074349442 | 29 | 7 | 32.3 | 0 | 181 | 267 | 11 | 39 | XP_041467375.1 transcription factor Sp4-like [Lytechinus variegatus] | diamond | 87 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32022487 | 32022487 | PRJNA725806_P_NODE_164358_length_162_cov_3.048000_g164056_i0 | PRJNA725806 | 164358 | 162 | 3.048 | 4.93776 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00255 | NR | KAJ8025067.1 | 206669 | g164056 | i0 | 45 | 2.81481481481481 | 40 | 19 | 74.1 | 1 | 160 | 41 | 343 | 379 | KAJ8025067.1 Acyl-CoA synthetase family member 2, mitochondrial [Holothuria leucospilota] | diamond | 456 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32107006 | 32107006 | PRJNA725806_P_NODE_35378_length_274_cov_15.497890_g35081_i0 | PRJNA725806 | 35378 | 274 | 15.49789 | 42.4642186 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 73.6 | 7.89e-13 | NR | XP_030841101.1 | 7668 | g35081 | i0 | 63.8 | 0.514598540145985 | 47 | 17 | 51.5 | 0 | 234 | 94 | 37 | 83 | XP_030841101.1 fibropellin-1 [Strongylocentrotus purpuratus] | diamond | 141 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32117473 | 32117473 | PRJNA725806_P_NODE_128738_length_179_cov_4.697183_g128436_i0 | PRJNA725806 | 128738 | 179 | 4.697183 | 8.40795757 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67 | 4.33e-11 | NR | XP_041485382.1 | 7654 | g128436 | i0 | 76.3 | 19.4078212290503 | 38 | 9 | 63.7 | 0 | 168 | 55 | 911 | 948 | XP_041485382.1 piwi-like protein 1 [Lytechinus variegatus] | diamond | 3474 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32170521 | 32170521 | PRJNA725806_P_NODE_111218_length_189_cov_9.960526_g110916_i0 | PRJNA725806 | 111218 | 189 | 9.960526 | 18.82539414 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 43.1 | 0.0132 | NR | XP_038056081.1 | 46514 | g110916 | i0 | 60.7 | 1.82539682539683 | 28 | 11 | 44.4 | 0 | 151 | 68 | 402 | 429 | XP_038056081.1 fibroblast growth factor receptor 2-like [Patiria miniata] | diamond | 345 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32843640 | 32843640 | PRJNA725806_P_NODE_113220_length_188_cov_4.980132_g112918_i0 | PRJNA725806 | 113220 | 188 | 4.980132 | 9.3626481600000009 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 49.7 | 6.3e-5 | NR | KAJ8025173.1 | 206669 | g112918 | i0 | 39.2 | 1.57978723404255 | 51 | 31 | 81.4 | 0 | 157 | 5 | 170 | 220 | KAJ8025173.1 BRCA1-associated RING domain protein 1 [Holothuria leucospilota] | diamond | 297 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;