contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA982106" and tax_kingdom = "Loebvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 963627 | 963627 | PRJNA982106_P_NODE_11301_length_313_cov_1.925000_g11061_i0 | PRJNA982106 | 11301 | 313 | 1.925 | 6.02525 | Inoviridae sp. | 2219103 | Viruses | Viruses | 479 | 1.1299999999999996e-130 | NTclustered | gi|2056841409|tpg|BK044138.1| | 2219103 | g11061 | i0 | 94.249 | 2.94888178913738 | 313 | 18 | 100 | 0 | 1 | 313 | 1000 | 688 | MAG TPA_asm: Inoviridae sp. isolate ctOnB2, partial genome | blastn | 923 | 479 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 963672 | 963672 | PRJNA982106_P_NODE_14481_length_288_cov_1.074419_g14241_i0 | PRJNA982106 | 14481 | 288 | 1.074419 | 3.09432672 | Inoviridae sp. | 2219103 | Viruses | Viruses | 311 | 3.98e-80 | NTclustered | gi|2057046767|tpg|BK049390.1| | 2219103 | g14241 | i0 | 91.892 | 1.78472222222222 | 222 | 18 | 77 | 0 | 1 | 222 | 13536 | 13757 | MAG TPA_asm: Inoviridae sp. isolate ctFES7, partial genome | blastn | 514 | 311 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 2238981 | 2238981 | PRJNA982106_P_NODE_14982_length_285_cov_1.089623_g14742_i0 | PRJNA982106 | 14982 | 285 | 1.089623 | 3.10542555 | Inoviridae sp. | 2219103 | Viruses | Viruses | 505 | 1.6799999999999995e-138 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g14742 | i0 | 98.596 | 1 | 285 | 4 | 100 | 0 | 1 | 285 | 24414 | 24698 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 285 | 505 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 3514389 | 3514389 | PRJNA982106_P_NODE_2343_length_567_cov_0.935223_g2105_i0 | PRJNA982106 | 2343 | 567 | 0.935223 | 5.30271441 | Inoviridae sp. | 2219103 | Viruses | Viruses | 948 | 0 | NTclustered | gi|2054774612|tpg|BK049634.1| | 2219103 | g2105 | i0 | 99.806 | 4.32980599647266 | 516 | 1 | 91 | 0 | 1 | 516 | 15851 | 16366 | MAG TPA_asm: Inoviridae sp. isolate ctWZQ6, partial genome | blastn | 2455 | 948 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 3514605 | 3514605 | PRJNA982106_P_NODE_4803_length_417_cov_1.575581_g4564_i0 | PRJNA982106 | 4803 | 417 | 1.575581 | 6.57017277 | Uncultured phage WW-nAnB strain 3 | 1449897 | Viruses | Viruses | 632 | 1.1299999999999995e-176 | NTclustered | gi|764162356|ref|NC_026613.1| | 1449897 | g4564 | i0 | 94.005 | 14.6426858513189 | 417 | 25 | 100 | 0 | 1 | 417 | 1884 | 1468 | Uncultured phage WW-nAnB strain 3, complete genome | blastn | 6106 | 632 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Uncultured phage WW-nAnB strain 3 | |||
| 4791679 | 4791679 | PRJNA982106_P_NODE_11164_length_315_cov_0.954545_g10924_i0 | PRJNA982106 | 11164 | 315 | 0.954545 | 3.00681675 | Inoviridae sp. | 2219103 | Viruses | Viruses | 560 | 3.96e-155 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g10924 | i0 | 98.73 | 1 | 315 | 4 | 100 | 0 | 1 | 315 | 50916 | 51230 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 315 | 560 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 6067095 | 6067095 | PRJNA982106_P_NODE_21085_length_251_cov_0.865169_g20845_i0 | PRJNA982106 | 21085 | 251 | 0.865169 | 2.17157419 | Inoviridae sp. | 2219103 | Viruses | Viruses | 403 | 5.45e-108 | NTclustered | gi|2057786728|tpg|BK054803.1| | 2219103 | g20845 | i0 | 95.618 | 11.402390438247 | 251 | 11 | 100 | 0 | 1 | 251 | 28383 | 28633 | MAG TPA_asm: Inoviridae sp. isolate ct8kI1, partial genome | blastn | 2862 | 403 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 7341554 | 7341554 | PRJNA982106_P_NODE_19766_length_255_cov_0.884615_g19526_i0 | PRJNA982106 | 19766 | 255 | 0.884615 | 2.25576825 | Inoviridae sp. | 2219103 | Viruses | Viruses | 453 | 5.44e-123 | NTclustered | gi|2057795283|tpg|BK054926.1| | 2219103 | g19526 | i0 | 98.819 | 3.98823529411765 | 254 | 3 | 99 | 0 | 1 | 254 | 12420 | 12167 | MAG TPA_asm: Inoviridae sp. isolate ctrx76, partial genome | blastn | 1017 | 453 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 7341769 | 7341769 | PRJNA982106_P_NODE_30846_length_242_cov_0.911243_g30606_i0 | PRJNA982106 | 30846 | 242 | 0.911243 | 2.20520806 | Inoviridae sp. | 2219103 | Viruses | Viruses | 422 | 1.44e-113 | NTclustered | gi|2056850090|tpg|BK044307.1| | 2219103 | g30606 | i0 | 98.333 | 2.73140495867769 | 240 | 4 | 99 | 0 | 3 | 242 | 2052 | 2291 | MAG TPA_asm: Inoviridae sp. isolate ctI0821, partial genome | blastn | 661 | 422 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 9891901 | 9891901 | PRJNA982106_P_NODE_2128_length_598_cov_1.594286_g1892_i0 | PRJNA982106 | 2128 | 598 | 1.594286 | 9.53383028 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1062 | 0 | NTclustered | gi|2052885848|tpg|BK017376.1| | 2219103 | g1892 | i0 | 98.826 | 0.996655518394649 | 596 | 7 | 99 | 0 | 3 | 598 | 31143 | 30548 | MAG TPA_asm: Inoviridae sp. isolate ctt7x1, partial genome | blastn | 596 | 1062 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 15298883 | 15298883 | PRJNA982106_P_NODE_23632_length_249_cov_0.875000_g23392_i0 | PRJNA982106 | 23632 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 261 | 3.44e-65 | NTclustered | gi|2059683555|tpg|BK029323.1| | 2219103 | g23392 | i0 | 85.6 | 55.7228915662651 | 250 | 34 | 100 | 2 | 1 | 249 | 3079 | 2831 | MAG TPA_asm: Inoviridae sp. isolate ctsqZ10, partial genome | blastn | 13875 | 261 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 18815846 | 18815846 | PRJNA982106_P_NODE_935_length_938_cov_2.358382_g742_i0 | PRJNA982106 | 935 | 938 | 2.358382 | 22.12162316 | Inoviridae sp. | 2219103 | Viruses | Viruses | 1387 | 0 | NTclustered | gi|2056892461|tpg|BK053727.1| | 2219103 | g742 | i0 | 93.39 | 26.2835820895522 | 938 | 61 | 99 | 1 | 2 | 938 | 4862 | 3925 | MAG TPA_asm: Inoviridae sp. isolate ctKTw4, partial genome | blastn | 24654 | 1387 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 20090592 | 20090592 | PRJNA982106_P_NODE_9436_length_333_cov_0.888462_g9196_i0 | PRJNA982106 | 9436 | 333 | 0.888462 | 2.95857846 | Inoviridae sp. | 2219103 | Viruses | Viruses | 593 | 4.159999999999999e-165 | NTclustered | gi|2057178442|tpg|BK058966.1| | 2219103 | g9196 | i0 | 99.094 | 4.2012012012012 | 331 | 2 | 99 | 1 | 1 | 330 | 833 | 503 | MAG TPA_asm: Inoviridae sp. isolate ctWC68, partial genome | blastn | 1399 | 593 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 21365970 | 21365970 | PRJNA982106_P_NODE_26437_length_246_cov_0.890173_g26197_i0 | PRJNA982106 | 26437 | 246 | 0.890173 | 2.18982558 | Inoviridae sp. | 2219103 | Viruses | Viruses | 438 | 1.4599999999999996e-118 | NTclustered | gi|2056883710|tpg|BK053541.1| | 2219103 | g26197 | i0 | 98.78 | 1.34959349593496 | 246 | 3 | 100 | 0 | 1 | 246 | 17370 | 17615 | MAG TPA_asm: Inoviridae sp. isolate ct2Vp13, partial genome | blastn | 332 | 438 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 22640738 | 22640738 | PRJNA982106_P_NODE_13298_length_296_cov_1.475336_g13058_i0 | PRJNA982106 | 13298 | 296 | 1.475336 | 4.36699456 | Inoviridae sp. | 2219103 | Viruses | Viruses | 547 | 2.8799999999999986e-151 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g13058 | i0 | 100 | 1 | 296 | 0 | 100 | 0 | 1 | 296 | 53308 | 53013 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 296 | 547 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23916371 | 23916371 | PRJNA982106_P_NODE_17619_length_268_cov_1.041026_g17379_i0 | PRJNA982106 | 17619 | 268 | 1.041026 | 2.78994968 | Inoviridae sp. | 2219103 | Viruses | Viruses | 490 | 4.39e-134 | NTclustered | gi|2059665191|tpg|BK029006.1| | 2219103 | g17379 | i0 | 99.627 | 1.92537313432836 | 268 | 1 | 100 | 0 | 1 | 268 | 57839 | 57572 | MAG TPA_asm: Inoviridae sp. isolate ctJ6z6, partial genome | blastn | 516 | 490 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23916432 | 23916432 | PRJNA982106_P_NODE_21279_length_251_cov_0.865169_g21039_i0 | PRJNA982106 | 21279 | 251 | 0.865169 | 2.17157419 | Inoviridae sp. | 2219103 | Viruses | Viruses | 161 | 3.62e-35 | NTclustered | gi|2059562607|tpg|BK036347.1| | 2219103 | g21039 | i0 | 95.96 | 0.394422310756972 | 99 | 4 | 39 | 0 | 1 | 99 | 12386 | 12484 | MAG TPA_asm: Inoviridae sp. isolate ctdOu2, partial genome | blastn | 99 | 161 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23916437 | 23916437 | PRJNA982106_P_NODE_21619_length_250_cov_0.870056_g21379_i0 | PRJNA982106 | 21619 | 250 | 0.870056 | 2.17514 | Inoviridae sp. | 2219103 | Viruses | Viruses | 145 | 3.63e-30 | NTclustered | gi|2052892616|tpg|BK017517.1| | 2219103 | g21379 | i0 | 100 | 1.672 | 78 | 0 | 79 | 0 | 1 | 78 | 7390 | 7313 | MAG TPA_asm: Inoviridae sp. isolate ctma920, partial genome | blastn | 418 | 145 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 23916733 | 23916733 | PRJNA982106_P_NODE_9119_length_337_cov_0.928030_g8879_i0 | PRJNA982106 | 9119 | 337 | 0.92803 | 3.1274611 | Inoviridae sp. ctDEu7 | 2826759 | Viruses | Viruses | 601 | 2.52e-167 | NTclustered | gi|2051098504|tpg|BK014988.1| | 2826759 | g8879 | i0 | 98.813 | 4 | 337 | 4 | 100 | 0 | 1 | 337 | 27277 | 26941 | MAG TPA_asm: Inoviridae sp. ctDEu7, partial genome | blastn | 1348 | 601 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. ctDEu7 | |||
| 25189831 | 25189831 | PRJNA982106_P_NODE_12300_length_304_cov_2.649351_g12060_i0 | PRJNA982106 | 12300 | 304 | 2.649351 | 8.05402704 | Inoviridae sp. | 2219103 | Viruses | Viruses | 473 | 5.1e-129 | NTclustered | gi|2056892461|tpg|BK053727.1| | 2219103 | g12060 | i0 | 94.737 | 15.9802631578947 | 304 | 16 | 100 | 0 | 1 | 304 | 2613 | 2310 | MAG TPA_asm: Inoviridae sp. isolate ctKTw4, partial genome | blastn | 4858 | 473 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. |
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);;