contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7512969 | 7512969 | PRJNA565584_P_NODE_51366_length_415_cov_1.707602_g50215_i0 | PRJNA565584 | 51366 | 415 | 1.707602 | 7.0865483 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 243 | 1.39e-71 | NR | UNI74094.1 | 2900380 | g50215 | i0 | 86.2 | 0.997590361445783 | 138 | 19 | 99.8 | 0 | 415 | 2 | 1815 | 1952 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 414 | 243 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 27648252 | 27648252 | PRJNA565584_P_NODE_46404_length_438_cov_1.484932_g45253_i0 | PRJNA565584 | 46404 | 438 | 1.484932 | 6.50400216 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 190 | 4.509999999999999e-55 | NR | UNI74091.1 | 2900380 | g45253 | i0 | 67.9 | 0.917808219178082 | 134 | 43 | 91.8 | 0 | 438 | 37 | 294 | 427 | UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 402 | 190 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 27774523 | 27774523 | PRJNA565584_P_NODE_18864_length_736_cov_1.926094_g17771_i0 | PRJNA565584 | 18864 | 736 | 1.926094 | 14.17605184 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 400 | 9.66e-137 | NR | UNI74090.1 | 2900380 | g17771 | i0 | 81.8 | 0.986413043478261 | 242 | 44 | 98.6 | 0 | 732 | 7 | 109 | 350 | UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 726 | 400 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 27995436 | 27995436 | PRJNA565584_P_NODE_175925_length_249_cov_1.659091_g174773_i0 | PRJNA565584 | 175925 | 249 | 1.659091 | 4.13113659 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 78.6 | 7.93e-15 | NR | UNI74090.1 | 2900380 | g174773 | i0 | 67.3 | 0.662650602409639 | 55 | 18 | 66.3 | 0 | 245 | 81 | 352 | 406 | UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 165 | 78.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 29353265 | 29353265 | PRJNA565584_P_NODE_96649_length_304_cov_1.822511_g95497_i0 | PRJNA565584 | 96649 | 304 | 1.822511 | 5.54043344 | Rhabdoviridae sp. | 1955137 | Viruses | Viruses | 144 | 2.17e-38 | NR | XKB76561.1 | 1955137 | g95497 | i0 | 64 | 0.986842105263158 | 100 | 36 | 98.7 | 0 | 4 | 303 | 50 | 149 | XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.] | diamond | 300 | 144 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Rhabdoviridae sp. | |||
| 30016350 | 30016350 | PRJNA565584_P_NODE_38311_length_486_cov_1.636804_g37160_i0 | PRJNA565584 | 38311 | 486 | 1.636804 | 7.95486744 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 162 | 5.85e-44 | NR | UNI74091.1 | 2900380 | g37160 | i0 | 56.4 | 0.962962962962963 | 156 | 68 | 96.3 | 0 | 4 | 471 | 18 | 173 | UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 468 | 162 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 30901018 | 30901018 | PRJNA565584_P_NODE_39374_length_478_cov_2.916049_g38223_i0 | PRJNA565584 | 39374 | 478 | 2.916049 | 13.93871422 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 114 | 6.460000000000001e-27 | NR | UNI74120.1 | 2900383 | g38223 | i0 | 46 | 0.709205020920502 | 113 | 61 | 70.9 | 0 | 139 | 477 | 1 | 113 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 339 | 114 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 31248449 | 31248449 | PRJNA565584_P_NODE_28715_length_573_cov_2.144000_g27571_i0 | PRJNA565584 | 28715 | 573 | 2.144 | 12.28512 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 162 | 4.87e-48 | NR | UNI74092.1 | 2900380 | g27571 | i0 | 88.3 | 0.492146596858639 | 94 | 11 | 49.2 | 0 | 2 | 283 | 25 | 118 | UNI74092.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 282 | 162 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32007611 | 32007611 | PRJNA565584_P_NODE_14478_length_862_cov_2.378961_g13455_i0 | PRJNA565584 | 14478 | 862 | 2.378961 | 20.50664382 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 314 | 2.38e-102 | NR | UNI74120.1 | 2900383 | g13455 | i0 | 57.7 | 0.904872389791183 | 260 | 110 | 90.5 | 0 | 3 | 782 | 108 | 367 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 780 | 314 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 32671470 | 32671470 | PRJNA565584_P_NODE_194360_length_245_cov_1.587209_g193208_i0 | PRJNA565584 | 194360 | 245 | 1.587209 | 3.88866205 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 89.7 | 1.02e-18 | NR | UNI74091.1 | 2900380 | g193208 | i0 | 62.3 | 0.844897959183673 | 69 | 26 | 84.5 | 0 | 3 | 209 | 444 | 512 | UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 207 | 89.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32829162 | 32829162 | PRJNA565584_P_NODE_53920_length_405_cov_1.397590_g52769_i0 | PRJNA565584 | 53920 | 405 | 1.39759 | 5.6602395 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 202 | 1.27e-62 | NR | UNI74093.1 | 2900380 | g52769 | i0 | 76.9 | 0.992592592592593 | 134 | 31 | 99.3 | 0 | 3 | 404 | 67 | 200 | UNI74093.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 402 | 202 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis |
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);;