contig_metadata
18 rows where bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622849 | 622849 | PRJNA657343_P_NODE_17781_length_217_cov_0.922619_g17757_i0 | PRJNA657343 | 17781 | 217 | 0.922619 | 2.00208323 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 357 | 3.63e-94 | NTclustered | gi|421976335|gb|JQ519484.1| | 5778 | g17757 | i0 | 97.156 | 43.7695852534562 | 211 | 6 | 97 | 0 | 6 | 216 | 361 | 151 | Vermamoeba vermiformis clone JGHverm1 beta-tubulin gene, partial cds | blastn | 9498 | 357 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 623114 | 623114 | PRJNA657343_P_NODE_401_length_805_cov_57.970899_g390_i0 | PRJNA657343 | 401 | 805 | 57.970899 | 466.66573695 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 327 | 1.2e-84 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g390 | i0 | 83.696 | 21.583850931677 | 368 | 38 | 44 | 14 | 190 | 543 | 1 | 360 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 17375 | 327 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 3712142 | 3712142 | PRJNA657343_P_NODE_39003_length_166_cov_0.888889_g38979_i0 | PRJNA657343 | 39003 | 166 | 0.888889 | 1.47555574 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 279 | 5.86e-71 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g38979 | i0 | 98.125 | 81.078313253012 | 160 | 3 | 96 | 0 | 3 | 162 | 5015 | 5174 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 13459 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4450788 | 4450788 | PRJNA657343_P_NODE_2064_length_478_cov_2.251748_g2041_i0 | PRJNA657343 | 2064 | 478 | 2.251748 | 10.76335544 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 752 | 0 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g2041 | i0 | 95.532 | 4.84937238493724 | 470 | 21 | 98 | 0 | 5 | 474 | 265 | 734 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 2318 | 752 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5727612 | 5727612 | PRJNA657343_S_NODE_31645_length_156_cov_2.074766_g31620_i0 | PRJNA657343 | 31645 | 156 | 2.074766 | 3.23663496 | Lobosea sp. Mb_5C | 507804 | Tubulinea | other_Eukaryota | 270 | 3.2599999999999996e-68 | NTclustered | gi|169264626|dbj|AB425950.1| | 507804 | g31620 | i0 | 98.077 | 9.41666666666667 | 156 | 1 | 100 | 2 | 1 | 156 | 637 | 790 | Lobosea sp. Mb_5C gene for 18S ribosomal RNA, partial sequence | blastn | 1469 | 270 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Mb_5C | ||||||
| 6264140 | 6264140 | PRJNA657343_P_NODE_10625_length_262_cov_2.300469_g10601_i0 | PRJNA657343 | 10625 | 262 | 2.300469 | 6.02722878 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 80.5 | 2.5e-15 | NR | AKN09691.1 | 5775 | g10601 | i0 | 47.1 | 0.973282442748092 | 85 | 23 | 97.3 | 1 | 255 | 1 | 753 | 815 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 255 | 80.5 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 10088992 | 10088992 | PRJNA657343_P_NODE_108_length_1167_cov_72.902504_g105_i0 | PRJNA657343 | 108 | 1167 | 72.902504 | 850.77222168 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 1690 | 0 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g105 | i0 | 92.967 | 39.2245072836333 | 1166 | 73 | 99 | 8 | 3 | 1164 | 1161 | 1 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 45775 | 1690 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 | ||||||
| 12102360 | 12102360 | PRJNA657343_P_NODE_21910_length_200_cov_3.311258_g21886_i0 | PRJNA657343 | 21910 | 200 | 3.311258 | 6.622516 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 318 | 1.55e-82 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g21886 | i0 | 95.918 | 21.69 | 196 | 8 | 98 | 0 | 3 | 198 | 126 | 321 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 4338 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14652073 | 14652073 | PRJNA657343_P_NODE_37752_length_167_cov_0.881356_g37728_i0 | PRJNA657343 | 37752 | 167 | 0.881356 | 1.47186452 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 117 | 4.900000000000001e-22 | NTclustered | gi|88601207|gb|DQ384272.1| | 5778 | g37728 | i0 | 87.879 | 0.592814371257485 | 99 | 12 | 59 | 0 | 30 | 128 | 225 | 127 | Hartmannella vermiformis unknown mRNA | blastn | 99 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19011913 | 19011913 | PRJNA657343_P_NODE_30675_length_177_cov_2.718750_g30651_i0 | PRJNA657343 | 30675 | 177 | 2.71875 | 4.8121875 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 318 | 1.34e-82 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g30651 | i0 | 100 | 37.2146892655367 | 172 | 0 | 97 | 0 | 3 | 174 | 2716 | 2887 | Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6587 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21562502 | 21562502 | PRJNA657343_S_NODE_28537_length_166_cov_21.940171_g28512_i0 | PRJNA657343 | 28537 | 166 | 21.940171 | 36.42068386 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 294 | 2.09e-75 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g28512 | i0 | 100 | 95.9397590361446 | 159 | 0 | 96 | 0 | 3 | 161 | 1044 | 1202 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 15926 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 24849392 | 24849392 | PRJNA657343_P_NODE_3300_length_405_cov_3.682584_g3277_i0 | PRJNA657343 | 3300 | 405 | 3.682584 | 14.9144652 | Nolandella sp. LAK-2 | 1908693 | Tubulinea | other_Eukaryota | 217 | 1.69e-68 | NR | AFX73095.1 | 1260117 | g3277 | i0 | 73.8 | 1.94814814814815 | 130 | 34 | 96.3 | 0 | 2 | 391 | 14 | 143 | AFX73095.1 elongation factor 2 alpha, partial [Nolandella sp. LAK-2012] | diamond | 789 | 217 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Nolandella | Nolandella sp. LAK-2012 | ||
| 25386863 | 25386863 | PRJNA657343_P_NODE_6380_length_316_cov_4.707865_g6356_i0 | PRJNA657343 | 6380 | 316 | 4.707865 | 14.8768534 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 577 | 3.9499999999999996e-160 | NTclustered | gi|2463802139|gb|OQ678078.1| | 5778 | g6356 | i0 | 99.683 | 99.6582278481013 | 315 | 1 | 99 | 0 | 1 | 315 | 11 | 325 | Vermamoeba vermiformis isolate IQ5E small subunit ribosomal RNA gene, partial sequence | blastn | 31492 | 577 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25386865 | 25386865 | PRJNA657343_P_NODE_9040_length_278_cov_40.349345_g9016_i0 | PRJNA657343 | 9040 | 278 | 40.349345 | 112.1711791 | Echinamoeba | 136449 | Tubulinea | other_Eukaryota | 342 | 1.36e-89 | NTclustered | gi|399764170|gb|JQ271681.1| | 1215984 | g9016 | i0 | 89.706 | 52.2194244604317 | 272 | 22 | 97 | 5 | 3 | 272 | 1542 | 1275 | Echinamoeba silvestris strain UKNCC:CCAP1519/1 18S ribosomal RNA gene, partial sequence | blastn | 14517 | 342 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba silvestris | |||
| 27586972 | 27586972 | PRJNA657343_P_NODE_4824_length_351_cov_2.380795_g4801_i0 | PRJNA657343 | 4824 | 351 | 2.380795 | 8.35659045 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 180 | 1.9299999999999994e-54 | NR | ABD46560.1 | 5778 | g4801 | i0 | 73.3 | 0.991452991452991 | 116 | 31 | 99.1 | 0 | 3 | 350 | 92 | 207 | ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis] | diamond | 348 | 180 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29240977 | 29240977 | PRJNA657343_P_NODE_2509_length_447_cov_5.977387_g2486_i0 | PRJNA657343 | 2509 | 447 | 5.977387 | 26.71891989 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 157 | 4.46e-45 | NR | AAY21191.1 | 5778 | g2486 | i0 | 61.3 | 1.85234899328859 | 137 | 53 | 91.9 | 0 | 6 | 416 | 98 | 234 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 828 | 158 | 0.993670886075949 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29493527 | 29493527 | PRJNA657343_P_NODE_13470_length_240_cov_2.068063_g13446_i0 | PRJNA657343 | 13470 | 240 | 2.068063 | 4.9633512 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 2.53e-33 | NR | BAN33737.1 | 931554 | g13446 | i0 | 79.7 | 4.7625 | 74 | 15 | 92.5 | 0 | 6 | 227 | 249 | 322 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1143 | 129 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 32862412 | 32862412 | PRJNA657343_P_NODE_20000_length_207_cov_3.462025_g19976_i0 | PRJNA657343 | 20000 | 207 | 3.462025 | 7.16639175 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 105 | 6.93e-26 | NR | ABD46560.1 | 5778 | g19976 | i0 | 72.7 | 0.956521739130435 | 66 | 18 | 95.7 | 0 | 7 | 204 | 2 | 67 | ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis] | diamond | 198 | 105 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;