RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA437204" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 31 ✖

bioproject 1

  • PRJNA437204 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
4260001 4260001 PRJNA437204_P_NODE_6164_length_650_cov_1.790295_g5871_i0 PRJNA437204 6164 650 1.790295 11.6369175 Picornaviridae sp. 1530251 Viruses Viruses 418 3.48e-141   NR URG14866.1 1530251 g5871 i0 94 0.996923076923077 216 13 99.7 0 649 2 275 490 URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 648 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
20833642 20833642 PRJNA437204_P_NODE_125037_length_241_cov_1.351190_g124738_i0 PRJNA437204 125037 241 1.35119 3.2563679 Picornaviridae sp. 1530251 Viruses Viruses 162 4.92e-45   NR URG14866.1 1530251 g124738 i0 96.2 0.983402489626556 79 3 98.3 0 241 5 182 260 URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 237 162 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
23385361 23385361 PRJNA437204_P_NODE_719_length_1465_cov_3.561782_g602_i0 PRJNA437204 719 1465 3.561782 52.1801063 Hangzhou marna-like virus 1 3029006 Viruses Viruses 706 4.559999999999999e-229   NR WEU70895.1 3029006 g602 i0 72.1 0.974744027303754 476 132 97.3 1 1461 37 2219 2694 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 1428 706 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
26727296 26727296 PRJNA437204_P_NODE_32081_length_349_cov_0.967391_g31782_i0 PRJNA437204 32081 349 0.967391 3.37619459 Qianjiang hepeli-like virus 14 3348976 Viruses Viruses 114 7.94e-27   NR XHA85831.1 3348976 g31782 i0 55 0.936962750716332 109 48 93.7 1 20 346 292 399 XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14] diamond 327 114 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Qianjiang hepeli-like virus 14
27392087 27392087 PRJNA437204_P_NODE_117883_length_243_cov_0.905882_g117584_i0 PRJNA437204 117883 243 0.905882 2.20129326 Marnaviridae sp. 2715102 Viruses Viruses 70.5 6.23e-12   NR ULF99987.1 2715102 g117584 i0 43.8 0.987654320987654 80 45 98.8 0 3 242 184 263 ULF99987.1 MAG: hypothetical protein 2 [Marnaviridae sp.] diamond 240 70.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
27644789 27644789 PRJNA437204_P_NODE_484_length_1640_cov_1.531589_g399_i0 PRJNA437204 484 1640 1.531589 25.1180596 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 581 1.4799999999999995e-196   NR XCM68125.1 3003959 g399 i0 60 0.878048780487805 480 184 87.3 6 2 1432 373 847 XCM68125.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1440 581 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27739610 27739610 PRJNA437204_P_NODE_124344_length_242_cov_0.905325_g124045_i0 PRJNA437204 124344 242 0.905325 2.1908865 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 105 3.0999999999999997e-24   NR XCM68009.1 3003959 g124045 i0 55 0.991735537190083 80 36 99.2 0 3 242 286 365 XCM68009.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 240 105 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28212646 28212646 PRJNA437204_P_NODE_98986_length_247_cov_0.885057_g98687_i0 PRJNA437204 98986 247 0.885057 2.18609079 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 65.1 5.16e-10   NR XCM67838.1 3003959 g98687 i0 36.7 0.959514170040486 79 50 96 0 239 3 536 614 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 237 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28418913 28418913 PRJNA437204_P_NODE_3566_length_809_cov_1.470109_g3307_i0 PRJNA437204 3566 809 1.470109 11.89318181 Viruses 10239 Viruses Viruses 219 2.96e-65   NR XCM68010.1 1955153 g3307 i0 58 3.47836835599506 176 74 65.3 0 529 2 36 211 XCM68010.1 MAG: structural polyprotein, partial [Picornavirales sp.] diamond 2814 219 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28497162 28497162 PRJNA437204_P_NODE_17727_length_431_cov_1.589385_g17428_i0 PRJNA437204 17727 431 1.589385 6.85024935 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 70.5 6.37e-11   NR XCM67928.1 3003959 g17428 i0 29.8 1.82366589327146 131 84 91.2 3 2 394 1066 1188 XCM67928.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 786 70.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28591897 28591897 PRJNA437204_P_NODE_51667_length_297_cov_1.142857_g51368_i0 PRJNA437204 51667 297 1.142857 3.39428529 Marnaviridae sp. 2715102 Viruses Viruses 63.5 3.5e-9   NR QRI44262.1 2715102 g51368 i0 55.4 1.15151515151515 65 26 65.7 1 86 280 456 517 QRI44262.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] diamond 342 63.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
28718167 28718167 PRJNA437204_P_NODE_71147_length_263_cov_1.552632_g70848_i0 PRJNA437204 71147 263 1.552632 4.08342216 Striga asiatica dicistro-like virus 1 2943843 Viruses Viruses 163 1.0800000000000001e-44   NR UQR78685.1 2943843 g70848 i0 85.1 1.98479087452471 87 13 99.2 0 262 2 444 530 UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1] diamond 522 163 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Striga asiatica dicistro-like virus 1
28875903 28875903 PRJNA437204_P_NODE_123428_length_242_cov_0.911243_g123129_i0 PRJNA437204 123428 242 0.911243 2.20520806 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 81.3 1.01e-15   NR XCM68268.1 3003959 g123129 i0 48.1 0.954545454545455 77 40 95.5 0 242 12 594 670 XCM68268.1 MAG: helicase, partial [Picornavirales sp.] diamond 231 81.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29065488 29065488 PRJNA437204_P_NODE_3788_length_791_cov_1.330084_g3526_i0 PRJNA437204 3788 791 1.330084 10.52096444 Hangzhou marna-like virus 1 3029006 Viruses Viruses 417 6.669999999999998e-130   NR WEU70895.1 3029006 g3526 i0 72.1 0.993678887484197 262 73 99.4 0 6 791 1146 1407 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 786 417 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
29507359 29507359 PRJNA437204_P_NODE_49270_length_302_cov_1.340611_g48971_i0 PRJNA437204 49270 302 1.340611 4.04864522 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 49.3 3.92e-4   NR UNY41988.1 3003959 g48971 i0 64.3 0.417218543046358 42 13 40.7 2 299 177 2898 2938 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 126 49.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29538914 29538914 PRJNA437204_P_NODE_50210_length_300_cov_1.343612_g49911_i0 PRJNA437204 50210 300 1.343612 4.030836 Kummerowia striata picorna-like virus 2739852 Viruses Viruses 148 5.2e-39   NR QKK82977.1 2739852 g49911 i0 72.4 0.98 98 27 98 0 6 299 1255 1352 QKK82977.1 hypothetical protein 1 [Kummerowia striata picorna-like virus] diamond 294 148 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Kummerowia striata picorna-like virus
29854803 29854803 PRJNA437204_P_NODE_26751_length_371_cov_1.030201_g26452_i0 PRJNA437204 26751 371 1.030201 3.82204571 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 207 3.38e-59   NR XCM68009.1 3003959 g26452 i0 77.2 5.93530997304582 123 28 99.5 0 370 2 1363 1485 XCM68009.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 2202 207 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30044208 30044208 PRJNA437204_P_NODE_3451_length_817_cov_2.692204_g3193_i0 PRJNA437204 3451 817 2.692204 21.99530668 Hangzhou marna-like virus 1 3029006 Viruses Viruses 451 1.04e-141   NR WEU70895.1 3029006 g3193 i0 84 0.987760097919217 269 43 98.8 0 808 2 1947 2215 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 807 451 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
30075765 30075765 PRJNA437204_P_NODE_53072_length_294_cov_1.153846_g52773_i0 PRJNA437204 53072 294 1.153846 3.39230724 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 154 6.25e-41   NR XCM67914.1 3003959 g52773 i0 72.2 0.989795918367347 97 27 99 0 292 2 2011 2107 XCM67914.1 MAG: polyprotein [Picornavirales sp.] diamond 291 154 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30549731 30549731 PRJNA437204_P_NODE_26553_length_372_cov_0.996656_g26254_i0 PRJNA437204 26553 372 0.996656 3.70756032 Striga asiatica dicistro-like virus 1 2943843 Viruses Viruses 202 2.09e-58   NR UQR78685.1 2943843 g26254 i0 79.7 0.991935483870968 123 25 99.2 0 370 2 200 322 UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1] diamond 369 202 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Striga asiatica dicistro-like virus 1
30612868 30612868 PRJNA437204_P_NODE_53153_length_294_cov_1.045249_g52854_i0 PRJNA437204 53153 294 1.045249 3.07303206 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 2.69e-32   NR XCM67914.1 3003959 g52854 i0 68.4 1 98 30 99 1 292 2 2342 2439 XCM67914.1 MAG: polyprotein [Picornavirales sp.] diamond 294 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30739317 30739317 PRJNA437204_P_NODE_1754_length_1045_cov_1.350823_g1556_i0 PRJNA437204 1754 1045 1.350823 14.11610035 Hangzhou marna-like virus 1 3029006 Viruses Viruses 496 3.5599999999999996e-156   NR WEU70895.1 3029006 g1556 i0 71.5 0.98755980861244 344 95 98.2 3 1028 3 68 410 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 1032 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
30739318 30739318 PRJNA437204_P_NODE_17774_length_431_cov_0.963687_g17475_i0 PRJNA437204 17774 431 0.963687 4.15349097 Jeanralphio narna-like virus 2716644 Viruses Viruses 184 1.24e-51   NR QIJ70055.1 2716644 g17475 i0 60 1.04408352668213 150 53 99.5 1 1 429 255 404 QIJ70055.1 RNA-dependent RNA polymerase [Jeanralphio narna-like virus] diamond 450 184 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Jeanralphio narna-like virus
31244898 31244898 PRJNA437204_P_NODE_24395_length_383_cov_1.338710_g24096_i0 PRJNA437204 24395 383 1.33871 5.1272593 Striga asiatica dicistro-like virus 1 2943843 Viruses Viruses 204 6.61e-59   NR UQR78685.1 2943843 g24096 i0 76.4 0.994778067885117 127 30 99.5 0 1 381 67 193 UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1] diamond 381 204 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Striga asiatica dicistro-like virus 1
31403276 31403276 PRJNA437204_P_NODE_77796_length_253_cov_1.711111_g77497_i0 PRJNA437204 77796 253 1.711111 4.32911083 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 126 1.7999999999999998e-31   NR XCM67914.1 3003959 g77497 i0 71.1 0.984189723320158 83 24 98.4 0 251 3 1791 1873 XCM67914.1 MAG: polyprotein [Picornavirales sp.] diamond 249 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31403281 31403281 PRJNA437204_P_NODE_876_length_1359_cov_1.601866_g743_i0 PRJNA437204 876 1359 1.601866 21.76935894 Hangzhou marna-like virus 1 3029006 Viruses Viruses 280 1.6500000000000002e-79   NR WEU70895.1 3029006 g743 i0 36.6 1.00220750551876 454 257 99.8 5 1 1356 646 1070 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 1362 280 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
31498139 31498139 PRJNA437204_P_NODE_103216_length_246_cov_0.890173_g102917_i0 PRJNA437204 103216 246 0.890173 2.18982558 Poplar mosaic virus 12166 Viruses Viruses 164 7.56e-45   NR NP_958171.1 12166 g102917 i0 89 1 82 9 100 0 246 1 1894 1975 NP_958171.1 replicase [Poplar mosaic virus] diamond 246 164 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus populi
31798865 31798865 PRJNA437204_P_NODE_56697_length_287_cov_1.093458_g56398_i0 PRJNA437204 56697 287 1.093458 3.13822446 Viruses 10239 Viruses Viruses 71.2 6e-12   NR XCM67884.1 1955153 g56398 i0 69.8 2.55052264808362 43 13 44.9 0 232 104 376 418 XCM67884.1 MAG: structural polyprotein [Picornavirales sp.] diamond 732 71.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
32004187 32004187 PRJNA437204_P_NODE_22998_length_391_cov_1.333333_g22699_i0 PRJNA437204 22998 391 1.333333 5.21333203 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 126 8.2e-31   NR XCM68268.1 3003959 g22699 i0 49.6 0.867007672634271 113 51 86.7 1 3 341 898 1004 XCM68268.1 MAG: helicase, partial [Picornavirales sp.] diamond 339 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32130881 32130881 PRJNA437204_P_NODE_21198_length_403_cov_0.927273_g20899_i0 PRJNA437204 21198 403 0.927273 3.73691019 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 90.9 3.35e-18   NR XCM67838.1 3003959 g20899 i0 37.5 0.952853598014888 128 65 95.3 1 403 20 726 838 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 384 90.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32383783 32383783 PRJNA437204_P_NODE_28659_length_362_cov_1.373702_g28360_i0 PRJNA437204 28659 362 1.373702 4.97280124 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.3 8.19e-17   NR XCM68437.1 3003959 g28360 i0 41.7 2.96685082872928 120 70 99.4 0 361 2 240 359 XCM68437.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 1074 86.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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