contig_metadata
15 rows where bioproject = "PRJNA1112809" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26687961 | 26687961 | PRJNA1112809_P_NODE_121661_length_295_cov_0.932432_g118386_i0 | PRJNA1112809 | 121661 | 295 | 0.932432 | 2.7506744 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 136 | 1.63e-36 | NR | DBA50491.1 | 3115894 | g118386 | i0 | 75.5 | 2.98983050847458 | 98 | 24 | 99.7 | 0 | 295 | 2 | 112 | 209 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 882 | 136 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 27415788 | 27415788 | PRJNA1112809_P_NODE_152063_length_261_cov_2.787234_g148788_i0 | PRJNA1112809 | 152063 | 261 | 2.787234 | 7.27468074 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 90.9 | 2.34e-19 | NR | DBA50491.1 | 3115894 | g148788 | i0 | 56.5 | 1.95402298850575 | 85 | 36 | 96.6 | 1 | 252 | 1 | 231 | 315 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 510 | 91.3 | 0.995618838992333 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28331074 | 28331074 | PRJNA1112809_P_NODE_109286_length_314_cov_1.095436_g106011_i0 | PRJNA1112809 | 109286 | 314 | 1.095436 | 3.43966904 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 75.1 | 7.77e-14 | NR | DAC81394.1 | 2609864 | g106011 | i0 | 66.1 | 0.535031847133758 | 56 | 19 | 53.5 | 0 | 313 | 146 | 176 | 231 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 168 | 75.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28552330 | 28552330 | PRJNA1112809_P_NODE_102987_length_325_cov_1.706349_g99712_i0 | PRJNA1112809 | 102987 | 325 | 1.706349 | 5.54563425 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 105 | 2.52e-24 | NR | DAC81401.1 | 2609864 | g99712 | i0 | 61.5 | 2.01230769230769 | 109 | 41 | 99.7 | 1 | 1 | 324 | 142 | 250 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 654 | 105 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28804508 | 28804508 | PRJNA1112809_P_NODE_107588_length_317_cov_0.823770_g104313_i0 | PRJNA1112809 | 107588 | 317 | 0.82377 | 2.6113509 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 84 | 6.91e-17 | NR | DBA50492.1 | 3115894 | g104313 | i0 | 56.9 | 1.36277602523659 | 72 | 31 | 68.1 | 0 | 74 | 289 | 10 | 81 | DBA50492.1 MAG TPA_asm: Penton [Adintovirus bos4377] | diamond | 432 | 84 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 29964342 | 29964342 | PRJNA1112809_P_NODE_160191_length_254_cov_1.563536_g156916_i0 | PRJNA1112809 | 160191 | 254 | 1.563536 | 3.97138144 | Viruses | 10239 | Viruses | Viruses | 68.9 | 1.25e-11 | NR | DAC81396.1 | 2609864 | g156916 | i0 | 59 | 1.88976377952756 | 78 | 32 | 92.1 | 0 | 3 | 236 | 6 | 83 | DAC81396.1 TPA_asm: acintoc2 [Pimephales minnow adintovirus] | diamond | 480 | 69.3 | 0.994227994227994 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30225810 | 30225810 | PRJNA1112809_P_NODE_153932_length_260_cov_1.160428_g150657_i0 | PRJNA1112809 | 153932 | 260 | 1.160428 | 3.0171128 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 107 | 1.94e-26 | NR | DAC81394.1 | 2609864 | g150657 | i0 | 61.2 | 0.980769230769231 | 85 | 33 | 98.1 | 0 | 257 | 3 | 62 | 146 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 255 | 107 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30352827 | 30352827 | PRJNA1112809_P_NODE_189572_length_242_cov_0.940828_g186297_i0 | PRJNA1112809 | 189572 | 242 | 0.940828 | 2.27680376 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 92.8 | 5.08e-21 | NR | DAC81394.1 | 2609864 | g186297 | i0 | 58.2 | 0.979338842975207 | 79 | 33 | 97.9 | 0 | 4 | 240 | 53 | 131 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 237 | 92.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30857775 | 30857775 | PRJNA1112809_P_NODE_99234_length_333_cov_0.907692_g95959_i0 | PRJNA1112809 | 99234 | 333 | 0.907692 | 3.02261436 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 128 | 2.89e-34 | NR | DAC81394.1 | 2609864 | g95959 | i0 | 55 | 2 | 111 | 50 | 100 | 0 | 333 | 1 | 67 | 177 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 666 | 129 | 0.992248062015504 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31426690 | 31426690 | PRJNA1112809_P_NODE_173856_length_248_cov_0.880000_g170581_i0 | PRJNA1112809 | 173856 | 248 | 0.88 | 2.1824 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 106 | 4.75e-25 | NR | DBA50499.1 | 3115894 | g170581 | i0 | 67.5 | 2.90322580645161 | 80 | 26 | 96.8 | 0 | 247 | 8 | 96 | 175 | DBA50499.1 MAG TPA_asm: PolBb, partial [Adintovirus bos4377] | diamond | 720 | 106 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 31711392 | 31711392 | PRJNA1112809_P_NODE_133337_length_281_cov_0.971154_g130062_i0 | PRJNA1112809 | 133337 | 281 | 0.971154 | 2.72894274 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 124 | 4.99e-32 | NR | DBA50491.1 | 3115894 | g130062 | i0 | 61.3 | 1.98576512455516 | 93 | 36 | 99.3 | 0 | 2 | 280 | 250 | 342 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 558 | 124 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 31774586 | 31774586 | PRJNA1112809_P_NODE_51937_length_526_cov_1.686534_g48672_i0 | PRJNA1112809 | 51937 | 526 | 1.686534 | 8.87116884 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 117 | 1.02e-28 | NR | DBA50496.1 | 3115894 | g48672 | i0 | 48.6 | 0.844106463878327 | 148 | 76 | 84.4 | 0 | 11 | 454 | 61 | 208 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 444 | 117 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 31901146 | 31901146 | PRJNA1112809_P_NODE_113057_length_307_cov_2.658120_g109782_i0 | PRJNA1112809 | 113057 | 307 | 2.65812 | 8.1604284 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 115 | 3.3e-28 | NR | DBA50491.1 | 3115894 | g109782 | i0 | 66.7 | 2.93159609120521 | 102 | 34 | 99.7 | 0 | 2 | 307 | 131 | 232 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 900 | 115 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 32691451 | 32691451 | PRJNA1112809_P_NODE_120820_length_296_cov_1.282511_g117545_i0 | PRJNA1112809 | 120820 | 296 | 1.282511 | 3.79623256 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 87.4 | 6.83e-18 | NR | DAC81401.1 | 2609864 | g117545 | i0 | 58.3 | 2.18918918918919 | 72 | 30 | 73 | 0 | 76 | 291 | 1 | 72 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 648 | 87.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32849001 | 32849001 | PRJNA1112809_P_NODE_192420_length_241_cov_1.226190_g189145_i0 | PRJNA1112809 | 192420 | 241 | 1.22619 | 2.9551179 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 93.6 | 2.09e-21 | NR | DBA50340.1 | 2609864 | g189145 | i0 | 52.5 | 2.98755186721992 | 80 | 38 | 99.6 | 0 | 241 | 2 | 72 | 151 | DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764] | diamond | 720 | 93.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;