contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2292304 | 2292304 | PRJNA1078753_P_NODE_41662_length_242_cov_0.911243_g41466_i0 | PRJNA1078753 | 41662 | 242 | 0.911243 | 2.20520806 | Paramyxoviridae | 11158 | Viruses | Viruses | 448 | 2.3799999999999995e-121 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g41466 | i0 | 100 | 68.2148760330578 | 242 | 0 | 100 | 0 | 1 | 242 | 13003 | 12762 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 16508 | 448 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 2743426 | 2743426 | PRJNA1078753_P_NODE_7483_length_396_cov_3.563467_g7287_i0 | PRJNA1078753 | 7483 | 396 | 3.563467 | 14.11132932 | Crinivirus ipomeae | 3428114 | Viruses | Viruses | 52.8 | 0.038 | NTclustered | gi|1563209845|gb|MH614270.1| | 81931 | g7287 | i0 | 100 | 0.0707070707070707 | 28 | 0 | 7 | 0 | 333 | 360 | 5718 | 5691 | Sweet potato chlorotic stunt virus isolate SPCSV-UNB-01 segment RNA2, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Crinivirus | Crinivirus ipomeae | ||
| 3567679 | 3567679 | PRJNA1078753_P_NODE_9103_length_368_cov_1.044068_g8907_i0 | PRJNA1078753 | 9103 | 368 | 1.044068 | 3.84217024 | Paramyxoviridae | 11158 | Viruses | Viruses | 675 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g8907 | i0 | 99.728 | 85.2798913043478 | 368 | 1 | 100 | 0 | 1 | 368 | 1656 | 1289 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 31383 | 680 | 0.992647058823529 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 9945008 | 9945008 | PRJNA1078753_P_NODE_1668_length_746_cov_1.306092_g1494_i0 | PRJNA1078753 | 1668 | 746 | 1.306092 | 9.74344632 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1367 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g1494 | i0 | 99.732 | 73.3632707774799 | 746 | 2 | 100 | 0 | 1 | 746 | 4609 | 3864 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 54729 | 1373 | 0.995630007283321 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12495740 | 12495740 | PRJNA1078753_P_NODE_31370_length_248_cov_2.640000_g31174_i0 | PRJNA1078753 | 31370 | 248 | 2.64 | 6.5472 | Paramyxoviridae | 11158 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g31174 | i0 | 100 | 96.9838709677419 | 248 | 0 | 100 | 0 | 1 | 248 | 4540 | 4787 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 24052 | 459 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 14221150 | 14221150 | PRJNA1078753_P_NODE_11592_length_337_cov_1.295455_g11396_i0 | PRJNA1078753 | 11592 | 337 | 1.295455 | 4.36568335 | Sopapen virus | 3131614 | Viruses | Viruses | 139 | 2.37e-28 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g11396 | i0 | 93.548 | 7.86943620178042 | 93 | 6 | 28 | 0 | 82 | 174 | 435 | 527 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 2652 | 139 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 15044525 | 15044525 | PRJNA1078753_P_NODE_19332_length_281_cov_1.475962_g19136_i0 | PRJNA1078753 | 19332 | 281 | 1.475962 | 4.14745322 | Paramyxoviridae | 11158 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g19136 | i0 | 100 | 68.9964412811388 | 281 | 0 | 100 | 0 | 1 | 281 | 2514 | 2234 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 19388 | 520 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 16319307 | 16319307 | PRJNA1078753_P_NODE_12693_length_326_cov_1.818182_g12497_i0 | PRJNA1078753 | 12693 | 326 | 1.818182 | 5.92727332 | Paramyxoviridae | 11158 | Viruses | Viruses | 597 | 3.139999999999999e-166 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g12497 | i0 | 99.693 | 83.9815950920245 | 326 | 1 | 100 | 0 | 1 | 326 | 6500 | 6175 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 27378 | 603 | 0.990049751243781 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 17594714 | 17594714 | PRJNA1078753_P_NODE_30214_length_249_cov_0.875000_g30018_i0 | PRJNA1078753 | 30214 | 249 | 0.875 | 2.17875 | Paramyxoviridae | 11158 | Viruses | Viruses | 460 | 3.16e-125 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g30018 | i0 | 100 | 67.6987951807229 | 249 | 0 | 100 | 0 | 1 | 249 | 2538 | 2786 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 16857 | 460 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 19318469 | 19318469 | PRJNA1078753_P_NODE_9736_length_359_cov_1.356643_g9540_i0 | PRJNA1078753 | 9736 | 359 | 1.356643 | 4.87034837 | Fabavirus betaviciae | 3047702 | Viruses | Viruses | 259 | 1.87e-64 | NTclustered | gi|2202597465|gb|MZ571837.1| | 76875 | g9540 | i0 | 80.347 | 4.14763231197772 | 346 | 65 | 96 | 3 | 1 | 344 | 2864 | 3208 | Broad bean wilt virus 2 isolate LNSY-YZC segment RNA2, complete sequence | blastn | 1489 | 259 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Fabavirus | Fabavirus betaviciae | ||
| 20143315 | 20143315 | PRJNA1078753_P_NODE_30836_length_249_cov_0.875000_g30640_i0 | PRJNA1078753 | 30836 | 249 | 0.875 | 2.17875 | Orthorubulavirus | 2560195 | Viruses | Viruses | 460 | 3.16e-125 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g30640 | i0 | 100 | 68.7228915662651 | 249 | 0 | 100 | 0 | 1 | 249 | 6482 | 6234 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17112 | 460 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21418885 | 21418885 | PRJNA1078753_P_NODE_1737_length_735_cov_1.122356_g1561_i0 | PRJNA1078753 | 1737 | 735 | 1.122356 | 8.2493166 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1347 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g1561 | i0 | 99.728 | 97.9931972789116 | 735 | 2 | 100 | 0 | 1 | 735 | 5350 | 4616 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 72025 | 1347 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24418554 | 24418554 | PRJNA1078753_P_NODE_40060_length_243_cov_0.905882_g39864_i0 | PRJNA1078753 | 40060 | 243 | 0.905882 | 2.20129326 | Sopafab virus | 3131770 | Viruses | Viruses | 300 | 7.08e-77 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g39864 | i0 | 89.583 | 243.802469135802 | 240 | 20 | 98 | 5 | 2 | 238 | 3124 | 3361 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 59244 | 300 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus |
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);;