contig_metadata
17 rows where bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 831038 | 831038 | PRJNA841653_P_NODE_6521_length_666_cov_700.158516_g5883_i0 | PRJNA841653 | 6521 | 666 | 700.158516 | 4663.05571656 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1206 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g5883 | i0 | 99.697 | 46.7417417417417 | 659 | 2 | 99 | 0 | 1 | 659 | 2898 | 2240 | 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 | 31130 | 1206 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 3782577 | 3782577 | PRJNA841653_P_NODE_28783_length_303_cov_862.939130_g28109_i0 | PRJNA841653 | 28783 | 303 | 862.93913 | 2614.7055639 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 497 | 3.0199999999999993e-136 | NTclustered | gi|2806326577|gb|PQ345827.1| | 5778 | g28109 | i0 | 100 | 88.7788778877888 | 269 | 0 | 89 | 0 | 35 | 303 | 117 | 385 | Vermamoeba vermiformis isolate 8FSa small subunit ribosomal RNA gene, partial sequence | blastn | 26900 | 497 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5933246 | 5933246 | PRJNA841653_P_NODE_14485_length_432_cov_2.598886_g13814_i0 | PRJNA841653 | 14485 | 432 | 2.598886 | 11.22718752 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 483 | 1.2499999999999999e-131 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g13814 | i0 | 87.067 | 10.525462962963 | 433 | 48 | 99 | 8 | 1 | 430 | 1042 | 615 | 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 | 4547 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7208706 | 7208706 | PRJNA841653_P_NODE_34706_length_278_cov_710.375610_g34032_i0 | PRJNA841653 | 34706 | 278 | 710.37561 | 1974.8441958 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 486 | 5.919999999999998e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g34032 | i0 | 99.257 | 44.9640287769784 | 269 | 2 | 97 | 0 | 10 | 278 | 3405 | 3673 | 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 | 12500 | 486 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8482852 | 8482852 | PRJNA841653_P_NODE_12267_length_473_cov_2.922500_g11596_i0 | PRJNA841653 | 12267 | 473 | 2.9225 | 13.823425 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 719 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g11596 | i0 | 94.492 | 68.3150105708245 | 472 | 17 | 98 | 7 | 9 | 473 | 19979 | 20448 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 32313 | 719 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8883929 | 8883929 | PRJNA841653_P_NODE_49767_length_247_cov_11.333333_g49093_i0 | PRJNA841653 | 49767 | 247 | 11.333333 | 27.99333251 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 87.9 | 6.12e-13 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g49093 | i0 | 91.935 | 18.0971659919028 | 62 | 5 | 25 | 0 | 6 | 67 | 5548 | 5609 | 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 | 4470 | 87.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9758986 | 9758986 | PRJNA841653_P_NODE_60448_length_242_cov_0.911243_g59774_i0 | PRJNA841653 | 60448 | 242 | 0.911243 | 2.20520806 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 340 | 4.15e-89 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g59774 | i0 | 92.116 | 0.995867768595041 | 241 | 19 | 99 | 0 | 2 | 242 | 374 | 614 | 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 | 241 | 340 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11434781 | 11434781 | PRJNA841653_P_NODE_9269_length_553_cov_7.675000_g8603_i0 | PRJNA841653 | 9269 | 553 | 7.675 | 42.44275 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 872 | 0 | NTclustered | gi|54306228|gb|AY626163.1| | 297386 | g8603 | i0 | 95.772 | 77.6491862567812 | 544 | 18 | 98 | 5 | 1 | 542 | 1102 | 562 | Lobosea sp. Borok small subunit ribosomal RNA gene, partial sequence | blastn | 42940 | 872 | 1 | Eukaryota | Amoebozoa | Tubulinea | Lobosea sp. Borok | ||||||
| 12710323 | 12710323 | PRJNA841653_P_NODE_29570_length_299_cov_1306.743363_g28896_i0 | PRJNA841653 | 29570 | 299 | 1306.743363 | 3907.16265537 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 529 | 1.0499999999999996e-145 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g28896 | i0 | 100 | 50.0100334448161 | 286 | 0 | 96 | 0 | 14 | 299 | 948 | 1233 | 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 | 14953 | 529 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 12710622 | 12710622 | PRJNA841653_P_NODE_9370_length_549_cov_9.693277_g8704_i0 | PRJNA841653 | 9370 | 549 | 9.693277 | 53.21609073 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 1007 | 0 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g8704 | i0 | 100 | 79.9872495446266 | 545 | 0 | 99 | 0 | 5 | 549 | 605 | 1149 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 43913 | 1007 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 16133329 | 16133329 | PRJNA841653_P_NODE_41153_length_257_cov_1.521739_g40479_i0 | PRJNA841653 | 41153 | 257 | 1.521739 | 3.91086923 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 403 | 5.599999999999998e-108 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g40479 | i0 | 95.276 | 47.727626459144 | 254 | 12 | 99 | 0 | 1 | 254 | 27737 | 27484 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 12266 | 403 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18682287 | 18682287 | PRJNA841653_P_NODE_60815_length_241_cov_64.404762_g60141_i0 | PRJNA841653 | 60815 | 241 | 64.404762 | 155.21547642 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 387 | 5.24e-103 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g60141 | i0 | 95.833 | 32.8215767634855 | 240 | 8 | 99 | 2 | 1 | 239 | 4201 | 3963 | Vermamoeba sp. isolate 22 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 7910 | 387 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 21232140 | 21232140 | PRJNA841653_P_NODE_15037_length_423_cov_11.262857_g14366_i0 | PRJNA841653 | 15037 | 423 | 11.262857 | 47.64188511 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 425 | 2.08e-114 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g14366 | i0 | 85.646 | 1.99054373522459 | 418 | 45 | 97 | 14 | 1 | 411 | 26004 | 25595 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 842 | 425 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22507817 | 22507817 | PRJNA841653_P_NODE_62898_length_239_cov_48.945783_g62224_i0 | PRJNA841653 | 62898 | 239 | 48.945783 | 116.98042137 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 416 | 6.609999999999999e-112 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g62224 | i0 | 99.561 | 101.627615062762 | 228 | 1 | 95 | 0 | 1 | 228 | 2242 | 2015 | 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 | 24289 | 416 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22908053 | 22908053 | PRJNA841653_P_NODE_15618_length_415_cov_29.546784_g14946_i0 | PRJNA841653 | 15618 | 415 | 29.546784 | 122.6191536 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 739 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g14946 | i0 | 99.507 | 21.944578313253 | 406 | 2 | 98 | 0 | 1 | 406 | 1630 | 1225 | 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 | 9107 | 739 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25056218 | 25056218 | PRJNA841653_P_NODE_13480_length_449_cov_3.007979_g12809_i0 | PRJNA841653 | 13480 | 449 | 3.007979 | 13.50582571 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 512 | 1.66e-140 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g12809 | i0 | 87.919 | 0.99554565701559 | 447 | 38 | 99 | 13 | 1 | 445 | 623 | 191 | 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 | 447 | 512 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25056297 | 25056297 | PRJNA841653_P_NODE_17940_length_385_cov_84.262821_g17268_i0 | PRJNA841653 | 17940 | 385 | 84.262821 | 324.41186085 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 667 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g17268 | i0 | 98.67 | 44.9376623376623 | 376 | 5 | 98 | 0 | 10 | 385 | 6674 | 7049 | 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 | 17301 | 667 | 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);;