contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4191644 | 4191644 | PRJNA168635_P_NODE_26624_length_167_cov_7.796610_g26208_i0 | PRJNA168635 | 26624 | 167 | 7.79661 | 13.0203387 | Chronazork virus | 3129863 | Viruses | Viruses | 86.1 | 1.38e-12 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g26208 | i0 | 90.625 | 0.383233532934132 | 64 | 6 | 38 | 0 | 75 | 138 | 100 | 163 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 64 | 86.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 6742473 | 6742473 | PRJNA168635_P_NODE_9006_length_279_cov_7.700000_g8591_i0 | PRJNA168635 | 9006 | 279 | 7.7 | 21.483 | Ripapryg virus | 3131042 | Viruses | Viruses | 80.5 | 1.18e-10 | NTclustered | gi|2717321468|gb|PP173344.1| | 3131042 | g8591 | i0 | 89.062 | 0.229390681003584 | 64 | 7 | 23 | 0 | 56 | 119 | 4 | 67 | MAG: Ripapryg virus isolate KCAP3_k141_5414 genomic sequence | blastn | 64 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripapryg virus | |||||
| 8017977 | 8017977 | PRJNA168635_P_NODE_33647_length_157_cov_3.055556_g33231_i0 | PRJNA168635 | 33647 | 157 | 3.055556 | 4.79722292 | Dracophyllum associated narna-like virus 45 | 3066882 | Viruses | Viruses | 270 | 3.2899999999999993e-68 | NTclustered | gi|2626077459|gb|OQ987610.1| | 3066882 | g33231 | i0 | 98.065 | 1.96178343949045 | 155 | 3 | 99 | 0 | 1 | 155 | 745 | 591 | MAG: Dracophyllum associated narna-like virus 45 isolate DRALON genomic sequence | blastn | 308 | 270 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 45 | |||
| 8017990 | 8017990 | PRJNA168635_P_NODE_34147_length_155_cov_7.556604_g33731_i0 | PRJNA168635 | 34147 | 155 | 7.556604 | 11.7127362 | Ripachij virus | 3130407 | Viruses | Viruses | 243 | 7.05e-60 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g33731 | i0 | 94.839 | 309.522580645161 | 155 | 8 | 100 | 0 | 1 | 155 | 353 | 507 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 47976 | 243 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 10568462 | 10568462 | PRJNA168635_P_NODE_17889_length_190_cov_1.297872_g17473_i0 | PRJNA168635 | 17889 | 190 | 1.297872 | 2.4659568 | Ripaglys virus | 3130696 | Viruses | Viruses | 182 | 2e-41 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g17473 | i0 | 85.882 | 91.3578947368421 | 170 | 24 | 89 | 0 | 2 | 171 | 1003 | 1172 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 17358 | 182 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 11843285 | 11843285 | PRJNA168635_P_NODE_4130_length_412_cov_21.517906_g3729_i0 | PRJNA168635 | 4130 | 412 | 21.517906 | 88.65377272 | Ripachij virus | 3130407 | Viruses | Viruses | 438 | 2.6e-118 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g3729 | i0 | 91.304 | 172.123786407767 | 322 | 27 | 78 | 1 | 92 | 412 | 442 | 763 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 70915 | 438 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 16941482 | 16941482 | PRJNA168635_P_NODE_10874_length_249_cov_36.920000_g10459_i0 | PRJNA168635 | 10874 | 249 | 36.92 | 91.9308 | Ripachij virus | 3130407 | Viruses | Viruses | 344 | 3.32e-90 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g10459 | i0 | 91.566 | 44.9598393574297 | 249 | 21 | 100 | 0 | 1 | 249 | 763 | 515 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 11195 | 344 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 18216186 | 18216186 | PRJNA168635_P_NODE_2155_length_551_cov_12.555777_g1783_i0 | PRJNA168635 | 2155 | 551 | 12.555777 | 69.18233127 | Chrocahess virus | 3129527 | Viruses | Viruses | 174 | 1.11e-38 | NTclustered | gi|2717317804|gb|PP171975.1| | 3129527 | g1783 | i0 | 86.061 | 9.94192377495463 | 165 | 19 | 30 | 3 | 103 | 267 | 257 | 417 | MAG: Chrocahess virus isolate CC1B_k141_93065 genomic sequence | blastn | 5478 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chrocahess virus | |||
| 18216459 | 18216459 | PRJNA168635_P_NODE_715_length_874_cov_8.672727_g511_i0 | PRJNA168635 | 715 | 874 | 8.672727 | 75.79963398 | Psammomys obesus associated mitovirus 1 | 2993411 | Viruses | Viruses | 1528 | 0 | NTclustered | gi|2431564465|tpg|BK062831.1| | 2993411 | g511 | i0 | 99.406 | 0.963386727688787 | 842 | 5 | 96 | 0 | 33 | 874 | 1984 | 1143 | TPA_asm: Psammomys obesus associated mitovirus 1 RdRp gene, partial cds | blastn | 842 | 1528 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Psammomys obesus associated mitovirus 1 | ||
| 19490301 | 19490301 | PRJNA168635_P_NODE_15276_length_205_cov_4.378205_g14860_i0 | PRJNA168635 | 15276 | 205 | 4.378205 | 8.97532025 | Chrocagost virus | 3129398 | Viruses | Viruses | 235 | 1.6599999999999997e-57 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g14860 | i0 | 88.718 | 106.282926829268 | 195 | 18 | 94 | 4 | 13 | 205 | 5861 | 5669 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 21788 | 235 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 19490508 | 19490508 | PRJNA168635_P_NODE_276_length_1190_cov_10.002629_g198_i0 | PRJNA168635 | 276 | 1190 | 10.002629 | 119.0312851 | Psammomys obesus associated mitovirus 1 | 2993411 | Viruses | Viruses | 2111 | 0 | NTclustered | gi|2431564465|tpg|BK062831.1| | 2993411 | g198 | i0 | 99.484 | 0.976470588235294 | 1162 | 5 | 98 | 1 | 29 | 1189 | 1 | 1162 | TPA_asm: Psammomys obesus associated mitovirus 1 RdRp gene, partial cds | blastn | 1162 | 2111 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Psammomys obesus associated mitovirus 1 | ||
| 22041001 | 22041001 | PRJNA168635_P_NODE_16618_length_196_cov_3.020408_g16202_i0 | PRJNA168635 | 16618 | 196 | 3.020408 | 5.91999968 | Sopatrul virus | 3131609 | Viruses | Viruses | 102 | 1.66e-17 | NTclustered | gi|2717322931|gb|PP173910.1| | 3131609 | g16202 | i0 | 89.157 | 0.423469387755102 | 83 | 8 | 42 | 1 | 114 | 196 | 450 | 369 | MAG: Sopatrul virus isolate SP1A_k141_123728 genomic sequence | blastn | 83 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopatrul virus | |||||
| 23316479 | 23316479 | PRJNA168635_P_NODE_15499_length_203_cov_25.480519_g15083_i0 | PRJNA168635 | 15499 | 203 | 25.480519 | 51.72545357 | Sopawol virus | 3131668 | Viruses | Viruses | 287 | 4.46e-73 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g15083 | i0 | 94.652 | 96.7241379310345 | 187 | 6 | 91 | 4 | 19 | 203 | 2 | 186 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 19635 | 287 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol 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);;