contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168798 | 3168798 | PRJNA642647_P_NODE_183_length_834_cov_3.016311_g152_i0 | PRJNA642647 | 183 | 834 | 3.016311 | 25.15603374 | Forni cryoconite toluca-like virus 2 | 3367771 | Viruses | Viruses | 313 | 2.5799999999999995e-101 | NR | XHY08967.1 | 3367771 | g152 | i0 | 58.5 | 0.97841726618705 | 272 | 109 | 97.8 | 2 | 830 | 15 | 171 | 438 | XHY08967.1 MAG: structural protein [Forni cryoconite toluca-like virus 2] | diamond | 816 | 313 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Forni cryoconite toluca-like virus 2 | |||||
| 14646936 | 14646936 | PRJNA642647_P_NODE_632_length_449_cov_4.696602_g583_i0 | PRJNA642647 | 632 | 449 | 4.696602 | 21.08774298 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 95.9 | 7.84e-20 | NR | XHA86821.1 | 3347850 | g583 | i0 | 58.3 | 1.14922048997773 | 84 | 35 | 56.1 | 0 | 442 | 191 | 390 | 473 | XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183] | diamond | 516 | 95.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 27334303 | 27334303 | PRJNA642647_P_NODE_6563_length_151_cov_1.342105_g6513_i0 | PRJNA642647 | 6563 | 151 | 1.342105 | 2.02657855 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 57.8 | 5.3e-8 | NR | UHS71939.1 | 1955165 | g6513 | i0 | 47.9 | 5.82119205298013 | 48 | 25 | 95.4 | 0 | 5 | 148 | 763 | 810 | UHS71939.1 MAG: hypothetical protein 1 [Luteoviridae sp.] | diamond | 879 | 57.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 27776398 | 27776398 | PRJNA642647_P_NODE_824_length_389_cov_3.477273_g774_i0 | PRJNA642647 | 824 | 389 | 3.477273 | 13.52659197 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 208 | 6.56e-63 | NR | XHA86823.1 | 3347850 | g774 | i0 | 67.4 | 1.98971722365039 | 129 | 42 | 99.5 | 0 | 2 | 388 | 310 | 438 | XHA86823.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 183] | diamond | 774 | 208 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 28186437 | 28186437 | PRJNA642647_P_NODE_5826_length_158_cov_1.561983_g5776_i0 | PRJNA642647 | 5826 | 158 | 1.561983 | 2.46793314 | Tolivirales sp. | 2809914 | Viruses | Viruses | 92.8 | 2.68e-20 | NR | WRQ65315.1 | 2809914 | g5776 | i0 | 95.5 | 0.835443037974684 | 44 | 2 | 83.5 | 0 | 25 | 156 | 401 | 444 | WRQ65315.1 polyprotein [Tolivirales sp.] | diamond | 132 | 92.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28325175 | 28325175 | PRJNA642647_P_NODE_5326_length_165_cov_1.179688_g5276_i0 | PRJNA642647 | 5326 | 165 | 1.179688 | 1.9464852 | Viruses | 10239 | Viruses | Viruses | 90.1 | 1.97e-19 | NR | XHA86823.1 | 3347850 | g5276 | i0 | 71.7 | 2.87272727272727 | 53 | 15 | 96.4 | 0 | 2 | 160 | 329 | 381 | XHA86823.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 183] | diamond | 474 | 90.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 28597277 | 28597277 | PRJNA642647_P_NODE_887_length_376_cov_1.787611_g837_i0 | PRJNA642647 | 887 | 376 | 1.787611 | 6.72141736 | Forsythia suspensa tombusvirus | 2740140 | Viruses | Viruses | 78.2 | 4.74e-14 | NR | QNM36911.1 | 2740140 | g837 | i0 | 45.9 | 0.86968085106383 | 109 | 51 | 83.8 | 3 | 19 | 333 | 268 | 372 | QNM36911.1 coat protein [Forsythia suspensa tombusvirus] | diamond | 327 | 78.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Forsythia suspensa tombusvirus | ||
| 29070950 | 29070950 | PRJNA642647_P_NODE_1428_length_292_cov_2.054902_g1378_i0 | PRJNA642647 | 1428 | 292 | 2.054902 | 6.00031384 | Tolivirales sp. | 2809914 | Viruses | Viruses | 110 | 3.28e-26 | NR | WRQ65081.1 | 2809914 | g1378 | i0 | 64.2 | 0.976027397260274 | 95 | 34 | 97.6 | 0 | 8 | 292 | 12 | 106 | WRQ65081.1 structural protein [Tolivirales sp.] | diamond | 285 | 110 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29259999 | 29259999 | PRJNA642647_P_NODE_2109_length_237_cov_3.560000_g2059_i0 | PRJNA642647 | 2109 | 237 | 3.56 | 8.4372 | Bat associated nodavirus | 2781639 | Viruses | Viruses | 67.8 | 5.14e-11 | NR | XCO48213.1 | 2781639 | g2059 | i0 | 45.8 | 0.911392405063291 | 72 | 39 | 91.1 | 0 | 5 | 220 | 126 | 197 | XCO48213.1 MAG: putative ORF1a protein [Bat associated nodavirus] | diamond | 216 | 67.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Bat associated nodavirus | |||
| 29367305 | 29367305 | PRJNA642647_P_NODE_29_length_1686_cov_4.539721_g25_i0 | PRJNA642647 | 29 | 1686 | 4.539721 | 76.53969606 | Viruses | 10239 | Viruses | Viruses | 344 | 1.23e-105 | NR | WRQ65393.1 | 2809914 | g25 | i0 | 40.1 | 3.41637010676157 | 469 | 264 | 81.9 | 10 | 305 | 1684 | 95 | 555 | WRQ65393.1 polyprotein, partial [Tolivirales sp.] | diamond | 5760 | 344 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 29417938 | 29417938 | PRJNA642647_P_NODE_3449_length_190_cov_3.261438_g3399_i0 | PRJNA642647 | 3449 | 190 | 3.261438 | 6.1967322 | Qianjiang tombus-like virus 37 | 3348058 | Viruses | Viruses | 47.4 | 4.34e-4 | NR | XHA86406.1 | 3348058 | g3399 | i0 | 41.8 | 0.868421052631579 | 55 | 30 | 85.3 | 2 | 169 | 8 | 41 | 94 | XHA86406.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 37] | diamond | 165 | 47.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 37 | |||
| 29512638 | 29512638 | PRJNA642647_P_NODE_5790_length_158_cov_3.785124_g5740_i0 | PRJNA642647 | 5790 | 158 | 3.785124 | 5.98049592 | Forni cryoconite toluca-like virus 2 | 3367771 | Viruses | Viruses | 77.8 | 8.19e-16 | NR | XHY08966.1 | 3367771 | g5740 | i0 | 64.7 | 0.968354430379747 | 51 | 18 | 96.8 | 0 | 155 | 3 | 71 | 121 | XHY08966.1 MAG: RNA-dependent RNA polymerase [Forni cryoconite toluca-like virus 2] | diamond | 153 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Forni cryoconite toluca-like virus 2 | |||||
| 29828464 | 29828464 | PRJNA642647_P_NODE_5251_length_166_cov_1.054264_g5201_i0 | PRJNA642647 | 5251 | 166 | 1.054264 | 1.75007824 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 45.4 | 0.00149 | NR | XHA86821.1 | 3347850 | g5201 | i0 | 55 | 1.44578313253012 | 40 | 18 | 72.3 | 0 | 121 | 2 | 1 | 40 | XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183] | diamond | 240 | 45.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 30302872 | 30302872 | PRJNA642647_P_NODE_4872_length_166_cov_3.930233_g4822_i0 | PRJNA642647 | 4872 | 166 | 3.930233 | 6.52418678 | Tolivirales sp. | 2809914 | Viruses | Viruses | 50.8 | 1.83e-5 | NR | WRQ65695.1 | 2809914 | g4822 | i0 | 78.6 | 0.506024096385542 | 28 | 6 | 50.6 | 0 | 85 | 2 | 76 | 103 | WRQ65695.1 structural protein [Tolivirales sp.] | diamond | 84 | 50.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30366017 | 30366017 | PRJNA642647_P_NODE_3132_length_198_cov_5.391304_g3082_i0 | PRJNA642647 | 3132 | 198 | 5.391304 | 10.67478192 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 111 | 5.7600000000000005e-27 | NR | XHA86823.1 | 3347850 | g3082 | i0 | 73.8 | 1.96969696969697 | 65 | 17 | 98.5 | 0 | 195 | 1 | 240 | 304 | XHA86823.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 183] | diamond | 390 | 111 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 30618261 | 30618261 | PRJNA642647_P_NODE_4313_length_174_cov_3.138686_g4263_i0 | PRJNA642647 | 4313 | 174 | 3.138686 | 5.46131364 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 70.5 | 2.47e-12 | NR | XHA86821.1 | 3347850 | g4263 | i0 | 56.9 | 0.879310344827586 | 51 | 22 | 87.9 | 0 | 4 | 156 | 423 | 473 | XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183] | diamond | 153 | 70.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 30681338 | 30681338 | PRJNA642647_P_NODE_13_length_1909_cov_5.702457_g10_i0 | PRJNA642647 | 13 | 1909 | 5.702457 | 108.85990413 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 428 | 3.13e-141 | NR | XHA86823.1 | 3347850 | g10 | i0 | 56.9 | 1.1440544787847 | 364 | 156 | 57.2 | 1 | 1092 | 1 | 1 | 363 | XHA86823.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang tombus-like virus 183] | diamond | 2184 | 428 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 30776475 | 30776475 | PRJNA642647_P_NODE_4334_length_174_cov_1.474453_g4284_i0 | PRJNA642647 | 4334 | 174 | 1.474453 | 2.56554822 | Tolivirales sp. | 2809914 | Viruses | Viruses | 73.2 | 2.56e-13 | NR | WRQ65701.1 | 2809914 | g4284 | i0 | 56.9 | 1 | 58 | 24 | 100 | 1 | 1 | 174 | 35 | 91 | WRQ65701.1 structural protein [Tolivirales sp.] | diamond | 174 | 73.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 31186823 | 31186823 | PRJNA642647_P_NODE_415_length_547_cov_2.074510_g366_i0 | PRJNA642647 | 415 | 547 | 2.07451 | 11.3475697 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 182 | 1.72e-51 | NR | XHA86821.1 | 3347850 | g366 | i0 | 63.6 | 1.53564899451554 | 140 | 51 | 76.8 | 0 | 422 | 3 | 1 | 140 | XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183] | diamond | 840 | 182 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 31250293 | 31250293 | PRJNA642647_P_NODE_955_length_361_cov_2.623457_g905_i0 | PRJNA642647 | 955 | 361 | 2.623457 | 9.47067977 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 130 | 1.73e-33 | NR | ASY03259.1 | 2034334 | g905 | i0 | 59.6 | 0.947368421052632 | 114 | 46 | 94.7 | 0 | 3 | 344 | 217 | 330 | ASY03259.1 coat protein [Norway luteo-like virus 4] | diamond | 342 | 130 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 32326277 | 32326277 | PRJNA642647_P_NODE_2319_length_226_cov_1.735450_g2269_i0 | PRJNA642647 | 2319 | 226 | 1.73545 | 3.922117 | Qianjiang tombus-like virus 89 | 3348160 | Viruses | Viruses | 122 | 5.839999999999999e-31 | NR | XHA86562.1 | 3348160 | g2269 | i0 | 81.9 | 1.92477876106195 | 72 | 13 | 95.6 | 0 | 6 | 221 | 157 | 228 | XHA86562.1 MAG: putative viral coat protein [Qianjiang tombus-like virus 89] | diamond | 435 | 122 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 89 | |||
| 32862326 | 32862326 | PRJNA642647_P_NODE_6540_length_151_cov_1.912281_g6490_i0 | PRJNA642647 | 6540 | 151 | 1.912281 | 2.88754431 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 98.6 | 8.319999999999999e-23 | NR | UHS71971.1 | 1955165 | g6490 | i0 | 89.8 | 2.9205298013245 | 49 | 5 | 97.4 | 0 | 5 | 151 | 156 | 204 | UHS71971.1 MAG: hypothetical protein 3 [Luteoviridae sp.] | diamond | 441 | 98.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. |
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);;