contig_metadata
14 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;