contig_metadata
22 rows where bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934786 | 934786 | PRJNA951388_S_NODE_8021_length_298_cov_5.871111_g7894_i0 | PRJNA951388 | 8021 | 298 | 5.871111 | 17.49591078 | Bromovirus BMV | 3427622 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|2329659869|gb|OK558648.1| | 12302 | g7894 | i0 | 100 | 37.8959731543624 | 298 | 0 | 100 | 0 | 1 | 298 | 817 | 1114 | Brome mosaic virus isolate VRS-315 ORF1 and ORF2 genes, complete cds | blastn | 11293 | 551 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 6037873 | 6037873 | PRJNA951388_S_NODE_10785_length_250_cov_1.096045_g10658_i0 | PRJNA951388 | 10785 | 250 | 1.096045 | 2.7401125 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10658 | i0 | 100 | 0.232 | 30 | 0 | 12 | 0 | 1 | 30 | 13 | 42 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 6037888 | 6037888 | PRJNA951388_S_NODE_3765_length_415_cov_18.944444_g3638_i0 | PRJNA951388 | 3765 | 415 | 18.944444 | 78.6194426 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g3638 | i0 | 100 | 6.98795180722892 | 29 | 0 | 7 | 0 | 74 | 102 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 9862750 | 9862750 | PRJNA951388_S_NODE_2608_length_471_cov_33.608040_g2481_i0 | PRJNA951388 | 2608 | 471 | 33.60804 | 158.2938684 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g2481 | i0 | 100 | 0.121019108280255 | 29 | 0 | 6 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 9862760 | 9862760 | PRJNA951388_S_NODE_4128_length_403_cov_11.709091_g4001_i0 | PRJNA951388 | 4128 | 403 | 11.709091 | 47.18763673 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 8.31e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g4001 | i0 | 100 | 0.387096774193548 | 31 | 0 | 8 | 0 | 1 | 31 | 13 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 156 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 12413830 | 12413830 | PRJNA951388_S_NODE_11870_length_233_cov_4.756250_g11743_i0 | PRJNA951388 | 11870 | 233 | 4.75625 | 11.0820625 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g11743 | i0 | 100 | 0.244635193133047 | 29 | 0 | 12 | 0 | 205 | 233 | 34 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 12413840 | 12413840 | PRJNA951388_S_NODE_2850_length_458_cov_8.706494_g2723_i0 | PRJNA951388 | 2850 | 458 | 8.706494 | 39.87574252 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g2723 | i0 | 94.444 | 0.262008733624454 | 36 | 2 | 8 | 0 | 423 | 458 | 91 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 120 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 13688405 | 13688405 | PRJNA951388_S_NODE_5131_length_370_cov_7.404040_g5004_i0 | PRJNA951388 | 5131 | 370 | 7.40404 | 27.394948 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g5004 | i0 | 100 | 0.154054054054054 | 29 | 0 | 8 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18786506 | 18786506 | PRJNA951388_S_NODE_955_length_662_cov_4.198642_g840_i0 | PRJNA951388 | 955 | 662 | 4.198642 | 27.79501004 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 60.2 | 3.94e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g840 | i0 | 100 | 0.0483383685800604 | 32 | 0 | 5 | 0 | 631 | 662 | 37 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20061395 | 20061395 | PRJNA951388_S_NODE_13076_length_204_cov_6.290076_g12949_i0 | PRJNA951388 | 13076 | 204 | 6.290076 | 12.831755039999999 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g12949 | i0 | 100 | 0.563725490196078 | 30 | 0 | 15 | 0 | 175 | 204 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 20061397 | 20061397 | PRJNA951388_S_NODE_1616_length_550_cov_27.492662_g1495_i0 | PRJNA951388 | 1616 | 550 | 27.492662 | 151.209641 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.015 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g1495 | i0 | 100 | 0.0527272727272727 | 29 | 0 | 5 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 21336816 | 21336816 | PRJNA951388_S_NODE_177_length_1186_cov_114.204852_g116_i0 | PRJNA951388 | 177 | 1186 | 114.204852 | 1354.46954472 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.034 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g116 | i0 | 100 | 0.0244519392917369 | 29 | 0 | 2 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 27468126 | 27468126 | PRJNA951388_S_NODE_383_length_894_cov_3.880633_g292_i0 | PRJNA951388 | 383 | 894 | 3.880633 | 34.69285902 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 75.5 | 5.22e-11 | NR | XEQ84337.1 | RQ13 | g292 | i0 | 30.4 | 1.69127516778523 | 168 | 104 | 52 | 3 | 92 | 556 | 288 | 455 | XEQ84337.1 polyprotein, partial [Mink kobuvirus] | diamond | 1512 | 75.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 27632479 | 27632479 | PRJNA951388_S_NODE_684_length_743_cov_4.432836_g574_i0 | PRJNA951388 | 684 | 743 | 4.432836 | 32.93597148 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 271 | 4.46e-86 | NR | ADI48258.1 | RQ13 | g574 | i0 | 55.2 | 2.95154777927322 | 239 | 101 | 96.5 | 4 | 719 | 3 | 1 | 233 | ADI48258.1 3D, partial [Bat kobuvirus TM003k] | diamond | 2193 | 272 | 0.996323529411765 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 28446993 | 28446993 | PRJNA951388_S_NODE_426_length_863_cov_12.545570_g330_i0 | PRJNA951388 | 426 | 863 | 12.54557 | 108.2682691 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 582 | 2.9499999999999996e-206 | NR | 8WUS_E | 11801 | g330 | i0 | 99 | 8.97914252607184 | 287 | 3 | 99.8 | 0 | 3 | 863 | 31 | 317 | 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] | diamond | 7749 | 582 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 28958732 | 28958732 | PRJNA951388_S_NODE_808_length_705_cov_4.901899_g695_i0 | PRJNA951388 | 808 | 705 | 4.901899 | 34.55838795 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 59.3 | 4.47e-6 | NR | XOL43542.1 | RQ13 | g695 | i0 | 29 | 3.05957446808511 | 183 | 98 | 65.1 | 7 | 574 | 116 | 950 | 1130 | XOL43542.1 polyprotein [Kobuvirus dekago] | diamond | 2157 | 59.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 29772734 | 29772734 | PRJNA951388_S_NODE_931_length_668_cov_134.105882_g816_i0 | PRJNA951388 | 931 | 668 | 134.105882 | 895.82729176 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 77 | 3.34e-12 | NR | QJX58422.1 | RQ13 | g816 | i0 | 43.8 | 3.01796407185629 | 96 | 52 | 42.2 | 2 | 4 | 285 | 2264 | 2359 | QJX58422.1 polyprotein [Salivirus A] | diamond | 2016 | 77 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Salivirus | Zebrafish jaw picornavirus | ||
| 30562441 | 30562441 | PRJNA951388_S_NODE_6753_length_327_cov_1.862205_g6626_i0 | PRJNA951388 | 6753 | 327 | 1.862205 | 6.08941035 | Human immunodeficiency virus 1 | 11676 | Viruses | Viruses | 48.9 | 6.4e-4 | NR | WAJ62392.1 | 11676 | g6626 | i0 | 35.4 | 3.00917431192661 | 82 | 43 | 75.2 | 1 | 44 | 289 | 330 | 401 | WAJ62392.1 gag protein, partial [Human immunodeficiency virus 1] | diamond | 984 | 48.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 30568974 | 30568974 | PRJNA951388_S_NODE_5393_length_363_cov_1.593103_g5266_i0 | PRJNA951388 | 5393 | 363 | 1.593103 | 5.78296389 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 114 | 9.06e-27 | NR | YP_010796386.1 | RQ13 | g5266 | i0 | 51.9 | 4.43801652892562 | 108 | 52 | 89.3 | 0 | 326 | 3 | 1354 | 1461 | YP_010796386.1 polyprotein [tropivirus A1] | diamond | 1611 | 115 | 0.991304347826087 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Tropivirus | Zebrafish jaw picornavirus | ||
| 31257850 | 31257850 | PRJNA951388_S_NODE_615_length_774_cov_11.880171_g507_i0 | PRJNA951388 | 615 | 774 | 11.880171 | 91.95252354 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 493 | 4.71e-159 | NR | NP_057933.2 | 11801 | g507 | i0 | 97.3 | 1 | 258 | 7 | 100 | 0 | 1 | 774 | 1076 | 1333 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 774 | 493 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31637328 | 31637328 | PRJNA951388_S_NODE_7096_length_319_cov_3.621951_g6969_i0 | PRJNA951388 | 7096 | 319 | 3.621951 | 11.55402369 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 137 | 7.48e-35 | NR | QUS52515.1 | RQ13 | g6969 | i0 | 61.2 | 1.93730407523511 | 103 | 40 | 96.9 | 0 | 6 | 314 | 2223 | 2325 | QUS52515.1 polyprotein [ludopivirus A1] | diamond | 618 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Ludopivirus | Zebrafish jaw picornavirus | ||
| 32750464 | 32750464 | PRJNA951388_S_NODE_10140_length_259_cov_5.161290_g10013_i0 | PRJNA951388 | 10140 | 259 | 5.16129 | 13.3677411 | Mitoviridae | 2732892 | Viruses | Viruses | 93.6 | 5.99e-20 | NR | YP_010799405.1 | 2497445 | g10013 | i0 | 50 | 4.06563706563707 | 92 | 40 | 99.6 | 1 | 259 | 2 | 125 | 216 | YP_010799405.1 RNA-dependent RNA polymerase [Nigrospora oryzae mitovirus 2] | diamond | 1053 | 94.4 | 0.991525423728813 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Unuamitovirus | Unuamitovirus nior2 |
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);;