contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA812001" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8464113 | 8464113 | PRJNA812001_P_NODE_9347_length_512_cov_1.259681_g9101_i0 | PRJNA812001 | 9347 | 512 | 1.259681 | 6.44956672 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 323 | 1.19e-102 | NR | WQY91225.1 | 3110108 | g9101 | i0 | 92.4 | 2.98828125 | 170 | 13 | 99.6 | 0 | 510 | 1 | 499 | 668 | WQY91225.1 hypothetical protein [Hafnia phage TS33] | diamond | 1530 | 323 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 10152998 | 10152998 | PRJNA812001_P_NODE_35148_length_321_cov_2.282258_g34902_i0 | PRJNA812001 | 35148 | 321 | 2.282258 | 7.32604818 | Viruses | 10239 | Viruses | Viruses | 161 | 3.44e-44 | NR | YP_874043.1 | 407392 | g34902 | i0 | 76.6 | 1.75700934579439 | 94 | 22 | 87.9 | 0 | 308 | 27 | 492 | 585 | YP_874043.1 hypothetical protein YS40_030 [Thermus phage phiYS40] | diamond | 564 | 162 | 0.993827160493827 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiYS40 | |||||
| 12704042 | 12704042 | PRJNA812001_P_NODE_7330_length_572_cov_2.082164_g7085_i0 | PRJNA812001 | 7330 | 572 | 2.082164 | 11.90997808 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 159 | 8.799999999999999e-47 | NR | QHJ79797.1 | 2832643 | g7085 | i0 | 69 | 1.20104895104895 | 113 | 35 | 59.3 | 0 | 401 | 63 | 1 | 113 | QHJ79797.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 687 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19937306 | 19937306 | PRJNA812001_P_NODE_3656_length_803_cov_10.202740_g3436_i0 | PRJNA812001 | 3656 | 803 | 10.20274 | 81.9280022 | Bacillus phage SP-15 | 1792032 | Viruses | Viruses | 84.7 | 1.74e-16 | NR | YP_009302701.1 | 1792032 | g3436 | i0 | 47.4 | 0.36239103362391 | 97 | 45 | 34 | 1 | 278 | 6 | 1 | 97 | YP_009302701.1 hypothetical protein SP15_304 [Bacillus phage SP-15] | diamond | 291 | 84.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thornevirus | Thornevirus SP15 | ||||
| 19937647 | 19937647 | PRJNA812001_P_NODE_7956_length_550_cov_1.501048_g7711_i0 | PRJNA812001 | 7956 | 550 | 1.501048 | 8.255764 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 278 | 1.15e-93 | NR | QHJ80257.1 | 2832643 | g7711 | i0 | 89.4 | 0.774545454545455 | 142 | 15 | 77.5 | 0 | 514 | 89 | 1 | 142 | QHJ80257.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 426 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20350666 | 20350666 | PRJNA812001_P_NODE_12876_length_445_cov_4.193050_g12630_i0 | PRJNA812001 | 12876 | 445 | 4.19305 | 18.6590725 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.1 | 5.83e-8 | NR | XOS38649.1 | 2832643 | g12630 | i0 | 39.8 | 3.90337078651685 | 113 | 61 | 73.5 | 2 | 426 | 100 | 2 | 111 | XOS38649.1 MAG: hypothetical protein MSP1091_46 [Caudoviricetes sp.] | diamond | 1737 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26651315 | 26651315 | PRJNA812001_P_NODE_10281_length_490_cov_2.071942_g10035_i0 | PRJNA812001 | 10281 | 490 | 2.071942 | 10.1525158 | Viruses | 10239 | Viruses | Viruses | 126 | 1.2e-34 | NR | QUL77296.1 | 2811509 | g10035 | i0 | 66.3 | 1.93469387755102 | 86 | 29 | 52.7 | 0 | 408 | 151 | 1 | 86 | QUL77296.1 hypothetical protein [Escherichia phage UPEC06] | diamond | 948 | 126 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Escherichia phage UPEC06 | |||||
| 26737333 | 26737333 | PRJNA812001_P_NODE_98701_length_247_cov_1.327586_g98455_i0 | PRJNA812001 | 98701 | 247 | 1.327586 | 3.27913742 | Wisapiscaud virus 1 | 3375905 | Viruses | Viruses | 118 | 8.160000000000001e-29 | NR | XJU74172.1 | 3375905 | g98455 | i0 | 70.4 | 0.983805668016194 | 81 | 24 | 98.4 | 0 | 245 | 3 | 287 | 367 | XJU74172.1 MAG: tail protein [Wisapiscaud virus 1] | diamond | 243 | 118 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Wisapiscaud virus 1 | |||||
| 27243904 | 27243904 | PRJNA812001_P_NODE_136843_length_228_cov_4.503226_g136597_i0 | PRJNA812001 | 136843 | 228 | 4.503226 | 10.26735528 | Achromobacter phage JWF | 1589748 | Viruses | Viruses | 111 | 2.17e-29 | NR | YP_009224052.1 | 1589748 | g136597 | i0 | 70.8 | 1.89473684210526 | 72 | 21 | 94.7 | 0 | 12 | 227 | 69 | 140 | YP_009224052.1 Holliday junction resolvase [Achromobacter phage JWF] | diamond | 432 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Achromobacter phage JWF | |||||
| 27591574 | 27591574 | PRJNA812001_P_NODE_11624_length_464_cov_1.690537_g11378_i0 | PRJNA812001 | 11624 | 464 | 1.690537 | 7.84409168 | Salmonella phage vB_SalM-LPST94 | 2282399 | Viruses | Viruses | 266 | 8.78e-82 | NR | AXF41693.1 | 2282399 | g11378 | i0 | 87 | 0.995689655172414 | 154 | 20 | 99.6 | 0 | 2 | 463 | 534 | 687 | AXF41693.1 hypothetical protein LPST94_00131 [Salmonella phage vB_SalM-LPST94] | diamond | 462 | 266 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Kuttervirus | Salmonella phage vB_SalM-LPST94 | ||
| 27591578 | 27591578 | PRJNA812001_P_NODE_131024_length_241_cov_0.916667_g130778_i0 | PRJNA812001 | 131024 | 241 | 0.916667 | 2.20916747 | Vibrio phage vB_VcorM_GR11A | 2711164 | Viruses | Viruses | 69.7 | 4.73e-12 | NR | QJT71284.1 | 2711164 | g130778 | i0 | 50.7 | 0.83402489626556 | 67 | 32 | 82.2 | 1 | 241 | 44 | 180 | 246 | QJT71284.1 hypothetical protein GR11A_00247 [Vibrio phage vB_VcorM_GR11A] | diamond | 201 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VcorM_GR11A | |||||
| 28380709 | 28380709 | PRJNA812001_P_NODE_16006_length_409_cov_1.815476_g15760_i0 | PRJNA812001 | 16006 | 409 | 1.815476 | 7.42529684 | Serratia phage Eta | 1282995 | Viruses | Viruses | 56.6 | 1.69e-7 | NR | YP_008130345.1 | 1282995 | g15760 | i0 | 50 | 0.425427872860636 | 58 | 29 | 42.5 | 0 | 407 | 234 | 4 | 61 | YP_008130345.1 hypothetical protein Eta_0052 [Serratia phage Eta] | diamond | 174 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Seretavirus | Seretavirus eta | |||
| 29170212 | 29170212 | PRJNA812001_P_NODE_24389_length_356_cov_2.756184_g24143_i0 | PRJNA812001 | 24389 | 356 | 2.756184 | 9.81201504 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 50.4 | 1.09e-5 | NR | QHJ79757.1 | 2832643 | g24143 | i0 | 62.5 | 0.404494382022472 | 48 | 14 | 40.4 | 1 | 173 | 30 | 4 | 47 | QHJ79757.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 144 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29233355 | 29233355 | PRJNA812001_P_NODE_14449_length_425_cov_1.127841_g14203_i0 | PRJNA812001 | 14449 | 425 | 1.127841 | 4.79332425 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 81.3 | 4.94e-17 | NR | DAU29119.1 | 2832643 | g14203 | i0 | 48.4 | 0.670588235294118 | 95 | 38 | 64.2 | 4 | 141 | 413 | 4 | 91 | DAU29119.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 285 | 81.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29706412 | 29706412 | PRJNA812001_P_NODE_137750_length_209_cov_4.044118_g137504_i0 | PRJNA812001 | 137750 | 209 | 4.044118 | 8.45220662 | Klebsiella phage FKP1 | 3237190 | Viruses | Viruses | 41.6 | 0.032 | NR | XFC52219.1 | 3237190 | g137504 | i0 | 38.3 | 0.674641148325359 | 47 | 28 | 66 | 1 | 150 | 13 | 62 | 108 | XFC52219.1 methyltransferase [Klebsiella phage FKP10] | diamond | 141 | 41.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Taipeivirus | Klebsiella phage FKP10 | ||
| 29769848 | 29769848 | PRJNA812001_P_NODE_39171_length_312_cov_0.916318_g38925_i0 | PRJNA812001 | 39171 | 312 | 0.916318 | 2.85891216 | Hafnia phage TS33 | 3110108 | Viruses | Viruses | 171 | 1.29e-48 | NR | WQY91229.1 | 3110108 | g38925 | i0 | 79.8 | 1 | 104 | 20 | 99 | 1 | 309 | 1 | 192 | 295 | WQY91229.1 62kDa structural protein [Hafnia phage TS33] | diamond | 312 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Hafnia phage TS33 | ||||
| 30054113 | 30054113 | PRJNA812001_P_NODE_9811_length_500_cov_2.159251_g9565_i0 | PRJNA812001 | 9811 | 500 | 2.159251 | 10.796255 | Serratia phage vB_SmaM-Kashira | 2943834 | Viruses | Viruses | 129 | 1.24e-34 | NR | URC22635.1 | 2943834 | g9565 | i0 | 52.9 | 0.624 | 104 | 49 | 62.4 | 0 | 314 | 3 | 1 | 104 | URC22635.1 hypothetical protein KASHIRA_00410 [Serratia phage vB_SmaM-Kashira] | diamond | 312 | 129 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Serratia phage vB_SmaM-Kashira | |||||
| 30622828 | 30622828 | PRJNA812001_P_NODE_21693_length_369_cov_1.793919_g21447_i0 | PRJNA812001 | 21693 | 369 | 1.793919 | 6.61956111 | Serratia phage Eta | 1282995 | Viruses | Viruses | 206 | 2.01e-63 | NR | YP_008130344.1 | 1282995 | g21447 | i0 | 82.1 | 1 | 123 | 22 | 100 | 0 | 1 | 369 | 148 | 270 | YP_008130344.1 major head protein [Serratia phage Eta] | diamond | 369 | 206 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sarkviridae | Seretavirus | Seretavirus eta | |||
| 31697763 | 31697763 | PRJNA812001_P_NODE_14977_length_419_cov_1.910405_g14731_i0 | PRJNA812001 | 14977 | 419 | 1.910405 | 8.00459695 | Serratia phage vB_SmaM-ChuuTotoro | 2943832 | Viruses | Viruses | 132 | 1.55e-36 | NR | URC22120.1 | 2943832 | g14731 | i0 | 65.7 | 0.708830548926014 | 99 | 34 | 70.9 | 0 | 123 | 419 | 4 | 102 | URC22120.1 hypothetical protein CHUUTOTORO_00160 [Serratia phage vB_SmaM-ChuuTotoro] | diamond | 297 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Serratia phage vB_SmaM-ChuuTotoro | |||||
| 32299253 | 32299253 | PRJNA812001_P_NODE_35779_length_320_cov_1.161943_g35533_i0 | PRJNA812001 | 35779 | 320 | 1.161943 | 3.7182176 | Achromobacter phage JWF | 1589748 | Viruses | Viruses | 133 | 1.4299999999999998e-37 | NR | YP_009224027.1 | 1589748 | g35533 | i0 | 82.1 | 0.73125 | 78 | 13 | 73.1 | 1 | 318 | 85 | 4 | 80 | YP_009224027.1 hypothetical protein AXJ13_gp021 [Achromobacter phage JWF] | diamond | 234 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Achromobacter phage JWF | |||||
| 32583752 | 32583752 | PRJNA812001_P_NODE_128219_length_242_cov_0.911243_g127973_i0 | PRJNA812001 | 128219 | 242 | 0.911243 | 2.20520806 | Acinetobacter phage ABPH49 | 2282400 | Viruses | Viruses | 77.8 | 5.88e-17 | NR | AXN57863.1 | 2282400 | g127973 | i0 | 63 | 0.669421487603306 | 54 | 20 | 66.9 | 0 | 4 | 165 | 8 | 61 | AXN57863.1 hypothetical protein [Acinetobacter phage ABPH49] | diamond | 162 | 77.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage ABPH49 | |||||
| 32615093 | 32615093 | PRJNA812001_P_NODE_135900_length_237_cov_2.189024_g135654_i0 | PRJNA812001 | 135900 | 237 | 2.189024 | 5.18798688 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.9 | 4.36e-18 | NR | DAV92137.1 | 2832643 | g135654 | i0 | 65.1 | 0.79746835443038 | 63 | 22 | 79.7 | 0 | 5 | 193 | 9 | 71 | DAV92137.1 MAG TPA: T-complex protein 1 subunit alpha [Caudoviricetes sp.] | diamond | 189 | 80.9 | 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);;