contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA939369" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2189785 | 2189785 | PRJNA939369_S_NODE_502_length_1483_cov_5.260993_g296_i0 | PRJNA939369 | 502 | 1483 | 5.260993 | 78.02052619 | Fiersviridae | 2842319 | Viruses | Viruses | 85.9 | 8.56e-14 | NR | YP_010771401.1 | 2786414 | g296 | i0 | 25.4 | 1.50101146325017 | 311 | 211 | 59.7 | 7 | 446 | 1330 | 184 | 489 | YP_010771401.1 maturation protein [ssRNA phage SRR5466725_16] | diamond | 2226 | 86.7 | 0.990772779700115 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Grendvuvirus | Grendvuvirus asiocola | ||
| 3465134 | 3465134 | PRJNA939369_S_NODE_33223_length_292_cov_1.100457_g32806_i0 | PRJNA939369 | 33223 | 292 | 1.100457 | 3.21333444 | Camellia sinensis secoviridae virus 1 | 2957729 | Viruses | Viruses | 199 | 7.429999999999999e-57 | NR | USS99170.1 | 2957729 | g32806 | i0 | 95.8 | 6.9041095890411 | 96 | 4 | 98.6 | 0 | 3 | 290 | 1779 | 1874 | USS99170.1 polyprotein [Camellia sinensis secoviridae virus 1] | diamond | 2016 | 199 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Camellia sinensis secoviridae virus 1 | |||
| 16217224 | 16217224 | PRJNA939369_S_NODE_2453_length_716_cov_1.819596_g2069_i0 | PRJNA939369 | 2453 | 716 | 1.819596 | 13.02830736 | Picobirnavirus sp. | 1907787 | Viruses | Viruses | 370 | 2.84e-123 | NR | QXV86716.1 | 1907787 | g2069 | i0 | 75.2 | 0.99720670391061506 | 238 | 59 | 99.7 | 0 | 714 | 1 | 130 | 367 | QXV86716.1 MAG: RNA-dependent RNA-polymerase [Picobirnavirus sp.] | diamond | 714 | 370 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 21316231 | 21316231 | PRJNA939369_S_NODE_1117_length_990_cov_2.451472_g809_i0 | PRJNA939369 | 1117 | 990 | 2.451472 | 24.2695728 | Orthopicobirnavirus | 2948851 | Viruses | Viruses | 425 | 1.2599999999999996e-143 | NR | USE08238.1 | 1907787 | g809 | i0 | 63.5 | 4.85151515151515 | 329 | 115 | 99.1 | 2 | 981 | 1 | 124 | 449 | USE08238.1 MAG: putative RNA-dependent RNA polymerase, partial [Picobirnavirus sp.] | diamond | 4803 | 429 | 0.990675990675991 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 27031900 | 27031900 | PRJNA939369_S_NODE_72902_length_242_cov_2.201183_g72485_i0 | PRJNA939369 | 72902 | 242 | 2.201183 | 5.32686286 | Orthopicobirnavirus | 2948851 | Viruses | Viruses | 122 | 1.25e-30 | NR | UAW00543.1 | 442302 | g72485 | i0 | 75.3 | 1.92148760330579 | 77 | 19 | 95.5 | 0 | 1 | 231 | 44 | 120 | UAW00543.1 MAG: RNA-dependent RNA polymerase [Porcine picobirnavirus] | diamond | 465 | 123 | 0.991869918699187 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Porcine picobirnavirus | ||
| 28098810 | 28098810 | PRJNA939369_S_NODE_33225_length_292_cov_1.073059_g32808_i0 | PRJNA939369 | 33225 | 292 | 1.073059 | 3.13333228 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 61.2 | 9.35e-9 | NR | AVX53416.1 | 2161795 | g32808 | i0 | 46.6 | 0.75 | 73 | 39 | 75 | 0 | 68 | 286 | 121 | 193 | AVX53416.1 putative ORF1 [Marmot picobirnavirus] | diamond | 219 | 61.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 28572453 | 28572453 | PRJNA939369_S_NODE_33667_length_291_cov_1.059633_g33250_i0 | PRJNA939369 | 33667 | 291 | 1.059633 | 3.08353203 | Cystovirus CAP3 | 2876922 | Viruses | Viruses | 48.5 | 4.44e-4 | NR | UBF42555.1 | 2876922 | g33250 | i0 | 36 | 0.88659793814433 | 86 | 48 | 86.6 | 2 | 2 | 253 | 123 | 203 | UBF42555.1 SpoIIE-like phosphate domain protein [Cystovirus CAP3] | diamond | 258 | 48.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Cystovirus CAP3 | ||
| 29803796 | 29803796 | PRJNA939369_S_NODE_12931_length_389_cov_1.319620_g12514_i0 | PRJNA939369 | 12931 | 389 | 1.31962 | 5.1333218 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 184 | 6.859999999999999e-52 | NR | UQT02510.1 | 2936548 | g12514 | i0 | 68.3 | 0.948586118251928 | 123 | 39 | 94.9 | 0 | 18 | 386 | 88 | 210 | UQT02510.1 P2 [Red mite associated cystovirus] | diamond | 369 | 184 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 29930423 | 29930423 | PRJNA939369_S_NODE_20291_length_336_cov_2.148289_g19874_i0 | PRJNA939369 | 20291 | 336 | 2.148289 | 7.21825104 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 94.4 | 3.9e-21 | NR | AVX53416.1 | 2161795 | g19874 | i0 | 63.8 | 0.714285714285714 | 80 | 29 | 71.4 | 0 | 37 | 276 | 14 | 93 | AVX53416.1 putative ORF1 [Marmot picobirnavirus] | diamond | 240 | 94.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 30088126 | 30088126 | PRJNA939369_S_NODE_3792_length_602_cov_2.421550_g3386_i0 | PRJNA939369 | 3792 | 602 | 2.42155 | 14.577731 | Qianjiang noda-like virus 72 | 3348660 | Viruses | Viruses | 52 | 5.83e-4 | NR | XHA86042.1 | 3348660 | g3386 | i0 | 26.6 | 0.712624584717608 | 143 | 101 | 70.8 | 3 | 599 | 174 | 475 | 614 | XHA86042.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang noda-like virus 72] | diamond | 429 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 72 | |||
| 30309868 | 30309868 | PRJNA939369_S_NODE_312_length_1918_cov_3.566938_g165_i0 | PRJNA939369 | 312 | 1918 | 3.566938 | 68.41387084 | Leviviridae sp. | 2027243 | Viruses | Viruses | 245 | 1.18e-71 | NR | URG16217.1 | 2027243 | g165 | i0 | 42.9 | 2.32429614181439 | 345 | 177 | 52.6 | 7 | 561 | 1568 | 3 | 336 | URG16217.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 4458 | 245 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30909811 | 30909811 | PRJNA939369_S_NODE_2654_length_694_cov_1.975845_g2260_i0 | PRJNA939369 | 2654 | 694 | 1.975845 | 13.7123643 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 102 | 3.96e-21 | NR | AVX53395.1 | 2161795 | g2260 | i0 | 35.8 | 2.48991354466859 | 162 | 91 | 70 | 2 | 497 | 12 | 44 | 192 | AVX53395.1 putative capsid [Marmot picobirnavirus] | diamond | 1728 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 30948484 | 30948484 | PRJNA939369_S_NODE_6854_length_484_cov_1.423358_g6437_i0 | PRJNA939369 | 6854 | 484 | 1.423358 | 6.88905272 | Stralarivirus | 2948915 | Viruses | Viruses | 184 | 1.06e-50 | NR | BBG58107.1 | 1676255 | g6437 | i0 | 95.7 | 2.87603305785124 | 93 | 4 | 57.6 | 0 | 484 | 206 | 450 | 542 | BBG58107.1 polyprotein, partial [Cnidium vein yellowing virus 2] | diamond | 1392 | 184 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Cnidium vein yellowing virus 2 | ||||
| 31320476 | 31320476 | PRJNA939369_S_NODE_1035_length_1027_cov_1.708595_g749_i0 | PRJNA939369 | 1035 | 1027 | 1.708595 | 17.54727065 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 319 | 2.15e-102 | NR | AVX53417.1 | 2161795 | g749 | i0 | 49.6 | 0.984420642648491 | 337 | 160 | 96.4 | 5 | 3 | 992 | 115 | 448 | AVX53417.1 putative capsid, partial [Marmot picobirnavirus] | diamond | 1011 | 319 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 31889823 | 31889823 | PRJNA939369_S_NODE_197_length_2435_cov_6.287045_g83_i0 | PRJNA939369 | 197 | 2435 | 6.287045 | 153.08954575 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 414 | 4.68e-133 | NR | AVX53417.1 | 2161795 | g83 | i0 | 48.2 | 0.590143737166324 | 479 | 221 | 57.4 | 9 | 1399 | 2 | 2 | 466 | AVX53417.1 putative capsid, partial [Marmot picobirnavirus] | diamond | 1437 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 32403244 | 32403244 | PRJNA939369_S_NODE_62139_length_248_cov_0.880000_g61722_i0 | PRJNA939369 | 62139 | 248 | 0.88 | 2.1824 | Konmavirus | 2842809 | Viruses | Viruses | 68.6 | 3.17e-11 | NR | YP_010770188.1 | 2786682 | g61722 | i0 | 50.7 | 1.79032258064516 | 69 | 34 | 83.5 | 0 | 229 | 23 | 300 | 368 | YP_010770188.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_4] | diamond | 444 | 68.9 | 0.995645863570392 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Blumeviridae | Konmavirus | Konmavirus peladaptatum | ||
| 32774707 | 32774707 | PRJNA939369_S_NODE_28300_length_306_cov_0.939914_g27883_i0 | PRJNA939369 | 28300 | 306 | 0.939914 | 2.87613684 | Leviviridae sp. | 2027243 | Viruses | Viruses | 79.3 | 1.08e-14 | NR | UJQ85467.1 | 2027243 | g27883 | i0 | 48.1 | 1.54901960784314 | 79 | 41 | 77.5 | 0 | 239 | 3 | 294 | 372 | UJQ85467.1 MAG: hypothetical protein 3 [Leviviridae sp.] | diamond | 474 | 79.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;