contig_metadata
14 rows where bioproject = "PRJNA685060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8828969 | 8828969 | PRJNA685060_P_NODE_11327_length_278_cov_1.502439_g11237_i0 | PRJNA685060 | 11327 | 278 | 1.502439 | 4.17678042 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 105 | 6.97e-24 | NR | XP_038077645.1 | 46514 | g11237 | i0 | 53.3 | 5.75179856115108 | 90 | 42 | 97.1 | 0 | 9 | 278 | 1709 | 1798 | XP_038077645.1 endoribonuclease Dicer-like [Patiria miniata] | diamond | 1599 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 9594718 | 9594718 | PRJNA685060_P_NODE_11528_length_275_cov_1.806931_g11438_i0 | PRJNA685060 | 11528 | 275 | 1.806931 | 4.96906025 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 453 | 5.9300000000000005e-123 | NTclustered | gi|1826640151|ref|XM_033252220.1| | 1529436 | g11438 | i0 | 96.364 | 17.8072727272727 | 275 | 10 | 100 | 0 | 1 | 275 | 1004 | 730 | PREDICTED: Anneissia japonica tigger transposable element-derived protein 4-like (LOC117109799), mRNA | blastn | 4897 | 453 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 17244180 | 17244180 | PRJNA685060_P_NODE_8594_length_324_cov_1.227092_g8504_i0 | PRJNA685060 | 8594 | 324 | 1.227092 | 3.97577808 | root | 1 | Root_unresolved | Root_unresolved | 148 | 1.69e-40 | NR | XP_033646653.1 | 7604 | g8504 | i0 | 66.4 | 9.90740740740741 | 107 | 36 | 99.1 | 0 | 322 | 2 | 277 | 383 | XP_033646653.1 3-ketoacyl-CoA thiolase, mitochondrial-like [Asterias rubens] | diamond | 3210 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 21068628 | 21068628 | PRJNA685060_P_NODE_6857_length_364_cov_1.054983_g6767_i0 | PRJNA685060 | 6857 | 364 | 1.054983 | 3.84013812 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 132 | 5.18e-35 | NR | XP_041469160.1 | 7654 | g6767 | i0 | 56.3 | 1.96978021978022 | 119 | 51 | 98.1 | 1 | 360 | 4 | 20 | 137 | XP_041469160.1 serine racemase-like isoform X1 [Lytechinus variegatus] | diamond | 717 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26777489 | 26777489 | PRJNA685060_P_NODE_9001_length_316_cov_1.761317_g8911_i0 | PRJNA685060 | 9001 | 316 | 1.761317 | 5.56576172 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 65.1 | 1.2e-9 | NR | XP_011679485.2 | 7668 | g8911 | i0 | 68.3 | 1.68037974683544 | 41 | 13 | 38.9 | 0 | 269 | 147 | 562 | 602 | XP_011679485.2 tRNA modification GTPase GTPBP3, mitochondrial [Strongylocentrotus purpuratus] | diamond | 531 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27030528 | 27030528 | PRJNA685060_P_NODE_9002_length_316_cov_1.753086_g8912_i0 | PRJNA685060 | 9002 | 316 | 1.753086 | 5.53975176 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 68.9 | 5.9e-11 | NR | XP_030852099.1 | 7668 | g8912 | i0 | 34.3 | 3.9493670886076 | 105 | 69 | 99.7 | 0 | 2 | 316 | 1767 | 1871 | XP_030852099.1 nipped-B-like protein A [Strongylocentrotus purpuratus] | diamond | 1248 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27461575 | 27461575 | PRJNA685060_P_NODE_2723_length_598_cov_1.398095_g2633_i0 | PRJNA685060 | 2723 | 598 | 1.398095 | 8.3606081 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 89.7 | 2.36e-18 | NR | XP_033123569.1 | 1529436 | g2633 | i0 | 32.8 | 1.9314381270903 | 192 | 122 | 96.3 | 3 | 576 | 1 | 2 | 186 | XP_033123569.1 carboxypeptidase A1-like [Anneissia japonica] | diamond | 1155 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27694318 | 27694318 | PRJNA685060_P_NODE_17144_length_242_cov_0.911243_g17054_i0 | PRJNA685060 | 17144 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 48.9 | 2.49e-4 | NR | XP_063953024.1 | 7653 | g17054 | i0 | 55.6 | 2.0702479338843 | 36 | 16 | 44.6 | 0 | 185 | 78 | 39 | 74 | XP_063953024.1 leucine-rich repeats and immunoglobulin-like domains protein 3 isoform X2 [Lytechinus pictus] | diamond | 501 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 29114956 | 29114956 | PRJNA685060_P_NODE_8808_length_320_cov_1.246964_g8718_i0 | PRJNA685060 | 8808 | 320 | 1.246964 | 3.9902848 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 126 | 2.05e-31 | NR | XP_798924.4 | 7668 | g8718 | i0 | 51.6 | 3.5625 | 95 | 46 | 89.1 | 0 | 1 | 285 | 444 | 538 | XP_798924.4 testin isoform X1 [Strongylocentrotus purpuratus] | diamond | 1140 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29714401 | 29714401 | PRJNA685060_P_NODE_11590_length_274_cov_2.900498_g11500_i0 | PRJNA685060 | 11590 | 274 | 2.900498 | 7.94736452 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 46.2 | 0.00303 | NR | XP_033640968.1 | 7604 | g11500 | i0 | 60 | 1.97080291970803 | 30 | 12 | 32.8 | 0 | 183 | 272 | 296 | 325 | XP_033640968.1 thioredoxin domain-containing protein 5-like [Asterias rubens] | diamond | 540 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30398651 | 30398651 | PRJNA685060_P_NODE_10233_length_295_cov_1.022523_g10143_i0 | PRJNA685060 | 10233 | 295 | 1.022523 | 3.01644285 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 90.5 | 9.24e-19 | NR | XP_033123084.1 | 1529436 | g10143 | i0 | 46.2 | 1.85084745762712 | 91 | 49 | 92.5 | 0 | 285 | 13 | 190 | 280 | XP_033123084.1 pumilio homolog 3-like [Anneissia japonica] | diamond | 546 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30587584 | 30587584 | PRJNA685060_P_NODE_2253_length_657_cov_1.489726_g2166_i0 | PRJNA685060 | 2253 | 657 | 1.489726 | 9.78749982 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 249 | 3.77e-77 | NR | XP_022100478.1 | 133434 | g2166 | i0 | 56.3 | 9.44292237442922 | 206 | 89 | 94.1 | 1 | 618 | 1 | 126 | 330 | XP_022100478.1 alpha-1,3-mannosyl-glycoprotein 2-beta-N-acetylglucosaminyltransferase-like isoform X2 [Acanthaster planci] | diamond | 6204 | 249 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 31946981 | 31946981 | PRJNA685060_P_NODE_3637_length_514_cov_1.034014_g3547_i0 | PRJNA685060 | 3637 | 514 | 1.034014 | 5.31483196 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 57.4 | 4.42e-6 | NR | XP_063952793.1 | 7653 | g3547 | i0 | 31.5 | 2.15953307392996 | 89 | 53 | 51.9 | 2 | 394 | 128 | 494 | 574 | XP_063952793.1 uncharacterized protein LOC129255740 isoform X2 [Lytechinus pictus] | diamond | 1110 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 32358778 | 32358778 | PRJNA685060_P_NODE_12859_length_257_cov_1.255435_g12769_i0 | PRJNA685060 | 12859 | 257 | 1.255435 | 3.22646795 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 84 | 1.39e-16 | NR | XP_022082410.1 | 133434 | g12769 | i0 | 56.2 | 2.56809338521401 | 73 | 31 | 85.2 | 1 | 2 | 220 | 479 | 550 | XP_022082410.1 ribosome biogenesis protein bop1-A-like isoform X2 [Acanthaster planci] | diamond | 660 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;