RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 35 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA682774 · 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
664682 664682 PRJNA682774_P_NODE_5221_length_243_cov_0.917647_g5192_i0 PRJNA682774 5221 243 0.917647 2.22988221 Bacteriophage sp. 38018 Viruses Viruses 449 6.65e-122   NTclustered gi|2293622934|gb|OP072902.1| 38018 g5192 i0 100 100 243 0 100 0 1 243 9967 10209 MAG: Bacteriophage sp. isolate 4295_84845, partial genome blastn 24300 449 1 Viruses               Bacteriophage sp.
1174701 1174701 PRJNA682774_P_NODE_3481_length_253_cov_0.866667_g3452_i0 PRJNA682774 3481 253 0.866667 2.19266751 Viruses 10239 Viruses Viruses 468 1.92e-127   NTclustered gi|2293619247|gb|OP072850.1| 38018 g3452 i0 100 7 253 0 100 0 1 253 61840 61588 MAG: Bacteriophage sp. isolate 4168_84109, partial genome blastn 1771 468 1 Viruses               Bacteriophage sp.
3215433 3215433 PRJNA682774_P_NODE_2723_length_280_cov_1.222222_g2694_i0 PRJNA682774 2723 280 1.222222 3.4222216 Exiguobacterium phage vB_EalM-132 2419623 Viruses Viruses 361 3.769999999999999e-95   NTclustered gi|1503528544|gb|MH884511.1| 2419623 g2694 i0 89.789 1.01428571428571 284 25 100 2 1 280 99648 99931 Exiguobacterium phage vB_EalM-132, complete genome blastn 284 361 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae   Exiguobacterium phage vB_EalM-132
3726518 3726518 PRJNA682774_P_NODE_1363_length_374_cov_1.478405_g1334_i0 PRJNA682774 1363 374 1.478405 5.5292347 Viruses 10239 Viruses Viruses 675 0   NTclustered gi|2059746340|tpg|BK027071.1| 38018 g1334 i0 99.198 32.951871657754 374 3 100 0 1 374 20017 20390 MAG TPA_asm: Bacteriophage sp. isolate ctlRX10, partial genome blastn 12324 675 1 Viruses               Bacteriophage sp.
4492605 4492605 PRJNA682774_P_NODE_4684_length_246_cov_0.901734_g4655_i0 PRJNA682774 4684 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 411 3.1799999999999995e-110   NTclustered gi|2052986268|tpg|BK030742.1| 2832643 g4655 i0 96.748 4 246 8 100 0 1 246 5664 5419 MAG TPA_asm: Caudoviricetes sp. isolate ctWpu13, partial genome blastn 984 411 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
5768260 5768260 PRJNA682774_P_NODE_1225_length_391_cov_1.437107_g1196_i0 PRJNA682774 1225 391 1.437107 5.61908837 Bacteriophage sp. 38018 Viruses Viruses 568 3e-157   NTclustered gi|2293619940|gb|OP072857.1| 38018 g1196 i0 93.077 59.7237851662404 390 24 99 3 4 391 22067 21679 MAG: Bacteriophage sp. isolate 4182_5948, partial genome blastn 23352 568 1 Viruses               Bacteriophage sp.
5768281 5768281 PRJNA682774_P_NODE_3345_length_255_cov_1.285714_g3316_i0 PRJNA682774 3345 255 1.285714 3.2785707 Caudoviricetes sp. 2832643 Viruses Viruses 414 2.56e-111   NTclustered gi|2054807617|tpg|BK050242.1| 2832643 g3316 i0 98.712 8.02745098039216 233 3 91 0 1 233 12489 12721 MAG TPA_asm: Caudoviricetes sp. isolate ct8eg13, partial genome blastn 2047 414 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
7552601 7552601 PRJNA682774_P_NODE_2186_length_306_cov_1.004292_g2157_i0 PRJNA682774 2186 306 1.004292 3.07313352 root 1 Root_unresolved Root_unresolved 555 1.7799999999999996e-153   NTclustered gi|2295300213|gb|OP075061.1| 38018 g2157 i0 99.346 17.9640522875817 306 2 100 0 1 306 43041 42736 MAG: Bacteriophage sp. isolate 2944_3426, partial genome blastn 5497 555 1 Viruses               Bacteriophage sp.
8317826 8317826 PRJNA682774_P_NODE_4807_length_245_cov_0.906977_g4778_i0 PRJNA682774 4807 245 0.906977 2.22209365 Caudoviricetes sp. 2832643 Viruses Viruses 193 1.25e-44   NTclustered gi|2053198840|tpg|BK016651.1| 2832643 g4778 i0 89.474 3.42040816326531 152 16 62 0 79 230 15680 15831 MAG TPA_asm: Caudoviricetes sp. isolate ctEFm9, partial genome blastn 838 193 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9593260 9593260 PRJNA682774_P_NODE_3448_length_253_cov_0.866667_g3419_i0 PRJNA682774 3448 253 0.866667 2.19266751 Caudoviricetes sp. 2832643 Viruses Viruses 429 9.079999999999999e-116   NTclustered gi|2056751438|tpg|BK045317.1| 2832643 g3419 i0 97.233 1 253 7 100 0 1 253 32119 31867 MAG TPA_asm: Caudoviricetes sp. isolate ct5tf5, partial genome blastn 253 429 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10103358 10103358 PRJNA682774_P_NODE_1788_length_334_cov_1.348659_g1759_i0 PRJNA682774 1788 334 1.348659 4.50452106 Carjivirus 2948652 Viruses Viruses 617 2.48e-172   NTclustered gi|2295393960|gb|OP076018.1| 38018 g1759 i0 100 100 334 0 100 0 1 334 45588 45255 MAG: Bacteriophage sp. isolate 4037_14187, complete genome blastn 33400 617 1 Viruses               Bacteriophage sp.
10103370 10103370 PRJNA682774_P_NODE_4728_length_246_cov_0.901734_g4699_i0 PRJNA682774 4728 246 0.901734 2.21826564 Carjivirus 2948652 Viruses Viruses 444 3.14e-120   NTclustered gi|2293599869|gb|OP072876.1| 38018 g4699 i0 99.187 99.4471544715447 246 2 100 0 1 246 91500 91255 MAG: Bacteriophage sp. isolate 4249_104662, complete genome blastn 24464 444 1 Viruses               Bacteriophage sp.
11378291 11378291 PRJNA682774_P_NODE_5469_length_242_cov_0.923077_g5440_i0 PRJNA682774 5469 242 0.923077 2.23384634 Viruses 10239 Viruses Viruses 359 1.15e-94   NTclustered gi|2293634526|gb|OP073432.1| 38018 g5440 i0 93.443 13.7933884297521 244 12 100 4 1 242 48933 48692 MAG: Bacteriophage sp. isolate 0750_76133, partial genome blastn 3338 359 1 Viruses               Bacteriophage sp.
12144045 12144045 PRJNA682774_P_NODE_4890_length_245_cov_0.906977_g4861_i0 PRJNA682774 4890 245 0.906977 2.22209365 Bacteriophage sp. 38018 Viruses Viruses 453 5.1900000000000006e-123   NTclustered gi|2293618551|gb|OP072840.1| 38018 g4861 i0 100 99.8367346938775 245 0 100 0 1 245 97063 96819 MAG: Bacteriophage sp. isolate 4078_53722, partial genome blastn 24460 453 1 Viruses               Bacteriophage sp.
13418639 13418639 PRJNA682774_P_NODE_4611_length_246_cov_0.901734_g4582_i0 PRJNA682774 4611 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 455 1.4500000000000002e-123   NTclustered gi|2054713487|tpg|BK053275.1| 2832643 g4582 i0 100 2 246 0 100 0 1 246 28932 29177 MAG TPA_asm: Caudoviricetes sp. isolate ctKhp19, partial genome blastn 492 455 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
13418644 13418644 PRJNA682774_P_NODE_4791_length_245_cov_0.906977_g4762_i0 PRJNA682774 4791 245 0.906977 2.22209365 Bacteriophage sp. 38018 Viruses Viruses 448 2.41e-121   NTclustered gi|2289938487|gb|OP030732.1| 38018 g4762 i0 99.592 14.1061224489796 245 1 100 0 1 245 4175 4419 MAG: Bacteriophage sp. isolate 0029_61813, partial genome blastn 3456 448 1 Viruses               Bacteriophage sp.
14693622 14693622 PRJNA682774_P_NODE_4692_length_246_cov_0.901734_g4663_i0 PRJNA682774 4692 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 449 6.74e-122   NTclustered gi|2057146005|tpg|BK058407.1| 2832643 g4663 i0 99.593 5 246 1 100 0 1 246 44057 43812 MAG TPA_asm: Caudoviricetes sp. isolate ctQel4, partial genome blastn 1230 449 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14693624 14693624 PRJNA682774_P_NODE_4832_length_245_cov_0.906977_g4803_i0 PRJNA682774 4832 245 0.906977 2.22209365 Myoviridae sp. ctHMa1 2827671 Viruses Viruses 409 1.1399999999999998e-109   NTclustered gi|2052868790|tpg|BK032590.1| 2827671 g4803 i0 96.735 1 245 8 100 0 1 245 19760 19516 MAG TPA_asm: Myoviridae sp. ctHMa1, partial genome blastn 245 409 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae sp. ctHMa1
15967391 15967391 PRJNA682774_P_NODE_4993_length_244_cov_0.912281_g4964_i0 PRJNA682774 4993 244 0.912281 2.22596564 Caudoviricetes sp. 2832643 Viruses Viruses 451 1.86e-122   NTclustered gi|2056747663|tpg|BK045242.1| 2832643 g4964 i0 100 4.88934426229508 244 0 100 0 1 244 1794 2037 MAG TPA_asm: Caudoviricetes sp. isolate ct3yG8, partial genome blastn 1193 451 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17242569 17242569 PRJNA682774_P_NODE_2234_length_303_cov_1.426087_g2205_i0 PRJNA682774 2234 303 1.426087 4.32104361 Caudoviricetes sp. 2832643 Viruses Viruses 560 3.79e-155   NTclustered gi|2054455656|tpg|BK031417.1| 2832643 g2205 i0 100 2 303 0 100 0 1 303 22221 22523 MAG TPA_asm: Caudoviricetes sp. isolate ctIcV26, partial genome blastn 606 560 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17242600 17242600 PRJNA682774_P_NODE_4454_length_247_cov_0.896552_g4425_i0 PRJNA682774 4454 247 0.896552 2.21448344 Bacteriophage sp. 38018 Viruses Viruses 451 1.88e-122   NTclustered gi|2294896982|gb|OP076197.1| 38018 g4425 i0 99.595 22.6558704453441 247 1 100 0 1 247 2855 3101 MAG: Bacteriophage sp. isolate 4279_101181, partial genome blastn 5596 451 1 Viruses               Bacteriophage sp.
17242606 17242606 PRJNA682774_P_NODE_4714_length_246_cov_0.901734_g4685_i0 PRJNA682774 4714 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 449 6.74e-122   NTclustered gi|2059595670|tpg|BK036982.1| 2832643 g4685 i0 99.593 1 246 1 100 0 1 246 159228 159473 MAG TPA_asm: Caudoviricetes sp. isolate ctu5P3, partial genome blastn 246 449 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
17242611 17242611 PRJNA682774_P_NODE_5014_length_244_cov_0.912281_g4985_i0 PRJNA682774 5014 244 0.912281 2.22596564 Bacteriophage sp. 38018 Viruses Viruses 429 8.699999999999998e-116   NTclustered gi|2294111392|gb|OP073770.1| 38018 g4985 i0 98.361 10.9508196721311 244 4 100 0 1 244 10674 10917 MAG: Bacteriophage sp. isolate 1234_1583, complete genome blastn 2672 429 1 Viruses               Bacteriophage sp.
18516771 18516771 PRJNA682774_P_NODE_5375_length_242_cov_0.923077_g5346_i0 PRJNA682774 5375 242 0.923077 2.23384634 Caudoviricetes sp. 2832643 Viruses Viruses 425 1.11e-114   NTclustered gi|2056831809|tpg|BK043950.1| 2832643 g5346 i0 98.347 14.0867768595041 242 4 100 0 1 242 29504 29263 MAG TPA_asm: Caudoviricetes sp. isolate ctjQy2, partial genome blastn 3409 425 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
19026454 19026454 PRJNA682774_P_NODE_5175_length_243_cov_0.917647_g5146_i0 PRJNA682774 5175 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 433 6.69e-117   NTclustered gi|2294906814|gb|OP076387.1| 38018 g5146 i0 98.765 2.96296296296296 243 3 100 0 1 243 41359 41601 MAG: Bacteriophage sp. isolate 1979_37048, partial genome blastn 720 433 1 Viruses               Bacteriophage sp.
19026456 19026456 PRJNA682774_P_NODE_5475_length_242_cov_0.923077_g5446_i0 PRJNA682774 5475 242 0.923077 2.23384634 Viruses 10239 Viruses Viruses 442 1.1099999999999995e-119   NTclustered gi|2289944612|gb|OP030813.1| 38018 g5446 i0 99.587 100 242 1 100 0 1 242 15079 14838 MAG: Bacteriophage sp. isolate 0654_72482, partial genome blastn 24200 442 1 Viruses               Bacteriophage sp.
19791588 19791588 PRJNA682774_P_NODE_3596_length_252_cov_0.871508_g3567_i0 PRJNA682774 3596 252 0.871508 2.19620016 Bacteriophage sp. 38018 Viruses Viruses 466 6.89e-127   NTclustered gi|2293648626|gb|OP073698.1| 38018 g3567 i0 100 50.1904761904762 252 0 100 0 1 252 16308 16057 MAG: Bacteriophage sp. isolate 1125_100070, partial genome blastn 12648 466 1 Viruses               Bacteriophage sp.
21067131 21067131 PRJNA682774_P_NODE_5217_length_243_cov_0.917647_g5188_i0 PRJNA682774 5217 243 0.917647 2.22988221 Caudoviricetes sp. 2832643 Viruses Viruses 449 6.65e-122   NTclustered gi|2054548281|tpg|BK047993.1| 2832643 g5188 i0 100 7.20987654320988 243 0 100 0 1 243 22097 22339 MAG TPA_asm: Caudoviricetes sp. isolate ctYDy2, partial genome blastn 1752 449 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21576890 21576890 PRJNA682774_P_NODE_1577_length_351_cov_1.122302_g1548_i0 PRJNA682774 1577 351 1.122302 3.93928002 Viruses 10239 Viruses Viruses 643 4.3e-180   NTclustered gi|2295290043|gb|OP074941.1| 38018 g1548 i0 99.715 58.7407407407407 351 1 100 0 1 351 16332 16682 MAG: Bacteriophage sp. isolate 2832_29229, partial genome blastn 20618 643 1 Viruses               Bacteriophage sp.
22852145 22852145 PRJNA682774_P_NODE_1198_length_396_cov_0.965944_g1169_i0 PRJNA682774 1198 396 0.965944 3.82513824 root 1 Root_unresolved Root_unresolved 721 0   NTclustered gi|2295420087|gb|OP075984.1| 38018 g1169 i0 99.495 17.020202020202 396 2 100 0 1 396 28645 29040 MAG: Bacteriophage sp. isolate 3998_43183, partial genome blastn 6740 721 1 Viruses               Bacteriophage sp.
24890784 24890784 PRJNA682774_P_NODE_2260_length_302_cov_1.305677_g2231_i0 PRJNA682774 2260 302 1.305677 3.94314454 Caudoviricetes sp. 2832643 Viruses Viruses 553 6.32e-153   NTclustered gi|2053077518|tpg|BK020018.1| 2832643 g2231 i0 99.669 19.0033112582781 302 1 100 0 1 302 655 354 MAG TPA_asm: Caudoviricetes sp. isolate ctDlT5, partial genome blastn 5739 553 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
24890791 24890791 PRJNA682774_P_NODE_2780_length_278_cov_1.180488_g2751_i0 PRJNA682774 2780 278 1.180488 3.28175664 Bacteriophage sp. 38018 Viruses Viruses 514 2.7199999999999996e-141   NTclustered gi|2295215745|gb|OP074354.1| 38018 g2751 i0 100 100 278 0 100 0 1 278 32148 31871 MAG: Bacteriophage sp. isolate 2136_61046, partial genome blastn 27800 514 1 Viruses               Bacteriophage sp.
24890799 24890799 PRJNA682774_P_NODE_3240_length_259_cov_1.161290_g3211_i0 PRJNA682774 3240 259 1.16129 3.0077411 Bacteriophage sp. 38018 Viruses Viruses 298 2.74e-76   NTclustered gi|2295314767|gb|OP075327.1| 38018 g3211 i0 87.549 0.992277992277992 257 32 99 0 3 259 2748 2492 MAG: Bacteriophage sp. isolate 3243_33813, partial genome blastn 257 298 1 Viruses               Bacteriophage sp.
25401207 25401207 PRJNA682774_P_NODE_3780_length_251_cov_0.876404_g3751_i0 PRJNA682774 3780 251 0.876404 2.19977404 Viruses 10239 Viruses Viruses 464 2.47e-126   NTclustered gi|2293619247|gb|OP072850.1| 38018 g3751 i0 100 19.7370517928287 251 0 100 0 1 251 49784 49534 MAG: Bacteriophage sp. isolate 4168_84109, partial genome blastn 4954 464 1 Viruses               Bacteriophage sp.
25401216 25401216 PRJNA682774_P_NODE_4440_length_247_cov_0.896552_g4411_i0 PRJNA682774 4440 247 0.896552 2.21448344 root 1 Root_unresolved Root_unresolved 457 4.05e-124   NTclustered gi|2295249468|gb|OP074639.1| 38018 g4411 i0 100 14.6599190283401 247 0 100 0 1 247 50499 50253 MAG: Bacteriophage sp. isolate 2491_66952, partial genome blastn 3621 457 1 Viruses               Bacteriophage sp.

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