contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1009467 | 1009467 | PRJNA1046144_P_NODE_72021_length_198_cov_8.798450_g71726_i0 | PRJNA1046144 | 72021 | 198 | 8.79845 | 17.420931 | Betaretrovirus | 140052 | Viruses | Viruses | 361 | 2.51e-95 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g71726 | i0 | 99.495 | 4 | 198 | 1 | 100 | 0 | 1 | 198 | 2098 | 2295 | Squirrel monkey retrovirus, complete genome | blastn | 792 | 361 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 1447558 | 1447558 | PRJNA1046144_P_NODE_67182_length_227_cov_4.556962_g66887_i0 | PRJNA1046144 | 67182 | 227 | 4.556962 | 10.34430374 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 420 | 4.81e-113 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g66887 | i0 | 100 | 4.00440528634361 | 227 | 0 | 100 | 0 | 1 | 227 | 2079 | 1853 | Squirrel monkey retrovirus, complete genome | blastn | 909 | 420 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 3559579 | 3559579 | PRJNA1046144_P_NODE_12463_length_452_cov_6.122715_g12168_i0 | PRJNA1046144 | 12463 | 452 | 6.122715 | 27.6746718 | Betaretrovirus | 140052 | Viruses | Viruses | 824 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g12168 | i0 | 99.558 | 5.23672566371681 | 452 | 2 | 100 | 0 | 1 | 452 | 8100 | 7649 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 2367 | 824 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 7387285 | 7387285 | PRJNA1046144_P_NODE_9266_length_519_cov_4.026667_g8973_i0 | PRJNA1046144 | 9266 | 519 | 4.026667 | 20.89840173 | Betaretrovirus | 140052 | Viruses | Viruses | 959 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g8973 | i0 | 100 | 7.83236994219653 | 519 | 0 | 100 | 0 | 1 | 519 | 8583 | 8065 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 4065 | 959 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 10375524 | 10375524 | PRJNA1046144_P_NODE_37429_length_279_cov_1.800000_g37134_i0 | PRJNA1046144 | 37429 | 279 | 1.8 | 5.022 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 516 | 7.58e-142 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g37134 | i0 | 100 | 3 | 279 | 0 | 100 | 0 | 1 | 279 | 1034 | 1312 | Squirrel monkey retrovirus, complete genome | blastn | 837 | 516 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 12487790 | 12487790 | PRJNA1046144_P_NODE_13030_length_443_cov_2.417112_g12735_i0 | PRJNA1046144 | 13030 | 443 | 2.417112 | 10.70780616 | Betaretrovirus | 140052 | Viruses | Viruses | 797 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g12735 | i0 | 99.097 | 4.08126410835214 | 443 | 4 | 100 | 0 | 1 | 443 | 1887 | 1445 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1808 | 797 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 12488404 | 12488404 | PRJNA1046144_P_NODE_9270_length_519_cov_2.751111_g8977_i0 | PRJNA1046144 | 9270 | 519 | 2.751111 | 14.27826609 | Betaretrovirus | 140052 | Viruses | Viruses | 937 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g8977 | i0 | 99.229 | 3.11368015414258 | 519 | 4 | 100 | 0 | 1 | 519 | 3371 | 2853 | Squirrel monkey retrovirus, complete genome | blastn | 1616 | 937 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 14201596 | 14201596 | PRJNA1046144_P_NODE_6892_length_601_cov_1.590226_g6603_i0 | PRJNA1046144 | 6892 | 601 | 1.590226 | 9.55725826 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 1099 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g6603 | i0 | 99.667 | 4.66888519134775 | 601 | 2 | 100 | 0 | 1 | 601 | 367 | 967 | Squirrel monkey retrovirus, complete genome | blastn | 2806 | 1099 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 17586781 | 17586781 | PRJNA1046144_P_NODE_1894_length_1099_cov_3.131068_g1729_i0 | PRJNA1046144 | 1894 | 1099 | 3.131068 | 34.41043732 | Betaretrovirus | 140052 | Viruses | Viruses | 2019 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g1729 | i0 | 99.818 | 4 | 1099 | 2 | 100 | 0 | 1 | 1099 | 7594 | 6496 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 4396 | 2019 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 18860724 | 18860724 | PRJNA1046144_P_NODE_3415_length_836_cov_4.744459_g3179_i0 | PRJNA1046144 | 3415 | 836 | 4.744459 | 39.66367724 | Betaretrovirus | 140052 | Viruses | Viruses | 1535 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g3179 | i0 | 99.761 | 4.06459330143541 | 838 | 0 | 100 | 2 | 1 | 836 | 3617 | 4454 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 3398 | 1535 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 25235501 | 25235501 | PRJNA1046144_P_NODE_4480_length_739_cov_3.495522_g4215_i0 | PRJNA1046144 | 4480 | 739 | 3.495522 | 25.83190758 | Betaretrovirus | 140052 | Viruses | Viruses | 1360 | 0 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g4215 | i0 | 99.865 | 4.20297699594046 | 739 | 1 | 100 | 0 | 1 | 739 | 6236 | 5498 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 3106 | 1360 | 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);;