contig_metadata
15 rows where bioproject = "PRJNA773778", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2482671 | 2482671 | PRJNA773778_S_NODE_24582_length_305_cov_1.327586_g24432_i0 | PRJNA773778 | 24582 | 305 | 1.327586 | 4.0491373 | Orthorubulavirus | 2560195 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g24432 | i0 | 100 | 84.055737704918 | 305 | 0 | 100 | 0 | 1 | 305 | 2754 | 3058 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25637 | 564 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2482788 | 2482788 | PRJNA773778_S_NODE_6542_length_503_cov_2.220930_g6392_i0 | PRJNA773778 | 6542 | 503 | 2.22093 | 11.1712779 | Orthorubulavirus | 2560195 | Viruses | Viruses | 929 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g6392 | i0 | 100 | 81.4373757455268 | 503 | 0 | 100 | 0 | 1 | 503 | 2303 | 1801 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 40963 | 929 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10135878 | 10135878 | PRJNA773778_S_NODE_25908_length_299_cov_1.991150_g25758_i0 | PRJNA773778 | 25908 | 299 | 1.99115 | 5.9535385 | Orthorubulavirus | 2560195 | Viruses | Viruses | 553 | 6.25e-153 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g25758 | i0 | 100 | 83.9765886287625 | 299 | 0 | 100 | 0 | 1 | 299 | 6930 | 7228 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25109 | 553 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11411130 | 11411130 | PRJNA773778_S_NODE_3269_length_631_cov_1.783154_g3124_i0 | PRJNA773778 | 3269 | 631 | 1.783154 | 11.25170174 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1160 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3124 | i0 | 99.842 | 67.9080824088748 | 631 | 1 | 100 | 0 | 1 | 631 | 3760 | 3130 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 42850 | 1160 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12686797 | 12686797 | PRJNA773778_S_NODE_10190_length_427_cov_2.242938_g10040_i0 | PRJNA773778 | 10190 | 427 | 2.242938 | 9.57734526 | Orthorubulavirus | 2560195 | Viruses | Viruses | 789 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g10040 | i0 | 100 | 83 | 427 | 0 | 100 | 0 | 1 | 427 | 7829 | 8255 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 35441 | 789 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12686819 | 12686819 | PRJNA773778_S_NODE_16110_length_357_cov_2.838028_g15960_i0 | PRJNA773778 | 16110 | 357 | 2.838028 | 10.13175996 | Orthorubulavirus | 2560195 | Viruses | Viruses | 660 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g15960 | i0 | 100 | 80.1960784313726 | 357 | 0 | 100 | 0 | 1 | 357 | 78 | 434 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 28630 | 660 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13505048 | 13505048 | PRJNA773778_S_NODE_38231_length_256_cov_1.683060_g38081_i0 | PRJNA773778 | 38231 | 256 | 1.68306 | 4.3086336 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 468 | 1.95e-127 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g38081 | i0 | 99.609 | 83 | 256 | 1 | 100 | 0 | 1 | 256 | 7435 | 7690 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 21248 | 468 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13961308 | 13961308 | PRJNA773778_S_NODE_48891_length_238_cov_4.490909_g48741_i0 | PRJNA773778 | 48891 | 238 | 4.490909 | 10.68836342 | Orthorubulavirus | 2560195 | Viruses | Viruses | 440 | 3.899999999999999e-119 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g48741 | i0 | 100 | 66.5294117647059 | 238 | 0 | 100 | 0 | 1 | 238 | 6476 | 6239 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 15834 | 440 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16054201 | 16054201 | PRJNA773778_S_NODE_9093_length_447_cov_1.631016_g8943_i0 | PRJNA773778 | 9093 | 447 | 1.631016 | 7.29064152 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 826 | 0 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g8943 | i0 | 100 | 85.3937360178971 | 447 | 0 | 100 | 0 | 1 | 447 | 2752 | 2306 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 38171 | 826 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22884918 | 22884918 | PRJNA773778_S_NODE_16238_length_356_cov_1.805654_g16088_i0 | PRJNA773778 | 16238 | 356 | 1.805654 | 6.42812824 | Orthorubulavirus | 2560195 | Viruses | Viruses | 649 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g16088 | i0 | 99.718 | 94.811797752809 | 354 | 1 | 99 | 0 | 1 | 354 | 4847 | 4494 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 33753 | 654 | 0.992354740061162 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22885013 | 22885013 | PRJNA773778_S_NODE_378_length_1387_cov_3.261035_g334_i0 | PRJNA773778 | 378 | 1387 | 3.261035 | 45.23055545 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2523 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g334 | i0 | 99.927 | 74.5933669790916 | 1369 | 1 | 99 | 0 | 19 | 1387 | 391 | 1759 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 103461 | 2523 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22885059 | 22885059 | PRJNA773778_S_NODE_4758_length_561_cov_2.319672_g4610_i0 | PRJNA773778 | 4758 | 561 | 2.319672 | 13.01335992 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1026 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4610 | i0 | 99.643 | 68.9126559714795 | 561 | 2 | 100 | 0 | 1 | 561 | 4245 | 3685 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 38660 | 1026 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 25433976 | 25433976 | PRJNA773778_S_NODE_36520_length_261_cov_2.457447_g36370_i0 | PRJNA773778 | 36520 | 261 | 2.457447 | 6.41393667 | Orthorubulavirus | 2560195 | Viruses | Viruses | 483 | 7.12e-132 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g36370 | i0 | 100 | 97.3639846743295 | 261 | 0 | 100 | 0 | 1 | 261 | 706 | 966 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 25412 | 483 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 31728380 | 31728380 | PRJNA773778_S_NODE_41617_length_249_cov_1.909091_g41467_i0 | PRJNA773778 | 41617 | 249 | 1.909091 | 4.75363659 | Sanya bunya-like virus 21 | 2970006 | Viruses | Viruses | 48.9 | 2.74e-4 | NR | UUW20969.1 | 2970006 | g41467 | i0 | 33.8 | 0.927710843373494 | 77 | 50 | 91.6 | 1 | 229 | 2 | 1546 | 1622 | UUW20969.1 MAG: hypothetical protein [Sanya bunya-like virus 21] | diamond | 231 | 48.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sanya bunya-like virus 21 | ||||
| 32623518 | 32623518 | PRJNA773778_S_NODE_16640_length_352_cov_4.139785_g16490_i0 | PRJNA773778 | 16640 | 352 | 4.139785 | 14.5720432 | Orthodiscovirus | 2948850 | Viruses | Viruses | 187 | 5.599999999999999e-56 | NR | YP_010840595.1 | 2587545 | g16490 | i0 | 73.5 | 1.99431818181818 | 117 | 31 | 99.7 | 0 | 1 | 351 | 208 | 324 | YP_010840595.1 nucleocapsid [Coniothyrium diplodiella negative-stranded RNA virus 1] | diamond | 702 | 187 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus coniellae |
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);;