contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 435021 | 435021 | PRJNA438572_P_NODE_22241_length_245_cov_0.906977_g22122_i0 | PRJNA438572 | 22241 | 245 | 0.906977 | 2.22209365 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 374 | 4.16e-99 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g22122 | i0 | 94.606 | 7.79591836734694 | 241 | 13 | 98 | 0 | 1 | 241 | 102109 | 102349 | Klebsiella phage pzk-kv8, complete genome | blastn | 1910 | 374 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 435237 | 435237 | PRJNA438572_P_NODE_9661_length_329_cov_1.218750_g9542_i0 | PRJNA438572 | 9661 | 329 | 1.21875 | 4.0096875 | Marfavirus F48 | 2845079 | Viruses | Viruses | 492 | 1.54e-134 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g9542 | i0 | 93.617 | 66.8571428571429 | 329 | 21 | 100 | 0 | 1 | 329 | 100449 | 100777 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 21996 | 492 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 2366373 | 2366373 | PRJNA438572_P_NODE_11802_length_299_cov_1.371681_g11683_i0 | PRJNA438572 | 11802 | 299 | 1.371681 | 4.10132619 | Marfavirus | 2843419 | Viruses | Viruses | 464 | 3.0099999999999996e-126 | NTclustered | gi|1769034342|gb|MN434092.1| | 2653641 | g11683 | i0 | 94.649 | 91.3946488294314 | 299 | 16 | 100 | 0 | 1 | 299 | 131903 | 132201 | Klebsiella phage AmPh_EK29, complete genome | blastn | 27327 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 4261959 | 4261959 | PRJNA438572_P_NODE_14824_length_270_cov_1.553299_g14705_i0 | PRJNA438572 | 14824 | 270 | 1.553299 | 4.1939073 | Bacteriophage sp. | 38018 | Viruses | Viruses | 475 | 1.2399999999999999e-129 | NTclustered | gi|1977365072|gb|MW462191.1| | 38018 | g14705 | i0 | 98.513 | 5.79259259259259 | 269 | 4 | 99 | 0 | 2 | 270 | 96138 | 95870 | Bacteriophage sp. isolate contig405706 genomic sequence | blastn | 1564 | 475 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 4262084 | 4262084 | PRJNA438572_P_NODE_22584_length_244_cov_1.888889_g22465_i0 | PRJNA438572 | 22584 | 244 | 1.888889 | 4.60888916 | Marfavirus F48 | 2845079 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g22465 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 1721 | 1964 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 244 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 5538686 | 5538686 | PRJNA438572_P_NODE_17945_length_251_cov_1.893258_g17826_i0 | PRJNA438572 | 17945 | 251 | 1.893258 | 4.75207758 | Klebsiella phage vB_KpnM_SmallBear_ER8 | 3374993 | Viruses | Viruses | 320 | 5.65e-83 | NTclustered | gi|2895980300|gb|PP738792.1| | 3374993 | g17826 | i0 | 94.712 | 29.5258964143426 | 208 | 7 | 82 | 4 | 15 | 220 | 156492 | 156697 | Klebsiella phage vB_KpnM_SmallBear_ER8, complete genome | blastn | 7411 | 320 | 1 | Viruses | Klebsiella phage vB_KpnM_SmallBear_ER8 | ||||||||
| 5538911 | 5538911 | PRJNA438572_P_NODE_8265_length_354_cov_1.110320_g8146_i0 | PRJNA438572 | 8265 | 354 | 1.11032 | 3.9305328 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 466 | 1.0099999999999999e-126 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g8146 | i0 | 90.598 | 80.4265536723164 | 351 | 33 | 99 | 0 | 1 | 351 | 126977 | 126627 | Klebsiella phage pzk-kv8, complete genome | blastn | 28471 | 466 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 8088444 | 8088444 | PRJNA438572_P_NODE_9787_length_327_cov_1.228346_g9668_i0 | PRJNA438572 | 9787 | 327 | 1.228346 | 4.01669142 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 604 | 1.8799999999999993e-168 | NTclustered | gi|2053025026|tpg|BK023955.1| | 2832643 | g9668 | i0 | 100 | 9.95107033639144 | 327 | 0 | 100 | 0 | 1 | 327 | 370 | 696 | MAG TPA_asm: Caudoviricetes sp. isolate ctWEw2, partial genome | blastn | 3254 | 604 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9362953 | 9362953 | PRJNA438572_P_NODE_15668_length_263_cov_1.231579_g15549_i0 | PRJNA438572 | 15668 | 263 | 1.231579 | 3.23905277 | Marfavirus F48 | 2845079 | Viruses | Viruses | 427 | 3.41e-115 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g15549 | i0 | 96.169 | 7.11026615969582 | 261 | 10 | 99 | 0 | 3 | 263 | 55998 | 55738 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 1870 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 9362978 | 9362978 | PRJNA438572_P_NODE_17408_length_252_cov_1.307263_g17289_i0 | PRJNA438572 | 17408 | 252 | 1.307263 | 3.29430276 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 377 | 3.32e-100 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g17289 | i0 | 93.651 | 1 | 252 | 16 | 100 | 0 | 1 | 252 | 103725 | 103976 | Klebsiella phage pzk-kv8, complete genome | blastn | 252 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 10638881 | 10638881 | PRJNA438572_P_NODE_16989_length_253_cov_0.866667_g16870_i0 | PRJNA438572 | 16989 | 253 | 0.866667 | 2.19266751 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 353 | 5.62e-93 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g16870 | i0 | 92.095 | 80.1897233201581 | 253 | 16 | 99 | 4 | 1 | 252 | 102750 | 102501 | Klebsiella phage pzk-kv8, complete genome | blastn | 20288 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 11913671 | 11913671 | PRJNA438572_P_NODE_15170_length_267_cov_1.422680_g15051_i0 | PRJNA438572 | 15170 | 267 | 1.42268 | 3.7985556 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 340 | 4.66e-89 | NTclustered | gi|1220000999|gb|MF417895.1| | 2100421 | g15051 | i0 | 90.076 | 40.2621722846442 | 262 | 26 | 98 | 0 | 6 | 267 | 633 | 894 | Uncultured Caudovirales phage clone 10AX_1, partial genome | blastn | 10750 | 340 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 13844558 | 13844558 | PRJNA438572_P_NODE_20251_length_248_cov_0.891429_g20132_i0 | PRJNA438572 | 20251 | 248 | 0.891429 | 2.21074392 | Marfavirus | 2843419 | Viruses | Viruses | 392 | 1.1599999999999999e-104 | NTclustered | gi|1789811001|gb|MN395284.1| | 2689112 | g20132 | i0 | 95.161 | 19.9637096774194 | 248 | 12 | 100 | 0 | 1 | 248 | 116560 | 116313 | Klebsiella phage PhiKpNIH-6, complete genome | blastn | 4951 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 14463559 | 14463559 | PRJNA438572_P_NODE_10852_length_312_cov_0.979079_g10733_i0 | PRJNA438572 | 10852 | 312 | 0.979079 | 3.05472648 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 424 | 5.37e-114 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g10733 | i0 | 91.29 | 6.95512820512821 | 310 | 27 | 99 | 0 | 3 | 312 | 149653 | 149962 | Klebsiella phage pzk-kv8, complete genome | blastn | 2170 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 14463584 | 14463584 | PRJNA438572_P_NODE_11952_length_297_cov_1.388393_g11833_i0 | PRJNA438572 | 11952 | 297 | 1.388393 | 4.12352721 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 67.6 | 9.85e-7 | NTclustered | gi|1971775256|gb|MW460245.1| | 2805747 | g11833 | i0 | 100 | 0.508417508417508 | 36 | 0 | 12 | 0 | 147 | 182 | 654 | 619 | Burkholderia phage BCSR5, complete genome | blastn | 151 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 14463708 | 14463708 | PRJNA438572_P_NODE_19832_length_249_cov_0.886364_g19713_i0 | PRJNA438572 | 19832 | 249 | 0.886364 | 2.20704636 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 377 | 3.27e-100 | NTclustered | gi|2914882854|gb|OR222208.1| | 2832643 | g19713 | i0 | 94 | 29.7871485943775 | 250 | 14 | 100 | 1 | 1 | 249 | 22302 | 22053 | MAG: Caudoviricetes sp. isolate MSP0766 genomic sequence | blastn | 7417 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15118806 | 15118806 | PRJNA438572_P_NODE_22632_length_244_cov_1.567251_g22513_i0 | PRJNA438572 | 22632 | 244 | 1.567251 | 3.82409244 | Marfavirus | 2843419 | Viruses | Viruses | 394 | 3.17e-105 | NTclustered | gi|1859648364|ref|NC_048694.1| | 2070028 | g22513 | i0 | 96.25 | 19.594262295082 | 240 | 9 | 98 | 0 | 2 | 241 | 162967 | 163206 | Klebsiella phage vB_Kpn_F48, complete genome | blastn | 4781 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 17012366 | 17012366 | PRJNA438572_P_NODE_21634_length_246_cov_0.901734_g21515_i0 | PRJNA438572 | 21634 | 246 | 0.901734 | 2.21826564 | Bacteriophage sp. | 38018 | Viruses | Viruses | 405 | 1.48e-108 | NTclustered | gi|1977365072|gb|MW462191.1| | 38018 | g21515 | i0 | 96.341 | 1 | 246 | 9 | 100 | 0 | 1 | 246 | 88212 | 88457 | Bacteriophage sp. isolate contig405706 genomic sequence | blastn | 246 | 405 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 17012383 | 17012383 | PRJNA438572_P_NODE_22534_length_245_cov_0.901163_g22415_i0 | PRJNA438572 | 22534 | 245 | 0.901163 | 2.20784935 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2059843324|tpg|BK040376.1| | 2832643 | g22415 | i0 | 99.592 | 10.9795918367347 | 245 | 1 | 100 | 0 | 1 | 245 | 112950 | 113194 | MAG TPA_asm: Caudoviricetes sp. isolate ctRxF12, partial genome | blastn | 2690 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18286729 | 18286729 | PRJNA438572_P_NODE_24895_length_227_cov_2.025974_g24776_i0 | PRJNA438572 | 24895 | 227 | 2.025974 | 4.59896098 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 2.289999999999999e-96 | NTclustered | gi|2914920971|gb|OR221384.1| | 2832643 | g24776 | i0 | 95.595 | 6.97356828193833 | 227 | 10 | 100 | 0 | 1 | 227 | 11667 | 11441 | MAG: Caudoviricetes sp. isolate MSP1712 genomic sequence | blastn | 1583 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19560989 | 19560989 | PRJNA438572_P_NODE_23336_length_243_cov_1.311765_g23217_i0 | PRJNA438572 | 23336 | 243 | 1.311765 | 3.18758895 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 311 | 3.27e-80 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g23217 | i0 | 89.919 | 15.4320987654321 | 248 | 16 | 100 | 8 | 1 | 243 | 132748 | 132505 | Klebsiella phage pzk-kv8, complete genome | blastn | 3750 | 311 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 20836675 | 20836675 | PRJNA438572_P_NODE_2817_length_582_cov_3.121807_g2700_i0 | PRJNA438572 | 2817 | 582 | 3.121807 | 18.16891674 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 65.8 | 7.38e-6 | NTclustered | gi|37701115|gb|AY397046.1| | 11676 | g2700 | i0 | 97.368 | 2.20962199312715 | 38 | 1 | 7 | 0 | 400 | 437 | 297 | 334 | HIV-1 strain A|A15 from Ghana gag protein (gag) gene, partial cds | blastn | 1286 | 65.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 20836727 | 20836727 | PRJNA438572_P_NODE_4977_length_445_cov_1.244624_g4858_i0 | PRJNA438572 | 4977 | 445 | 1.244624 | 5.5385768 | Vibrio phage 1.244.A._10N.261.54.C3 | 1881412 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|1332557523|gb|MG592609.1| | 1881412 | g4858 | i0 | 97.059 | 0.364044943820225 | 34 | 1 | 8 | 0 | 2 | 35 | 126419 | 126452 | Vibrio phage 1.244.A._10N.261.54.C3, partial genome | blastn | 162 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Vibrio phage 1.244.A._10N.261.54.C3 | |||
| 20836770 | 20836770 | PRJNA438572_P_NODE_7217_length_376_cov_1.227723_g7098_i0 | PRJNA438572 | 7217 | 376 | 1.227723 | 4.61623848 | Marfavirus F48 | 2845079 | Viruses | Viruses | 584 | 2.8499999999999984e-162 | NTclustered | gi|1859648364|ref|NC_048694.1| | 2070028 | g7098 | i0 | 94.681 | 8.45212765957447 | 376 | 20 | 100 | 0 | 1 | 376 | 142750 | 143125 | Klebsiella phage vB_Kpn_F48, complete genome | blastn | 3178 | 584 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 23387428 | 23387428 | PRJNA438572_P_NODE_9499_length_332_cov_0.903475_g9380_i0 | PRJNA438572 | 9499 | 332 | 0.903475 | 2.999537 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 446 | 1.23e-120 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g9380 | i0 | 90.937 | 1.68975903614458 | 331 | 30 | 99 | 0 | 1 | 331 | 156342 | 156672 | Klebsiella phage pzk-kv8, complete genome | blastn | 561 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 |
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);;