contig_metadata
11 rows where bioproject = "PRJNA438687", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1710175 | 1710175 | PRJNA438687_S_NODE_4022_length_221_cov_38.709677_g3932_i0 | PRJNA438687 | 4022 | 221 | 38.709677 | 85.54838617 | Chronazork virus | 3129863 | Viruses | Viruses | 172 | 1.44e-38 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g3932 | i0 | 83.333 | 26.683257918552 | 198 | 22 | 86 | 6 | 1 | 189 | 120 | 315 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 5897 | 172 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 1710189 | 1710189 | PRJNA438687_S_NODE_4622_length_206_cov_13.017544_g4532_i0 | PRJNA438687 | 4622 | 206 | 13.017544 | 26.81614064 | Chronazork virus | 3129863 | Viruses | Viruses | 91.6 | 3.82e-14 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g4532 | i0 | 90.141 | 0.344660194174757 | 71 | 5 | 33 | 2 | 121 | 189 | 167 | 97 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 71 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 2985967 | 2985967 | PRJNA438687_S_NODE_2783_length_267_cov_29.038793_g2693_i0 | PRJNA438687 | 2783 | 267 | 29.038793 | 77.53357731 | Chronazork virus | 3129863 | Viruses | Viruses | 231 | 2.9199999999999996e-56 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g2693 | i0 | 86.364 | 24.314606741573 | 220 | 21 | 79 | 6 | 24 | 235 | 97 | 315 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 6492 | 231 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 2986026 | 2986026 | PRJNA438687_S_NODE_5663_length_185_cov_32.860000_g5573_i0 | PRJNA438687 | 5663 | 185 | 32.86 | 60.791 | Chronaparn virus | 3129907 | Viruses | Viruses | 104 | 4.3e-18 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g5573 | i0 | 93.056 | 28.6216216216216 | 72 | 4 | 38 | 1 | 1 | 71 | 3672 | 3743 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5295 | 104 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 8088466 | 8088466 | PRJNA438687_S_NODE_1807_length_316_cov_29.733096_g1717_i0 | PRJNA438687 | 1807 | 316 | 29.733096 | 93.95658336 | Chronaparn virus | 3129907 | Viruses | Viruses | 115 | 3.72e-21 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g1717 | i0 | 91.765 | 16.8354430379747 | 85 | 3 | 26 | 3 | 236 | 316 | 3756 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5320 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 10639143 | 10639143 | PRJNA438687_S_NODE_1969_length_307_cov_35.632353_g1879_i0 | PRJNA438687 | 1969 | 307 | 35.632353 | 109.39132371 | Chronazork virus | 3129863 | Viruses | Viruses | 191 | 5.82e-44 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g1879 | i0 | 83.486 | 23.214983713355 | 218 | 22 | 67 | 10 | 33 | 238 | 315 | 100 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 7127 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 13188961 | 13188961 | PRJNA438687_S_NODE_2611_length_276_cov_1.788382_g2521_i0 | PRJNA438687 | 2611 | 276 | 1.788382 | 4.93593432 | Chrocagosk virus | 3129397 | Viruses | Viruses | 315 | 2.9299999999999993e-81 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g2521 | i0 | 87.319 | 56.9528985507246 | 276 | 34 | 100 | 1 | 1 | 276 | 46 | 320 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 15719 | 315 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 15737987 | 15737987 | PRJNA438687_S_NODE_4913_length_200_cov_29.593939_g4823_i0 | PRJNA438687 | 4913 | 200 | 29.593939 | 59.187878 | Chronaparn virus | 3129907 | Viruses | Viruses | 117 | 6.0700000000000005e-22 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g4823 | i0 | 95.833 | 27.215 | 72 | 3 | 36 | 0 | 129 | 200 | 3743 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5443 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 19561223 | 19561223 | PRJNA438687_S_NODE_4156_length_217_cov_31.615385_g4066_i0 | PRJNA438687 | 4156 | 217 | 31.615385 | 68.60538545 | Chronaparn virus | 3129907 | Viruses | Viruses | 122 | 1.4399999999999994e-23 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g4066 | i0 | 89.796 | 26.2119815668203 | 98 | 6 | 43 | 3 | 124 | 217 | 3769 | 3672 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 5688 | 122 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 19561281 | 19561281 | PRJNA438687_S_NODE_7296_length_161_cov_1.190476_g7206_i0 | PRJNA438687 | 7296 | 161 | 1.190476 | 1.91666636 | Ripasluj virus | 3131271 | Viruses | Viruses | 176 | 7.609999999999999e-40 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g7206 | i0 | 87.097 | 2.57142857142857 | 155 | 20 | 96 | 0 | 1 | 155 | 59 | 213 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 414 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj virus | |||||
| 23387540 | 23387540 | PRJNA438687_S_NODE_5799_length_183_cov_4.317568_g5709_i0 | PRJNA438687 | 5799 | 183 | 4.317568 | 7.90114944 | Ripasluj virus | 3131271 | Viruses | Viruses | 163 | 6.899999999999999e-36 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g5709 | i0 | 83.333 | 47.1147540983607 | 180 | 26 | 98 | 4 | 4 | 183 | 224 | 49 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 8622 | 163 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj 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);;