RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 15 ✖

bioproject 1

  • PRJNA1126661 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
282354 282354 PRJNA1126661_P_NODE_32461_length_308_cov_2.148936_g31932_i0 PRJNA1126661 32461 308 2.148936 6.61872288 Zebrafish picornavirus 1 2304617 Viruses Viruses 529 1.0899999999999996e-145   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g31932 i0 97.72 2.98376623376623 307 7 99 0 2 308 1850 2156 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 919 529 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2833132 2833132 PRJNA1126661_P_NODE_41363_length_301_cov_2.991228_g40834_i0 PRJNA1126661 41363 301 2.991228 9.00359628 Fabavirus alphaviciae 3047701 Viruses Viruses 255 1.99e-63   NTclustered gi|1524754184|gb|MH645162.1| 50817 g40834 i0 97.333 5.7109634551495 150 4 99 0 151 300 1655 1804 Broad bean wilt virus 1 isolate BBWV1_RNA2, partial genome blastn 1719 255 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus alphaviciae
6660697 6660697 PRJNA1126661_P_NODE_82906_length_214_cov_5.156028_g82376_i0 PRJNA1126661 82906 214 5.156028 11.03389992 Zebrafish picornavirus 1 2304617 Viruses Viruses 357 3.5699999999999996e-94   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g82376 i0 96.729 3 214 7 100 0 1 214 6863 7076 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 642 357 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13035858 13035858 PRJNA1126661_P_NODE_1631_length_832_cov_2.060606_g1186_i0 PRJNA1126661 1631 832 2.060606 17.14424192 Zebrafish picornavirus 1 2304617 Viruses Viruses 1482 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g1186 i0 98.798 3 832 10 100 0 1 832 3688 4519 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 2496 1482 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
15585106 15585106 PRJNA1126661_P_NODE_1893_length_731_cov_1.585106_g1414_i0 PRJNA1126661 1893 731 1.585106 11.58712486 Zebrafish picornavirus 1 2304617 Viruses Viruses 1223 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1414 i0 96.854 2.99726402188782 731 23 100 0 1 731 4451 5181 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2191 1223 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17608385 17608385 PRJNA1126661_P_NODE_11954_length_326_cov_6.169960_g11425_i0 PRJNA1126661 11954 326 6.16996 20.1140696 Enterovirus 12059 Viruses Viruses 279 1.29e-70   NTclustered gi|2296422178|gb|OP410463.1| 12083 g11425 i0 100 91.9355828220859 151 0 93 0 176 326 2667 2517 Human poliovirus 2 isolate ENV_UNK_LON_NEW_BEC_22_036_F7, complete genome blastn 29971 279 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus coxsackiepol
17608877 17608877 PRJNA1126661_P_NODE_82614_length_215_cov_5.443662_g82084_i0 PRJNA1126661 82614 215 5.443662 11.7038733 Tobamovirus 12234 Viruses Viruses 396 7.6e-106   NTclustered gi|2184811942|gb|MW430120.1| 12235 g82084 i0 100 99.5348837209302 214 0 99 0 1 214 5129 5342 Cucumber green mottle mosaic virus isolate WA-3, complete genome blastn 21400 396 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus viridimaculae
19408553 19408553 PRJNA1126661_P_NODE_62956_length_271_cov_2.363636_g62426_i0 PRJNA1126661 62956 271 2.363636 6.40545356 Fabavirus alphaviciae 3047701 Viruses Viruses 412 9.899999999999997e-111   NTclustered gi|1524754184|gb|MH645162.1| 50817 g62426 i0 94.096 5.97785977859779 271 16 100 0 1 271 522 792 Broad bean wilt virus 1 isolate BBWV1_RNA2, partial genome blastn 1620 412 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Fabavirus Fabavirus alphaviciae
19408706 19408706 PRJNA1126661_P_NODE_79056_length_228_cov_6.348387_g78526_i0 PRJNA1126661 79056 228 6.348387 14.47432236 Tobamovirus viridimaculae 3432895 Viruses Viruses 422 1.34e-113   NTclustered gi|2184811942|gb|MW430120.1| 12235 g78526 i0 100 100 228 0 100 0 1 228 1406 1633 Cucumber green mottle mosaic virus isolate WA-3, complete genome blastn 22800 422 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus viridimaculae
19408757 19408757 PRJNA1126661_P_NODE_876_length_1386_cov_1.932216_g601_i0 PRJNA1126661 876 1386 1.932216 26.78051376 Zebrafish picornavirus 1 2304617 Viruses Viruses 2388 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g601 i0 97.763 2.997113997114 1386 31 100 0 1 1386 5398 6783 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 4154 2388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
20683602 20683602 PRJNA1126661_P_NODE_17437_length_326_cov_4.426877_g16908_i0 PRJNA1126661 17437 326 4.426877 14.43161902 Allexivirus deltallii 3433711 Viruses Viruses 65.8 3.94e-6   NTclustered gi|2059392176|gb|MT279193.1| 12430 g16908 i0 100 0.107361963190184 35 0 11 0 254 288 35 1 Garlic virus D isolate GarVD_BR, complete genome blastn 35 65.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Allexivirus Allexivirus deltallii
21432763 21432763 PRJNA1126661_P_NODE_26757_length_326_cov_2.976285_g26228_i0 PRJNA1126661 26757 326 2.976285 9.7026891 Tobamovirus 12234 Viruses Viruses 508 1.51e-139   NTclustered gi|2497646326|gb|OQ198404.1| 12235 g26228 i0 92.355 100.306748466258 327 24 100 1 1 326 627 301 Cucumber green mottle mosaic virus isolate NT-2015-02, partial genome blastn 32700 508 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus viridimaculae
21959531 21959531 PRJNA1126661_P_NODE_70558_length_252_cov_0.871508_g70028_i0 PRJNA1126661 70558 252 0.871508 2.19620016 Zebrafish picornavirus 1 2304617 Viruses Viruses 416 7.029999999999999e-112   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g70028 i0 96.429 3 252 9 100 0 1 252 7811 7560 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 756 416 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24508517 24508517 PRJNA1126661_P_NODE_4800_length_399_cov_1.644172_g4273_i0 PRJNA1126661 4800 399 1.644172 6.56024628 Zebrafish picornavirus 1 2304617 Viruses Viruses 652 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g4273 i0 96.231 2.99248120300752 398 15 99 0 2 399 1366 969 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1194 652 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24508634 24508634 PRJNA1126661_P_NODE_59940_length_278_cov_2.282927_g59410_i0 PRJNA1126661 59940 278 2.282927 6.34653706 Malassezia restricta virus MrV40L 2727863 Viruses Viruses 470 5.959999999999998e-128   NTclustered gi|1832308141|gb|MN603497.1| 2727863 g59410 i0 97.122 1.16906474820144 278 8 100 0 1 278 2727 3004 Malassezia restricta virus MrV40L, complete genome blastn 325 470 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L

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