contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1561928 | 1561928 | PRJNA1144090_P_NODE_4222_length_1374_cov_5.331284_g3961_i0 | PRJNA1144090 | 4222 | 1374 | 5.331284 | 73.25184216 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 455 | 1.5699999999999997e-155 | NR | AAY34140.1 | 5778 | g3961 | i0 | 64.8 | 4.22707423580786 | 369 | 125 | 79.7 | 3 | 1360 | 266 | 1 | 368 | AAY34140.1 Nop58p, partial [Vermamoeba vermiformis] | diamond | 5808 | 455 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1561962 | 1561962 | PRJNA1144090_P_NODE_46002_length_377_cov_3.108553_g45467_i0 | PRJNA1144090 | 46002 | 377 | 3.108553 | 11.71924481 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 87 | 1.23e-17 | NR | BAF75060.1 | 5775 | g45467 | i0 | 38.9 | 0.89920424403183 | 113 | 46 | 89.9 | 1 | 37 | 375 | 5 | 94 | BAF75060.1 aquaporin [Amoeba proteus] | diamond | 339 | 87 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 2838485 | 2838485 | PRJNA1144090_P_NODE_75083_length_291_cov_2.756881_g74548_i0 | PRJNA1144090 | 75083 | 291 | 2.756881 | 8.02252371 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 115 | 4.24e-29 | NR | BAF75060.1 | 5775 | g74548 | i0 | 55.8 | 0.979381443298969 | 95 | 42 | 97.9 | 0 | 1 | 285 | 85 | 179 | BAF75060.1 aquaporin [Amoeba proteus] | diamond | 285 | 115 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 5390049 | 5390049 | PRJNA1144090_P_NODE_106605_length_246_cov_3.763006_g106070_i0 | PRJNA1144090 | 106605 | 246 | 3.763006 | 9.25699476 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 145 | 1.62e-39 | NR | BAN33737.1 | 931554 | g106070 | i0 | 90 | 0.975609756097561 | 80 | 8 | 97.6 | 0 | 6 | 245 | 384 | 463 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 240 | 145 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5390643 | 5390643 | PRJNA1144090_P_NODE_55265_length_342_cov_1.698885_g54730_i0 | PRJNA1144090 | 55265 | 342 | 1.698885 | 5.8101867 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 88.2 | 6.47e-20 | NR | AAX99356.1 | 5778 | g54730 | i0 | 46.4 | 0.736842105263158 | 84 | 45 | 73.7 | 0 | 321 | 70 | 4 | 87 | AAX99356.1 guanine deaminase-like protein, partial [Vermamoeba vermiformis] | diamond | 252 | 88.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9215507 | 9215507 | PRJNA1144090_P_NODE_5468_length_1222_cov_32.539600_g5167_i0 | PRJNA1144090 | 5468 | 1222 | 32.5396 | 397.633912 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 630 | 5.099999999999998e-225 | NR | AAP88974.1 | 5775 | g5167 | i0 | 78.5 | 0.957446808510638 | 390 | 82 | 95.7 | 1 | 1221 | 52 | 1 | 388 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1170 | 630 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 11765835 | 11765835 | PRJNA1144090_P_NODE_2990_length_1592_cov_101.592495_g2792_i0 | PRJNA1144090 | 2990 | 1592 | 101.592495 | 1617.3525204 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 771 | 1.7e-277 | NR | BAN33737.1 | 931554 | g2792 | i0 | 81.7 | 3.46356783919598 | 464 | 79 | 86.3 | 1 | 22 | 1395 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5514 | 771 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 15590109 | 15590109 | PRJNA1144090_P_NODE_33_length_5632_cov_7.663249_g25_i0 | PRJNA1144090 | 33 | 5632 | 7.663249 | 431.59418368 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 609 | 1.1799999999999999e-179 | NR | AAD33718.1 | 5775 | g25 | i0 | 51.8 | 0.347301136363636 | 652 | 272 | 34 | 13 | 2 | 1918 | 295 | 917 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 1956 | 609 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 16335408 | 16335408 | PRJNA1144090_P_NODE_16013_length_690_cov_3.298217_g15509_i0 | PRJNA1144090 | 16013 | 690 | 3.298217 | 22.7576973 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 287 | 2.52e-85 | NR | AAD33718.1 | 5775 | g15509 | i0 | 65.5 | 1.03478260869565 | 238 | 72 | 100 | 6 | 1 | 690 | 67 | 302 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 714 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 18139195 | 18139195 | PRJNA1144090_P_NODE_53915_length_346_cov_4.402930_g53380_i0 | PRJNA1144090 | 53915 | 346 | 4.40293 | 15.2341378 | Nolandella sp. ATCC 5 | 1908693 | Tubulinea | other_Eukaryota | 171 | 4.77e-50 | NR | ACA04827.1 | 498005 | g53380 | i0 | 71.1 | 7.82947976878613 | 114 | 33 | 98.8 | 0 | 3 | 344 | 92 | 205 | ACA04827.1 beta-tubulin, partial [Nolandella sp. ATCC 50913] | diamond | 2709 | 171 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Nolandella | Nolandella sp. ATCC 50913 | ||
| 24513073 | 24513073 | PRJNA1144090_P_NODE_3000_length_1590_cov_113.974291_g2792_i1 | PRJNA1144090 | 3000 | 1590 | 113.974291 | 1812.1912269 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 771 | 1.64e-277 | NR | BAN33737.1 | 931554 | g2792 | i1 | 81.7 | 3.46792452830189 | 464 | 79 | 86.4 | 1 | 1571 | 198 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5514 | 771 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26721816 | 26721816 | PRJNA1144090_P_NODE_103721_length_248_cov_1.731429_g103186_i0 | PRJNA1144090 | 103721 | 248 | 1.731429 | 4.29394392 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 110 | 7.67e-26 | NR | ACA13172.1 | 5778 | g103186 | i0 | 63.4 | 0.991935483870968 | 82 | 30 | 99.2 | 0 | 248 | 3 | 182 | 263 | ACA13172.1 mismatch repair MutS-like protein, partial [Vermamoeba vermiformis] | diamond | 246 | 110 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27418419 | 27418419 | PRJNA1144090_P_NODE_71783_length_298_cov_2.195556_g71248_i0 | PRJNA1144090 | 71783 | 298 | 2.195556 | 6.54275688 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 123 | 4.369999999999999e-31 | NR | AAD37351.1 | 5775 | g71248 | i0 | 75.9 | 0.795302013422819 | 79 | 18 | 79.5 | 1 | 237 | 1 | 86 | 163 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 237 | 123 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27481269 | 27481269 | PRJNA1144090_P_NODE_26383_length_517_cov_3.128378_g25850_i0 | PRJNA1144090 | 26383 | 517 | 3.128378 | 16.17371426 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 207 | 5.8600000000000005e-64 | NR | AKA62191.1 | 931554 | g25850 | i0 | 61.2 | 0.986460348162476 | 170 | 63 | 97.5 | 2 | 1 | 504 | 84 | 252 | AKA62191.1 putative rhodoquinone biosynthesis methyltransferase-like protein RQUA [Copromyxa protea] | diamond | 510 | 207 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28901972 | 28901972 | PRJNA1144090_P_NODE_95728_length_256_cov_1.573770_g95193_i0 | PRJNA1144090 | 95728 | 256 | 1.57377 | 4.0288512 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 83.2 | 2.58e-16 | NR | AKN09694.1 | 5775 | g95193 | i0 | 46.8 | 1.1015625 | 94 | 39 | 98.4 | 3 | 256 | 5 | 343 | 435 | AKN09694.1 Gem1 [Amoeba proteus] | diamond | 282 | 83.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28965470 | 28965470 | PRJNA1144090_P_NODE_89968_length_264_cov_3.581152_g89433_i0 | PRJNA1144090 | 89968 | 264 | 3.581152 | 9.45424128 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 112 | 4.37e-28 | NR | BAF75060.1 | 5775 | g89433 | i0 | 69.7 | 0.863636363636364 | 76 | 23 | 86.4 | 0 | 3 | 230 | 209 | 284 | BAF75060.1 aquaporin [Amoeba proteus] | diamond | 228 | 112 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29344255 | 29344255 | PRJNA1144090_P_NODE_47469_length_371_cov_1.550336_g46934_i0 | PRJNA1144090 | 47469 | 371 | 1.550336 | 5.75174656 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 146 | 1.35e-40 | NR | AKN09689.1 | 5775 | g46934 | i0 | 58.5 | 0.994609164420485 | 123 | 51 | 99.5 | 0 | 369 | 1 | 131 | 253 | AKN09689.1 Tom20 [Amoeba proteus] | diamond | 369 | 146 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29470198 | 29470198 | PRJNA1144090_P_NODE_98070_length_252_cov_2.150838_g97535_i0 | PRJNA1144090 | 98070 | 252 | 2.150838 | 5.42011176 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 79 | 6.51e-15 | NR | AAD37351.1 | 5775 | g97535 | i0 | 78.4 | 1.5952380952381 | 51 | 10 | 60.7 | 1 | 252 | 100 | 161 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 402 | 79 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29659461 | 29659461 | PRJNA1144090_P_NODE_29290_length_487_cov_2.577295_g28756_i0 | PRJNA1144090 | 29290 | 487 | 2.577295 | 12.55142665 | Rhizamoeba sp. ATCC 5 | 2909502 | Tubulinea | other_Eukaryota | 176 | 1.42e-47 | NR | AEH95280.1 | 497999 | g28756 | i0 | 54.9 | 6.87474332648871 | 162 | 73 | 99.8 | 0 | 487 | 2 | 448 | 609 | AEH95280.1 RNA polymerase II largest subunit, partial [Rhizamoeba sp. ATCC 50933] | diamond | 3348 | 176 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba sp. ATCC 50933 | ||
| 30281051 | 30281051 | PRJNA1144090_P_NODE_57972_length_333_cov_3.130769_g57437_i0 | PRJNA1144090 | 57972 | 333 | 3.130769 | 10.42546077 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 158 | 1.3799999999999998e-47 | NR | AAX57202.1 | 5778 | g57437 | i0 | 69.1 | 9.90990990990991 | 110 | 33 | 99.1 | 1 | 2 | 331 | 18 | 126 | AAX57202.1 vacuolar protein sorting protein 26, partial [Vermamoeba vermiformis] | diamond | 3300 | 158 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31239478 | 31239478 | PRJNA1144090_P_NODE_90335_length_264_cov_1.612565_g89800_i0 | PRJNA1144090 | 90335 | 264 | 1.612565 | 4.2571716 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 81.3 | 4.63e-16 | NR | AKN09693.1 | 5775 | g89800 | i0 | 47.4 | 0.886363636363636 | 78 | 41 | 88.6 | 0 | 240 | 7 | 50 | 127 | AKN09693.1 metaxin [Amoeba proteus] | diamond | 234 | 81.3 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31461159 | 31461159 | PRJNA1144090_P_NODE_15776_length_696_cov_3.073836_g15280_i0 | PRJNA1144090 | 15776 | 696 | 3.073836 | 21.39389856 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 201 | 3.2e-60 | NR | AKN09689.1 | 5775 | g15280 | i0 | 46.7 | 0.969827586206897 | 225 | 106 | 96.6 | 3 | 1 | 672 | 69 | 280 | AKN09689.1 Tom20 [Amoeba proteus] | diamond | 675 | 201 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;