contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA911178" 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 |
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);;