contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA896758" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27719570 | 27719570 | PRJNA896758_P_NODE_5144_length_501_cov_1.724299_g4756_i0 | PRJNA896758 | 5144 | 501 | 1.724299 | 8.63873799 | Sea turtle neural virus 1 | 3112944 | Viruses | Viruses | 49.7 | 0.00171 | NR | WET19891.1 | 3112944 | g4756 | i0 | 52.4 | 0.251497005988024 | 42 | 20 | 25.1 | 0 | 501 | 376 | 456 | 497 | WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] | diamond | 126 | 49.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Sea turtle neural virus 1 | ||
| 27782372 | 27782372 | PRJNA896758_P_NODE_12884_length_320_cov_1.611336_g12494_i0 | PRJNA896758 | 12884 | 320 | 1.611336 | 5.1562752 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 109 | 3.27e-26 | NR | XOS40026.1 | 2832643 | g12494 | i0 | 64.5 | 0.7125 | 76 | 27 | 71.3 | 0 | 230 | 3 | 34 | 109 | XOS40026.1 MAG: hypothetical protein MSP1048_67 [Caudoviricetes sp.] | diamond | 228 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27782390 | 27782390 | PRJNA896758_P_NODE_24624_length_245_cov_0.895349_g24234_i0 | PRJNA896758 | 24624 | 245 | 0.895349 | 2.19360505 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 145 | 2.86e-39 | NR | XAO34295.1 | 3145150 | g24234 | i0 | 80.2 | 0.991836734693878 | 81 | 16 | 99.2 | 0 | 1 | 243 | 177 | 257 | XAO34295.1 hypothetical protein HMHLAPFJ_00001 [Ralstonia phage PY059YO380] | diamond | 243 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 28129653 | 28129653 | PRJNA896758_P_NODE_14305_length_304_cov_1.000000_g13915_i0 | PRJNA896758 | 14305 | 304 | 1 | 3.04 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 1.11e-33 | NR | XOS40026.1 | 2832643 | g13915 | i0 | 59.4 | 0.996710526315789 | 101 | 41 | 99.7 | 0 | 2 | 304 | 213 | 313 | XOS40026.1 MAG: hypothetical protein MSP1048_67 [Caudoviricetes sp.] | diamond | 303 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28413839 | 28413839 | PRJNA896758_P_NODE_9466_length_371_cov_1.429530_g9076_i0 | PRJNA896758 | 9466 | 371 | 1.42953 | 5.3035563 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82.4 | 5.64e-17 | NR | XOR88454.1 | 2832643 | g9076 | i0 | 82.2 | 0.363881401617251 | 45 | 8 | 36.4 | 0 | 237 | 371 | 1 | 45 | XOR88454.1 MAG: hypothetical protein MSP1660_66 [Caudoviricetes sp.] | diamond | 135 | 82.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28823905 | 28823905 | PRJNA896758_P_NODE_19088_length_266_cov_1.533679_g18698_i0 | PRJNA896758 | 19088 | 266 | 1.533679 | 4.07958614 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.2 | 9.81e-13 | NR | XOR52210.1 | 2832643 | g18698 | i0 | 50 | 1.92857142857143 | 86 | 43 | 97 | 0 | 2 | 259 | 1074 | 1159 | XOR52210.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 513 | 73.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29866142 | 29866142 | PRJNA896758_P_NODE_13811_length_309_cov_3.546610_g13421_i0 | PRJNA896758 | 13811 | 309 | 3.54661 | 10.9590249 | Micromonas commoda virus | 3057169 | Viruses | Viruses | 60.1 | 6.62e-9 | NR | XHR79475.1 | 3057169 | g13421 | i0 | 50 | 1.2621359223301 | 70 | 31 | 68 | 1 | 23 | 232 | 62 | 127 | XHR79475.1 hypothetical protein [Micromonas commoda virus] | diamond | 390 | 60.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Micromonas commoda virus | |||
| 29992568 | 29992568 | PRJNA896758_P_NODE_23011_length_248_cov_0.880000_g22621_i0 | PRJNA896758 | 23011 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 100 | 1.05e-22 | NR | XOS39995.1 | 2832643 | g22621 | i0 | 72.6 | 0.883064516129032 | 73 | 17 | 88.3 | 2 | 30 | 248 | 126 | 195 | XOS39995.1 MAG: conserved phage protein [Caudoviricetes sp.] | diamond | 219 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31414546 | 31414546 | PRJNA896758_P_NODE_21456_length_251_cov_0.865169_g21066_i0 | PRJNA896758 | 21456 | 251 | 0.865169 | 2.17157419 | Acanthamoeba castellanii medusavirus | 2080449 | Viruses | Viruses | 57.8 | 2.07e-7 | NR | YP_010804886.1 | 2080449 | g21066 | i0 | 47.4 | 0.932270916334661 | 78 | 39 | 93.2 | 2 | 4 | 237 | 76 | 151 | YP_010804886.1 replication factor C large subunit [Acanthamoeba castellanii medusavirus] | diamond | 234 | 57.8 | 1 | Viruses | Acanthamoeba castellanii medusavirus | ||||||||
| 31477957 | 31477957 | PRJNA896758_P_NODE_25016_length_244_cov_0.900585_g24626_i0 | PRJNA896758 | 25016 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 154 | 7.47e-42 | NR | XOR78535.1 | 2832643 | g24626 | i0 | 93.8 | 0.995901639344262 | 81 | 5 | 99.6 | 0 | 1 | 243 | 38 | 118 | XOR78535.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 243 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31509580 | 31509580 | PRJNA896758_P_NODE_24116_length_246_cov_0.890173_g23726_i0 | PRJNA896758 | 24116 | 246 | 0.890173 | 2.18982558 | Durnavirales sp. | 2809355 | Viruses | Viruses | 49.3 | 1.9e-4 | NR | WRQ64726.1 | 2809355 | g23726 | i0 | 41 | 1.01219512195122 | 83 | 46 | 98.8 | 3 | 246 | 4 | 10 | 91 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 249 | 49.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 31801601 | 31801601 | PRJNA896758_P_NODE_10257_length_357_cov_1.084507_g9867_i0 | PRJNA896758 | 10257 | 357 | 1.084507 | 3.87168999 | root | 1 | Root_unresolved | Root_unresolved | 106 | 1.95e-26 | NR | YP_184795.1 | 39640 | g9867 | i0 | 57 | 9.57983193277311 | 86 | 37 | 72.3 | 0 | 345 | 88 | 68 | 153 | YP_184795.1 Histone [Bracoviriform congregatae] | diamond | 3420 | 107 | 0.990654205607477 | Viruses | Polydnaviriformidae | Bracoviriform | Bracoviriform congregatae |
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);;