contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2038562 | 2038562 | PRJNA781453_P_NODE_25602_length_287_cov_1.074766_g25487_i0 | PRJNA781453 | 25602 | 287 | 1.074766 | 3.08457842 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 531 | 2.799999999999999e-146 | NTclustered | gi|2054472816|tpg|BK031770.1| | 2832643 | g25487 | i0 | 100 | 1.97212543554007 | 287 | 0 | 100 | 0 | 1 | 287 | 10162 | 10448 | MAG TPA_asm: Caudoviricetes sp. isolate ctpsk1, partial genome | blastn | 566 | 531 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2038915 | 2038915 | PRJNA781453_P_NODE_37922_length_244_cov_0.900585_g37807_i0 | PRJNA781453 | 37922 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|2054539178|tpg|BK047823.1| | 2832643 | g37807 | i0 | 99.587 | 2.97540983606557 | 242 | 1 | 99 | 0 | 3 | 244 | 34124 | 34365 | MAG TPA_asm: Caudoviricetes sp. isolate ctIhz3, partial genome | blastn | 726 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4591260 | 4591260 | PRJNA781453_P_NODE_39764_length_242_cov_0.911243_g39649_i0 | PRJNA781453 | 39764 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 183 | 7.41e-42 | NTclustered | gi|2056746445|tpg|BK045213.1| | 2832643 | g39649 | i0 | 86.667 | 0.681818181818182 | 165 | 22 | 68 | 0 | 1 | 165 | 14650 | 14486 | MAG TPA_asm: Caudoviricetes sp. isolate ctlIw2, partial genome | blastn | 165 | 183 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8416048 | 8416048 | PRJNA781453_P_NODE_40007_length_242_cov_0.911243_g39892_i0 | PRJNA781453 | 40007 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8699999999999998e-112 | NTclustered | gi|2053106382|tpg|BK020608.1| | 2832643 | g39892 | i0 | 98.319 | 7.94628099173554 | 238 | 4 | 98 | 0 | 1 | 238 | 5981 | 6218 | MAG TPA_asm: Caudoviricetes sp. isolate ctoTG1, partial genome | blastn | 1923 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9691279 | 9691279 | PRJNA781453_P_NODE_35808_length_247_cov_0.885057_g35693_i0 | PRJNA781453 | 35808 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2059705518|tpg|BK029657.1| | 2832643 | g35693 | i0 | 99.19 | 25.4898785425101 | 247 | 2 | 100 | 0 | 1 | 247 | 50777 | 50531 | MAG TPA_asm: Caudoviricetes sp. isolate ctA2R1, partial genome | blastn | 6296 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9691392 | 9691392 | PRJNA781453_P_NODE_40368_length_241_cov_0.916667_g40253_i0 | PRJNA781453 | 40368 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 200 | 7.319999999999998e-47 | NTclustered | gi|2054474373|tpg|BK031805.1| | 2832643 | g40253 | i0 | 96.694 | 0.50207468879668 | 121 | 3 | 50 | 1 | 1 | 121 | 702 | 821 | MAG TPA_asm: Caudoviricetes sp. isolate ct7OL11, partial genome | blastn | 121 | 200 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16065030 | 16065030 | PRJNA781453_P_NODE_24933_length_291_cov_1.288991_g24818_i0 | PRJNA781453 | 24933 | 291 | 1.288991 | 3.75096381 | Klebsiella phage phi1_175008 | 3127744 | Viruses | Viruses | 230 | 1.1599999999999998e-55 | NTclustered | gi|2864144020|gb|PQ360875.1| | 3127744 | g24818 | i0 | 81.429 | 1.12371134020619 | 280 | 52 | 96 | 0 | 9 | 288 | 31198 | 31477 | Klebsiella phage phi1_175008, complete genome | blastn | 327 | 230 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage phi1_175008 | |||||
| 18613762 | 18613762 | PRJNA781453_P_NODE_12615_length_416_cov_1.081633_g12501_i0 | PRJNA781453 | 12615 | 416 | 1.081633 | 4.49959328 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 758 | 0 | NTclustered | gi|2056970301|tpg|BK023111.1| | 2832643 | g12501 | i0 | 99.519 | 52.3100961538462 | 416 | 2 | 100 | 0 | 1 | 416 | 20185 | 20600 | MAG TPA_asm: Caudoviricetes sp. isolate ctaJd5, partial genome | blastn | 21761 | 758 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21614457 | 21614457 | PRJNA781453_P_NODE_39837_length_242_cov_0.911243_g39722_i0 | PRJNA781453 | 39837 | 242 | 0.911243 | 2.20520806 | Viruses | 10239 | Viruses | Viruses | 442 | 1.1099999999999995e-119 | NTclustered | gi|1549118192|gb|MK250015.1| | 2491281 | g39722 | i0 | 99.587 | 9 | 242 | 1 | 100 | 0 | 1 | 242 | 372038 | 372279 | MAG: Prevotella phage Lak-A1, complete genome | blastn | 2178 | 442 | 1 | Viruses | Grandeviruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lakviridae | Vetruanivirus | Vetruanivirus primi | ||
| 22440187 | 22440187 | PRJNA781453_P_NODE_34678_length_248_cov_0.880000_g34563_i0 | PRJNA781453 | 34678 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 5.34e-113 | NTclustered | gi|2054543371|tpg|BK047898.1| | 2832643 | g34563 | i0 | 97.177 | 7 | 248 | 7 | 100 | 0 | 1 | 248 | 4099 | 4346 | MAG TPA_asm: Caudoviricetes sp. isolate ctdDx65, partial genome | blastn | 1736 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22440205 | 22440205 | PRJNA781453_P_NODE_35338_length_247_cov_0.885057_g35223_i0 | PRJNA781453 | 35338 | 247 | 0.885057 | 2.18609079 | phage Lak_Megaphage_RVC_AP1_GC26 | 3109224 | Viruses | Viruses | 435 | 1.9e-117 | NTclustered | gi|2637654041|gb|OR769218.1| | 3109224 | g35223 | i0 | 98.381 | 7.78137651821862 | 247 | 4 | 100 | 0 | 1 | 247 | 381301 | 381055 | MAG: Phage Lak_Megaphage_RVC_AP1_GC26, complete sequence | blastn | 1922 | 435 | 1 | Viruses | Caudoviricetes code 15 clade | Heunggongvirae | Uroviricota | Caudoviricetes | phage Lak_Megaphage_RVC_AP1_GC26 | ||||
| 23715450 | 23715450 | PRJNA781453_P_NODE_27839_length_273_cov_2.105000_g27724_i0 | PRJNA781453 | 27839 | 273 | 2.105 | 5.74665 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2059623175|tpg|BK028264.1| | 2832643 | g27724 | i0 | 100 | 0.212454212454212 | 29 | 0 | 11 | 0 | 13 | 41 | 44643 | 44615 | MAG TPA_asm: Caudoviricetes sp. isolate ctYCW9, partial genome | blastn | 58 | 54.7 | 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);;