contig_metadata
17 rows where bioproject = "PRJNA1237347", tax_phylum = "Duplornaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10540606 | 10540606 | PRJNA1237347_P_NODE_11969_length_2296_cov_9.373819_g10338_i0 | PRJNA1237347 | 11969 | 2296 | 9.373819 | 215.22288424 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 4085 | 0 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g10338 | i0 | 98.78 | 1 | 2296 | 28 | 100 | 0 | 1 | 2296 | 1 | 2296 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 2296 | 4085 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 13097514 | 13097514 | PRJNA1237347_P_NODE_466971_length_252_cov_4.960894_g460398_i0 | PRJNA1237347 | 466971 | 252 | 4.960894 | 12.50145288 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 411 | 3.269999999999999e-110 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g460398 | i0 | 96.032 | 1 | 252 | 10 | 100 | 0 | 1 | 252 | 2964 | 3215 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 252 | 411 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 15648911 | 15648911 | PRJNA1237347_P_NODE_73033_length_833_cov_6.953947_g67137_i0 | PRJNA1237347 | 73033 | 833 | 6.953947 | 57.92637851 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 1373 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g67137 | i0 | 96.399 | 1 | 833 | 30 | 100 | 0 | 1 | 833 | 4046 | 3214 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 833 | 1373 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 20742638 | 20742638 | PRJNA1237347_P_NODE_33177_length_1346_cov_10.311076_g29398_i0 | PRJNA1237347 | 33177 | 1346 | 10.311076 | 138.78708296 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 2292 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g29398 | i0 | 97.4 | 1.02154531946508 | 1346 | 35 | 100 | 0 | 1 | 1346 | 2972 | 1627 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 1375 | 2292 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 23291540 | 23291540 | PRJNA1237347_P_NODE_23239_length_1630_cov_12.861914_g20349_i0 | PRJNA1237347 | 23239 | 1630 | 12.861914 | 209.6491982 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 2811 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g20349 | i0 | 97.793 | 1.00061349693252 | 1631 | 35 | 100 | 1 | 1 | 1630 | 1631 | 1 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 1631 | 2811 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 23298819 | 23298819 | PRJNA1237347_P_NODE_899_length_6745_cov_9.210582_g787_i0 | PRJNA1237347 | 899 | 6745 | 9.210582 | 621.2537559 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 6408 | 0 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g787 | i0 | 83.842 | 1.00103780578206 | 6752 | 1074 | 100 | 15 | 1 | 6745 | 1 | 6742 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 6752 | 6408 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 26852132 | 26852132 | PRJNA1237347_P_NODE_70481_length_852_cov_3.671374_g64673_i0 | PRJNA1237347 | 70481 | 852 | 3.671374 | 31.28010648 | Qianjiang toti-like virus 1 | 3348831 | Viruses | Viruses | 58.9 | 1.12e-5 | NR | XHA85765.1 | 3348832 | g64673 | i0 | 24.5 | 1.03521126760563 | 294 | 190 | 98.6 | 12 | 7 | 846 | 572 | 847 | XHA85765.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang toti-like virus 10] | diamond | 882 | 58.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Qianjiang toti-like virus 10 | |||
| 27167785 | 27167785 | PRJNA1237347_P_NODE_399662_length_280_cov_1.077295_g393089_i0 | PRJNA1237347 | 399662 | 280 | 1.077295 | 3.016426 | Tuatara cloaca-associated totivirus-2 | 2970569 | Viruses | Viruses | 108 | 5.6999999999999995e-25 | NR | UUV42635.1 | 2970569 | g393089 | i0 | 46.7 | 0.985714285714286 | 92 | 49 | 98.6 | 0 | 278 | 3 | 559 | 650 | UUV42635.1 MAG: RNA-dependent RNA polymerase [Tuatara cloaca-associated totivirus-2] | diamond | 276 | 108 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Tuatara cloaca-associated totivirus-2 | ||
| 27313121 | 27313121 | PRJNA1237347_P_NODE_58323_length_960_cov_3.299887_g52946_i0 | PRJNA1237347 | 58323 | 960 | 3.299887 | 31.6789152 | Viruses | 10239 | Viruses | Viruses | 157 | 7.54e-39 | NR | WZH58279.1 | 3129403 | g52946 | i0 | 32.5 | 2.940625 | 308 | 195 | 93.8 | 6 | 900 | 1 | 258 | 560 | WZH58279.1 MAG: RNA-dependent RNA polymerase [Chrocuvert virus] | diamond | 2823 | 157 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocuvert virus | |||
| 27344704 | 27344704 | PRJNA1237347_P_NODE_450943_length_259_cov_1.236559_g444370_i0 | PRJNA1237347 | 450943 | 259 | 1.236559 | 3.20268781 | Viruses | 10239 | Viruses | Viruses | 56.6 | 5.74e-7 | NR | DAZ87251.1 | 2912705 | g444370 | i0 | 35.1 | 1.83011583011583 | 77 | 40 | 82.2 | 2 | 45 | 257 | 156 | 228 | DAZ87251.1 TPA_asm: RNA-dependent polymerase, partial [Laestrygon toti-like virus] | diamond | 474 | 56.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Laestrygon toti-like virus | |||
| 27818260 | 27818260 | PRJNA1237347_P_NODE_203064_length_429_cov_1.884831_g196492_i0 | PRJNA1237347 | 203064 | 429 | 1.884831 | 8.08592499 | Viruses | 10239 | Viruses | Viruses | 128 | 1.05e-31 | NR | WAK73612.1 | 2976315 | g196492 | i0 | 44 | 1.98601398601399 | 141 | 78 | 98.6 | 1 | 5 | 427 | 146 | 285 | WAK73612.1 RNA-dependent RNA polymerase [Phytophthora palustris toti-like virus 4] | diamond | 852 | 129 | 0.992248062015504 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Phytophthora palustris toti-like virus 4 | |||
| 28684190 | 28684190 | PRJNA1237347_P_NODE_687_length_7392_cov_15.509769_g602_i0 | PRJNA1237347 | 687 | 7392 | 15.509769 | 1146.48212448 | Sichuan farmland cysto-like virus | 2824592 | Viruses | Viruses | 396 | 1.7599999999999995e-116 | NR | QYF49781.1 | 2824592 | g602 | i0 | 34.6 | 0.248376623376623 | 612 | 373 | 24.6 | 8 | 5584 | 3767 | 11 | 601 | QYF49781.1 MAG: putative RNA-dependent RNA polymerase [Sichuan farmland cysto-like virus] | diamond | 1836 | 396 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Sichuan farmland cysto-like virus | |||
| 28936046 | 28936046 | PRJNA1237347_P_NODE_106668_length_654_cov_1.987952_g100223_i0 | PRJNA1237347 | 106668 | 654 | 1.987952 | 13.00120608 | Totiviridae sp. | 1955172 | Viruses | Viruses | 51.6 | 0.00116 | NR | WAK77275.1 | 1955172 | g100223 | i0 | 28.8 | 3.02752293577982 | 132 | 86 | 57.3 | 4 | 265 | 639 | 105 | 235 | WAK77275.1 MAG: RNA-dependent RNA polymerase [Totiviridae sp.] | diamond | 1980 | 51.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 30862619 | 30862619 | PRJNA1237347_P_NODE_109494_length_643_cov_1.689474_g103032_i0 | PRJNA1237347 | 109494 | 643 | 1.689474 | 10.86331782 | Qianjiang toti-like virus 8 | 3348857 | Viruses | Viruses | 55.8 | 3.98e-5 | NR | XHA85760.1 | 3348857 | g103032 | i0 | 30.1 | 0.867807153965785 | 93 | 64 | 42.9 | 1 | 367 | 642 | 424 | 516 | XHA85760.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang toti-like virus 8] | diamond | 558 | 55.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Qianjiang toti-like virus 8 | |||
| 32318212 | 32318212 | PRJNA1237347_P_NODE_465439_length_253_cov_1.705556_g458866_i0 | PRJNA1237347 | 465439 | 253 | 1.705556 | 4.31505668 | Planotaenium ohtanii toti-like virus | 2933122 | Viruses | Viruses | 65.1 | 5.82e-10 | NR | CAI5383898.1 | 2933122 | g458866 | i0 | 48.8 | 0.972332015810277 | 82 | 37 | 93.7 | 3 | 246 | 10 | 766 | 845 | CAI5383898.1 RNA-dependent RNA polymerase [Planotaenium ohtanii toti-like virus] | diamond | 246 | 65.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Planotaenium ohtanii toti-like virus | |||
| 32602331 | 32602331 | PRJNA1237347_P_NODE_332560_length_313_cov_1.458333_g325987_i0 | PRJNA1237347 | 332560 | 313 | 1.458333 | 4.56458229 | Cronartium ribicola totivirus 1 | 2687247 | Viruses | Viruses | 79 | 1.61e-14 | NR | QGX74227.1 | 2687247 | g325987 | i0 | 40 | 0.910543130990415 | 95 | 57 | 91.1 | 0 | 9 | 293 | 61 | 155 | QGX74227.1 putative capsid protein [Cronartium ribicola totivirus 1] | diamond | 285 | 79 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Cronartium ribicola totivirus 1 | |||
| 32872542 | 32872542 | PRJNA1237347_P_NODE_284720_length_345_cov_1.415441_g278147_i0 | PRJNA1237347 | 284720 | 345 | 1.415441 | 4.88327145 | Viruses | 10239 | Viruses | Viruses | 82.8 | 1.03e-15 | NR | WAK73612.1 | 2976315 | g278147 | i0 | 38.3 | 2 | 115 | 70 | 100 | 1 | 345 | 1 | 36 | 149 | WAK73612.1 RNA-dependent RNA polymerase [Phytophthora palustris toti-like virus 4] | diamond | 690 | 82.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Phytophthora palustris toti-like virus 4 |
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);;