RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 15 ✖

bioproject 1

  • PRJNA758088 · 15 ✖

analysis 1

  • diamond · 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
26894999 26894999 PRJNA758088_P_NODE_290841_length_250_cov_0.870056_g283870_i0 PRJNA758088 290841 250 0.870056 2.17514 Mitoviridae sp. 2809572 Viruses Viruses 163 1.1999999999999998e-44   NR UJQ92537.1 2809572 g283870 i0 89.2 0.996 83 9 99.6 0 249 1 382 464 UJQ92537.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 249 163 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
27558321 27558321 PRJNA758088_P_NODE_347724_length_243_cov_0.905882_g340753_i0 PRJNA758088 347724 243 0.905882 2.20129326 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 126 1.58e-31   NR XDO02803.1 3239337 g340753 i0 67.9 0.962962962962963 78 25 96.3 0 3 236 1750 1827 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 234 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28253066 28253066 PRJNA758088_P_NODE_255926_length_265_cov_1.203125_g248955_i0 PRJNA758088 255926 265 1.203125 3.18828125 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 63.9 1.76e-9   NR XDO02803.1 3239337 g248955 i0 62.8 0.486792452830189 43 16 48.7 0 1 129 1943 1985 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 129 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28505755 28505755 PRJNA758088_P_NODE_96887_length_427_cov_0.994350_g89917_i0 PRJNA758088 96887 427 0.99435 4.2458745 Pineapple secovirus C 3022851 Viruses Viruses 238 6.69e-70   NR WCR39296.1 3022851 g89917 i0 76.8 0.997658079625293 142 33 99.8 0 2 427 532 673 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 426 238 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
28632236 28632236 PRJNA758088_P_NODE_160327_length_334_cov_0.885057_g153356_i0 PRJNA758088 160327 334 0.885057 2.95609038 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 57.8 5.85e-7   NR XDO02803.1 3239337 g153356 i0 28.6 0.94311377245509 105 75 94.3 0 332 18 1267 1371 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 315 57.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28695383 28695383 PRJNA758088_P_NODE_32067_length_839_cov_1.604439_g26240_i0 PRJNA758088 32067 839 1.604439 13.46124321 Pineapple secovirus C 3022851 Viruses Viruses 426 2.56e-138   NR WCR39296.1 3022851 g26240 i0 77.1 0.951132300357569 266 60 95.1 1 839 42 798 1062 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 798 426 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
28726744 28726744 PRJNA758088_P_NODE_15967_length_1296_cov_2.077678_g12243_i0 PRJNA758088 15967 1296 2.077678 26.92670688 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 267 3.71e-76   NR XDO02804.1 3239337 g12243 i0 42 0.909722222222222 393 196 88 9 91 1230 559 932 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 1179 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29273110 29273110 PRJNA758088_P_NODE_342629_length_244_cov_0.900585_g335658_i0 PRJNA758088 342629 244 0.900585 2.1974274 Prunevirus 1914295 Viruses Viruses 85.9 2.54e-17   NR UIW14227.1 2560282 g335658 i0 80 1.22950819672131 50 10 61.5 0 150 1 1 50 UIW14227.1 MAG: replicase [Actinidia seed borne latent virus] diamond 300 86.7 0.990772779700115 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Prunevirus Prunevirus actinidiae
29358301 29358301 PRJNA758088_P_NODE_183149_length_314_cov_0.958506_g176178_i0 PRJNA758088 183149 314 0.958506 3.00970884 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 91.7 6.03e-19   NR XDO02803.1 3239337 g176178 i0 47.6 0.984076433121019 103 54 98.4 0 4 312 1469 1571 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 309 91.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29547477 29547477 PRJNA758088_P_NODE_128830_length_370_cov_1.282828_g121859_i0 PRJNA758088 128830 370 1.282828 4.7464636 Pineapple secovirus C 3022851 Viruses Viruses 142 1.42e-36   NR WCR39296.1 3022851 g121859 i0 63.3 0.883783783783784 109 40 88.4 0 328 2 396 504 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 327 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C
29831809 29831809 PRJNA758088_P_NODE_121071_length_381_cov_1.581169_g114101_i0 PRJNA758088 121071 381 1.581169 6.02425389 Shuangao Insect Virus 3 1608077 Viruses Viruses 165 2.63e-44   NR AJG39251.1 1608077 g114101 i0 61.9 1.98425196850394 126 48 99.2 0 4 381 88 213 AJG39251.1 RNA-dependent RNA polymerase [Shuangao Insect Virus 3] diamond 756 165 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Peribunyaviridae   Shuangao Insect Virus 3
29863407 29863407 PRJNA758088_P_NODE_64391_length_538_cov_4.501075_g57462_i0 PRJNA758088 64391 538 4.501075 24.2157835 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 65.1 1.28e-8   NR XDO02804.1 3239337 g57462 i0 33.7 0.546468401486989 98 58 50.7 3 111 383 976 1073 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 294 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29895122 29895122 PRJNA758088_P_NODE_137611_length_358_cov_2.701754_g130640_i0 PRJNA758088 137611 358 2.701754 9.67227932 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 147 2.93e-38   NR XDO02804.1 3239337 g130640 i0 60.7 0.980446927374302 117 43 95.5 1 357 16 379 495 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 351 147 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
32012849 32012849 PRJNA758088_P_NODE_216218_length_290_cov_0.917051_g209247_i0 PRJNA758088 216218 290 0.917051 2.6594479 Shuangao Insect Virus 3 1608077 Viruses Viruses 55.1 3.11e-6   NR UYE93738.1 1608077 g209247 i0 66.7 0.827586206896552 39 13 40.3 0 168 284 208 246 UYE93738.1 MAG: RNA-dependent RNA polymerase, partial [Shuangao Insect Virus 3] diamond 240 55.1 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Peribunyaviridae   Shuangao Insect Virus 3
32329571 32329571 PRJNA758088_P_NODE_213939_length_291_cov_1.403670_g206968_i0 PRJNA758088 213939 291 1.40367 4.0846797 Pineapple secovirus C 3022851 Viruses Viruses 169 3.21e-46   NR WCR39296.1 3022851 g206968 i0 81.1 0.979381443298969 95 18 97.9 0 3 287 710 804 WCR39296.1 polyprotein 2 [Pineapple secovirus C] diamond 285 169 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae   Pineapple secovirus C

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