contig_metadata
12 rows where bioproject = "PRJNA1073712" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1016091 | 1016091 | PRJNA1073712_P_NODE_1001_length_587_cov_2.050584_g918_i0 | PRJNA1073712 | 1001 | 587 | 2.050584 | 12.03692808 | Norzivirales | 2842247 | Viruses | Viruses | 91.6 | 1.23e-13 | NTclustered | gi|1698235331|gb|MN033940.1| | 2027243 | g918 | i0 | 91.045 | 0.228279386712095 | 67 | 6 | 11 | 0 | 482 | 548 | 4102 | 4168 | MAG: Leviviridae sp. isolate H4_Bulk_Litter_22_scaffold_329 RNA-dependent RNA polymerase (H4BulkLitter22329_000001), hypothetical protein (H4BulkLitter22329_000002), hypothetical protein (H4BulkLitter22329_000003), hypothetical protein (H4BulkLitter22329_000004), and hypothetical protein (H4BulkLitter22329_000005) genes, complete cds | blastn | 134 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 1462096 | 1462096 | PRJNA1073712_P_NODE_13342_length_247_cov_0.885057_g13259_i0 | PRJNA1073712 | 13342 | 247 | 0.885057 | 2.18609079 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 80.5 | 1.02e-10 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g13259 | i0 | 91.667 | 14.1497975708502 | 60 | 1 | 23 | 3 | 1 | 58 | 100 | 157 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3495 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 5290354 | 5290354 | PRJNA1073712_P_NODE_11985_length_250_cov_0.870056_g11902_i0 | PRJNA1073712 | 11985 | 250 | 0.870056 | 2.17514 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 86.1 | 2.23e-12 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g11902 | i0 | 92.063 | 13.62 | 63 | 1 | 24 | 3 | 1 | 61 | 99 | 159 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3405 | 86.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 7840274 | 7840274 | PRJNA1073712_P_NODE_7847_length_284_cov_1.327014_g7764_i0 | PRJNA1073712 | 7847 | 284 | 1.327014 | 3.76871976 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 80.5 | 1.2e-10 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g7764 | i0 | 91.667 | 11.9225352112676 | 60 | 1 | 20 | 3 | 227 | 284 | 159 | 102 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3386 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 9115215 | 9115215 | PRJNA1073712_P_NODE_14728_length_245_cov_0.895349_g14645_i0 | PRJNA1073712 | 14728 | 245 | 0.895349 | 2.19360505 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 76.8 | 1.31e-9 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g14645 | i0 | 91.379 | 13.534693877551 | 58 | 1 | 23 | 3 | 1 | 56 | 102 | 157 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3316 | 76.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 11666221 | 11666221 | PRJNA1073712_P_NODE_13050_length_248_cov_0.880000_g12967_i0 | PRJNA1073712 | 13050 | 248 | 0.88 | 2.1824 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 82.4 | 2.86e-11 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g12967 | i0 | 91.803 | 14.4677419354839 | 61 | 1 | 24 | 3 | 1 | 59 | 99 | 157 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3588 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 18039326 | 18039326 | PRJNA1073712_P_NODE_8155_length_281_cov_0.956731_g8072_i0 | PRJNA1073712 | 8155 | 281 | 0.956731 | 2.68841411 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 80.5 | 1.19e-10 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g8072 | i0 | 91.667 | 12.2277580071174 | 60 | 1 | 21 | 3 | 1 | 58 | 100 | 157 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3436 | 80.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 18039331 | 18039331 | PRJNA1073712_P_NODE_9135_length_270_cov_1.548223_g9052_i0 | PRJNA1073712 | 9135 | 270 | 1.548223 | 4.1802021 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 82.4 | 3.16e-11 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g9052 | i0 | 91.803 | 12.6 | 61 | 1 | 22 | 3 | 212 | 270 | 157 | 99 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3402 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 19313249 | 19313249 | PRJNA1073712_P_NODE_10796_length_254_cov_1.364641_g10713_i0 | PRJNA1073712 | 10796 | 254 | 1.364641 | 3.46618814 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 82.4 | 2.94e-11 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g10713 | i0 | 91.803 | 12.9291338582677 | 61 | 1 | 23 | 3 | 1 | 59 | 100 | 158 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3284 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 20588561 | 20588561 | PRJNA1073712_P_NODE_10497_length_257_cov_1.385870_g10414_i0 | PRJNA1073712 | 10497 | 257 | 1.38587 | 3.5616859 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 82.4 | 2.98e-11 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g10414 | i0 | 91.803 | 13.5719844357977 | 61 | 1 | 23 | 3 | 199 | 257 | 157 | 99 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3488 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 20588578 | 20588578 | PRJNA1073712_P_NODE_12797_length_248_cov_0.880000_g12714_i0 | PRJNA1073712 | 12797 | 248 | 0.88 | 2.1824 | StochSRVP_11 levi-like virus | 3038628 | Viruses | Viruses | 82.4 | 2.86e-11 | NTclustered | gi|2484124043|gb|OQ722337.1| | 3038628 | g12714 | i0 | 91.803 | 14.1411290322581 | 61 | 1 | 24 | 3 | 1 | 59 | 100 | 158 | MAG: StochSRVP_11 levi-like virus isolate SRVP22_05, partial genome | blastn | 3507 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | StochSRVP_11 levi-like virus | |||||
| 23139920 | 23139920 | PRJNA1073712_P_NODE_15959_length_242_cov_2.627219_g15876_i0 | PRJNA1073712 | 15959 | 242 | 2.627219 | 6.35786998 | Sclerotinia sclerotiorum mitovirus 12-U | 2879881 | Viruses | Viruses | 361 | 3.19e-95 | NTclustered | gi|2111887202|gb|MW454895.1| | 2879881 | g15876 | i0 | 99.495 | 1.28925619834711 | 198 | 1 | 82 | 0 | 1 | 198 | 700 | 897 | Sclerotinia sclerotiorum mitovirus 12-U isolate GB375-6 RNA-dependent RNA polymerase gene, complete cds | blastn | 312 | 361 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 12-U |
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);;