contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA1111146" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26687927 | 26687927 | PRJNA1111146_P_NODE_358761_length_182_cov_0.868217_g357623_i0 | PRJNA1111146 | 358761 | 182 | 0.868217 | 1.58015494 | Lynx pardinus | 191816 | Chordata | Chordata | 42.4 | 0.016 | NR | VFV23952.1 | 191816 | g357623 | i0 | 61.1 | 1.00549450549451 | 36 | 13 | 57.7 | 1 | 12 | 116 | 58 | 93 | VFV23952.1 Hypothetical predicted protein, partial [Lynx pardinus] | diamond | 183 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Lynx | Lynx pardinus | |
| 27067714 | 27067714 | PRJNA1111146_P_NODE_336922_length_183_cov_0.876923_g335784_i0 | PRJNA1111146 | 336922 | 183 | 0.876923 | 1.60476909 | Equus caballus | 9796 | Chordata | Chordata | 43.1 | 0.012 | NR | XP_070102340.1 | 9796 | g335784 | i0 | 63.9 | 1.0327868852459 | 36 | 13 | 59 | 0 | 179 | 72 | 83 | 118 | XP_070102340.1 DNA excision repair protein ERCC-8 isoform X2 [Equus caballus] | diamond | 189 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus caballus | |
| 27194110 | 27194110 | PRJNA1111146_P_NODE_200262_length_206_cov_1.490196_g199124_i0 | PRJNA1111146 | 200262 | 206 | 1.490196 | 3.06980376 | Canis lupus familiaris | 9615 | Chordata | Chordata | 63.2 | 1.45e-9 | NR | BAA25253.1 | 9615 | g199124 | i0 | 50 | 2.6504854368932 | 58 | 28 | 83 | 1 | 33 | 203 | 911 | 968 | BAA25253.1 unnamed protein product [Canis lupus familiaris] | diamond | 546 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 27194138 | 27194138 | PRJNA1111146_P_NODE_382102_length_180_cov_0.897638_g380964_i0 | PRJNA1111146 | 382102 | 180 | 0.897638 | 1.6157484 | Chinchilla lanigera | 34839 | Chordata | Chordata | 85.1 | 1.58e-17 | NR | XP_013361742.1 | 34839 | g380964 | i0 | 85.7 | 0.933333333333333 | 56 | 8 | 93.3 | 0 | 178 | 11 | 191 | 246 | XP_013361742.1 PREDICTED: collagen alpha-2(I) chain-like [Chinchilla lanigera] | diamond | 168 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Chinchillidae | Chinchilla | Chinchilla lanigera | |
| 27352508 | 27352508 | PRJNA1111146_P_NODE_238583_length_198_cov_2.606897_g237445_i0 | PRJNA1111146 | 238583 | 198 | 2.606897 | 5.16165606 | Ovis aries | 9940 | Chordata | Chordata | 67 | 8.81e-12 | NR | XDA83449.1 | 9940 | g237445 | i0 | 74.4 | 0.590909090909091 | 39 | 10 | 59.1 | 0 | 148 | 32 | 41 | 79 | XDA83449.1 hypothetical protein R6Z07_013537 [Ovis aries] | diamond | 117 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 27659478 | 27659478 | PRJNA1111146_P_NODE_206124_length_205_cov_1.473684_g204986_i0 | PRJNA1111146 | 206124 | 205 | 1.473684 | 3.0210522 | Ovis | 9935 | Chordata | Chordata | 89.7 | 6.55e-19 | NR | KAG5207710.1 | 9940 | g204986 | i0 | 67.2 | 1.9609756097561 | 67 | 21 | 98 | 1 | 4 | 204 | 2851 | 2916 | KAG5207710.1 hypothetical protein JEQ12_017474 [Ovis aries] | diamond | 402 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 27888934 | 27888934 | PRJNA1111146_P_NODE_202785_length_206_cov_1.104575_g201647_i0 | PRJNA1111146 | 202785 | 206 | 1.104575 | 2.2754245 | Phyllostomus discolor | 89673 | Chordata | Chordata | 62.4 | 9.07e-10 | NR | KAF6072886.1 | 89673 | g201647 | i0 | 56.3 | 0.699029126213592 | 48 | 21 | 69.9 | 0 | 205 | 62 | 110 | 157 | KAF6072886.1 hypothetical protein HJG60_010423 [Phyllostomus discolor] | diamond | 144 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 28489043 | 28489043 | PRJNA1111146_P_NODE_390027_length_180_cov_0.881890_g388889_i0 | PRJNA1111146 | 390027 | 180 | 0.88189 | 1.587402 | Choloepus didactylus | 27675 | Chordata | Chordata | 52.8 | 4.54e-6 | NR | XP_037684815.1 | 27675 | g388889 | i0 | 63.6 | 0.55 | 33 | 12 | 55 | 0 | 80 | 178 | 306 | 338 | XP_037684815.1 endogenous retrovirus group V member 2 Env polyprotein-like [Choloepus didactylus] | diamond | 99 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus | |
| 28678581 | 28678581 | PRJNA1111146_P_NODE_315127_length_185_cov_0.863636_g313989_i0 | PRJNA1111146 | 315127 | 185 | 0.863636 | 1.5977266 | Acinonyx jubatus | 32536 | Chordata | Chordata | 43.9 | 0.00676 | NR | XP_026898278.2 | 32536 | g313989 | i0 | 71.4 | 0.681081081081081 | 42 | 9 | 64.9 | 2 | 1 | 120 | 150 | 190 | XP_026898278.2 probable G-protein coupled receptor 27 [Acinonyx jubatus] | diamond | 126 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Acinonyx | Acinonyx jubatus | |
| 28867851 | 28867851 | PRJNA1111146_P_NODE_357008_length_182_cov_0.875969_g355870_i0 | PRJNA1111146 | 357008 | 182 | 0.875969 | 1.59426358 | Nipponia nippon | 128390 | Chordata | Chordata | 42 | 0.0306 | NR | XP_009473365.1 | 128390 | g355870 | i0 | 69 | 0.478021978021978 | 29 | 6 | 47.8 | 1 | 87 | 1 | 1 | 26 | XP_009473365.1 PREDICTED: ribokinase [Nipponia nippon] | diamond | 87 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Pelecaniformes | Threskiornithidae | Nipponia | Nipponia nippon | |
| 28994430 | 28994430 | PRJNA1111146_P_NODE_11828_length_454_cov_1.329177_g10699_i0 | PRJNA1111146 | 11828 | 454 | 1.329177 | 6.03446358 | Staurois parvus | 386267 | Chordata | Chordata | 48.1 | 5.26e-4 | NR | CAI9547784.1 | 386267 | g10699 | i0 | 54.1 | 0.244493392070485 | 37 | 17 | 24.4 | 0 | 343 | 453 | 50 | 86 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 111 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29373102 | 29373102 | PRJNA1111146_P_NODE_407289_length_179_cov_0.880952_g406151_i0 | PRJNA1111146 | 407289 | 179 | 0.880952 | 1.57690408 | Sus scrofa | 9823 | Chordata | Chordata | 43.9 | 0.00625 | NR | XP_020946894.1 | 9823 | g406151 | i0 | 50 | 1.75977653631285 | 50 | 22 | 78.8 | 1 | 146 | 6 | 1 | 50 | XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] | diamond | 315 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 29531008 | 29531008 | PRJNA1111146_P_NODE_9750_length_496_cov_2.801354_g8629_i0 | PRJNA1111146 | 9750 | 496 | 2.801354 | 13.89471584 | Staurois parvus | 386267 | Chordata | Chordata | 58.5 | 1.23e-7 | NR | CAI9533415.1 | 386267 | g8629 | i0 | 40 | 2.04435483870968 | 110 | 47 | 55 | 4 | 107 | 379 | 1 | 110 | CAI9533415.1 unnamed protein product [Staurois parvus] | diamond | 1014 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29562354 | 29562354 | PRJNA1111146_P_NODE_272430_length_192_cov_1.323741_g271292_i0 | PRJNA1111146 | 272430 | 192 | 1.323741 | 2.54158272 | Manis javanica | 9974 | Chordata | Chordata | 55.5 | 5.85e-7 | NR | KAI5937361.1 | 9974 | g271292 | i0 | 66.7 | 3.171875 | 51 | 13 | 73.4 | 2 | 50 | 190 | 178 | 228 | KAI5937361.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 609 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 29751671 | 29751671 | PRJNA1111146_P_NODE_313471_length_185_cov_0.863636_g312333_i0 | PRJNA1111146 | 313471 | 185 | 0.863636 | 1.5977266 | Suricata suricatta | 37032 | Chordata | Chordata | 64.3 | 4.19e-10 | NR | XP_029771491.1 | 37032 | g312333 | i0 | 58.3 | 0.972972972972973 | 60 | 24 | 97.3 | 1 | 184 | 5 | 71 | 129 | XP_029771491.1 prolyl 4-hydroxylase subunit alpha-3 [Suricata suricatta] | diamond | 180 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Herpestidae | Suricata | Suricata suricatta | |
| 29814987 | 29814987 | PRJNA1111146_P_NODE_249471_length_196_cov_1.853147_g248333_i0 | PRJNA1111146 | 249471 | 196 | 1.853147 | 3.6321681199999998 | Cavia porcellus | 10141 | Chordata | Chordata | 48.1 | 2.57e-4 | NR | XP_063101670.1 | 10141 | g248333 | i0 | 61.8 | 0.520408163265306 | 34 | 13 | 52 | 0 | 111 | 10 | 557 | 590 | XP_063101670.1 LOW QUALITY PROTEIN: uncharacterized protein LOC106026455 [Cavia porcellus] | diamond | 102 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Caviidae | Cavia | Cavia porcellus | |
| 30162353 | 30162353 | PRJNA1111146_P_NODE_317012_length_184_cov_2.282443_g315874_i0 | PRJNA1111146 | 317012 | 184 | 2.2824430000000002 | 4.19969512 | Odocoileus virginianus | 9874 | Chordata | Chordata | 72.8 | 1.55e-13 | NR | XP_070309256.1 | 9874 | g315874 | i0 | 83.3 | 0.684782608695652 | 42 | 7 | 68.5 | 0 | 58 | 183 | 191 | 232 | XP_070309256.1 G1/S-specific cyclin-D2 isoform X1 [Odocoileus virginianus] | diamond | 126 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 30447138 | 30447138 | PRJNA1111146_P_NODE_91453_length_248_cov_1.830769_g90315_i0 | PRJNA1111146 | 91453 | 248 | 1.830769 | 4.54030712 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 60.1 | 3.13e-8 | NR | XP_069906595.1 | 9986 | g90315 | i0 | 59.6 | 2.2741935483871 | 47 | 19 | 56.9 | 0 | 189 | 49 | 594 | 640 | XP_069906595.1 LOW QUALITY PROTEIN: LINE-1 retrotransposable element ORF2 protein [Oryctolagus cuniculus] | diamond | 564 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus | |
| 30604847 | 30604847 | PRJNA1111146_P_NODE_342713_length_183_cov_0.869231_g341575_i0 | PRJNA1111146 | 342713 | 183 | 0.869231 | 1.59069273 | Cnephaeus nilssonii | 3371016 | Chordata | Chordata | 62.8 | 1.41e-9 | NR | KAK1345167.1 | 3371016 | g341575 | i0 | 77.5 | 14.4098360655738 | 40 | 9 | 65.6 | 0 | 182 | 63 | 218 | 257 | KAK1345167.1 hypothetical protein QTO34_013877 [Cnephaeus nilssonii] | diamond | 2637 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Cnephaeus | Cnephaeus nilssonii | |
| 30754164 | 30754164 | PRJNA1111146_P_NODE_341814_length_183_cov_0.869231_g340676_i0 | PRJNA1111146 | 341814 | 183 | 0.869231 | 1.59069273 | Gymnophiona | 8445 | Chordata | Chordata | 54.3 | 1.27e-6 | NR | XP_033818801.1 | 260995 | g340676 | i0 | 51.7 | 4.67213114754098 | 58 | 28 | 95.1 | 0 | 176 | 3 | 70 | 127 | XP_033818801.1 NF-kappa-B inhibitor delta [Geotrypetes seraphini] | diamond | 855 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 30785696 | 30785696 | PRJNA1111146_P_NODE_295674_length_188_cov_1.133333_g294536_i0 | PRJNA1111146 | 295674 | 188 | 1.133333 | 2.13066604 | Mammalia | 40674 | Chordata | Chordata | 47 | 2.18e-4 | NR | KAF6435770.1 | 9407 | g294536 | i0 | 64.1 | 4.22872340425532 | 39 | 12 | 62.2 | 1 | 50 | 166 | 45 | 81 | KAF6435770.1 hypothetical protein HJG63_012498 [Rousettus aegyptiacus] | diamond | 795 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 30794391 | 30794391 | PRJNA1111146_P_NODE_231894_length_200_cov_1.217687_g230756_i0 | PRJNA1111146 | 231894 | 200 | 1.217687 | 2.435374 | Tiliqua scincoides | 71010 | Chordata | Chordata | 57 | 2.01e-7 | NR | XP_066486932.1 | 71010 | g230756 | i0 | 39.3 | 9.645 | 61 | 36 | 90 | 1 | 2 | 181 | 3744 | 3804 | XP_066486932.1 MAX gene-associated protein isoform X1 [Tiliqua scincoides] | diamond | 1929 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Scincidae | Tiliqua | Tiliqua scincoides | |
| 31363541 | 31363541 | PRJNA1111146_P_NODE_369776_length_181_cov_0.890625_g368638_i0 | PRJNA1111146 | 369776 | 181 | 0.890625 | 1.61203125 | Muntiacus muntjak | 9888 | Chordata | Chordata | 52.4 | 6.45e-6 | NR | KAB0342827.1 | 9888 | g368638 | i0 | 89.3 | 0.464088397790055 | 28 | 3 | 46.4 | 0 | 4 | 87 | 380 | 407 | KAB0342827.1 hypothetical protein FD754_019753 [Muntiacus muntjak] | diamond | 84 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 31679534 | 31679534 | PRJNA1111146_P_NODE_212057_length_204_cov_1.165563_g210919_i0 | PRJNA1111146 | 212057 | 204 | 1.165563 | 2.37774852 | Ambystoma mexicanum | 8296 | Chordata | Chordata | 50.1 | 5.75e-5 | NR | XP_069467883.1 | 8296 | g210919 | i0 | 48.1 | 2.63235294117647 | 52 | 27 | 76.5 | 0 | 8 | 163 | 101 | 152 | XP_069467883.1 uncharacterized protein [Ambystoma mexicanum] | diamond | 537 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31774457 | 31774457 | PRJNA1111146_P_NODE_341357_length_183_cov_0.869231_g340219_i0 | PRJNA1111146 | 341357 | 183 | 0.869231 | 1.59069273 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 83.6 | 8e-18 | NR | KAI4571944.1 | 2918886 | g340219 | i0 | 93.2 | 0.721311475409836 | 44 | 1 | 68.9 | 1 | 48 | 173 | 135 | 178 | KAI4571944.1 hypothetical protein MJG53_014050 [Ovis ammon polii x Ovis aries] | diamond | 132 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 32249533 | 32249533 | PRJNA1111146_P_NODE_360238_length_181_cov_2.296875_g359100_i0 | PRJNA1111146 | 360238 | 181 | 2.296875 | 4.15734375 | Felis catus | 9685 | Chordata | Chordata | 58.5 | 2.58e-8 | NR | XP_044916283.1 | 9685 | g359100 | i0 | 81.8 | 0.729281767955801 | 44 | 6 | 72.9 | 1 | 48 | 179 | 154 | 195 | XP_044916283.1 uncharacterized protein LOC123386175 [Felis catus] | diamond | 132 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Felis | Felis catus | |
| 32565863 | 32565863 | PRJNA1111146_P_NODE_430659_length_177_cov_0.919355_g429521_i0 | PRJNA1111146 | 430659 | 177 | 0.919355 | 1.62725835 | Bos mutus | 72004 | Chordata | Chordata | 50.1 | 3.99e-5 | NR | MXQ81817.1 | 72004 | g429521 | i0 | 100 | 0.372881355932203 | 22 | 0 | 37.3 | 0 | 14 | 79 | 263 | 284 | MXQ81817.1 hypothetical protein [Bos mutus] | diamond | 66 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 32597175 | 32597175 | PRJNA1111146_P_NODE_384340_length_180_cov_0.897638_g383202_i0 | PRJNA1111146 | 384340 | 180 | 0.897638 | 1.6157484 | Muntiacus reevesi | 9886 | Chordata | Chordata | 48.9 | 1.05e-4 | NR | KAB0346092.1 | 9886 | g383202 | i0 | 76.5 | 0.566666666666667 | 34 | 8 | 56.7 | 0 | 160 | 59 | 39 | 72 | KAB0346092.1 hypothetical protein FD755_024261, partial [Muntiacus reevesi] | diamond | 102 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi |
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);;