RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA1129273" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 23 ✖

bioproject 1

  • PRJNA1129273 · 23 ✖

analysis 1

  • blastn · 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
283261 283261 PRJNA1129273_P_NODE_5061_length_316_cov_1.172840_g4781_i0 PRJNA1129273 5061 316 1.17284 3.7061744 Augustepiccardvirus augustepiccard 3426500 Viruses Viruses 429 1.17e-115   NTclustered gi|2071739426|gb|MZ501051.1| 2851954 g4781 i0 91.374 54.4050632911392 313 27 99 0 2 314 19375 19063 Escherichia phage AugustePiccard strain Bas01, complete genome blastn 17192 429 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Augustepiccardvirus Augustepiccardvirus augustepiccard
4110257 4110257 PRJNA1129273_P_NODE_3324_length_404_cov_2.782477_g3045_i0 PRJNA1129273 3324 404 2.782477 11.24120708 Soybean thrips dicistrovirus 1 2797876 Viruses Viruses 263 1.64e-65   NTclustered gi|1954985862|gb|MT195550.1| 2797876 g3045 i0 78.803 0.992574257425743 401 77 98 7 8 404 7182 6786 Soybean thrips dicistrovirus 1 strain STN1, complete genome blastn 401 263 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Soybean thrips dicistrovirus 1
4110292 4110292 PRJNA1129273_P_NODE_8064_length_258_cov_1.081081_g7784_i0 PRJNA1129273 8064 258 1.081081 2.78918898 Veterinaerplatzvirus SU57 3433204 Viruses Viruses 418 2.0099999999999995e-112   NTclustered gi|1867204057|gb|MT511058.1| 2743969 g7784 i0 96.094 58.5 256 10 99 0 2 257 16854 16599 Escherichia phage vB_EcoD_SU57, complete genome blastn 15093 418 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Veterinaerplatzvirus Veterinaerplatzvirus SU57
5386428 5386428 PRJNA1129273_P_NODE_10525_length_242_cov_0.923077_g10245_i0 PRJNA1129273 10525 242 0.923077 2.23384634 Pseudomonas phage D6 3025445 Viruses Viruses 237 5.61e-58   NTclustered gi|2449456336|gb|OQ363659.1| 3025445 g10245 i0 85.714 0.925619834710744 224 32 93 0 18 241 266046 266269 Pseudomonas phage D6, complete genome blastn 224 237 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage D6
6661121 6661121 PRJNA1129273_P_NODE_4786_length_326_cov_1.221344_g4506_i0 PRJNA1129273 4786 326 1.221344 3.98158144 Zebrafish picornavirus 1 2304617 Viruses Viruses 569 6.839999999999998e-158   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g4506 i0 98.452 2.95705521472393 323 5 99 0 4 326 719 397 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 964 569 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
6661172 6661172 PRJNA1129273_P_NODE_9966_length_245_cov_0.883721_g9686_i0 PRJNA1129273 9966 245 0.883721 2.16511645 Veterinaerplatzvirus FP 3433202 Viruses Viruses 374 4.16e-99   NTclustered gi|1867199596|gb|MT682706.1| 2750857 g9686 i0 94.262 62.8530612244898 244 14 99 0 1 244 31898 32141 Escherichia phage vB_EcoS_FP, complete genome blastn 15399 374 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Veterinaerplatzvirus Veterinaerplatzvirus FP
9211267 9211267 PRJNA1129273_P_NODE_5948_length_289_cov_2.800926_g5668_i0 PRJNA1129273 5948 289 2.800926 8.09467614 Suseptimavirus ECBP2 3052757 Viruses Viruses 466 8.06e-127   NTclustered gi|408905854|ref|NC_018859.1| 1604355 g5668 i0 95.833 12.7820069204152 288 12 99 0 1 288 28580 28867 Escherichia phage ECBP2, complete genome blastn 3694 466 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus ECBP2
9959780 9959780 PRJNA1129273_P_NODE_5128_length_313_cov_1.908333_g4848_i0 PRJNA1129273 5128 313 1.908333 5.97308229 Mktvariviridae 3424663 Viruses Viruses 368 2.56e-97   NTclustered gi|2438101311|ref|NC_070983.1| 2860374 g4848 i0 88.013 4.98402555910543 317 31 99 1 1 310 67966 68282 Escherichia phage IME267, complete genome blastn 1560 368 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus IME267
10486754 10486754 PRJNA1129273_P_NODE_2249_length_526_cov_3.156733_g1973_i0 PRJNA1129273 2249 526 3.156733 16.60441558 Hubei picorna-like virus 14 1923093 Viruses Viruses 394 7.44e-105   NTclustered gi|1132371418|ref|NC_033112.1| 1923093 g1973 i0 80.539 1.97338403041825 519 95 98 6 5 520 1581 2096 Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 1038 394 1 Viruses               Hubei picorna-like virus 14
10486763 10486763 PRJNA1129273_P_NODE_3349_length_402_cov_1.844985_g3070_i0 PRJNA1129273 3349 402 1.844985 7.4168397 Polycipiviridae sp. 2496155 Viruses Viruses 52.8 0.039   NTclustered gi|2756421824|gb|PP744841.1| 2496155 g3070 i0 90.244 0.101990049751244 41 3 10 1 296 335 9211 9171 MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence blastn 41 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae   Polycipiviridae sp.
10486789 10486789 PRJNA1129273_P_NODE_7469_length_266_cov_1.196891_g7189_i0 PRJNA1129273 7469 266 1.196891 3.18373006 Hubei picorna-like virus 14 1923093 Viruses Viruses 132 3.04e-26   NTclustered gi|1132371418|ref|NC_033112.1| 1923093 g7189 i0 80.226 1.71052631578947 177 34 66 1 72 247 978 802 Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 455 132 1 Viruses               Hubei picorna-like virus 14
13036946 13036946 PRJNA1129273_P_NODE_10831_length_237_cov_2.329268_g10551_i0 PRJNA1129273 10831 237 2.329268 5.52036516 Kuravirus SGF2 3060083 Viruses Viruses 239 1.52e-58   NTclustered gi|2438101932|ref|NC_070988.1| 2601630 g10551 i0 87.143 32.9746835443038 210 27 89 0 6 215 8080 7871 Shigella phage SGF2, complete genome blastn 7815 239 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Kuravirus Kuravirus SGF2
13036990 13036990 PRJNA1129273_P_NODE_7731_length_262_cov_1.629630_g7451_i0 PRJNA1129273 7731 262 1.62963 4.2696306 Suseptimavirus ECBP2 3052757 Viruses Viruses 425 1.22e-114   NTclustered gi|408905854|ref|NC_018859.1| 1604355 g7451 i0 96.154 10.9541984732824 260 10 99 0 2 261 57572 57313 Escherichia phage ECBP2, complete genome blastn 2870 425 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus ECBP2
14312201 14312201 PRJNA1129273_P_NODE_5752_length_294_cov_1.733032_g5472_i0 PRJNA1129273 5752 294 1.733032 5.09511408 Suseptimavirus ECBP2 3052757 Viruses Viruses 357 5.16e-94   NTclustered gi|408905854|ref|NC_018859.1| 1604355 g5472 i0 88.699 13.8979591836735 292 33 99 0 2 293 16385 16676 Escherichia phage ECBP2, complete genome blastn 4086 357 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus ECBP2
15586182 15586182 PRJNA1129273_P_NODE_4593_length_334_cov_1.467433_g4313_i0 PRJNA1129273 4593 334 1.467433 4.90122622 Hubei picorna-like virus 14 1923093 Viruses Viruses 217 1.06e-51   NTclustered gi|1132371418|ref|NC_033112.1| 1923093 g4313 i0 80.068 1.77245508982036 296 56 88 3 39 333 2806 3099 Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 592 217 1 Viruses               Hubei picorna-like virus 14
16860417 16860417 PRJNA1129273_P_NODE_11094_length_228_cov_3.870968_g10814_i0 PRJNA1129273 11094 228 3.870968 8.82580704 Escherichia phage JeanPiccard 2851955 Viruses Viruses 353 4.98e-93   NTclustered gi|2071744090|gb|MZ501080.1| 2851955 g10814 i0 94.714 60.6578947368421 227 12 99 0 1 227 12186 11960 Escherichia phage JeanPiccard strain Bas02, complete genome blastn 13830 353 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae   Escherichia phage JeanPiccard
17609348 17609348 PRJNA1129273_P_NODE_8054_length_258_cov_1.243243_g7774_i0 PRJNA1129273 8054 258 1.243243 3.20756694 Kuravirus 680277 Viruses Viruses 464 2.5499999999999994e-126   NTclustered gi|2131271452|gb|OK148440.1| 2875841 g7774 i0 99.222 11.9418604651163 257 2 99 0 2 258 54734 54478 Escherichia phage MLP3, complete genome blastn 3081 464 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Kuravirus Escherichia phage MLP3
19409181 19409181 PRJNA1129273_P_NODE_8596_length_251_cov_3.078652_g8316_i0 PRJNA1129273 8596 251 3.078652 7.72741652 Sopawad virus 3131649 Viruses Viruses 366 7.15e-97   NTclustered gi|2717323044|gb|PP173950.1| 3131649 g8316 i0 93.522 25.8446215139442 247 14 98 1 5 251 4090 4334 MAG: Sopawad virus isolate SP1A_k141_78953 genomic sequence blastn 6487 366 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Sopawad virus
20684663 20684663 PRJNA1129273_P_NODE_2237_length_527_cov_2.218062_g1961_i0 PRJNA1129273 2237 527 2.218062 11.68918674 Hubei picorna-like virus 14 1923093 Viruses Viruses 436 1.22e-117   NTclustered gi|1132371418|ref|NC_033112.1| 1923093 g1961 i0 83.913 1.74573055028463 460 70 87 4 69 526 3606 3149 Hubei picorna-like virus 14 strain QTM26191 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 920 436 1 Viruses               Hubei picorna-like virus 14
20684670 20684670 PRJNA1129273_P_NODE_4257_length_349_cov_1.105072_g3977_i0 PRJNA1129273 4257 349 1.105072 3.85670128 Suseptimavirus SU7 3060723 Viruses Viruses 616 9.32e-172   NTclustered gi|2438100929|ref|NC_070980.1| 2849626 g3977 i0 98.563 12.9713467048711 348 5 99 0 1 348 68235 68582 Escherichia phage vB_EcoP_SU7, complete genome blastn 4527 616 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus SU7
20684686 20684686 PRJNA1129273_P_NODE_6737_length_277_cov_0.867647_g6457_i0 PRJNA1129273 6737 277 0.867647 2.40338219 Nieuwekanaalvirus KBNP1711 3052361 Viruses Viruses 411 3.649999999999999e-110   NTclustered gi|589892323|ref|NC_023593.1| 1436889 g6457 i0 94.074 3.85559566787004 270 16 97 0 2 271 10994 10725 Escherichia phage KBNP1711, complete genome blastn 1068 411 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Nieuwekanaalvirus Nieuwekanaalvirus KBNP1711
24509214 24509214 PRJNA1129273_P_NODE_3640_length_383_cov_1.322581_g3360_i0 PRJNA1129273 3640 383 1.322581 5.06548523 Caudoviricetes sp. 2832643 Viruses Viruses 538 2.3e-148   NTclustered gi|2914851513|gb|OR221600.1| 2832643 g3360 i0 92.167 1 383 26 99 4 2 382 7070 6690 MAG: Caudoviricetes sp. isolate MSP1454 genomic sequence blastn 383 538 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24509215 24509215 PRJNA1129273_P_NODE_3780_length_374_cov_1.966777_g3500_i0 PRJNA1129273 3780 374 1.966777 7.35574598 Suseptimavirus ECBP2 3052757 Viruses Viruses 577 4.749999999999998e-160   NTclustered gi|408905854|ref|NC_018859.1| 1604355 g3500 i0 94.851 49.7754010695187 369 19 99 0 2 370 34649 35017 Escherichia phage ECBP2, complete genome blastn 18616 577 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mktvariviridae Suseptimavirus Suseptimavirus ECBP2

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