contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_phylum = "Preplasmiviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26644863 | 26644863 | PRJNA930380_P_NODE_7441_length_285_cov_1.367925_g7388_i0 | PRJNA930380 | 7441 | 285 | 1.367925 | 3.89858625 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 132 | 1.05e-34 | NR | DBA49709.1 | 3115923 | g7388 | i0 | 67.4 | 0.936842105263158 | 89 | 29 | 93.7 | 0 | 282 | 16 | 296 | 384 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 267 | 132 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 26961494 | 26961494 | PRJNA930380_P_NODE_9362_length_275_cov_1.252475_g9309_i0 | PRJNA930380 | 9362 | 275 | 1.252475 | 3.44430625 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 133 | 1.6999999999999998e-36 | NR | DBA49710.1 | 3115923 | g9309 | i0 | 67.8 | 0.981818181818182 | 90 | 29 | 98.2 | 0 | 5 | 274 | 93 | 182 | DBA49710.1 MAG TPA_asm: Penton [Adintovirus manis3465] | diamond | 270 | 133 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 27056640 | 27056640 | PRJNA930380_P_NODE_8822_length_278_cov_1.502439_g8769_i0 | PRJNA930380 | 8822 | 278 | 1.502439 | 4.17678042 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 80.1 | 4.21e-15 | NR | DBA49717.1 | 3115923 | g8769 | i0 | 58.1 | 0.669064748201439 | 62 | 26 | 66.9 | 0 | 278 | 93 | 1242 | 1303 | DBA49717.1 MAG TPA_asm: PolBb [Adintovirus manis3465] | diamond | 186 | 80.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 27119489 | 27119489 | PRJNA930380_P_NODE_12382_length_248_cov_0.880000_g12329_i0 | PRJNA930380 | 12382 | 248 | 0.88 | 2.1824 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 86.7 | 8.76e-18 | NR | DBA49709.1 | 3115923 | g12329 | i0 | 59.4 | 0.834677419354839 | 69 | 25 | 79.8 | 1 | 1 | 198 | 304 | 372 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 207 | 86.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 27309619 | 27309619 | PRJNA930380_P_NODE_7963_length_282_cov_4.444976_g7910_i0 | PRJNA930380 | 7963 | 282 | 4.444976 | 12.53483232 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 158 | 1.21e-44 | NR | DBA49709.1 | 3115923 | g7910 | i0 | 79.6 | 0.98936170212766 | 93 | 19 | 98.9 | 0 | 2 | 280 | 296 | 388 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 279 | 158 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 28319831 | 28319831 | PRJNA930380_P_NODE_7646_length_284_cov_1.459716_g7593_i0 | PRJNA930380 | 7646 | 284 | 1.459716 | 4.14559344 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 151 | 4.2e-42 | NR | DBA49709.1 | 3115923 | g7593 | i0 | 75.3 | 0.982394366197183 | 93 | 23 | 98.2 | 0 | 3 | 281 | 296 | 388 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 279 | 151 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 28351390 | 28351390 | PRJNA930380_P_NODE_10106_length_270_cov_1.243655_g10053_i0 | PRJNA930380 | 10106 | 270 | 1.243655 | 3.3578685 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 124 | 6.31e-33 | NR | DBA49710.1 | 3115923 | g10053 | i0 | 79.2 | 0.8 | 72 | 15 | 80 | 0 | 3 | 218 | 93 | 164 | DBA49710.1 MAG TPA_asm: Penton [Adintovirus manis3465] | diamond | 216 | 124 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 28382986 | 28382986 | PRJNA930380_P_NODE_7066_length_286_cov_3.511737_g7013_i0 | PRJNA930380 | 7066 | 286 | 3.511737 | 10.04356782 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 69.7 | 2.13e-11 | NR | DBA49717.1 | 3115923 | g7013 | i0 | 57.9 | 0.597902097902098 | 57 | 21 | 56.6 | 1 | 259 | 98 | 1247 | 1303 | DBA49717.1 MAG TPA_asm: PolBb [Adintovirus manis3465] | diamond | 171 | 69.7 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 28477766 | 28477766 | PRJNA930380_P_NODE_7546_length_284_cov_2.919431_g7493_i0 | PRJNA930380 | 7546 | 284 | 2.919431 | 8.29118404 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 109 | 3.96e-26 | NR | DBA49709.1 | 3115923 | g7493 | i0 | 71.6 | 0.78169014084507 | 74 | 21 | 78.2 | 0 | 3 | 224 | 296 | 369 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 222 | 109 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 29298692 | 29298692 | PRJNA930380_P_NODE_8169_length_281_cov_2.913462_g8116_i0 | PRJNA930380 | 8169 | 281 | 2.913462 | 8.18682822 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 52 | 3.1e-5 | NR | DBA49709.1 | 3115923 | g8116 | i0 | 45.8 | 0.512455516014235 | 48 | 26 | 51.2 | 0 | 3 | 146 | 296 | 343 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 144 | 52 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 32079633 | 32079633 | PRJNA930380_P_NODE_11058_length_256_cov_1.338798_g11005_i0 | PRJNA930380 | 11058 | 256 | 1.338798 | 3.42732288 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 109 | 1.24e-25 | NR | DBA49717.1 | 3115923 | g11005 | i0 | 61.9 | 0.984375 | 84 | 31 | 97.3 | 1 | 255 | 7 | 706 | 789 | DBA49717.1 MAG TPA_asm: PolBb [Adintovirus manis3465] | diamond | 252 | 109 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 32174799 | 32174799 | PRJNA930380_P_NODE_10218_length_269_cov_1.209184_g10165_i0 | PRJNA930380 | 10218 | 269 | 1.209184 | 3.25270496 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 77.4 | 2.57e-14 | NR | DBA49709.1 | 3115923 | g10165 | i0 | 67.9 | 0.62453531598513 | 56 | 18 | 62.5 | 0 | 1 | 168 | 304 | 359 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 168 | 77.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 32174802 | 32174802 | PRJNA930380_P_NODE_6278_length_290_cov_1.419355_g6225_i0 | PRJNA930380 | 6278 | 290 | 1.419355 | 4.1161295 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 48.5 | 6.22e-4 | NR | DBA49717.1 | 3115923 | g6225 | i0 | 55.3 | 0.486206896551724 | 47 | 19 | 48.6 | 2 | 146 | 6 | 205 | 249 | DBA49717.1 MAG TPA_asm: PolBb [Adintovirus manis3465] | diamond | 141 | 48.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 | |||
| 32459502 | 32459502 | PRJNA930380_P_NODE_7999_length_282_cov_2.435407_g7946_i0 | PRJNA930380 | 7999 | 282 | 2.435407 | 6.86784774 | Adintovirus manis3465 | 3115923 | Viruses | Viruses | 147 | 1.72e-40 | NR | DBA49709.1 | 3115923 | g7946 | i0 | 78.5 | 0.98936170212766 | 93 | 20 | 98.9 | 0 | 281 | 3 | 296 | 388 | DBA49709.1 MAG TPA_asm: Integrase [Adintovirus manis3465] | diamond | 279 | 147 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus manis3465 |
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);;