RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 35 ✖

bioproject 1

  • PRJNA812001 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
8464113 8464113 PRJNA812001_P_NODE_9347_length_512_cov_1.259681_g9101_i0 PRJNA812001 9347 512 1.259681 6.44956672 Hafnia phage TS33 3110108 Viruses Viruses 323 1.19e-102   NR WQY91225.1 3110108 g9101 i0 92.4 2.98828125 170 13 99.6 0 510 1 499 668 WQY91225.1 hypothetical protein [Hafnia phage TS33] diamond 1530 323 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
10152998 10152998 PRJNA812001_P_NODE_35148_length_321_cov_2.282258_g34902_i0 PRJNA812001 35148 321 2.282258 7.32604818 Viruses 10239 Viruses Viruses 161 3.44e-44   NR YP_874043.1 407392 g34902 i0 76.6 1.75700934579439 94 22 87.9 0 308 27 492 585 YP_874043.1 hypothetical protein YS40_030 [Thermus phage phiYS40] diamond 564 162 0.993827160493827 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage phiYS40
12704042 12704042 PRJNA812001_P_NODE_7330_length_572_cov_2.082164_g7085_i0 PRJNA812001 7330 572 2.082164 11.90997808 Caudoviricetes sp. 2832643 Viruses Viruses 159 8.799999999999999e-47   NR QHJ79797.1 2832643 g7085 i0 69 1.20104895104895 113 35 59.3 0 401 63 1 113 QHJ79797.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 687 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19937306 19937306 PRJNA812001_P_NODE_3656_length_803_cov_10.202740_g3436_i0 PRJNA812001 3656 803 10.20274 81.9280022 Bacillus phage SP-15 1792032 Viruses Viruses 84.7 1.74e-16   NR YP_009302701.1 1792032 g3436 i0 47.4 0.36239103362391 97 45 34 1 278 6 1 97 YP_009302701.1 hypothetical protein SP15_304 [Bacillus phage SP-15] diamond 291 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Thornevirus Thornevirus SP15
19937647 19937647 PRJNA812001_P_NODE_7956_length_550_cov_1.501048_g7711_i0 PRJNA812001 7956 550 1.501048 8.255764 Caudoviricetes sp. 2832643 Viruses Viruses 278 1.15e-93   NR QHJ80257.1 2832643 g7711 i0 89.4 0.774545454545455 142 15 77.5 0 514 89 1 142 QHJ80257.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 426 278 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
20350666 20350666 PRJNA812001_P_NODE_12876_length_445_cov_4.193050_g12630_i0 PRJNA812001 12876 445 4.19305 18.6590725 Caudoviricetes sp. 2832643 Viruses Viruses 60.1 5.83e-8   NR XOS38649.1 2832643 g12630 i0 39.8 3.90337078651685 113 61 73.5 2 426 100 2 111 XOS38649.1 MAG: hypothetical protein MSP1091_46 [Caudoviricetes sp.] diamond 1737 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26651315 26651315 PRJNA812001_P_NODE_10281_length_490_cov_2.071942_g10035_i0 PRJNA812001 10281 490 2.071942 10.1525158 Viruses 10239 Viruses Viruses 126 1.2e-34   NR QUL77296.1 2811509 g10035 i0 66.3 1.93469387755102 86 29 52.7 0 408 151 1 86 QUL77296.1 hypothetical protein [Escherichia phage UPEC06] diamond 948 126 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Escherichia phage UPEC06
26737333 26737333 PRJNA812001_P_NODE_98701_length_247_cov_1.327586_g98455_i0 PRJNA812001 98701 247 1.327586 3.27913742 Wisapiscaud virus 1 3375905 Viruses Viruses 118 8.160000000000001e-29   NR XJU74172.1 3375905 g98455 i0 70.4 0.983805668016194 81 24 98.4 0 245 3 287 367 XJU74172.1 MAG: tail protein [Wisapiscaud virus 1] diamond 243 118 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Wisapiscaud virus 1
27243904 27243904 PRJNA812001_P_NODE_136843_length_228_cov_4.503226_g136597_i0 PRJNA812001 136843 228 4.503226 10.26735528 Achromobacter phage JWF 1589748 Viruses Viruses 111 2.17e-29   NR YP_009224052.1 1589748 g136597 i0 70.8 1.89473684210526 72 21 94.7 0 12 227 69 140 YP_009224052.1 Holliday junction resolvase [Achromobacter phage JWF] diamond 432 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
27568508 27568508 PRJNA812001_P_NODE_39724_length_310_cov_1.987342_g39478_i0 PRJNA812001 39724 310 1.987342 6.1607602 root 1 Root_unresolved Root_unresolved 106 6.45e-28   NR QGA72446.1 340016 g39478 i0 91.1 1.08387096774194 56 5 54.2 0 143 310 10 65 QGA72446.1 hypothetical protein [uncultured virus] diamond 336 106 1 Viruses               uncultured virus
27591574 27591574 PRJNA812001_P_NODE_11624_length_464_cov_1.690537_g11378_i0 PRJNA812001 11624 464 1.690537 7.84409168 Salmonella phage vB_SalM-LPST94 2282399 Viruses Viruses 266 8.78e-82   NR AXF41693.1 2282399 g11378 i0 87 0.995689655172414 154 20 99.6 0 2 463 534 687 AXF41693.1 hypothetical protein LPST94_00131 [Salmonella phage vB_SalM-LPST94] diamond 462 266 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Kuttervirus Salmonella phage vB_SalM-LPST94
27591578 27591578 PRJNA812001_P_NODE_131024_length_241_cov_0.916667_g130778_i0 PRJNA812001 131024 241 0.916667 2.20916747 Vibrio phage vB_VcorM_GR11A 2711164 Viruses Viruses 69.7 4.73e-12   NR QJT71284.1 2711164 g130778 i0 50.7 0.83402489626556 67 32 82.2 1 241 44 180 246 QJT71284.1 hypothetical protein GR11A_00247 [Vibrio phage vB_VcorM_GR11A] diamond 201 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage vB_VcorM_GR11A
27749496 27749496 PRJNA812001_P_NODE_37984_length_314_cov_2.564315_g37738_i0 PRJNA812001 37984 314 2.564315 8.0519491 uncultured virus 340016 Viruses Viruses 83.6 8.6e-19   NR QGA72442.1 340016 g37738 i0 78 0.477707006369427 50 11 47.8 0 311 162 16 65 QGA72442.1 thymidylate kinase [uncultured virus] diamond 150 83.6 1 Viruses               uncultured virus
28380709 28380709 PRJNA812001_P_NODE_16006_length_409_cov_1.815476_g15760_i0 PRJNA812001 16006 409 1.815476 7.42529684 Serratia phage Eta 1282995 Viruses Viruses 56.6 1.69e-7   NR YP_008130345.1 1282995 g15760 i0 50 0.425427872860636 58 29 42.5 0 407 234 4 61 YP_008130345.1 hypothetical protein Eta_0052 [Serratia phage Eta] diamond 174 56.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
28538816 28538816 PRJNA812001_P_NODE_137407_length_220_cov_4.115646_g137161_i0 PRJNA812001 137407 220 4.115646 9.0544212 Thermus phage TH115 3079687 Viruses Viruses 68.6 2.12e-11   NR WQZ00057.1 3079687 g137161 i0 56.3 0.654545454545455 48 21 65.5 0 197 54 234 281 WQZ00057.1 hypothetical protein [Thermus phage TH115] diamond 144 68.6 1 Viruses               Thermus phage TH115
29170212 29170212 PRJNA812001_P_NODE_24389_length_356_cov_2.756184_g24143_i0 PRJNA812001 24389 356 2.756184 9.81201504 Caudoviricetes sp. 2832643 Viruses Viruses 50.4 1.09e-5   NR QHJ79757.1 2832643 g24143 i0 62.5 0.404494382022472 48 14 40.4 1 173 30 4 47 QHJ79757.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 144 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29233355 29233355 PRJNA812001_P_NODE_14449_length_425_cov_1.127841_g14203_i0 PRJNA812001 14449 425 1.127841 4.79332425 Caudoviricetes sp. 2832643 Viruses Viruses 81.3 4.94e-17   NR DAU29119.1 2832643 g14203 i0 48.4 0.670588235294118 95 38 64.2 4 141 413 4 91 DAU29119.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 285 81.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29706412 29706412 PRJNA812001_P_NODE_137750_length_209_cov_4.044118_g137504_i0 PRJNA812001 137750 209 4.044118 8.45220662 Klebsiella phage FKP1 3237190 Viruses Viruses 41.6 0.032   NR XFC52219.1 3237190 g137504 i0 38.3 0.674641148325359 47 28 66 1 150 13 62 108 XFC52219.1 methyltransferase [Klebsiella phage FKP10] diamond 141 41.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae Taipeivirus Klebsiella phage FKP10
29769848 29769848 PRJNA812001_P_NODE_39171_length_312_cov_0.916318_g38925_i0 PRJNA812001 39171 312 0.916318 2.85891216 Hafnia phage TS33 3110108 Viruses Viruses 171 1.29e-48   NR WQY91229.1 3110108 g38925 i0 79.8 1 104 20 99 1 309 1 192 295 WQY91229.1 62kDa structural protein [Hafnia phage TS33] diamond 312 171 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33
29873556 29873556 PRJNA812001_P_NODE_1531_length_1192_cov_20.955317_g1368_i0 PRJNA812001 1531 1192 20.955317 249.78737863999999 Narnavirus 186767 Viruses Viruses 306 1.03e-97   NR XBY85592.1 3229034 g1368 i0 63.8 1.21057046979866 254 72 61.4 4 1125 394 1 244 XBY85592.1 MAG: hypothetical protein [Exserohilum turcicum narnavirus 1] diamond 1443 309 0.990291262135922 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Exserohilum turcicum narnavirus 1
29968341 29968341 PRJNA812001_P_NODE_19971_length_379_cov_2.715686_g19725_i0 PRJNA812001 19971 379 2.715686 10.29244994 Jerseyvirus 1910991 Viruses Viruses 189 1.5e-59   NR UVX80968.1 38018 g19725 i0 78.1 1.80474934036939 114 25 90.2 0 379 38 11 124 UVX80968.1 MAG: HNH endonuclease [Bacteriophage sp.] diamond 684 189 1 Viruses               Bacteriophage sp.
30054113 30054113 PRJNA812001_P_NODE_9811_length_500_cov_2.159251_g9565_i0 PRJNA812001 9811 500 2.159251 10.796255 Serratia phage vB_SmaM-Kashira 2943834 Viruses Viruses 129 1.24e-34   NR URC22635.1 2943834 g9565 i0 52.9 0.624 104 49 62.4 0 314 3 1 104 URC22635.1 hypothetical protein KASHIRA_00410 [Serratia phage vB_SmaM-Kashira] diamond 312 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-Kashira
30622828 30622828 PRJNA812001_P_NODE_21693_length_369_cov_1.793919_g21447_i0 PRJNA812001 21693 369 1.793919 6.61956111 Serratia phage Eta 1282995 Viruses Viruses 206 2.01e-63   NR YP_008130344.1 1282995 g21447 i0 82.1 1 123 22 100 0 1 369 148 270 YP_008130344.1 major head protein [Serratia phage Eta] diamond 369 206 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
30686042 30686042 PRJNA812001_P_NODE_125193_length_242_cov_1.366864_g124947_i0 PRJNA812001 125193 242 1.366864 3.30781088 Mamestra configurata nucleopolyhedrovirus A 207830 Viruses Viruses 42.4 0.0499   NR QNH90560.1 207830 g124947 i0 45.3 0.65702479338843 53 22 62 2 87 236 423 471 QNH90560.1 maco-A 94/2 86 [Mamestra configurata nucleopolyhedrovirus A] diamond 159 42.4 1 Viruses       Naldaviricetes Lefavirales Baculoviridae Alphabaculovirus Alphabaculovirus maconfiguratae
31002241 31002241 PRJNA812001_P_NODE_12234_length_454_cov_8.918635_g11988_i0 PRJNA812001 12234 454 8.918635 40.4906029 Erythrocytic necrosis virus 1543320 Viruses Viruses 93.2 1.63e-21   NR QCF47491.1 1543320 g11988 i0 87.8 0.323788546255507 49 6 32.4 0 297 443 26 74 QCF47491.1 RNA-dependent DNA polymerase [Erythrocytic necrosis virus] diamond 147 93.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
31128174 31128174 PRJNA812001_P_NODE_134635_length_241_cov_0.916667_g134389_i0 PRJNA812001 134635 241 0.916667 2.20916747 Drosophila-associated Gosford narnavirus 3077863 Viruses Viruses 96.3 5.16e-21   NR WPV74303.1 3077863 g134389 i0 57.1 1.94190871369295 77 32 95.9 1 239 9 639 714 WPV74303.1 MAG: RNA-dependent RNA polymerase, partial [Drosophila-associated Gosford narnavirus] diamond 468 96.3 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Drosophila microbiome-associated Gosford Narnavirus
31223121 31223121 PRJNA812001_P_NODE_122875_length_243_cov_0.905882_g122629_i0 PRJNA812001 122875 243 0.905882 2.20129326 Tupanvirus deep ocean 2126984 Viruses Viruses 79 6.61e-15   NR YP_010780739.1 2126984 g122629 i0 49.4 1 81 40 98.8 1 242 3 1041 1121 YP_010780739.1 hypothetical protein QJ856_gp0626 [Tupanvirus deep ocean] diamond 243 79 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus altamarinense
31697763 31697763 PRJNA812001_P_NODE_14977_length_419_cov_1.910405_g14731_i0 PRJNA812001 14977 419 1.910405 8.00459695 Serratia phage vB_SmaM-ChuuTotoro 2943832 Viruses Viruses 132 1.55e-36   NR URC22120.1 2943832 g14731 i0 65.7 0.708830548926014 99 34 70.9 0 123 419 4 102 URC22120.1 hypothetical protein CHUUTOTORO_00160 [Serratia phage vB_SmaM-ChuuTotoro] diamond 297 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-ChuuTotoro
32172540 32172540 PRJNA812001_P_NODE_6278_length_619_cov_7.478022_g6036_i0 PRJNA812001 6278 619 7.478022 46.28895618 uncultured virus 340016 Viruses Viruses 318 1.1799999999999995e-96   NR QGA72470.1 340016 g6036 i0 77.1 1.81744749596123 188 42 90.6 1 590 30 224 411 QGA72470.1 DNA polymerase I [uncultured virus] diamond 1125 318 1 Viruses               uncultured virus
32299253 32299253 PRJNA812001_P_NODE_35779_length_320_cov_1.161943_g35533_i0 PRJNA812001 35779 320 1.161943 3.7182176 Achromobacter phage JWF 1589748 Viruses Viruses 133 1.4299999999999998e-37   NR YP_009224027.1 1589748 g35533 i0 82.1 0.73125 78 13 73.1 1 318 85 4 80 YP_009224027.1 hypothetical protein AXJ13_gp021 [Achromobacter phage JWF] diamond 234 133 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
32488941 32488941 PRJNA812001_P_NODE_19959_length_379_cov_7.124183_g19713_i0 PRJNA812001 19959 379 7.124183 27.00065357 Erythrocytic necrosis virus 1543320 Viruses Viruses 60.5 1.16e-8   NR QCF47477.1 1543320 g19713 i0 60.9 0.728232189973615 46 17 35.6 1 68 202 91 136 QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] diamond 276 60.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
32583752 32583752 PRJNA812001_P_NODE_128219_length_242_cov_0.911243_g127973_i0 PRJNA812001 128219 242 0.911243 2.20520806 Acinetobacter phage ABPH49 2282400 Viruses Viruses 77.8 5.88e-17   NR AXN57863.1 2282400 g127973 i0 63 0.669421487603306 54 20 66.9 0 4 165 8 61 AXN57863.1 hypothetical protein [Acinetobacter phage ABPH49] diamond 162 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage ABPH49
32615093 32615093 PRJNA812001_P_NODE_135900_length_237_cov_2.189024_g135654_i0 PRJNA812001 135900 237 2.189024 5.18798688 Caudoviricetes sp. 2832643 Viruses Viruses 80.9 4.36e-18   NR DAV92137.1 2832643 g135654 i0 65.1 0.79746835443038 63 22 79.7 0 5 193 9 71 DAV92137.1 MAG TPA: T-complex protein 1 subunit alpha [Caudoviricetes sp.] diamond 189 80.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32772373 32772373 PRJNA812001_P_NODE_70860_length_260_cov_6.454545_g70614_i0 PRJNA812001 70860 260 6.454545 16.781817 Thermus phage TH115 3079687 Viruses Viruses 114 2.6500000000000004e-27   NR WQZ00057.1 3079687 g70614 i0 63 0.842307692307692 73 27 84.2 0 32 250 234 306 WQZ00057.1 hypothetical protein [Thermus phage TH115] diamond 219 114 1 Viruses               Thermus phage TH115
32898264 32898264 PRJNA812001_P_NODE_137380_length_220_cov_7.761905_g137134_i0 PRJNA812001 137380 220 7.761905 17.076191 Thermus phage TH115 3079687 Viruses Viruses 90.9 1.63e-19   NR WQZ00051.1 3079687 g137134 i0 56.7 0.913636363636364 67 29 91.4 0 201 1 308 374 WQZ00051.1 hypothetical protein [Thermus phage TH115] diamond 201 90.9 1 Viruses               Thermus phage TH115

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