contig_metadata
29 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283618 | 283618 | PRJNA1132896_P_NODE_2801_length_332_cov_1.077220_g2710_i0 | PRJNA1132896 | 2801 | 332 | 1.07722 | 3.5763704 | Inoviridae sp. | 2219103 | Viruses | Viruses | 562 | 1.17e-155 | NTclustered | gi|2056841409|tpg|BK044138.1| | 2219103 | g2710 | i0 | 97.289 | 11.9698795180723 | 332 | 8 | 100 | 1 | 1 | 332 | 831 | 501 | MAG TPA_asm: Inoviridae sp. isolate ctOnB2, partial genome | blastn | 3974 | 562 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 283632 | 283632 | PRJNA1132896_P_NODE_4341_length_284_cov_1.421801_g4250_i0 | PRJNA1132896 | 4341 | 284 | 1.421801 | 4.03791484 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 294 | 3.95e-75 | NTclustered | gi|2754691800|gb|PP872668.1| | 3003959 | g4250 | i0 | 85.87 | 0.971830985915493 | 276 | 39 | 97 | 0 | 9 | 284 | 5384 | 5659 | MAG: Picornavirales sp. isolate TC-PLV-112 MR233-17E/429 genomic sequence | blastn | 276 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 1031739 | 1031739 | PRJNA1132896_P_NODE_2041_length_378_cov_2.662295_g1950_i0 | PRJNA1132896 | 2041 | 378 | 2.662295 | 10.0634751 | Viruses | 10239 | Viruses | Viruses | 699 | 0 | NTclustered | gi|2293618405|gb|OP072838.1| | 38018 | g1950 | i0 | 100 | 63.9285714285714 | 378 | 0 | 100 | 0 | 1 | 378 | 33639 | 34016 | MAG: Bacteriophage sp. isolate 4063_100815, partial genome | blastn | 24165 | 699 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 2834261 | 2834261 | PRJNA1132896_P_NODE_1763_length_403_cov_2.400000_g1672_i0 | PRJNA1132896 | 1763 | 403 | 2.4 | 9.672 | Inoviridae sp. | 2219103 | Viruses | Viruses | 545 | 1.45e-150 | NTclustered | gi|2056841409|tpg|BK044138.1| | 2219103 | g1672 | i0 | 90.819 | 17.6153846153846 | 403 | 32 | 100 | 1 | 1 | 403 | 989 | 1386 | MAG TPA_asm: Inoviridae sp. isolate ctOnB2, partial genome | blastn | 7099 | 545 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2834266 | 2834266 | PRJNA1132896_P_NODE_2443_length_351_cov_1.697842_g2352_i0 | PRJNA1132896 | 2443 | 351 | 1.697842 | 5.95942542 | Bacteriophage sp. | 38018 | Viruses | Viruses | 593 | 4.389999999999998e-165 | NTclustered | gi|2293567168|gb|OP072222.1| | 38018 | g2352 | i0 | 97.151 | 56.6324786324786 | 351 | 10 | 100 | 0 | 1 | 351 | 10093 | 10443 | MAG: Bacteriophage sp. isolate 2140_32659, partial genome | blastn | 19878 | 593 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 2834310 | 2834310 | PRJNA1132896_P_NODE_7163_length_250_cov_0.870056_g7072_i0 | PRJNA1132896 | 7163 | 250 | 0.870056 | 2.17514 | Rollinsvirus ph04 | 3060671 | Viruses | Viruses | 429 | 8.949999999999998e-116 | NTclustered | gi|2438090144|ref|NC_070890.1| | 2024263 | g7072 | i0 | 97.6 | 1 | 250 | 6 | 100 | 0 | 1 | 250 | 23894 | 23645 | Agrobacterium phage Atu_ph04, complete genome | blastn | 250 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pootjesviridae | Rollinsvirus | Rollinsvirus ph04 | |||
| 4859799 | 4859799 | PRJNA1132896_P_NODE_2084_length_375_cov_1.529801_g1993_i0 | PRJNA1132896 | 2084 | 375 | 1.529801 | 5.73675375 | Viruses | 10239 | Viruses | Viruses | 693 | 0 | NTclustered | gi|2295252070|gb|OP074681.1| | 38018 | g1993 | i0 | 100 | 61 | 375 | 0 | 100 | 0 | 1 | 375 | 6027 | 5653 | MAG: Bacteriophage sp. isolate 2538_124211, partial genome | blastn | 22875 | 693 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 6661477 | 6661477 | PRJNA1132896_P_NODE_3026_length_321_cov_1.814516_g2935_i0 | PRJNA1132896 | 3026 | 321 | 1.814516 | 5.82459636 | Bacteriophage sp. | 38018 | Viruses | Viruses | 593 | 3.9899999999999986e-165 | NTclustered | gi|2295252070|gb|OP074681.1| | 38018 | g2935 | i0 | 100 | 64.5295950155763 | 321 | 0 | 100 | 0 | 1 | 321 | 34972 | 35292 | MAG: Bacteriophage sp. isolate 2538_124211, partial genome | blastn | 20714 | 593 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 6661480 | 6661480 | PRJNA1132896_P_NODE_3826_length_291_cov_1.935780_g3735_i0 | PRJNA1132896 | 3826 | 291 | 1.93578 | 5.6331198 | Theiavirus salishense | 3060737 | Viruses | Viruses | 75 | 5.75e-9 | NTclustered | gi|2500354595|ref|NC_075036.1| | 2024608 | g3735 | i0 | 86.567 | 0.230240549828179 | 67 | 9 | 23 | 0 | 42 | 108 | 14838 | 14772 | Bodo saltans virus strain NG1, complete genome | blastn | 67 | 75 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 7936613 | 7936613 | PRJNA1132896_P_NODE_1127_length_490_cov_1.103118_g1036_i0 | PRJNA1132896 | 1127 | 490 | 1.103118 | 5.4052782 | Microviridae sp. | 2202644 | Viruses | Viruses | 412 | 1.9e-110 | NTclustered | gi|2057978150|tpg|BK046697.1| | 2202644 | g1036 | i0 | 83.716 | 0.889795918367347 | 436 | 71 | 89 | 0 | 50 | 485 | 4570 | 4135 | MAG TPA_asm: Microviridae sp. isolate ctadE1, partial genome | blastn | 436 | 412 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 8684843 | 8684843 | PRJNA1132896_P_NODE_1947_length_385_cov_2.137821_g1856_i0 | PRJNA1132896 | 1947 | 385 | 2.137821 | 8.23061085 | Viruses | 10239 | Viruses | Viruses | 706 | 0 | NTclustered | gi|2289939345|gb|OP030745.1| | 38018 | g1856 | i0 | 99.74 | 60.1064935064935 | 385 | 1 | 100 | 0 | 1 | 385 | 28554 | 28170 | MAG: Bacteriophage sp. isolate 0114_71899, partial genome | blastn | 23141 | 706 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 9211594 | 9211594 | PRJNA1132896_P_NODE_10288_length_241_cov_0.916667_g10197_i0 | PRJNA1132896 | 10288 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.06e-120 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10197 | i0 | 100 | 0.995850622406639 | 240 | 0 | 99 | 0 | 1 | 240 | 9511 | 9750 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 240 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10487111 | 10487111 | PRJNA1132896_P_NODE_2069_length_376_cov_2.330033_g1978_i0 | PRJNA1132896 | 2069 | 376 | 2.330033 | 8.76092408 | Myoviridae sp. ct5xX4 | 2826616 | Viruses | Viruses | 364 | 4.049999999999999e-96 | NTclustered | gi|2051144302|tpg|BK015793.1| | 2826616 | g1978 | i0 | 99.5 | 79.9840425531915 | 200 | 1 | 53 | 0 | 1 | 200 | 20191 | 19992 | MAG TPA_asm: Myoviridae sp. ct5xX4, partial genome | blastn | 30074 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ct5xX4 | |||||
| 10487199 | 10487199 | PRJNA1132896_P_NODE_9549_length_243_cov_0.905882_g9458_i0 | PRJNA1132896 | 9549 | 243 | 0.905882 | 2.20129326 | uncultured virus | 340016 | Viruses | Viruses | 296 | 9.16e-76 | NTclustered | gi|291327608|gb|GU735101.1| | 340016 | g9458 | i0 | 88.477 | 1.79012345679012 | 243 | 26 | 99 | 2 | 2 | 243 | 2725 | 2966 | Uncultured virus contig002 genomic sequence | blastn | 435 | 296 | 1 | Viruses | uncultured virus | ||||||||
| 13037333 | 13037333 | PRJNA1132896_P_NODE_4291_length_285_cov_1.146226_g4200_i0 | PRJNA1132896 | 4291 | 285 | 1.146226 | 3.2667441 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 494 | 3.64e-135 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g4200 | i0 | 97.895 | 48.3649122807018 | 285 | 6 | 100 | 0 | 1 | 285 | 11703 | 11987 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 13784 | 494 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13785113 | 13785113 | PRJNA1132896_P_NODE_6671_length_251_cov_2.140449_g6580_i0 | PRJNA1132896 | 6671 | 251 | 2.140449 | 5.37252699 | Viruses | 10239 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|2293597007|gb|OP072644.1| | 38018 | g6580 | i0 | 99.203 | 37.6812749003984 | 251 | 2 | 100 | 0 | 1 | 251 | 21351 | 21101 | MAG: Bacteriophage sp. isolate 3467_68914, complete genome | blastn | 9458 | 453 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 15586578 | 15586578 | PRJNA1132896_P_NODE_9033_length_244_cov_1.538012_g8942_i0 | PRJNA1132896 | 9033 | 244 | 1.538012 | 3.75274928 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 416 | 6.769999999999999e-112 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g8942 | i0 | 97.531 | 10.9590163934426 | 243 | 6 | 99 | 0 | 1 | 243 | 14498 | 14740 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 2674 | 416 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16334184 | 16334184 | PRJNA1132896_P_NODE_4653_length_280_cov_1.246377_g4562_i0 | PRJNA1132896 | 4653 | 280 | 1.246377 | 3.4898556 | Viruses | 10239 | Viruses | Viruses | 501 | 2.13e-137 | NTclustered | gi|2293618405|gb|OP072838.1| | 38018 | g4562 | i0 | 98.929 | 59.2642857142857 | 280 | 3 | 100 | 0 | 1 | 280 | 35044 | 34765 | MAG: Bacteriophage sp. isolate 4063_100815, partial genome | blastn | 16594 | 501 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 16860805 | 16860805 | PRJNA1132896_P_NODE_3274_length_311_cov_1.294118_g3183_i0 | PRJNA1132896 | 3274 | 311 | 1.294118 | 4.02470698 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 575 | 1.3899999999999995e-159 | NTclustered | gi|2060029275|tpg|BK027293.1| | 2832643 | g3183 | i0 | 100 | 10.491961414791 | 311 | 0 | 100 | 0 | 1 | 311 | 12413 | 12103 | MAG TPA_asm: Caudoviricetes sp. isolate ctENK15, partial genome | blastn | 3263 | 575 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16860822 | 16860822 | PRJNA1132896_P_NODE_5474_length_268_cov_1.251282_g5383_i0 | PRJNA1132896 | 5474 | 268 | 1.251282 | 3.35343576 | Microviridae sp. | 2202644 | Viruses | Viruses | 425 | 1.25e-114 | NTclustered | gi|2057978150|tpg|BK046697.1| | 2202644 | g5383 | i0 | 95.489 | 3.97761194029851 | 266 | 12 | 99 | 0 | 1 | 266 | 569 | 304 | MAG TPA_asm: Microviridae sp. isolate ctadE1, partial genome | blastn | 1066 | 425 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 16860827 | 16860827 | PRJNA1132896_P_NODE_5634_length_265_cov_2.562500_g5543_i0 | PRJNA1132896 | 5634 | 265 | 2.5625 | 6.790625 | uncultured virus | 340016 | Viruses | Viruses | 320 | 6.01e-83 | NTclustered | gi|291327616|gb|GU735109.1| | 340016 | g5543 | i0 | 87.218 | 1.00377358490566 | 266 | 32 | 100 | 2 | 1 | 265 | 1456 | 1720 | Uncultured virus contig012 genomic sequence | blastn | 266 | 320 | 1 | Viruses | uncultured virus | ||||||||
| 18135354 | 18135354 | PRJNA1132896_P_NODE_10175_length_241_cov_0.916667_g10084_i0 | PRJNA1132896 | 10175 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 1.88e-102 | NTclustered | gi|2052901204|tpg|BK017687.1| | 2832643 | g10084 | i0 | 95.436 | 1 | 241 | 11 | 100 | 0 | 1 | 241 | 9807 | 10047 | MAG TPA_asm: Caudoviricetes sp. isolate ctXTf36, partial genome | blastn | 241 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18135415 | 18135415 | PRJNA1132896_P_NODE_7295_length_250_cov_0.870056_g7204_i0 | PRJNA1132896 | 7295 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 1.6e-68 | NTclustered | gi|2052963916|tpg|BK030275.1| | 2832643 | g7204 | i0 | 96.914 | 34.956 | 162 | 5 | 65 | 0 | 1 | 162 | 17349 | 17510 | MAG TPA_asm: Caudoviricetes sp. isolate ctP9N3, partial genome | blastn | 8739 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18135437 | 18135437 | PRJNA1132896_P_NODE_8955_length_245_cov_0.895349_g8864_i0 | PRJNA1132896 | 8955 | 245 | 0.895349 | 2.19360505 | Bacteriophage sp. | 38018 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2289963407|gb|OP031037.1| | 38018 | g8864 | i0 | 99.592 | 66.9632653061225 | 245 | 1 | 100 | 0 | 1 | 245 | 19868 | 19624 | MAG: Bacteriophage sp. isolate 1748_94912, partial genome | blastn | 16406 | 448 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 19409569 | 19409569 | PRJNA1132896_P_NODE_8796_length_245_cov_0.895349_g8705_i0 | PRJNA1132896 | 8796 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2057080427|tpg|BK037909.1| | 2832643 | g8705 | i0 | 100 | 68.8530612244898 | 245 | 0 | 100 | 0 | 1 | 245 | 32289 | 32045 | MAG TPA_asm: Caudoviricetes sp. isolate ctslE2, partial genome | blastn | 16869 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20685022 | 20685022 | PRJNA1132896_P_NODE_5237_length_271_cov_1.888889_g5146_i0 | PRJNA1132896 | 5237 | 271 | 1.888889 | 5.11888919 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 135 | 2.4e-27 | NTclustered | gi|2754691800|gb|PP872668.1| | 3003959 | g5146 | i0 | 81.765 | 0.627306273062731 | 170 | 24 | 62 | 6 | 1 | 168 | 112 | 276 | MAG: Picornavirales sp. isolate TC-PLV-112 MR233-17E/429 genomic sequence | blastn | 170 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 21433663 | 21433663 | PRJNA1132896_P_NODE_5497_length_267_cov_1.896907_g5406_i0 | PRJNA1132896 | 5497 | 267 | 1.896907 | 5.06474169 | Viruses | 10239 | Viruses | Viruses | 494 | 3.38e-135 | NTclustered | gi|2057172601|tpg|BK058858.1| | 38018 | g5406 | i0 | 100 | 16.9026217228464 | 267 | 0 | 100 | 0 | 1 | 267 | 23570 | 23836 | MAG TPA_asm: Bacteriophage sp. isolate ctTBt6, partial genome | blastn | 4513 | 494 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 21433678 | 21433678 | PRJNA1132896_P_NODE_7997_length_248_cov_0.874286_g7906_i0 | PRJNA1132896 | 7997 | 248 | 0.874286 | 2.16822928 | root | 1 | Root_unresolved | Root_unresolved | 442 | 1.1399999999999995e-119 | NTclustered | gi|2294898160|gb|OP076218.1| | 38018 | g7906 | i0 | 98.79 | 2.84677419354839 | 248 | 3 | 100 | 0 | 1 | 248 | 42651 | 42404 | MAG: Bacteriophage sp. isolate 4302_31796, partial genome | blastn | 706 | 442 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 24509600 | 24509600 | PRJNA1132896_P_NODE_7320_length_250_cov_0.870056_g7229_i0 | PRJNA1132896 | 7320 | 250 | 0.870056 | 2.17514 | uncultured virus | 340016 | Viruses | Viruses | 89.8 | 1.73e-13 | NTclustered | gi|385764243|gb|JQ794210.1| | 340016 | g7229 | i0 | 85.714 | 0.336 | 84 | 12 | 34 | 0 | 3 | 86 | 321 | 238 | Uncultured virus clone M1-Oct-2009-R-Contig-52 genomic sequence | blastn | 84 | 89.8 | 1 | Viruses | uncultured virus |
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);;