contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA781453" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1212188 | 1212188 | PRJNA781453_P_NODE_28781_length_268_cov_1.497436_g28666_i0 | PRJNA781453 | 28781 | 268 | 1.497436 | 4.01312848 | Carlavirus | 12163 | Viruses | Viruses | 468 | 2.06e-127 | NTclustered | gi|1081700958|gb|KU896946.1| | 12169 | g28666 | i0 | 98.134 | 35.1865671641791 | 268 | 5 | 100 | 0 | 1 | 268 | 1871 | 1604 | Potato virus S isolate HB7, complete genome | blastn | 9430 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 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. | |||||
| 4590387 | 4590387 | PRJNA781453_P_NODE_11184_length_445_cov_1.666667_g11070_i0 | PRJNA781453 | 11184 | 445 | 1.666667 | 7.41666815 | Bacteriophage sp. | 38018 | Viruses | Viruses | 817 | 0 | NTclustered | gi|2059912809|tpg|BK041510.1| | 38018 | g11070 | i0 | 99.775 | 35.5505617977528 | 445 | 1 | 100 | 0 | 1 | 445 | 37605 | 37161 | MAG TPA_asm: Bacteriophage sp. isolate cthoT2, partial genome | blastn | 15820 | 817 | 1 | Viruses | Bacteriophage 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. | |||||
| 7141040 | 7141040 | PRJNA781453_P_NODE_24946_length_291_cov_1.224771_g24831_i0 | PRJNA781453 | 24946 | 291 | 1.224771 | 3.56408361 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 488 | 1.7299999999999995e-133 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24831 | i0 | 96.907 | 99.7731958762887 | 291 | 9 | 100 | 0 | 1 | 291 | 6781 | 7071 | Potato virus S isolate X1-SD, complete genome | blastn | 29034 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 7141584 | 7141584 | PRJNA781453_P_NODE_6486_length_588_cov_1.943689_g6376_i0 | PRJNA781453 | 6486 | 588 | 1.943689 | 11.42889132 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 1086 | 0 | NTclustered | gi|2209095232|gb|OL472818.1| | 2900455 | g6376 | i0 | 100 | 4.98639455782313 | 588 | 0 | 100 | 0 | 1 | 588 | 4476 | 3889 | MAG: Brine shrimp yue-like virus 3 isolate SH/98 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2932 | 1086 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 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. | |||||
| 10966597 | 10966597 | PRJNA781453_P_NODE_22309_length_309_cov_1.305085_g22194_i0 | PRJNA781453 | 22309 | 309 | 1.305085 | 4.03271265 | Avian carcinoma virus | 11958 | Viruses | Viruses | 555 | 1.7999999999999994e-153 | NTclustered | gi|209658|gb|M25158.1|AC2TKSEA | 11958 | g22194 | i0 | 99.029 | 99.7928802588997 | 309 | 3 | 100 | 0 | 1 | 309 | 1704 | 1396 | Avian retrovirus proviral tyrosine kinase (ENV-SEA oncogene), 3' end | blastn | 30836 | 555 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian carcinoma virus | ||
| 10966852 | 10966852 | PRJNA781453_P_NODE_31029_length_256_cov_1.016393_g30914_i0 | PRJNA781453 | 31029 | 256 | 1.016393 | 2.60196608 | Potyvirus rapae | 3240607 | Viruses | Viruses | 457 | 4.22e-124 | NTclustered | gi|2019445938|dbj|LC537503.1| | 12230 | g30914 | i0 | 98.828 | 100 | 256 | 3 | 100 | 0 | 1 | 256 | 8845 | 9100 | Turnip mosaic virus CHN244 RNA, nearly complete sequence | blastn | 25600 | 457 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 12691914 | 12691914 | PRJNA781453_P_NODE_38750_length_243_cov_0.905882_g38635_i0 | PRJNA781453 | 38750 | 243 | 0.905882 | 2.20129326 | Carlavirus | 12163 | Viruses | Viruses | 427 | 3.11e-115 | NTclustered | gi|1746543057|gb|MN095414.1| | 12169 | g38635 | i0 | 98.354 | 97.7942386831276 | 243 | 4 | 100 | 0 | 1 | 243 | 4992 | 5234 | Potato virus S isolate KZ.Ushkonyr, complete genome | blastn | 23764 | 427 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 13516061 | 13516061 | PRJNA781453_P_NODE_15851_length_368_cov_1.037288_g15737_i0 | PRJNA781453 | 15851 | 368 | 1.037288 | 3.81721984 | Potyvirus rapae | 3240607 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2019445986|dbj|LC537527.1| | 12230 | g15737 | i0 | 99.455 | 99.7255434782609 | 367 | 2 | 99 | 0 | 2 | 368 | 7384 | 7750 | Turnip mosaic virus CHZH34A RNA, nearly complete sequence | blastn | 36699 | 667 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 14791446 | 14791446 | PRJNA781453_P_NODE_35132_length_248_cov_0.862857_g35017_i0 | PRJNA781453 | 35132 | 248 | 0.862857 | 2.13988536 | Potyvirus rapae | 3240607 | Viruses | Viruses | 420 | 5.34e-113 | NTclustered | gi|2019445942|dbj|LC537505.1| | 12230 | g35017 | i0 | 97.177 | 100.008064516129 | 248 | 7 | 100 | 0 | 1 | 248 | 3048 | 2801 | Turnip mosaic virus CHN254 RNA, nearly complete sequence | blastn | 24802 | 420 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus rapae | ||
| 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 | |||||
| 16515139 | 16515139 | PRJNA781453_P_NODE_24693_length_293_cov_1.045455_g24578_i0 | PRJNA781453 | 24693 | 293 | 1.045455 | 3.06318315 | root | 1 | Root_unresolved | Root_unresolved | 542 | 1.32e-149 | NTclustered | gi|829492|gb|U24467.1|HIV1U24467 | 11676 | g24578 | i0 | 100 | 121.235494880546 | 293 | 0 | 100 | 0 | 1 | 293 | 318 | 26 | Human immunodeficiency virus type 1 patient 3799(9-93), clone 15 LTR, (nef), partial cds | blastn | 35522 | 542 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 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. | |||||
| 18614464 | 18614464 | PRJNA781453_P_NODE_35655_length_247_cov_0.885057_g35540_i0 | PRJNA781453 | 35655 | 247 | 0.885057 | 2.18609079 | Bacteriophage sp. | 38018 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2289948408|gb|OP030861.1| | 38018 | g35540 | i0 | 100 | 12 | 247 | 0 | 100 | 0 | 1 | 247 | 48601 | 48847 | MAG: Bacteriophage sp. isolate 0975_117677, partial genome | blastn | 2964 | 457 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 19889153 | 19889153 | PRJNA781453_P_NODE_17076_length_354_cov_1.096085_g16961_i0 | PRJNA781453 | 17076 | 354 | 1.096085 | 3.8801409 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 643 | 4.3399999999999985e-180 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g16961 | i0 | 99.435 | 99.4124293785311 | 354 | 2 | 100 | 0 | 1 | 354 | 5934 | 6287 | Potato virus S isolate X1-SD, complete genome | blastn | 35192 | 643 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 19889382 | 19889382 | PRJNA781453_P_NODE_24656_length_293_cov_1.227273_g24541_i0 | PRJNA781453 | 24656 | 293 | 1.227273 | 3.59590989 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 536 | 6.149999999999998e-148 | NTclustered | gi|1825505916|gb|MT107560.1| | 12169 | g24541 | i0 | 99.659 | 99.8668941979522 | 293 | 1 | 100 | 0 | 1 | 293 | 7943 | 7651 | Potato virus S isolate X1-SD, complete genome | blastn | 29261 | 536 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 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. | |||||
| 24988649 | 24988649 | PRJNA781453_P_NODE_12760_length_413_cov_1.358824_g12646_i0 | PRJNA781453 | 12760 | 413 | 1.358824 | 5.61194312 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 741 | 0 | NTclustered | gi|1002341922|gb|KU058657.1| | 12169 | g12646 | i0 | 99.031 | 57.041162227602896 | 413 | 4 | 100 | 0 | 1 | 413 | 8197 | 7785 | Potato virus S isolate NZ-A ab030 Lincoln, complete genome | blastn | 23558 | 741 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 24989344 | 24989344 | PRJNA781453_P_NODE_36240_length_246_cov_0.890173_g36125_i0 | PRJNA781453 | 36240 | 246 | 0.890173 | 2.18982558 | Bacteriophage sp. | 38018 | Viruses | Viruses | 283 | 7.239999999999999e-72 | NTclustered | gi|2053043885|tpg|BK024308.1| | 38018 | g36125 | i0 | 87.5 | 5.44308943089431 | 248 | 27 | 100 | 4 | 1 | 246 | 16937 | 17182 | MAG TPA_asm: Bacteriophage sp. isolate ctrOp24, partial genome | blastn | 1339 | 283 | 1 | Viruses | Bacteriophage 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);;