contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1151835 | 1151835 | PRJNA631119_P_NODE_20701_length_293_cov_1.645455_g20583_i0 | PRJNA631119 | 20701 | 293 | 1.645455 | 4.82118315 | Orthorubulavirus | 2560195 | Viruses | Viruses | 542 | 1.32e-149 | NTclustered | gi|1394370381|gb|MH362816.1| | 2560580 | g20583 | i0 | 100 | 64 | 293 | 0 | 100 | 0 | 1 | 293 | 15036 | 14744 | Mammalian orthorubulavirus 5 strain CAN, complete genome | blastn | 18752 | 542 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2427027 | 2427027 | PRJNA631119_P_NODE_13742_length_340_cov_2.531835_g13624_i0 | PRJNA631119 | 13742 | 340 | 2.531835 | 8.608239 | Paramyxoviridae | 11158 | Viruses | Viruses | 614 | 3.2699999999999995e-171 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g13624 | i0 | 99.408 | 67.6 | 338 | 2 | 99 | 0 | 1 | 338 | 2757 | 3094 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 22984 | 614 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 2427174 | 2427174 | PRJNA631119_P_NODE_3502_length_588_cov_2.252427_g3390_i0 | PRJNA631119 | 3502 | 588 | 2.252427 | 13.24427076 | Paramyxoviridae | 11158 | Viruses | Viruses | 1075 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g3390 | i0 | 99.66 | 97 | 588 | 2 | 100 | 0 | 1 | 588 | 4275 | 4862 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 57036 | 1081 | 0.994449583718779 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 4980195 | 4980195 | PRJNA631119_P_NODE_9244_length_395_cov_1.416149_g9126_i0 | PRJNA631119 | 9244 | 395 | 1.416149 | 5.59378855 | Paramyxoviridae | 11158 | Viruses | Viruses | 730 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g9126 | i0 | 100 | 68 | 395 | 0 | 100 | 0 | 1 | 395 | 2783 | 2389 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 26860 | 730 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 6255600 | 6255600 | PRJNA631119_P_NODE_40485_length_230_cov_2.687898_g40367_i0 | PRJNA631119 | 40485 | 230 | 2.687898 | 6.1821654 | Orthorubulavirus | 2560195 | Viruses | Viruses | 411 | 2.939999999999999e-110 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g40367 | i0 | 99.123 | 51.5782608695652 | 228 | 2 | 99 | 0 | 3 | 230 | 6450 | 6223 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 11863 | 411 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6981692 | 6981692 | PRJNA631119_P_NODE_31606_length_250_cov_1.288136_g31488_i0 | PRJNA631119 | 31606 | 250 | 1.288136 | 3.22034 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g31488 | i0 | 100 | 83.896 | 250 | 0 | 100 | 0 | 1 | 250 | 529 | 778 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 20974 | 462 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8804729 | 8804729 | PRJNA631119_P_NODE_11647_length_361_cov_3.777778_g11529_i0 | PRJNA631119 | 11647 | 361 | 3.777778 | 13.63777858 | Orthorubulavirus | 2560195 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g11529 | i0 | 100 | 79.4875346260388 | 361 | 0 | 100 | 0 | 1 | 361 | 402 | 42 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 28695 | 667 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 17729685 | 17729685 | PRJNA631119_P_NODE_1794_length_790_cov_1.820084_g1692_i0 | PRJNA631119 | 1794 | 790 | 1.820084 | 14.3786636 | Paramyxoviridae | 11158 | Viruses | Viruses | 1421 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g1692 | i0 | 99.114 | 72.5696202531646 | 790 | 7 | 100 | 0 | 1 | 790 | 897 | 108 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 57330 | 1421 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 19729848 | 19729848 | PRJNA631119_P_NODE_29796_length_254_cov_2.016575_g29678_i0 | PRJNA631119 | 29796 | 254 | 2.016575 | 5.1221005 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g29678 | i0 | 100 | 83.9330708661417 | 254 | 0 | 100 | 0 | 1 | 254 | 7187 | 7440 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 21319 | 470 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 19729900 | 19729900 | PRJNA631119_P_NODE_40296_length_232_cov_3.352201_g40178_i0 | PRJNA631119 | 40296 | 232 | 3.352201 | 7.77710632 | Chrocurosk virus | 3129322 | Viruses | Viruses | 285 | 1.88e-72 | NTclustered | gi|2717317280|gb|PP171770.1| | 3129322 | g40178 | i0 | 88.936 | 192.663793103448 | 235 | 20 | 99 | 6 | 2 | 232 | 1662 | 1894 | MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence | blastn | 44698 | 285 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocurosk virus | |||
| 24829571 | 24829571 | PRJNA631119_P_NODE_41080_length_211_cov_4.057971_g40962_i0 | PRJNA631119 | 41080 | 211 | 4.057971 | 8.56231881 | Tiger orthorubulavirus | 3028512 | Viruses | Viruses | 390 | 3.459999999999999e-104 | NTclustered | gi|2465104481|gb|OQ236149.1| | 3028512 | g40962 | i0 | 100 | 67.9952606635071 | 211 | 0 | 100 | 0 | 1 | 211 | 3320 | 3110 | MAG: Tiger orthorubulavirus isolate PMV/GD/ZAK2044/2021 genomic sequence | blastn | 14347 | 390 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Tiger orthorubulavirus |
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);;