contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26817382 | 26817382 | PRJNA1136505_P_NODE_67201_length_362_cov_1.463668_g60341_i0 | PRJNA1136505 | 67201 | 362 | 1.463668 | 5.29847816 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 74.7 | 9.39e-13 | NR | YP_009449258.1 | 2023057 | g60341 | i0 | 39.7 | 1.00276243093923 | 121 | 67 | 99.4 | 3 | 361 | 2 | 38 | 153 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 363 | 74.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27165016 | 27165016 | PRJNA1136505_P_NODE_135602_length_249_cov_0.875000_g128742_i0 | PRJNA1136505 | 135602 | 249 | 0.875 | 2.17875 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 60.5 | 2.38e-8 | NR | YP_009449258.1 | 2023057 | g128742 | i0 | 35.6 | 1.04819277108434 | 87 | 49 | 100 | 3 | 1 | 249 | 165 | 248 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 261 | 60.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27481160 | 27481160 | PRJNA1136505_P_NODE_70663_length_351_cov_1.154676_g63803_i0 | PRJNA1136505 | 70663 | 351 | 1.154676 | 4.05291276 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 177 | 1.23e-52 | NR | YP_009449055.1 | 2023057 | g63803 | i0 | 70.1 | 1 | 117 | 35 | 100 | 0 | 1 | 351 | 122 | 238 | YP_009449055.1 ribonucleotide reductase large subunit [Orpheovirus IHUMI-LCC2] | diamond | 351 | 177 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27512811 | 27512811 | PRJNA1136505_P_NODE_34763_length_605_cov_1.924812_g27952_i0 | PRJNA1136505 | 34763 | 605 | 1.924812 | 11.6451126 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 188 | 2.1e-53 | NR | YP_009448979.1 | 2023057 | g27952 | i0 | 53.9 | 0.828099173553719 | 167 | 76 | 82.8 | 1 | 104 | 604 | 8 | 173 | YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 501 | 188 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27828491 | 27828491 | PRJNA1136505_P_NODE_109064_length_276_cov_2.108374_g102204_i0 | PRJNA1136505 | 109064 | 276 | 2.108374 | 5.81911224 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 131 | 1.0999999999999999e-33 | NR | YP_009448979.1 | 2023057 | g102204 | i0 | 67 | 0.989130434782609 | 91 | 30 | 98.9 | 0 | 275 | 3 | 291 | 381 | YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 273 | 131 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27923170 | 27923170 | PRJNA1136505_P_NODE_23945_length_913_cov_1.292857_g17583_i0 | PRJNA1136505 | 23945 | 913 | 1.292857 | 11.80378441 | Pithovirus LCPAC1 | 2506586 | Viruses | Viruses | 246 | 1.99e-76 | NR | QBK89984.1 | 2506586 | g17583 | i0 | 48.6 | 1.7710843373494 | 282 | 129 | 90.7 | 7 | 6 | 833 | 45 | 316 | QBK89984.1 MAG: phosphoribosyl transferase domain protein [Pithovirus LCPAC101] | diamond | 1617 | 246 | 1 | Viruses | Pithoviruses | Pithovirus LCPAC101 | |||||||
| 28175608 | 28175608 | PRJNA1136505_P_NODE_12886_length_1910_cov_2.580838_g8941_i0 | PRJNA1136505 | 12886 | 1910 | 2.580838 | 49.2940058 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 149 | 2.29e-33 | NR | YP_009449258.1 | 2023057 | g8941 | i0 | 31.9 | 0.920418848167539 | 586 | 314 | 91.3 | 25 | 120 | 1862 | 621 | 1126 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 1758 | 149 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 28649527 | 28649527 | PRJNA1136505_P_NODE_126047_length_255_cov_1.939560_g119187_i0 | PRJNA1136505 | 126047 | 255 | 1.93956 | 4.945878 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 70.9 | 5.42e-12 | NR | YP_009449258.1 | 2023057 | g119187 | i0 | 44.8 | 1.02352941176471 | 87 | 40 | 97.6 | 3 | 254 | 6 | 166 | 248 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 261 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 29565003 | 29565003 | PRJNA1136505_P_NODE_65450_length_368_cov_1.566102_g58590_i0 | PRJNA1136505 | 65450 | 368 | 1.566102 | 5.76325536 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 102 | 2.74e-22 | NR | YP_010781233.1 | 2126984 | g58590 | i0 | 46.3 | 1.00271739130435 | 123 | 62 | 97.8 | 3 | 5 | 364 | 1444 | 1565 | YP_010781233.1 hypothetical protein QJ856_gp0132 [Tupanvirus deep ocean] | diamond | 369 | 102 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 30164964 | 30164964 | PRJNA1136505_P_NODE_143772_length_245_cov_1.790698_g136912_i0 | PRJNA1136505 | 143772 | 245 | 1.790698 | 4.3872101 | Faunusvirus sp. | 2487766 | Viruses | Viruses | 70.5 | 6.51e-12 | NR | AYV79487.1 | 2487766 | g136912 | i0 | 41.6 | 0.942857142857143 | 77 | 43 | 94.3 | 1 | 243 | 13 | 235 | 309 | AYV79487.1 MAG: phosphatidylinositol kinase [Faunusvirus sp.] | diamond | 231 | 70.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Faunusvirus sp. | |||
| 30512664 | 30512664 | PRJNA1136505_P_NODE_139873_length_247_cov_0.885057_g133013_i0 | PRJNA1136505 | 139873 | 247 | 0.885057 | 2.18609079 | Erwinia phage vB_EamP-S6 | 1051675 | Viruses | Viruses | 66.6 | 1.57e-10 | NR | YP_007005815.1 | 1051675 | g133013 | i0 | 41.9 | 1.80971659919028 | 74 | 43 | 89.9 | 0 | 243 | 22 | 1929 | 2002 | YP_007005815.1 virion RNA polymerase [Erwinia phage vB_EamP-S6] | diamond | 447 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Waedenswilvirus | Waedenswilvirus S6 | |||
| 30544336 | 30544336 | PRJNA1136505_P_NODE_149493_length_243_cov_0.905882_g142633_i0 | PRJNA1136505 | 149493 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 48.5 | 2.75e-4 | NR | XOR05398.1 | 2832643 | g142633 | i0 | 41.6 | 2.77777777777778 | 77 | 43 | 93.8 | 2 | 242 | 15 | 128 | 203 | XOR05398.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 675 | 48.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30860281 | 30860281 | PRJNA1136505_P_NODE_63414_length_376_cov_0.815182_g56554_i0 | PRJNA1136505 | 63414 | 376 | 0.815182 | 3.06508432 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 79.3 | 2.36e-14 | NR | YP_009448636.1 | 2023057 | g56554 | i0 | 42.7 | 0.877659574468085 | 110 | 53 | 87.8 | 4 | 20 | 349 | 149 | 248 | YP_009448636.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 330 | 79.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 31207338 | 31207338 | PRJNA1136505_P_NODE_85635_length_314_cov_1.680498_g78775_i0 | PRJNA1136505 | 85635 | 314 | 1.680498 | 5.27676372 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 84.7 | 1.6e-16 | NR | YP_009449258.1 | 2023057 | g78775 | i0 | 41 | 0.955414012738854 | 100 | 53 | 95.5 | 2 | 303 | 4 | 52 | 145 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 300 | 84.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 31524226 | 31524226 | PRJNA1136505_P_NODE_82776_length_320_cov_2.251012_g75916_i0 | PRJNA1136505 | 82776 | 320 | 2.251012 | 7.2032384 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 142 | 1.9e-37 | NR | YP_009448979.1 | 2023057 | g75916 | i0 | 60 | 0.984375 | 105 | 42 | 98.4 | 0 | 5 | 319 | 388 | 492 | YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 315 | 142 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 32093460 | 32093460 | PRJNA1136505_P_NODE_102998_length_284_cov_1.459716_g96138_i0 | PRJNA1136505 | 102998 | 284 | 1.459716 | 4.14559344 | Penicillium discovirus | 2185132 | Viruses | Viruses | 107 | 3.79e-26 | NR | YP_010840287.1 | 2185132 | g96138 | i0 | 57.4 | 0.992957746478873 | 94 | 40 | 99.3 | 0 | 283 | 2 | 44 | 137 | YP_010840287.1 Nucleocapsid [Penicillium discovirus] | diamond | 282 | 107 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Discoviridae | Orthodiscovirus | Orthodiscovirus missouriense |
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);;