contig_metadata
20 rows where bioproject = "PRJNA928559", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6005132 | 6005132 | PRJNA928559_P_NODE_104145_length_349_cov_6.326087_g102576_i0 | PRJNA928559 | 104145 | 349 | 6.326087 | 22.07804363 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 226 | 1.8299999999999995e-54 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g102576 | i0 | 80.312 | 6.35816618911175 | 320 | 46 | 90 | 16 | 36 | 349 | 1 | 309 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 2219 | 226 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 6005238 | 6005238 | PRJNA928559_P_NODE_111785_length_337_cov_2.700758_g110216_i0 | PRJNA928559 | 111785 | 337 | 2.700758 | 9.10155446 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 556 | 5.529999999999999e-154 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g110216 | i0 | 96.439 | 85.4421364985163 | 337 | 12 | 100 | 0 | 1 | 337 | 2283 | 2619 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28794 | 556 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 6007322 | 6007322 | PRJNA928559_P_NODE_46505_length_498_cov_18.682353_g44943_i0 | PRJNA928559 | 46505 | 498 | 18.682353 | 93.03811794 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 213 | 2.11e-50 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g44943 | i0 | 83.83 | 40.0140562248996 | 235 | 26 | 62 | 11 | 238 | 468 | 4488 | 4262 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19927 | 213 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 6356797 | 6356797 | PRJNA928559_P_NODE_154505_length_283_cov_1.509524_g152936_i0 | PRJNA928559 | 154505 | 283 | 1.509524 | 4.27195292 | Lesquereusia modesta | 1260108 | Tubulinea | other_Eukaryota | 114 | 5.5e-29 | NR | AFX73094.1 | 1260108 | g152936 | i0 | 64.5 | 3.92226148409894 | 93 | 33 | 98.6 | 0 | 281 | 3 | 118 | 210 | AFX73094.1 elongation factor 2 alpha, partial [Lesquereusia modesta] | diamond | 1110 | 114 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Lesquereusiidae | Lesquereusia | Lesquereusia modesta | ||
| 7280217 | 7280217 | PRJNA928559_P_NODE_117946_length_328_cov_1.721569_g116377_i0 | PRJNA928559 | 117946 | 328 | 1.721569 | 5.64674632 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 315 | 3.56e-81 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g116377 | i0 | 83.988 | 1.81707317073171 | 331 | 50 | 100 | 1 | 1 | 328 | 2605 | 2935 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 596 | 315 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 8554820 | 8554820 | PRJNA928559_P_NODE_106047_length_346_cov_2.659341_g104478_i0 | PRJNA928559 | 106047 | 346 | 2.659341 | 9.20131986 | Gephyramoeba sp. ATCC50654 | 136454 | Tubulinea | other_Eukaryota | 556 | 5.69e-154 | NTclustered | gi|11527304|gb|AF293897.1|AF293897 | 136454 | g104478 | i0 | 95.665 | 23.4421965317919 | 346 | 15 | 100 | 0 | 1 | 346 | 584 | 929 | Gephyramoeba sp. ATCC50654 small subunit ribosomal RNA gene, complete sequence | blastn | 8111 | 556 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Gephyramoeba | Gephyramoeba sp. ATCC50654 | |||
| 9832158 | 9832158 | PRJNA928559_P_NODE_69248_length_422_cov_4.501433_g67679_i0 | PRJNA928559 | 69248 | 422 | 4.501433 | 18.99604726 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 710 | 0 | NTclustered | gi|345294028|gb|JF694284.1| | 1078852 | g67679 | i0 | 97.143 | 69.4644549763033 | 420 | 12 | 99 | 0 | 1 | 420 | 203 | 622 | Pyxidicula operculata small subunit ribosomal RNA gene, partial sequence | blastn | 29314 | 710 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 9832539 | 9832539 | PRJNA928559_P_NODE_99488_length_357_cov_7.028169_g97919_i0 | PRJNA928559 | 99488 | 357 | 7.028169 | 25.09056333 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 82.4 | 4.31e-11 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g97919 | i0 | 83.908 | 0.243697478991597 | 87 | 13 | 24 | 1 | 167 | 253 | 25944 | 26029 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 87 | 82.4 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11107276 | 11107276 | PRJNA928559_P_NODE_225469_length_215_cov_13.577465_g223900_i0 | PRJNA928559 | 225469 | 215 | 13.577465 | 29.19154975 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 313 | 7.879999999999998e-81 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g223900 | i0 | 100 | 75.1488372093023 | 169 | 0 | 79 | 0 | 1 | 169 | 18 | 186 | 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 | 16157 | 313 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12732102 | 12732102 | PRJNA928559_P_NODE_129430_length_312_cov_1.899582_g127861_i0 | PRJNA928559 | 129430 | 312 | 1.899582 | 5.92669584 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 166 | 2.82e-46 | NR | YP_003540812.1 | 5778 | g127861 | i0 | 97.7 | 0.836538461538462 | 87 | 2 | 83.7 | 0 | 263 | 3 | 101 | 187 | YP_003540812.1 ATP synthase F1 subunit alpha [Vermamoeba vermiformis] | diamond | 261 | 166 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14930000 | 14930000 | PRJNA928559_P_NODE_113272_length_335_cov_1.786260_g111703_i0 | PRJNA928559 | 113272 | 335 | 1.78626 | 5.983971 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 202 | 2.96e-47 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g111703 | i0 | 78.947 | 19.8507462686567 | 342 | 38 | 100 | 22 | 1 | 335 | 2147 | 1833 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 6650 | 202 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 16206868 | 16206868 | PRJNA928559_P_NODE_34173_length_564_cov_10.847251_g32627_i0 | PRJNA928559 | 34173 | 564 | 10.847251 | 61.17849564 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 582 | 1.5899999999999999e-161 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g32627 | i0 | 85.891 | 1.00531914893617 | 567 | 57 | 100 | 17 | 1 | 564 | 759 | 213 | 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 | 567 | 582 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17480484 | 17480484 | PRJNA928559_P_NODE_134594_length_305_cov_4.150862_g133025_i0 | PRJNA928559 | 134594 | 305 | 4.150862 | 12.6601291 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 409 | 1.46e-109 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g133025 | i0 | 90.909 | 27.744262295082 | 308 | 23 | 100 | 5 | 1 | 305 | 769 | 1074 | 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 | 8462 | 409 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17482515 | 17482515 | PRJNA928559_P_NODE_66754_length_429_cov_2.410112_g65185_i0 | PRJNA928559 | 66754 | 429 | 2.410112 | 10.33938048 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 472 | 2.68e-128 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g65185 | i0 | 98.502 | 56.8205128205128 | 267 | 4 | 62 | 0 | 1 | 267 | 1320 | 1586 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 24376 | 472 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 20030534 | 20030534 | PRJNA928559_P_NODE_38916_length_535_cov_9.547619_g37361_i0 | PRJNA928559 | 38916 | 535 | 9.547619 | 51.07976165 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 802 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g37361 | i0 | 94.14 | 11.8654205607477 | 529 | 27 | 98 | 4 | 1 | 526 | 26423 | 26950 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 6348 | 802 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23856182 | 23856182 | PRJNA928559_P_NODE_32899_length_573_cov_109.248000_g31365_i0 | PRJNA928559 | 32899 | 573 | 109.248 | 625.99104 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1031 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g31365 | i0 | 99.127 | 19.6666666666667 | 573 | 5 | 100 | 0 | 1 | 573 | 1784 | 1212 | 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 | 11269 | 1031 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24204266 | 24204266 | PRJNA928559_P_NODE_144579_length_293_cov_22.545455_g143010_i0 | PRJNA928559 | 144579 | 293 | 22.545455 | 66.05818315 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 542 | 1.32e-149 | NTclustered | gi|2806326577|gb|PQ345827.1| | 5778 | g143010 | i0 | 100 | 100 | 293 | 0 | 100 | 0 | 1 | 293 | 75 | 367 | Vermamoeba vermiformis isolate 8FSa small subunit ribosomal RNA gene, partial sequence | blastn | 29300 | 542 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25128981 | 25128981 | PRJNA928559_P_NODE_169580_length_268_cov_2.348718_g168011_i0 | PRJNA928559 | 169580 | 268 | 2.348718 | 6.29456424 | Gephyramoeba sp. ATCC50654 | 136454 | Tubulinea | other_Eukaryota | 440 | 4.479999999999998e-119 | NTclustered | gi|11527304|gb|AF293897.1|AF293897 | 136454 | g168011 | i0 | 96.269 | 97.1044776119403 | 268 | 10 | 100 | 0 | 1 | 268 | 74 | 341 | Gephyramoeba sp. ATCC50654 small subunit ribosomal RNA gene, complete sequence | blastn | 26024 | 440 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Gephyramoeba | Gephyramoeba sp. ATCC50654 | |||
| 25129772 | 25129772 | PRJNA928559_P_NODE_221140_length_231_cov_8.050633_g219571_i0 | PRJNA928559 | 221140 | 231 | 8.050633 | 18.59696223 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 351 | 1.8199999999999998e-92 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g219571 | i0 | 98.98 | 11.8398268398268 | 196 | 2 | 85 | 0 | 36 | 231 | 1 | 196 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 2735 | 351 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 25130074 | 25130074 | PRJNA928559_P_NODE_36020_length_552_cov_15.083507_g34470_i0 | PRJNA928559 | 36020 | 552 | 15.083507000000001 | 83.26095864 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 835 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g34470 | i0 | 94.815 | 61.6195652173913 | 540 | 21 | 97 | 6 | 1 | 538 | 20590 | 20056 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 34014 | 835 | 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);;