contig_metadata
16 rows where bioproject = "PRJNA797475", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1216876 | 1216876 | PRJNA797475_P_NODE_241_length_1671_cov_21.771589_g203_i1 | PRJNA797475 | 241 | 1671 | 21.771589 | 363.80325219 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2961 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g203 | i1 | 98.682 | 76.2423698384201 | 1669 | 22 | 99 | 0 | 3 | 1671 | 43 | 1711 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 127401 | 2961 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2492410 | 2492410 | PRJNA797475_P_NODE_322_length_1507_cov_4.813808_g288_i0 | PRJNA797475 | 322 | 1507 | 4.813808 | 72.54408656 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2756 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g288 | i0 | 99.668 | 83.0889183808892 | 1507 | 5 | 100 | 0 | 1 | 1507 | 6837 | 8343 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 125215 | 2756 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3768708 | 3768708 | PRJNA797475_P_NODE_9403_length_340_cov_1.430712_g9304_i0 | PRJNA797475 | 9403 | 340 | 1.430712 | 4.8644208 | Orthorubulavirus | 2560195 | Viruses | Viruses | 628 | 1.1699999999999999e-175 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g9304 | i0 | 100 | 68.8911764705882 | 340 | 0 | 100 | 0 | 1 | 340 | 11586 | 11247 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 23423 | 628 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7595051 | 7595051 | PRJNA797475_P_NODE_20226_length_256_cov_2.098361_g20127_i0 | PRJNA797475 | 20226 | 256 | 2.098361 | 5.37180416 | Orthorubulavirus | 2560195 | Viruses | Viruses | 473 | 4.189999999999999e-129 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g20127 | i0 | 100 | 69.95703125 | 256 | 0 | 100 | 0 | 1 | 256 | 12138 | 12393 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17909 | 473 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10145455 | 10145455 | PRJNA797475_P_NODE_228_length_1698_cov_20.818462_g203_i0 | PRJNA797475 | 228 | 1698 | 20.818462 | 353.49748476 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3094 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g203 | i0 | 99.587 | 76.1419316843345 | 1696 | 7 | 99 | 0 | 3 | 1698 | 68 | 1763 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 129289 | 3097 | 0.99903132063287 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13970952 | 13970952 | PRJNA797475_P_NODE_491_length_1267_cov_22.970687_g446_i0 | PRJNA797475 | 491 | 1267 | 22.970687 | 291.03860429 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2329 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g446 | i0 | 99.842 | 84.4443567482242 | 1267 | 2 | 100 | 0 | 1 | 1267 | 3061 | 1795 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 106991 | 2340 | 0.995299145299145 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13970958 | 13970958 | PRJNA797475_P_NODE_731_length_1070_cov_13.996991_g29_i1 | PRJNA797475 | 731 | 1070 | 13.996991 | 149.7678037 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1943 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g29 | i1 | 99.439 | 68.985046728972 | 1070 | 6 | 100 | 0 | 1 | 1070 | 4187 | 3118 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 73814 | 1943 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15245354 | 15245354 | PRJNA797475_P_NODE_192_length_1780_cov_6.115407_g172_i0 | PRJNA797475 | 192 | 1780 | 6.115407 | 108.8542446 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3260 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g172 | i0 | 99.775 | 83.2151685393258 | 1777 | 4 | 99 | 0 | 4 | 1780 | 8259 | 6483 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 148123 | 3277 | 0.9948123283491 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15245394 | 15245394 | PRJNA797475_P_NODE_7592_length_371_cov_2.241611_g7493_i0 | PRJNA797475 | 7592 | 371 | 2.241611 | 8.31637681 | Orthorubulavirus | 2560195 | Viruses | Viruses | 680 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g7493 | i0 | 99.73 | 69.1940700808625 | 371 | 1 | 100 | 0 | 1 | 371 | 11049 | 10679 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25671 | 686 | 0.991253644314869 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16519889 | 16519889 | PRJNA797475_P_NODE_4073_length_493_cov_1.997619_g3975_i0 | PRJNA797475 | 4073 | 493 | 1.997619 | 9.84826167 | Orthorubulavirus | 2560195 | Viruses | Viruses | 905 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3975 | i0 | 99.797 | 69.2758620689655 | 493 | 1 | 100 | 0 | 1 | 493 | 9891 | 9399 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 34153 | 905 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16519895 | 16519895 | PRJNA797475_P_NODE_733_length_1069_cov_13.400602_g29_i2 | PRJNA797475 | 733 | 1069 | 13.400602 | 143.25243538 | Paramyxoviridae | 11158 | Viruses | Viruses | 1934 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g29 | i2 | 99.345 | 68.9859681945744 | 1068 | 7 | 99 | 0 | 1 | 1068 | 2057 | 3124 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 73746 | 1936 | 0.99896694214876 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 16519900 | 16519900 | PRJNA797475_P_NODE_9933_length_332_cov_1.918919_g9834_i0 | PRJNA797475 | 9933 | 332 | 1.918919 | 6.37081108 | Orthorubulavirus | 2560195 | Viruses | Viruses | 614 | 3.1799999999999995e-171 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g9834 | i0 | 100 | 70.3463855421687 | 332 | 0 | 100 | 0 | 1 | 332 | 6483 | 6152 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 23355 | 614 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 19068661 | 19068661 | PRJNA797475_P_NODE_35_length_2752_cov_10.711459_g29_i0 | PRJNA797475 | 35 | 2752 | 10.711459 | 294.77935168 | Orthorubulavirus | 2560195 | Viruses | Viruses | 5005 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g29 | i0 | 99.491 | 85.8288517441861 | 2752 | 14 | 100 | 0 | 1 | 2752 | 6162 | 3411 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 236201 | 5011 | 0.99880263420475 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21619103 | 21619103 | PRJNA797475_P_NODE_3417_length_532_cov_1.259259_g3319_i0 | PRJNA797475 | 3417 | 532 | 1.259259 | 6.69925788 | Orthorubulavirus | 2560195 | Viruses | Viruses | 974 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3319 | i0 | 99.811 | 69.1691729323308 | 530 | 1 | 99 | 0 | 2 | 531 | 10383 | 9854 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 36798 | 974 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25443759 | 25443759 | PRJNA797475_P_NODE_4640_length_464_cov_1.104859_g4542_i0 | PRJNA797475 | 4640 | 464 | 1.104859 | 5.12654576 | Orthorubulavirus | 2560195 | Viruses | Viruses | 841 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4542 | i0 | 99.353 | 67 | 464 | 3 | 100 | 0 | 1 | 464 | 13582 | 13119 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 31088 | 846 | 0.994089834515366 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25443770 | 25443770 | PRJNA797475_P_NODE_800_length_1034_cov_12.527575_g29_i3 | PRJNA797475 | 800 | 1034 | 12.527575 | 129.5351255 | Paramyxoviridae | 11158 | Viruses | Viruses | 1866 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g29 | i3 | 99.226 | 69.0522243713733 | 1034 | 8 | 100 | 0 | 1 | 1034 | 3382 | 2349 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 71400 | 1871 | 0.997327632282202 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza 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);;