contig_metadata
12 rows where bioproject = "PRJNA983848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 970204 | 970204 | PRJNA983848_P_NODE_65961_length_393_cov_125.787500_g60078_i0 | PRJNA983848 | 65961 | 393 | 125.7875 | 494.344875 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 693 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g60078 | i0 | 98.473 | 35.2213740458015 | 393 | 6 | 100 | 0 | 1 | 393 | 6704 | 7096 | 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 | 13842 | 693 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 971137 | 971137 | PRJNA983848_P_NODE_91161_length_319_cov_34.500000_g85278_i0 | PRJNA983848 | 91161 | 319 | 34.5 | 110.055 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 590 | 5.1299999999999986e-164 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g85278 | i0 | 100 | 46.1379310344828 | 319 | 0 | 100 | 0 | 1 | 319 | 3430 | 3748 | 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 | 14718 | 590 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8622379 | 8622379 | PRJNA983848_P_NODE_42307_length_571_cov_2.052209_g36457_i0 | PRJNA983848 | 42307 | 571 | 2.052209 | 11.71811339 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 673 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g36457 | i0 | 88.153 | 1.00525394045534 | 574 | 56 | 100 | 12 | 1 | 571 | 331 | 895 | 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 | 574 | 673 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8622809 | 8622809 | PRJNA983848_P_NODE_54407_length_456_cov_4.736292_g48528_i0 | PRJNA983848 | 54407 | 456 | 4.736292 | 21.59749152 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 719 | 0 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g48528 | i0 | 95.207 | 59.1776315789474 | 459 | 15 | 100 | 5 | 1 | 456 | 20542 | 20088 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 26985 | 719 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8623226 | 8623226 | PRJNA983848_P_NODE_65567_length_395_cov_2.655280_g59684_i0 | PRJNA983848 | 65567 | 395 | 2.65528 | 10.488356 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 396 | 1.52e-105 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g59684 | i0 | 85.176 | 2.0126582278481 | 398 | 46 | 99 | 12 | 3 | 395 | 25601 | 25990 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 795 | 396 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11173627 | 11173627 | PRJNA983848_P_NODE_66449_length_391_cov_157.144654_g60566_i0 | PRJNA983848 | 66449 | 391 | 157.144654 | 614.43559714 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 695 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g60566 | i0 | 98.721 | 9.0460358056266 | 391 | 5 | 100 | 0 | 1 | 391 | 1256 | 1646 | 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 | 3537 | 695 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11475318 | 11475318 | PRJNA983848_P_NODE_61809_length_412_cov_198.300885_g55927_i0 | PRJNA983848 | 61809 | 412 | 198.300885 | 816.9996462 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 749 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g55927 | i0 | 99.513 | 35.422330097087404 | 411 | 2 | 99 | 0 | 1 | 411 | 2435 | 2845 | 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 | 14594 | 749 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13720762 | 13720762 | PRJNA983848_P_NODE_128991_length_262_cov_2.873016_g123108_i0 | PRJNA983848 | 128991 | 262 | 2.873016 | 7.52730192 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 379 | 9.649999999999998e-101 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g123108 | i0 | 92.748 | 1.9618320610687 | 262 | 19 | 100 | 0 | 1 | 262 | 28044 | 28305 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 514 | 379 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17849178 | 17849178 | PRJNA983848_P_NODE_166574_length_221_cov_38.452703_g160691_i0 | PRJNA983848 | 166574 | 221 | 38.452703 | 84.98047363 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 401 | 1.6899999999999995e-107 | NTclustered | gi|2806326577|gb|PQ345827.1| | 5778 | g160691 | i0 | 99.548 | 100 | 221 | 0 | 100 | 1 | 1 | 221 | 361 | 142 | Vermamoeba vermiformis isolate 8FSa small subunit ribosomal RNA gene, partial sequence | blastn | 22100 | 401 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20092804 | 20092804 | PRJNA983848_P_NODE_105696_length_293_cov_2.045455_g99813_i0 | PRJNA983848 | 105696 | 293 | 2.045455 | 5.99318315 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 486 | 6.2799999999999984e-133 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g99813 | i0 | 96.587 | 60.3310580204778 | 293 | 10 | 100 | 0 | 1 | 293 | 27067 | 27359 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 17677 | 486 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21372247 | 21372247 | PRJNA983848_P_NODE_62477_length_409_cov_4.669643_g56595_i0 | PRJNA983848 | 62477 | 409 | 4.669643 | 19.09883987 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 616 | 1.11e-171 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g56595 | i0 | 94.279 | 14.9242053789731 | 402 | 23 | 98 | 0 | 8 | 409 | 26933 | 26532 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 6104 | 616 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22949358 | 22949358 | PRJNA983848_P_NODE_75718_length_358_cov_4.677193_g69835_i0 | PRJNA983848 | 75718 | 358 | 4.677193 | 16.74435094 | root | 1 | Root_unresolved | Root_unresolved | 595 | 1.2499999999999995e-165 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g69835 | i0 | 96.648 | 46.7793296089385 | 358 | 12 | 100 | 0 | 1 | 358 | 19556 | 19913 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 16747 | 595 | 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);;