contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA833575" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 824195 | 824195 | PRJNA833575_P_NODE_21401_length_320_cov_1.147410_g21264_i0 | PRJNA833575 | 21401 | 320 | 1.14741 | 3.671712 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 580 | 3.099999999999999e-161 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g21264 | i0 | 99.377 | 4.28125 | 321 | 1 | 100 | 1 | 1 | 320 | 11616 | 11296 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 1370 | 580 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 2099684 | 2099684 | PRJNA833575_P_NODE_23862_length_304_cov_2.038298_g23725_i0 | PRJNA833575 | 23862 | 304 | 2.038298 | 6.19642592 | Escherichia phage TR1 | 2972435 | Viruses | Viruses | 556 | 4.919999999999999e-154 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g23725 | i0 | 99.671 | 15.4375 | 304 | 1 | 100 | 0 | 1 | 304 | 24666 | 24363 | Escherichia phage TR1, complete genome | blastn | 4693 | 556 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 | |||
| 3374921 | 3374921 | PRJNA833575_P_NODE_17363_length_352_cov_2.141343_g17226_i0 | PRJNA833575 | 17363 | 352 | 2.141343 | 7.53752736 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 562 | 1.2399999999999997e-155 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g17226 | i0 | 94.199 | 16.9431818181818 | 362 | 11 | 100 | 1 | 1 | 352 | 5595 | 5956 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 5964 | 562 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 3375225 | 3375225 | PRJNA833575_P_NODE_35643_length_246_cov_1.627119_g35506_i0 | PRJNA833575 | 35643 | 246 | 1.627119 | 4.00271274 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 449 | 6.74e-122 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g35506 | i0 | 99.593 | 6.03252032520325 | 246 | 1 | 100 | 0 | 1 | 246 | 17829 | 17584 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 1484 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 4652455 | 4652455 | PRJNA833575_P_NODE_13444_length_397_cov_1.606707_g13307_i0 | PRJNA833575 | 13444 | 397 | 1.606707 | 6.37862679 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 728 | 0 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g13307 | i0 | 99.748 | 63.5869017632242 | 397 | 1 | 100 | 0 | 1 | 397 | 21242 | 20846 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 25244 | 728 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 8881925 | 8881925 | PRJNA833575_P_NODE_22767_length_311_cov_1.314050_g22630_i0 | PRJNA833575 | 22767 | 311 | 1.31405 | 4.0866955 | Christensenvirus | 2732061 | Viruses | Viruses | 575 | 1.3899999999999995e-159 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g22630 | i0 | 100 | 7 | 311 | 0 | 100 | 0 | 1 | 311 | 1817 | 1507 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 2177 | 575 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 8882118 | 8882118 | PRJNA833575_P_NODE_36867_length_241_cov_1.145349_g36730_i0 | PRJNA833575 | 36867 | 241 | 1.145349 | 2.76029109 | Christensenvirus | 2732061 | Viruses | Viruses | 435 | 1.84e-117 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g36730 | i0 | 99.17 | 38.5435684647303 | 241 | 2 | 100 | 0 | 1 | 241 | 36750 | 36510 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 9289 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 11027958 | 11027958 | PRJNA833575_P_NODE_23509_length_306_cov_2.599156_g23372_i0 | PRJNA833575 | 23509 | 306 | 2.599156 | 7.95341736 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 555 | 1.7799999999999996e-153 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g23372 | i0 | 99.346 | 1 | 306 | 2 | 100 | 0 | 1 | 306 | 24899 | 24594 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 306 | 555 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 11028140 | 11028140 | PRJNA833575_P_NODE_33749_length_254_cov_2.254054_g33612_i0 | PRJNA833575 | 33749 | 254 | 2.254054 | 5.72529716 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 459 | 1.1599999999999999e-124 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g33612 | i0 | 99.213 | 1 | 254 | 2 | 100 | 0 | 1 | 254 | 27123 | 26870 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 254 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 12303496 | 12303496 | PRJNA833575_P_NODE_2870_length_806_cov_1.358209_g2763_i0 | PRJNA833575 | 2870 | 806 | 1.358209 | 10.94716454 | Escherichia phage TR1 | 2972435 | Viruses | Viruses | 1489 | 0 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g2763 | i0 | 100 | 2.39454094292804 | 806 | 0 | 100 | 0 | 1 | 806 | 20124 | 19319 | Escherichia phage TR1, complete genome | blastn | 1930 | 1489 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 | |||
| 12303711 | 12303711 | PRJNA833575_P_NODE_41690_length_231_cov_1.333333_g41553_i0 | PRJNA833575 | 41690 | 231 | 1.333333 | 3.07999923 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g41553 | i0 | 100 | 49.8831168831169 | 231 | 0 | 100 | 0 | 1 | 231 | 38288 | 38518 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 11523 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 13577722 | 13577722 | PRJNA833575_P_NODE_21031_length_322_cov_1.992095_g20894_i0 | PRJNA833575 | 21031 | 322 | 1.992095 | 6.4145459 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 584 | 2.41e-162 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g20894 | i0 | 99.379 | 3.7639751552795 | 322 | 2 | 100 | 0 | 1 | 322 | 12593 | 12914 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 1212 | 584 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 13578040 | 13578040 | PRJNA833575_P_NODE_41171_length_232_cov_0.883436_g41034_i0 | PRJNA833575 | 41171 | 232 | 0.883436 | 2.04957152 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 429 | 8.2e-116 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g41034 | i0 | 100 | 36.9137931034483 | 232 | 0 | 100 | 0 | 1 | 232 | 19556 | 19325 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 8564 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 13578096 | 13578096 | PRJNA833575_P_NODE_44231_length_228_cov_1.811321_g44094_i0 | PRJNA833575 | 44231 | 228 | 1.811321 | 4.12981188 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 422 | 1.34e-113 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g44094 | i0 | 100 | 13.6271929824561 | 228 | 0 | 100 | 0 | 1 | 228 | 25625 | 25398 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 3107 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 13982770 | 13982770 | PRJNA833575_P_NODE_29771_length_272_cov_2.354680_g29634_i0 | PRJNA833575 | 29771 | 272 | 2.35468 | 6.4047296 | Christensenvirus | 2732061 | Viruses | Viruses | 497 | 2.67e-136 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g29634 | i0 | 99.632 | 65.7977941176471 | 272 | 1 | 100 | 0 | 1 | 272 | 41312 | 41041 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 17897 | 497 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 16127038 | 16127038 | PRJNA833575_P_NODE_37833_length_236_cov_1.700599_g37696_i0 | PRJNA833575 | 37833 | 236 | 1.700599 | 4.01341364 | Erwinia phage pEa_SNUABM_20 | 2869548 | Viruses | Viruses | 320 | 5.26e-83 | NTclustered | gi|2084421582|gb|MZ443771.1| | 2869548 | g37696 | i0 | 91.102 | 31.3898305084746 | 236 | 21 | 100 | 0 | 1 | 236 | 6002 | 5767 | Erwinia phage pEa_SNUABM_20, complete genome | blastn | 7408 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Alexandravirus | Erwinia phage pEa_SNUABM_20 | ||||
| 17402717 | 17402717 | PRJNA833575_P_NODE_36354_length_243_cov_1.241379_g36217_i0 | PRJNA833575 | 36354 | 243 | 1.241379 | 3.01655097 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 433 | 6.69e-117 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g36217 | i0 | 98.765 | 1 | 243 | 3 | 100 | 0 | 1 | 243 | 20882 | 20640 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 243 | 433 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 19950661 | 19950661 | PRJNA833575_P_NODE_22376_length_314_cov_0.881633_g22239_i0 | PRJNA833575 | 22376 | 314 | 0.881633 | 2.76832762 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 575 | 1.4099999999999994e-159 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g22239 | i0 | 99.682 | 1 | 314 | 1 | 100 | 0 | 1 | 314 | 16381 | 16068 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 314 | 575 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 22501176 | 22501176 | PRJNA833575_P_NODE_33598_length_255_cov_1.510753_g33461_i0 | PRJNA833575 | 33598 | 255 | 1.510753 | 3.85242015 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g33461 | i0 | 100 | 15.1764705882353 | 255 | 0 | 100 | 0 | 1 | 255 | 9232 | 9486 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 3870 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 22906715 | 22906715 | PRJNA833575_P_NODE_8398_length_493_cov_1.188679_g8261_i0 | PRJNA833575 | 8398 | 493 | 1.188679 | 5.86018747 | Christensenvirus | 2732061 | Viruses | Viruses | 905 | 0 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g8261 | i0 | 99.797 | 55.2738336713996 | 493 | 1 | 100 | 0 | 1 | 493 | 42027 | 41535 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 27250 | 905 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 25050533 | 25050533 | PRJNA833575_P_NODE_27380_length_284_cov_2.009302_g27243_i0 | PRJNA833575 | 27380 | 284 | 2.009302 | 5.70641768 | Escherichia phage TR1 | 2972435 | Viruses | Viruses | 525 | 1.2899999999999994e-144 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g27243 | i0 | 100 | 3.99295774647887 | 284 | 0 | 100 | 0 | 1 | 284 | 24286 | 24003 | Escherichia phage TR1, complete genome | blastn | 1134 | 525 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 | |||
| 25050632 | 25050632 | PRJNA833575_P_NODE_34300_length_252_cov_1.573770_g34163_i0 | PRJNA833575 | 34300 | 252 | 1.57377 | 3.9659004 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 460 | 3.2e-125 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g34163 | i0 | 99.603 | 9.03571428571429 | 252 | 1 | 100 | 0 | 1 | 252 | 13065 | 13316 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 2277 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 25455400 | 25455400 | PRJNA833575_P_NODE_20780_length_324_cov_1.678431_g20643_i0 | PRJNA833575 | 20780 | 324 | 1.678431 | 5.43811644 | Christensenvirus | 2732061 | Viruses | Viruses | 593 | 4.0299999999999986e-165 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g20643 | i0 | 99.691 | 68.9722222222222 | 324 | 1 | 100 | 0 | 1 | 324 | 38329 | 38006 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 22347 | 593 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 25455501 | 25455501 | PRJNA833575_P_NODE_27780_length_282_cov_1.779343_g27643_i0 | PRJNA833575 | 27780 | 282 | 1.779343 | 5.01774726 | Christensenvirus | 2732061 | Viruses | Viruses | 516 | 7.67e-142 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g27643 | i0 | 99.645 | 28.4893617021277 | 282 | 1 | 100 | 0 | 1 | 282 | 7793 | 8074 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 8034 | 516 | 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);;