contig_metadata
15 rows where bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3971488 | 3971488 | PRJNA1000943_P_NODE_7524_length_300_cov_1.325991_g7386_i0 | PRJNA1000943 | 7524 | 300 | 1.325991 | 3.977973 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 486 | 6.459999999999999e-133 | NTclustered | gi|421976355|gb|JQ519494.1| | 5778 | g7386 | i0 | 95.987 | 0.996666666666667 | 299 | 12 | 99 | 0 | 2 | 300 | 517 | 219 | Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds | blastn | 299 | 486 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5247851 | 5247851 | PRJNA1000943_P_NODE_10305_length_261_cov_1.425532_g10167_i0 | PRJNA1000943 | 10305 | 261 | 1.425532 | 3.72063852 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 213 | 1.03e-50 | NTclustered | gi|61968712|gb|AY803788.1| | 5778 | g10167 | i0 | 87.302 | 2.17241379310345 | 189 | 21 | 72 | 2 | 73 | 261 | 927 | 742 | Hartmannella vermiformis vacuolar protein sorting protein 35-3 (VPS35-3) gene, partial cds | blastn | 567 | 213 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5247987 | 5247987 | PRJNA1000943_P_NODE_7365_length_302_cov_4.244541_g7227_i0 | PRJNA1000943 | 7365 | 302 | 4.244541 | 12.81851382 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 531 | 2.9599999999999993e-146 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g7227 | i0 | 98.344 | 20.450331125827802 | 302 | 5 | 100 | 0 | 1 | 302 | 7085 | 6784 | 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 | 6176 | 531 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7797635 | 7797635 | PRJNA1000943_P_NODE_15707_length_238_cov_2.387879_g15569_i0 | PRJNA1000943 | 15707 | 238 | 2.387879 | 5.68315202 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 120 | 2.66e-31 | NR | AFX84551.1 | 704142 | g15569 | i0 | 67.9 | 0.983193277310924 | 78 | 25 | 98.3 | 0 | 236 | 3 | 156 | 233 | AFX84551.1 alpha tubulin, partial [Saccamoeba lacustris] | diamond | 234 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 10348247 | 10348247 | PRJNA1000943_P_NODE_15169_length_243_cov_0.917647_g15031_i0 | PRJNA1000943 | 15169 | 243 | 0.917647 | 2.22988221 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 377 | 3.18e-100 | NTclustered | gi|423292048|gb|JQ519470.1| | 5778 | g15031 | i0 | 94.65 | 79.1028806584362 | 243 | 13 | 100 | 0 | 1 | 243 | 153 | 395 | Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds | blastn | 19222 | 377 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10348307 | 10348307 | PRJNA1000943_P_NODE_5769_length_334_cov_2.835249_g5631_i0 | PRJNA1000943 | 5769 | 334 | 2.835249 | 9.46973166 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 573 | 5.43e-159 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g5631 | i0 | 97.605 | 13.7784431137725 | 334 | 8 | 100 | 0 | 1 | 334 | 1631 | 1298 | 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 | 4602 | 573 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13752682 | 13752682 | PRJNA1000943_P_NODE_1011_length_741_cov_4.384731_g885_i0 | PRJNA1000943 | 1011 | 741 | 4.384731 | 32.49085671 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1321 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g885 | i0 | 98.919 | 95.9217273954116 | 740 | 7 | 99 | 1 | 1 | 739 | 4889 | 5628 | 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 | 71078 | 1321 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17996833 | 17996833 | PRJNA1000943_P_NODE_155_length_1519_cov_5.450899_g125_i0 | PRJNA1000943 | 155 | 1519 | 5.450899 | 82.79915581 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 771 | 6.69e-278 | NR | BAN33737.1 | 931554 | g125 | i0 | 81.7 | 3.63001974983542 | 464 | 79 | 90.5 | 1 | 1516 | 143 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5514 | 771 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 17996872 | 17996872 | PRJNA1000943_P_NODE_5495_length_342_cov_1.148699_g5357_i0 | PRJNA1000943 | 5495 | 342 | 1.148699 | 3.92855058 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 472 | 2.09e-128 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g5357 | i0 | 91.52 | 2 | 342 | 29 | 100 | 0 | 1 | 342 | 69 | 410 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 684 | 472 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20125803 | 20125803 | PRJNA1000943_P_NODE_6836_length_311_cov_3.441176_g6698_i0 | PRJNA1000943 | 6836 | 311 | 3.441176 | 10.70205736 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 558 | 1.3999999999999997e-154 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g6698 | i0 | 99.035 | 58.7942122186495 | 311 | 3 | 100 | 0 | 1 | 311 | 3879 | 3569 | 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 | 18285 | 558 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21821957 | 21821957 | PRJNA1000943_P_NODE_13558_length_246_cov_2.763006_g13420_i0 | PRJNA1000943 | 13558 | 246 | 2.763006 | 6.79699476 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 377 | 3.2300000000000003e-100 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g13420 | i0 | 94.309 | 7.36178861788618 | 246 | 14 | 100 | 0 | 1 | 246 | 394 | 639 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 1811 | 377 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23097355 | 23097355 | PRJNA1000943_P_NODE_6599_length_316_cov_5.687243_g6461_i0 | PRJNA1000943 | 6599 | 316 | 5.687243 | 17.97168788 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 579 | 1.0999999999999999e-160 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g6461 | i0 | 99.684 | 47.7721518987342 | 316 | 1 | 100 | 0 | 1 | 316 | 3436 | 3751 | 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 | 15096 | 579 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24371056 | 24371056 | PRJNA1000943_P_NODE_5280_length_348_cov_1.181818_g5142_i0 | PRJNA1000943 | 5280 | 348 | 1.181818 | 4.11272664 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 505 | 2.1e-138 | NTclustered | gi|146335208|gb|EF216680.1| | 5778 | g5142 | i0 | 92.816 | 1.19827586206897 | 348 | 25 | 100 | 0 | 1 | 348 | 1138 | 1485 | Hartmannella vermiformis transketolase mRNA, complete cds | blastn | 417 | 505 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29079767 | 29079767 | PRJNA1000943_P_NODE_3308_length_426_cov_1.014164_g3171_i0 | PRJNA1000943 | 3308 | 426 | 1.014164 | 4.32033864 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 2.21e-24 | NR | BAF75060.1 | 5775 | g3171 | i0 | 52 | 1.50704225352113 | 102 | 48 | 71.1 | 1 | 124 | 426 | 43 | 144 | BAF75060.1 aquaporin [Amoeba proteus] | diamond | 642 | 105 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30887465 | 30887465 | PRJNA1000943_P_NODE_8014_length_291_cov_2.862385_g7876_i0 | PRJNA1000943 | 8014 | 291 | 2.862385 | 8.32954035 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 124 | 2.07e-31 | NR | AAD37351.1 | 5775 | g7876 | i0 | 65.7 | 1.93814432989691 | 99 | 30 | 97.9 | 2 | 291 | 7 | 112 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 564 | 124 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;