contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1085664" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13770690 | 13770690 | PRJNA1085664_S_NODE_14171_length_231_cov_1.670213_g13752_i0 | PRJNA1085664 | 14171 | 231 | 1.670213 | 3.85819203 | Neogale vison | 452646 | Chordata | Chordata | 71.6 | 1.36e-12 | NR | XP_044116115.1 | 452646 | g13752 | i0 | 69.4 | 0.636363636363636 | 49 | 15 | 63.6 | 0 | 206 | 60 | 272 | 320 | XP_044116115.1 putative olfactory receptor 8G3 pseudogene [Neogale vison] | diamond | 147 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Neogale | Neogale vison | |
| 26909356 | 26909356 | PRJNA1085664_S_NODE_29002_length_165_cov_1.155738_g28583_i0 | PRJNA1085664 | 29002 | 165 | 1.155738 | 1.9069677 | Rhinolophus ferrumequinum | 59479 | Chordata | Chordata | 44.7 | 0.00268 | NR | ACC62065.1 | 59479 | g28583 | i0 | 48.9 | 1.63636363636364 | 45 | 23 | 81.8 | 0 | 3 | 137 | 478 | 522 | ACC62065.1 hypothetical protein [Rhinolophus ferrumequinum] | diamond | 270 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Rhinolophidae | Rhinolophus | Rhinolophus ferrumequinum | |
| 27225355 | 27225355 | PRJNA1085664_S_NODE_11383_length_257_cov_3.140187_g10964_i0 | PRJNA1085664 | 11383 | 257 | 3.140187 | 8.07028059 | Bos indicus x Bos taurus | 30522 | Chordata | Chordata | 70.1 | 1.04e-11 | NR | XP_027375161.1 | 30522 | g10964 | i0 | 77 | 1.01556420233463 | 87 | 18 | 99.2 | 1 | 1 | 255 | 380 | 466 | XP_027375161.1 5E5 antigen-like [Bos indicus x Bos taurus] | diamond | 261 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos indicus x Bos taurus | |
| 27478301 | 27478301 | PRJNA1085664_S_NODE_36203_length_151_cov_0.888889_g35784_i0 | PRJNA1085664 | 36203 | 151 | 0.888889 | 1.34222239 | Mirounga leonina | 9715 | Chordata | Chordata | 42.7 | 0.0103 | NR | KAF3827309.1 | 9715 | g35784 | i0 | 82.6 | 0.456953642384106 | 23 | 4 | 45.7 | 0 | 63 | 131 | 474 | 496 | KAF3827309.1 hypothetical protein GH733_002795 [Mirounga leonina] | diamond | 69 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga leonina | |
| 27532878 | 27532878 | PRJNA1085664_S_NODE_22903_length_183_cov_1.714286_g22484_i0 | PRJNA1085664 | 22903 | 183 | 1.714286 | 3.13714338 | Myotis | 9434 | Chordata | Chordata | 53.9 | 1.98e-6 | NR | XP_059562598.1 | 98922 | g22484 | i0 | 78.7 | 2 | 61 | 13 | 100 | 0 | 183 | 1 | 645 | 705 | XP_059562598.1 ankyrin repeat domain-containing protein 12 isoform X5 [Myotis daubentonii] | diamond | 366 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis daubentonii | |
| 27825729 | 27825729 | PRJNA1085664_S_NODE_9544_length_281_cov_1.810924_g9125_i0 | PRJNA1085664 | 9544 | 281 | 1.810924 | 5.08869644 | Trichechus manatus latirostris | 127582 | Chordata | Chordata | 50.4 | 1.09e-4 | NR | XP_023588091.1 | 127582 | g9125 | i0 | 53.5 | 1.5373665480427 | 43 | 20 | 45.9 | 0 | 153 | 281 | 339 | 381 | XP_023588091.1 nucleoporin NUP42 isoform X3 [Trichechus manatus latirostris] | diamond | 432 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Sirenia | Trichechidae | Trichechus | Trichechus manatus | |
| 27983453 | 27983453 | PRJNA1085664_S_NODE_36545_length_151_cov_0.888889_g36126_i0 | PRJNA1085664 | 36545 | 151 | 0.888889 | 1.34222239 | Sus scrofa | 9823 | Chordata | Chordata | 41.6 | 0.0272 | NR | XP_013836702.1 | 9823 | g36126 | i0 | 65.5 | 0.576158940397351 | 29 | 10 | 57.6 | 0 | 150 | 64 | 26 | 54 | XP_013836702.1 sperm-associated antigen 7 isoform X1 [Sus scrofa] | diamond | 87 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 28109639 | 28109639 | PRJNA1085664_S_NODE_25345_length_175_cov_1.818182_g24926_i0 | PRJNA1085664 | 25345 | 175 | 1.818182 | 3.1818185 | Halichoerus grypus | 9711 | Chordata | Chordata | 49.7 | 2.94e-5 | NR | XP_035920310.1 | 9711 | g24926 | i0 | 55 | 0.685714285714286 | 40 | 18 | 68.6 | 0 | 128 | 9 | 139 | 178 | XP_035920310.1 uncharacterized protein LOC118518013 isoform X2 [Halichoerus grypus] | diamond | 120 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Halichoerus | Halichoerus grypus | |
| 28520355 | 28520355 | PRJNA1085664_S_NODE_35227_length_152_cov_0.880734_g34808_i0 | PRJNA1085664 | 35227 | 152 | 0.880734 | 1.33871568 | Camelus ferus | 419612 | Chordata | Chordata | 49.7 | 3.81e-5 | NR | EPY82171.1 | 419612 | g34808 | i0 | 71.9 | 0.631578947368421 | 32 | 9 | 63.2 | 0 | 13 | 108 | 172 | 203 | EPY82171.1 actin-binding LIM protein 1 isoform 5-like protein [Camelus ferus] | diamond | 96 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus ferus | |
| 28898965 | 28898965 | PRJNA1085664_S_NODE_12088_length_250_cov_1.855072_g11669_i0 | PRJNA1085664 | 12088 | 250 | 1.855072 | 4.63768 | Diceros bicornis minor | 77932 | Chordata | Chordata | 42.7 | 0.0311 | NR | XP_058411710.1 | 77932 | g11669 | i0 | 54.3 | 0.84 | 35 | 16 | 42 | 0 | 136 | 240 | 150 | 184 | XP_058411710.1 uncharacterized protein LOC131414684 isoform X1 [Diceros bicornis minor] | diamond | 210 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Rhinocerotidae | Diceros | Diceros bicornis | |
| 28898966 | 28898966 | PRJNA1085664_S_NODE_25588_length_174_cov_3.297710_g25169_i0 | PRJNA1085664 | 25588 | 174 | 3.29771 | 5.7380154 | Manis javanica | 9974 | Chordata | Chordata | 42.4 | 0.0194 | NR | KAI5942576.1 | 9974 | g25169 | i0 | 58.8 | 1.81034482758621 | 34 | 14 | 58.6 | 0 | 156 | 55 | 73 | 106 | KAI5942576.1 LINE-1 retrotransposable element ORF1 protein [Manis javanica] | diamond | 315 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 28921994 | 28921994 | PRJNA1085664_S_NODE_32748_length_156_cov_1.265487_g32329_i0 | PRJNA1085664 | 32748 | 156 | 1.265487 | 1.97415972 | Carnivora | 33554 | Chordata | Chordata | 41.2 | 0.0398 | NR | XP_012913798.1 | 9669 | g32329 | i0 | 54.5 | 1.82692307692308 | 33 | 15 | 63.5 | 0 | 101 | 3 | 554 | 586 | XP_012913798.1 mitofusin-1 isoform X2 [Mustela putorius furo] | diamond | 285 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Mustela | Mustela putorius | |
| 29183490 | 29183490 | PRJNA1085664_S_NODE_30769_length_160_cov_1.641026_g30350_i0 | PRJNA1085664 | 30769 | 160 | 1.641026 | 2.6256416 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 45.1 | 0.00175 | NR | XP_069909281.1 | 9986 | g30350 | i0 | 48.6 | 0.69375 | 37 | 19 | 69.4 | 0 | 30 | 140 | 14 | 50 | XP_069909281.1 uncharacterized protein [Oryctolagus cuniculus] | diamond | 111 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 29751365 | 29751365 | PRJNA1085664_S_NODE_30551_length_161_cov_1.084746_g30132_i0 | PRJNA1085664 | 30551 | 161 | 1.084746 | 1.74644106 | Sagmatias obliquidens | 3371155 | Chordata | Chordata | 61.6 | 2.65e-9 | NR | XP_026943587.1 | 3371155 | g30132 | i0 | 67.3 | 0.91304347826087 | 49 | 13 | 85.7 | 1 | 2 | 139 | 659 | 707 | XP_026943587.1 lysine-specific demethylase 4D-like [Sagmatias obliquidens] | diamond | 147 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Sagmatias | Sagmatias obliquidens | |
| 30067428 | 30067428 | PRJNA1085664_S_NODE_15932_length_218_cov_1.371429_g15513_i0 | PRJNA1085664 | 15932 | 218 | 1.371429 | 2.98971522 | Meles meles | 9662 | Chordata | Chordata | 52.8 | 8.05e-6 | NR | XP_045881491.1 | 9662 | g15513 | i0 | 36.9 | 1.85779816513761 | 65 | 40 | 88.1 | 1 | 5 | 196 | 1848 | 1912 | XP_045881491.1 LOW QUALITY PROTEIN: uncharacterized protein LOC123954405 [Meles meles] | diamond | 405 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 30257415 | 30257415 | PRJNA1085664_S_NODE_11592_length_255_cov_2.613208_g11173_i0 | PRJNA1085664 | 11592 | 255 | 2.613208 | 6.6636804 | Crocuta crocuta | 9678 | Chordata | Chordata | 47.4 | 3.47e-4 | NR | KAF0876880.1 | 9678 | g11173 | i0 | 57.1 | 0.811764705882353 | 35 | 15 | 41.2 | 0 | 133 | 29 | 13 | 47 | KAF0876880.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 207 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 30699320 | 30699320 | PRJNA1085664_S_NODE_33714_length_154_cov_1.252252_g33295_i0 | PRJNA1085664 | 33714 | 154 | 1.252252 | 1.92846808 | Cervus elaphus hippelaphus | 46360 | Chordata | Chordata | 51.6 | 6.01e-6 | NR | OWK16157.1 | 46360 | g33295 | i0 | 84 | 0.487012987012987 | 25 | 4 | 48.7 | 0 | 80 | 154 | 179 | 203 | OWK16157.1 hypothetical protein Celaphus_00003981 [Cervus elaphus hippelaphus] | diamond | 75 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 31109962 | 31109962 | PRJNA1085664_S_NODE_19295_length_198_cov_2.477419_g18876_i0 | PRJNA1085664 | 19295 | 198 | 2.477419 | 4.90528962 | Eumetopias jubatus | 34886 | Chordata | Chordata | 46.2 | 0.00127 | NR | XP_027969646.1 | 34886 | g18876 | i0 | 71 | 1.40909090909091 | 31 | 9 | 47 | 0 | 106 | 198 | 96 | 126 | XP_027969646.1 pachytene checkpoint protein 2 homolog [Eumetopias jubatus] | diamond | 279 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Otariidae | Eumetopias | Eumetopias jubatus | |
| 31268233 | 31268233 | PRJNA1085664_S_NODE_21615_length_188_cov_1.986207_g21196_i0 | PRJNA1085664 | 21615 | 188 | 1.986207 | 3.73406916 | Eschrichtius robustus | 9764 | Chordata | Chordata | 73.2 | 3.3e-13 | NR | KAJ8791547.1 | 9764 | g21196 | i0 | 75.8 | 0.98936170212766 | 62 | 15 | 98.9 | 0 | 1 | 186 | 299 | 360 | KAJ8791547.1 hypothetical protein J1605_020643 [Eschrichtius robustus] | diamond | 186 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31458120 | 31458120 | PRJNA1085664_S_NODE_37116_length_150_cov_1.130841_g36697_i0 | PRJNA1085664 | 37116 | 150 | 1.130841 | 1.6962615 | Sus scrofa | 9823 | Chordata | Chordata | 51.6 | 4.21e-6 | NR | XP_020945645.1 | 9823 | g36697 | i0 | 100 | 1.36 | 34 | 0 | 68 | 0 | 1 | 102 | 5 | 38 | XP_020945645.1 proline-rich protein 18-like isoform X3 [Sus scrofa] | diamond | 204 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 31742525 | 31742525 | PRJNA1085664_S_NODE_23577_length_181_cov_1.391304_g23158_i0 | PRJNA1085664 | 23577 | 181 | 1.391304 | 2.51826024 | Phyllostomus discolor | 89673 | Chordata | Chordata | 42.4 | 0.00947 | NR | KAF6125225.1 | 89673 | g23158 | i0 | 48.7 | 0.646408839779006 | 39 | 19 | 63 | 1 | 33 | 146 | 88 | 126 | KAF6125225.1 hypothetical protein HJG60_009746 [Phyllostomus discolor] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 31828743 | 31828743 | PRJNA1085664_S_NODE_30897_length_160_cov_1.230769_g30478_i0 | PRJNA1085664 | 30897 | 160 | 1.230769 | 1.9692304 | Mammalia | 40674 | Chordata | Chordata | 50.8 | 1.16e-5 | NR | KAI5947274.1 | 9974 | g30478 | i0 | 48.1 | 6.84375 | 52 | 27 | 97.5 | 0 | 160 | 5 | 60 | 111 | KAI5947274.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 1095 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 31963994 | 31963994 | PRJNA1085664_S_NODE_36198_length_151_cov_0.888889_g35779_i0 | PRJNA1085664 | 36198 | 151 | 0.888889 | 1.34222239 | Elephas maximus indicus | 99487 | Chordata | Chordata | 50.4 | 8.66e-6 | NR | XP_049722511.1 | 99487 | g35779 | i0 | 82.1 | 0.556291390728477 | 28 | 5 | 55.6 | 0 | 34 | 117 | 74 | 101 | XP_049722511.1 RING finger protein 122 isoform X1 [Elephas maximus indicus] | diamond | 84 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Proboscidea | Elephantidae | Elephas | Elephas maximus | |
| 32470553 | 32470553 | PRJNA1085664_S_NODE_36999_length_150_cov_1.345794_g36580_i0 | PRJNA1085664 | 36999 | 150 | 1.345794 | 2.018691 | Eschrichtius robustus | 9764 | Chordata | Chordata | 46.6 | 4.2e-4 | NR | KAJ8784093.1 | 9764 | g36580 | i0 | 69.4 | 0.72 | 36 | 10 | 70 | 1 | 28 | 132 | 145 | 180 | KAJ8784093.1 hypothetical protein J1605_008593 [Eschrichtius robustus] | diamond | 108 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 32565556 | 32565556 | PRJNA1085664_S_NODE_23499_length_181_cov_1.811594_g23080_i0 | PRJNA1085664 | 23499 | 181 | 1.811594 | 3.27898514 | Camelus dromedarius | 9838 | Chordata | Chordata | 43.5 | 0.00898 | NR | KAB1268256.1 | 9838 | g23080 | i0 | 54.8 | 0.696132596685083 | 42 | 19 | 69.6 | 0 | 44 | 169 | 1 | 42 | KAB1268256.1 hypothetical protein Cadr_000013791 [Camelus dromedarius] | diamond | 126 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus dromedarius | |
| 32691070 | 32691070 | PRJNA1085664_S_NODE_10960_length_263_cov_1.309091_g10541_i0 | PRJNA1085664 | 10960 | 263 | 1.309091 | 3.44290933 | Smutsia gigantea | 1559511 | Chordata | Chordata | 42.7 | 0.0273 | NR | KAK2495661.1 | 1559511 | g10541 | i0 | 44 | 0.570342205323194 | 50 | 27 | 55.9 | 1 | 104 | 250 | 16 | 65 | KAK2495661.1 hypothetical protein MC885_018523, partial [Smutsia gigantea] | diamond | 150 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Smutsia | Smutsia gigantea |
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);;