contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9708462 | 9708462 | PRJNA795983_S_NODE_42288_length_242_cov_0.911243_g42163_i0 | PRJNA795983 | 42288 | 242 | 0.911243 | 2.20520806 | Acanthamoeba castellanii mamavirus | 554168 | Viruses | Viruses | 102 | 1.88e-23 | NR | AEQ60860.1 | 554168 | g42163 | i0 | 57.9 | 0.942148760330578 | 76 | 32 | 94.2 | 0 | 14 | 241 | 27 | 102 | AEQ60860.1 FAD dependent oxidoreductase family protein [Acanthamoeba castellanii mamavirus] | diamond | 228 | 102 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Acanthamoeba castellanii mamavirus | ||
| 12696169 | 12696169 | PRJNA795983_S_NODE_9710_length_392_cov_2.388715_g9585_i0 | PRJNA795983 | 9710 | 392 | 2.388715 | 9.3637628 | Gammaretrovirus | 153135 | Viruses | Viruses | 253 | 1.73e-75 | NR | NP_040333.1 | 11795 | g9585 | i0 | 97.7 | 11.8622448979592 | 129 | 3 | 98.7 | 0 | 390 | 4 | 326 | 454 | NP_040333.1 RNA-dependent DNA polymerase, partial [Friend murine leukemia virus] | diamond | 4650 | 253 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 18631538 | 18631538 | PRJNA795983_S_NODE_19115_length_312_cov_1.623431_g18990_i0 | PRJNA795983 | 19115 | 312 | 1.623431 | 5.06510472 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 147 | 1.14e-39 | NR | AYV78014.1 | 2487765 | g18990 | i0 | 66 | 0.990384615384615 | 103 | 34 | 99 | 1 | 311 | 3 | 170 | 271 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 309 | 147 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 21182417 | 21182417 | PRJNA795983_S_NODE_10417_length_383_cov_1.948387_g10292_i0 | PRJNA795983 | 10417 | 383 | 1.948387 | 7.46232221 | Gammaretrovirus | 153135 | Viruses | Viruses | 233 | 3.7899999999999986e-68 | NR | ABU54795.1 | 11786 | g10292 | i0 | 95.7 | 9.98694516971279 | 116 | 5 | 90.9 | 0 | 33 | 380 | 657 | 772 | ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus] | diamond | 3825 | 235 | 0.991489361702128 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 27116821 | 27116821 | PRJNA795983_S_NODE_5982_length_468_cov_2.648101_g5857_i0 | PRJNA795983 | 5982 | 468 | 2.648101 | 12.39311268 | Pandoravirus japonicus | 2823154 | Viruses | Viruses | 122 | 2.56e-29 | NR | BCU03046.1 | 2823154 | g5857 | i0 | 43.8 | 1.48076923076923 | 130 | 69 | 81.4 | 2 | 88 | 468 | 36 | 164 | BCU03046.1 hypothetical protein [Pandoravirus japonicus] | diamond | 693 | 122 | 1 | Viruses | Pandoravirus | Pandoravirus japonicus | |||||||
| 27591132 | 27591132 | PRJNA795983_S_NODE_14324_length_343_cov_1.133333_g14199_i0 | PRJNA795983 | 14324 | 343 | 1.133333 | 3.88733219 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 51.2 | 1.26e-4 | NR | AYV80864.1 | 2487768 | g14199 | i0 | 38.3 | 1.2332361516035 | 60 | 28 | 51.6 | 2 | 7 | 183 | 545 | 596 | AYV80864.1 MAG: hypothetical protein Harvfovirus8_25 [Harvfovirus sp.] | diamond | 423 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 28064511 | 28064511 | PRJNA795983_S_NODE_29745_length_268_cov_2.317949_g29620_i0 | PRJNA795983 | 29745 | 268 | 2.317949 | 6.21210332 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 57 | 5.06e-7 | NR | YP_010840939.1 | 3065075 | g29620 | i0 | 47 | 0.738805970149254 | 66 | 34 | 72.8 | 1 | 267 | 73 | 14 | 79 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 198 | 57 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 29043500 | 29043500 | PRJNA795983_S_NODE_26688_length_279_cov_1.208738_g26563_i0 | PRJNA795983 | 26688 | 279 | 1.208738 | 3.37237902 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 120 | 3.28e-30 | NR | YP_010803269.1 | 3060017 | g26563 | i0 | 61.3 | 1 | 93 | 36 | 100 | 0 | 279 | 1 | 248 | 340 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 279 | 120 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29138312 | 29138312 | PRJNA795983_S_NODE_24469_length_287_cov_1.439252_g24344_i0 | PRJNA795983 | 24469 | 287 | 1.439252 | 4.13065324 | Pandoravirus macleodensis | 2107707 | Viruses | Viruses | 70.9 | 7.93e-12 | NR | YP_009481523.1 | 2107707 | g24344 | i0 | 38 | 0.961672473867596 | 92 | 55 | 95.1 | 2 | 11 | 283 | 150 | 240 | YP_009481523.1 hypothetical protein pmac_cds_839 [Pandoravirus macleodensis] | diamond | 276 | 70.9 | 1 | Viruses | Pandoravirus | Pandoravirus macleodensis | |||||||
| 29390783 | 29390783 | PRJNA795983_S_NODE_16229_length_329_cov_1.195312_g16104_i0 | PRJNA795983 | 16229 | 329 | 1.195312 | 3.93257648 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 164 | 7.49e-46 | NR | AYV78014.1 | 2487765 | g16104 | i0 | 67.9 | 0.993920972644377 | 109 | 35 | 99.4 | 0 | 1 | 327 | 277 | 385 | AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] | diamond | 327 | 164 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 29990702 | 29990702 | PRJNA795983_S_NODE_25951_length_281_cov_2.567308_g25826_i0 | PRJNA795983 | 25951 | 281 | 2.567308 | 7.21413548 | Homavirus sp. | 2487769 | Viruses | Viruses | 81.3 | 1.67e-15 | NR | AYV82270.1 | 2487769 | g25826 | i0 | 43.6 | 1.95373665480427 | 94 | 44 | 97.2 | 4 | 281 | 9 | 191 | 278 | AYV82270.1 MAG: hypothetical protein Homavirus23_1, partial [Homavirus sp.] | diamond | 549 | 81.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 30370235 | 30370235 | PRJNA795983_S_NODE_40472_length_244_cov_1.274854_g40347_i0 | PRJNA795983 | 40472 | 244 | 1.274854 | 3.11064376 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 85.9 | 2.7e-18 | NR | ARF12304.1 | 1977640 | g40347 | i0 | 52.6 | 1.94262295081967 | 78 | 37 | 95.9 | 0 | 3 | 236 | 132 | 209 | ARF12304.1 metal dependent phosphohydrolase [Klosneuvirus KNV1] | diamond | 474 | 85.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 30907109 | 30907109 | PRJNA795983_S_NODE_17014_length_324_cov_0.968127_g16889_i0 | PRJNA795983 | 17014 | 324 | 0.968127 | 3.13673148 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 216 | 1.02e-62 | NR | NP_057933.2 | 11801 | g16889 | i0 | 98.1 | 2.94444444444444 | 106 | 2 | 98.1 | 0 | 320 | 3 | 1094 | 1199 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 954 | 216 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31286014 | 31286014 | PRJNA795983_S_NODE_5595_length_480_cov_2.324324_g5470_i0 | PRJNA795983 | 5595 | 480 | 2.324324 | 11.1567552 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 101 | 1.97e-21 | NR | WLN26256.1 | 3065075 | g5470 | i0 | 47.6 | 0.64375 | 103 | 54 | 64.4 | 0 | 3 | 311 | 132 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 309 | 101 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31390342 | 31390342 | PRJNA795983_S_NODE_24176_length_288_cov_1.860465_g24051_i0 | PRJNA795983 | 24176 | 288 | 1.860465 | 5.3581392 | Gammaretrovirus | 153135 | Viruses | Viruses | 198 | 1.7999999999999997e-56 | NR | AMK06426.1 | 11786 | g24051 | i0 | 98.9 | 11.875 | 95 | 1 | 99 | 0 | 287 | 3 | 975 | 1069 | AMK06426.1 putative gag-pro-pol polyprotein [Murine leukemia virus] | diamond | 3420 | 200 | 0.99 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 32045410 | 32045410 | PRJNA795983_S_NODE_5278_length_491_cov_1.456938_g5154_i0 | PRJNA795983 | 5278 | 491 | 1.456938 | 7.15356558 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 182 | 7.39e-53 | NR | VBB17617.1 | 2420051 | g5154 | i0 | 59.1 | 1.0020366598778 | 164 | 60 | 98.4 | 2 | 483 | 1 | 188 | 347 | VBB17617.1 2-nitropropane dioxygenase [Yasminevirus sp. GU-2018] | diamond | 492 | 182 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 32520197 | 32520197 | PRJNA795983_S_NODE_23999_length_289_cov_1.425926_g23874_i0 | PRJNA795983 | 23999 | 289 | 1.425926 | 4.12092614 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 58.5 | 1.56e-7 | NR | AYV82936.1 | 2487770 | g23874 | i0 | 37 | 0.84083044982699 | 81 | 48 | 84.1 | 1 | 22 | 264 | 38 | 115 | AYV82936.1 MAG: glycoside hydrolase [Hyperionvirus sp.] | diamond | 243 | 58.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus 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);;