contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26740 | 26740 | PRJEB29441_P_NODE_44081_length_163_cov_0.894737_g43640_i0 | PRJEB29441 | 44081 | 163 | 0.894737 | 1.45842131 | Sopafab virus | 3131770 | Viruses | Viruses | 202 | 1.27e-47 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g43640 | i0 | 90.323 | 0.950920245398773 | 155 | 14 | 94 | 1 | 2 | 155 | 3053 | 3207 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 155 | 202 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 26869 | 26869 | PRJEB29441_P_NODE_8241_length_400_cov_3.641026_g7802_i0 | PRJEB29441 | 8241 | 400 | 3.641026 | 14.564104 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 510 | 5.26e-140 | NTclustered | gi|2245490479|gb|ON164313.1| | 2583949 | g7802 | i0 | 89.75 | 3.56 | 400 | 39 | 99 | 2 | 1 | 399 | 1281 | 883 | MAG: Narnaviridae sp. isolate 280-k141_177927 RNA dependent RNA polymerase gene, partial cds | blastn | 1424 | 510 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 1300536 | 1300536 | PRJEB29441_P_NODE_15082_length_281_cov_1.663793_g14641_i0 | PRJEB29441 | 15082 | 281 | 1.663793 | 4.67525833 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 448 | 2.8299999999999996e-121 | NTclustered | gi|2245490377|gb|ON164216.1| | 2583949 | g14641 | i0 | 95.374 | 3.56227758007117 | 281 | 13 | 100 | 0 | 1 | 281 | 829 | 549 | MAG: Narnaviridae sp. isolate 176-k141_19736 RNA dependent RNA polymerase gene, partial cds | blastn | 1001 | 448 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 6405024 | 6405024 | PRJEB29441_P_NODE_47606_length_161_cov_0.910714_g47165_i0 | PRJEB29441 | 47606 | 161 | 0.910714 | 1.46624954 | Chrocagosk virus | 3129397 | Viruses | Viruses | 63.9 | 6.18e-6 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g47165 | i0 | 97.297 | 0.229813664596273 | 37 | 1 | 23 | 0 | 4 | 40 | 517 | 553 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 37 | 63.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 10229671 | 10229671 | PRJEB29441_P_NODE_649_length_1492_cov_6.738046_g534_i0 | PRJEB29441 | 649 | 1492 | 6.738046 | 100.53164632 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 472 | 9.92e-128 | NTclustered | gi|2183471522|gb|MZ680192.1| | 2583949 | g534 | i0 | 90.411 | 3.01005361930295 | 365 | 25 | 24 | 8 | 1 | 362 | 2059 | 2416 | MAG: Narnaviridae sp. isolate 126b-k141_36033 putative RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 4491 | 472 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 11504529 | 11504529 | PRJEB29441_P_NODE_24270_length_214_cov_1.296970_g23829_i0 | PRJEB29441 | 24270 | 214 | 1.29697 | 2.7755158 | Sopafab virus | 3131770 | Viruses | Viruses | 171 | 4.99e-38 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g23829 | i0 | 91.87 | 259.406542056075 | 123 | 9 | 57 | 1 | 23 | 144 | 3236 | 3358 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 55513 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 11504933 | 11504933 | PRJEB29441_P_NODE_4930_length_539_cov_6.593878_g4506_i0 | PRJEB29441 | 4930 | 539 | 6.593878 | 35.54100242 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 843 | 0 | NTclustered | gi|2245490377|gb|ON164216.1| | 2583949 | g4506 | i0 | 95.292 | 15.9480519480519 | 531 | 25 | 99 | 0 | 1 | 531 | 531 | 1 | MAG: Narnaviridae sp. isolate 176-k141_19736 RNA dependent RNA polymerase gene, partial cds | blastn | 8596 | 843 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 14054440 | 14054440 | PRJEB29441_P_NODE_15052_length_281_cov_2.327586_g14611_i0 | PRJEB29441 | 15052 | 281 | 2.327586 | 6.54051666 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 270 | 6.569999999999999e-68 | NTclustered | gi|2245490381|gb|ON164219.1| | 2583949 | g14611 | i0 | 85.019 | 3.8220640569395 | 267 | 38 | 95 | 2 | 3 | 268 | 1146 | 881 | MAG: Narnaviridae sp. isolate 177-k141_84465 RNA dependent RNA polymerase gene, partial cds | blastn | 1074 | 270 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 15328766 | 15328766 | PRJEB29441_P_NODE_35273_length_176_cov_1.204724_g34832_i0 | PRJEB29441 | 35273 | 176 | 1.204724 | 2.12031424 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 292 | 8.04e-75 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g34832 | i0 | 96.591 | 2.90909090909091 | 176 | 6 | 100 | 0 | 1 | 176 | 1348 | 1523 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 512 | 292 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 19152038 | 19152038 | PRJEB29441_P_NODE_29376_length_193_cov_1.590278_g28935_i0 | PRJEB29441 | 29376 | 193 | 1.590278 | 3.06923654 | Ripachij virus | 3130407 | Viruses | Viruses | 292 | 9.01e-75 | NTclustered | gi|2717319663|gb|PP172709.1| | 3130407 | g28935 | i0 | 94.681 | 167.652849740933 | 188 | 10 | 97 | 0 | 5 | 192 | 444 | 631 | MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence | blastn | 32357 | 292 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripachij virus | |||||
| 19152303 | 19152303 | PRJEB29441_P_NODE_45216_length_162_cov_1.353982_g44775_i0 | PRJEB29441 | 45216 | 162 | 1.353982 | 2.19345084 | Sopaded virus | 3131761 | Viruses | Viruses | 102 | 1.32e-17 | NTclustered | gi|2717323334|gb|PP174062.1| | 3131761 | g44775 | i0 | 87.778 | 0.555555555555556 | 90 | 7 | 54 | 4 | 75 | 162 | 333 | 420 | MAG: Sopaded virus isolate SP1C_k141_196651 genomic sequence | blastn | 90 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopaded virus | |||||
| 22978257 | 22978257 | PRJEB29441_P_NODE_1459_length_1021_cov_7.350823_g1242_i0 | PRJEB29441 | 1459 | 1021 | 7.350823 | 75.05190283 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 1304 | 0 | NTclustered | gi|2245490377|gb|ON164216.1| | 2583949 | g1242 | i0 | 91.309 | 17.7531831537708 | 955 | 83 | 94 | 0 | 1 | 955 | 553 | 1507 | MAG: Narnaviridae sp. isolate 176-k141_19736 RNA dependent RNA polymerase gene, partial cds | blastn | 18126 | 1304 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 22978599 | 22978599 | PRJEB29441_P_NODE_34819_length_177_cov_1.453125_g34378_i0 | PRJEB29441 | 34819 | 177 | 1.453125 | 2.57203125 | Chronazork virus | 3129863 | Viruses | Viruses | 91.6 | 3.17e-14 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g34378 | i0 | 90 | 0.587570621468927 | 70 | 7 | 40 | 0 | 108 | 177 | 166 | 97 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 104 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork 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);;