contig_metadata
9 rows where bioproject = "PRJNA812715", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7602894 | 7602894 | PRJNA812715_P_NODE_13146_length_1051_cov_8.889571_g11846_i0 | PRJNA812715 | 13146 | 1051 | 8.889571 | 93.42939121 | root | 1 | Root_unresolved | Root_unresolved | 1941 | 0 | NTclustered | gi|2648012127|gb|PP068615.1| | 10515 | g11846 | i0 | 100 | 100.001902949572 | 1051 | 0 | 100 | 0 | 1 | 1051 | 18316 | 17266 | Human adenovirus 2 isolate HAdV-C2/USA/5R6/2010, complete genome | blastn | 105102 | 1941 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 17802596 | 17802596 | PRJNA812715_P_NODE_50574_length_379_cov_2.535948_g48777_i0 | PRJNA812715 | 50574 | 379 | 2.535948 | 9.61124292 | root | 1 | Root_unresolved | Root_unresolved | 701 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g48777 | i0 | 100 | 100 | 379 | 0 | 100 | 0 | 1 | 379 | 16736 | 17114 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 37900 | 701 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 19076377 | 19076377 | PRJNA812715_P_NODE_11295_length_1174_cov_2.498638_g10143_i0 | PRJNA812715 | 11295 | 1174 | 2.498638 | 29.33401012 | root | 1 | Root_unresolved | Root_unresolved | 2146 | 0 | NTclustered | gi|2452971169|gb|OQ518290.1| | 10515 | g10143 | i0 | 99.659 | 100.046848381601 | 1174 | 4 | 100 | 0 | 1 | 1174 | 15583 | 16756 | Human adenovirus 2 isolate HAdV-C2/USA/2E10/2009, complete genome | blastn | 117455 | 2146 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 22902518 | 22902518 | PRJNA812715_P_NODE_33938_length_504_cov_300.819026_g32157_i0 | PRJNA812715 | 33938 | 504 | 300.819026 | 1516.12789104 | root | 1 | Root_unresolved | Root_unresolved | 915 | 0 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g32157 | i0 | 100 | 98.2142857142857 | 495 | 0 | 98 | 0 | 4 | 498 | 14729 | 15223 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 49500 | 915 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 25451635 | 25451635 | PRJNA812715_P_NODE_46000_length_404_cov_229.012085_g44204_i0 | PRJNA812715 | 46000 | 404 | 229.012085 | 925.2088234 | root | 1 | Root_unresolved | Root_unresolved | 732 | 0 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g44204 | i0 | 99.749 | 98.7623762376238 | 399 | 1 | 99 | 0 | 1 | 399 | 11551 | 11153 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 39900 | 737 | 0.993215739484396 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 28002036 | 28002036 | PRJNA812715_P_NODE_16585_length_882_cov_2.184178_g15101_i0 | PRJNA812715 | 16585 | 882 | 2.184178 | 19.26444996 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 89.7 | 6.85e-17 | NR | DAC81404.1 | 2609864 | g15101 | i0 | 30.8 | 1.47959183673469 | 169 | 115 | 56.8 | 2 | 330 | 830 | 17 | 185 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 1305 | 90.5 | 0.991160220994475 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28159995 | 28159995 | PRJNA812715_P_NODE_99345_length_254_cov_1.690608_g97544_i0 | PRJNA812715 | 99345 | 254 | 1.6906080000000001 | 4.29414432 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 109 | 1.24e-27 | NR | DBA46914.1 | 3115887 | g97544 | i0 | 65 | 0.94488188976378 | 80 | 27 | 94.5 | 1 | 242 | 3 | 1 | 79 | DBA46914.1 MAG TPA_asm: PacK [Adintovirus androctonus13035] | diamond | 240 | 109 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 28728111 | 28728111 | PRJNA812715_P_NODE_14567_length_975_cov_4.294900_g13176_i0 | PRJNA812715 | 14567 | 975 | 4.2949 | 41.875275 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 61.6 | 8.15e-7 | NR | DAC81404.1 | 2609864 | g13176 | i0 | 28.6 | 1.26769230769231 | 119 | 84 | 36.3 | 1 | 36 | 389 | 17 | 135 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 1236 | 61.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29864736 | 29864736 | PRJNA812715_P_NODE_14671_length_970_cov_4.031215_g13176_i1 | PRJNA812715 | 14671 | 970 | 4.031215 | 39.1027855 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 60.8 | 1.47e-6 | NR | DAC81404.1 | 2609864 | g13176 | i1 | 28.4 | 0.64639175257732 | 116 | 82 | 35.6 | 1 | 40 | 384 | 20 | 135 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 627 | 60.8 | 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);;