contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax_kingdom = "Pararnavirae"
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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;