RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 18 ✖

bioproject 1

  • PRJNA1073183 · 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
27035775 27035775 PRJNA1073183_P_NODE_202_length_2069_cov_20.502505_g187_i0 PRJNA1073183 202 2069 20.502505 424.19682845 Miniopterus inflatus ribovirus 3400667 Viruses Viruses 748 1.21e-262   NR XOT37672.1 3400667 g187 i0 55.3 2.92170130497825 669 298 96.9 1 19 2022 1 669 XOT37672.1 MAG: putative RNA-dependent RNA polymerase [Miniopterus inflatus ribovirus] diamond 6045 748 1 Viruses               Miniopterus inflatus ribovirus
27121797 27121797 PRJNA1073183_P_NODE_29102_length_248_cov_0.880000_g29007_i0 PRJNA1073183 29102 248 0.88 2.1824 Orthopoxvirus 10242 Viruses Viruses 115 1.04e-30   NR UXL57756.1 10244 g29007 i0 61.7 13.4516129032258 81 31 98 0 4 246 45 125 UXL57756.1 Thymidine kinase, partial [Monkeypox virus] diamond 3336 116 0.991379310344828 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae Orthopoxvirus Orthopoxvirus monkeypox
27415326 27415326 PRJNA1073183_P_NODE_603_length_1446_cov_12.168245_g364_i1 PRJNA1073183 603 1446 12.168245 175.9528227 Riboviria sp. 2585031 Viruses Viruses 290 6.069999999999999e-89   NR XBC37016.1 2585031 g364 i1 40.6 0.87344398340249 421 243 86.9 5 3 1259 65 480 XBC37016.1 MAG: hypothetical protein [Riboviria sp.] diamond 1263 290 1 Viruses               Riboviria sp.
27888557 27888557 PRJNA1073183_P_NODE_425_length_1631_cov_31.676508_g396_i0 PRJNA1073183 425 1631 31.676508 516.64384548 Riboviria sp. 2585031 Viruses Viruses 199 6.96e-54   NR XBC37015.1 2585031 g396 i0 32.4 0.835070508890251 454 283 80.6 7 34 1347 3 448 XBC37015.1 MAG: hypothetical protein [Riboviria sp.] diamond 1362 199 1 Viruses               Riboviria sp.
27920174 27920174 PRJNA1073183_P_NODE_525_length_1520_cov_14.429164_g493_i0 PRJNA1073183 525 1520 14.429164 219.3232928 Riboviria sp. 2585031 Viruses Viruses 311 2.899999999999999e-97   NR XBC37014.1 2585031 g493 i0 43.1 0.870394736842105 441 224 84.3 12 106 1386 26 453 XBC37014.1 MAG: hypothetical protein [Riboviria sp.] diamond 1323 311 1 Viruses               Riboviria sp.
28330625 28330625 PRJNA1073183_P_NODE_34726_length_237_cov_2.445122_g34631_i0 PRJNA1073183 34726 237 2.445122 5.79493914 Caudoviricetes sp. 2832643 Viruses Viruses 69.7 1.27e-13   NR XOR26342.1 2832643 g34631 i0 68.2 2.68354430379747 44 14 55.7 0 237 106 29 72 XOR26342.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 636 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28362174 28362174 PRJNA1073183_P_NODE_27246_length_250_cov_0.870056_g27151_i0 PRJNA1073183 27246 250 0.870056 2.17514 Barrevirus sp. 2487763 Viruses Viruses 63.5 7.43e-10   NR AYV77273.1 2487763 g27151 i0 38.1 1.008 84 50 98.4 1 4 249 129 212 AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] diamond 252 63.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Barrevirus sp.
29309430 29309430 PRJNA1073183_P_NODE_13249_length_356_cov_1.360424_g13154_i0 PRJNA1073183 13249 356 1.360424 4.84310944 Erysiphe necator associated ssRNA virus 1 2695359 Viruses Viruses 152 3.66e-40   NR QHD64840.1 2695359 g13154 i0 59.3 0.99438202247191 118 48 99.4 0 2 355 250 367 QHD64840.1 RdRp [Erysiphe necator associated ssRNA virus 1] diamond 354 152 1 Viruses               Erysiphe necator associated ssRNA virus 1
29341168 29341168 PRJNA1073183_P_NODE_17469_length_313_cov_1.225000_g17374_i0 PRJNA1073183 17469 313 1.225 3.83425 Circoviridae sp. 1954248 Viruses Viruses 68.9 4.09e-12   NR AYP28910.1 1954248 g17374 i0 36.5 1.83067092651757 85 53 81.5 1 312 58 35 118 AYP28910.1 MAG: hypothetical protein [Circoviridae sp.] diamond 573 68.9 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
29901060 29901060 PRJNA1073183_P_NODE_27331_length_250_cov_0.870056_g27236_i0 PRJNA1073183 27331 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 49.3 1.88e-4   NR AET42571.1 181211 g27236 i0 39.7 2.256 63 38 75.6 0 1 189 255 317 AET42571.1 fatty acid elongase [Emiliania huxleyi virus 202] diamond 564 49.7 0.991951710261569 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Coccolithovirus Emiliania huxleyi virus 202
29932743 29932743 PRJNA1073183_P_NODE_4031_length_627_cov_1.918773_g3942_i0 PRJNA1073183 4031 627 1.918773 12.03070671 Gammaretrovirus 153135 Viruses Viruses 406 1.1e-130   NR NP_040333.1 11795 g3942 i0 96.6 4.97607655502392 208 7 99.5 0 626 3 554 761 NP_040333.1 RNA-dependent DNA polymerase, partial [Friend murine leukemia virus] diamond 3120 410 0.990243902439024 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
30288969 30288969 PRJNA1073183_P_NODE_392_length_1674_cov_25.575890_g364_i0 PRJNA1073183 392 1674 25.57589 428.1403986 Riboviria sp. 2585031 Viruses Viruses 334 5.86e-105   NR XBC37016.1 2585031 g364 i0 40.8 0.874551971326165 488 279 87.1 7 30 1487 1 480 XBC37016.1 MAG: hypothetical protein [Riboviria sp.] diamond 1464 334 1 Viruses               Riboviria sp.
30383770 30383770 PRJNA1073183_P_NODE_493_length_1539_cov_32.873806_g462_i0 PRJNA1073183 493 1539 32.873806 505.92787434 Riboviria sp. 2585031 Viruses Viruses 434 1.6199999999999995e-144   NR XBC37013.1 2585031 g462 i0 44.6 0.91812865497076 471 258 91.2 1 1512 109 5 475 XBC37013.1 MAG: hypothetical protein [Riboviria sp.] diamond 1413 434 1 Viruses               Riboviria sp.
30572665 30572665 PRJNA1073183_P_NODE_14513_length_341_cov_1.679104_g14418_i0 PRJNA1073183 14513 341 1.679104 5.72574464 Edafosvirus sp. 2487765 Viruses Viruses 164 4.47e-46   NR AYV78014.1 2487765 g14418 i0 66.1 0.98533724340176 112 38 98.5 0 338 3 261 372 AYV78014.1 MAG: elongation factor 1 alpha long form [Edafosvirus sp.] diamond 336 164 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
30952253 30952253 PRJNA1073183_P_NODE_28314_length_249_cov_0.875000_g28219_i0 PRJNA1073183 28314 249 0.875 2.17875 Homavirus sp. 2487769 Viruses Viruses 132 2.73e-35   NR AYV82419.1 2487769 g28219 i0 73.2 0.987951807228916 82 22 98.8 0 246 1 98 179 AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] diamond 246 132 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Homavirus sp.
31015250 31015250 PRJNA1073183_P_NODE_18595_length_303_cov_1.339130_g18500_i0 PRJNA1073183 18595 303 1.33913 4.0575639 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 80.5 4.31e-15   NR XCM68117.1 3003959 g18500 i0 42.4 0.98019801980198 99 57 98 0 302 6 2411 2509 XCM68117.1 MAG: polyprotein [Picornavirales sp.] diamond 297 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32596761 32596761 PRJNA1073183_P_NODE_26440_length_251_cov_0.865169_g26345_i0 PRJNA1073183 26440 251 0.865169 2.17157419 Harvfovirus sp. 2487768 Viruses Viruses 44.7 0.00432   NR AYV81692.1 2487768 g26345 i0 27.7 0.99203187250996006 83 54 99.2 1 1 249 57 133 AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.] diamond 249 44.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Harvfovirus sp.
32754063 32754063 PRJNA1073183_P_NODE_34300_length_241_cov_0.916667_g34205_i0 PRJNA1073183 34300 241 0.916667 2.20916747 Hepelivirales sp. 2809460 Viruses Viruses 97.1 2.16e-21   NR WAY16439.1 2809460 g34205 i0 53.2 1.96680497925311 79 37 98.3 0 3 239 388 466 WAY16439.1 hypothetical protein [Hepelivirales sp.] diamond 474 97.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Hepelivirales sp.

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