contig_metadata
18 rows where bioproject = "PRJNA285816", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4887119 | 4887119 | PRJNA285816_S_NODE_5844_length_286_cov_302.000000_g5742_i0 | PRJNA285816 | 5844 | 286 | 302 | 863.72 | root | 1 | Root_unresolved | Root_unresolved | 135 | 2.5500000000000003e-27 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g5742 | i0 | 82.822 | 12.6223776223776 | 163 | 16 | 53 | 6 | 1 | 152 | 3399 | 3560 | 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 | 3610 | 135 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8025151 | 8025151 | PRJNA285816_S_NODE_1167_length_604_cov_5.565766_g1076_i0 | PRJNA285816 | 1167 | 604 | 5.565766 | 33.61722664 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 416 | 1.84e-111 | NTclustered | gi|421976335|gb|JQ519484.1| | 5778 | g1076 | i0 | 80.141 | 81.0132450331126 | 569 | 103 | 93 | 9 | 22 | 585 | 253 | 816 | Vermamoeba vermiformis clone JGHverm1 beta-tubulin gene, partial cds | blastn | 48932 | 416 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8711794 | 8711794 | PRJNA285816_S_NODE_11747_length_217_cov_467.416667_g11645_i0 | PRJNA285816 | 11747 | 217 | 467.416667 | 1014.29416739 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 383 | 5.98e-102 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g11645 | i0 | 99.524 | 96.9124423963134 | 210 | 1 | 97 | 0 | 1 | 210 | 1676 | 1467 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 21030 | 383 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 14400887 | 14400887 | PRJNA285816_S_NODE_1412_length_550_cov_11.429142_g1315_i0 | PRJNA285816 | 1412 | 550 | 11.429142 | 62.860281 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 186 | 5.259999999999998e-54 | NR | AAP88974.1 | 5775 | g1315 | i0 | 77.5 | 3.72 | 111 | 25 | 60.5 | 0 | 2 | 334 | 278 | 388 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 2046 | 187 | 0.994652406417112 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 15674839 | 15674839 | PRJNA285816_S_NODE_4193_length_332_cov_4.462898_g4091_i0 | PRJNA285816 | 4193 | 332 | 4.462898 | 14.81682136 | Centropyxis laevigata | 318528 | Tubulinea | other_Eukaryota | 608 | 1.479999999999999e-169 | NTclustered | gi|61655689|gb|AY848965.1| | 318528 | g4091 | i0 | 99.699 | 6.94578313253012 | 332 | 1 | 100 | 0 | 1 | 332 | 37 | 368 | Centropyxis laevigata small subunit ribosomal RNA gene, partial sequence | blastn | 2306 | 608 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Centropyxidae | Centropyxis | Centropyxis laevigata | ||
| 16361599 | 16361599 | PRJNA285816_S_NODE_1393_length_555_cov_312.798419_g1297_i0 | PRJNA285816 | 1393 | 555 | 312.798419 | 1736.03122545 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 821 | 0 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g1297 | i0 | 93.502 | 78.2738738738739 | 554 | 33 | 99 | 3 | 2 | 553 | 620 | 1172 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 43442 | 821 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 18910572 | 18910572 | PRJNA285816_S_NODE_20255_length_179_cov_333.776923_g20153_i0 | PRJNA285816 | 20255 | 179 | 333.776923 | 597.46069217 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 320 | 3.76e-83 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g20153 | i0 | 98.889 | 100.245810055866 | 180 | 1 | 100 | 1 | 1 | 179 | 1478 | 1299 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 17944 | 320 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 24011083 | 24011083 | PRJNA285816_S_NODE_379_length_954_cov_20.555801_g331_i0 | PRJNA285816 | 379 | 954 | 20.555801 | 196.10234154 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 283 | 9.82e-92 | NR | AAY21191.1 | 5778 | g331 | i0 | 63.6 | 0.742138364779874 | 236 | 85 | 74.2 | 1 | 111 | 818 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 708 | 283 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24598167 | 24598167 | PRJNA285816_S_NODE_25480_length_167_cov_0.881356_g25378_i0 | PRJNA285816 | 25480 | 167 | 0.881356 | 1.47186452 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 97.1 | 9.89e-22 | NR | AKT93973.1 | 5778 | g25378 | i0 | 78.8 | 1.86826347305389 | 52 | 11 | 93.4 | 0 | 1 | 156 | 114 | 165 | AKT93973.1 NADH dehydrogenase subunit 11 [Vermamoeba vermiformis] | diamond | 312 | 97.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26947475 | 26947475 | PRJNA285816_S_NODE_29222_length_162_cov_1.345133_g29120_i0 | PRJNA285816 | 29222 | 162 | 1.345133 | 2.17911546 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 64.7 | 2.27e-10 | NR | AKN09691.1 | 5775 | g29120 | i0 | 50 | 2 | 54 | 27 | 100 | 0 | 162 | 1 | 754 | 807 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 324 | 64.7 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27168740 | 27168740 | PRJNA285816_S_NODE_14082_length_204_cov_2.012903_g13980_i0 | PRJNA285816 | 14082 | 204 | 2.012903 | 4.10632212 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 104 | 3.3e-24 | NR | ABD62815.1 | 5778 | g13980 | i0 | 77.6 | 0.985294117647059 | 67 | 15 | 98.5 | 0 | 203 | 3 | 714 | 780 | ABD62815.1 mitochondrial single-subunit RNA polymerase [Vermamoeba vermiformis] | diamond | 201 | 104 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28053172 | 28053172 | PRJNA285816_S_NODE_2045_length_463_cov_1.425121_g1943_i0 | PRJNA285816 | 2045 | 463 | 1.425121 | 6.59831023 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 229 | 3.23e-73 | NR | ABD46560.1 | 5778 | g1943 | i0 | 75.2 | 0.965442764578834 | 149 | 37 | 96.5 | 0 | 15 | 461 | 1 | 149 | ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis] | diamond | 447 | 229 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28084761 | 28084761 | PRJNA285816_S_NODE_29265_length_162_cov_1.168142_g29163_i0 | PRJNA285816 | 29265 | 162 | 1.168142 | 1.89239004 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 88.2 | 1.03e-18 | NR | BAN33737.1 | 931554 | g29163 | i0 | 81.1 | 19.6296296296296 | 53 | 10 | 98.1 | 0 | 160 | 2 | 11 | 63 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 3180 | 88.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 30422082 | 30422082 | PRJNA285816_S_NODE_493_length_859_cov_6.423457_g439_i0 | PRJNA285816 | 493 | 859 | 6.423457 | 55.17749563 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 190 | 3.6999999999999994e-57 | NR | ABD72565.1 | 5778 | g439 | i0 | 64.2 | 0.478463329452852 | 137 | 49 | 47.8 | 0 | 127 | 537 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 411 | 190 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31622714 | 31622714 | PRJNA285816_S_NODE_30656_length_152_cov_2.019417_g30554_i0 | PRJNA285816 | 30656 | 152 | 2.019417 | 3.06951384 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 53.9 | 1.05e-6 | NR | AFX73097.1 | 704142 | g30554 | i0 | 58.1 | 2.54605263157895 | 43 | 18 | 84.9 | 0 | 129 | 1 | 145 | 187 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 387 | 53.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 31717636 | 31717636 | PRJNA285816_S_NODE_1117_length_615_cov_20.628975_g1030_i0 | PRJNA285816 | 1117 | 615 | 20.628975 | 126.86819625 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 172 | 3.14e-51 | NR | ABD72565.1 | 5778 | g1030 | i0 | 59 | 0.678048780487805 | 139 | 55 | 67.8 | 1 | 118 | 534 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 417 | 172 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32445595 | 32445595 | PRJNA285816_S_NODE_7759_length_255_cov_1.975728_g7657_i0 | PRJNA285816 | 7759 | 255 | 1.975728 | 5.0381064 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 126 | 2.66e-34 | NR | ABD46563.1 | 5778 | g7657 | i0 | 69.9 | 1.95294117647059 | 83 | 24 | 97.6 | 1 | 6 | 254 | 46 | 127 | ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis] | diamond | 498 | 126 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32872750 | 32872750 | PRJNA285816_S_NODE_10160_length_229_cov_2.772222_g10058_i0 | PRJNA285816 | 10160 | 229 | 2.772222 | 6.34838838 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 5.469999999999999e-38 | NR | AAX57202.1 | 5778 | g10058 | i0 | 91.4 | 6.74672489082969 | 70 | 6 | 91.7 | 0 | 229 | 20 | 59 | 128 | AAX57202.1 vacuolar protein sorting protein 26, partial [Vermamoeba vermiformis] | diamond | 1545 | 132 | 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);;