RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA857143 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
11047158 11047158 PRJNA857143_S_NODE_169_length_2281_cov_5.031703_g115_i0 PRJNA857143 169 2281 5.031703 114.77314543 Sopawar virus 3131855 Viruses Viruses 91.3 8.85e-15   NR WZH62023.1 3131855 g115 i0 27.8 1.00613765892153 291 197 38.1 5 897 1766 260 538 WZH62023.1 MAG: RNA-dependent RNA polymerase [Sopawar virus] diamond 2295 91.3 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Sopawar virus
27023413 27023413 PRJNA857143_S_NODE_132422_length_281_cov_1.442308_g131329_i0 PRJNA857143 132422 281 1.442308 4.05288548 Pseudomonas phage phi12 161736 Viruses Viruses 79 8.39e-16   NR NP_690826.1 161736 g131329 i0 65.5 0.587188612099644 55 19 58.7 0 3 167 138 192 NP_690826.1 nucleocapsid protein P8 [Pseudomonas phage phi12] diamond 165 79 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27497530 27497530 PRJNA857143_S_NODE_199063_length_232_cov_2.201258_g197970_i0 PRJNA857143 199063 232 2.201258 5.10691856 Pseudomonas phage phi12 161736 Viruses Viruses 122 4.549999999999999e-34   NR NP_690821.1 161736 g197970 i0 67.1 0.982758620689655 76 25 98.3 0 4 231 17 92 NP_690821.1 P15 protein [Pseudomonas phage phi12] diamond 228 122 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27876273 27876273 PRJNA857143_S_NODE_161465_length_258_cov_1.264865_g160372_i0 PRJNA857143 161465 258 1.264865 3.2633517 Pseudomonas phage phi12 161736 Viruses Viruses 163 4.4e-45   NR NP_690823.1 161736 g160372 i0 89.4 0.988372093023256 85 9 98.8 0 3 257 425 509 NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] diamond 255 163 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27947702 27947702 PRJNA857143_S_NODE_66525_length_361_cov_1.142361_g65432_i0 PRJNA857143 66525 361 1.142361 4.12392321 root 1 Root_unresolved Root_unresolved 52.8 3.91e-6   NR NP_689325.1 204440 g65432 i0 44.3 5.80886426592798 61 33 50.7 1 320 138 10 69 NP_689325.1 putative ubiquitin [Mamestra configurata nucleopolyhedrovirus B] diamond 2097 52.8 1 Viruses       Naldaviricetes Lefavirales Baculoviridae Alphabaculovirus Alphabaculovirus sp. 'altermaconfiguratae'
28507883 28507883 PRJNA857143_S_NODE_55247_length_383_cov_4.777419_g54154_i0 PRJNA857143 55247 383 4.777419 18.29751477 Barrevirus sp. 2487763 Viruses Viruses 79.7 2.59e-15   NR AYV77273.1 2487763 g54154 i0 43.6 0.610966057441253 78 43 60.3 1 374 144 143 220 AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] diamond 234 79.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Barrevirus sp.
28516066 28516066 PRJNA857143_S_NODE_79387_length_339_cov_3.973684_g78294_i0 PRJNA857143 79387 339 3.973684 13.47078876 Largemouth bass virus 10492 Viruses Viruses 45.4 0.012   NR QKO01790.1 10492 g78294 i0 50 6.4070796460177 42 21 37.2 0 181 56 389 430 QKO01790.1 hypothetical protein [Frog virus 3] diamond 2172 45.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Largemouth bass virus
28791791 28791791 PRJNA857143_S_NODE_108567_length_304_cov_1.103896_g107474_i0 PRJNA857143 108567 304 1.103896 3.35584384 Solumvirus sp. 2487773 Viruses Viruses 88.6 4.05e-19   NR AYV86227.1 2487773 g107474 i0 71 0.611842105263158 62 18 61.2 0 304 119 128 189 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 186 88.6 1 Viruses Pithoviruses             Solumvirus sp.
28886592 28886592 PRJNA857143_S_NODE_136748_length_277_cov_1.911765_g135655_i0 PRJNA857143 136748 277 1.911765 5.29558905 Solumvirus sp. 2487773 Viruses Viruses 145 2.37e-41   NR AYV86227.1 2487773 g135655 i0 71.7 0.996389891696751 92 26 99.6 0 1 276 65 156 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 276 145 1 Viruses Pithoviruses             Solumvirus sp.
29202581 29202581 PRJNA857143_S_NODE_3849_length_954_cov_2.002270_g3223_i0 PRJNA857143 3849 954 2.00227 19.1016558 Caudoviricetes sp. 2832643 Viruses Viruses 65.9 3.85e-8   NR DAN37901.1 2832643 g3223 i0 35.4 1.34591194968553 113 57 31.1 4 337 633 49 159 DAN37901.1 MAG TPA: properdin [Caudoviricetes sp.] diamond 1284 65.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29391999 29391999 PRJNA857143_S_NODE_44969_length_409_cov_3.997024_g43876_i0 PRJNA857143 44969 409 3.997024 16.34782816 Pseudomonas phage phi12 161736 Viruses Viruses 150 3.48e-44   NR NP_690820.1 161736 g43876 i0 72.5 0.667481662591687 91 25 66.7 0 397 125 9 99 NP_690820.1 P14 protein [Pseudomonas phage phi12] diamond 273 150 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
29802270 29802270 PRJNA857143_S_NODE_177571_length_249_cov_1.659091_g176478_i0 PRJNA857143 177571 249 1.659091 4.13113659 Mimiviridae sp. ChoanoV1 2596887 Viruses Viruses 60.5 1.36e-8   NR QDY51821.1 2596887 g176478 i0 40.6 0.771084337349398 64 36 77.1 1 28 219 187 248 QDY51821.1 hypothetical protein 1_206 [Mimiviridae sp. ChoanoV1] diamond 192 60.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Schizomimiviridae   Mimiviridae sp. ChoanoV1
30853101 30853101 PRJNA857143_S_NODE_191834_length_243_cov_1.376471_g190741_i0 PRJNA857143 191834 243 1.376471 3.34482453 Viruses 10239 Viruses Viruses 83.2 5.88e-17   NR QTE03356.1 2815032 g190741 i0 40.7 2 81 48 100 0 243 1 102 182 QTE03356.1 MAG: replication-associated protein [Emberiza rustica CRESS-DNA-virus sp.] diamond 486 84 0.990476190476191 Viruses   Shotokuvirae Cressdnaviricota         Emberiza rustica CRESS-DNA-virus sp.
31034849 31034849 PRJNA857143_S_NODE_98615_length_315_cov_0.966942_g97522_i0 PRJNA857143 98615 315 0.966942 3.0458673 Barrevirus sp. 2487763 Viruses Viruses 52.4 3.56e-5   NR AYV77035.1 2487763 g97522 i0 32.9 0.666666666666667 70 47 66.7 0 312 103 98 167 AYV77035.1 MAG: hypothetical protein Barrevirus9_4 [Barrevirus sp.] diamond 210 52.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Barrevirus sp.
31192128 31192128 PRJNA857143_S_NODE_46615_length_405_cov_1.599398_g45522_i0 PRJNA857143 46615 405 1.599398 6.4775619 Pseudomonas phage phi12 161736 Viruses Viruses 156 2.08e-45   NR NP_690826.1 161736 g45522 i0 56.5 0.97037037037037 131 57 97 0 403 11 1 131 NP_690826.1 nucleocapsid protein P8 [Pseudomonas phage phi12] diamond 393 156 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
31477333 31477333 PRJNA857143_S_NODE_105856_length_306_cov_9.836910_g104763_i0 PRJNA857143 105856 306 9.83691 30.1009446 Clandestinovirus 2831644 Viruses Viruses 55.8 1.77e-6   NR QYA18863.1 2831644 g104763 i0 41.8 1.31372549019608 67 32 61.8 2 44 232 274 337 QYA18863.1 oxidoreductase [Clandestinovirus] diamond 402 55.8 1 Viruses               Clandestinovirus
32867683 32867683 PRJNA857143_S_NODE_13820_length_604_cov_2.167608_g12782_i0 PRJNA857143 13820 604 2.167608 13.09235232 Pseudomonas phage phi12 161736 Viruses Viruses 158 3.6e-41   NR NP_690823.1 161736 g12782 i0 67 0.571192052980132 115 38 57.1 0 259 603 12 126 NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] diamond 345 158 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
32899069 32899069 PRJNA857143_S_NODE_180460_length_248_cov_1.262857_g179367_i0 PRJNA857143 180460 248 1.262857 3.13188536 Spleen focus-forming virus 11819 Viruses Viruses 50.4 1.25e-5   NR CAA48763.1 11819 g179367 i0 83.8 0.44758064516129 37 6 44.8 0 211 101 74 110 CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] diamond 111 50.4 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Spleen focus-forming virus

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