contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 689122 | 689122 | PRJNA704949_P_NODE_1390761_length_211_cov_1.444444_g1375423_i0 | PRJNA704949 | 1390761 | 211 | 1.444444 | 3.04777684 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 390 | 3.459999999999999e-104 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1375423 | i0 | 100 | 10.1800947867299 | 211 | 0 | 100 | 0 | 1 | 211 | 36971 | 37181 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 2148 | 390 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1185452 | 1185452 | PRJNA704949_P_NODE_1057641_length_251_cov_2.282178_g1042305_i0 | PRJNA704949 | 1057641 | 251 | 2.282178 | 5.72826678 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 7.9e-27 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1042305 | i0 | 89.623 | 36.5139442231076 | 106 | 10 | 42 | 1 | 21 | 126 | 883 | 987 | 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 | 9165 | 135 | 0.992592592592593 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 1967615 | 1967615 | PRJNA704949_P_NODE_1692142_length_185_cov_2.382353_g1676803_i0 | PRJNA704949 | 1692142 | 185 | 2.382353 | 4.40735305 | Echinamoeba silvestris | 1215984 | Tubulinea | other_Eukaryota | 307 | 3.05e-79 | NTclustered | gi|399764170|gb|JQ271681.1| | 1215984 | g1676803 | i0 | 98.286 | 11.3783783783784 | 175 | 3 | 95 | 0 | 11 | 185 | 539 | 365 | Echinamoeba silvestris strain UKNCC:CCAP1519/1 18S ribosomal RNA gene, partial sequence | blastn | 2105 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba silvestris | |||
| 1967782 | 1967782 | PRJNA704949_P_NODE_1715362_length_184_cov_1.155556_g1700023_i0 | PRJNA704949 | 1715362 | 184 | 1.155556 | 2.12622304 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 335 | 1.3899999999999996e-87 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1700023 | i0 | 99.457 | 1 | 184 | 1 | 100 | 0 | 1 | 184 | 45264 | 45447 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 184 | 335 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 2466004 | 2466004 | PRJNA704949_P_NODE_868982_length_283_cov_3.474359_g853648_i0 | PRJNA704949 | 868982 | 283 | 3.474359 | 9.83243597 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 490 | 4.67e-134 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g853648 | i0 | 99.262 | 23.5441696113074 | 271 | 2 | 96 | 0 | 13 | 283 | 946 | 1216 | 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 | 6663 | 490 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4521834 | 4521834 | PRJNA704949_P_NODE_1948484_length_168_cov_2.554622_g1933145_i0 | PRJNA704949 | 1948484 | 168 | 2.554622 | 4.29176496 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 294 | 2.12e-75 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1933145 | i0 | 98.214 | 1 | 168 | 3 | 100 | 0 | 1 | 168 | 36664 | 36497 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 168 | 294 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5794077 | 5794077 | PRJNA704949_P_NODE_1570825_length_195_cov_1.123288_g1555486_i0 | PRJNA704949 | 1570825 | 195 | 1.123288 | 2.1904116 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 355 | 1.15e-93 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1555486 | i0 | 99.487 | 43.2871794871795 | 195 | 1 | 100 | 0 | 1 | 195 | 29274 | 29080 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 8441 | 355 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5798454 | 5798454 | PRJNA704949_P_NODE_2111985_length_164_cov_0.904348_g2096646_i0 | PRJNA704949 | 2111985 | 164 | 0.904348 | 1.48313072 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 272 | 9.65e-69 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g2096646 | i0 | 100 | 87.390243902439 | 147 | 0 | 90 | 0 | 18 | 164 | 37326 | 37180 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 14332 | 272 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5801005 | 5801005 | PRJNA704949_P_NODE_401445_length_429_cov_1.778947_g386333_i0 | PRJNA704949 | 401445 | 429 | 1.778947 | 7.63168263 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 782 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g386333 | i0 | 99.534 | 7.78554778554779 | 429 | 2 | 100 | 0 | 1 | 429 | 46966 | 46538 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 3340 | 782 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5801831 | 5801831 | PRJNA704949_P_NODE_490925_length_389_cov_1.376471_g475680_i0 | PRJNA704949 | 490925 | 389 | 1.376471 | 5.35447219 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 682 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g475680 | i0 | 100 | 23.6401028277635 | 369 | 0 | 95 | 0 | 1 | 369 | 1590 | 1222 | 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 | 9196 | 682 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5806094 | 5806094 | PRJNA704949_P_NODE_985605_length_262_cov_4.666667_g970270_i0 | PRJNA704949 | 985605 | 262 | 4.666667 | 12.22666754 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 442 | 1.2099999999999994e-119 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g970270 | i0 | 99.587 | 0.923664122137405 | 242 | 1 | 92 | 0 | 21 | 262 | 16975 | 16734 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 242 | 442 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8349607 | 8349607 | PRJNA704949_P_NODE_299327_length_491_cov_2.714932_g284528_i0 | PRJNA704949 | 299327 | 491 | 2.714932 | 13.33031612 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 854 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g284528 | i0 | 99.158 | 1.89002036659878 | 475 | 3 | 97 | 1 | 18 | 491 | 6277 | 5803 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 928 | 854 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8350283 | 8350283 | PRJNA704949_P_NODE_365987_length_448_cov_2.225564_g350955_i0 | PRJNA704949 | 365987 | 448 | 2.225564 | 9.97052672 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 822 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g350955 | i0 | 99.777 | 1.89285714285714 | 448 | 1 | 100 | 0 | 1 | 448 | 38934 | 38487 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 848 | 822 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10894974 | 10894974 | PRJNA704949_P_NODE_1612569_length_192_cov_1.055944_g1597230_i0 | PRJNA704949 | 1612569 | 192 | 1.055944 | 2.02741248 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 355 | 1.13e-93 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1597230 | i0 | 100 | 5.58333333333333 | 192 | 0 | 100 | 0 | 1 | 192 | 16049 | 16240 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 1072 | 355 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10897406 | 10897406 | PRJNA704949_P_NODE_1918029_length_169_cov_1.816667_g1902690_i0 | PRJNA704949 | 1918029 | 169 | 1.816667 | 3.07016723 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 278 | 2.14e-70 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1902690 | i0 | 100 | 1.5207100591716 | 150 | 0 | 89 | 0 | 1 | 150 | 29540 | 29391 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 257 | 278 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12171808 | 12171808 | PRJNA704949_P_NODE_1810430_length_177_cov_1.218750_g1795091_i0 | PRJNA704949 | 1810430 | 177 | 1.21875 | 2.1571875 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 327 | 2.2199999999999996e-85 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1795091 | i0 | 100 | 1 | 177 | 0 | 100 | 0 | 1 | 177 | 36956 | 36780 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 177 | 327 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12179553 | 12179553 | PRJNA704949_P_NODE_715210_length_318_cov_1.546468_g699881_i0 | PRJNA704949 | 715210 | 318 | 1.546468 | 4.91776824 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 580 | 3.0699999999999998e-161 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g699881 | i0 | 99.686 | 1 | 318 | 0 | 100 | 1 | 1 | 318 | 28834 | 28518 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 318 | 580 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17271849 | 17271849 | PRJNA704949_P_NODE_1992634_length_167_cov_1.322034_g1977295_i0 | PRJNA704949 | 1992634 | 167 | 1.322034 | 2.20779678 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 276 | 7.64e-70 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1977295 | i0 | 100 | 0.892215568862275 | 149 | 0 | 89 | 0 | 1 | 149 | 3421 | 3273 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 149 | 276 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17276359 | 17276359 | PRJNA704949_P_NODE_513854_length_380_cov_1.546828_g498582_i0 | PRJNA704949 | 513854 | 380 | 1.546828 | 5.8779464 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 697 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g498582 | i0 | 99.737 | 30.9236842105263 | 380 | 1 | 100 | 0 | 1 | 380 | 25627 | 26006 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 11751 | 697 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21090611 | 21090611 | PRJNA704949_P_NODE_1270877_length_224_cov_1.188571_g1255540_i0 | PRJNA704949 | 1270877 | 224 | 1.188571 | 2.66239904 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 414 | 2.1999999999999996e-111 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1255540 | i0 | 100 | 1 | 224 | 0 | 100 | 0 | 1 | 224 | 30213 | 30436 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 224 | 414 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22369711 | 22369711 | PRJNA704949_P_NODE_1803458_length_177_cov_1.625000_g1788119_i0 | PRJNA704949 | 1803458 | 177 | 1.625 | 2.87625 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 322 | 1.03e-83 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1788119 | i0 | 99.435 | 1.25988700564972 | 177 | 1 | 100 | 0 | 1 | 177 | 32019 | 31843 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 223 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22370306 | 22370306 | PRJNA704949_P_NODE_1876118_length_172_cov_1.691057_g1860779_i0 | PRJNA704949 | 1876118 | 172 | 1.691057 | 2.90861804 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 285 | 1.31e-72 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1860779 | i0 | 98.16 | 5.42441860465116 | 163 | 3 | 95 | 0 | 10 | 172 | 20646 | 20808 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 933 | 285 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24917084 | 24917084 | PRJNA704949_P_NODE_1586460_length_193_cov_3.680556_g1571121_i0 | PRJNA704949 | 1586460 | 193 | 3.680556 | 7.10347308 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 279 | 7.01e-71 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g1571121 | i0 | 94.086 | 11.4041450777202 | 186 | 8 | 95 | 1 | 11 | 193 | 50674 | 50859 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 2201 | 279 | 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);;