contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18850150 | 18850150 | PRJEB83711_P_NODE_22535_length_374_cov_1.375415_g22269_i0 | PRJEB83711 | 22535 | 374 | 1.375415 | 5.1440521 | Chelydra serpentina | 8475 | Chordata | Chordata | 177 | 3.53e-53 | NR | KAG6930089.1 | 8475 | g22269 | i0 | 75.2 | 4.85294117647059 | 121 | 30 | 97.1 | 0 | 372 | 10 | 129 | 249 | KAG6930089.1 hypothetical protein G0U57_004388, partial [Chelydra serpentina] | diamond | 1815 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Chelydridae | Chelydra | Chelydra serpentina | ||
| 26844712 | 26844712 | PRJEB83711_P_NODE_61741_length_251_cov_0.876404_g61475_i0 | PRJEB83711 | 61741 | 251 | 0.876404 | 2.19977404 | Myotis brandtii | 109478 | Chordata | Chordata | 56.6 | 5.28e-7 | NR | EPQ09303.1 | 109478 | g61475 | i0 | 49.1 | 2.54581673306773 | 53 | 26 | 62.2 | 1 | 79 | 234 | 63 | 115 | EPQ09303.1 Cytochrome P450 2B11 [Myotis brandtii] | diamond | 639 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis brandtii | |
| 26970924 | 26970924 | PRJEB83711_P_NODE_16902_length_430_cov_4.512605_g16636_i0 | PRJEB83711 | 16902 | 430 | 4.512605 | 19.4042015 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 142 | 4.37e-38 | NR | XP_051791274.1 | 27687 | g16636 | i0 | 60.4 | 6.78837209302326 | 139 | 27 | 96.3 | 2 | 17 | 430 | 115 | 226 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2919 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27255536 | 27255536 | PRJEB83711_P_NODE_76023_length_243_cov_1.388235_g75757_i0 | PRJEB83711 | 76023 | 243 | 1.388235 | 3.37341105 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 150 | 7.87e-41 | NR | KAJ7313892.1 | 171643 | g75757 | i0 | 93.8 | 0.987654320987654 | 80 | 5 | 98.8 | 0 | 241 | 2 | 214 | 293 | KAJ7313892.1 hypothetical protein JRQ81_005671 [Phrynocephalus forsythii] | diamond | 240 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 27382125 | 27382125 | PRJEB83711_P_NODE_44703_length_278_cov_1.278049_g44437_i0 | PRJEB83711 | 44703 | 278 | 1.278049 | 3.55297622 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 72.4 | 1.35e-12 | NR | KAI4586026.1 | 2918886 | g44437 | i0 | 79.2 | 0.517985611510791 | 48 | 10 | 51.8 | 0 | 278 | 135 | 34 | 81 | KAI4586026.1 hypothetical protein MJG53_003813 [Ovis ammon polii x Ovis aries] | diamond | 144 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 27571454 | 27571454 | PRJEB83711_P_NODE_67024_length_248_cov_0.891429_g66758_i0 | PRJEB83711 | 67024 | 248 | 0.891429 | 2.21074392 | Eublepharis macularius | 481883 | Chordata | Chordata | 55.5 | 1.27e-6 | NR | XP_054852797.1 | 481883 | g66758 | i0 | 36.1 | 0.870967741935484 | 72 | 46 | 87.1 | 0 | 7 | 222 | 200 | 271 | XP_054852797.1 uncharacterized protein LOC129341561 isoform X1 [Eublepharis macularius] | diamond | 216 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Eublepharidae | Eublepharis | Eublepharis macularius | |
| 27627427 | 27627427 | PRJEB83711_P_NODE_61244_length_251_cov_0.876404_g60978_i0 | PRJEB83711 | 61244 | 251 | 0.876404 | 2.19977404 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 1.14e-4 | NR | CAI5777507.1 | 74358 | g60978 | i0 | 80 | 3.28685258964143 | 25 | 5 | 29.9 | 0 | 126 | 200 | 56 | 80 | CAI5777507.1 Hypothetical predicted protein [Podarcis lilfordi] | diamond | 825 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis lilfordi | |
| 27753775 | 27753775 | PRJEB83711_P_NODE_55764_length_256_cov_1.371585_g55498_i0 | PRJEB83711 | 55764 | 256 | 1.371585 | 3.5112576 | Rodentia | 9989 | Chordata | Chordata | 44.7 | 0.00919 | NR | NP_032602.1 | 10090 | g55498 | i0 | 71.7 | 28.34765625 | 46 | 13 | 53.9 | 0 | 114 | 251 | 1430 | 1475 | NP_032602.1 multidrug resistance-associated protein 1 isoform 1 [Mus musculus] | diamond | 7257 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27981974 | 27981974 | PRJEB83711_P_NODE_19945_length_396_cov_3.297214_g19679_i0 | PRJEB83711 | 19945 | 396 | 3.297214 | 13.05696744 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0337 | NR | KAG2471189.1 | 55291 | g19679 | i0 | 57.1 | 0.265151515151515 | 35 | 15 | 26.5 | 0 | 196 | 92 | 92 | 126 | KAG2471189.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28045030 | 28045030 | PRJEB83711_P_NODE_44565_length_278_cov_1.687805_g44299_i0 | PRJEB83711 | 44565 | 278 | 1.687805 | 4.6920979 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 177 | 1.24e-50 | NR | KAJ7319640.1 | 171643 | g44299 | i0 | 84.6 | 1.96402877697842 | 91 | 14 | 98.2 | 0 | 4 | 276 | 474 | 564 | KAJ7319640.1 hypothetical protein JRQ81_019151 [Phrynocephalus forsythii] | diamond | 546 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 28985242 | 28985242 | PRJEB83711_P_NODE_54808_length_258_cov_0.978378_g54542_i0 | PRJEB83711 | 54808 | 258 | 0.978378 | 2.52421524 | Anura | 8342 | Chordata | Chordata | 45.1 | 0.00663 | NR | XP_041429831.1 | 8355 | g54542 | i0 | 35.7 | 2.97674418604651 | 84 | 54 | 97.7 | 0 | 3 | 254 | 334 | 417 | XP_041429831.1 uncharacterized protein LOC121397286 [Xenopus laevis] | diamond | 768 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 29244918 | 29244918 | PRJEB83711_P_NODE_64969_length_249_cov_0.886364_g64703_i0 | PRJEB83711 | 64969 | 249 | 0.886364 | 2.20704636 | Ranitomeya imitator | 111125 | Chordata | Chordata | 52.4 | 1.55e-5 | NR | XP_069604432.1 | 111125 | g64703 | i0 | 34.7 | 0.903614457831325 | 75 | 49 | 90.4 | 0 | 20 | 244 | 218 | 292 | XP_069604432.1 uncharacterized protein [Ranitomeya imitator] | diamond | 225 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 30160491 | 30160491 | PRJEB83711_P_NODE_17452_length_424_cov_0.789174_g17186_i0 | PRJEB83711 | 17452 | 424 | 0.789174 | 3.34609776 | Xenopus laevis | 8355 | Chordata | Chordata | 65.5 | 2.82e-9 | NR | XP_041429831.1 | 8355 | g17186 | i0 | 40 | 1.69103773584906 | 115 | 69 | 81.4 | 0 | 350 | 6 | 311 | 425 | XP_041429831.1 uncharacterized protein LOC121397286 [Xenopus laevis] | diamond | 717 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 30287501 | 30287501 | PRJEB83711_P_NODE_32992_length_313_cov_5.350000_g32726_i0 | PRJEB83711 | 32992 | 313 | 5.35 | 16.7455 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 1.79e-9 | NR | CAI9620946.1 | 386267 | g32726 | i0 | 70.3 | 0.354632587859425 | 37 | 11 | 35.5 | 0 | 239 | 129 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30887433 | 30887433 | PRJEB83711_P_NODE_59334_length_252_cov_1.240223_g59068_i0 | PRJEB83711 | 59334 | 252 | 1.240223 | 3.12536196 | Physeter macrocephalus | 9755 | Chordata | Chordata | 43.5 | 0.0218 | NR | XP_028353933.1 | 9755 | g59068 | i0 | 36.6 | 0.845238095238095 | 71 | 40 | 81 | 2 | 245 | 42 | 493 | 561 | XP_028353933.1 coiled-coil domain-containing protein 57 [Physeter macrocephalus] | diamond | 213 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 31013787 | 31013787 | PRJEB83711_P_NODE_68995_length_247_cov_0.896552_g68729_i0 | PRJEB83711 | 68995 | 247 | 0.896552 | 2.21448344 | Mobula hypostoma | 723540 | Chordata | Chordata | 53.1 | 8.1e-6 | NR | XP_062916020.1 | 723540 | g68729 | i0 | 39.7 | 0.88663967611336 | 73 | 42 | 86.2 | 1 | 3 | 215 | 511 | 583 | XP_062916020.1 nesprin-2 isoform X2 [Mobula hypostoma] | diamond | 219 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Myliobatidae | Mobula | Mobula hypostoma | |
| 31202912 | 31202912 | PRJEB83711_P_NODE_43895_length_280_cov_1.086957_g43629_i0 | PRJEB83711 | 43895 | 280 | 1.086957 | 3.0434796 | Bufotes viridis | 30338 | Chordata | Chordata | 50.1 | 9.04e-5 | NR | CAK8623450.1 | 30338 | g43629 | i0 | 90 | 0.321428571428571 | 30 | 3 | 32.1 | 0 | 158 | 247 | 157 | 186 | CAK8623450.1 hypothetical protein BUFVIR_LOCUS12817 [Bufotes viridis] | diamond | 90 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31519828 | 31519828 | PRJEB83711_P_NODE_67076_length_248_cov_0.891429_g66810_i0 | PRJEB83711 | 67076 | 248 | 0.891429 | 2.21074392 | Natator depressus | 27790 | Chordata | Chordata | 142 | 1.13e-39 | NR | CAM5079620.1 | 27790 | g66810 | i0 | 80.2 | 12.7379032258065 | 81 | 16 | 98 | 0 | 246 | 4 | 89 | 169 | CAM5079620.1 unnamed protein product [Natator depressus] | diamond | 3159 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Natator | Natator depressus | ||
| 31614541 | 31614541 | PRJEB83711_P_NODE_80516_length_236_cov_2.245399_g80250_i0 | PRJEB83711 | 80516 | 236 | 2.245399 | 5.29914164 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 118 | 3.5099999999999997e-32 | NR | KAJ7313365.1 | 171643 | g80250 | i0 | 81.3 | 1.90677966101695 | 75 | 13 | 94.1 | 1 | 2 | 223 | 53 | 127 | KAJ7313365.1 hypothetical protein JRQ81_004662 [Phrynocephalus forsythii] | diamond | 450 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii | |
| 32089066 | 32089066 | PRJEB83711_P_NODE_65838_length_249_cov_0.886364_g65572_i0 | PRJEB83711 | 65838 | 249 | 0.886364 | 2.20704636 | Leptonychotes weddellii | 9713 | Chordata | Chordata | 77 | 3.21e-14 | NR | XP_030877726.1 | 9713 | g65572 | i0 | 60.8 | 0.891566265060241 | 74 | 28 | 88 | 1 | 240 | 22 | 184 | 257 | XP_030877726.1 FH1/FH2 domain-containing protein 3-like, partial [Leptonychotes weddellii] | diamond | 222 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Leptonychotes | Leptonychotes weddellii | |
| 32657842 | 32657842 | PRJEB83711_P_NODE_74540_length_244_cov_0.912281_g74274_i0 | PRJEB83711 | 74540 | 244 | 0.912281 | 2.22596564 | Phocoena sinus | 42100 | Chordata | Chordata | 49.3 | 1.79e-4 | NR | XP_032466749.1 | 42100 | g74274 | i0 | 54.5 | 0.540983606557377 | 44 | 16 | 54.1 | 1 | 88 | 219 | 295 | 334 | XP_032466749.1 WD repeat and FYVE domain-containing protein 2 isoform X4 [Phocoena sinus] | diamond | 132 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Phocoenidae | Phocoena | Phocoena sinus | |
| 32745398 | 32745398 | PRJEB83711_P_NODE_74220_length_244_cov_0.912281_g73954_i0 | PRJEB83711 | 74220 | 244 | 0.912281 | 2.22596564 | Squamata | 8509 | Chordata | Chordata | 45.8 | 0.00271 | NR | XP_003220483.1 | 28377 | g73954 | i0 | 85.2 | 1.32786885245902 | 27 | 4 | 33.2 | 0 | 243 | 163 | 227 | 253 | XP_003220483.1 ATP synthase F(0) complex subunit B1, mitochondrial [Anolis carolinensis] | diamond | 324 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dactyloidae | Anolis | Anolis carolinensis | |
| 32752650 | 32752650 | PRJEB83711_P_NODE_53480_length_260_cov_1.663102_g53214_i0 | PRJEB83711 | 53480 | 260 | 1.663102 | 4.3240652 | Staurois parvus | 386267 | Chordata | Chordata | 87.8 | 2.45e-20 | NR | CAI9547784.1 | 386267 | g53214 | i0 | 50.7 | 0.865384615384615 | 75 | 37 | 86.5 | 0 | 1 | 225 | 15 | 89 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 225 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32847038 | 32847038 | PRJEB83711_P_NODE_70280_length_246_cov_1.156069_g70014_i0 | PRJEB83711 | 70280 | 246 | 1.156069 | 2.84392974 | Phrynocephalus forsythii | 171643 | Chordata | Chordata | 91.7 | 1.16e-19 | NR | KAJ7311176.1 | 171643 | g70014 | i0 | 67.1 | 0.890243902439024 | 73 | 24 | 89 | 0 | 24 | 242 | 290 | 362 | KAJ7311176.1 hypothetical protein JRQ81_006783 [Phrynocephalus forsythii] | diamond | 219 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Agamidae | Phrynocephalus | Phrynocephalus forsythii |
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);;