contig_metadata
11 rows where bioproject = "PRJNA1078753", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 29941291 | 29941291 | PRJNA1078753_P_NODE_4011_length_513_cov_2.588636_g3817_i0 | PRJNA1078753 | 4011 | 513 | 2.588636 | 13.27970268 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 91.7 | 6.69e-18 | NR | WLN26256.1 | 3065075 | g3817 | i0 | 51.7 | 0.508771929824561 | 87 | 42 | 50.9 | 0 | 250 | 510 | 229 | 315 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 261 | 91.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31512813 | 31512813 | PRJNA1078753_P_NODE_13256_length_321_cov_1.495968_g13060_i0 | PRJNA1078753 | 13256 | 321 | 1.495968 | 4.80205728 | Chuvivirus | 2842604 | Viruses | Viruses | 131 | 1.17e-33 | NR | WET19887.1 | 2842604 | g13060 | i0 | 64.2 | 1.98130841121495 | 106 | 38 | 99.1 | 0 | 2 | 319 | 243 | 348 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 636 | 131 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;