contig_metadata
22 rows where bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2320354 | 2320354 | PRJNA1204310_P_NODE_36682_length_308_cov_0.995745_g36385_i0 | PRJNA1204310 | 36682 | 308 | 0.995745 | 3.0668946 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 564 | 2.99e-156 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g36385 | i0 | 99.675 | 49.2402597402597 | 308 | 1 | 100 | 0 | 1 | 308 | 575 | 268 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 15166 | 569 | 0.991212653778559 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 4156355 | 4156355 | PRJNA1204310_P_NODE_43324_length_281_cov_4.538462_g43027_i0 | PRJNA1204310 | 43324 | 281 | 4.538462 | 12.75307822 | Glaeseria mira | 242547 | Tubulinea | other_Eukaryota | 335 | 2.3e-87 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g43027 | i0 | 88.489 | 91.1138790035587 | 278 | 31 | 99 | 1 | 1 | 277 | 296 | 19 | Glaeseria mira actin mRNA, partial cds | blastn | 25603 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 4156774 | 4156774 | PRJNA1204310_P_NODE_644_length_1623_cov_62.105806_g562_i0 | PRJNA1204310 | 644 | 1623 | 62.105806 | 1007.97723138 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 2.9100000000000003e-276 | NR | BAN33737.1 | 931554 | g562 | i0 | 81.2 | 2.54343807763401 | 463 | 81 | 84.5 | 1 | 39 | 1409 | 1 | 463 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 4128 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5431756 | 5431756 | PRJNA1204310_P_NODE_1005_length_1408_cov_3.402996_g886_i0 | PRJNA1204310 | 1005 | 1408 | 3.402996 | 47.91418368 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1557 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g886 | i0 | 87.15 | 27.1732954545455 | 1393 | 153 | 97 | 16 | 14 | 1384 | 1 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 38260 | 1557 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5432241 | 5432241 | PRJNA1204310_P_NODE_29085_length_344_cov_2.140221_g28788_i0 | PRJNA1204310 | 29085 | 344 | 2.140221 | 7.36236024 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 636 | 7.059999999999998e-178 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g28788 | i0 | 100 | 83.1482558139535 | 344 | 0 | 100 | 0 | 1 | 344 | 1083 | 740 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 28603 | 636 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 6707350 | 6707350 | PRJNA1204310_P_NODE_51246_length_253_cov_0.866667_g50949_i0 | PRJNA1204310 | 51246 | 253 | 0.866667 | 2.19266751 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 468 | 1.92e-127 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g50949 | i0 | 100 | 26.6837944664032 | 253 | 0 | 100 | 0 | 1 | 253 | 1655 | 1403 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 6751 | 468 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 9256823 | 9256823 | PRJNA1204310_P_NODE_21628_length_391_cov_1.116352_g21331_i0 | PRJNA1204310 | 21628 | 391 | 1.116352 | 4.36493632 | Copromyxa laresi | 1789826 | Tubulinea | other_Eukaryota | 640 | 6.27e-179 | NTclustered | gi|1042160931|dbj|LC102272.1| | 1789826 | g21331 | i0 | 96.164 | 99.3222506393862 | 391 | 15 | 100 | 0 | 1 | 391 | 57 | 447 | Copromyxa sp. MK-2016 gene for actin, partial cds, strain: ZEB1_cl1 | blastn | 38835 | 640 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa laresi | ||
| 11807400 | 11807400 | PRJNA1204310_P_NODE_19230_length_411_cov_1.153846_g18933_i0 | PRJNA1204310 | 19230 | 411 | 1.153846 | 4.74230706 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 229 | 9.18e-72 | NR | AAP88974.1 | 5775 | g18933 | i0 | 81.6 | 0.992700729927007 | 136 | 25 | 99.3 | 0 | 410 | 3 | 131 | 266 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 408 | 229 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 11807610 | 11807610 | PRJNA1204310_P_NODE_27890_length_351_cov_0.888489_g27593_i0 | PRJNA1204310 | 27890 | 351 | 0.888489 | 3.11859639 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 201 | 4.24e-62 | NR | AFX84537.1 | 5775 | g27593 | i0 | 82.1 | 1 | 117 | 21 | 100 | 0 | 351 | 1 | 106 | 222 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 351 | 201 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 12523606 | 12523606 | PRJNA1204310_P_NODE_14070_length_472_cov_6.263158_g13773_i0 | PRJNA1204310 | 14070 | 472 | 6.263158 | 29.56210576 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 872 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g13773 | i0 | 100 | 95.2733050847458 | 472 | 0 | 100 | 0 | 1 | 472 | 1652 | 1181 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 44969 | 872 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 13083065 | 13083065 | PRJNA1204310_P_NODE_45951_length_272_cov_1.175879_g45654_i0 | PRJNA1204310 | 45951 | 272 | 1.175879 | 3.19839088 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 160 | 6.08e-48 | NR | AAW58116.1 | 5775 | g45654 | i0 | 81.1 | 0.992647058823529 | 90 | 17 | 99.3 | 0 | 272 | 3 | 59 | 148 | AAW58116.1 peroxiredoxin, partial [Amoeba proteus] | diamond | 270 | 160 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 15631713 | 15631713 | PRJNA1204310_P_NODE_2113_length_1080_cov_2.420060_g1925_i0 | PRJNA1204310 | 2113 | 1080 | 2.42006 | 26.136648 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 563 | 1.74e-199 | NR | AAP88974.1 | 5775 | g1925 | i0 | 79.2 | 0.961111111111111 | 346 | 70 | 96.1 | 1 | 1080 | 43 | 47 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1038 | 563 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 18180207 | 18180207 | PRJNA1204310_P_NODE_11855_length_511_cov_1.958904_g11558_i0 | PRJNA1204310 | 11855 | 511 | 1.958904 | 10.00999944 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 364 | 5.6599999999999985e-96 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g11558 | i0 | 80.04 | 1.09784735812133 | 496 | 95 | 97 | 4 | 1 | 494 | 494 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 561 | 364 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 22005515 | 22005515 | PRJNA1204310_P_NODE_1578_length_1212_cov_12.890255_g1415_i0 | PRJNA1204310 | 1578 | 1212 | 12.890255 | 156.2298906 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 619 | 1.61e-220 | NR | AAP88974.1 | 5775 | g1415 | i0 | 77.6 | 0.97029702970297 | 392 | 85 | 96.8 | 2 | 1204 | 32 | 1 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1176 | 619 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 22006303 | 22006303 | PRJNA1204310_P_NODE_50918_length_253_cov_0.866667_g50621_i0 | PRJNA1204310 | 50918 | 253 | 0.866667 | 2.19266751 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 142 | 2.2199999999999996e-41 | NR | AFX73058.1 | 160823 | g50621 | i0 | 85.7 | 0.99604743083004 | 84 | 12 | 99.6 | 0 | 2 | 253 | 69 | 152 | AFX73058.1 14-3-3 protein, partial [Chaos carolinense] | diamond | 252 | 142 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 23281961 | 23281961 | PRJNA1204310_P_NODE_7699_length_624_cov_2.573503_g7413_i0 | PRJNA1204310 | 7699 | 624 | 2.573503 | 16.05865872 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 342 | 4.38e-116 | NR | AFX84537.1 | 5775 | g7413 | i0 | 80.7 | 0.995192307692308 | 207 | 40 | 99.5 | 0 | 623 | 3 | 47 | 253 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 621 | 342 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28209427 | 28209427 | PRJNA1204310_P_NODE_2866_length_955_cov_1.833333_g2648_i0 | PRJNA1204310 | 2866 | 955 | 1.833333 | 17.50833015 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 498 | 4.17e-173 | NR | BAN33737.1 | 931554 | g2648 | i0 | 74 | 1.01465968586387 | 323 | 79 | 99.9 | 1 | 954 | 1 | 130 | 452 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 969 | 498 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28999328 | 28999328 | PRJNA1204310_P_NODE_52188_length_252_cov_0.871508_g51891_i0 | PRJNA1204310 | 52188 | 252 | 0.871508 | 2.19620016 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 119 | 4.75e-29 | NR | AKN09691.1 | 5775 | g51891 | i0 | 67.5 | 0.988095238095238 | 83 | 27 | 98.8 | 0 | 2 | 250 | 694 | 776 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 249 | 119 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30262455 | 30262455 | PRJNA1204310_P_NODE_45872_length_272_cov_1.537688_g45575_i0 | PRJNA1204310 | 45872 | 272 | 1.537688 | 4.18251136 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 97.1 | 4.34e-22 | NR | AKN09689.1 | 5775 | g45575 | i0 | 58.8 | 0.9375 | 85 | 32 | 91.5 | 3 | 15 | 263 | 95 | 178 | AKN09689.1 Tom20 [Amoeba proteus] | diamond | 255 | 97.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31336422 | 31336422 | PRJNA1204310_P_NODE_42836_length_283_cov_1.485714_g42539_i0 | PRJNA1204310 | 42836 | 283 | 1.485714 | 4.20457062 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 145 | 3.5999999999999995e-38 | NR | AKN09691.1 | 5775 | g42539 | i0 | 69.1 | 0.996466431095406 | 94 | 29 | 99.6 | 0 | 282 | 1 | 588 | 681 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 282 | 145 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32064047 | 32064047 | PRJNA1204310_P_NODE_7998_length_613_cov_2.655556_g7712_i0 | PRJNA1204310 | 7998 | 613 | 2.655556 | 16.27855828 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 147 | 6.21e-40 | NR | AAY87037.1 | 5778 | g7712 | i0 | 44.5 | 0.978792822185971 | 200 | 102 | 94.9 | 5 | 583 | 2 | 37 | 233 | AAY87037.1 CmfA-like protein, partial [Vermamoeba vermiformis] | diamond | 600 | 147 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32809499 | 32809499 | PRJNA1204310_P_NODE_41460_length_288_cov_1.204651_g41163_i0 | PRJNA1204310 | 41460 | 288 | 1.204651 | 3.46939488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 4.2e-9 | NR | AKN09691.1 | 5775 | g41163 | i0 | 41.5 | 1.77083333333333 | 82 | 48 | 85.4 | 0 | 269 | 24 | 37 | 118 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 510 | 63.2 | 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);;