RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 35 ✖

bioproject 1

  • PRJNA1002570 · 35 ✖

analysis 1

  • blastn · 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
1000828 1000828 PRJNA1002570_P_NODE_841_length_1881_cov_3.792035_g707_i0 PRJNA1002570 841 1881 3.792035 71.32817835 Christensenvirus 2732061 Viruses Viruses 3378 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g707 i0 99.837 18.4827219564062 1839 2 100 1 44 1881 9479 11317 Escherichia phage TR2, complete genome blastn 34766 3378 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
1426910 1426910 PRJNA1002570_P_NODE_1882_length_809_cov_2.434783_g1705_i0 PRJNA1002570 1882 809 2.434783 19.69739447 Escherichia phage TR2 2978981 Viruses Viruses 1489 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g1705 i0 99.876 7.67985166872682 809 1 100 0 1 809 23650 22842 Escherichia phage TR2, complete genome blastn 6213 1489 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
1427356 1427356 PRJNA1002570_P_NODE_45362_length_231_cov_2.689873_g45167_i0 PRJNA1002570 45362 231 2.689873 6.21360663 Caudoviricetes sp. 2832643 Viruses Viruses 342 1.0899999999999997e-89   NTclustered gi|2056949657|tpg|BK022664.1| 2832643 g45167 i0 96.172 39.8744588744589 209 8 90 0 1 209 17534 17326 MAG TPA_asm: Caudoviricetes sp. isolate ct1lS4, partial genome blastn 9211 342 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3551417 3551417 PRJNA1002570_P_NODE_663_length_2740_cov_3.060367_g542_i0 PRJNA1002570 663 2740 3.060367 83.8540558 Christensenvirus 2732061 Viruses Viruses 5044 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g542 i0 99.891 19.6729927007299 2740 3 100 0 1 2740 33774 36513 Escherichia phage TR2, complete genome blastn 53904 5044 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
4828598 4828598 PRJNA1002570_P_NODE_1204_length_1134_cov_3.103676_g1050_i0 PRJNA1002570 1204 1134 3.103676 35.19568584 Christensenvirus 2732061 Viruses Viruses 2089 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g1050 i0 99.912 7.39329805996473 1134 1 100 0 1 1134 29610 30743 Escherichia phage TR2, complete genome blastn 8384 2089 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
4828667 4828667 PRJNA1002570_P_NODE_23324_length_283_cov_1.880952_g23129_i0 PRJNA1002570 23324 283 1.880952 5.32309416 Viruses 10239 Viruses Viruses 507 4.64e-139   NTclustered gi|2914749608|gb|OR221231.1| 2832643 g23129 i0 98.94 7.34628975265018 283 3 100 0 1 283 31523 31241 MAG: Caudoviricetes sp. isolate MSP1880 genomic sequence blastn 2079 507 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5255401 5255401 PRJNA1002570_P_NODE_39325_length_247_cov_0.885057_g39130_i0 PRJNA1002570 39325 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 401 1.9199999999999992e-107   NTclustered gi|2057986153|tpg|BK046851.1| 2832643 g39130 i0 95.951 42.412955465587 247 10 100 0 1 247 33500 33746 MAG TPA_asm: Caudoviricetes sp. isolate ctbP211, partial genome blastn 10476 401 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6103733 6103733 PRJNA1002570_P_NODE_1325_length_1042_cov_2.476780_g1166_i0 PRJNA1002570 1325 1042 2.47678 25.8080476 Christensenvirus 2732061 Viruses Viruses 1925 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g1166 i0 100 13.2792706333973 1042 0 100 0 1 1042 37579 36538 Escherichia phage TR2, complete genome blastn 13837 1925 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
6104018 6104018 PRJNA1002570_P_NODE_925_length_1558_cov_3.157576_g786_i0 PRJNA1002570 925 1558 3.157576 49.19503408 Christensenvirus 2732061 Viruses Viruses 2867 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g786 i0 99.872 15.4287548138639 1558 2 100 0 1 1558 5027 3470 Escherichia phage TR2, complete genome blastn 24038 2867 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
6530536 6530536 PRJNA1002570_P_NODE_29626_length_268_cov_2.015385_g29431_i0 PRJNA1002570 29626 268 2.015385 5.4012318 Caudoviricetes sp. 2832643 Viruses Viruses 311 3.6699999999999996e-80   NTclustered gi|2058073035|tpg|BK042980.1| 2832643 g29431 i0 89.712 4.74253731343284 243 25 91 0 1 243 2805 2563 MAG TPA_asm: Caudoviricetes sp. isolate ctjPb1, partial genome blastn 1271 311 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
6530822 6530822 PRJNA1002570_P_NODE_546_length_3489_cov_3.343091_g442_i0 PRJNA1002570 546 3489 3.343091 116.64044499 Escherichia phage TR2 2978981 Viruses Viruses 6421 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g442 i0 99.885 93.4820865577529 3489 4 100 0 1 3489 26004 29492 Escherichia phage TR2, complete genome blastn 326159 6421 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
7804599 7804599 PRJNA1002570_P_NODE_1127_length_1205_cov_3.109541_g977_i0 PRJNA1002570 1127 1205 3.109541 37.46996905 Escherichia phage TR2 2978981 Viruses Viruses 2207 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g977 i0 99.751 37.7244813278008 1205 2 100 1 1 1205 17834 19037 Escherichia phage TR2, complete genome blastn 45458 2207 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
7804911 7804911 PRJNA1002570_P_NODE_30247_length_266_cov_4.150259_g30052_i0 PRJNA1002570 30247 266 4.150259 11.03968894 Caudoviricetes sp. 2832643 Viruses Viruses 209 1.36e-49   NTclustered gi|2914921323|gb|OR221391.1| 2832643 g30052 i0 92.466 2.70676691729323 146 11 55 0 121 266 39905 39760 MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence blastn 720 209 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9079945 9079945 PRJNA1002570_P_NODE_36128_length_251_cov_0.865169_g35933_i0 PRJNA1002570 36128 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 464 2.47e-126   NTclustered gi|2058123527|tpg|BK033972.1| 2832643 g35933 i0 100 1 251 0 100 0 1 251 15296 15546 MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome blastn 251 464 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9080184 9080184 PRJNA1002570_P_NODE_868_length_1770_cov_2.783736_g732_i0 PRJNA1002570 868 1770 2.783736 49.2721272 Escherichia phage TR2 2978981 Viruses Viruses 3253 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g732 i0 99.831 9.6774011299435 1770 3 100 0 1 1770 21084 19315 Escherichia phage TR2, complete genome blastn 17129 3253 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
9928822 9928822 PRJNA1002570_P_NODE_608_length_3098_cov_3.597686_g492_i0 PRJNA1002570 608 3098 3.597686 111.45631228 Christensenvirus 2732061 Viruses Viruses 5683 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g492 i0 99.774 53.0577792123951 3098 7 100 0 1 3098 38616 41713 Escherichia phage TR2, complete genome blastn 164373 5705 0.996143733567046 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
9928841 9928841 PRJNA1002570_P_NODE_768_length_2177_cov_3.451521_g642_i0 PRJNA1002570 768 2177 3.451521 75.13961217 Christensenvirus 2732061 Viruses Viruses 4004 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g642 i0 99.862 48.9182361047313 2177 3 100 0 1 2177 8560 6384 Escherichia phage TR2, complete genome blastn 106495 4004 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
10355714 10355714 PRJNA1002570_P_NODE_39249_length_247_cov_0.885057_g39054_i0 PRJNA1002570 39249 247 0.885057 2.18609079 Caudoviricetes sp. 2832643 Viruses Viruses 457 4.05e-124   NTclustered gi|2914941530|gb|OR221752.1| 2832643 g39054 i0 100 1 247 0 100 0 1 247 44110 44356 MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence blastn 247 457 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11203877 11203877 PRJNA1002570_P_NODE_1109_length_1236_cov_2.823732_g959_i0 PRJNA1002570 1109 1236 2.823732 34.90132752 Christensenvirus 2732061 Viruses Viruses 2255 0   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g959 i0 99.595 71.3608414239482 1236 5 100 0 1 1236 6417 5182 Escherichia phage TR1, complete genome blastn 88202 2272 0.992517605633803 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
11204141 11204141 PRJNA1002570_P_NODE_669_length_2710_cov_3.470611_g548_i0 PRJNA1002570 669 2710 3.470611 94.0535581 Christensenvirus 2732061 Viruses Viruses 5000 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g548 i0 99.963 24.0594095940959 2710 1 100 0 1 2710 33818 31109 Escherichia phage TR2, complete genome blastn 65201 5005 0.999000999000999 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
12479509 12479509 PRJNA1002570_P_NODE_250_length_6681_cov_3.730630_g198_i0 PRJNA1002570 250 6681 3.73063 249.2433903 Christensenvirus 2732061 Viruses Viruses 12277 0   NTclustered gi|2449455461|gb|OQ357823.1| 3069117 g198 i0 99.835 30.0634635533603 6681 11 100 0 1 6681 23043 29723 Escherichia phage CY1_Cui-2023, complete genome blastn 200854 12321 0.996428861293726 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage CY1_Cui-2023
12479629 12479629 PRJNA1002570_P_NODE_43310_length_242_cov_0.911243_g43115_i0 PRJNA1002570 43310 242 0.911243 2.20520806 Potyvirus 12195 Viruses Viruses 442 1.1099999999999995e-119   NTclustered gi|2862287743|gb|PQ536902.1| 12196 g43115 i0 99.587 99.9917355371901 242 1 100 0 1 242 9169 8928 Bean common mosaic virus isolate Gimge1 polyprotein gene, partial cds blastn 24198 442 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus phaseovulgaris
15454934 15454934 PRJNA1002570_P_NODE_24233_length_281_cov_1.697115_g24038_i0 PRJNA1002570 24233 281 1.697115 4.76889315 Caudoviricetes sp. 2832643 Viruses Viruses 486 5.989999999999999e-133   NTclustered gi|2915049885|gb|OR222835.1| 2832643 g24038 i0 97.865 88.3451957295374 281 6 100 0 1 281 1155 1435 MAG: Caudoviricetes sp. isolate MSP0519 genomic sequence blastn 24825 486 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17578589 17578589 PRJNA1002570_P_NODE_3834_length_549_cov_4.247899_g3642_i0 PRJNA1002570 3834 549 4.247899 23.32096551 Christensenvirus 2732061 Viruses Viruses 1014 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g3642 i0 100 3 549 0 100 0 1 549 17258 17806 Escherichia phage TR2, complete genome blastn 1647 1014 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
18852447 18852447 PRJNA1002570_P_NODE_375_length_5122_cov_3.492177_g299_i0 PRJNA1002570 375 5122 3.492177 178.86930594 Christensenvirus 2732061 Viruses Viruses 7038 0   NTclustered gi|2449455461|gb|OQ357823.1| 3069117 g299 i0 99.714 57.9468957438501 3844 11 99 0 1279 5122 11127 14970 Escherichia phage CY1_Cui-2023, complete genome blastn 296804 7055 0.997590361445783 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage CY1_Cui-2023
19277989 19277989 PRJNA1002570_P_NODE_31916_length_262_cov_1.629630_g31721_i0 PRJNA1002570 31916 262 1.62963 4.2696306 Shenzhenvirus AhSzq1 2733998 Viruses Viruses 318 2.1299999999999995e-82   NTclustered gi|1842012929|ref|NC_047949.1| 2138298 g31721 i0 88.593 2.00763358778626 263 28 100 2 1 262 98538 98799 Aeromonas phage AhSzq-1, partial genome blastn 526 318 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Shenzhenvirus Shenzhenvirus AhSzq1
20127258 20127258 PRJNA1002570_P_NODE_5216_length_476_cov_3.086849_g5022_i0 PRJNA1002570 5216 476 3.086849 14.69340124 Christensenvirus 2732061 Viruses Viruses 880 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g5022 i0 100 2 476 0 100 0 1 476 24725 24250 Escherichia phage TR2, complete genome blastn 952 880 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
21402825 21402825 PRJNA1002570_P_NODE_30697_length_265_cov_2.406250_g30502_i0 PRJNA1002570 30697 265 2.40625 6.3765625 Christensenvirus 2732061 Viruses Viruses 490 4.3299999999999986e-134   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g30502 i0 100 5 265 0 100 0 1 265 9311 9575 Escherichia phage TR1, complete genome blastn 1325 490 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
21402831 21402831 PRJNA1002570_P_NODE_3137_length_604_cov_2.783427_g2947_i0 PRJNA1002570 3137 604 2.783427 16.81189908 Christensenvirus 2732061 Viruses Viruses 1116 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g2947 i0 100 4.03973509933775 604 0 100 0 1 604 23615 24218 Escherichia phage TR2, complete genome blastn 2440 1116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
22677433 22677433 PRJNA1002570_P_NODE_1058_length_1302_cov_4.930838_g913_i0 PRJNA1002570 1058 1302 4.930838 64.19951076 Christensenvirus 2732061 Viruses Viruses 2405 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g913 i0 100 23.6513056835637 1302 0 100 0 1 1302 26021 24720 Escherichia phage TR2, complete genome blastn 30794 2405 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
23104932 23104932 PRJNA1002570_P_NODE_979_length_1443_cov_3.539416_g838_i0 PRJNA1002570 979 1443 3.539416 51.07377288 Escherichia phage TR2 2978981 Viruses Viruses 2654 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g838 i0 99.861 23.035343035343 1443 2 100 0 1 1443 22763 21321 Escherichia phage TR2, complete genome blastn 33240 2654 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
23952962 23952962 PRJNA1002570_P_NODE_1399_length_995_cov_2.675705_g1236_i0 PRJNA1002570 1399 995 2.6757049999999998 26.62326475 Christensenvirus 2732061 Viruses Viruses 1827 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g1236 i0 99.799 4.57386934673367 995 2 100 0 1 995 38568 37574 Escherichia phage TR2, complete genome blastn 4551 1832 0.997270742358079 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
23953239 23953239 PRJNA1002570_P_NODE_9439_length_376_cov_4.597360_g9244_i0 PRJNA1002570 9439 376 4.59736 17.2860736 Christensenvirus 2732061 Viruses Viruses 695 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g9244 i0 100 5.98936170212766 376 0 100 0 1 376 31130 30755 Escherichia phage TR2, complete genome blastn 2252 695 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
24378343 24378343 PRJNA1002570_P_NODE_300_length_5905_cov_5.053841_g238_i0 PRJNA1002570 300 5905 5.053841 298.42931105 Maltschvirus maltsch 2956182 Viruses Viruses 809 0   NTclustered gi|1862931570|emb|LR798200.1| 2100421 g238 i0 76.949 5.42794242167655 1488 289 25 39 2048 3508 39293 40753 uncultured Caudovirales phage genome assembly blastn 32052 809 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
25227023 25227023 PRJNA1002570_P_NODE_6640_length_432_cov_1.919220_g6446_i0 PRJNA1002570 6640 432 1.91922 8.2910304 Christensenvirus 2732061 Viruses Viruses 798 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g6446 i0 100 6.99537037037037 432 0 100 0 1 432 9015 8584 Escherichia phage TR2, complete genome blastn 3022 798 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2

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