RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 18 ✖

bioproject 1

  • PRJNA561212 · 18 ✖

analysis 1

  • diamond · 18 ✖

tax_clade 0

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
545332 545332 PRJNA561212_P_NODE_1_length_10659_cov_2833.062441_g0_i0 PRJNA561212 1 10659 2833.062441 301976.12558619 Viruses 10239 Viruses Viruses 833 6.05e-254   NR XCO48968.1 1955144 g0 i0 32.2 5.04728398536448 1841 962 50 38 1940 7267 153 1772 XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 53799 841 0.990487514863258 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
26635850 26635850 PRJNA561212_P_NODE_25501_length_243_cov_0.917647_g25290_i0 PRJNA561212 25501 243 0.917647 2.22988221 Sanya narna-like virus 1 2970204 Viruses Viruses 69.7 1.16e-11   NR UUW20996.1 2970204 g25290 i0 47.9 0.901234567901235 73 37 90.1 1 18 236 480 551 UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1] diamond 219 69.7 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sanya narna-like virus 1
27363863 27363863 PRJNA561212_P_NODE_15783_length_284_cov_1.289100_g15572_i0 PRJNA561212 15783 284 1.2891 3.661044 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 77.8 3.01e-14   NR XHA88449.1 3348787 g15572 i0 37.4 0.961267605633803 91 57 96.1 0 12 284 195 285 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 273 77.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
27566832 27566832 PRJNA561212_P_NODE_1844_length_800_cov_1.343879_g1656_i0 PRJNA561212 1844 800 1.343879 10.751032 Viruses 10239 Viruses Viruses 59.7 5.01e-6   NR UUG74260.1 2952015 g1656 i0 26.3 4.29 232 161 85.9 4 787 101 575 799 UUG74260.1 MAG: hypothetical protein, partial [XiangYun toti-like virus 7] diamond 3432 59.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   XiangYun toti-like virus 7
27995162 27995162 PRJNA561212_P_NODE_4405_length_528_cov_1.369231_g4196_i0 PRJNA561212 4405 528 1.369231 7.22953968 Sclerotinia sclerotiorum narnavirus 1 2822897 Viruses Viruses 63.5 1.46e-8   NR QZE12035.1 2822897 g4196 i0 33.6 0.744318181818182 131 80 73.3 3 108 494 35 160 QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1] diamond 393 63.5 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Sclerotinia sclerotiorum narnavirus 1
28153137 28153137 PRJNA561212_P_NODE_11305_length_329_cov_2.937500_g11094_i0 PRJNA561212 11305 329 2.9375 9.664375 Picornaviridae sp. 1530251 Viruses Viruses 106 2.1699999999999994e-24   NR WWV87070.1 1530251 g11094 i0 49.1 0.966565349544073 106 54 96.7 0 319 2 120 225 WWV87070.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 318 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28247506 28247506 PRJNA561212_P_NODE_25886_length_242_cov_0.923077_g25675_i0 PRJNA561212 25886 242 0.923077 2.23384634 Sopuslov virus 3131840 Viruses Viruses 50.1 7.54e-5   NR WZH62005.1 3131840 g25675 i0 37.7 0.954545454545455 77 40 93 3 230 6 92 162 WZH62005.1 MAG: RNA-dependent RNA polymerase, partial [Sopuslov virus] diamond 231 50.1 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Sopuslov virus
28956444 28956444 PRJNA561212_P_NODE_9148_length_364_cov_0.951890_g8937_i0 PRJNA561212 9148 364 0.95189 3.4648796 Viruses 10239 Viruses Viruses 72.8 1.7e-12   NR WPR17273.1 3066908 g8937 i0 36.1 5.83516483516483 119 74 97.3 2 9 362 121 238 WPR17273.1 MAG: RNA-dependent RNA polymerase, partial [Dracophyllum associated narna-like virus 70] diamond 2124 72.8 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Dracophyllum associated narna-like virus 70
29195056 29195056 PRJNA561212_P_NODE_209_length_1944_cov_2.265099_g160_i0 PRJNA561212 209 1944 2.265099 44.03352456 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 195 3.21e-48   NR XHA88449.1 3348787 g160 i0 52.3 0.300925925925926 195 82 30.1 3 16 600 378 561 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 585 195 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
29447283 29447283 PRJNA561212_P_NODE_90_length_2617_cov_2.301101_g67_i0 PRJNA561212 90 2617 2.301101 60.21981317 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 390 4.769999999999999e-112   NR XHA88449.1 3348787 g67 i0 40.1 0.765762323270921 668 335 74.4 22 11 1957 1946 2567 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 2004 390 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
29731386 29731386 PRJNA561212_P_NODE_430_length_1489_cov_1.766949_g342_i0 PRJNA561212 430 1489 1.766949 26.30987061 Prasiola crispa toti-like virus 2933125 Viruses Viruses 83.6 9.71e-13   NR CAI5383882.1 2933125 g342 i0 23.7 0.979180658159839 486 313 90.1 17 1481 141 193 659 CAI5383882.1 putative capsid protein [Prasiola crispa toti-like virus] diamond 1458 83.6 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Prasiola crispa toti-like virus
30616103 30616103 PRJNA561212_P_NODE_12713_length_312_cov_2.150628_g12502_i0 PRJNA561212 12713 312 2.150628 6.70995936 Picornaviridae sp. 1530251 Viruses Viruses 117 4.65e-29   NR WWV86705.1 1530251 g12502 i0 53.9 0.980769230769231 102 46 97.1 1 2 304 134 235 WWV86705.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 306 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30710972 30710972 PRJNA561212_P_NODE_16334_length_280_cov_1.091787_g16123_i0 PRJNA561212 16334 280 1.091787 3.0570036 Hangzhou nephotettix cincticeps phenuivirus 1 2905447 Viruses Viruses 71.2 5.74e-12   NR UHK03292.1 2905447 g16123 i0 45.3 0.685714285714286 64 35 68.6 0 208 17 1554 1617 UHK03292.1 MAG: RNA-dependent RNA polymerase [Hangzhou nephotettix cincticeps phenuivirus 1] diamond 192 71.2 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Phenuiviridae   Hangzhou nephotettix cincticeps phenuivirus 1
31659170 31659170 PRJNA561212_P_NODE_4777_length_507_cov_2.195853_g4568_i0 PRJNA561212 4777 507 2.195853 11.13297471 Prasiola crispa toti-like virus 2933125 Viruses Viruses 67.4 1.57e-9   NR CAI5383883.1 2933125 g4568 i0 31.9 0.834319526627219 141 93 82.2 2 16 432 47 186 CAI5383883.1 RNA-dependent RNA polymerase [Prasiola crispa toti-like virus] diamond 423 67.4 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Prasiola crispa toti-like virus
31975656 31975656 PRJNA561212_P_NODE_1898_length_787_cov_30.278711_g1707_i0 PRJNA561212 1898 787 30.278711 238.29345557 Frijoles virus VP-161A 426788 Viruses Viruses 71.6 1.52e-11   NR YP_009665189.1 426788 g1707 i0 38.7 1.13214739517154 111 66 42.3 1 158 490 27 135 YP_009665189.1 N protein, partial [Frijoles virus VP-161A] diamond 891 71.6 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Phenuiviridae Phlebovirus Phlebovirus limboense
32292475 32292475 PRJNA561212_P_NODE_2199_length_735_cov_1.321752_g2002_i0 PRJNA561212 2199 735 1.321752 9.7148772 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 89 4.23e-16   NR XCO56027.1 3233859 g2002 i0 30.4 1.66530612244898 204 130 83.3 2 114 725 575 766 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 1224 89 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
32418748 32418748 PRJNA561212_P_NODE_5659_length_465_cov_0.920918_g5448_i0 PRJNA561212 5659 465 0.920918 4.2822687 brine shrimp arlivirus 9 2900384 Viruses Viruses 284 1.13e-92   NR UNI74140.1 2900384 g5448 i0 92.8 1.96129032258065 152 11 98.1 0 10 465 198 349 UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 912 284 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
32576993 32576993 PRJNA561212_P_NODE_539_length_1376_cov_1.987721_g436_i0 PRJNA561212 539 1376 1.987721 27.35104096 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 302 6.87e-87   NR XHA88449.1 3348787 g436 i0 40.6 1.0094476744186 463 215 99 6 1371 10 1534 1945 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 1389 302 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;