contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26855136 | 26855136 | PRJNA492280_P_NODE_20601_length_164_cov_3.236220_g20494_i0 | PRJNA492280 | 20601 | 164 | 3.23622 | 5.3074008 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75.5 | 1.3e-14 | NR | XOS36382.1 | 2832643 | g20494 | i0 | 74 | 0.914634146341463 | 50 | 10 | 91.5 | 1 | 3 | 152 | 108 | 154 | XOS36382.1 MAG: thymidylate synthase [Caudoviricetes sp.] | diamond | 150 | 75.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26886756 | 26886756 | PRJNA492280_P_NODE_19721_length_164_cov_3.377953_g19614_i0 | PRJNA492280 | 19721 | 164 | 3.377953 | 5.53984292 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 49.3 | 6.21e-5 | NR | XOR14691.1 | 2832643 | g19614 | i0 | 95.8 | 0.439024390243902 | 24 | 1 | 43.9 | 0 | 91 | 162 | 626 | 649 | XOR14691.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] | diamond | 72 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27803078 | 27803078 | PRJNA492280_P_NODE_13024_length_164_cov_5.779528_g12917_i0 | PRJNA492280 | 13024 | 164 | 5.779528 | 9.47842592 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 51.6 | 9.46e-6 | NR | CAB4152307.1 | 2100421 | g12917 | i0 | 95.8 | 0.439024390243902 | 24 | 1 | 43.9 | 0 | 5 | 76 | 407 | 430 | CAB4152307.1 PolA DNA polymerase I - 3'-5' exonuclease and polymerase domains [uncultured Caudovirales phage] | diamond | 72 | 51.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28181566 | 28181566 | PRJNA492280_P_NODE_14326_length_164_cov_4.881890_g14219_i0 | PRJNA492280 | 14326 | 164 | 4.88189 | 8.0062996 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 57 | 1.18e-7 | NR | XOS71940.1 | 2832643 | g14219 | i0 | 92 | 0.914634146341463 | 25 | 2 | 45.7 | 0 | 89 | 163 | 571 | 595 | XOS71940.1 MAG: phage associated primase, partial [Caudoviricetes sp.] | diamond | 150 | 57 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28812959 | 28812959 | PRJNA492280_P_NODE_17328_length_164_cov_3.874016_g17221_i0 | PRJNA492280 | 17328 | 164 | 3.874016 | 6.35338624 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 45.1 | 0.00193 | NR | CAB4134624.1 | 2100421 | g17221 | i0 | 58.1 | 0.786585365853659 | 43 | 12 | 67.7 | 2 | 159 | 49 | 165 | 207 | CAB4134624.1 Phage-like element PBSX protein, XkdF [uncultured Caudovirales phage] | diamond | 129 | 45.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28971212 | 28971212 | PRJNA492280_P_NODE_33128_length_150_cov_4.398230_g33021_i0 | PRJNA492280 | 33128 | 150 | 4.39823 | 6.597345 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40.8 | 0.049 | NR | XOS01503.1 | 2832643 | g33021 | i0 | 62.5 | 0.48 | 24 | 9 | 48 | 0 | 77 | 148 | 240 | 263 | XOS01503.1 MAG: hypothetical protein MSP1228_56 [Caudoviricetes sp.] | diamond | 72 | 40.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29034564 | 29034564 | PRJNA492280_P_NODE_34188_length_150_cov_3.265487_g34081_i0 | PRJNA492280 | 34188 | 150 | 3.265487 | 4.8982305 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 79 | 1.13e-15 | NR | XOR14693.1 | 2832643 | g34081 | i0 | 46.1 | 2.04 | 102 | 2 | 98 | 1 | 148 | 2 | 239 | 340 | XOR14693.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] | diamond | 306 | 79 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29476055 | 29476055 | PRJNA492280_P_NODE_29610_length_151_cov_6.710526_g29503_i0 | PRJNA492280 | 29610 | 151 | 6.710526 | 10.13289426 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 55.8 | 3.12e-8 | NR | XAO34315.1 | 3145150 | g29503 | i0 | 91.7 | 0.47682119205298 | 24 | 2 | 47.7 | 0 | 77 | 148 | 31 | 54 | XAO34315.1 hypothetical protein HMHLAPFJ_00021 [Ralstonia phage PY059YO380] | diamond | 72 | 55.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 29665418 | 29665418 | PRJNA492280_P_NODE_24650_length_164_cov_2.629921_g24543_i0 | PRJNA492280 | 24650 | 164 | 2.629921 | 4.31307044 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 74.3 | 9.21e-14 | NR | XOS31925.1 | 2832643 | g24543 | i0 | 64.7 | 1.24390243902439 | 68 | 9 | 97 | 1 | 4 | 162 | 77 | 144 | XOS31925.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 204 | 74.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30676560 | 30676560 | PRJNA492280_P_NODE_8393_length_183_cov_4.102740_g8286_i0 | PRJNA492280 | 8393 | 183 | 4.10274 | 7.5080142 | Stenotrophomonas virus Jojan6 | 2932861 | Viruses | Viruses | 44.7 | 0.00216 | NR | UPU15964.1 | 2932861 | g8286 | i0 | 58.8 | 0.557377049180328 | 34 | 14 | 55.7 | 0 | 102 | 1 | 93 | 126 | UPU15964.1 major tail protein [Stenotrophomonas virus Jojan60] | diamond | 102 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas virus Jojan60 | |||||
| 30992754 | 30992754 | PRJNA492280_P_NODE_30454_length_151_cov_4.263158_g30347_i0 | PRJNA492280 | 30454 | 151 | 4.263158 | 6.43736858 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0363 | NR | XOQ91085.1 | 2832643 | g30347 | i0 | 30.5 | 2.54304635761589 | 128 | 9 | 95.4 | 1 | 146 | 3 | 17 | 144 | XOQ91085.1 MAG: baseplate protein [Caudoviricetes sp.] | diamond | 384 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31688207 | 31688207 | PRJNA492280_P_NODE_30957_length_151_cov_3.631579_g30850_i0 | PRJNA492280 | 30957 | 151 | 3.631579 | 5.48368429 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.8 | 1.49e-5 | NR | XOS71940.1 | 2832643 | g30850 | i0 | 91.7 | 0.95364238410596 | 24 | 2 | 47.7 | 0 | 74 | 145 | 219 | 242 | XOS71940.1 MAG: phage associated primase, partial [Caudoviricetes sp.] | diamond | 144 | 50.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31814796 | 31814796 | PRJNA492280_P_NODE_20277_length_164_cov_3.291339_g20170_i0 | PRJNA492280 | 20277 | 164 | 3.291339 | 5.39779596 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.1 | 5.58e-7 | NR | XOR14618.1 | 2832643 | g20170 | i0 | 100 | 0.402439024390244 | 22 | 0 | 40.2 | 0 | 10 | 75 | 98 | 119 | XOR14618.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 66 | 55.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32321357 | 32321357 | PRJNA492280_P_NODE_23759_length_164_cov_2.763780_g23652_i0 | PRJNA492280 | 23759 | 164 | 2.76378 | 4.5325992 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.5 | 0.00691 | NR | XOQ89890.1 | 2832643 | g23652 | i0 | 72 | 0.914634146341463 | 25 | 7 | 45.7 | 0 | 164 | 90 | 646 | 670 | XOQ89890.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 150 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;