contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1145276" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11766872 | 11766872 | PRJNA1145276_P_NODE_11810_length_296_cov_1.035874_g11753_i0 | PRJNA1145276 | 11810 | 296 | 1.035874 | 3.06618704 | Cricetulus griseus | 10029 | Chordata | Chordata | 81.3 | 5.35e-18 | NR | EGV98992.1 | 10029 | g11753 | i0 | 80.4 | 0.466216216216216 | 46 | 9 | 46.6 | 0 | 150 | 13 | 18 | 63 | EGV98992.1 hypothetical protein I79_014295 [Cricetulus griseus] | diamond | 138 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 19414642 | 19414642 | PRJNA1145276_P_NODE_9516_length_330_cov_1.832685_g9459_i0 | PRJNA1145276 | 9516 | 330 | 1.832685 | 6.0478605 | root | 1 | Root_unresolved | Root_unresolved | 143 | 5.99e-37 | NR | ERE66291.1 | 10029 | g9459 | i0 | 83.3 | 1.52727272727273 | 84 | 14 | 76.4 | 0 | 254 | 3 | 103 | 186 | ERE66291.1 CD177 antigen [Cricetulus griseus] | diamond | 504 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 26595466 | 26595466 | PRJNA1145276_P_NODE_721_length_1080_cov_2.879841_g684_i0 | PRJNA1145276 | 721 | 1080 | 2.879841 | 31.1022828 | Cricetulus griseus | 10029 | Chordata | Chordata | 304 | 9.5e-96 | NR | XP_035306442.1 | 10029 | g684 | i0 | 51 | 2.54166666666667 | 306 | 140 | 85 | 2 | 919 | 2 | 59 | 354 | XP_035306442.1 endogenous retrovirus group K member 113 Gag polyprotein isoform X1 [Cricetulus griseus] | diamond | 2745 | 304 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 26627374 | 26627374 | PRJNA1145276_P_NODE_16881_length_248_cov_0.880000_g16824_i0 | PRJNA1145276 | 16881 | 248 | 0.88 | 2.1824 | Panthera pardus | 9691 | Chordata | Chordata | 43.9 | 0.0149 | NR | XP_053747462.1 | 9691 | g16824 | i0 | 44.1 | 0.786290322580645 | 34 | 19 | 41.1 | 0 | 97 | 198 | 340 | 373 | XP_053747462.1 histone deacetylase 8 isoform X9 [Panthera pardus] | diamond | 195 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Panthera | Panthera pardus | |
| 26753712 | 26753712 | PRJNA1145276_P_NODE_3841_length_499_cov_0.938967_g3784_i0 | PRJNA1145276 | 3841 | 499 | 0.938967 | 4.68544533 | Mesocricetus auratus | 10036 | Chordata | Chordata | 55.8 | 1.28e-5 | NR | XP_040587518.1 | 10036 | g3784 | i0 | 36.6 | 0.559118236472946 | 93 | 41 | 45.1 | 1 | 111 | 335 | 215 | 307 | XP_040587518.1 LOW QUALITY PROTEIN: olfactory receptor 52H1-like [Mesocricetus auratus] | diamond | 279 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 27102068 | 27102068 | PRJNA1145276_P_NODE_4902_length_447_cov_1.157754_g4845_i0 | PRJNA1145276 | 4902 | 447 | 1.157754 | 5.17516038 | Mus musculus | 10090 | Chordata | Chordata | 57 | 6.89e-7 | NR | EDL08153.1 | 10090 | g4845 | i0 | 63.4 | 0.550335570469799 | 41 | 14 | 26.8 | 1 | 121 | 2 | 32 | 72 | EDL08153.1 mCG1030119 [Mus musculus] | diamond | 246 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27133395 | 27133395 | PRJNA1145276_P_NODE_14922_length_260_cov_0.823529_g14865_i0 | PRJNA1145276 | 14922 | 260 | 0.823529 | 2.1411754 | Sigmodon hispidus | 42415 | Chordata | Chordata | 85.1 | 1.57e-18 | NR | KAL1770787.1 | 42415 | g14865 | i0 | 64.2 | 0.611538461538462 | 53 | 19 | 61.2 | 0 | 164 | 6 | 49 | 101 | KAL1770787.1 protease, partial [Sigmodon hispidus] | diamond | 159 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Sigmodon | Sigmodon hispidus | |
| 27544534 | 27544534 | PRJNA1145276_P_NODE_14904_length_260_cov_1.235294_g14847_i0 | PRJNA1145276 | 14904 | 260 | 1.235294 | 3.2117644 | Mesocricetus auratus | 10036 | Chordata | Chordata | 166 | 4.73e-46 | NR | XP_040610490.1 | 10036 | g14847 | i0 | 82.6 | 0.992307692307692 | 86 | 15 | 99.2 | 0 | 3 | 260 | 397 | 482 | XP_040610490.1 MLV-related proviral Env polyprotein-like [Mesocricetus auratus] | diamond | 258 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 27702689 | 27702689 | PRJNA1145276_P_NODE_18704_length_243_cov_0.905882_g18647_i0 | PRJNA1145276 | 18704 | 243 | 0.905882 | 2.20129326 | Mirounga leonina | 9715 | Chordata | Chordata | 60.1 | 2.98e-8 | NR | KAF3830573.1 | 9715 | g18647 | i0 | 73.7 | 2.2962962962963 | 38 | 10 | 46.9 | 0 | 213 | 100 | 147 | 184 | KAF3830573.1 hypothetical protein GH733_004392 [Mirounga leonina] | diamond | 558 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga leonina | |
| 28018218 | 28018218 | PRJNA1145276_P_NODE_4825_length_450_cov_1.222812_g4768_i0 | PRJNA1145276 | 4825 | 450 | 1.222812 | 5.502654 | Suncus etruscus | 109475 | Chordata | Chordata | 58.9 | 7.4e-7 | NR | XP_049645818.1 | 109475 | g4768 | i0 | 61.5 | 0.346666666666667 | 52 | 20 | 34.7 | 0 | 84 | 239 | 165 | 216 | XP_049645818.1 endogenous retrovirus group K member 6 Gag polyprotein-like [Suncus etruscus] | diamond | 156 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 28649702 | 28649702 | PRJNA1145276_P_NODE_19327_length_241_cov_1.821429_g19270_i0 | PRJNA1145276 | 19327 | 241 | 1.821429 | 4.38964389 | Apodemus sylvaticus | 10129 | Chordata | Chordata | 43.5 | 0.0195 | NR | XP_052026244.1 | 10129 | g19270 | i0 | 64.9 | 0.460580912863071 | 37 | 9 | 41.1 | 1 | 108 | 10 | 148 | 184 | XP_052026244.1 igE-binding protein-like [Apodemus sylvaticus] | diamond | 111 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus sylvaticus | |
| 28901986 | 28901986 | PRJNA1145276_P_NODE_18348_length_244_cov_0.900585_g18291_i0 | PRJNA1145276 | 18348 | 244 | 0.900585 | 2.1974274 | Phocoena sinus | 42100 | Chordata | Chordata | 72.8 | 3.62e-14 | NR | XP_032469154.1 | 42100 | g18291 | i0 | 75.6 | 37.6475409836066 | 45 | 11 | 55.3 | 0 | 49 | 183 | 66 | 110 | XP_032469154.1 peptidyl-prolyl cis-trans isomerase E-like [Phocoena sinus] | diamond | 9186 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Phocoenidae | Phocoena | Phocoena sinus | |
| 29218112 | 29218112 | PRJNA1145276_P_NODE_15709_length_251_cov_0.865169_g15652_i0 | PRJNA1145276 | 15709 | 251 | 0.865169 | 2.17157419 | Phodopus roborovskii | 109678 | Chordata | Chordata | 46.2 | 0.00246 | NR | CAH6780257.1 | 109678 | g15652 | i0 | 44.6 | 1.32669322709163 | 56 | 22 | 61 | 2 | 53 | 205 | 8 | 59 | CAH6780257.1 Trpc5 [Phodopus roborovskii] | diamond | 333 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Phodopus | Phodopus roborovskii | |
| 29375770 | 29375770 | PRJNA1145276_P_NODE_5489_length_425_cov_1.306818_g5432_i0 | PRJNA1145276 | 5489 | 425 | 1.306818 | 5.5539765 | Mus musculus | 10090 | Chordata | Chordata | 123 | 2.11e-29 | NR | AXP11718.1 | 10090 | g5432 | i0 | 52.8 | 4.32 | 123 | 58 | 86.8 | 0 | 6 | 374 | 373 | 495 | AXP11718.1 putative gag-pol protein [Mus musculus] | diamond | 1836 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29817677 | 29817677 | PRJNA1145276_P_NODE_6151_length_403_cov_1.166667_g6094_i0 | PRJNA1145276 | 6151 | 403 | 1.166667 | 4.70166801 | Rattus norvegicus | 10116 | Chordata | Chordata | 153 | 2.9299999999999996e-42 | NR | pir|JC7527| | 10116 | g6094 | i0 | 53.4 | 1.95037220843672 | 131 | 61 | 97.5 | 0 | 401 | 9 | 201 | 331 | pir|JC7527| nuclear retroviral polymerase-like protein - rat [Rattus norvegicus] | diamond | 786 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 29849504 | 29849504 | PRJNA1145276_P_NODE_15291_length_255_cov_1.269231_g15234_i0 | PRJNA1145276 | 15291 | 255 | 1.269231 | 3.23653905 | Rattus norvegicus | 10116 | Chordata | Chordata | 46.2 | 1.76e-4 | NR | EDM06249.1 | 10116 | g15234 | i0 | 69.7 | 0.388235294117647 | 33 | 8 | 36.5 | 1 | 96 | 188 | 24 | 56 | EDM06249.1 rCG35309 [Rattus norvegicus] | diamond | 99 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 30133398 | 30133398 | PRJNA1145276_P_NODE_13632_length_274_cov_1.915423_g13575_i0 | PRJNA1145276 | 13632 | 274 | 1.915423 | 5.24825902 | Suncus etruscus | 109475 | Chordata | Chordata | 150 | 4.04e-40 | NR | XP_049636651.1 | 109475 | g13575 | i0 | 72.5 | 0.996350364963504 | 91 | 25 | 99.6 | 0 | 1 | 273 | 364 | 454 | XP_049636651.1 MLV-related proviral Env polyprotein-like [Suncus etruscus] | diamond | 273 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 30449937 | 30449937 | PRJNA1145276_P_NODE_11333_length_302_cov_1.606987_g11276_i0 | PRJNA1145276 | 11333 | 302 | 1.606987 | 4.85310074 | Cricetulus griseus | 10029 | Chordata | Chordata | 112 | 1.39e-27 | NR | ERE68429.1 | 10029 | g11276 | i0 | 49 | 3.9635761589404 | 100 | 51 | 99.3 | 0 | 2 | 301 | 161 | 260 | ERE68429.1 putative Gag polyprotein [Cricetulus griseus] | diamond | 1197 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30722862 | 30722862 | PRJNA1145276_P_NODE_19314_length_242_cov_0.863905_g19257_i0 | PRJNA1145276 | 19314 | 242 | 0.863905 | 2.0906501 | Chordata | 7711 | Chordata | Chordata | 67 | 9.89e-11 | NR | VCW67208.1 | 48420 | g19257 | i0 | 75 | 23.1694214876033 | 40 | 10 | 49.6 | 0 | 112 | 231 | 23 | 62 | VCW67208.1 unnamed protein product, partial [Gulo gulo] | diamond | 5607 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Gulo | Gulo gulo | |
| 31239489 | 31239489 | PRJNA1145276_P_NODE_16775_length_248_cov_0.880000_g16718_i0 | PRJNA1145276 | 16775 | 248 | 0.88 | 2.1824 | Microtus ochrogaster | 79684 | Chordata | Chordata | 60.8 | 1.62e-8 | NR | KAH0517223.1 | 79684 | g16718 | i0 | 75 | 0.483870967741935 | 40 | 10 | 48.4 | 0 | 148 | 29 | 1 | 40 | KAH0517223.1 Dual specificity protein phosphatase 26 [Microtus ochrogaster] | diamond | 120 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Microtus | Microtus ochrogaster | |
| 31461248 | 31461248 | PRJNA1145276_P_NODE_16876_length_248_cov_0.880000_g16819_i0 | PRJNA1145276 | 16876 | 248 | 0.88 | 2.1824 | Nannospalax galili | 1026970 | Chordata | Chordata | 112 | 1.18e-26 | NR | XP_029409942.1 | 1026970 | g16819 | i0 | 65.1 | 1.00403225806452 | 83 | 28 | 99.2 | 1 | 247 | 2 | 75 | 157 | XP_029409942.1 uncharacterized protein LOC115066968 [Nannospalax galili] | diamond | 249 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Spalacidae | Nannospalax | Nannospalax galili | |
| 31808961 | 31808961 | PRJNA1145276_P_NODE_9157_length_336_cov_1.536122_g9100_i0 | PRJNA1145276 | 9157 | 336 | 1.536122 | 5.16136992 | Suncus etruscus | 109475 | Chordata | Chordata | 90.9 | 1.38e-18 | NR | XP_049628622.1 | 109475 | g9100 | i0 | 68.4 | 2.49107142857143 | 57 | 18 | 50.9 | 0 | 164 | 334 | 1 | 57 | XP_049628622.1 endogenous retrovirus group K member 10 Gag polyprotein-like [Suncus etruscus] | diamond | 837 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 32505215 | 32505215 | PRJNA1145276_P_NODE_13779_length_273_cov_1.150000_g13722_i0 | PRJNA1145276 | 13779 | 273 | 1.15 | 3.1395 | Microtus oregoni | 111838 | Chordata | Chordata | 65.9 | 3.76e-10 | NR | XP_041504608.1 | 111838 | g13722 | i0 | 47.8 | 1.01098901098901 | 92 | 35 | 98.9 | 3 | 271 | 2 | 67 | 147 | XP_041504608.1 endogenous retrovirus group K member 10 Gag polyprotein-like [Microtus oregoni] | diamond | 276 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Microtus | Microtus oregoni | |
| 32631062 | 32631062 | PRJNA1145276_P_NODE_6540_length_392_cov_1.206897_g6483_i0 | PRJNA1145276 | 6540 | 392 | 1.206897 | 4.73103624 | Alexandromys fortis | 100897 | Chordata | Chordata | 222 | 2.47e-67 | NR | XP_049988519.1 | 100897 | g6483 | i0 | 78.5 | 0.994897959183674 | 130 | 28 | 99.5 | 0 | 390 | 1 | 291 | 420 | XP_049988519.1 igE-binding protein-like [Alexandromys fortis] | diamond | 390 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Alexandromys | Alexandromys fortis | |
| 32746251 | 32746251 | PRJNA1145276_P_NODE_1260_length_838_cov_1.439216_g1213_i0 | PRJNA1145276 | 1260 | 838 | 1.439216 | 12.06063008 | Mammalia | 40674 | Chordata | Chordata | 399 | 8.799999999999999e-127 | NR | MBZ3886481.1 | 30640 | g1213 | i0 | 99 | 38.1551312649165 | 201 | 2 | 72 | 0 | 3 | 605 | 423 | 623 | MBZ3886481.1 Nuclear factor NF-kappa-B p105 subunit [Sciurus carolinensis] | diamond | 31974 | 403 | 0.990074441687345 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 32777538 | 32777538 | PRJNA1145276_P_NODE_14840_length_261_cov_1.095745_g14783_i0 | PRJNA1145276 | 14840 | 261 | 1.095745 | 2.85989445 | Aves | 8782 | Chordata | Chordata | 49.7 | 1.68e-4 | NR | PKK33602.1 | 8932 | g14783 | i0 | 67.6 | 4.03448275862069 | 34 | 11 | 39.1 | 0 | 104 | 205 | 193 | 226 | PKK33602.1 endogenous retrovirus group K member 18 Pol protein-like [Columba livia] | diamond | 1053 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Columbiformes | Columbidae | Columba | Columba livia |
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);;