contig_metadata
11 rows where bioproject = "PRJNA315314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 381082 | 381082 | PRJNA315314_S_NODE_701_length_910_cov_11.082860_g542_i0 | PRJNA315314 | 701 | 910 | 11.08286 | 100.854026 | root | 1 | Root_unresolved | Root_unresolved | 181 | 1.4899999999999999e-53 | NR | ABD46602.1 | 5778 | g542 | i0 | 69.7 | 1.60879120879121 | 119 | 36 | 39.2 | 0 | 409 | 53 | 1 | 119 | ABD46602.1 unknown, partial [Vermamoeba vermiformis] | diamond | 1464 | 182 | 0.994505494505495 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3615927 | 3615927 | PRJNA315314_S_NODE_26383_length_163_cov_21.537313_g26062_i0 | PRJNA315314 | 26383 | 163 | 21.537313 | 35.10582019 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 272 | 9.58e-69 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g26062 | i0 | 96.933 | 97.7055214723926 | 163 | 4 | 100 | 1 | 1 | 163 | 1494 | 1655 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 15926 | 274 | 0.992700729927007 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 5484183 | 5484183 | PRJNA315314_S_NODE_14925_length_211_cov_31.043956_g14604_i0 | PRJNA315314 | 14925 | 211 | 31.043956 | 65.50274716 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 359 | 9.749999999999999e-95 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g14604 | i0 | 97.156 | 61.3601895734597 | 211 | 6 | 100 | 0 | 1 | 211 | 154 | 364 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 12947 | 359 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 6168117 | 6168117 | PRJNA315314_S_NODE_21845_length_177_cov_54.783784_g21524_i0 | PRJNA315314 | 21845 | 177 | 54.783784 | 96.96729768 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 322 | 1.03e-83 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g21524 | i0 | 99.435 | 99.5480225988701 | 177 | 1 | 100 | 0 | 1 | 177 | 390 | 566 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 17620 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 11859509 | 11859509 | PRJNA315314_S_NODE_23030_length_173_cov_51.423611_g22709_i0 | PRJNA315314 | 23030 | 173 | 51.423611 | 88.96284703 | Lobosea sp. Borok | 297386 | Tubulinea | other_Eukaryota | 307 | 2.81e-79 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g22709 | i0 | 98.837 | 100.173410404624 | 172 | 2 | 99 | 0 | 1 | 172 | 1117 | 946 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 17330 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 18232351 | 18232351 | PRJNA315314_S_NODE_13915_length_219_cov_2.047368_g13594_i0 | PRJNA315314 | 13915 | 219 | 2.047368 | 4.48373592 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 163 | 8.58e-36 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g13594 | i0 | 84.024 | 53.4977168949772 | 169 | 27 | 77 | 0 | 1 | 169 | 39697 | 39865 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 11716 | 163 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19507105 | 19507105 | PRJNA315314_S_NODE_956_length_789_cov_9.560526_g542_i1 | PRJNA315314 | 956 | 789 | 9.560526 | 75.43255014 | root | 1 | Root_unresolved | Root_unresolved | 181 | 2.8499999999999996e-54 | NR | ABD46602.1 | 5778 | g542 | i1 | 69.7 | 2.31939163498099 | 119 | 36 | 45.2 | 0 | 409 | 53 | 1 | 119 | ABD46602.1 unknown, partial [Vermamoeba vermiformis] | diamond | 1830 | 182 | 0.994505494505495 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22057123 | 22057123 | PRJNA315314_S_NODE_11918_length_235_cov_8.980583_g11597_i0 | PRJNA315314 | 11918 | 235 | 8.980583 | 21.10437005 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 435 | 1.79e-117 | NTclustered | gi|399764168|gb|JQ271679.1| | 1215977 | g11597 | i0 | 100 | 61.0127659574468 | 235 | 0 | 100 | 0 | 1 | 235 | 166 | 400 | Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence | blastn | 14338 | 435 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 22057268 | 22057268 | PRJNA315314_S_NODE_1918_length_561_cov_14.924812_g1643_i0 | PRJNA315314 | 1918 | 561 | 14.924812 | 83.72819532 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 254 | 1.41e-62 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g1643 | i0 | 77.433 | 27.4010695187166 | 483 | 72 | 85 | 23 | 84 | 561 | 1554 | 1104 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15372 | 254 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 23333041 | 23333041 | PRJNA315314_S_NODE_579_length_991_cov_51.143451_g441_i0 | PRJNA315314 | 579 | 991 | 51.143451 | 506.83159941 | Tubulinea group 04 sp. P18 | 1215998 | Tubulinea | other_Eukaryota | 1814 | 0 | NTclustered | gi|399764278|gb|JQ271789.1| | 1215998 | g441 | i0 | 99.697 | 32.1220988900101 | 991 | 3 | 100 | 0 | 1 | 991 | 20 | 1010 | Tubulinea group 04 sp. P18 18S ribosomal RNA gene, partial sequence | blastn | 31833 | 1814 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea group 04 sp. P18 | ||||||
| 24606734 | 24606734 | PRJNA315314_S_NODE_1280_length_676_cov_29.165379_g1046_i0 | PRJNA315314 | 1280 | 676 | 29.165379 | 197.15796204 | uncultured Rhizamoeba | 1260765 | Tubulinea | other_Eukaryota | 357 | 1.28e-93 | NTclustered | gi|511487963|gb|JX898537.1| | 1260765 | g1046 | i0 | 84.252 | 24.3668639053254 | 381 | 45 | 55 | 11 | 54 | 424 | 1 | 376 | Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence | blastn | 16472 | 357 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | uncultured Rhizamoeba |
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);;