contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26645934 | 26645934 | PRJNA976345_P_NODE_17441_length_404_cov_2.905149_g15850_i0 | PRJNA976345 | 17441 | 404 | 2.905149 | 11.73680196 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 65.5 | 9.56e-10 | NR | DBA46909.1 | 3115887 | g15850 | i0 | 34.3 | 0.995049504950495 | 134 | 81 | 95 | 4 | 386 | 3 | 1 | 133 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 402 | 65.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 27784416 | 27784416 | PRJNA976345_P_NODE_2284_length_1592_cov_11.449583_g1446_i0 | PRJNA976345 | 2284 | 1592 | 11.449583 | 182.27736136 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 156 | 1.98e-40 | NR | DBA46917.1 | 3115887 | g1446 | i0 | 40.1 | 0.437185929648241 | 232 | 129 | 42.2 | 7 | 634 | 1305 | 1 | 230 | DBA46917.1 MAG TPA_asm: Penton [Adintovirus androctonus13035] | diamond | 696 | 156 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 28068341 | 28068341 | PRJNA976345_P_NODE_31765_length_300_cov_3.245283_g30159_i0 | PRJNA976345 | 31765 | 300 | 3.245283 | 9.735849 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 68.2 | 6.14e-11 | NR | DBA46911.1 | 3115887 | g30159 | i0 | 43.5 | 1.25 | 69 | 39 | 69 | 0 | 1 | 207 | 253 | 321 | DBA46911.1 MAG TPA_asm: Integrase [Adintovirus androctonus13035] | diamond | 375 | 68.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 28289231 | 28289231 | PRJNA976345_P_NODE_64146_length_224_cov_1.227513_g62538_i0 | PRJNA976345 | 64146 | 224 | 1.227513 | 2.74962912 | Adintovirus macaca128 | 3115921 | Viruses | Viruses | 68.9 | 1.2e-11 | NR | DBA46380.1 | 3115921 | g62538 | i0 | 45.5 | 1.75446428571429 | 66 | 34 | 88.4 | 1 | 16 | 213 | 54 | 117 | DBA46380.1 MAG TPA_asm: Integrase [Adintovirus macaca12800] | diamond | 393 | 68.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus macaca12800 | |||
| 28320896 | 28320896 | PRJNA976345_P_NODE_15586_length_429_cov_4.667513_g14001_i0 | PRJNA976345 | 15586 | 429 | 4.667513 | 20.02363077 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 103 | 2.22e-22 | NR | DBA48453.1 | 3115912 | g14001 | i0 | 37.2 | 1.09090909090909 | 156 | 80 | 96.5 | 3 | 421 | 8 | 346 | 501 | DBA48453.1 MAG TPA_asm: PolBa [Adintovirus homo3309] | diamond | 468 | 103 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 29236741 | 29236741 | PRJNA976345_P_NODE_7449_length_653_cov_2.724919_g6030_i0 | PRJNA976345 | 7449 | 653 | 2.724919 | 17.79372107 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 55.8 | 1.89e-5 | NR | DBA46909.1 | 3115887 | g6030 | i0 | 30.9 | 0.624808575803982 | 136 | 87 | 59.7 | 4 | 19 | 408 | 1 | 135 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 408 | 55.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29331303 | 29331303 | PRJNA976345_P_NODE_18189_length_395_cov_3.208333_g16595_i0 | PRJNA976345 | 18189 | 395 | 3.208333 | 12.67291535 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 63.5 | 4.51e-9 | NR | DBA46909.1 | 3115887 | g16595 | i0 | 33.3 | 1.0253164556962 | 135 | 79 | 97.2 | 5 | 2 | 385 | 9 | 139 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 405 | 63.5 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29425802 | 29425802 | PRJNA976345_P_NODE_12929_length_475_cov_9.525000_g11365_i0 | PRJNA976345 | 12929 | 475 | 9.525 | 45.24375 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 52.8 | 7.65e-5 | NR | DBA46909.1 | 3115887 | g11365 | i0 | 29.6 | 0.726315789473684 | 115 | 77 | 70.1 | 3 | 456 | 124 | 32 | 146 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 345 | 52.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29425809 | 29425809 | PRJNA976345_P_NODE_140249_length_170_cov_3.496296_g138641_i0 | PRJNA976345 | 140249 | 170 | 3.496296 | 5.9437032 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 41.6 | 0.0355 | NR | DBA46911.1 | 3115887 | g138641 | i0 | 47.2 | 0.635294117647059 | 36 | 19 | 63.5 | 0 | 170 | 63 | 286 | 321 | DBA46911.1 MAG TPA_asm: Integrase [Adintovirus androctonus13035] | diamond | 108 | 41.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 29425873 | 29425873 | PRJNA976345_P_NODE_6849_length_688_cov_6.621746_g5465_i0 | PRJNA976345 | 6849 | 688 | 6.621746 | 45.55761248 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 212 | 3.34e-59 | NR | DBA48453.1 | 3115912 | g5465 | i0 | 46.2 | 1.0203488372093 | 234 | 112 | 99 | 4 | 681 | 1 | 467 | 693 | DBA48453.1 MAG TPA_asm: PolBa [Adintovirus homo3309] | diamond | 702 | 212 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 | |||
| 30026226 | 30026226 | PRJNA976345_P_NODE_5391_length_802_cov_6.456323_g4114_i0 | PRJNA976345 | 5391 | 802 | 6.456323 | 51.77971046 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 71.2 | 1.39e-10 | NR | DBA46909.1 | 3115887 | g4114 | i0 | 32 | 0.643391521197007 | 172 | 107 | 63.2 | 5 | 703 | 197 | 1 | 165 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 516 | 71.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 30057553 | 30057553 | PRJNA976345_P_NODE_7731_length_640_cov_4.011570_g6297_i0 | PRJNA976345 | 7731 | 640 | 4.01157 | 25.674048 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 66.2 | 3.48e-9 | NR | DBA46909.1 | 3115887 | g6297 | i0 | 31.5 | 0.684375 | 146 | 95 | 66.1 | 4 | 22 | 444 | 1 | 146 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 438 | 66.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 30215513 | 30215513 | PRJNA976345_P_NODE_78192_length_207_cov_3.639535_g76584_i0 | PRJNA976345 | 78192 | 207 | 3.639535 | 7.53383745 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 58.9 | 3.96e-8 | NR | DBA46911.1 | 3115887 | g76584 | i0 | 50 | 0.695652173913043 | 48 | 22 | 69.6 | 1 | 24 | 167 | 275 | 320 | DBA46911.1 MAG TPA_asm: Integrase [Adintovirus androctonus13035] | diamond | 144 | 58.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31068882 | 31068882 | PRJNA976345_P_NODE_15255_length_434_cov_5.531328_g13670_i0 | PRJNA976345 | 15255 | 434 | 5.531328 | 24.00596352 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 47.8 | 0.00333 | NR | DBA46909.1 | 3115887 | g13670 | i0 | 26.7 | 0.80184331797235 | 116 | 81 | 78.8 | 3 | 92 | 433 | 1 | 114 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 348 | 47.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31163222 | 31163222 | PRJNA976345_P_NODE_20155_length_375_cov_3.164706_g18557_i0 | PRJNA976345 | 20155 | 375 | 3.164706 | 11.8676475 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 50.8 | 1.59e-4 | NR | DBA46909.1 | 3115887 | g18557 | i0 | 22.4 | 0.856 | 107 | 83 | 85.6 | 0 | 374 | 54 | 40 | 146 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 321 | 50.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31289867 | 31289867 | PRJNA976345_P_NODE_8295_length_614_cov_4.404145_g6838_i0 | PRJNA976345 | 8295 | 614 | 4.404145 | 27.0414503 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 54.3 | 5.33e-5 | NR | DBA46909.1 | 3115887 | g6838 | i0 | 25.8 | 0.586319218241042 | 120 | 88 | 58.1 | 1 | 358 | 2 | 4 | 123 | DBA46909.1 MAG TPA_asm: Endon [Adintovirus androctonus13035] | diamond | 360 | 54.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31480020 | 31480020 | PRJNA976345_P_NODE_5056_length_837_cov_7.310474_g3809_i0 | PRJNA976345 | 5056 | 837 | 7.310474 | 61.18866738 | Adintovirus macaca128 | 3115921 | Viruses | Viruses | 187 | 4.34e-53 | NR | DBA46384.1 | 3115921 | g3809 | i0 | 47.4 | 0.763440860215054 | 213 | 97 | 74.6 | 4 | 836 | 213 | 194 | 396 | DBA46384.1 MAG TPA_asm: PLA2X-Adenain [Adintovirus macaca12800] | diamond | 639 | 187 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus macaca12800 | |||
| 31701185 | 31701185 | PRJNA976345_P_NODE_87097_length_199_cov_3.365854_g85489_i0 | PRJNA976345 | 87097 | 199 | 3.365854 | 6.69804946 | Adintovirus androctonus13 | 3115887 | Viruses | Viruses | 68.6 | 1.51e-11 | NR | DBA46921.1 | 3115887 | g85489 | i0 | 43.8 | 3.8894472361809 | 64 | 36 | 96.5 | 0 | 6 | 197 | 240 | 303 | DBA46921.1 MAG TPA_asm: Hexon [Adintovirus androctonus13035] | diamond | 774 | 68.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus androctonus13035 | |||
| 31922596 | 31922596 | PRJNA976345_P_NODE_82357_length_203_cov_5.273810_g80749_i0 | PRJNA976345 | 82357 | 203 | 5.27381 | 10.7058343 | Adintovirus homo33 | 3115912 | Viruses | Viruses | 90.9 | 2.44e-19 | NR | DBA48453.1 | 3115912 | g80749 | i0 | 57.6 | 0.975369458128079 | 66 | 28 | 97.5 | 0 | 4 | 201 | 669 | 734 | DBA48453.1 MAG TPA_asm: PolBa [Adintovirus homo3309] | diamond | 198 | 90.9 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus homo3309 |
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);;