contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA734348" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8371644 | 8371644 | PRJNA734348_P_NODE_49087_length_291_cov_1.839450_g48390_i0 | PRJNA734348 | 49087 | 291 | 1.83945 | 5.3527995 | Locarnavirus | 2560169 | Viruses | Viruses | 196 | 8.859999999999999e-56 | NR | ULF50557.1 | 2715102 | g48390 | i0 | 94.8 | 5.93814432989691 | 96 | 5 | 99 | 0 | 2 | 289 | 442 | 537 | ULF50557.1 MAG: hypothetical protein 1 [Marnaviridae sp.] | diamond | 1728 | 196 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Marnaviridae sp. | |||
| 8372362 | 8372362 | PRJNA734348_P_NODE_87_length_7152_cov_14.340726_g75_i0 | PRJNA734348 | 87 | 7152 | 14.340726 | 1025.64872352 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 1061 | 0 | NR | NP_690823.1 | 161736 | g75 | i0 | 79.5 | 0.270553691275168 | 645 | 132 | 27.1 | 0 | 1719 | 3653 | 12 | 656 | NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] | diamond | 1935 | 1061 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 9645839 | 9645839 | PRJNA734348_P_NODE_136048_length_238_cov_2.896970_g135350_i0 | PRJNA734348 | 136048 | 238 | 2.89697 | 6.8947886 | Mitovirus sp. | 2587224 | Viruses | Viruses | 78.6 | 6.78e-15 | NR | QDH87999.1 | 2587224 | g135350 | i0 | 62.5 | 2.50840336134454 | 64 | 23 | 80.7 | 1 | 47 | 238 | 12 | 74 | QDH87999.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] | diamond | 597 | 78.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 12197481 | 12197481 | PRJNA734348_P_NODE_37830_length_318_cov_1.208163_g37134_i0 | PRJNA734348 | 37830 | 318 | 1.208163 | 3.84195834 | Leviviridae sp. | 2027243 | Viruses | Viruses | 94.4 | 6.7e-20 | NR | WNK16400.1 | 2027243 | g37134 | i0 | 51.5 | 0.971698113207547 | 103 | 48 | 97.2 | 1 | 316 | 8 | 126 | 226 | WNK16400.1 MAG: putative replicase protein [Leviviridae sp.] | diamond | 309 | 94.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 27463417 | 27463417 | PRJNA734348_P_NODE_39803_length_311_cov_1.294118_g39107_i0 | PRJNA734348 | 39803 | 311 | 1.294118 | 4.02470698 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 168 | 4.19e-49 | NR | 2VHC_A | 161736 | g39107 | i0 | 92.7 | 0.92604501607717 | 96 | 7 | 92.6 | 0 | 3 | 290 | 236 | 331 | 2VHC_A Chain A, NTPASE P4 [Pseudomonas phage phi12] | diamond | 288 | 168 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 28000235 | 28000235 | PRJNA734348_P_NODE_65225_length_274_cov_2.124378_g64528_i0 | PRJNA734348 | 65225 | 274 | 2.124378 | 5.82079572 | brine shrimp yue-like virus 8 | 2900460 | Viruses | Viruses | 145 | 4.32e-38 | NR | UNI74191.1 | 2900460 | g64528 | i0 | 77.4 | 1.01824817518248 | 93 | 18 | 98.5 | 1 | 3 | 272 | 1628 | 1720 | UNI74191.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 8] | diamond | 279 | 145 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 8 | |||
| 28031682 | 28031682 | PRJNA734348_P_NODE_1445_length_2234_cov_17.841277_g1291_i0 | PRJNA734348 | 1445 | 2234 | 17.841277 | 398.57412818 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 261 | 3.16e-78 | NR | NP_690829.1 | 161736 | g1291 | i0 | 55.1 | 0.331692032229185 | 247 | 109 | 32.9 | 1 | 1397 | 2131 | 1 | 247 | NP_690829.1 muramidase [Pseudomonas phage phi12] | diamond | 741 | 261 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 28694877 | 28694877 | PRJNA734348_P_NODE_93327_length_251_cov_0.865169_g92629_i0 | PRJNA734348 | 93327 | 251 | 0.865169 | 2.17157419 | Qianjiang dicistro-like virus 113 | 3347367 | Viruses | Viruses | 46.2 | 0.00255 | NR | XHA87929.1 | 3347367 | g92629 | i0 | 35.2 | 0.848605577689243 | 71 | 44 | 82.5 | 1 | 246 | 40 | 588 | 658 | XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] | diamond | 213 | 46.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Qianjiang dicistro-like virus 113 | |||
| 28915368 | 28915368 | PRJNA734348_P_NODE_42948_length_307_cov_1.794872_g42251_i0 | PRJNA734348 | 42948 | 307 | 1.794872 | 5.51025704 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 202 | 3.7300000000000004e-59 | NR | NP_690823.1 | 161736 | g42251 | i0 | 93.1 | 0.996742671009772 | 102 | 7 | 99.7 | 0 | 2 | 307 | 154 | 255 | NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] | diamond | 306 | 202 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 29325998 | 29325998 | PRJNA734348_P_NODE_24529_length_396_cov_1.857585_g23834_i0 | PRJNA734348 | 24529 | 396 | 1.857585 | 7.3560366 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 253 | 9.23e-78 | NR | NP_690825.1 | 161736 | g23834 | i0 | 96.9 | 0.992424242424242 | 131 | 4 | 99.2 | 0 | 394 | 2 | 181 | 311 | NP_690825.1 major core structural protein P1 [Pseudomonas phage phi12] | diamond | 393 | 253 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 29809791 | 29809791 | PRJNA734348_P_NODE_46311_length_296_cov_3.403587_g45614_i0 | PRJNA734348 | 46311 | 296 | 3.403587 | 10.07461752 | Mihkrovirus | 2842867 | Viruses | Viruses | 80.1 | 6.9e-17 | NR | QDH88675.1 | 2027243 | g45614 | i0 | 49.4 | 1.69256756756757 | 87 | 44 | 88.2 | 0 | 2 | 262 | 31 | 117 | QDH88675.1 MAG: hypothetical protein H1Bulk304066_000002 [Leviviridae sp.] | diamond | 501 | 80.9 | 0.990111248454882 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 30146939 | 30146939 | PRJNA734348_P_NODE_31212_length_348_cov_1.680000_g30516_i0 | PRJNA734348 | 31212 | 348 | 1.68 | 5.8464 | Pseudomonas phage phi12 | 161736 | Viruses | Viruses | 213 | 7.49e-63 | NR | NP_690825.1 | 161736 | g30516 | i0 | 97.4 | 1 | 116 | 3 | 100 | 0 | 1 | 348 | 68 | 183 | NP_690825.1 major core structural protein P1 [Pseudomonas phage phi12] | diamond | 348 | 213 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 31063776 | 31063776 | PRJNA734348_P_NODE_99875_length_249_cov_0.875000_g99177_i0 | PRJNA734348 | 99875 | 249 | 0.875 | 2.17875 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 166 | 5.049999999999999e-46 | NR | CAI9858974.1 | 3048756 | g99177 | i0 | 98.8 | 0.987951807228916 | 82 | 1 | 98.8 | 0 | 3 | 248 | 289 | 370 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 246 | 166 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 |
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);;