contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1473724 | 1473724 | PRJNA1093380_P_NODE_2462_length_371_cov_1.033557_g2356_i0 | PRJNA1093380 | 2462 | 371 | 1.033557 | 3.83449647 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 686 | 0 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g2356 | i0 | 100 | 68.1563342318059 | 371 | 0 | 100 | 0 | 1 | 371 | 10682 | 11052 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 25286 | 686 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1473730 | 1473730 | PRJNA1093380_P_NODE_2742_length_358_cov_2.403509_g2636_i0 | PRJNA1093380 | 2742 | 358 | 2.403509 | 8.60456222 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g2636 | i0 | 100 | 0.0782122905027933 | 28 | 0 | 8 | 0 | 60 | 87 | 1596 | 1569 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2749879 | 2749879 | PRJNA1093380_P_NODE_3543_length_327_cov_1.062992_g3437_i0 | PRJNA1093380 | 3543 | 327 | 1.062992 | 3.47598384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 571 | 1.9099999999999998e-158 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g3437 | i0 | 98.165 | 1 | 327 | 6 | 100 | 0 | 1 | 327 | 34526 | 34852 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 327 | 571 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2749882 | 2749882 | PRJNA1093380_P_NODE_3983_length_312_cov_1.539749_g3877_i0 | PRJNA1093380 | 3983 | 312 | 1.539749 | 4.80401688 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 571 | 1.81e-158 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g3877 | i0 | 99.679 | 1 | 312 | 1 | 100 | 0 | 1 | 312 | 44612 | 44301 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 312 | 571 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5302032 | 5302032 | PRJNA1093380_P_NODE_4465_length_304_cov_1.251082_g4359_i0 | PRJNA1093380 | 4465 | 304 | 1.251082 | 3.80328928 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 274 | 5.55e-69 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g4359 | i0 | 85.878 | 0.861842105263158 | 262 | 32 | 86 | 5 | 1 | 261 | 15549 | 15292 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 262 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7851865 | 7851865 | PRJNA1093380_P_NODE_17947_length_226_cov_2.013072_g17841_i0 | PRJNA1093380 | 17947 | 226 | 2.013072 | 4.54954272 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 374 | 3.7799999999999985e-99 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g17841 | i0 | 96.861 | 1.97345132743363 | 223 | 7 | 99 | 0 | 1 | 223 | 40330 | 40552 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 446 | 374 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9126738 | 9126738 | PRJNA1093380_P_NODE_11748_length_251_cov_1.977528_g11642_i0 | PRJNA1093380 | 11748 | 251 | 1.977528 | 4.96359528 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 368 | 1.99e-97 | NTclustered | gi|2059891082|tpg|BK041165.1| | 2832643 | g11642 | i0 | 93.522 | 38.5657370517928 | 247 | 16 | 98 | 0 | 5 | 251 | 17915 | 17669 | MAG TPA_asm: Caudoviricetes sp. isolate ctXUT2, partial genome | blastn | 9680 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9126823 | 9126823 | PRJNA1093380_P_NODE_2408_length_374_cov_1.146179_g2302_i0 | PRJNA1093380 | 2408 | 374 | 1.146179 | 4.28670946 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 686 | 0 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g2302 | i0 | 99.733 | 1 | 374 | 1 | 100 | 0 | 1 | 374 | 22033 | 21660 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 374 | 686 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10402365 | 10402365 | PRJNA1093380_P_NODE_13709_length_248_cov_0.880000_g13603_i0 | PRJNA1093380 | 13709 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2054697996|tpg|BK052940.1| | 2832643 | g13603 | i0 | 100 | 21.7540322580645 | 248 | 0 | 100 | 0 | 1 | 248 | 12693 | 12940 | MAG TPA_asm: Caudoviricetes sp. isolate ctFOz5, partial genome | blastn | 5395 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10402387 | 10402387 | PRJNA1093380_P_NODE_14749_length_245_cov_2.424419_g14643_i0 | PRJNA1093380 | 14749 | 245 | 2.424419 | 5.93982655 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g14643 | i0 | 99.592 | 1 | 245 | 1 | 100 | 0 | 1 | 245 | 39708 | 39952 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 245 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10402509 | 10402509 | PRJNA1093380_P_NODE_7469_length_276_cov_1.517241_g7363_i0 | PRJNA1093380 | 7469 | 276 | 1.517241 | 4.18758516 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 316 | 8.149999999999999e-82 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g7363 | i0 | 87.319 | 1.98913043478261 | 276 | 35 | 100 | 0 | 1 | 276 | 45066 | 44791 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 549 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 11222621 | 11222621 | PRJNA1093380_P_NODE_10949_length_256_cov_1.857923_g10843_i0 | PRJNA1093380 | 10949 | 256 | 1.857923 | 4.75628288 | root | 1 | Root_unresolved | Root_unresolved | 340 | 4.44e-89 | NTclustered | gi|6180218|gb|AF065710.2|AF065710 | 36452 | g10843 | i0 | 90.625 | 43.22265625 | 256 | 24 | 100 | 0 | 1 | 256 | 2067 | 2322 | Stealth virus 1 clone C16134 T3 | blastn | 11065 | 340 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus cercopithecinebeta5 | ||
| 12952925 | 12952925 | PRJNA1093380_P_NODE_4391_length_306_cov_1.351931_g4285_i0 | PRJNA1093380 | 4391 | 306 | 1.351931 | 4.13690886 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 505 | 1.8199999999999998e-138 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g4285 | i0 | 96.405 | 1 | 306 | 11 | 100 | 0 | 1 | 306 | 43895 | 44200 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 306 | 505 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14227793 | 14227793 | PRJNA1093380_P_NODE_1372_length_473_cov_1.732500_g1267_i0 | PRJNA1093380 | 1372 | 473 | 1.7325 | 8.194725 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 763 | 0 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g1267 | i0 | 95.772 | 1 | 473 | 20 | 100 | 0 | 1 | 473 | 34222 | 33750 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 473 | 763 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15046883 | 15046883 | PRJNA1093380_P_NODE_14652_length_246_cov_0.890173_g14546_i0 | PRJNA1093380 | 14652 | 246 | 0.890173 | 2.18982558 | Christensenvirus | 2732061 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2312628476|gb|OP251154.1| | 2978981 | g14546 | i0 | 100 | 5.4390243902439 | 246 | 0 | 100 | 0 | 1 | 246 | 37862 | 37617 | Escherichia phage TR2, complete genome | blastn | 1338 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR2 | |||
| 15501838 | 15501838 | PRJNA1093380_P_NODE_3353_length_333_cov_1.611538_g3247_i0 | PRJNA1093380 | 3353 | 333 | 1.611538 | 5.36642154 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 1.3e-80 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g3247 | i0 | 98.315 | 1.92492492492492 | 178 | 3 | 53 | 0 | 156 | 333 | 30472 | 30649 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 641 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15501945 | 15501945 | PRJNA1093380_P_NODE_9713_length_264_cov_0.984293_g9607_i0 | PRJNA1093380 | 9713 | 264 | 0.984293 | 2.59853352 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 1.68e-78 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g9607 | i0 | 87.879 | 1 | 264 | 26 | 100 | 3 | 1 | 264 | 37562 | 37305 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 264 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18050765 | 18050765 | PRJNA1093380_P_NODE_14175_length_247_cov_0.885057_g14069_i0 | PRJNA1093380 | 14175 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g14069 | i0 | 100 | 1 | 247 | 0 | 100 | 0 | 1 | 247 | 40000 | 40246 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 247 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18050864 | 18050864 | PRJNA1093380_P_NODE_5275_length_290_cov_0.889401_g5169_i0 | PRJNA1093380 | 5275 | 290 | 0.889401 | 2.5792629 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 3.849999999999999e-110 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g5169 | i0 | 91.483 | 1.09310344827586 | 317 | 0 | 100 | 1 | 1 | 290 | 13310 | 13626 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 317 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18050879 | 18050879 | PRJNA1093380_P_NODE_6655_length_281_cov_1.730769_g6549_i0 | PRJNA1093380 | 6655 | 281 | 1.730769 | 4.86346089 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 514 | 2.75e-141 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g6549 | i0 | 99.644 | 1 | 281 | 1 | 100 | 0 | 1 | 281 | 12927 | 13207 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 281 | 514 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19324881 | 19324881 | PRJNA1093380_P_NODE_3056_length_345_cov_1.452206_g2950_i0 | PRJNA1093380 | 3056 | 345 | 1.452206 | 5.0101107 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 638 | 1.97e-178 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g2950 | i0 | 100 | 13.8898550724638 | 345 | 0 | 100 | 0 | 1 | 345 | 6345 | 6001 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 4792 | 638 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19324969 | 19324969 | PRJNA1093380_P_NODE_9856_length_263_cov_1.305263_g9750_i0 | PRJNA1093380 | 9856 | 263 | 1.305263 | 3.43284169 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 1.67e-78 | NTclustered | gi|2915030437|gb|OR222657.1| | 2832643 | g9750 | i0 | 87.786 | 3.39923954372624 | 262 | 30 | 99 | 2 | 1 | 261 | 17017 | 16757 | MAG: Caudoviricetes sp. isolate MSP0272 genomic sequence | blastn | 894 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20600228 | 20600228 | PRJNA1093380_P_NODE_4437_length_305_cov_0.995690_g4331_i0 | PRJNA1093380 | 4437 | 305 | 0.99569 | 3.0368545 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g4331 | i0 | 100 | 1 | 305 | 0 | 100 | 0 | 1 | 305 | 18363 | 18667 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 305 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21875882 | 21875882 | PRJNA1093380_P_NODE_10758_length_257_cov_2.108696_g10652_i0 | PRJNA1093380 | 10758 | 257 | 2.108696 | 5.41934872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 9.51e-96 | NTclustered | gi|2914949116|gb|OR221876.1| | 2832643 | g10652 | i0 | 92.52 | 0.988326848249027 | 254 | 17 | 98 | 2 | 5 | 257 | 6122 | 6374 | MAG: Caudoviricetes sp. isolate MSP1134 genomic sequence | blastn | 254 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23151411 | 23151411 | PRJNA1093380_P_NODE_16159_length_243_cov_0.905882_g16053_i0 | PRJNA1093380 | 16159 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 372 | 1.48e-98 | NTclustered | gi|2914875093|gb|OR221474.1| | 2832643 | g16053 | i0 | 96.053 | 2.08230452674897 | 228 | 9 | 94 | 0 | 16 | 243 | 31862 | 32089 | MAG: Caudoviricetes sp. isolate MSP1603 genomic sequence | blastn | 506 | 372 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23971485 | 23971485 | PRJNA1093380_P_NODE_11679_length_252_cov_1.262570_g11573_i0 | PRJNA1093380 | 11679 | 252 | 1.26257 | 3.1816764 | Christensenvirus | 2732061 | Viruses | Viruses | 460 | 3.2e-125 | NTclustered | gi|2287965697|gb|OP087522.1| | 2972435 | g11573 | i0 | 99.603 | 11.968253968254 | 252 | 1 | 100 | 0 | 1 | 252 | 5575 | 5826 | Escherichia phage TR1, complete genome | blastn | 3016 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Escherichia phage TR1 |
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);;