contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742864 | 742864 | PRJNA763243_P_NODE_22201_length_339_cov_5.037594_g21855_i0 | PRJNA763243 | 22201 | 339 | 5.037594 | 17.07744366 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 588 | 1.97e-163 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g21855 | i0 | 97.935 | 4.18289085545723 | 339 | 7 | 100 | 0 | 1 | 339 | 3608 | 3946 | Squirrel monkey retrovirus, complete genome | blastn | 1418 | 588 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 1205101 | 1205101 | PRJNA763243_P_NODE_3221_length_752_cov_5.014728_g2944_i0 | PRJNA763243 | 3221 | 752 | 5.014728 | 37.71075456 | Betaretrovirus | 140052 | Viruses | Viruses | 1225 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g2944 | i0 | 99.263 | 12.7061170212766 | 678 | 5 | 90 | 0 | 1 | 678 | 4759 | 5436 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 9555 | 1225 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 7583216 | 7583216 | PRJNA763243_P_NODE_32406_length_299_cov_7.977876_g32060_i0 | PRJNA763243 | 32406 | 299 | 7.977876 | 23.85384924 | root | 1 | Root_unresolved | Root_unresolved | 534 | 2.26e-147 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g32060 | i0 | 98.997 | 100.257525083612 | 299 | 2 | 100 | 1 | 1 | 299 | 1660 | 1957 | Moloney murine leukemia virus, complete genome | blastn | 29977 | 534 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 8858260 | 8858260 | PRJNA763243_P_NODE_1987_length_922_cov_3.783274_g1756_i0 | PRJNA763243 | 1987 | 922 | 3.783274 | 34.88178628 | Betaretrovirus | 140052 | Viruses | Viruses | 1664 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g1756 | i0 | 99.241 | 3.73101952277657 | 922 | 7 | 100 | 0 | 1 | 922 | 1159 | 2080 | Squirrel monkey retrovirus, complete genome | blastn | 3440 | 1664 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 8858332 | 8858332 | PRJNA763243_P_NODE_3407_length_734_cov_5.065053_g3127_i0 | PRJNA763243 | 3407 | 734 | 5.065053 | 37.17748902 | Gammaretrovirus | 153135 | Viruses | Viruses | 1328 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g3127 | i0 | 99.319 | 82.8841961852861 | 734 | 5 | 100 | 0 | 1 | 734 | 4583 | 5316 | Moloney murine leukemia virus, complete genome | blastn | 60837 | 1328 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 9671054 | 9671054 | PRJNA763243_P_NODE_1288_length_1091_cov_5.167976_g1108_i0 | PRJNA763243 | 1288 | 1091 | 5.167976 | 56.38261816 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 1977 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g1108 | i0 | 99.358 | 3.58020164986251 | 1091 | 7 | 100 | 0 | 1 | 1091 | 3616 | 2526 | Squirrel monkey retrovirus, complete genome | blastn | 3906 | 1977 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 12223277 | 12223277 | PRJNA763243_P_NODE_54430_length_249_cov_0.875000_g54084_i0 | PRJNA763243 | 54430 | 249 | 0.875 | 2.17875 | Gammaretrovirus momursar | 3428958 | Viruses | Viruses | 446 | 8.849999999999999e-121 | NTclustered | gi|332197|gb|M30733.1|MSVP21A | 11809 | g54084 | i0 | 100 | 62.2369477911647 | 241 | 0 | 97 | 0 | 6 | 246 | 960 | 720 | Murine sarcoma virus p21 ras protein, complete cds | blastn | 15497 | 446 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus momursar | ||
| 12684793 | 12684793 | PRJNA763243_P_NODE_12590_length_429_cov_2.848315_g12245_i0 | PRJNA763243 | 12590 | 429 | 2.848315 | 12.21927135 | Betaretrovirus | 140052 | Viruses | Viruses | 571 | 2.569999999999999e-158 | NTclustered | gi|332630|gb|M13260.1|PCSRVLTR | 11856 | g12245 | i0 | 96.532 | 6.88111888111888 | 346 | 11 | 100 | 1 | 1 | 345 | 214 | 559 | Squirrel monkey retrovirus 5' LTR | blastn | 2952 | 571 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 13496763 | 13496763 | PRJNA763243_P_NODE_291_length_1907_cov_5.963468_g230_i0 | PRJNA763243 | 291 | 1907 | 5.963468 | 113.72333476 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 3406 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g230 | i0 | 98.899 | 4.50865233350813 | 1907 | 21 | 100 | 0 | 1 | 1907 | 6205 | 8111 | Squirrel monkey retrovirus, complete genome | blastn | 8598 | 3406 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 13959105 | 13959105 | PRJNA763243_P_NODE_10771_length_459_cov_13.233161_g10428_i0 | PRJNA763243 | 10771 | 459 | 13.233161 | 60.74020899 | root | 1 | Root_unresolved | Root_unresolved | 837 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g10428 | i0 | 99.564 | 15.7930283224401 | 459 | 2 | 100 | 0 | 1 | 459 | 6678 | 6220 | Moloney murine leukemia virus, complete genome | blastn | 7249 | 837 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 13959258 | 13959258 | PRJNA763243_P_NODE_42591_length_270_cov_9.563452_g42245_i0 | PRJNA763243 | 42591 | 270 | 9.563452 | 25.8213204 | root | 1 | Root_unresolved | Root_unresolved | 499 | 7.349999999999998e-137 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g42245 | i0 | 100 | 99.9814814814815 | 270 | 0 | 100 | 0 | 1 | 270 | 3354 | 3623 | Moloney murine leukemia virus, complete genome | blastn | 26995 | 499 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 16508063 | 16508063 | PRJNA763243_P_NODE_2953_length_783_cov_5.819718_g2682_i0 | PRJNA763243 | 2953 | 783 | 5.819718 | 45.56839194 | Betaretrovirus | 140052 | Viruses | Viruses | 1435 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g2682 | i0 | 99.745 | 4.19157088122605 | 783 | 2 | 100 | 0 | 1 | 783 | 5459 | 6241 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 3282 | 1435 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 17322112 | 17322112 | PRJNA763243_P_NODE_61994_length_242_cov_1.426036_g61648_i0 | PRJNA763243 | 61994 | 242 | 1.426036 | 3.45100712 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 448 | 2.3799999999999995e-121 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g61648 | i0 | 100 | 4.00826446280992 | 242 | 0 | 100 | 0 | 1 | 242 | 2523 | 2282 | Squirrel monkey retrovirus, complete genome | blastn | 970 | 448 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 17782796 | 17782796 | PRJNA763243_P_NODE_2534_length_833_cov_7.155263_g2276_i0 | PRJNA763243 | 2534 | 833 | 7.155263 | 59.60334079 | Betaretrovirus | 140052 | Viruses | Viruses | 1522 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g2276 | i0 | 99.64 | 3.62304921968787 | 833 | 3 | 100 | 0 | 1 | 833 | 3921 | 4753 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 3018 | 1522 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 20331643 | 20331643 | PRJNA763243_P_NODE_40576_length_275_cov_4.668317_g40230_i0 | PRJNA763243 | 40576 | 275 | 4.668317 | 12.83787175 | root | 1 | Root_unresolved | Root_unresolved | 499 | 7.51e-137 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g40230 | i0 | 100 | 98.4545454545455 | 270 | 0 | 98 | 0 | 6 | 275 | 2261 | 1992 | Moloney murine leukemia virus, complete genome | blastn | 27075 | 499 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 22882878 | 22882878 | PRJNA763243_P_NODE_25218_length_322_cov_6.502008_g24872_i0 | PRJNA763243 | 25218 | 322 | 6.502008 | 20.93646576 | Gammaretrovirus | 153135 | Viruses | Viruses | 590 | 5.18e-164 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g24872 | i0 | 99.689 | 100 | 322 | 1 | 100 | 0 | 1 | 322 | 3618 | 3939 | Moloney murine leukemia virus, complete genome | blastn | 32200 | 590 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 22883058 | 22883058 | PRJNA763243_P_NODE_7078_length_546_cov_4.509514_g6740_i0 | PRJNA763243 | 7078 | 546 | 4.509514 | 24.62194644 | Betaretrovirus | 140052 | Viruses | Viruses | 909 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g6740 | i0 | 97.212 | 3.28388278388278 | 538 | 14 | 99 | 1 | 1 | 538 | 1081 | 545 | Squirrel monkey retrovirus, complete genome | blastn | 1793 | 909 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 24157060 | 24157060 | PRJNA763243_P_NODE_72579_length_208_cov_5.555556_g72233_i0 | PRJNA763243 | 72579 | 208 | 5.555556 | 11.55555648 | root | 1 | Root_unresolved | Root_unresolved | 379 | 7.359999999999998e-101 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g72233 | i0 | 99.519 | 99.375 | 208 | 1 | 100 | 0 | 1 | 208 | 1719 | 1512 | Moloney murine leukemia virus, complete genome | blastn | 20670 | 379 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 25431958 | 25431958 | PRJNA763243_P_NODE_6580_length_562_cov_4.697342_g6248_i0 | PRJNA763243 | 6580 | 562 | 4.697342 | 26.39906204 | Gammaretrovirus | 153135 | Viruses | Viruses | 1011 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g6248 | i0 | 99.11 | 99.5427046263345 | 562 | 5 | 100 | 0 | 1 | 562 | 3960 | 4521 | Moloney murine leukemia virus, complete genome | blastn | 55943 | 1011 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;