contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA680334" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27018676 | 27018676 | PRJNA680334_S_NODE_26502_length_233_cov_5.875000_g26016_i0 | PRJNA680334 | 26502 | 233 | 5.875 | 13.68875 | Vibrio phage vB_VibM_1 | 3075960 | Viruses | Viruses | 86.7 | 1.79e-18 | NR | WNO47358.1 | 3075960 | g26016 | i0 | 60.6 | 0.849785407725322 | 66 | 26 | 85 | 0 | 2 | 199 | 195 | 260 | WNO47358.1 hypothetical protein [Vibrio phage vB_VibM_10AMN] | diamond | 198 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VibM_10AMN | |||||
| 28281888 | 28281888 | PRJNA680334_S_NODE_90066_length_159_cov_1.746032_g89580_i0 | PRJNA680334 | 90066 | 159 | 1.746032 | 2.77619088 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 44.7 | 0.002 | NR | DAR57496.1 | 2831613 | g89580 | i0 | 45.8 | 0.905660377358491 | 48 | 26 | 90.6 | 0 | 14 | 157 | 124 | 171 | DAR57496.1 MAG TPA: protein of unknown function (DUF4376) [Herelleviridae sp.] | diamond | 144 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 29576386 | 29576386 | PRJNA680334_S_NODE_83170_length_163_cov_2.146154_g82684_i0 | PRJNA680334 | 83170 | 163 | 2.146154 | 3.49823102 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 70.1 | 2.85e-12 | NR | XOR16660.1 | 2832643 | g82684 | i0 | 63 | 0.993865030674847 | 54 | 20 | 99.4 | 0 | 162 | 1 | 543 | 596 | XOR16660.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 162 | 70.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29639470 | 29639470 | PRJNA680334_S_NODE_25390_length_236_cov_10.758621_g24904_i0 | PRJNA680334 | 25390 | 236 | 10.758621 | 25.39034556 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99.8 | 5.71e-25 | NR | XOQ97186.1 | 2832643 | g24904 | i0 | 82.1 | 0.711864406779661 | 56 | 10 | 71.2 | 0 | 203 | 36 | 1 | 56 | XOQ97186.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 168 | 99.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29702519 | 29702519 | PRJNA680334_S_NODE_6150_length_363_cov_7.518182_g5665_i0 | PRJNA680334 | 6150 | 363 | 7.518182 | 27.29100066 | Rheinheimera phage Barba5S | 2849599 | Viruses | Viruses | 140 | 3.61e-39 | NR | YP_009822707.1 | 2849599 | g5665 | i0 | 54 | 3.02479338842975 | 124 | 53 | 100 | 2 | 1 | 363 | 86 | 208 | YP_009822707.1 HNH endonuclease [Rheinheimera phage Barba5S] | diamond | 1098 | 140 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Barbavirus | Barbavirus barba5S | ||||
| 29967432 | 29967432 | PRJNA680334_S_NODE_4511_length_399_cov_3.193989_g4029_i0 | PRJNA680334 | 4511 | 399 | 3.193989 | 12.74401611 | Viruses | 10239 | Viruses | Viruses | 82.8 | 7.74e-16 | NR | DAD96844.1 | 2826295 | g4029 | i0 | 32.1 | 2.67669172932331 | 140 | 87 | 99.2 | 3 | 399 | 4 | 86 | 225 | DAD96844.1 MAG TPA: endonuclease [Siphoviridae sp. ct5op20] | diamond | 1068 | 83.2 | 0.995192307692308 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ct5op20 | |||||
| 30283736 | 30283736 | PRJNA680334_S_NODE_74532_length_169_cov_1.830882_g74046_i0 | PRJNA680334 | 74532 | 169 | 1.830882 | 3.09419058 | Viruses | 10239 | Viruses | Viruses | 59.7 | 6.8e-10 | NR | UZV41323.1 | 2996088 | g74046 | i0 | 60.6 | 1.17159763313609 | 33 | 13 | 58.6 | 0 | 20 | 118 | 56 | 88 | UZV41323.1 TMhelix containing protein [Vibrio phage vB_VpaM_R16F] | diamond | 198 | 59.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VpaM_R16F | |||||
| 30429886 | 30429886 | PRJNA680334_S_NODE_75793_length_168_cov_2.162963_g75307_i0 | PRJNA680334 | 75793 | 168 | 2.162963 | 3.63377784 | Staphylococcus phage PMBT8 | 2590894 | Viruses | Viruses | 58.5 | 3.55e-8 | NR | QDF14320.1 | 2590894 | g75307 | i0 | 60.5 | 0.767857142857143 | 43 | 17 | 76.8 | 0 | 35 | 163 | 1055 | 1097 | QDF14320.1 tail length tape-measure protein [Staphylococcus phage PMBT8] | diamond | 129 | 58.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage PMBT8 | ||||
| 30650427 | 30650427 | PRJNA680334_S_NODE_19273_length_257_cov_5.964286_g18787_i0 | PRJNA680334 | 19273 | 257 | 5.964286 | 15.32821502 | Acinetobacter phage Phab24 | 2855484 | Viruses | Viruses | 58.2 | 1.09e-7 | NR | QXM18517.1 | 2855484 | g18787 | i0 | 64.1 | 0.455252918287938 | 39 | 14 | 45.5 | 0 | 118 | 2 | 3 | 41 | QXM18517.1 hypothetical protein Phab24_id071 [Acinetobacter phage Phab24] | diamond | 117 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage Phab24 |
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);;