contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3508989 | 3508989 | PRJNA980839_P_NODE_201163_length_250_cov_1.231638_g197379_i0 | PRJNA980839 | 201163 | 250 | 1.231638 | 3.079095 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 217 | 7.59e-52 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g197379 | i0 | 85.446 | 0.852 | 213 | 26 | 85 | 1 | 2 | 214 | 9721 | 9928 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 213 | 217 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5098495 | 5098495 | PRJNA980839_P_NODE_200364_length_250_cov_1.740113_g196580_i0 | PRJNA980839 | 200364 | 250 | 1.740113 | 4.3502825 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 451 | 1.91e-122 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g196580 | i0 | 99.2 | 7.012 | 250 | 2 | 100 | 0 | 1 | 250 | 3601 | 3850 | 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 | 1753 | 451 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6060127 | 6060127 | PRJNA980839_P_NODE_121185_length_323_cov_0.984000_g117401_i0 | PRJNA980839 | 121185 | 323 | 0.984 | 3.17832 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 547 | 3.1699999999999985e-151 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g117401 | i0 | 97.214 | 36.0061919504644 | 323 | 9 | 100 | 0 | 1 | 323 | 7051 | 6729 | 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 | 11630 | 547 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6060566 | 6060566 | PRJNA980839_P_NODE_141505_length_295_cov_3.207207_g137721_i0 | PRJNA980839 | 141505 | 295 | 3.207207 | 9.46126065 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 518 | 2.25e-142 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g137721 | i0 | 98.311 | 103.698305084746 | 296 | 4 | 100 | 1 | 1 | 295 | 28138 | 27843 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 30591 | 518 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6060911 | 6060911 | PRJNA980839_P_NODE_159705_length_279_cov_1.024272_g155921_i0 | PRJNA980839 | 159705 | 279 | 1.024272 | 2.85771888 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 161 | 4.0899999999999995e-35 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g155921 | i0 | 78.74 | 3.63082437275986 | 254 | 45 | 89 | 6 | 32 | 279 | 1837 | 2087 | Rhizamoeba saxonica 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 | 1013 | 161 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 6063873 | 6063873 | PRJNA980839_P_NODE_91525_length_384_cov_1.109325_g87741_i0 | PRJNA980839 | 91525 | 384 | 1.109325 | 4.259808 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 374 | 6.889999999999998e-99 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g87741 | i0 | 84.496 | 17.8880208333333 | 387 | 51 | 100 | 7 | 1 | 384 | 26270 | 25890 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 6869 | 374 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7334391 | 7334391 | PRJNA980839_P_NODE_110706_length_340_cov_1.947566_g106922_i0 | PRJNA980839 | 110706 | 340 | 1.947566 | 6.6217244 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 265 | 3.79e-66 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g106922 | i0 | 81.609 | 28.0882352941176 | 348 | 39 | 96 | 21 | 2 | 328 | 3879 | 4222 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 9550 | 265 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7335239 | 7335239 | PRJNA980839_P_NODE_150806_length_286_cov_1.906103_g147022_i0 | PRJNA980839 | 150806 | 286 | 1.906103 | 5.45145458 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 291 | 5.15e-74 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g147022 | i0 | 85.017 | 1.22027972027972 | 287 | 41 | 100 | 2 | 1 | 286 | 17973 | 17688 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 349 | 291 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7337684 | 7337684 | PRJNA980839_P_NODE_55666_length_555_cov_2.006224_g51908_i0 | PRJNA980839 | 55666 | 555 | 2.006224 | 11.1345432 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 830 | 0 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g51908 | i0 | 93.716 | 86.954954954955 | 557 | 30 | 100 | 4 | 1 | 555 | 26821 | 26268 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 48260 | 830 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12439204 | 12439204 | PRJNA980839_P_NODE_67310_length_479_cov_1.605911_g63528_i0 | PRJNA980839 | 67310 | 479 | 1.605911 | 7.69231369 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 584 | 3.7199999999999985e-162 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g63528 | i0 | 88.773 | 2.0125260960334 | 481 | 49 | 100 | 5 | 1 | 479 | 28335 | 28812 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 964 | 584 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12439557 | 12439557 | PRJNA980839_P_NODE_84930_length_404_cov_1.350453_g81146_i0 | PRJNA980839 | 84930 | 404 | 1.350453 | 5.45583012 | Centropyxis laevigata | 318528 | Tubulinea | other_Eukaryota | 736 | 0 | NTclustered | gi|61655689|gb|AY848965.1| | 318528 | g81146 | i0 | 99.505 | 43.9628712871287 | 404 | 2 | 100 | 0 | 1 | 404 | 439 | 36 | Centropyxis laevigata small subunit ribosomal RNA gene, partial sequence | blastn | 17761 | 736 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Centropyxidae | Centropyxis | Centropyxis laevigata | ||
| 13713818 | 13713818 | PRJNA980839_P_NODE_72771_length_452_cov_1.593668_g68987_i0 | PRJNA980839 | 72771 | 452 | 1.593668 | 7.20337936 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 270 | 1.11e-67 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g68987 | i0 | 77.655 | 1 | 452 | 95 | 99 | 6 | 2 | 450 | 41134 | 40686 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 452 | 270 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14984580 | 14984580 | PRJNA980839_P_NODE_114912_length_333_cov_1.292308_g111128_i0 | PRJNA980839 | 114912 | 333 | 1.292308 | 4.30338564 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 217 | 1.05e-51 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g111128 | i0 | 80.399 | 1.78978978978979 | 301 | 45 | 89 | 8 | 1 | 297 | 2098 | 2388 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 596 | 217 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14986462 | 14986462 | PRJNA980839_P_NODE_207572_length_248_cov_2.885714_g203788_i0 | PRJNA980839 | 207572 | 248 | 2.885714 | 7.15657072 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 431 | 2.47e-116 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g203788 | i0 | 97.984 | 97.625 | 248 | 5 | 100 | 0 | 1 | 248 | 20625 | 20378 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 24211 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14987512 | 14987512 | PRJNA980839_P_NODE_43472_length_683_cov_1.732787_g39797_i0 | PRJNA980839 | 43472 | 683 | 1.732787 | 11.83493521 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 483 | 2.04e-131 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g39797 | i0 | 80.308 | 2.43484626647145 | 650 | 119 | 95 | 8 | 1 | 647 | 22143 | 22786 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 1663 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15297691 | 15297691 | PRJNA980839_P_NODE_128652_length_312_cov_1.117155_g124868_i0 | PRJNA980839 | 128652 | 312 | 1.117155 | 3.4855236 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 549 | 8.489999999999997e-152 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g124868 | i0 | 98.397 | 83.1634615384615 | 312 | 5 | 100 | 0 | 1 | 312 | 4917 | 5228 | 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 | 25947 | 549 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17535978 | 17535978 | PRJNA980839_P_NODE_182894_length_261_cov_0.984043_g179110_i0 | PRJNA980839 | 182894 | 261 | 0.984043 | 2.56835223 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 254 | 6.08e-63 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g179110 | i0 | 92.265 | 1.39080459770115 | 181 | 10 | 68 | 2 | 83 | 259 | 25694 | 25874 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 363 | 254 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18812355 | 18812355 | PRJNA980839_P_NODE_92875_length_380_cov_1.671010_g89091_i0 | PRJNA980839 | 92875 | 380 | 1.67101 | 6.349838 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 196 | 1.58e-45 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g89091 | i0 | 88.82 | 1.28684210526316 | 161 | 16 | 42 | 2 | 217 | 377 | 41605 | 41763 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 489 | 196 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21362672 | 21362672 | PRJNA980839_P_NODE_92797_length_380_cov_2.120521_g89013_i0 | PRJNA980839 | 92797 | 380 | 2.120521 | 8.0579798 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 521 | 2.3e-143 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g89013 | i0 | 95.679 | 0.852631578947368 | 324 | 14 | 85 | 0 | 1 | 324 | 327 | 4 | 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 | 324 | 521 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23912690 | 23912690 | PRJNA980839_P_NODE_66599_length_483_cov_1.595122_g62817_i0 | PRJNA980839 | 66599 | 483 | 1.595122 | 7.70443926 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 839 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g62817 | i0 | 98.137 | 54.9130434782609 | 483 | 5 | 100 | 3 | 1 | 483 | 2682 | 3160 | 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 | 26523 | 839 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25185526 | 25185526 | PRJNA980839_P_NODE_247160_length_216_cov_11.258741_g243376_i0 | PRJNA980839 | 247160 | 216 | 11.258741 | 24.31888056 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 233 | 6.34e-57 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g243376 | i0 | 86.364 | 6.02777777777778 | 220 | 23 | 100 | 6 | 1 | 216 | 51232 | 51448 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 1302 | 233 | 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);;