contig_metadata
12 rows where bioproject = "PRJNA1136505" and tax_kingdom = "Bamfordvirae"
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 | ||
| 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. | |||
| 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 |
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);;