contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1270312 | 1270312 | PRJNA980839_P_NODE_222621_length_245_cov_0.895349_g218837_i0 | PRJNA980839 | 222621 | 245 | 0.895349 | 2.19360505 | Microbacterium phage Triscuit | 2126721 | Viruses | Viruses | 144 | 7.23e-38 | NR | AVR56943.1 | 2126721 | g218837 | i0 | 79 | 0.991836734693878 | 81 | 17 | 99.2 | 0 | 244 | 2 | 245 | 325 | AVR56943.1 DNA polymerase I [Microbacterium phage Triscuit] | diamond | 243 | 144 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microbacterium phage Triscuit | |||||
| 9887244 | 9887244 | PRJNA980839_P_NODE_237288_length_241_cov_0.916667_g233504_i0 | PRJNA980839 | 237288 | 241 | 0.916667 | 2.20916747 | Microbacterium phage Cicada | 2743916 | Viruses | Viruses | 72.8 | 1.07e-13 | NR | QLF82728.1 | 2743916 | g233504 | i0 | 77.5 | 0.49792531120332 | 40 | 9 | 49.8 | 0 | 120 | 1 | 12 | 51 | QLF82728.1 hypothetical protein SEA_CICADA_45 [Microbacterium phage Cicada] | diamond | 120 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Goodmanvirus | Microbacterium phage Cicada | ||||
| 27089586 | 27089586 | PRJNA980839_P_NODE_219922_length_245_cov_1.790698_g216138_i0 | PRJNA980839 | 219922 | 245 | 1.790698 | 4.3872101 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 107 | 2.7699999999999993e-28 | NR | XOS00960.1 | 2832643 | g216138 | i0 | 68.8 | 0.979591836734694 | 80 | 25 | 98 | 0 | 242 | 3 | 7 | 86 | XOS00960.1 MAG: hypothetical protein MSP1251_54 [Caudoviricetes sp.] | diamond | 240 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27285181 | 27285181 | PRJNA980839_P_NODE_148523_length_288_cov_2.125581_g144739_i0 | PRJNA980839 | 148523 | 288 | 2.125581 | 6.12167328 | root | 1 | Root_unresolved | Root_unresolved | 110 | 1.17e-29 | NR | CAB4177875.1 | 2100421 | g144739 | i0 | 80 | 1.27083333333333 | 60 | 12 | 62.5 | 0 | 223 | 44 | 1 | 60 | CAB4177875.1 hypothetical protein UFOVP1015_12 [uncultured Caudovirales phage] | diamond | 366 | 110 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27816195 | 27816195 | PRJNA980839_P_NODE_193424_length_253_cov_1.711111_g189640_i0 | PRJNA980839 | 193424 | 253 | 1.711111 | 4.32911083 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 119 | 5.84e-29 | NR | XOR63755.1 | 2832643 | g189640 | i0 | 72.3 | 0.984189723320158 | 83 | 23 | 98.4 | 0 | 251 | 3 | 504 | 586 | XOR63755.1 MAG: lig protein [Caudoviricetes sp.] | diamond | 249 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27847399 | 27847399 | PRJNA980839_P_NODE_144044_length_293_cov_1.050000_g140260_i0 | PRJNA980839 | 144044 | 293 | 1.05 | 3.0765 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 80.1 | 8.58e-17 | NR | CAB4179971.1 | 2100421 | g140260 | i0 | 45.2 | 0.95221843003413 | 93 | 48 | 94.2 | 2 | 1 | 276 | 10 | 100 | CAB4179971.1 hypothetical protein UFOVP1040_10 [uncultured Caudovirales phage] | diamond | 279 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28447633 | 28447633 | PRJNA980839_P_NODE_209046_length_248_cov_0.948571_g205262_i0 | PRJNA980839 | 209046 | 248 | 0.948571 | 2.35245608 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 5.29e-17 | NR | XOR38086.1 | 2832643 | g205262 | i0 | 68.4 | 0.689516129032258 | 57 | 17 | 67.7 | 1 | 81 | 248 | 1 | 57 | XOR38086.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 171 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28763083 | 28763083 | PRJNA980839_P_NODE_175467_length_266_cov_1.580311_g171683_i0 | PRJNA980839 | 175467 | 266 | 1.580311 | 4.20362726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.7 | 2.71e-19 | NR | DAH75483.1 | 2832643 | g171683 | i0 | 51.8 | 0.958646616541353 | 85 | 38 | 94.7 | 2 | 261 | 10 | 118 | 200 | DAH75483.1 MAG TPA: 4-amino-4-deoxy-L-arabinose (L-Ara4N) transferase protein [Caudoviricetes sp.] | diamond | 255 | 91.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28794592 | 28794592 | PRJNA980839_P_NODE_218267_length_246_cov_0.890173_g214483_i0 | PRJNA980839 | 218267 | 246 | 0.890173 | 2.18982558 | Arthrobacter phage Mendel | 2484218 | Viruses | Viruses | 50.8 | 4.66e-5 | NR | YP_009842182.1 | 2484218 | g214483 | i0 | 39.3 | 1.02439024390244 | 84 | 49 | 100 | 2 | 1 | 246 | 81 | 164 | YP_009842182.1 hypothetical protein HWB96_gp07 [Arthrobacter phage Mendel] | diamond | 252 | 50.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Anjalivirus | Anjalivirus mendel | ||||
| 29331532 | 29331532 | PRJNA980839_P_NODE_197029_length_251_cov_1.387640_g193245_i0 | PRJNA980839 | 197029 | 251 | 1.38764 | 3.4829764 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 52.4 | 1.42e-5 | NR | CAB4139172.1 | 2100421 | g193245 | i0 | 69.7 | 9.82470119521912 | 33 | 10 | 39.4 | 0 | 99 | 1 | 138 | 170 | CAB4139172.1 MdpB Microcystin-dependent protein [uncultured Caudovirales phage] | diamond | 2466 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29331545 | 29331545 | PRJNA980839_P_NODE_228249_length_243_cov_1.735294_g224465_i0 | PRJNA980839 | 228249 | 243 | 1.735294 | 4.21676442 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 79.3 | 4.8e-15 | NR | XOQ96263.1 | 2832643 | g224465 | i0 | 80.4 | 0.62962962962963 | 51 | 10 | 63 | 0 | 242 | 90 | 839 | 889 | XOQ96263.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 153 | 79.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29583814 | 29583814 | PRJNA980839_P_NODE_203410_length_250_cov_0.870056_g199626_i0 | PRJNA980839 | 203410 | 250 | 0.870056 | 2.17514 | Corynebacterium phage phi673 | 2052821 | Viruses | Viruses | 67 | 1.15e-10 | NR | YP_009639725.1 | 2052821 | g199626 | i0 | 45.8 | 0.996 | 83 | 41 | 99.6 | 1 | 2 | 250 | 497 | 575 | YP_009639725.1 putative DNA polymerase I [Corynebacterium phage phi673] | diamond | 249 | 67 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ikedavirus | Ikedavirus phi673 | ||||
| 31131829 | 31131829 | PRJNA980839_P_NODE_210115_length_248_cov_0.880000_g206331_i0 | PRJNA980839 | 210115 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 44.7 | 0.00513 | NR | CAB4183528.1 | 2100421 | g206331 | i0 | 54.8 | 0.508064516129032 | 42 | 19 | 50.8 | 0 | 123 | 248 | 113 | 154 | CAB4183528.1 Collagen triple helix repeat [uncultured Caudovirales phage] | diamond | 126 | 44.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31416723 | 31416723 | PRJNA980839_P_NODE_216456_length_246_cov_1.393064_g212672_i0 | PRJNA980839 | 216456 | 246 | 1.393064 | 3.42693744 | Xanthomonas phage BUDD | 2961708 | Viruses | Viruses | 107 | 8.899999999999999e-25 | NR | USV41025.1 | 2961708 | g212672 | i0 | 59.8 | 1 | 82 | 30 | 100 | 1 | 246 | 1 | 222 | 300 | USV41025.1 DNA topoisomerase II large subunit [Xanthomonas phage BUDD] | diamond | 246 | 107 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage BUDD | |||||
| 31954309 | 31954309 | PRJNA980839_P_NODE_155637_length_282_cov_1.473684_g151853_i0 | PRJNA980839 | 155637 | 282 | 1.473684 | 4.15578888 | Podoviridae sp. ctKoA1 | 2832643 | Viruses | Viruses | 103 | 3.35e-23 | NR | QGH73247.1 | 2656709 | g151853 | i0 | 63 | 0.776595744680851 | 73 | 27 | 77.7 | 0 | 4 | 222 | 553 | 625 | QGH73247.1 MAG: type I site specific restriction modification system [Podoviridae sp. ctKoA10] | diamond | 219 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ctKoA10 | |||||
| 32649775 | 32649775 | PRJNA980839_P_NODE_170620_length_270_cov_1.187817_g166836_i0 | PRJNA980839 | 170620 | 270 | 1.187817 | 3.2071059 | Mycobacterium phage Patience | 1074308 | Viruses | Viruses | 74.3 | 9.47e-14 | NR | YP_009012187.2 | 1074308 | g166836 | i0 | 53.1 | 2.13333333333333 | 96 | 33 | 97.8 | 4 | 5 | 268 | 99 | 190 | YP_009012187.2 hypothetical protein CL65_gp048 [Mycobacterium phage Patience] | diamond | 576 | 74.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Patiencevirus | Patiencevirus patience |
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);;