contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJEB48872" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6446924 | 6446924 | PRJEB48872_P_NODE_235106_length_345_cov_1.526144_g219294_i0 | PRJEB48872 | 235106 | 345 | 1.526144 | 5.2651968 | root | 1 | Root_unresolved | Root_unresolved | 108 | 1.0099999999999999e-24 | NR | BAA20419.1 | 10090 | g219294 | i0 | 46.1 | 6 | 115 | 56 | 95.7 | 2 | 331 | 2 | 911 | 1024 | BAA20419.1 reverse transcriptase, partial [Mus musculus] | diamond | 2070 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26812026 | 26812026 | PRJEB48872_P_NODE_370581_length_244_cov_2.868293_g354769_i0 | PRJEB48872 | 370581 | 244 | 2.868293 | 6.99863492 | Cervus elaphus | 9860 | Chordata | Chordata | 58.2 | 1.4e-7 | NR | XP_043734886.1 | 9860 | g354769 | i0 | 62.7 | 0.627049180327869 | 51 | 19 | 62.7 | 0 | 82 | 234 | 431 | 481 | XP_043734886.1 alpha-1,6-mannosyl-glycoprotein 4-beta-N-acetylglucosaminyltransferase-like [Cervus elaphus] | diamond | 153 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 26812030 | 26812030 | PRJEB48872_P_NODE_509441_length_191_cov_1.368421_g493629_i0 | PRJEB48872 | 509441 | 191 | 1.368421 | 2.61368411 | Mesocricetus auratus | 10036 | Chordata | Chordata | 48.1 | 2.21e-4 | NR | XP_040613942.1 | 10036 | g493629 | i0 | 44.4 | 0.848167539267016 | 54 | 30 | 84.8 | 0 | 189 | 28 | 244 | 297 | XP_040613942.1 pre-mRNA 3' end processing protein WDR33 isoform X2 [Mesocricetus auratus] | diamond | 162 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 27096661 | 27096661 | PRJEB48872_P_NODE_216442_length_367_cov_1.570122_g200634_i0 | PRJEB48872 | 216442 | 367 | 1.570122 | 5.76234774 | Alexandromys fortis | 100897 | Chordata | Chordata | 46.6 | 0.00598 | NR | XP_050003558.1 | 100897 | g200634 | i0 | 48.8 | 0.572207084468665 | 41 | 21 | 33.5 | 0 | 71 | 193 | 220 | 260 | XP_050003558.1 adiponectin receptor protein 1 [Alexandromys fortis] | diamond | 210 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Alexandromys | Alexandromys fortis | |
| 27159643 | 27159643 | PRJEB48872_P_NODE_370622_length_244_cov_2.751220_g354810_i0 | PRJEB48872 | 370622 | 244 | 2.75122 | 6.7129768 | Cervus canadensis | 1574408 | Chordata | Chordata | 52.4 | 1.55e-5 | NR | XP_043342340.1 | 1574408 | g354810 | i0 | 48.3 | 0.713114754098361 | 58 | 30 | 71.3 | 0 | 244 | 71 | 796 | 853 | XP_043342340.1 antiviral innate immune response receptor RIG-I-like [Cervus canadensis] | diamond | 174 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus canadensis | |
| 27318127 | 27318127 | PRJEB48872_P_NODE_652983_length_158_cov_1.260504_g637171_i0 | PRJEB48872 | 652983 | 158 | 1.260504 | 1.99159632 | Staurois parvus | 386267 | Chordata | Chordata | 51.2 | 7.9e-7 | NR | CAI9540006.1 | 386267 | g637171 | i0 | 57.5 | 0.759493670886076 | 40 | 17 | 75.9 | 0 | 123 | 4 | 1 | 40 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 120 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27570598 | 27570598 | PRJEB48872_P_NODE_32324_length_1432_cov_8.974156_g23171_i0 | PRJEB48872 | 32324 | 1432 | 8.974156 | 128.50991392 | Mus musculus | 10090 | Chordata | Chordata | 46.6 | 0.0174 | NR | EDL30953.1 | 10090 | g23171 | i0 | 64.5 | 0.0649441340782123 | 31 | 11 | 6.5 | 0 | 121 | 29 | 37 | 67 | EDL30953.1 mCG145491, isoform CRA_b, partial [Mus musculus] | diamond | 93 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27886323 | 27886323 | PRJEB48872_P_NODE_292885_length_292_cov_4.683794_g277073_i0 | PRJEB48872 | 292885 | 292 | 4.683794 | 13.67667848 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 1.46e-9 | NR | CAI9620946.1 | 386267 | g277073 | i0 | 70.3 | 0.38013698630137 | 37 | 11 | 38 | 0 | 255 | 145 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28265101 | 28265101 | PRJEB48872_P_NODE_699206_length_150_cov_1.108108_g683394_i0 | PRJEB48872 | 699206 | 150 | 1.108108 | 1.662162 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 85.5 | 3.36e-19 | NR | KAI4551129.1 | 2918886 | g683394 | i0 | 83.3 | 7.54 | 48 | 8 | 96 | 0 | 7 | 150 | 52 | 99 | KAI4551129.1 hypothetical protein MJG53_000307 [Ovis ammon polii x Ovis aries] | diamond | 1131 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 28707394 | 28707394 | PRJEB48872_P_NODE_305067_length_284_cov_1.297959_g289255_i0 | PRJEB48872 | 305067 | 284 | 1.297959 | 3.68620356 | Alexandromys fortis | 100897 | Chordata | Chordata | 87 | 3.61e-19 | NR | XP_049977085.1 | 100897 | g289255 | i0 | 51.1 | 38.7253521126761 | 94 | 46 | 99.3 | 0 | 283 | 2 | 20 | 113 | XP_049977085.1 40S ribosomal protein S15-like [Alexandromys fortis] | diamond | 10998 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Alexandromys | Alexandromys fortis | |
| 28707404 | 28707404 | PRJEB48872_P_NODE_612887_length_166_cov_0.858268_g597075_i0 | PRJEB48872 | 612887 | 166 | 0.858268 | 1.42472488 | Mus musculus | 10090 | Chordata | Chordata | 44.3 | 4.16e-4 | NR | EDL36965.1 | 10090 | g597075 | i0 | 61.1 | 0.650602409638554 | 36 | 11 | 59.6 | 1 | 100 | 2 | 1 | 36 | EDL36965.1 mCG148278 [Mus musculus] | diamond | 108 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28770392 | 28770392 | PRJEB48872_P_NODE_369407_length_245_cov_1.781553_g353595_i0 | PRJEB48872 | 369407 | 245 | 1.781553 | 4.36480485 | Rattus norvegicus | 10116 | Chordata | Chordata | 42.4 | 0.0136 | NR | EDM00356.1 | 10116 | g353595 | i0 | 77.8 | 0.330612244897959 | 27 | 6 | 33.1 | 0 | 30 | 110 | 21 | 47 | EDM00356.1 rCG35761, isoform CRA_a [Rattus norvegicus] | diamond | 81 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 29464685 | 29464685 | PRJEB48872_P_NODE_249090_length_330_cov_3.116838_g233278_i0 | PRJEB48872 | 249090 | 330 | 3.116838 | 10.2855654 | Mus musculus | 10090 | Chordata | Chordata | 43.5 | 0.0197 | NR | EDL01504.1 | 10090 | g233278 | i0 | 48.8 | 0.372727272727273 | 41 | 21 | 37.3 | 0 | 330 | 208 | 94 | 134 | EDL01504.1 mCG145865, partial [Mus musculus] | diamond | 123 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29464688 | 29464688 | PRJEB48872_P_NODE_621510_length_164_cov_1.312000_g605698_i0 | PRJEB48872 | 621510 | 164 | 1.312 | 2.15168 | Mastomys coucha | 35658 | Chordata | Chordata | 42 | 0.0126 | NR | XP_031226809.1 | 35658 | g605698 | i0 | 58.1 | 1.13414634146341 | 31 | 13 | 56.7 | 0 | 153 | 61 | 31 | 61 | XP_031226809.1 keratin-associated protein 10-1-like isoform X2 [Mastomys coucha] | diamond | 186 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mastomys | Mastomys coucha | |
| 29528315 | 29528315 | PRJEB48872_P_NODE_543510_length_182_cov_0.881119_g527698_i0 | PRJEB48872 | 543510 | 182 | 0.881119 | 1.60363658 | Panthera uncia | 29064 | Chordata | Chordata | 42.7 | 0.0167 | NR | XP_049490775.1 | 29064 | g527698 | i0 | 44.7 | 0.774725274725275 | 47 | 23 | 75.8 | 2 | 23 | 160 | 593 | 637 | XP_049490775.1 ubiquilin-4 isoform X1 [Panthera uncia] | diamond | 141 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Panthera | Panthera uncia | |
| 29647426 | 29647426 | PRJEB48872_P_NODE_575810_length_174_cov_1.214815_g559998_i0 | PRJEB48872 | 575810 | 174 | 1.214815 | 2.1137781 | Rodentia | 9989 | Chordata | Chordata | 43.5 | 7.3e-4 | NR | EGV96219.1 | 10029 | g559998 | i0 | 57.1 | 1.39655172413793 | 28 | 12 | 48.3 | 0 | 91 | 8 | 26 | 53 | EGV96219.1 hypothetical protein I79_005905 [Cricetulus griseus] | diamond | 243 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30033627 | 30033627 | PRJEB48872_P_NODE_471151_length_203_cov_1.250000_g455339_i0 | PRJEB48872 | 471151 | 203 | 1.25 | 2.5375 | Apodemus speciosus | 105296 | Chordata | Chordata | 44.3 | 0.00648 | NR | GAB1298491.1 | 105296 | g455339 | i0 | 62.5 | 0.472906403940887 | 32 | 12 | 47.3 | 0 | 121 | 26 | 554 | 585 | GAB1298491.1 Transcription factor TFIIIB component B'' homolog [Apodemus speciosus] | diamond | 96 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 30791772 | 30791772 | PRJEB48872_P_NODE_524774_length_187_cov_0.918919_g508962_i0 | PRJEB48872 | 524774 | 187 | 0.918919 | 1.71837853 | Engystomops pustulosus | 76066 | Chordata | Chordata | 43.1 | 0.0134 | NR | KAG8571490.1 | 76066 | g508962 | i0 | 49.3 | 7.50802139037433 | 67 | 25 | 99.5 | 2 | 187 | 2 | 1069 | 1131 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 1404 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31329035 | 31329035 | PRJEB48872_P_NODE_153156_length_473_cov_2.168203_g137397_i0 | PRJEB48872 | 153156 | 473 | 2.168203 | 10.25560019 | Apodemus speciosus | 105296 | Chordata | Chordata | 53.9 | 4.32e-5 | NR | GAB1285821.1 | 105296 | g137397 | i0 | 79.3 | 0.183932346723044 | 29 | 6 | 18.4 | 0 | 115 | 29 | 206 | 234 | GAB1285821.1 BRO1 domain-containing protein BROX [Apodemus speciosus] | diamond | 87 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 31487415 | 31487415 | PRJEB48872_P_NODE_303656_length_285_cov_1.219512_g287844_i0 | PRJEB48872 | 303656 | 285 | 1.219512 | 3.4756092 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 124 | 3.04e-33 | NR | KAI4562102.1 | 2918886 | g287844 | i0 | 72.9 | 0.894736842105263 | 85 | 23 | 89.5 | 0 | 29 | 283 | 54 | 138 | KAI4562102.1 hypothetical protein MJT46_011064 [Ovis ammon polii x Ovis aries] | diamond | 255 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 31708597 | 31708597 | PRJEB48872_P_NODE_140977_length_503_cov_1.618534_g125274_i0 | PRJEB48872 | 140977 | 503 | 1.618534 | 8.14122602 | Capra hircus | 9925 | Chordata | Chordata | 92.4 | 2.95e-18 | NR | XP_017900741.1 | 9925 | g125274 | i0 | 53.5 | 0.602385685884692 | 101 | 45 | 60.2 | 2 | 350 | 48 | 214 | 312 | XP_017900741.1 PREDICTED: collagen alpha-1(I) chain-like, partial [Capra hircus] | diamond | 303 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 31866590 | 31866590 | PRJEB48872_P_NODE_558377_length_178_cov_1.230216_g542565_i0 | PRJEB48872 | 558377 | 178 | 1.230216 | 2.18978448 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 70.9 | 3.38e-13 | NR | KAI4561493.1 | 2918886 | g542565 | i0 | 97.1 | 1.71910112359551 | 34 | 0 | 57.3 | 1 | 75 | 176 | 171 | 203 | KAI4561493.1 hypothetical protein MJG53_016547 [Ovis ammon polii x Ovis aries] | diamond | 306 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 32049875 | 32049875 | PRJEB48872_P_NODE_647758_length_159_cov_1.158333_g631946_i0 | PRJEB48872 | 647758 | 159 | 1.158333 | 1.8417494700000001 | Chordata | 7711 | Chordata | Chordata | 71.2 | 1.07e-12 | NR | KAE8579759.1 | 8364 | g631946 | i0 | 58.3 | 57.9622641509434 | 48 | 20 | 90.6 | 0 | 13 | 156 | 66 | 113 | KAE8579759.1 hypothetical protein XENTR_v10024172 [Xenopus tropicalis] | diamond | 9216 | 71.6 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32151555 | 32151555 | PRJEB48872_P_NODE_324298_length_271_cov_1.413793_g308486_i0 | PRJEB48872 | 324298 | 271 | 1.413793 | 3.83137903 | Mus musculus | 10090 | Chordata | Chordata | 47.4 | 2.15e-4 | NR | EDL11837.1 | 10090 | g308486 | i0 | 73.1 | 0.287822878228782 | 26 | 7 | 28.8 | 0 | 142 | 65 | 49 | 74 | EDL11837.1 mCG1035771, isoform CRA_b [Mus musculus] | diamond | 78 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 32151556 | 32151556 | PRJEB48872_P_NODE_350838_length_255_cov_1.555556_g335026_i0 | PRJEB48872 | 350838 | 255 | 1.555556 | 3.9666678 | Heptranchias perlo | 212740 | Chordata | Chordata | 52.4 | 1.74e-5 | NR | XP_067844505.1 | 212740 | g335026 | i0 | 40.3 | 0.905882352941176 | 77 | 46 | 90.6 | 0 | 22 | 252 | 62 | 138 | XP_067844505.1 ankyrin repeat domain-containing protein 63 [Heptranchias perlo] | diamond | 231 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 32373176 | 32373176 | PRJEB48872_P_NODE_682659_length_152_cov_2.584071_g666847_i0 | PRJEB48872 | 682659 | 152 | 2.584071 | 3.92778792 | Mus musculus | 10090 | Chordata | Chordata | 97.1 | 1.24e-24 | NR | BAE34520.1 | 10090 | g666847 | i0 | 98 | 0.967105263157895 | 49 | 1 | 96.7 | 0 | 149 | 3 | 39 | 87 | BAE34520.1 unnamed protein product [Mus musculus] | diamond | 147 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 32594494 | 32594494 | PRJEB48872_P_NODE_519960_length_188_cov_1.422819_g504148_i0 | PRJEB48872 | 519960 | 188 | 1.422819 | 2.67489972 | Ovis ammon polii | 230172 | Chordata | Chordata | 45.1 | 0.00221 | NR | KAI4529053.1 | 230172 | g504148 | i0 | 83.3 | 0.382978723404255 | 24 | 4 | 38.3 | 0 | 100 | 171 | 1 | 24 | KAI4529053.1 hypothetical protein MG293_020891 [Ovis ammon polii] | diamond | 72 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon | |
| 32814741 | 32814741 | PRJEB48872_P_NODE_360300_length_250_cov_1.208531_g344488_i0 | PRJEB48872 | 360300 | 250 | 1.208531 | 3.0213275 | Staurois parvus | 386267 | Chordata | Chordata | 41.6 | 0.00886 | NR | CAI9601297.1 | 386267 | g344488 | i0 | 43.2 | 0.528 | 44 | 23 | 50.4 | 1 | 233 | 108 | 3 | 46 | CAI9601297.1 unnamed protein product [Staurois parvus] | diamond | 132 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus |
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);;