contig_metadata
13 rows where bioproject = "PRJNA577580" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6942191 | 6942191 | PRJNA577580_P_NODE_15226_length_246_cov_1.491329_g15148_i0 | PRJNA577580 | 15226 | 246 | 1.491329 | 3.66866934 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 390 | 4.15e-104 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g15148 | i0 | 95.492 | 2.97560975609756 | 244 | 11 | 99 | 0 | 1 | 244 | 2137 | 2380 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 732 | 390 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9492472 | 9492472 | PRJNA577580_P_NODE_5308_length_388_cov_1.457143_g5230_i0 | PRJNA577580 | 5308 | 388 | 1.457143 | 5.65371484 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 695 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g5230 | i0 | 98.969 | 3 | 388 | 4 | 100 | 0 | 1 | 388 | 7551 | 7938 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1164 | 695 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12043075 | 12043075 | PRJNA577580_P_NODE_11330_length_274_cov_0.990050_g11252_i0 | PRJNA577580 | 11330 | 274 | 0.99005 | 2.712737 | Sopafab virus | 3131770 | Viruses | Viruses | 255 | 1.79e-63 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g11252 | i0 | 84.043 | 68.1824817518248 | 282 | 27 | 97 | 12 | 10 | 274 | 310 | 30 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 18682 | 255 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 12043153 | 12043153 | PRJNA577580_P_NODE_6130_length_363_cov_1.496552_g6052_i0 | PRJNA577580 | 6130 | 363 | 1.496552 | 5.43248376 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 623 | 5.819999999999999e-174 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g6052 | i0 | 98.31 | 2.93388429752066 | 355 | 6 | 98 | 0 | 1 | 355 | 4198 | 3844 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1065 | 623 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13318010 | 13318010 | PRJNA577580_P_NODE_1891_length_661_cov_16.153061_g1816_i0 | PRJNA577580 | 1891 | 661 | 16.153061 | 106.77173321 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.018 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g1816 | i0 | 100 | 0.0438729198184569 | 29 | 0 | 4 | 0 | 1 | 29 | 7 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 17141721 | 17141721 | PRJNA577580_P_NODE_9134_length_301_cov_1.478070_g9056_i0 | PRJNA577580 | 9134 | 301 | 1.47807 | 4.4489907 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 529 | 1.0599999999999996e-145 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g9056 | i0 | 98.339 | 3 | 301 | 5 | 100 | 0 | 1 | 301 | 4728 | 4428 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 903 | 529 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 28058722 | 28058722 | PRJNA577580_P_NODE_12625_length_261_cov_1.659574_g12547_i0 | PRJNA577580 | 12625 | 261 | 1.659574 | 4.33148814 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 52.8 | 1.41e-5 | NR | UJQ92489.1 | 2809572 | g12547 | i0 | 35.7 | 0.804597701149425 | 70 | 45 | 80.5 | 0 | 52 | 261 | 20 | 89 | UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 210 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28248070 | 28248070 | PRJNA577580_P_NODE_686_length_1036_cov_2.997923_g637_i0 | PRJNA577580 | 686 | 1036 | 2.997923 | 31.05848228 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 171 | 1.1e-43 | NR | UJQ92489.1 | 2809572 | g637 | i0 | 37.2 | 0.732625482625483 | 253 | 154 | 71.8 | 2 | 270 | 1013 | 9 | 261 | UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 759 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29745446 | 29745446 | PRJNA577580_P_NODE_9010_length_303_cov_1.356522_g8932_i0 | PRJNA577580 | 9010 | 303 | 1.356522 | 4.11026166 | Duamitovirus | 2948686 | Viruses | Viruses | 116 | 1.1300000000000002e-27 | NR | YP_004564622.1 | 1037523 | g8932 | i0 | 65.5 | 4.16831683168317 | 84 | 23 | 77.2 | 1 | 239 | 6 | 339 | 422 | YP_004564622.1 RNA-dependent RNA polymerase [Tuber aestivum mitovirus] | diamond | 1263 | 117 | 0.991452991452991 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus tuae1 | ||
| 30047870 | 30047870 | PRJNA577580_P_NODE_16671_length_238_cov_2.024242_g16593_i0 | PRJNA577580 | 16671 | 238 | 2.024242 | 4.81769596 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 46.6 | 0.00155 | NR | UJQ92489.1 | 2809572 | g16593 | i0 | 36.5 | 0.794117647058823 | 63 | 40 | 79.4 | 0 | 235 | 47 | 167 | 229 | UJQ92489.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 189 | 46.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 30205775 | 30205775 | PRJNA577580_P_NODE_52_length_2278_cov_8.436735_g41_i0 | PRJNA577580 | 52 | 2278 | 8.436735 | 192.1888233 | Diaporthe gulyae mitovirus 3 | 3077427 | Viruses | Viruses | 144 | 8.62e-32 | NR | WNM95031.1 | 3077427 | g41 | i0 | 29.2 | 0.578138718173837 | 439 | 269 | 55.7 | 12 | 406 | 1674 | 70 | 482 | WNM95031.1 MAG: RNA-dependent RNA polymerase [Diaporthe gulyae mitovirus 3] | diamond | 1317 | 144 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Diaporthe gulyae mitovirus 3 | ||
| 31311941 | 31311941 | PRJNA577580_P_NODE_435_length_1234_cov_7.890612_g397_i0 | PRJNA577580 | 435 | 1234 | 7.890612 | 97.37015208 | Ripajen virus | 3131483 | Viruses | Viruses | 155 | 1.24e-37 | NR | WZH61493.1 | 3131483 | g397 | i0 | 36.5 | 0.838735818476499 | 345 | 198 | 81.9 | 10 | 1011 | 1 | 45 | 376 | WZH61493.1 MAG: RNA-dependent RNA polymerase [Ripajen virus] | diamond | 1035 | 155 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripajen virus | |||
| 32703228 | 32703228 | PRJNA577580_P_NODE_9520_length_296_cov_1.399103_g9442_i0 | PRJNA577580 | 9520 | 296 | 1.399103 | 4.14134488 | Guangxi riverbank mitovirus 3 | 2937069 | Viruses | Viruses | 69.7 | 2.31e-11 | NR | UPW42193.1 | 2937069 | g9442 | i0 | 40.2 | 2.93918918918919 | 97 | 57 | 97.3 | 1 | 295 | 8 | 379 | 475 | UPW42193.1 MAG: putative RNA dependent RNA polymerase [Guangxi riverbank mitovirus 3] | diamond | 870 | 69.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Guangxi riverbank mitovirus 3 |
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);;