contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9743029 | 9743029 | PRJNA812715_P_NODE_98048_length_256_cov_1.683060_g96247_i0 | PRJNA812715 | 98048 | 256 | 1.68306 | 4.3086336 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 64.7 | 8e-10 | NR | AAK29054.1 | 1891767 | g96247 | i0 | 70.5 | 0.515625 | 44 | 13 | 51.6 | 0 | 64 | 195 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 64.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 10153295 | 10153295 | PRJNA812715_P_NODE_110928_length_246_cov_1.572254_g109127_i0 | PRJNA812715 | 110928 | 246 | 1.572254 | 3.86774484 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 62.4 | 4.64e-9 | NR | AAK29054.1 | 1891767 | g109127 | i0 | 70.5 | 0.536585365853659 | 44 | 13 | 53.7 | 0 | 168 | 37 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 62.4 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 26705851 | 26705851 | PRJNA812715_P_NODE_101021_length_251_cov_4.426966_g99220_i0 | PRJNA812715 | 101021 | 251 | 4.426966 | 11.11168466 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 55.1 | 1.82e-6 | NR | AAK29054.1 | 1891767 | g99220 | i0 | 63.6 | 0.525896414342629 | 44 | 16 | 52.6 | 0 | 167 | 36 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 55.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 27243978 | 27243978 | PRJNA812715_P_NODE_68003_length_311_cov_5.365546_g66203_i0 | PRJNA812715 | 68003 | 311 | 5.365546 | 16.68684806 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 66.6 | 3.29e-10 | NR | AAK29054.1 | 1891767 | g66203 | i0 | 73.8 | 0.405144694533762 | 42 | 11 | 40.5 | 0 | 123 | 248 | 494 | 535 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 126 | 66.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 27370746 | 27370746 | PRJNA812715_P_NODE_84463_length_277_cov_1.813725_g82663_i0 | PRJNA812715 | 84463 | 277 | 1.813725 | 5.02401825 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 60.1 | 4.41e-8 | NR | AAK29054.1 | 1891767 | g82663 | i0 | 72.5 | 0.433212996389892 | 40 | 11 | 43.3 | 0 | 146 | 265 | 498 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 120 | 60.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 27654748 | 27654748 | PRJNA812715_P_NODE_54104_length_362_cov_2.650519_g52305_i0 | PRJNA812715 | 54104 | 362 | 2.650519 | 9.59487878 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 42 | 0.021 | NR | AAF28272.1 | 1891767 | g52305 | i0 | 80 | 0.207182320441989 | 25 | 5 | 20.7 | 0 | 287 | 361 | 28 | 52 | AAF28272.1 large t antigen, partial [Betapolyomavirus macacae] | diamond | 75 | 42 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 27812676 | 27812676 | PRJNA812715_P_NODE_123504_length_231_cov_5.575949_g121703_i0 | PRJNA812715 | 123504 | 231 | 5.575949 | 12.88044219 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 50.4 | 6.18e-5 | NR | AAK29054.1 | 1891767 | g121703 | i0 | 64.1 | 0.506493506493506 | 39 | 14 | 50.6 | 0 | 120 | 4 | 494 | 532 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 117 | 50.4 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 28831486 | 28831486 | PRJNA812715_P_NODE_56628_length_351_cov_9.028777_g54829_i0 | PRJNA812715 | 56628 | 351 | 9.028777 | 31.69100727 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 3.34e-4 | NR | AAD55993.1 | 1891767 | g54829 | i0 | 64.3 | 1.74358974358974 | 28 | 10 | 23.9 | 0 | 157 | 240 | 75 | 102 | AAD55993.1 large T antigen, partial [Betapolyomavirus macacae] | diamond | 612 | 47.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 28917268 | 28917268 | PRJNA812715_P_NODE_122908_length_235_cov_2.925926_g121107_i0 | PRJNA812715 | 122908 | 235 | 2.925926 | 6.8759261 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 53.1 | 6.91e-6 | NR | AAK29054.1 | 1891767 | g121107 | i0 | 65.1 | 0.548936170212766 | 43 | 15 | 54.9 | 0 | 173 | 45 | 495 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 129 | 53.1 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 29738221 | 29738221 | PRJNA812715_P_NODE_93750_length_262_cov_3.021164_g91949_i0 | PRJNA812715 | 93750 | 262 | 3.021164 | 7.91544968 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 63.9 | 1.61e-9 | NR | AAK29054.1 | 1891767 | g91949 | i0 | 72.7 | 0.50381679389313 | 44 | 12 | 50.4 | 0 | 130 | 261 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 63.9 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 29801518 | 29801518 | PRJNA812715_P_NODE_76131_length_290_cov_4.838710_g74331_i0 | PRJNA812715 | 76131 | 290 | 4.83871 | 14.032259 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 56.6 | 8.44e-7 | NR | AAK29054.1 | 1891767 | g74331 | i0 | 68.2 | 0.455172413793103 | 44 | 14 | 45.5 | 0 | 149 | 280 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 56.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30117398 | 30117398 | PRJNA812715_P_NODE_62512_length_329_cov_4.109375_g60713_i0 | PRJNA812715 | 62512 | 329 | 4.109375 | 13.51984375 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 61.6 | 2.33e-8 | NR | AAK29054.1 | 1891767 | g60713 | i0 | 71.4 | 0.382978723404255 | 42 | 12 | 38.3 | 0 | 133 | 258 | 494 | 535 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 126 | 61.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30244067 | 30244067 | PRJNA812715_P_NODE_97012_length_258_cov_1.162162_g95211_i0 | PRJNA812715 | 97012 | 258 | 1.162162 | 2.99837796 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 56.2 | 7.7e-7 | NR | AAK29054.1 | 1891767 | g95211 | i0 | 68.4 | 0.441860465116279 | 38 | 12 | 44.2 | 0 | 113 | 226 | 498 | 535 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 114 | 56.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30465379 | 30465379 | PRJNA812715_P_NODE_118313_length_242_cov_1.822485_g116512_i0 | PRJNA812715 | 118313 | 242 | 1.822485 | 4.4104137 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 58.2 | 1.33e-7 | NR | AAK29054.1 | 1891767 | g116512 | i0 | 75.7 | 0.45867768595041303 | 37 | 9 | 45.9 | 0 | 112 | 2 | 494 | 530 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 111 | 58.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30465415 | 30465415 | PRJNA812715_P_NODE_86793_length_273_cov_4.480000_g84992_i0 | PRJNA812715 | 86793 | 273 | 4.48 | 12.2304 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 51.2 | 5.37e-5 | NR | AAK29054.1 | 1891767 | g84992 | i0 | 61.4 | 0.483516483516484 | 44 | 17 | 48.4 | 0 | 212 | 81 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 132 | 51.2 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30875829 | 30875829 | PRJNA812715_P_NODE_94974_length_261_cov_1.085106_g93173_i0 | PRJNA812715 | 94974 | 261 | 1.085106 | 2.83212666 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 61.6 | 1.01e-8 | NR | AAK29054.1 | 1891767 | g93173 | i0 | 75 | 0.459770114942529 | 40 | 10 | 46 | 0 | 182 | 63 | 498 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 120 | 61.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 32393930 | 32393930 | PRJNA812715_P_NODE_64679_length_322_cov_1.811245_g62879_i0 | PRJNA812715 | 64679 | 322 | 1.811245 | 5.8322089 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 55.8 | 2.31e-6 | NR | AAK29054.1 | 1891767 | g62879 | i0 | 65.9 | 0.885093167701863 | 44 | 15 | 41 | 0 | 238 | 107 | 494 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 285 | 55.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 32709443 | 32709443 | PRJNA812715_P_NODE_122140_length_240_cov_2.281437_g120339_i0 | PRJNA812715 | 122140 | 240 | 2.281437 | 5.4754488 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 46.6 | 0.00153 | NR | AAK29054.1 | 1891767 | g120339 | i0 | 70 | 0.5 | 40 | 12 | 50 | 0 | 238 | 119 | 498 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 120 | 46.6 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae |
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);;