contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB81463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654138 | 26654138 | PRJEB81463_P_NODE_30861_length_200_cov_4.850394_g30589_i0 | PRJEB81463 | 30861 | 200 | 4.850394 | 9.700788 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 109 | 4.58e-27 | NR | DAQ55194.1 | 2832643 | g30589 | i0 | 81.5 | 1.965 | 65 | 12 | 97.5 | 0 | 198 | 4 | 137 | 201 | DAQ55194.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 393 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27034247 | 27034247 | PRJEB81463_P_NODE_18182_length_261_cov_3.297872_g17910_i0 | PRJEB81463 | 18182 | 261 | 3.297872 | 8.60744592 | Siphoviridae sp. ctZHD14 | 2827891 | Viruses | Viruses | 132 | 3.49e-34 | NR | DAF55171.1 | 2827891 | g17910 | i0 | 73.6 | 2.88505747126437 | 87 | 23 | 100 | 0 | 1 | 261 | 364 | 450 | DAF55171.1 MAG TPA: DNA TOPOISOMERASE IV, B SUBUNIT [Siphoviridae sp. ctZHD14] | diamond | 753 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctZHD14 | |||||
| 27413820 | 27413820 | PRJEB81463_P_NODE_23843_length_248_cov_0.891429_g23571_i0 | PRJEB81463 | 23843 | 248 | 0.891429 | 2.21074392 | environmental Halophage eHP-28 | 1168829 | Viruses | Viruses | 99.4 | 2.2700000000000003e-22 | NR | AFH22511.1 | 1168829 | g23571 | i0 | 73.8 | 0.737903225806452 | 61 | 16 | 73.8 | 0 | 6 | 188 | 24 | 84 | AFH22511.1 hypothetical protein OSG_eHP28_00095 [environmental Halophage eHP-28] | diamond | 183 | 99.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Shortaselviridae | environmental Halophage eHP-28 | |||
| 27508440 | 27508440 | PRJEB81463_P_NODE_26743_length_244_cov_0.912281_g26471_i0 | PRJEB81463 | 26743 | 244 | 0.912281 | 2.22596564 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 57.4 | 2.49e-7 | NR | CAB4135888.1 | 2100421 | g26471 | i0 | 46.1 | 0.934426229508197 | 76 | 33 | 93.4 | 1 | 236 | 9 | 1 | 68 | CAB4135888.1 hypothetical protein UFOVP300_2 [uncultured Caudovirales phage] | diamond | 228 | 57.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27571405 | 27571405 | PRJEB81463_P_NODE_23864_length_248_cov_0.891429_g23592_i0 | PRJEB81463 | 23864 | 248 | 0.891429 | 2.21074392 | Siphoviridae sp. ctZHD14 | 2827891 | Viruses | Viruses | 122 | 3.6699999999999995e-30 | NR | DAF55203.1 | 2827891 | g23592 | i0 | 65.9 | 0.991935483870968 | 82 | 28 | 99.2 | 0 | 246 | 1 | 603 | 684 | DAF55203.1 MAG TPA: protein of unknown function (DUF5048) [Siphoviridae sp. ctZHD14] | diamond | 246 | 122 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctZHD14 | |||||
| 28258575 | 28258575 | PRJEB81463_P_NODE_13886_length_283_cov_1.214286_g13614_i0 | PRJEB81463 | 13886 | 283 | 1.214286 | 3.43642938 | Viruses | 10239 | Viruses | Viruses | 59.7 | 1.76e-9 | NR | YP_009808315.1 | 2301696 | g13614 | i0 | 68.4 | 1.28268551236749 | 38 | 12 | 40.3 | 0 | 127 | 14 | 5 | 42 | YP_009808315.1 hypothetical protein HOT93_gp072 [Gordonia phage Horus] | diamond | 363 | 60.1 | 0.993344425956739 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Horusvirus | Horusvirus horus | ||||
| 28645059 | 28645059 | PRJEB81463_P_NODE_25607_length_245_cov_1.476744_g25335_i0 | PRJEB81463 | 25607 | 245 | 1.476744 | 3.6180228 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 63.5 | 9.19e-10 | NR | XOS47170.1 | 2832643 | g25335 | i0 | 90 | 0.36734693877551 | 30 | 3 | 36.7 | 0 | 241 | 152 | 222 | 251 | XOS47170.1 MAG: putative PhoH-like protein [Caudoviricetes sp.] | diamond | 90 | 63.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30065773 | 30065773 | PRJEB81463_P_NODE_20892_length_252_cov_0.871508_g20620_i0 | PRJEB81463 | 20892 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 127 | 4.81e-34 | NR | XOE95038.1 | 2832643 | g20620 | i0 | 75.3 | 1.92857142857143 | 81 | 20 | 96.4 | 0 | 243 | 1 | 1 | 81 | XOE95038.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 486 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31709405 | 31709405 | PRJEB81463_P_NODE_26377_length_244_cov_1.543860_g26105_i0 | PRJEB81463 | 26377 | 244 | 1.54386 | 3.7670184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.9 | 7.45e-21 | NR | DAG25138.1 | 2832643 | g26105 | i0 | 59.3 | 0.995901639344262 | 81 | 30 | 95.9 | 2 | 241 | 8 | 158 | 238 | DAG25138.1 MAG TPA: DNA directed DNA polymerase [Caudoviricetes sp.] | diamond | 243 | 95.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32279092 | 32279092 | PRJEB81463_P_NODE_28199_length_242_cov_0.923077_g27927_i0 | PRJEB81463 | 28199 | 242 | 0.923077 | 2.23384634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.1 | 6.82e-10 | NR | XOR78549.1 | 2832643 | g27927 | i0 | 51.5 | 0.818181818181818 | 66 | 29 | 80.6 | 2 | 231 | 37 | 1 | 64 | XOR78549.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 198 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32563913 | 32563913 | PRJEB81463_P_NODE_25919_length_245_cov_0.906977_g25647_i0 | PRJEB81463 | 25919 | 245 | 0.906977 | 2.22209365 | Pseudomonas phage UAntarctica | 2856996 | Viruses | Viruses | 52.8 | 4.1e-7 | NR | QYW06418.1 | 2856996 | g25647 | i0 | 48.8 | 0.52653061224489806 | 43 | 22 | 52.7 | 0 | 103 | 231 | 3 | 45 | QYW06418.1 hypothetical protein uan_006 [Pseudomonas phage UAntarctica] | diamond | 129 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage UAntarctica |
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);;