contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26812570 | 26812570 | PRJEB66218_P_NODE_236421_length_203_cov_0.915493_g233990_i0 | PRJEB66218 | 236421 | 203 | 0.915493 | 1.85845079 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 51.6 | 1.32e-5 | NR | DBA50496.1 | 3115894 | g233990 | i0 | 40.9 | 1.95073891625616 | 66 | 39 | 97.5 | 0 | 198 | 1 | 6 | 71 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 396 | 51.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 26970578 | 26970578 | PRJEB66218_P_NODE_140242_length_251_cov_0.984211_g137813_i0 | PRJEB66218 | 140242 | 251 | 0.984211 | 2.47036961 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 86.3 | 1.07e-19 | NR | DAC81395.1 | 2609864 | g137813 | i0 | 65.6 | 0.764940239043825 | 64 | 22 | 76.5 | 0 | 58 | 249 | 1 | 64 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 192 | 86.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 26970637 | 26970637 | PRJEB66218_P_NODE_241522_length_202_cov_0.921986_g239091_i0 | PRJEB66218 | 241522 | 202 | 0.921986 | 1.86241172 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 62.8 | 1e-10 | NR | DAC81395.1 | 2609864 | g239091 | i0 | 50.7 | 0.995049504950495 | 67 | 33 | 99.5 | 0 | 202 | 2 | 27 | 93 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 201 | 62.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 27381877 | 27381877 | PRJEB66218_P_NODE_65643_length_401_cov_1.558824_g63220_i0 | PRJEB66218 | 65643 | 401 | 1.558824 | 6.25088424 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 57.8 | 7.77e-7 | NR | DAC81404.1 | 2609864 | g63220 | i0 | 31.7 | 3.89775561097257 | 101 | 68 | 74.8 | 1 | 300 | 1 | 36 | 136 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 1563 | 58.2 | 0.993127147766323 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28013401 | 28013401 | PRJEB66218_P_NODE_228985_length_204_cov_1.678322_g226555_i0 | PRJEB66218 | 228985 | 204 | 1.678322 | 3.42377688 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 81.3 | 3.84e-16 | NR | DBA50491.1 | 3115894 | g226555 | i0 | 55.2 | 5.89705882352941 | 67 | 30 | 98.5 | 0 | 204 | 4 | 36 | 102 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 1203 | 81.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 28265607 | 28265607 | PRJEB66218_P_NODE_218486_length_206_cov_2.841379_g216056_i0 | PRJEB66218 | 218486 | 206 | 2.841379 | 5.85324074 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 45.1 | 0.00327 | NR | DAC81404.1 | 2609864 | g216056 | i0 | 33.3 | 0.961165048543689 | 66 | 43 | 94.7 | 1 | 9 | 203 | 142 | 207 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 198 | 45.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28708040 | 28708040 | PRJEB66218_P_NODE_83127_length_345_cov_0.922535_g80700_i0 | PRJEB66218 | 83127 | 345 | 0.922535 | 3.18274575 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 84.3 | 3.45e-17 | NR | DAC81394.1 | 2609864 | g80700 | i0 | 74.1 | 0.469565217391304 | 54 | 14 | 47 | 0 | 345 | 184 | 178 | 231 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 162 | 84.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28897215 | 28897215 | PRJEB66218_P_NODE_46828_length_500_cov_1.141230_g44412_i0 | PRJEB66218 | 46828 | 500 | 1.14123 | 5.70615 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 95.5 | 1e-20 | NR | DAC81394.1 | 2609864 | g44412 | i0 | 58.8 | 0.408 | 68 | 28 | 40.8 | 0 | 296 | 499 | 10 | 77 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 204 | 95.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 29086846 | 29086846 | PRJEB66218_P_NODE_195608_length_212_cov_1.198675_g193178_i0 | PRJEB66218 | 195608 | 212 | 1.198675 | 2.541191 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 85.1 | 4.37e-18 | NR | DBA50496.1 | 3115894 | g193178 | i0 | 60.6 | 0.933962264150943 | 66 | 26 | 93.4 | 0 | 2 | 199 | 144 | 209 | DBA50496.1 MAG TPA_asm: Adintoc2 [Adintovirus bos4377] | diamond | 198 | 85.1 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 30128510 | 30128510 | PRJEB66218_P_NODE_202292_length_210_cov_0.872483_g199862_i0 | PRJEB66218 | 202292 | 210 | 0.872483 | 1.8322143 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 74.3 | 7.28e-14 | NR | DAC81400.1 | 2609864 | g199862 | i0 | 50.7 | 0.985714285714286 | 69 | 34 | 98.6 | 0 | 209 | 3 | 115 | 183 | DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] | diamond | 207 | 74.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30381994 | 30381994 | PRJEB66218_P_NODE_188813_length_216_cov_0.870968_g186383_i0 | PRJEB66218 | 188813 | 216 | 0.870968 | 1.88129088 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 77.8 | 2.09e-15 | NR | DAC81394.1 | 2609864 | g186383 | i0 | 54.3 | 1.94444444444444 | 70 | 32 | 97.2 | 0 | 2 | 211 | 78 | 147 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 420 | 77.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 30382021 | 30382021 | PRJEB66218_P_NODE_250453_length_170_cov_5.183486_g248021_i0 | PRJEB66218 | 250453 | 170 | 5.183486 | 8.8119262 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.5 | 2.12e-8 | NR | DAC81394.1 | 2609864 | g248021 | i0 | 67.6 | 0.652941176470588 | 37 | 12 | 65.3 | 0 | 58 | 168 | 7 | 43 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 111 | 58.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31202598 | 31202598 | PRJEB66218_P_NODE_229215_length_204_cov_1.412587_g226785_i0 | PRJEB66218 | 229215 | 204 | 1.412587 | 2.88167748 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 72.4 | 1.71e-14 | NR | DAC81395.1 | 2609864 | g226785 | i0 | 56.9 | 0.955882352941177 | 65 | 28 | 95.6 | 0 | 10 | 204 | 1 | 65 | DAC81395.1 TPA_asm: gasderminX [Pimephales minnow adintovirus] | diamond | 195 | 72.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31234491 | 31234491 | PRJEB66218_P_NODE_144135_length_247_cov_1.059140_g141706_i0 | PRJEB66218 | 144135 | 247 | 1.05914 | 2.6160758 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 78.6 | 9.55e-15 | NR | DAC81393.1 | 2609864 | g141706 | i0 | 51.2 | 3.98380566801619 | 82 | 40 | 99.6 | 0 | 1 | 246 | 396 | 477 | DAC81393.1 TPA_asm: PolB-C [Pimephales minnow adintovirus] | diamond | 984 | 78.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31297917 | 31297917 | PRJEB66218_P_NODE_25395_length_750_cov_3.444122_g23172_i0 | PRJEB66218 | 25395 | 750 | 3.444122 | 25.830915 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 81.3 | 3.75e-14 | NR | DAC81404.1 | 2609864 | g23172 | i0 | 37.8 | 0.54 | 135 | 82 | 53.6 | 2 | 732 | 331 | 123 | 256 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 405 | 81.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31733480 | 31733480 | PRJEB66218_P_NODE_72837_length_375_cov_0.878981_g70412_i0 | PRJEB66218 | 72837 | 375 | 0.878981 | 3.29617875 | Viruses | 10239 | Viruses | Viruses | 75.1 | 5.38e-13 | NR | DAC81401.1 | 2609864 | g70412 | i0 | 66 | 1.256 | 50 | 17 | 40 | 0 | 3 | 152 | 312 | 361 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 471 | 75.5 | 0.994701986754967 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 31803846 | 31803846 | PRJEB66218_P_NODE_161297_length_233_cov_1.668605_g158867_i0 | PRJEB66218 | 161297 | 233 | 1.668605 | 3.88784965 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 77.4 | 1.4e-14 | NR | DAC81401.1 | 2609864 | g158867 | i0 | 55.1 | 5.04721030042918 | 78 | 34 | 99.1 | 1 | 3 | 233 | 191 | 268 | DAC81401.1 TPA_asm: integrase [Pimephales minnow adintovirus] | diamond | 1176 | 77.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32057123 | 32057123 | PRJEB66218_P_NODE_27218_length_716_cov_2.317557_g24950_i0 | PRJEB66218 | 27218 | 716 | 2.317557 | 16.59370812 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 100 | 2.8700000000000003e-21 | NR | DAC81404.1 | 2609864 | g24950 | i0 | 35.1 | 0.70391061452514 | 168 | 106 | 69.6 | 3 | 6 | 503 | 87 | 253 | DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] | diamond | 504 | 100 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32152026 | 32152026 | PRJEB66218_P_NODE_140038_length_251_cov_1.326316_g137609_i0 | PRJEB66218 | 140038 | 251 | 1.326316 | 3.32905316 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 96.3 | 1.98e-21 | NR | DBA50491.1 | 3115894 | g137609 | i0 | 59.8 | 1.9601593625498 | 82 | 33 | 98 | 0 | 4 | 249 | 249 | 330 | DBA50491.1 MAG TPA_asm: Integrase [Adintovirus bos4377] | diamond | 492 | 97.1 | 0.991761071060762 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 32657589 | 32657589 | PRJEB66218_P_NODE_82380_length_347_cov_1.000000_g79953_i0 | PRJEB66218 | 82380 | 347 | 1 | 3.47 | Adintovirus bos4377 | 3115894 | Viruses | Viruses | 114 | 2.76e-29 | NR | DBA50495.1 | 3115894 | g79953 | i0 | 47.8 | 0.994236311239193 | 115 | 60 | 99.4 | 0 | 2 | 346 | 55 | 169 | DBA50495.1 MAG TPA_asm: Adenain [Adintovirus bos4377] | diamond | 345 | 114 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus bos4377 | |||
| 32745314 | 32745314 | PRJEB66218_P_NODE_147120_length_244_cov_1.327869_g144691_i0 | PRJEB66218 | 147120 | 244 | 1.327869 | 3.24000036 | Viruses | 10239 | Viruses | Viruses | 79 | 1.99e-15 | NR | DAC81396.1 | 2609864 | g144691 | i0 | 57.3 | 1.84426229508197 | 75 | 32 | 92.2 | 0 | 11 | 235 | 9 | 83 | DAC81396.1 TPA_asm: acintoc2 [Pimephales minnow adintovirus] | diamond | 450 | 79 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 32815246 | 32815246 | PRJEB66218_P_NODE_199940_length_211_cov_0.840000_g197510_i0 | PRJEB66218 | 199940 | 211 | 0.84 | 1.7724 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 78.6 | 9.78e-16 | NR | DAC81394.1 | 2609864 | g197510 | i0 | 58.8 | 1.93364928909953 | 68 | 28 | 96.7 | 0 | 209 | 6 | 67 | 134 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 408 | 78.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;