contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1130570 | 1130570 | PRJNA560932_P_NODE_25641_length_352_cov_1.713262_g25285_i0 | PRJNA560932 | 25641 | 352 | 1.713262 | 6.03068224 | Betaretrovirus | 140052 | Viruses | Viruses | 651 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g25285 | i0 | 100 | 3.59659090909091 | 352 | 0 | 100 | 0 | 1 | 352 | 4365 | 4014 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1266 | 651 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 2405940 | 2405940 | PRJNA560932_P_NODE_24702_length_358_cov_1.059649_g24346_i0 | PRJNA560932 | 24702 | 358 | 1.059649 | 3.7935434200000002 | Mimivirus | 315393 | Viruses | Viruses | 189 | 2.48e-43 | NTclustered | gi|2267817464|gb|MW685904.1| | 212035 | g24346 | i0 | 80.233 | 16.8128491620112 | 258 | 46 | 72 | 5 | 1 | 256 | 795379 | 795125 | Acanthamoeba polyphaga mimivirus isolate M4, complete genome | blastn | 6019 | 189 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 2405950 | 2405950 | PRJNA560932_P_NODE_33302_length_314_cov_1.481328_g32946_i0 | PRJNA560932 | 33302 | 314 | 1.481328 | 4.65136992 | Betaretrovirus | 140052 | Viruses | Viruses | 569 | 6.559999999999998e-158 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g32946 | i0 | 99.363 | 4.28980891719745 | 314 | 2 | 100 | 0 | 1 | 314 | 7700 | 8013 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1347 | 569 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 4372274 | 4372274 | PRJNA560932_P_NODE_57804_length_247_cov_0.885057_g57448_i0 | PRJNA560932 | 57804 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|2914928861|gb|OR221539.1| | 2832643 | g57448 | i0 | 99.595 | 99.7125506072875 | 247 | 1 | 100 | 0 | 1 | 247 | 14024 | 13778 | MAG: Caudoviricetes sp. isolate MSP1537 genomic sequence | blastn | 24629 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6234114 | 6234114 | PRJNA560932_P_NODE_20385_length_390_cov_1.552050_g20029_i0 | PRJNA560932 | 20385 | 390 | 1.55205 | 6.052995 | Betaretrovirus | 140052 | Viruses | Viruses | 710 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g20029 | i0 | 99.487 | 3.15128205128205 | 390 | 2 | 100 | 0 | 1 | 390 | 1053 | 664 | Squirrel monkey retrovirus, complete genome | blastn | 1229 | 710 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 6922692 | 6922692 | PRJNA560932_P_NODE_41606_length_283_cov_1.195238_g41250_i0 | PRJNA560932 | 41606 | 283 | 1.195238 | 3.38252354 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.3 | 4.28e-15 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g41250 | i0 | 98.148 | 25.7526501766784 | 54 | 1 | 19 | 0 | 225 | 278 | 4 | 57 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 7288 | 95.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8197721 | 8197721 | PRJNA560932_P_NODE_53867_length_250_cov_0.870056_g53511_i0 | PRJNA560932 | 53867 | 250 | 0.870056 | 2.17514 | Lentivirus simimdef | 3418654 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|444342259|gb|JX498544.1| | 11723 | g53511 | i0 | 100 | 2.016 | 28 | 0 | 11 | 0 | 143 | 170 | 482 | 455 | Simian immunodeficiency virus isolate P146.P1A12 from USA rev protein (rev) gene, complete cds; tat protein (tat) gene, partial cds; envelope glycoprotein (env) gene, complete cds; and nonfunctional nef protein (nef) gene, partial sequence | blastn | 504 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus simimdef | ||
| 9473074 | 9473074 | PRJNA560932_P_NODE_15768_length_442_cov_1.149051_g15413_i0 | PRJNA560932 | 15768 | 442 | 1.149051 | 5.07880542 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 784 | 0 | NTclustered | gi|3273865|gb|AF071010.1|AF071010 | 11757 | g15413 | i0 | 98.643 | 54.1131221719457 | 442 | 6 | 100 | 0 | 1 | 442 | 2350 | 2791 | Mouse mammary tumor virus putative integrase, env polyprotein, and superantigen mRNA, complete cds | blastn | 23918 | 784 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 9473123 | 9473123 | PRJNA560932_P_NODE_20688_length_387_cov_4.952229_g20332_i0 | PRJNA560932 | 20688 | 387 | 4.952229 | 19.16512623 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 566 | 1.0699999999999999e-156 | NTclustered | gi|332046|gb|M13080.1|MLVLTRAB | 11786 | g20332 | i0 | 98.746 | 121.509043927649 | 319 | 3 | 98 | 1 | 70 | 387 | 125 | 443 | Murine leukemia virus RadLV variant, proviral LTR from cell line Ti-8 | blastn | 47024 | 566 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 10059076 | 10059076 | PRJNA560932_P_NODE_14888_length_454_cov_2.228346_g14533_i0 | PRJNA560932 | 14888 | 454 | 2.228346 | 10.11669084 | Betaretrovirus | 140052 | Viruses | Viruses | 826 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g14533 | i0 | 99.559 | 8.51982378854625 | 454 | 1 | 100 | 1 | 1 | 454 | 8199 | 8651 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 3868 | 826 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 12023659 | 12023659 | PRJNA560932_P_NODE_24010_length_362_cov_2.453287_g23654_i0 | PRJNA560932 | 24010 | 362 | 2.453287 | 8.88089894 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 669 | 0 | NTclustered | gi|2733486712|gb|PP781986.1| | 333761 | g23654 | i0 | 100 | 100 | 362 | 0 | 100 | 0 | 1 | 362 | 1460 | 1099 | Human papillomavirus 18 isolate InDRE-41Tams/Mexico/2023, complete genome | blastn | 36200 | 669 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 7 | ||
| 13298819 | 13298819 | PRJNA560932_P_NODE_51731_length_251_cov_1.724719_g51375_i0 | PRJNA560932 | 51731 | 251 | 1.724719 | 4.32904469 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 183 | 7.73e-42 | NTclustered | gi|1174571674|gb|KY684104.1| | 1977638 | g51375 | i0 | 84.699 | 107.107569721116 | 183 | 28 | 73 | 0 | 67 | 249 | 162161 | 161979 | Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence | blastn | 26884 | 183 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 16433272 | 16433272 | PRJNA560932_P_NODE_59113_length_246_cov_1.335260_g58757_i0 | PRJNA560932 | 59113 | 246 | 1.33526 | 3.2847396 | Betaretrovirus | 140052 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g58757 | i0 | 100 | 4 | 246 | 0 | 100 | 0 | 1 | 246 | 6488 | 6733 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 984 | 455 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 17122531 | 17122531 | PRJNA560932_P_NODE_58134_length_247_cov_0.885057_g57778_i0 | PRJNA560932 | 58134 | 247 | 0.885057 | 2.18609079 | Faxonius propinquus nudivirus | 3139431 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2717329057|gb|PP539709.1| | 3139431 | g57778 | i0 | 92.683 | 0.331983805668016 | 41 | 0 | 16 | 2 | 11 | 49 | 124550 | 124589 | Faxonius propinquus nudivirus isolate FP6H, complete genome | blastn | 82 | 56.5 | 1 | Viruses | Naldaviricetes | Lefavirales | Nudiviridae | Faxonius propinquus nudivirus | |||||
| 18396660 | 18396660 | PRJNA560932_P_NODE_49675_length_258_cov_1.162162_g49319_i0 | PRJNA560932 | 49675 | 258 | 1.162162 | 2.99837796 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 460 | 3.29e-125 | NTclustered | gi|3273865|gb|AF071010.1|AF071010 | 11757 | g49319 | i0 | 98.837 | 69.2945736434109 | 258 | 3 | 100 | 0 | 1 | 258 | 1610 | 1353 | Mouse mammary tumor virus putative integrase, env polyprotein, and superantigen mRNA, complete cds | blastn | 17878 | 460 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 18981943 | 18981943 | PRJNA560932_P_NODE_29435_length_331_cov_2.875969_g29079_i0 | PRJNA560932 | 29435 | 331 | 2.875969 | 9.51945739 | Betaretrovirus | 140052 | Viruses | Viruses | 612 | 1.14e-170 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g29079 | i0 | 100 | 4.20845921450151 | 331 | 0 | 100 | 0 | 1 | 331 | 5862 | 5532 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1393 | 612 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 19671113 | 19671113 | PRJNA560932_P_NODE_30696_length_326_cov_1.217391_g30340_i0 | PRJNA560932 | 30696 | 326 | 1.217391 | 3.96869466 | Microviridae sp. | 2202644 | Viruses | Viruses | 52.8 | 0.031 | NTclustered | gi|2636866959|gb|OR407820.1| | 2202644 | g30340 | i0 | 100 | 0.0858895705521472 | 28 | 0 | 9 | 0 | 204 | 231 | 364 | 391 | MAG: Microviridae sp. isolate xizangnaqu01-28471 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 19671219 | 19671219 | PRJNA560932_P_NODE_43856_length_276_cov_1.310345_g43500_i0 | PRJNA560932 | 43856 | 276 | 1.310345 | 3.6165522 | Bacteriophage sp. | 38018 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2293573864|gb|OP072313.1| | 38018 | g43500 | i0 | 90.909 | 0.264492753623188 | 44 | 1 | 16 | 2 | 64 | 107 | 70212 | 70252 | MAG: Bacteriophage sp. isolate 2452_64193, partial genome | blastn | 73 | 56.5 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 20257102 | 20257102 | PRJNA560932_P_NODE_5436_length_735_cov_1.993958_g5105_i0 | PRJNA560932 | 5436 | 735 | 1.993958 | 14.6555913 | Tequatrovirus | 10663 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g5105 | i0 | 100 | 79.4557823129252 | 584 | 0 | 79 | 0 | 152 | 735 | 38777 | 38194 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 58400 | 1079 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 20946763 | 20946763 | PRJNA560932_P_NODE_28157_length_338_cov_1.773585_g27801_i0 | PRJNA560932 | 28157 | 338 | 1.773585 | 5.9947173 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 625 | 1.4999999999999999e-174 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g27801 | i0 | 100 | 4 | 338 | 0 | 100 | 0 | 1 | 338 | 2431 | 2094 | Squirrel monkey retrovirus, complete genome | blastn | 1352 | 625 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 22221980 | 22221980 | PRJNA560932_P_NODE_8218_length_606_cov_1.744841_g7865_i0 | PRJNA560932 | 8218 | 606 | 1.744841 | 10.57373646 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 62.1 | 9.97e-5 | NTclustered | gi|407734945|gb|JX447155.1| | 11676 | g7865 | i0 | 95 | 0.132013201320132 | 40 | 0 | 7 | 2 | 27 | 66 | 4357 | 4394 | HIV-1 isolate AA039a03R from Thailand pol protein (pol) gene, partial cds; and vif protein (vif), vpr protein (vpr), vpu protein (vpu), envelope glycoprotein (env), and nef protein (nef) genes, complete cds | blastn | 80 | 62.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 22807673 | 22807673 | PRJNA560932_P_NODE_18_length_4859_cov_3.129545_g12_i0 | PRJNA560932 | 18 | 4859 | 3.129545 | 152.06459155 | Gammaretrovirus | 153135 | Viruses | Viruses | 8346 | 0 | NTclustered | gi|1167936743|gb|KY574509.1| | 11786 | g12 | i0 | 98.239 | 97.1697880222268 | 4771 | 84 | 98 | 0 | 75 | 4845 | 2472 | 7242 | Murine leukemia virus isolate Akv2-C78, complete genome | blastn | 472148 | 8346 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 22807687 | 22807687 | PRJNA560932_P_NODE_30458_length_327_cov_1.216535_g30102_i0 | PRJNA560932 | 30458 | 327 | 1.216535 | 3.97806945 | Betaretrovirus | 140052 | Viruses | Viruses | 604 | 1.8799999999999993e-168 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g30102 | i0 | 100 | 3.75840978593272 | 327 | 0 | 100 | 0 | 1 | 327 | 4724 | 4398 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1229 | 604 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon |
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);;