contig_metadata
18 rows where bioproject = "PRJNA980587", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 955672 | 955672 | PRJNA980587_P_NODE_43001_length_353_cov_1.646429_g42208_i0 | PRJNA980587 | 43001 | 353 | 1.646429 | 5.81189437 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 188 | 1.4099999999999995e-55 | NR | XP_041463347.1 | 7654 | g42208 | i0 | 76.1 | 499.71671388102 | 113 | 27 | 96 | 0 | 341 | 3 | 11 | 123 | XP_041463347.1 tubulin alpha-1 chain-like isoform X2 [Lytechinus variegatus] | diamond | 176400 | 189 | 0.994708994708995 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 12748813 | 12748813 | PRJNA980587_P_NODE_77230_length_253_cov_1.688889_g76437_i0 | PRJNA980587 | 77230 | 253 | 1.688889 | 4.27288917 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 116 | 1.27e-29 | NR | XP_071487048.1 | 105358 | g76437 | i0 | 73.6 | 7.0197628458498 | 72 | 19 | 85.4 | 0 | 248 | 33 | 30 | 101 | XP_071487048.1 ADP,ATP carrier protein-like [Diadema antillarum] | diamond | 1776 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 20082636 | 20082636 | PRJNA980587_P_NODE_76216_length_255_cov_4.917582_g75423_i0 | PRJNA980587 | 76216 | 255 | 4.917582 | 12.5398341 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 105 | 1.85e-25 | NR | XP_071487048.1 | 105358 | g75423 | i0 | 72.3 | 8.90588235294118 | 65 | 18 | 76.5 | 0 | 254 | 60 | 37 | 101 | XP_071487048.1 ADP,ATP carrier protein-like [Diadema antillarum] | diamond | 2271 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 23907879 | 23907879 | PRJNA980587_P_NODE_22259_length_533_cov_1.456522_g21468_i0 | PRJNA980587 | 22259 | 533 | 1.456522 | 7.76326226 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 259 | 1.78e-84 | NR | XP_038051326.1 | 46514 | g21468 | i0 | 70.8 | 2.72420262664165 | 161 | 47 | 90.6 | 0 | 6 | 488 | 86 | 246 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 1452 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 26773018 | 26773018 | PRJNA980587_P_NODE_51441_length_320_cov_1.829960_g50648_i0 | PRJNA980587 | 51441 | 320 | 1.82996 | 5.855872 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 62.4 | 1.16e-9 | NR | XP_033102083.1 | 1529436 | g50648 | i0 | 51.3 | 0.73125 | 78 | 38 | 73.1 | 0 | 296 | 63 | 63 | 140 | XP_033102083.1 coiled-coil domain-containing protein 86-like [Anneissia japonica] | diamond | 234 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 26868207 | 26868207 | PRJNA980587_P_NODE_67461_length_275_cov_1.559406_g66668_i0 | PRJNA980587 | 67461 | 275 | 1.559406 | 4.2883665 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 43.9 | 0.0201 | NR | PIK51386.1 | 307972 | g66668 | i0 | 58.1 | 0.469090909090909 | 43 | 13 | 45.8 | 2 | 162 | 37 | 86 | 124 | PIK51386.1 hypothetical protein BSL78_11708 [Apostichopus japonicus] | diamond | 129 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 26962737 | 26962737 | PRJNA980587_P_NODE_54142_length_311_cov_1.726891_g53349_i0 | PRJNA980587 | 54142 | 311 | 1.726891 | 5.37063101 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 147 | 1.42e-39 | NR | XP_030837968.1 | 7668 | g53349 | i0 | 65.3 | 42.5787781350482 | 101 | 35 | 97.4 | 0 | 4 | 306 | 352 | 452 | XP_030837968.1 glutathione reductase, mitochondrial [Strongylocentrotus purpuratus] | diamond | 13242 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27500315 | 27500315 | PRJNA980587_P_NODE_16383_length_646_cov_1.240838_g15610_i0 | PRJNA980587 | 16383 | 646 | 1.240838 | 8.01581348 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 186 | 2.76e-53 | NR | XP_063953807.1 | 7653 | g15610 | i0 | 43.8 | 2.01547987616099 | 217 | 111 | 99.4 | 3 | 644 | 3 | 99 | 307 | XP_063953807.1 rab GDP dissociation inhibitor alpha-like [Lytechinus pictus] | diamond | 1302 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 27658261 | 27658261 | PRJNA980587_P_NODE_16524_length_642_cov_1.841828_g15750_i0 | PRJNA980587 | 16524 | 642 | 1.841828 | 11.82453576 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 48.9 | 0.00805 | NR | XP_022110808.1 | 133434 | g15750 | i0 | 31 | 0.817757009345794 | 126 | 51 | 58.9 | 4 | 519 | 142 | 546 | 635 | XP_022110808.1 long-chain fatty acid transport protein 6-like [Acanthaster planci] | diamond | 525 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28510590 | 28510590 | PRJNA980587_P_NODE_48867_length_329_cov_2.644531_g48074_i0 | PRJNA980587 | 48867 | 329 | 2.644531 | 8.70050699 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 143 | 3.28e-41 | NR | XP_038059478.1 | 46514 | g48074 | i0 | 64.8 | 0.957446808510638 | 105 | 37 | 95.7 | 0 | 15 | 329 | 1 | 105 | XP_038059478.1 superoxide dismutase [Cu-Zn]-like [Patiria miniata] | diamond | 315 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 29079037 | 29079037 | PRJNA980587_P_NODE_10488_length_856_cov_7.280971_g9804_i0 | PRJNA980587 | 10488 | 856 | 7.280971 | 62.32511176 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 77.8 | 7.42e-13 | NR | XP_033106964.1 | 1529436 | g9804 | i0 | 32.7 | 3.82359813084112 | 217 | 126 | 73.9 | 9 | 817 | 185 | 6 | 208 | XP_033106964.1 glutathione S-transferase theta-3-like isoform X1 [Anneissia japonica] | diamond | 3273 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 29305913 | 29305913 | PRJNA980587_P_NODE_49909_length_325_cov_2.591270_g49116_i0 | PRJNA980587 | 49909 | 325 | 2.59127 | 8.4216275 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 178 | 5.01e-53 | NR | XP_796441.3 | 7668 | g49116 | i0 | 81.5 | 105.729230769231 | 108 | 20 | 99.7 | 0 | 1 | 324 | 102 | 209 | XP_796441.3 rRNA 2'-O-methyltransferase fibrillarin isoform X1 [Strongylocentrotus purpuratus] | diamond | 34362 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30311088 | 30311088 | PRJNA980587_P_NODE_65992_length_279_cov_1.121359_g65199_i0 | PRJNA980587 | 65992 | 279 | 1.121359 | 3.12859161 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 47.4 | 0.00132 | NR | XP_071479759.1 | 105358 | g65199 | i0 | 80.8 | 0.279569892473118 | 26 | 5 | 28 | 0 | 3 | 80 | 570 | 595 | XP_071479759.1 lysine--tRNA ligase-like [Diadema antillarum] | diamond | 78 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30847704 | 30847704 | PRJNA980587_P_NODE_49814_length_326_cov_1.205534_g49021_i0 | PRJNA980587 | 49814 | 326 | 1.205534 | 3.93004084 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 98.6 | 1.5899999999999995e-23 | NR | XP_030852344.1 | 7668 | g49021 | i0 | 47.7 | 2.86196319018405 | 107 | 52 | 98.5 | 3 | 6 | 326 | 12 | 114 | XP_030852344.1 thioredoxin domain-containing protein 12-like [Strongylocentrotus purpuratus] | diamond | 933 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31859313 | 31859313 | PRJNA980587_P_NODE_4937_length_1306_cov_6.800487_g4494_i0 | PRJNA980587 | 4937 | 1306 | 6.800487 | 88.81436022 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 296 | 1.03e-94 | NR | XP_033111488.1 | 1529436 | g4494 | i0 | 52.2 | 7.28866768759571 | 289 | 131 | 66.4 | 4 | 1251 | 385 | 7 | 288 | XP_033111488.1 spermidine synthase-like [Anneissia japonica] | diamond | 9519 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 31897199 | 31897199 | PRJNA980587_P_NODE_43217_length_352_cov_1.577061_g42424_i0 | PRJNA980587 | 43217 | 352 | 1.577061 | 5.55125472 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.7 | 3.71e-18 | NR | XP_033122759.1 | 1529436 | g42424 | i0 | 39.3 | 5.86363636363636 | 117 | 66 | 98.9 | 2 | 349 | 2 | 1 | 113 | XP_033122759.1 coactosin-like protein [Anneissia japonica] | diamond | 2064 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 32055328 | 32055328 | PRJNA980587_P_NODE_15838_length_660_cov_1.529813_g15071_i0 | PRJNA980587 | 15838 | 660 | 1.529813 | 10.0967658 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 123 | 5.88e-31 | NR | XP_041458278.1 | 7654 | g15071 | i0 | 35 | 3.67727272727273 | 200 | 120 | 90 | 5 | 656 | 63 | 2 | 193 | XP_041458278.1 phosphatidylcholine transfer protein-like isoform X2 [Lytechinus variegatus] | diamond | 2427 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32403535 | 32403535 | PRJNA980587_P_NODE_17179_length_627_cov_1.108303_g16402_i0 | PRJNA980587 | 17179 | 627 | 1.108303 | 6.94905981 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 92.4 | 2.47e-19 | NR | XP_033645935.1 | 7604 | g16402 | i0 | 39.4 | 4.41148325358852 | 137 | 79 | 63.6 | 1 | 624 | 226 | 59 | 195 | XP_033645935.1 COMM domain-containing protein 9-like [Asterias rubens] | diamond | 2766 | 92.4 | 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);;