contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1253217 | 1253217 | PRJNA928559_P_NODE_8541_length_1039_cov_18.684265_g7436_i0 | PRJNA928559 | 8541 | 1039 | 18.684265 | 194.12951335 | Luzcentumvirus | 3425748 | Viruses | Viruses | 56.5 | 0.008 | NTclustered | gi|2177948915|gb|OL676770.1| | 2900301 | g7436 | i0 | 100 | 0.121270452358037 | 30 | 0 | 3 | 0 | 591 | 620 | 4717 | 4688 | Vibrio virus VPMCC5, complete genome | blastn | 126 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Vibrio virus VPMCC5 | ||||
| 1253243 | 1253243 | PRJNA928559_P_NODE_94921_length_366_cov_1.358362_g93352_i0 | PRJNA928559 | 94921 | 366 | 1.358362 | 4.97160492 | Pakpunavirus | 1921407 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|971745828|ref|NC_028817.1| | 1716041 | g93352 | i0 | 81.429 | 6.12021857923497 | 70 | 12 | 19 | 1 | 115 | 183 | 61259 | 61190 | Pseudomonas phage K8, complete genome | blastn | 2240 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Pakpunavirus | Pseudomonas phage K8 | |||
| 2178032 | 2178032 | PRJNA928559_P_NODE_158102_length_279_cov_2.378641_g156533_i0 | PRJNA928559 | 158102 | 279 | 2.378641 | 6.63640839 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 182 | 3.14e-41 | NTclustered | gi|2914932618|gb|OR221606.1| | 2832643 | g156533 | i0 | 89.041 | 16.0501792114695 | 146 | 16 | 52 | 0 | 1 | 146 | 2182 | 2037 | MAG: Caudoviricetes sp. isolate MSP1459 genomic sequence | blastn | 4478 | 182 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2528608 | 2528608 | PRJNA928559_P_NODE_200422_length_248_cov_0.891429_g198853_i0 | PRJNA928559 | 200422 | 248 | 0.891429 | 2.21074392 | root | 1 | Root_unresolved | Root_unresolved | 459 | 1.13e-124 | NTclustered | gi|2914842066|gb|OR222894.1| | 2832643 | g198853 | i0 | 100 | 30.133064516129 | 248 | 0 | 100 | 0 | 1 | 248 | 40360 | 40607 | MAG: Caudoviricetes sp. isolate MSP0452 genomic sequence | blastn | 7473 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2528777 | 2528777 | PRJNA928559_P_NODE_37182_length_545_cov_6.245763_g35630_i0 | PRJNA928559 | 37182 | 545 | 6.245763 | 34.03940835 | Viruses | 10239 | Viruses | Viruses | 113 | 2.42e-20 | NTclustered | gi|2209083203|gb|OM687511.1| | 2924716 | g35630 | i0 | 92.405 | 24.3706422018349 | 79 | 6 | 14 | 0 | 57 | 135 | 69845 | 69923 | Burkholderia phage vB_BpP_HN01, complete genome | blastn | 13282 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Burkholderia phage vB_BpP_HN01 | ||||
| 7631040 | 7631040 | PRJNA928559_P_NODE_202306_length_247_cov_0.896552_g200737_i0 | PRJNA928559 | 202306 | 247 | 0.896552 | 2.21448344 | root | 1 | Root_unresolved | Root_unresolved | 451 | 1.88e-122 | NTclustered | gi|2915026475|gb|OR222618.1| | 2832643 | g200737 | i0 | 99.595 | 52.8825910931174 | 247 | 1 | 100 | 0 | 1 | 247 | 91085 | 90839 | MAG: Caudoviricetes sp. isolate MSP0313 genomic sequence | blastn | 13062 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12732536 | 12732536 | PRJNA928559_P_NODE_54290_length_468_cov_2.217722_g52724_i0 | PRJNA928559 | 54290 | 468 | 2.217722 | 10.37893896 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1795715111|emb|LR743531.1| | 2674974 | g52724 | i0 | 96.97 | 1.0982905982906 | 33 | 0 | 7 | 1 | 1 | 32 | 30634 | 30602 | Xanthomonas phage Tenjo genome assembly, chromosome: 1 | blastn | 514 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage Tenjo | |||||
| 13656371 | 13656371 | PRJNA928559_P_NODE_154591_length_283_cov_1.485714_g153022_i0 | PRJNA928559 | 154591 | 283 | 1.485714 | 4.20457062 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 202 | 2.4499999999999998e-47 | NTclustered | gi|2914806757|gb|OR221571.1| | 2832643 | g153022 | i0 | 80.142 | 2.56890459363958 | 282 | 46 | 98 | 8 | 4 | 280 | 2356 | 2080 | MAG: Caudoviricetes sp. isolate MSP1497 genomic sequence | blastn | 727 | 202 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14007247 | 14007247 | PRJNA928559_P_NODE_96631_length_362_cov_27.377163_g95062_i0 | PRJNA928559 | 96631 | 362 | 27.377163 | 99.10533006 | root | 1 | Root_unresolved | Root_unresolved | 667 | 0 | NTclustered | gi|2915034053|gb|OR222678.1| | 2832643 | g95062 | i0 | 100 | 77.2486187845304 | 361 | 0 | 99 | 0 | 2 | 362 | 30549 | 30189 | MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence | blastn | 27964 | 667 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16207098 | 16207098 | PRJNA928559_P_NODE_51573_length_478_cov_2.644444_g50010_i0 | PRJNA928559 | 51573 | 478 | 2.644444 | 12.64044232 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 394 | 6.709999999999999e-105 | NTclustered | gi|2914942936|gb|OR221765.1| | 2832643 | g50010 | i0 | 83.07 | 1122.3410041841 | 443 | 65 | 92 | 9 | 6 | 443 | 41084 | 40647 | MAG: Caudoviricetes sp. isolate MSP1261 genomic sequence | blastn | 536479 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17481480 | 17481480 | PRJNA928559_P_NODE_200094_length_248_cov_0.891429_g198525_i0 | PRJNA928559 | 200094 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.9299999999999994e-107 | NTclustered | gi|2915016823|gb|OR222530.1| | 2832643 | g198525 | i0 | 98.261 | 16.7661290322581 | 230 | 3 | 93 | 1 | 1 | 230 | 31036 | 31264 | MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence | blastn | 4158 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18754791 | 18754791 | PRJNA928559_P_NODE_193415_length_251_cov_0.876404_g191846_i0 | PRJNA928559 | 193415 | 251 | 0.876404 | 2.19977404 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 1.22e-79 | NTclustered | gi|2056870103|tpg|BK044667.1| | 2832643 | g191846 | i0 | 88.845 | 2.00796812749004 | 251 | 28 | 100 | 0 | 1 | 251 | 19566 | 19816 | MAG TPA_asm: Caudoviricetes sp. isolate ctQL51, partial genome | blastn | 504 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18755903 | 18755903 | PRJNA928559_P_NODE_71155_length_417_cov_3.479651_g69586_i0 | PRJNA928559 | 71155 | 417 | 3.479651 | 14.51014467 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 113 | 1.81e-20 | NTclustered | gi|1862809795|emb|LR798293.1| | 2100421 | g69586 | i0 | 89.888 | 10.5011990407674 | 89 | 7 | 21 | 2 | 24 | 112 | 32051 | 31965 | uncultured Caudovirales phage genome assembly | blastn | 4379 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 20029804 | 20029804 | PRJNA928559_P_NODE_192856_length_251_cov_0.876404_g191287_i0 | PRJNA928559 | 192856 | 251 | 0.876404 | 2.19977404 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|2057009209|tpg|BK048656.1| | 2832643 | g191287 | i0 | 99.203 | 1.98804780876494 | 251 | 2 | 100 | 0 | 1 | 251 | 54611 | 54861 | MAG TPA_asm: Caudoviricetes sp. isolate ctOa11, partial genome | blastn | 499 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20030923 | 20030923 | PRJNA928559_P_NODE_6816_length_1151_cov_12.345083_g5835_i0 | PRJNA928559 | 6816 | 1151 | 12.345083 | 142.09190533 | Limnohabitans phage YIMV22061 | 3390366 | Viruses | Viruses | 780 | 0 | NTclustered | gi|2874380709|gb|PQ492660.1| | 3390366 | g5835 | i0 | 79.412 | 1.56559513466551 | 1156 | 198 | 99 | 26 | 3 | 1149 | 5765 | 6889 | Limnohabitans phage YIMV22061, complete genome | blastn | 1802 | 780 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Limnohabitans phage YIMV22061 | ||||
| 21305535 | 21305535 | PRJNA928559_P_NODE_212037_length_243_cov_0.917647_g210468_i0 | PRJNA928559 | 212037 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 433 | 6.69e-117 | NTclustered | gi|2059901129|tpg|BK041318.1| | 2832643 | g210468 | i0 | 98.765 | 4.94238683127572 | 243 | 3 | 100 | 0 | 1 | 243 | 48847 | 48605 | MAG TPA_asm: Caudoviricetes sp. isolate ctapA22, partial genome | blastn | 1201 | 433 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22579442 | 22579442 | PRJNA928559_P_NODE_128278_length_313_cov_9.895833_g126709_i0 | PRJNA928559 | 128278 | 313 | 9.895833 | 30.97395729 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 573 | 5.049999999999998e-159 | NTclustered | gi|2054619390|tpg|BK022090.1| | 2832643 | g126709 | i0 | 99.682 | 9.49520766773163 | 314 | 0 | 100 | 1 | 1 | 313 | 39132 | 38819 | MAG TPA_asm: Caudoviricetes sp. isolate ctpXa14, partial genome | blastn | 2972 | 573 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22579835 | 22579835 | PRJNA928559_P_NODE_155638_length_282_cov_1.387560_g154069_i0 | PRJNA928559 | 155638 | 282 | 1.38756 | 3.9129192 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.6699999999999998e-133 | NTclustered | gi|2052267259|tpg|BK019874.1| | 2832643 | g154069 | i0 | 97.872 | 20.9432624113475 | 282 | 6 | 100 | 0 | 1 | 282 | 7346 | 7627 | MAG TPA_asm: Caudoviricetes sp. isolate ct8pq41, partial genome | blastn | 5906 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22581000 | 22581000 | PRJNA928559_P_NODE_318_length_4758_cov_50.220277_g236_i0 | PRJNA928559 | 318 | 4758 | 50.220277 | 2389.48077966 | Limnohabitans phage YIMV22061 | 3390366 | Viruses | Viruses | 939 | 0 | NTclustered | gi|2874380709|gb|PQ492660.1| | 3390366 | g236 | i0 | 84.713 | 1.00966792770071 | 942 | 140 | 20 | 4 | 73 | 1012 | 33471 | 34410 | Limnohabitans phage YIMV22061, complete genome | blastn | 4804 | 939 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Limnohabitans phage YIMV22061 | ||||
| 22581640 | 22581640 | PRJNA928559_P_NODE_83058_length_389_cov_4.639241_g81489_i0 | PRJNA928559 | 83058 | 389 | 4.639241 | 18.04664749 | Limnohabitans phage YIMV22061 | 3390366 | Viruses | Viruses | 135 | 3.59e-27 | NTclustered | gi|2874380709|gb|PQ492660.1| | 3390366 | g81489 | i0 | 78.922 | 0.997429305912596 | 204 | 39 | 52 | 4 | 125 | 327 | 18162 | 18362 | Limnohabitans phage YIMV22061, complete genome | blastn | 388 | 135 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Limnohabitans phage YIMV22061 | ||||
| 22581851 | 22581851 | PRJNA928559_P_NODE_98_length_6871_cov_10.045455_g77_i0 | PRJNA928559 | 98 | 6871 | 10.045455 | 690.22321305 | Limnohabitans phage YIMV22061 | 3390366 | Viruses | Viruses | 1452 | 0 | NTclustered | gi|2874380709|gb|PQ492660.1| | 3390366 | g77 | i0 | 86.192 | 2.17930432251492 | 1347 | 180 | 58 | 5 | 4117 | 5460 | 2343 | 3686 | Limnohabitans phage YIMV22061, complete genome | blastn | 14974 | 1452 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Limnohabitans phage YIMV22061 | ||||
| 23854987 | 23854987 | PRJNA928559_P_NODE_159779_length_278_cov_0.956098_g158210_i0 | PRJNA928559 | 159779 | 278 | 0.956098 | 2.65795244 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|2054807925|tpg|BK050248.1| | 2832643 | g158210 | i0 | 100 | 0.100719424460432 | 28 | 0 | 10 | 0 | 144 | 171 | 23564 | 23537 | MAG TPA_asm: Caudoviricetes sp. isolate ctm1v2, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23856044 | 23856044 | PRJNA928559_P_NODE_2339_length_1884_cov_8.399227_g1866_i0 | PRJNA928559 | 2339 | 1884 | 8.399227 | 158.24143668 | Limnohabitans phage YIMV22061 | 3390366 | Viruses | Viruses | 1038 | 0 | NTclustered | gi|2874380709|gb|PQ492660.1| | 3390366 | g1866 | i0 | 77.219 | 9.26326963906582 | 1848 | 376 | 97 | 39 | 18 | 1841 | 23929 | 22103 | Limnohabitans phage YIMV22061, complete genome | blastn | 17452 | 1038 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographiviridae | Limnohabitans phage YIMV22061 | ||||
| 25479815 | 25479815 | PRJNA928559_P_NODE_99440_length_358_cov_0.954386_g97871_i0 | PRJNA928559 | 99440 | 358 | 0.954386 | 3.41670188 | root | 1 | Root_unresolved | Root_unresolved | 656 | 0 | NTclustered | gi|2915026475|gb|OR222618.1| | 2832643 | g97871 | i0 | 99.721 | 74.3435754189944 | 358 | 1 | 100 | 0 | 1 | 358 | 83554 | 83197 | MAG: Caudoviricetes sp. isolate MSP0313 genomic sequence | blastn | 26615 | 656 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;