contig_metadata
7 rows where bioproject = "PRJNA591127", tax_phylum = "Lenarviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 565097 | 565097 | PRJNA591127_P_NODE_23261_length_179_cov_3.661972_g23092_i0 | PRJNA591127 | 23261 | 179 | 3.661972 | 6.55492988 | Ripasluj virus | 3131271 | Viruses | Viruses | 272 | 1.07e-68 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g23092 | i0 | 94.828 | 70.5307262569832 | 174 | 9 | 97 | 0 | 6 | 179 | 224 | 51 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 12625 | 272 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj virus | |||||
| 18417049 | 18417049 | PRJNA591127_P_NODE_8255_length_257_cov_0.881818_g8087_i0 | PRJNA591127 | 8255 | 257 | 0.881818 | 2.26627226 | Ripathuj virus | 3131458 | Viruses | Viruses | 281 | 2.74e-71 | NTclustered | gi|2717322573|gb|PP173760.1| | 3131458 | g8087 | i0 | 86.853 | 188.782101167315 | 251 | 33 | 98 | 0 | 7 | 257 | 469 | 219 | MAG: Ripathuj virus isolate RCCP2_k141_221326 genomic sequence | blastn | 48517 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripathuj virus | |||||
| 23517473 | 23517473 | PRJNA591127_P_NODE_27259_length_157_cov_2.250000_g27090_i0 | PRJNA591127 | 27259 | 157 | 2.25 | 3.5325 | Chronazanb virus | 3129852 | Viruses | Viruses | 126 | 7.53e-25 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g27090 | i0 | 95 | 8.15286624203822 | 80 | 4 | 51 | 0 | 1 | 80 | 4477 | 4398 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 1280 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 24791159 | 24791159 | PRJNA591127_P_NODE_13780_length_198_cov_1.503106_g13611_i0 | PRJNA591127 | 13780 | 198 | 1.503106 | 2.97614988 | Ripachij virus | 3130407 | Viruses | Viruses | 250 | 5.67e-62 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g13611 | i0 | 89.394 | 217.570707070707 | 198 | 21 | 100 | 0 | 1 | 198 | 613 | 416 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 43079 | 250 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 28595767 | 28595767 | PRJNA591127_P_NODE_22887_length_182_cov_1.344828_g22718_i0 | PRJNA591127 | 22887 | 182 | 1.344828 | 2.44758696 | Leviviridae sp. | 2027243 | Viruses | Viruses | 75.9 | 3.43e-14 | NR | URG16528.1 | 2027243 | g22718 | i0 | 56.7 | 1.97802197802198 | 60 | 26 | 98.9 | 0 | 180 | 1 | 509 | 568 | URG16528.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 360 | 75.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31944470 | 31944470 | PRJNA591127_P_NODE_26257_length_162_cov_1.248000_g26088_i0 | PRJNA591127 | 26257 | 162 | 1.248 | 2.02176 | ssRNA phage Gerhypos.2_3 | 2786263 | Viruses | Viruses | 70.5 | 1.98e-12 | NR | YP_010770593.1 | 2786264 | g26088 | i0 | 75 | 0.740740740740741 | 40 | 10 | 74.1 | 0 | 3 | 122 | 368 | 407 | YP_010770593.1 maturation protein, partial [ssRNA phage Gerhypos.2_30] | diamond | 120 | 70.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus neosolivicinum | ||
| 32166328 | 32166328 | PRJNA591127_P_NODE_25998_length_163_cov_1.857143_g25829_i0 | PRJNA591127 | 25998 | 163 | 1.857143 | 3.02714309 | Plasmopara viticola lesion associated ourmia-like virus 82 | 2686556 | Viruses | Viruses | 108 | 1.06e-25 | NR | YP_010800276.1 | 2686556 | g25829 | i0 | 90.6 | 0.975460122699387 | 53 | 5 | 97.5 | 0 | 3 | 161 | 231 | 283 | YP_010800276.1 RNA dependent RNA polymerase, partial [Plasmopara viticola lesion associated ourmia-like virus 82] | diamond | 159 | 108 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaplasmoparae |
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);;