contig_metadata
21 rows where bioproject = "PRJNA597223" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 568958 | 568958 | PRJNA597223_P_NODE_28261_length_287_cov_2.730159_g26415_i0 | PRJNA597223 | 28261 | 287 | 2.730159 | 7.83555633 | Sopafab virus | 3131770 | Viruses | Viruses | 440 | 4.849999999999998e-119 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g26415 | i0 | 96.958 | 87.0348432055749 | 263 | 6 | 91 | 2 | 24 | 285 | 4 | 265 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 24979 | 440 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 569574 | 569574 | PRJNA597223_P_NODE_84381_length_153_cov_1.796610_g82535_i0 | PRJNA597223 | 84381 | 153 | 1.79661 | 2.7488133 | Erysiphe necator associated ourmia-like virus 87 | 2741867 | Viruses | Viruses | 202 | 1.1799999999999998e-47 | NTclustered | gi|1848976707|gb|MN611615.1| | 2741867 | g82535 | i0 | 90.728 | 1.97385620915033 | 151 | 14 | 99 | 0 | 1 | 151 | 1638 | 1788 | Erysiphe necator associated ourmia-like virus 87 isolate PMS5_114, complete genome | blastn | 302 | 202 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 87 | ||
| 2416053 | 2416053 | PRJNA597223_P_NODE_40422_length_225_cov_1.189474_g38576_i0 | PRJNA597223 | 40422 | 225 | 1.189474 | 2.6763165 | Ourmiavirus | 186783 | Viruses | Viruses | 254 | 5.11e-63 | NTclustered | gi|1848976557|gb|MN611540.1| | 2741780 | g38576 | i0 | 87.225 | 8.07555555555555 | 227 | 24 | 99 | 5 | 1 | 223 | 84 | 309 | Erysiphe necator associated ourmia-like virus 12 isolate PMS1_143, complete genome | blastn | 1817 | 254 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 12 | ||
| 5672742 | 5672742 | PRJNA597223_P_NODE_28625_length_284_cov_11.064257_g26779_i0 | PRJNA597223 | 28625 | 284 | 11.064257 | 31.42248988 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 76.8 | 1.56e-9 | NTclustered | gi|2183471790|gb|MZ680316.1| | 2583949 | g26779 | i0 | 87.879 | 3.67253521126761 | 66 | 7 | 23 | 1 | 1 | 65 | 3334 | 3269 | MAG: Narnaviridae sp. isolate 84b-k141_9447 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 1043 | 76.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 19695939 | 19695939 | PRJNA597223_P_NODE_79096_length_159_cov_1.137097_g77250_i0 | PRJNA597223 | 79096 | 159 | 1.137097 | 1.80798423 | Lagenaria siceraria associated mitovirus | 2867096 | Viruses | Viruses | 281 | 1.54e-71 | NTclustered | gi|2079774884|gb|MZ032029.1| | 2867096 | g77250 | i0 | 98.734 | 0.993710691823899 | 158 | 2 | 99 | 0 | 1 | 158 | 488 | 331 | Lagenaria siceraria associated mitovirus strain 1, complete genome | blastn | 158 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Lagenaria siceraria associated mitovirus | ||
| 27553504 | 27553504 | PRJNA597223_P_NODE_44124_length_212_cov_4.531073_g42278_i0 | PRJNA597223 | 44124 | 212 | 4.531073 | 9.60587476 | Leviviridae sp. | 2027243 | Viruses | Viruses | 45.4 | 0.0027 | NR | UJQ84969.1 | 2027243 | g42278 | i0 | 43.1 | 2.23584905660377 | 58 | 33 | 82.1 | 0 | 181 | 8 | 132 | 189 | UJQ84969.1 MAG: hypothetical protein 1 [Leviviridae sp.] | diamond | 474 | 45.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27680401 | 27680401 | PRJNA597223_P_NODE_21044_length_350_cov_3.053968_g19206_i0 | PRJNA597223 | 21044 | 350 | 3.053968 | 10.688888 | ssRNA phage SRR696 | 3430255 | Viruses | Viruses | 47.8 | 0.00211 | NR | YP_010769641.1 | 2786581 | g19206 | i0 | 40.4 | 0.762857142857143 | 89 | 37 | 69.4 | 3 | 99 | 341 | 130 | 210 | YP_010769641.1 RNA-directed RNA polymerase [ssRNA phage SRR6960799_24] | diamond | 267 | 47.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Koteshevirus | Koteshevirus lutadaptatum | ||
| 27837767 | 27837767 | PRJNA597223_P_NODE_28564_length_285_cov_2.548000_g26718_i0 | PRJNA597223 | 28564 | 285 | 2.548 | 7.2618 | Leviviridae sp. | 2027243 | Viruses | Viruses | 55.5 | 1.95e-6 | NR | UJQ85362.1 | 2027243 | g26718 | i0 | 39.7 | 0.821052631578947 | 78 | 45 | 80 | 2 | 274 | 47 | 90 | 167 | UJQ85362.1 MAG: putative maturation protein, partial [Leviviridae sp.] | diamond | 234 | 55.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27869364 | 27869364 | PRJNA597223_P_NODE_68625_length_173_cov_1.362319_g66779_i0 | PRJNA597223 | 68625 | 173 | 1.362319 | 2.35681187 | Sopatylt virus | 3131631 | Viruses | Viruses | 44.3 | 0.00417 | NR | WZH61697.1 | 3131631 | g66779 | i0 | 40 | 0.953757225433526 | 55 | 30 | 90.2 | 1 | 171 | 16 | 67 | 121 | WZH61697.1 MAG: RNA-dependent RNA polymerase [Sopatylt virus] | diamond | 165 | 44.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopatylt virus | |||||
| 27869368 | 27869368 | PRJNA597223_P_NODE_76125_length_162_cov_2.338583_g74279_i0 | PRJNA597223 | 76125 | 162 | 2.338583 | 3.78850446 | Leviviridae sp. | 2027243 | Viruses | Viruses | 87.4 | 1.3e-18 | NR | UJQ85963.1 | 2027243 | g74279 | i0 | 75 | 0.962962962962963 | 52 | 13 | 96.3 | 0 | 6 | 161 | 151 | 202 | UJQ85963.1 MAG: putative maturation protein [Leviviridae sp.] | diamond | 156 | 87.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27964178 | 27964178 | PRJNA597223_P_NODE_27605_length_292_cov_2.214008_g25759_i0 | PRJNA597223 | 27605 | 292 | 2.214008 | 6.46490336 | Leviviridae sp. | 2027243 | Viruses | Viruses | 172 | 3.72e-48 | NR | UJQ85965.1 | 2027243 | g25759 | i0 | 86.5 | 0.986301369863014 | 96 | 13 | 98.6 | 0 | 3 | 290 | 12 | 107 | UJQ85965.1 MAG: putative replicase protein [Leviviridae sp.] | diamond | 288 | 172 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28532744 | 28532744 | PRJNA597223_P_NODE_36247_length_241_cov_2.572816_g34401_i0 | PRJNA597223 | 36247 | 241 | 2.572816 | 6.20048656 | Leviviridae sp. | 2027243 | Viruses | Viruses | 76.3 | 1.01e-15 | NR | UJQ85964.1 | 2027243 | g34401 | i0 | 70.2 | 0.70954356846473 | 57 | 16 | 71 | 1 | 179 | 9 | 1 | 56 | UJQ85964.1 MAG: putative coat protein [Leviviridae sp.] | diamond | 171 | 76.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28722113 | 28722113 | PRJNA597223_P_NODE_44127_length_212_cov_4.395480_g42281_i0 | PRJNA597223 | 44127 | 212 | 4.39548 | 9.3184176 | Leviviridae sp. | 2027243 | Viruses | Viruses | 83.2 | 1.39e-16 | NR | UJQ84892.1 | 2027243 | g42281 | i0 | 59.3 | 0.834905660377358 | 59 | 24 | 83.5 | 0 | 1 | 177 | 488 | 546 | UJQ84892.1 MAG: putative replicase protein, partial [Leviviridae sp.] | diamond | 177 | 83.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 29542845 | 29542845 | PRJNA597223_P_NODE_61290_length_185_cov_2.873333_g59444_i0 | PRJNA597223 | 61290 | 185 | 2.873333 | 5.31566605 | Ripaflad virus | 3130546 | Viruses | Viruses | 57.8 | 8.5e-8 | NR | WZH59842.1 | 3130546 | g59444 | i0 | 53.4 | 0.940540540540541 | 58 | 27 | 94.1 | 0 | 179 | 6 | 267 | 324 | WZH59842.1 MAG: RNA-dependent RNA polymerase [Ripaflad virus] | diamond | 174 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaflad virus | |||||
| 29605729 | 29605729 | PRJNA597223_P_NODE_72070_length_167_cov_4.651515_g70224_i0 | PRJNA597223 | 72070 | 167 | 4.651515 | 7.76803005 | Leviviridae sp. | 2027243 | Viruses | Viruses | 53.9 | 1.37e-6 | NR | URG16077.1 | 2027243 | g70224 | i0 | 50 | 2.15568862275449 | 60 | 25 | 98.8 | 2 | 1 | 165 | 147 | 206 | URG16077.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 360 | 53.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 29985098 | 29985098 | PRJNA597223_P_NODE_76431_length_162_cov_1.440945_g74585_i0 | PRJNA597223 | 76431 | 162 | 1.440945 | 2.3343309 | ssRNA phage SRR696 | 2846144 | Viruses | Viruses | 57.8 | 6.02e-8 | NR | YP_010769023.1 | 2786531 | g74585 | i0 | 61.2 | 0.907407407407407 | 49 | 19 | 90.7 | 0 | 11 | 157 | 99 | 147 | YP_010769023.1 RNA-directed RNA polymerase [ssRNA phage SRR6960509_4] | diamond | 147 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Duinviridae | Samuneavirus | Samuneavirus asiocola | ||
| 30648294 | 30648294 | PRJNA597223_P_NODE_3773_length_891_cov_4.945093_g2748_i0 | PRJNA597223 | 3773 | 891 | 4.945093 | 44.06077863 | Leviviridae sp. | 2027243 | Viruses | Viruses | 189 | 3.11e-51 | NR | UJQ85367.1 | 2027243 | g2748 | i0 | 37.4 | 1.04377104377104 | 310 | 171 | 97.3 | 5 | 25 | 891 | 5 | 312 | UJQ85367.1 MAG: putative replicase protein [Leviviridae sp.] | diamond | 930 | 189 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31027872 | 31027872 | PRJNA597223_P_NODE_21035_length_350_cov_3.406349_g19197_i0 | PRJNA597223 | 21035 | 350 | 3.406349 | 11.9222215 | ssRNA phage SRR696 | 3430255 | Viruses | Viruses | 47.8 | 0.00211 | NR | YP_010769641.1 | 2786581 | g19197 | i0 | 40.4 | 0.762857142857143 | 89 | 37 | 69.4 | 3 | 252 | 10 | 130 | 210 | YP_010769641.1 RNA-directed RNA polymerase [ssRNA phage SRR6960799_24] | diamond | 267 | 47.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Koteshevirus | Koteshevirus lutadaptatum | ||
| 31470500 | 31470500 | PRJNA597223_P_NODE_56476_length_188_cov_1.784314_g54630_i0 | PRJNA597223 | 56476 | 188 | 1.784314 | 3.35451032 | Leviviridae sp. | 2027243 | Viruses | Viruses | 104 | 7.2e-25 | NR | UJQ85963.1 | 2027243 | g54630 | i0 | 72.6 | 0.98936170212766 | 62 | 17 | 98.9 | 0 | 2 | 187 | 237 | 298 | UJQ85963.1 MAG: putative maturation protein [Leviviridae sp.] | diamond | 186 | 104 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32008116 | 32008116 | PRJNA597223_P_NODE_25078_length_312_cov_1.700361_g23234_i0 | PRJNA597223 | 25078 | 312 | 1.700361 | 5.30512632 | ssRNA phage SRR696 | 3428423 | Viruses | Viruses | 47 | 0.00248 | NR | YP_010769885.1 | 2786582 | g23234 | i0 | 32.2 | 0.836538461538462 | 87 | 56 | 83.7 | 1 | 286 | 26 | 139 | 222 | YP_010769885.1 maturation protein [ssRNA phage SRR6960799_25] | diamond | 261 | 47 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Dunchevirus | Dunchevirus limicola | ||
| 32387757 | 32387757 | PRJNA597223_P_NODE_3119_length_972_cov_3.885806_g2212_i0 | PRJNA597223 | 3119 | 972 | 3.885806 | 37.77003432 | Leviviridae sp. | 2027243 | Viruses | Viruses | 107 | 1.0999999999999998e-24 | NR | UJQ85805.1 | 2027243 | g2212 | i0 | 46.2 | 0.737654320987654 | 119 | 64 | 36.7 | 0 | 427 | 71 | 1 | 119 | UJQ85805.1 MAG: putative coat protein [Leviviridae sp.] | diamond | 717 | 107 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae 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);;