contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300848 | 1300848 | PRJEB29441_P_NODE_31722_length_186_cov_1.175182_g31281_i0 | PRJEB29441 | 31722 | 186 | 1.175182 | 2.18583852 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 2.44e-60 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g31281 | i0 | 90.374 | 141.204301075269 | 187 | 16 | 100 | 2 | 1 | 186 | 17982 | 18167 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 26264 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2576072 | 2576072 | PRJEB29441_P_NODE_10343_length_351_cov_1.682119_g9902_i0 | PRJEB29441 | 10343 | 351 | 1.682119 | 5.90423769 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 2.31e-78 | NTclustered | gi|2914931672|gb|OR221590.1| | 2832643 | g9902 | i0 | 82.486 | 2.00854700854701 | 354 | 56 | 100 | 4 | 1 | 351 | 15097 | 15447 | MAG: Caudoviricetes sp. isolate MSP1469 genomic sequence | blastn | 705 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3852683 | 3852683 | PRJEB29441_P_NODE_29424_length_193_cov_1.416667_g28983_i0 | PRJEB29441 | 29424 | 193 | 1.416667 | 2.73416731 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 309 | 8.94e-80 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g28983 | i0 | 95.812 | 2.38860103626943 | 191 | 8 | 99 | 0 | 1 | 191 | 114499 | 114689 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 461 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 5129186 | 5129186 | PRJEB29441_P_NODE_45125_length_162_cov_1.654867_g44684_i0 | PRJEB29441 | 45125 | 162 | 1.654867 | 2.68088454 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 259 | 7.400000000000001e-65 | NTclustered | gi|2915041439|gb|OR222744.1| | 2832643 | g44684 | i0 | 95.652 | 2.97530864197531 | 161 | 7 | 99 | 0 | 1 | 161 | 62686 | 62846 | MAG: Caudoviricetes sp. isolate MSP0616 genomic sequence | blastn | 482 | 259 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8641323 | 8641323 | PRJEB29441_P_NODE_12227_length_318_cov_3.252788_g11786_i0 | PRJEB29441 | 12227 | 318 | 3.252788 | 10.34386584 | root | 1 | Root_unresolved | Root_unresolved | 582 | 8.549999999999998e-162 | NTclustered | gi|2915034053|gb|OR222678.1| | 2832643 | g11786 | i0 | 99.686 | 65.1320754716981 | 318 | 1 | 100 | 0 | 1 | 318 | 30515 | 30198 | MAG: Caudoviricetes sp. isolate MSP0255 genomic sequence | blastn | 20712 | 582 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8953436 | 8953436 | PRJEB29441_P_NODE_23808_length_216_cov_1.832335_g23367_i0 | PRJEB29441 | 23808 | 216 | 1.832335 | 3.9578436 | Pseudomonas phage PotUPM1 | 3035940 | Viruses | Viruses | 388 | 1.28e-103 | NTclustered | gi|2468022649|gb|OQ633420.1| | 3035940 | g23367 | i0 | 99.074 | 4.89814814814815 | 216 | 2 | 100 | 0 | 1 | 216 | 21883 | 21668 | Pseudomonas phage PotUPM1, complete genome | blastn | 1058 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PotUPM1 | |||||
| 10229111 | 10229111 | PRJEB29441_P_NODE_1749_length_930_cov_10.368899_g1507_i0 | PRJEB29441 | 1749 | 930 | 10.368899 | 96.4307607 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1096 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1507 | i0 | 96.531 | 413.743010752688 | 663 | 22 | 71 | 1 | 1 | 662 | 17757 | 18419 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 384781 | 1096 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11504493 | 11504493 | PRJEB29441_P_NODE_22690_length_222_cov_1.179191_g22249_i0 | PRJEB29441 | 22690 | 222 | 1.179191 | 2.61780402 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.2 | 1.18e-4 | NTclustered | gi|2059770218|tpg|BK039125.1| | 2832643 | g22249 | i0 | 100 | 0.702702702702703 | 32 | 0 | 14 | 0 | 17 | 48 | 81836 | 81867 | MAG TPA_asm: Caudoviricetes sp. isolate ctHIv3, partial genome | blastn | 156 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14054707 | 14054707 | PRJEB29441_P_NODE_29812_length_192_cov_1.069930_g29371_i0 | PRJEB29441 | 29812 | 192 | 1.06993 | 2.0542656 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.2 | 9.88e-5 | NTclustered | gi|2059770218|tpg|BK039125.1| | 2832643 | g29371 | i0 | 100 | 0.8125 | 32 | 0 | 17 | 0 | 8 | 39 | 81836 | 81867 | MAG TPA_asm: Caudoviricetes sp. isolate ctHIv3, partial genome | blastn | 156 | 60.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14054864 | 14054864 | PRJEB29441_P_NODE_39372_length_167_cov_0.864407_g38931_i0 | PRJEB29441 | 39372 | 167 | 0.864407 | 1.44355969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.2600000000000001e-77 | NTclustered | gi|2052201437|tpg|BK056134.1| | 2832643 | g38931 | i0 | 99.398 | 25.5089820359281 | 166 | 1 | 99 | 0 | 2 | 167 | 19402 | 19237 | MAG TPA_asm: Caudoviricetes sp. isolate ctDNN3, partial genome | blastn | 4260 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15328844 | 15328844 | PRJEB29441_P_NODE_4093_length_598_cov_3.830601_g3685_i0 | PRJEB29441 | 4093 | 598 | 3.830601 | 22.90699398 | Pseudomonas phage PotUPM1 | 3035940 | Viruses | Viruses | 566 | 1.7099999999999995e-156 | NTclustered | gi|2468022649|gb|OQ633420.1| | 3035940 | g3685 | i0 | 96 | 1.76588628762542 | 350 | 11 | 58 | 1 | 1 | 347 | 32094 | 32443 | Pseudomonas phage PotUPM1, complete genome | blastn | 1056 | 566 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PotUPM1 | |||||
| 16603495 | 16603495 | PRJEB29441_P_NODE_38114_length_168_cov_2.142857_g37673_i0 | PRJEB29441 | 38114 | 168 | 2.142857 | 3.59999976 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 311 | 2.11e-80 | NTclustered | gi|2054522819|tpg|BK047507.1| | 2832643 | g37673 | i0 | 100 | 7.02976190476191 | 168 | 0 | 100 | 0 | 1 | 168 | 42440 | 42273 | MAG TPA_asm: Caudoviricetes sp. isolate cti5P2, partial genome | blastn | 1181 | 311 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16603508 | 16603508 | PRJEB29441_P_NODE_38814_length_167_cov_0.864407_g38373_i0 | PRJEB29441 | 38814 | 167 | 0.864407 | 1.44355969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 298 | 1.63e-76 | NTclustered | gi|2914933639|gb|OR221620.1| | 2832643 | g38373 | i0 | 98.802 | 2.68263473053892 | 167 | 2 | 100 | 0 | 1 | 167 | 3064 | 3230 | MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence | blastn | 448 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17878247 | 17878247 | PRJEB29441_P_NODE_34195_length_179_cov_1.153846_g33754_i0 | PRJEB29441 | 34195 | 179 | 1.153846 | 2.06538434 | Warsawvirus wv3MF5 | 3433337 | Viruses | Viruses | 150 | 5.23e-32 | NTclustered | gi|2046341757|ref|NC_054890.1| | 2749426 | g33754 | i0 | 85.915 | 2.4804469273743 | 142 | 18 | 79 | 2 | 39 | 179 | 16564 | 16424 | Pseudomonas phage vB_PsyP_3MF5, complete genome | blastn | 444 | 150 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Warsawvirus | Warsawvirus wv3MF5 | ||
| 19151808 | 19151808 | PRJEB29441_P_NODE_15076_length_281_cov_1.715517_g14635_i0 | PRJEB29441 | 15076 | 281 | 1.715517 | 4.82060277 | Pseudomonas phage PotUPM1 | 3035940 | Viruses | Viruses | 165 | 3.19e-36 | NTclustered | gi|2468022649|gb|OQ633420.1| | 3035940 | g14635 | i0 | 97.895 | 0.637010676156584 | 95 | 2 | 34 | 0 | 187 | 281 | 26839 | 26745 | Pseudomonas phage PotUPM1, complete genome | blastn | 179 | 165 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PotUPM1 | |||||
| 19152326 | 19152326 | PRJEB29441_P_NODE_46596_length_161_cov_1.366071_g46155_i0 | PRJEB29441 | 46596 | 161 | 1.366071 | 2.19937431 | Pseudomonas phage PotUPM1 | 3035940 | Viruses | Viruses | 276 | 7.29e-70 | NTclustered | gi|2468022649|gb|OQ633420.1| | 3035940 | g46155 | i0 | 97.516 | 2.00621118012422 | 161 | 4 | 100 | 0 | 1 | 161 | 22121 | 21961 | Pseudomonas phage PotUPM1, complete genome | blastn | 323 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage PotUPM1 | |||||
| 22978506 | 22978506 | PRJEB29441_P_NODE_28379_length_197_cov_1.033784_g27938_i0 | PRJEB29441 | 28379 | 197 | 1.033784 | 2.03655448 | Warsawvirus wv3MF5 | 3433337 | Viruses | Viruses | 241 | 3.3900000000000008e-59 | NTclustered | gi|2046341757|ref|NC_054890.1| | 2749426 | g27938 | i0 | 89.84 | 1.7005076142132 | 187 | 19 | 95 | 0 | 1 | 187 | 14010 | 13824 | Pseudomonas phage vB_PsyP_3MF5, complete genome | blastn | 335 | 241 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Warsawvirus | Warsawvirus wv3MF5 | ||
| 22978554 | 22978554 | PRJEB29441_P_NODE_31659_length_186_cov_1.489051_g31218_i0 | PRJEB29441 | 31659 | 186 | 1.489051 | 2.76963486 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 200 | 5.369999999999999e-47 | NTclustered | gi|2057995593|tpg|BK047028.1| | 2832643 | g31218 | i0 | 86.022 | 1 | 186 | 26 | 100 | 0 | 1 | 186 | 17731 | 17546 | MAG TPA_asm: Caudoviricetes sp. isolate ctl4d2, partial genome | blastn | 186 | 200 | 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);;