contig_metadata
30 rows where analysis = "blastn", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724119 | 724119 | PRJNA745553_S_NODE_18501_length_287_cov_2.158879_g18306_i0 | PRJNA745553 | 18501 | 287 | 2.158879 | 6.19598273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 508 | 1.31e-139 | NTclustered | gi|2056864296|tpg|BK044549.1| | 2832643 | g18306 | i0 | 99.64 | 66.3031358885017 | 278 | 1 | 97 | 0 | 10 | 287 | 12973 | 13250 | MAG TPA_asm: Caudoviricetes sp. isolate ctzwt36, partial genome | blastn | 19029 | 508 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 724188 | 724188 | PRJNA745553_S_NODE_22641_length_260_cov_2.117647_g22446_i0 | PRJNA745553 | 22641 | 260 | 2.117647 | 5.5058822 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 339 | 1.62e-88 | NTclustered | gi|2053202698|tpg|BK017000.1| | 2832643 | g22446 | i0 | 90.31 | 4.85 | 258 | 25 | 99 | 0 | 1 | 258 | 20838 | 21095 | MAG TPA_asm: Caudoviricetes sp. isolate ctD2V3, partial genome | blastn | 1261 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3275333 | 3275333 | PRJNA745553_S_NODE_1063_length_757_cov_19.754386_g943_i0 | PRJNA745553 | 1063 | 757 | 19.754386 | 149.54070202 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|2915048873|gb|OR222826.1| | 2832643 | g943 | i0 | 100 | 0.0383091149273448 | 29 | 0 | 4 | 0 | 729 | 757 | 58 | 30 | MAG: Caudoviricetes sp. isolate MSP0531 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3275434 | 3275434 | PRJNA745553_S_NODE_16343_length_305_cov_3.512931_g16148_i0 | PRJNA745553 | 16343 | 305 | 3.512931 | 10.71443955 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 2.18e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g16148 | i0 | 95.652 | 25.1213114754098 | 46 | 0 | 15 | 2 | 2 | 46 | 100081 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7662 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4552904 | 4552904 | PRJNA745553_S_NODE_5284_length_494_cov_2156.596200_g5090_i0 | PRJNA745553 | 5284 | 494 | 2156.5962 | 10653.585228 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 3.7e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g5090 | i0 | 95.652 | 15.497975708502 | 46 | 0 | 9 | 2 | 450 | 494 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7656 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4553002 | 4553002 | PRJNA745553_S_NODE_9964_length_384_cov_2.598071_g9769_i0 | PRJNA745553 | 9964 | 384 | 2.598071 | 9.97659264 | Brucella phage BiPBO1 | 1718278 | Viruses | Viruses | 518 | 3.01e-142 | NTclustered | gi|940326333|gb|KT724718.1| | 1718278 | g9769 | i0 | 91.293 | 6.140625 | 379 | 33 | 99 | 0 | 6 | 384 | 23562 | 23184 | Brucella phage BiPBO1, complete genome | blastn | 2358 | 518 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Brucella phage BiPBO1 | |||||
| 5827632 | 5827632 | PRJNA745553_S_NODE_12025_length_353_cov_3318.100000_g11830_i0 | PRJNA745553 | 12025 | 353 | 3318.1 | 11712.893 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 2.56e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g11830 | i0 | 95.652 | 21.6883852691218 | 46 | 0 | 13 | 2 | 309 | 353 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7656 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5827636 | 5827636 | PRJNA745553_S_NODE_12145_length_352_cov_1.655914_g11950_i0 | PRJNA745553 | 12145 | 352 | 1.655914 | 5.82881728 | Quesadillavirus quesadilla | 2956353 | Viruses | Viruses | 60.2 | 1.99e-4 | NTclustered | gi|1938304972|ref|NC_051584.1| | 2664226 | g11950 | i0 | 94.737 | 0.267045454545455 | 38 | 2 | 11 | 0 | 302 | 339 | 12478 | 12515 | Mycobacterium phage Quesadilla, complete genome | blastn | 94 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Quesadillavirus | Quesadillavirus quesadilla | ||||
| 5827979 | 5827979 | PRJNA745553_S_NODE_3905_length_545_cov_5.065678_g3717_i0 | PRJNA745553 | 3905 | 545 | 5.065678 | 27.6079451 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 4.11e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g3717 | i0 | 95.652 | 23.5798165137615 | 46 | 0 | 8 | 2 | 499 | 543 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 12851 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5827982 | 5827982 | PRJNA745553_S_NODE_4025_length_540_cov_8.297645_g3837_i0 | PRJNA745553 | 4025 | 540 | 8.297645 | 44.807283 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75 | 1.13e-8 | NTclustered | gi|2915048873|gb|OR222826.1| | 2832643 | g3837 | i0 | 100 | 23.75 | 40 | 0 | 7 | 0 | 492 | 531 | 58 | 19 | MAG: Caudoviricetes sp. isolate MSP0531 genomic sequence | blastn | 12825 | 75 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5827985 | 5827985 | PRJNA745553_S_NODE_4185_length_533_cov_2194.780435_g3995_i0 | PRJNA745553 | 4185 | 533 | 2194.780435 | 11698.17971855 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 4.02e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g3995 | i0 | 95.652 | 14.2589118198874 | 46 | 0 | 8 | 2 | 489 | 533 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7600 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5827990 | 5827990 | PRJNA745553_S_NODE_4285_length_530_cov_1.277899_g4095_i0 | PRJNA745553 | 4285 | 530 | 1.277899 | 6.7728647 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 845 | 0 | NTclustered | gi|2052198332|tpg|BK056061.1| | 2832643 | g4095 | i0 | 97.566 | 2.73396226415094 | 493 | 12 | 93 | 0 | 21 | 513 | 6124 | 6616 | MAG TPA_asm: Caudoviricetes sp. isolate ctHUM7, partial genome | blastn | 1449 | 845 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8377801 | 8377801 | PRJNA745553_S_NODE_7147_length_442_cov_25.615176_g6953_i0 | PRJNA745553 | 7147 | 442 | 25.615176 | 113.21907792 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 3.28e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g6953 | i0 | 95.652 | 29.0837104072398 | 46 | 0 | 10 | 2 | 2 | 46 | 100081 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 12855 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12203484 | 12203484 | PRJNA745553_S_NODE_11450_length_362_cov_1.532872_g11255_i0 | PRJNA745553 | 11450 | 362 | 1.532872 | 5.54899664 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 669 | 0 | NTclustered | gi|2914921080|gb|OR221385.1| | 2832643 | g11255 | i0 | 100 | 14.9668508287293 | 362 | 0 | 100 | 0 | 1 | 362 | 40019 | 39658 | MAG: Caudoviricetes sp. isolate MSP1713 genomic sequence | blastn | 5418 | 669 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13477819 | 13477819 | PRJNA745553_S_NODE_1051_length_761_cov_1343.062500_g931_i0 | PRJNA745553 | 1051 | 761 | 1343.0625 | 10220.705625 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 5.86e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g931 | i0 | 95.652 | 9.98685939553219 | 46 | 0 | 6 | 2 | 717 | 761 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7600 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13478293 | 13478293 | PRJNA745553_S_NODE_8871_length_405_cov_1.855422_g8676_i0 | PRJNA745553 | 8871 | 405 | 1.855422 | 7.5144591 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 732 | 0 | NTclustered | gi|2056972337|tpg|BK023149.1| | 2832643 | g8676 | i0 | 99.259 | 5.45432098765432 | 405 | 3 | 100 | 0 | 1 | 405 | 23286 | 23690 | MAG TPA_asm: Caudoviricetes sp. isolate ctZ9a2, partial genome | blastn | 2209 | 732 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17302215 | 17302215 | PRJNA745553_S_NODE_17134_length_298_cov_4.284444_g16939_i0 | PRJNA745553 | 17134 | 298 | 4.284444 | 12.76764312 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|2057993488|tpg|BK046985.1| | 2832643 | g16939 | i0 | 94.286 | 0.11744966442953 | 35 | 1 | 11 | 1 | 17 | 50 | 61257 | 61223 | MAG TPA_asm: Caudoviricetes sp. isolate ctSAk21, partial genome | blastn | 35 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17302431 | 17302431 | PRJNA745553_S_NODE_3034_length_586_cov_1733.538012_g2851_i0 | PRJNA745553 | 3034 | 586 | 1733.538012 | 10158.53275032 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 4.45e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g2851 | i0 | 95.652 | 12.9692832764505 | 46 | 0 | 8 | 2 | 542 | 586 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7600 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18575929 | 18575929 | PRJNA745553_S_NODE_24975_length_248_cov_2.840000_g24780_i0 | PRJNA745553 | 24975 | 248 | 2.84 | 7.0432 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2052178267|tpg|BK033163.1| | 2832643 | g24780 | i0 | 100 | 1 | 248 | 0 | 100 | 0 | 1 | 248 | 14437 | 14190 | MAG TPA_asm: Caudoviricetes sp. isolate ctCv31, partial genome | blastn | 248 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18575980 | 18575980 | PRJNA745553_S_NODE_2775_length_601_cov_3.005682_g2596_i0 | PRJNA745553 | 2775 | 601 | 3.005682 | 18.06414882 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1024 | 0 | NTclustered | gi|2057167607|tpg|BK058770.1| | 2832643 | g2596 | i0 | 98.616 | 6.39600665557404 | 578 | 8 | 96 | 0 | 2 | 579 | 101015 | 101592 | MAG TPA_asm: Caudoviricetes sp. isolate ctoyD1, partial genome | blastn | 3844 | 1024 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18576163 | 18576163 | PRJNA745553_S_NODE_9335_length_396_cov_0.953560_g9140_i0 | PRJNA745553 | 9335 | 396 | 0.95356 | 3.7760976 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 226 | 2.1099999999999998e-54 | NTclustered | gi|2054557975|tpg|BK048184.1| | 2832643 | g9140 | i0 | 83.966 | 0.598484848484849 | 237 | 37 | 60 | 1 | 160 | 396 | 5399 | 5634 | MAG TPA_asm: Caudoviricetes sp. isolate cthMZ1, partial genome | blastn | 237 | 226 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19851500 | 19851500 | PRJNA745553_S_NODE_8836_length_405_cov_2801.548193_g8641_i0 | PRJNA745553 | 8836 | 405 | 2801.548193 | 11346.27018165 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 2.98e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g8641 | i0 | 95.652 | 18.9037037037037 | 46 | 0 | 11 | 2 | 361 | 405 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7656 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19851501 | 19851501 | PRJNA745553_S_NODE_8876_length_404_cov_2678.528701_g8681_i0 | PRJNA745553 | 8876 | 404 | 2678.528701 | 10821.25595204 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 2.97e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g8681 | i0 | 95.652 | 18.950495049505 | 46 | 0 | 11 | 2 | 1 | 45 | 100081 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7656 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19851514 | 19851514 | PRJNA745553_S_NODE_9676_length_389_cov_4.813291_g9481_i0 | PRJNA745553 | 9676 | 389 | 4.813291 | 18.72370199 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 612 | 1.36e-170 | NTclustered | gi|2059917771|tpg|BK041575.1| | 2832643 | g9481 | i0 | 96.978 | 6.81233933161954 | 364 | 11 | 94 | 0 | 18 | 381 | 14756 | 15119 | MAG TPA_asm: Caudoviricetes sp. isolate ctgEa13, partial genome | blastn | 2650 | 612 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21126841 | 21126841 | PRJNA745553_S_NODE_25577_length_246_cov_0.890173_g25382_i0 | PRJNA745553 | 25577 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.2 | 1.33e-4 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g25382 | i0 | 94.872 | 12.150406504065 | 39 | 0 | 15 | 2 | 209 | 246 | 100125 | 100088 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 2989 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21126937 | 21126937 | PRJNA745553_S_NODE_3617_length_558_cov_9.480412_g3432_i0 | PRJNA745553 | 3617 | 558 | 9.480412 | 52.90069896 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75 | 1.17e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g3432 | i0 | 95.745 | 13.0878136200717 | 47 | 0 | 8 | 2 | 513 | 558 | 100125 | 100080 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7303 | 75 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22401906 | 22401906 | PRJNA745553_S_NODE_878_length_799_cov_7.684573_g767_i0 | PRJNA745553 | 878 | 799 | 7.684573 | 61.39973827 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1086 | 0 | NTclustered | gi|2052178267|tpg|BK033163.1| | 2832643 | g767 | i0 | 93.342 | 10.2503128911139 | 736 | 47 | 92 | 2 | 65 | 799 | 11931 | 12665 | MAG TPA_asm: Caudoviricetes sp. isolate ctCv31, partial genome | blastn | 8190 | 1086 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22401923 | 22401923 | PRJNA745553_S_NODE_9758_length_387_cov_2731.152866_g9563_i0 | PRJNA745553 | 9758 | 387 | 2731.152866 | 10569.56159142 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 2.84e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g9563 | i0 | 95.652 | 19.7829457364341 | 46 | 0 | 12 | 2 | 1 | 45 | 100081 | 100125 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7656 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24950883 | 24950883 | PRJNA745553_S_NODE_3880_length_546_cov_1882.684989_g3692_i0 | PRJNA745553 | 3880 | 546 | 1882.684989 | 10279.46003994 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 4.12e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g3692 | i0 | 95.652 | 13.9194139194139 | 46 | 0 | 8 | 2 | 502 | 546 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 7600 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24950908 | 24950908 | PRJNA745553_S_NODE_5080_length_501_cov_18.768692_g4886_i0 | PRJNA745553 | 5080 | 501 | 18.768692 | 94.03114692 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 3.76e-8 | NTclustered | gi|2915033806|gb|OR222676.1| | 2832643 | g4886 | i0 | 95.652 | 25.6586826347305 | 46 | 0 | 9 | 2 | 456 | 500 | 100125 | 100081 | MAG: Caudoviricetes sp. isolate MSP0253 genomic sequence | blastn | 12855 | 73.1 | 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);;