contig_metadata
24 rows where bioproject = "PRJNA661142" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 628159 | 628159 | PRJNA661142_P_NODE_6101_length_311_cov_3.236641_g6036_i0 | PRJNA661142 | 6101 | 311 | 3.236641 | 10.06595351 | Salmonella phage Arash | 3038319 | Viruses | Viruses | 52.8 | 0.029 | NTclustered | gi|2496427113|gb|OQ632216.1| | 3038319 | g6036 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 70 | 97 | 81054 | 81081 | Salmonella phage Arash, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Salmonella phage Arash | |||||
| 1904321 | 1904321 | PRJNA661142_P_NODE_9042_length_241_cov_0.916667_g8977_i0 | PRJNA661142 | 9042 | 241 | 0.916667 | 2.20916747 | Pseudomonas phage ZRG1 | 3032262 | Viruses | Viruses | 171 | 5.74e-38 | NTclustered | gi|2512630189|gb|OQ504961.1| | 3032262 | g8977 | i0 | 79.498 | 0.991701244813278 | 239 | 49 | 99 | 0 | 3 | 241 | 51873 | 51635 | Pseudomonas phage ZRG1, complete genome | blastn | 239 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage ZRG1 | |||||
| 1904325 | 1904325 | PRJNA661142_P_NODE_9682_length_223_cov_1.465517_g9617_i0 | PRJNA661142 | 9682 | 223 | 1.465517 | 3.26810291 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 379 | 7.999999999999999e-101 | NTclustered | gi|2915008907|gb|OR222427.1| | 2832643 | g9617 | i0 | 97.309 | 1 | 223 | 6 | 100 | 0 | 1 | 223 | 50858 | 51080 | MAG: Caudoviricetes sp. isolate MSP0968 genomic sequence | blastn | 223 | 379 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4455999 | 4455999 | PRJNA661142_P_NODE_1504_length_615_cov_69.549470_g1444_i0 | PRJNA661142 | 1504 | 615 | 69.54947 | 427.7292405 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1014 | 0 | NTclustered | gi|2915047649|gb|OR222810.1| | 2832643 | g1444 | i0 | 96.423 | 3 | 615 | 22 | 100 | 0 | 1 | 615 | 61885 | 61271 | MAG: Caudoviricetes sp. isolate MSP0547 genomic sequence | blastn | 1845 | 1014 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4456060 | 4456060 | PRJNA661142_P_NODE_6944_length_290_cov_1.692946_g6879_i0 | PRJNA661142 | 6944 | 290 | 1.692946 | 4.9095434 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 475 | 1.3399999999999997e-129 | NTclustered | gi|2915008907|gb|OR222427.1| | 2832643 | g6879 | i0 | 96.207 | 1.28965517241379 | 290 | 11 | 100 | 0 | 1 | 290 | 13504 | 13215 | MAG: Caudoviricetes sp. isolate MSP0968 genomic sequence | blastn | 374 | 475 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4456088 | 4456088 | PRJNA661142_P_NODE_9184_length_237_cov_1.085106_g9119_i0 | PRJNA661142 | 9184 | 237 | 1.085106 | 2.57170122 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 433 | 6.5e-117 | NTclustered | gi|2914951517|gb|OR221910.1| | 2832643 | g9119 | i0 | 99.578 | 3 | 237 | 1 | 100 | 0 | 1 | 237 | 46305 | 46541 | MAG: Caudoviricetes sp. isolate MSP0216 genomic sequence | blastn | 711 | 433 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5731528 | 5731528 | PRJNA661142_P_NODE_10285_length_207_cov_0.848101_g10220_i0 | PRJNA661142 | 10285 | 207 | 0.848101 | 1.75556907 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 355 | 1.23e-93 | NTclustered | gi|2915008907|gb|OR222427.1| | 2832643 | g10220 | i0 | 97.585 | 1.98067632850242 | 207 | 5 | 100 | 0 | 1 | 207 | 20632 | 20838 | MAG: Caudoviricetes sp. isolate MSP0968 genomic sequence | blastn | 410 | 355 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6265672 | 6265672 | PRJNA661142_P_NODE_8405_length_256_cov_1.251208_g8340_i0 | PRJNA661142 | 8405 | 256 | 1.251208 | 3.20309248 | root | 1 | Root_unresolved | Root_unresolved | 418 | 1.9899999999999994e-112 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g8340 | i0 | 99.563 | 89.453125 | 229 | 1 | 89 | 0 | 1 | 229 | 14045 | 13817 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 22900 | 418 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 9556636 | 9556636 | PRJNA661142_P_NODE_408_length_969_cov_65.246739_g372_i0 | PRJNA661142 | 408 | 969 | 65.246739 | 632.24090091 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 708 | 0 | NTclustered | gi|2915041439|gb|OR222744.1| | 2832643 | g372 | i0 | 80.844 | 2.40557275541796 | 924 | 158 | 94 | 16 | 48 | 962 | 56535 | 55622 | MAG: Caudoviricetes sp. isolate MSP0616 genomic sequence | blastn | 2331 | 708 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13382240 | 13382240 | PRJNA661142_P_NODE_7211_length_283_cov_13.504274_g7146_i0 | PRJNA661142 | 7211 | 283 | 13.504274 | 38.21709542 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.7399999999999985e-124 | NTclustered | gi|2915047649|gb|OR222810.1| | 2832643 | g7146 | i0 | 95.76 | 3 | 283 | 12 | 100 | 0 | 1 | 283 | 61854 | 62136 | MAG: Caudoviricetes sp. isolate MSP0547 genomic sequence | blastn | 849 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14657047 | 14657047 | PRJNA661142_P_NODE_10232_length_208_cov_1.603774_g10167_i0 | PRJNA661142 | 10232 | 208 | 1.603774 | 3.33584992 | Pseudomonas phage ZRG1 | 3032262 | Viruses | Viruses | 125 | 2.8099999999999997e-35 | NR | WID42129.1 | 3032262 | g10167 | i0 | 88.2 | 0.980769230769231 | 68 | 8 | 98.1 | 0 | 204 | 1 | 12 | 79 | WID42129.1 baseplate assembly protein W [Pseudomonas phage ZRG1] | diamond | 204 | 125 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage ZRG1 | |||||
| 17206182 | 17206182 | PRJNA661142_P_NODE_7514_length_277_cov_1.342105_g7449_i0 | PRJNA661142 | 7514 | 277 | 1.342105 | 3.71763085 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.6399999999999999e-133 | NTclustered | gi|2915008907|gb|OR222427.1| | 2832643 | g7449 | i0 | 98.551 | 0.996389891696751 | 276 | 4 | 99 | 0 | 1 | 276 | 41339 | 41064 | MAG: Caudoviricetes sp. isolate MSP0968 genomic sequence | blastn | 276 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17206199 | 17206199 | PRJNA661142_P_NODE_9314_length_233_cov_1.516304_g9249_i0 | PRJNA661142 | 9314 | 233 | 1.516304 | 3.53298832 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 322 | 1.44e-83 | NTclustered | gi|2915047649|gb|OR222810.1| | 2832643 | g9249 | i0 | 95.098 | 2.66094420600858 | 204 | 10 | 88 | 0 | 30 | 233 | 60882 | 61085 | MAG: Caudoviricetes sp. isolate MSP0547 genomic sequence | blastn | 620 | 322 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18480469 | 18480469 | PRJNA661142_P_NODE_11475_length_167_cov_0.864407_g11410_i0 | PRJNA661142 | 11475 | 167 | 0.864407 | 1.44355969 | Bacteriophage sp. | 38018 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2294106312|gb|OP073255.1| | 38018 | g11410 | i0 | 96.97 | 0.197604790419162 | 33 | 1 | 20 | 0 | 47 | 79 | 12185 | 12217 | MAG: Bacteriophage sp. isolate 0467_37095, partial genome | blastn | 33 | 56.5 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 19755057 | 19755057 | PRJNA661142_P_NODE_12616_length_161_cov_1.366071_g12551_i0 | PRJNA661142 | 12616 | 161 | 1.366071 | 2.19937431 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.57e-71 | NTclustered | gi|2914962068|gb|OR221989.1| | 2832643 | g12551 | i0 | 98.137 | 7.37267080745342 | 161 | 3 | 100 | 0 | 1 | 161 | 87351 | 87191 | MAG: Caudoviricetes sp. isolate MSP0135 genomic sequence | blastn | 1187 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19755146 | 19755146 | PRJNA661142_P_NODE_9816_length_220_cov_0.894737_g9751_i0 | PRJNA661142 | 9816 | 220 | 0.894737 | 1.9684214 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 222 | 1.4e-53 | NTclustered | gi|2914925236|gb|OR221463.1| | 2832643 | g9751 | i0 | 96.296 | 3.76818181818182 | 135 | 5 | 61 | 0 | 1 | 135 | 4776 | 4910 | MAG: Caudoviricetes sp. isolate MSP1616 genomic sequence | blastn | 829 | 222 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21030710 | 21030710 | PRJNA661142_P_NODE_837_length_766_cov_56.652720_g785_i0 | PRJNA661142 | 837 | 766 | 56.65272 | 433.9598352 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1216 | 0 | NTclustered | gi|2915041439|gb|OR222744.1| | 2832643 | g785 | i0 | 95.3 | 3 | 766 | 36 | 100 | 0 | 1 | 766 | 60889 | 60124 | MAG: Caudoviricetes sp. isolate MSP0616 genomic sequence | blastn | 2298 | 1216 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22839195 | 22839195 | PRJNA661142_P_NODE_4818_length_354_cov_5.783607_g4753_i0 | PRJNA661142 | 4818 | 354 | 5.783607 | 20.47396878 | Viruses | 10239 | Viruses | Viruses | 592 | 1.5999999999999996e-164 | NTclustered | gi|2177952863|gb|OL452263.1| | 2900479 | g4753 | i0 | 99.387 | 10.3559322033898 | 326 | 2 | 92 | 0 | 1 | 326 | 5951 | 6276 | MAG: Brine shrimp chuvirus 1 isolate CHN/15, complete genome | blastn | 3666 | 592 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | brine shrimp chuvirus 1 | |||
| 23580846 | 23580846 | PRJNA661142_P_NODE_8919_length_244_cov_0.994872_g8854_i0 | PRJNA661142 | 8919 | 244 | 0.994872 | 2.42748768 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 300 | 7.12e-77 | NTclustered | gi|2245489534|gb|ON163861.1| | 2809572 | g8854 | i0 | 88.889 | 0.995901639344262 | 243 | 27 | 99 | 0 | 2 | 244 | 650 | 892 | MAG: Mitoviridae sp. isolate 25-k141_218903 RNA dependent RNA polymerase gene, partial cds | blastn | 243 | 300 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 26701398 | 26701398 | PRJNA661142_P_NODE_11901_length_165_cov_0.879310_g11836_i0 | PRJNA661142 | 11901 | 165 | 0.87931 | 1.4508615 | Myoviridae sp. ctThM1 | 2656730 | Viruses | Viruses | 64.3 | 3.03e-10 | NR | QGH72520.1 | 2656730 | g11836 | i0 | 76.3 | 0.690909090909091 | 38 | 9 | 69.1 | 0 | 3 | 116 | 379 | 416 | QGH72520.1 MAG: DNA polymerase I [Myoviridae sp. ctThM1] | diamond | 114 | 64.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ctThM1 | |||||
| 29291877 | 29291877 | PRJNA661142_P_NODE_11409_length_167_cov_0.864407_g11344_i0 | PRJNA661142 | 11409 | 167 | 0.864407 | 1.44355969 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 45.4 | 4.51e-4 | NR | CAB5214299.1 | 2100421 | g11344 | i0 | 48.9 | 1.45508982035928 | 45 | 23 | 80.8 | 0 | 165 | 31 | 76 | 120 | CAB5214299.1 hypothetical protein UFOVP190_46 [uncultured Caudovirales phage] | diamond | 243 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29355184 | 29355184 | PRJNA661142_P_NODE_3709_length_408_cov_1.136490_g3645_i0 | PRJNA661142 | 3709 | 408 | 1.13649 | 4.6368792 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 72.8 | 6.97e-12 | NR | XOS04929.1 | 2832643 | g3645 | i0 | 41.1 | 0.786764705882353 | 107 | 54 | 72.1 | 3 | 33 | 326 | 3 | 109 | XOS04929.1 MAG: hypothetical protein MSP1124_12 [Caudoviricetes sp.] | diamond | 321 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29796975 | 29796975 | PRJNA661142_P_NODE_4471_length_368_cov_10.050157_g4406_i0 | PRJNA661142 | 4471 | 368 | 10.050157 | 36.98457776 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 136 | 1.0299999999999998e-37 | NR | XOS67955.1 | 2832643 | g4406 | i0 | 56.9 | 1.00271739130435 | 123 | 49 | 97.8 | 3 | 361 | 2 | 73 | 194 | XOS67955.1 MAG: p53 [Caudoviricetes sp.] | diamond | 369 | 136 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30744919 | 30744919 | PRJNA661142_P_NODE_10534_length_197_cov_1.722973_g10469_i0 | PRJNA661142 | 10534 | 197 | 1.722973 | 3.39425681 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 8.05e-22 | NR | DAW55533.1 | 2832643 | g10469 | i0 | 70.8 | 0.989847715736041 | 65 | 19 | 99 | 0 | 3 | 197 | 105 | 169 | DAW55533.1 MAG TPA: S adenosylmethionine synthase [Caudoviricetes sp.] | diamond | 195 | 95.5 | 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);;