contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA627467" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26998312 | 26998312 | PRJNA627467_P_NODE_16582_length_166_cov_3.085470_g16513_i0 | PRJNA627467 | 16582 | 166 | 3.08547 | 5.1218802 | Schitoviridae | 2842329 | Viruses | Viruses | 47.8 | 2.3e-4 | NR | YP_010079427.1 | 2591042 | g16513 | i0 | 34 | 1.91566265060241 | 53 | 35 | 95.8 | 0 | 2 | 160 | 1765 | 1817 | YP_010079427.1 virion RNA polymerase [Achromobacter phage vB_AxyP_19-32_Axy11] | diamond | 318 | 48.1 | 0.993762993762994 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Pourcelvirus | Pourcelvirus Axy11 | |||
| 27080595 | 27080595 | PRJNA627467_P_NODE_10362_length_186_cov_3.007299_g10293_i0 | PRJNA627467 | 10362 | 186 | 3.007299 | 5.59357614 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 64.7 | 8.36e-12 | NR | CAB4160898.1 | 2100421 | g10293 | i0 | 57.4 | 0.870967741935484 | 54 | 21 | 83.9 | 1 | 159 | 4 | 1 | 54 | CAB4160898.1 hypothetical protein UFOVP728_18 [uncultured Caudovirales phage] | diamond | 162 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27270187 | 27270187 | PRJNA627467_P_NODE_19443_length_161_cov_0.910714_g19374_i0 | PRJNA627467 | 19443 | 161 | 0.910714 | 1.46624954 | Microbacterium phage Phinky | 2762418 | Viruses | Viruses | 45.8 | 0.00101 | NR | QNJ55534.1 | 2762418 | g19374 | i0 | 46.7 | 1.54658385093168 | 45 | 24 | 83.9 | 0 | 159 | 25 | 294 | 338 | QNJ55534.1 tape measure protein [Microbacterium phage Phinky] | diamond | 249 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Squashvirus | Microbacterium phage Phinky | ||||
| 27491470 | 27491470 | PRJNA627467_P_NODE_3163_length_316_cov_2.168539_g3095_i0 | PRJNA627467 | 3163 | 316 | 2.168539 | 6.85258324 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 49.3 | 4.07e-4 | NR | CAB4154460.1 | 2100421 | g3095 | i0 | 76.7 | 0.284810126582278 | 30 | 7 | 28.5 | 0 | 93 | 4 | 285 | 314 | CAB4154460.1 hypothetical protein UFOVP653_3 [uncultured Caudovirales phage] | diamond | 90 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28230090 | 28230090 | PRJNA627467_P_NODE_3506_length_316_cov_2.022472_g3438_i0 | PRJNA627467 | 3506 | 316 | 2.022472 | 6.39101152 | Viruses | 10239 | Viruses | Viruses | 49.3 | 2.29e-4 | NR | ATW58267.1 | 2048980 | g3438 | i0 | 69.2 | 0.531645569620253 | 26 | 8 | 24.7 | 0 | 84 | 7 | 104 | 129 | ATW58267.1 DNA processing protein A [Pseudomonas phage ventosus] | diamond | 168 | 49.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vandenendeviridae | Ventosusvirus | Ventosusvirus ventosus | |||
| 28438774 | 28438774 | PRJNA627467_P_NODE_16046_length_167_cov_3.966102_g15977_i0 | PRJNA627467 | 16046 | 167 | 3.966102 | 6.62339034 | Acidovorax phage AP1 | 2908629 | Viruses | Viruses | 77 | 4.57e-16 | NR | UIS65458.1 | 2908629 | g15977 | i0 | 76.1 | 0.826347305389222 | 46 | 11 | 82.6 | 0 | 5 | 142 | 109 | 154 | UIS65458.1 late expression factor-5 [Acidovorax phage AP1] | diamond | 138 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acidovorax phage AP1 | |||||
| 28533513 | 28533513 | PRJNA627467_P_NODE_4927_length_316_cov_1.651685_g4859_i0 | PRJNA627467 | 4927 | 316 | 1.651685 | 5.2193246 | Acidovorax phage ACF1 | 2856860 | Viruses | Viruses | 56.6 | 1.17e-6 | NR | QXV72282.1 | 2856860 | g4859 | i0 | 86.2 | 0.275316455696203 | 29 | 4 | 27.5 | 0 | 97 | 11 | 118 | 146 | QXV72282.1 portal protein [Acidovorax phage ACF1] | diamond | 87 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acidovorax phage ACF1 | |||||
| 29259328 | 29259328 | PRJNA627467_P_NODE_4069_length_316_cov_1.842697_g4001_i0 | PRJNA627467 | 4069 | 316 | 1.842697 | 5.82292252 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 45.8 | 0.00507 | NR | CAB4174407.1 | 2100421 | g4001 | i0 | 62.5 | 0.607594936708861 | 32 | 12 | 30.4 | 0 | 4 | 99 | 117 | 148 | CAB4174407.1 Biotin-protein ligase, N-terminal [uncultured Caudovirales phage] | diamond | 192 | 45.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29322572 | 29322572 | PRJNA627467_P_NODE_4889_length_316_cov_1.655431_g4821_i0 | PRJNA627467 | 4889 | 316 | 1.655431 | 5.23116196 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 112 | 2.88e-26 | NR | XOS43008.1 | 2832643 | g4821 | i0 | 57.7 | 0.987341772151899 | 104 | 12 | 98.7 | 1 | 4 | 315 | 479 | 550 | XOS43008.1 MAG: virion-associated phage protein [Caudoviricetes sp.] | diamond | 312 | 112 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29354396 | 29354396 | PRJNA627467_P_NODE_14749_length_171_cov_6.311475_g14680_i0 | PRJNA627467 | 14749 | 171 | 6.311475 | 10.79262225 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 72.8 | 3.51e-13 | NR | CAB4153068.1 | 2100421 | g14680 | i0 | 64.2 | 0.929824561403509 | 53 | 19 | 93 | 0 | 5 | 163 | 331 | 383 | CAB4153068.1 Virulence-protein E, N-terminal [uncultured Caudovirales phage] | diamond | 159 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30112098 | 30112098 | PRJNA627467_P_NODE_4832_length_316_cov_1.666667_g4764_i0 | PRJNA627467 | 4832 | 316 | 1.666667 | 5.26666772 | Caulobacter phage Seuss | 1675601 | Viruses | Viruses | 47 | 0.00279 | NR | YP_009785516.1 | 1675601 | g4764 | i0 | 60.6 | 1.23417721518987 | 33 | 13 | 31.3 | 0 | 216 | 314 | 613 | 645 | YP_009785516.1 DNA primase [Caulobacter phage Seuss] | diamond | 390 | 47 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Seussvirus | Seussvirus seuss | ||||
| 30491397 | 30491397 | PRJNA627467_P_NODE_18693_length_162_cov_1.769912_g18624_i0 | PRJNA627467 | 18693 | 162 | 1.769912 | 2.86725744 | Mycobacterium phage Jung | 2742107 | Viruses | Viruses | 77.8 | 4.38e-16 | NR | YP_009964466.1 | 2742107 | g18624 | i0 | 70.8 | 0.888888888888889 | 48 | 14 | 88.9 | 0 | 6 | 149 | 131 | 178 | YP_009964466.1 hypothetical protein I5J41_gp55 [Mycobacterium phage Jung] | diamond | 144 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fishburnevirus | Fishburnevirus jung | ||||
| 30491398 | 30491398 | PRJNA627467_P_NODE_19793_length_159_cov_3.445455_g19724_i0 | PRJNA627467 | 19793 | 159 | 3.445455 | 5.47827345 | Microbacterium phage Caron | 3028494 | Viruses | Viruses | 89.7 | 5.540000000000001e-21 | NR | WDS52053.1 | 3028494 | g19724 | i0 | 82 | 1.90566037735849 | 50 | 9 | 94.3 | 0 | 6 | 155 | 111 | 160 | WDS52053.1 membrane protein [Microbacterium phage Caron] | diamond | 303 | 89.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Casidaviridae | Barnstormervirus | Barnstormervirus caron | |||
| 31028640 | 31028640 | PRJNA627467_P_NODE_10215_length_187_cov_1.644928_g10146_i0 | PRJNA627467 | 10215 | 187 | 1.644928 | 3.07601536 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 64.7 | 9.95e-12 | NR | CAB4153230.1 | 2100421 | g10146 | i0 | 62.3 | 0.850267379679144 | 53 | 20 | 85 | 0 | 165 | 7 | 6 | 58 | CAB4153230.1 hypothetical protein UFOVP607_58 [uncultured Caudovirales phage] | diamond | 159 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31389146 | 31389146 | PRJNA627467_P_NODE_19876_length_159_cov_2.427273_g19807_i0 | PRJNA627467 | 19876 | 159 | 2.427273 | 3.85936407 | Oneupvirus | 2733200 | Viruses | Viruses | 85.5 | 1.31e-18 | NR | YP_009274499.1 | 1838074 | g19807 | i0 | 80 | 4.71698113207547 | 50 | 10 | 94.3 | 0 | 155 | 6 | 78 | 127 | YP_009274499.1 thymidylate synthase [Gordonia phage OneUp] | diamond | 750 | 85.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Oneupvirus | Oneupvirus oneup | ||||
| 32008879 | 32008879 | PRJNA627467_P_NODE_19038_length_161_cov_3.419643_g18969_i0 | PRJNA627467 | 19038 | 161 | 3.419643 | 5.50562523 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 85.1 | 1.42e-17 | NR | XOR04999.1 | 2832643 | g18969 | i0 | 82.2 | 1.7888198757764 | 45 | 8 | 83.9 | 0 | 138 | 4 | 575 | 619 | XOR04999.1 MAG: topoisomerase II large subunit [Caudoviricetes sp.] | diamond | 288 | 85.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32103702 | 32103702 | PRJNA627467_P_NODE_11718_length_182_cov_1.503759_g11649_i0 | PRJNA627467 | 11718 | 182 | 1.503759 | 2.73684138 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.6 | 2.09e-7 | NR | XOS43002.1 | 2832643 | g11649 | i0 | 53.7 | 1.1043956043956 | 67 | 19 | 94 | 2 | 172 | 2 | 249 | 313 | XOS43002.1 MAG: hypothetical protein MSP0968_45 [Caudoviricetes sp.] | diamond | 201 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32230538 | 32230538 | PRJNA627467_P_NODE_16338_length_167_cov_1.389831_g16269_i0 | PRJNA627467 | 16338 | 167 | 1.389831 | 2.32101777 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 58.9 | 2.58e-8 | NR | CAB4138506.1 | 2100421 | g16269 | i0 | 78.8 | 0.592814371257485 | 33 | 7 | 59.3 | 0 | 105 | 7 | 329 | 361 | CAB4138506.1 PolB DNA polymerase elongation subunit (family B) [uncultured Caudovirales phage] | diamond | 99 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32433183 | 32433183 | PRJNA627467_P_NODE_21559_length_151_cov_4.607843_g21490_i0 | PRJNA627467 | 21559 | 151 | 4.607843 | 6.95784293 | root | 1 | Root_unresolved | Root_unresolved | 89 | 5.53e-19 | NR | YP_009219053.1 | 1678082 | g21490 | i0 | 85.7 | 1.94701986754967 | 49 | 7 | 97.4 | 0 | 147 | 1 | 187 | 235 | YP_009219053.1 DNA primase [Pseudomonas phage KPP21] | diamond | 294 | 89 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Luzseptimavirus | Luzseptimavirus KPP21 | |||
| 32641042 | 32641042 | PRJNA627467_P_NODE_14820_length_171_cov_3.254098_g14751_i0 | PRJNA627467 | 14820 | 171 | 3.254098 | 5.56450758 | Acidovorax phage AP1 | 2908629 | Viruses | Viruses | 51.2 | 4.83e-6 | NR | UIS65458.1 | 2908629 | g14751 | i0 | 72.7 | 0.578947368421053 | 33 | 9 | 57.9 | 0 | 71 | 169 | 2 | 34 | UIS65458.1 late expression factor-5 [Acidovorax phage AP1] | diamond | 99 | 51.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acidovorax phage AP1 |
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);;