contig_metadata
16 rows where bioproject = "PRJNA874604", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3789788 | 3789788 | PRJNA874604_P_NODE_3083_length_885_cov_2.293103_g2816_i0 | PRJNA874604 | 3083 | 885 | 2.293103 | 20.29396155 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1613 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2816 | i0 | 99.548 | 80.8576271186441 | 885 | 4 | 100 | 0 | 1 | 885 | 952 | 68 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 71559 | 1613 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3789893 | 3789893 | PRJNA874604_P_NODE_43983_length_298_cov_1.026667_g43631_i0 | PRJNA874604 | 43983 | 298 | 1.026667 | 3.05946766 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|1387672470|gb|MH305898.1| | 11320 | g43631 | i0 | 100 | 100 | 298 | 0 | 100 | 0 | 1 | 298 | 1842 | 1545 | Influenza A virus (A/New Hampshire/19/2018(H1N1)) segment 2 polymerase PB1 (PB1) gene, complete cds; and nonfunctional PB1-F2 protein (PB1-F2) gene, complete sequence | blastn | 29800 | 551 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 3789985 | 3789985 | PRJNA874604_P_NODE_5303_length_702_cov_2.815580_g4987_i0 | PRJNA874604 | 5303 | 702 | 2.81558 | 19.7653716 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1291 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4987 | i0 | 99.858 | 68.8376068376068 | 702 | 1 | 100 | 0 | 1 | 702 | 3819 | 3118 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 48324 | 1291 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 5065915 | 5065915 | PRJNA874604_P_NODE_33264_length_331_cov_2.724806_g32912_i0 | PRJNA874604 | 33264 | 331 | 2.724806 | 9.01910786 | Orthorubulavirus | 2560195 | Viruses | Viruses | 606 | 5.299999999999998e-169 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g32912 | i0 | 99.698 | 69 | 331 | 1 | 100 | 0 | 1 | 331 | 4115 | 3785 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 22839 | 606 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 5065936 | 5065936 | PRJNA874604_P_NODE_3564_length_833_cov_2.793421_g3283_i0 | PRJNA874604 | 3564 | 833 | 2.793421 | 23.26919693 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1517 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3283 | i0 | 99.52 | 71.2641056422569 | 833 | 4 | 100 | 0 | 1 | 833 | 1748 | 916 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 59363 | 1517 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7615790 | 7615790 | PRJNA874604_P_NODE_1986_length_1070_cov_1.716148_g1768_i0 | PRJNA874604 | 1986 | 1070 | 1.716148 | 18.3627836 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1960 | 0 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g1768 | i0 | 99.72 | 97.9672897196262 | 1070 | 3 | 100 | 0 | 1 | 1070 | 391 | 1460 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 104825 | 1960 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10166352 | 10166352 | PRJNA874604_P_NODE_19248_length_409_cov_1.750000_g18896_i0 | PRJNA874604 | 19248 | 409 | 1.75 | 7.1575 | Orthorubulavirus | 2560195 | Viruses | Viruses | 739 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g18896 | i0 | 99.267 | 83.9902200488998 | 409 | 3 | 100 | 0 | 1 | 409 | 7251 | 6843 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 34352 | 745 | 0.991946308724832 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10166667 | 10166667 | PRJNA874604_P_NODE_57548_length_270_cov_1.563452_g57196_i0 | PRJNA874604 | 57548 | 270 | 1.563452 | 4.2213204 | Orthorubulavirus | 2560195 | Viruses | Viruses | 446 | 9.719999999999998e-121 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g57196 | i0 | 100 | 64.4851851851852 | 241 | 0 | 89 | 0 | 30 | 270 | 12778 | 12538 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17411 | 446 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13992007 | 13992007 | PRJNA874604_P_NODE_65011_length_257_cov_1.456522_g64659_i0 | PRJNA874604 | 65011 | 257 | 1.456522 | 3.74326154 | Orthorubulavirus | 2560195 | Viruses | Viruses | 464 | 2.5299999999999998e-126 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g64659 | i0 | 99.225 | 68.15953307393 | 258 | 1 | 100 | 1 | 1 | 257 | 9683 | 9940 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17517 | 464 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15266255 | 15266255 | PRJNA874604_P_NODE_88712_length_245_cov_0.895349_g88360_i0 | PRJNA874604 | 88712 | 245 | 0.895349 | 2.19360505 | Orthorubulavirus | 2560195 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g88360 | i0 | 100 | 68.9959183673469 | 245 | 0 | 100 | 0 | 1 | 245 | 10654 | 10410 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 16904 | 453 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16540441 | 16540441 | PRJNA874604_P_NODE_35233_length_324_cov_2.211155_g34881_i0 | PRJNA874604 | 35233 | 324 | 2.211155 | 7.1641422 | Orthorubulavirus | 2560195 | Viruses | Viruses | 588 | 1.88e-163 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g34881 | i0 | 99.383 | 78.2438271604938 | 324 | 2 | 100 | 0 | 1 | 324 | 8059 | 8382 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25351 | 593 | 0.991568296795953 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 19978045 | 19978045 | PRJNA874604_P_NODE_16896_length_431_cov_2.195531_g16544_i0 | PRJNA874604 | 16896 | 431 | 2.195531 | 9.46273861 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 785 | 0 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g16544 | i0 | 99.536 | 85.0324825986079 | 431 | 2 | 100 | 0 | 1 | 431 | 2688 | 2258 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 36649 | 785 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 20364159 | 20364159 | PRJNA874604_P_NODE_26676_length_360_cov_1.599303_g26324_i0 | PRJNA874604 | 26676 | 360 | 1.599303 | 5.7574908 | Orthorubulavirus | 2560195 | Viruses | Viruses | 660 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g26324 | i0 | 99.722 | 96.9027777777778 | 360 | 1 | 100 | 0 | 1 | 360 | 4517 | 4876 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 34885 | 665 | 0.992481203007519 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22915415 | 22915415 | PRJNA874604_P_NODE_11838_length_501_cov_3.654206_g11487_i0 | PRJNA874604 | 11838 | 501 | 3.654206 | 18.30757206 | Orthorubulavirus | 2560195 | Viruses | Viruses | 909 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g11487 | i0 | 99.401 | 81.435129740519 | 501 | 3 | 100 | 0 | 1 | 501 | 1801 | 2301 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 40799 | 909 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 24189358 | 24189358 | PRJNA874604_P_NODE_28659_length_350_cov_3.335740_g28307_i0 | PRJNA874604 | 28659 | 350 | 3.33574 | 11.67509 | Orthorubulavirus | 2560195 | Viruses | Viruses | 647 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g28307 | i0 | 100 | 85.9542857142857 | 350 | 0 | 100 | 0 | 1 | 350 | 3031 | 2682 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 30084 | 647 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 31920166 | 31920166 | PRJNA874604_P_NODE_57837_length_270_cov_1.172589_g57485_i0 | PRJNA874604 | 57837 | 270 | 1.172589 | 3.1659903 | Orthomarburgvirus marburgense | 3052505 | Viruses | Viruses | 183 | 2.53e-51 | NR | AAR85459.1 | 3052505 | g57485 | i0 | 100 | 3.95555555555556 | 89 | 0 | 98.9 | 0 | 268 | 2 | 1186 | 1274 | AAR85459.1 L protein [Orthomarburgvirus marburgense] | diamond | 1068 | 183 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Filoviridae | Orthomarburgvirus | Orthomarburgvirus marburgense |
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);;