RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1144090 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
18138955 18138955 PRJNA1144090_P_NODE_31975_length_464_cov_2.867008_g31440_i0 PRJNA1144090 31975 464 2.867008 13.30291712 Marnaviridae sp. 2715102 Viruses Viruses 268 7.33e-86   NR QRI44260.1 2715102 g31440 i0 83.7 2.9676724137931 153 25 98.9 0 463 5 154 306 QRI44260.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] diamond 1377 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
27165106 27165106 PRJNA1144090_P_NODE_10842_length_855_cov_3.134271_g10407_i0 PRJNA1144090 10842 855 3.134271 26.79801705 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 221 5.89e-62   NR XCM67754.1 3003959 g10407 i0 42.9 1.98947368421053 287 146 97.5 4 835 2 368 645 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1701 221 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27512874 27512874 PRJNA1144090_P_NODE_103_length_4134_cov_5.010835_g87_i0 PRJNA1144090 103 4134 5.010835 207.1479189 Zebrafish gut calicivirus RQ08 Viruses Viruses 972 0   NR XBS25272.1 RQ08 g87 i0 41.7 0.957910014513788 1320 694 91.9 25 3798 1 199 1496 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 3960 972 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27512910 27512910 PRJNA1144090_P_NODE_33203_length_453_cov_4.081579_g32668_i0 PRJNA1144090 33203 453 4.081579 18.48955287 Zebrafish gut calicivirus RQ08 Viruses Viruses 68.2 5.3e-10   NR AVM87224.1 RQ08 g32668 i0 32.4 0.960264900662252 145 85 89.4 5 34 438 42 183 AVM87224.1 polyprotein [Fujian spotted paddle-tail newt calicivirus] diamond 435 68.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
27544476 27544476 PRJNA1144090_P_NODE_52084_length_353_cov_2.032143_g51549_i0 PRJNA1144090 52084 353 2.032143 7.17346479 Picornaviridae sp. 1530251 Viruses Viruses 191 8.819999999999998e-54   NR URG14835.1 1530251 g51549 i0 67.5 0.994334277620397 117 38 99.4 0 2 352 364 480 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 351 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
27702613 27702613 PRJNA1144090_P_NODE_25104_length_533_cov_3.163043_g24573_i0 PRJNA1144090 25104 533 3.163043 16.85901919 Picornaviridae sp. 1530251 Viruses Viruses 64.3 2.2e-8   NR URG14836.1 1530251 g24573 i0 34.7 0.534709193245779 95 60 52.3 1 13 291 564 658 URG14836.1 MAG: capsid protein [Picornaviridae sp.] diamond 285 64.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28428596 28428596 PRJNA1144090_P_NODE_22666_length_566_cov_2.385396_g22139_i0 PRJNA1144090 22666 566 2.385396 13.50134136 Picornaviridae sp. 1530251 Viruses Viruses 140 1.08e-34   NR URG14835.1 1530251 g22139 i0 41.3 1.03886925795053 196 104 98.1 5 565 11 762 957 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 588 140 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28649680 28649680 PRJNA1144090_P_NODE_79027_length_283_cov_3.057143_g78492_i0 PRJNA1144090 79027 283 3.057143 8.65171469 Picornaviridae sp. 1530251 Viruses Viruses 97.4 3.8e-21   NR URG14835.1 1530251 g78492 i0 52.1 0.996466431095406 94 45 99.6 0 1 282 642 735 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 282 97.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28681323 28681323 PRJNA1144090_P_NODE_85867_length_271_cov_2.858586_g85332_i0 PRJNA1144090 85867 271 2.858586 7.74676806 Ripimarn virus 3130173 Viruses Viruses 98.2 1.69e-21   NR WZH59220.1 3130173 g85332 i0 53.4 0.974169741697417 88 38 97.4 1 270 7 116 200 WZH59220.1 MAG: hypothetical protein [Ripimarn virus] diamond 264 98.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Ripimarn virus
28712724 28712724 PRJNA1144090_P_NODE_20167_length_604_cov_4.367232_g19643_i0 PRJNA1144090 20167 604 4.367232 26.37808128 Picornaviridae sp. 1530251 Viruses Viruses 260 2e-76   NR URG14835.1 1530251 g19643 i0 64.7 0.928807947019868 187 66 92.9 0 575 15 1067 1253 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 561 260 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28744276 28744276 PRJNA1144090_P_NODE_62347_length_321_cov_2.254032_g61812_i0 PRJNA1144090 62347 321 2.254032 7.23544272 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 152 4.26e-40   NR XCM67753.1 3003959 g61812 i0 66 1.92523364485981 103 35 96.3 0 319 11 382 484 XCM67753.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 618 152 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28838842 28838842 PRJNA1144090_P_NODE_23488_length_554_cov_3.155925_g22958_i0 PRJNA1144090 23488 554 3.155925 17.4838245 Picornaviridae sp. 1530251 Viruses Viruses 264 4.81e-78   NR URG14835.1 1530251 g22958 i0 72.2 0.953068592057762 176 49 95.3 0 1 528 1261 1436 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 528 264 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29280823 29280823 PRJNA1144090_P_NODE_2609_length_1684_cov_3.428305_g2435_i0 PRJNA1144090 2609 1684 3.428305 57.7326562 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 665 1.56e-228   NR XCM67754.1 3003959 g2435 i0 60.1 1.00118764845606 562 211 99.4 7 9 1682 71 623 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1686 665 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30196655 30196655 PRJNA1144090_P_NODE_11232_length_840_cov_1.547588_g10794_i0 PRJNA1144090 11232 840 1.547588 12.9997392 Picornaviridae sp. 1530251 Viruses Viruses 408 5.67e-127   NR URG14835.1 1530251 g10794 i0 71.7 0.996428571428571 279 78 99.6 1 838 2 472 749 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 837 408 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30544486 30544486 PRJNA1144090_P_NODE_633_length_2697_cov_14.560213_g565_i0 PRJNA1144090 633 2697 14.560213 392.68894461 Zebrafish gut calicivirus RQ08 Viruses Viruses 553 3.219999999999998e-169   NR XBS25272.1 RQ08 g565 i0 42.3 0.809788654060067 728 396 79.5 11 2696 552 1487 2203 XBS25272.1 MAG: ORF1 protein [Barramundi calicivirus 1] diamond 2184 553 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
30575791 30575791 PRJNA1144090_P_NODE_72153_length_297_cov_3.620536_g71618_i0 PRJNA1144090 72153 297 3.620536 10.75299192 Picornaviridae sp. 1530251 Viruses Viruses 73.6 1.07e-12   NR URG14835.1 1530251 g71618 i0 39.6 0.96969696969697 96 57 97 1 295 8 957 1051 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 288 73.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31397815 31397815 PRJNA1144090_P_NODE_23716_length_551_cov_2.504184_g23186_i0 PRJNA1144090 23716 551 2.504184 13.79805384 Picornaviridae sp. 1530251 Viruses Viruses 58.9 2.01e-6   NR URG14835.1 1530251 g23186 i0 32.5 0.838475499092559 154 86 76.8 5 68 490 1 149 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 462 58.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31429313 31429313 PRJNA1144090_P_NODE_95676_length_256_cov_1.650273_g95141_i0 PRJNA1144090 95676 256 1.650273 4.22469888 Picornaviridae sp. 1530251 Viruses Viruses 89.7 1.28e-18   NR URG14835.1 1530251 g95141 i0 58.8 0.9375 80 33 93.8 0 12 251 246 325 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 240 89.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31745520 31745520 PRJNA1144090_P_NODE_36717_length_428_cov_2.467606_g36182_i0 PRJNA1144090 36717 428 2.467606 10.56135368 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 98.2 1.27e-20   NR XCM67753.1 3003959 g36182 i0 38.3 0.988317757009346 141 86 98.1 1 7 426 1017 1157 XCM67753.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 423 98.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31966917 31966917 PRJNA1144090_P_NODE_29598_length_484_cov_3.221411_g29064_i0 PRJNA1144090 29598 484 3.221411 15.59162924 Picornaviridae sp. 1530251 Viruses Viruses 46.6 0.0198   NR URG14835.1 1530251 g29064 i0 50 0.272727272727273 44 22 27.3 0 483 352 732 775 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 132 46.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32283779 32283779 PRJNA1144090_P_NODE_52079_length_353_cov_2.078571_g51544_i0 PRJNA1144090 52079 353 2.078571 7.33735563 Picornaviridae sp. 1530251 Viruses Viruses 184 3.2e-51   NR URG14835.1 1530251 g51544 i0 79.5 0.994334277620397 117 24 99.4 0 1 351 1443 1559 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 351 184 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32494098 32494098 PRJNA1144090_P_NODE_36199_length_432_cov_1.537604_g35664_i0 PRJNA1144090 36199 432 1.537604 6.64244928 Picornavirales 464095 Viruses Viruses 204 1.3e-57   NR URG14835.1 1530251 g35664 i0 68.8 4 144 45 100 0 432 1 1519 1662 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 1728 206 0.990291262135922 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32536875 32536875 PRJNA1144090_P_NODE_96659_length_254_cov_2.552486_g96124_i0 PRJNA1144090 96659 254 2.552486 6.48331444 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 81.6 8.84e-16   NR XCM67753.1 3003959 g96124 i0 54.1 0.874015748031496 74 33 86.2 1 228 10 927 1000 XCM67753.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 222 81.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32757123 32757123 PRJNA1144090_P_NODE_11200_length_841_cov_4.221354_g10762_i0 PRJNA1144090 11200 841 4.221354 35.50158714 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 283 2.4299999999999996e-85   NR XCM67754.1 3003959 g10762 i0 58.4 0.916765755053508 257 103 90.2 1 2 760 642 898 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 771 283 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);;