contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA772154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1206760 | 1206760 | PRJNA772154_P_NODE_12461_length_314_cov_2.709544_g12276_i0 | PRJNA772154 | 12461 | 314 | 2.709544 | 8.50796816 | Orthorubulavirus | 2560195 | Viruses | Viruses | 580 | 3.0299999999999992e-161 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g12276 | i0 | 100 | 68.5796178343949 | 314 | 0 | 100 | 0 | 1 | 314 | 4181 | 4494 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 21534 | 580 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2482190 | 2482190 | PRJNA772154_P_NODE_11402_length_332_cov_1.505792_g11217_i0 | PRJNA772154 | 11402 | 332 | 1.505792 | 4.99922944 | Orthorubulavirus | 2560195 | Viruses | Viruses | 614 | 3.1799999999999995e-171 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g11217 | i0 | 100 | 97.0030120481928 | 332 | 0 | 100 | 0 | 1 | 332 | 1291 | 960 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 32205 | 614 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2482203 | 2482203 | PRJNA772154_P_NODE_14742_length_283_cov_2.100000_g14557_i0 | PRJNA772154 | 14742 | 283 | 2.1 | 5.943 | Orthorubulavirus | 2560195 | Viruses | Viruses | 484 | 2.1699999999999994e-132 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14557 | i0 | 97.527 | 67.7279151943463 | 283 | 7 | 100 | 0 | 1 | 283 | 12755 | 12473 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 19167 | 484 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6310874 | 6310874 | PRJNA772154_P_NODE_9745_length_367_cov_1.829932_g9560_i0 | PRJNA772154 | 9745 | 367 | 1.829932 | 6.71585044 | Orthorubulavirus | 2560195 | Viruses | Viruses | 671 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g9560 | i0 | 99.727 | 79.6185286103542 | 366 | 1 | 99 | 0 | 1 | 366 | 433 | 68 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 29220 | 673 | 0.99702823179792 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7584838 | 7584838 | PRJNA772154_P_NODE_1326_length_1277_cov_2.633721_g1221_i0 | PRJNA772154 | 1326 | 1277 | 2.633721 | 33.63261717 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2335 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g1221 | i0 | 99.687 | 75.9169929522318 | 1277 | 3 | 100 | 1 | 1 | 1277 | 1648 | 373 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 96946 | 2335 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10135386 | 10135386 | PRJNA772154_P_NODE_1668_length_1137_cov_2.846805_g1541_i0 | PRJNA772154 | 1668 | 1137 | 2.846805 | 32.36817285 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2076 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g1541 | i0 | 99.648 | 85.0439753737907 | 1137 | 2 | 100 | 1 | 1 | 1137 | 2940 | 1806 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 96695 | 2087 | 0.994729276473407 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13501144 | 13501144 | PRJNA772154_P_NODE_19571_length_249_cov_0.886364_g19386_i0 | PRJNA772154 | 19571 | 249 | 0.886364 | 2.20704636 | Betacoronavirus muris | 3433759 | Viruses | Viruses | 403 | 5.3999999999999986e-108 | NTclustered | gi|2333448071|gb|OK491634.1| | 11138 | g19386 | i0 | 95.968 | 97.2289156626506 | 248 | 10 | 99 | 0 | 1 | 248 | 29896 | 30143 | Murine hepatitis virus strain COR-118, complete genome | blastn | 24210 | 403 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus muris | ||
| 13960747 | 13960747 | PRJNA772154_P_NODE_13951_length_292_cov_1.671233_g13766_i0 | PRJNA772154 | 13951 | 292 | 1.671233 | 4.88000036 | Orthorubulavirus | 2560195 | Viruses | Viruses | 529 | 1.0299999999999996e-145 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g13766 | i0 | 99.315 | 71.2671232876712 | 292 | 2 | 100 | 0 | 1 | 292 | 8417 | 8126 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20810 | 534 | 0.99063670411985 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16509762 | 16509762 | PRJNA772154_P_NODE_5973_length_511_cov_3.025114_g5789_i0 | PRJNA772154 | 5973 | 511 | 3.025114 | 15.45833254 | Orthorubulavirus | 2560195 | Viruses | Viruses | 944 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g5789 | i0 | 100 | 83 | 511 | 0 | 100 | 0 | 1 | 511 | 8157 | 7647 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 42413 | 944 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18599047 | 18599047 | PRJNA772154_P_NODE_16135_length_267_cov_1.608247_g15950_i0 | PRJNA772154 | 16135 | 267 | 1.608247 | 4.29401949 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 488 | 1.5699999999999998e-133 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g15950 | i0 | 99.625 | 67.9475655430712 | 267 | 1 | 100 | 0 | 1 | 267 | 10634 | 10900 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 18142 | 488 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22884511 | 22884511 | PRJNA772154_P_NODE_14518_length_286_cov_1.098592_g14333_i0 | PRJNA772154 | 14518 | 286 | 1.098592 | 3.14197312 | Orthorubulavirus | 2560195 | Viruses | Viruses | 529 | 1e-145 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14333 | i0 | 100 | 83.8216783216783 | 286 | 0 | 100 | 0 | 1 | 286 | 7002 | 7287 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 23973 | 529 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22884551 | 22884551 | PRJNA772154_P_NODE_3198_length_778_cov_2.295035_g3028_i0 | PRJNA772154 | 3198 | 778 | 2.295035 | 17.8553723 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1426 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3028 | i0 | 99.743 | 69 | 778 | 2 | 100 | 0 | 1 | 778 | 3960 | 3183 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 53682 | 1426 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24158448 | 24158448 | PRJNA772154_P_NODE_14159_length_290_cov_1.119816_g13974_i0 | PRJNA772154 | 14159 | 290 | 1.119816 | 3.2474664 | Orthorubulavirus | 2560195 | Viruses | Viruses | 531 | 2.83e-146 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g13974 | i0 | 99.655 | 97.9896551724138 | 290 | 1 | 100 | 0 | 1 | 290 | 575 | 286 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 28417 | 531 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;