contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1710175 | 1710175 | PRJNA438687_S_NODE_4022_length_221_cov_38.709677_g3932_i0 | PRJNA438687 | 4022 | 221 | 38.709677 | 85.54838617 | Chronazork virus | 3129863 | Viruses | Viruses | 172 | 1.44e-38 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g3932 | i0 | 83.333 | 26.683257918552 | 198 | 22 | 86 | 6 | 1 | 189 | 120 | 315 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 5897 | 172 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 1710189 | 1710189 | PRJNA438687_S_NODE_4622_length_206_cov_13.017544_g4532_i0 | PRJNA438687 | 4622 | 206 | 13.017544 | 26.81614064 | Chronazork virus | 3129863 | Viruses | Viruses | 91.6 | 3.82e-14 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g4532 | i0 | 90.141 | 0.344660194174757 | 71 | 5 | 33 | 2 | 121 | 189 | 167 | 97 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 71 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 2985967 | 2985967 | PRJNA438687_S_NODE_2783_length_267_cov_29.038793_g2693_i0 | PRJNA438687 | 2783 | 267 | 29.038793 | 77.53357731 | Chronazork virus | 3129863 | Viruses | Viruses | 231 | 2.9199999999999996e-56 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g2693 | i0 | 86.364 | 24.314606741573 | 220 | 21 | 79 | 6 | 24 | 235 | 97 | 315 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 6492 | 231 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 2986001 | 2986001 | PRJNA438687_S_NODE_4223_length_216_cov_1.220994_g4133_i0 | PRJNA438687 | 4223 | 216 | 1.220994 | 2.63734704 | Chronozanb virus | 3129714 | Viruses | Viruses | 191 | 3.8700000000000003e-44 | NTclustered | gi|2717318279|gb|PP172162.1| | 3129714 | g4133 | i0 | 95.798 | 0.550925925925926 | 119 | 4 | 55 | 1 | 54 | 171 | 3631 | 3749 | MAG: Chronozanb virus isolate CN1A_k141_10639 genomic sequence | blastn | 119 | 191 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Chronozanb virus | |||
| 2986026 | 2986026 | PRJNA438687_S_NODE_5663_length_185_cov_32.860000_g5573_i0 | PRJNA438687 | 5663 | 185 | 32.86 | 60.791 | Chronaparn virus | 3129907 | Viruses | Viruses | 104 | 4.3e-18 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g5573 | i0 | 93.056 | 28.6216216216216 | 72 | 4 | 38 | 1 | 1 | 71 | 3672 | 3743 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5295 | 104 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 2986033 | 2986033 | PRJNA438687_S_NODE_6043_length_178_cov_6.741259_g5953_i0 | PRJNA438687 | 6043 | 178 | 6.741259 | 11.99944102 | Sopidub virus | 3131684 | Viruses | Viruses | 100 | 5.3e-17 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g5953 | i0 | 90.789 | 1.52808988764045 | 76 | 6 | 43 | 1 | 5 | 80 | 2212 | 2138 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 272 | 100 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 2986072 | 2986072 | PRJNA438687_S_NODE_8123_length_151_cov_2.086207_g8033_i0 | PRJNA438687 | 8123 | 151 | 2.086207 | 3.15017257 | Sobemovirus sp. | 2809869 | Viruses | Viruses | 182 | 1.51e-41 | NTclustered | gi|2171144996|gb|MZ218234.1| | 2809869 | g8033 | i0 | 94.118 | 78.1523178807947 | 119 | 7 | 79 | 0 | 33 | 151 | 4524 | 4406 | MAG: Sobemovirus sp. isolate R90-k141_286143 genomic sequence | blastn | 11801 | 182 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus sp. | ||
| 5538983 | 5538983 | PRJNA438687_S_NODE_3245_length_248_cov_2.751174_g3155_i0 | PRJNA438687 | 3245 | 248 | 2.751174 | 6.82291152 | Sobemovirus CNMOV | 3432495 | Viruses | Viruses | 451 | 1.89e-122 | NTclustered | gi|2575892443|gb|OR238492.1| | 2931826 | g3155 | i0 | 99.595 | 7.96774193548387 | 247 | 1 | 99 | 0 | 2 | 248 | 608 | 362 | Cynosurus mottle virus isolate Schladen, complete genome | blastn | 1976 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CNMOV | ||
| 6813130 | 6813130 | PRJNA438687_S_NODE_6686_length_169_cov_1.365672_g6596_i0 | PRJNA438687 | 6686 | 169 | 1.365672 | 2.30798568 | Sopidub virus | 3131684 | Viruses | Viruses | 80.5 | 6.47e-11 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g6596 | i0 | 87.5 | 0.958579881656805 | 72 | 5 | 40 | 4 | 95 | 162 | 2139 | 2210 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 162 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 8088466 | 8088466 | PRJNA438687_S_NODE_1807_length_316_cov_29.733096_g1717_i0 | PRJNA438687 | 1807 | 316 | 29.733096 | 93.95658336 | Chronaparn virus | 3129907 | Viruses | Viruses | 115 | 3.72e-21 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g1717 | i0 | 91.765 | 16.8354430379747 | 85 | 3 | 26 | 3 | 236 | 316 | 3756 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5320 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 9363300 | 9363300 | PRJNA438687_S_NODE_3148_length_252_cov_4.152074_g3058_i0 | PRJNA438687 | 3148 | 252 | 4.152074 | 10.46322648 | Chronozanb virus | 3129714 | Viruses | Viruses | 161 | 3.639999999999999e-35 | NTclustered | gi|2717318279|gb|PP172162.1| | 3129714 | g3058 | i0 | 90.323 | 0.837301587301587 | 124 | 11 | 49 | 1 | 79 | 201 | 3626 | 3749 | MAG: Chronozanb virus isolate CN1A_k141_10639 genomic sequence | blastn | 211 | 161 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Chronozanb virus | |||
| 9363376 | 9363376 | PRJNA438687_S_NODE_6448_length_172_cov_3.620438_g6358_i0 | PRJNA438687 | 6448 | 172 | 3.620438 | 6.22715336 | Mute swan feces associated sobemovirus 1 | 2832221 | Viruses | Viruses | 313 | 5.989999999999998e-81 | NTclustered | gi|2032489095|gb|MW588173.1| | 2832221 | g6358 | i0 | 99.419 | 10.8662790697674 | 172 | 1 | 100 | 0 | 1 | 172 | 2147 | 1976 | Mute swan feces associated sobemovirus 1 strain Abbotsbury/A/2016 polyprotein P2a, polyprotein 2b, and capsid protein genes, complete cds | blastn | 1869 | 313 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Mute swan feces associated sobemovirus 1 | ||
| 10639118 | 10639118 | PRJNA438687_S_NODE_1009_length_378_cov_1.618076_g920_i0 | PRJNA438687 | 1009 | 378 | 1.618076 | 6.11632728 | Mute swan feces associated sobemovirus 1 | 2832221 | Viruses | Viruses | 671 | 0 | NTclustered | gi|2032489095|gb|MW588173.1| | 2832221 | g920 | i0 | 98.681 | 8.02116402116402 | 379 | 4 | 100 | 1 | 1 | 378 | 1505 | 1127 | Mute swan feces associated sobemovirus 1 strain Abbotsbury/A/2016 polyprotein P2a, polyprotein 2b, and capsid protein genes, complete cds | blastn | 3032 | 671 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Mute swan feces associated sobemovirus 1 | ||
| 10639143 | 10639143 | PRJNA438687_S_NODE_1969_length_307_cov_35.632353_g1879_i0 | PRJNA438687 | 1969 | 307 | 35.632353 | 109.39132371 | Chronazork virus | 3129863 | Viruses | Viruses | 191 | 5.82e-44 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g1879 | i0 | 83.486 | 23.214983713355 | 218 | 22 | 67 | 10 | 33 | 238 | 315 | 100 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 7127 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 13188961 | 13188961 | PRJNA438687_S_NODE_2611_length_276_cov_1.788382_g2521_i0 | PRJNA438687 | 2611 | 276 | 1.788382 | 4.93593432 | Chrocagosk virus | 3129397 | Viruses | Viruses | 315 | 2.9299999999999993e-81 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g2521 | i0 | 87.319 | 56.9528985507246 | 276 | 34 | 100 | 1 | 1 | 276 | 46 | 320 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 15719 | 315 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 13188994 | 13188994 | PRJNA438687_S_NODE_4131_length_218_cov_4.535519_g4041_i0 | PRJNA438687 | 4131 | 218 | 4.535519 | 9.88743142 | Sobemovirus CNMOV | 3432495 | Viruses | Viruses | 381 | 2.1599999999999994e-101 | NTclustered | gi|2575892419|gb|OR238488.1| | 2931826 | g4041 | i0 | 98.174 | 10.894495412844 | 219 | 3 | 100 | 1 | 1 | 218 | 2477 | 2695 | Cynosurus mottle virus isolate CV-104, complete genome | blastn | 2375 | 381 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CNMOV | ||
| 15737987 | 15737987 | PRJNA438687_S_NODE_4913_length_200_cov_29.593939_g4823_i0 | PRJNA438687 | 4913 | 200 | 29.593939 | 59.187878 | Chronaparn virus | 3129907 | Viruses | Viruses | 117 | 6.0700000000000005e-22 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g4823 | i0 | 95.833 | 27.215 | 72 | 3 | 36 | 0 | 129 | 200 | 3743 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5443 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 18286893 | 18286893 | PRJNA438687_S_NODE_1535_length_331_cov_220.554054_g1445_i0 | PRJNA438687 | 1535 | 331 | 220.554054 | 730.03391874 | Sopozig virus | 3131662 | Viruses | Viruses | 503 | 7.16e-138 | NTclustered | gi|2717323079|gb|PP173963.1| | 3131662 | g1445 | i0 | 97.297 | 257.078549848943 | 296 | 8 | 89 | 0 | 17 | 312 | 588 | 293 | MAG: Sopozig virus isolate SP1B_k141_130621 genomic sequence | blastn | 85093 | 503 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Sopozig virus | |||
| 18942709 | 18942709 | PRJNA438687_S_NODE_7795_length_155_cov_1.333333_g7705_i0 | PRJNA438687 | 7795 | 155 | 1.333333 | 2.06666615 | Sobemovirus | 12137 | Viruses | Viruses | 174 | 2.61e-39 | NTclustered | gi|2562620724|gb|OQ974933.1| | 40979 | g7705 | i0 | 91.339 | 11.1354838709677 | 127 | 11 | 82 | 0 | 1 | 127 | 1843 | 1969 | Cocksfoot mottle virus isolate CfMV_Est, complete genome | blastn | 1726 | 174 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus CFMV | ||
| 19561223 | 19561223 | PRJNA438687_S_NODE_4156_length_217_cov_31.615385_g4066_i0 | PRJNA438687 | 4156 | 217 | 31.615385 | 68.60538545 | Chronaparn virus | 3129907 | Viruses | Viruses | 122 | 1.4399999999999994e-23 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g4066 | i0 | 89.796 | 26.2119815668203 | 98 | 6 | 43 | 3 | 124 | 217 | 3769 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5688 | 122 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 19561281 | 19561281 | PRJNA438687_S_NODE_7296_length_161_cov_1.190476_g7206_i0 | PRJNA438687 | 7296 | 161 | 1.190476 | 1.91666636 | Ripasluj virus | 3131271 | Viruses | Viruses | 176 | 7.609999999999999e-40 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g7206 | i0 | 87.097 | 2.57142857142857 | 155 | 20 | 96 | 0 | 1 | 155 | 59 | 213 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 414 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj virus | |||||
| 23387540 | 23387540 | PRJNA438687_S_NODE_5799_length_183_cov_4.317568_g5709_i0 | PRJNA438687 | 5799 | 183 | 4.317568 | 7.90114944 | Ripasluj virus | 3131271 | Viruses | Viruses | 163 | 6.899999999999999e-36 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g5709 | i0 | 83.333 | 47.1147540983607 | 180 | 26 | 98 | 4 | 4 | 183 | 224 | 49 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 8622 | 163 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj 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);;