contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA665531" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1905347 | 1905347 | PRJNA665531_P_NODE_13782_length_279_cov_1.582524_g13546_i0 | PRJNA665531 | 13782 | 279 | 1.582524 | 4.41524196 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 516 | 7.58e-142 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g13546 | i0 | 100 | 1 | 279 | 0 | 100 | 0 | 1 | 279 | 46521 | 46799 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 279 | 516 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2437474 | 2437474 | PRJNA665531_P_NODE_12642_length_291_cov_8.853211_g12406_i0 | PRJNA665531 | 12642 | 291 | 8.853211 | 25.76284401 | Sepunavirus | 1980928 | Viruses | Viruses | 501 | 2.23e-137 | NTclustered | gi|971761109|ref|NC_028962.1| | 1572704 | g12406 | i0 | 100 | 16.7697594501718 | 271 | 0 | 93 | 0 | 21 | 291 | 137728 | 137458 | Staphylococcus phage phiIPLA-C1C, complete genome | blastn | 4880 | 501 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Sepunavirus | Sepunavirus IPLAC1C | |||
| 4457289 | 4457289 | PRJNA665531_P_NODE_19144_length_242_cov_0.911243_g18908_i0 | PRJNA665531 | 19144 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 403 | 5.22e-108 | NTclustered | gi|2057182940|tpg|BK059062.1| | 2832643 | g18908 | i0 | 97.083 | 17.6694214876033 | 240 | 6 | 99 | 1 | 1 | 240 | 33216 | 33454 | MAG TPA_asm: Caudoviricetes sp. isolate ctGwI2, partial genome | blastn | 4276 | 403 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4457308 | 4457308 | PRJNA665531_P_NODE_19844_length_233_cov_2.156250_g19608_i0 | PRJNA665531 | 19844 | 233 | 2.15625 | 5.0240625 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 322 | 1.44e-83 | NTclustered | gi|2914993804|gb|OR222211.1| | 2832643 | g19608 | i0 | 91.845 | 22.2188841201717 | 233 | 15 | 99 | 4 | 2 | 233 | 50084 | 50313 | MAG: Caudoviricetes sp. isolate MSP0761 genomic sequence | blastn | 5177 | 322 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7008006 | 7008006 | PRJNA665531_P_NODE_19326_length_241_cov_0.916667_g19090_i0 | PRJNA665531 | 19326 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.99e-62 | NTclustered | gi|2054791465|tpg|BK049930.1| | 2832643 | g19090 | i0 | 89.5 | 21.2157676348548 | 200 | 20 | 83 | 1 | 43 | 241 | 4935 | 5134 | MAG TPA_asm: Caudoviricetes sp. isolate ct7mf1, partial genome | blastn | 5113 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8282442 | 8282442 | PRJNA665531_P_NODE_12127_length_298_cov_1.586667_g11891_i0 | PRJNA665531 | 12127 | 298 | 1.586667 | 4.72826766 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 518 | 2.2699999999999998e-142 | NTclustered | gi|2054694536|tpg|BK052869.1| | 2832643 | g11891 | i0 | 97.987 | 3.16442953020134 | 298 | 6 | 100 | 0 | 1 | 298 | 87013 | 86716 | MAG TPA_asm: Caudoviricetes sp. isolate ct7qV16, partial genome | blastn | 943 | 518 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9557728 | 9557728 | PRJNA665531_P_NODE_12848_length_289_cov_1.611111_g12612_i0 | PRJNA665531 | 12848 | 289 | 1.611111 | 4.65611079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 6.359999999999998e-113 | NTclustered | gi|2054462587|tpg|BK031569.1| | 2832643 | g12612 | i0 | 94.182 | 9.3840830449827 | 275 | 16 | 95 | 0 | 15 | 289 | 602 | 876 | MAG TPA_asm: Caudoviricetes sp. isolate ctfNY3, partial genome | blastn | 2712 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10833503 | 10833503 | PRJNA665531_P_NODE_19369_length_241_cov_0.916667_g19133_i0 | PRJNA665531 | 19369 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 392 | 1.1299999999999999e-104 | NTclustered | gi|2052220891|tpg|BK056516.1| | 2832643 | g19133 | i0 | 95.902 | 6.45643153526971 | 244 | 7 | 100 | 1 | 1 | 241 | 102 | 345 | MAG TPA_asm: Caudoviricetes sp. isolate ctjVN1, partial genome | blastn | 1556 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14658578 | 14658578 | PRJNA665531_P_NODE_9592_length_338_cov_1.283019_g9356_i0 | PRJNA665531 | 9592 | 338 | 1.283019 | 4.33660422 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 547 | 3.339999999999999e-151 | NTclustered | gi|2054474797|tpg|BK031814.1| | 2832643 | g9356 | i0 | 95.858 | 1 | 338 | 14 | 100 | 0 | 1 | 338 | 20639 | 20976 | MAG TPA_asm: Caudoviricetes sp. isolate ctnNF5, partial genome | blastn | 338 | 547 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19756412 | 19756412 | PRJNA665531_P_NODE_4896_length_497_cov_3.820755_g4661_i0 | PRJNA665531 | 4896 | 497 | 3.820755 | 18.98915235 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|2053226277|tpg|BK035376.1| | 2831613 | g4661 | i0 | 94.444 | 0.0724346076458753 | 36 | 1 | 7 | 1 | 10 | 45 | 98078 | 98044 | MAG TPA_asm: Herelleviridae sp. isolate ctdGG3, partial genome | blastn | 36 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 22306597 | 22306597 | PRJNA665531_P_NODE_15538_length_262_cov_2.402116_g15302_i0 | PRJNA665531 | 15538 | 262 | 2.402116 | 6.29354392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 9.379999999999998e-121 | NTclustered | gi|2914935464|gb|OR221651.1| | 2832643 | g15302 | i0 | 97.328 | 2.99236641221374 | 262 | 7 | 100 | 0 | 1 | 262 | 36001 | 35740 | MAG: Caudoviricetes sp. isolate MSP1402 genomic sequence | blastn | 784 | 446 | 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);;