contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8045396 | 8045396 | PRJNA340009_P_NODE_37647_length_206_cov_4.515924_g37340_i0 | PRJNA340009 | 37647 | 206 | 4.515924 | 9.30280344 | Meles meles | 9662 | Chordata | Chordata | 62.4 | 2.73e-9 | NR | XP_045881491.1 | 9662 | g37340 | i0 | 63.4 | 1.19417475728155 | 41 | 15 | 59.7 | 0 | 79 | 201 | 171 | 211 | XP_045881491.1 LOW QUALITY PROTEIN: uncharacterized protein LOC123954405 [Meles meles] | diamond | 246 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 26807150 | 26807150 | PRJNA340009_P_NODE_14681_length_309_cov_1.111538_g14374_i0 | PRJNA340009 | 14681 | 309 | 1.111538 | 3.43465242 | Opisthokonta | 33154 | Chordata | Chordata | 48.5 | 6.07e-4 | NR | XP_006880946.1 | 28737 | g14374 | i0 | 52.8 | 3.7378640776699 | 53 | 23 | 51.5 | 2 | 292 | 134 | 211 | 261 | XP_006880946.1 PREDICTED: sepiapterin reductase [Elephantulus edwardii] | diamond | 1155 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Macroscelidea | Macroscelididae | Elephantulus | Elephantulus edwardii | |
| 27787086 | 27787086 | PRJNA340009_P_NODE_77284_length_161_cov_0.910714_g76977_i0 | PRJNA340009 | 77284 | 161 | 0.910714 | 1.46624954 | Chondrichthyes | 7777 | Chordata | Chordata | 43.5 | 0.00655 | NR | XP_067859951.1 | 212740 | g76977 | i0 | 48.5 | 1.84472049689441 | 33 | 17 | 61.5 | 0 | 154 | 56 | 194 | 226 | XP_067859951.1 cytokine receptor-like factor 3 [Heptranchias perlo] | diamond | 297 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 28211526 | 28211526 | PRJNA340009_P_NODE_67606_length_165_cov_0.879310_g67299_i0 | PRJNA340009 | 67606 | 165 | 0.87931 | 1.4508615 | Manis javanica | 9974 | Chordata | Chordata | 47.8 | 1.69e-4 | NR | KAI5936292.1 | 9974 | g67299 | i0 | 62.9 | 2.61818181818182 | 35 | 13 | 63.6 | 0 | 157 | 53 | 133 | 167 | KAI5936292.1 LINE-1 retrotransposable element ORF2 protein [Manis javanica] | diamond | 432 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 28274738 | 28274738 | PRJNA340009_P_NODE_37686_length_206_cov_3.273885_g37379_i0 | PRJNA340009 | 37686 | 206 | 3.273885 | 6.7442031 | Branchiostoma floridae | 7739 | Chordata | Chordata | 43.5 | 0.00929 | NR | XP_035673168.1 | 7739 | g37379 | i0 | 41.7 | 0.524271844660194 | 36 | 21 | 52.4 | 0 | 196 | 89 | 112 | 147 | XP_035673168.1 ADP-ribosylation factor-like [Branchiostoma floridae] | diamond | 108 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 28685499 | 28685499 | PRJNA340009_P_NODE_37367_length_207_cov_1.544304_g37060_i0 | PRJNA340009 | 37367 | 207 | 1.544304 | 3.19670928 | Phyllostomus discolor | 89673 | Chordata | Chordata | 65.1 | 7.04e-11 | NR | KAF6084338.1 | 89673 | g37060 | i0 | 63.3 | 0.710144927536232 | 49 | 18 | 71 | 0 | 51 | 197 | 71 | 119 | KAF6084338.1 hypothetical protein HJG60_008609 [Phyllostomus discolor] | diamond | 147 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 29790217 | 29790217 | PRJNA340009_P_NODE_45351_length_190_cov_44.113475_g45044_i0 | PRJNA340009 | 45351 | 190 | 44.113475 | 83.8156025 | Heterocephalus glaber | 10181 | Chordata | Chordata | 82 | 1.33e-17 | NR | EHB13068.1 | 10181 | g45044 | i0 | 88.4 | 12.3315789473684 | 43 | 5 | 67.9 | 0 | 19 | 147 | 114 | 156 | EHB13068.1 60S ribosomal protein L23a [Heterocephalus glaber] | diamond | 2343 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Bathyergidae | Heterocephalus | Heterocephalus glaber | |
| 30232698 | 30232698 | PRJNA340009_P_NODE_75112_length_161_cov_27.017857_g74805_i0 | PRJNA340009 | 75112 | 161 | 27.017857 | 43.49874977 | Branchiostoma floridae | 7739 | Chordata | Chordata | 40.8 | 0.0488 | NR | XP_035674994.1 | 7739 | g74805 | i0 | 82.4 | 0.316770186335404 | 17 | 3 | 31.7 | 0 | 2 | 52 | 174 | 190 | XP_035674994.1 tubulin alpha-1 chain-like [Branchiostoma floridae] | diamond | 51 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 30296358 | 30296358 | PRJNA340009_P_NODE_73252_length_162_cov_1.787611_g72945_i0 | PRJNA340009 | 73252 | 162 | 1.787611 | 2.89592982 | Staurois parvus | 386267 | Chordata | Chordata | 42.4 | 0.00477 | NR | CAI9547784.1 | 386267 | g72945 | i0 | 42.9 | 0.907407407407407 | 49 | 28 | 90.7 | 0 | 149 | 3 | 26 | 74 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 147 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30327955 | 30327955 | PRJNA340009_P_NODE_28092_length_233_cov_4.266304_g27785_i0 | PRJNA340009 | 28092 | 233 | 4.266304 | 9.94048832 | Ovis canadensis | 37174 | Chordata | Chordata | 44.3 | 0.00939 | NR | XP_069414236.1 | 37174 | g27785 | i0 | 53.6 | 0.721030042918455 | 56 | 19 | 64.4 | 3 | 60 | 209 | 77 | 131 | XP_069414236.1 aldehyde dehydrogenase, mitochondrial [Ovis canadensis] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis canadensis | |
| 30548582 | 30548582 | PRJNA340009_P_NODE_20153_length_269_cov_1.854545_g19846_i0 | PRJNA340009 | 20153 | 269 | 1.854545 | 4.98872605 | Eschrichtius robustus | 9764 | Chordata | Chordata | 85.1 | 2.93e-19 | NR | KAJ8781220.1 | 9764 | g19846 | i0 | 66.1 | 0.62453531598513 | 56 | 19 | 62.5 | 0 | 178 | 11 | 23 | 78 | KAJ8781220.1 hypothetical protein J1605_011204 [Eschrichtius robustus] | diamond | 168 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 31008243 | 31008243 | PRJNA340009_P_NODE_26654_length_239_cov_1.473684_g26347_i0 | PRJNA340009 | 26654 | 239 | 1.473684 | 3.52210476 | Metazoa | 33208 | Chordata | Chordata | 87 | 8.97e-18 | NR | XP_042313078.1 | 8520 | g26347 | i0 | 70.7 | 9.46443514644352 | 58 | 17 | 72.8 | 0 | 12 | 185 | 618 | 675 | XP_042313078.1 prolyl endopeptidase [Sceloporus undulatus] | diamond | 2262 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Phrynosomatidae | Sceloporus | Sceloporus undulatus | |
| 31781326 | 31781326 | PRJNA340009_P_NODE_42977_length_195_cov_2.027397_g42670_i0 | PRJNA340009 | 42977 | 195 | 2.027397 | 3.95342415 | Haliaeetus albicilla | 8969 | Chordata | Chordata | 44.3 | 0.00561 | NR | XP_069659176.1 | 8969 | g42670 | i0 | 42.3 | 0.8 | 52 | 27 | 75.4 | 2 | 11 | 157 | 48 | 99 | XP_069659176.1 uncharacterized protein [Haliaeetus albicilla] | diamond | 156 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Accipitriformes | Accipitridae | Haliaeetus | Haliaeetus albicilla | |
| 31813150 | 31813150 | PRJNA340009_P_NODE_80197_length_153_cov_4.903846_g79890_i0 | PRJNA340009 | 80197 | 153 | 4.903846 | 7.50288438 | Chrysemys picta bellii | 8478 | Chordata | Chordata | 42.4 | 0.014 | NR | XP_005313184.2 | 8478 | g79890 | i0 | 53.8 | 0.764705882352941 | 39 | 17 | 74.5 | 1 | 143 | 30 | 30 | 68 | XP_005313184.2 BET1-like protein [Chrysemys picta bellii] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Chrysemys | Chrysemys picta | ||
| 31844615 | 31844615 | PRJNA340009_P_NODE_30417_length_226_cov_1.056497_g30110_i0 | PRJNA340009 | 30417 | 226 | 1.056497 | 2.38768322 | Staurois parvus | 386267 | Chordata | Chordata | 44.7 | 3.83e-4 | NR | CAI9622433.1 | 386267 | g30110 | i0 | 81.8 | 0.292035398230089 | 22 | 4 | 29.2 | 0 | 12 | 77 | 11 | 32 | CAI9622433.1 unnamed protein product, partial [Staurois parvus] | diamond | 66 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31971256 | 31971256 | PRJNA340009_P_NODE_44798_length_191_cov_43.091549_g44491_i0 | PRJNA340009 | 44798 | 191 | 43.091549 | 82.30485859 | Teratoscincus roborowskii | 102174 | Chordata | Chordata | 49.7 | 6.41e-5 | NR | AIY32697.1 | 102174 | g44491 | i0 | 58.7 | 0.722513089005236 | 46 | 19 | 72.3 | 0 | 46 | 183 | 2 | 47 | AIY32697.1 NADH dehydrogenase subunit 1 [Teratoscincus roborowskii] | diamond | 138 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Sphaerodactylidae | Teratoscincus | Teratoscincus roborowskii | |
| 32002946 | 32002946 | PRJNA340009_P_NODE_18038_length_282_cov_3.304721_g17731_i0 | PRJNA340009 | 18038 | 282 | 3.304721 | 9.31931322 | Petromyzon marinus | 7757 | Chordata | Chordata | 43.9 | 0.0136 | NR | XP_032815660.1 | 7757 | g17731 | i0 | 31.8 | 0.702127659574468 | 66 | 44 | 70.2 | 1 | 8 | 205 | 29 | 93 | XP_032815660.1 nucleoside diphosphate kinase 6 [Petromyzon marinus] | diamond | 198 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 32698250 | 32698250 | PRJNA340009_P_NODE_29660_length_228_cov_2.279330_g29353_i0 | PRJNA340009 | 29660 | 228 | 2.27933 | 5.1968724 | Rhinolophus ferrumequinum | 59479 | Chordata | Chordata | 60.1 | 2.3e-8 | NR | ACC62065.1 | 59479 | g29353 | i0 | 64.6 | 1.26315789473684 | 48 | 17 | 63.2 | 0 | 35 | 178 | 287 | 334 | ACC62065.1 hypothetical protein [Rhinolophus ferrumequinum] | diamond | 288 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Rhinolophidae | Rhinolophus | Rhinolophus ferrumequinum | |
| 32824352 | 32824352 | PRJNA340009_P_NODE_38120_length_205_cov_3.403846_g37813_i0 | PRJNA340009 | 38120 | 205 | 3.403846 | 6.9778843 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 98.2 | 2.36e-22 | NR | XP_028681576.2 | 27687 | g37813 | i0 | 78.1 | 3.74634146341463 | 64 | 14 | 93.7 | 0 | 2 | 193 | 62 | 125 | XP_028681576.2 piggyBac transposable element-derived protein 4-like [Erpetoichthys calabaricus] | diamond | 768 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32887138 | 32887138 | PRJNA340009_P_NODE_42720_length_196_cov_0.884354_g42413_i0 | PRJNA340009 | 42720 | 196 | 0.884354 | 1.73333384 | Staurois parvus | 386267 | Chordata | Chordata | 50.1 | 7.71e-6 | NR | CAI9618505.1 | 386267 | g42413 | i0 | 52.6 | 1.16326530612245 | 38 | 18 | 58.2 | 0 | 5 | 118 | 14 | 51 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 228 | 50.1 | 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);;