contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27247572 | 27247572 | PRJNA983848_P_NODE_123003_length_269_cov_3.668367_g117120_i0 | PRJNA983848 | 123003 | 269 | 3.668367 | 9.86790723 | Wuhan House Fly Virus 1 | 1608104 | Viruses | Viruses | 42.7 | 0.0496 | NR | APG78745.1 | 1608104 | g117120 | i0 | 29.5 | 1.05947955390335 | 95 | 59 | 97 | 1 | 3 | 263 | 200 | 294 | APG78745.1 putative nucleoprotein [Wuhan House Fly Virus 1] | diamond | 285 | 42.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sigmavirus | Sigmavirus wuhan | ||
| 27531918 | 27531918 | PRJNA983848_P_NODE_57703_length_435_cov_3.325967_g51823_i0 | PRJNA983848 | 57703 | 435 | 3.325967 | 14.46795645 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 155 | 1.6399999999999999e-40 | NR | YP_009333157.1 | 1922390 | g51823 | i0 | 49 | 1.0551724137931 | 153 | 67 | 99.3 | 2 | 433 | 2 | 1541 | 1691 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 459 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 28352767 | 28352767 | PRJNA983848_P_NODE_54246_length_457_cov_4.442708_g48367_i0 | PRJNA983848 | 54246 | 457 | 4.442708 | 20.30317556 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 84 | 1.73e-15 | NR | YP_009333157.1 | 1922390 | g48367 | i0 | 35.2 | 0.800875273522976 | 122 | 79 | 80.1 | 0 | 2 | 367 | 2207 | 2328 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 366 | 84 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 28763182 | 28763182 | PRJNA983848_P_NODE_40167_length_598_cov_4.563810_g34340_i0 | PRJNA983848 | 40167 | 598 | 4.56381 | 27.2915838 | Austropotamobius brown spot virus | 2576634 | Viruses | Viruses | 191 | 1.26e-52 | NR | QCO84580.1 | 2576634 | g34340 | i0 | 46.4 | 1.94648829431438 | 194 | 98 | 97.3 | 1 | 582 | 1 | 646 | 833 | QCO84580.1 glycoprotein, partial [Austropotamobius brown spot virus] | diamond | 1164 | 191 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Austropotamobius brown spot virus | ||||
| 28857920 | 28857920 | PRJNA983848_P_NODE_78508_length_350_cov_2.667870_g72625_i0 | PRJNA983848 | 78508 | 350 | 2.66787 | 9.337545 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 51.2 | 1.31e-4 | NR | YP_009333156.1 | 1922390 | g72625 | i0 | 32.9 | 0.728571428571429 | 85 | 56 | 72.9 | 1 | 94 | 348 | 1 | 84 | YP_009333156.1 hypothetical protein 2 [Beihai hermit crab virus 3] | diamond | 255 | 51.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29016209 | 29016209 | PRJNA983848_P_NODE_78608_length_350_cov_1.841155_g72725_i0 | PRJNA983848 | 78608 | 350 | 1.841155 | 6.4440425 | Boana pugnax lyssa-like virus 1 | 2985438 | Viruses | Viruses | 48.9 | 8.13e-4 | NR | UYD62334.1 | 2985438 | g72725 | i0 | 36.4 | 0.565714285714286 | 66 | 40 | 56.6 | 1 | 206 | 9 | 197 | 260 | UYD62334.1 nucleoprotein [Boana pugnax lyssa-like virus 1] | diamond | 198 | 48.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Amplylivirus | Amplylivirus pugnax | ||
| 29237009 | 29237009 | PRJNA983848_P_NODE_60729_length_418_cov_1.953623_g54847_i0 | PRJNA983848 | 60729 | 418 | 1.953623 | 8.16614414 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 252 | 1.59e-74 | NR | YP_009333157.1 | 1922390 | g54847 | i0 | 86.3 | 0.997607655502392 | 139 | 19 | 99.8 | 0 | 417 | 1 | 540 | 678 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 417 | 252 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29457604 | 29457604 | PRJNA983848_P_NODE_47130_length_516_cov_4.749436_g41260_i0 | PRJNA983848 | 47130 | 516 | 4.749436 | 24.50708976 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 182 | 1.78e-49 | NR | YP_009333157.1 | 1922390 | g41260 | i0 | 50.9 | 0.994186046511628 | 171 | 84 | 99.4 | 0 | 2 | 514 | 189 | 359 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 513 | 182 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 29552415 | 29552415 | PRJNA983848_P_NODE_33630_length_716_cov_2.931571_g27928_i0 | PRJNA983848 | 33630 | 716 | 2.931571 | 20.99004836 | Otter fecal bunyavirus | 1504566 | Viruses | Viruses | 173 | 4.75e-50 | NR | AIB06815.1 | 1504566 | g27928 | i0 | 51.3 | 0.791899441340782 | 189 | 85 | 78.4 | 4 | 1 | 561 | 49 | 232 | AIB06815.1 nucleocapsid protein, partial [Otter fecal bunyavirus] | diamond | 567 | 173 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Otter fecal bunyavirus | |||
| 29773527 | 29773527 | PRJNA983848_P_NODE_54271_length_457_cov_3.427083_g48392_i0 | PRJNA983848 | 54271 | 457 | 3.427083 | 15.66176931 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 179 | 1.01e-48 | NR | YP_009333157.1 | 1922390 | g48392 | i0 | 57.7 | 0.978118161925602 | 149 | 63 | 97.8 | 0 | 7 | 453 | 1398 | 1546 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 447 | 179 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30120978 | 30120978 | PRJNA983848_P_NODE_111572_length_284_cov_3.748815_g105689_i0 | PRJNA983848 | 111572 | 284 | 3.748815 | 10.6466346 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 79.7 | 6.31e-15 | NR | YP_009333157.1 | 1922390 | g105689 | i0 | 38 | 0.971830985915493 | 92 | 57 | 97.2 | 0 | 9 | 284 | 1690 | 1781 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 276 | 79.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30152496 | 30152496 | PRJNA983848_P_NODE_16852_length_1464_cov_4.304098_g12881_i0 | PRJNA983848 | 16852 | 1464 | 4.304098 | 63.01199472 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 276 | 2.769999999999999e-82 | NR | YP_009333156.1 | 1922390 | g12881 | i0 | 35.6 | 1.03073770491803 | 503 | 292 | 99.2 | 12 | 3 | 1454 | 90 | 579 | YP_009333156.1 hypothetical protein 2 [Beihai hermit crab virus 3] | diamond | 1509 | 276 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30152497 | 30152497 | PRJNA983848_P_NODE_20072_length_1242_cov_3.779299_g15583_i0 | PRJNA983848 | 20072 | 1242 | 3.779299 | 46.93889358 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 587 | 2.629999999999999e-188 | NR | YP_009333157.1 | 1922390 | g15583 | i0 | 66.6 | 0.997584541062802 | 413 | 138 | 99.8 | 0 | 2 | 1240 | 794 | 1206 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 1239 | 587 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 30405933 | 30405933 | PRJNA983848_P_NODE_95773_length_310_cov_3.312236_g89890_i0 | PRJNA983848 | 95773 | 310 | 3.312236 | 10.2679316 | Otter fecal bunyavirus | 1504566 | Viruses | Viruses | 99.8 | 1.42e-22 | NR | AIB06816.1 | 1504566 | g89890 | i0 | 44.7 | 1.81935483870968 | 94 | 52 | 91 | 0 | 7 | 288 | 88 | 181 | AIB06816.1 glycoprotein, partial [Otter fecal bunyavirus] | diamond | 564 | 99.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Peribunyaviridae | Otter fecal bunyavirus | |||
| 30531809 | 30531809 | PRJNA983848_P_NODE_86753_length_329_cov_3.156250_g80870_i0 | PRJNA983848 | 86753 | 329 | 3.15625 | 10.3840625 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 78.6 | 2.73e-14 | NR | YP_009333154.1 | 1922390 | g80870 | i0 | 34.3 | 0.984802431610942 | 108 | 71 | 98.5 | 0 | 1 | 324 | 325 | 432 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 324 | 78.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31005801 | 31005801 | PRJNA983848_P_NODE_27354_length_891_cov_3.979218_g21976_i0 | PRJNA983848 | 27354 | 891 | 3.979218 | 35.45483238 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 106 | 1.58e-21 | NR | YP_009333154.1 | 1922390 | g21976 | i0 | 31.2 | 0.723905723905724 | 215 | 147 | 72.4 | 1 | 9 | 653 | 526 | 739 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 645 | 106 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31258646 | 31258646 | PRJNA983848_P_NODE_55215_length_451_cov_4.103175_g49336_i0 | PRJNA983848 | 55215 | 451 | 4.103175 | 18.50531925 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 66.2 | 2.2e-9 | NR | YP_009333154.1 | 1922390 | g49336 | i0 | 35.6 | 0.69179600886918 | 104 | 59 | 65.9 | 3 | 145 | 441 | 76 | 176 | YP_009333154.1 putative glycoprotein [Beihai hermit crab virus 3] | diamond | 312 | 66.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31480338 | 31480338 | PRJNA983848_P_NODE_20236_length_1230_cov_3.491789_g15724_i0 | PRJNA983848 | 20236 | 1230 | 3.491789 | 42.9490047 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 349 | 4.84e-104 | NR | YP_009333157.1 | 1922390 | g15724 | i0 | 45.4 | 1 | 410 | 222 | 99.5 | 1 | 7 | 1230 | 1780 | 2189 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 1230 | 349 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus | ||
| 31701447 | 31701447 | PRJNA983848_P_NODE_20517_length_1213_cov_4.097368_g15972_i0 | PRJNA983848 | 20517 | 1213 | 4.097368 | 49.70107384 | Austropotamobius brown spot virus | 2576634 | Viruses | Viruses | 241 | 8.299999999999999e-68 | NR | QCO84580.1 | 2576634 | g15972 | i0 | 31.3 | 0.9719703215169 | 393 | 266 | 96.5 | 4 | 1171 | 2 | 167 | 558 | QCO84580.1 glycoprotein, partial [Austropotamobius brown spot virus] | diamond | 1179 | 241 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Austropotamobius brown spot virus | ||||
| 32556020 | 32556020 | PRJNA983848_P_NODE_99739_length_303_cov_1.765217_g93856_i0 | PRJNA983848 | 99739 | 303 | 1.765217 | 5.34860751 | Beihai hermit crab virus 3 | 1922390 | Viruses | Viruses | 176 | 1.07e-48 | NR | YP_009333157.1 | 1922390 | g93856 | i0 | 84.8 | 0.98019801980198 | 99 | 15 | 98 | 0 | 5 | 301 | 693 | 791 | YP_009333157.1 RNA-dependent RNA polymerase [Beihai hermit crab virus 3] | diamond | 297 | 176 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Mivirus | Hermit mivirus |
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);;