contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 400988 | 400988 | PRJNA379145_P_NODE_44621_length_266_cov_6.854077_g42469_i0 | PRJNA379145 | 44621 | 266 | 6.854077 | 18.23184482 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 492 | 1.2099999999999999e-134 | NTclustered | gi|2054522819|tpg|BK047507.1| | 2832643 | g42469 | i0 | 100 | 6.35338345864662 | 266 | 0 | 100 | 0 | 1 | 266 | 42157 | 42422 | MAG TPA_asm: Caudoviricetes sp. isolate cti5P2, partial genome | blastn | 1690 | 492 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5504616 | 5504616 | PRJNA379145_P_NODE_54385_length_211_cov_2.308989_g52231_i0 | PRJNA379145 | 54385 | 211 | 2.308989 | 4.87196679 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2057013570|tpg|BK048722.1| | 2832643 | g52231 | i0 | 96.875 | 0.151658767772512 | 32 | 0 | 15 | 1 | 11 | 41 | 7568 | 7599 | MAG TPA_asm: Caudoviricetes sp. isolate ctQb49, partial genome | blastn | 32 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9329062 | 9329062 | PRJNA379145_P_NODE_51348_length_226_cov_1.849741_g49194_i0 | PRJNA379145 | 51348 | 226 | 1.849741 | 4.18041466 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2059830562|tpg|BK040153.1| | 2832643 | g49194 | i0 | 100 | 0.256637168141593 | 29 | 0 | 13 | 0 | 61 | 89 | 25976 | 26004 | MAG TPA_asm: Caudoviricetes sp. isolate ctpi22, partial genome | blastn | 58 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10604885 | 10604885 | PRJNA379145_P_NODE_67669_length_165_cov_1.984848_g65515_i0 | PRJNA379145 | 67669 | 165 | 1.984848 | 3.2749992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.4899999999999995e-72 | NTclustered | gi|2052227111|tpg|BK056639.1| | 2832643 | g65515 | i0 | 97.576 | 160.575757575758 | 165 | 4 | 100 | 0 | 1 | 165 | 33750 | 33586 | MAG TPA_asm: Caudoviricetes sp. isolate ctLIy4, partial genome | blastn | 26495 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11879528 | 11879528 | PRJNA379145_P_NODE_310_length_3310_cov_13.614587_g252_i0 | PRJNA379145 | 310 | 3310 | 13.614587 | 450.6428297 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 84.2 | 1.22e-10 | NTclustered | gi|2058145578|tpg|BK034395.1| | 2832643 | g252 | i0 | 100 | 0.0897280966767372 | 45 | 0 | 1 | 0 | 426 | 470 | 6946 | 6990 | MAG TPA_asm: Caudoviricetes sp. isolate ctVxq14, partial genome | blastn | 297 | 84.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15703566 | 15703566 | PRJNA379145_P_NODE_37773_length_323_cov_2.906897_g35622_i0 | PRJNA379145 | 37773 | 323 | 2.906897 | 9.38927731 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 553 | 6.819999999999998e-153 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g35622 | i0 | 97.531 | 380.888544891641 | 324 | 7 | 100 | 1 | 1 | 323 | 18086 | 18409 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 123027 | 553 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18252795 | 18252795 | PRJNA379145_P_NODE_71415_length_156_cov_1.650407_g69260_i0 | PRJNA379145 | 71415 | 156 | 1.650407 | 2.57463492 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.1899999999999994e-72 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g69260 | i0 | 99.359 | 328.634615384615 | 156 | 1 | 100 | 0 | 1 | 156 | 18072 | 17917 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 51267 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20802313 | 20802313 | PRJNA379145_P_NODE_38577_length_315_cov_8.145390_g36426_i0 | PRJNA379145 | 38577 | 315 | 8.14539 | 25.6579785 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 67.6 | 1.05e-6 | NTclustered | gi|1971775256|gb|MW460245.1| | 2805747 | g36426 | i0 | 100 | 0.479365079365079 | 36 | 0 | 11 | 0 | 149 | 184 | 654 | 619 | Burkholderia phage BCSR5, complete genome | blastn | 151 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 22077248 | 22077248 | PRJNA379145_P_NODE_26338_length_472_cov_13.134396_g24285_i0 | PRJNA379145 | 26338 | 472 | 13.134396 | 61.99434912 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.046 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g24285 | i0 | 100 | 0.0593220338983051 | 28 | 0 | 6 | 0 | 376 | 403 | 1569 | 1596 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;