contig_metadata
12 rows where bioproject = "PRJNA911178", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8544808 | 8544808 | PRJNA911178_P_NODE_175467_length_285_cov_21.924528_g172994_i0 | PRJNA911178 | 175467 | 285 | 21.924528 | 62.4849048 | Chrocagost virus | 3129398 | Viruses | Viruses | 302 | 2.37e-77 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g172994 | i0 | 87.405 | 318.571929824561 | 262 | 33 | 92 | 0 | 19 | 280 | 5862 | 5601 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 90793 | 302 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 8545508 | 8545508 | PRJNA911178_P_NODE_255967_length_248_cov_0.880000_g253493_i0 | PRJNA911178 | 255967 | 248 | 0.88 | 2.1824 | Ripakrox virus | 3130763 | Viruses | Viruses | 237 | 5.77e-58 | NTclustered | gi|2717320712|gb|PP173065.1| | 3130763 | g253493 | i0 | 85.714 | 1.97177419354839 | 231 | 26 | 91 | 6 | 15 | 240 | 417 | 189 | MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence | blastn | 489 | 237 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripakrox virus | |||
| 9819789 | 9819789 | PRJNA911178_P_NODE_173948_length_286_cov_2.868545_g171475_i0 | PRJNA911178 | 173948 | 286 | 2.868545 | 8.2040387 | Ripaglys virus | 3130696 | Viruses | Viruses | 211 | 4.12e-50 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g171475 | i0 | 85.93 | 287.968531468531 | 199 | 26 | 70 | 2 | 87 | 285 | 2694 | 2498 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 82359 | 211 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 11094866 | 11094866 | PRJNA911178_P_NODE_107069_length_351_cov_1.507194_g104597_i0 | PRJNA911178 | 107069 | 351 | 1.507194 | 5.29025094 | Ripasluq virus | 3131229 | Viruses | Viruses | 316 | 1.0699999999999999e-81 | NTclustered | gi|2717321969|gb|PP173531.1| | 3131229 | g104597 | i0 | 93.427 | 293.435897435897 | 213 | 14 | 61 | 0 | 139 | 351 | 2903 | 3115 | MAG: Ripasluq virus isolate MP3_k141_106077 genomic sequence | blastn | 102996 | 316 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripasluq virus | |||||
| 11096422 | 11096422 | PRJNA911178_P_NODE_296529_length_239_cov_2.331325_g294055_i0 | PRJNA911178 | 296529 | 239 | 2.331325 | 5.57186675 | Ripasluq virus | 3131229 | Viruses | Viruses | 213 | 9.31e-51 | NTclustered | gi|2717321969|gb|PP173531.1| | 3131229 | g294055 | i0 | 87.912 | 91.1548117154812 | 182 | 20 | 76 | 1 | 58 | 239 | 2903 | 3082 | MAG: Ripasluq virus isolate MP3_k141_106077 genomic sequence | blastn | 21786 | 213 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripasluq virus | |||||
| 11097121 | 11097121 | PRJNA911178_P_NODE_94409_length_370_cov_1.882155_g91939_i0 | PRJNA911178 | 94409 | 370 | 1.882155 | 6.9639735 | Ripakrox virus | 3130763 | Viruses | Viruses | 359 | 1.85e-94 | NTclustered | gi|2717320712|gb|PP173065.1| | 3130763 | g91939 | i0 | 85.673 | 0.943243243243243 | 349 | 41 | 94 | 9 | 1 | 346 | 343 | 1 | MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence | blastn | 349 | 359 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripakrox virus | |||
| 13647283 | 13647283 | PRJNA911178_P_NODE_97711_length_365_cov_1.054795_g95241_i0 | PRJNA911178 | 97711 | 365 | 1.054795 | 3.85000175 | Penoulivirus zetaplasmoparae | 2956297 | Viruses | Viruses | 180 | 1.52e-40 | NTclustered | gi|2500381432|ref|NC_076816.1| | 2686562 | g95241 | i0 | 92.126 | 1.56438356164384 | 127 | 10 | 35 | 0 | 10 | 136 | 1 | 127 | Plasmopara viticola lesion associated ourmia-like virus 88 isolate DMS8_23510 RNA dependent RNA polymerase (QKR92_gp1) gene, complete cds | blastn | 571 | 180 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus zetaplasmoparae | ||
| 14919315 | 14919315 | PRJNA911178_P_NODE_119272_length_336_cov_0.946768_g116800_i0 | PRJNA911178 | 119272 | 336 | 0.946768 | 3.18114048 | Ripakrox virus | 3130763 | Viruses | Viruses | 322 | 2.19e-83 | NTclustered | gi|2717320712|gb|PP173065.1| | 3130763 | g116800 | i0 | 89.231 | 1.5952380952381 | 260 | 25 | 77 | 3 | 79 | 336 | 1 | 259 | MAG: Ripakrox virus isolate KCAP3_k141_106909 genomic sequence | blastn | 536 | 322 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripakrox virus | |||
| 26675951 | 26675951 | PRJNA911178_P_NODE_153961_length_301_cov_2.057018_g151488_i0 | PRJNA911178 | 153961 | 301 | 2.057018 | 6.19162418 | Oidiodendron maius splipalmivirus 1 | 2769353 | Viruses | Viruses | 45.1 | 0.0115 | NR | QNN89179.1 | 2769353 | g151488 | i0 | 45.5 | 0.438538205980066 | 44 | 23 | 43.9 | 1 | 300 | 169 | 706 | 748 | QNN89179.1 putative RNA dependent RNA polymerase [Oidiodendron maius splipalmivirus 1] | diamond | 132 | 45.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Delepalmivirus | Delepalmivirus oidiodendri | ||
| 27656514 | 27656514 | PRJNA911178_P_NODE_222344_length_260_cov_1.176471_g219870_i0 | PRJNA911178 | 222344 | 260 | 1.176471 | 3.0588246 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 85.5 | 1.72e-17 | NR | URG16567.1 | 2809572 | g219870 | i0 | 51.2 | 2.91923076923077 | 82 | 36 | 94.6 | 1 | 256 | 11 | 172 | 249 | URG16567.1 MAG: RNA dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 759 | 85.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28729928 | 28729928 | PRJNA911178_P_NODE_85967_length_385_cov_1.708333_g83499_i0 | PRJNA911178 | 85967 | 385 | 1.708333 | 6.57708205 | Mbeech associated narna-like virus 34 | 3066960 | Viruses | Viruses | 144 | 9.57e-39 | NR | WPR17352.1 | 3066960 | g83499 | i0 | 52.8 | 0.958441558441558 | 123 | 58 | 95.8 | 0 | 376 | 8 | 92 | 214 | WPR17352.1 MAG: RNA-dependent RNA polymerase, partial [Mbeech associated narna-like virus 34] | diamond | 369 | 144 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mbeech associated narna-like virus 34 | |||
| 30940911 | 30940911 | PRJNA911178_P_NODE_141574_length_312_cov_1.857741_g139101_i0 | PRJNA911178 | 141574 | 312 | 1.857741 | 5.79615192 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 56.6 | 1.1e-6 | NR | UJQ92506.1 | 2809572 | g139101 | i0 | 39 | 0.740384615384615 | 77 | 46 | 74 | 1 | 287 | 57 | 399 | 474 | UJQ92506.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 231 | 56.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae 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);;