contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27220804 | 27220804 | PRJNA800090_P_NODE_133862_length_273_cov_1.225490_g131677_i0 | PRJNA800090 | 133862 | 273 | 1.22549 | 3.3455877 | Betanucleorhabdovirus | 2733248 | Viruses | Viruses | 148 | 5.739999999999999e-40 | NR | DAF42413.1 | 2793726 | g131677 | i0 | 69.7 | 7.82417582417582 | 89 | 27 | 97.8 | 0 | 5 | 271 | 87 | 175 | DAF42413.1 TPA_asm: G, partial [Cuscuta virus 1] | diamond | 2136 | 149 | 0.993288590604027 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Cuscuta virus 1 | |||
| 27284307 | 27284307 | PRJNA800090_P_NODE_149183_length_257_cov_1.164894_g146998_i0 | PRJNA800090 | 149183 | 257 | 1.164894 | 2.99377758 | Viruses | 10239 | Viruses | Viruses | 95.9 | 2.22e-21 | NR | DAF42409.1 | 2793726 | g146998 | i0 | 56 | 7.8443579766537 | 84 | 37 | 98.1 | 0 | 3 | 254 | 14 | 97 | DAF42409.1 TPA_asm: P [Cuscuta virus 1] | diamond | 2016 | 96.3 | 0.995846313603323 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Cuscuta virus 1 | |||
| 27496578 | 27496578 | PRJNA800090_P_NODE_171703_length_236_cov_2.353293_g169518_i0 | PRJNA800090 | 171703 | 236 | 2.353293 | 5.55377148 | Salmonella phage SSBI34 | 2861009 | Viruses | Viruses | 43.9 | 0.00176 | NR | QYC52643.1 | 2861009 | g169518 | i0 | 55.3 | 0.483050847457627 | 38 | 17 | 48.3 | 0 | 123 | 236 | 1 | 38 | QYC52643.1 hypothetical protein [Salmonella phage SSBI34] | diamond | 114 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salmonella phage SSBI34 | |||||
| 27717932 | 27717932 | PRJNA800090_P_NODE_37904_length_604_cov_4.822430_g35751_i0 | PRJNA800090 | 37904 | 604 | 4.82243 | 29.1274772 | Sambucus betanucleorhabdovirus 4 | 3141832 | Viruses | Viruses | 164 | 1.98e-43 | NR | XBH23539.1 | 3141832 | g35751 | i0 | 45.4 | 5.53807947019868 | 185 | 99 | 91.9 | 1 | 3 | 557 | 447 | 629 | XBH23539.1 MAG: glycoprotein [Sambucus betanucleorhabdovirus 4] | diamond | 3345 | 164 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Sambucus betanucleorhabdovirus 4 | ||
| 27843659 | 27843659 | PRJNA800090_P_NODE_55024_length_476_cov_2.449631_g52840_i0 | PRJNA800090 | 55024 | 476 | 2.449631 | 11.66024356 | Tomato betanucleorhabdovirus 2 | 2950851 | Viruses | Viruses | 97.4 | 8.09e-21 | NR | UTQ50536.1 | 2950851 | g52840 | i0 | 42.9 | 1.96008403361345 | 105 | 60 | 66.2 | 0 | 1 | 315 | 227 | 331 | UTQ50536.1 MAG: phosphoprotein [Tomato betanucleorhabdovirus 2] | diamond | 933 | 97.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Betanucleorhabdovirus betalycopersici | ||
| 28222521 | 28222521 | PRJNA800090_P_NODE_22706_length_832_cov_3.840105_g20820_i0 | PRJNA800090 | 22706 | 832 | 3.840105 | 31.9496736 | Sambucus betanucleorhabdovirus 1 | 3141829 | Viruses | Viruses | 390 | 2.21e-131 | NR | XBH23499.1 | 3141829 | g20820 | i0 | 74.3 | 3.80048076923077 | 265 | 65 | 95.6 | 1 | 830 | 36 | 196 | 457 | XBH23499.1 MAG: nucleoprotein [Sambucus betanucleorhabdovirus 1] | diamond | 3162 | 390 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Sambucus betanucleorhabdovirus 1 | ||
| 29075381 | 29075381 | PRJNA800090_P_NODE_163348_length_243_cov_4.126437_g161163_i0 | PRJNA800090 | 163348 | 243 | 4.126437 | 10.02724191 | Escherichia phage vB_EcoS-Ro145c2YLVW | 2144178 | Viruses | Viruses | 126 | 1.0599999999999998e-31 | NR | YP_010749480.1 | 2144178 | g161163 | i0 | 89.4 | 8.95061728395062 | 66 | 7 | 81.5 | 0 | 46 | 243 | 1 | 66 | YP_010749480.1 hypothetical protein QCF77_gp51 [Escherichia phage vB_EcoS-Ro145c2YLVW] | diamond | 2175 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Kagunavirus | Escherichia phage vB_EcoS-Ro145c2YLVW | |||
| 29106864 | 29106864 | PRJNA800090_P_NODE_181448_length_232_cov_1.625767_g179263_i0 | PRJNA800090 | 181448 | 232 | 1.625767 | 3.77177944 | Marseillevirus LCMAC2 | 2506606 | Viruses | Viruses | 60.8 | 8.15e-9 | NR | QBK87781.1 | 2506606 | g179263 | i0 | 39.1 | 1.82327586206897 | 69 | 42 | 89.2 | 0 | 213 | 7 | 108 | 176 | QBK87781.1 MAG: hypothetical protein LCMAC202_01170 [Marseillevirus LCMAC202] | diamond | 423 | 60.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC202 | |||
| 29170067 | 29170067 | PRJNA800090_P_NODE_196729_length_220_cov_2.278146_g194544_i0 | PRJNA800090 | 196729 | 220 | 2.278146 | 5.0119212 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 64.7 | 5.77e-12 | NR | WPH57058.1 | 3096133 | g194544 | i0 | 73.2 | 0.559090909090909 | 41 | 11 | 55.9 | 0 | 128 | 6 | 5 | 45 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 123 | 64.7 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 29422305 | 29422305 | PRJNA800090_P_NODE_190029_length_229_cov_0.912500_g187844_i0 | PRJNA800090 | 190029 | 229 | 0.9125 | 2.089625 | uncultured virus | 340016 | Viruses | Viruses | 47 | 6.59e-4 | NR | CAH6421660.1 | 340016 | g187844 | i0 | 45.8 | 0.62882096069869 | 48 | 25 | 62.9 | 1 | 82 | 225 | 73 | 119 | CAH6421660.1 START domain-containing protein [uncultured virus] | diamond | 144 | 47 | 1 | Viruses | uncultured virus | ||||||||
| 29864503 | 29864503 | PRJNA800090_P_NODE_121311_length_290_cov_1.321267_g119126_i0 | PRJNA800090 | 121311 | 290 | 1.321267 | 3.8316743 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 57 | 6.05e-7 | NR | AYV82548.1 | 2487770 | g119126 | i0 | 38.9 | 0.982758620689655 | 95 | 55 | 95.2 | 2 | 9 | 284 | 193 | 287 | AYV82548.1 MAG: chromosome condensation regulator [Hyperionvirus sp.] | diamond | 285 | 57 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 29896271 | 29896271 | PRJNA800090_P_NODE_33031_length_659_cov_3.103390_g30910_i0 | PRJNA800090 | 33031 | 659 | 3.10339 | 20.4513401 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 210 | 1.22e-58 | NR | QJD14857.1 | 2715797 | g30910 | i0 | 56.7 | 2.02124430955994 | 224 | 81 | 97.9 | 4 | 657 | 13 | 459 | 675 | QJD14857.1 replicase [Actinidia seed-borne latent like virus] | diamond | 1332 | 210 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus | |||
| 30717518 | 30717518 | PRJNA800090_P_NODE_49574_length_509_cov_3.138636_g47393_i0 | PRJNA800090 | 49574 | 509 | 3.138636 | 15.97565724 | Beet betanucleorhabdovirus 1 | 3064197 | Viruses | Viruses | 66.6 | 3.09e-9 | NR | WKW47887.1 | 3064197 | g47393 | i0 | 29.1 | 0.931237721021611 | 158 | 107 | 92.5 | 3 | 471 | 1 | 1834 | 1987 | WKW47887.1 RNA-dependent RNA polymerase [Beet betanucleorhabdovirus 1] | diamond | 474 | 66.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Beet betanucleorhabdovirus 1 | ||
| 30938961 | 30938961 | PRJNA800090_P_NODE_64414_length_430_cov_1.523546_g62230_i0 | PRJNA800090 | 64414 | 430 | 1.523546 | 6.5512478 | Pandoravirus japonicus | 2823154 | Viruses | Viruses | 138 | 1.61e-35 | NR | BCU03046.1 | 2823154 | g62230 | i0 | 44.8 | 1.01162790697674 | 145 | 76 | 99.1 | 2 | 3 | 428 | 51 | 194 | BCU03046.1 hypothetical protein [Pandoravirus japonicus] | diamond | 435 | 138 | 1 | Viruses | Pandoravirus | Pandoravirus japonicus | |||||||
| 30970487 | 30970487 | PRJNA800090_P_NODE_130174_length_277_cov_2.807692_g127989_i0 | PRJNA800090 | 130174 | 277 | 2.807692 | 7.77730684 | Beet betanucleorhabdovirus 1 | 3064197 | Viruses | Viruses | 126 | 1.3399999999999998e-31 | NR | WKW47886.1 | 3064197 | g127989 | i0 | 65.9 | 2.77256317689531 | 85 | 29 | 92.1 | 0 | 275 | 21 | 282 | 366 | WKW47886.1 glycoprotein [Beet betanucleorhabdovirus 1] | diamond | 768 | 126 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Beet betanucleorhabdovirus 1 | ||
| 31074160 | 31074160 | PRJNA800090_P_NODE_40415_length_580_cov_2.800391_g38256_i0 | PRJNA800090 | 40415 | 580 | 2.800391 | 16.2422678 | Betanucleorhabdovirus | 2733248 | Viruses | Viruses | 251 | 4.22e-78 | NR | CAI5383865.1 | 2933137 | g38256 | i0 | 63.2 | 4.97586206896552 | 193 | 70 | 99.8 | 1 | 2 | 580 | 29 | 220 | CAI5383865.1 N putative nucleocapid, partial [Common ivy rhabdovirus] | diamond | 2886 | 251 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Common ivy rhabdovirus | |||
| 31801227 | 31801227 | PRJNA800090_P_NODE_75117_length_389_cov_3.471875_g72932_i0 | PRJNA800090 | 75117 | 389 | 3.471875 | 13.50559375 | Betanucleorhabdovirus | 2733248 | Viruses | Viruses | 111 | 1.53e-25 | NR | UTQ50577.1 | 2950850 | g72932 | i0 | 46.5 | 3.84061696658098 | 127 | 68 | 97.9 | 0 | 382 | 2 | 1976 | 2102 | UTQ50577.1 MAG: RNA-dependent RNA polymerase [Tomato betanucleorhabdovirus 1] | diamond | 1494 | 111 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Betanucleorhabdovirus alphalycopersici | ||
| 32267232 | 32267232 | PRJNA800090_P_NODE_115018_length_299_cov_3.173913_g112833_i0 | PRJNA800090 | 115018 | 299 | 3.173913 | 9.48999987 | Tomato betanucleorhabdovirus 2 | 2950851 | Viruses | Viruses | 155 | 2.19e-44 | NR | UTQ50538.1 | 2950851 | g112833 | i0 | 70.4 | 1.96655518394649 | 98 | 28 | 98.3 | 1 | 298 | 5 | 138 | 234 | UTQ50538.1 MAG: matrix protein [Tomato betanucleorhabdovirus 2] | diamond | 588 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betanucleorhabdovirus | Betanucleorhabdovirus betalycopersici | ||
| 32402668 | 32402668 | PRJNA800090_P_NODE_10919_length_1226_cov_2.421780_g9701_i0 | PRJNA800090 | 10919 | 1226 | 2.42178 | 29.6910228 | Pandoravirus | 2060084 | Viruses | Viruses | 252 | 7.97e-75 | NR | YP_009481523.1 | 2107707 | g9701 | i0 | 36.2 | 2.96084828711256 | 403 | 238 | 94.5 | 8 | 69 | 1226 | 46 | 446 | YP_009481523.1 hypothetical protein pmac_cds_839 [Pandoravirus macleodensis] | diamond | 3630 | 252 | 1 | Viruses | Pandoravirus | Pandoravirus macleodensis | |||||||
| 32529360 | 32529360 | PRJNA800090_P_NODE_8239_length_1399_cov_4.766917_g7252_i0 | PRJNA800090 | 8239 | 1399 | 4.766917 | 66.68916883 | Betanucleorhabdovirus | 2733248 | Viruses | Viruses | 412 | 4.56e-139 | NR | DAF42410.1 | 2793726 | g7252 | i0 | 60.6 | 1.97069335239457 | 307 | 121 | 65.8 | 0 | 2 | 922 | 19 | 325 | DAF42410.1 TPA_asm: P3 [Cuscuta virus 1] | diamond | 2757 | 414 | 0.995169082125604 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Cuscuta virus 1 | |||
| 32866709 | 32866709 | PRJNA800090_P_NODE_168260_length_239_cov_1.694118_g166075_i0 | PRJNA800090 | 168260 | 239 | 1.694118 | 4.04894202 | Phytophthora cinnamomi ormycovirus 7-5 | 3239326 | Viruses | Viruses | 86.3 | 1.43e-17 | NR | XDO01624.1 | 3239326 | g166075 | i0 | 51.9 | 0.99163179916318 | 79 | 38 | 99.2 | 0 | 238 | 2 | 300 | 378 | XDO01624.1 hypothetical protein [Phytophthora cinnamomi ormycovirus 7-5] | diamond | 237 | 86.3 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus phytophthorae | |||
| 32866754 | 32866754 | PRJNA800090_S_NODE_27340_length_245_cov_1.051136_g27228_i0 | PRJNA800090 | 27340 | 245 | 1.051136 | 2.5752832 | Actinidia seed-borne latent like virus | 2715797 | Viruses | Viruses | 90.5 | 6.06e-19 | NR | QJD14857.1 | 2715797 | g27228 | i0 | 61.4 | 0.857142857142857 | 70 | 27 | 85.7 | 0 | 1 | 210 | 524 | 593 | QJD14857.1 replicase [Actinidia seed-borne latent like virus] | diamond | 210 | 90.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Actinidia seed-borne latent like virus |
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);;