contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA407368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1081762 | 1081762 | PRJNA407368_S_NODE_4341_length_274_cov_22.053061_g4239_i0 | PRJNA407368 | 4341 | 274 | 22.053061 | 60.42538714 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 507 | 4.47e-139 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4239 | i0 | 100 | 37 | 274 | 0 | 100 | 0 | 1 | 274 | 1219 | 946 | 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 | 10138 | 507 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 2357135 | 2357135 | PRJNA407368_S_NODE_4322_length_275_cov_59.516260_g4220_i0 | PRJNA407368 | 4322 | 275 | 59.51626 | 163.669715 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 363 | 1.03e-95 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g4220 | i0 | 92.218 | 58.2072727272727 | 257 | 19 | 93 | 1 | 3 | 258 | 4544 | 4288 | 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 | 16007 | 363 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 2965934 | 2965934 | PRJNA407368_S_NODE_8903_length_169_cov_36.092857_g8801_i0 | PRJNA407368 | 8903 | 169 | 36.092857 | 60.99692833 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 287 | 3.55e-73 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g8801 | i0 | 97.076 | 96.9822485207101 | 171 | 3 | 100 | 2 | 1 | 169 | 2267 | 2437 | 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 | 16390 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 6792731 | 6792731 | PRJNA407368_S_NODE_1326_length_549_cov_65.444231_g1239_i0 | PRJNA407368 | 1326 | 549 | 65.444231 | 359.28882819 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 566 | 1.56e-156 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g1239 | i0 | 100 | 60.8670309653916 | 306 | 0 | 100 | 0 | 244 | 549 | 586 | 891 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 33416 | 566 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 7459648 | 7459648 | PRJNA407368_S_NODE_5506_length_232_cov_5.251232_g5404_i0 | PRJNA407368 | 5506 | 232 | 5.251232 | 12.18285824 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 429 | 8.2e-116 | NTclustered | gi|2806326577|gb|PQ345827.1| | 5778 | g5404 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 377 | 146 | Vermamoeba vermiformis isolate 8FSa small subunit ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7459669 | 7459669 | PRJNA407368_S_NODE_8046_length_180_cov_59.715232_g7944_i0 | PRJNA407368 | 8046 | 180 | 59.715232 | 107.4874176 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 287 | 3.85e-73 | NTclustered | gi|1016841274|gb|KU746981.1| | 5778 | g7944 | i0 | 100 | 86.1111111111111 | 155 | 0 | 86 | 0 | 26 | 180 | 178 | 24 | Vermamoeba vermiformis isolate SSH23 18S ribosomal RNA gene, partial sequence | blastn | 15500 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10009764 | 10009764 | PRJNA407368_S_NODE_2148_length_419_cov_82.374359_g2047_i0 | PRJNA407368 | 2148 | 419 | 82.374359 | 345.14856421 | root | 1 | Root_unresolved | Root_unresolved | 691 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g2047 | i0 | 96.852 | 40.7016706443914 | 413 | 13 | 99 | 0 | 1 | 413 | 19520 | 19932 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 17054 | 691 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11285000 | 11285000 | PRJNA407368_S_NODE_5869_length_223_cov_3.396907_g5767_i0 | PRJNA407368 | 5869 | 223 | 3.396907 | 7.57510261 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 368 | 1.73e-97 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g5767 | i0 | 96.413 | 40.9641255605381 | 223 | 8 | 100 | 0 | 1 | 223 | 1213 | 1435 | 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 | 9135 | 368 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11893922 | 11893922 | PRJNA407368_S_NODE_4030_length_288_cov_57.212355_g3928_i0 | PRJNA407368 | 4030 | 288 | 57.212355 | 164.7715824 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 444 | 3.76e-120 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g3928 | i0 | 94.483 | 43.8055555555556 | 290 | 13 | 100 | 3 | 1 | 288 | 3918 | 4206 | 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 | 12616 | 444 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 13168892 | 13168892 | PRJNA407368_S_NODE_6071_length_218_cov_3.264550_g5969_i0 | PRJNA407368 | 6071 | 218 | 3.26455 | 7.116719 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 209 | 1.08e-49 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5969 | i0 | 84.977 | 0.977064220183486 | 213 | 25 | 97 | 7 | 8 | 218 | 827 | 620 | 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 | 213 | 209 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14444025 | 14444025 | PRJNA407368_S_NODE_5052_length_247_cov_4.761468_g4950_i0 | PRJNA407368 | 5052 | 247 | 4.761468 | 11.76082596 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 211 | 3.48e-50 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g4950 | i0 | 82.731 | 1.63157894736842 | 249 | 32 | 100 | 6 | 1 | 247 | 26819 | 27058 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 403 | 211 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 15717787 | 15717787 | PRJNA407368_S_NODE_4353_length_274_cov_4.138776_g4251_i0 | PRJNA407368 | 4353 | 274 | 4.138776 | 11.34024624 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 405 | 1.68e-108 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g4251 | i0 | 97.872 | 42.5510948905109 | 235 | 4 | 100 | 1 | 41 | 274 | 6728 | 6962 | 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 | 11659 | 405 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16384141 | 16384141 | PRJNA407368_S_NODE_7913_length_182_cov_60.803922_g7811_i0 | PRJNA407368 | 7913 | 182 | 60.803922 | 110.66313804 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 331 | 1.7800000000000002e-86 | NTclustered | gi|1345606837|gb|MG969829.1| | 5778 | g7811 | i0 | 99.451 | 100.038461538462 | 182 | 1 | 100 | 0 | 1 | 182 | 197 | 378 | Vermamoeba vermiformis isolate Hart1f small subunit ribosomal RNA gene, partial sequence | blastn | 18207 | 331 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19540798 | 19540798 | PRJNA407368_S_NODE_1876_length_453_cov_192.978774_g1778_i0 | PRJNA407368 | 1876 | 453 | 192.978774 | 874.19384622 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 460 | 6.16e-125 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1778 | i0 | 99.603 | 2.51655629139073 | 252 | 1 | 100 | 0 | 202 | 453 | 3416 | 3667 | 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 | 1140 | 460 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 19540895 | 19540895 | PRJNA407368_S_NODE_6196_length_215_cov_18.032258_g6094_i0 | PRJNA407368 | 6196 | 215 | 18.032258 | 38.7693547 | Vermamoeba sp. | 1972851 | Tubulinea | other_Eukaryota | 392 | 9.83e-105 | NTclustered | gi|2651357782|gb|PP174298.1| | 1972851 | g6094 | i0 | 99.535 | 98.2558139534884 | 215 | 1 | 100 | 0 | 1 | 215 | 3311 | 3097 | 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 | 21125 | 392 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba sp. | ||||
| 20816694 | 20816694 | PRJNA407368_S_NODE_2577_length_377_cov_51.514368_g2475_i0 | PRJNA407368 | 2577 | 377 | 51.514368 | 194.20916736 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 665 | 0 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g2475 | i0 | 100 | 22.7612732095491 | 360 | 0 | 95 | 0 | 18 | 377 | 1706 | 1347 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 8581 | 665 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 20816713 | 20816713 | PRJNA407368_S_NODE_337_length_1102_cov_17.371855_g305_i0 | PRJNA407368 | 337 | 1102 | 17.371855 | 191.4378421 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 725 | 0 | NTclustered | gi|399764168|gb|JQ271679.1| | 1215977 | g305 | i0 | 98.54 | 29.9582577132486 | 411 | 5 | 37 | 1 | 693 | 1102 | 3 | 413 | Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence | blastn | 33014 | 725 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 22091579 | 22091579 | PRJNA407368_S_NODE_5018_length_248_cov_4.173516_g4916_i0 | PRJNA407368 | 5018 | 248 | 4.173516 | 10.35031968 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 248 | 2.67e-61 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g4916 | i0 | 86.076 | 0.955645161290323 | 237 | 26 | 94 | 6 | 15 | 248 | 25765 | 25997 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 237 | 248 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22091595 | 22091595 | PRJNA407368_S_NODE_5738_length_226_cov_6.167513_g5636_i0 | PRJNA407368 | 5738 | 226 | 6.167513 | 13.93857938 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 322 | 1.39e-83 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g5636 | i0 | 95.098 | 75.2654867256637 | 204 | 10 | 90 | 0 | 1 | 204 | 28025 | 28228 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 17010 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22758613 | 22758613 | PRJNA407368_S_NODE_1238_length_566_cov_98.875233_g1154_i0 | PRJNA407368 | 1238 | 566 | 98.875233 | 559.63381878 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 898 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1154 | i0 | 99.593 | 26.7809187279152 | 492 | 2 | 87 | 0 | 32 | 523 | 2410 | 2901 | 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 | 15158 | 898 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24641598 | 24641598 | PRJNA407368_S_NODE_8900_length_169_cov_132.278571_g8798_i0 | PRJNA407368 | 8900 | 169 | 132.278571 | 223.55078499 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 267 | 4.63e-67 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g8798 | i0 | 96.875 | 96.1775147928994 | 160 | 4 | 95 | 1 | 2 | 161 | 3818 | 3660 | 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 | 16254 | 267 | 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);;