contig_metadata
12 rows where bioproject = "PRJNA1160211", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5412535 | 5412535 | PRJNA1160211_S_NODE_175485_length_340_cov_3.850187_g174252_i0 | PRJNA1160211 | 175485 | 340 | 3.850187 | 13.0906358 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 490 | 5.74e-134 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g174252 | i0 | 100 | 123.723529411765 | 265 | 0 | 78 | 0 | 53 | 317 | 6488 | 6224 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 42066 | 490 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6687311 | 6687311 | PRJNA1160211_S_NODE_159306_length_362_cov_0.858131_g158073_i0 | PRJNA1160211 | 159306 | 362 | 0.858131 | 3.10643422 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 538 | 2.1599999999999998e-148 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g158073 | i0 | 99.66 | 75.0469613259668 | 294 | 1 | 81 | 0 | 18 | 311 | 7495 | 7788 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 27167 | 538 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9966629 | 9966629 | PRJNA1160211_S_NODE_219208_length_290_cov_3.423963_g217975_i0 | PRJNA1160211 | 219208 | 290 | 3.423963 | 9.9294927 | Orthorubulavirus | 2560195 | Viruses | Viruses | 536 | 6.079999999999999e-148 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g217975 | i0 | 100 | 73.3413793103448 | 290 | 0 | 100 | 0 | 1 | 290 | 649 | 938 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 21269 | 536 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11242183 | 11242183 | PRJNA1160211_S_NODE_5209_length_938_cov_119.989595_g4632_i0 | PRJNA1160211 | 5209 | 938 | 119.989595 | 1125.5024011 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1526 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4632 | i0 | 99.29 | 107.38592750533 | 845 | 5 | 90 | 1 | 71 | 915 | 1796 | 2639 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 100728 | 1537 | 0.992843201040989 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13791781 | 13791781 | PRJNA1160211_S_NODE_205411_length_304_cov_423.549784_g204178_i0 | PRJNA1160211 | 205411 | 304 | 423.549784 | 1287.59134336 | Orthorubulavirus | 2560195 | Viruses | Viruses | 296 | 1.19e-75 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g204178 | i0 | 100 | 49.8914473684211 | 160 | 0 | 53 | 0 | 75 | 234 | 4660 | 4501 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 15167 | 296 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13791816 | 13791816 | PRJNA1160211_S_NODE_21331_length_701_cov_1.907643_g20314_i0 | PRJNA1160211 | 21331 | 701 | 1.907643 | 13.37257743 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1133 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g20314 | i0 | 99.518 | 74.6062767475036 | 622 | 3 | 89 | 0 | 50 | 671 | 677 | 56 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 52299 | 1144 | 0.990384615384615 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16340991 | 16340991 | PRJNA1160211_S_NODE_211553_length_298_cov_2.520000_g210320_i0 | PRJNA1160211 | 211553 | 298 | 2.52 | 7.5096 | Orthorubulavirus | 2560195 | Viruses | Viruses | 551 | 2.239999999999999e-152 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g210320 | i0 | 100 | 83.0335570469799 | 298 | 0 | 100 | 0 | 1 | 298 | 2777 | 3074 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 24744 | 551 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18890293 | 18890293 | PRJNA1160211_S_NODE_278435_length_243_cov_1.958824_g277202_i0 | PRJNA1160211 | 278435 | 243 | 1.958824 | 4.75994232 | Orthorubulavirus | 2560195 | Viruses | Viruses | 438 | 1.4399999999999996e-118 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g277202 | i0 | 99.177 | 69 | 243 | 2 | 100 | 0 | 1 | 243 | 3979 | 3737 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 16767 | 438 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 18890401 | 18890401 | PRJNA1160211_S_NODE_33515_length_636_cov_2.369449_g32404_i0 | PRJNA1160211 | 33515 | 636 | 2.369449 | 15.06969564 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g32404 | i0 | 99.843 | 70.7845911949686 | 636 | 1 | 100 | 0 | 1 | 636 | 928 | 1563 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 45019 | 1170 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21986409 | 21986409 | PRJNA1160211_S_NODE_199258_length_311_cov_9.378151_g198025_i0 | PRJNA1160211 | 199258 | 311 | 9.378151 | 29.16604961 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 499 | 8.639999999999999e-137 | NTclustered | gi|2209094280|gb|OL472816.1| | 2900455 | g198025 | i0 | 100 | 3.47266881028939 | 270 | 0 | 87 | 0 | 24 | 293 | 1220 | 951 | MAG: Brine shrimp yue-like virus 3 isolate 02/QH/92-02 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1080 | 499 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 23990397 | 23990397 | PRJNA1160211_S_NODE_125759_length_412_cov_1.356932_g124529_i0 | PRJNA1160211 | 125759 | 412 | 1.356932 | 5.59055984 | Orthorubulavirus | 2560195 | Viruses | Viruses | 743 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g124529 | i0 | 100 | 66.3495145631068 | 402 | 0 | 98 | 0 | 1 | 402 | 3509 | 3108 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 27336 | 743 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25264940 | 25264940 | PRJNA1160211_S_NODE_250740_length_261_cov_2.478723_g249507_i0 | PRJNA1160211 | 250740 | 261 | 2.478723 | 6.46946703 | Orthorubulavirus | 2560195 | Viruses | Viruses | 398 | 2.649999999999999e-106 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g249507 | i0 | 98.661 | 83.360153256705 | 224 | 3 | 86 | 0 | 38 | 261 | 1216 | 1439 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 21757 | 398 | 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);;