contig_metadata
11 rows where bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4866588 | 4866588 | PRJNA1160211_S_NODE_229004_length_280_cov_13.048309_g227771_i0 | PRJNA1160211 | 229004 | 280 | 13.048309 | 36.5352652 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 307 | 4.9900000000000007e-79 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g227771 | i0 | 88.672 | 50.2071428571429 | 256 | 24 | 91 | 4 | 1 | 256 | 1881 | 1631 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 14058 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 5412020 | 5412020 | PRJNA1160211_S_NODE_105025_length_447_cov_527.149733_g103798_i0 | PRJNA1160211 | 105025 | 447 | 527.149733 | 2356.35930651 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 527 | 5.899999999999998e-145 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g103798 | i0 | 98.653 | 29.8232662192394 | 297 | 4 | 66 | 0 | 76 | 372 | 5480 | 5776 | 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 | 13331 | 527 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6688207 | 6688207 | PRJNA1160211_S_NODE_284386_length_239_cov_16.638554_g283153_i0 | PRJNA1160211 | 284386 | 239 | 16.638554 | 39.76614406 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 394 | 3.099999999999999e-105 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g283153 | i0 | 99.537 | 2.2928870292887 | 216 | 1 | 90 | 0 | 1 | 216 | 3667 | 3452 | 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 | 548 | 394 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9966736 | 9966736 | PRJNA1160211_S_NODE_247228_length_264_cov_2.188482_g245995_i0 | PRJNA1160211 | 247228 | 264 | 2.188482 | 5.77759248 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 449 | 7.320000000000001e-122 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g245995 | i0 | 98.431 | 47.9545454545455 | 255 | 4 | 97 | 0 | 1 | 255 | 5121 | 5375 | 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 | 12660 | 449 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10512797 | 10512797 | PRJNA1160211_S_NODE_115709_length_428_cov_56.707042_g114480_i0 | PRJNA1160211 | 115709 | 428 | 56.707042 | 242.70613976 | Tubulinea group 04 sp. PPD16 | 1215999 | Tubulinea | other_Eukaryota | 420 | 9.819999999999999e-113 | NTclustered | gi|399764279|gb|JQ271790.1| | 1215999 | g114480 | i0 | 89.244 | 53.2172897196262 | 344 | 25 | 79 | 10 | 25 | 360 | 1468 | 1807 | Tubulinea group 04 sp. PPD16 18S ribosomal RNA gene, partial sequence | blastn | 22777 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. PPD16 | ||||||
| 11241372 | 11241372 | PRJNA1160211_S_NODE_121689_length_418_cov_6.359420_g120460_i0 | PRJNA1160211 | 121689 | 418 | 6.35942 | 26.5823756 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 508 | 1.99e-139 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g120460 | i0 | 92.201 | 55.3444976076555 | 359 | 28 | 86 | 0 | 1 | 359 | 1162 | 804 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 23134 | 508 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 12516775 | 12516775 | PRJNA1160211_S_NODE_102110_length_453_cov_3.752632_g100884_i0 | PRJNA1160211 | 102110 | 453 | 3.752632 | 16.99942296 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 586 | 9.729999999999998e-163 | NTclustered | gi|399764264|gb|JQ271775.1| | 1215986 | g100884 | i0 | 91.435 | 39.3377483443709 | 432 | 30 | 95 | 6 | 1 | 430 | 580 | 154 | Tubulinea group 02 sp. 1HFKJ 18S ribosomal RNA gene, partial sequence | blastn | 17820 | 590 | 0.993220338983051 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 02 sp. 1HFKJ | ||||||
| 14338311 | 14338311 | PRJNA1160211_S_NODE_154252_length_368_cov_23.467797_g153019_i0 | PRJNA1160211 | 154252 | 368 | 23.467797 | 86.36149296 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 327 | 5.19e-85 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g153019 | i0 | 86.601 | 1.47010869565217 | 306 | 29 | 82 | 10 | 58 | 357 | 1 | 300 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 541 | 327 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba | |||
| 15065860 | 15065860 | PRJNA1160211_S_NODE_124652_length_413_cov_10.111765_g123423_i0 | PRJNA1160211 | 124652 | 413 | 10.111765 | 41.76158945 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 699 | 0 | NTclustered | gi|11527309|gb|AF293902.1|AF293902 | 136464 | g123423 | i0 | 98.974 | 93.089588377724 | 390 | 4 | 94 | 0 | 24 | 413 | 848 | 1237 | Saccamoeba limax small subunit ribosomal RNA gene, complete sequence | blastn | 38446 | 704 | 0.992897727272727 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba limax | ||
| 16340964 | 16340964 | PRJNA1160211_S_NODE_204553_length_305_cov_16.879310_g203320_i0 | PRJNA1160211 | 204553 | 305 | 16.87931 | 51.4818955 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 514 | 3.02e-141 | NTclustered | gi|24527245|gb|AY145442.1| | 211864 | g203320 | i0 | 97.059 | 83.2327868852459 | 306 | 7 | 100 | 2 | 1 | 305 | 1816 | 1512 | Hartmannellidae sp. LOS7N/I small subunit ribosomal RNA gene, complete sequence | blastn | 25386 | 514 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannellidae sp. LOS7N/I | |||
| 20710370 | 20710370 | PRJNA1160211_S_NODE_106097_length_445_cov_81.231183_g104869_i0 | PRJNA1160211 | 106097 | 445 | 81.231183 | 361.47876435 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 366 | 1.3499999999999996e-96 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g104869 | i0 | 82.588 | 16.638202247191 | 425 | 64 | 95 | 9 | 1 | 422 | 26007 | 25590 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 7404 | 366 | 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);;