RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 33 ✖

tax_clade 1

bioproject 1

  • PRJNA688655 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
10871205 10871205 PRJNA688655_P_NODE_1729_length_422_cov_2.538682_g1664_i0 PRJNA688655 1729 422 2.538682 10.71323804 Gammaretrovirus murleu 3428959 Viruses Viruses 278 2.1199999999999998e-89   NR 8WUS_E 11801 g1664 i0 97.1 12.9383886255924 140 4 99.5 0 3 422 235 374 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] diamond 5460 278 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
26797428 26797428 PRJNA688655_P_NODE_5241_length_291_cov_1.059633_g5176_i0 PRJNA688655 5241 291 1.059633 3.08353203 Caudoviricetes sp. 2832643 Viruses Viruses 94.4 3.83e-20   NR DAT50472.1 2832643 g5176 i0 54.1 1.79381443298969 85 38 87.6 1 20 274 114 197 DAT50472.1 MAG TPA: Chromatin remodeling complex ATPase [Caudoviricetes sp.] diamond 522 94.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26987211 26987211 PRJNA688655_P_NODE_11902_length_246_cov_0.890173_g11837_i0 PRJNA688655 11902 246 0.890173 2.18982558 Caudoviricetes sp. 2832643 Viruses Viruses 78.6 3.33e-15   NR DAG45282.1 2832643 g11837 i0 76.9 3.07317073170732 39 9 47.6 0 140 24 1 39 DAG45282.1 MAG TPA: Protein of unknown function (DUF5131) [Caudoviricetes sp.] diamond 756 78.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27050726 27050726 PRJNA688655_P_NODE_7202_length_257_cov_2.092391_g7137_i0 PRJNA688655 7202 257 2.092391 5.37744487 Bacillus phage PK16 1873894 Viruses Viruses 47 9.1e-4   NR ANY29250.1 1873894 g7137 i0 41.3 0.875486381322957 75 40 87.5 3 225 1 94 164 ANY29250.1 hypothetical protein [Bacillus phage PK16] diamond 225 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae Caeruleovirus Bacillus phage PK16
27271892 27271892 PRJNA688655_P_NODE_16423_length_241_cov_0.916667_g16358_i0 PRJNA688655 16423 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 118 6.48e-30   NR DAZ41723.1 2832643 g16358 i0 60 1.9792531120332 80 32 99.6 0 241 2 255 334 DAZ41723.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 477 118 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27524614 27524614 PRJNA688655_P_NODE_6423_length_270_cov_1.172589_g6358_i0 PRJNA688655 6423 270 1.172589 3.1659903 Caudoviricetes sp. 2832643 Viruses Viruses 177 4.54e-51   NR XOR21345.1 2832643 g6358 i0 92.1 2.96666666666667 89 7 98.9 0 3 269 106 194 XOR21345.1 MAG: gp61 protein [Caudoviricetes sp.] diamond 801 177 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27871899 27871899 PRJNA688655_P_NODE_5725_length_282_cov_1.105263_g5660_i0 PRJNA688655 5725 282 1.105263 3.11684166 Bacillus phage BCD7 1136534 Viruses Viruses 48.9 1.81e-5   NR YP_007005953.1 1136534 g5660 i0 62.8 0.457446808510638 43 13 45.7 2 153 281 3 42 YP_007005953.1 hypothetical protein F400_gp102 [Bacillus phage BCD7] diamond 129 48.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Becedseptimavirus Becedseptimavirus BCD7
27935157 27935157 PRJNA688655_P_NODE_1645_length_431_cov_1.290503_g1580_i0 PRJNA688655 1645 431 1.290503 5.56206793 Caudoviricetes sp. 2832643 Viruses Viruses 186 5.919999999999999e-56   NR DAQ85694.1 2832643 g1580 i0 61.8 1.00232018561485 144 54 99.5 1 430 2 99 242 DAQ85694.1 MAG TPA: Head protein [Caudoviricetes sp.] diamond 432 186 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27935160 27935160 PRJNA688655_P_NODE_2405_length_372_cov_1.802676_g2340_i0 PRJNA688655 2405 372 1.802676 6.70595472 Caudoviricetes sp. 2832643 Viruses Viruses 112 4.45e-26   NR DAQ85693.1 2832643 g2340 i0 47 0.92741935483871 115 61 92.7 0 367 23 610 724 DAQ85693.1 MAG TPA: DNA polymerase B [Caudoviricetes sp.] diamond 345 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27966570 27966570 PRJNA688655_P_NODE_12065_length_246_cov_0.890173_g12000_i0 PRJNA688655 12065 246 0.890173 2.18982558 Mycobacterium phage prophiGD27-1 2813254 Viruses Viruses 46.2 2.15e-4   NR QSM04241.1 2813254 g12000 i0 63.3 0.365853658536585 30 11 36.6 0 99 10 14 43 QSM04241.1 hypothetical protein PROPHIGD27-1_45 [Mycobacterium phage prophiGD27-1] diamond 90 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Mycobacterium phage prophiGD27-1
28377010 28377010 PRJNA688655_P_NODE_1466_length_453_cov_1.013158_g1401_i0 PRJNA688655 1466 453 1.013158 4.58960574 Caudoviricetes sp. 2832643 Viruses Viruses 201 1.08e-59   NR XOR21344.1 2832643 g1401 i0 67.6 0.980132450331126 148 48 98 0 6 449 10 157 XOR21344.1 MAG: phage portal protein [Caudoviricetes sp.] diamond 444 201 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28566513 28566513 PRJNA688655_P_NODE_2427_length_371_cov_1.291946_g2362_i0 PRJNA688655 2427 371 1.291946 4.79311966 Acinetobacter phage vB_AbaM_ME3 1837876 Viruses Viruses 72.4 6.51e-12   NR YP_009595845.1 1837876 g2362 i0 32.8 1.01078167115903 125 77 97.8 3 365 3 154 275 YP_009595845.1 large terminase subunit [Acinetobacter phage vB_AbaM_ME3] diamond 375 72.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Metrivirus Metrivirus ME3
28661368 28661368 PRJNA688655_P_NODE_13407_length_244_cov_0.900585_g13342_i0 PRJNA688655 13407 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 53.1 5.69e-7   NR DAI10838.1 2832643 g13342 i0 42.5 1.59836065573771 73 33 82.4 2 2 202 1 70 DAI10838.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 390 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28850514 28850514 PRJNA688655_P_NODE_10888_length_247_cov_0.885057_g10823_i0 PRJNA688655 10888 247 0.885057 2.18609079 uncultured Caudovirales phage 2100421 Viruses Viruses 97.1 1.3400000000000002e-21   NR CAB4185919.1 2100421 g10823 i0 56.1 1.9919028340081 82 36 99.6 0 247 2 221 302 CAB4185919.1 portal_HK97, phage portal protein, HK97 family [uncultured Caudovirales phage] diamond 492 97.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28913633 28913633 PRJNA688655_P_NODE_6148_length_274_cov_1.507463_g6083_i0 PRJNA688655 6148 274 1.507463 4.13044862 Bacillus phage BCD7 1136534 Viruses Viruses 67 2.1e-11   NR YP_007005893.1 1136534 g6083 i0 60.7 0.667883211678832 61 23 65.7 1 184 5 1 61 YP_007005893.1 Holliday junction resolvase [Bacillus phage BCD7] diamond 183 67 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Becedseptimavirus Becedseptimavirus BCD7
28977167 28977167 PRJNA688655_P_NODE_6228_length_273_cov_1.155000_g6163_i0 PRJNA688655 6228 273 1.155 3.15315 Caudoviricetes sp. 2832643 Viruses Viruses 124 6.73e-33   NR DAY91847.1 2832643 g6163 i0 65.9 1 91 30 98.9 1 272 3 96 186 DAY91847.1 MAG TPA: Mannosyl-glycoprotein endo-beta-N-acetylglucosaminidase [Caudoviricetes sp.] diamond 273 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29020434 29020434 PRJNA688655_P_NODE_3788_length_322_cov_1.236948_g3723_i0 PRJNA688655 3788 322 1.236948 3.98297256 Becedseptimavirus 2843358 Viruses Viruses 117 4.13e-28   NR UWD54021.1 38018 g3723 i0 65.1 5.45031055900621 83 29 77.3 0 250 2 444 526 UWD54021.1 MAG: DNA polymerase family A [Bacteriophage sp.] diamond 1755 118 0.991525423728814 Viruses               Bacteriophage sp.
29608124 29608124 PRJNA688655_P_NODE_8150_length_251_cov_0.865169_g8085_i0 PRJNA688655 8150 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 60.1 3.23e-8   NR DAI30395.1 2832643 g8085 i0 41.9 1.02788844621514 86 47 99.2 2 250 2 861 946 DAI30395.1 MAG TPA: Kelch repeat [Caudoviricetes sp.] diamond 258 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29829461 29829461 PRJNA688655_P_NODE_10911_length_247_cov_0.885057_g10846_i0 PRJNA688655 10911 247 0.885057 2.18609079 Fadolivirus algeromassiliense 3060017 Viruses Viruses 44.7 0.00799   NR YP_010803684.1 3060017 g10846 i0 41.2 1.88259109311741 51 29 60.7 1 241 92 348 398 YP_010803684.1 peptidase C19 ubiquitin carboxyl-terminal hydrolase [Fadolivirus algeromassiliense] diamond 465 44.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Fadolivirus Fadolivirus algeromassiliense
30050504 30050504 PRJNA688655_P_NODE_1151_length_501_cov_1.079439_g1086_i0 PRJNA688655 1151 501 1.079439 5.40798939 Caudoviricetes sp. 2832643 Viruses Viruses 207 2.15e-62   NR DAQ85692.1 2832643 g1086 i0 60.6 1.01796407185629 170 63 99.4 2 3 500 214 383 DAQ85692.1 MAG TPA: Terminase [Caudoviricetes sp.] diamond 510 207 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30113759 30113759 PRJNA688655_P_NODE_14952_length_243_cov_0.905882_g14887_i0 PRJNA688655 14952 243 0.905882 2.20129326 Caudoviricetes sp. 2832643 Viruses Viruses 88.6 3.27e-19   NR DAO31584.1 2832643 g14887 i0 58.4 1.98765432098765 77 29 91.4 1 22 243 50 126 DAO31584.1 MAG TPA: Protein of unknown function (DUF669) [Caudoviricetes sp.] diamond 483 88.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30208361 30208361 PRJNA688655_P_NODE_852_length_579_cov_1.278656_g787_i0 PRJNA688655 852 579 1.278656 7.40341824 Caudoviricetes sp. 2832643 Viruses Viruses 123 1.89e-30   NR DAQ85696.1 2832643 g787 i0 56.6 0.549222797927461 106 39 54.9 1 261 578 4 102 DAQ85696.1 MAG TPA: Major tail protein [Caudoviricetes sp.] diamond 318 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30619298 30619298 PRJNA688655_P_NODE_493_length_746_cov_1.136701_g432_i0 PRJNA688655 493 746 1.136701 8.47978946 Bacillus phage BCD7 1136534 Viruses Viruses 100 4.9899999999999996e-23   NR YP_007005922.1 1136534 g432 i0 57.8 0.333780160857909 83 34 33.4 1 249 1 1 82 YP_007005922.1 hypothetical protein F400_gp071 [Bacillus phage BCD7] diamond 249 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Becedseptimavirus Becedseptimavirus BCD7
30872078 30872078 PRJNA688655_P_NODE_13094_length_245_cov_0.895349_g13029_i0 PRJNA688655 13094 245 0.895349 2.19360505 Caudoviricetes sp. 2832643 Viruses Viruses 55.1 1.62e-6   NR DAN04088.1 2832643 g13029 i0 40.3 1.88571428571429 77 34 94.3 3 3 233 157 221 DAN04088.1 MAG TPA: restriction enzyme [Caudoviricetes sp.] diamond 462 55.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31219361 31219361 PRJNA688655_P_NODE_1835_length_411_cov_2.357988_g1770_i0 PRJNA688655 1835 411 2.357988 9.69133068 Poseidoniales virus 3101553 Viruses Viruses 108 3.55e-27   NR XHA59796.1 3101553 g1770 i0 51.5 0.751824817518248 103 46 75.2 1 311 3 56 154 XHA59796.1 MAG: hypothetical protein [Poseidoniales virus] diamond 309 108 1 Viruses               Poseidoniales virus
31282870 31282870 PRJNA688655_P_NODE_15755_length_242_cov_0.911243_g15690_i0 PRJNA688655 15755 242 0.911243 2.20520806 Siphoviridae sp. ctnPP24 2825662 Viruses Viruses 69.3 5.33e-12   NR DAF87307.1 2825662 g15690 i0 44.3 0.979338842975207 79 38 90.5 2 237 19 90 168 DAF87307.1 MAG TPA: homing endonuclease [Siphoviridae sp. ctnPP24] diamond 237 69.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctnPP24
31409542 31409542 PRJNA688655_P_NODE_776_length_605_cov_2.093985_g711_i0 PRJNA688655 776 605 2.093985 12.66860925 Caudoviricetes sp. 2832643 Viruses Viruses 207 6.26e-59   NR DAQ85693.1 2832643 g711 i0 51.8 0.986776859504132 199 90 98.7 2 599 3 123 315 DAQ85693.1 MAG TPA: DNA polymerase B [Caudoviricetes sp.] diamond 597 207 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31662347 31662347 PRJNA688655_P_NODE_13097_length_245_cov_0.895349_g13032_i0 PRJNA688655 13097 245 0.895349 2.19360505 Edafosvirus sp. 2487765 Viruses Viruses 102 4.9299999999999996e-24   NR AYV77936.1 2487765 g13032 i0 58.8 0.979591836734694 80 33 98 0 3 242 61 140 AYV77936.1 MAG: GTP binding translation elongation factor [Edafosvirus sp.] diamond 240 102 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
31737176 31737176 PRJNA688655_P_NODE_13357_length_244_cov_1.619883_g13292_i0 PRJNA688655 13357 244 1.619883 3.95251452 Zukovirus 3044870 Viruses Viruses 115 1.28e-27   NR YP_010655569.1 2601695 g13292 i0 70 3.9344262295082 80 24 98.4 0 3 242 730 809 YP_010655569.1 DNA polymerase I [Streptomyces phage Zuko] diamond 960 115 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Zukovirus Zukovirus zuko
31820545 31820545 PRJNA688655_P_NODE_8977_length_250_cov_0.870056_g8912_i0 PRJNA688655 8977 250 0.870056 2.17514 uncultured Caudovirales phage 2100421 Viruses Viruses 63.2 1.55e-10   NR CAB5226352.1 2100421 g8912 i0 45.1 0.984 82 43 98.4 2 248 3 28 107 CAB5226352.1 hypothetical protein UFOVP760_129 [uncultured Caudovirales phage] diamond 246 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31947039 31947039 PRJNA688655_P_NODE_9557_length_249_cov_0.875000_g9492_i0 PRJNA688655 9557 249 0.875 2.17875 Caudoviricetes sp. 2832643 Viruses Viruses 47 9.45e-4   NR DAN47132.1 2832643 g9492 i0 43 0.951807228915663 79 36 84.3 3 39 248 51 129 DAN47132.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 237 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32232251 32232251 PRJNA688655_P_NODE_4658_length_302_cov_1.344978_g4593_i0 PRJNA688655 4658 302 1.344978 4.06183356 Bacillus phage BCD7 1136534 Viruses Viruses 104 1.34e-23   NR YP_007005955.1 1136534 g4593 i0 65.8 0.78476821192053 79 27 78.5 0 298 62 110 188 YP_007005955.1 putative terminase large subunit [Bacillus phage BCD7] diamond 237 104 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Becedseptimavirus Becedseptimavirus BCD7
32674220 32674220 PRJNA688655_P_NODE_16120_length_241_cov_0.916667_g16055_i0 PRJNA688655 16120 241 0.916667 2.20916747 Pithovirus LCPAC1 2506587 Viruses Viruses 42.7 0.0368   NR QBK90293.1 2506587 g16055 i0 31.3 0.995850622406639 80 44 99.6 1 1 240 24 92 QBK90293.1 MAG: hypothetical protein LCPAC102_02060 [Pithovirus LCPAC102] diamond 240 42.7 1 Viruses Pithoviruses             Pithovirus LCPAC102

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