contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10518941 | 10518941 | PRJNA1174207_P_NODE_10549_length_467_cov_1.172589_g10023_i0 | PRJNA1174207 | 10549 | 467 | 1.172589 | 5.47599063 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 159 | 1.12e-41 | NR | XOS58798.1 | 2832643 | g10023 | i0 | 59.4 | 0.995717344753747 | 155 | 60 | 99.6 | 1 | 2 | 466 | 616 | 767 | XOS58798.1 MAG: tape measure protein [Caudoviricetes sp.] | diamond | 465 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11794284 | 11794284 | PRJNA1174207_P_NODE_29950_length_265_cov_1.270833_g29421_i0 | PRJNA1174207 | 29950 | 265 | 1.270833 | 3.36770745 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82.4 | 2.72e-17 | NR | XOS01517.1 | 2832643 | g29421 | i0 | 51.1 | 0.99622641509434 | 88 | 43 | 99.6 | 0 | 264 | 1 | 1 | 88 | XOS01517.1 MAG: hypothetical protein MSP1228_70 [Caudoviricetes sp.] | diamond | 264 | 82.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26692226 | 26692226 | PRJNA1174207_P_NODE_31861_length_257_cov_1.298913_g31332_i0 | PRJNA1174207 | 31861 | 257 | 1.298913 | 3.33820641 | Microbacterium phage Aesir | 2767554 | Viruses | Viruses | 123 | 2.31e-30 | NR | QNN98612.1 | 2767554 | g31332 | i0 | 66.7 | 0.980544747081712 | 84 | 28 | 98.1 | 0 | 252 | 1 | 707 | 790 | QNN98612.1 DNA primase/helicase [Microbacterium phage Aesir] | diamond | 252 | 123 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Krampusvirus | Microbacterium phage Aesir | ||||
| 26723466 | 26723466 | PRJNA1174207_P_NODE_24141_length_289_cov_2.393519_g23612_i0 | PRJNA1174207 | 24141 | 289 | 2.393519 | 6.91726991 | Stenotrophomonas phage B2 | 2936871 | Viruses | Viruses | 130 | 6.539999999999999e-37 | NR | URG13003.1 | 2936871 | g23612 | i0 | 85.2 | 0.84083044982699 | 81 | 12 | 84.1 | 0 | 42 | 284 | 1 | 81 | URG13003.1 hypothetical protein B2_10 [Stenotrophomonas phage B2] | diamond | 243 | 130 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage B2 | |||||
| 27261887 | 27261887 | PRJNA1174207_P_NODE_42043_length_238_cov_2.593939_g41514_i0 | PRJNA1174207 | 42043 | 238 | 2.593939 | 6.17357482 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 108 | 1.79e-25 | NR | XOR99870.1 | 2832643 | g41514 | i0 | 75.6 | 0.983193277310924 | 78 | 19 | 98.3 | 0 | 2 | 235 | 756 | 833 | XOR99870.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] | diamond | 234 | 108 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27420009 | 27420009 | PRJNA1174207_P_NODE_17203_length_344_cov_2.162362_g16674_i0 | PRJNA1174207 | 17203 | 344 | 2.162362 | 7.43852528 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 71.2 | 1.11e-11 | NR | CAB4139992.1 | 2100421 | g16674 | i0 | 37.8 | 0.968023255813954 | 111 | 61 | 96.8 | 2 | 337 | 5 | 53 | 155 | CAB4139992.1 HELICc domain containing protein [uncultured Caudovirales phage] | diamond | 333 | 71.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27956597 | 27956597 | PRJNA1174207_P_NODE_43425_length_220_cov_4.585034_g42896_i0 | PRJNA1174207 | 43425 | 220 | 4.585034 | 10.0870748 | Thermus phage MN1 | 3018631 | Viruses | Viruses | 83.6 | 2.15e-17 | NR | BDX35518.1 | 3018631 | g42896 | i0 | 89.1 | 1.2 | 46 | 5 | 62.7 | 0 | 3 | 140 | 217 | 262 | BDX35518.1 hypothetical protein MN1_510 [Thermus phage MN1] | diamond | 264 | 83.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage MN1 | |||||
| 28240511 | 28240511 | PRJNA1174207_P_NODE_26366_length_280_cov_1.227053_g25837_i0 | PRJNA1174207 | 26366 | 280 | 1.227053 | 3.4357484 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 97.4 | 1.35e-23 | NR | CAB4143479.1 | 2100421 | g25837 | i0 | 54.8 | 3.19285714285714 | 73 | 33 | 78.2 | 0 | 4 | 222 | 56 | 128 | CAB4143479.1 GIY-YIG_SegABCDEFG domain containing protein [uncultured Caudovirales phage] | diamond | 894 | 97.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28588215 | 28588215 | PRJNA1174207_P_NODE_38967_length_244_cov_0.900585_g38438_i0 | PRJNA1174207 | 38967 | 244 | 0.900585 | 2.1974274 | Pseudomonas phage PaMx74 | 1175663 | Viruses | Viruses | 52.4 | 1.5e-5 | NR | YP_009199510.1 | 1175663 | g38438 | i0 | 41.9 | 1.56147540983607 | 62 | 36 | 76.2 | 0 | 196 | 11 | 262 | 323 | YP_009199510.1 exonuclease [Pseudomonas phage PaMx74] | diamond | 381 | 52.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mesyanzhinovviridae | Cinvestavvirus | Cinvestavvirus PaMx74 | |||
| 28840508 | 28840508 | PRJNA1174207_P_NODE_40128_length_243_cov_0.905882_g39599_i0 | PRJNA1174207 | 40128 | 243 | 0.905882 | 2.20129326 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 79 | 2.22e-15 | NR | CAB4125162.1 | 2100421 | g39599 | i0 | 46.8 | 0.975308641975309 | 79 | 42 | 97.5 | 0 | 3 | 239 | 130 | 208 | CAB4125162.1 hypothetical protein UFOVP54_72 [uncultured Caudovirales phage] | diamond | 237 | 79 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29219624 | 29219624 | PRJNA1174207_P_NODE_26109_length_281_cov_1.355769_g25580_i0 | PRJNA1174207 | 26109 | 281 | 1.355769 | 3.80971089 | Arthrobacter phage Ranunculus | 3374963 | Viruses | Viruses | 102 | 1.36e-23 | NR | XIJ71100.1 | 3374963 | g25580 | i0 | 65.2 | 0.950177935943061 | 89 | 31 | 95 | 0 | 2 | 268 | 214 | 302 | XIJ71100.1 minor tail protein [Arthrobacter phage Ranunculus] | diamond | 267 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Arthrobacter phage Ranunculus | |||||
| 29945855 | 29945855 | PRJNA1174207_P_NODE_35471_length_248_cov_2.142857_g34942_i0 | PRJNA1174207 | 35471 | 248 | 2.142857 | 5.31428536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 120 | 3.02e-30 | NR | XOS13866.1 | 2832643 | g34942 | i0 | 79.3 | 0.991935483870968 | 82 | 17 | 99.2 | 0 | 248 | 3 | 111 | 192 | XOS13866.1 MAG: hypothetical protein MSP0123_122 [Caudoviricetes sp.] | diamond | 246 | 120 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30893769 | 30893769 | PRJNA1174207_P_NODE_24674_length_287_cov_1.439252_g24145_i0 | PRJNA1174207 | 24674 | 287 | 1.439252 | 4.13065324 | Aeromonas phage HJ | 3035942 | Viruses | Viruses | 74.7 | 3.44e-13 | NR | WEV89374.1 | 3035942 | g24145 | i0 | 39.6 | 0.951219512195122 | 91 | 55 | 95.1 | 0 | 286 | 14 | 323 | 413 | WEV89374.1 hypothetical protein H10PHJ05_73 [Aeromonas phage HJ05] | diamond | 273 | 74.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage HJ05 | |||||
| 30956976 | 30956976 | PRJNA1174207_P_NODE_28694_length_270_cov_1.411168_g28165_i0 | PRJNA1174207 | 28694 | 270 | 1.411168 | 3.8101536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 100 | 3.2899999999999996e-23 | NR | XOR07016.1 | 2832643 | g28165 | i0 | 52.8 | 0.988888888888889 | 89 | 41 | 97.8 | 1 | 266 | 3 | 236 | 324 | XOR07016.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 267 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31494364 | 31494364 | PRJNA1174207_P_NODE_21256_length_310_cov_0.974684_g20727_i0 | PRJNA1174207 | 21256 | 310 | 0.974684 | 3.0215204 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 178 | 1.88e-49 | NR | XOS58798.1 | 2832643 | g20727 | i0 | 86.7 | 0.948387096774194 | 98 | 9 | 94.8 | 1 | 294 | 1 | 1270 | 1363 | XOS58798.1 MAG: tape measure protein [Caudoviricetes sp.] | diamond | 294 | 178 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31747173 | 31747173 | PRJNA1174207_P_NODE_32037_length_256_cov_1.683060_g31508_i0 | PRJNA1174207 | 32037 | 256 | 1.68306 | 4.3086336 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 63.2 | 2.8e-9 | NR | CAB4180388.1 | 2100421 | g31508 | i0 | 32.5 | 0.97265625 | 83 | 56 | 97.3 | 0 | 5 | 253 | 274 | 356 | CAB4180388.1 hypothetical protein UFOVP1043_28 [uncultured Caudovirales phage] | diamond | 249 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32000349 | 32000349 | PRJNA1174207_P_NODE_37118_length_246_cov_1.780347_g36589_i0 | PRJNA1174207 | 37118 | 246 | 1.780347 | 4.37965362 | Rhodococcus phage Grayson | 2182359 | Viruses | Viruses | 60.1 | 3.65e-9 | NR | AWN04428.1 | 2182359 | g36589 | i0 | 46.6 | 0.707317073170732 | 58 | 31 | 70.7 | 0 | 2 | 175 | 75 | 132 | AWN04428.1 hypothetical protein PBI_GRAYSON_84 [Rhodococcus phage Grayson] | diamond | 174 | 60.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Weaselvirus | Rhodococcus phage Grayson | ||||
| 32095247 | 32095247 | PRJNA1174207_P_NODE_20938_length_310_cov_2.957806_g20409_i0 | PRJNA1174207 | 20938 | 310 | 2.957806 | 9.1691986 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.2 | 3.43e-8 | NR | XOR33920.1 | 2832643 | g20409 | i0 | 44.8 | 1.0258064516129 | 58 | 32 | 56.1 | 0 | 134 | 307 | 19 | 76 | XOR33920.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 318 | 58.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32601388 | 32601388 | PRJNA1174207_P_NODE_29000_length_269_cov_1.178571_g28471_i0 | PRJNA1174207 | 29000 | 269 | 1.178571 | 3.17035599 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 91.7 | 1.19e-21 | NR | DAF83753.1 | 2832643 | g28471 | i0 | 77.4 | 1.182156133829 | 53 | 12 | 59.1 | 0 | 109 | 267 | 1 | 53 | DAF83753.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 318 | 91.7 | 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);;