contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10577278 | 10577278 | PRJNA293022_P_NODE_53269_length_191_cov_1.232394_g52532_i0 | PRJNA293022 | 53269 | 191 | 1.232394 | 2.35387254 | Sea turtle neural virus 1 | 3112944 | Viruses | Viruses | 99.4 | 2.18e-22 | NR | WET19893.1 | 3112944 | g52532 | i0 | 64.5 | 2.92146596858639 | 62 | 22 | 97.4 | 0 | 3 | 188 | 1143 | 1204 | WET19893.1 MAG: polymerase [Sea turtle neural virus 1] | diamond | 558 | 99.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Sea turtle neural virus 1 | ||
| 27516567 | 27516567 | PRJNA293022_P_NODE_5423_length_606_cov_1.764811_g4741_i0 | PRJNA293022 | 5423 | 606 | 1.764811 | 10.69475466 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 208 | 3.99e-58 | NR | YP_010085034.1 | RQ04 | g4741 | i0 | 51.7 | 0.995049504950495 | 201 | 93 | 99 | 2 | 604 | 5 | 888 | 1085 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 603 | 208 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 27863782 | 27863782 | PRJNA293022_P_NODE_4345_length_667_cov_1.498382_g3711_i0 | PRJNA293022 | 4345 | 667 | 1.498382 | 9.99420794 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 199 | 7.849999999999998e-55 | NR | YP_010085034.1 | RQ04 | g3711 | i0 | 44.5 | 0.980509745127436 | 218 | 115 | 97.2 | 3 | 657 | 10 | 357 | 570 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 654 | 199 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 27895361 | 27895361 | PRJNA293022_P_NODE_37905_length_227_cov_1.157303_g37168_i0 | PRJNA293022 | 37905 | 227 | 1.157303 | 2.62707781 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 140 | 1.77e-36 | NR | UNI74144.1 | 2900384 | g37168 | i0 | 94.7 | 0.991189427312775 | 75 | 4 | 99.1 | 0 | 3 | 227 | 1384 | 1458 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 225 | 140 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 28274226 | 28274226 | PRJNA293022_P_NODE_52746_length_192_cov_1.090909_g52009_i0 | PRJNA293022 | 52746 | 192 | 1.090909 | 2.09454528 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 43.1 | 0.0147 | NR | YP_010085034.1 | RQ04 | g52009 | i0 | 43.3 | 0.9375 | 60 | 34 | 93.8 | 0 | 10 | 189 | 1498 | 1557 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 180 | 43.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 28512948 | 28512948 | PRJNA293022_P_NODE_31347_length_250_cov_2.029851_g30610_i0 | PRJNA293022 | 31347 | 250 | 2.029851 | 5.0746275 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 53.1 | 9.12e-6 | NR | YP_010840939.1 | 3065075 | g30610 | i0 | 48.9 | 1.128 | 47 | 24 | 56.4 | 0 | 109 | 249 | 228 | 274 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 282 | 53.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 28810734 | 28810734 | PRJNA293022_P_NODE_21888_length_304_cov_1.552941_g21151_i0 | PRJNA293022 | 21888 | 304 | 1.552941 | 4.72094064 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 55.5 | 2.75e-6 | NR | YP_010085034.1 | RQ04 | g21151 | i0 | 33.8 | 1.41118421052632 | 71 | 46 | 69.1 | 1 | 286 | 77 | 2015 | 2085 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 429 | 55.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 28810736 | 28810736 | PRJNA293022_P_NODE_40988_length_218_cov_1.349112_g40251_i0 | PRJNA293022 | 40988 | 218 | 1.349112 | 2.94106416 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 47.8 | 4.72e-4 | NR | UVF58767.1 | 3065075 | g40251 | i0 | 37.3 | 1.03211009174312 | 75 | 43 | 97.7 | 2 | 215 | 3 | 58 | 132 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 225 | 47.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 28810740 | 28810740 | PRJNA293022_P_NODE_968_length_1216_cov_14.745501_g691_i0 | PRJNA293022 | 968 | 1216 | 14.745501 | 179.30529216 | Retropinna hantavirus | 3064110 | Viruses | Viruses | 264 | 1.43e-81 | NR | WLJ60755.1 | 3064110 | g691 | i0 | 42.6 | 0.846217105263158 | 343 | 186 | 83.4 | 5 | 56 | 1069 | 6 | 342 | WLJ60755.1 MAG: nucleoprotein [Retropinna hantavirus] | diamond | 1029 | 264 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Retropinna hantavirus | |||
| 29284515 | 29284515 | PRJNA293022_P_NODE_31609_length_249_cov_1.780000_g30872_i0 | PRJNA293022 | 31609 | 249 | 1.78 | 4.4322 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 61.2 | 1.24e-8 | NR | YP_010085034.1 | RQ04 | g30872 | i0 | 35.4 | 0.987951807228916 | 82 | 53 | 98.8 | 0 | 3 | 248 | 1567 | 1648 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 246 | 61.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 29568803 | 29568803 | PRJNA293022_P_NODE_27190_length_270_cov_1.574661_g26453_i0 | PRJNA293022 | 27190 | 270 | 1.574661 | 4.2515847 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 61.2 | 1.63e-8 | NR | UVF58767.1 | 2951531 | g26453 | i0 | 47.9 | 0.533333333333333 | 48 | 25 | 53.3 | 0 | 148 | 5 | 1027 | 1074 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 144 | 61.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 29726479 | 29726479 | PRJNA293022_P_NODE_68490_length_168_cov_1.747899_g67753_i0 | PRJNA293022 | 68490 | 168 | 1.747899 | 2.93647032 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 96.3 | 1.86e-21 | NR | UNI74144.1 | 2900384 | g67753 | i0 | 87.3 | 0.982142857142857 | 55 | 7 | 98.2 | 0 | 166 | 2 | 1812 | 1866 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 165 | 96.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 30074048 | 30074048 | PRJNA293022_P_NODE_18572_length_331_cov_2.092199_g17835_i0 | PRJNA293022 | 18572 | 331 | 2.092199 | 6.92517869 | Zebrafish cardiovascular hantavirus | RQ04 | Viruses | Viruses | 100 | 4.39e-22 | NR | YP_010085034.1 | RQ04 | g17835 | i0 | 49.5 | 0.897280966767372 | 99 | 50 | 89.7 | 0 | 331 | 35 | 701 | 799 | YP_010085034.1 L protein [Wenling red spikefish hantavirus] | diamond | 297 | 100 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Actinovirus | Zebrafish cardiovascular hantavirus | ||
| 30074051 | 30074051 | PRJNA293022_P_NODE_52_length_2958_cov_3.500859_g27_i0 | PRJNA293022 | 52 | 2958 | 3.500859 | 103.55540922 | Retropinna hantavirus | 3064110 | Viruses | Viruses | 430 | 1.09e-131 | NR | WLJ60758.1 | 3064110 | g27 | i0 | 31.4 | 0.871196754563895 | 859 | 543 | 84.4 | 18 | 2899 | 404 | 73 | 912 | WLJ60758.1 MAG: glycoprotein, partial [Retropinna hantavirus] | diamond | 2577 | 430 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Retropinna hantavirus | |||
| 30168781 | 30168781 | PRJNA293022_P_NODE_44812_length_208_cov_2.886792_g44075_i0 | PRJNA293022 | 44812 | 208 | 2.886792 | 6.00452736 | Retropinna hantavirus | 3064110 | Viruses | Viruses | 73.9 | 2.14e-13 | NR | WLJ60734.1 | 3064110 | g44075 | i0 | 47.1 | 0.980769230769231 | 68 | 36 | 98.1 | 0 | 4 | 207 | 326 | 393 | WLJ60734.1 MAG: L protein, partial [Retropinna hantavirus] | diamond | 204 | 73.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Retropinna hantavirus | |||
| 30359060 | 30359060 | PRJNA293022_P_NODE_2452_length_854_cov_3.563975_g1987_i0 | PRJNA293022 | 2452 | 854 | 3.563975 | 30.4363465 | Turtle fraservirus 1 | 2912878 | Viruses | Viruses | 75.1 | 5.18e-11 | NR | YP_010840845.1 | 2912878 | g1987 | i0 | 26 | 0.892271662763466 | 254 | 167 | 88.2 | 10 | 94 | 846 | 20 | 255 | YP_010840845.1 glycoprotein precursor [Turtle fraservirus 1] | diamond | 762 | 75.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Tosoviridae | Fraservirus | Fraservirus testudinis | ||
| 31022093 | 31022093 | PRJNA293022_P_NODE_25595_length_279_cov_2.021739_g24858_i0 | PRJNA293022 | 25595 | 279 | 2.021739 | 5.64065181 | Luposicya lupus actinovirus | 2951511 | Viruses | Viruses | 68.2 | 6.68e-11 | NR | UVF58773.1 | 2951511 | g24858 | i0 | 43.2 | 0.870967741935484 | 81 | 45 | 86 | 1 | 262 | 23 | 11 | 91 | UVF58773.1 MAG: L protein [Luposicya lupus actinovirus] | diamond | 243 | 68.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Hantaviridae | Percilovirus | Percilovirus gobii | ||
| 31306456 | 31306456 | PRJNA293022_P_NODE_37175_length_229_cov_1.716667_g36438_i0 | PRJNA293022 | 37175 | 229 | 1.716667 | 3.93116743 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 110 | 6.270000000000001e-26 | NR | UVF58767.1 | 2951531 | g36438 | i0 | 74.6 | 0.825327510917031 | 63 | 16 | 82.5 | 0 | 32 | 220 | 580 | 642 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 189 | 110 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 32445634 | 32445634 | PRJNA293022_P_NODE_73399_length_165_cov_1.724138_g72662_i0 | PRJNA293022 | 73399 | 165 | 1.724138 | 2.8448277 | Melon yellow spot virus | 89471 | Viruses | Viruses | 116 | 1.27e-28 | NR | BAG82844.1 | 89471 | g72662 | i0 | 84.9 | 0.963636363636364 | 53 | 8 | 96.4 | 0 | 162 | 4 | 311 | 363 | BAG82844.1 glycoprotein precursor [Melon yellow spot virus] | diamond | 159 | 116 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Tospoviridae | Orthotospovirus | Orthotospovirus meloflavi | ||
| 32666342 | 32666342 | PRJNA293022_P_NODE_25640_length_279_cov_1.347826_g24903_i0 | PRJNA293022 | 25640 | 279 | 1.347826 | 3.76043454 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 93.6 | 8.22e-20 | NR | UVF58767.1 | 2951531 | g24903 | i0 | 50.5 | 0.978494623655914 | 91 | 42 | 94.6 | 2 | 270 | 7 | 1430 | 1520 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 273 | 93.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus |
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);;