contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3275332 | 3275332 | PRJNA745553_S_NODE_10523_length_374_cov_5.362126_g10328_i0 | PRJNA745553 | 10523 | 374 | 5.362126 | 20.05435124 | Tonghua Botou tick virus 2 | 2972055 | Viruses | Viruses | 606 | 6.059999999999998e-169 | NTclustered | gi|2819062441|gb|PQ150489.1| | 2972055 | g10328 | i0 | 97.465 | 6.00802139037433 | 355 | 9 | 95 | 0 | 10 | 364 | 2289 | 1935 | MAG: Tonghua Botou tick virus 2 isolate Beijing_119 genomic sequence | blastn | 2247 | 606 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tonghua Botou tick virus 2 | |||
| 8377526 | 8377526 | PRJNA745553_S_NODE_2067_length_650_cov_4.441941_g1895_i0 | PRJNA745553 | 2067 | 650 | 4.441941 | 28.8726165 | Dracophyllum associated narna-like virus 19 | 3066855 | Viruses | Viruses | 725 | 0 | NTclustered | gi|2626077411|gb|OQ987586.1| | 3066855 | g1895 | i0 | 87.619 | 9.36 | 630 | 70 | 96 | 7 | 19 | 641 | 1 | 629 | MAG: Dracophyllum associated narna-like virus 19 isolate DRALON genomic sequence | blastn | 6084 | 725 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 19 | |||
| 10928265 | 10928265 | PRJNA745553_S_NODE_26989_length_240_cov_2.305389_g26794_i0 | PRJNA745553 | 26989 | 240 | 2.305389 | 5.5329336 | Sopafab virus | 3131770 | Viruses | Viruses | 231 | 2.58e-56 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g26794 | i0 | 84.047 | 63.45 | 257 | 23 | 100 | 12 | 1 | 240 | 51 | 306 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 15228 | 231 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 12203686 | 12203686 | PRJNA745553_S_NODE_2270_length_633_cov_5.900000_g2094_i0 | PRJNA745553 | 2270 | 633 | 5.9 | 37.347 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 230 | 2.7099999999999992e-55 | NTclustered | gi|2183453089|gb|MZ679401.1| | 2808997 | g2094 | i0 | 90.805 | 0.608214849921011 | 174 | 12 | 27 | 4 | 9 | 180 | 157 | 328 | MAG: Botourmiaviridae sp. isolate 110-k141_211195 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 385 | 230 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 16026890 | 16026890 | PRJNA745553_S_NODE_27473_length_236_cov_4.061350_g27278_i0 | PRJNA745553 | 27473 | 236 | 4.06135 | 9.584786 | Sopatuq virus | 3131685 | Viruses | Viruses | 135 | 2.04e-27 | NTclustered | gi|2717323148|gb|PP173986.1| | 3131685 | g27278 | i0 | 91.089 | 16.4915254237288 | 101 | 8 | 42 | 1 | 90 | 189 | 3138 | 3238 | MAG: Sopatuq virus isolate SP1B_k141_215904 genomic sequence | blastn | 3892 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sopatuq virus | |||
| 17302385 | 17302385 | PRJNA745553_S_NODE_27434_length_236_cov_7.042945_g27239_i0 | PRJNA745553 | 27434 | 236 | 7.042945 | 16.6213502 | Chrocagost virus | 3129398 | Viruses | Viruses | 204 | 5.519999999999999e-48 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g27239 | i0 | 83.721 | 740.546610169491 | 215 | 35 | 91 | 0 | 10 | 224 | 5648 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 174769 | 204 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 17302442 | 17302442 | PRJNA745553_S_NODE_3174_length_579_cov_2.604743_g2991_i0 | PRJNA745553 | 3174 | 579 | 2.604743 | 15.08146197 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 316 | 1.84e-81 | NTclustered | gi|2395813225|gb|ON811959.1| | 2583949 | g2991 | i0 | 77.281 | 8.01554404145078 | 559 | 113 | 95 | 14 | 2 | 553 | 1355 | 1906 | MAG: Narnaviridae sp. isolate TIGMIC_1, complete genome | blastn | 4641 | 316 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 19851058 | 19851058 | PRJNA745553_S_NODE_12096_length_352_cov_8.283154_g11901_i0 | PRJNA745553 | 12096 | 352 | 8.283154 | 29.15670208 | Sopawol virus | 3131668 | Viruses | Viruses | 433 | 1.0199999999999999e-116 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g11901 | i0 | 93.22 | 81.3068181818182 | 295 | 18 | 83 | 2 | 12 | 304 | 296 | 2 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 28620 | 433 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 21126905 | 21126905 | PRJNA745553_S_NODE_29757_length_213_cov_9.307143_g29562_i0 | PRJNA745553 | 29757 | 213 | 9.307143 | 19.82421459 | Chrocagost virus | 3129398 | Viruses | Viruses | 189 | 1.37e-43 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g29562 | i0 | 84.375 | 65.6009389671361 | 192 | 30 | 90 | 0 | 2 | 193 | 5648 | 5839 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 13973 | 189 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost 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);;