contig_metadata
16 rows where bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838774 | 838774 | PRJNA849822_P_NODE_7521_length_558_cov_1.484536_g7349_i0 | PRJNA849822 | 7521 | 558 | 1.484536 | 8.28371088 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 569 | 1.2299999999999996e-157 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g7349 | i0 | 85.231 | 24.6111111111111 | 562 | 73 | 100 | 8 | 1 | 558 | 25835 | 26390 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 13733 | 569 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3389233 | 3389233 | PRJNA849822_P_NODE_15483_length_369_cov_1.844595_g15309_i0 | PRJNA849822 | 15483 | 369 | 1.844595 | 6.80655555 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 499 | 1.04e-136 | NTclustered | gi|146335208|gb|EF216680.1| | 5778 | g15309 | i0 | 91.105 | 1.00542005420054 | 371 | 29 | 100 | 4 | 1 | 369 | 1418 | 1786 | Hartmannella vermiformis transketolase mRNA, complete cds | blastn | 371 | 499 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3389260 | 3389260 | PRJNA849822_P_NODE_18723_length_334_cov_1.754789_g18549_i0 | PRJNA849822 | 18723 | 334 | 1.754789 | 5.86099526 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 424 | 5.79e-114 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g18549 | i0 | 89.412 | 1.01796407185629 | 340 | 30 | 100 | 4 | 1 | 334 | 1018 | 679 | 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 | 340 | 424 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 4666992 | 4666992 | PRJNA849822_P_NODE_15384_length_370_cov_2.942761_g15210_i0 | PRJNA849822 | 15384 | 370 | 2.942761 | 10.8882157 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 483 | 1.05e-131 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g15210 | i0 | 95.38 | 57.3054054054054 | 303 | 14 | 82 | 0 | 68 | 370 | 20055 | 20357 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 21203 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5941839 | 5941839 | PRJNA849822_P_NODE_29745_length_268_cov_1.200000_g29571_i0 | PRJNA849822 | 29745 | 268 | 1.2 | 3.216 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 198 | 2.9799999999999998e-46 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g29571 | i0 | 83.258 | 85.25 | 221 | 31 | 81 | 5 | 23 | 238 | 28119 | 27900 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 22847 | 198 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7611593 | 7611593 | PRJNA849822_P_NODE_4086_length_791_cov_18.732591_g3923_i0 | PRJNA849822 | 4086 | 791 | 18.732591 | 148.17479481 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1406 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g3923 | i0 | 98.736 | 88.8445006321112 | 791 | 10 | 100 | 0 | 1 | 791 | 5689 | 4899 | 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 | 70276 | 1406 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11042185 | 11042185 | PRJNA849822_P_NODE_17249_length_349_cov_1.753623_g17075_i0 | PRJNA849822 | 17249 | 349 | 1.753623 | 6.12014427 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 442 | 1.6699999999999993e-119 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g17075 | i0 | 93.046 | 1.73065902578797 | 302 | 21 | 87 | 0 | 48 | 349 | 1 | 302 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 604 | 442 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13592403 | 13592403 | PRJNA849822_P_NODE_3871_length_816_cov_3.577389_g3712_i0 | PRJNA849822 | 3871 | 816 | 3.577389 | 29.19149424 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1203 | 0 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g3712 | i0 | 96.311 | 4.125 | 732 | 27 | 90 | 0 | 2 | 733 | 732 | 1 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 3366 | 1203 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14866611 | 14866611 | PRJNA849822_P_NODE_27192_length_279_cov_2.786408_g27018_i0 | PRJNA849822 | 27192 | 279 | 2.786408 | 7.77407832 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 99 | 3.25e-16 | NTclustered | gi|89357437|gb|DQ407656.1| | 5778 | g27018 | i0 | 100 | 0.189964157706093 | 53 | 0 | 19 | 0 | 1 | 53 | 358 | 410 | Hartmannella vermiformis chitinase-like protein cluster A mRNA, partial cds | blastn | 53 | 99 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16141221 | 16141221 | PRJNA849822_P_NODE_10553_length_458_cov_2.774026_g10380_i0 | PRJNA849822 | 10553 | 458 | 2.774026 | 12.70503908 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 697 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g10380 | i0 | 94.105 | 1 | 458 | 27 | 100 | 0 | 1 | 458 | 666 | 209 | 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 | 458 | 697 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16141299 | 16141299 | PRJNA849822_P_NODE_21013_length_316_cov_1.283951_g20839_i0 | PRJNA849822 | 21013 | 316 | 1.283951 | 4.05728516 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 435 | 2.5100000000000003e-117 | NTclustered | gi|88601123|gb|DQ390348.1| | 5778 | g20839 | i0 | 91.456 | 1 | 316 | 27 | 100 | 0 | 1 | 316 | 361 | 46 | Hartmannella vermiformis lactate dehydrogenase-like protein mRNA, partial cds | blastn | 316 | 435 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18689788 | 18689788 | PRJNA849822_P_NODE_10115_length_470_cov_1.934509_g9942_i0 | PRJNA849822 | 10115 | 470 | 1.934509 | 9.0921923 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 473 | 8.229999999999999e-129 | NTclustered | gi|88601207|gb|DQ384272.1| | 5778 | g9942 | i0 | 91.988 | 0.717021276595745 | 337 | 27 | 72 | 0 | 134 | 470 | 14 | 350 | Hartmannella vermiformis unknown mRNA | blastn | 337 | 473 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19965010 | 19965010 | PRJNA849822_P_NODE_216_length_2608_cov_3.486391_g193_i0 | PRJNA849822 | 216 | 2608 | 3.486391 | 90.92507728 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1234 | 0 | NTclustered | gi|421976355|gb|JQ519494.1| | 5778 | g193 | i0 | 94.71 | 63.1288343558282 | 794 | 42 | 30 | 0 | 452 | 1245 | 1 | 794 | Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds | blastn | 164640 | 1234 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19965076 | 19965076 | PRJNA849822_P_NODE_28816_length_272_cov_1.371859_g28642_i0 | PRJNA849822 | 28816 | 272 | 1.371859 | 3.73145648 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 398 | 2.7799999999999997e-106 | NTclustered | gi|146335208|gb|EF216680.1| | 5778 | g28642 | i0 | 93.609 | 0.977941176470588 | 266 | 17 | 98 | 0 | 1 | 266 | 316 | 581 | Hartmannella vermiformis transketolase mRNA, complete cds | blastn | 266 | 398 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21240633 | 21240633 | PRJNA849822_P_NODE_22537_length_305_cov_1.681034_g22363_i0 | PRJNA849822 | 22537 | 305 | 1.681034 | 5.1271537 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 436 | 6.719999999999999e-118 | NTclustered | gi|66270666|gb|AY950658.1| | 5778 | g22363 | i0 | 92.459 | 1.95409836065574 | 305 | 23 | 100 | 0 | 1 | 305 | 324 | 20 | Hartmannella vermiformis Nop58p mRNA, partial cds | blastn | 596 | 436 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27970880 | 27970880 | PRJNA849822_P_NODE_26605_length_282_cov_1.492823_g26431_i0 | PRJNA849822 | 26605 | 282 | 1.492823 | 4.20976086 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 160 | 1.9e-43 | NR | ABD62815.1 | 5778 | g26431 | i0 | 81.7 | 0.98936170212766 | 93 | 17 | 98.9 | 0 | 2 | 280 | 351 | 443 | ABD62815.1 mitochondrial single-subunit RNA polymerase [Vermamoeba vermiformis] | diamond | 279 | 160 | 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);;