contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA685060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3216994 | 3216994 | PRJNA685060_P_NODE_11943_length_269_cov_2.637755_g11853_i0 | PRJNA685060 | 11943 | 269 | 2.637755 | 7.09556095 | Gordonia phage ObLaDi | 2978487 | Viruses | Viruses | 89 | 4.66e-20 | NR | UXE03743.1 | 2978487 | g11853 | i0 | 56.3 | 2.23048327137546 | 71 | 31 | 79.2 | 0 | 39 | 251 | 62 | 132 | UXE03743.1 HNH endonuclease [Gordonia phage ObLaDi] | diamond | 600 | 89 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kruegerviridae | Cafassovirus | Cafassovirus obladi | |||
| 27050678 | 27050678 | PRJNA685060_P_NODE_7742_length_342_cov_1.717472_g7652_i0 | PRJNA685060 | 7742 | 342 | 1.717472 | 5.87375424 | Siphoviridae sp. ctCIv11 | 2827806 | Viruses | Viruses | 50.4 | 1.66e-4 | NR | DAF44839.1 | 2827806 | g7652 | i0 | 33.3 | 0.684210526315789 | 78 | 49 | 67.5 | 2 | 18 | 248 | 159 | 234 | DAF44839.1 MAG TPA: HD domain [Siphoviridae sp. ctCIv11] | diamond | 234 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctCIv11 | |||||
| 27524560 | 27524560 | PRJNA685060_P_NODE_1843_length_731_cov_2.156535_g1761_i0 | PRJNA685060 | 1843 | 731 | 2.156535 | 15.76427085 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 184 | 9.49e-52 | NR | WRQ64934.1 | 2809868 | g1761 | i0 | 57.1 | 0.640218878248974 | 156 | 54 | 61.6 | 3 | 1 | 450 | 277 | 425 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 468 | 184 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 29702782 | 29702782 | PRJNA685060_P_NODE_1790_length_743_cov_2.150746_g1708_i0 | PRJNA685060 | 1790 | 743 | 2.150746 | 15.98004278 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 236 | 2.19e-72 | NR | WRQ64935.1 | 2809868 | g1708 | i0 | 50.2 | 1.00538358008075 | 249 | 118 | 99.7 | 5 | 1 | 741 | 67 | 311 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 747 | 236 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 30430119 | 30430119 | PRJNA685060_P_NODE_12513_length_262_cov_1.010582_g12423_i0 | PRJNA685060 | 12513 | 262 | 1.010582 | 2.64772484 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 78.6 | 1.04e-14 | NR | WRQ64934.1 | 2809868 | g12423 | i0 | 44.8 | 0.99618320610687 | 87 | 48 | 99.6 | 0 | 261 | 1 | 63 | 149 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 261 | 78.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 32516958 | 32516958 | PRJNA685060_P_NODE_9939_length_299_cov_2.367257_g9849_i0 | PRJNA685060 | 9939 | 299 | 2.367257 | 7.07809843 | Rhabdoviridae sp. | 1955137 | Viruses | Viruses | 69.7 | 2.34e-11 | NR | XKB76561.1 | 1955137 | g9849 | i0 | 37.1 | 0.973244147157191 | 97 | 60 | 96.3 | 1 | 298 | 11 | 282 | 378 | XKB76561.1 MAG: hypothetical protein [Rhabdoviridae sp.] | diamond | 291 | 69.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Rhabdoviridae 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);;