contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA682774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3215433 | 3215433 | PRJNA682774_P_NODE_2723_length_280_cov_1.222222_g2694_i0 | PRJNA682774 | 2723 | 280 | 1.222222 | 3.4222216 | Exiguobacterium phage vB_EalM-132 | 2419623 | Viruses | Viruses | 361 | 3.769999999999999e-95 | NTclustered | gi|1503528544|gb|MH884511.1| | 2419623 | g2694 | i0 | 89.789 | 1.01428571428571 | 284 | 25 | 100 | 2 | 1 | 280 | 99648 | 99931 | Exiguobacterium phage vB_EalM-132, complete genome | blastn | 284 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Exiguobacterium phage vB_EalM-132 | ||||
| 4492605 | 4492605 | PRJNA682774_P_NODE_4684_length_246_cov_0.901734_g4655_i0 | PRJNA682774 | 4684 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 3.1799999999999995e-110 | NTclustered | gi|2052986268|tpg|BK030742.1| | 2832643 | g4655 | i0 | 96.748 | 4 | 246 | 8 | 100 | 0 | 1 | 246 | 5664 | 5419 | MAG TPA_asm: Caudoviricetes sp. isolate ctWpu13, partial genome | blastn | 984 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5768281 | 5768281 | PRJNA682774_P_NODE_3345_length_255_cov_1.285714_g3316_i0 | PRJNA682774 | 3345 | 255 | 1.285714 | 3.2785707 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 414 | 2.56e-111 | NTclustered | gi|2054807617|tpg|BK050242.1| | 2832643 | g3316 | i0 | 98.712 | 8.02745098039216 | 233 | 3 | 91 | 0 | 1 | 233 | 12489 | 12721 | MAG TPA_asm: Caudoviricetes sp. isolate ct8eg13, partial genome | blastn | 2047 | 414 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8317826 | 8317826 | PRJNA682774_P_NODE_4807_length_245_cov_0.906977_g4778_i0 | PRJNA682774 | 4807 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 193 | 1.25e-44 | NTclustered | gi|2053198840|tpg|BK016651.1| | 2832643 | g4778 | i0 | 89.474 | 3.42040816326531 | 152 | 16 | 62 | 0 | 79 | 230 | 15680 | 15831 | MAG TPA_asm: Caudoviricetes sp. isolate ctEFm9, partial genome | blastn | 838 | 193 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9593260 | 9593260 | PRJNA682774_P_NODE_3448_length_253_cov_0.866667_g3419_i0 | PRJNA682774 | 3448 | 253 | 0.866667 | 2.19266751 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 9.079999999999999e-116 | NTclustered | gi|2056751438|tpg|BK045317.1| | 2832643 | g3419 | i0 | 97.233 | 1 | 253 | 7 | 100 | 0 | 1 | 253 | 32119 | 31867 | MAG TPA_asm: Caudoviricetes sp. isolate ct5tf5, partial genome | blastn | 253 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13418639 | 13418639 | PRJNA682774_P_NODE_4611_length_246_cov_0.901734_g4582_i0 | PRJNA682774 | 4611 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2054713487|tpg|BK053275.1| | 2832643 | g4582 | i0 | 100 | 2 | 246 | 0 | 100 | 0 | 1 | 246 | 28932 | 29177 | MAG TPA_asm: Caudoviricetes sp. isolate ctKhp19, partial genome | blastn | 492 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14693622 | 14693622 | PRJNA682774_P_NODE_4692_length_246_cov_0.901734_g4663_i0 | PRJNA682774 | 4692 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 449 | 6.74e-122 | NTclustered | gi|2057146005|tpg|BK058407.1| | 2832643 | g4663 | i0 | 99.593 | 5 | 246 | 1 | 100 | 0 | 1 | 246 | 44057 | 43812 | MAG TPA_asm: Caudoviricetes sp. isolate ctQel4, partial genome | blastn | 1230 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14693624 | 14693624 | PRJNA682774_P_NODE_4832_length_245_cov_0.906977_g4803_i0 | PRJNA682774 | 4832 | 245 | 0.906977 | 2.22209365 | Myoviridae sp. ctHMa1 | 2827671 | Viruses | Viruses | 409 | 1.1399999999999998e-109 | NTclustered | gi|2052868790|tpg|BK032590.1| | 2827671 | g4803 | i0 | 96.735 | 1 | 245 | 8 | 100 | 0 | 1 | 245 | 19760 | 19516 | MAG TPA_asm: Myoviridae sp. ctHMa1, partial genome | blastn | 245 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ctHMa1 | |||||
| 15967391 | 15967391 | PRJNA682774_P_NODE_4993_length_244_cov_0.912281_g4964_i0 | PRJNA682774 | 4993 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2056747663|tpg|BK045242.1| | 2832643 | g4964 | i0 | 100 | 4.88934426229508 | 244 | 0 | 100 | 0 | 1 | 244 | 1794 | 2037 | MAG TPA_asm: Caudoviricetes sp. isolate ct3yG8, partial genome | blastn | 1193 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17242569 | 17242569 | PRJNA682774_P_NODE_2234_length_303_cov_1.426087_g2205_i0 | PRJNA682774 | 2234 | 303 | 1.426087 | 4.32104361 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 560 | 3.79e-155 | NTclustered | gi|2054455656|tpg|BK031417.1| | 2832643 | g2205 | i0 | 100 | 2 | 303 | 0 | 100 | 0 | 1 | 303 | 22221 | 22523 | MAG TPA_asm: Caudoviricetes sp. isolate ctIcV26, partial genome | blastn | 606 | 560 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17242606 | 17242606 | PRJNA682774_P_NODE_4714_length_246_cov_0.901734_g4685_i0 | PRJNA682774 | 4714 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 449 | 6.74e-122 | NTclustered | gi|2059595670|tpg|BK036982.1| | 2832643 | g4685 | i0 | 99.593 | 1 | 246 | 1 | 100 | 0 | 1 | 246 | 159228 | 159473 | MAG TPA_asm: Caudoviricetes sp. isolate ctu5P3, partial genome | blastn | 246 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18516771 | 18516771 | PRJNA682774_P_NODE_5375_length_242_cov_0.923077_g5346_i0 | PRJNA682774 | 5375 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 425 | 1.11e-114 | NTclustered | gi|2056831809|tpg|BK043950.1| | 2832643 | g5346 | i0 | 98.347 | 14.0867768595041 | 242 | 4 | 100 | 0 | 1 | 242 | 29504 | 29263 | MAG TPA_asm: Caudoviricetes sp. isolate ctjQy2, partial genome | blastn | 3409 | 425 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21067131 | 21067131 | PRJNA682774_P_NODE_5217_length_243_cov_0.917647_g5188_i0 | PRJNA682774 | 5217 | 243 | 0.917647 | 2.22988221 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2054548281|tpg|BK047993.1| | 2832643 | g5188 | i0 | 100 | 7.20987654320988 | 243 | 0 | 100 | 0 | 1 | 243 | 22097 | 22339 | MAG TPA_asm: Caudoviricetes sp. isolate ctYDy2, partial genome | blastn | 1752 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24890784 | 24890784 | PRJNA682774_P_NODE_2260_length_302_cov_1.305677_g2231_i0 | PRJNA682774 | 2260 | 302 | 1.305677 | 3.94314454 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 553 | 6.32e-153 | NTclustered | gi|2053077518|tpg|BK020018.1| | 2832643 | g2231 | i0 | 99.669 | 19.0033112582781 | 302 | 1 | 100 | 0 | 1 | 302 | 655 | 354 | MAG TPA_asm: Caudoviricetes sp. isolate ctDlT5, partial genome | blastn | 5739 | 553 | 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);;