contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27070350 | 27070350 | PRJNA1137393_P_NODE_73502_length_162_cov_0.920354_g72986_i0 | PRJNA1137393 | 73502 | 162 | 0.920354 | 1.49097348 | Engystomops pustulosus | 76066 | Chordata | Chordata | 45.4 | 0.00138 | NR | KAG8571490.1 | 76066 | g72986 | i0 | 60.9 | 3.42592592592593 | 46 | 18 | 85.2 | 0 | 6 | 143 | 1030 | 1075 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 555 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 27165041 | 27165041 | PRJNA1137393_P_NODE_49542_length_167_cov_0.881356_g49026_i0 | PRJNA1137393 | 49542 | 167 | 0.881356 | 1.47186452 | Staurois parvus | 386267 | Chordata | Chordata | 50.1 | 5.09e-6 | NR | CAI9547784.1 | 386267 | g49026 | i0 | 43.6 | 1.67065868263473 | 55 | 31 | 98.8 | 0 | 2 | 166 | 21 | 75 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 279 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27797103 | 27797103 | PRJNA1137393_P_NODE_58044_length_165_cov_0.896552_g57528_i0 | PRJNA1137393 | 58044 | 165 | 0.896552 | 1.4793108 | Equus przewalskii | 9798 | Chordata | Chordata | 50.8 | 1.78e-5 | NR | XP_070443790.1 | 9798 | g57528 | i0 | 71.4 | 1.58181818181818 | 28 | 8 | 50.9 | 0 | 148 | 65 | 965 | 992 | XP_070443790.1 uncharacterized protein [Equus przewalskii] | diamond | 261 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus przewalskii | |
| 27859919 | 27859919 | PRJNA1137393_P_NODE_17545_length_211_cov_1.080247_g17029_i0 | PRJNA1137393 | 17545 | 211 | 1.080247 | 2.27932117 | Engystomops pustulosus | 76066 | Chordata | Chordata | 57 | 2.35e-7 | NR | KAG8571490.1 | 76066 | g17029 | i0 | 51.5 | 4.69194312796209 | 66 | 32 | 93.8 | 0 | 208 | 11 | 1022 | 1087 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 990 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28007202 | 28007202 | PRJNA1137393_P_NODE_37865_length_171_cov_0.827869_g37349_i0 | PRJNA1137393 | 37865 | 171 | 0.827869 | 1.41565599 | Anura | 8342 | Chordata | Chordata | 42 | 0.0264 | NR | XP_066453998.1 | 57060 | g37349 | i0 | 54.3 | 2.47368421052632 | 35 | 16 | 61.4 | 0 | 66 | 170 | 116 | 150 | XP_066453998.1 uncharacterized protein [Eleutherodactylus coqui] | diamond | 423 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 28049514 | 28049514 | PRJNA1137393_P_NODE_48065_length_167_cov_0.881356_g47549_i0 | PRJNA1137393 | 48065 | 167 | 0.881356 | 1.47186452 | Pleurodeles waltl | 8319 | Chordata | Chordata | 64.3 | 3.24e-10 | NR | KAJ1209028.1 | 8319 | g47549 | i0 | 48.1 | 1.94011976047904 | 54 | 28 | 97 | 0 | 3 | 164 | 497 | 550 | KAJ1209028.1 hypothetical protein NDU88_004407 [Pleurodeles waltl] | diamond | 324 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 28049518 | 28049518 | PRJNA1137393_P_NODE_61845_length_164_cov_0.904348_g61329_i0 | PRJNA1137393 | 61845 | 164 | 0.904348 | 1.48313072 | Engystomops pustulosus | 76066 | Chordata | Chordata | 52 | 6.75e-7 | NR | KAG8573553.1 | 76066 | g61329 | i0 | 61.5 | 12.6585365853659 | 52 | 20 | 95.1 | 0 | 163 | 8 | 8 | 59 | KAG8573553.1 hypothetical protein GDO81_012454 [Engystomops pustulosus] | diamond | 2076 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 28207210 | 28207210 | PRJNA1137393_P_NODE_74726_length_155_cov_2.726415_g74210_i0 | PRJNA1137393 | 74726 | 155 | 2.726415 | 4.22594325 | Ranitomeya imitator | 111125 | Chordata | Chordata | 44.3 | 0.00313 | NR | CAJ0956274.1 | 111125 | g74210 | i0 | 52.9 | 1.35483870967742 | 34 | 16 | 65.8 | 0 | 48 | 149 | 1 | 34 | CAJ0956274.1 unnamed protein product [Ranitomeya imitator] | diamond | 210 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 28322672 | 28322672 | PRJNA1137393_P_NODE_42086_length_169_cov_0.866667_g41570_i0 | PRJNA1137393 | 42086 | 169 | 0.866667 | 1.46466723 | Amphibia | 8292 | Chordata | Chordata | 56.6 | 1.76e-7 | NR | XP_069461787.1 | 8296 | g41570 | i0 | 51.9 | 1.95266272189349 | 54 | 25 | 94.1 | 1 | 1 | 159 | 530 | 583 | XP_069461787.1 uncharacterized protein [Ambystoma mexicanum] | diamond | 330 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 29028617 | 29028617 | PRJNA1137393_P_NODE_58308_length_165_cov_0.896552_g57792_i0 | PRJNA1137393 | 58308 | 165 | 0.896552 | 1.4793108 | Orcinus orca | 9733 | Chordata | Chordata | 50.8 | 1.78e-5 | NR | XP_049552061.1 | 9733 | g57792 | i0 | 65.3 | 2.67272727272727 | 49 | 15 | 85.5 | 2 | 141 | 1 | 237 | 285 | XP_049552061.1 COMM domain-containing protein 1 isoform X1 [Orcinus orca] | diamond | 441 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Orcinus | Orcinus orca | |
| 29091582 | 29091582 | PRJNA1137393_P_NODE_33188_length_177_cov_1.171875_g32672_i0 | PRJNA1137393 | 33188 | 177 | 1.171875 | 2.07421875 | Eretmochelys imbricata | 27787 | Chordata | Chordata | 43.1 | 0.0119 | NR | CAM5095396.1 | 27787 | g32672 | i0 | 37.3 | 2.25423728813559 | 67 | 26 | 86.4 | 2 | 7 | 159 | 3665 | 3731 | CAM5095396.1 unnamed protein product [Eretmochelys imbricata] | diamond | 399 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Eretmochelys | Eretmochelys imbricata | ||
| 29123327 | 29123327 | PRJNA1137393_P_NODE_22569_length_195_cov_0.917808_g22053_i0 | PRJNA1137393 | 22569 | 195 | 0.917808 | 1.7897256 | Heterodontus francisci | 7792 | Chordata | Chordata | 51.6 | 1.09e-5 | NR | XP_067875135.1 | 7792 | g22053 | i0 | 54.7 | 0.815384615384615 | 53 | 22 | 81.5 | 1 | 25 | 183 | 8 | 58 | XP_067875135.1 ras homolog family member Ub isoform X2 [Heterodontus francisci] | diamond | 159 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 29123328 | 29123328 | PRJNA1137393_P_NODE_26509_length_187_cov_1.318841_g25993_i0 | PRJNA1137393 | 26509 | 187 | 1.318841 | 2.46623267 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 40.8 | 0.0412 | NR | CAD7673045.1 | 34880 | g25993 | i0 | 74.2 | 0.497326203208556 | 31 | 8 | 49.7 | 0 | 90 | 182 | 99 | 129 | CAD7673045.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 93 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 29123330 | 29123330 | PRJNA1137393_P_NODE_34989_length_174_cov_1.616000_g34473_i0 | PRJNA1137393 | 34989 | 174 | 1.616 | 2.81184 | Peromyscus californicus insignis | 564181 | Chordata | Chordata | 48.1 | 1.79e-4 | NR | XP_052608684.1 | 564181 | g34473 | i0 | 45.8 | 0.827586206896552 | 48 | 26 | 82.8 | 0 | 152 | 9 | 173 | 220 | XP_052608684.1 zinc finger protein 709-like [Peromyscus californicus insignis] | diamond | 144 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Peromyscus | Peromyscus californicus | |
| 29123340 | 29123340 | PRJNA1137393_P_NODE_72469_length_162_cov_0.920354_g71953_i0 | PRJNA1137393 | 72469 | 162 | 0.920354 | 1.49097348 | Styela clava | 7725 | Chordata | Chordata | 57.4 | 8.22e-8 | NR | XP_039264563.1 | 7725 | g71953 | i0 | 63 | 3.55555555555556 | 46 | 16 | 85.2 | 1 | 154 | 17 | 437 | 481 | XP_039264563.1 uncharacterized protein LOC120340385 [Styela clava] | diamond | 576 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 29186393 | 29186393 | PRJNA1137393_P_NODE_41329_length_169_cov_0.866667_g40813_i0 | PRJNA1137393 | 41329 | 169 | 0.866667 | 1.46466723 | Pleurodeles waltl | 8319 | Chordata | Chordata | 80.1 | 8.94e-16 | NR | KAJ1096084.1 | 8319 | g40813 | i0 | 70.9 | 2.92899408284024 | 55 | 16 | 97.6 | 0 | 3 | 167 | 579 | 633 | KAJ1096084.1 hypothetical protein NDU88_001230 [Pleurodeles waltl] | diamond | 495 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29722652 | 29722652 | PRJNA1137393_P_NODE_51130_length_167_cov_0.881356_g50614_i0 | PRJNA1137393 | 51130 | 167 | 0.881356 | 1.47186452 | Pleurodeles waltl | 8319 | Chordata | Chordata | 89.7 | 3.7e-19 | NR | KAJ1082712.1 | 8319 | g50614 | i0 | 70.9 | 7.8502994011976 | 55 | 16 | 98.8 | 0 | 167 | 3 | 1404 | 1458 | KAJ1082712.1 hypothetical protein NDU88_002877 [Pleurodeles waltl] | diamond | 1311 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29849334 | 29849334 | PRJNA1137393_P_NODE_65451_length_163_cov_1.175439_g64935_i0 | PRJNA1137393 | 65451 | 163 | 1.175439 | 1.91596557 | Staurois parvus | 386267 | Chordata | Chordata | 45.8 | 2.12e-4 | NR | CAI9547784.1 | 386267 | g64935 | i0 | 40.4 | 0.957055214723926 | 52 | 31 | 95.7 | 0 | 158 | 3 | 34 | 85 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 156 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30323714 | 30323714 | PRJNA1137393_P_NODE_65812_length_163_cov_0.912281_g65296_i0 | PRJNA1137393 | 65812 | 163 | 0.912281 | 1.48701803 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 43.5 | 0.00683 | NR | KAI8494107.1 | 7741 | g65296 | i0 | 37.5 | 4.41717791411043 | 48 | 30 | 88.3 | 0 | 145 | 2 | 214 | 261 | KAI8494107.1 hypothetical protein Bbelb_284540 [Branchiostoma belcheri] | diamond | 720 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 30386740 | 30386740 | PRJNA1137393_P_NODE_67093_length_163_cov_0.912281_g66577_i0 | PRJNA1137393 | 67093 | 163 | 0.912281 | 1.48701803 | Acinonyx jubatus | 32536 | Chordata | Chordata | 46.6 | 5.58e-4 | NR | XP_053055818.1 | 32536 | g66577 | i0 | 55.6 | 0.828220858895706 | 45 | 16 | 82.8 | 1 | 135 | 1 | 6 | 46 | XP_053055818.1 polypeptide N-acetylgalactosaminyltransferase 10 isoform X1 [Acinonyx jubatus] | diamond | 135 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Acinonyx | Acinonyx jubatus | |
| 30797008 | 30797008 | PRJNA1137393_P_NODE_58094_length_165_cov_0.896552_g57578_i0 | PRJNA1137393 | 58094 | 165 | 0.896552 | 1.4793108 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 42 | 0.01 | NR | KAF6495744.1 | 9407 | g57578 | i0 | 55.6 | 0.818181818181818 | 45 | 18 | 78.2 | 1 | 30 | 158 | 53 | 97 | KAF6495744.1 hypothetical protein HJG63_010133 [Rousettus aegyptiacus] | diamond | 135 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 30860297 | 30860297 | PRJNA1137393_P_NODE_36574_length_172_cov_1.560976_g36058_i0 | PRJNA1137393 | 36574 | 172 | 1.560976 | 2.68487872 | Pleurodeles waltl | 8319 | Chordata | Chordata | 72.4 | 5.03e-13 | NR | KAJ1196035.1 | 8319 | g36058 | i0 | 64.4 | 1.7093023255814 | 45 | 16 | 78.5 | 0 | 37 | 171 | 608 | 652 | KAJ1196035.1 hypothetical protein NDU88_005295 [Pleurodeles waltl] | diamond | 294 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 31207351 | 31207351 | PRJNA1137393_P_NODE_28675_length_184_cov_0.711111_g28159_i0 | PRJNA1137393 | 28675 | 184 | 0.711111 | 1.30844424 | Ranitomeya imitator | 111125 | Chordata | Chordata | 53.1 | 3.65e-6 | NR | CAJ0920470.1 | 111125 | g28159 | i0 | 63.2 | 1.23913043478261 | 38 | 14 | 62 | 0 | 2 | 115 | 709 | 746 | CAJ0920470.1 unnamed protein product [Ranitomeya imitator] | diamond | 228 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 31618985 | 31618985 | PRJNA1137393_P_NODE_72876_length_162_cov_0.920354_g72360_i0 | PRJNA1137393 | 72876 | 162 | 0.920354 | 1.49097348 | Vulpes vulpes | 9627 | Chordata | Chordata | 42 | 0.0232 | NR | XP_025856236.1 | 9627 | g72360 | i0 | 69.6 | 0.425925925925926 | 23 | 7 | 42.6 | 0 | 125 | 57 | 137 | 159 | XP_025856236.1 LOW QUALITY PROTEIN: uncharacterized protein LOC112921192 [Vulpes vulpes] | diamond | 69 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Vulpes | Vulpes vulpes | |
| 32462373 | 32462373 | PRJNA1137393_P_NODE_74019_length_160_cov_2.315315_g73503_i0 | PRJNA1137393 | 74019 | 160 | 2.315315 | 3.704504 | Chondrichthyes | 7777 | Chordata | Chordata | 43.9 | 0.00424 | NR | XP_039359890.1 | 260615 | g73503 | i0 | 56.8 | 4.48125 | 37 | 15 | 69.4 | 1 | 49 | 159 | 141 | 176 | XP_039359890.1 mth938 domain-containing protein isoform X2 [Mauremys reevesii] | diamond | 717 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Geoemydidae | Mauremys | Mauremys reevesii | ||
| 32662380 | 32662380 | PRJNA1137393_P_NODE_11940_length_242_cov_1.170984_g11424_i0 | PRJNA1137393 | 11940 | 242 | 1.170984 | 2.83378128 | Engystomops pustulosus | 76066 | Chordata | Chordata | 51.6 | 2.8e-5 | NR | KAG8571490.1 | 76066 | g11424 | i0 | 62.2 | 9.17355371900826 | 37 | 14 | 45.9 | 0 | 114 | 4 | 982 | 1018 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 2220 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32662383 | 32662383 | PRJNA1137393_P_NODE_47620_length_167_cov_1.398305_g47104_i0 | PRJNA1137393 | 47620 | 167 | 1.398305 | 2.33516935 | Orycteropus afer afer | 1230840 | Chordata | Chordata | 41.2 | 0.0469 | NR | XP_007954483.1 | 1230840 | g47104 | i0 | 45.1 | 0.916167664670659 | 51 | 22 | 84.4 | 2 | 27 | 167 | 7 | 55 | XP_007954483.1 ribonuclease P protein subunit p30 [Orycteropus afer afer] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tubulidentata | Orycteropodidae | Orycteropus | Orycteropus afer | |
| 32662396 | 32662396 | PRJNA1137393_P_NODE_75200_length_152_cov_2.563107_g74684_i0 | PRJNA1137393 | 75200 | 152 | 2.563107 | 3.89592264 | Myotis brandtii | 109478 | Chordata | Chordata | 49.3 | 5.2e-5 | NR | EPQ05981.1 | 109478 | g74684 | i0 | 96.2 | 0.513157894736842 | 26 | 1 | 51.3 | 0 | 81 | 4 | 53 | 78 | EPQ05981.1 Signal transduction protein CBL-C [Myotis brandtii] | diamond | 78 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis brandtii |
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);;