contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA633835" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26637684 | 26637684 | PRJNA633835_S_NODE_7361_length_275_cov_0.980198_g7293_i0 | PRJNA633835 | 7361 | 275 | 0.980198 | 2.6955445 | Polypterus senegalus | 55291 | Chordata | Chordata | 107 | 1.02e-24 | NR | MBN3294582.1 | 55291 | g7293 | i0 | 60.2 | 0.96 | 88 | 35 | 96 | 0 | 265 | 2 | 843 | 930 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 264 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 26669137 | 26669137 | PRJNA633835_S_NODE_9021_length_257_cov_1.086957_g8953_i0 | PRJNA633835 | 9021 | 257 | 1.086957 | 2.79347949 | Ranitomeya imitator | 111125 | Chordata | Chordata | 65.1 | 6.16e-10 | NR | CAJ0919964.1 | 111125 | g8953 | i0 | 66.7 | 4.62256809338521 | 45 | 15 | 52.5 | 0 | 257 | 123 | 141 | 185 | CAJ0919964.1 unnamed protein product [Ranitomeya imitator] | diamond | 1188 | 65.5 | 0.993893129770992 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 26732364 | 26732364 | PRJNA633835_S_NODE_261_length_837_cov_40.697644_g201_i0 | PRJNA633835 | 261 | 837 | 40.697644 | 340.63928028 | Polypterus senegalus | 55291 | Chordata | Chordata | 263 | 9.56e-77 | NR | MBN3294582.1 | 55291 | g201 | i0 | 85.1 | 0.530465949820789 | 148 | 22 | 53 | 0 | 391 | 834 | 595 | 742 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 444 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27207090 | 27207090 | PRJNA633835_S_NODE_10622_length_247_cov_1.178161_g10554_i0 | PRJNA633835 | 10622 | 247 | 1.178161 | 2.91005767 | Staurois parvus | 386267 | Chordata | Chordata | 42.4 | 0.00595 | NR | CAI9548781.1 | 386267 | g10554 | i0 | 63.6 | 0.947368421052632 | 33 | 12 | 40.1 | 0 | 247 | 149 | 13 | 45 | CAI9548781.1 unnamed protein product [Staurois parvus] | diamond | 234 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27283180 | 27283180 | PRJNA633835_S_NODE_10623_length_247_cov_1.149425_g10555_i0 | PRJNA633835 | 10623 | 247 | 1.149425 | 2.83907975 | Lepidosauria | 8504 | Chordata | Chordata | 50.4 | 7.41e-5 | NR | XP_005989425.1 | 7897 | g10555 | i0 | 76.7 | 50.2226720647773 | 30 | 7 | 36.4 | 0 | 92 | 3 | 667 | 696 | XP_005989425.1 dynamin-like 120 kDa protein, mitochondrial isoform X1 [Latimeria chalumnae] | diamond | 12405 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 27428801 | 27428801 | PRJNA633835_S_NODE_12463_length_230_cov_2.076433_g12395_i0 | PRJNA633835 | 12463 | 230 | 2.076433 | 4.7757959 | Crotalus adamanteus | 8729 | Chordata | Chordata | 97.8 | 1.3e-21 | NR | KAK9391398.1 | 8729 | g12395 | i0 | 63.2 | 1.77391304347826 | 68 | 25 | 88.7 | 0 | 228 | 25 | 347 | 414 | KAK9391398.1 hypothetical protein NXF25_017787 [Crotalus adamanteus] | diamond | 408 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 27807674 | 27807674 | PRJNA633835_S_NODE_144_length_1049_cov_13.812500_g84_i1 | PRJNA633835 | 144 | 1049 | 13.8125 | 144.893125 | Polypterus senegalus | 55291 | Chordata | Chordata | 232 | 2.15e-64 | NR | MBN3294582.1 | 55291 | g84 | i1 | 71.3 | 0.469018112488084 | 164 | 44 | 46.9 | 1 | 553 | 1044 | 439 | 599 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 492 | 232 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28249295 | 28249295 | PRJNA633835_S_NODE_7966_length_268_cov_1.035897_g7898_i0 | PRJNA633835 | 7966 | 268 | 1.035897 | 2.77620396 | Polypterus senegalus | 55291 | Chordata | Chordata | 83.2 | 1.42e-16 | NR | KAG2463908.1 | 55291 | g7898 | i0 | 79.2 | 0.593283582089552 | 53 | 10 | 59.3 | 1 | 96 | 254 | 16 | 67 | KAG2463908.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 159 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28565215 | 28565215 | PRJNA633835_S_NODE_9327_length_254_cov_0.917127_g9259_i0 | PRJNA633835 | 9327 | 254 | 0.917127 | 2.32950258 | Myxine glutinosa | 7769 | Chordata | Chordata | 65.1 | 5.74e-10 | NR | XP_067960236.1 | 7769 | g9259 | i0 | 71.4 | 2.64566929133858 | 56 | 13 | 65 | 2 | 86 | 250 | 113 | 166 | XP_067960236.1 uncharacterized protein [Myxine glutinosa] | diamond | 672 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 29322886 | 29322886 | PRJNA633835_S_NODE_8829_length_259_cov_1.043011_g8761_i0 | PRJNA633835 | 8829 | 259 | 1.043011 | 2.70139849 | Pseudophryne corroboree | 495146 | Chordata | Chordata | 56.6 | 5.67e-7 | NR | XP_063806728.1 | 495146 | g8761 | i0 | 37.3 | 2.62934362934363 | 59 | 37 | 68.3 | 0 | 7 | 183 | 91 | 149 | XP_063806728.1 uncharacterized protein LOC134990161 [Pseudophryne corroboree] | diamond | 681 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Myobatrachidae | Pseudophryne | Pseudophryne corroboree | |
| 29480542 | 29480542 | PRJNA633835_S_NODE_10210_length_249_cov_0.875000_g10142_i0 | PRJNA633835 | 10210 | 249 | 0.875 | 2.17875 | Somniosus microcephalus | 191813 | Chordata | Chordata | 123 | 1.5e-30 | NR | WPH61295.1 | 191813 | g10142 | i0 | 70.7 | 3.95180722891566 | 82 | 24 | 98.8 | 0 | 2 | 247 | 680 | 761 | WPH61295.1 reverse transcriptase [Somniosus microcephalus] | diamond | 984 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Squaliformes | Somniosidae | Somniosus | Somniosus microcephalus | |
| 29543877 | 29543877 | PRJNA633835_S_NODE_10270_length_249_cov_0.875000_g10202_i0 | PRJNA633835 | 10270 | 249 | 0.875 | 2.17875 | Ranitomeya imitator | 111125 | Chordata | Chordata | 79.3 | 5.41e-15 | NR | CAJ0932021.1 | 111125 | g10202 | i0 | 59.4 | 0.771084337349398 | 64 | 22 | 72.3 | 1 | 249 | 70 | 42 | 105 | CAJ0932021.1 unnamed protein product [Ranitomeya imitator] | diamond | 192 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29764870 | 29764870 | PRJNA633835_S_NODE_131_length_1090_cov_14.150442_g84_i0 | PRJNA633835 | 131 | 1090 | 14.150442 | 154.2398178 | Polypterus senegalus | 55291 | Chordata | Chordata | 232 | 3.25e-64 | NR | MBN3294582.1 | 55291 | g84 | i0 | 71.3 | 0.451376146788991 | 164 | 44 | 45.1 | 1 | 497 | 6 | 439 | 599 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 492 | 232 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30460478 | 30460478 | PRJNA633835_S_NODE_213_length_902_cov_15.281062_g84_i3 | PRJNA633835 | 213 | 902 | 15.281062 | 137.83517924 | Polypterus senegalus | 55291 | Chordata | Chordata | 232 | 4.2300000000000004e-65 | NR | MBN3294582.1 | 55291 | g84 | i3 | 71.3 | 0.545454545454545 | 164 | 44 | 54.5 | 1 | 255 | 746 | 439 | 599 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 492 | 232 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30839193 | 30839193 | PRJNA633835_S_NODE_11574_length_243_cov_0.929412_g11506_i0 | PRJNA633835 | 11574 | 243 | 0.929412 | 2.25847116 | Protopterus annectens | 7888 | Chordata | Chordata | 90.9 | 4.24e-19 | NR | XP_043916150.1 | 7888 | g11506 | i0 | 81.1 | 5.88888888888889 | 53 | 10 | 65.4 | 0 | 161 | 3 | 616 | 668 | XP_043916150.1 LOW QUALITY PROTEIN: uncharacterized protein K02A2.6-like [Protopterus annectens] | diamond | 1431 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 31294111 | 31294111 | PRJNA633835_S_NODE_10495_length_248_cov_0.874286_g10427_i0 | PRJNA633835 | 10495 | 248 | 0.874286 | 2.16822928 | Anura | 8342 | Chordata | Chordata | 124 | 5.79e-31 | NR | CAJ0964630.1 | 111125 | g10427 | i0 | 87.1 | 5.25 | 62 | 8 | 75 | 0 | 63 | 248 | 444 | 505 | CAJ0964630.1 unnamed protein product [Ranitomeya imitator] | diamond | 1302 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 31471565 | 31471565 | PRJNA633835_S_NODE_8796_length_259_cov_1.349462_g8728_i0 | PRJNA633835 | 8796 | 259 | 1.349462 | 3.49510658 | Polypterus senegalus | 55291 | Chordata | Chordata | 115 | 8.89e-28 | NR | MBN3294582.1 | 55291 | g8728 | i0 | 76.1 | 0.776061776061776 | 67 | 16 | 77.6 | 0 | 202 | 2 | 920 | 986 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 201 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31566538 | 31566538 | PRJNA633835_S_NODE_3276_length_353_cov_1.685714_g3208_i0 | PRJNA633835 | 3276 | 353 | 1.685714 | 5.95057042 | Ranitomeya imitator | 111125 | Chordata | Chordata | 76.6 | 1.77e-13 | NR | CAJ0965884.1 | 111125 | g3208 | i0 | 92.5 | 0.339943342776204 | 40 | 3 | 34 | 0 | 179 | 298 | 10 | 49 | CAJ0965884.1 unnamed protein product [Ranitomeya imitator] | diamond | 120 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 31598138 | 31598138 | PRJNA633835_S_NODE_9236_length_255_cov_0.978022_g9168_i0 | PRJNA633835 | 9236 | 255 | 0.978022 | 2.4939561 | Polypterus senegalus | 55291 | Chordata | Chordata | 68.2 | 4.81e-11 | NR | KAG2456690.1 | 55291 | g9168 | i0 | 86.1 | 1.70588235294118 | 36 | 5 | 42.4 | 0 | 19 | 126 | 471 | 506 | KAG2456690.1 AL5AP protein, partial [Polypterus senegalus] | diamond | 435 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31850859 | 31850859 | PRJNA633835_S_NODE_157_length_1019_cov_13.329810_g84_i2 | PRJNA633835 | 157 | 1019 | 13.32981 | 135.8307639 | Polypterus senegalus | 55291 | Chordata | Chordata | 233 | 8.28e-65 | NR | MBN3294582.1 | 55291 | g84 | i2 | 71.3 | 0.482826300294406 | 164 | 44 | 48.3 | 1 | 255 | 746 | 439 | 599 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 492 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31945684 | 31945684 | PRJNA633835_S_NODE_6377_length_288_cov_0.869767_g6309_i0 | PRJNA633835 | 6377 | 288 | 0.869767 | 2.50492896 | Polypterus senegalus | 55291 | Chordata | Chordata | 158 | 1.4199999999999999e-42 | NR | MBN3294582.1 | 55291 | g6309 | i0 | 84.6 | 0.947916666666667 | 91 | 14 | 94.8 | 0 | 16 | 288 | 758 | 848 | MBN3294582.1 LORF2 protein [Polypterus senegalus] | diamond | 273 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32325935 | 32325935 | PRJNA633835_S_NODE_5159_length_307_cov_1.094017_g5091_i0 | PRJNA633835 | 5159 | 307 | 1.094017 | 3.35863219 | Polypterus senegalus | 55291 | Chordata | Chordata | 74.3 | 5.91e-13 | NR | XP_039591329.1 | 55291 | g5091 | i0 | 78.3 | 4.76872964169381 | 46 | 10 | 45 | 0 | 31 | 168 | 383 | 428 | XP_039591329.1 zinc finger BED domain-containing protein 4-like isoform X2 [Polypterus senegalus] | diamond | 1464 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32578809 | 32578809 | PRJNA633835_S_NODE_10139_length_249_cov_1.119318_g10071_i0 | PRJNA633835 | 10139 | 249 | 1.119318 | 2.78710182 | Rana temporaria | 8407 | Chordata | Chordata | 47.4 | 9.63e-4 | NR | XP_040207327.1 | 8407 | g10071 | i0 | 95 | 0.240963855421687 | 20 | 1 | 24.1 | 0 | 190 | 249 | 379 | 398 | XP_040207327.1 calpain-2 catalytic subunit-like [Rana temporaria] | diamond | 60 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 32893350 | 32893350 | PRJNA633835_S_NODE_12100_length_241_cov_0.916667_g12032_i0 | PRJNA633835 | 12100 | 241 | 0.916667 | 2.20916747 | Staurois parvus | 386267 | Chordata | Chordata | 76.6 | 2.23e-16 | NR | CAI9561898.1 | 386267 | g12032 | i0 | 55.7 | 0.871369294605809 | 70 | 31 | 87.1 | 0 | 22 | 231 | 3 | 72 | CAI9561898.1 unnamed protein product [Staurois parvus] | diamond | 210 | 76.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);;