contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax_kingdom = "Heunggongvirae"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 798017 | 798017 | PRJNA800090_P_NODE_176061_length_234_cov_1.745455_g173876_i0 | PRJNA800090 | 176061 | 234 | 1.745455 | 4.0843647 | Moovirus moo | 3060392 | Viruses | Viruses | 333 | 6.679999999999999e-87 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g173876 | i0 | 92.308 | 1 | 234 | 18 | 100 | 0 | 1 | 234 | 49628 | 49861 | Shigella virus Moo19, complete genome | blastn | 234 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 2072909 | 2072909 | PRJNA800090_P_NODE_137402_length_269_cov_1.380000_g135217_i0 | PRJNA800090 | 137402 | 269 | 1.38 | 3.7122 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 364 | 2.7899999999999998e-96 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g135217 | i0 | 91.078 | 1 | 269 | 24 | 100 | 0 | 1 | 269 | 1401 | 1133 | Hafnia phage TS33, complete genome | blastn | 269 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 2076374 | 2076374 | PRJNA800090_S_NODE_20862_length_274_cov_0.804878_g20750_i0 | PRJNA800090 | 20862 | 274 | 0.804878 | 2.20536572 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 292 | 1.3599999999999999e-74 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g20750 | i0 | 89.27 | 0.85036496350365 | 233 | 25 | 85 | 0 | 40 | 272 | 10859 | 10627 | Hafnia phage TS33, complete genome | blastn | 233 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 3350252 | 3350252 | PRJNA800090_P_NODE_53883_length_483_cov_1.057971_g51699_i0 | PRJNA800090 | 53883 | 483 | 1.057971 | 5.10999993 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 887 | 0 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g51699 | i0 | 99.793 | 66.703933747412 | 483 | 1 | 100 | 0 | 1 | 483 | 22742 | 23224 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 32218 | 887 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 4626362 | 4626362 | PRJNA800090_P_NODE_172144_length_236_cov_1.724551_g169959_i0 | PRJNA800090 | 172144 | 236 | 1.724551 | 4.06994036 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 211 | 3.3e-50 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g169959 | i0 | 85.024 | 0.877118644067797 | 207 | 31 | 88 | 0 | 3 | 209 | 36111 | 36317 | Hafnia phage TS33, complete genome | blastn | 207 | 211 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 4626452 | 4626452 | PRJNA800090_P_NODE_176004_length_234_cov_1.745455_g173819_i0 | PRJNA800090 | 176004 | 234 | 1.745455 | 4.0843647 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 394 | 3.02e-105 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g173819 | i0 | 97.009 | 2.97008547008547 | 234 | 7 | 100 | 0 | 1 | 234 | 5232 | 4999 | Hafnia phage TS33, complete genome | blastn | 695 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 4628372 | 4628372 | PRJNA800090_P_NODE_87404_length_354_cov_1.515789_g85219_i0 | PRJNA800090 | 87404 | 354 | 1.515789 | 5.36589306 | Moovirus moo | 3060392 | Viruses | Viruses | 499 | 9.95e-137 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g85219 | i0 | 92.09 | 57.5932203389831 | 354 | 28 | 100 | 0 | 1 | 354 | 39275 | 38922 | Shigella virus Moo19, complete genome | blastn | 20388 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 5900155 | 5900155 | PRJNA800090_P_NODE_113245_length_302_cov_2.472103_g111060_i0 | PRJNA800090 | 113245 | 302 | 2.472103 | 7.46575106 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 267 | 9.22e-67 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g111060 | i0 | 95.758 | 1.10264900662252 | 165 | 7 | 55 | 0 | 1 | 165 | 20685 | 20521 | Hafnia phage TS33, complete genome | blastn | 333 | 267 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 5900603 | 5900603 | PRJNA800090_P_NODE_132945_length_274_cov_1.404878_g130760_i0 | PRJNA800090 | 132945 | 274 | 1.404878 | 3.84936572 | Moovirus moo | 3060392 | Viruses | Viruses | 368 | 2.1999999999999996e-97 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g130760 | i0 | 90.876 | 34.3978102189781 | 274 | 25 | 100 | 0 | 1 | 274 | 51449 | 51176 | Shigella virus Moo19, complete genome | blastn | 9425 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 7174668 | 7174668 | PRJNA800090_P_NODE_101466_length_323_cov_1.700787_g99281_i0 | PRJNA800090 | 101466 | 323 | 1.700787 | 5.49354201 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 409 | 1.56e-109 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g99281 | i0 | 89.474 | 1 | 323 | 34 | 100 | 0 | 1 | 323 | 10466 | 10144 | Hafnia phage TS33, complete genome | blastn | 323 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 8873175 | 8873175 | PRJNA800090_P_NODE_112527_length_304_cov_0.829787_g110342_i0 | PRJNA800090 | 112527 | 304 | 0.829787 | 2.52255248 | Christensenvirus | 2732061 | Viruses | Viruses | 562 | 1.06e-155 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g110342 | i0 | 100 | 50.4967105263158 | 304 | 0 | 100 | 0 | 1 | 304 | 276 | 579 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 15351 | 562 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 12276966 | 12276966 | PRJNA800090_P_NODE_152870_length_253_cov_1.983696_g150685_i0 | PRJNA800090 | 152870 | 253 | 1.983696 | 5.01875088 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 462 | 8.95e-126 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g150685 | i0 | 99.605 | 3.15810276679842 | 253 | 1 | 100 | 0 | 1 | 253 | 16826 | 17078 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 799 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 12277007 | 12277007 | PRJNA800090_P_NODE_154450_length_252_cov_1.196721_g152265_i0 | PRJNA800090 | 154450 | 252 | 1.196721 | 3.01573692 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g152265 | i0 | 100 | 1 | 252 | 0 | 100 | 0 | 1 | 252 | 16095 | 16346 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 252 | 466 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 12699874 | 12699874 | PRJNA800090_P_NODE_145390_length_260_cov_3.418848_g143205_i0 | PRJNA800090 | 145390 | 260 | 3.418848 | 8.8890048 | Phapecoctavirus | 2733124 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|2330525092|dbj|LC739533.1| | 2992780 | g143205 | i0 | 96.875 | 0.738461538461539 | 32 | 0 | 12 | 1 | 24 | 55 | 118433 | 118403 | Escherichia phage phiWec179 DNA, complete genome | blastn | 192 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phapecoctavirus | Escherichia phage phiWec179 | ||||
| 13551306 | 13551306 | PRJNA800090_P_NODE_161771_length_245_cov_1.636364_g159586_i0 | PRJNA800090 | 161771 | 245 | 1.636364 | 4.0090918 | Moovirus moo | 3060392 | Viruses | Viruses | 409 | 1.1399999999999998e-109 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g159586 | i0 | 96.735 | 35.5510204081633 | 245 | 8 | 100 | 0 | 1 | 245 | 56395 | 56639 | Shigella virus Moo19, complete genome | blastn | 8710 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 16099523 | 16099523 | PRJNA800090_P_NODE_131253_length_276_cov_1.739130_g129068_i0 | PRJNA800090 | 131253 | 276 | 1.73913 | 4.7999988 | Escherichia phage TR1 | 2972435 | Viruses | Viruses | 494 | 3.51e-135 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g129068 | i0 | 98.913 | 63.5 | 276 | 3 | 100 | 0 | 1 | 276 | 25655 | 25380 | Escherichia phage TR1, complete genome | blastn | 17526 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 | |||
| 16102125 | 16102125 | PRJNA800090_P_NODE_70333_length_406_cov_2.955490_g68148_i0 | PRJNA800090 | 70333 | 406 | 2.95549 | 11.9992894 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g68148 | i0 | 96.305 | 1 | 406 | 15 | 100 | 0 | 1 | 406 | 12921 | 13326 | Hafnia phage TS33, complete genome | blastn | 406 | 667 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 17376352 | 17376352 | PRJNA800090_P_NODE_172554_length_236_cov_1.125749_g170369_i0 | PRJNA800090 | 172554 | 236 | 1.1257490000000001 | 2.65676764 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 353 | 5.18e-93 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g170369 | i0 | 93.644 | 1 | 236 | 15 | 100 | 0 | 1 | 236 | 17323 | 17558 | Hafnia phage TS33, complete genome | blastn | 236 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 18649049 | 18649049 | PRJNA800090_P_NODE_155475_length_251_cov_1.203297_g153290_i0 | PRJNA800090 | 155475 | 251 | 1.203297 | 3.02027547 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g153290 | i0 | 99.602 | 2 | 251 | 1 | 100 | 0 | 1 | 251 | 27625 | 27875 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 502 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 19924019 | 19924019 | PRJNA800090_P_NODE_141176_length_265_cov_1.469388_g138991_i0 | PRJNA800090 | 141176 | 265 | 1.469388 | 3.8938782 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 361 | 3.539999999999999e-95 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g138991 | i0 | 93.75 | 0.905660377358491 | 240 | 15 | 91 | 0 | 1 | 240 | 11746 | 11507 | Hafnia phage TS33, complete genome | blastn | 240 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 19926780 | 19926780 | PRJNA800090_P_NODE_84876_length_360_cov_2.529210_g82691_i0 | PRJNA800090 | 84876 | 360 | 2.52921 | 9.105156 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 255 | 2.42e-63 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g82691 | i0 | 97.333 | 0.416666666666667 | 150 | 4 | 42 | 0 | 1 | 150 | 12288 | 12139 | Hafnia phage TS33, complete genome | blastn | 150 | 255 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 22473844 | 22473844 | PRJNA800090_P_NODE_120138_length_292_cov_0.968610_g117953_i0 | PRJNA800090 | 120138 | 292 | 0.96861 | 2.8283412 | Moovirus moo | 3060392 | Viruses | Viruses | 407 | 5.009999999999999e-109 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g117953 | i0 | 92.123 | 13.1952054794521 | 292 | 17 | 100 | 1 | 1 | 292 | 43742 | 44027 | Shigella virus Moo19, complete genome | blastn | 3853 | 407 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 22474317 | 22474317 | PRJNA800090_P_NODE_139438_length_267_cov_1.106061_g137253_i0 | PRJNA800090 | 139438 | 267 | 1.106061 | 2.95318287 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 488 | 1.5699999999999998e-133 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g137253 | i0 | 99.625 | 3.72659176029963 | 267 | 1 | 100 | 0 | 1 | 267 | 4808 | 4542 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 995 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 22475664 | 22475664 | PRJNA800090_P_NODE_200078_length_190_cov_4.760331_g197893_i0 | PRJNA800090 | 200078 | 190 | 4.760331 | 9.0446289 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 263 | 6.93e-66 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g197893 | i0 | 91.579 | 1 | 190 | 16 | 100 | 0 | 1 | 190 | 24024 | 23835 | Hafnia phage TS33, complete genome | blastn | 190 | 263 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 22476584 | 22476584 | PRJNA800090_P_NODE_65378_length_426_cov_1.607843_g63194_i0 | PRJNA800090 | 65378 | 426 | 1.607843 | 6.84941118 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 425 | 2.1e-114 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g63194 | i0 | 88.385 | 0.828638497652582 | 353 | 41 | 83 | 0 | 2 | 354 | 19336 | 18984 | Hafnia phage TS33, complete genome | blastn | 353 | 425 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 22476636 | 22476636 | PRJNA800090_P_NODE_67898_length_416_cov_0.979827_g65714_i0 | PRJNA800090 | 67898 | 416 | 0.979827 | 4.07608032 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 448 | 4.37e-121 | NTclustered | gi|2642095204|gb|OR844384.1| | 3110108 | g65714 | i0 | 88.064 | 0.90625 | 377 | 45 | 91 | 0 | 40 | 416 | 10859 | 10483 | Hafnia phage TS33, complete genome | blastn | 377 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 23750957 | 23750957 | PRJNA800090_P_NODE_187299_length_230_cov_0.906832_g185114_i0 | PRJNA800090 | 187299 | 230 | 0.906832 | 2.0857136 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 420 | 4.89e-113 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g185114 | i0 | 99.565 | 1 | 230 | 1 | 100 | 0 | 1 | 230 | 9523 | 9752 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 230 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 |
Advanced export
JSON shape: default, array, newline-delimited
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);;