contig_metadata
20 rows where bioproject = "PRJNA577226" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 562117 | 562117 | PRJNA577226_S_NODE_45821_length_184_cov_1.496599_g44882_i0 | PRJNA577226 | 45821 | 184 | 1.496599 | 2.75374216 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 335 | 1.3899999999999996e-87 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g44882 | i0 | 99.457 | 25.75 | 184 | 1 | 100 | 0 | 1 | 184 | 25844 | 26027 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 4738 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3112762 | 3112762 | PRJNA577226_S_NODE_39783_length_197_cov_2.018750_g38844_i0 | PRJNA577226 | 39783 | 197 | 2.01875 | 3.9769375 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 348 | 1.94e-91 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g38844 | i0 | 98.477 | 66.1167512690355 | 197 | 3 | 100 | 0 | 1 | 197 | 2539 | 2343 | 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 | 13025 | 348 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3688465 | 3688465 | PRJNA577226_S_NODE_12303_length_370_cov_16.810811_g11364_i0 | PRJNA577226 | 12303 | 370 | 16.810811 | 62.2000007 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 577 | 4.6899999999999996e-160 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g11364 | i0 | 97.898 | 51.7918918918919 | 333 | 7 | 90 | 0 | 1 | 333 | 1250 | 918 | 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 | 19163 | 577 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4389513 | 4389513 | PRJNA577226_S_NODE_44504_length_186_cov_12.302013_g43565_i0 | PRJNA577226 | 44504 | 186 | 12.302013 | 22.88174418 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 311 | 2.38e-80 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g43565 | i0 | 96.774 | 1.72043010752688 | 186 | 6 | 100 | 0 | 1 | 186 | 7096 | 6911 | 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 | 320 | 311 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4389874 | 4389874 | PRJNA577226_S_NODE_58804_length_163_cov_7.174603_g57865_i0 | PRJNA577226 | 58804 | 163 | 7.174603 | 11.69460289 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 302 | 1.22e-77 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g57865 | i0 | 100 | 95.9631901840491 | 163 | 0 | 100 | 0 | 1 | 163 | 3865 | 3703 | 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 | 15642 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6240842 | 6240842 | PRJNA577226_S_NODE_29145_length_231_cov_10.500000_g28206_i0 | PRJNA577226 | 29145 | 231 | 10.5 | 24.255 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 427 | 2.9399999999999998e-115 | NTclustered | gi|399764177|gb|JQ271688.1| | 5778 | g28206 | i0 | 100 | 100 | 231 | 0 | 100 | 0 | 1 | 231 | 382 | 152 | Hartmannella vermiformis strain ECH26 18S ribosomal RNA gene, partial sequence | blastn | 23100 | 427 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10765723 | 10765723 | PRJNA577226_S_NODE_23869_length_257_cov_19.404545_g22930_i0 | PRJNA577226 | 23869 | 257 | 19.404545 | 49.86968065 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 475 | 1.1699999999999999e-129 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g22930 | i0 | 100 | 3.33852140077821 | 257 | 0 | 100 | 0 | 1 | 257 | 6065 | 6321 | 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 | 858 | 475 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12616650 | 12616650 | PRJNA577226_S_NODE_6050_length_560_cov_13.472275_g5130_i0 | PRJNA577226 | 6050 | 560 | 13.472275 | 75.44474 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 335 | 4.89e-87 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5130 | i0 | 96.098 | 777.185714285714 | 205 | 8 | 37 | 0 | 186 | 390 | 4735 | 4939 | 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 | 435224 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13315333 | 13315333 | PRJNA577226_S_NODE_19311_length_289_cov_9.873016_g18372_i0 | PRJNA577226 | 19311 | 289 | 9.873016 | 28.53301624 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 529 | 1.01e-145 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g18372 | i0 | 99.654 | 5.56747404844291 | 289 | 1 | 100 | 0 | 1 | 289 | 1620 | 1332 | 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 | 1609 | 529 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14590637 | 14590637 | PRJNA577226_S_NODE_36432_length_206_cov_1.928994_g35493_i0 | PRJNA577226 | 36432 | 206 | 1.928994 | 3.97372764 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 230 | 7.749999999999999e-56 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g35493 | i0 | 96.403 | 45.0728155339806 | 139 | 5 | 67 | 0 | 1 | 139 | 25996 | 26134 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 9285 | 230 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15864391 | 15864391 | PRJNA577226_S_NODE_32973_length_217_cov_1.644444_g32034_i0 | PRJNA577226 | 32973 | 217 | 1.644444 | 3.56844348 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 396 | 7.689999999999997e-106 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g32034 | i0 | 99.539 | 3.7741935483871 | 217 | 1 | 100 | 0 | 1 | 217 | 26543 | 26327 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 819 | 396 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17139817 | 17139817 | PRJNA577226_S_NODE_50534_length_175_cov_11.413043_g49595_i0 | PRJNA577226 | 50534 | 175 | 11.413043 | 19.97282525 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 322 | 1.02e-83 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g49595 | i0 | 100 | 102.588571428571 | 174 | 0 | 99 | 0 | 1 | 174 | 2254 | 2427 | 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 | 17953 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17140123 | 17140123 | PRJNA577226_S_NODE_62094_length_160_cov_0.951220_g61155_i0 | PRJNA577226 | 62094 | 160 | 0.95122 | 1.521952 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 287 | 3.34e-73 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g61155 | i0 | 99.367 | 1.9125 | 158 | 1 | 99 | 0 | 1 | 158 | 28129 | 28286 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 306 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18988420 | 18988420 | PRJNA577226_S_NODE_14395_length_340_cov_9.125413_g13456_i0 | PRJNA577226 | 14395 | 340 | 9.125413 | 31.0264042 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 628 | 1.1699999999999999e-175 | NTclustered | gi|891071998|gb|KT266863.1| | 5778 | g13456 | i0 | 100 | 99.8058823529412 | 340 | 0 | 100 | 0 | 1 | 340 | 19 | 358 | Vermamoeba vermiformis isolate TW EDP 1 18S ribosomal RNA gene, partial sequence | blastn | 33934 | 628 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19689247 | 19689247 | PRJNA577226_S_NODE_9496_length_429_cov_12.459184_g8561_i0 | PRJNA577226 | 9496 | 429 | 12.459184 | 53.44989936 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 782 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g8561 | i0 | 99.534 | 76.0955710955711 | 429 | 2 | 100 | 0 | 1 | 429 | 2934 | 2506 | 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 | 32645 | 782 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20263874 | 20263874 | PRJNA577226_S_NODE_40276_length_196_cov_1.635220_g39337_i0 | PRJNA577226 | 40276 | 196 | 1.63522 | 3.2050312 | root | 1 | Root_unresolved | Root_unresolved | 361 | 2.48e-95 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g39337 | i0 | 100 | 27.0969387755102 | 195 | 0 | 99 | 0 | 2 | 196 | 19780 | 19586 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 5311 | 361 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22238563 | 22238563 | PRJNA577226_S_NODE_24918_length_251_cov_7.649533_g23979_i0 | PRJNA577226 | 24918 | 251 | 7.649533 | 19.20032783 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 464 | 2.47e-126 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g23979 | i0 | 100 | 60.8884462151394 | 251 | 0 | 100 | 0 | 1 | 251 | 4030 | 4280 | 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 | 15283 | 464 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22814814 | 22814814 | PRJNA577226_S_NODE_59618_length_162_cov_4.568000_g58679_i0 | PRJNA577226 | 59618 | 162 | 4.568 | 7.40016 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 294 | 2.03e-75 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g58679 | i0 | 99.383 | 8.26543209876543 | 162 | 1 | 100 | 0 | 1 | 162 | 4445 | 4284 | 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 | 1339 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24788435 | 24788435 | PRJNA577226_S_NODE_54380_length_169_cov_19.424242_g53441_i0 | PRJNA577226 | 54380 | 169 | 19.424242 | 32.82696898 | Golemanskia viscidula | 2898944 | Tubulinea | other_Eukaryota | 265 | 1.66e-66 | NTclustered | gi|2156866376|gb|OL677473.1| | 2898944 | g53441 | i0 | 94.706 | 100.278106508876 | 170 | 8 | 100 | 1 | 1 | 169 | 127 | 296 | Difflugia viscidula voucher 204 small subunit ribosomal RNA gene, partial sequence | blastn | 16947 | 265 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Difflugiidae | Golemanskia | Golemanskia viscidula | ||
| 25363420 | 25363420 | PRJNA577226_S_NODE_12600_length_365_cov_11.530488_g11661_i0 | PRJNA577226 | 12600 | 365 | 11.530488 | 42.0862812 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 658 | 0 | NTclustered | gi|2777861736|gb|PQ072230.1| | 5778 | g11661 | i0 | 99.18 | 100.279452054795 | 366 | 2 | 100 | 1 | 1 | 365 | 1195 | 1560 | Vermamoeba vermiformis strain CCAP_1534_12_consensus_sequence small subunit ribosomal RNA gene, partial sequence | blastn | 36602 | 658 | 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);;