RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA577580" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 12 ✖

bioproject 1

  • PRJNA577580 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1839450 1839450 PRJNA577580_P_NODE_10082_length_288_cov_3.153488_g10004_i0 PRJNA577580 10082 288 3.153488 9.08204544 Caudoviricetes sp. vir323 3068356 Viruses Viruses 102 2.61e-17   NTclustered gi|2587525388|tpg|BK063679.1| 3068356 g10004 i0 87.5 3.68402777777778 88 11 90 0 10 97 8906 8819 TPA_asm: Caudoviricetes sp. vir323 genomic sequence blastn 1061 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp. vir323
4391537 4391537 PRJNA577580_P_NODE_6324_length_357_cov_2.003521_g6246_i0 PRJNA577580 6324 357 2.003521 7.15256997 Cotonvirus japonicum 3059904 Viruses Viruses 67.6 1.21e-6   NTclustered gi|2500766720|ref|NC_079139.1| 2811091 g6246 i0 81.395 0.57703081232493 86 12 24 4 3 86 533397 533314 Cotonvirus japonicus DNA, complete genome blastn 206 67.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Cotonvirus Cotonvirus japonicum
6241738 6241738 PRJNA577580_P_NODE_7845_length_322_cov_1.831325_g7767_i0 PRJNA577580 7845 322 1.831325 5.8968665 Megavirus 3044761 Viruses Viruses 78.7 4.99e-10   NTclustered gi|363539767|ref|NC_016072.1| 1094892 g7767 i0 84.146 1.7360248447205 82 11 25 2 58 138 1129728 1129808 Megavirus chiliensis, complete genome blastn 559 78.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Megavirus Megavirus chilense
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
13318068 13318068 PRJNA577580_P_NODE_8211_length_316_cov_1.358025_g8133_i0 PRJNA577580 8211 316 1.358025 4.291359 Caudoviricetes sp. 2832643 Viruses Viruses 80.5 1.36e-10   NTclustered gi|2914774203|gb|OR222100.1| 2832643 g8133 i0 88.235 27.8481012658228 68 6 21 2 169 235 33141 33207 MAG: Caudoviricetes sp. isolate MSP0010 genomic sequence blastn 8800 80.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14592919 14592919 PRJNA577580_P_NODE_4912_length_404_cov_2.592145_g4834_i0 PRJNA577580 4912 404 2.592145 10.4722658 Caudoviricetes sp. vir323 3068356 Viruses Viruses 121 1.05e-22   NTclustered gi|2587525388|tpg|BK063679.1| 3068356 g4834 i0 75.397 5.22772277227723 252 60 79 2 78 328 9381 9131 TPA_asm: Caudoviricetes sp. vir323 genomic sequence blastn 2112 121 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp. vir323
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
18415951 18415951 PRJNA577580_P_NODE_3575_length_476_cov_3.548387_g3497_i0 PRJNA577580 3575 476 3.548387 16.89032212 Pseudomonas phage Lu11 1161927 Viruses Viruses 63.9 2.14e-5   NTclustered gi|388684650|ref|NC_017972.1| 1161927 g3497 i0 87.719 0.672268907563025 57 4 12 2 32 88 124877 124824 Pseudomonas phage Lu11, complete genome blastn 320 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Lu11

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