RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 17 ✖

bioproject 1

  • PRJEB28062 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
3851146 3851146 PRJEB28062_P_NODE_5244_length_1748_cov_55.872239_g4152_i0 PRJEB28062 5244 1748 55.872239 976.64673772 Botourmiaviridae sp. 2808997 Viruses Viruses 749 2.87e-264   NR UYL94592.1 2808997 g4152 i0 67.5 0.978260869565217 570 182 97.8 2 1724 15 16 582 UYL94592.1 MAG: RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] diamond 1710 749 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
6402931 6402931 PRJEB28062_P_NODE_4286_length_1946_cov_15.023492_g3295_i0 PRJEB28062 4286 1946 15.023492 292.35715432 Viruses 10239 Viruses Viruses 788 9.45e-280   NR WWV86528.1 1955170 g3295 i0 62.2 2.7934224049332 603 227 92.8 1 1856 51 2 604 WWV86528.1 MAG: reverse transcriptase-like protein [Partitiviridae sp.] diamond 5436 795 0.991194968553459 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
12779022 12779022 PRJEB28062_P_NODE_7731_length_1419_cov_40.270431_g6311_i0 PRJEB28062 7731 1419 40.270431 571.43741589 Alphacarmovirus 1911599 Viruses Viruses 573 7.229999999999998e-196   NR YP_004191789.1 943272 g6311 i0 70 3.88372093023256 373 112 78.9 0 299 1417 316 688 YP_004191789.1 p87 [Honeysuckle ringspot virus] diamond 5511 578 0.991349480968858 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae Alphacarmovirus Alphacarmovirus lonicerae
21700299 21700299 PRJEB28062_P_NODE_1078_length_4484_cov_331.484697_g511_i0 PRJEB28062 1078 4484 331.484697 14863.77381348 Picornavirales 464095 Viruses Viruses 506 8.079999999999998e-156   NR NP_044946.1 64279 g511 i0 35.7 4.57560214094558 978 492 62.8 25 3083 267 16 895 NP_044946.1 capsid polyprotein, partial [Drosophila C virus] diamond 20517 509 0.994106090373281 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
26716246 26716246 PRJEB28062_P_NODE_4101_length_1990_cov_251.032864_g3132_i0 PRJEB28062 4101 1990 251.032864 4995.5539936 Cripavirus sp. 1955141 Viruses Viruses 100 9.91e-18   NR ULF99876.1 1955141 g3132 i0 33.9 0.382914572864322 127 84 19.1 0 1581 1961 405 531 ULF99876.1 MAG: hypothetical protein 1 [Cripavirus sp.] diamond 762 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
26780084 26780084 PRJEB28062_P_NODE_129221_length_243_cov_1.788235_g126857_i0 PRJEB28062 129221 243 1.788235 4.34541105 Pleurotus pulmonarius virga-like virus 1 3231516 Viruses Viruses 55.1 1.64e-6   NR XCI72490.1 3231516 g126857 i0 40 0.925925925925926 75 42 92.6 1 18 242 325 396 XCI72490.1 methyltransferase [Pleurotus pulmonarius virga-like virus 1] diamond 225 55.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae   Pleurotus pulmonarius virga-like virus 1
27665235 27665235 PRJEB28062_P_NODE_23024_length_779_cov_1.797450_g20848_i0 PRJEB28062 23024 779 1.79745 14.0021355 Cripavirus sp. 1955141 Viruses Viruses 53.5 5.34e-4   NR ULF99863.1 1955141 g20848 i0 27 1.82156611039795 237 160 87 4 697 20 754 988 ULF99863.1 MAG: putative replicase polyprotein [Cripavirus sp.] diamond 1419 53.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
27917535 27917535 PRJEB28062_P_NODE_40925_length_567_cov_21.338057_g38591_i0 PRJEB28062 40925 567 21.338057 120.98678319 Rhizoctonia cerealis bunyavirus 3068840 Viruses Viruses 56.6 6.96e-6   NR WMI40170.1 3068840 g38591 i0 26.3 0.804232804232804 152 105 79.9 2 45 497 84 229 WMI40170.1 MAG: hypothetical protein [Rhizoctonia cerealis bunyavirus] diamond 456 56.6 1 Viruses   Orthornavirae Negarnaviricota Ellioviricetes Bunyavirales     Rhizoctonia cerealis bunyavirus
28138903 28138903 PRJEB28062_P_NODE_12365_length_1092_cov_517.991168_g10631_i0 PRJEB28062 12365 1092 517.991168 5656.46355456 Dicistroviridae sp. 1955144 Viruses Viruses 152 2.27e-36   NR XCO48968.1 1955144 g10631 i0 30.4 1.5989010989011 309 201 83 4 1060 155 445 746 XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 1746 152 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28517645 28517645 PRJEB28062_P_NODE_5147_length_1765_cov_24.368794_g4063_i0 PRJEB28062 5147 1765 24.368794 430.1092141 Xiaogan partiti-like virus 1 2970246 Viruses Viruses 429 4.27e-141   NR UUW20933.1 2970246 g4063 i0 44 0.892351274787535 525 289 89.2 3 1675 101 4 523 UUW20933.1 MAG: coat protein [Xiaogan partiti-like virus 1] diamond 1575 429 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Xiaogan partiti-like virus 1
29401635 29401635 PRJEB28062_P_NODE_38369_length_589_cov_2.815891_g36042_i0 PRJEB28062 38369 589 2.815891 16.58559799 Qingdao RNA virus 4 2979708 Viruses Viruses 277 2.72e-82   NR BDR95913.1 2979708 g36042 i0 67.5 0.98811544991511 194 63 98.8 0 584 3 1112 1305 BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] diamond 582 277 1 Viruses   Orthornavirae Negarnaviricota Chunqiuviricetes Muvirales Qinviridae   Qingdao RNA virus 4
29528036 29528036 PRJEB28062_P_NODE_85810_length_358_cov_22.459649_g83448_i0 PRJEB28062 85810 358 22.459649 80.40554342 Ripoflin virus 3130381 Viruses Viruses 47 0.00395   NR WZH59543.1 3130381 g83448 i0 30.5 0.879888268156425 105 71 87.2 2 26 337 164 267 WZH59543.1 MAG: hypothetical protein [Ripoflin virus] diamond 315 47 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Ripoflin virus
30121384 30121384 PRJEB28062_P_NODE_59632_length_454_cov_1.501312_g57273_i0 PRJEB28062 59632 454 1.501312 6.81595648 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 115 2.06e-26   NR YP_009104360.1 3063761 g57273 i0 47.7 4.44052863436123 132 66 85.2 3 431 45 765 896 YP_009104360.1 polyprotein [Crohivirus A] diamond 2016 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Crohivirus Danio blood picornavirus/Zebrafish picornavirus 2
30286390 30286390 PRJEB28062_P_NODE_27752_length_704_cov_1.690967_g25494_i0 PRJEB28062 27752 704 1.690967 11.90440768 Mitoviridae sp. 2809572 Viruses Viruses 169 2.99e-44   NR UJQ92537.1 2809572 g25494 i0 48.6 0.788352272727273 185 94 78.8 1 132 686 4 187 UJQ92537.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] diamond 555 169 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Mitoviridae sp.
30854635 30854635 PRJEB28062_P_NODE_129874_length_242_cov_1.846154_g127510_i0 PRJEB28062 129874 242 1.846154 4.46769268 Penicillium roseopurpureum chrysovirus 1 2485919 Viruses Viruses 112 1.5500000000000002e-26   NR AYP71812.1 2485919 g127510 i0 65.8 1.88429752066116 76 26 94.2 0 237 10 509 584 AYP71812.1 RNA-dependent RNA polymerase [Penicillium roseopurpureum chrysovirus 1] diamond 456 112 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Alphachrysovirus Alphachrysovirus penicillii
31518641 31518641 PRJEB28062_P_NODE_113776_length_276_cov_3.133005_g111413_i0 PRJEB28062 113776 276 3.133005 8.6470938 Dicistroviridae sp. 1955144 Viruses Viruses 118 1.23e-28   NR XCO48987.1 1955144 g111413 i0 76.1 0.771739130434783 71 17 77.2 0 253 41 308 378 XCO48987.1 MAG: putative ORF2 protein [Dicistroviridae sp.] diamond 213 118 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
32366454 32366454 PRJEB28062_P_NODE_93619_length_334_cov_1.973180_g91257_i0 PRJEB28062 93619 334 1.97318 6.5904212 Viruses 10239 Viruses Viruses 110 1.33e-25   NR XCO49233.1 1955144 g91257 i0 48.6 6.8622754491018 109 56 97.9 0 1 327 226 334 XCO49233.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 2292 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae 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);;