contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2232141 | 2232141 | PRJNA980839_P_NODE_11862_length_1857_cov_4.714686_g10197_i0 | PRJNA980839 | 11862 | 1857 | 4.714686 | 87.55171902 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 1097 | 0 | NR | WOK35054.1 | 11036 | g10197 | i0 | 97.9 | 1.9967689822294 | 618 | 13 | 99.8 | 0 | 2 | 1855 | 1707 | 2324 | WOK35054.1 nonstructural polyprotein precursor P1234 [Venezuelan equine encephalitis virus] | diamond | 3708 | 1097 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 7335351 | 7335351 | PRJNA980839_P_NODE_156206_length_281_cov_4.028846_g152422_i0 | PRJNA980839 | 156206 | 281 | 4.028846 | 11.32105726 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 188 | 1.71e-53 | NR | NP_740697.1 | 11036 | g152422 | i0 | 98.9 | 5.95729537366548 | 93 | 1 | 99.3 | 0 | 3 | 281 | 256 | 348 | NP_740697.1 putative nonstructural protein nsP2 [Venezuelan equine encephalitis virus] | diamond | 1674 | 188 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 11160254 | 11160254 | PRJNA980839_P_NODE_122509_length_320_cov_3.821862_g118725_i0 | PRJNA980839 | 122509 | 320 | 3.821862 | 12.2299584 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 218 | 2.85e-63 | NR | WOK35054.1 | 11036 | g118725 | i0 | 100 | 12.890625 | 106 | 0 | 99.4 | 0 | 2 | 319 | 2328 | 2433 | WOK35054.1 nonstructural polyprotein precursor P1234 [Venezuelan equine encephalitis virus] | diamond | 4125 | 218 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 11163524 | 11163524 | PRJNA980839_P_NODE_70909_length_460_cov_3.532300_g67126_i0 | PRJNA980839 | 70909 | 460 | 3.5323 | 16.24858 | Alphavirus venezuelan | 3426322 | Viruses | Viruses | 293 | 2.21e-97 | NR | 2HWK_A | 11037 | g67126 | i0 | 99.3 | 4.6304347826087 | 142 | 1 | 92.6 | 0 | 428 | 3 | 139 | 280 | 2HWK_A Chain A, helicase nsP2 [Venezuelan equine encephalitis virus (strain TC-83)] | diamond | 2130 | 293 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 11163663 | 11163663 | PRJNA980839_P_NODE_77189_length_432_cov_4.362117_g73405_i0 | PRJNA980839 | 77189 | 432 | 4.362117 | 18.84434544 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 301 | 4.669999999999999e-95 | NR | NP_740697.1 | 11036 | g73405 | i0 | 99.3 | 4 | 144 | 1 | 100 | 0 | 432 | 1 | 451 | 594 | NP_740697.1 putative nonstructural protein nsP2 [Venezuelan equine encephalitis virus] | diamond | 1728 | 301 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 13713192 | 13713192 | PRJNA980839_P_NODE_39231_length_744_cov_3.162444_g35657_i0 | PRJNA980839 | 39231 | 744 | 3.162444 | 23.52858336 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 458 | 8.66e-146 | NR | NP_040823.1 | 11036 | g35657 | i0 | 96.3 | 2.96370967741935 | 245 | 9 | 98.8 | 0 | 9 | 743 | 1474 | 1718 | NP_040823.1 non-structural polyprotein precursor P123 [Venezuelan equine encephalitis virus] | diamond | 2205 | 458 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 30753026 | 30753026 | PRJNA980839_P_NODE_85614_length_401_cov_3.246951_g81830_i0 | PRJNA980839 | 85614 | 401 | 3.246951 | 13.02027351 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 263 | 5.459999999999999e-81 | NR | NP_740697.1 | 11036 | g81830 | i0 | 100 | 5.97007481296758 | 133 | 0 | 99.5 | 0 | 401 | 3 | 136 | 268 | NP_740697.1 putative nonstructural protein nsP2 [Venezuelan equine encephalitis virus] | diamond | 2394 | 263 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 31511779 | 31511779 | PRJNA980839_P_NODE_203336_length_250_cov_0.870056_g199552_i0 | PRJNA980839 | 203336 | 250 | 0.870056 | 2.17514 | Facey's Paddock virus | 159143 | Viruses | Viruses | 43.1 | 0.0309 | NR | YP_010085067.1 | 159143 | g199552 | i0 | 37.9 | 0.792 | 66 | 38 | 79.2 | 1 | 37 | 234 | 128 | 190 | YP_010085067.1 membrane glycoprotein polyprotein [Facey's Paddock virus] | diamond | 198 | 43.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Orthobunyavirus | Orthobunyavirus faceyense | ||
| 31637987 | 31637987 | PRJNA980839_P_NODE_177456_length_264_cov_3.685864_g173672_i0 | PRJNA980839 | 177456 | 264 | 3.685864 | 9.73068096 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 172 | 1.0499999999999999e-47 | NR | NP_040823.1 | 11036 | g173672 | i0 | 97.7 | 2 | 88 | 2 | 100 | 0 | 1 | 264 | 1270 | 1357 | NP_040823.1 non-structural polyprotein precursor P123 [Venezuelan equine encephalitis virus] | diamond | 528 | 172 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 31638020 | 31638020 | PRJNA980839_P_NODE_31356_length_905_cov_6.012019_g28068_i0 | PRJNA980839 | 31356 | 905 | 6.012019 | 54.40877195 | Venezuelan equine encephalitis virus | 11036 | Viruses | Viruses | 587 | 8.439999999999998e-193 | NR | NP_040823.1 | 11036 | g28068 | i0 | 98.7 | 2.97016574585635 | 301 | 4 | 99.8 | 0 | 3 | 905 | 311 | 611 | NP_040823.1 non-structural polyprotein precursor P123 [Venezuelan equine encephalitis virus] | diamond | 2688 | 587 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan | ||
| 32813536 | 32813536 | PRJNA980839_P_NODE_119960_length_324_cov_4.179283_g116176_i0 | PRJNA980839 | 119960 | 324 | 4.179283 | 13.54087692 | Alphavirus | 11019 | Viruses | Viruses | 213 | 1.66e-61 | NR | NP_040823.1 | 11036 | g116176 | i0 | 100 | 4.9537037037037 | 107 | 0 | 99.1 | 0 | 2 | 322 | 1382 | 1488 | NP_040823.1 non-structural polyprotein precursor P123 [Venezuelan equine encephalitis virus] | diamond | 1605 | 213 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus venezuelan |
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);;