contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26599043 | 26599043 | PRJNA293022_P_NODE_1_length_9527_cov_9212.645495_g0_i0 | PRJNA293022 | 1 | 9527 | 9212.645495 | 877688.73630865 | Carcharodon carcharias | 13397 | Chordata | Chordata | 1097 | 0 | NR | XP_041058168.1 | 13397 | g0 | i0 | 66.2 | 0.240579405899024 | 764 | 254 | 24.1 | 2 | 3179 | 5470 | 2 | 761 | XP_041058168.1 uncharacterized protein LOC121285616 [Carcharodon carcharias] | diamond | 2292 | 1097 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Lamniformes | Alopiidae | Carcharodon | Carcharodon carcharias | |
| 27060207 | 27060207 | PRJNA293022_P_NODE_71122_length_167_cov_0.881356_g70385_i0 | PRJNA293022 | 71122 | 167 | 0.881356 | 1.47186452 | Opisthokonta | 33154 | Chordata | Chordata | 82.8 | 9.76e-17 | NR | NP_001006536.1 | 9031 | g70385 | i0 | 65.5 | 6.89820359281437 | 55 | 19 | 98.8 | 0 | 3 | 167 | 192 | 246 | NP_001006536.1 cell division cycle protein 20 homolog [Gallus gallus] | diamond | 1152 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 27105619 | 27105619 | PRJNA293022_P_NODE_2_length_9439_cov_9252.072204_g0_i1 | PRJNA293022 | 2 | 9439 | 9252.072204 | 873303.09533556 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 1147 | 0 | NR | XP_051788188.1 | 27687 | g0 | i1 | 60.9 | 0.57209450153618 | 892 | 343 | 28.3 | 5 | 3450 | 6119 | 2 | 889 | XP_051788188.1 uncharacterized protein LOC127529223 [Erpetoichthys calabaricus] | diamond | 5400 | 1147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27263970 | 27263970 | PRJNA293022_P_NODE_3_length_9310_cov_9325.310334_g0_i2 | PRJNA293022 | 3 | 9310 | 9325.310334 | 868186.3920954 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 1147 | 0 | NR | XP_051788188.1 | 27687 | g0 | i2 | 60.9 | 0.57937701396348 | 892 | 343 | 28.7 | 5 | 3321 | 5990 | 2 | 889 | XP_051788188.1 uncharacterized protein LOC127529223 [Erpetoichthys calabaricus] | diamond | 5394 | 1147 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27548086 | 27548086 | PRJNA293022_P_NODE_63004_length_175_cov_1.055556_g62267_i0 | PRJNA293022 | 63004 | 175 | 1.055556 | 1.847223 | Staurois parvus | 386267 | Chordata | Chordata | 45.4 | 1.19e-4 | NR | CAI9619281.1 | 386267 | g62267 | i0 | 69.2 | 0.445714285714286 | 26 | 8 | 44.6 | 0 | 80 | 3 | 20 | 45 | CAI9619281.1 unnamed protein product [Staurois parvus] | diamond | 78 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27927033 | 27927033 | PRJNA293022_P_NODE_29065_length_261_cov_1.193396_g28328_i0 | PRJNA293022 | 29065 | 261 | 1.193396 | 3.11476356 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 9.72e-7 | NR | CAI9557087.1 | 386267 | g28328 | i0 | 63.9 | 0.827586206896552 | 36 | 11 | 39.1 | 1 | 178 | 77 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28242599 | 28242599 | PRJNA293022_P_NODE_52726_length_192_cov_1.174825_g51989_i0 | PRJNA293022 | 52726 | 192 | 1.174825 | 2.255664 | Staurois parvus | 386267 | Chordata | Chordata | 47 | 4.08e-5 | NR | CAI9622145.1 | 386267 | g51989 | i0 | 68.6 | 0.546875 | 35 | 11 | 54.7 | 0 | 1 | 105 | 15 | 49 | CAI9622145.1 unnamed protein product [Staurois parvus] | diamond | 105 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28242604 | 28242604 | PRJNA293022_P_NODE_70886_length_167_cov_0.881356_g70149_i0 | PRJNA293022 | 70886 | 167 | 0.881356 | 1.47186452 | Scyliorhinus torazame | 75743 | Chordata | Chordata | 51.2 | 5.06e-6 | NR | GCB79319.1 | 75743 | g70149 | i0 | 55.8 | 28.0059880239521 | 52 | 23 | 93.4 | 0 | 161 | 6 | 100 | 151 | GCB79319.1 hypothetical protein [Scyliorhinus torazame] | diamond | 4677 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus torazame | |
| 28368982 | 28368982 | PRJNA293022_P_NODE_9406_length_467_cov_1.964115_g8675_i0 | PRJNA293022 | 9406 | 467 | 1.964115 | 9.17241705 | Balaenoptera physalus | 9770 | Chordata | Chordata | 49.7 | 2.24e-4 | NR | KAB0401909.1 | 9770 | g8675 | i0 | 37.6 | 0.597430406852248 | 93 | 53 | 57.8 | 3 | 311 | 42 | 13 | 103 | KAB0401909.1 hypothetical protein E2I00_017869, partial [Balaenoptera physalus] | diamond | 279 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 28432255 | 28432255 | PRJNA293022_P_NODE_6_length_7472_cov_9431.905564_g0_i4 | PRJNA293022 | 6 | 7472 | 9431.905564 | 704751.98374208 | Carcharodon carcharias | 13397 | Chordata | Chordata | 798 | 3.7e-259 | NR | XP_041058168.1 | 13397 | g0 | i4 | 68.4 | 0.217210920770878 | 541 | 168 | 21.7 | 2 | 3134 | 4756 | 2 | 539 | XP_041058168.1 uncharacterized protein LOC121285616 [Carcharodon carcharias] | diamond | 1623 | 798 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Lamniformes | Alopiidae | Carcharodon | Carcharodon carcharias | |
| 28590258 | 28590258 | PRJNA293022_P_NODE_77707_length_163_cov_0.912281_g76970_i0 | PRJNA293022 | 77707 | 163 | 0.912281 | 1.48701803 | Mobula hypostoma | 723540 | Chordata | Chordata | 48.5 | 1.16e-4 | NR | XP_062916020.1 | 723540 | g76970 | i0 | 56.8 | 0.680981595092024 | 37 | 16 | 68.1 | 0 | 135 | 25 | 518 | 554 | XP_062916020.1 nesprin-2 isoform X2 [Mobula hypostoma] | diamond | 111 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Myliobatidae | Mobula | Mobula hypostoma | |
| 28937495 | 28937495 | PRJNA293022_P_NODE_68_length_2640_cov_10794.695484_g0_i6 | PRJNA293022 | 68 | 2640 | 10794.695484 | 284979.9607776 | Carcharodon carcharias | 13397 | Chordata | Chordata | 425 | 2.769999999999999e-134 | NR | XP_041053337.1 | 13397 | g0 | i6 | 45.3 | 3.17840909090909 | 457 | 248 | 51.7 | 1 | 89 | 1453 | 175 | 631 | XP_041053337.1 uncharacterized protein LOC121283180 [Carcharodon carcharias] | diamond | 8391 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Lamniformes | Alopiidae | Carcharodon | Carcharodon carcharias | |
| 28969061 | 28969061 | PRJNA293022_P_NODE_28208_length_265_cov_1.620370_g27471_i0 | PRJNA293022 | 28208 | 265 | 1.62037 | 4.2939805 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 45.1 | 0.00592 | NR | XP_055493306.1 | 7782 | g27471 | i0 | 75 | 1.14339622641509 | 28 | 7 | 31.7 | 0 | 91 | 174 | 138 | 165 | XP_055493306.1 uncharacterized protein LOC129698280 [Leucoraja erinaceus] | diamond | 303 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 29190131 | 29190131 | PRJNA293022_P_NODE_10289_length_446_cov_2.289673_g9554_i0 | PRJNA293022 | 10289 | 446 | 2.289673 | 10.21194158 | Ranitomeya imitator | 111125 | Chordata | Chordata | 63.5 | 1.81e-8 | NR | CAJ0933392.1 | 111125 | g9554 | i0 | 62.5 | 0.322869955156951 | 48 | 16 | 30.9 | 1 | 173 | 310 | 53 | 100 | CAJ0933392.1 unnamed protein product [Ranitomeya imitator] | diamond | 144 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29347934 | 29347934 | PRJNA293022_P_NODE_55049_length_188_cov_0.870504_g54312_i0 | PRJNA293022 | 55049 | 188 | 0.87050399999999994 | 1.63654752 | Polypterus senegalus | 55291 | Chordata | Chordata | 62.8 | 1.35e-9 | NR | KAG2463681.1 | 55291 | g54312 | i0 | 61 | 0.941489361702128 | 59 | 23 | 94.1 | 0 | 7 | 183 | 147 | 205 | KAG2463681.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 177 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29505623 | 29505623 | PRJNA293022_P_NODE_25830_length_277_cov_12.276316_g25093_i0 | PRJNA293022 | 25830 | 277 | 12.276316 | 34.00539532 | Naja naja | 35670 | Chordata | Chordata | 42.4 | 0.0196 | NR | KAG8138624.1 | 35670 | g25093 | i0 | 59.1 | 0.23826714801444 | 22 | 9 | 23.8 | 0 | 69 | 4 | 43 | 64 | KAG8138624.1 hypothetical protein E2320_001439 [Naja naja] | diamond | 66 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 29631731 | 29631731 | PRJNA293022_P_NODE_74310_length_165_cov_0.896552_g73573_i0 | PRJNA293022 | 74310 | 165 | 0.896552 | 1.4793108 | Ranitomeya imitator | 111125 | Chordata | Chordata | 43.9 | 0.00504 | NR | CAJ0952439.1 | 111125 | g73573 | i0 | 48.9 | 0.818181818181818 | 45 | 23 | 81.8 | 0 | 30 | 164 | 668 | 712 | CAJ0952439.1 unnamed protein product [Ranitomeya imitator] | diamond | 135 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29853135 | 29853135 | PRJNA293022_P_NODE_71031_length_167_cov_0.881356_g70294_i0 | PRJNA293022 | 71031 | 167 | 0.881356 | 1.47186452 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 45.4 | 0.00148 | NR | XP_028656942.1 | 27687 | g70294 | i0 | 82.6 | 0.413173652694611 | 23 | 4 | 41.3 | 0 | 73 | 5 | 100 | 122 | XP_028656942.1 protein ZBED8-like [Erpetoichthys calabaricus] | diamond | 69 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 30074049 | 30074049 | PRJNA293022_P_NODE_45492_length_207_cov_1.202532_g44755_i0 | PRJNA293022 | 45492 | 207 | 1.202532 | 2.48924124 | Polypterus senegalus | 55291 | Chordata | Chordata | 43.5 | 0.0124 | NR | KAG2463379.1 | 55291 | g44755 | i0 | 64.5 | 5.97101449275362 | 31 | 11 | 44.9 | 0 | 4 | 96 | 313 | 343 | KAG2463379.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 1236 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30692044 | 30692044 | PRJNA293022_P_NODE_72553_length_166_cov_0.888889_g71816_i0 | PRJNA293022 | 72553 | 166 | 0.888889 | 1.47555574 | Chordata | 7711 | Chordata | Chordata | 69.3 | 5.54e-12 | NR | XP_043830454.1 | 33562 | g71816 | i0 | 60.4 | 23.5843373493976 | 48 | 19 | 86.7 | 0 | 160 | 17 | 26 | 73 | XP_043830454.1 heat shock factor protein 3-like isoform X2 [Dromiciops gliroides] | diamond | 3915 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Microbiotheria | Microbiotheriidae | Dromiciops | Dromiciops gliroides | |
| 31102714 | 31102714 | PRJNA293022_P_NODE_77215_length_163_cov_0.912281_g76478_i0 | PRJNA293022 | 77215 | 163 | 0.912281 | 1.48701803 | Aves | 8782 | Chordata | Chordata | 42.4 | 0.0139 | NR | XP_055674138.1 | 8954 | g76478 | i0 | 47.2 | 3.92024539877301 | 36 | 19 | 66.3 | 0 | 159 | 52 | 46 | 81 | XP_055674138.1 vitelline membrane outer layer protein 1 homolog [Falco peregrinus] | diamond | 639 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Falconiformes | Falconidae | Falco | Falco peregrinus | |
| 31496505 | 31496505 | PRJNA293022_P_NODE_23916_length_289_cov_2.133333_g23179_i0 | PRJNA293022 | 23916 | 289 | 2.133333 | 6.16533237 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 50.8 | 7.96e-5 | NR | XP_055487001.1 | 7782 | g23179 | i0 | 54.4 | 1.79584775086505 | 57 | 23 | 57.1 | 2 | 7 | 171 | 160 | 215 | XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus] | diamond | 519 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 31875715 | 31875715 | PRJNA293022_P_NODE_33537_length_241_cov_4.598958_g32800_i0 | PRJNA293022 | 33537 | 241 | 4.598958 | 11.08348878 | Varanus komodoensis | 61221 | Chordata | Chordata | 82 | 1.21e-16 | NR | KAF7248073.1 | 61221 | g32800 | i0 | 64.5 | 0.771784232365145 | 62 | 21 | 75.9 | 1 | 1 | 183 | 77 | 138 | KAF7248073.1 Neuronal vesicle trafficking-associated protein 1 [Varanus komodoensis] | diamond | 186 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 31939005 | 31939005 | PRJNA293022_P_NODE_55117_length_187_cov_4.695652_g54380_i0 | PRJNA293022 | 55117 | 187 | 4.695652 | 8.78086924 | Myxine glutinosa | 7769 | Chordata | Chordata | 47 | 5.75e-4 | NR | XP_067964253.1 | 7769 | g54380 | i0 | 51.9 | 0.834224598930481 | 52 | 16 | 69 | 1 | 8 | 136 | 699 | 750 | XP_067964253.1 solute carrier family 45 member 4-like isoform X2 [Myxine glutinosa] | diamond | 156 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 31939011 | 31939011 | PRJNA293022_P_NODE_9137_length_473_cov_4.740566_g8406_i0 | PRJNA293022 | 9137 | 473 | 4.740566 | 22.42287718 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 62.8 | 2.6e-8 | NR | XP_055487001.1 | 7782 | g8406 | i0 | 58.2 | 0.348837209302326 | 55 | 22 | 34.2 | 1 | 471 | 310 | 159 | 213 | XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus] | diamond | 165 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 32666343 | 32666343 | PRJNA293022_P_NODE_38000_length_226_cov_4.638418_g37263_i0 | PRJNA293022 | 38000 | 226 | 4.638418 | 10.48282468 | Ranitomeya imitator | 111125 | Chordata | Chordata | 69.3 | 1.21e-11 | NR | CAJ0927840.1 | 111125 | g37263 | i0 | 72.5 | 0.530973451327434 | 40 | 11 | 53.1 | 0 | 205 | 86 | 119 | 158 | CAJ0927840.1 unnamed protein product [Ranitomeya imitator] | diamond | 120 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 32666347 | 32666347 | PRJNA293022_P_NODE_57880_length_183_cov_1.253731_g57143_i0 | PRJNA293022 | 57880 | 183 | 1.253731 | 2.29432773 | Bufotes viridis | 30338 | Chordata | Chordata | 45.1 | 0.00249 | NR | CAK8629749.1 | 30338 | g57143 | i0 | 52.9 | 0.557377049180328 | 34 | 16 | 55.7 | 0 | 176 | 75 | 331 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 102 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 32778241 | 32778241 | PRJNA293022_P_NODE_72580_length_166_cov_0.888889_g71843_i0 | PRJNA293022 | 72580 | 166 | 0.888889 | 1.47555574 | Metazoa | 33208 | Chordata | Chordata | 42.4 | 0.0187 | NR | KAI8506615.1 | 7741 | g71843 | i0 | 46.5 | 3.23493975903614 | 43 | 23 | 77.7 | 0 | 16 | 144 | 1448 | 1490 | KAI8506615.1 hypothetical protein Bbelb_160420 [Branchiostoma belcheri] | diamond | 537 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri |
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);;