RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 23 ✖

bioproject 1

  • PRJNA421571 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
19548039 19548039 PRJNA421571_P_NODE_16_length_5580_cov_36.930271_g12_i0 PRJNA421571 16 5580 36.930271 2060.7091218 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1594 0   NR XCM68141.1 3003959 g12 i0 49.8 0.92741935483871 1725 816 91 24 293 5371 205 1911 XCM68141.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 5175 1594 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
24648353 24648353 PRJNA421571_P_NODE_120_length_4105_cov_8.144097_g91_i0 PRJNA421571 120 4105 8.144097 334.31518185 Capillovirus sp. 2767538 Viruses Viruses 1129 0   NR WGV36183.1 2767538 g91 i0 48.1 1.99512789281364 1348 583 97.7 21 4099 89 856 2097 WGV36183.1 MAG: polyprotein [Capillovirus sp.] diamond 8190 1129 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus sp.
26600515 26600515 PRJNA421571_P_NODE_60641_length_337_cov_1.166667_g58092_i0 PRJNA421571 60641 337 1.166667 3.93166779 brine shrimp arlivirus 5 2900380 Viruses Viruses 137 2.73e-39   NR UNI74092.1 2900380 g58092 i0 69.1 0.863501483679525 97 30 86.4 0 335 45 24 120 UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] diamond 291 137 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsafivalis
26759035 26759035 PRJNA421571_P_NODE_51301_length_382_cov_1.631068_g48753_i0 PRJNA421571 51301 382 1.631068 6.23067976 Capillovirus sp. 2767538 Viruses Viruses 51.2 2e-4   NR WGV36183.1 2767538 g48753 i0 34.4 0.958115183246073 122 70 92.7 4 1 354 393 508 WGV36183.1 MAG: polyprotein [Capillovirus sp.] diamond 366 51.2 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus sp.
26980652 26980652 PRJNA421571_P_NODE_14962_length_961_cov_3.320946_g13036_i0 PRJNA421571 14962 961 3.320946 31.91429106 Silene betaflexivirus 1 2794409 Viruses Viruses 303 1.7e-89   NR QQG34583.1 2794409 g13036 i0 50.5 1.00208116545265 321 155 99 3 955 5 576 896 QQG34583.1 polyprotein [Silene betaflexivirus 1] diamond 963 303 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Silene betaflexivirus 1
27107093 27107093 PRJNA421571_P_NODE_90382_length_253_cov_2.138889_g87833_i0 PRJNA421571 90382 253 2.138889 5.41138917 Qianjiang hepeli-like virus 14 3348976 Viruses Viruses 109 1.32e-25   NR XHA85831.1 3348976 g87833 i0 61.4 0.984189723320158 83 32 98.4 0 251 3 34 116 XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14] diamond 249 109 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Qianjiang hepeli-like virus 14
27123498 27123498 PRJNA421571_P_NODE_42202_length_446_cov_2.461126_g39654_i0 PRJNA421571 42202 446 2.461126 10.97662196 Nepovirus 12270 Viruses Viruses 273 4.32e-82   NR UIT55566.1 173976 g39654 i0 82.4 3.98206278026906 148 26 99.6 0 2 445 147 294 UIT55566.1 polyprotein, partial [Cycas necrotic stunt virus] diamond 1776 273 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus cycas
27265370 27265370 PRJNA421571_P_NODE_48643_length_399_cov_1.233129_g46095_i0 PRJNA421571 48643 399 1.233129 4.92018471 Silene betaflexivirus 1 2794409 Viruses Viruses 187 6.769999999999999e-52   NR QQG34583.1 2794409 g46095 i0 64.4 0.992481203007519 132 47 99.2 0 398 3 121 252 QQG34583.1 polyprotein [Silene betaflexivirus 1] diamond 396 187 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Silene betaflexivirus 1
27455087 27455087 PRJNA421571_P_NODE_59223_length_343_cov_1.003704_g56674_i0 PRJNA421571 59223 343 1.003704 3.44270472 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 87.4 2.65e-17   NR XCM68314.1 3003959 g56674 i0 41 1.02332361516035 117 63 99.7 2 2 343 232 345 XCM68314.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 351 87.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28023287 28023287 PRJNA421571_P_NODE_57445_length_350_cov_1.927798_g54896_i0 PRJNA421571 57445 350 1.927798 6.747293 Perth bee virus 4 2201298 Viruses Viruses 145 3.62e-38   NR AWK77899.1 2201298 g54896 i0 59.1 0.985714285714286 115 47 98.6 0 348 4 404 518 AWK77899.1 structural polyprotein [Perth bee virus 4] diamond 345 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
28481842 28481842 PRJNA421571_P_NODE_67646_length_311_cov_2.168067_g65097_i0 PRJNA421571 67646 311 2.168067 6.74268837 Viruses 10239 Viruses Viruses 150 1.83e-40   NR XCM68426.1 1955153 g65097 i0 72.8 1.98713826366559 103 28 99.4 0 3 311 208 310 XCM68426.1 MAG: structural polyprotein, partial [Picornavirales sp.] diamond 618 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28623243 28623243 PRJNA421571_P_NODE_24327_length_695_cov_1.567524_g21880_i0 PRJNA421571 24327 695 1.567524 10.8942918 Zebrafish jaw picornavirus RQ13 Viruses Viruses 82 8.04e-14   NR YP_009552756.1 RQ13 g21880 i0 39.6 3.47913669064748 139 79 58.3 3 289 693 1703 1840 YP_009552756.1 polyprotein [Rhimavirus A] diamond 2418 82 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
28812220 28812220 PRJNA421571_P_NODE_101628_length_244_cov_1.350877_g99079_i0 PRJNA421571 101628 244 1.350877 3.29613988 Orbilia oligospora narnavirus 1 3380797 Viruses Viruses 93.6 4.94e-20   NR BFU49212.1 3380797 g99079 i0 62 2.91393442622951 79 29 95.9 1 10 243 640 718 BFU49212.1 RNA-dependent RNA polymerase [Orbilia oligospora narnavirus 1] diamond 711 93.6 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Orbilia oligospora narnavirus 1
28812232 28812232 PRJNA421571_P_NODE_28308_length_617_cov_1.827206_g25801_i0 PRJNA421571 28308 617 1.827206 11.27386102 Zebrafish jaw picornavirus RQ13 Viruses Viruses 233 8.61e-67   NR XBH24011.1 RQ13 g25801 i0 54.9 4.95948136142626 204 91 99.2 1 614 3 2097 2299 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 3060 233 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
29191555 29191555 PRJNA421571_P_NODE_59609_length_341_cov_1.559701_g57060_i0 PRJNA421571 59609 341 1.559701 5.31858041 Striga asiatica dicistro-like virus 1 2943843 Viruses Viruses 203 9.999999999999997e-59   NR UQR78685.1 2943843 g57060 i0 80.5 0.994134897360704 113 22 99.4 0 340 2 459 571 UQR78685.1 structural polyprotein, partial [Striga asiatica dicistro-like virus 1] diamond 339 203 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Striga asiatica dicistro-like virus 1
29633056 29633056 PRJNA421571_P_NODE_33170_length_544_cov_0.963907_g30633_i0 PRJNA421571 33170 544 0.963907 5.24365408 Durnavirales sp. 2809355 Viruses Viruses 92 4.73e-18   NR WRQ64726.1 2809355 g30633 i0 31.1 0.904411764705882 164 110 89.9 2 505 17 80 241 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 492 92 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
30392065 30392065 PRJNA421571_P_NODE_39653_length_469_cov_3.843434_g37105_i0 PRJNA421571 39653 469 3.843434 18.02570546 Capillovirus sp. 2767538 Viruses Viruses 183 2.86e-50   NR WGV36183.1 2767538 g37105 i0 59 0.997867803837953 156 64 99.8 0 468 1 242 397 WGV36183.1 MAG: polyprotein [Capillovirus sp.] diamond 468 183 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Capillovirus Capillovirus sp.
31972178 31972178 PRJNA421571_P_NODE_17538_length_871_cov_2.206767_g15430_i0 PRJNA421571 17538 871 2.206767 19.22094057 Qianjiang hepeli-like virus 14 3348976 Viruses Viruses 245 2.94e-73   NR XHA85831.1 3348976 g15430 i0 61.8 0.70264064293915 204 77 70.3 1 15 626 285 487 XHA85831.1 MAG: hypothetical protein [Qianjiang hepeli-like virus 14] diamond 612 245 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales     Qianjiang hepeli-like virus 14
32130647 32130647 PRJNA421571_P_NODE_53458_length_370_cov_1.808081_g50909_i0 PRJNA421571 53458 370 1.808081 6.6898997 Citrus leaf blotch virus 129141 Viruses Viruses 239 3.93e-76   NR NP_624334.1 129141 g50909 i0 98.4 1.97837837837838 122 2 98.9 0 368 3 137 258 NP_624334.1 movement protein [Citrus leaf blotch virus] diamond 732 239 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Citrivirus Citrivirus citri
32162220 32162220 PRJNA421571_P_NODE_138_length_3975_cov_49.841876_g12_i1 PRJNA421571 138 3975 49.841876 1981.214571 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1004 0   NR XCM68125.1 3003959 g12 i1 61.8 0.615849056603774 816 303 61.4 7 1325 3763 38 847 XCM68125.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2448 1004 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32415347 32415347 PRJNA421571_P_NODE_62899_length_328_cov_3.235294_g60350_i0 PRJNA421571 62899 328 3.235294 10.61176432 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 134 1.05e-33   NR XCM68009.1 3003959 g60350 i0 55.4 0.923780487804878 101 45 92.4 0 303 1 285 385 XCM68009.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 303 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32478730 32478730 PRJNA421571_P_NODE_51559_length_381_cov_0.740260_g49011_i0 PRJNA421571 51559 381 0.74026 2.8203906 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 59.7 2.15e-7   NR ULF99705.1 3003959 g49011 i0 38 0.78740157480315 100 62 78.7 0 301 2 1948 2047 ULF99705.1 MAG: hypothetical protein [Picornavirales sp.] diamond 300 59.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32684200 32684200 PRJNA421571_P_NODE_37060_length_496_cov_2.803783_g34517_i0 PRJNA421571 37060 496 2.803783 13.90676368 Zebrafish jaw picornavirus RQ13 Viruses Viruses 74.3 4.61e-12   NR NP_740444.1 RQ13 g34517 i0 42.7 5.19556451612903 96 53 56.9 2 3 284 369 464 NP_740444.1 3D [aichivirus A1] diamond 2577 74.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Zebrafish jaw picornavirus

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