contig_metadata
22 rows where bioproject = "PRJNA770826", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3298099 | 3298099 | PRJNA770826_P_NODE_2503_length_549_cov_4.370000_g2336_i0 | PRJNA770826 | 2503 | 549 | 4.37 | 23.9913 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 288 | 3.64e-97 | NR | AAW58116.1 | 5775 | g2336 | i0 | 80.2 | 0.885245901639344 | 162 | 32 | 88.5 | 0 | 64 | 549 | 1 | 162 | AAW58116.1 peroxiredoxin, partial [Amoeba proteus] | diamond | 486 | 288 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 4575108 | 4575108 | PRJNA770826_P_NODE_12264_length_229_cov_3.177778_g12093_i0 | PRJNA770826 | 12264 | 229 | 3.177778 | 7.27711162 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 285 | 1.85e-72 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g12093 | i0 | 89.083 | 88.9912663755458 | 229 | 25 | 100 | 0 | 1 | 229 | 254 | 26 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 20379 | 285 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 4575234 | 4575234 | PRJNA770826_P_NODE_504_length_1114_cov_28.676056_g425_i0 | PRJNA770826 | 504 | 1114 | 28.676056 | 319.45126384 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 809 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i0 | 80.993 | 2.38330341113106 | 1047 | 176 | 93 | 18 | 84 | 1114 | 1382 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2655 | 809 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 5850427 | 5850427 | PRJNA770826_P_NODE_2585_length_540_cov_5.336049_g2417_i0 | PRJNA770826 | 2585 | 540 | 5.336049 | 28.8146646 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 841 | 0 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g2417 | i0 | 95.292 | 98.9888888888889 | 531 | 24 | 98 | 1 | 10 | 540 | 640 | 111 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 53454 | 841 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 13500715 | 13500715 | PRJNA770826_P_NODE_5131_length_375_cov_3.134969_g4960_i0 | PRJNA770826 | 5131 | 375 | 3.134969 | 11.75613375 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 693 | 0 | NTclustered | gi|345294028|gb|JF694284.1| | 1078852 | g4960 | i0 | 100 | 69.6293333333333 | 375 | 0 | 100 | 0 | 1 | 375 | 901 | 1275 | Pyxidicula operculata small subunit ribosomal RNA gene, partial sequence | blastn | 26111 | 693 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 16049573 | 16049573 | PRJNA770826_P_NODE_513_length_1105_cov_29.258523_g425_i1 | PRJNA770826 | 513 | 1105 | 29.258523 | 323.30667915 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 837 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i1 | 81.429 | 2.4316742081448 | 1050 | 172 | 94 | 18 | 72 | 1105 | 1385 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2687 | 837 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 16049602 | 16049602 | PRJNA770826_P_NODE_873_length_896_cov_30.332940_g425_i4 | PRJNA770826 | 873 | 896 | 30.33294 | 271.7831424 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 667 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i4 | 80.562 | 2.63839285714286 | 890 | 154 | 98 | 17 | 21 | 896 | 1227 | 343 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2364 | 667 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 17325288 | 17325288 | PRJNA770826_P_NODE_574_length_1061_cov_28.289526_g425_i2 | PRJNA770826 | 574 | 1061 | 28.289526 | 300.15187086 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 832 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i2 | 81.322 | 7.4062205466541 | 1044 | 178 | 97 | 15 | 4 | 1034 | 1040 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 7858 | 832 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 17325302 | 17325302 | PRJNA770826_P_NODE_694_length_980_cov_2.987111_g589_i0 | PRJNA770826 | 694 | 980 | 2.987111 | 29.2736878 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 441 | 1.8699999999999994e-153 | NR | AFX73090.1 | 160823 | g589 | i0 | 92.3 | 2.75510204081633 | 234 | 18 | 71.6 | 0 | 703 | 2 | 1 | 234 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 2700 | 445 | 0.991011235955056 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 18598704 | 18598704 | PRJNA770826_P_NODE_4135_length_424_cov_2.080000_g3964_i0 | PRJNA770826 | 4135 | 424 | 2.08 | 8.8192 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 556 | 7.099999999999998e-154 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g3964 | i0 | 90.521 | 99.6556603773585 | 422 | 38 | 99 | 2 | 4 | 424 | 526 | 106 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 42254 | 556 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 21608888 | 21608888 | PRJNA770826_P_NODE_857_length_901_cov_2.095070_g744_i0 | PRJNA770826 | 857 | 901 | 2.09507 | 18.8765807 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 546 | 1.0899999999999999e-193 | NR | AAP88974.1 | 5775 | g744 | i0 | 87.8 | 0.985571587125416 | 296 | 36 | 98.6 | 0 | 12 | 899 | 91 | 386 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 888 | 546 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 22424281 | 22424281 | PRJNA770826_P_NODE_618_length_1031_cov_28.478615_g425_i3 | PRJNA770826 | 618 | 1031 | 28.478615 | 293.61452065 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 821 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g425 | i3 | 81.172 | 3.64403491755577 | 1041 | 179 | 99 | 15 | 4 | 1031 | 1040 | 4 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 3757 | 821 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 23699858 | 23699858 | PRJNA770826_P_NODE_2419_length_559_cov_3.031373_g2252_i0 | PRJNA770826 | 2419 | 559 | 3.031373 | 16.94537507 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 1005 | 0 | NTclustered | gi|345294028|gb|JF694284.1| | 1078852 | g2252 | i0 | 99.106 | 76.5366726296959 | 559 | 5 | 100 | 0 | 1 | 559 | 771 | 213 | Pyxidicula operculata small subunit ribosomal RNA gene, partial sequence | blastn | 42784 | 1005 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 26831812 | 26831812 | PRJNA770826_P_NODE_18161_length_190_cov_1.106383_g17990_i0 | PRJNA770826 | 18161 | 190 | 1.106383 | 2.1021277 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 102 | 9.92e-24 | NR | AOW71840.1 | 5775 | g17990 | i0 | 75.8 | 0.978947368421053 | 62 | 15 | 97.9 | 0 | 188 | 3 | 99 | 160 | AOW71840.1 bacterial recombinase A, partial [Amoeba proteus] | diamond | 186 | 102 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30338107 | 30338107 | PRJNA770826_P_NODE_6232_length_335_cov_0.909091_g6061_i0 | PRJNA770826 | 6232 | 335 | 0.909091 | 3.04545485 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 199 | 1.3999999999999997e-56 | NR | AAD33718.1 | 5775 | g6061 | i0 | 90.1 | 0.994029850746269 | 111 | 11 | 99.4 | 0 | 1 | 333 | 730 | 840 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 333 | 199 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31105348 | 31105348 | PRJNA770826_P_NODE_11715_length_235_cov_2.602151_g11544_i0 | PRJNA770826 | 11715 | 235 | 2.602151 | 6.11505485 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.9 | 1.25e-13 | NR | AFX73093.1 | 5778 | g11544 | i0 | 54.5 | 4.16170212765957 | 66 | 17 | 84.3 | 1 | 198 | 1 | 39 | 91 | AFX73093.1 elongation factor 2 alpha, partial [Vermamoeba vermiformis] | diamond | 978 | 73.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31570470 | 31570470 | PRJNA770826_P_NODE_12956_length_223_cov_2.011494_g12785_i0 | PRJNA770826 | 12956 | 223 | 2.011494 | 4.48563162 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 143 | 3.24e-39 | NR | AAP88974.1 | 5775 | g12785 | i0 | 89 | 0.982062780269058 | 73 | 8 | 98.2 | 0 | 4 | 222 | 1 | 73 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 219 | 143 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31949713 | 31949713 | PRJNA770826_P_NODE_36017_length_165_cov_0.896552_g35846_i0 | PRJNA770826 | 36017 | 165 | 0.896552 | 1.4793108 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 107 | 3.36e-28 | NR | AFX73078.1 | 160823 | g35846 | i0 | 90.9 | 1 | 55 | 5 | 100 | 0 | 1 | 165 | 81 | 135 | AFX73078.1 beta-tubulin, partial [Chaos carolinense] | diamond | 165 | 107 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 31981323 | 31981323 | PRJNA770826_P_NODE_11138_length_241_cov_1.895833_g10967_i0 | PRJNA770826 | 11138 | 241 | 1.895833 | 4.56895753 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 100 | 4.96e-24 | NR | AAY21191.1 | 5778 | g10967 | i0 | 63.6 | 1.91701244813278 | 77 | 28 | 95.9 | 0 | 239 | 9 | 145 | 221 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 462 | 100 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32013141 | 32013141 | PRJNA770826_P_NODE_6338_length_332_cov_1.102473_g6167_i0 | PRJNA770826 | 6338 | 332 | 1.102473 | 3.66021036 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 206 | 4.86e-64 | NR | AFX84537.1 | 5775 | g6167 | i0 | 86.2 | 0.984939759036145 | 109 | 15 | 98.5 | 0 | 331 | 5 | 146 | 254 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 327 | 206 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32361407 | 32361407 | PRJNA770826_P_NODE_25359_length_168_cov_1.310924_g25188_i0 | PRJNA770826 | 25359 | 168 | 1.310924 | 2.20235232 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 77 | 9.73e-15 | NR | AAD37351.1 | 5775 | g25188 | i0 | 63 | 0.964285714285714 | 54 | 20 | 96.4 | 0 | 2 | 163 | 99 | 152 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 162 | 77 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32676829 | 32676829 | PRJNA770826_P_NODE_36220_length_164_cov_1.356522_g36049_i0 | PRJNA770826 | 36220 | 164 | 1.356522 | 2.22469608 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 88.6 | 6.47e-19 | NR | AAD37351.1 | 5775 | g36049 | i0 | 79.6 | 0.98780487804878 | 54 | 11 | 98.8 | 0 | 164 | 3 | 115 | 168 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 162 | 88.6 | 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);;