contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1167252" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1588906 | 1588906 | PRJNA1167252_P_NODE_13202_length_339_cov_2.323308_g12929_i0 | PRJNA1167252 | 13202 | 339 | 2.323308 | 7.87601412 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 627 | 4.1799999999999996e-175 | NTclustered | gi|927440244|emb|LN651193.1| | 28354 | g12929 | i0 | 100 | 50.6253687315634 | 339 | 0 | 100 | 0 | 1 | 339 | 597 | 935 | Plantago asiatica mosaic virus CP gene for coat protein, isolate LIL1.2 | blastn | 17162 | 627 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 1589433 | 1589433 | PRJNA1167252_P_NODE_4842_length_612_cov_1.445269_g4572_i0 | PRJNA1167252 | 4842 | 612 | 1.445269 | 8.84504628 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 1109 | 0 | NTclustered | gi|1049927946|gb|KX245539.1| | 28354 | g4572 | i0 | 99.346 | 49.6078431372549 | 612 | 4 | 100 | 0 | 1 | 612 | 5469 | 4858 | Plantago asiatica mosaic virus strain CAAS01, complete genome | blastn | 30360 | 1109 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 1589515 | 1589515 | PRJNA1167252_P_NODE_7802_length_459_cov_1.515544_g7529_i0 | PRJNA1167252 | 7802 | 459 | 1.515544 | 6.95634696 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 848 | 0 | NTclustered | gi|1049927946|gb|KX245539.1| | 28354 | g7529 | i0 | 100 | 26.880174291939 | 459 | 0 | 100 | 0 | 1 | 459 | 1081 | 623 | Plantago asiatica mosaic virus strain CAAS01, complete genome | blastn | 12338 | 848 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 6692281 | 6692281 | PRJNA1167252_P_NODE_18106_length_287_cov_1.093458_g17833_i0 | PRJNA1167252 | 18106 | 287 | 1.093458 | 3.13822446 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 520 | 6.049999999999999e-143 | NTclustered | gi|1018644214|gb|KU159092.1| | 28354 | g17833 | i0 | 99.303 | 15 | 287 | 2 | 100 | 0 | 1 | 287 | 1448 | 1162 | Plantago asiatica mosaic virus isolate Ko-JJ_3-1, complete genome | blastn | 4305 | 520 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 10518570 | 10518570 | PRJNA1167252_P_NODE_9709_length_404_cov_1.413897_g9436_i0 | PRJNA1167252 | 9709 | 404 | 1.413897 | 5.71214388 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 741 | 0 | NTclustered | gi|1018644205|gb|KU159091.1| | 28354 | g9436 | i0 | 99.752 | 15.8514851485149 | 404 | 1 | 100 | 0 | 1 | 404 | 2190 | 1787 | Plantago asiatica mosaic virus isolate Ko-JJ_2-2, complete genome | blastn | 6404 | 741 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 13067913 | 13067913 | PRJNA1167252_P_NODE_15111_length_316_cov_1.279835_g14838_i0 | PRJNA1167252 | 15111 | 316 | 1.279835 | 4.0442786 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 584 | 2.359999999999999e-162 | NTclustered | gi|1049927946|gb|KX245539.1| | 28354 | g14838 | i0 | 100 | 24.5189873417722 | 316 | 0 | 100 | 0 | 1 | 316 | 3610 | 3925 | Plantago asiatica mosaic virus strain CAAS01, complete genome | blastn | 7748 | 584 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 14343129 | 14343129 | PRJNA1167252_P_NODE_10792_length_380_cov_1.462541_g10519_i0 | PRJNA1167252 | 10792 | 380 | 1.462541 | 5.5576558 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 675 | 0 | NTclustered | gi|1049927946|gb|KX245539.1| | 28354 | g10519 | i0 | 98.684 | 16.8289473684211 | 380 | 5 | 100 | 0 | 1 | 380 | 1820 | 1441 | Plantago asiatica mosaic virus strain CAAS01, complete genome | blastn | 6395 | 675 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 16891342 | 16891342 | PRJNA1167252_P_NODE_13574_length_334_cov_1.712644_g13301_i0 | PRJNA1167252 | 13574 | 334 | 1.712644 | 5.72023096 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 612 | 1.15e-170 | NTclustered | gi|1018644214|gb|KU159092.1| | 28354 | g13301 | i0 | 99.701 | 34.3622754491018 | 334 | 1 | 100 | 0 | 1 | 334 | 3320 | 3653 | Plantago asiatica mosaic virus isolate Ko-JJ_3-1, complete genome | blastn | 11477 | 612 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 18166022 | 18166022 | PRJNA1167252_P_NODE_18615_length_283_cov_1.057143_g18342_i0 | PRJNA1167252 | 18615 | 283 | 1.057143 | 2.99171469 | Ripagrog virus | 3130723 | Viruses | Viruses | 281 | 3.06e-71 | NTclustered | gi|2717320584|gb|PP173025.1| | 3130723 | g18342 | i0 | 89.286 | 184.017667844523 | 224 | 24 | 79 | 0 | 4 | 227 | 1939 | 1716 | MAG: Ripagrog virus isolate KCAP2_k141_407948 genomic sequence | blastn | 52077 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripagrog virus | |||||
| 21991292 | 21991292 | PRJNA1167252_P_NODE_27238_length_245_cov_1.936047_g26965_i0 | PRJNA1167252 | 27238 | 245 | 1.936047 | 4.74331515 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|927440246|emb|LN651194.1| | 28354 | g26965 | i0 | 100 | 41.6571428571429 | 245 | 0 | 100 | 0 | 1 | 245 | 625 | 381 | Plantago asiatica mosaic virus CP gene for coat protein, isolate LIL6 | blastn | 10206 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis | ||
| 24540392 | 24540392 | PRJNA1167252_P_NODE_21300_length_262_cov_1.650794_g21027_i0 | PRJNA1167252 | 21300 | 262 | 1.650794 | 4.32508028 | Potexvirus marmorplantagonis | 3433852 | Viruses | Viruses | 468 | 1.9999999999999996e-127 | NTclustered | gi|545669889|gb|KF471012.1| | 28354 | g21027 | i0 | 98.855 | 15 | 262 | 3 | 100 | 0 | 1 | 262 | 761 | 500 | Plantago asiatica mosaic virus RNA-dependent RNA polymerase gene, partial cds; and triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds | blastn | 3930 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmorplantagonis |
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);;