RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA789095" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 23 ✖

bioproject 1

  • PRJNA789095 · 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
13524178 13524178 PRJNA789095_P_NODE_35491_length_343_cov_3.581481_g34157_i0 PRJNA789095 35491 343 3.581481 12.28447983 Hemigrapsus takanoi nimavirus 2133792 Viruses Viruses 102 1.97e-22   NR BDT63272.1 2133792 g34157 i0 68.6 0.612244897959184 70 22 61.2 0 134 343 636 705 BDT63272.1 MAG: putative reverse transcriptase [Hemigrapsus takanoi nimavirus] diamond 210 102 1 Viruses       Naldaviricetes   Nimaviridae   Hemigrapsus takanoi nimavirus
19896805 19896805 PRJNA789095_P_NODE_17796_length_604_cov_1.097928_g16479_i0 PRJNA789095 17796 604 1.097928 6.63148512 Hemigrapsus takanoi nimavirus 2133792 Viruses Viruses 217 1.81e-61   NR BDT63272.1 2133792 g16479 i0 55.6 1.0182119205298 205 84 99.3 2 604 5 386 588 BDT63272.1 MAG: putative reverse transcriptase [Hemigrapsus takanoi nimavirus] diamond 615 217 1 Viruses       Naldaviricetes   Nimaviridae   Hemigrapsus takanoi nimavirus
26610337 26610337 PRJNA789095_P_NODE_45481_length_298_cov_2.346667_g44147_i0 PRJNA789095 45481 298 2.346667 6.99306766 brine shrimp arlivirus 8 2900383 Viruses Viruses 104 5.229999999999999e-24   NR UNI74120.1 2900383 g44147 i0 60.5 0.815436241610738 81 32 81.5 0 3 245 279 359 UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] diamond 243 104 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsaeighalis
27022139 27022139 PRJNA789095_P_NODE_40042_length_315_cov_3.450413_g38708_i0 PRJNA789095 40042 315 3.450413 10.86880095 Caudoviricetes sp. 2832643 Viruses Viruses 81.3 7.18e-16   NR XOR63745.1 2832643 g38708 i0 56.1 0.628571428571429 66 29 62.9 0 313 116 211 276 XOR63745.1 MAG: virion structural protein [Caudoviricetes sp.] diamond 198 81.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27874924 27874924 PRJNA789095_P_NODE_27705_length_413_cov_4.432353_g26373_i0 PRJNA789095 27705 413 4.432353 18.30561789 Fadolivirus algeromassiliense 3060017 Viruses Viruses 53.5 1.51e-5   NR YP_010803386.1 3060017 g26373 i0 50 2.26634382566586 46 23 33.4 0 148 11 119 164 YP_010803386.1 ubiquitin-conjugating enzyme E2 [Fadolivirus algeromassiliense] diamond 936 53.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Fadolivirus Fadolivirus algeromassiliense
27969705 27969705 PRJNA789095_P_NODE_81745_length_203_cov_4.100000_g80411_i0 PRJNA789095 81745 203 4.1 8.323 Zebrafish jaw poxvirus RQ14 Viruses Viruses 49.3 7.72e-5   NR BCT22566.1 RQ14 g80411 i0 35.5 0.916256157635468 62 40 91.6 0 188 3 36 97 BCT22566.1 hypothetical protein [Carp edema virus] diamond 186 49.3 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
28159393 28159393 PRJNA789095_P_NODE_45805_length_297_cov_2.450893_g44471_i0 PRJNA789095 45805 297 2.450893 7.27915221 Caudoviricetes sp. 2832643 Viruses Viruses 122 1.7399999999999998e-32   NR XOR85577.1 2832643 g44471 i0 47.5 1.19191919191919 118 41 98 1 3 293 11 128 XOR85577.1 MAG: hypothetical protein MSP1783_13 [Caudoviricetes sp.] diamond 354 122 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28190516 28190516 PRJNA789095_P_NODE_59646_length_264_cov_2.261780_g58312_i0 PRJNA789095 59646 264 2.26178 5.9710992 Zebrafish jaw poxvirus RQ14 Viruses Viruses 50.1 1.25e-4   NR BCT22826.1 RQ14 g58312 i0 34.1 1 88 38 98.9 4 2 262 81 149 BCT22826.1 hypothetical protein [Carp edema virus] diamond 264 50.1 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
28348596 28348596 PRJNA789095_P_NODE_73066_length_244_cov_0.859649_g71732_i0 PRJNA789095 73066 244 0.859649 2.09754356 Caudoviricetes sp. 2832643 Viruses Viruses 41.2 0.042   NR XOR96070.1 2832643 g71732 i0 33.3 0.590163934426229 48 32 59 0 3 146 64 111 XOR96070.1 MAG: hypothetical protein MSP1401_7 [Caudoviricetes sp.] diamond 144 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29990617 29990617 PRJNA789095_P_NODE_73411_length_243_cov_1.776471_g72077_i0 PRJNA789095 73411 243 1.776471 4.31682453 Zebrafish jaw poxvirus RQ14 Viruses Viruses 60.1 2.78e-8   NR BCT22649.1 RQ14 g72077 i0 37.3 0.925925925925926 75 47 92.6 0 1 225 176 250 BCT22649.1 hypothetical protein [Carp edema virus] diamond 225 60.1 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
30062821 30062821 PRJNA789095_P_NODE_47091_length_293_cov_1.050000_g45757_i0 PRJNA789095 47091 293 1.05 3.0765 Viruses 10239 Viruses Viruses 89.4 1.06e-19   NR UOW66397.1 2924891 g45757 i0 63.5 1.96587030716724 96 35 98.3 0 2 289 13 108 UOW66397.1 internal virion protein A [Aeromonas phage vB_AspA_Tola] diamond 576 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales   Tolavirus Tolavirus tola
30189270 30189270 PRJNA789095_P_NODE_81172_length_209_cov_5.441176_g79838_i0 PRJNA789095 81172 209 5.441176 11.37205784 Gajwadongvirus 2731941 Viruses Viruses 108 1.17e-25   NR QHJ80580.1 38018 g79838 i0 74.6 4.7511961722488 67 17 96.2 0 206 6 402 468 QHJ80580.1 MAG: hypothetical protein [Bacteriophage sp.] diamond 993 108 1 Viruses               Bacteriophage sp.
30275164 30275164 PRJNA789095_P_NODE_62532_length_258_cov_1.248649_g61198_i0 PRJNA789095 62532 258 1.248649 3.22151442 Caudoviricetes sp. 2832643 Viruses Viruses 57.8 4.4e-8   NR XOS24121.1 2832643 g61198 i0 37 0.941860465116279 81 50 93 1 1 240 3 83 XOS24121.1 MAG: gp40 protein [Caudoviricetes sp.] diamond 243 57.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30275165 30275165 PRJNA789095_P_NODE_67092_length_250_cov_0.870056_g65758_i0 PRJNA789095 67092 250 0.870056 2.17514 Zebrafish jaw poxvirus RQ14 Viruses Viruses 64.3 9.66e-10   NR BCT22613.1 RQ14 g65758 i0 40 0.96 80 48 96 0 248 9 5 84 BCT22613.1 serine-threonine kinase [Carp edema virus] diamond 240 64.3 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
30653896 30653896 PRJNA789095_P_NODE_67453_length_249_cov_2.806818_g66119_i0 PRJNA789095 67453 249 2.806818 6.98897682 Microbacterium phage NoodlelyBoi 2813165 Viruses Viruses 65.5 1.63e-10   NR YP_010751682.1 2813165 g66119 i0 43.6 1.13253012048193 94 38 95.2 2 12 248 70 163 YP_010751682.1 hypothetical protein QDA08_gp28 [Microbacterium phage NoodlelyBoi] diamond 282 65.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Hodgkinviridae Quhwahvirus Quhwahvirus noodelyboi
31033469 31033469 PRJNA789095_P_NODE_60955_length_261_cov_2.531915_g59621_i0 PRJNA789095 60955 261 2.531915 6.60829815 Ralstonia phage RP12 1923889 Viruses Viruses 76.6 4.12e-15   NR YP_009598740.1 1923889 g59621 i0 63.2 0.655172413793103 57 21 65.5 0 89 259 4 60 YP_009598740.1 hypothetical protein FDH28_gp047 [Ralstonia phage RP12] diamond 171 76.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
31285915 31285915 PRJNA789095_P_NODE_55535_length_273_cov_2.025000_g54201_i0 PRJNA789095 55535 273 2.025 5.52825 Avian associated hepe-like virus 21 3067867 Viruses Viruses 52.4 3.82e-6   NR WPR16533.1 3067867 g54201 i0 33.3 0.989010989010989 90 60 98.9 0 272 3 34 123 WPR16533.1 MAG: RNA-dependent RNA polymerase, partial [Avian associated hepe-like virus 21] diamond 270 52.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Hepelivirales Hepeviridae   Avian associated hepe-like virus 21
31349424 31349424 PRJNA789095_P_NODE_46156_length_296_cov_2.313901_g44822_i0 PRJNA789095 46156 296 2.313901 6.84914696 Zebrafish jaw poxvirus RQ14 Viruses Viruses 46.2 0.00389   NR BCT22728.1 RQ14 g44822 i0 55.9 0.344594594594595 34 15 34.5 0 193 294 1 34 BCT22728.1 DNA topoisomerase I [Carp edema virus] diamond 102 46.2 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
31412577 31412577 PRJNA789095_P_NODE_71036_length_246_cov_0.890173_g69702_i0 PRJNA789095 71036 246 0.890173 2.18982558 Zebrafish jaw poxvirus RQ14 Viruses Viruses 96.3 2.44e-21   NR BCT22662.1 RQ14 g69702 i0 53.8 0.975609756097561 80 37 97.6 0 243 4 109 188 BCT22662.1 soluble myristylprotein [Carp edema virus] diamond 240 96.3 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
32022834 32022834 PRJNA789095_P_NODE_67958_length_249_cov_0.875000_g66624_i0 PRJNA789095 67958 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 130 4.62e-33   NR XOR35160.1 2832643 g66624 i0 75.6 2.96385542168675 82 20 98.8 0 248 3 368 449 XOR35160.1 MAG: tail sheath protein [Caudoviricetes sp.] diamond 738 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32086055 32086055 PRJNA789095_P_NODE_47158_length_292_cov_4.022831_g45824_i0 PRJNA789095 47158 292 4.022831 11.74666652 root 1 Root_unresolved Root_unresolved 82.4 4.93e-16   NR XOR59342.1 2832643 g45824 i0 75.5 1.01712328767123 49 12 50.3 0 143 289 142 190 XOR59342.1 MAG: virion structural protein [Caudoviricetes sp.] diamond 297 82.8 0.995169082125604 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32614529 32614529 PRJNA789095_P_NODE_69620_length_247_cov_1.431034_g68286_i0 PRJNA789095 69620 247 1.431034 3.53465398 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 166 1.17e-45   NR WKU61618.1 3063761 g68286 i0 98.8 0.995951417004049 82 1 99.6 0 1 246 146 227 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 246 166 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
32771833 32771833 PRJNA789095_P_NODE_79840_length_224_cov_4.013245_g78506_i0 PRJNA789095 79840 224 4.013245 8.9896688 Trachysalambria curvirostris nimavirus 2984282 Viruses Viruses 70.1 6.74e-12   NR BDT63038.1 2984282 g78506 i0 47.2 6.84375 72 38 96.4 0 3 218 798 869 BDT63038.1 MAG: hypothetical protein [Trachysalambria curvirostris nimavirus] diamond 1533 70.1 1 Viruses       Naldaviricetes   Nimaviridae   Trachysalambria curvirostris nimavirus

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