contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA893346" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9796005 | 9796005 | PRJNA893346_P_NODE_22948_length_320_cov_1.242915_g22458_i0 | PRJNA893346 | 22948 | 320 | 1.242915 | 3.977328 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 204 | 1.03e-59 | NR | QDC27501.1 | RQ01 | g22458 | i0 | 91.5 | 26.83125 | 106 | 9 | 99.4 | 0 | 319 | 2 | 52 | 157 | QDC27501.1 polymerase PB1 [Influenza B virus] | diamond | 8586 | 205 | 0.995121951219512 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 10171790 | 10171790 | PRJNA893346_P_NODE_1028_length_1521_cov_4.130525_g854_i0 | PRJNA893346 | 1028 | 1521 | 4.130525 | 62.82528525 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 571 | 7.96e-199 | NR | AVM87625.1 | RQ01 | g854 | i0 | 63.8 | 1.70414201183432 | 472 | 166 | 92.1 | 3 | 1465 | 65 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 2592 | 571 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 26999920 | 26999920 | PRJNA893346_P_NODE_22202_length_326_cov_1.023715_g21713_i0 | PRJNA893346 | 22202 | 326 | 1.023715 | 3.3373109 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 201 | 2.44e-58 | NR | AXG64340.1 | RQ01 | g21713 | i0 | 90.7 | 8.94478527607362 | 108 | 10 | 99.4 | 0 | 325 | 2 | 400 | 507 | AXG64340.1 polymerase PB2, partial [Influenza B virus] | diamond | 2916 | 201 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 27276995 | 27276995 | PRJNA893346_P_NODE_703_length_1741_cov_2.574940_g577_i0 | PRJNA893346 | 703 | 1741 | 2.57494 | 44.8297054 | Zebrafish systemic paramyxovirus | RQ10 | Viruses | Viruses | 94 | 9.99e-16 | NR | YP_010790479.1 | RQ10 | g577 | i0 | 30.4 | 0.385985066053992 | 224 | 149 | 37.4 | 1 | 452 | 1102 | 1728 | 1951 | YP_010790479.1 L protein [Wenzhou pacific spadenose shark paramyxovirus] | diamond | 672 | 94 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Scoliodonvirus | Zebrafish systemic paramyxovirus | ||
| 27435078 | 27435078 | PRJNA893346_P_NODE_203_length_2610_cov_18.799764_g160_i0 | PRJNA893346 | 203 | 2610 | 18.799764 | 490.6738404 | Ferlavirus reptilis | 3052205 | Viruses | Viruses | 87.4 | 1.09e-13 | NR | AAV54052.1 | 3052205 | g160 | i0 | 22.3 | 0.971264367816092 | 431 | 305 | 47.7 | 10 | 1629 | 385 | 12 | 428 | AAV54052.1 F protein [Ferlavirus reptilis] | diamond | 2535 | 87.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Ferlavirus | Ferlavirus reptilis | ||
| 27750821 | 27750821 | PRJNA893346_P_NODE_364_length_2167_cov_21.913563_g295_i0 | PRJNA893346 | 364 | 2167 | 21.913563 | 474.86691021 | Mount Mabu Lophuromys virus 2 | 2116560 | Viruses | Viruses | 82.4 | 4.61e-12 | NR | YP_009666854.1 | 2116560 | g295 | i0 | 25.6 | 0.539916935856022 | 390 | 268 | 52.5 | 11 | 1606 | 470 | 183 | 561 | YP_009666854.1 G protein [Mount Mabu Lophuromys virus 2] | diamond | 1170 | 82.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Jeilongvirus | Jeilongvirus mabuense | ||
| 27845150 | 27845150 | PRJNA893346_P_NODE_5244_length_709_cov_1.915094_g4788_i0 | PRJNA893346 | 5244 | 709 | 1.915094 | 13.57801646 | Paramyxoviridae sp. | 1663356 | Viruses | Viruses | 179 | 2.28e-47 | NR | UED37238.1 | 1663356 | g4788 | i0 | 41.2 | 3.84203102961918 | 221 | 129 | 93.5 | 1 | 19 | 681 | 1192 | 1411 | UED37238.1 RNA-dependent RNA polymerase [Paramyxoviridae sp.] | diamond | 2724 | 179 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Paramyxoviridae sp. | |||
| 27971587 | 27971587 | PRJNA893346_P_NODE_5285_length_706_cov_3.421801_g4829_i0 | PRJNA893346 | 5285 | 706 | 3.421801 | 24.15791506 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 301 | 8.809999999999997e-96 | NR | AVM87624.1 | RQ01 | g4829 | i0 | 64 | 1.0028328611898 | 236 | 82 | 99.9 | 2 | 706 | 2 | 248 | 481 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 708 | 301 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 28224009 | 28224009 | PRJNA893346_P_NODE_9606_length_509_cov_1.589450_g9122_i0 | PRJNA893346 | 9606 | 509 | 1.58945 | 8.0903005 | Zebrafish systemic paramyxovirus | RQ10 | Viruses | Viruses | 133 | 1.97e-32 | NR | YP_010790479.1 | RQ10 | g9122 | i0 | 42.6 | 0.996070726915521 | 169 | 97 | 99.6 | 0 | 1 | 507 | 808 | 976 | YP_010790479.1 L protein [Wenzhou pacific spadenose shark paramyxovirus] | diamond | 507 | 133 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Scoliodonvirus | Zebrafish systemic paramyxovirus | ||
| 28540174 | 28540174 | PRJNA893346_P_NODE_40207_length_232_cov_2.157233_g39717_i0 | PRJNA893346 | 40207 | 232 | 2.157233 | 5.00478056 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 105 | 1.0999999999999998e-24 | NR | QOE76805.1 | RQ12 | g39717 | i0 | 62.3 | 0.995689655172414 | 77 | 29 | 99.6 | 0 | 231 | 1 | 200 | 276 | QOE76805.1 neuraminidase [Siamese algae-eater influenza-like virus] | diamond | 231 | 105 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 28697978 | 28697978 | PRJNA893346_P_NODE_25187_length_303_cov_1.247826_g24697_i0 | PRJNA893346 | 25187 | 303 | 1.247826 | 3.78091278 | Chuvivirus | 2842604 | Viruses | Viruses | 138 | 7.1e-36 | NR | UVF58769.1 | 2842604 | g24697 | i0 | 60.4 | 3 | 101 | 40 | 100 | 0 | 1 | 303 | 327 | 427 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 909 | 139 | 0.992805755395683 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Chuvivirus | ||
| 28990014 | 28990014 | PRJNA893346_P_NODE_26708_length_292_cov_1.520548_g26218_i0 | PRJNA893346 | 26708 | 292 | 1.520548 | 4.44000016 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 197 | 2.79e-58 | NR | QCT23357.1 | RQ01 | g26218 | i0 | 97.9 | 21.9143835616438 | 97 | 2 | 99.7 | 0 | 1 | 291 | 253 | 349 | QCT23357.1 polymerase PB1, partial [Influenza B virus] | diamond | 6399 | 197 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29108372 | 29108372 | PRJNA893346_P_NODE_2188_length_1105_cov_3.549419_g1883_i0 | PRJNA893346 | 2188 | 1105 | 3.549419 | 39.22107995 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 410 | 1.0799999999999999e-137 | NR | AVM87625.1 | RQ01 | g1883 | i0 | 62.3 | 0.963800904977376 | 355 | 129 | 95 | 3 | 54 | 1103 | 1 | 355 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1065 | 410 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 29203187 | 29203187 | PRJNA893346_P_NODE_6309_length_642_cov_3.514938_g5843_i0 | PRJNA893346 | 6309 | 642 | 3.514938 | 22.56590196 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 244 | 4.83e-74 | NR | AVM87624.1 | RQ01 | g5843 | i0 | 60.1 | 0.901869158878505 | 193 | 77 | 90.2 | 0 | 63 | 641 | 3 | 195 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 579 | 244 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 29273731 | 29273731 | PRJNA893346_P_NODE_22909_length_320_cov_1.558704_g22419_i0 | PRJNA893346 | 22909 | 320 | 1.558704 | 4.9878528 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 199 | 1.7100000000000004e-59 | NR | QCT23030.1 | RQ01 | g22419 | i0 | 88.7 | 14.90625 | 106 | 12 | 99.4 | 0 | 1 | 318 | 42 | 147 | QCT23030.1 polymerase PA, partial [Influenza B virus] | diamond | 4770 | 199 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29897763 | 29897763 | PRJNA893346_P_NODE_831_length_1634_cov_5.646381_g682_i0 | PRJNA893346 | 831 | 1634 | 5.646381 | 92.26186554 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 666 | 3.189999999999998e-234 | NR | AVM87624.1 | RQ01 | g682 | i0 | 62.6 | 0.962056303549572 | 524 | 192 | 96 | 3 | 1572 | 4 | 3 | 523 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 1572 | 666 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 30063259 | 30063259 | PRJNA893346_P_NODE_12631_length_440_cov_1.267030_g12145_i0 | PRJNA893346 | 12631 | 440 | 1.26703 | 5.5749320000000004 | Paramyxoviridae | 11158 | Viruses | Viruses | 117 | 2.7700000000000003e-27 | NR | AEX65755.1 | 11241 | g12145 | i0 | 46.7 | 1.94318181818182 | 137 | 71 | 93.4 | 1 | 440 | 30 | 1030 | 1164 | AEX65755.1 L [Rinderpest morbillivirus] [Rinderpest morbillivirus] | diamond | 855 | 118 | 0.991525423728814 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Morbillivirus | Morbillivirus pecoris | ||
| 30181884 | 30181884 | PRJNA893346_P_NODE_1232_length_1423_cov_2.145926_g1032_i0 | PRJNA893346 | 1232 | 1423 | 2.1459259999999998 | 30.53652698 | Enneapterygius tutuilae paramyxovirus | 2951524 | Viruses | Viruses | 297 | 2.03e-95 | NR | UVF58808.1 | 2951524 | g1032 | i0 | 66.2 | 1.35769501054111 | 210 | 71 | 44.3 | 0 | 746 | 1375 | 1 | 210 | UVF58808.1 MAG: RNA-dependent RNA polymerase, partial [Enneapterygius tutuilae paramyxovirus] | diamond | 1932 | 297 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Enneapterygius tutuilae paramyxovirus | |||
| 30497989 | 30497989 | PRJNA893346_P_NODE_2033_length_1144_cov_53.529412_g1747_i0 | PRJNA893346 | 2033 | 1144 | 53.529412 | 612.37647328 | Rinderpest virus (strain Kabete O) | 11242 | Viruses | Viruses | 63.2 | 5.65e-7 | NR | P22046.1 | 11242 | g1747 | i0 | 25.3 | 0.652972027972028 | 249 | 176 | 64.2 | 6 | 965 | 231 | 63 | 305 | P22046.1 RecName: Full=Matrix protein [Rinderpest virus (strain Kabete O)] | diamond | 747 | 63.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Morbillivirus | Morbillivirus pecoris | ||
| 30750781 | 30750781 | PRJNA893346_P_NODE_30634_length_268_cov_0.861538_g30144_i0 | PRJNA893346 | 30634 | 268 | 0.861538 | 2.30892184 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 73.2 | 9.78e-13 | NR | QOE76804.1 | RQ12 | g30144 | i0 | 37.9 | 0.973880597014925 | 87 | 54 | 97.4 | 0 | 264 | 4 | 438 | 524 | QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] | diamond | 261 | 73.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 31035365 | 31035365 | PRJNA893346_P_NODE_10135_length_495_cov_0.971564_g9651_i0 | PRJNA893346 | 10135 | 495 | 0.971564 | 4.8092418 | Melampyrum roseum virus 1 | 2793732 | Viruses | Viruses | 61.2 | 1.42e-7 | NR | YP_010840921.1 | 2793732 | g9651 | i0 | 46.5 | 0.43030303030303 | 71 | 38 | 43 | 0 | 9 | 221 | 126 | 196 | YP_010840921.1 protein 2 [Melampyrum roseum virus 1] | diamond | 213 | 61.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Varicosavirus | Varicosavirus melampyri | ||
| 31161094 | 31161094 | PRJNA893346_P_NODE_7675_length_576_cov_1.337972_g7199_i0 | PRJNA893346 | 7675 | 576 | 1.337972 | 7.70671872 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 95.5 | 3.23e-20 | NR | QOE76807.1 | RQ12 | g7199 | i0 | 39.2 | 0.677083333333333 | 130 | 78 | 67.7 | 1 | 8 | 397 | 126 | 254 | QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus] | diamond | 390 | 95.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 31572773 | 31572773 | PRJNA893346_P_NODE_37756_length_244_cov_0.900585_g37266_i0 | PRJNA893346 | 37756 | 244 | 0.900585 | 2.1974274 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 76.6 | 4.15e-14 | NR | QOE76804.1 | RQ12 | g37266 | i0 | 45.6 | 0.971311475409836 | 79 | 43 | 97.1 | 0 | 242 | 6 | 315 | 393 | QOE76804.1 nucleoprotein [Siamese algae-eater influenza-like virus] | diamond | 237 | 76.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 32553650 | 32553650 | PRJNA893346_P_NODE_24399_length_309_cov_0.915254_g23909_i0 | PRJNA893346 | 24399 | 309 | 0.915254 | 2.82813486 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 97.4 | 3e-22 | NR | QOE76807.1 | RQ12 | g23909 | i0 | 48 | 0.990291262135922 | 102 | 52 | 98.1 | 1 | 5 | 307 | 4 | 105 | QOE76807.1 matrix protein [Siamese algae-eater influenza-like virus] | diamond | 306 | 97.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 32805250 | 32805250 | PRJNA893346_P_NODE_21480_length_332_cov_1.138996_g20991_i0 | PRJNA893346 | 21480 | 332 | 1.138996 | 3.78146672 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 135 | 5.849999999999998e-35 | NR | QOE76805.1 | RQ12 | g20991 | i0 | 67.3 | 0.885542168674699 | 98 | 31 | 88.6 | 1 | 2 | 295 | 354 | 450 | QOE76805.1 neuraminidase [Siamese algae-eater influenza-like virus] | diamond | 294 | 135 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus |
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);;