contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA980585" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27500281 | 27500281 | PRJNA980585_P_NODE_26943_length_288_cov_1.432558_g26689_i0 | PRJNA980585 | 26943 | 288 | 1.432558 | 4.12576704 | Mycobacterium phage Indlulamithi | 2656582 | Viruses | Viruses | 44.3 | 0.0185 | NR | YP_009853827.1 | 2656582 | g26689 | i0 | 39.4 | 0.6875 | 66 | 37 | 66.7 | 2 | 283 | 92 | 825 | 889 | YP_009853827.1 DNA polymerase [Mycobacterium phage Indlulamithi] | diamond | 198 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Indlulamithivirus | Indlulamithivirus indlulamithi | ||||
| 27847325 | 27847325 | PRJNA980585_P_NODE_29944_length_280_cov_1.140097_g29690_i0 | PRJNA980585 | 29944 | 280 | 1.140097 | 3.1922716 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 172 | 1.0299999999999999e-52 | NR | XOR38049.1 | 2832643 | g29690 | i0 | 86 | 0.996428571428571 | 93 | 13 | 99.6 | 0 | 1 | 279 | 36 | 128 | XOR38049.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 279 | 172 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27847359 | 27847359 | PRJNA980585_P_NODE_61604_length_235_cov_2.518519_g61350_i0 | PRJNA980585 | 61604 | 235 | 2.518519 | 5.91851965 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 45.4 | 0.0036 | NR | XOR59761.1 | 2832643 | g61350 | i0 | 52.1 | 0.612765957446809 | 48 | 20 | 61.3 | 1 | 146 | 3 | 122 | 166 | XOR59761.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 144 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28289349 | 28289349 | PRJNA980585_P_NODE_40206_length_251_cov_1.589888_g39952_i0 | PRJNA980585 | 40206 | 251 | 1.589888 | 3.99061888 | Stenotrophomonas phage Philippe | 2859655 | Viruses | Viruses | 42.7 | 0.0429 | NR | YP_010657518.1 | 2859655 | g39952 | i0 | 31.5 | 0.872509960159363 | 73 | 45 | 87.3 | 1 | 16 | 234 | 1723 | 1790 | YP_010657518.1 single subunit virion RNA polymerase [Stenotrophomonas phage Philippe] | diamond | 219 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Philippevirus | Philippevirus philippe | |||
| 28573606 | 28573606 | PRJNA980585_P_NODE_45947_length_248_cov_3.222857_g45693_i0 | PRJNA980585 | 45947 | 248 | 3.222857 | 7.99268536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52 | 1.75e-6 | NR | XOR12428.1 | 2832643 | g45693 | i0 | 54.8 | 0.508064516129032 | 42 | 19 | 50.8 | 0 | 3 | 128 | 44 | 85 | XOR12428.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 126 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28889315 | 28889315 | PRJNA980585_P_NODE_13548_length_374_cov_5.378738_g13294_i0 | PRJNA980585 | 13548 | 374 | 5.378738 | 20.11648012 | Bacillus phage vB_BsuM-Goe3 | 1933063 | Viruses | Viruses | 45.1 | 0.00629 | NR | YP_009832166.1 | 1933063 | g13294 | i0 | 39.7 | 0.545454545454545 | 68 | 36 | 50.5 | 2 | 210 | 22 | 51 | 118 | YP_009832166.1 CoA ligase [Bacillus phage vB_BsuM-Goe3] | diamond | 204 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Grisebachstrassevirus | Grisebachstrassevirus goe3 | |||
| 29236841 | 29236841 | PRJNA980585_P_NODE_49169_length_247_cov_0.885057_g48915_i0 | PRJNA980585 | 49169 | 247 | 0.885057 | 2.18609079 | Myoviridae sp. ct | 2832643 | Viruses | Viruses | 70.5 | 6.6e-12 | NR | DAD71951.1 | 2827599 | g48915 | i0 | 50 | 0.874493927125506 | 72 | 35 | 87.4 | 1 | 11 | 226 | 334 | 404 | DAD71951.1 MAG TPA: endonuclease-like protein [Myoviridae sp. ct0f722] | diamond | 216 | 70.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Myoviridae sp. ct0f722 | |||||
| 29868261 | 29868261 | PRJNA980585_P_NODE_29551_length_281_cov_1.149038_g29297_i0 | PRJNA980585 | 29551 | 281 | 1.149038 | 3.22879678 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 122 | 1.91e-32 | NR | XOQ90693.1 | 2832643 | g29297 | i0 | 58.2 | 2.7864768683274 | 91 | 38 | 97.2 | 0 | 6 | 278 | 74 | 164 | XOQ90693.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 783 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30184114 | 30184114 | PRJNA980585_P_NODE_29252_length_282_cov_0.842105_g28998_i0 | PRJNA980585 | 29252 | 282 | 0.842105 | 2.3747361 | Brevundimonas phage vB_BgoS-Bajun | 2948594 | Viruses | Viruses | 119 | 1.04e-28 | NR | UTC29883.1 | 2948594 | g28998 | i0 | 69.9 | 0.98936170212766 | 93 | 28 | 98.9 | 0 | 279 | 1 | 1352 | 1444 | UTC29883.1 putative tail tape measure protein [Brevundimonas phage vB_BgoS-Bajun] | diamond | 279 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Brevundimonas phage vB_BgoS-Bajun |
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);;